EDA.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "import os\n",
    "\n",
    "plt.rcParams[\"figure.figsize\"] = (15,5)\n",
    "plt.rcParams['lines.linewidth'] = 4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "PROJECT_BASE_DIR = \"/opt/ml/online_retail_prediction\"\n",
    "INPUT_DIR = os.path.join(PROJECT_BASE_DIR, \"input\")\n",
    "TRAIN_CSV = os.path.join(INPUT_DIR, \"train.csv\")\n",
    "SUBMISSION_CSV = os.path.join(INPUT_DIR, \"sample_submission.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Glimpse the data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>order_id</th>\n",
       "      <th>product_id</th>\n",
       "      <th>description</th>\n",
       "      <th>quantity</th>\n",
       "      <th>order_date</th>\n",
       "      <th>price</th>\n",
       "      <th>customer_id</th>\n",
       "      <th>country</th>\n",
       "      <th>total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>489434</td>\n",
       "      <td>85048</td>\n",
       "      <td>15CM CHRISTMAS GLASS BALL 20 LIGHTS</td>\n",
       "      <td>12</td>\n",
       "      <td>2009-12-01 07:45:00</td>\n",
       "      <td>11.4675</td>\n",
       "      <td>13085</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>137.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>489434</td>\n",
       "      <td>79323P</td>\n",
       "      <td>PINK CHERRY LIGHTS</td>\n",
       "      <td>12</td>\n",
       "      <td>2009-12-01 07:45:00</td>\n",
       "      <td>11.1375</td>\n",
       "      <td>13085</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>133.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>489434</td>\n",
       "      <td>79323W</td>\n",
       "      <td>WHITE CHERRY LIGHTS</td>\n",
       "      <td>12</td>\n",
       "      <td>2009-12-01 07:45:00</td>\n",
       "      <td>11.1375</td>\n",
       "      <td>13085</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>133.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>489434</td>\n",
       "      <td>22041</td>\n",
       "      <td>RECORD FRAME 7\" SINGLE SIZE</td>\n",
       "      <td>48</td>\n",
       "      <td>2009-12-01 07:45:00</td>\n",
       "      <td>3.4650</td>\n",
       "      <td>13085</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>166.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>489434</td>\n",
       "      <td>21232</td>\n",
       "      <td>STRAWBERRY CERAMIC TRINKET BOX</td>\n",
       "      <td>24</td>\n",
       "      <td>2009-12-01 07:45:00</td>\n",
       "      <td>2.0625</td>\n",
       "      <td>13085</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>49.50</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  order_id product_id                          description  quantity  \\\n",
       "0   489434      85048  15CM CHRISTMAS GLASS BALL 20 LIGHTS        12   \n",
       "1   489434     79323P                   PINK CHERRY LIGHTS        12   \n",
       "2   489434     79323W                  WHITE CHERRY LIGHTS        12   \n",
       "3   489434      22041         RECORD FRAME 7\" SINGLE SIZE         48   \n",
       "4   489434      21232       STRAWBERRY CERAMIC TRINKET BOX        24   \n",
       "\n",
       "           order_date    price  customer_id         country   total  \n",
       "0 2009-12-01 07:45:00  11.4675        13085  United Kingdom  137.61  \n",
       "1 2009-12-01 07:45:00  11.1375        13085  United Kingdom  133.65  \n",
       "2 2009-12-01 07:45:00  11.1375        13085  United Kingdom  133.65  \n",
       "3 2009-12-01 07:45:00   3.4650        13085  United Kingdom  166.32  \n",
       "4 2009-12-01 07:45:00   2.0625        13085  United Kingdom   49.50  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_df = pd.read_csv(TRAIN_CSV, parse_dates=[\"order_date\"])\n",
    "submission_df = pd.read_csv(SUBMISSION_CSV)\n",
    "train_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 780502 entries, 0 to 780501\n",
      "Data columns (total 9 columns):\n",
      " #   Column       Non-Null Count   Dtype         \n",
      "---  ------       --------------   -----         \n",
      " 0   order_id     780502 non-null  object        \n",
      " 1   product_id   780502 non-null  object        \n",
      " 2   description  780502 non-null  object        \n",
      " 3   quantity     780502 non-null  int64         \n",
      " 4   order_date   780502 non-null  datetime64[ns]\n",
      " 5   price        780502 non-null  float64       \n",
      " 6   customer_id  780502 non-null  int64         \n",
      " 7   country      780502 non-null  object        \n",
      " 8   total        780502 non-null  float64       \n",
      "dtypes: datetime64[ns](1), float64(2), int64(2), object(4)\n",
      "memory usage: 53.6+ MB\n"
     ]
    }
   ],
   "source": [
    "train_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "order_id       0\n",
       "product_id     0\n",
       "description    0\n",
       "quantity       0\n",
       "order_date     0\n",
       "price          0\n",
       "customer_id    0\n",
       "country        0\n",
       "total          0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Null item 개수 확인\n",
    "train_df.isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "order_id       0.0\n",
       "product_id     0.0\n",
       "description    0.0\n",
       "quantity       0.0\n",
       "order_date     0.0\n",
       "price          0.0\n",
       "customer_id    0.0\n",
       "country        0.0\n",
       "total          0.0\n",
       "dtype: float64"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 전체 개수로 나눠서 결측치 데이터 비율 확인\n",
    "train_df.isna().sum() / train_df.shape[0] "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>quantity</th>\n",
       "      <th>price</th>\n",
       "      <th>customer_id</th>\n",
       "      <th>total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>780502.000000</td>\n",
       "      <td>780502.000000</td>\n",
       "      <td>780502.000000</td>\n",
       "      <td>780502.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>12.623307</td>\n",
       "      <td>6.140931</td>\n",
       "      <td>15313.393466</td>\n",
       "      <td>33.715373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>143.906302</td>\n",
       "      <td>119.042266</td>\n",
       "      <td>1695.765797</td>\n",
       "      <td>274.207403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>-74215.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>12346.000000</td>\n",
       "      <td>-127352.940000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.062500</td>\n",
       "      <td>13963.000000</td>\n",
       "      <td>7.260000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>5.000000</td>\n",
       "      <td>3.217500</td>\n",
       "      <td>15239.000000</td>\n",
       "      <td>19.470000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>12.000000</td>\n",
       "      <td>6.187500</td>\n",
       "      <td>16788.000000</td>\n",
       "      <td>32.175000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>74215.000000</td>\n",
       "      <td>64300.500000</td>\n",
       "      <td>18287.000000</td>\n",
       "      <td>127352.940000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            quantity          price    customer_id          total\n",
       "count  780502.000000  780502.000000  780502.000000  780502.000000\n",
       "mean       12.623307       6.140931   15313.393466      33.715373\n",
       "std       143.906302     119.042266    1695.765797     274.207403\n",
       "min    -74215.000000       0.000000   12346.000000 -127352.940000\n",
       "25%         2.000000       2.062500   13963.000000       7.260000\n",
       "50%         5.000000       3.217500   15239.000000      19.470000\n",
       "75%        12.000000       6.187500   16788.000000      32.175000\n",
       "max     74215.000000   64300.500000   18287.000000  127352.940000"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "train_retail shape is (780502, 9)\n",
      "sample_submission shape is (5914, 2)\n"
     ]
    }
   ],
   "source": [
    "print(f'train_retail shape is {train_df.shape}')\n",
    "print(f'sample_submission shape is {submission_df.shape}')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "5914\n"
     ]
    }
   ],
   "source": [
    "# train data의 모든 고객이 submssion에 포함되어 있는지 확인\n",
    "print(np.sum(submission_df[\"customer_id\"].isin(train_df[\"customer_id\"].unique())))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2009-12-01 07:45:00\n",
      "2011-11-30 17:42:00\n"
     ]
    }
   ],
   "source": [
    "# train set의 기간 파악\n",
    "print(train_df['order_date'].min())\n",
    "print(train_df['order_date'].max())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5914"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# unique한 customer_id 수\n",
    "len(train_df['customer_id'].unique())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 한 명 단위로 Data를 보면서 어떻게 구조화 되어있는지 확인"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>order_id</th>\n",
       "      <th>product_id</th>\n",
       "      <th>description</th>\n",
       "      <th>quantity</th>\n",
       "      <th>order_date</th>\n",
       "      <th>price</th>\n",
       "      <th>customer_id</th>\n",
       "      <th>country</th>\n",
       "      <th>total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>21447</th>\n",
       "      <td>491725</td>\n",
       "      <td>TEST001</td>\n",
       "      <td>This is a test product.</td>\n",
       "      <td>10</td>\n",
       "      <td>2009-12-14 08:34:00</td>\n",
       "      <td>7.4250</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>74.2500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21702</th>\n",
       "      <td>491742</td>\n",
       "      <td>TEST001</td>\n",
       "      <td>This is a test product.</td>\n",
       "      <td>5</td>\n",
       "      <td>2009-12-14 11:00:00</td>\n",
       "      <td>7.4250</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>37.1250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21705</th>\n",
       "      <td>491744</td>\n",
       "      <td>TEST001</td>\n",
       "      <td>This is a test product.</td>\n",
       "      <td>5</td>\n",
       "      <td>2009-12-14 11:02:00</td>\n",
       "      <td>7.4250</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>37.1250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28492</th>\n",
       "      <td>492718</td>\n",
       "      <td>TEST001</td>\n",
       "      <td>This is a test product.</td>\n",
       "      <td>5</td>\n",
       "      <td>2009-12-18 10:47:00</td>\n",
       "      <td>7.4250</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>37.1250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28504</th>\n",
       "      <td>492722</td>\n",
       "      <td>TEST002</td>\n",
       "      <td>This is a test product.</td>\n",
       "      <td>1</td>\n",
       "      <td>2009-12-18 10:55:00</td>\n",
       "      <td>1.6500</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>1.6500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31276</th>\n",
       "      <td>493410</td>\n",
       "      <td>TEST001</td>\n",
       "      <td>This is a test product.</td>\n",
       "      <td>5</td>\n",
       "      <td>2010-01-04 09:24:00</td>\n",
       "      <td>7.4250</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>37.1250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31278</th>\n",
       "      <td>493412</td>\n",
       "      <td>TEST001</td>\n",
       "      <td>This is a test product.</td>\n",
       "      <td>5</td>\n",
       "      <td>2010-01-04 09:53:00</td>\n",
       "      <td>7.4250</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>37.1250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37892</th>\n",
       "      <td>494450</td>\n",
       "      <td>TEST001</td>\n",
       "      <td>This is a test product.</td>\n",
       "      <td>5</td>\n",
       "      <td>2010-01-14 13:50:00</td>\n",
       "      <td>7.4250</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>37.1250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44909</th>\n",
       "      <td>495295</td>\n",
       "      <td>TEST001</td>\n",
       "      <td>This is a test product.</td>\n",
       "      <td>5</td>\n",
       "      <td>2010-01-22 13:30:00</td>\n",
       "      <td>7.4250</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>37.1250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49055</th>\n",
       "      <td>C495800</td>\n",
       "      <td>ADJUST</td>\n",
       "      <td>Adjustment by john on 26/01/2010 17</td>\n",
       "      <td>-1</td>\n",
       "      <td>2010-01-26 17:27:00</td>\n",
       "      <td>170.7750</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>-170.7750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78388</th>\n",
       "      <td>499763</td>\n",
       "      <td>20682</td>\n",
       "      <td>RED SPOTTY CHILDS UMBRELLA</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-03-02 13:08:00</td>\n",
       "      <td>5.3625</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>5.3625</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78389</th>\n",
       "      <td>499763</td>\n",
       "      <td>20679</td>\n",
       "      <td>EDWARDIAN PARASOL RED</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-03-02 13:08:00</td>\n",
       "      <td>9.8175</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>9.8175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78390</th>\n",
       "      <td>499763</td>\n",
       "      <td>15056N</td>\n",
       "      <td>EDWARDIAN PARASOL NATURAL</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-03-02 13:08:00</td>\n",
       "      <td>9.8175</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>9.8175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78391</th>\n",
       "      <td>499763</td>\n",
       "      <td>15056BL</td>\n",
       "      <td>EDWARDIAN PARASOL BLACK</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-03-02 13:08:00</td>\n",
       "      <td>9.8175</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>9.8175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78392</th>\n",
       "      <td>499763</td>\n",
       "      <td>15056P</td>\n",
       "      <td>EDWARDIAN PARASOL PINK</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-03-02 13:08:00</td>\n",
       "      <td>9.8175</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>9.8175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194356</th>\n",
       "      <td>513774</td>\n",
       "      <td>21524</td>\n",
       "      <td>DOORMAT SPOTTY HOME SWEET HOME</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-06-28 13:53:00</td>\n",
       "      <td>12.3585</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>12.3585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194357</th>\n",
       "      <td>513774</td>\n",
       "      <td>22692</td>\n",
       "      <td>DOORMAT WELCOME TO OUR HOME</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-06-28 13:53:00</td>\n",
       "      <td>12.3585</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>12.3585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194358</th>\n",
       "      <td>513774</td>\n",
       "      <td>22660</td>\n",
       "      <td>DOORMAT I LOVE LONDON</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-06-28 13:53:00</td>\n",
       "      <td>12.3585</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>12.3585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194359</th>\n",
       "      <td>513774</td>\n",
       "      <td>22687</td>\n",
       "      <td>DOORMAT CHRISTMAS VILLAGE</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-06-28 13:53:00</td>\n",
       "      <td>12.3585</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>12.3585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194360</th>\n",
       "      <td>513774</td>\n",
       "      <td>48173C</td>\n",
       "      <td>DOORMAT BLACK FLOCK</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-06-28 13:53:00</td>\n",
       "      <td>12.3585</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>12.3585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194361</th>\n",
       "      <td>513774</td>\n",
       "      <td>22691</td>\n",
       "      <td>DOORMAT WELCOME SUNRISE</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-06-28 13:53:00</td>\n",
       "      <td>12.3585</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>12.3585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194362</th>\n",
       "      <td>513774</td>\n",
       "      <td>48111</td>\n",
       "      <td>DOORMAT 3 SMILEY CATS</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-06-28 13:53:00</td>\n",
       "      <td>12.3585</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>12.3585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194363</th>\n",
       "      <td>513774</td>\n",
       "      <td>22690</td>\n",
       "      <td>DOORMAT HOME SWEET HOME BLUE</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-06-28 13:53:00</td>\n",
       "      <td>12.3585</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>12.3585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194364</th>\n",
       "      <td>513774</td>\n",
       "      <td>21523</td>\n",
       "      <td>DOORMAT FANCY FONT HOME SWEET HOME</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-06-28 13:53:00</td>\n",
       "      <td>12.3585</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>12.3585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194365</th>\n",
       "      <td>513774</td>\n",
       "      <td>48138</td>\n",
       "      <td>DOORMAT UNION FLAG</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-06-28 13:53:00</td>\n",
       "      <td>12.3585</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>12.3585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194366</th>\n",
       "      <td>513774</td>\n",
       "      <td>22689</td>\n",
       "      <td>DOORMAT MERRY CHRISTMAS RED</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-06-28 13:53:00</td>\n",
       "      <td>12.3585</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>12.3585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194367</th>\n",
       "      <td>513774</td>\n",
       "      <td>22365</td>\n",
       "      <td>DOORMAT RESPECTABLE HOUSE</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-06-28 13:53:00</td>\n",
       "      <td>12.3585</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>12.3585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194368</th>\n",
       "      <td>513774</td>\n",
       "      <td>48185</td>\n",
       "      <td>DOORMAT FAIRY CAKE</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-06-28 13:53:00</td>\n",
       "      <td>12.3585</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>12.3585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194369</th>\n",
       "      <td>513774</td>\n",
       "      <td>22688</td>\n",
       "      <td>DOORMAT PEACE ON EARTH BLUE</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-06-28 13:53:00</td>\n",
       "      <td>12.3585</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>12.3585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194370</th>\n",
       "      <td>513774</td>\n",
       "      <td>48188</td>\n",
       "      <td>DOORMAT WELCOME PUPPIES</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-06-28 13:53:00</td>\n",
       "      <td>12.3585</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>12.3585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194371</th>\n",
       "      <td>513774</td>\n",
       "      <td>48187</td>\n",
       "      <td>DOORMAT NEW ENGLAND</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-06-28 13:53:00</td>\n",
       "      <td>12.3585</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>12.3585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194372</th>\n",
       "      <td>513774</td>\n",
       "      <td>22366</td>\n",
       "      <td>DOORMAT AIRMAIL</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-06-28 13:53:00</td>\n",
       "      <td>12.3585</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>12.3585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194373</th>\n",
       "      <td>513774</td>\n",
       "      <td>20685</td>\n",
       "      <td>DOORMAT RED SPOT</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-06-28 13:53:00</td>\n",
       "      <td>12.3585</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>12.3585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194374</th>\n",
       "      <td>513774</td>\n",
       "      <td>21955</td>\n",
       "      <td>DOORMAT UNION JACK GUNS AND ROSES</td>\n",
       "      <td>1</td>\n",
       "      <td>2010-06-28 13:53:00</td>\n",
       "      <td>12.3585</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>12.3585</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196542</th>\n",
       "      <td>C514024</td>\n",
       "      <td>M</td>\n",
       "      <td>Manual</td>\n",
       "      <td>-1</td>\n",
       "      <td>2010-06-30 11:22:00</td>\n",
       "      <td>8.5470</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>-8.5470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196543</th>\n",
       "      <td>C514024</td>\n",
       "      <td>M</td>\n",
       "      <td>Manual</td>\n",
       "      <td>-1</td>\n",
       "      <td>2010-06-30 11:22:00</td>\n",
       "      <td>21.3510</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>-21.3510</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196544</th>\n",
       "      <td>C514024</td>\n",
       "      <td>M</td>\n",
       "      <td>Manual</td>\n",
       "      <td>-1</td>\n",
       "      <td>2010-06-30 11:22:00</td>\n",
       "      <td>7.6890</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>-7.6890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196545</th>\n",
       "      <td>C514024</td>\n",
       "      <td>M</td>\n",
       "      <td>Manual</td>\n",
       "      <td>-1</td>\n",
       "      <td>2010-06-30 11:22:00</td>\n",
       "      <td>42.7020</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>-42.7020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196546</th>\n",
       "      <td>C514024</td>\n",
       "      <td>M</td>\n",
       "      <td>Manual</td>\n",
       "      <td>-3</td>\n",
       "      <td>2010-06-30 11:22:00</td>\n",
       "      <td>21.3510</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>-64.0530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196547</th>\n",
       "      <td>C514024</td>\n",
       "      <td>M</td>\n",
       "      <td>Manual</td>\n",
       "      <td>-1</td>\n",
       "      <td>2010-06-30 11:22:00</td>\n",
       "      <td>1.8975</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>-1.8975</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196548</th>\n",
       "      <td>C514024</td>\n",
       "      <td>M</td>\n",
       "      <td>Manual</td>\n",
       "      <td>-4</td>\n",
       "      <td>2010-06-30 11:22:00</td>\n",
       "      <td>21.8130</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>-87.2520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196549</th>\n",
       "      <td>C514024</td>\n",
       "      <td>M</td>\n",
       "      <td>Manual</td>\n",
       "      <td>-1</td>\n",
       "      <td>2010-06-30 11:22:00</td>\n",
       "      <td>52.4370</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>-52.4370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196550</th>\n",
       "      <td>C514024</td>\n",
       "      <td>M</td>\n",
       "      <td>Manual</td>\n",
       "      <td>-1</td>\n",
       "      <td>2010-06-30 11:22:00</td>\n",
       "      <td>234.8115</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>-234.8115</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>290224</th>\n",
       "      <td>C525099</td>\n",
       "      <td>D</td>\n",
       "      <td>Discount</td>\n",
       "      <td>-1</td>\n",
       "      <td>2010-10-04 09:54:00</td>\n",
       "      <td>1.6500</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>-1.6500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291616</th>\n",
       "      <td>C525274</td>\n",
       "      <td>TEST001</td>\n",
       "      <td>This is a test product.</td>\n",
       "      <td>-1</td>\n",
       "      <td>2010-10-04 16:33:00</td>\n",
       "      <td>7.4250</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>-7.4250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>433791</th>\n",
       "      <td>541431</td>\n",
       "      <td>23166</td>\n",
       "      <td>MEDIUM CERAMIC TOP STORAGE JAR</td>\n",
       "      <td>74215</td>\n",
       "      <td>2011-01-18 10:01:00</td>\n",
       "      <td>1.7160</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>127352.9400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>433796</th>\n",
       "      <td>C541433</td>\n",
       "      <td>23166</td>\n",
       "      <td>MEDIUM CERAMIC TOP STORAGE JAR</td>\n",
       "      <td>-74215</td>\n",
       "      <td>2011-01-18 10:17:00</td>\n",
       "      <td>1.7160</td>\n",
       "      <td>12346</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>-127352.9400</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       order_id product_id                          description  quantity  \\\n",
       "21447    491725    TEST001              This is a test product.        10   \n",
       "21702    491742    TEST001              This is a test product.         5   \n",
       "21705    491744    TEST001              This is a test product.         5   \n",
       "28492    492718    TEST001              This is a test product.         5   \n",
       "28504    492722    TEST002              This is a test product.         1   \n",
       "31276    493410    TEST001              This is a test product.         5   \n",
       "31278    493412    TEST001              This is a test product.         5   \n",
       "37892    494450    TEST001              This is a test product.         5   \n",
       "44909    495295    TEST001              This is a test product.         5   \n",
       "49055   C495800     ADJUST  Adjustment by john on 26/01/2010 17        -1   \n",
       "78388    499763      20682           RED SPOTTY CHILDS UMBRELLA         1   \n",
       "78389    499763      20679                EDWARDIAN PARASOL RED         1   \n",
       "78390    499763     15056N            EDWARDIAN PARASOL NATURAL         1   \n",
       "78391    499763    15056BL              EDWARDIAN PARASOL BLACK         1   \n",
       "78392    499763     15056P               EDWARDIAN PARASOL PINK         1   \n",
       "194356   513774      21524       DOORMAT SPOTTY HOME SWEET HOME         1   \n",
       "194357   513774      22692          DOORMAT WELCOME TO OUR HOME         1   \n",
       "194358   513774      22660                DOORMAT I LOVE LONDON         1   \n",
       "194359   513774      22687            DOORMAT CHRISTMAS VILLAGE         1   \n",
       "194360   513774     48173C                 DOORMAT BLACK FLOCK          1   \n",
       "194361   513774      22691              DOORMAT WELCOME SUNRISE         1   \n",
       "194362   513774      48111                DOORMAT 3 SMILEY CATS         1   \n",
       "194363   513774      22690        DOORMAT HOME SWEET HOME BLUE          1   \n",
       "194364   513774      21523   DOORMAT FANCY FONT HOME SWEET HOME         1   \n",
       "194365   513774      48138                   DOORMAT UNION FLAG         1   \n",
       "194366   513774      22689         DOORMAT MERRY CHRISTMAS RED          1   \n",
       "194367   513774      22365            DOORMAT RESPECTABLE HOUSE         1   \n",
       "194368   513774      48185                   DOORMAT FAIRY CAKE         1   \n",
       "194369   513774      22688          DOORMAT PEACE ON EARTH BLUE         1   \n",
       "194370   513774      48188              DOORMAT WELCOME PUPPIES         1   \n",
       "194371   513774      48187                  DOORMAT NEW ENGLAND         1   \n",
       "194372   513774      22366                     DOORMAT AIRMAIL          1   \n",
       "194373   513774      20685                     DOORMAT RED SPOT         1   \n",
       "194374   513774      21955    DOORMAT UNION JACK GUNS AND ROSES         1   \n",
       "196542  C514024          M                               Manual        -1   \n",
       "196543  C514024          M                               Manual        -1   \n",
       "196544  C514024          M                               Manual        -1   \n",
       "196545  C514024          M                               Manual        -1   \n",
       "196546  C514024          M                               Manual        -3   \n",
       "196547  C514024          M                               Manual        -1   \n",
       "196548  C514024          M                               Manual        -4   \n",
       "196549  C514024          M                               Manual        -1   \n",
       "196550  C514024          M                               Manual        -1   \n",
       "290224  C525099          D                             Discount        -1   \n",
       "291616  C525274    TEST001              This is a test product.        -1   \n",
       "433791   541431      23166       MEDIUM CERAMIC TOP STORAGE JAR     74215   \n",
       "433796  C541433      23166       MEDIUM CERAMIC TOP STORAGE JAR    -74215   \n",
       "\n",
       "                order_date     price  customer_id         country        total  \n",
       "21447  2009-12-14 08:34:00    7.4250        12346  United Kingdom      74.2500  \n",
       "21702  2009-12-14 11:00:00    7.4250        12346  United Kingdom      37.1250  \n",
       "21705  2009-12-14 11:02:00    7.4250        12346  United Kingdom      37.1250  \n",
       "28492  2009-12-18 10:47:00    7.4250        12346  United Kingdom      37.1250  \n",
       "28504  2009-12-18 10:55:00    1.6500        12346  United Kingdom       1.6500  \n",
       "31276  2010-01-04 09:24:00    7.4250        12346  United Kingdom      37.1250  \n",
       "31278  2010-01-04 09:53:00    7.4250        12346  United Kingdom      37.1250  \n",
       "37892  2010-01-14 13:50:00    7.4250        12346  United Kingdom      37.1250  \n",
       "44909  2010-01-22 13:30:00    7.4250        12346  United Kingdom      37.1250  \n",
       "49055  2010-01-26 17:27:00  170.7750        12346  United Kingdom    -170.7750  \n",
       "78388  2010-03-02 13:08:00    5.3625        12346  United Kingdom       5.3625  \n",
       "78389  2010-03-02 13:08:00    9.8175        12346  United Kingdom       9.8175  \n",
       "78390  2010-03-02 13:08:00    9.8175        12346  United Kingdom       9.8175  \n",
       "78391  2010-03-02 13:08:00    9.8175        12346  United Kingdom       9.8175  \n",
       "78392  2010-03-02 13:08:00    9.8175        12346  United Kingdom       9.8175  \n",
       "194356 2010-06-28 13:53:00   12.3585        12346  United Kingdom      12.3585  \n",
       "194357 2010-06-28 13:53:00   12.3585        12346  United Kingdom      12.3585  \n",
       "194358 2010-06-28 13:53:00   12.3585        12346  United Kingdom      12.3585  \n",
       "194359 2010-06-28 13:53:00   12.3585        12346  United Kingdom      12.3585  \n",
       "194360 2010-06-28 13:53:00   12.3585        12346  United Kingdom      12.3585  \n",
       "194361 2010-06-28 13:53:00   12.3585        12346  United Kingdom      12.3585  \n",
       "194362 2010-06-28 13:53:00   12.3585        12346  United Kingdom      12.3585  \n",
       "194363 2010-06-28 13:53:00   12.3585        12346  United Kingdom      12.3585  \n",
       "194364 2010-06-28 13:53:00   12.3585        12346  United Kingdom      12.3585  \n",
       "194365 2010-06-28 13:53:00   12.3585        12346  United Kingdom      12.3585  \n",
       "194366 2010-06-28 13:53:00   12.3585        12346  United Kingdom      12.3585  \n",
       "194367 2010-06-28 13:53:00   12.3585        12346  United Kingdom      12.3585  \n",
       "194368 2010-06-28 13:53:00   12.3585        12346  United Kingdom      12.3585  \n",
       "194369 2010-06-28 13:53:00   12.3585        12346  United Kingdom      12.3585  \n",
       "194370 2010-06-28 13:53:00   12.3585        12346  United Kingdom      12.3585  \n",
       "194371 2010-06-28 13:53:00   12.3585        12346  United Kingdom      12.3585  \n",
       "194372 2010-06-28 13:53:00   12.3585        12346  United Kingdom      12.3585  \n",
       "194373 2010-06-28 13:53:00   12.3585        12346  United Kingdom      12.3585  \n",
       "194374 2010-06-28 13:53:00   12.3585        12346  United Kingdom      12.3585  \n",
       "196542 2010-06-30 11:22:00    8.5470        12346  United Kingdom      -8.5470  \n",
       "196543 2010-06-30 11:22:00   21.3510        12346  United Kingdom     -21.3510  \n",
       "196544 2010-06-30 11:22:00    7.6890        12346  United Kingdom      -7.6890  \n",
       "196545 2010-06-30 11:22:00   42.7020        12346  United Kingdom     -42.7020  \n",
       "196546 2010-06-30 11:22:00   21.3510        12346  United Kingdom     -64.0530  \n",
       "196547 2010-06-30 11:22:00    1.8975        12346  United Kingdom      -1.8975  \n",
       "196548 2010-06-30 11:22:00   21.8130        12346  United Kingdom     -87.2520  \n",
       "196549 2010-06-30 11:22:00   52.4370        12346  United Kingdom     -52.4370  \n",
       "196550 2010-06-30 11:22:00  234.8115        12346  United Kingdom    -234.8115  \n",
       "290224 2010-10-04 09:54:00    1.6500        12346  United Kingdom      -1.6500  \n",
       "291616 2010-10-04 16:33:00    7.4250        12346  United Kingdom      -7.4250  \n",
       "433791 2011-01-18 10:01:00    1.7160        12346  United Kingdom  127352.9400  \n",
       "433796 2011-01-18 10:17:00    1.7160        12346  United Kingdom -127352.9400  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_df[train_df.customer_id == train_df.customer_id.min()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "4645\n",
      "['POST' 'D' 'M' 'PADS' 'ADJUST' 'DOT' 'CRUK']\n"
     ]
    }
   ],
   "source": [
    "print(len(train_df['product_id'].unique()))\n",
    "number_product_id = np.char.isalpha(list(train_df['product_id'].unique()))\n",
    "print(train_df['product_id'].unique()[number_product_id])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 1. 어떻게 접근해서 Data를 풀어 나갈 수 있을까?\n",
    " - 로그 데이터니, 고객의 구매 기록을 시계열 처럼 펼처서 보도록 하겠습니다.\n",
    " - 그렇게 하기 위해서는 특정 시간별로 행들을 묶어 줘서 봐야합니다.\n",
    " - 저는 간단하게 월단위로 total을 sum해서 해당 고객의 total값을 봐보도록 하겠습니다."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "train_df['year_month'] = pd.to_datetime(train_df['order_date']).dt.strftime(\"%Y-%m\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>order_id</th>\n",
       "      <th>product_id</th>\n",
       "      <th>description</th>\n",
       "      <th>quantity</th>\n",
       "      <th>order_date</th>\n",
       "      <th>price</th>\n",
       "      <th>customer_id</th>\n",
       "      <th>country</th>\n",
       "      <th>total</th>\n",
       "      <th>year_month</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>489434</td>\n",
       "      <td>85048</td>\n",
       "      <td>15CM CHRISTMAS GLASS BALL 20 LIGHTS</td>\n",
       "      <td>12</td>\n",
       "      <td>2009-12-01 07:45:00</td>\n",
       "      <td>11.4675</td>\n",
       "      <td>13085</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>137.6100</td>\n",
       "      <td>2009-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>489434</td>\n",
       "      <td>79323P</td>\n",
       "      <td>PINK CHERRY LIGHTS</td>\n",
       "      <td>12</td>\n",
       "      <td>2009-12-01 07:45:00</td>\n",
       "      <td>11.1375</td>\n",
       "      <td>13085</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>133.6500</td>\n",
       "      <td>2009-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>489434</td>\n",
       "      <td>79323W</td>\n",
       "      <td>WHITE CHERRY LIGHTS</td>\n",
       "      <td>12</td>\n",
       "      <td>2009-12-01 07:45:00</td>\n",
       "      <td>11.1375</td>\n",
       "      <td>13085</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>133.6500</td>\n",
       "      <td>2009-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>489434</td>\n",
       "      <td>22041</td>\n",
       "      <td>RECORD FRAME 7\" SINGLE SIZE</td>\n",
       "      <td>48</td>\n",
       "      <td>2009-12-01 07:45:00</td>\n",
       "      <td>3.4650</td>\n",
       "      <td>13085</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>166.3200</td>\n",
       "      <td>2009-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>489434</td>\n",
       "      <td>21232</td>\n",
       "      <td>STRAWBERRY CERAMIC TRINKET BOX</td>\n",
       "      <td>24</td>\n",
       "      <td>2009-12-01 07:45:00</td>\n",
       "      <td>2.0625</td>\n",
       "      <td>13085</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>49.5000</td>\n",
       "      <td>2009-12</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>780497</th>\n",
       "      <td>C579886</td>\n",
       "      <td>22197</td>\n",
       "      <td>POPCORN HOLDER</td>\n",
       "      <td>-1</td>\n",
       "      <td>2011-11-30 17:39:00</td>\n",
       "      <td>1.4025</td>\n",
       "      <td>15676</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>-1.4025</td>\n",
       "      <td>2011-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>780498</th>\n",
       "      <td>C579886</td>\n",
       "      <td>23146</td>\n",
       "      <td>TRIPLE HOOK ANTIQUE IVORY ROSE</td>\n",
       "      <td>-1</td>\n",
       "      <td>2011-11-30 17:39:00</td>\n",
       "      <td>5.4285</td>\n",
       "      <td>15676</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>-5.4285</td>\n",
       "      <td>2011-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>780499</th>\n",
       "      <td>C579887</td>\n",
       "      <td>84946</td>\n",
       "      <td>ANTIQUE SILVER T-LIGHT GLASS</td>\n",
       "      <td>-1</td>\n",
       "      <td>2011-11-30 17:42:00</td>\n",
       "      <td>2.0625</td>\n",
       "      <td>16717</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>-2.0625</td>\n",
       "      <td>2011-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>780500</th>\n",
       "      <td>C579887</td>\n",
       "      <td>85048</td>\n",
       "      <td>15CM CHRISTMAS GLASS BALL 20 LIGHTS</td>\n",
       "      <td>-1</td>\n",
       "      <td>2011-11-30 17:42:00</td>\n",
       "      <td>13.1175</td>\n",
       "      <td>16717</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>-13.1175</td>\n",
       "      <td>2011-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>780501</th>\n",
       "      <td>C579887</td>\n",
       "      <td>23490</td>\n",
       "      <td>T-LIGHT HOLDER HANGING LOVE BIRD</td>\n",
       "      <td>-3</td>\n",
       "      <td>2011-11-30 17:42:00</td>\n",
       "      <td>6.1875</td>\n",
       "      <td>16717</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>-18.5625</td>\n",
       "      <td>2011-11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>780502 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       order_id product_id                          description  quantity  \\\n",
       "0        489434      85048  15CM CHRISTMAS GLASS BALL 20 LIGHTS        12   \n",
       "1        489434     79323P                   PINK CHERRY LIGHTS        12   \n",
       "2        489434     79323W                  WHITE CHERRY LIGHTS        12   \n",
       "3        489434      22041         RECORD FRAME 7\" SINGLE SIZE         48   \n",
       "4        489434      21232       STRAWBERRY CERAMIC TRINKET BOX        24   \n",
       "...         ...        ...                                  ...       ...   \n",
       "780497  C579886      22197                       POPCORN HOLDER        -1   \n",
       "780498  C579886      23146       TRIPLE HOOK ANTIQUE IVORY ROSE        -1   \n",
       "780499  C579887      84946         ANTIQUE SILVER T-LIGHT GLASS        -1   \n",
       "780500  C579887      85048  15CM CHRISTMAS GLASS BALL 20 LIGHTS        -1   \n",
       "780501  C579887      23490     T-LIGHT HOLDER HANGING LOVE BIRD        -3   \n",
       "\n",
       "                order_date    price  customer_id         country     total  \\\n",
       "0      2009-12-01 07:45:00  11.4675        13085  United Kingdom  137.6100   \n",
       "1      2009-12-01 07:45:00  11.1375        13085  United Kingdom  133.6500   \n",
       "2      2009-12-01 07:45:00  11.1375        13085  United Kingdom  133.6500   \n",
       "3      2009-12-01 07:45:00   3.4650        13085  United Kingdom  166.3200   \n",
       "4      2009-12-01 07:45:00   2.0625        13085  United Kingdom   49.5000   \n",
       "...                    ...      ...          ...             ...       ...   \n",
       "780497 2011-11-30 17:39:00   1.4025        15676  United Kingdom   -1.4025   \n",
       "780498 2011-11-30 17:39:00   5.4285        15676  United Kingdom   -5.4285   \n",
       "780499 2011-11-30 17:42:00   2.0625        16717  United Kingdom   -2.0625   \n",
       "780500 2011-11-30 17:42:00  13.1175        16717  United Kingdom  -13.1175   \n",
       "780501 2011-11-30 17:42:00   6.1875        16717  United Kingdom  -18.5625   \n",
       "\n",
       "       year_month  \n",
       "0         2009-12  \n",
       "1         2009-12  \n",
       "2         2009-12  \n",
       "3         2009-12  \n",
       "4         2009-12  \n",
       "...           ...  \n",
       "780497    2011-11  \n",
       "780498    2011-11  \n",
       "780499    2011-11  \n",
       "780500    2011-11  \n",
       "780501    2011-11  \n",
       "\n",
       "[780502 rows x 10 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "year_month\n",
       "2009-12    1.089206e+06\n",
       "2010-01    8.752202e+05\n",
       "2010-02    8.045341e+05\n",
       "2010-03    1.045142e+06\n",
       "2010-04    9.207129e+05\n",
       "2010-05    9.204911e+05\n",
       "2010-06    9.384945e+05\n",
       "2010-07    9.254608e+05\n",
       "2010-08    9.656781e+05\n",
       "2010-09    1.284558e+06\n",
       "2010-10    1.586509e+06\n",
       "2010-11    1.862892e+06\n",
       "2010-12    9.114152e+05\n",
       "2011-01    7.816576e+05\n",
       "2011-02    7.186312e+05\n",
       "2011-03    9.546507e+05\n",
       "2011-04    7.016174e+05\n",
       "2011-05    1.067569e+06\n",
       "2011-06    1.001323e+06\n",
       "2011-07    9.456353e+05\n",
       "2011-08    1.014879e+06\n",
       "2011-09    1.533438e+06\n",
       "2011-10    1.605956e+06\n",
       "2011-11    1.859245e+06\n",
       "Name: total, dtype: float64"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "total_per_month = train_df.groupby('year_month')['total'].sum()\n",
    "total_per_month"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAABDAAAAFgCAYAAABNIolGAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAgAElEQVR4nO3dfbildV33/fcHJkwlBWQcSTBQUUNLFES6LW+UhMGrAgsVKkFF0ZTM6lbwriPzKTUv9Y4sihJFM1BRlBRELnyqq1AGRJCUGE0SLp5i8LlU4Hv/sc4Na/bsvWfAtff5+zHv13GsY9b6ng/rs891rjnX+q7zIVWFJEmSJElSy7YZO4AkSZIkSdLm2MCQJEmSJEnNs4EhSZIkSZKaZwNDkiRJkiQ1zwaGJEmSJElq3qqxA7Ru5513rt13333sGJIkSZIkbRUuuuii/6yq1fPrNjA2Y/fdd2fdunVjx5AkSZIkaauQ5KqF6h5CIkmSJEmSmmcDQ5IkSZIkNc8GhiRJkiRJap4NDEmSJEmS1DwbGJIkSZIkqXk2MCRJkiRJUvNsYEiSJEmSpObZwJAkSZIkSc2zgSFJkiRJkppnA0OSJEmSJDXPBoYkSZIkSWreqrEDSJKk/v2PD5w8dgQ++mvHjh1BkiQtIxsYkiRJkiRthW542zljR+D+xx2yxeN6CIkkSZIkSWqeDQxJkiRJktQ8GxiSJEmSJKl5NjAkSZIkSVLzbGBIkiRJkqTm2cCQJEmSJEnNs4EhSZIkSZKaZwNDkiRJkiQ1zwaGJEmSJElqng0MSZIkSZLUPBsYkiRJkiSpecvWwEhySpIbknxxqvbeJJcMt68luWSo757kv6aG/dXUNPskuSzJ+iQnJslQ3ynJeUmuHP7dcahnGG99kkuTPHZqXkcP41+Z5Ojl+tslSZIkSdJsLeceGO8E1k4XquqZVbV3Ve0NfAD44NTgr8wNq6oXTtVPAp4P7Dnc5uZ5AnB+Ve0JnD88Bjhkatxjh+lJshPwSuDxwH7AK+eaHpIkSZIkqW3L1sCoqs8AGxYaNuxF8QzgtKXmkWQX4D5VdUFVFfAu4LBh8KHAqcP9U+fV31UTFwA7DPM5GDivqjZU1c3AecxrsEiSJEmSpDaNdQ6MXwCur6orp2p7JPl8kk8n+YWh9kDg6qlxrh5qAGuq6trh/nXAmqlpvr7ANIvVN5Hk2CTrkqy78cYb7+SfJkmSJEmSZm2sBsaRbLz3xbXAg6rqMcDvAX+f5D5bOrNh74yaVbiqOrmq9q2qfVevXj2r2UqSJEmSpLtoxRsYSVYBvwq8d65WVd+vqpuG+xcBXwEeBlwD7Do1+a5DDeD64dCQuUNNbhjq1wC7LTDNYnVJkiRJktS4MfbA+EXgy1V1+6EhSVYn2Xa4/2AmJ+D86nCIyLeS7D+cN+Mo4MPDZGcBc1cSOXpe/ajhaiT7A98c5nMucFCSHYeTdx401CRJkiRJUuNWLdeMk5wGHADsnORq4JVV9XbgCDY9eecTgVcn+SFwG/DCqpo7AeiLmFzR5J7AOcMN4A3A+5IcA1zF5KSgAGcDTwXWA98DngNQVRuSvAa4cBjv1VPPIUmSJEmSGrZsDYyqOnKR+rMXqH2AyWVVFxp/HfCoBeo3AQcuUC/gxYvM6xTglKVyS5IkSZKk9ox1Ek9JkiRJkqQtZgNDkiRJkiQ1zwaGJEmSJElqng0MSZIkSZLUPBsYkiRJkiSpeTYwJEmSJElS82xgSJIkSZKk5tnAkCRJkiRJzbOBIUmSJEmSmmcDQ5IkSZIkNc8GhiRJkiRJap4NDEmSJEmS1DwbGJIkSZIkqXk2MCRJkiRJUvNsYEiSJEmSpOatGjuAJEmSJEl3N9f/2b+MHYE1v/NzY0eYKffAkCRJkiRJzXMPDEmSGvY/znzT2BH46NNeNnYESZIk98CQJEmSJEnts4EhSZIkSZKaZwNDkiRJkiQ1zwaGJEmSJElqng0MSZIkSZLUPBsYkiRJkiSpeTYwJEmSJElS81aNHUCSJEmSpDvjujd/eewIPOD3HzF2hK3Osu2BkeSUJDck+eJU7Y+TXJPkkuH21Klhr0iyPskVSQ6eqq8dauuTnDBV3yPJZ4f6e5NsN9TvMTxePwzffXPPIUmSJEmS2rach5C8E1i7QP2tVbX3cDsbIMlewBHAI4dp/jLJtkm2Bf4COATYCzhyGBfgjcO8HgrcDBwz1I8Bbh7qbx3GW/Q5Zvw3S5IkSZKkZbBsDYyq+gywYQtHPxQ4vaq+X1X/DqwH9htu66vqq1X1A+B04NAkAZ4MnDFMfypw2NS8Th3unwEcOIy/2HNIkiRJkqTGjXESz+OSXDocYrLjUHsg8PWpca4eaovV7wd8o6pumVffaF7D8G8O4y82r00kOTbJuiTrbrzxxrv2V0qSJEmSpJlZ6QbGScBDgL2Ba4E3r/Dzb5GqOrmq9q2qfVevXj12HEmSJEmStnor2sCoquur6taqug34G+44hOMaYLepUXcdaovVbwJ2SLJqXn2jeQ3D7zuMv9i8JEmSJElS41a0gZFkl6mHTwPmrlByFnDEcAWRPYA9gc8BFwJ7Dlcc2Y7JSTjPqqoCPgkcPkx/NPDhqXkdPdw/HPjEMP5izyFJkiRJkhq3avOj3DVJTgMOAHZOcjXwSuCAJHsDBXwNeAFAVV2e5H3AvwK3AC+uqluH+RwHnAtsC5xSVZcPT3E8cHqS1wKfB94+1N8OvDvJeiYnET1ic88hSZIkSZLatmwNjKo6coHy2xeozY3/OuB1C9TPBs5eoP5VFriKSFX9N/D0O/MckiRJkiSpbWNchUSSJEmSJOlOsYEhSZIkSZKaZwNDkiRJkiQ1zwaGJEmSJElqng0MSZIkSZLUPBsYkiRJkiSpeTYwJEmSJElS82xgSJIkSZKk5tnAkCRJkiRJzbOBIUmSJEmSmmcDQ5IkSZIkNc8GhiRJkiRJap4NDEmSJEmS1DwbGJIkSZIkqXk2MCRJkiRJUvNsYEiSJEmSpObZwJAkSZIkSc2zgSFJkiRJkppnA0OSJEmSJDXPBoYkSZIkSWqeDQxJkiRJktQ8GxiSJEmSJKl5NjAkSZIkSVLzbGBIkiRJkqTm2cCQJEmSJEnNWzV2AEmSxvLUD/3+2BE4+7A3jx1BkiSpC8u2B0aSU5LckOSLU7U3JflykkuTnJlkh6G+e5L/SnLJcPurqWn2SXJZkvVJTkySob5TkvOSXDn8u+NQzzDe+uF5Hjs1r6OH8a9McvRy/e2SJEmSJGm2lvMQkncCa+fVzgMeVVU/C/wb8IqpYV+pqr2H2wun6icBzwf2HG5z8zwBOL+q9gTOHx4DHDI17rHD9CTZCXgl8HhgP+CVc00PSZIkSZLUtmVrYFTVZ4AN82ofr6pbhocXALsuNY8kuwD3qaoLqqqAdwGHDYMPBU4d7p86r/6umrgA2GGYz8HAeVW1oapuZtJMmd9gkSRJkiRJDRrzJJ7PBc6ZerxHks8n+XSSXxhqDwSunhrn6qEGsKaqrh3uXwesmZrm6wtMs1hdkiRJkiQ1bpSTeCb5A+AW4D1D6VrgQVV1U5J9gA8leeSWzq+qKknNMN+xTA4/4UEPetCsZitJkiRJku6iFd8DI8mzgV8CfmM4LISq+n5V3TTcvwj4CvAw4Bo2Psxk16EGcP1waMjcoSY3DPVrgN0WmGax+iaq6uSq2req9l29evVd/EslSZIkSdKsrGgDI8la4OXAr1TV96bqq5NsO9x/MJMTcH51OETkW0n2H64+chTw4WGys4C5K4kcPa9+1HA1kv2Bbw7zORc4KMmOw8k7DxpqkiRJkiSpcct2CEmS04ADgJ2TXM3kCiCvAO4BnDdcDfWC4YojTwReneSHwG3AC6tq7gSgL2JyRZN7Mjlnxtx5M94AvC/JMcBVwDOG+tnAU4H1wPeA5wBU1YYkrwEuHMZ79dRzSJIkSZKkhi1bA6Oqjlyg/PZFxv0A8IFFhq0DHrVA/SbgwAXqBbx4kXmdApyyeGpJkiRJktSiMa9CIkmSJEmStEVsYEiSJEmSpObZwJAkSZIkSc2zgSFJkiRJkppnA0OSJEmSJDXPBoYkSZIkSWqeDQxJkiRJktQ8GxiSJEmSJKl5NjAkSZIkSVLzbGBIkiRJkqTm2cCQJEmSJEnNs4EhSZIkSZKaZwNDkiRJkiQ1zwaGJEmSJElqng0MSZIkSZLUPBsYkiRJkiSpeTYwJEmSJElS81aNHaA3N570d2NHAGD1b/3m2BEkSZIkSVox7oEhSZIkSZKaZwNDkiRJkiQ1z0NIJEmSJC3qbz94w9gReN6v3n/sCJIa4B4YkiRJkiSpeTYwJEmSJElS8zyERNqMC//6l8eOwONe8A9jR5AkSZKkUbkHhiRJkiRJat6ie2AkuQyohQYBVVU/u2ypJEmSJEmSpiy1B8YvAb+8wG2uvllJTklyQ5IvTtV2SnJekiuHf3cc6klyYpL1SS5N8tipaY4exr8yydFT9X2SXDZMc2KS3NXnkCRJkiRJ7Vq0gVFVVy1128L5vxNYO692AnB+Ve0JnD88BjgE2HO4HQucBJNmBPBK4PHAfsAr5xoSwzjPn5pu7V15DkmSJEmS1LbNnsQzyf7AnwM/DWwHbAt8t6rus7lpq+ozSXafVz4UOGC4fyrwKeD4of6uqirggiQ7JNllGPe8qtow5DkPWJvkU8B9quqCof4u4DDgnDv7HFV17eb+FkmSJEm6u/va/3fd2BHY/aUPGDuCGrUlVyF5G3AE8H5gX+Ao4GE/wnOumWoYXAesGe4/EPj61HhXD7Wl6lcvUL8rz2EDQ5IkSerUOe/9z7EjAHDIM3ceO4J0t7ZFVyGpqvXAtlV1a1W9g00PC7lLhj0hFjpR6MzcledIcmySdUnW3XjjjcuUTJIkSZIkbaktaWB8L8l2wCVJ/jTJ727hdIu5fjg0hOHfG4b6NcBuU+PtOtSWqu+6QP2uPMdGqurkqtq3qvZdvXr1nf4DJUmSJEnSbG1JI+JZw3jHAd9l0gD41R/hOc8C5q4kcjTw4an6UcOVQvYHvjkcBnIucFCSHYeTdx4EnDsM+1aS/Yerjxw1b1535jkkSZIkSVLDtuQcGIdV1Z8B/w28CiDJ7wB/trkJk5zG5GSaOye5msnVRN4AvC/JMcBVwDOG0c8GngqsB74HPAegqjYkeQ1w4TDeq+dO6Am8iMmVTu7J5OSd5wz1O/UckiRJkiSpbVvSwDiaTZsVz16gtomqOnKRQQcuMG4BL15kPqcApyxQXwc8aoH6TXf2OSRJkiRJUrsWbWAkORL4dWCPJGdNDboPsGHhqSRJmnjOmTM53/OP5B1P+9jYESRJkjQjS+2B8c9MLi+6M/Dmqfq3gUuXM5QkSZL0ozj8AxePHYEzfu2xY0eQpLuVRRsYVXUVk/NH/FySNcDjhkFfqqpbViKcJEmSJN1dXPiOGzY/0jJ73HPuP3YE6S7b7Dkwkjwd+J/Ap4AAf57kZVV1xjJnk6QV99fvPnjsCLzgWeeOHUGSJElqzpacxPMPgcdV1Q0ASVYD/wuwgSFJkiRJklbEljQwtplrXgxuArZZpjySpM143XvH30vkD57pXiKSJElaWVvSwDgnybnAacPjZwJnL18kSXfWuW9/6tgROPiYpf9beO87xr8iBcAzn+NVKSRJkqQebUkDo4C/Bn5+eHwysP+yJZIkSVoGv3TGe8aOwEcO/42xI0iS1K0taWA8paqOBz44V0jyKuD4ZUslSZIkSZI0ZdEGRpLfAl4EPDjJpVODfgL438sdTJIkSZIkac5Se2D8PXAO8HrghKn6t6tqw7KmkiRJkiRJmrJoA6Oqvgl8Ezhy5eJIkiRJkiRtakvOgaEOXX/Sm8aOwJrfetnYESRJkiRJdxPbjB1AkiRJkiRpc2xgSJIkSZKk5tnAkCRJkiRJzbOBIUmSJEmSmmcDQ5IkSZIkNc8GhiRJkiRJap4NDEmSJEmS1DwbGJIkSZIkqXk2MCRJkiRJUvNWjR1AW6//OPHwsSPwoJecMXYESZIkSdIWcA8MSZIkSZLUPBsYkiRJkiSpeR5CIkmS1IhfPuNDY0cA4B8OP2zsCJIkbcI9MCRJkiRJUvNWvIGR5OFJLpm6fSvJS5P8cZJrpupPnZrmFUnWJ7kiycFT9bVDbX2SE6bqeyT57FB/b5Lthvo9hsfrh+G7r+TfLkmSJEmS7poVb2BU1RVVtXdV7Q3sA3wPOHMY/Na5YVV1NkCSvYAjgEcCa4G/TLJtkm2BvwAOAfYCjhzGBXjjMK+HAjcDxwz1Y4Cbh/pbh/EkSZIkSVLjxj6E5EDgK1V11RLjHAqcXlXfr6p/B9YD+w239VX11ar6AXA6cGiSAE8G5q6PeSpw2NS8Th3unwEcOIwvSZIkSZIaNnYD4wjgtKnHxyW5NMkpSXYcag8Evj41ztVDbbH6/YBvVNUt8+obzWsY/s1h/I0kOTbJuiTrbrzxxh/l75MkSZIkSTMwWgNjOC/FrwDvH0onAQ8B9gauBd48UjSq6uSq2req9l29evVYMSRJkiRJ0mDMPTAOAS6uqusBqur6qrq1qm4D/obJISIA1wC7TU2361BbrH4TsEOSVfPqG81rGH7fYXxJkiRJktSwMRsYRzJ1+EiSXaaGPQ344nD/LOCI4QoiewB7Ap8DLgT2HK44sh2Tw1HOqqoCPgkcPkx/NPDhqXkdPdw/HPjEML4kSZIkSWrYqs2PMntJ7g08BXjBVPlPk+wNFPC1uWFVdXmS9wH/CtwCvLiqbh3mcxxwLrAtcEpVXT7M63jg9CSvBT4PvH2ovx14d5L1wAYmTQ9JkiTdCYedcf7YEfjQ4QeOHUGStMJGaWBU1XeZd/LMqnrWEuO/DnjdAvWzgbMXqH+VOw5Bma7/N/D0uxBZkiRJkiSNaOyrkEiSJEmSJG3WKHtgSJIkSYKXnPn1sSNw4tN22/xIktQA98CQJEmSJEnNs4EhSZIkSZKaZwNDkiRJkiQ1zwaGJEmSJElqng0MSZIkSZLUPBsYkiRJkiSpeTYwJEmSJElS82xgSJIkSZKk5tnAkCRJkiRJzbOBIUmSJEmSmmcDQ5IkSZIkNc8GhiRJkiRJap4NDEmSJEmS1DwbGJIkSZIkqXk2MCRJkiRJUvNsYEiSJEmSpObZwJAkSZIkSc2zgSFJkiRJkppnA0OSJEmSJDXPBoYkSZIkSWqeDQxJkiRJktQ8GxiSJEmSJKl5NjAkSZIkSVLzbGBIkiRJkqTmjdbASPK1JJcluSTJuqG2U5Lzklw5/LvjUE+SE5OsT3JpksdOzefoYfwrkxw9Vd9nmP/6Ydos9RySJEmSJKldY++B8aSq2ruq9h0enwCcX1V7AucPjwEOAfYcbscCJ8GkGQG8Eng8sB/wyqmGxEnA86emW7uZ55AkSZIkSY0au4Ex36HAqcP9U4HDpurvqokLgB2S7AIcDJxXVRuq6mbgPGDtMOw+VXVBVRXwrnnzWug5JEmSJElSo8ZsYBTw8SQXJTl2qK2pqmuH+9cBa4b7DwS+PjXt1UNtqfrVC9SXeo7bJTk2ybok62688ca79MdJkiRJkqTZWTXic/98VV2T5P7AeUm+PD2wqipJLWeAxZ6jqk4GTgbYd999lzWDJEmSJEnavNH2wKiqa4Z/bwDOZHIOi+uHwz8Y/r1hGP0aYLepyXcdakvVd12gzhLPIUmSJEmSGjVKAyPJvZP8xNx94CDgi8BZwNyVRI4GPjzcPws4argayf7AN4fDQM4FDkqy43DyzoOAc4dh30qy/3D1kaPmzWuh55AkSZIkSY0a6xCSNcCZw5VNVwF/X1UfS3Ih8L4kxwBXAc8Yxj8beCqwHvge8ByAqtqQ5DXAhcN4r66qDcP9FwHvBO4JnDPcAN6wyHNIkiRJkqRGjdLAqKqvAo9eoH4TcOAC9QJevMi8TgFOWaC+DnjUlj6HJEmSJElqV2uXUZUkSZIkSdqEDQxJkiRJktQ8GxiSJEmSJKl5NjAkSZIkSVLzbGBIkiRJkqTm2cCQJEmSJEnNs4EhSZIkSZKaZwNDkiRJkiQ1zwaGJEmSJElqng0MSZIkSZLUPBsYkiRJkiSpeTYwJEmSJElS82xgSJIkSZKk5tnAkCRJkiRJzbOBIUmSJEmSmmcDQ5IkSZIkNc8GhiRJkiRJap4NDEmSJEmS1DwbGJIkSZIkqXk2MCRJkiRJUvNsYEiSJEmSpObZwJAkSZIkSc2zgSFJkiRJkppnA0OSJEmSJDXPBoYkSZIkSWqeDQxJkiRJktS8FW9gJNktySeT/GuSy5P8zlD/4yTXJLlkuD11appXJFmf5IokB0/V1w619UlOmKrvkeSzQ/29SbYb6vcYHq8fhu++cn+5JEmSJEm6q8bYA+MW4Perai9gf+DFSfYahr21qvYebmcDDMOOAB4JrAX+Msm2SbYF/gI4BNgLOHJqPm8c5vVQ4GbgmKF+DHDzUH/rMJ4kSZIkSWrcijcwquraqrp4uP9t4EvAA5eY5FDg9Kr6flX9O7Ae2G+4ra+qr1bVD4DTgUOTBHgycMYw/anAYVPzOnW4fwZw4DC+JEmSJElq2KjnwBgO4XgM8NmhdFySS5OckmTHofZA4OtTk1091Bar3w/4RlXdMq++0byG4d8cxp+f69gk65Ksu/HGG3+kv1GSJEmSJP3oRmtgJNke+ADw0qr6FnAS8BBgb+Ba4M1jZauqk6tq36rad/Xq1WPFkCRJkiRJg1EaGEl+jEnz4j1V9UGAqrq+qm6tqtuAv2FyiAjANcBuU5PvOtQWq98E7JBk1bz6RvMaht93GF+SJEmSJDVsjKuQBHg78KWqestUfZep0Z4GfHG4fxZwxHAFkT2APYHPARcCew5XHNmOyYk+z6qqAj4JHD5MfzTw4al5HT3cPxz4xDC+JEmSJElq2KrNjzJzTwCeBVyW5JKh9v8yuYrI3kABXwNeAFBVlyd5H/CvTK5g8uKquhUgyXHAucC2wClVdfkwv+OB05O8Fvg8k4YJw7/vTrIe2MCk6SFJkiRJkhq34g2MqvonYKErf5y9xDSvA163QP3shaarqq9yxyEo0/X/Bp5+Z/JKkiRJkqTxjXoVEkmSJEmSpC1hA0OSJEmSJDXPBoYkSZIkSWqeDQxJkiRJktQ8GxiSJEmSJKl5NjAkSZIkSVLzbGBIkiRJkqTm2cCQJEmSJEnNs4EhSZIkSZKaZwNDkiRJkiQ1zwaGJEmSJElqng0MSZIkSZLUPBsYkiRJkiSpeTYwJEmSJElS82xgSJIkSZKk5tnAkCRJkiRJzbOBIUmSJEmSmmcDQ5IkSZIkNc8GhiRJkiRJap4NDEmSJEmS1DwbGJIkSZIkqXk2MCRJkiRJUvNsYEiSJEmSpObZwJAkSZIkSc2zgSFJkiRJkppnA0OSJEmSJDVvq2xgJFmb5Iok65OcMHYeSZIkSZK0tK2ugZFkW+AvgEOAvYAjk+w1bipJkiRJkrSUra6BAewHrK+qr1bVD4DTgUNHziRJkiRJkpaQqho7w4pKcjiwtqqeNzx+FvD4qjpuapxjgWOHhw8HrphxjJ2B/5zxPGeth4zQR84eMkIfOc04Oz3kNOPs9JCzh4zQR04zzk4POXvICH3kNOPs9JCzh4zQR87lyPhTVbV6fnHVjJ/kbqGqTgZOXq75J1lXVfsu1/xnoYeM0EfOHjJCHznNODs95DTj7PSQs4eM0EdOM85ODzl7yAh95DTj7PSQs4eM0EfOlcy4NR5Ccg2w29TjXYeaJEmSJElq1NbYwLgQ2DPJHkm2A44Azho5kyRJkiRJWsJWdwhJVd2S5DjgXGBb4JSqunyFYyzb4Skz1ENG6CNnDxmhj5xmnJ0ecppxdnrI2UNG6COnGWenh5w9ZIQ+cppxdnrI2UNG6CPnimXc6k7iKUmSJEmS+rM1HkIiSZIkSZI6YwNDkiRJkiQ1zwaGJEmSJElqng0MSZIkSZLUPBsYWlKSPxo7w7QkByc5Jsnu8+rPHSfRxjLxjCRPH+4fmOTEJC9K0uz7Lcknxs4wX5Kd5z3+zWFZHpskY+WaluRpSXYa7q9O8q4klyV5b5Jdx84HkOQtSZ4wdo7NSbJTkj9K8rzhvfMHST6S5E1Jdhw735wkT0rytiQfTvLBJG9I8tCxc01LsirJC5J8LMmlw+2cJC9M8mNj55NaleReSV6e5GVJfjzJs5OcleRPk2w/dr7FJPm3sTNo65XkwUlOSfLaJNsn+ZskX0zy/vmf16VZaPYL1d1Fkm2HD5Kvmf8lIskfjpXrTnje2AHmJPkT4A+AnwHOT/LbU4OPGyfVJv4CeAbwLODdwAuBC4EnAm8dMdftpr7QzN0uA54w93jsfFM+PndneK88C7gIeArwlrFCzfO6qtow3H8b8HngEOAc4B2jpdrYs4A/S3LV8CH8MWMHWsTfAfcG9gE+CTwAeCPwX8A7x4t1hySvB44CLgB+CHxluL0/ydPHzDbPu4G9gT8GnjrcXgU8mslyblqSJi4XdzfYfrss77x3AmuAPYCPAvsCbwICnDRerDsk+XaSbw23byf5NvCQufrY+QCS/OzU/R9L8odDI+hPktxrzGzTkhw392NJkocm+UySbyT5bJKfGTsfwNAo/82WG2hM3jcXAt9hsn38MpPPQh8DThkv1saSbJPkuUk+muQLSS5OcnqSA8bONifJfYcfRr6cZEOSm5J8aajtMHa+LZHknGV/Di+juryS/C1wL+BzTL5IfLqqfm8YdnFVPXbMfEOOxTZ4Ae5ZVatWMs9ihi/aj6mqW4Y38d8DV1TV7yb5fFWN/sUsyWVV9TPDr5zXAbtU1Q+SrAIurqqf3cwsll2Ss4BvAa9l8uUwwD8CPw9QVVeNl+4O069pkouBX6iq7w7L9uKqGv3DRZIrqurhw/2LqmqfqWGXVNXe46W7Pcfnq+oxSR4GPBM4AtgWOA04raqa+OVubnklCXB1VT1w/rAR483luGxuvRve05+uqidksofIP1bVo8ZNOJHk36rqYXd22ErKsOfSQoOAL1TV6Hsw9bD9BpflLM37f+haJtvwGh5/oZFt+InADsDLqur6ofbvVbXHuMnuMP2aJnkzcD8mTf3DgPtV1U1zch8AABRcSURBVFFj5puT5PKqeuRw/6PA31bVmcMX2tdV1eh7Lya5BvgX4MnA/2Ky7f5oVf1g1GBT5n1e+4+qetBCw8aW5B3AVUyW4+FMPgv/I3A88OGq+vMR4wGQ5FzgE8CpVXXdUHsAcDRwYFUdNGa+OUkW+z87wEeqapflfP4mvpjeze03t8FL8jbgL5N8EDiSyYvcgm8Aj5vbEE5L8vUR8ixmVVXdAlBV30jyy8DJSd4PbDdutNvN5fthkgvnNjBD0+W2caNNVNWvJHkacDLwP6vqrCQ/bKVxMeWew94C2wDbVtV34fZle+u40W73qSSvBl4/3H/a8OHnScA3R842pwCGRsVrgNcMv44dCZwNtHL4wzZDI+AngO2T7F5VX0tyP9p5f9+WZKdhr5ufZNIIoqpuHr7gtGLDsEfIB6rqNpj88gQ8Hbh51GR3uJHJB8np5VbD4/uPkmhTPWy/wWU5c0PT4uwafuUbHjfxi19VvSTJPsBpST7EZO+/JrJNmX5ND2TyGfOHST4DfGGkTAuZ/h50/6o6E6CqPpXkJ0bKNN8NVXV4kvsAhwLPZ/LZ9yNMfoT4+NKTr4jbhh9J7gvcK8m+VbUuk8Mrtx0527R9quo5w/1/SnJBVf3RsF5eAozewAB2r6o3TheGRsYb08jh8oMLgU+z8P/fy76niA2M5Xf7B+/hy/exmZxX4hNAK7uDvQv4KWCTBgaTvRxa8ZUk/3dVfRqgqm4FjknyWuDXxo12u+uSbF9V36mqtXPFoXvaTLd8+JL9cSZfZo+hnS+I067ljkNFNiTZpaquHb7Q3jJirmnHMTms6Yrh8e8m+S7wD0x+ZWzBJhuXqroUuBR4xcrHWdTrmex2CvBc4G+HnsBPMzn8oQV/Anw+k+PNHw78FkzOf0JbH8qPYHL4zV8mmWtY7MDk0JwjRku1sa8y+TXpP+YPaKhx3sP2G1yWs7Ruaht++5eFJA8Bvj1iro1U1UVJfpHJNujTwI+PHGm++w4/lGwD3KOqfghtNYIGZyR5J/Bq4MwkLwXOZLK3wybvp5HMNdG+xeTwwHcPn4OeDpzA1OG2I3o5k889tzHZy+YVSR4N3IdJw6UVP0zykKr6yrAHwdyPjN9vaL28KsnLmeyBMbeH1Rrg2UAr/58DfAl4QVVdOX/ASmx3PIRkmSX5O+Dvqupj8+rPA06qKk+otoWS3BOgqv5rgWEPrKprVj7Vlklyb+DeVXXD2FnmGzYyP1dVfzV2li2RZFsmH4i+N3aWaUnuy2QvoZvGzjJt7sP42Dm2xPDaZthjaRWT8zhcU1XXjhztdsPu+g8G1lfVN8bOsznDB10aXC9fDPxTVW3S+Eny243sytvF9ttluTKSpBr80JxkFyaH1549dpY5w676006oquuHH3PeU1UHjpFrIUmezaQZ/RDgHky+JH4IeGNVjb4nZZLPVNUTx85xZ2VybpGbhx8bm5DkyUzO1/EDJnuGHFFVnx1+hHhZVb18zHwAw56oJzDZ22ZuD7rrgbOYrJMbFpt2JSU5HLisqq5YYNhhVfWhZX3+Bv8v1giGL19rgbnjzq8Bzm3tA3oPOc04Oz3kNOPs9JCzh4xLSfKUqjpv7BxSq5I8gsmXh+n3+FlV9aXxUm2sh4zauiyyTn64qr68+FQrbzjc835V9Z9jZ9Fd51VIRpTkKWNnAEhyFHAxcACTk2zdC3gScNEwrAk95DTj7PSQ04yz00POHjJugbePHWBzWtk2LqW1jEkekeT4TC41feJw/6fHzjWtk4zHA6czOfTuc8MtTM43ccKY2eb0kBH6eL2hj5ytZ1xinTy9pXVy8HAmh583uSyXkuQ5mx9rfCuR0z0wRpR5Z+odMccVwOPn/4I47Mb02WrgjPXQR04zzk4POc04Oz3k7CEjQCZXGlpwEPDkqrr3Sua5s1rZNi6lpYzDl4cjmXyBuHoo78rkfCenV9Ubxso2p4eMAJmc3+aRc+dsmKpvB1xeVXuOk2yjLD1k7OX1bj5nJxmbXyehj2W5lJa2O0tZiZyexHOZbeaD5P1WMssSwsJnsL6Nts4O3kNOM85ODznNODs95OwhI8AvAL8JzD/3SYD9Vj7OpnrYNvaQcXAMC395eAtwOdDCh/IeMsLkvfyTTK7qMm2XYVgLesjYy+vdQ84eMvawTkIHyzLJpYsNAtasZJaljJ3TBsbya/6DJPA64OJMrkoxd+bYBwFPYXLZxVb0kNOMs9NDTjPOTg85e8gIcAHwvbkrNk0b9iJpQQ/bxh4yQh9fHnrICPBS4PwkV7Lxe/yhTK740YIeMvbyeveQs4eMPayT0MeyXAMczKaXPA/wzysfZ1Gj5vQQkmWW5BzgT6vqkwsMa+bMwsMu0Aez6Ynp5q+Yo+ohpxlnp4ecZpydHnL2kLEHPWwbe8gIkGQt8DZgwS8P86/8MYYeMs5Jsg2TBtX0e/zCxq6m0HTGXl7vHnL2kBHaXyehj2WZ5O3AO6rqnxYY9vdV9esjxNrE2DltYGhBSX6pqj4ydo7N6SGnGWenh5xmnJ0ecvaQEfrJqbumky8PzWdcSJJjq+rksXMspcWMvbzePeTsIeN8La6T0Oey1KZsYIyghw+SSS6uqseOnWNzeshpxtnpIacZZ6eHnD1khD5ydrJtbD4jtPvlYVoPGaGb904PGXt5vZvP2UnG5tdJ6GZZNp8RVjanl1Edx6vHDrAFWjoh3VJ6yGnG2ekhpxlnp4ecPWSEPnL2sG3sISPAC8cOsAV6yAh9vHd6yNjL691Dzh4y9rBOQh/LsoeMsII5bWCMo4c39QvGDrCFeshpxtnpIacZZ6eHnD1khD5y9rBt7CEj9JGzh4wAvzx2gC3QQ8ZeXu8ecvaQsYd1EvpYlj1khBXM6VVIxtHcB8kkjwAOZeqYsCTfrqovjRhrEz3kNOPs9JDTjLPTQ84eMkI/Oedpbtu4gB4yQh9fHnrISFVdDZDkOVX1jrHzLKSHjHTyetNHzuYzdrJOQgfLkj4ywgrmdA+MFZBk+ySHJ/ndJC8BdhpOItOEJMcDpzPpnH1uuAU4LckJY2ab1kNOM85ODznNODs95OwhI3SV8xFJjk9yYpITgScl+emxc03rIeNCpr88jJ1lMT1knOdVYwfYAs1m7OX17iFnDxmnNLtOQh/LsoeMsLI5PYnnMkvyDOD/AS4FnsTk2rjbAD8D/EZVXTZiPACS/BvwyKr64bz6dsDlVbXnOMk21kNOM85ODznNODs95OwhI/SRc2iyHMmk0XL1UN4VOAI4vareMFa2OT1k3Jwk/1FVDxo7x1Jaypjk0sUGAQ+rqnusZJ4Fg3SQcSktvd5L6SFnKxl7XyehnWW5lB4ywsrk9BCS5feHwP5V9b0kOwPvqaqDk/ws8NfA/zVuPABuA34SuGpefZdhWCt6yGnG2ekhpxlnp4ecPWSEPnIew8JNlrcAlwMtNAd6yLi5Lw9rVjLLYnrIOFgDHAzcPK8eJj9AtaD5jL283j3k7CEjHayT0Mey7CEjjJ/TBsbyC/Bfw/3vAvcHqKpLk9xntFQbeylwfpIrga8PtQcBDwWOGy3VpnrIacbZ6SGnGWenh5w9ZIQ+cvbQZOkhI/Tx5aGHjAAfAbavqkvmD0jyqZWPs6AeMvbyeveQs4eMPayT0Mey7CEjjJzTBsbyOxv4WJLPAGuB9wMk2YlGzipbVR9L8jBgP6ZO+AZcWFW3jpdsYz3kNOPs9JDTjLPTQ84eMkI3OXtosvSQEfr48tBDRqrqmCWG/fpKZllMDxnp5PWmj5zNZ+xknYQOliV9ZISRc3oOjBWQ5KnAXsAXquq8obYN8GNV9f1Rw21Gku2r6jtj59icHnKacXZ6yGnG2ekhZw8Zoa2cw3aw5SZLFxm1Mlp67yymh4zaurhOajnYwFghSdYw9QGoqq4fM8+W8oQxs2PG2ekhpxlnp4ecPWSEPnL28IG3h4zQR84eMkI3750eMvbyejefs5OMza+T0M2ybD4jrExODyFZZkn2Bv4KuC+TX24Adk3yDeBFVXXxaOEGSX5vsUHA9iuZZSk95DTj7PSQ04yz00POHjJCPzmX8K9MDtVoWQ8ZoY+czWTs4b3TQ8bNaOb13owecjaR8W6wTkIjy3IzesgIK5DTBsbyeyfwgqr67HQxyf7AO4BHjxFqnj8B3gTcssCwbVY4y1J6yGnG2ekhpxlnp4ecPWSEDnL28IG3h4zQR84eMg6af+/QQcZeXu8ecvaQkQ7WSehjWfaQEcbPaQNj+d17fvMCoKouSHLvMQIt4GLgQ1V10fwBSZ43Qp7F9JDTjLPTQ04zzk4POXvICH3k7OEDbw8ZoY+cPWSEPt47PWTs5fXuIWcPGXtYJ6GPZdlDRhg5p+fAWGZJTgQeAryLO85ivhtwFPDvVTX6mcyTPBzYUFU3LjBsTSvn6+ghpxlnp4ecZpydHnL2kBH6yJnkn4HfXuQD79erarcRYs3P0XxG6CNnDxmhm/dODxl7eb2bz9lJxubXSehmWTafEcbPaQNjBSQ5BDiUjc9iflZVnT1eKkmSxtHDB94eMkIfOXvIqNnp5fXuIWcPGXvRw7LsISOMn9MGhkhyX+AVwGHA/YECbgA+DLyhqr4xYrzb9ZDTjLPTQ04zzk4POXvICP3klFrTw3unh4zaurhOaqW1dCzN3VKS+yZ5Q5IvJdmQ5Kbh/huS7DB2vsH7gJuBA6pqp6q6H/Ckofa+UZNtrIecZpydHnKacXZ6yNlDRugg59S28cutbht7yAh95Owh46D59w4dZOzl9e4hZw8Z6WCdhD6WZQ8ZYfyc7oGxzJKcC3wCOLWqrhtqDwCeDTy5qg4aMR4ASa6oqoff2WErrYecZpydHnKacXZ6yNlDRugj5xLbxqOBAxvZNjafEfrI2UNG6Oa900PGXl7v5nN2krH5dRK6WZbNZ4Txc7oHxvLbvareOPfiAlTVdVX1BuCnRsw17aokL0+yZq6QZE2S47njxKMt6CGnGWenh5xmnJ0ecvaQEfrIudi28Y20s23sISP0kbOHjNDHe6eHjL283j3k7CFjD+sk9LEse8gII+e0gbH8enhTPxO4H/DpJDcn2QB8CtgJeMaYwebpIacZZ6eHnGacnR5y9pAR+sjZw7axh4zQR84eMkIf750eMvbyeveQs4eMPayT0Mey7CEjjJzTQ0iWWZIdgROYXIVkDZMT21wPnAW8sao2jBjvdkkeAewKXFBV35mqr62qj42XbGM95DTj7PSQ04yz00POHjJC+zl72Db2kBH6yNlDxjmtv3eg/Yy9vN495OwhI7S/TkIfy7KHjNBAzqrytsw34BHALwLbz6uvHTvbkOMlwBXAh4CvAYdODbt47Hw95TTj1pXTjFtXzh4ydpaz6W1jLxl7ydlJxubfOz1k7OX17iVn6xl7WSd7WJa9ZBw75+h//N391sObGrhsbuUDdgfWAb8zPP782Pl6ymnGrSunGbeunD1k7CVnJ9vG5jP2krOHjEOWHt47PWTs5fVuPmcnGZtfJztals1nbCHnKrTcng/sU1XfSbI7cEaS3avqz4CMmuwO29Swu1dVfS3JAUxy/hTtZIQ+cppxdnrIacbZ6SFnDxmhj5w9bBt7yAh95OwhI/Tx3ukhYy+vdw85e8jYwzoJfSzLHjLCyDk9iefy2+hNDRwAHJLkLbSzIl6fZO+5B0PeXwJ2Bn5mtFSb6iGnGWenh5xmnJ0ecvaQEfrI2cO2sYeM0EfOHjJCH++dHjL28nr3kLOHjD2sk9DHsuwhI4yc0wbG8uvhTX0UcN10oapuqaqjgCeOE2lBPeQ04+z0kNOMs9NDzh4yQh85e9g29pAR+sjZQ0bo473TQ8ZeXu8ecvaQsYd1EvpYlj1khJFzehWSZZZkV+CWmrpO7tSwJ1TV/x4hliRJo+lh29hDRugjZw8ZNTu9vN495OwhYy96WJY9ZITxc9rAkCRJkiRJzfMQEkmSJEmS1DwbGJIkSZIkqXk2MCRJkiRJUvNsYEiSJG2BJC9Ncq+px98ZM48kSVsbGxiSJKlLSbZd4ad8KXCvzY4lSZKWhQ0MSZK07JK8OslLpx6/LsnvJHlZkguTXJrkVVPDP5TkoiSXJzl2qv6dJG9O8gXg5xZ5rq8leX2SS5KsS/LYJOcm+UqSFw7jJMmbknwxyWVJnjnUD0jyqSRnJPlykvcM474E+Engk0k+Oe/v+EKSC5KsmfmCkyRJt7OBIUmSVsIpwFEASbYBjgCuA/YE9gP2BvZJ8sRh/OdW1T7AvsBLktxvqN8b+GxVPbqq/mmJ5/uPqtob+EfgncDhwP7AXJPkV4fnfDTwi8CbkuwyDHsMk70t9gIeDDyhqk4E/g/wpKp60lSWC6rq0cBngOff6aUiSZK22KqxA0iSpLu/qvpakpuSPAZYA3weeBxw0HAfYHsmDY3PMGlaPG2o7zbUbwJuBT6wBU951vDvZcD2VfVt4NtJvp9kB+DngdOq6lbg+iSfHvJ8C/hcVV0NkOQSYHdgoWbJD4CPDPcvAp6yBbkkSdJdZANDkiStlL8Fng08gMkeGQcCr6+qv54eKckBTPaK+Lmq+l6STwE/Pgz+76HpsDnfH/69ber+3OPNff6ZHv/WJcb/YVXVFownSZJmwENIJEnSSjkTWMtkT4dzh9tzk2wPkOSBSe4P3Be4eWhePILJoR+z9o/AM5Nsm2Q18ETgc5uZ5tvATyxDFkmStAX8pUCSJK2IqvrBcALMbwx7UXw8yU8D/5IE4DvAbwIfA16Y5EvAFcAFyxDnTCYnAf0CUMDLq+q6oWGymJOBjyX5P1PnwZAkSSskd+z5KEmStHyGk3deDDy9qq4cO48kSeqLh5BIkqRll2QvYD1wvs0LSZJ0V7gHhiRJ6lKSM4E95pWPr6pzx8gjSZKWlw0MSZIkSZLUPA8hkSRJkiRJzbOBIUmSJEmSmmcDQ5IkSZIkNc8GhiRJkiRJat7/D+u76xpMz3TQAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 1080x360 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "sns.barplot(x=total_per_month.index, y=total_per_month)\n",
    "plt.xticks(rotation=90)\n",
    "plt.tight_layout()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/opt/conda/lib/python3.7/site-packages/seaborn/distributions.py:2557: FutureWarning: `distplot` is a deprecated function and will be removed in a future version. Please adapt your code to use either `displot` (a figure-level function with similar flexibility) or `histplot` (an axes-level function for histograms).\n",
      "  warnings.warn(msg, FutureWarning)\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7f9ca8667fd0>"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAA4QAAAE9CAYAAABTFKyvAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjMsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+AADFEAAAgAElEQVR4nO3df7Bfd13n8eeLmyZAgVDaqJAUE20opoz8ulRQxlUKNFUkO2M7pIp02WpdbRV1Z51Ud7vY2c5Y1wFRW7VLq6WCSYmAd5lobC2zjj9IcwsFmpTIpS00AWz6gxSYbeqN7/3j+2n36+1Nctvm3Jv7Pc/HzHfuOe/z+Zz7OfnMfNvXPef7+aaqkCRJkiT1zzMWegCSJEmSpIVhIJQkSZKknjIQSpIkSVJPGQglSZIkqacMhJIkSZLUUwZCSZIkSeqpJQs9gPlwyimn1OrVqxd6GJIkSZK0IG677bb7q2rFzHqngTDJeuB9wBjw/qr6zRnHlwEfAF4NPAC8raruaccuBS4EDgG/WFXbW/2XgZ8GCvgc8M6qeuRI41i9ejWTk5PH8MokSZIkafFI8qXZ6p09MppkDLgKOAdYB5yfZN2MZhcCD1XVacB7gStb33XARuAMYD1wdZKxJCuBXwTGq+plDILmxq6uQZIkSZJGWZefITwTmKqqu6rqUWAzsGFGmw3A9W17K3BWkrT65qo6WFV3A1PtfDC4q/msJEuAZwNf6fAaJEmSJGlkdRkIVwL3Du3vbbVZ21TVNHAAOPlwfatqH/DbwJeBrwIHquqvOxm9JEmSJI24RbXKaJKTGNw9XAO8CDgxydsP0/aiJJNJJvfv3z+fw5QkSZKkRaHLQLgPOHVof1WrzdqmPQK6nMHiMofr+0bg7qraX1X/AnwE+P7ZfnlVXVNV41U1vmLFExbTkSRJkqTe6zIQ7gTWJlmTZCmDxV8mZrSZAC5o2+cCt1RVtfrGJMuSrAHWArcyeFT0tUme3T5reBZwZ4fXIEmSJEkjq7Ovnaiq6SSXANsZrAZ6XVXtSnI5MFlVE8C1wA1JpoAHaSuGtnY3AruBaeDiqjoE7EiyFfhUq38auKara5AkSZKkUZbBDbnRNj4+Xn4PoSRJkqS+SnJbVY3PrC+qRWUkSZIkSceOgVCSJEmSespAKEmSJEk9ZSBcQB/a8eWFHoIkSZKkHjMQSpIkSVJPGQglSZIkqacMhJIkSZLUUwZCSZIkSeopA6EkSZIk9ZSBUJIkSZJ6ykAoSZIkST1lIJQkSZKknjIQSpIkSVJPGQglSZIkqacMhJIkSZLUUwZCSZIkSeopA6EkSZIk9ZSBUJIkSZJ6ykAoSZIkST1lIJQkSZKknjIQSpIkSVJPGQglSZIkqacMhJIkSZLUUwZCSZIkSeopA6EkSZIk9VSngTDJ+iR7kkwl2TTL8WVJtrTjO5KsHjp2aavvSXJ2q52e5Pah18NJfqnLa5AkSZKkUbWkqxMnGQOuAt4E7AV2Jpmoqt1DzS4EHqqq05JsBK4E3pZkHbAROAN4EXBzkpdU1R7gFUPn3wd8tKtrkCRJkqRR1uUdwjOBqaq6q6oeBTYDG2a02QBc37a3AmclSatvrqqDVXU3MNXON+ws4ItV9aXOrkCSJEmSRliXgXAlcO/Q/t5Wm7VNVU0DB4CT59h3I/Bnx3C8kiRJktQri3JRmSRLgbcCHz5Cm4uSTCaZ3L9///wNTpIkSZIWiS4D4T7g1KH9Va02a5skS4DlwANz6HsO8Kmq+ufD/fKquqaqxqtqfMWKFU/5IiRJkiRpVHUZCHcCa5OsaXf0NgITM9pMABe07XOBW6qqWn1jW4V0DbAWuHWo3/n4uKgkSZIkPS2drTJaVdNJLgG2A2PAdVW1K8nlwGRVTQDXAjckmQIeZBAaae1uBHYD08DFVXUIIMmJDFYu/dmuxi5JkiRJfdBZIASoqm3Athm1y4a2HwHOO0zfK4ArZql/i8HCM5IkSZKkp2FRLiojSZIkSXr6DISSJEmS1FMGQkmSJEnqKQOhJEmSJPWUgVCSJEmSespAKEmSJEk9ZSCUJEmSpJ4yEEqSJElSTxkIJUmSJKmnDISSJEmS1FMGQkmSJEnqKQOhJEmSJPWUgVCSJEmSespAKEmSJEk9ZSCUJEmSpJ4yEEqSJElSTxkIJUmSJKmnDISSJEmS1FMGQkmSJEnqKQOhJEmSJPWUgVCSJEmSespAKEmSJEk9ZSCUJEmSpJ4yEEqSJElST3UaCJOsT7InyVSSTbMcX5ZkSzu+I8nqoWOXtvqeJGcP1Z+fZGuSzye5M8nrurwGSZIkSRpVnQXCJGPAVcA5wDrg/CTrZjS7EHioqk4D3gtc2fquAzYCZwDrgavb+QDeB/xVVb0UeDlwZ1fXIEmSJEmjrMs7hGcCU1V1V1U9CmwGNsxoswG4vm1vBc5KklbfXFUHq+puYAo4M8ly4AeBawGq6tGq+nqH1yBJkiRJI6vLQLgSuHdof2+rzdqmqqaBA8DJR+i7BtgP/HGSTyd5f5ITuxm+JEmSJI22xbaozBLgVcAfVNUrgW8BT/hsIkCSi5JMJpncv3//fI5RkiRJkhaFLgPhPuDUof1VrTZrmyRLgOXAA0fouxfYW1U7Wn0rg4D4BFV1TVWNV9X4ihUrnualSJIkSdLo6TIQ7gTWJlmTZCmDRWImZrSZAC5o2+cCt1RVtfrGtgrpGmAtcGtVfQ24N8nprc9ZwO4Or0GSJEmSRtaSrk5cVdNJLgG2A2PAdVW1K8nlwGRVTTBYHOaGJFPAgwxCI63djQzC3jRwcVUdaqf+BeCDLWTeBbyzq2uQJEmSpFHWWSAEqKptwLYZtcuGth8BzjtM3yuAK2ap3w6MH9uRSpIkSVL/LLZFZSRJkiRJx4iBUJIkSZJ6ykAoSZIkST1lIJQkSZKknjIQSpIkSVJPGQglSZIkqacMhJIkSZLUUwZCSZIkSeopA6EkSZIk9ZSBUJIkSZJ6ykAoSZIkST1lIJQkSZKknjIQSpIkSVJPGQglSZIkqacMhJIkSZLUUwZCSZIkSeopA6EkSZIk9ZSBUJIkSZJ6ykAoSZIkST1lIJQkSZKknjIQSpIkSVJPGQglSZIkqacMhJIkSZLUUwZCSZIkSeqpTgNhkvVJ9iSZSrJpluPLkmxpx3ckWT107NJW35Pk7KH6PUk+l+T2JJNdjl+SJEmSRtmSrk6cZAy4CngTsBfYmWSiqnYPNbsQeKiqTkuyEbgSeFuSdcBG4AzgRcDNSV5SVYdavx+uqvu7GrskSZIk9UGXdwjPBKaq6q6qehTYDGyY0WYDcH3b3gqclSStvrmqDlbV3cBUO58kSZIk6RjpMhCuBO4d2t/barO2qapp4ABw8lH6FvDXSW5LclEH45YkSZKkXujskdEOvb6q9iX5NuCmJJ+vqr+d2aiFxYsAXvziF8/3GCVJkiTpuNflHcJ9wKlD+6tabdY2SZYAy4EHjtS3qh77eR/wUQ7zKGlVXVNV41U1vmLFiqd9MZIkSZI0aroMhDuBtUnWJFnKYJGYiRltJoAL2va5wC1VVa2+sa1CugZYC9ya5MQkzwVIciLwZuCODq9BkiRJkkZWZ4+MVtV0kkuA7cAYcF1V7UpyOTBZVRPAtcANSaaABxmERlq7G4HdwDRwcVUdSvLtwEcH686wBPhQVf1VV9cgSZIkSaOs088QVtU2YNuM2mVD248A5x2m7xXAFTNqdwEvP/YjlSRJkqT+6fSL6SVJkiRJxy8DoSRJkiT1lIFQkiRJknrKQChJkiRJPWUglCRJkqSeMhBKkiRJUk8ZCCVJkiSppwyEkiRJktRTBkJJkiRJ6qk5BcIkH0nyo0kMkJIkSZI0IuYa8K4GfgL4QpLfTHJ6h2OSJEmSJM2DOQXCqrq5qn4SeBVwD3Bzkn9I8s4kJ3Q5QEmSJElSN+b8CGiSk4H/APw08GngfQwC4k2djEySJEmS1Kklc2mU5KPA6cANwI9V1VfboS1JJrsanCRJkiSpO3MKhMD/qqptw4Uky6rqYFWNdzAuSZIkSVLH5vrI6P+YpfaPx3IgkiRJkqT5dcQ7hEm+A1gJPCvJK4G0Q88Dnt3x2CRJkiRJHTraI6NnM1hIZhXwnqH6N4Bf62hMkiRJkqR5cMRAWFXXA9cn+fGq+vN5GpMkSZIkaR4c7ZHRt1fVnwKrk/zKzONV9Z5ZukmSJEmSFoGjPTJ6Yvv5nK4HIkmSJEmaX0d7ZPSP2s/fmJ/hSJIkSZLmy5y+diLJbyV5XpITkvxNkv1J3t714CRJkiRJ3Znr9xC+uaoeBt4C3AOcBvyXrgYlSZIkSereXAPhY4+W/ijw4ao60NF4JEmSJEnzZK6B8ONJPg+8GvibJCuAR47WKcn6JHuSTCXZNMvxZUm2tOM7kqweOnZpq+9JcvaMfmNJPp3k43McvyRJkiRphjkFwqraBHw/MF5V/wJ8C9hwpD5JxoCrgHOAdcD5SdbNaHYh8FBVnQa8F7iy9V0HbATOANYDV7fzPeZdwJ1zGbskSZIkaXZzvUMI8FLgbUneAZwLvPko7c8Epqrqrqp6FNjME0PkBuD6tr0VOCtJWn1zVR2sqruBqXY+kqxi8Ojq+5/E2CVJkiRJMxztewgBSHID8N3A7cChVi7gA0fothK4d2h/L/B9h2tTVdNJDgAnt/onZ/Rd2bZ/B/hV4LlzGbskSZIkaXZzCoTAOLCuqqrLwRxNkrcA91XVbUl+6ChtLwIuAnjxi188D6OTJEmSpMVlro+M3gF8x5M89z7g1KH9Va02a5skS4DlwANH6PsDwFuT3MPgEdQ3JPnT2X55VV1TVeNVNb5ixYonOXRJkiRJGn1zDYSnALuTbE8y8djrKH12AmuTrEmylMEiMTP7TAAXtO1zgVvaXcgJYGNbhXQNsBa4taourapVVbW6ne+Wqnr7HK9BkiRJkjRkro+MvvvJnrh9JvASYDswBlxXVbuSXA5MVtUEcC1wQ5Ip4EEGIY/W7kZgNzANXFxVh2b9RZIkSZKkpyRz/Vhgku8E1lbVzUmeDYxV1Tc6Hd0xMj4+XpOTkws9jCf40I4v8xPf5+cbJUmSJHUryW1VNT6zPqdHRpP8DIOvhfijVloJfOzYDU+SJEmSNN/m+hnCixks6PIwQFV9Afi2rgYlSZIkSereXAPhwfbl8sDjK4Iu6FdQSJIkSZKenrkGwv+T5NeAZyV5E/Bh4H93NyxJkiRJUtfmGgg3AfuBzwE/C2wD/mtXg5IkSZIkdW9OXztRVf+a5GPAx6pqf8djkiRJkiTNgyPeIczAu5PcD+wB9iTZn+Sy+RmeJEmSJKkrR3tk9JcZrC76mqp6QVW9APg+4AeS/HLno5MkSZIkdeZogfCngPOr6u7HClV1F/B24B1dDkySJEmS1K2jBcITqur+mcX2OcITuhmSJEmSJGk+HC0QPvoUj0mSJEmSjnNHW2X05UkenqUe4JkdjEeSJEmSNE+OGAiramy+BiJJkiRJml9z/WJ6SZIkSdKIMRBKkiRJUk8ZCCVJkiSppwyEkiRJktRTBkJJkiRJ6ikDoSRJkiT1lIFQkiRJknrKQChJkiRJPWUglCRJkqSeMhBKkiRJUk8ZCCVJkiSppzoNhEnWJ9mTZCrJplmOL0uypR3fkWT10LFLW31PkrNb7ZlJbk3ymSS7kvxGl+OXJEmSpFHWWSBMMgZcBZwDrAPOT7JuRrMLgYeq6jTgvcCVre86YCNwBrAeuLqd7yDwhqp6OfAKYH2S13Z1DZIkSZI0yrq8Q3gmMFVVd1XVo8BmYMOMNhuA69v2VuCsJGn1zVV1sKruBqaAM2vgm639Ce1VHV6DJEmSJI2sLgPhSuDeof29rTZrm6qaBg4AJx+pb5KxJLcD9wE3VdWOTkYvSZIkSSNu0S0qU1WHquoVwCrgzCQvm61dkouSTCaZ3L9///wOUpIkSZIWgS4D4T7g1KH9Va02a5skS4DlwANz6VtVXwc+weAzhk9QVddU1XhVja9YseJpXIYkSZIkjaYuA+FOYG2SNUmWMlgkZmJGmwnggrZ9LnBLVVWrb2yrkK4B1gK3JlmR5PkASZ4FvAn4fIfXIEmSJEkja0lXJ66q6SSXANuBMeC6qtqV5HJgsqomgGuBG5JMAQ8yCI20djcCu4Fp4OKqOpTkhcD1bcXRZwA3VtXHu7oGSZIkSRplnQVCgKraBmybUbtsaPsR4LzD9L0CuGJG7bPAK4/9SCVJkiSpfxbdojKSJEmSpGPDQChJkiRJPWUglCRJkqSeMhBKkiRJUk8ZCCVJkiSppwyEkiRJktRTBkJJkiRJ6ikDoSRJkiT1lIFQkiRJknrKQChJkiRJPWUglCRJkqSeMhBKkiRJUk8ZCCVJkiSppwyEkiRJktRTBkJJkiRJ6ikDoSRJkiT1lIFQkiRJknrKQChJkiRJPWUglCRJkqSeMhBKkiRJUk8ZCCVJkiSppwyEkiRJktRTBkJJkiRJ6ikDoSRJkiT1VKeBMMn6JHuSTCXZNMvxZUm2tOM7kqweOnZpq+9JcnarnZrkE0l2J9mV5F1djl+SJEmSRllngTDJGHAVcA6wDjg/yboZzS4EHqqq04D3Ale2vuuAjcAZwHrg6na+aeA/V9U64LXAxbOcU5IkSZI0B13eITwTmKqqu6rqUWAzsGFGmw3A9W17K3BWkrT65qo6WFV3A1PAmVX11ar6FEBVfQO4E1jZ4TVIkiRJ0sjqMhCuBO4d2t/LE8Pb422qaho4AJw8l77t8dJXAjuO4ZglSZIkqTcW5aIySZ4D/DnwS1X18GHaXJRkMsnk/v3753eAkiRJkrQIdBkI9wGnDu2varVZ2yRZAiwHHjhS3yQnMAiDH6yqjxzul1fVNVU1XlXjK1aseJqXIkmSJEmjp8tAuBNYm2RNkqUMFomZmNFmArigbZ8L3FJV1eob2yqka4C1wK3t84XXAndW1Xs6HLskSZIkjbwlXZ24qqaTXAJsB8aA66pqV5LLgcmqmmAQ7m5IMgU8yCA00trdCOxmsLLoxVV1KMnrgZ8CPpfk9varfq2qtnV1HZIkSZI0qjoLhAAtqG2bUbtsaPsR4LzD9L0CuGJG7e+AHPuRSpIkSVL/LMpFZSRJkiRJT5+BUJIkSZJ6ykAoSZIkST1lIJQkSZKknjIQSpIkSVJPGQglSZIkqacMhJIkSZLUUwZCSZIkSeopA6EkSZIk9ZSBUJIkSZJ6ykAoSZIkST1lIJQkSZKknjIQSpIkSVJPGQglSZIkqacMhJIkSZLUUwZCSZIkSeopA6EkSZIk9ZSBUJIkSZJ6ykAoSZIkST1lIJQkSZKknjIQSpIkSVJPGQglSZIkqacMhJIkSZLUUwZCSZIkSeopA6EkSZIk9VSngTDJ+iR7kkwl2TTL8WVJtrTjO5KsHjp2aavvSXL2UP26JPcluaPLsUuSJEnSqOssECYZA64CzgHWAecnWTej2YXAQ1V1GvBe4MrWdx2wETgDWA9c3c4H8CetJkmSJEl6Grq8Q3gmMFVVd1XVo8BmYMOMNhuA69v2VuCsJGn1zVV1sKruBqba+aiqvwUe7HDckiRJktQLXQbClcC9Q/t7W23WNlU1DRwATp5j3yNKclGSySST+/fvf5JDlyRJkqTRN7KLylTVNVU1XlXjK1asWOjhSJIkSdJxp8tAuA84dWh/VavN2ibJEmA58MAc+0qSJEmSnoYuA+FOYG2SNUmWMlgkZmJGmwnggrZ9LnBLVVWrb2yrkK4B1gK3djhWSZIkSeqdzgJh+0zgJcB24E7gxqraleTyJG9tza4FTk4yBfwKsKn13QXcCOwG/gq4uKoOAST5M+AfgdOT7E1yYVfXIEmSJEmjbEmXJ6+qbcC2GbXLhrYfAc47TN8rgCtmqZ9/jIcpSZIkSb00sovKSJIkSZKOzEAoSZIkST1lIJQkSZKknjIQSpIkSVJPGQglSZIkqacMhJIkSZLUUwZCSZIkSeopA6EkSZIk9ZSBUJIkSZJ6ykAoSZIkST1lIJQkSZKknjIQSpIkSVJPGQglSZIkqacMhJIkSZLUUwZCSZIkSeopA6EkSZIk9ZSBUJIkSZJ6ykAoSZIkST1lIJQkSZKknjIQLpC/n7qfL/zzNxZ6GJIkSZJ6bMlCD6BvvnVwmt/8y89zwye/xHOXLeFdb1zL85+9dKGHJUmSJKmHvEM4jw5OH+LHfu/vuOGTXwLgGweneffErgUelSRJkqS+MhDOo2VLxnjLy1/0b2ofu/0rbN/1tQUakSRJkqQ+MxDOs0t++DS+54XP+ze1X//oHTz0rUcXaESSJEmS+qrTQJhkfZI9SaaSbJrl+LIkW9rxHUlWDx27tNX3JDl7ruc83i1d8gx++7zvZckz8njt/m8e5L/76KgkSZKkedbZojJJxoCrgDcBe4GdSSaqavdQswuBh6rqtCQbgSuBtyVZB2wEzgBeBNyc5CWtz9HOedw740XL+YU3rOW9N//T47WJz3yF16w+iZetXP6Uz5vk6I0O1/cp94Sn8WvJ0/rNkiRJ0vHnlOcu5YXLn7XQw5iTLlcZPROYqqq7AJJsBjYAw+FtA/Dutr0V+P0MUs0GYHNVHQTuTjLVzscczrko/PwPfzdbdn6Zrxx45PHaf/sL7xJKkiRJi91/+nffzaZzXrrQw5iTLh8ZXQncO7S/t9VmbVNV08AB4OQj9J3LOReFE8aewY+/ehUnjHmHTJIkSdLCGNnvIUxyEXBR2/1mkj0LOZ7DOAW4f6EHoWPOeR1Nzuvocm5Hk/M6mpzX0TRy83rplXDpQg/iib5ztmKXgXAfcOrQ/qpWm63N3iRLgOXAA0fpe7RzAlBV1wDXPNXBz4ckk1U1vtDj0LHlvI4m53V0ObejyXkdTc7raHJeF1aXj4zuBNYmWZNkKYNFYiZmtJkALmjb5wK3VFW1+sa2CukaYC1w6xzPKUmSJEmag87uEFbVdJJLgO3AGHBdVe1KcjkwWVUTwLXADW3RmAcZBDxauxsZLBYzDVxcVYcAZjtnV9cgSZIkSaMsgxtyWghJLmqPtmqEOK+jyXkdXc7taHJeR5PzOpqc14VlIJQkSZKknuryM4SSJEmSpOOYgXABJFmfZE+SqSSbFno8ml2S65Lcl+SOodoLktyU5Avt50mtniS/2+b0s0leNdTngtb+C0kuGKq/OsnnWp/fTeKXUnYsyalJPpFkd5JdSd7V6s7rIpfkmUluTfKZNre/0eprkuxo87GlLUhGW7RsS6vvSLJ66FyXtvqeJGcP1X3vXiBJxpJ8OsnH277zusgluae9V96eZLLVfC9e5JI8P8nWJJ9PcmeS1zmvi0BV+ZrHF4PFcL4IfBewFPgMsG6hx+Vr1rn6QeBVwB1Dtd8CNrXtTcCVbftHgL8EArwW2NHqLwDuaj9PatsntWO3trZpfc9Z6Gse9RfwQuBVbfu5wD8B65zXxf9q/97PadsnADvaPNwIbGz1PwR+rm3/PPCHbXsjsKVtr2vvy8uANe39esz37gWf318BPgR8vO07r4v8BdwDnDKj5nvxIn8B1wM/3baXAs93Xo//l3cI59+ZwFRV3VVVjwKbgQ0LPCbNoqr+lsHqt8M2MHizo/3890P1D9TAJ4HnJ3khcDZwU1U9WFUPATcB69ux51XVJ2vwDveBoXOpI1X11ar6VNv+BnAnsBLnddFrc/TNtntCexXwBmBrq8+c28fmfCtwVvtL8wZgc1UdrKq7gSkG79u+dy+QJKuAHwXe3/aD8zqqfC9exJIsZ/DH9GsBqurRqvo6zutxz0A4/1YC9w7t7201LQ7fXlVfbdtfA769bR9uXo9U3ztLXfOkPUr2SgZ3kpzXEdAeK7wduI/B/0B8Efh6VU23JsPz8fgctuMHgJN58nOu7v0O8KvAv7b9k3FeR0EBf53ktiQXtZrvxYvbGmA/8MftEe/3JzkR5/W4ZyCUnqL21ymX6V2EkjwH+HPgl6rq4eFjzuviVVWHquoVwCoGd35eusBD0tOU5C3AfVV120KPRcfc66vqVcA5wMVJfnD4oO/Fi9ISBh+1+YOqeiXwLQaPiD7OeT0+GQjn3z7g1KH9Va2mxeGf2yMLtJ/3tfrh5vVI9VWz1NWxJCcwCIMfrKqPtLLzOkLaI0qfAF7H4BGkJe3Q8Hw8Poft+HLgAZ78nKtbPwC8Nck9DB7nfAPwPpzXRa+q9rWf9wEfZfBHHN+LF7e9wN6q2tH2tzIIiM7rcc5AOP92AmvbCmlLGXzofWKBx6S5mwAeW+3qAuAvhurvaCtmvRY40B6P2A68OclJbVWtNwPb27GHk7y2fb7lHUPnUkfav/W1wJ1V9Z6hQ87rIpdkRZLnt+1nAW9i8BnRTwDntmYz5/axOT8XuKX95XoC2JjBapVrgLUMFjHwvXsBVNWlVbWqqlYz+De/pap+Eud1UUtyYpLnPrbN4D30DnwvXtSq6mvAvUlOb6WzgN04r8e/rlar8XX4F4NVlf6Jwedbfn2hx+PrsPP0Z8BXgX9h8FevCxl8FuVvgC8ANwMvaG0DXNXm9HPA+NB5/iODBQymgHcO1ccZ/Afwi8DvA1noax71F/B6Bo+qfBa4vb1+xHld/C/ge4FPt7m9A7is1b+Lwf/4TwEfBpa1+jPb/lQ7/l1D5/r1Nn97GFrBzvfuBZ/jH+L/rzLqvC7iV5u/z7TXrsf+3X0vXvwv4BXAZHsv/hiDVUKd1+P8lfaPK0mSJEnqGR8ZlSRJkqSeMhBKkiRJUk8ZCCVJkiSppwyEkiRJktRTBkJJkiRJ6ikDoSRJHUpyeZI3LvQ4JEmajV87IUlSR5KMVdWhhR6HJEmH4x1CSZKegiSrk3w+yQeT3Jlka5JnJ7knyZVJPgWcl+RPkpzb+rwmyT8k+UySW5M8N8lYkv+ZZGeSzyb52QW+NElSjxgIJUl66k4Hrq6q7wEeBn6+1R+oqldV1ebHGiZZCmwB3lVVLwfeCPxf4ELgQFW9BngN8DNJ1sznRUiS+stAKEnSU3dvVf192/5T4PVte8ssbU8HvlpVOwGq6uGqmgbeDLwjye3ADuBkYG23w5YkaWDJQg9AkqRFbOYH8R/b/9aTOEeAX6iq7cdmSJIkzZ13CCVJeupenPfNhLIAAACzSURBVOR1bfsngL87Qts9wAuTvAagfX5wCbAd+LkkJ7T6S5Kc2OWgJUl6jIFQkqSnbg9wcZI7gZOAPzhcw6p6FHgb8HtJPgPcBDwTeD+wG/hUkjuAP8IneCRJ88SvnZAk6SlIshr4eFW9bIGHIknSU+YdQkmSJEnqKe8QSpIkSVJPeYdQkiRJknrKQChJkiRJPWUglCRJkqSeMhBKkiRJUk8ZCCVJkiSppwyEkiRJktRT/w9l7srjG4VX4AAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 1080x360 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "sns.distplot(train_df.price, bins=500)"
   ]
  }
 ],
 "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.7.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}