1.3_Test_Set_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Test set analysis"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "from import_man import *"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "_cell_guid": "da09e07b-fdfc-30b1-dfff-ad7dc625d15a"
   },
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"dataset/test.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(45689, 34)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>StoreID</th>\n",
       "      <td>1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>1000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Date</th>\n",
       "      <td>01/03/2018</td>\n",
       "      <td>02/03/2018</td>\n",
       "      <td>03/03/2018</td>\n",
       "      <td>04/03/2018</td>\n",
       "      <td>05/03/2018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IsHoliday</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>IsOpen</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HasPromotions</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>StoreType</th>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>Hyper Market</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AssortmentType</th>\n",
       "      <td>General</td>\n",
       "      <td>General</td>\n",
       "      <td>General</td>\n",
       "      <td>General</td>\n",
       "      <td>General</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NearestCompetitor</th>\n",
       "      <td>326</td>\n",
       "      <td>326</td>\n",
       "      <td>326</td>\n",
       "      <td>326</td>\n",
       "      <td>326</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Region</th>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Region_AreaKM2</th>\n",
       "      <td>9643</td>\n",
       "      <td>9643</td>\n",
       "      <td>9643</td>\n",
       "      <td>9643</td>\n",
       "      <td>9643</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Region_GDP</th>\n",
       "      <td>17130</td>\n",
       "      <td>17130</td>\n",
       "      <td>17130</td>\n",
       "      <td>17130</td>\n",
       "      <td>17130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Region_PopulationK</th>\n",
       "      <td>2770</td>\n",
       "      <td>2770</td>\n",
       "      <td>2770</td>\n",
       "      <td>2770</td>\n",
       "      <td>2770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CloudCover</th>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Events</th>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Fog-Rain</td>\n",
       "      <td>Rain</td>\n",
       "      <td>Rain-Snow</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Max_Dew_PointC</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Max_Gust_SpeedKm_h</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Max_Humidity</th>\n",
       "      <td>95</td>\n",
       "      <td>99</td>\n",
       "      <td>100</td>\n",
       "      <td>97</td>\n",
       "      <td>87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Max_Sea_Level_PressurehPa</th>\n",
       "      <td>1022</td>\n",
       "      <td>1021</td>\n",
       "      <td>1023</td>\n",
       "      <td>1014</td>\n",
       "      <td>1018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Max_TemperatureC</th>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Max_VisibilityKm</th>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Max_Wind_SpeedKm_h</th>\n",
       "      <td>18</td>\n",
       "      <td>19</td>\n",
       "      <td>18</td>\n",
       "      <td>29</td>\n",
       "      <td>42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mean_Dew_PointC</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>-1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mean_Humidity</th>\n",
       "      <td>75</td>\n",
       "      <td>83</td>\n",
       "      <td>74</td>\n",
       "      <td>83</td>\n",
       "      <td>65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mean_Sea_Level_PressurehPa</th>\n",
       "      <td>1019</td>\n",
       "      <td>1013</td>\n",
       "      <td>1020</td>\n",
       "      <td>1007</td>\n",
       "      <td>1007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mean_TemperatureC</th>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mean_VisibilityKm</th>\n",
       "      <td>14</td>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>11</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mean_Wind_SpeedKm_h</th>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>18</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Min_Dew_PointC</th>\n",
       "      <td>-1</td>\n",
       "      <td>-1</td>\n",
       "      <td>-3</td>\n",
       "      <td>-2</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Min_Humidity</th>\n",
       "      <td>46</td>\n",
       "      <td>52</td>\n",
       "      <td>41</td>\n",
       "      <td>65</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Min_Sea_Level_PressurehPa</th>\n",
       "      <td>1011</td>\n",
       "      <td>1009</td>\n",
       "      <td>1013</td>\n",
       "      <td>1002</td>\n",
       "      <td>1000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Min_TemperatureC</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>-2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Min_VisibilitykM</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Precipitationmm</th>\n",
       "      <td>0</td>\n",
       "      <td>5.08</td>\n",
       "      <td>0</td>\n",
       "      <td>3.05</td>\n",
       "      <td>0.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WindDirDegrees</th>\n",
       "      <td>180</td>\n",
       "      <td>315</td>\n",
       "      <td>210</td>\n",
       "      <td>193</td>\n",
       "      <td>247</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       0             1             2  \\\n",
       "StoreID                             1000          1000          1000   \n",
       "Date                          01/03/2018    02/03/2018    03/03/2018   \n",
       "IsHoliday                              0             0             0   \n",
       "IsOpen                                 1             1             1   \n",
       "HasPromotions                          0             0             0   \n",
       "StoreType                   Hyper Market  Hyper Market  Hyper Market   \n",
       "AssortmentType                   General       General       General   \n",
       "NearestCompetitor                    326           326           326   \n",
       "Region                                 7             7             7   \n",
       "Region_AreaKM2                      9643          9643          9643   \n",
       "Region_GDP                         17130         17130         17130   \n",
       "Region_PopulationK                  2770          2770          2770   \n",
       "CloudCover                             6             7             2   \n",
       "Events                              Rain          Rain      Fog-Rain   \n",
       "Max_Dew_PointC                         3             4             2   \n",
       "Max_Gust_SpeedKm_h                   NaN           NaN           NaN   \n",
       "Max_Humidity                          95            99           100   \n",
       "Max_Sea_Level_PressurehPa           1022          1021          1023   \n",
       "Max_TemperatureC                       9             5             8   \n",
       "Max_VisibilityKm                      31            31            31   \n",
       "Max_Wind_SpeedKm_h                    18            19            18   \n",
       "Mean_Dew_PointC                        2             2            -1   \n",
       "Mean_Humidity                         75            83            74   \n",
       "Mean_Sea_Level_PressurehPa          1019          1013          1020   \n",
       "Mean_TemperatureC                      6             4             3   \n",
       "Mean_VisibilityKm                     14            12            13   \n",
       "Mean_Wind_SpeedKm_h                    5             6            11   \n",
       "Min_Dew_PointC                        -1            -1            -3   \n",
       "Min_Humidity                          46            52            41   \n",
       "Min_Sea_Level_PressurehPa           1011          1009          1013   \n",
       "Min_TemperatureC                       2             3            -2   \n",
       "Min_VisibilitykM                      10            10            10   \n",
       "Precipitationmm                        0          5.08             0   \n",
       "WindDirDegrees                       180           315           210   \n",
       "\n",
       "                                       3             4  \n",
       "StoreID                             1000          1000  \n",
       "Date                          04/03/2018    05/03/2018  \n",
       "IsHoliday                              0             0  \n",
       "IsOpen                                 0             1  \n",
       "HasPromotions                          0             1  \n",
       "StoreType                   Hyper Market  Hyper Market  \n",
       "AssortmentType                   General       General  \n",
       "NearestCompetitor                    326           326  \n",
       "Region                                 7             7  \n",
       "Region_AreaKM2                      9643          9643  \n",
       "Region_GDP                         17130         17130  \n",
       "Region_PopulationK                  2770          2770  \n",
       "CloudCover                             6             4  \n",
       "Events                              Rain     Rain-Snow  \n",
       "Max_Dew_PointC                         7             7  \n",
       "Max_Gust_SpeedKm_h                   NaN            61  \n",
       "Max_Humidity                          97            87  \n",
       "Max_Sea_Level_PressurehPa           1014          1018  \n",
       "Max_TemperatureC                      10            10  \n",
       "Max_VisibilityKm                      31            26  \n",
       "Max_Wind_SpeedKm_h                    29            42  \n",
       "Mean_Dew_PointC                        4             1  \n",
       "Mean_Humidity                         83            65  \n",
       "Mean_Sea_Level_PressurehPa          1007          1007  \n",
       "Mean_TemperatureC                      6             6  \n",
       "Mean_VisibilityKm                     11            10  \n",
       "Mean_Wind_SpeedKm_h                   18            23  \n",
       "Min_Dew_PointC                        -2            -5  \n",
       "Min_Humidity                          65            25  \n",
       "Min_Sea_Level_PressurehPa           1002          1000  \n",
       "Min_TemperatureC                       1             2  \n",
       "Min_VisibilitykM                       6             8  \n",
       "Precipitationmm                     3.05          0.25  \n",
       "WindDirDegrees                       193           247  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head().T"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### How many days are the stores open?"
   ]
  },
  {
   "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>StoreID</th>\n",
       "      <th>Date</th>\n",
       "      <th>IsHoliday</th>\n",
       "      <th>IsOpen</th>\n",
       "      <th>HasPromotions</th>\n",
       "      <th>StoreType</th>\n",
       "      <th>AssortmentType</th>\n",
       "      <th>NearestCompetitor</th>\n",
       "      <th>Region</th>\n",
       "      <th>Region_AreaKM2</th>\n",
       "      <th>...</th>\n",
       "      <th>Mean_TemperatureC</th>\n",
       "      <th>Mean_VisibilityKm</th>\n",
       "      <th>Mean_Wind_SpeedKm_h</th>\n",
       "      <th>Min_Dew_PointC</th>\n",
       "      <th>Min_Humidity</th>\n",
       "      <th>Min_Sea_Level_PressurehPa</th>\n",
       "      <th>Min_TemperatureC</th>\n",
       "      <th>Min_VisibilitykM</th>\n",
       "      <th>Precipitationmm</th>\n",
       "      <th>WindDirDegrees</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1000</td>\n",
       "      <td>01/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>14.0</td>\n",
       "      <td>5</td>\n",
       "      <td>-1</td>\n",
       "      <td>46</td>\n",
       "      <td>1011</td>\n",
       "      <td>2</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1000</td>\n",
       "      <td>02/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>12.0</td>\n",
       "      <td>6</td>\n",
       "      <td>-1</td>\n",
       "      <td>52</td>\n",
       "      <td>1009</td>\n",
       "      <td>3</td>\n",
       "      <td>10.0</td>\n",
       "      <td>5.08</td>\n",
       "      <td>315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1000</td>\n",
       "      <td>03/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>13.0</td>\n",
       "      <td>11</td>\n",
       "      <td>-3</td>\n",
       "      <td>41</td>\n",
       "      <td>1013</td>\n",
       "      <td>-2</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>210</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1000</td>\n",
       "      <td>05/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>10.0</td>\n",
       "      <td>23</td>\n",
       "      <td>-5</td>\n",
       "      <td>25</td>\n",
       "      <td>1000</td>\n",
       "      <td>2</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.25</td>\n",
       "      <td>247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1000</td>\n",
       "      <td>06/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>10.0</td>\n",
       "      <td>19</td>\n",
       "      <td>-2</td>\n",
       "      <td>33</td>\n",
       "      <td>1016</td>\n",
       "      <td>0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.51</td>\n",
       "      <td>213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1000</td>\n",
       "      <td>07/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>11.0</td>\n",
       "      <td>14</td>\n",
       "      <td>-2</td>\n",
       "      <td>40</td>\n",
       "      <td>1020</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.25</td>\n",
       "      <td>230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1000</td>\n",
       "      <td>08/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>10.0</td>\n",
       "      <td>13</td>\n",
       "      <td>-2</td>\n",
       "      <td>41</td>\n",
       "      <td>1031</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1000</td>\n",
       "      <td>09/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>15.0</td>\n",
       "      <td>5</td>\n",
       "      <td>-2</td>\n",
       "      <td>43</td>\n",
       "      <td>1034</td>\n",
       "      <td>-2</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1000</td>\n",
       "      <td>10/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>24.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-3</td>\n",
       "      <td>31</td>\n",
       "      <td>1029</td>\n",
       "      <td>-3</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1000</td>\n",
       "      <td>12/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>17.0</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>1024</td>\n",
       "      <td>0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1000</td>\n",
       "      <td>13/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>12.0</td>\n",
       "      <td>5</td>\n",
       "      <td>-2</td>\n",
       "      <td>74</td>\n",
       "      <td>1024</td>\n",
       "      <td>-2</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.25</td>\n",
       "      <td>276</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1000</td>\n",
       "      <td>14/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>14.0</td>\n",
       "      <td>10</td>\n",
       "      <td>-7</td>\n",
       "      <td>26</td>\n",
       "      <td>1028</td>\n",
       "      <td>0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1000</td>\n",
       "      <td>15/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>14.0</td>\n",
       "      <td>10</td>\n",
       "      <td>-3</td>\n",
       "      <td>27</td>\n",
       "      <td>1027</td>\n",
       "      <td>-2</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1000</td>\n",
       "      <td>16/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>13.0</td>\n",
       "      <td>16</td>\n",
       "      <td>-5</td>\n",
       "      <td>28</td>\n",
       "      <td>1022</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1000</td>\n",
       "      <td>17/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>12.0</td>\n",
       "      <td>18</td>\n",
       "      <td>-2</td>\n",
       "      <td>57</td>\n",
       "      <td>1024</td>\n",
       "      <td>3</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1000</td>\n",
       "      <td>19/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>18.0</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "      <td>1022</td>\n",
       "      <td>3</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1000</td>\n",
       "      <td>20/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>22.0</td>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>26</td>\n",
       "      <td>1022</td>\n",
       "      <td>4</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1000</td>\n",
       "      <td>21/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>17.0</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>28</td>\n",
       "      <td>1023</td>\n",
       "      <td>5</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1000</td>\n",
       "      <td>22/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>8.0</td>\n",
       "      <td>13</td>\n",
       "      <td>2</td>\n",
       "      <td>30</td>\n",
       "      <td>1024</td>\n",
       "      <td>7</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>357</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1000</td>\n",
       "      <td>23/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>10.0</td>\n",
       "      <td>8</td>\n",
       "      <td>-1</td>\n",
       "      <td>23</td>\n",
       "      <td>1018</td>\n",
       "      <td>2</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1000</td>\n",
       "      <td>24/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6</td>\n",
       "      <td>-1</td>\n",
       "      <td>48</td>\n",
       "      <td>1016</td>\n",
       "      <td>-1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.51</td>\n",
       "      <td>306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1000</td>\n",
       "      <td>26/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>12.0</td>\n",
       "      <td>10</td>\n",
       "      <td>-2</td>\n",
       "      <td>46</td>\n",
       "      <td>1011</td>\n",
       "      <td>0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1000</td>\n",
       "      <td>27/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5</td>\n",
       "      <td>-3</td>\n",
       "      <td>36</td>\n",
       "      <td>1005</td>\n",
       "      <td>-2</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1000</td>\n",
       "      <td>28/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>10.0</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>1002</td>\n",
       "      <td>4</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1000</td>\n",
       "      <td>29/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>11.0</td>\n",
       "      <td>19</td>\n",
       "      <td>-5</td>\n",
       "      <td>20</td>\n",
       "      <td>1006</td>\n",
       "      <td>4</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1000</td>\n",
       "      <td>30/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>13.0</td>\n",
       "      <td>18</td>\n",
       "      <td>-2</td>\n",
       "      <td>31</td>\n",
       "      <td>1010</td>\n",
       "      <td>4</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>246</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>1000</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>12.0</td>\n",
       "      <td>11</td>\n",
       "      <td>-2</td>\n",
       "      <td>26</td>\n",
       "      <td>1013</td>\n",
       "      <td>2</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>1000</td>\n",
       "      <td>02/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>10.0</td>\n",
       "      <td>29</td>\n",
       "      <td>-5</td>\n",
       "      <td>26</td>\n",
       "      <td>997</td>\n",
       "      <td>4</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>256</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>1000</td>\n",
       "      <td>03/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>11.0</td>\n",
       "      <td>31</td>\n",
       "      <td>-3</td>\n",
       "      <td>33</td>\n",
       "      <td>995</td>\n",
       "      <td>4</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.06</td>\n",
       "      <td>247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>1000</td>\n",
       "      <td>04/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>326</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>12.0</td>\n",
       "      <td>29</td>\n",
       "      <td>-2</td>\n",
       "      <td>34</td>\n",
       "      <td>1011</td>\n",
       "      <td>3</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.76</td>\n",
       "      <td>253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45651</th>\n",
       "      <td>1748</td>\n",
       "      <td>24/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6</td>\n",
       "      <td>-1</td>\n",
       "      <td>48</td>\n",
       "      <td>1016</td>\n",
       "      <td>-1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.51</td>\n",
       "      <td>306</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45653</th>\n",
       "      <td>1748</td>\n",
       "      <td>26/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>12.0</td>\n",
       "      <td>10</td>\n",
       "      <td>-2</td>\n",
       "      <td>46</td>\n",
       "      <td>1011</td>\n",
       "      <td>0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45654</th>\n",
       "      <td>1748</td>\n",
       "      <td>27/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5</td>\n",
       "      <td>-3</td>\n",
       "      <td>36</td>\n",
       "      <td>1005</td>\n",
       "      <td>-2</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45655</th>\n",
       "      <td>1748</td>\n",
       "      <td>28/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>10.0</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>1002</td>\n",
       "      <td>4</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45656</th>\n",
       "      <td>1748</td>\n",
       "      <td>29/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>11.0</td>\n",
       "      <td>19</td>\n",
       "      <td>-5</td>\n",
       "      <td>20</td>\n",
       "      <td>1006</td>\n",
       "      <td>4</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45657</th>\n",
       "      <td>1748</td>\n",
       "      <td>30/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>13.0</td>\n",
       "      <td>18</td>\n",
       "      <td>-2</td>\n",
       "      <td>31</td>\n",
       "      <td>1010</td>\n",
       "      <td>4</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>246</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45658</th>\n",
       "      <td>1748</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>12.0</td>\n",
       "      <td>11</td>\n",
       "      <td>-2</td>\n",
       "      <td>26</td>\n",
       "      <td>1013</td>\n",
       "      <td>2</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45660</th>\n",
       "      <td>1748</td>\n",
       "      <td>02/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>10.0</td>\n",
       "      <td>29</td>\n",
       "      <td>-5</td>\n",
       "      <td>26</td>\n",
       "      <td>997</td>\n",
       "      <td>4</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>256</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45661</th>\n",
       "      <td>1748</td>\n",
       "      <td>03/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>11.0</td>\n",
       "      <td>31</td>\n",
       "      <td>-3</td>\n",
       "      <td>33</td>\n",
       "      <td>995</td>\n",
       "      <td>4</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.06</td>\n",
       "      <td>247</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45662</th>\n",
       "      <td>1748</td>\n",
       "      <td>04/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>12.0</td>\n",
       "      <td>29</td>\n",
       "      <td>-2</td>\n",
       "      <td>34</td>\n",
       "      <td>1011</td>\n",
       "      <td>3</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.76</td>\n",
       "      <td>253</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45663</th>\n",
       "      <td>1748</td>\n",
       "      <td>05/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>11.0</td>\n",
       "      <td>27</td>\n",
       "      <td>-7</td>\n",
       "      <td>24</td>\n",
       "      <td>1009</td>\n",
       "      <td>3</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.03</td>\n",
       "      <td>259</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45665</th>\n",
       "      <td>1748</td>\n",
       "      <td>07/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>13.0</td>\n",
       "      <td>10</td>\n",
       "      <td>-6</td>\n",
       "      <td>29</td>\n",
       "      <td>1014</td>\n",
       "      <td>4</td>\n",
       "      <td>8.0</td>\n",
       "      <td>4.06</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45668</th>\n",
       "      <td>1748</td>\n",
       "      <td>10/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>10.0</td>\n",
       "      <td>6</td>\n",
       "      <td>-4</td>\n",
       "      <td>20</td>\n",
       "      <td>1033</td>\n",
       "      <td>-2</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45669</th>\n",
       "      <td>1748</td>\n",
       "      <td>11/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>13.0</td>\n",
       "      <td>5</td>\n",
       "      <td>-2</td>\n",
       "      <td>33</td>\n",
       "      <td>1030</td>\n",
       "      <td>-1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45670</th>\n",
       "      <td>1748</td>\n",
       "      <td>12/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>22.0</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>29</td>\n",
       "      <td>1024</td>\n",
       "      <td>5</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45671</th>\n",
       "      <td>1748</td>\n",
       "      <td>13/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>13</td>\n",
       "      <td>21.0</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>1018</td>\n",
       "      <td>4</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>186</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45672</th>\n",
       "      <td>1748</td>\n",
       "      <td>14/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>10.0</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>35</td>\n",
       "      <td>1018</td>\n",
       "      <td>7</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>218</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45674</th>\n",
       "      <td>1748</td>\n",
       "      <td>16/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>10.0</td>\n",
       "      <td>13</td>\n",
       "      <td>-3</td>\n",
       "      <td>25</td>\n",
       "      <td>1026</td>\n",
       "      <td>7</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>276</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45675</th>\n",
       "      <td>1748</td>\n",
       "      <td>17/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>12.0</td>\n",
       "      <td>10</td>\n",
       "      <td>-1</td>\n",
       "      <td>23</td>\n",
       "      <td>1023</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45676</th>\n",
       "      <td>1748</td>\n",
       "      <td>18/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>1013</td>\n",
       "      <td>6</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>205</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45677</th>\n",
       "      <td>1748</td>\n",
       "      <td>19/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>14</td>\n",
       "      <td>27.0</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>20</td>\n",
       "      <td>1010</td>\n",
       "      <td>6</td>\n",
       "      <td>24.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45678</th>\n",
       "      <td>1748</td>\n",
       "      <td>20/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>10.0</td>\n",
       "      <td>21</td>\n",
       "      <td>-3</td>\n",
       "      <td>22</td>\n",
       "      <td>1012</td>\n",
       "      <td>7</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45679</th>\n",
       "      <td>1748</td>\n",
       "      <td>21/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>10.0</td>\n",
       "      <td>14</td>\n",
       "      <td>-5</td>\n",
       "      <td>18</td>\n",
       "      <td>1021</td>\n",
       "      <td>3</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45681</th>\n",
       "      <td>1748</td>\n",
       "      <td>23/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "      <td>-3</td>\n",
       "      <td>15</td>\n",
       "      <td>1023</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45682</th>\n",
       "      <td>1748</td>\n",
       "      <td>24/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>-1</td>\n",
       "      <td>12</td>\n",
       "      <td>1026</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>341</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45683</th>\n",
       "      <td>1748</td>\n",
       "      <td>25/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>1023</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45684</th>\n",
       "      <td>1748</td>\n",
       "      <td>26/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>10</td>\n",
       "      <td>17.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>1015</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45685</th>\n",
       "      <td>1748</td>\n",
       "      <td>27/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>17.0</td>\n",
       "      <td>5</td>\n",
       "      <td>-1</td>\n",
       "      <td>18</td>\n",
       "      <td>1011</td>\n",
       "      <td>2</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.00</td>\n",
       "      <td>196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45686</th>\n",
       "      <td>1748</td>\n",
       "      <td>28/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>12</td>\n",
       "      <td>16.0</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>42</td>\n",
       "      <td>1009</td>\n",
       "      <td>6</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.25</td>\n",
       "      <td>202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45688</th>\n",
       "      <td>1748</td>\n",
       "      <td>30/04/2018</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Hyper Market</td>\n",
       "      <td>General</td>\n",
       "      <td>4607</td>\n",
       "      <td>7</td>\n",
       "      <td>9643</td>\n",
       "      <td>...</td>\n",
       "      <td>11</td>\n",
       "      <td>11.0</td>\n",
       "      <td>11</td>\n",
       "      <td>5</td>\n",
       "      <td>70</td>\n",
       "      <td>1001</td>\n",
       "      <td>8</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3.05</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>37586 rows × 34 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       StoreID        Date  IsHoliday  IsOpen  HasPromotions     StoreType  \\\n",
       "0         1000  01/03/2018          0       1              0  Hyper Market   \n",
       "1         1000  02/03/2018          0       1              0  Hyper Market   \n",
       "2         1000  03/03/2018          0       1              0  Hyper Market   \n",
       "4         1000  05/03/2018          0       1              1  Hyper Market   \n",
       "5         1000  06/03/2018          0       1              1  Hyper Market   \n",
       "6         1000  07/03/2018          0       1              1  Hyper Market   \n",
       "7         1000  08/03/2018          0       1              1  Hyper Market   \n",
       "8         1000  09/03/2018          0       1              1  Hyper Market   \n",
       "9         1000  10/03/2018          0       1              0  Hyper Market   \n",
       "11        1000  12/03/2018          0       1              0  Hyper Market   \n",
       "12        1000  13/03/2018          0       1              0  Hyper Market   \n",
       "13        1000  14/03/2018          0       1              0  Hyper Market   \n",
       "14        1000  15/03/2018          0       1              0  Hyper Market   \n",
       "15        1000  16/03/2018          0       1              0  Hyper Market   \n",
       "16        1000  17/03/2018          0       1              0  Hyper Market   \n",
       "18        1000  19/03/2018          0       1              1  Hyper Market   \n",
       "19        1000  20/03/2018          0       1              1  Hyper Market   \n",
       "20        1000  21/03/2018          0       1              1  Hyper Market   \n",
       "21        1000  22/03/2018          0       1              1  Hyper Market   \n",
       "22        1000  23/03/2018          0       1              1  Hyper Market   \n",
       "23        1000  24/03/2018          0       1              0  Hyper Market   \n",
       "25        1000  26/03/2018          0       1              0  Hyper Market   \n",
       "26        1000  27/03/2018          0       1              0  Hyper Market   \n",
       "27        1000  28/03/2018          0       1              0  Hyper Market   \n",
       "28        1000  29/03/2018          0       1              0  Hyper Market   \n",
       "29        1000  30/03/2018          0       1              0  Hyper Market   \n",
       "30        1000  31/03/2018          0       1              0  Hyper Market   \n",
       "32        1000  02/04/2018          0       1              1  Hyper Market   \n",
       "33        1000  03/04/2018          0       1              1  Hyper Market   \n",
       "34        1000  04/04/2018          0       1              1  Hyper Market   \n",
       "...        ...         ...        ...     ...            ...           ...   \n",
       "45651     1748  24/03/2018          0       1              0  Hyper Market   \n",
       "45653     1748  26/03/2018          0       1              0  Hyper Market   \n",
       "45654     1748  27/03/2018          0       1              0  Hyper Market   \n",
       "45655     1748  28/03/2018          0       1              0  Hyper Market   \n",
       "45656     1748  29/03/2018          0       1              0  Hyper Market   \n",
       "45657     1748  30/03/2018          0       1              0  Hyper Market   \n",
       "45658     1748  31/03/2018          0       1              0  Hyper Market   \n",
       "45660     1748  02/04/2018          0       1              1  Hyper Market   \n",
       "45661     1748  03/04/2018          0       1              1  Hyper Market   \n",
       "45662     1748  04/04/2018          0       1              1  Hyper Market   \n",
       "45663     1748  05/04/2018          0       1              1  Hyper Market   \n",
       "45665     1748  07/04/2018          0       1              0  Hyper Market   \n",
       "45668     1748  10/04/2018          0       1              0  Hyper Market   \n",
       "45669     1748  11/04/2018          0       1              0  Hyper Market   \n",
       "45670     1748  12/04/2018          0       1              0  Hyper Market   \n",
       "45671     1748  13/04/2018          0       1              0  Hyper Market   \n",
       "45672     1748  14/04/2018          0       1              0  Hyper Market   \n",
       "45674     1748  16/04/2018          0       1              1  Hyper Market   \n",
       "45675     1748  17/04/2018          0       1              1  Hyper Market   \n",
       "45676     1748  18/04/2018          0       1              1  Hyper Market   \n",
       "45677     1748  19/04/2018          0       1              1  Hyper Market   \n",
       "45678     1748  20/04/2018          0       1              1  Hyper Market   \n",
       "45679     1748  21/04/2018          0       1              0  Hyper Market   \n",
       "45681     1748  23/04/2018          0       1              0  Hyper Market   \n",
       "45682     1748  24/04/2018          0       1              0  Hyper Market   \n",
       "45683     1748  25/04/2018          0       1              0  Hyper Market   \n",
       "45684     1748  26/04/2018          0       1              0  Hyper Market   \n",
       "45685     1748  27/04/2018          0       1              0  Hyper Market   \n",
       "45686     1748  28/04/2018          0       1              0  Hyper Market   \n",
       "45688     1748  30/04/2018          0       1              1  Hyper Market   \n",
       "\n",
       "      AssortmentType  NearestCompetitor  Region  Region_AreaKM2  \\\n",
       "0            General                326       7            9643   \n",
       "1            General                326       7            9643   \n",
       "2            General                326       7            9643   \n",
       "4            General                326       7            9643   \n",
       "5            General                326       7            9643   \n",
       "6            General                326       7            9643   \n",
       "7            General                326       7            9643   \n",
       "8            General                326       7            9643   \n",
       "9            General                326       7            9643   \n",
       "11           General                326       7            9643   \n",
       "12           General                326       7            9643   \n",
       "13           General                326       7            9643   \n",
       "14           General                326       7            9643   \n",
       "15           General                326       7            9643   \n",
       "16           General                326       7            9643   \n",
       "18           General                326       7            9643   \n",
       "19           General                326       7            9643   \n",
       "20           General                326       7            9643   \n",
       "21           General                326       7            9643   \n",
       "22           General                326       7            9643   \n",
       "23           General                326       7            9643   \n",
       "25           General                326       7            9643   \n",
       "26           General                326       7            9643   \n",
       "27           General                326       7            9643   \n",
       "28           General                326       7            9643   \n",
       "29           General                326       7            9643   \n",
       "30           General                326       7            9643   \n",
       "32           General                326       7            9643   \n",
       "33           General                326       7            9643   \n",
       "34           General                326       7            9643   \n",
       "...              ...                ...     ...             ...   \n",
       "45651        General               4607       7            9643   \n",
       "45653        General               4607       7            9643   \n",
       "45654        General               4607       7            9643   \n",
       "45655        General               4607       7            9643   \n",
       "45656        General               4607       7            9643   \n",
       "45657        General               4607       7            9643   \n",
       "45658        General               4607       7            9643   \n",
       "45660        General               4607       7            9643   \n",
       "45661        General               4607       7            9643   \n",
       "45662        General               4607       7            9643   \n",
       "45663        General               4607       7            9643   \n",
       "45665        General               4607       7            9643   \n",
       "45668        General               4607       7            9643   \n",
       "45669        General               4607       7            9643   \n",
       "45670        General               4607       7            9643   \n",
       "45671        General               4607       7            9643   \n",
       "45672        General               4607       7            9643   \n",
       "45674        General               4607       7            9643   \n",
       "45675        General               4607       7            9643   \n",
       "45676        General               4607       7            9643   \n",
       "45677        General               4607       7            9643   \n",
       "45678        General               4607       7            9643   \n",
       "45679        General               4607       7            9643   \n",
       "45681        General               4607       7            9643   \n",
       "45682        General               4607       7            9643   \n",
       "45683        General               4607       7            9643   \n",
       "45684        General               4607       7            9643   \n",
       "45685        General               4607       7            9643   \n",
       "45686        General               4607       7            9643   \n",
       "45688        General               4607       7            9643   \n",
       "\n",
       "            ...        Mean_TemperatureC  Mean_VisibilityKm  \\\n",
       "0           ...                        6               14.0   \n",
       "1           ...                        4               12.0   \n",
       "2           ...                        3               13.0   \n",
       "4           ...                        6               10.0   \n",
       "5           ...                        6               10.0   \n",
       "6           ...                        4               11.0   \n",
       "7           ...                        4               10.0   \n",
       "8           ...                        3               15.0   \n",
       "9           ...                        3               24.0   \n",
       "11          ...                        8               17.0   \n",
       "12          ...                        4               12.0   \n",
       "13          ...                        5               14.0   \n",
       "14          ...                        4               14.0   \n",
       "15          ...                        4               13.0   \n",
       "16          ...                        4               12.0   \n",
       "18          ...                        8               18.0   \n",
       "19          ...                       11               22.0   \n",
       "20          ...                       12               17.0   \n",
       "21          ...                       11                8.0   \n",
       "22          ...                        9               10.0   \n",
       "23          ...                        3                9.0   \n",
       "25          ...                        5               12.0   \n",
       "26          ...                        6                8.0   \n",
       "27          ...                       11               10.0   \n",
       "28          ...                        8               11.0   \n",
       "29          ...                        7               13.0   \n",
       "30          ...                        8               12.0   \n",
       "32          ...                        8               10.0   \n",
       "33          ...                        9               11.0   \n",
       "34          ...                        6               12.0   \n",
       "...         ...                      ...                ...   \n",
       "45651       ...                        3                9.0   \n",
       "45653       ...                        5               12.0   \n",
       "45654       ...                        6                8.0   \n",
       "45655       ...                       11               10.0   \n",
       "45656       ...                        8               11.0   \n",
       "45657       ...                        7               13.0   \n",
       "45658       ...                        8               12.0   \n",
       "45660       ...                        8               10.0   \n",
       "45661       ...                        9               11.0   \n",
       "45662       ...                        6               12.0   \n",
       "45663       ...                        6               11.0   \n",
       "45665       ...                        6               13.0   \n",
       "45668       ...                        6               10.0   \n",
       "45669       ...                        8               13.0   \n",
       "45670       ...                       12               22.0   \n",
       "45671       ...                       13               21.0   \n",
       "45672       ...                       12               10.0   \n",
       "45674       ...                       12               10.0   \n",
       "45675       ...                       12               12.0   \n",
       "45676       ...                       16               10.0   \n",
       "45677       ...                       14               27.0   \n",
       "45678       ...                       11               10.0   \n",
       "45679       ...                        8               10.0   \n",
       "45681       ...                       13                NaN   \n",
       "45682       ...                       13                NaN   \n",
       "45683       ...                       11                NaN   \n",
       "45684       ...                       10               17.0   \n",
       "45685       ...                       11               17.0   \n",
       "45686       ...                       12               16.0   \n",
       "45688       ...                       11               11.0   \n",
       "\n",
       "       Mean_Wind_SpeedKm_h Min_Dew_PointC  Min_Humidity  \\\n",
       "0                        5             -1            46   \n",
       "1                        6             -1            52   \n",
       "2                       11             -3            41   \n",
       "4                       23             -5            25   \n",
       "5                       19             -2            33   \n",
       "6                       14             -2            40   \n",
       "7                       13             -2            41   \n",
       "8                        5             -2            43   \n",
       "9                        3             -3            31   \n",
       "11                       6              0            38   \n",
       "12                       5             -2            74   \n",
       "13                      10             -7            26   \n",
       "14                      10             -3            27   \n",
       "15                      16             -5            28   \n",
       "16                      18             -2            57   \n",
       "18                      16              0            33   \n",
       "19                      14              1            26   \n",
       "20                      10              3            28   \n",
       "21                      13              2            30   \n",
       "22                       8             -1            23   \n",
       "23                       6             -1            48   \n",
       "25                      10             -2            46   \n",
       "26                       5             -3            36   \n",
       "27                      11              1            27   \n",
       "28                      19             -5            20   \n",
       "29                      18             -2            31   \n",
       "30                      11             -2            26   \n",
       "32                      29             -5            26   \n",
       "33                      31             -3            33   \n",
       "34                      29             -2            34   \n",
       "...                    ...            ...           ...   \n",
       "45651                    6             -1            48   \n",
       "45653                   10             -2            46   \n",
       "45654                    5             -3            36   \n",
       "45655                   11              1            27   \n",
       "45656                   19             -5            20   \n",
       "45657                   18             -2            31   \n",
       "45658                   11             -2            26   \n",
       "45660                   29             -5            26   \n",
       "45661                   31             -3            33   \n",
       "45662                   29             -2            34   \n",
       "45663                   27             -7            24   \n",
       "45665                   10             -6            29   \n",
       "45668                    6             -4            20   \n",
       "45669                    5             -2            33   \n",
       "45670                    8              3            29   \n",
       "45671                    5              1            17   \n",
       "45672                   13              1            35   \n",
       "45674                   13             -3            25   \n",
       "45675                   10             -1            23   \n",
       "45676                   10              1            14   \n",
       "45677                    6              4            20   \n",
       "45678                   21             -3            22   \n",
       "45679                   14             -5            18   \n",
       "45681                   13             -3            15   \n",
       "45682                    6             -1            12   \n",
       "45683                   11              0            22   \n",
       "45684                    5              0            20   \n",
       "45685                    5             -1            18   \n",
       "45686                    6              4            42   \n",
       "45688                   11              5            70   \n",
       "\n",
       "       Min_Sea_Level_PressurehPa  Min_TemperatureC  Min_VisibilitykM  \\\n",
       "0                           1011                 2              10.0   \n",
       "1                           1009                 3              10.0   \n",
       "2                           1013                -2              10.0   \n",
       "4                           1000                 2               8.0   \n",
       "5                           1016                 0              10.0   \n",
       "6                           1020                 1              10.0   \n",
       "7                           1031                 1              10.0   \n",
       "8                           1034                -2              10.0   \n",
       "9                           1029                -3              18.0   \n",
       "11                          1024                 0              10.0   \n",
       "12                          1024                -2               5.0   \n",
       "13                          1028                 0              10.0   \n",
       "14                          1027                -2              10.0   \n",
       "15                          1022                 1              10.0   \n",
       "16                          1024                 3              10.0   \n",
       "18                          1022                 3              11.0   \n",
       "19                          1022                 4              11.0   \n",
       "20                          1023                 5               6.0   \n",
       "21                          1024                 7               3.0   \n",
       "22                          1018                 2               5.0   \n",
       "23                          1016                -1               3.0   \n",
       "25                          1011                 0               8.0   \n",
       "26                          1005                -2               5.0   \n",
       "27                          1002                 4               8.0   \n",
       "28                          1006                 4               6.0   \n",
       "29                          1010                 4              10.0   \n",
       "30                          1013                 2               8.0   \n",
       "32                           997                 4              10.0   \n",
       "33                           995                 4               4.0   \n",
       "34                          1011                 3               4.0   \n",
       "...                          ...               ...               ...   \n",
       "45651                       1016                -1               3.0   \n",
       "45653                       1011                 0               8.0   \n",
       "45654                       1005                -2               5.0   \n",
       "45655                       1002                 4               8.0   \n",
       "45656                       1006                 4               6.0   \n",
       "45657                       1010                 4              10.0   \n",
       "45658                       1013                 2               8.0   \n",
       "45660                        997                 4              10.0   \n",
       "45661                        995                 4               4.0   \n",
       "45662                       1011                 3               4.0   \n",
       "45663                       1009                 3              10.0   \n",
       "45665                       1014                 4               8.0   \n",
       "45668                       1033                -2              10.0   \n",
       "45669                       1030                -1              10.0   \n",
       "45670                       1024                 5              10.0   \n",
       "45671                       1018                 4              10.0   \n",
       "45672                       1018                 7              10.0   \n",
       "45674                       1026                 7              10.0   \n",
       "45675                       1023                 1              10.0   \n",
       "45676                       1013                 6              10.0   \n",
       "45677                       1010                 6              24.0   \n",
       "45678                       1012                 7              10.0   \n",
       "45679                       1021                 3              10.0   \n",
       "45681                       1023                 6               NaN   \n",
       "45682                       1026                 3               NaN   \n",
       "45683                       1023                 4               NaN   \n",
       "45684                       1015                 1              10.0   \n",
       "45685                       1011                 2              10.0   \n",
       "45686                       1009                 6              10.0   \n",
       "45688                       1001                 8               5.0   \n",
       "\n",
       "       Precipitationmm  WindDirDegrees  \n",
       "0                 0.00             180  \n",
       "1                 5.08             315  \n",
       "2                 0.00             210  \n",
       "4                 0.25             247  \n",
       "5                 0.51             213  \n",
       "6                 0.25             230  \n",
       "7                 0.00             309  \n",
       "8                 0.00             190  \n",
       "9                 0.00             178  \n",
       "11                0.00              26  \n",
       "12                0.25             276  \n",
       "13                0.00              33  \n",
       "14                0.00              54  \n",
       "15                0.00              57  \n",
       "16                0.00              30  \n",
       "18                0.00              32  \n",
       "19                0.00              33  \n",
       "20                0.00              41  \n",
       "21                0.00             357  \n",
       "22                0.00              18  \n",
       "23                0.51             306  \n",
       "25                0.00              37  \n",
       "26                0.00              22  \n",
       "27                0.00             356  \n",
       "28                0.00             253  \n",
       "29                0.00             246  \n",
       "30                0.00             208  \n",
       "32                0.00             256  \n",
       "33                4.06             247  \n",
       "34                0.76             253  \n",
       "...                ...             ...  \n",
       "45651             0.51             306  \n",
       "45653             0.00              37  \n",
       "45654             0.00              22  \n",
       "45655             0.00             356  \n",
       "45656             0.00             253  \n",
       "45657             0.00             246  \n",
       "45658             0.00             208  \n",
       "45660             0.00             256  \n",
       "45661             4.06             247  \n",
       "45662             0.76             253  \n",
       "45663             2.03             259  \n",
       "45665             4.06              16  \n",
       "45668             0.00             221  \n",
       "45669             0.00              67  \n",
       "45670             0.00              57  \n",
       "45671             0.00             186  \n",
       "45672             0.00             218  \n",
       "45674             0.00             276  \n",
       "45675             0.00             221  \n",
       "45676             0.00             205  \n",
       "45677             0.00             203  \n",
       "45678             0.00              28  \n",
       "45679             0.00              29  \n",
       "45681             0.00              34  \n",
       "45682             0.00             341  \n",
       "45683             0.00              21  \n",
       "45684             0.00             128  \n",
       "45685             0.00             196  \n",
       "45686             0.25             202  \n",
       "45688             3.05               9  \n",
       "\n",
       "[37586 rows x 34 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[(df['IsOpen'] == 1)]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Closed days percentage"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "17.735122239488717"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "((45689-37586)/45689)*100"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}