datascrum-sales-traffic-describe-sample-v2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import psycopg2\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "from scipy import stats\n",
    "import datetime as dt\n",
    "from datetime import date\n",
    "import statsmodels.api as sm\n",
    "from sklearn import preprocessing\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'user': 'altcap_usr', 'dbname': 'altcap_db', 'host': '167.99.88.131', 'port': '5432', 'tty': '', 'options': '', 'sslmode': 'prefer', 'sslcompression': '0', 'krbsrvname': 'postgres', 'target_session_attrs': 'any'} \n",
      "\n",
      "PostgreSQL connection is closed\n"
     ]
    }
   ],
   "source": [
    "DB_NAME = ''\n",
    "DB_USER = ''\n",
    "DB_PWD = ''\n",
    "DB_HOST = ''\n",
    "DB_PORT = ''\n",
    "\n",
    "try:\n",
    "    connection = psycopg2.connect(user = DB_USER,\n",
    "                                  password = DB_PWD,\n",
    "                                  host = DB_PWD ,\n",
    "                                  port = DB_PORT,\n",
    "                                  database = DB_NAME)\n",
    "    cursor = connection.cursor()\n",
    "    print ( connection.get_dsn_parameters(),\"\\n\")\n",
    "    record_traffic = pd.read_sql(\"SELECT * FROM trafficdata;\",connection)\n",
    "    record_eod = pd.read_sql(\"SELECT * FROM eodhistoricaldata;\",connection)\n",
    "    record_sales = pd.read_sql(\"SELECT * FROM salesestimate;\",connection)\n",
    "    \n",
    "except (Exception, psycopg2.Error) as error :\n",
    "    print (\"Error while connecting to PostgreSQL\", error)\n",
    "    \n",
    "finally:\n",
    "    #closing database connection.\n",
    "        if(connection):\n",
    "            cursor.close()\n",
    "            connection.close()\n",
    "            print(\"PostgreSQL connection is closed\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>open</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>close</th>\n",
       "      <th>adjusted_close</th>\n",
       "      <th>volume</th>\n",
       "      <th>company_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>8383</td>\n",
       "      <td>2001-10-04</td>\n",
       "      <td>24.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>11000.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>8384</td>\n",
       "      <td>2001-10-05</td>\n",
       "      <td>25.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>37930.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>8385</td>\n",
       "      <td>2001-10-08</td>\n",
       "      <td>25.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>8386</td>\n",
       "      <td>2001-10-12</td>\n",
       "      <td>24.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>8387</td>\n",
       "      <td>2001-10-17</td>\n",
       "      <td>24.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>52174.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     id        date  open  high   low  close  adjusted_close   volume  \\\n",
       "0  8383  2001-10-04  24.0  24.0  24.0   24.0            24.0  11000.0   \n",
       "1  8384  2001-10-05  25.0  25.0  23.0   24.0            24.0  37930.0   \n",
       "2  8385  2001-10-08  25.0  25.0  24.0   24.0            24.0  10000.0   \n",
       "3  8386  2001-10-12  24.0  24.0  24.0   24.0            24.0  10000.0   \n",
       "4  8387  2001-10-17  24.0  25.0  23.0   24.0            24.0  52174.0   \n",
       "\n",
       "   company_id  \n",
       "0           1  \n",
       "1           1  \n",
       "2           1  \n",
       "3           1  \n",
       "4           1  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "record_traffic.date = record_traffic.date.map(lambda x: x.strftime('%Y-%m-%d'))\n",
    "record_eod.date = record_eod.date.map(lambda x: x.strftime('%Y-%m-%d'))\n",
    "record_sales.date = record_sales.date.map(lambda x: x.strftime('%Y-%m-%d'))\n",
    "record_eod.head()\n",
    "# record_traffic.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id_x</th>\n",
       "      <th>date</th>\n",
       "      <th>traffic</th>\n",
       "      <th>paid_traffic</th>\n",
       "      <th>company_id</th>\n",
       "      <th>period</th>\n",
       "      <th>source_id_x</th>\n",
       "      <th>id_y</th>\n",
       "      <th>analysis_estimates</th>\n",
       "      <th>analysis_high</th>\n",
       "      <th>analysis_low</th>\n",
       "      <th>analysis_mean</th>\n",
       "      <th>analysis_year_ago</th>\n",
       "      <th>trend_2month_ago</th>\n",
       "      <th>trend_current</th>\n",
       "      <th>trend_month_ago</th>\n",
       "      <th>trend_week_ago</th>\n",
       "      <th>trend_year_ago</th>\n",
       "      <th>source_id_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>613</td>\n",
       "      <td>2019-03-15</td>\n",
       "      <td>11575</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>23</td>\n",
       "      <td>2.842580e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.789720e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>2.813970e+09</td>\n",
       "      <td>2.789720e+09</td>\n",
       "      <td>2.802240e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>615</td>\n",
       "      <td>2019-03-17</td>\n",
       "      <td>7820</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>17</td>\n",
       "      <td>23</td>\n",
       "      <td>2.842580e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.789720e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>2.813970e+09</td>\n",
       "      <td>2.789720e+09</td>\n",
       "      <td>2.802240e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>498</td>\n",
       "      <td>2019-03-14</td>\n",
       "      <td>11575</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>14</td>\n",
       "      <td>23</td>\n",
       "      <td>2.823000e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.787440e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>2.813970e+09</td>\n",
       "      <td>2.787440e+09</td>\n",
       "      <td>2.803580e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>500</td>\n",
       "      <td>2019-03-04</td>\n",
       "      <td>9087</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>23</td>\n",
       "      <td>2.823000e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>2.824190e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>2.803710e+09</td>\n",
       "      <td>2.793790e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>501</td>\n",
       "      <td>2019-03-03</td>\n",
       "      <td>4674</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>23</td>\n",
       "      <td>2.823000e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>2.824190e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>2.804110e+09</td>\n",
       "      <td>2.793790e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>502</td>\n",
       "      <td>2019-03-02</td>\n",
       "      <td>5785</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>23</td>\n",
       "      <td>2.823000e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>2.824190e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>2.803710e+09</td>\n",
       "      <td>2.793790e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>503</td>\n",
       "      <td>2019-03-01</td>\n",
       "      <td>10687</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>2.823000e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>2.824190e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>2.803710e+09</td>\n",
       "      <td>2.793790e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>510</td>\n",
       "      <td>2019-03-12</td>\n",
       "      <td>5559</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>23</td>\n",
       "      <td>2.823000e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>2.822500e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>2.803580e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>521</td>\n",
       "      <td>2019-03-11</td>\n",
       "      <td>5821</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>11</td>\n",
       "      <td>23</td>\n",
       "      <td>2.823000e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>2.822500e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>2.803580e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>522</td>\n",
       "      <td>2019-03-10</td>\n",
       "      <td>5702</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>10</td>\n",
       "      <td>23</td>\n",
       "      <td>2.823000e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>2.822500e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>2.803580e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>523</td>\n",
       "      <td>2019-03-09</td>\n",
       "      <td>4804</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>23</td>\n",
       "      <td>2.823000e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>2.824730e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>2.803580e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>524</td>\n",
       "      <td>2019-03-08</td>\n",
       "      <td>4968</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>8</td>\n",
       "      <td>23</td>\n",
       "      <td>2.823000e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>2.824730e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>2.803580e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>525</td>\n",
       "      <td>2019-03-07</td>\n",
       "      <td>5021</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>23</td>\n",
       "      <td>2.823000e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>2.824730e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>2.803580e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>526</td>\n",
       "      <td>2019-03-06</td>\n",
       "      <td>5490</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>23</td>\n",
       "      <td>2.823000e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>2.824730e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>2.803580e+09</td>\n",
       "      <td>2.793790e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>527</td>\n",
       "      <td>2019-03-05</td>\n",
       "      <td>9092</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>23</td>\n",
       "      <td>2.823000e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>2.824190e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>2.804110e+09</td>\n",
       "      <td>2.793790e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>614</td>\n",
       "      <td>2019-03-16</td>\n",
       "      <td>12302</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "      <td>23</td>\n",
       "      <td>2.842580e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.789720e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>2.813970e+09</td>\n",
       "      <td>2.789720e+09</td>\n",
       "      <td>2.802240e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>732</td>\n",
       "      <td>2019-03-18</td>\n",
       "      <td>7818</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>18</td>\n",
       "      <td>23</td>\n",
       "      <td>2.842580e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.789720e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>2.813970e+09</td>\n",
       "      <td>2.789720e+09</td>\n",
       "      <td>2.802240e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>499</td>\n",
       "      <td>2019-03-13</td>\n",
       "      <td>12305</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>13</td>\n",
       "      <td>23</td>\n",
       "      <td>2.823000e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.787440e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>2.813970e+09</td>\n",
       "      <td>2.787440e+09</td>\n",
       "      <td>2.803580e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1073</td>\n",
       "      <td>2019-03-20</td>\n",
       "      <td>6908</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>20</td>\n",
       "      <td>23</td>\n",
       "      <td>2.842580e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.789720e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>2.813970e+09</td>\n",
       "      <td>2.789720e+09</td>\n",
       "      <td>2.793790e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1074</td>\n",
       "      <td>2019-03-19</td>\n",
       "      <td>7200</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>19</td>\n",
       "      <td>23</td>\n",
       "      <td>2.842580e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.789720e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>2.813970e+09</td>\n",
       "      <td>2.789720e+09</td>\n",
       "      <td>2.802240e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1100</td>\n",
       "      <td>2019-03-20</td>\n",
       "      <td>8979</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.179700e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.325000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.179700e+08</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1256</td>\n",
       "      <td>2019-03-20</td>\n",
       "      <td>74761</td>\n",
       "      <td>421</td>\n",
       "      <td>11</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>22</td>\n",
       "      <td>3</td>\n",
       "      <td>1.102000e+08</td>\n",
       "      <td>1.100000e+08</td>\n",
       "      <td>1.100700e+08</td>\n",
       "      <td>1.031000e+08</td>\n",
       "      <td>1.100700e+08</td>\n",
       "      <td>1.100700e+08</td>\n",
       "      <td>1.100700e+08</td>\n",
       "      <td>1.100700e+08</td>\n",
       "      <td>1.031000e+08</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1902</td>\n",
       "      <td>2019-03-26</td>\n",
       "      <td>17758</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>32</td>\n",
       "      <td>24</td>\n",
       "      <td>2.823000e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.783660e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>2.813970e+09</td>\n",
       "      <td>2.783660e+09</td>\n",
       "      <td>2.793790e+09</td>\n",
       "      <td>2.789720e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1904</td>\n",
       "      <td>2019-03-26</td>\n",
       "      <td>11128</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>33</td>\n",
       "      <td>1</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.179700e+08</td>\n",
       "      <td>1.325000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.325000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.179700e+08</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1906</td>\n",
       "      <td>2019-03-26</td>\n",
       "      <td>57618</td>\n",
       "      <td>426</td>\n",
       "      <td>11</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>34</td>\n",
       "      <td>3</td>\n",
       "      <td>1.102000e+08</td>\n",
       "      <td>1.100000e+08</td>\n",
       "      <td>1.100700e+08</td>\n",
       "      <td>1.031000e+08</td>\n",
       "      <td>1.100700e+08</td>\n",
       "      <td>1.100700e+08</td>\n",
       "      <td>1.100700e+08</td>\n",
       "      <td>1.100700e+08</td>\n",
       "      <td>1.031000e+08</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2023</td>\n",
       "      <td>2019-03-27</td>\n",
       "      <td>17815</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>35</td>\n",
       "      <td>24</td>\n",
       "      <td>2.823000e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.783660e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>2.803710e+09</td>\n",
       "      <td>2.783660e+09</td>\n",
       "      <td>2.793790e+09</td>\n",
       "      <td>2.789720e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2025</td>\n",
       "      <td>2019-03-27</td>\n",
       "      <td>10205</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>36</td>\n",
       "      <td>1</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.179700e+08</td>\n",
       "      <td>1.325000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.325000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.179700e+08</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2027</td>\n",
       "      <td>2019-03-27</td>\n",
       "      <td>58648</td>\n",
       "      <td>426</td>\n",
       "      <td>11</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>37</td>\n",
       "      <td>3</td>\n",
       "      <td>1.102000e+08</td>\n",
       "      <td>1.100000e+08</td>\n",
       "      <td>1.100700e+08</td>\n",
       "      <td>1.031000e+08</td>\n",
       "      <td>1.100700e+08</td>\n",
       "      <td>1.100700e+08</td>\n",
       "      <td>1.100700e+08</td>\n",
       "      <td>1.100700e+08</td>\n",
       "      <td>1.031000e+08</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2029</td>\n",
       "      <td>2019-03-28</td>\n",
       "      <td>8158</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>38</td>\n",
       "      <td>24</td>\n",
       "      <td>2.823000e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>2.783660e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>2.803710e+09</td>\n",
       "      <td>2.783660e+09</td>\n",
       "      <td>2.793790e+09</td>\n",
       "      <td>2.789720e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2031</td>\n",
       "      <td>2019-03-28</td>\n",
       "      <td>8442</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>39</td>\n",
       "      <td>1</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.179700e+08</td>\n",
       "      <td>1.325000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.325000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.179700e+08</td>\n",
       "      <td>3</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>380</th>\n",
       "      <td>3990</td>\n",
       "      <td>2019-05-09</td>\n",
       "      <td>11730</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>324</td>\n",
       "      <td>1</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.180000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.320000e+08</td>\n",
       "      <td>1.180000e+08</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>381</th>\n",
       "      <td>4090</td>\n",
       "      <td>2019-05-10</td>\n",
       "      <td>194699</td>\n",
       "      <td>279</td>\n",
       "      <td>14</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>341</td>\n",
       "      <td>11</td>\n",
       "      <td>9.797000e+09</td>\n",
       "      <td>8.985000e+09</td>\n",
       "      <td>9.457150e+09</td>\n",
       "      <td>9.677760e+09</td>\n",
       "      <td>9.457150e+09</td>\n",
       "      <td>9.457150e+09</td>\n",
       "      <td>9.457150e+09</td>\n",
       "      <td>9.457150e+09</td>\n",
       "      <td>9.677760e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>382</th>\n",
       "      <td>4208</td>\n",
       "      <td>2019-05-12</td>\n",
       "      <td>191500000</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>373</td>\n",
       "      <td>13</td>\n",
       "      <td>1.892000e+08</td>\n",
       "      <td>1.798000e+08</td>\n",
       "      <td>1.835100e+08</td>\n",
       "      <td>1.482600e+08</td>\n",
       "      <td>1.837100e+08</td>\n",
       "      <td>1.835100e+08</td>\n",
       "      <td>1.837500e+08</td>\n",
       "      <td>1.837500e+08</td>\n",
       "      <td>1.482600e+08</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>383</th>\n",
       "      <td>4209</td>\n",
       "      <td>2019-05-12</td>\n",
       "      <td>7430000</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>374</td>\n",
       "      <td>20</td>\n",
       "      <td>1.001400e+10</td>\n",
       "      <td>9.715000e+09</td>\n",
       "      <td>9.888310e+09</td>\n",
       "      <td>9.490240e+09</td>\n",
       "      <td>9.900330e+09</td>\n",
       "      <td>9.888310e+09</td>\n",
       "      <td>9.896750e+09</td>\n",
       "      <td>9.897160e+09</td>\n",
       "      <td>9.490240e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>384</th>\n",
       "      <td>4211</td>\n",
       "      <td>2019-05-12</td>\n",
       "      <td>20910000</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>375</td>\n",
       "      <td>19</td>\n",
       "      <td>1.053100e+10</td>\n",
       "      <td>1.026560e+10</td>\n",
       "      <td>1.038760e+10</td>\n",
       "      <td>1.090290e+10</td>\n",
       "      <td>1.038910e+10</td>\n",
       "      <td>1.038760e+10</td>\n",
       "      <td>1.038860e+10</td>\n",
       "      <td>1.038760e+10</td>\n",
       "      <td>1.090290e+10</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>385</th>\n",
       "      <td>4213</td>\n",
       "      <td>2019-05-12</td>\n",
       "      <td>13900000</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>376</td>\n",
       "      <td>18</td>\n",
       "      <td>1.031200e+09</td>\n",
       "      <td>9.832000e+08</td>\n",
       "      <td>1.008300e+09</td>\n",
       "      <td>9.545000e+08</td>\n",
       "      <td>1.009500e+09</td>\n",
       "      <td>1.008300e+09</td>\n",
       "      <td>1.009600e+09</td>\n",
       "      <td>1.009600e+09</td>\n",
       "      <td>9.545000e+08</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>386</th>\n",
       "      <td>4215</td>\n",
       "      <td>2019-05-12</td>\n",
       "      <td>157560000</td>\n",
       "      <td>0</td>\n",
       "      <td>26</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>363</td>\n",
       "      <td>24</td>\n",
       "      <td>3.191900e+10</td>\n",
       "      <td>3.038680e+10</td>\n",
       "      <td>3.107640e+10</td>\n",
       "      <td>3.126530e+10</td>\n",
       "      <td>3.106340e+10</td>\n",
       "      <td>3.107640e+10</td>\n",
       "      <td>3.106980e+10</td>\n",
       "      <td>3.107740e+10</td>\n",
       "      <td>3.126530e+10</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>387</th>\n",
       "      <td>4216</td>\n",
       "      <td>2019-05-12</td>\n",
       "      <td>28690000</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>365</td>\n",
       "      <td>15</td>\n",
       "      <td>4.266000e+09</td>\n",
       "      <td>4.005000e+09</td>\n",
       "      <td>4.108190e+09</td>\n",
       "      <td>4.042300e+09</td>\n",
       "      <td>4.125070e+09</td>\n",
       "      <td>4.108190e+09</td>\n",
       "      <td>4.118390e+09</td>\n",
       "      <td>4.118390e+09</td>\n",
       "      <td>4.042300e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>388</th>\n",
       "      <td>4220</td>\n",
       "      <td>2019-05-13</td>\n",
       "      <td>4580000</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>382</td>\n",
       "      <td>11</td>\n",
       "      <td>9.797000e+09</td>\n",
       "      <td>8.985000e+09</td>\n",
       "      <td>9.457150e+09</td>\n",
       "      <td>9.677760e+09</td>\n",
       "      <td>9.457150e+09</td>\n",
       "      <td>9.457150e+09</td>\n",
       "      <td>9.457150e+09</td>\n",
       "      <td>9.457150e+09</td>\n",
       "      <td>9.677760e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>389</th>\n",
       "      <td>4222</td>\n",
       "      <td>2019-05-13</td>\n",
       "      <td>69020</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>384</td>\n",
       "      <td>25</td>\n",
       "      <td>2.808430e+09</td>\n",
       "      <td>2.752400e+09</td>\n",
       "      <td>2.783150e+09</td>\n",
       "      <td>3.051220e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>2.783150e+09</td>\n",
       "      <td>2.783000e+09</td>\n",
       "      <td>2.783150e+09</td>\n",
       "      <td>3.051220e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>390</th>\n",
       "      <td>4223</td>\n",
       "      <td>2019-05-13</td>\n",
       "      <td>5230000</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>385</td>\n",
       "      <td>13</td>\n",
       "      <td>1.832000e+09</td>\n",
       "      <td>1.622620e+09</td>\n",
       "      <td>1.763250e+09</td>\n",
       "      <td>1.836210e+09</td>\n",
       "      <td>1.795910e+09</td>\n",
       "      <td>1.763250e+09</td>\n",
       "      <td>1.799960e+09</td>\n",
       "      <td>1.768930e+09</td>\n",
       "      <td>1.836210e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>391</th>\n",
       "      <td>4226</td>\n",
       "      <td>2019-05-13</td>\n",
       "      <td>20990000</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>386</td>\n",
       "      <td>4</td>\n",
       "      <td>2.618000e+08</td>\n",
       "      <td>2.495000e+08</td>\n",
       "      <td>2.553600e+08</td>\n",
       "      <td>2.414000e+08</td>\n",
       "      <td>2.618900e+08</td>\n",
       "      <td>2.553600e+08</td>\n",
       "      <td>2.583800e+08</td>\n",
       "      <td>2.553600e+08</td>\n",
       "      <td>2.414000e+08</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>392</th>\n",
       "      <td>4229</td>\n",
       "      <td>2019-05-13</td>\n",
       "      <td>191500000</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>387</td>\n",
       "      <td>13</td>\n",
       "      <td>1.892000e+08</td>\n",
       "      <td>1.798000e+08</td>\n",
       "      <td>1.835100e+08</td>\n",
       "      <td>1.482600e+08</td>\n",
       "      <td>1.837100e+08</td>\n",
       "      <td>1.835100e+08</td>\n",
       "      <td>1.837500e+08</td>\n",
       "      <td>1.837500e+08</td>\n",
       "      <td>1.482600e+08</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>393</th>\n",
       "      <td>4230</td>\n",
       "      <td>2019-05-13</td>\n",
       "      <td>7430000</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>388</td>\n",
       "      <td>20</td>\n",
       "      <td>1.001400e+10</td>\n",
       "      <td>9.715000e+09</td>\n",
       "      <td>9.888310e+09</td>\n",
       "      <td>9.490240e+09</td>\n",
       "      <td>9.900330e+09</td>\n",
       "      <td>9.888310e+09</td>\n",
       "      <td>9.896750e+09</td>\n",
       "      <td>9.897160e+09</td>\n",
       "      <td>9.490240e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>394</th>\n",
       "      <td>4232</td>\n",
       "      <td>2019-05-13</td>\n",
       "      <td>20910000</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>389</td>\n",
       "      <td>19</td>\n",
       "      <td>1.053100e+10</td>\n",
       "      <td>1.026560e+10</td>\n",
       "      <td>1.038760e+10</td>\n",
       "      <td>1.090290e+10</td>\n",
       "      <td>1.038910e+10</td>\n",
       "      <td>1.038760e+10</td>\n",
       "      <td>1.038860e+10</td>\n",
       "      <td>1.038760e+10</td>\n",
       "      <td>1.090290e+10</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>395</th>\n",
       "      <td>4234</td>\n",
       "      <td>2019-05-13</td>\n",
       "      <td>13900000</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>390</td>\n",
       "      <td>18</td>\n",
       "      <td>1.031200e+09</td>\n",
       "      <td>9.832000e+08</td>\n",
       "      <td>1.008300e+09</td>\n",
       "      <td>9.545000e+08</td>\n",
       "      <td>1.009500e+09</td>\n",
       "      <td>1.008300e+09</td>\n",
       "      <td>1.009600e+09</td>\n",
       "      <td>1.009600e+09</td>\n",
       "      <td>9.545000e+08</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>396</th>\n",
       "      <td>4236</td>\n",
       "      <td>2019-05-13</td>\n",
       "      <td>157560000</td>\n",
       "      <td>0</td>\n",
       "      <td>26</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>377</td>\n",
       "      <td>24</td>\n",
       "      <td>3.191900e+10</td>\n",
       "      <td>3.038680e+10</td>\n",
       "      <td>3.107640e+10</td>\n",
       "      <td>3.126530e+10</td>\n",
       "      <td>3.106340e+10</td>\n",
       "      <td>3.107640e+10</td>\n",
       "      <td>3.106980e+10</td>\n",
       "      <td>3.107740e+10</td>\n",
       "      <td>3.126530e+10</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>397</th>\n",
       "      <td>4237</td>\n",
       "      <td>2019-05-13</td>\n",
       "      <td>28690000</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>379</td>\n",
       "      <td>15</td>\n",
       "      <td>4.266000e+09</td>\n",
       "      <td>4.005000e+09</td>\n",
       "      <td>4.108190e+09</td>\n",
       "      <td>4.042300e+09</td>\n",
       "      <td>4.125070e+09</td>\n",
       "      <td>4.108190e+09</td>\n",
       "      <td>4.118390e+09</td>\n",
       "      <td>4.118390e+09</td>\n",
       "      <td>4.042300e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>398</th>\n",
       "      <td>4242</td>\n",
       "      <td>2019-05-14</td>\n",
       "      <td>69020</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>398</td>\n",
       "      <td>25</td>\n",
       "      <td>2.808430e+09</td>\n",
       "      <td>2.752400e+09</td>\n",
       "      <td>2.783150e+09</td>\n",
       "      <td>3.051220e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>2.783150e+09</td>\n",
       "      <td>2.783000e+09</td>\n",
       "      <td>2.783150e+09</td>\n",
       "      <td>3.051220e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>399</th>\n",
       "      <td>4243</td>\n",
       "      <td>2019-05-14</td>\n",
       "      <td>5230000</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>399</td>\n",
       "      <td>13</td>\n",
       "      <td>1.832000e+09</td>\n",
       "      <td>1.622620e+09</td>\n",
       "      <td>1.763250e+09</td>\n",
       "      <td>1.836210e+09</td>\n",
       "      <td>1.795910e+09</td>\n",
       "      <td>1.763250e+09</td>\n",
       "      <td>1.799960e+09</td>\n",
       "      <td>1.768930e+09</td>\n",
       "      <td>1.836210e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>400</th>\n",
       "      <td>4246</td>\n",
       "      <td>2019-05-14</td>\n",
       "      <td>20990000</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>400</td>\n",
       "      <td>4</td>\n",
       "      <td>2.618000e+08</td>\n",
       "      <td>2.495000e+08</td>\n",
       "      <td>2.553600e+08</td>\n",
       "      <td>2.414000e+08</td>\n",
       "      <td>2.618900e+08</td>\n",
       "      <td>2.553600e+08</td>\n",
       "      <td>2.583800e+08</td>\n",
       "      <td>2.553600e+08</td>\n",
       "      <td>2.414000e+08</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>401</th>\n",
       "      <td>4249</td>\n",
       "      <td>2019-05-14</td>\n",
       "      <td>191500000</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>401</td>\n",
       "      <td>13</td>\n",
       "      <td>1.892000e+08</td>\n",
       "      <td>1.798000e+08</td>\n",
       "      <td>1.835100e+08</td>\n",
       "      <td>1.482600e+08</td>\n",
       "      <td>1.837100e+08</td>\n",
       "      <td>1.835100e+08</td>\n",
       "      <td>1.837500e+08</td>\n",
       "      <td>1.837500e+08</td>\n",
       "      <td>1.482600e+08</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>402</th>\n",
       "      <td>4250</td>\n",
       "      <td>2019-05-14</td>\n",
       "      <td>7430000</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>402</td>\n",
       "      <td>20</td>\n",
       "      <td>1.001400e+10</td>\n",
       "      <td>9.715000e+09</td>\n",
       "      <td>9.888310e+09</td>\n",
       "      <td>9.490240e+09</td>\n",
       "      <td>9.900330e+09</td>\n",
       "      <td>9.888310e+09</td>\n",
       "      <td>9.896750e+09</td>\n",
       "      <td>9.897160e+09</td>\n",
       "      <td>9.490240e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>403</th>\n",
       "      <td>4252</td>\n",
       "      <td>2019-05-14</td>\n",
       "      <td>20910000</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>403</td>\n",
       "      <td>19</td>\n",
       "      <td>1.053100e+10</td>\n",
       "      <td>1.026560e+10</td>\n",
       "      <td>1.038760e+10</td>\n",
       "      <td>1.090290e+10</td>\n",
       "      <td>1.038910e+10</td>\n",
       "      <td>1.038760e+10</td>\n",
       "      <td>1.038860e+10</td>\n",
       "      <td>1.038760e+10</td>\n",
       "      <td>1.090290e+10</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>404</th>\n",
       "      <td>4254</td>\n",
       "      <td>2019-05-14</td>\n",
       "      <td>13900000</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>404</td>\n",
       "      <td>18</td>\n",
       "      <td>1.031200e+09</td>\n",
       "      <td>9.832000e+08</td>\n",
       "      <td>1.008300e+09</td>\n",
       "      <td>9.545000e+08</td>\n",
       "      <td>1.009500e+09</td>\n",
       "      <td>1.008300e+09</td>\n",
       "      <td>1.009600e+09</td>\n",
       "      <td>1.009600e+09</td>\n",
       "      <td>9.545000e+08</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>405</th>\n",
       "      <td>4256</td>\n",
       "      <td>2019-05-14</td>\n",
       "      <td>157560000</td>\n",
       "      <td>0</td>\n",
       "      <td>26</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>391</td>\n",
       "      <td>24</td>\n",
       "      <td>3.191900e+10</td>\n",
       "      <td>3.038680e+10</td>\n",
       "      <td>3.107640e+10</td>\n",
       "      <td>3.126530e+10</td>\n",
       "      <td>3.106340e+10</td>\n",
       "      <td>3.107640e+10</td>\n",
       "      <td>3.106980e+10</td>\n",
       "      <td>3.107740e+10</td>\n",
       "      <td>3.126530e+10</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>406</th>\n",
       "      <td>4257</td>\n",
       "      <td>2019-05-14</td>\n",
       "      <td>28690000</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>393</td>\n",
       "      <td>15</td>\n",
       "      <td>4.266000e+09</td>\n",
       "      <td>4.005000e+09</td>\n",
       "      <td>4.108190e+09</td>\n",
       "      <td>4.042300e+09</td>\n",
       "      <td>4.125070e+09</td>\n",
       "      <td>4.108190e+09</td>\n",
       "      <td>4.118390e+09</td>\n",
       "      <td>4.118390e+09</td>\n",
       "      <td>4.042300e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>407</th>\n",
       "      <td>4261</td>\n",
       "      <td>2019-05-15</td>\n",
       "      <td>4580000</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>410</td>\n",
       "      <td>11</td>\n",
       "      <td>9.797000e+09</td>\n",
       "      <td>8.985000e+09</td>\n",
       "      <td>9.457150e+09</td>\n",
       "      <td>9.677760e+09</td>\n",
       "      <td>9.457150e+09</td>\n",
       "      <td>9.457150e+09</td>\n",
       "      <td>9.457150e+09</td>\n",
       "      <td>9.457150e+09</td>\n",
       "      <td>9.677760e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>408</th>\n",
       "      <td>4263</td>\n",
       "      <td>2019-05-15</td>\n",
       "      <td>69020</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>412</td>\n",
       "      <td>25</td>\n",
       "      <td>2.808430e+09</td>\n",
       "      <td>2.752400e+09</td>\n",
       "      <td>2.783150e+09</td>\n",
       "      <td>3.051220e+09</td>\n",
       "      <td>2.789720e+09</td>\n",
       "      <td>2.783150e+09</td>\n",
       "      <td>2.783250e+09</td>\n",
       "      <td>2.783150e+09</td>\n",
       "      <td>3.051220e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>409</th>\n",
       "      <td>4264</td>\n",
       "      <td>2019-05-15</td>\n",
       "      <td>5230000</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>daily</td>\n",
       "      <td>1</td>\n",
       "      <td>413</td>\n",
       "      <td>13</td>\n",
       "      <td>1.832000e+09</td>\n",
       "      <td>1.622620e+09</td>\n",
       "      <td>1.763250e+09</td>\n",
       "      <td>1.836210e+09</td>\n",
       "      <td>1.794560e+09</td>\n",
       "      <td>1.763250e+09</td>\n",
       "      <td>1.789600e+09</td>\n",
       "      <td>1.768930e+09</td>\n",
       "      <td>1.836210e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>410 rows × 19 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     id_x        date    traffic  paid_traffic  company_id period  \\\n",
       "0     613  2019-03-15      11575             0           1  daily   \n",
       "1     615  2019-03-17       7820             0           1  daily   \n",
       "2     498  2019-03-14      11575             0           1  daily   \n",
       "3     500  2019-03-04       9087             0           1  daily   \n",
       "4     501  2019-03-03       4674             0           1  daily   \n",
       "5     502  2019-03-02       5785             0           1  daily   \n",
       "6     503  2019-03-01      10687             0           1  daily   \n",
       "7     510  2019-03-12       5559             0           1  daily   \n",
       "8     521  2019-03-11       5821             0           1  daily   \n",
       "9     522  2019-03-10       5702             0           1  daily   \n",
       "10    523  2019-03-09       4804             0           1  daily   \n",
       "11    524  2019-03-08       4968             0           1  daily   \n",
       "12    525  2019-03-07       5021             0           1  daily   \n",
       "13    526  2019-03-06       5490             0           1  daily   \n",
       "14    527  2019-03-05       9092             0           1  daily   \n",
       "15    614  2019-03-16      12302             0           1  daily   \n",
       "16    732  2019-03-18       7818             0           1  daily   \n",
       "17    499  2019-03-13      12305             0           1  daily   \n",
       "18   1073  2019-03-20       6908             0           1  daily   \n",
       "19   1074  2019-03-19       7200             0           1  daily   \n",
       "20   1100  2019-03-20       8979             0           9  daily   \n",
       "21   1256  2019-03-20      74761           421          11  daily   \n",
       "22   1902  2019-03-26      17758             0           1  daily   \n",
       "23   1904  2019-03-26      11128             0           9  daily   \n",
       "24   1906  2019-03-26      57618           426          11  daily   \n",
       "25   2023  2019-03-27      17815             0           1  daily   \n",
       "26   2025  2019-03-27      10205             0           9  daily   \n",
       "27   2027  2019-03-27      58648           426          11  daily   \n",
       "28   2029  2019-03-28       8158             0           1  daily   \n",
       "29   2031  2019-03-28       8442             0           9  daily   \n",
       "..    ...         ...        ...           ...         ...    ...   \n",
       "380  3990  2019-05-09      11730             0           9  daily   \n",
       "381  4090  2019-05-10     194699           279          14  daily   \n",
       "382  4208  2019-05-12  191500000             0          19  daily   \n",
       "383  4209  2019-05-12    7430000             0          20  daily   \n",
       "384  4211  2019-05-12   20910000             0          22  daily   \n",
       "385  4213  2019-05-12   13900000             0          24  daily   \n",
       "386  4215  2019-05-12  157560000             0          26  daily   \n",
       "387  4216  2019-05-12   28690000             0          27  daily   \n",
       "388  4220  2019-05-13    4580000             0          14  daily   \n",
       "389  4222  2019-05-13      69020             0           1  daily   \n",
       "390  4223  2019-05-13    5230000             0          13  daily   \n",
       "391  4226  2019-05-13   20990000             0          16  daily   \n",
       "392  4229  2019-05-13  191500000             0          19  daily   \n",
       "393  4230  2019-05-13    7430000             0          20  daily   \n",
       "394  4232  2019-05-13   20910000             0          22  daily   \n",
       "395  4234  2019-05-13   13900000             0          24  daily   \n",
       "396  4236  2019-05-13  157560000             0          26  daily   \n",
       "397  4237  2019-05-13   28690000             0          27  daily   \n",
       "398  4242  2019-05-14      69020             0           1  daily   \n",
       "399  4243  2019-05-14    5230000             0          13  daily   \n",
       "400  4246  2019-05-14   20990000             0          16  daily   \n",
       "401  4249  2019-05-14  191500000             0          19  daily   \n",
       "402  4250  2019-05-14    7430000             0          20  daily   \n",
       "403  4252  2019-05-14   20910000             0          22  daily   \n",
       "404  4254  2019-05-14   13900000             0          24  daily   \n",
       "405  4256  2019-05-14  157560000             0          26  daily   \n",
       "406  4257  2019-05-14   28690000             0          27  daily   \n",
       "407  4261  2019-05-15    4580000             0          14  daily   \n",
       "408  4263  2019-05-15      69020             0           1  daily   \n",
       "409  4264  2019-05-15    5230000             0          13  daily   \n",
       "\n",
       "     source_id_x  id_y  analysis_estimates  analysis_high  analysis_low  \\\n",
       "0              2    15                  23   2.842580e+09  2.749000e+09   \n",
       "1              2    17                  23   2.842580e+09  2.749000e+09   \n",
       "2              2    14                  23   2.823000e+09  2.749000e+09   \n",
       "3              2     4                  23   2.823000e+09  2.749000e+09   \n",
       "4              2     3                  23   2.823000e+09  2.749000e+09   \n",
       "5              2     2                  23   2.823000e+09  2.749000e+09   \n",
       "6              2     1                  23   2.823000e+09  2.749000e+09   \n",
       "7              2    12                  23   2.823000e+09  2.749000e+09   \n",
       "8              2    11                  23   2.823000e+09  2.749000e+09   \n",
       "9              2    10                  23   2.823000e+09  2.749000e+09   \n",
       "10             2     9                  23   2.823000e+09  2.749000e+09   \n",
       "11             2     8                  23   2.823000e+09  2.749000e+09   \n",
       "12             2     7                  23   2.823000e+09  2.749000e+09   \n",
       "13             2     6                  23   2.823000e+09  2.749000e+09   \n",
       "14             2     5                  23   2.823000e+09  2.749000e+09   \n",
       "15             2    16                  23   2.842580e+09  2.749000e+09   \n",
       "16             2    18                  23   2.842580e+09  2.749000e+09   \n",
       "17             2    13                  23   2.823000e+09  2.749000e+09   \n",
       "18             2    20                  23   2.842580e+09  2.749000e+09   \n",
       "19             2    19                  23   2.842580e+09  2.749000e+09   \n",
       "20             2    21                   1   1.320000e+08  1.320000e+08   \n",
       "21             2    22                   3   1.102000e+08  1.100000e+08   \n",
       "22             2    32                  24   2.823000e+09  2.749000e+09   \n",
       "23             2    33                   1   1.320000e+08  1.320000e+08   \n",
       "24             2    34                   3   1.102000e+08  1.100000e+08   \n",
       "25             2    35                  24   2.823000e+09  2.749000e+09   \n",
       "26             2    36                   1   1.320000e+08  1.320000e+08   \n",
       "27             2    37                   3   1.102000e+08  1.100000e+08   \n",
       "28             2    38                  24   2.823000e+09  2.749000e+09   \n",
       "29             2    39                   1   1.320000e+08  1.320000e+08   \n",
       "..           ...   ...                 ...            ...           ...   \n",
       "380            2   324                   1   1.320000e+08  1.320000e+08   \n",
       "381            2   341                  11   9.797000e+09  8.985000e+09   \n",
       "382            1   373                  13   1.892000e+08  1.798000e+08   \n",
       "383            1   374                  20   1.001400e+10  9.715000e+09   \n",
       "384            1   375                  19   1.053100e+10  1.026560e+10   \n",
       "385            1   376                  18   1.031200e+09  9.832000e+08   \n",
       "386            1   363                  24   3.191900e+10  3.038680e+10   \n",
       "387            1   365                  15   4.266000e+09  4.005000e+09   \n",
       "388            1   382                  11   9.797000e+09  8.985000e+09   \n",
       "389            1   384                  25   2.808430e+09  2.752400e+09   \n",
       "390            1   385                  13   1.832000e+09  1.622620e+09   \n",
       "391            1   386                   4   2.618000e+08  2.495000e+08   \n",
       "392            1   387                  13   1.892000e+08  1.798000e+08   \n",
       "393            1   388                  20   1.001400e+10  9.715000e+09   \n",
       "394            1   389                  19   1.053100e+10  1.026560e+10   \n",
       "395            1   390                  18   1.031200e+09  9.832000e+08   \n",
       "396            1   377                  24   3.191900e+10  3.038680e+10   \n",
       "397            1   379                  15   4.266000e+09  4.005000e+09   \n",
       "398            1   398                  25   2.808430e+09  2.752400e+09   \n",
       "399            1   399                  13   1.832000e+09  1.622620e+09   \n",
       "400            1   400                   4   2.618000e+08  2.495000e+08   \n",
       "401            1   401                  13   1.892000e+08  1.798000e+08   \n",
       "402            1   402                  20   1.001400e+10  9.715000e+09   \n",
       "403            1   403                  19   1.053100e+10  1.026560e+10   \n",
       "404            1   404                  18   1.031200e+09  9.832000e+08   \n",
       "405            1   391                  24   3.191900e+10  3.038680e+10   \n",
       "406            1   393                  15   4.266000e+09  4.005000e+09   \n",
       "407            1   410                  11   9.797000e+09  8.985000e+09   \n",
       "408            1   412                  25   2.808430e+09  2.752400e+09   \n",
       "409            1   413                  13   1.832000e+09  1.622620e+09   \n",
       "\n",
       "     analysis_mean  analysis_year_ago  trend_2month_ago  trend_current  \\\n",
       "0     2.789720e+09       3.051750e+09      2.813970e+09   2.789720e+09   \n",
       "1     2.789720e+09       3.051750e+09      2.813970e+09   2.789720e+09   \n",
       "2     2.787440e+09       3.051750e+09      2.813970e+09   2.787440e+09   \n",
       "3     2.787650e+09       3.051240e+09      2.824190e+09   2.787650e+09   \n",
       "4     2.787650e+09       3.051240e+09      2.824190e+09   2.787650e+09   \n",
       "5     2.787650e+09       3.051240e+09      2.824190e+09   2.787650e+09   \n",
       "6     2.787650e+09       3.051240e+09      2.824190e+09   2.787650e+09   \n",
       "7     2.787650e+09       3.051240e+09      2.822500e+09   2.787650e+09   \n",
       "8     2.787650e+09       3.051240e+09      2.822500e+09   2.787650e+09   \n",
       "9     2.787650e+09       3.051240e+09      2.822500e+09   2.787650e+09   \n",
       "10    2.787650e+09       3.051240e+09      2.824730e+09   2.787650e+09   \n",
       "11    2.787650e+09       3.051240e+09      2.824730e+09   2.787650e+09   \n",
       "12    2.787650e+09       3.051240e+09      2.824730e+09   2.787650e+09   \n",
       "13    2.787650e+09       3.051240e+09      2.824730e+09   2.787650e+09   \n",
       "14    2.787650e+09       3.051240e+09      2.824190e+09   2.787650e+09   \n",
       "15    2.789720e+09       3.051750e+09      2.813970e+09   2.789720e+09   \n",
       "16    2.789720e+09       3.051750e+09      2.813970e+09   2.789720e+09   \n",
       "17    2.787440e+09       3.051240e+09      2.813970e+09   2.787440e+09   \n",
       "18    2.789720e+09       3.051750e+09      2.813970e+09   2.789720e+09   \n",
       "19    2.789720e+09       3.051750e+09      2.813970e+09   2.789720e+09   \n",
       "20    1.320000e+08       1.179700e+08      1.320000e+08   1.320000e+08   \n",
       "21    1.100700e+08       1.031000e+08      1.100700e+08   1.100700e+08   \n",
       "22    2.783660e+09       3.051750e+09      2.813970e+09   2.783660e+09   \n",
       "23    1.320000e+08       1.179700e+08      1.325000e+08   1.320000e+08   \n",
       "24    1.100700e+08       1.031000e+08      1.100700e+08   1.100700e+08   \n",
       "25    2.783660e+09       3.051750e+09      2.803710e+09   2.783660e+09   \n",
       "26    1.320000e+08       1.179700e+08      1.325000e+08   1.320000e+08   \n",
       "27    1.100700e+08       1.031000e+08      1.100700e+08   1.100700e+08   \n",
       "28    2.783660e+09       3.051750e+09      2.803710e+09   2.783660e+09   \n",
       "29    1.320000e+08       1.179700e+08      1.325000e+08   1.320000e+08   \n",
       "..             ...                ...               ...            ...   \n",
       "380   1.320000e+08       1.180000e+08      1.320000e+08   1.320000e+08   \n",
       "381   9.457150e+09       9.677760e+09      9.457150e+09   9.457150e+09   \n",
       "382   1.835100e+08       1.482600e+08      1.837100e+08   1.835100e+08   \n",
       "383   9.888310e+09       9.490240e+09      9.900330e+09   9.888310e+09   \n",
       "384   1.038760e+10       1.090290e+10      1.038910e+10   1.038760e+10   \n",
       "385   1.008300e+09       9.545000e+08      1.009500e+09   1.008300e+09   \n",
       "386   3.107640e+10       3.126530e+10      3.106340e+10   3.107640e+10   \n",
       "387   4.108190e+09       4.042300e+09      4.125070e+09   4.108190e+09   \n",
       "388   9.457150e+09       9.677760e+09      9.457150e+09   9.457150e+09   \n",
       "389   2.783150e+09       3.051220e+09      2.787650e+09   2.783150e+09   \n",
       "390   1.763250e+09       1.836210e+09      1.795910e+09   1.763250e+09   \n",
       "391   2.553600e+08       2.414000e+08      2.618900e+08   2.553600e+08   \n",
       "392   1.835100e+08       1.482600e+08      1.837100e+08   1.835100e+08   \n",
       "393   9.888310e+09       9.490240e+09      9.900330e+09   9.888310e+09   \n",
       "394   1.038760e+10       1.090290e+10      1.038910e+10   1.038760e+10   \n",
       "395   1.008300e+09       9.545000e+08      1.009500e+09   1.008300e+09   \n",
       "396   3.107640e+10       3.126530e+10      3.106340e+10   3.107640e+10   \n",
       "397   4.108190e+09       4.042300e+09      4.125070e+09   4.108190e+09   \n",
       "398   2.783150e+09       3.051220e+09      2.787650e+09   2.783150e+09   \n",
       "399   1.763250e+09       1.836210e+09      1.795910e+09   1.763250e+09   \n",
       "400   2.553600e+08       2.414000e+08      2.618900e+08   2.553600e+08   \n",
       "401   1.835100e+08       1.482600e+08      1.837100e+08   1.835100e+08   \n",
       "402   9.888310e+09       9.490240e+09      9.900330e+09   9.888310e+09   \n",
       "403   1.038760e+10       1.090290e+10      1.038910e+10   1.038760e+10   \n",
       "404   1.008300e+09       9.545000e+08      1.009500e+09   1.008300e+09   \n",
       "405   3.107640e+10       3.126530e+10      3.106340e+10   3.107640e+10   \n",
       "406   4.108190e+09       4.042300e+09      4.125070e+09   4.108190e+09   \n",
       "407   9.457150e+09       9.677760e+09      9.457150e+09   9.457150e+09   \n",
       "408   2.783150e+09       3.051220e+09      2.789720e+09   2.783150e+09   \n",
       "409   1.763250e+09       1.836210e+09      1.794560e+09   1.763250e+09   \n",
       "\n",
       "     trend_month_ago  trend_week_ago  trend_year_ago  source_id_y  \n",
       "0       2.802240e+09    2.787650e+09    3.051750e+09            3  \n",
       "1       2.802240e+09    2.787650e+09    3.051750e+09            3  \n",
       "2       2.803580e+09    2.787650e+09    3.051750e+09            3  \n",
       "3       2.803710e+09    2.793790e+09    3.051240e+09            3  \n",
       "4       2.804110e+09    2.793790e+09    3.051240e+09            3  \n",
       "5       2.803710e+09    2.793790e+09    3.051240e+09            3  \n",
       "6       2.803710e+09    2.793790e+09    3.051240e+09            3  \n",
       "7       2.803580e+09    2.787650e+09    3.051240e+09            3  \n",
       "8       2.803580e+09    2.787650e+09    3.051240e+09            3  \n",
       "9       2.803580e+09    2.787650e+09    3.051240e+09            3  \n",
       "10      2.803580e+09    2.787650e+09    3.051240e+09            3  \n",
       "11      2.803580e+09    2.787650e+09    3.051240e+09            3  \n",
       "12      2.803580e+09    2.787650e+09    3.051240e+09            3  \n",
       "13      2.803580e+09    2.793790e+09    3.051240e+09            3  \n",
       "14      2.804110e+09    2.793790e+09    3.051240e+09            3  \n",
       "15      2.802240e+09    2.787650e+09    3.051750e+09            3  \n",
       "16      2.802240e+09    2.787650e+09    3.051750e+09            3  \n",
       "17      2.803580e+09    2.787650e+09    3.051240e+09            3  \n",
       "18      2.793790e+09    2.787650e+09    3.051750e+09            3  \n",
       "19      2.802240e+09    2.787650e+09    3.051750e+09            3  \n",
       "20      1.325000e+08    1.320000e+08    1.179700e+08            3  \n",
       "21      1.100700e+08    1.100700e+08    1.031000e+08            3  \n",
       "22      2.793790e+09    2.789720e+09    3.051750e+09            3  \n",
       "23      1.325000e+08    1.320000e+08    1.179700e+08            3  \n",
       "24      1.100700e+08    1.100700e+08    1.031000e+08            3  \n",
       "25      2.793790e+09    2.789720e+09    3.051750e+09            3  \n",
       "26      1.325000e+08    1.320000e+08    1.179700e+08            3  \n",
       "27      1.100700e+08    1.100700e+08    1.031000e+08            3  \n",
       "28      2.793790e+09    2.789720e+09    3.051750e+09            3  \n",
       "29      1.325000e+08    1.320000e+08    1.179700e+08            3  \n",
       "..               ...             ...             ...          ...  \n",
       "380     1.320000e+08    1.320000e+08    1.180000e+08            3  \n",
       "381     9.457150e+09    9.457150e+09    9.677760e+09            3  \n",
       "382     1.837500e+08    1.837500e+08    1.482600e+08            3  \n",
       "383     9.896750e+09    9.897160e+09    9.490240e+09            3  \n",
       "384     1.038860e+10    1.038760e+10    1.090290e+10            3  \n",
       "385     1.009600e+09    1.009600e+09    9.545000e+08            3  \n",
       "386     3.106980e+10    3.107740e+10    3.126530e+10            3  \n",
       "387     4.118390e+09    4.118390e+09    4.042300e+09            3  \n",
       "388     9.457150e+09    9.457150e+09    9.677760e+09            3  \n",
       "389     2.783000e+09    2.783150e+09    3.051220e+09            3  \n",
       "390     1.799960e+09    1.768930e+09    1.836210e+09            3  \n",
       "391     2.583800e+08    2.553600e+08    2.414000e+08            3  \n",
       "392     1.837500e+08    1.837500e+08    1.482600e+08            3  \n",
       "393     9.896750e+09    9.897160e+09    9.490240e+09            3  \n",
       "394     1.038860e+10    1.038760e+10    1.090290e+10            3  \n",
       "395     1.009600e+09    1.009600e+09    9.545000e+08            3  \n",
       "396     3.106980e+10    3.107740e+10    3.126530e+10            3  \n",
       "397     4.118390e+09    4.118390e+09    4.042300e+09            3  \n",
       "398     2.783000e+09    2.783150e+09    3.051220e+09            3  \n",
       "399     1.799960e+09    1.768930e+09    1.836210e+09            3  \n",
       "400     2.583800e+08    2.553600e+08    2.414000e+08            3  \n",
       "401     1.837500e+08    1.837500e+08    1.482600e+08            3  \n",
       "402     9.896750e+09    9.897160e+09    9.490240e+09            3  \n",
       "403     1.038860e+10    1.038760e+10    1.090290e+10            3  \n",
       "404     1.009600e+09    1.009600e+09    9.545000e+08            3  \n",
       "405     3.106980e+10    3.107740e+10    3.126530e+10            3  \n",
       "406     4.118390e+09    4.118390e+09    4.042300e+09            3  \n",
       "407     9.457150e+09    9.457150e+09    9.677760e+09            3  \n",
       "408     2.783250e+09    2.783150e+09    3.051220e+09            3  \n",
       "409     1.789600e+09    1.768930e+09    1.836210e+09            3  \n",
       "\n",
       "[410 rows x 19 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_sales_traffic = pd.merge(record_traffic, record_sales, on=['date','company_id'],how=\"inner\")\n",
    "\n",
    "# df_sales_traffic.apply(pd.value_counts).fillna(method='bfill')\n",
    "df_sales_traffic"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id_x</th>\n",
       "      <th>date</th>\n",
       "      <th>traffic</th>\n",
       "      <th>paid_traffic</th>\n",
       "      <th>company_id</th>\n",
       "      <th>period</th>\n",
       "      <th>source_id_x</th>\n",
       "      <th>id_y</th>\n",
       "      <th>analysis_estimates</th>\n",
       "      <th>analysis_high</th>\n",
       "      <th>analysis_low</th>\n",
       "      <th>analysis_mean</th>\n",
       "      <th>analysis_year_ago</th>\n",
       "      <th>trend_2month_ago</th>\n",
       "      <th>trend_current</th>\n",
       "      <th>trend_month_ago</th>\n",
       "      <th>trend_week_ago</th>\n",
       "      <th>trend_year_ago</th>\n",
       "      <th>source_id_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>613</td>\n",
       "      <td>2019-03-15</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>15</td>\n",
       "      <td>23</td>\n",
       "      <td>2.842580e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>0.086416</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>2.813970e+09</td>\n",
       "      <td>2.789720e+09</td>\n",
       "      <td>2.802240e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>615</td>\n",
       "      <td>2019-03-17</td>\n",
       "      <td>0.000016</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>17</td>\n",
       "      <td>23</td>\n",
       "      <td>2.842580e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>0.086416</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>2.813970e+09</td>\n",
       "      <td>2.789720e+09</td>\n",
       "      <td>2.802240e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>498</td>\n",
       "      <td>2019-03-14</td>\n",
       "      <td>0.000035</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>14</td>\n",
       "      <td>23</td>\n",
       "      <td>2.823000e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>0.086343</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>2.813970e+09</td>\n",
       "      <td>2.787440e+09</td>\n",
       "      <td>2.803580e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>3.051750e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>500</td>\n",
       "      <td>2019-03-04</td>\n",
       "      <td>0.000022</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>23</td>\n",
       "      <td>2.823000e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>0.086350</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>2.824190e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>2.803710e+09</td>\n",
       "      <td>2.793790e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>501</td>\n",
       "      <td>2019-03-03</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>daily</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>23</td>\n",
       "      <td>2.823000e+09</td>\n",
       "      <td>2.749000e+09</td>\n",
       "      <td>0.086350</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>2.824190e+09</td>\n",
       "      <td>2.787650e+09</td>\n",
       "      <td>2.804110e+09</td>\n",
       "      <td>2.793790e+09</td>\n",
       "      <td>3.051240e+09</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id_x        date   traffic  paid_traffic  company_id period  source_id_x  \\\n",
       "0   613  2019-03-15  0.000035             0           1  daily            2   \n",
       "1   615  2019-03-17  0.000016             0           1  daily            2   \n",
       "2   498  2019-03-14  0.000035             0           1  daily            2   \n",
       "3   500  2019-03-04  0.000022             0           1  daily            2   \n",
       "4   501  2019-03-03  0.000000             0           1  daily            2   \n",
       "\n",
       "   id_y  analysis_estimates  analysis_high  analysis_low  analysis_mean  \\\n",
       "0    15                  23   2.842580e+09  2.749000e+09       0.086416   \n",
       "1    17                  23   2.842580e+09  2.749000e+09       0.086416   \n",
       "2    14                  23   2.823000e+09  2.749000e+09       0.086343   \n",
       "3     4                  23   2.823000e+09  2.749000e+09       0.086350   \n",
       "4     3                  23   2.823000e+09  2.749000e+09       0.086350   \n",
       "\n",
       "   analysis_year_ago  trend_2month_ago  trend_current  trend_month_ago  \\\n",
       "0       3.051750e+09      2.813970e+09   2.789720e+09     2.802240e+09   \n",
       "1       3.051750e+09      2.813970e+09   2.789720e+09     2.802240e+09   \n",
       "2       3.051750e+09      2.813970e+09   2.787440e+09     2.803580e+09   \n",
       "3       3.051240e+09      2.824190e+09   2.787650e+09     2.803710e+09   \n",
       "4       3.051240e+09      2.824190e+09   2.787650e+09     2.804110e+09   \n",
       "\n",
       "   trend_week_ago  trend_year_ago  source_id_y  \n",
       "0    2.787650e+09    3.051750e+09            3  \n",
       "1    2.787650e+09    3.051750e+09            3  \n",
       "2    2.787650e+09    3.051750e+09            3  \n",
       "3    2.793790e+09    3.051240e+09            3  \n",
       "4    2.793790e+09    3.051240e+09            3  "
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_sales_traffic[['traffic','analysis_mean']] = (df_sales_traffic[['traffic','analysis_mean']] - df_sales_traffic[['traffic','analysis_mean']].min())/(df_sales_traffic[['traffic','analysis_mean']].max()-df_sales_traffic[['traffic','analysis_mean']].min())\n",
    "df_sales_traffic.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Text(0, 0.5, 'Daily Sales')"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYUAAAEKCAYAAAD9xUlFAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvnQurowAAFylJREFUeJzt3XuUZWV95vHvQyOXKIpKM6NcbOI0EAYVnBpAySQaNLZNQjMzBmGC8UJkaQZnvIQlWTheULKIGnUyEBUzaNQoojMLe7QNMRm8LJcYijQiIEgHW2lw2Y0KKohI+5s/zu49RXXVqV3dtevU5ftZq1ftvc979vntrstz3v3u8+5UFZIkAewx6gIkSQuHoSBJahkKkqSWoSBJahkKkqSWoSBJahkKkqSWoSBJahkKkqTWnqMuYLYOOOCAWrVq1ajLkKRF5brrrru7qlbO1G7RhcKqVasYHx8fdRmStKgk+U6Xdp4+kiS1DAVJUstQkCS1DAVJUstQkCS1DAVJUstQkCS1eguFJJcl2ZrkxmkeT5K/SLIpyQ1Jnt5XLZKkbvr88NqHgIuBD0/z+POB1c2/44H3Nl+lBeHKjXfy+v91Az9/6Jc7Pbb6wEfy+dc+a/6LWsBWnffZnbZtvujkOdn3kedv4IHt//9+8vusCLdcuHZO9q2H662nUFVfAn44pMk64MM1cA2wf5In9FWPNBtXbryT115x/ZSBAHDb1vt47ru+ML9FLWBTBcKw7bMxORAAHtheHHn+ht3et3Y2yjGFg4A7JqxvabZJI/eOq27llzW8zW1b75ufYpa5yYEw03btnlGGQqbYNuV3OcnZScaTjG/btq3nsiS4656fjboEaSRGGQpbgEMmrB8M3DVVw6q6tKrGqmps5coZJ/mTdtsT99931CVIIzHKUFgP/EFzFdIJwL1V9b0R1iO1zn3eEewxVV92gtUHPnJ+ilnm9lkx9Tdiuu3aPX1ekvpx4KvAEUm2JDkrySuSvKJpsgG4HdgEfAD4o75qkWbr1GMP4l2nHcPee079K+LVRw833VVGc3H10S0Xrt0pALz6qD+pWlyDNWNjY+X9FCRpdpJcV1VjM7XzE82SpJahIElqGQqSpJahIElqGQqSpJahIElqGQqSpJahIElqGQqSpJahIElqGQqSpJahIElqGQqSpJahIElqGQqSpJahIElqGQqSpJahIElqGQqSpJahIElqGQqSpJahIElqGQqSpJahIElqGQqSpJahIElqGQqSpJahIElqGQqSpJahIElq9RoKSdYkuTXJpiTnTfH4oUmuTrIxyQ1J1vZZjyRpuN5CIckK4BLg+cBRwBlJjprU7A3AFVV1LHA68Jd91SNJmlmfPYXjgE1VdXtVPQhcDqyb1KaARzfLjwHu6rEeSdIM+gyFg4A7JqxvabZN9GbgzCRbgA3Aq6baUZKzk4wnGd+2bVsftUqS6DcUMsW2mrR+BvChqjoYWAt8JMlONVXVpVU1VlVjK1eu7KFUSRL0GwpbgEMmrB/MzqeHzgKuAKiqrwL7AAf0WJMkaYg+Q+FaYHWSw5LsxWAgef2kNt8FTgJI8msMQsHzQ5I0Ir2FQlU9BJwDXAV8k8FVRjcluSDJKU2z1wEvT/J14OPAS6pq8ikmSdI82bPPnVfVBgYDyBO3vXHC8s3AiX3WIEnqzk80S5JahoIkqWUoSJJahoIkqWUoSJJahoIkqWUoSJJahoIkqWUoSJJahoIkqWUoSJJahoIkqWUoSJJahoIkqWUoSJJahoIkqWUoSJJahoIkqWUoSJJahoIkqWUoSJJahoIkqWUoSJJahoIkqWUoSJJahoIkqTVjKCT5vST7NctvSPK/kzy9/9IkSfOtS0/hv1XVT5L8OvA84K+B9/ZbliRpFLqEwvbm68nAe6vq08Be/ZUkSRqVLqFwZ5L3A6cBG5Ls3fF5JFmT5NYkm5KcN02b05LcnOSmJB/rXrokaa7t2aHNacAa4J1VdU+SJwDnzvSkJCuAS4DnAluAa5Osr6qbJ7RZDfwJcGJV/SjJgbtyEJKkuTHjO/6quh/YCvx6s+kh4LYO+z4O2FRVt1fVg8DlwLpJbV4OXFJVP2pea2vXwiVJc6/L1UdvAl7P4B09wCOAj3bY90HAHRPWtzTbJjocODzJV5Jck2RNh/1KknrS5fTRvweOBf4JoKru2nGJ6gwyxbaa4vVXA88CDga+nOToqrrnYTtKzgbOBjj00EM7vLQkaVd0GTB+sKqK5g96kkd23PcW4JAJ6wcDd03R5tNV9Yuq+jZwK4OQeJiqurSqxqpqbOXKlR1fXpI0W11C4Yrm6qP9k7wc+HvgAx2edy2wOslhSfYCTgfWT2pzJfBsgCQHMDiddHvX4iVJc2vG00dV9c4kzwV+DBwBvLGqPt/heQ8lOQe4ClgBXFZVNyW5ABivqvXNY7+d5GYGn4c4t6p+sBvHI0naDRmcGVo8xsbGanx8fNRlSNKikuS6qhqbqd20PYUkP2HngWEYDCBXVT16N+qTJC1A04ZCVXW5wkiStIR0uSQVgObTxvvsWK+q7/ZSkSRpZLp8eO2UJLcB3wa+CGwGPtdzXZKkEehySepbgROAb1XVYcBJwFd6rUqSNBJdQuEXzWWieyTZo6quBo7puS5J0gh0GVO4J8mjgC8Bf5NkK4NJ8SRJS0yXnsI64H7gNcDfAv8M/G6fRUmSRqPLJ5rvA0jyWAafar7RTx1L0tI0bU8hyWeSHN0sPwG4EXgZ8OEkr56n+iRJ82jY6aPDqurGZvmlwOer6ncZXIn0st4rkyTNu2Gh8IsJyycBGwCq6ifAL/ssSpI0GsPGFO5I8ioG9zx4OoNBZpLsy+Dua5KkJWZYT+Es4F8DLwFeOOFuaCcAH+y5LknSCAybEG8r8Ioptl8NXN1nUZKk0ejyOQVJ0jJhKEiSWl1mSX3cfBQiSRq9Lj2FryX5ZJK1SdJ7RZKkkekSCocDlwIvAjYl+dMkh/dbliRpFGYMhRr4fFWdAfwh8GLgH5N8Mckzeq9QkjRvZpwQL8njgTMZ9BS+D7wKWM/gngqfBA7rs0BJ0vzpcj+FrwIfAU6tqi0Tto8neV8/ZUmSRqFLKBxRVTXVA1X1Z3NcjyRphKYNhST/B6hmeafHq+qU/sqSJI3CsJ7CO+etCknSgjBs7qMvzmchkqTRG3b66IqqOi3JN2hOI01UVU/ttTJJ0rwbdvrovzZff2c+CpEkjd6w00ffa75+Z/7KkSSNUpcJ8U5Icm2SnyZ5MMn2JD/usvMka5LcmmRTkvOGtHtBkkoyNpviJUlzq8vcRxcDZwC3AfsymOrif8z0pCQrgEuA5wNHAWckOWqKdvsB/wX4WveyJUl96HQ/haraBKyoqu1V9UHg2R2edhywqapur6oHgcuBdVO0eyvwduCBjjVLknrSJRTuT7IXcH2Styd5DfDIDs87CLhjwvqWZlsrybHAIVX1mWE7SnJ2kvEk49u2bevw0pKkXdElFF7UtDsHuA84BPiPHZ431b0X2ktbk+wBvBt43Uw7qqpLq2qsqsZWrlzZ4aUlSbtixrmPquo7SVY2y2+Zxb63MAiQHQ4G7pqwvh9wNPCFZhqNfwmsT3JKVY3P4nUkSXNk2p5CBt6c5G7gFuBbSbYleWPHfV8LrE5yWHP66XQGU24DUFX3VtUBVbWqqlYB1wAGgiSN0LDTR68GTgT+bVU9vqoeCxwPnNiMKwxVVQ8xOOV0FfBN4IqquinJBUmcTE+SFqBMMys2STYCz62quydtXwn8XVUdOw/17WRsbKzGx+1MSNJsJLmuqmb8LNiwnsIjJgcCQFVtAx6xO8VJkhamYaHw4C4+JklapIZdffS0aaazCLBPT/VIkkZo2IR4K+azEEnS6HW5R/OScuXGO3nHVbdy1z0/44n778u5zzuCU489aOYnLpN6JC1vyyoUrtx4J6/+xPXt+p33/Kxdn68/xEeev4EHtk99xdco6pGkiTpNiLdUTAyELtvn2rBAmGi+6pGkyZZVKIxal0CQpFFaVqePZmvVeZ/dadvmi04eQSWSND/sKUxjqkAYtl2SlgJ7ChP0/Qd/nxXxFJKkBc2eQmM+egC3XLiWfVZMdZuJh/MUlaRRsacwz265cO2oS5CkadlTkCS1DIVZ8tSOpKXM00cdGASSlotl1VOY7o/75otOHvqYJC0X0955baHyzmuSNHtzcec1SdIyYyhIklqGgiSpZShIklqGgiSpZShIklqGgiSpZShIklqGgiSpZShIklqGgiSp1WsoJFmT5NYkm5KcN8Xjr01yc5IbkvxDkif1WY8kabjeQiHJCuAS4PnAUcAZSY6a1GwjMFZVTwU+Bby9r3okSTPrs6dwHLCpqm6vqgeBy4F1ExtU1dVVdX+zeg1wcI/1SJJm0GcoHATcMWF9S7NtOmcBn+uxHknSDPq881qm2DblzRuSnAmMAb85zeNnA2cDHHrooXNVnyRpkj57CluAQyasHwzcNblRkucA5wOnVNXPp9pRVV1aVWNVNbZy5cpeipUk9RsK1wKrkxyWZC/gdGD9xAZJjgXezyAQtvZYiySpg95CoaoeAs4BrgK+CVxRVTcluSDJKU2zdwCPAj6Z5Pok66fZnSRpHvQ5pkBVbQA2TNr2xgnLz+nz9SVJs+MnmiVJLUNBktQyFCRJLUNBktQyFCRJrV6vPtKueeqb/pYf/3z7lI9tvujkea5G0nJiT2GBGRYIAKvO++w8ViNpuTEUFphhgSBJfTMUJEktQ0GS1DIUFphH771i1CVIWsYMhQXmhresGRoMXn0kqU9ekroA3fCWNaMuQdIyZU9BktRadj2Fqa7z95SMJA0sq57CdB/88gNhkjSwrEJBkjScoSBJahkKkqSWoSBJai2rq482X3Ty0KuPrtx4J6/+xPXTPi5JS92y6ikMu/poukAY9jxJWmqWVSgM846rbh11CZI0coZC4657fjbqEiRp5AyFxhP333fUJUjSyC2rgeZhzn3eEdOOKczkyPM38MD22mm7A9SSFptl1VMY9kd6WCC854XH7LTtDVd+gyf/yQZWnffZKQMBHKCWtPgsq1CAQTBsvuhkzjzh0M7PmTwI/YYrv8FHr/ku22vqMJCkxWrZhcIOH//aHZ3bTh6Ens1zJWkxWbZjCrN5lz95EHp3egiOP0hayHoNhSRrgP8OrAD+qqoumvT43sCHgX8D/AB4YVVt7rOmXTnPf+7zjnjY+opkl4JhukDYUZfBIC19k/8O7LMi3HLh2p3ajereL72dPkqyArgEeD5wFHBGkqMmNTsL+FFV/Svg3cCf9VUP7FogvOeFx3DqsQc9bNsZxx/S6bmTv4HTBYKk5WGqN4YPbC+OPH/Dw7aN8t4vffYUjgM2VdXtAEkuB9YBN09osw54c7P8KeDiJKlaOCO4kwMB4G2nPgUYjC1sr2JFwhnHH9Jul6SpTPfGcCG9YewzFA4CJo7IbgGOn65NVT2U5F7g8cDdExslORs4G+DQQ7tfNdSnt536FENA0pLT59VHmWLb5Djs0oaqurSqxqpqbOXKlXNSXBcnPvlxc7q/fVZMdbiStHD0GQpbgIkn3w8G7pquTZI9gccAP+yxpmlNDoATn/w4/ublz5jT17jlwrXTBoODzNLSN93v/0J6w5i+Tt83f+S/BZwE3AlcC/ynqrppQpv/DDylql6R5HTgP1TVacP2OzY2VuPj47tc16hG9CUJRnf1UZLrqmpsxnZ9jukmWQu8h8ElqZdV1YVJLgDGq2p9kn2AjwDHMughnL5jYHo6uxsKkrQcdQ2FXj+nUFUbgA2Ttr1xwvIDwO/1WYMkqbtlO82FJGlnhoIkqWUoSJJahoIkqWUoSJJahoIkqWUoSJJavX54rQ9JtgHfmYNdHcCkifeWOI936VpOxwoe7656UlXNOHncoguFuZJkvMun+5YKj3fpWk7HCh5v3zx9JElqGQqSpNZyDoVLR13APPN4l67ldKzg8fZq2Y4pSJJ2tpx7CpKkSZZ8KCRZk+TWJJuSnDfF43sn+UTz+NeSrJr/KudGh2N9bZKbk9yQ5B+SPGkUdc6VmY53QrsXJKkki/qKlS7Hm+S05nt8U5KPzXeNc6nDz/OhSa5OsrH5md75TjWLRJLLkmxNcuM0jyfJXzT/FzckeXpvxVTVkv3H4OY+/wz8KrAX8HXgqElt/gh4X7N8OvCJUdfd47E+G/iVZvmVi/VYux5v024/4EvANcDYqOvu+fu7GtgIPLZZP3DUdfd8vJcCr2yWjwI2j7ru3Tje3wCeDtw4zeNrgc8xuK/9CcDX+qplqfcUjgM2VdXtVfUgcDmwblKbdcBfN8ufAk5KsnBumNrdjMdaVVdX1f3N6jUM7pu9WHX53gK8FXg78MB8FteDLsf7cuCSqvoRQFVtneca51KX4y3g0c3yY9j5HvCLRlV9ieH3p18HfLgGrgH2T/KEPmpZ6qFwEHDHhPUtzbYp21TVQ8C9wOPnpbq51eVYJzqLwTuPxWrG401yLHBIVX1mPgvrSZfv7+HA4Um+kuSaJGvmrbq51+V43wycmWQLgzs8vmp+ShuJ2f5+77Jeb8e5AEz1jn/y5VZd2iwGnY8jyZnAGPCbvVbUr6HHm2QP4N3AS+aroJ51+f7uyeAU0rMY9AK/nOToqrqn59r60OV4zwA+VFV/nuQZwEea4/1l/+XNu3n7O7XUewpbgEMmrB/Mzl3Mtk2SPRl0Q4d14xaqLsdKkucA5wOnVNXP56m2Psx0vPsBRwNfSLKZwXnY9Yt4sLnrz/Knq+oXVfVt4FYGIbEYdTnes4ArAKrqq8A+DOYJWoo6/X7PhaUeCtcCq5MclmQvBgPJ6ye1WQ+8uFl+AfB/qxnZWWRmPNbmdMr7GQTCYj7fDDMcb1XdW1UHVNWqqlrFYAzllKoaH025u63Lz/KVDC4mIMkBDE4n3T6vVc6dLsf7XeAkgCS/xiAUts1rlfNnPfAHzVVIJwD3VtX3+nihJX36qKoeSnIOcBWDqxkuq6qbklwAjFfVeuB/Muh2bmLQQzh9dBXvuo7H+g7gUcAnm7H071bVKSMrejd0PN4lo+PxXgX8dpKbge3AuVX1g9FVves6Hu/rgA8keQ2DUykvWaRv6EjycQan/Q5oxkjeBDwCoKrex2DMZC2wCbgfeGlvtSzS/0NJUg+W+ukjSdIsGAqSpJahIElqGQqSpJahIElqGQpakpJsT3J9M1vo15sZYof+vCd5YpJPNcvPStJpeowkL21e6/okDyb5RrN80SxrfldT70VJ/kWSf2xmAH1mkquS7Deb/Um7wktStSQl+WlVPapZPhD4GPCVqnpTx+c/C/jjqvqdWb7uZgazsd49xWN7NvNrTfW80My7VVW/aKYieXZVnTWb15d2lz0FLXnNp7fPBs5pPhG6KsmXk/xT8++ZAM32h81nn2SPJLclWTlhfVPzieEZJXlbkvcn+TzwwSRPbl57Y5LrkhzfNP0s8Ejg2iR/DPwpcErT49gryZYk+zf7fGkzp/7Xk3xwLv6PpB2W9CeapR2q6vbm9NGBwFbguVX1QJLVwMcZTBA41fN+meSjwO8D7wGeA3x9qp7AEMcCv9G83q9MeO0jGUzbfjxwCnB3VR0DkOQe4OiqenWzTvP1acDrgWdW1Q+TPG52/xPScIaClpMdM00+Arg4yTEMpoM4fIbnXQZ8mkEovAyY7bvzT1fVjvs57N289tOAh4Anz3Jfv8Xg5kg/BNjxVZorhoKWhSS/yiAAtjKYV+b7wNMYnEIdegOeqrojyfeT/BaDd/W/P8uXv2/C8usYzIt/JoNw+uks9xUW59TuWiQcU9CS14wHvA+4uJkw7THA95p591/EYMK1mfwV8FHgiqravhvl7HjtYjA772zv8vf3wOk7Tht5+khzzVDQUrXvjktSGfwh/TvgLc1jfwm8OMk1DE4d3TfNPiZaz2CG2d0d2L0Y+MPmtZ8EzOqeFlV1A4Pbi34pyfUMZr6V5oyXpEodZHBznndX1b8bdS1SnxxTkGaQ5Dzglcx+LEFadOwpSJJajilIklqGgiSpZShIklqGgiSpZShIklqGgiSp9f8Ab+ABCX1LThgAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.scatter(df_sales_traffic.traffic,df_sales_traffic.analysis_mean)\n",
    "plt.xlabel(\"Daily Traffic\")\n",
    "plt.ylabel(\"Daily Sales\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id_x</th>\n",
       "      <th>date</th>\n",
       "      <th>traffic</th>\n",
       "      <th>paid_traffic</th>\n",
       "      <th>company_id</th>\n",
       "      <th>period</th>\n",
       "      <th>source_id</th>\n",
       "      <th>id_y</th>\n",
       "      <th>open</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>close</th>\n",
       "      <th>adjusted_close</th>\n",
       "      <th>volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1549</td>\n",
       "      <td>2019-01-15</td>\n",
       "      <td>5780</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>12464</td>\n",
       "      <td>2992.0</td>\n",
       "      <td>2992.0</td>\n",
       "      <td>2669.0</td>\n",
       "      <td>2860.0</td>\n",
       "      <td>2860.0</td>\n",
       "      <td>1032066.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1551</td>\n",
       "      <td>2018-03-15</td>\n",
       "      <td>8689</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>12254</td>\n",
       "      <td>7504.0</td>\n",
       "      <td>7770.0</td>\n",
       "      <td>7504.0</td>\n",
       "      <td>7730.0</td>\n",
       "      <td>7730.0</td>\n",
       "      <td>270632.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1552</td>\n",
       "      <td>2018-02-15</td>\n",
       "      <td>5753</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>12234</td>\n",
       "      <td>7164.0</td>\n",
       "      <td>7288.0</td>\n",
       "      <td>7162.0</td>\n",
       "      <td>7286.0</td>\n",
       "      <td>7286.0</td>\n",
       "      <td>366737.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1553</td>\n",
       "      <td>2018-01-15</td>\n",
       "      <td>11041</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>12211</td>\n",
       "      <td>6888.0</td>\n",
       "      <td>6916.0</td>\n",
       "      <td>6695.0</td>\n",
       "      <td>6838.0</td>\n",
       "      <td>6838.0</td>\n",
       "      <td>196500.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1554</td>\n",
       "      <td>2017-12-15</td>\n",
       "      <td>7427</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>12193</td>\n",
       "      <td>6206.0</td>\n",
       "      <td>6223.0</td>\n",
       "      <td>5935.0</td>\n",
       "      <td>6200.0</td>\n",
       "      <td>6200.0</td>\n",
       "      <td>263194.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1555</td>\n",
       "      <td>2017-11-15</td>\n",
       "      <td>1982</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>12171</td>\n",
       "      <td>5656.0</td>\n",
       "      <td>5726.0</td>\n",
       "      <td>5642.0</td>\n",
       "      <td>5705.0</td>\n",
       "      <td>5705.0</td>\n",
       "      <td>327264.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1557</td>\n",
       "      <td>2017-09-15</td>\n",
       "      <td>3532</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>12128</td>\n",
       "      <td>5574.0</td>\n",
       "      <td>5700.0</td>\n",
       "      <td>5518.0</td>\n",
       "      <td>5549.0</td>\n",
       "      <td>5549.0</td>\n",
       "      <td>582871.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1558</td>\n",
       "      <td>2017-08-15</td>\n",
       "      <td>1088</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>12106</td>\n",
       "      <td>5890.0</td>\n",
       "      <td>5986.0</td>\n",
       "      <td>5853.0</td>\n",
       "      <td>5917.0</td>\n",
       "      <td>5917.0</td>\n",
       "      <td>87725.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1561</td>\n",
       "      <td>2017-06-15</td>\n",
       "      <td>1548</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>12063</td>\n",
       "      <td>6101.0</td>\n",
       "      <td>6132.0</td>\n",
       "      <td>5988.0</td>\n",
       "      <td>6046.0</td>\n",
       "      <td>6046.0</td>\n",
       "      <td>368754.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1562</td>\n",
       "      <td>2017-05-15</td>\n",
       "      <td>1473</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>12041</td>\n",
       "      <td>6155.0</td>\n",
       "      <td>6184.0</td>\n",
       "      <td>6099.0</td>\n",
       "      <td>6154.0</td>\n",
       "      <td>6154.0</td>\n",
       "      <td>340168.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1564</td>\n",
       "      <td>2017-03-15</td>\n",
       "      <td>904</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>12001</td>\n",
       "      <td>5696.0</td>\n",
       "      <td>5768.0</td>\n",
       "      <td>5655.0</td>\n",
       "      <td>5766.0</td>\n",
       "      <td>5766.0</td>\n",
       "      <td>345923.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1565</td>\n",
       "      <td>2017-02-15</td>\n",
       "      <td>1595</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11981</td>\n",
       "      <td>5305.0</td>\n",
       "      <td>5314.0</td>\n",
       "      <td>5173.0</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>5228.0</td>\n",
       "      <td>215660.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1567</td>\n",
       "      <td>2016-12-15</td>\n",
       "      <td>1324</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11940</td>\n",
       "      <td>4967.0</td>\n",
       "      <td>5030.0</td>\n",
       "      <td>4897.0</td>\n",
       "      <td>4914.0</td>\n",
       "      <td>4914.0</td>\n",
       "      <td>456845.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1568</td>\n",
       "      <td>2016-11-15</td>\n",
       "      <td>932</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11918</td>\n",
       "      <td>4662.0</td>\n",
       "      <td>4870.0</td>\n",
       "      <td>4657.0</td>\n",
       "      <td>4808.0</td>\n",
       "      <td>4808.0</td>\n",
       "      <td>595696.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1570</td>\n",
       "      <td>2016-09-15</td>\n",
       "      <td>1510</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11875</td>\n",
       "      <td>4566.0</td>\n",
       "      <td>4597.0</td>\n",
       "      <td>4451.0</td>\n",
       "      <td>4519.0</td>\n",
       "      <td>4519.0</td>\n",
       "      <td>378683.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1571</td>\n",
       "      <td>2018-11-15</td>\n",
       "      <td>3903</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>12424</td>\n",
       "      <td>5506.0</td>\n",
       "      <td>5720.0</td>\n",
       "      <td>5252.0</td>\n",
       "      <td>5312.0</td>\n",
       "      <td>5312.0</td>\n",
       "      <td>601453.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1572</td>\n",
       "      <td>2016-08-15</td>\n",
       "      <td>1740</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11853</td>\n",
       "      <td>4823.0</td>\n",
       "      <td>4868.0</td>\n",
       "      <td>4769.0</td>\n",
       "      <td>4832.0</td>\n",
       "      <td>4832.0</td>\n",
       "      <td>258496.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1573</td>\n",
       "      <td>2016-07-15</td>\n",
       "      <td>2214</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11832</td>\n",
       "      <td>4339.0</td>\n",
       "      <td>4406.0</td>\n",
       "      <td>4226.0</td>\n",
       "      <td>4371.0</td>\n",
       "      <td>4371.0</td>\n",
       "      <td>296005.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1574</td>\n",
       "      <td>2016-06-15</td>\n",
       "      <td>1289</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11810</td>\n",
       "      <td>3407.0</td>\n",
       "      <td>3506.0</td>\n",
       "      <td>3303.0</td>\n",
       "      <td>3455.0</td>\n",
       "      <td>3455.0</td>\n",
       "      <td>521209.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1576</td>\n",
       "      <td>2016-04-15</td>\n",
       "      <td>3404</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11769</td>\n",
       "      <td>3894.0</td>\n",
       "      <td>3912.0</td>\n",
       "      <td>3792.0</td>\n",
       "      <td>3793.0</td>\n",
       "      <td>3793.0</td>\n",
       "      <td>679490.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1577</td>\n",
       "      <td>2016-03-15</td>\n",
       "      <td>1445</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11748</td>\n",
       "      <td>3156.0</td>\n",
       "      <td>3171.0</td>\n",
       "      <td>3084.0</td>\n",
       "      <td>3084.0</td>\n",
       "      <td>3084.0</td>\n",
       "      <td>315908.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1578</td>\n",
       "      <td>2016-02-15</td>\n",
       "      <td>1878</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11727</td>\n",
       "      <td>2667.0</td>\n",
       "      <td>2717.0</td>\n",
       "      <td>2640.0</td>\n",
       "      <td>2665.0</td>\n",
       "      <td>2665.0</td>\n",
       "      <td>622431.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1579</td>\n",
       "      <td>2016-01-15</td>\n",
       "      <td>1445</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11706</td>\n",
       "      <td>3136.0</td>\n",
       "      <td>3194.0</td>\n",
       "      <td>2924.0</td>\n",
       "      <td>2944.0</td>\n",
       "      <td>2944.0</td>\n",
       "      <td>875995.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1580</td>\n",
       "      <td>2015-12-15</td>\n",
       "      <td>1065</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11686</td>\n",
       "      <td>3252.0</td>\n",
       "      <td>3476.0</td>\n",
       "      <td>3120.0</td>\n",
       "      <td>3467.0</td>\n",
       "      <td>3467.0</td>\n",
       "      <td>425485.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1582</td>\n",
       "      <td>2018-10-15</td>\n",
       "      <td>7198</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>12401</td>\n",
       "      <td>5140.0</td>\n",
       "      <td>5140.0</td>\n",
       "      <td>4897.0</td>\n",
       "      <td>4974.0</td>\n",
       "      <td>4974.0</td>\n",
       "      <td>660560.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1583</td>\n",
       "      <td>2015-10-15</td>\n",
       "      <td>3661</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11643</td>\n",
       "      <td>2960.0</td>\n",
       "      <td>3040.0</td>\n",
       "      <td>2934.0</td>\n",
       "      <td>2997.0</td>\n",
       "      <td>2997.0</td>\n",
       "      <td>1556279.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1584</td>\n",
       "      <td>2015-09-15</td>\n",
       "      <td>1136</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11621</td>\n",
       "      <td>2540.0</td>\n",
       "      <td>2572.0</td>\n",
       "      <td>2521.0</td>\n",
       "      <td>2527.0</td>\n",
       "      <td>2527.0</td>\n",
       "      <td>563395.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1586</td>\n",
       "      <td>2015-07-15</td>\n",
       "      <td>11975</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11578</td>\n",
       "      <td>3830.0</td>\n",
       "      <td>3831.0</td>\n",
       "      <td>3725.0</td>\n",
       "      <td>3793.0</td>\n",
       "      <td>3793.0</td>\n",
       "      <td>279231.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1587</td>\n",
       "      <td>2015-06-15</td>\n",
       "      <td>39985</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11556</td>\n",
       "      <td>3750.0</td>\n",
       "      <td>3809.0</td>\n",
       "      <td>3718.0</td>\n",
       "      <td>3740.0</td>\n",
       "      <td>3740.0</td>\n",
       "      <td>275785.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>1588</td>\n",
       "      <td>2015-05-15</td>\n",
       "      <td>6994</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11535</td>\n",
       "      <td>3825.0</td>\n",
       "      <td>3825.0</td>\n",
       "      <td>3744.0</td>\n",
       "      <td>3772.0</td>\n",
       "      <td>3772.0</td>\n",
       "      <td>289612.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>1589</td>\n",
       "      <td>2015-04-15</td>\n",
       "      <td>7325</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11514</td>\n",
       "      <td>4018.0</td>\n",
       "      <td>4028.0</td>\n",
       "      <td>3957.0</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>736695.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1592</td>\n",
       "      <td>2015-01-15</td>\n",
       "      <td>1404</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11452</td>\n",
       "      <td>2680.0</td>\n",
       "      <td>2749.0</td>\n",
       "      <td>2631.0</td>\n",
       "      <td>2651.0</td>\n",
       "      <td>2651.0</td>\n",
       "      <td>620337.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>1594</td>\n",
       "      <td>2014-12-15</td>\n",
       "      <td>7413</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11432</td>\n",
       "      <td>2720.0</td>\n",
       "      <td>2880.0</td>\n",
       "      <td>2705.0</td>\n",
       "      <td>2790.0</td>\n",
       "      <td>2790.0</td>\n",
       "      <td>1194387.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>1596</td>\n",
       "      <td>2014-10-15</td>\n",
       "      <td>8285</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11389</td>\n",
       "      <td>1855.0</td>\n",
       "      <td>1877.0</td>\n",
       "      <td>1765.0</td>\n",
       "      <td>1785.0</td>\n",
       "      <td>1785.0</td>\n",
       "      <td>1599159.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>1597</td>\n",
       "      <td>2014-09-15</td>\n",
       "      <td>9426</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11367</td>\n",
       "      <td>2437.0</td>\n",
       "      <td>2445.0</td>\n",
       "      <td>2312.0</td>\n",
       "      <td>2422.0</td>\n",
       "      <td>2422.0</td>\n",
       "      <td>1255318.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>1598</td>\n",
       "      <td>2014-08-15</td>\n",
       "      <td>7353</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11347</td>\n",
       "      <td>2350.0</td>\n",
       "      <td>2400.0</td>\n",
       "      <td>2299.0</td>\n",
       "      <td>2308.0</td>\n",
       "      <td>2308.0</td>\n",
       "      <td>961921.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>1599</td>\n",
       "      <td>2014-07-15</td>\n",
       "      <td>9226</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11324</td>\n",
       "      <td>3041.0</td>\n",
       "      <td>3158.0</td>\n",
       "      <td>3012.0</td>\n",
       "      <td>3062.0</td>\n",
       "      <td>3062.0</td>\n",
       "      <td>703686.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>1601</td>\n",
       "      <td>2014-05-15</td>\n",
       "      <td>1708</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11282</td>\n",
       "      <td>4041.0</td>\n",
       "      <td>4104.0</td>\n",
       "      <td>3834.0</td>\n",
       "      <td>3948.0</td>\n",
       "      <td>3948.0</td>\n",
       "      <td>1192086.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>1602</td>\n",
       "      <td>2014-04-15</td>\n",
       "      <td>6471</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11263</td>\n",
       "      <td>4336.0</td>\n",
       "      <td>4707.0</td>\n",
       "      <td>4310.0</td>\n",
       "      <td>4345.0</td>\n",
       "      <td>4345.0</td>\n",
       "      <td>1244181.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>1604</td>\n",
       "      <td>2018-08-15</td>\n",
       "      <td>5307</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>12359</td>\n",
       "      <td>6110.0</td>\n",
       "      <td>6152.0</td>\n",
       "      <td>6064.0</td>\n",
       "      <td>6100.0</td>\n",
       "      <td>6100.0</td>\n",
       "      <td>307382.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>1606</td>\n",
       "      <td>2014-01-15</td>\n",
       "      <td>3236</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11199</td>\n",
       "      <td>6696.0</td>\n",
       "      <td>6854.0</td>\n",
       "      <td>6470.0</td>\n",
       "      <td>6694.0</td>\n",
       "      <td>6694.0</td>\n",
       "      <td>551574.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>1608</td>\n",
       "      <td>2013-11-15</td>\n",
       "      <td>7636</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11159</td>\n",
       "      <td>5750.0</td>\n",
       "      <td>5770.0</td>\n",
       "      <td>5685.0</td>\n",
       "      <td>5736.0</td>\n",
       "      <td>5736.0</td>\n",
       "      <td>306425.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>1609</td>\n",
       "      <td>2013-10-15</td>\n",
       "      <td>2799</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11136</td>\n",
       "      <td>5000.0</td>\n",
       "      <td>5169.0</td>\n",
       "      <td>4912.0</td>\n",
       "      <td>5140.0</td>\n",
       "      <td>5140.0</td>\n",
       "      <td>337516.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>1611</td>\n",
       "      <td>2013-08-15</td>\n",
       "      <td>6054</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11094</td>\n",
       "      <td>4975.0</td>\n",
       "      <td>4975.0</td>\n",
       "      <td>4791.0</td>\n",
       "      <td>4830.0</td>\n",
       "      <td>4830.0</td>\n",
       "      <td>276726.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>1612</td>\n",
       "      <td>2013-07-15</td>\n",
       "      <td>476</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11071</td>\n",
       "      <td>4440.0</td>\n",
       "      <td>4491.0</td>\n",
       "      <td>4440.0</td>\n",
       "      <td>4480.0</td>\n",
       "      <td>4480.0</td>\n",
       "      <td>172083.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>1614</td>\n",
       "      <td>2013-05-15</td>\n",
       "      <td>3476</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11029</td>\n",
       "      <td>3732.0</td>\n",
       "      <td>3798.0</td>\n",
       "      <td>3712.0</td>\n",
       "      <td>3732.0</td>\n",
       "      <td>3732.0</td>\n",
       "      <td>535897.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>1616</td>\n",
       "      <td>2013-04-15</td>\n",
       "      <td>5669</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>11008</td>\n",
       "      <td>3195.0</td>\n",
       "      <td>3202.0</td>\n",
       "      <td>3129.0</td>\n",
       "      <td>3161.0</td>\n",
       "      <td>3161.0</td>\n",
       "      <td>105264.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>1617</td>\n",
       "      <td>2013-03-15</td>\n",
       "      <td>15618</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>10989</td>\n",
       "      <td>3184.0</td>\n",
       "      <td>3192.0</td>\n",
       "      <td>3160.0</td>\n",
       "      <td>3184.0</td>\n",
       "      <td>3184.0</td>\n",
       "      <td>233281.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>1618</td>\n",
       "      <td>2013-02-15</td>\n",
       "      <td>4060</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>10969</td>\n",
       "      <td>2770.0</td>\n",
       "      <td>2795.0</td>\n",
       "      <td>2736.0</td>\n",
       "      <td>2755.0</td>\n",
       "      <td>2755.0</td>\n",
       "      <td>140435.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>1619</td>\n",
       "      <td>2013-01-15</td>\n",
       "      <td>2124</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>10946</td>\n",
       "      <td>2584.0</td>\n",
       "      <td>2661.0</td>\n",
       "      <td>2584.0</td>\n",
       "      <td>2615.0</td>\n",
       "      <td>2615.0</td>\n",
       "      <td>368968.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>1621</td>\n",
       "      <td>2012-11-15</td>\n",
       "      <td>14082</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>10906</td>\n",
       "      <td>2159.0</td>\n",
       "      <td>2233.0</td>\n",
       "      <td>2159.0</td>\n",
       "      <td>2233.0</td>\n",
       "      <td>2233.0</td>\n",
       "      <td>389773.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>1622</td>\n",
       "      <td>2012-10-15</td>\n",
       "      <td>2373</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>10883</td>\n",
       "      <td>2242.0</td>\n",
       "      <td>2331.0</td>\n",
       "      <td>2242.0</td>\n",
       "      <td>2303.0</td>\n",
       "      <td>2303.0</td>\n",
       "      <td>164997.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>1624</td>\n",
       "      <td>2012-08-15</td>\n",
       "      <td>18102</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>10841</td>\n",
       "      <td>1836.0</td>\n",
       "      <td>1858.0</td>\n",
       "      <td>1807.0</td>\n",
       "      <td>1845.0</td>\n",
       "      <td>1845.0</td>\n",
       "      <td>141296.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>1626</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>4098</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>12316</td>\n",
       "      <td>6846.0</td>\n",
       "      <td>6896.0</td>\n",
       "      <td>6674.0</td>\n",
       "      <td>6700.0</td>\n",
       "      <td>6700.0</td>\n",
       "      <td>423593.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>1627</td>\n",
       "      <td>2012-06-15</td>\n",
       "      <td>6003</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>10798</td>\n",
       "      <td>1577.0</td>\n",
       "      <td>1675.0</td>\n",
       "      <td>1558.0</td>\n",
       "      <td>1649.0</td>\n",
       "      <td>1649.0</td>\n",
       "      <td>517827.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>1628</td>\n",
       "      <td>2012-05-15</td>\n",
       "      <td>7548</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>10777</td>\n",
       "      <td>1555.0</td>\n",
       "      <td>1604.0</td>\n",
       "      <td>1551.0</td>\n",
       "      <td>1593.0</td>\n",
       "      <td>1593.0</td>\n",
       "      <td>385316.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>1630</td>\n",
       "      <td>2012-03-15</td>\n",
       "      <td>8900</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>10737</td>\n",
       "      <td>1707.0</td>\n",
       "      <td>1735.0</td>\n",
       "      <td>1675.0</td>\n",
       "      <td>1695.0</td>\n",
       "      <td>1695.0</td>\n",
       "      <td>402404.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>1631</td>\n",
       "      <td>2012-02-15</td>\n",
       "      <td>10270</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>10716</td>\n",
       "      <td>1890.0</td>\n",
       "      <td>1890.0</td>\n",
       "      <td>1843.0</td>\n",
       "      <td>1881.0</td>\n",
       "      <td>1881.0</td>\n",
       "      <td>123146.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>1633</td>\n",
       "      <td>2018-05-15</td>\n",
       "      <td>4771</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>monthly</td>\n",
       "      <td>2</td>\n",
       "      <td>12294</td>\n",
       "      <td>6384.0</td>\n",
       "      <td>6388.0</td>\n",
       "      <td>6188.0</td>\n",
       "      <td>6240.0</td>\n",
       "      <td>6240.0</td>\n",
       "      <td>494340.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    id_x        date  traffic  paid_traffic  company_id   period  source_id  \\\n",
       "1   1549  2019-01-15     5780             0           1  monthly          2   \n",
       "2   1551  2018-03-15     8689             0           1  monthly          2   \n",
       "3   1552  2018-02-15     5753             0           1  monthly          2   \n",
       "4   1553  2018-01-15    11041             0           1  monthly          2   \n",
       "5   1554  2017-12-15     7427             0           1  monthly          2   \n",
       "6   1555  2017-11-15     1982             0           1  monthly          2   \n",
       "7   1557  2017-09-15     3532             0           1  monthly          2   \n",
       "8   1558  2017-08-15     1088             0           1  monthly          2   \n",
       "9   1561  2017-06-15     1548             0           1  monthly          2   \n",
       "10  1562  2017-05-15     1473             0           1  monthly          2   \n",
       "11  1564  2017-03-15      904             0           1  monthly          2   \n",
       "12  1565  2017-02-15     1595             0           1  monthly          2   \n",
       "13  1567  2016-12-15     1324             0           1  monthly          2   \n",
       "14  1568  2016-11-15      932             0           1  monthly          2   \n",
       "15  1570  2016-09-15     1510             0           1  monthly          2   \n",
       "16  1571  2018-11-15     3903             0           1  monthly          2   \n",
       "17  1572  2016-08-15     1740             0           1  monthly          2   \n",
       "18  1573  2016-07-15     2214             0           1  monthly          2   \n",
       "19  1574  2016-06-15     1289             0           1  monthly          2   \n",
       "20  1576  2016-04-15     3404             0           1  monthly          2   \n",
       "21  1577  2016-03-15     1445             0           1  monthly          2   \n",
       "22  1578  2016-02-15     1878             0           1  monthly          2   \n",
       "23  1579  2016-01-15     1445             0           1  monthly          2   \n",
       "24  1580  2015-12-15     1065             0           1  monthly          2   \n",
       "25  1582  2018-10-15     7198             0           1  monthly          2   \n",
       "26  1583  2015-10-15     3661             0           1  monthly          2   \n",
       "27  1584  2015-09-15     1136             0           1  monthly          2   \n",
       "28  1586  2015-07-15    11975             0           1  monthly          2   \n",
       "29  1587  2015-06-15    39985             0           1  monthly          2   \n",
       "30  1588  2015-05-15     6994             0           1  monthly          2   \n",
       "31  1589  2015-04-15     7325             0           1  monthly          2   \n",
       "32  1592  2015-01-15     1404             0           1  monthly          2   \n",
       "33  1594  2014-12-15     7413             0           1  monthly          2   \n",
       "34  1596  2014-10-15     8285             0           1  monthly          2   \n",
       "35  1597  2014-09-15     9426             0           1  monthly          2   \n",
       "36  1598  2014-08-15     7353             0           1  monthly          2   \n",
       "37  1599  2014-07-15     9226             0           1  monthly          2   \n",
       "38  1601  2014-05-15     1708             0           1  monthly          2   \n",
       "39  1602  2014-04-15     6471             0           1  monthly          2   \n",
       "40  1604  2018-08-15     5307             0           1  monthly          2   \n",
       "41  1606  2014-01-15     3236             0           1  monthly          2   \n",
       "42  1608  2013-11-15     7636             0           1  monthly          2   \n",
       "43  1609  2013-10-15     2799             0           1  monthly          2   \n",
       "44  1611  2013-08-15     6054             0           1  monthly          2   \n",
       "45  1612  2013-07-15      476             0           1  monthly          2   \n",
       "46  1614  2013-05-15     3476             0           1  monthly          2   \n",
       "47  1616  2013-04-15     5669             0           1  monthly          2   \n",
       "48  1617  2013-03-15    15618             0           1  monthly          2   \n",
       "49  1618  2013-02-15     4060             0           1  monthly          2   \n",
       "50  1619  2013-01-15     2124             0           1  monthly          2   \n",
       "51  1621  2012-11-15    14082             0           1  monthly          2   \n",
       "52  1622  2012-10-15     2373             0           1  monthly          2   \n",
       "53  1624  2012-08-15    18102             0           1  monthly          2   \n",
       "54  1626  2018-06-15     4098             0           1  monthly          2   \n",
       "55  1627  2012-06-15     6003             0           1  monthly          2   \n",
       "56  1628  2012-05-15     7548             0           1  monthly          2   \n",
       "81  1630  2012-03-15     8900             0           1  monthly          2   \n",
       "82  1631  2012-02-15    10270             0           1  monthly          2   \n",
       "83  1633  2018-05-15     4771             0           1  monthly          2   \n",
       "\n",
       "     id_y    open    high     low   close  adjusted_close     volume  \n",
       "1   12464  2992.0  2992.0  2669.0  2860.0          2860.0  1032066.0  \n",
       "2   12254  7504.0  7770.0  7504.0  7730.0          7730.0   270632.0  \n",
       "3   12234  7164.0  7288.0  7162.0  7286.0          7286.0   366737.0  \n",
       "4   12211  6888.0  6916.0  6695.0  6838.0          6838.0   196500.0  \n",
       "5   12193  6206.0  6223.0  5935.0  6200.0          6200.0   263194.0  \n",
       "6   12171  5656.0  5726.0  5642.0  5705.0          5705.0   327264.0  \n",
       "7   12128  5574.0  5700.0  5518.0  5549.0          5549.0   582871.0  \n",
       "8   12106  5890.0  5986.0  5853.0  5917.0          5917.0    87725.0  \n",
       "9   12063  6101.0  6132.0  5988.0  6046.0          6046.0   368754.0  \n",
       "10  12041  6155.0  6184.0  6099.0  6154.0          6154.0   340168.0  \n",
       "11  12001  5696.0  5768.0  5655.0  5766.0          5766.0   345923.0  \n",
       "12  11981  5305.0  5314.0  5173.0  5228.0          5228.0   215660.0  \n",
       "13  11940  4967.0  5030.0  4897.0  4914.0          4914.0   456845.0  \n",
       "14  11918  4662.0  4870.0  4657.0  4808.0          4808.0   595696.0  \n",
       "15  11875  4566.0  4597.0  4451.0  4519.0          4519.0   378683.0  \n",
       "16  12424  5506.0  5720.0  5252.0  5312.0          5312.0   601453.0  \n",
       "17  11853  4823.0  4868.0  4769.0  4832.0          4832.0   258496.0  \n",
       "18  11832  4339.0  4406.0  4226.0  4371.0          4371.0   296005.0  \n",
       "19  11810  3407.0  3506.0  3303.0  3455.0          3455.0   521209.0  \n",
       "20  11769  3894.0  3912.0  3792.0  3793.0          3793.0   679490.0  \n",
       "21  11748  3156.0  3171.0  3084.0  3084.0          3084.0   315908.0  \n",
       "22  11727  2667.0  2717.0  2640.0  2665.0          2665.0   622431.0  \n",
       "23  11706  3136.0  3194.0  2924.0  2944.0          2944.0   875995.0  \n",
       "24  11686  3252.0  3476.0  3120.0  3467.0          3467.0   425485.0  \n",
       "25  12401  5140.0  5140.0  4897.0  4974.0          4974.0   660560.0  \n",
       "26  11643  2960.0  3040.0  2934.0  2997.0          2997.0  1556279.0  \n",
       "27  11621  2540.0  2572.0  2521.0  2527.0          2527.0   563395.0  \n",
       "28  11578  3830.0  3831.0  3725.0  3793.0          3793.0   279231.0  \n",
       "29  11556  3750.0  3809.0  3718.0  3740.0          3740.0   275785.0  \n",
       "30  11535  3825.0  3825.0  3744.0  3772.0          3772.0   289612.0  \n",
       "31  11514  4018.0  4028.0  3957.0  4000.0          4000.0   736695.0  \n",
       "32  11452  2680.0  2749.0  2631.0  2651.0          2651.0   620337.0  \n",
       "33  11432  2720.0  2880.0  2705.0  2790.0          2790.0  1194387.0  \n",
       "34  11389  1855.0  1877.0  1765.0  1785.0          1785.0  1599159.0  \n",
       "35  11367  2437.0  2445.0  2312.0  2422.0          2422.0  1255318.0  \n",
       "36  11347  2350.0  2400.0  2299.0  2308.0          2308.0   961921.0  \n",
       "37  11324  3041.0  3158.0  3012.0  3062.0          3062.0   703686.0  \n",
       "38  11282  4041.0  4104.0  3834.0  3948.0          3948.0  1192086.0  \n",
       "39  11263  4336.0  4707.0  4310.0  4345.0          4345.0  1244181.0  \n",
       "40  12359  6110.0  6152.0  6064.0  6100.0          6100.0   307382.0  \n",
       "41  11199  6696.0  6854.0  6470.0  6694.0          6694.0   551574.0  \n",
       "42  11159  5750.0  5770.0  5685.0  5736.0          5736.0   306425.0  \n",
       "43  11136  5000.0  5169.0  4912.0  5140.0          5140.0   337516.0  \n",
       "44  11094  4975.0  4975.0  4791.0  4830.0          4830.0   276726.0  \n",
       "45  11071  4440.0  4491.0  4440.0  4480.0          4480.0   172083.0  \n",
       "46  11029  3732.0  3798.0  3712.0  3732.0          3732.0   535897.0  \n",
       "47  11008  3195.0  3202.0  3129.0  3161.0          3161.0   105264.0  \n",
       "48  10989  3184.0  3192.0  3160.0  3184.0          3184.0   233281.0  \n",
       "49  10969  2770.0  2795.0  2736.0  2755.0          2755.0   140435.0  \n",
       "50  10946  2584.0  2661.0  2584.0  2615.0          2615.0   368968.0  \n",
       "51  10906  2159.0  2233.0  2159.0  2233.0          2233.0   389773.0  \n",
       "52  10883  2242.0  2331.0  2242.0  2303.0          2303.0   164997.0  \n",
       "53  10841  1836.0  1858.0  1807.0  1845.0          1845.0   141296.0  \n",
       "54  12316  6846.0  6896.0  6674.0  6700.0          6700.0   423593.0  \n",
       "55  10798  1577.0  1675.0  1558.0  1649.0          1649.0   517827.0  \n",
       "56  10777  1555.0  1604.0  1551.0  1593.0          1593.0   385316.0  \n",
       "81  10737  1707.0  1735.0  1675.0  1695.0          1695.0   402404.0  \n",
       "82  10716  1890.0  1890.0  1843.0  1881.0          1881.0   123146.0  \n",
       "83  12294  6384.0  6388.0  6188.0  6240.0          6240.0   494340.0  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_sales_traffic = pd.merge(record_traffic, record_eod, on=['date','company_id'],how=\"inner\")\n",
    "\n",
    "# df_sales_traffic.apply(pd.value_counts).fillna(method='bfill')\n",
    "df_sales_traffic[df_sales_traffic.period=='monthly']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Text(0, 0.5, 'Monthly Sales')"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZAAAAEKCAYAAAA8QgPpAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDMuMC4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvnQurowAAIABJREFUeJzt3X+YnGV97/H3J8kCG8RswIiwBBOUQsEfBLeATU8rYAmgBQ7VFmxrtHg4rVhLORdtqLYEtYdYPKJeVjQVvMAqP0QNqahpDgHbo/IjYfkppERAyEIhmgQtpLhJvueP554wO5mZfWZ2ntmZnc/ruuaamXueeebeMDzfuX99b0UEZmZmjZo22RUwM7Pu5ABiZmZNcQAxM7OmOICYmVlTHEDMzKwpDiBmZtYUBxAzM2tKoQFE0l9IelDSA5KulbSXpPmS7pD0iKTrJe2Rjt0zPd+QXp9Xdp6LUvl6SYuKrLOZmeVTWACRNAh8EBiKiNcB04GzgI8Dl0fEocAW4Jz0lnOALRHxWuDydBySjkjvOxI4GficpOlF1dvMzPKZ0Ybz90saBWYCTwMnAO9Kr18NLAWuAE5PjwFuBD4rSan8uoh4EXhM0gbgGOCHtT70Fa94RcybN6/Vf4uZ2ZS2bt26n0bEnLzHFxZAImJE0ieAJ4BtwL8A64CtEbE9HbYRGEyPB4En03u3S3oO2C+V31526vL3VDVv3jzWrl3bqj/FzKwnSPpJI8cX2YU1m6z1MB84ENgbOKXKoaVkXKrxWq3yys87V9JaSWs3bdrUXKXNzCy3IgfR3wo8FhGbImIU+Abw68CApFLL5yDgqfR4IzAXIL0+C9hcXl7lPbtExPKIGIqIoTlzcrfAzMysSUUGkCeA4yTNTGMZJwI/Am4F3pGOWQzclB6vTM9Jr6+JLFXwSuCsNEtrPnAocGeB9TYzsxyKHAO5Q9KNwN3AdmAYWA7cDFwn6WOp7Mr0liuBL6dB8s1kM6+IiAcl3UAWfLYD50XEjqLqbWZm+Wgq7gcyNDQUHkQ3M2uMpHURMZT3+KKn8doErBge4bJV63lq6zYOHOjnwkWHccaCuhPQzMzaxgGkQ60YHuGib9zPttGst25k6zYu+sb9AA4iZtYRnAurQ122av2u4FGybXQHl61aP0k1MjMbywGkQz21dVtD5WZm7eYA0qEOHOhvqNzMrN0cQDrUhYsOo79vbM7I/r7pXLjosEmqkZnZWB5E71ClgXLPwjKzTuUA0sHOWDDogGFmHctdWGZm1hQHEDMza4oDiJmZNcUBxMzMmuIAYmZmTXEAMTOzpjiAmJlZU7wOpE2cmt3MphoHkDZwanYzm4rchdUGTs1uZlORA0gbODW7mU1FDiBt4NTsZjYVOYC0gVOzm9lU5EH0NnBqdjObihxA2sSp2c1sqimsC0vSYZLuKbv9XNL5kvaVtFrSI+l+djpekj4jaYOk+yQdXXauxen4RyQtLqrOZmaWX2EBJCLWR8RREXEU8CbgBeCbwBLglog4FLglPQc4BTg03c4FrgCQtC9wMXAscAxwcSnomJnZ5GnXIPqJwI8j4ifA6cDVqfxq4Iz0+HTgmsjcDgxIOgBYBKyOiM0RsQVYDZzcpnqbmVkN7QogZwHXpsf7R8TTAOn+lal8EHiy7D0bU1mtcjMzm0SFBxBJewCnAV8b79AqZVGnvPJzzpW0VtLaTZs2NV5RMzNrSDtaIKcAd0fEM+n5M6lrinT/bCrfCMwte99BwFN1yseIiOURMRQRQ3PmzGnxn2BmZpXaEUDO5qXuK4CVQGkm1WLgprLyd6fZWMcBz6UurlXASZJmp8Hzk1KZJSuGR1i4bA3zl9zMwmVrWDE8MtlVMrMeUOg6EEkzgd8G/mdZ8TLgBknnAE8A70zl3wZOBTaQzdh6L0BEbJb0UeCudNxHImJzkfXuJs70a2aTRRG7DSd0vaGhoVi7du1kV6MtFi5bw0iVpIyDA/18f8kJk1AjM+tWktZFxFDe450Lq8s506+ZTRanMmmhydh18MCB/qotEGf6NbOiOYBMQHnAmNXfx/O/3M7ojqxLsF1jERcuOmzMGAg406+ZtYe7sJpUGrwe2bqNALZuG90VPErasevgGQsGufTM1zM40I/Ixj4uPfP1HkA3s8K5BdKkatvUVtOOsQhn+jWzyeAWSJPyBgaPRZjZVOUA0qQ8gcFjEWY2lTmANKnaNrV908TsmX0eizCznuAxkCZ5m1oz63UOIBPgwWsz62XuwjIzs6Y4gJiZWVMcQMzMrCkOIGZm1hQHEDMza4oDiJmZNcXTeAsyGandzczayQGkAN5m1sx6gQNIAapl6i2ldq8WQNxaMbNu5ABSR7MX9ka2mXVrxcy6lQfRa6jcMKp0YV8xPDLue2tl6q1WXq+1YmbWyRxAapjIhb1apl6A51/cvlsAaqS1YmbWSRxAapjIhb20zezsmX1jyrduG92tFdNIa8XMrJMUGkAkDUi6UdLDkh6S9GZJ+0paLemRdD87HStJn5G0QdJ9ko4uO8/idPwjkhYXWeeSgYqL/3jllc5YMMjMPXYfYqpsxVRrrXgjKjPrBkW3QD4NfDciDgfeCDwELAFuiYhDgVvSc4BTgEPT7VzgCgBJ+wIXA8cCxwAXl4JOkSIaK68mTyum1FoZHOj3RlRm1lUKm4Ul6eXAbwLvAYiIXwK/lHQ68JZ02NXAbcBfAacD10REALen1ssB6djVEbE5nXc1cDJwbVF1B3hu22hD5dUcONDPSJUgUtk95X1FzKwbFdkCOQTYBHxJ0rCkL0raG9g/Ip4GSPevTMcPAk+WvX9jKqtVXqhWjE24e8rMprIiA8gM4GjgiohYADzPS91V1ahKWdQpH/tm6VxJayWt3bRpUzP13WXF8AjPv7h9t/JGL/7unjKzqazIhYQbgY0RcUd6fiNZAHlG0gER8XTqonq27Pi5Ze8/CHgqlb+lovy2yg+LiOXAcoChoaEGRirGqlzYVzJ7Zh8X/86RDV/83T1lZlNVYS2QiPgP4ElJpZ/sJwI/AlYCpZlUi4Gb0uOVwLvTbKzjgOdSF9cq4CRJs9Pg+UmprBDV1n8AzNxjhgOBmVmZolOZ/BnwFUl7AI8C7yULWjdIOgd4AnhnOvbbwKnABuCFdCwRsVnSR4G70nEfKQ2oF8EL+8zM8ik0gETEPcBQlZdOrHJsAOfVOM9VwFWtrV11eWdOmZn1Oq9Er3D84XN2G7Vvx8ypFcMjLFy2hvlLbmbhsjW5cm6ZmU0mB5AyK4ZH+Pq6kTFTvAQcffAsLlu1vrCL+0QSN5qZTRYHkDLVBtAD+MGPNxd6cXdGXjPrRg4gZWoNlFfOCW71xd0D92bWjRoKIGkq7RuKqsxka2SgvJUXd2fkNbNuNG4AkXSbpJenpIb3kqUm+WTxVWu/aqlHqi2Dh9Ze3J3yxMy6UZ5pvLMi4ueS3gd8KSIulnRf0RWbDKWFguXb2B5/+By+vm5kzBhF+cW9FfuZV/tc74tuZp0uTwCZkVKO/B7woYLrM+mqpR4ZevW+VS/urdzP3ClPzKzb5AkgHyFLHfL9iLhL0iHAI8VWq7PUurjXmz3lYGBmU924ASQivgZ8rez5o8DvFlmpbuHZU2bWy/IMov+KpFskPZCev0HSh4uvWufz7Ckz62V5pvH+I3ARMAoQEfcBZxVZqW7h2VNm1svyjIHMjIg7pTETWnffbakHefaUmfWyPAHkp5JeQ1qQLekdwNOF1qqLePaUmfWqPAHkPLKd/g6XNAI8BvxhobXqQq1YD2Jm1k3yzMJ6FHirpL2BaRHxi+Kr1V1auR7EzKxb1Awgki6oUQ5AREzJdCbN8HoQM+tF9Vog+7StFh0sT9eU14OYWS+qGUAi4pJ2VqQT5e2a8ja4ZtaL8iwk3EvSeZI+J+mq0q0dlZtseTd68noQM+tFeRYSfhl4FbAI+B5wENATA+m1uqBGtm4bs385wKVnvp7BgX4EDA70c+mZr/f4h5lNaXmm8b42It4p6fSIuFrSV8mSK055tbqmBLvKS91al575er6/5IQ219DMbPLkaYGMpvutkl4HzALmFVajDlJrg6mit7g1M+sGeQLIckmzgb8BVgI/Aj5eaK06xBkLBnfrmqoMHiWecWVmvSbPQsIvpoffAw5p5OSSHicbL9kBbI+IobQ17vVkrZjHgd+LiC3KFph8GjgVeAF4T0Tcnc6zGChlAP5YRFzdSD0mojJVycJlazzjysyMOi0QSb8j6dVlz/9W0r2SVkqa38BnHB8RR0XEUHq+BLglIg4FbknPAU4BDk23c4Er0ufuC1wMHAscA1ycWkSTotUzrlYMj4wZkF8xPNKKapqZFa5eF9bfAZsAJL2dLP/VH5N1Y31+Ap95OlBqQVwNnFFWfk1kbgcG0la6i4DVEbE5IrYAq4GTJ/D5E1KtW6vZGVeldSYjW7cRvDQg7yBiZt2gXhdWRMQL6fGZwJURsQ5YJ+n9Oc8fwL9ICuALEbEc2D8ink4f8LSkV6ZjB4Eny967MZXVKh9D0rlkLRcOPvjgnNWrrd4K9FZl4HUKFDPrZvUCiCS9jGw84kTgc2Wv7ZXz/Asj4qkUJFZLerje51UpizrlYwuy4LQcYGhoqNZYdy7tSo7oFChm1s3qdWF9CrgHWAs8FBFrASQtIOd+IBHxVLp/Fvgm2RjGM6lrinT/bDp8IzC37O0HAU/VKS9M3hXoE+Utcc2sm9UMIBFxFfBbwDlkM6NK/gN473gnlrS3pH1Kj4GTgAfIxlAWp8MWAzelxyuBdytzHPBc6upaBZwkaXYaPD+JghcyVptlVSqfyPhE5YD58YfPcQoUM+tadafxRsQIMFJRlnc3wv2Bb6b07zOAr0bEdyXdBdwg6RzgCeCd6fhvkwWqDWTdZu9Nn7dZ0keBu9JxH4mIzTnr0LAVwyNVFwuWNNuVVa1b7OvrRvjdNw1y68ObvBGVmXUdRUxouKAjDQ0Nxdq1a5t6b611HuUGB/obTltS67zNnMvMrAiS1pUtuRhXnpXoPSXPAHYzg9weMDezqSZPOvdPSDqyHZXpBHkGsJsZ5PaAuZlNNXlaIA+T5cO6Q9KfSJpVdKUmU7WV5uWaHeT2niFmNtWMG0Ai4osRsRB4N1n+qvskfVXS8UVXbjJUrjQf6O9j9sy+Ca86b+UKdjOzTpBrEF3SdODtZDOj5gI3AL8BPB8RZxVawyZMZBDdzKxXNTqIPm42XkmfBE4jS3z4vyPizvTSxyV5Ewwzsx6VZ0fCB4APl+XFKndMi+tjZmZdomYAkXR0engPcHhaELhLRNwdEc8VWLdJVy+hoplZr6vXAvk/dV4LYMqtfisPGAMz+/jP/9rO6M5sjKiohIpmZt2qZgCJiCk5y6qWylQjW14Y3e0Yp1o3M3tJnjEQJP062RTeXcdHxDUF1WlSVMvAW41XjpuZZfKsRP8y8Amyabu/lm65p3l1i7yBIcBbz5qZka8FMgQcEVMx62KZAwf6x02iWDLR8RAPzpvZVJAnlckDwKuKrshkq5ZqpG+6GOjvq3p8sxtMeR90M5sq6k3j/WeyHpt9gB9JuhN4sfR6RJxWfPXap9QCqNYymL/k5qr7gzQzHuJ90M1sqqjXhfWJttWiQ5yxYLDqRbxW91YzmXSd1t3Mpop6W9p+LyK+B5xaelxe1r4qTr5WZtJ1WnczmyryjIH8dpWyU1pdkU7Wyky6TutuZlNFvTGQPwXeDxwi6b6yl/YBflB0xTpNre6tZs4D1cdazMy6Sc107mnjqNnApcCSspd+ERGb21C3pjmdu5lZ41qWzj0lSnwOODvtB7J/Ov5lkl4WEU9MuLZmZta18uwH8gFgKfAMsDMVB/CG4qrV3bxQ0Mx6QZ6V6OcDh0XEz4quzFRQmZRxvFXrDjZm1q3yzMJ6kqwrqymSpksalvSt9Hy+pDskPSLpekl7pPI90/MN6fV5Zee4KJWvl7So2bq0Q72FgpWqrUr/i+vv4cMr7m9Tbc3MmpcngDwK3JYu4heUbg18xp8DD5U9/zhweUQcCmwBzknl5wBbIuK1wOXpOCQdAZwFHAmcDHwujcl0pEYWClYLNgF85fYnnNrEzDpeni6sJ9Jtj3TLTdJBwNuAvwMuULat4QnAu9IhV5ONr1wBnJ4eA9wIfDYdfzpwXUS8CDwmaQPZVro/bKQuzWq0i6nWqvW9+qbxmou+zY4IpkucfezcmsEmwKlNzKzjjRtAIuISAEn7ZE/jPxs4/6eAvyRbOwKwH7A1Iran5xuB0lVykKy7jIjYLum5dPwgcHvZOcvfs4ukc4FzAQ4++OAGqlhbo+MZkC0ULH8PZM28baM7dz3fEcE/3f4E/X3TxpSXc2oTM+t0efYDeZ2kYbKsvA9KWifpyBzvezvwbESsKy+ucmiM81q997xUELE8IoYiYmjOnDnjVS+XRsYzSqqtWq/6FwD/Nbqz1ktObWJmDVkxPMLCZWuYv+Tmtu1ZlKcLazlwQUTcCiDpLcA/Ar8+zvsWAqdJOhXYC3g5WYtkQNKM1Ao5CHgqHb8RmAtslDQDmAVsLisvKX9PoZpNfFi5an3ekpurHhfAwtfsyw9+vHlMRHRqEzNrRDO9Ja2QZxB971LwAIiI24C9x3tTRFwUEQdFxDyyQfA1EfEHwK3AO9Jhi4Gb0uOV6Tnp9TVpE6uVwFlpltZ84FDgzhz1nrBWJT6crlrtDPjR07/g8t8/qiV5tsysNzXTW9IKeVogj0r6G+DL6fkfAo9N4DP/CrhO0seAYeDKVH4l8OU0SL6ZLOgQEQ9KugH4EbAdOC8ixt+8vAWqjWdUtg7yDLKffexc/un26gv3t7ww2rI8W+W8vsSsd0zWNhE1c2HtOkCaDVxCtie6gH8FlkbElkJrNgGtzIVV70Jc2WyELMBUa0HU6saC7B+1lRf5RuplZt1v4bI1VWd/Dg708/0lJ+Q+T8tyYZWkQPHB3DWYYuq1DhrZXXCgv4+t20arnqd8a9vSZ06Edz3sPW5x9rbjD59TtZfj+MNbM6Golnrp3FfWe+NU29K2GdUifq3ypacdyfnX31P3fK26yBfdnPXFqrNM1gCqdY6vr9tYs/xjZ7y+sM+t1wJ5M9m6jGuBO6g5GbV3TZfYUaULsNqg+RkLBscNINCai3wrt+Ct5ItV53GL02qtJ6tV3ir1ZmG9Cvhr4HXAp8l2Jvxp2ba2Pa9a8KhVvmJ4JFcEbsVFvshdDydrtofVNlkDqGb19kTfERHfjYjFwHHABrKcWH/Wttp1uMEaF/tq5ZetWr/76scKrbrIt3IL3kq+WHWeVk03N2tU3UF0SXuS5bI6G5gHfAb4RvHV6g55pvmW1LvAtnoWFrRuC95KRXaPWXMa+R6atVK9QfSrybqvvgNcEhEPtK1WXaKR/c1rXXgbnWY32SZrtofV1sj30KyV6rVA/gh4HvgV4IN6aWBYZEkVX15w3bpC3l/6U+VX4q0Pb2qo3NqjqBandYdaywQG+vsK/dx6YyDTImKfdHt52W0fB4/GFTku0U4eAzHrPEtPO5K+aWOn6fRNE0tPGzfv7YTkSWXSc1YMj3DJPz/IlheyiD7Q38fS046c8MV+KvxK9BiIWeeZrG5MB5AKK4ZHuPDGexnd8dKcqa3bRrnwa/cCXuswVbrizKaayfiB6gBS4bJV68cEj5LRndF1C7OKWDHuAVszK3EAqVCvL7+b+vmLXDE+FbrizGzi8uwH0lPq9eVPVj9/MzuNecW4mRXNLZAKFy46bLcxEMhmNEy0n7+ZLqUVwyNc+LV7Gd2Z1Wdk67Zc4zGeLWU2MU4aOj4HkAqlL0grZ2GtGB5h6coHx8zTztultHTlg7uCR8nozmDpygfrvs+zpcya56Sh+Yy7oVQ3auWGUhNVbVZXudkz+5i5x4yav3LqbUT1+LK31fyVVNSmUv5VZr2g1gZN0yV2RkzZ737LN5SyifnQN++vGTwg29K21NIZ2bqN86+/J1fad8j3K6mVF3v/KrNeUaurt5Rp29/9jFsgBVoxPJI7GDSq1HIpKr9WtZbGZavW9+SvMus9tVoglbotl9143ALpIEXNeOqbLi7+nSP5ixrBaWTrNuYvuZlZ/X2M7tjJ87/MWgx5x3JqtTQqZ3WV+FeZTTXVFsxW0+uTUjyNt0B5fsE0opRD67J3vJEzFgzWHRAPshX0peABL62oH28acK0pwNV2WqzkqcI2FVTmrqv13e/1SSlugdQxkQHj0g6EreognC7x40tPHVOW91dSucoV9dX+xnr9v/190/2rzHpC+YLZWpNSej2Fj1sgNZS+MCNbtxG81D2TZxEf5NuBsBF7zNBuCwkrfyXlVWoZ1fobZ9VIAV3KIFxrJ8aSXv9VZlPPVMmm3WqFtUAk7QX8K7Bn+pwbI+JiSfOB64B9gbuBP4qIX6bdD68B3gT8DPj9iHg8nesi4BxgB/DBiFhVVL1L6q3kzvOladWv8GmpGbNtdCew+zhD+a+kvAN/4qWWR7W/ca++abu1NEq/tkqfN3/JzTUDZK//KrOpySl8dldkC+RF4ISIeCNwFHCypOOAjwOXR8ShwBaywEC63xIRrwUuT8ch6QjgLOBI4GTgc5KmF1hvoLGV3NVSjQzMbH4jl8GBfh5f9jYeX/Y2DpjVz86K12uNM1y46LBc/0GDl6b3VrP1hdFxf23VamUM9Pf5fzKzHlFYCySy+cH/mZ72pVsAJwDvSuVXA0uBK4DT02OAG4HPKtsG8XTguoh4EXhM0gbgGOCHRdUd8q/krjZj6cKv3btrZlIzyreHbSSQrf3J5t2CTS2lMY9af+N4v7ZqpXUvegMbM+schY6BSJou6R7gWWA18GNga0RsT4dsBEpXqUHgSYD0+nPAfuXlVd5TmFp7fFeWV+sGGt0Z7KwTP/r7pvOHxx1c8/Wb73t61+Nav/SrlV97x5NVjqyuNGDe3ze2MZd3YNB9wmZW6CysiNgBHCVpAPgm8KvVDkv31caBo075GJLOBc4FOPjg2hfnvMbb+ztredy3a2yiEXv1TWPo1fvyT7c/UfX10sp0aGwDp7ytnvLxDGh+tbr7hM16W1um8UbEVkm3AccBA5JmpFbGQcBT6bCNwFxgo6QZwCxgc1l5Sfl7yj9jObAcspXoE61zva6jFcMjXHD9Pbm7iypteWGUC2+8N9exrU5JMl0a01JwEDCzZhU5C2sOMJqCRz/wVrKB8VuBd5DNxFoM3JTesjI9/2F6fU1EhKSVwFclfRI4EDgUuLOoepfUGx+4bNX6poNHSb38WAMV02hbeZHfGeGAYWYtUeQYyAHArZLuA+4CVkfEt4C/Ai5Ig+H7AVem468E9kvlFwBLACLiQeAG4EfAd4HzUtdYoeqND7RyoVzftN176N7+xgOaOtd46zPAazTMrHUKCyARcV9ELIiIN0TE6yLiI6n80Yg4JiJeGxHvTLOriIj/Ss9fm15/tOxcfxcRr4mIwyLiO0XVuVy9QeJWXoR//5i5uw3yfH3dSO4Fi+WqBb1yXjlrZq3kbLxNmOgYSMlAfx9779najLrlqUlm9fchZes6nCnXzMbjbLxtULoIjzcLa7pUc2bUNGDpabUz6jbbTeZBcTNrFweQHGolVSxdqGul9dgZsWvXwFpb5NbaY8NjFWbW6RxA6qi88EP1PS/GW7Ver1XQyDoPM7NO4my8NZRSlJQHj5JtoztYuvLBXc+9otvMepFbIDVUS1FSbuu2UVYMj4xpXXhFt5n1EgeQGvIMYpendncQMLNe4y6sKlYMjzAtx/at3nnPzHqZA0iF0thHnsSEnillZr3MAaTCeGMfJZ4pZWa9zmMgFep1Sw0O9LckI24zaq1FMTObLA4gFWqt6Wg2tUgrVNv1sHItiplZu7kLq8JE1nQUpVq3Wq190c3M2sUtkAqt3sCpFRrZF93MrF0cQKqotaajqHGI8c47XqoUM7PJ4C6snErjECNbtxG8NA7RzL4djZ63E7vVzMwcQHIqahwiz3mLype1YniEhcvWMH/JzSxctmbCwdDMeou7sHIqahwi73lbnSrFM7vMbKLcAsmp1njDRMchijrveDyzy8wmygEkp6LGISZrfMMzu8xsotyFlVNR03sna9qwZ3aZ2UQpciQN7DZDQ0Oxdu3aya5GR6scA4Gs5ePNrMx6l6R1ETGU93i3QHpUJy6YNLPuUlgAkTQXuAZ4FbATWB4Rn5a0L3A9MA94HPi9iNgiScCngVOBF4D3RMTd6VyLgQ+nU38sIq4uqt69xJtgmdlEFDmIvh34XxHxq8BxwHmSjgCWALdExKHALek5wCnAoel2LnAFQAo4FwPHAscAF0uaXWC9zcwsh8ICSEQ8XWpBRMQvgIeAQeB0oNSCuBo4Iz0+HbgmMrcDA5IOABYBqyNic0RsAVYDJxdVbzMzy6ct03glzQMWAHcA+0fE05AFGeCV6bBB4Mmyt21MZbXKzcxsEhUeQCS9DPg6cH5E/LzeoVXKok555eecK2mtpLWbNm1qrrJmZpZboQFEUh9Z8PhKRHwjFT+TuqZI98+m8o3A3LK3HwQ8Vad8jIhYHhFDETE0Z86c1v4hHch5rMxsshUWQNKsqiuBhyLik2UvrQQWp8eLgZvKyt+tzHHAc6mLaxVwkqTZafD8pFTWs4rKDDyR+jiYmfWeIteBLAT+CLhf0j2p7K+BZcANks4BngDemV77NtkU3g1k03jfCxARmyV9FLgrHfeRiNhcYL07Xr08Vu2eluukjGa9q7AAEhH/j+rjFwAnVjk+gPNqnOsq4KrW1a6zjbfBVCflseqkYGZm7eVkih0mT/fUZGXwraaTgpmZtZcDSIfJk2a9k3Yo7KRgZmbt5QDSYWr9ch/Zum3XAHVROxQ2o5OCmZm1l5MpttF4YxtQO8067D5A3QljDE7KaNa7nM69TfKmT692XKXBgX6+v+SEQutrZr3H6dw71HizlcpbJwMz+9hzxjS2bhutei4PUJtZJ/AYSJvUm61UOfNqywujvLh9J7Nn9lV9jweozawTOIC0Sb3ZSrVaJxF4gNrMOpYDSJvUm61Uq3Xy3LbRjpltZWZWyWMgbVJvttJlq9ZXnXl14EB/x8y2MjOr5ADSRrWCwYWLDqs6Q8utP5rbAAAIZklEQVRdVWbWyRxAOoDXUphZN3IA6RDuqjKzbuNBdDMza4oDiJmZNcUBxMzMmuIAYmZmTXEAMTOzpkzJbLySNgE/afBtrwB+WkB1itRtde62+kL31dn1LV631bmR+r46IubkPfGUDCDNkLS2kTTGnaDb6txt9YXuq7PrW7xuq3OR9XUXlpmZNcUBxMzMmuIA8pLlk12BJnRbnbutvtB9dXZ9i9dtdS6svh4DMTOzprgFYmZmTXEAASSdLGm9pA2SlrT5s6+S9KykB8rK9pW0WtIj6X52Kpekz6R63ifp6LL3LE7HPyJpcVn5myTdn97zGUmaYH3nSrpV0kOSHpT0511Q570k3Snp3lTnS1L5fEl3pM+/XtIeqXzP9HxDen1e2bkuSuXrJS0qK2/5d0jSdEnDkr7VJfV9PP13u0fS2lTWyd+LAUk3Sno4fZ/f3Kn1lXRY+nct3X4u6fxJr29E9PQNmA78GDgE2AO4FziijZ//m8DRwANlZX8PLEmPlwAfT49PBb4DCDgOuCOV7ws8mu5np8ez02t3Am9O7/kOcMoE63sAcHR6vA/w78ARHV5nAS9Lj/uAO1JdbgDOSuWfB/40PX4/8Pn0+Czg+vT4iPT92BOYn74304v6DgEXAF8FvpWed3p9HwdeUVHWyd+Lq4H3pcd7AAOdXN+yek8H/gN49WTXty0XyU6+pX+wVWXPLwIuanMd5jE2gKwHDkiPDwDWp8dfAM6uPA44G/hCWfkXUtkBwMNl5WOOa1HdbwJ+u1vqDMwE7gaOJVtcNaPyewCsAt6cHs9Ix6nyu1E6rojvEHAQcAtwAvCt9PkdW990nsfZPYB05PcCeDnwGGkcuNPrW1HHk4Dvd0J93YUFg8CTZc83prLJtH9EPA2Q7l+ZymvVtV75xirlLZG6ShaQ/aLv6Dqn7qB7gGeB1WS/wLdGxPYqn7Orbun154D9mvhbJuJTwF8CO9Pz/Tq8vgAB/IukdZLOTWWd+r04BNgEfCl1E35R0t4dXN9yZwHXpseTWl8HkOyXWqVOnZpWq66Nlk+8ItLLgK8D50fEz+sd2mDdCqlzROyIiKPIftkfA/xqnc+Z1DpLejvwbESsKy+u8xkd8W8MLIyIo4FTgPMk/WadYye7zjPIuo6viIgFwPNkXUC1THZ9s0pk416nAV8b79AG69VUfR1Askg7t+z5QcBTk1SXkmckHQCQ7p9N5bXqWq/8oCrlEyKpjyx4fCUivtENdS6JiK3AbWT9wgOSSrtyln/Orrql12cBm5v4W5q1EDhN0uPAdWTdWJ/q4PoCEBFPpftngW+SBepO/V5sBDZGxB3p+Y1kAaVT61tyCnB3RDyTnk9ufVvRJ9fNN7JfIo+SDTKWBhSPbHMd5jF2DOQyxg6M/X16/DbGDozdmcr3JevPnZ1ujwH7ptfuSseWBsZOnWBdBVwDfKqivJPrPAcYSI/7gX8D3k72K658UPr96fF5jB2UviE9PpKxg9KPkg1oFvYdAt7CS4PoHVtfYG9gn7LHPwBO7vDvxb8Bh6XHS1NdO7a+6ZzXAe/tlP/v2naR7OQb2YyFfyfrF/9Qmz/7WuBpYJTsV8A5ZP3XtwCPpPvSf2AB/5DqeT8wVHaePwY2pFv5F2wIeCC957NUDBo2Ud/fIGva3gfck26ndnid3wAMpzo/APxtKj+EbObJBrKL856pfK/0fEN6/ZCyc30o1Ws9ZbNUivoOMTaAdGx9U93uTbcHS+fs8O/FUcDa9L1YQXZB7eT6zgR+BswqK5vU+nolupmZNcVjIGZm1hQHEDMza4oDiJmZNcUBxMzMmuIAYmZmTXEAsSlNUkj6ctnzGZI2KWW4beJ8A5LeX/b8LbXOJek2Sbn2olaWRfceSU+k+pWyrs5roG5HKMs4PCxpnqQLUpbZayT9d0kX5j2XWR4zxj/ErKs9D7xOUn9EbCNL/DgygfMNkGW//VwrKlcSEccCSHoP2Zz9D1Q7TtL0iNhR4zRnAjdGxEfTse8Hjo+IJ2scbzYhboFYL/gO2cpcyLKMlhLRlfarWJH2TLhd0htS+VJle7XcJulRSR9Mb1kGvCa1Di5LZS8r21fiK5X7KEg6R9LlZc//h6RP5ql4ajFtlfQxSXcCx0i6RNJdkh6Q9Pm098NpwAeAP5H0fyV9ETgY+LakD0p6n6RPpXO+StJN6W++V9KxDf57mgEOINYbrgPOkrQX2ar0O8peuwQYjog3AH9Nlqal5HBgEVlOp4tTDrAlwI8j4qiIKHUJLQDOJ9t/4xCyXFaVn39aej/Ae4EvNVD/WWT5j46JiB8Cn46IXwNen147OSJWAl8ELouIt0bE+8jyIv23iPhMxfn+AVid/uY3AQ81UBezXRxAbMqLiPvI8o2dDXy74uXfAL6cjlsD7CdpVnrt5oh4MSJ+SnYx3r/GR9wZERsjYidZapd5FZ//PLAGeLukw4G+iLi/gT/hl2TJCUtOTK2Re4HfIst51Yi3kO0DQURsj/rZlM1q8hiI9YqVwCfILp77lZXXS2P9YlnZDmr//5LnuC+StXAeprHWB8C2KCU4kmaS5Sk6OiJGJH2MLBdWo5zDyCbMLRDrFVcBH6nyy/9fgT+AbEYV8NNxfpH/gmwr34ZEljZ8LvAuysZgmtBPtsnUTyXtA/xuE+e4FfgT2LXR1ssnUB/rYQ4g1hNSF9Onq7y0FBiSdB/ZAPnicc7zM+D7aQD7snrHVnED2VakWxp8X+XnX02WNfWbjB3PyesDwCJJ95Nloz282fpYb3M2XrM2SetFLo+IWya7Lmat4BaIWcHS4sN/JxvLcPCwKcMtEDMza4pbIGZm1hQHEDMza4oDiJmZNcUBxMzMmuIAYmZmTXEAMTOzpvx/yFZ3zwLYLs8AAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.scatter(df_sales_traffic.traffic,df_sales_traffic.adjusted_close)\n",
    "plt.xlabel(\"Monthly Traffic\")\n",
    "plt.ylabel(\"Monthly Sales\")\n",
    "# plt.xlim(0,20000)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id_x</th>\n",
       "      <th>traffic</th>\n",
       "      <th>paid_traffic</th>\n",
       "      <th>company_id</th>\n",
       "      <th>source_id</th>\n",
       "      <th>id_y</th>\n",
       "      <th>open</th>\n",
       "      <th>high</th>\n",
       "      <th>low</th>\n",
       "      <th>close</th>\n",
       "      <th>adjusted_close</th>\n",
       "      <th>volume</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>118.000000</td>\n",
       "      <td>118.000000</td>\n",
       "      <td>118.0</td>\n",
       "      <td>118.0</td>\n",
       "      <td>118.000000</td>\n",
       "      <td>118.000000</td>\n",
       "      <td>118.000000</td>\n",
       "      <td>118.000000</td>\n",
       "      <td>118.000000</td>\n",
       "      <td>118.000000</td>\n",
       "      <td>118.000000</td>\n",
       "      <td>1.180000e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>1601.635593</td>\n",
       "      <td>11027.889831</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.932203</td>\n",
       "      <td>12053.720339</td>\n",
       "      <td>3708.728814</td>\n",
       "      <td>3785.050847</td>\n",
       "      <td>3632.279661</td>\n",
       "      <td>3708.864407</td>\n",
       "      <td>3708.864407</td>\n",
       "      <td>5.695133e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>800.436309</td>\n",
       "      <td>15972.225478</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.252469</td>\n",
       "      <td>585.776567</td>\n",
       "      <td>1246.486259</td>\n",
       "      <td>1252.616140</td>\n",
       "      <td>1229.938786</td>\n",
       "      <td>1243.236010</td>\n",
       "      <td>1243.236010</td>\n",
       "      <td>3.517534e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>498.000000</td>\n",
       "      <td>476.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>10716.000000</td>\n",
       "      <td>1555.000000</td>\n",
       "      <td>1604.000000</td>\n",
       "      <td>1551.000000</td>\n",
       "      <td>1593.000000</td>\n",
       "      <td>1593.000000</td>\n",
       "      <td>8.772500e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>1549.500000</td>\n",
       "      <td>3546.750000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>11626.500000</td>\n",
       "      <td>2991.250000</td>\n",
       "      <td>3071.250000</td>\n",
       "      <td>2915.750000</td>\n",
       "      <td>2980.750000</td>\n",
       "      <td>2980.750000</td>\n",
       "      <td>3.416068e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>1588.500000</td>\n",
       "      <td>6110.500000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>12470.500000</td>\n",
       "      <td>3277.000000</td>\n",
       "      <td>3342.500000</td>\n",
       "      <td>3182.000000</td>\n",
       "      <td>3247.000000</td>\n",
       "      <td>3247.000000</td>\n",
       "      <td>4.744350e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>1834.750000</td>\n",
       "      <td>10582.750000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>12512.750000</td>\n",
       "      <td>4001.000000</td>\n",
       "      <td>4066.000000</td>\n",
       "      <td>3918.750000</td>\n",
       "      <td>3987.000000</td>\n",
       "      <td>3987.000000</td>\n",
       "      <td>6.886348e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>4263.000000</td>\n",
       "      <td>69020.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>12547.000000</td>\n",
       "      <td>7504.000000</td>\n",
       "      <td>7770.000000</td>\n",
       "      <td>7504.000000</td>\n",
       "      <td>7730.000000</td>\n",
       "      <td>7730.000000</td>\n",
       "      <td>2.375860e+06</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              id_x       traffic  paid_traffic  company_id   source_id  \\\n",
       "count   118.000000    118.000000         118.0       118.0  118.000000   \n",
       "mean   1601.635593  11027.889831           0.0         1.0    1.932203   \n",
       "std     800.436309  15972.225478           0.0         0.0    0.252469   \n",
       "min     498.000000    476.000000           0.0         1.0    1.000000   \n",
       "25%    1549.500000   3546.750000           0.0         1.0    2.000000   \n",
       "50%    1588.500000   6110.500000           0.0         1.0    2.000000   \n",
       "75%    1834.750000  10582.750000           0.0         1.0    2.000000   \n",
       "max    4263.000000  69020.000000           0.0         1.0    2.000000   \n",
       "\n",
       "               id_y         open         high          low        close  \\\n",
       "count    118.000000   118.000000   118.000000   118.000000   118.000000   \n",
       "mean   12053.720339  3708.728814  3785.050847  3632.279661  3708.864407   \n",
       "std      585.776567  1246.486259  1252.616140  1229.938786  1243.236010   \n",
       "min    10716.000000  1555.000000  1604.000000  1551.000000  1593.000000   \n",
       "25%    11626.500000  2991.250000  3071.250000  2915.750000  2980.750000   \n",
       "50%    12470.500000  3277.000000  3342.500000  3182.000000  3247.000000   \n",
       "75%    12512.750000  4001.000000  4066.000000  3918.750000  3987.000000   \n",
       "max    12547.000000  7504.000000  7770.000000  7504.000000  7730.000000   \n",
       "\n",
       "       adjusted_close        volume  \n",
       "count      118.000000  1.180000e+02  \n",
       "mean      3708.864407  5.695133e+05  \n",
       "std       1243.236010  3.517534e+05  \n",
       "min       1593.000000  8.772500e+04  \n",
       "25%       2980.750000  3.416068e+05  \n",
       "50%       3247.000000  4.744350e+05  \n",
       "75%       3987.000000  6.886348e+05  \n",
       "max       7730.000000  2.375860e+06  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_sales_traffic.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}