market_basket_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Import Libraries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 222,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from matplotlib import pyplot as plt\n",
    "import datetime as dt\n",
    "import numpy as np\n",
    "import math"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Load dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 223,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(10000, 11)\n",
      "['customer_id', 'First Time', 'Recent Time', '# of Orders', '# of Orders in last 7 days', '# of Orders in last 4 weeks', 'Amount', 'Amount in last 7 days', 'Amount in last 4 weeks', 'Avg_DistanceFromResturant', 'Avg_DeliveryTime']\n",
      "customer_id                      int64\n",
      "First Time                      object\n",
      "Recent Time                     object\n",
      "# of Orders                      int64\n",
      "# of Orders in last 7 days     float64\n",
      "# of Orders in last 4 weeks    float64\n",
      "Amount                           int64\n",
      "Amount in last 7 days            int64\n",
      "Amount in last 4 weeks           int64\n",
      "Avg_DistanceFromResturant      float64\n",
      "Avg_DeliveryTime                 int64\n",
      "dtype: object\n"
     ]
    }
   ],
   "source": [
    "df = pd.read_csv('SampleAssessment.csv')\n",
    "print(df.shape)\n",
    "print(df.columns.tolist())\n",
    "print(df.dtypes)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Convert object to time"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 224,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "customer_id                             int64\n",
       "First Time                     datetime64[ns]\n",
       "Recent Time                    datetime64[ns]\n",
       "# of Orders                             int64\n",
       "# of Orders in last 7 days            float64\n",
       "# of Orders in last 4 weeks           float64\n",
       "Amount                                  int64\n",
       "Amount in last 7 days                   int64\n",
       "Amount in last 4 weeks                  int64\n",
       "Avg_DistanceFromResturant             float64\n",
       "Avg_DeliveryTime                        int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 224,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cols = ['First Time', 'Recent Time']\n",
    "for column in cols:\n",
    "    df[column] = pd.to_datetime(df[column])\n",
    "df.dtypes"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## count of unique vs null values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 225,
   "metadata": {},
   "outputs": [],
   "source": [
    "# summary_df = pd.DataFrame(columns=['num_unique', 'num_nulls'])\n",
    "# for column in df.columns:\n",
    "#     summary_df.loc[column] = [df[column].nunique(), df[column].isna().sum()]\n",
    "# summary_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### searching for null values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 226,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "customer_id                       0\n",
       "First Time                        0\n",
       "Recent Time                       0\n",
       "# of Orders                       0\n",
       "# of Orders in last 7 days     8077\n",
       "# of Orders in last 4 weeks    5659\n",
       "Amount                            0\n",
       "Amount in last 7 days             0\n",
       "Amount in last 4 weeks            0\n",
       "Avg_DistanceFromResturant         0\n",
       "Avg_DeliveryTime                  0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 226,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum(axis=0)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Only the below columns have null values, replace nulls with zeros\n",
    "* '# of Orders in last 7 day'\n",
    "* '# of Orders in last 4 weeks'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 227,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(0, 11)\n",
      "(0, 11)\n"
     ]
    }
   ],
   "source": [
    "cols = ['# of Orders in last 7 days', '# of Orders in last 4 weeks']\n",
    "for column in cols:\n",
    "    df[column].fillna(0, inplace=True)\n",
    "print(df[df['# of Orders in last 7 days'].isna()].shape)\n",
    "print(df[df['# of Orders in last 4 weeks'].isna()].shape)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Adding average order value column"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 228,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['average_cost'] = df.Amount / df['# of Orders']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Adding a time difference column"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 229,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['time_diff'] =  df['Recent Time'] - df['First Time']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 230,
   "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>customer_id</th>\n",
       "      <th>First Time</th>\n",
       "      <th>Recent Time</th>\n",
       "      <th># of Orders</th>\n",
       "      <th># of Orders in last 7 days</th>\n",
       "      <th># of Orders in last 4 weeks</th>\n",
       "      <th>Amount</th>\n",
       "      <th>Amount in last 7 days</th>\n",
       "      <th>Amount in last 4 weeks</th>\n",
       "      <th>Avg_DistanceFromResturant</th>\n",
       "      <th>Avg_DeliveryTime</th>\n",
       "      <th>average_cost</th>\n",
       "      <th>time_diff</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3574</th>\n",
       "      <td>254949</td>\n",
       "      <td>2015-07-21 04:37:00</td>\n",
       "      <td>2015-08-29 20:10:00</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1079</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>24</td>\n",
       "      <td>269.750000</td>\n",
       "      <td>39 days 15:33:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4640</th>\n",
       "      <td>627893</td>\n",
       "      <td>2015-09-21 16:33:00</td>\n",
       "      <td>2015-12-22 07:33:00</td>\n",
       "      <td>3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1286</td>\n",
       "      <td>0</td>\n",
       "      <td>1020</td>\n",
       "      <td>2.8</td>\n",
       "      <td>61</td>\n",
       "      <td>428.666667</td>\n",
       "      <td>91 days 15:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6938</th>\n",
       "      <td>1047998</td>\n",
       "      <td>2015-11-18 08:36:00</td>\n",
       "      <td>2015-11-22 08:27:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>409</td>\n",
       "      <td>0</td>\n",
       "      <td>409</td>\n",
       "      <td>2.3</td>\n",
       "      <td>26</td>\n",
       "      <td>409.000000</td>\n",
       "      <td>3 days 23:51:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3498</th>\n",
       "      <td>395690</td>\n",
       "      <td>2015-08-04 10:45:00</td>\n",
       "      <td>2015-11-09 23:11:00</td>\n",
       "      <td>4</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1439</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.4</td>\n",
       "      <td>43</td>\n",
       "      <td>359.750000</td>\n",
       "      <td>97 days 12:26:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5864</th>\n",
       "      <td>326302</td>\n",
       "      <td>2015-06-28 08:10:00</td>\n",
       "      <td>2015-10-07 11:33:00</td>\n",
       "      <td>2</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1483</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>46</td>\n",
       "      <td>741.500000</td>\n",
       "      <td>101 days 03:23:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      customer_id          First Time         Recent Time  # of Orders  \\\n",
       "3574       254949 2015-07-21 04:37:00 2015-08-29 20:10:00            4   \n",
       "4640       627893 2015-09-21 16:33:00 2015-12-22 07:33:00            3   \n",
       "6938      1047998 2015-11-18 08:36:00 2015-11-22 08:27:00            1   \n",
       "3498       395690 2015-08-04 10:45:00 2015-11-09 23:11:00            4   \n",
       "5864       326302 2015-06-28 08:10:00 2015-10-07 11:33:00            2   \n",
       "\n",
       "      # of Orders in last 7 days  # of Orders in last 4 weeks  Amount  \\\n",
       "3574                         0.0                          0.0    1079   \n",
       "4640                         0.0                          2.0    1286   \n",
       "6938                         0.0                          1.0     409   \n",
       "3498                         0.0                          0.0    1439   \n",
       "5864                         0.0                          0.0    1483   \n",
       "\n",
       "      Amount in last 7 days  Amount in last 4 weeks  \\\n",
       "3574                      0                       0   \n",
       "4640                      0                    1020   \n",
       "6938                      0                     409   \n",
       "3498                      0                       0   \n",
       "5864                      0                       0   \n",
       "\n",
       "      Avg_DistanceFromResturant  Avg_DeliveryTime  average_cost  \\\n",
       "3574                        1.8                24    269.750000   \n",
       "4640                        2.8                61    428.666667   \n",
       "6938                        2.3                26    409.000000   \n",
       "3498                        2.4                43    359.750000   \n",
       "5864                        2.3                46    741.500000   \n",
       "\n",
       "             time_diff  \n",
       "3574  39 days 15:33:00  \n",
       "4640  91 days 15:00:00  \n",
       "6938   3 days 23:51:00  \n",
       "3498  97 days 12:26:00  \n",
       "5864 101 days 03:23:00  "
      ]
     },
     "execution_count": 230,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sample(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 231,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['customer_id', 'First Time', 'Recent Time', '# of Orders',\n",
       "       '# of Orders in last 7 days', '# of Orders in last 4 weeks', 'Amount',\n",
       "       'Amount in last 7 days', 'Amount in last 4 weeks',\n",
       "       'Avg_DistanceFromResturant', 'Avg_DeliveryTime', 'average_cost',\n",
       "       'time_diff'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 231,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 232,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2015-06-05 17:21:00\n",
      "2016-01-07 12:42:00\n",
      "2015-06-08 22:07:00\n",
      "2016-01-13 05:54:00\n"
     ]
    }
   ],
   "source": [
    "print(df['First Time'].min())\n",
    "print(df['First Time'].max())\n",
    "\n",
    "print(df['Recent Time'].min())\n",
    "print(df['Recent Time'].max())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Generating RMF metrics"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 233,
   "metadata": {},
   "outputs": [],
   "source": [
    "rename_dict = {\"# of Orders\": \"Frequency\", \"Amount\": \"Monetory\"}\n",
    "df.rename(rename_dict, inplace=True, axis=1)\n",
    "x = (dt.datetime.utcnow() - df['Recent Time'])\n",
    "df['Recency'] = df['Recent Time'].apply(lambda x: (dt.datetime.utcnow() - x).days)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 234,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "customer_id                              int64\n",
       "First Time                      datetime64[ns]\n",
       "Recent Time                     datetime64[ns]\n",
       "Frequency                                int64\n",
       "# of Orders in last 7 days             float64\n",
       "# of Orders in last 4 weeks            float64\n",
       "Monetory                                 int64\n",
       "Amount in last 7 days                    int64\n",
       "Amount in last 4 weeks                   int64\n",
       "Avg_DistanceFromResturant              float64\n",
       "Avg_DeliveryTime                         int64\n",
       "average_cost                           float64\n",
       "time_diff                      timedelta64[ns]\n",
       "Recency                                  int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 234,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Creating quantiles"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 235,
   "metadata": {},
   "outputs": [],
   "source": [
    "quantile_baskets = [0.2, 0.4, 0.6, 0.8, 1]\n",
    "df_quantiles_dict = df.quantile(quantile_baskets).to_dict()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 236,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'customer_id': {0.2: 267988.4, 0.4: 532701.8, 0.6: 802909.6, 0.8: 1075403.8, 1.0: 1355445.0}, 'Frequency': {0.2: 1.0, 0.4: 2.0, 0.6: 3.0, 0.8: 9.0, 1.0: 212.0}, '# of Orders in last 7 days': {0.2: 0.0, 0.4: 0.0, 0.6: 0.0, 0.8: 0.0, 1.0: 14.0}, '# of Orders in last 4 weeks': {0.2: 0.0, 0.4: 0.0, 0.6: 1.0, 0.8: 2.0, 1.0: 46.0}, 'Monetory': {0.2: 218.0, 0.4: 495.0, 0.6: 1036.0, 0.8: 2689.2000000000007, 1.0: 138808.0}, 'Amount in last 7 days': {0.2: 0.0, 0.4: 0.0, 0.6: 0.0, 0.8: 0.0, 1.0: 10150.0}, 'Amount in last 4 weeks': {0.2: 0.0, 0.4: 0.0, 0.6: 66.0, 0.8: 567.0, 1.0: 26853.0}, 'Avg_DistanceFromResturant': {0.2: 1.5, 0.4: 2.1, 0.6: 2.6, 0.8: 3.2, 1.0: 5.9}, 'Avg_DeliveryTime': {0.2: 24.0, 0.4: 32.0, 0.6: 41.0, 0.8: 50.0, 1.0: 83.0}, 'average_cost': {0.2: 111.0, 0.4: 221.65882352941185, 0.6: 348.4571428571428, 0.8: 535.3632183908047, 1.0: 9906.5}, 'Recency': {0.2: 1013.0, 0.4: 1031.0, 0.6: 1060.0, 0.8: 1102.0, 1.0: 1196.0}}\n"
     ]
    }
   ],
   "source": [
    "print(df_quantiles_dict)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 237,
   "metadata": {},
   "outputs": [],
   "source": [
    "def r_score(curr_value, quantile_dict):\n",
    "    for index, quantile in quantile_dict.items():\n",
    "        if curr_value <= quantile:\n",
    "            return quantile_baskets.index(index) + 1\n",
    "    \n",
    "def f_m_score(curr_value, quantile_dict):\n",
    "    for index, quantile in quantile_dict.items():\n",
    "        if curr_value <= quantile:\n",
    "            return len(quantile_dict) - quantile_baskets.index(index)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 238,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['R'] = df['Recency'].apply(lambda x: r_score(x, df_quantiles_dict['Recency']))\n",
    "df['M'] = df['Monetory'].apply(lambda x: f_m_score(x, df_quantiles_dict['Monetory']))\n",
    "df['F'] = df['Frequency'].apply(lambda x: f_m_score(x, df_quantiles_dict['Frequency']))\n",
    "df['RMF'] = df.R.apply(str) + df.M.apply(str) + df.F.apply(str)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 239,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_items([(0.2, 1013.0), (0.4, 1031.0), (0.6, 1060.0), (0.8, 1102.0), (1.0, 1196.0)])"
      ]
     },
     "execution_count": 239,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_quantiles_dict['Recency'].items()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 240,
   "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>customer_id</th>\n",
       "      <th>First Time</th>\n",
       "      <th>Recent Time</th>\n",
       "      <th>Frequency</th>\n",
       "      <th># of Orders in last 7 days</th>\n",
       "      <th># of Orders in last 4 weeks</th>\n",
       "      <th>Monetory</th>\n",
       "      <th>Amount in last 7 days</th>\n",
       "      <th>Amount in last 4 weeks</th>\n",
       "      <th>Avg_DistanceFromResturant</th>\n",
       "      <th>Avg_DeliveryTime</th>\n",
       "      <th>average_cost</th>\n",
       "      <th>time_diff</th>\n",
       "      <th>Recency</th>\n",
       "      <th>R</th>\n",
       "      <th>M</th>\n",
       "      <th>F</th>\n",
       "      <th>RMF</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4529</th>\n",
       "      <td>462939</td>\n",
       "      <td>2015-07-25 17:00:00</td>\n",
       "      <td>2015-08-01 08:12:00</td>\n",
       "      <td>3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1749</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.5</td>\n",
       "      <td>55</td>\n",
       "      <td>583.000000</td>\n",
       "      <td>6 days 15:12:00</td>\n",
       "      <td>1142</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9773</th>\n",
       "      <td>23889</td>\n",
       "      <td>2015-11-13 01:06:00</td>\n",
       "      <td>2015-11-14 22:40:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>1.5</td>\n",
       "      <td>36</td>\n",
       "      <td>32.000000</td>\n",
       "      <td>1 days 21:34:00</td>\n",
       "      <td>1037</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>355</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9876</th>\n",
       "      <td>401275</td>\n",
       "      <td>2015-08-18 07:13:00</td>\n",
       "      <td>2015-08-21 11:29:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>413</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.4</td>\n",
       "      <td>15</td>\n",
       "      <td>413.000000</td>\n",
       "      <td>3 days 04:16:00</td>\n",
       "      <td>1122</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4704</th>\n",
       "      <td>475911</td>\n",
       "      <td>2015-08-31 22:23:00</td>\n",
       "      <td>2015-12-31 05:19:00</td>\n",
       "      <td>3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4648</td>\n",
       "      <td>0</td>\n",
       "      <td>663</td>\n",
       "      <td>2.3</td>\n",
       "      <td>51</td>\n",
       "      <td>1549.333333</td>\n",
       "      <td>121 days 06:56:00</td>\n",
       "      <td>991</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2383</th>\n",
       "      <td>922092</td>\n",
       "      <td>2015-11-01 09:35:00</td>\n",
       "      <td>2015-11-05 20:51:00</td>\n",
       "      <td>7</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>357</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.1</td>\n",
       "      <td>51</td>\n",
       "      <td>51.000000</td>\n",
       "      <td>4 days 11:16:00</td>\n",
       "      <td>1046</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>342</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      customer_id          First Time         Recent Time  Frequency  \\\n",
       "4529       462939 2015-07-25 17:00:00 2015-08-01 08:12:00          3   \n",
       "9773        23889 2015-11-13 01:06:00 2015-11-14 22:40:00          1   \n",
       "9876       401275 2015-08-18 07:13:00 2015-08-21 11:29:00          1   \n",
       "4704       475911 2015-08-31 22:23:00 2015-12-31 05:19:00          3   \n",
       "2383       922092 2015-11-01 09:35:00 2015-11-05 20:51:00          7   \n",
       "\n",
       "      # of Orders in last 7 days  # of Orders in last 4 weeks  Monetory  \\\n",
       "4529                         0.0                          0.0      1749   \n",
       "9773                         0.0                          1.0        32   \n",
       "9876                         0.0                          0.0       413   \n",
       "4704                         0.0                          2.0      4648   \n",
       "2383                         0.0                          0.0       357   \n",
       "\n",
       "      Amount in last 7 days  Amount in last 4 weeks  \\\n",
       "4529                      0                       0   \n",
       "9773                      0                      32   \n",
       "9876                      0                       0   \n",
       "4704                      0                     663   \n",
       "2383                      0                       0   \n",
       "\n",
       "      Avg_DistanceFromResturant  Avg_DeliveryTime  average_cost  \\\n",
       "4529                        2.5                55    583.000000   \n",
       "9773                        1.5                36     32.000000   \n",
       "9876                        2.4                15    413.000000   \n",
       "4704                        2.3                51   1549.333333   \n",
       "2383                        2.1                51     51.000000   \n",
       "\n",
       "             time_diff  Recency  R  M  F  RMF  \n",
       "4529   6 days 15:12:00     1142  5  2  3  523  \n",
       "9773   1 days 21:34:00     1037  3  5  5  355  \n",
       "9876   3 days 04:16:00     1122  5  4  5  545  \n",
       "4704 121 days 06:56:00      991  1  1  3  113  \n",
       "2383   4 days 11:16:00     1046  3  4  2  342  "
      ]
     },
     "execution_count": 240,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sample(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 241,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(632, 18)"
      ]
     },
     "execution_count": 241,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['RMF'] == '111'].shape"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### We have decent number of customers to target in the first basket\n",
    "### Explore the baskets having RMF 555, looks like they have placed only one "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 247,
   "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>customer_id</th>\n",
       "      <th>First Time</th>\n",
       "      <th>Recent Time</th>\n",
       "      <th>Frequency</th>\n",
       "      <th># of Orders in last 7 days</th>\n",
       "      <th># of Orders in last 4 weeks</th>\n",
       "      <th>Monetory</th>\n",
       "      <th>Amount in last 7 days</th>\n",
       "      <th>Amount in last 4 weeks</th>\n",
       "      <th>Avg_DistanceFromResturant</th>\n",
       "      <th>Avg_DeliveryTime</th>\n",
       "      <th>average_cost</th>\n",
       "      <th>time_diff</th>\n",
       "      <th>Recency</th>\n",
       "      <th>R</th>\n",
       "      <th>M</th>\n",
       "      <th>F</th>\n",
       "      <th>RMF</th>\n",
       "      <th>mean</th>\n",
       "      <th>7_days_propensity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6365</th>\n",
       "      <td>1162834</td>\n",
       "      <td>2015-08-02 09:15:00</td>\n",
       "      <td>2015-08-02 21:05:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>99</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>34</td>\n",
       "      <td>99.0</td>\n",
       "      <td>0 days 11:50:00</td>\n",
       "      <td>1141</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6392</th>\n",
       "      <td>574614</td>\n",
       "      <td>2015-08-23 19:30:00</td>\n",
       "      <td>2015-08-26 06:48:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>167</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.4</td>\n",
       "      <td>29</td>\n",
       "      <td>167.0</td>\n",
       "      <td>2 days 11:18:00</td>\n",
       "      <td>1118</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.003437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6399</th>\n",
       "      <td>1214823</td>\n",
       "      <td>2015-06-23 18:03:00</td>\n",
       "      <td>2015-06-26 14:28:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>109</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>35</td>\n",
       "      <td>109.0</td>\n",
       "      <td>2 days 20:25:00</td>\n",
       "      <td>1178</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.003437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6408</th>\n",
       "      <td>679331</td>\n",
       "      <td>2015-08-16 00:16:00</td>\n",
       "      <td>2015-08-20 22:27:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>86</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.7</td>\n",
       "      <td>44</td>\n",
       "      <td>86.0</td>\n",
       "      <td>4 days 22:11:00</td>\n",
       "      <td>1123</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.059540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6413</th>\n",
       "      <td>575306</td>\n",
       "      <td>2015-09-09 09:34:00</td>\n",
       "      <td>2015-09-09 10:32:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>167</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.7</td>\n",
       "      <td>32</td>\n",
       "      <td>167.0</td>\n",
       "      <td>0 days 00:58:00</td>\n",
       "      <td>1103</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6415</th>\n",
       "      <td>168077</td>\n",
       "      <td>2015-06-18 07:38:00</td>\n",
       "      <td>2015-06-18 11:58:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>158</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>40</td>\n",
       "      <td>158.0</td>\n",
       "      <td>0 days 04:20:00</td>\n",
       "      <td>1186</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6426</th>\n",
       "      <td>456971</td>\n",
       "      <td>2015-07-14 22:27:00</td>\n",
       "      <td>2015-07-19 14:28:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>60</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.6</td>\n",
       "      <td>27</td>\n",
       "      <td>60.0</td>\n",
       "      <td>4 days 16:01:00</td>\n",
       "      <td>1155</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.059540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6459</th>\n",
       "      <td>642126</td>\n",
       "      <td>2015-08-18 09:54:00</td>\n",
       "      <td>2015-08-22 06:11:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>158</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>27</td>\n",
       "      <td>158.0</td>\n",
       "      <td>3 days 20:17:00</td>\n",
       "      <td>1122</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.021604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6467</th>\n",
       "      <td>428629</td>\n",
       "      <td>2015-07-31 11:14:00</td>\n",
       "      <td>2015-07-31 19:02:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.6</td>\n",
       "      <td>32</td>\n",
       "      <td>45.0</td>\n",
       "      <td>0 days 07:48:00</td>\n",
       "      <td>1143</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6469</th>\n",
       "      <td>418352</td>\n",
       "      <td>2015-06-25 09:51:00</td>\n",
       "      <td>2015-06-27 19:51:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>194</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.9</td>\n",
       "      <td>50</td>\n",
       "      <td>194.0</td>\n",
       "      <td>2 days 10:00:00</td>\n",
       "      <td>1177</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.003437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6478</th>\n",
       "      <td>518410</td>\n",
       "      <td>2015-08-16 14:58:00</td>\n",
       "      <td>2015-08-17 00:16:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>31</td>\n",
       "      <td>26.0</td>\n",
       "      <td>0 days 09:18:00</td>\n",
       "      <td>1127</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6493</th>\n",
       "      <td>702881</td>\n",
       "      <td>2015-09-06 14:15:00</td>\n",
       "      <td>2015-09-09 04:08:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>60</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.9</td>\n",
       "      <td>17</td>\n",
       "      <td>60.0</td>\n",
       "      <td>2 days 13:53:00</td>\n",
       "      <td>1104</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.003437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6500</th>\n",
       "      <td>508439</td>\n",
       "      <td>2015-08-31 22:56:00</td>\n",
       "      <td>2015-09-02 16:09:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>91</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.4</td>\n",
       "      <td>64</td>\n",
       "      <td>91.0</td>\n",
       "      <td>1 days 17:13:00</td>\n",
       "      <td>1110</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6517</th>\n",
       "      <td>274398</td>\n",
       "      <td>2015-07-11 08:59:00</td>\n",
       "      <td>2015-07-12 12:15:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>179</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.2</td>\n",
       "      <td>15</td>\n",
       "      <td>179.0</td>\n",
       "      <td>1 days 03:16:00</td>\n",
       "      <td>1162</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6522</th>\n",
       "      <td>195504</td>\n",
       "      <td>2015-08-28 21:17:00</td>\n",
       "      <td>2015-08-30 14:19:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>116</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>37</td>\n",
       "      <td>116.0</td>\n",
       "      <td>1 days 17:02:00</td>\n",
       "      <td>1113</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6530</th>\n",
       "      <td>631241</td>\n",
       "      <td>2015-08-22 06:32:00</td>\n",
       "      <td>2015-08-24 04:05:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>114</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.9</td>\n",
       "      <td>56</td>\n",
       "      <td>114.0</td>\n",
       "      <td>1 days 21:33:00</td>\n",
       "      <td>1120</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6541</th>\n",
       "      <td>394108</td>\n",
       "      <td>2015-07-10 02:00:00</td>\n",
       "      <td>2015-07-14 09:10:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>95</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.6</td>\n",
       "      <td>32</td>\n",
       "      <td>95.0</td>\n",
       "      <td>4 days 07:10:00</td>\n",
       "      <td>1160</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.059540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6547</th>\n",
       "      <td>353058</td>\n",
       "      <td>2015-07-21 11:08:00</td>\n",
       "      <td>2015-07-23 16:16:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.1</td>\n",
       "      <td>52</td>\n",
       "      <td>40.0</td>\n",
       "      <td>2 days 05:08:00</td>\n",
       "      <td>1151</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.003437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6548</th>\n",
       "      <td>572784</td>\n",
       "      <td>2015-09-02 06:57:00</td>\n",
       "      <td>2015-09-04 12:01:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.7</td>\n",
       "      <td>33</td>\n",
       "      <td>13.0</td>\n",
       "      <td>2 days 05:04:00</td>\n",
       "      <td>1108</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.003437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6553</th>\n",
       "      <td>572327</td>\n",
       "      <td>2015-08-21 00:43:00</td>\n",
       "      <td>2015-08-25 01:32:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>30</td>\n",
       "      <td>16.0</td>\n",
       "      <td>4 days 00:49:00</td>\n",
       "      <td>1119</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.059540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6584</th>\n",
       "      <td>453319</td>\n",
       "      <td>2015-07-09 22:07:00</td>\n",
       "      <td>2015-07-11 20:01:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>48</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1 days 21:54:00</td>\n",
       "      <td>1163</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6589</th>\n",
       "      <td>980452</td>\n",
       "      <td>2015-08-09 12:48:00</td>\n",
       "      <td>2015-08-12 12:59:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>141</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>28</td>\n",
       "      <td>141.0</td>\n",
       "      <td>3 days 00:11:00</td>\n",
       "      <td>1131</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.021604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6592</th>\n",
       "      <td>593680</td>\n",
       "      <td>2015-08-20 17:38:00</td>\n",
       "      <td>2015-08-21 13:13:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>201</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.5</td>\n",
       "      <td>50</td>\n",
       "      <td>201.0</td>\n",
       "      <td>0 days 19:35:00</td>\n",
       "      <td>1122</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6595</th>\n",
       "      <td>24650</td>\n",
       "      <td>2015-08-02 02:45:00</td>\n",
       "      <td>2015-08-02 21:56:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>54</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>44</td>\n",
       "      <td>54.0</td>\n",
       "      <td>0 days 19:11:00</td>\n",
       "      <td>1141</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6599</th>\n",
       "      <td>521081</td>\n",
       "      <td>2015-08-25 10:45:00</td>\n",
       "      <td>2015-08-26 11:30:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>79</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>32</td>\n",
       "      <td>79.0</td>\n",
       "      <td>1 days 00:45:00</td>\n",
       "      <td>1117</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6602</th>\n",
       "      <td>561155</td>\n",
       "      <td>2015-07-31 19:32:00</td>\n",
       "      <td>2015-08-05 14:20:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>23</td>\n",
       "      <td>38.0</td>\n",
       "      <td>4 days 18:48:00</td>\n",
       "      <td>1138</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.059540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6609</th>\n",
       "      <td>1355283</td>\n",
       "      <td>2015-07-28 22:11:00</td>\n",
       "      <td>2015-07-29 17:56:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>51</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>38</td>\n",
       "      <td>51.0</td>\n",
       "      <td>0 days 19:45:00</td>\n",
       "      <td>1145</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6610</th>\n",
       "      <td>346060</td>\n",
       "      <td>2015-07-05 00:52:00</td>\n",
       "      <td>2015-07-09 22:33:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>211</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.7</td>\n",
       "      <td>49</td>\n",
       "      <td>211.0</td>\n",
       "      <td>4 days 21:41:00</td>\n",
       "      <td>1165</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.059540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6639</th>\n",
       "      <td>447365</td>\n",
       "      <td>2015-07-28 21:38:00</td>\n",
       "      <td>2015-07-30 03:55:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.3</td>\n",
       "      <td>33</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1 days 06:17:00</td>\n",
       "      <td>1145</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6657</th>\n",
       "      <td>984263</td>\n",
       "      <td>2015-08-27 10:20:00</td>\n",
       "      <td>2015-08-30 11:59:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>211</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.2</td>\n",
       "      <td>30</td>\n",
       "      <td>211.0</td>\n",
       "      <td>3 days 01:39:00</td>\n",
       "      <td>1113</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.021604</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9822</th>\n",
       "      <td>585619</td>\n",
       "      <td>2015-08-02 17:53:00</td>\n",
       "      <td>2015-08-03 22:24:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>121</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>22</td>\n",
       "      <td>121.0</td>\n",
       "      <td>1 days 04:31:00</td>\n",
       "      <td>1140</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9823</th>\n",
       "      <td>406698</td>\n",
       "      <td>2015-08-10 02:46:00</td>\n",
       "      <td>2015-08-11 19:05:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>22</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1 days 16:19:00</td>\n",
       "      <td>1132</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9830</th>\n",
       "      <td>113803</td>\n",
       "      <td>2015-07-04 02:26:00</td>\n",
       "      <td>2015-07-05 12:09:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>131</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.6</td>\n",
       "      <td>52</td>\n",
       "      <td>131.0</td>\n",
       "      <td>1 days 09:43:00</td>\n",
       "      <td>1169</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9833</th>\n",
       "      <td>659143</td>\n",
       "      <td>2015-09-03 21:41:00</td>\n",
       "      <td>2015-09-05 10:18:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>162</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.5</td>\n",
       "      <td>54</td>\n",
       "      <td>162.0</td>\n",
       "      <td>1 days 12:37:00</td>\n",
       "      <td>1107</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9835</th>\n",
       "      <td>1281697</td>\n",
       "      <td>2015-08-27 09:46:00</td>\n",
       "      <td>2015-08-30 12:33:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>171</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.4</td>\n",
       "      <td>27</td>\n",
       "      <td>171.0</td>\n",
       "      <td>3 days 02:47:00</td>\n",
       "      <td>1113</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.021604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9839</th>\n",
       "      <td>399075</td>\n",
       "      <td>2015-06-22 18:44:00</td>\n",
       "      <td>2015-06-23 22:31:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>39</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>39</td>\n",
       "      <td>39.0</td>\n",
       "      <td>1 days 03:47:00</td>\n",
       "      <td>1181</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9842</th>\n",
       "      <td>515740</td>\n",
       "      <td>2015-08-14 10:46:00</td>\n",
       "      <td>2015-08-18 11:24:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>194</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>30</td>\n",
       "      <td>194.0</td>\n",
       "      <td>4 days 00:38:00</td>\n",
       "      <td>1125</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.059540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9846</th>\n",
       "      <td>433976</td>\n",
       "      <td>2015-07-17 13:50:00</td>\n",
       "      <td>2015-07-21 01:33:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>185</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.6</td>\n",
       "      <td>64</td>\n",
       "      <td>185.0</td>\n",
       "      <td>3 days 11:43:00</td>\n",
       "      <td>1154</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.021604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9861</th>\n",
       "      <td>426903</td>\n",
       "      <td>2015-07-15 02:47:00</td>\n",
       "      <td>2015-07-15 11:16:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>129</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>32</td>\n",
       "      <td>129.0</td>\n",
       "      <td>0 days 08:29:00</td>\n",
       "      <td>1159</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9864</th>\n",
       "      <td>444824</td>\n",
       "      <td>2015-07-16 20:20:00</td>\n",
       "      <td>2015-07-17 09:23:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>117</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.9</td>\n",
       "      <td>55</td>\n",
       "      <td>117.0</td>\n",
       "      <td>0 days 13:03:00</td>\n",
       "      <td>1157</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9869</th>\n",
       "      <td>593142</td>\n",
       "      <td>2015-09-05 22:41:00</td>\n",
       "      <td>2015-09-09 17:56:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>115</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.8</td>\n",
       "      <td>15</td>\n",
       "      <td>115.0</td>\n",
       "      <td>3 days 19:15:00</td>\n",
       "      <td>1103</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.021604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9874</th>\n",
       "      <td>647824</td>\n",
       "      <td>2015-09-06 04:40:00</td>\n",
       "      <td>2015-09-07 07:41:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>200</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.1</td>\n",
       "      <td>41</td>\n",
       "      <td>200.0</td>\n",
       "      <td>1 days 03:01:00</td>\n",
       "      <td>1105</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9877</th>\n",
       "      <td>571561</td>\n",
       "      <td>2015-08-30 22:00:00</td>\n",
       "      <td>2015-08-31 18:28:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.4</td>\n",
       "      <td>55</td>\n",
       "      <td>40.0</td>\n",
       "      <td>0 days 20:28:00</td>\n",
       "      <td>1112</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9884</th>\n",
       "      <td>554937</td>\n",
       "      <td>2015-08-24 13:42:00</td>\n",
       "      <td>2015-08-26 01:52:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>134</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.8</td>\n",
       "      <td>28</td>\n",
       "      <td>134.0</td>\n",
       "      <td>1 days 12:10:00</td>\n",
       "      <td>1118</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9886</th>\n",
       "      <td>394742</td>\n",
       "      <td>2015-07-22 10:27:00</td>\n",
       "      <td>2015-07-26 17:12:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>117</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.3</td>\n",
       "      <td>28</td>\n",
       "      <td>117.0</td>\n",
       "      <td>4 days 06:45:00</td>\n",
       "      <td>1148</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.059540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9887</th>\n",
       "      <td>599219</td>\n",
       "      <td>2015-08-22 01:15:00</td>\n",
       "      <td>2015-08-25 08:43:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.3</td>\n",
       "      <td>17</td>\n",
       "      <td>48.0</td>\n",
       "      <td>3 days 07:28:00</td>\n",
       "      <td>1118</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.021604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9895</th>\n",
       "      <td>382875</td>\n",
       "      <td>2015-07-05 09:31:00</td>\n",
       "      <td>2015-07-05 16:56:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>127</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>47</td>\n",
       "      <td>127.0</td>\n",
       "      <td>0 days 07:25:00</td>\n",
       "      <td>1169</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9897</th>\n",
       "      <td>378001</td>\n",
       "      <td>2015-07-22 18:48:00</td>\n",
       "      <td>2015-07-26 03:23:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>88</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.5</td>\n",
       "      <td>59</td>\n",
       "      <td>88.0</td>\n",
       "      <td>3 days 08:35:00</td>\n",
       "      <td>1149</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.021604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9898</th>\n",
       "      <td>460874</td>\n",
       "      <td>2015-07-27 08:18:00</td>\n",
       "      <td>2015-07-31 15:54:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>53</td>\n",
       "      <td>15.0</td>\n",
       "      <td>4 days 07:36:00</td>\n",
       "      <td>1143</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.059540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9907</th>\n",
       "      <td>1241939</td>\n",
       "      <td>2015-08-26 14:59:00</td>\n",
       "      <td>2015-08-28 16:37:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>49</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.5</td>\n",
       "      <td>37</td>\n",
       "      <td>49.0</td>\n",
       "      <td>2 days 01:38:00</td>\n",
       "      <td>1115</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.003437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9924</th>\n",
       "      <td>540705</td>\n",
       "      <td>2015-08-17 13:03:00</td>\n",
       "      <td>2015-08-20 16:22:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>191</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.4</td>\n",
       "      <td>21</td>\n",
       "      <td>191.0</td>\n",
       "      <td>3 days 03:19:00</td>\n",
       "      <td>1123</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.021604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9926</th>\n",
       "      <td>286928</td>\n",
       "      <td>2015-07-25 22:24:00</td>\n",
       "      <td>2015-07-29 23:29:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>176</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.6</td>\n",
       "      <td>17</td>\n",
       "      <td>176.0</td>\n",
       "      <td>4 days 01:05:00</td>\n",
       "      <td>1145</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.059540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9945</th>\n",
       "      <td>1224513</td>\n",
       "      <td>2015-07-31 18:03:00</td>\n",
       "      <td>2015-08-04 09:21:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>54</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.5</td>\n",
       "      <td>30</td>\n",
       "      <td>54.0</td>\n",
       "      <td>3 days 15:18:00</td>\n",
       "      <td>1139</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.021604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9962</th>\n",
       "      <td>341891</td>\n",
       "      <td>2015-06-29 10:05:00</td>\n",
       "      <td>2015-07-03 02:18:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>107</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>31</td>\n",
       "      <td>107.0</td>\n",
       "      <td>3 days 16:13:00</td>\n",
       "      <td>1172</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.021604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9963</th>\n",
       "      <td>490622</td>\n",
       "      <td>2015-07-26 14:42:00</td>\n",
       "      <td>2015-07-27 10:38:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>99</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.7</td>\n",
       "      <td>56</td>\n",
       "      <td>99.0</td>\n",
       "      <td>0 days 19:56:00</td>\n",
       "      <td>1147</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9968</th>\n",
       "      <td>481215</td>\n",
       "      <td>2015-08-05 05:37:00</td>\n",
       "      <td>2015-08-05 09:00:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>190</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3.2</td>\n",
       "      <td>37</td>\n",
       "      <td>190.0</td>\n",
       "      <td>0 days 03:23:00</td>\n",
       "      <td>1138</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9969</th>\n",
       "      <td>546962</td>\n",
       "      <td>2015-08-19 03:22:00</td>\n",
       "      <td>2015-08-23 04:07:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>205</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.1</td>\n",
       "      <td>34</td>\n",
       "      <td>205.0</td>\n",
       "      <td>4 days 00:45:00</td>\n",
       "      <td>1121</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.059540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9972</th>\n",
       "      <td>22434</td>\n",
       "      <td>2015-07-07 08:34:00</td>\n",
       "      <td>2015-07-08 14:11:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>156</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.8</td>\n",
       "      <td>70</td>\n",
       "      <td>156.0</td>\n",
       "      <td>1 days 05:37:00</td>\n",
       "      <td>1166</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000073</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9987</th>\n",
       "      <td>1192374</td>\n",
       "      <td>2015-08-07 23:04:00</td>\n",
       "      <td>2015-08-11 15:42:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>217</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.8</td>\n",
       "      <td>18</td>\n",
       "      <td>217.0</td>\n",
       "      <td>3 days 16:38:00</td>\n",
       "      <td>1132</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.021604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9992</th>\n",
       "      <td>634959</td>\n",
       "      <td>2015-09-06 23:27:00</td>\n",
       "      <td>2015-09-10 02:48:00</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>80</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1.2</td>\n",
       "      <td>22</td>\n",
       "      <td>80.0</td>\n",
       "      <td>3 days 03:21:00</td>\n",
       "      <td>1103</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>555</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.021604</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>505 rows × 20 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      customer_id          First Time         Recent Time  Frequency  \\\n",
       "6365      1162834 2015-08-02 09:15:00 2015-08-02 21:05:00          1   \n",
       "6392       574614 2015-08-23 19:30:00 2015-08-26 06:48:00          1   \n",
       "6399      1214823 2015-06-23 18:03:00 2015-06-26 14:28:00          1   \n",
       "6408       679331 2015-08-16 00:16:00 2015-08-20 22:27:00          1   \n",
       "6413       575306 2015-09-09 09:34:00 2015-09-09 10:32:00          1   \n",
       "6415       168077 2015-06-18 07:38:00 2015-06-18 11:58:00          1   \n",
       "6426       456971 2015-07-14 22:27:00 2015-07-19 14:28:00          1   \n",
       "6459       642126 2015-08-18 09:54:00 2015-08-22 06:11:00          1   \n",
       "6467       428629 2015-07-31 11:14:00 2015-07-31 19:02:00          1   \n",
       "6469       418352 2015-06-25 09:51:00 2015-06-27 19:51:00          1   \n",
       "6478       518410 2015-08-16 14:58:00 2015-08-17 00:16:00          1   \n",
       "6493       702881 2015-09-06 14:15:00 2015-09-09 04:08:00          1   \n",
       "6500       508439 2015-08-31 22:56:00 2015-09-02 16:09:00          1   \n",
       "6517       274398 2015-07-11 08:59:00 2015-07-12 12:15:00          1   \n",
       "6522       195504 2015-08-28 21:17:00 2015-08-30 14:19:00          1   \n",
       "6530       631241 2015-08-22 06:32:00 2015-08-24 04:05:00          1   \n",
       "6541       394108 2015-07-10 02:00:00 2015-07-14 09:10:00          1   \n",
       "6547       353058 2015-07-21 11:08:00 2015-07-23 16:16:00          1   \n",
       "6548       572784 2015-09-02 06:57:00 2015-09-04 12:01:00          1   \n",
       "6553       572327 2015-08-21 00:43:00 2015-08-25 01:32:00          1   \n",
       "6584       453319 2015-07-09 22:07:00 2015-07-11 20:01:00          1   \n",
       "6589       980452 2015-08-09 12:48:00 2015-08-12 12:59:00          1   \n",
       "6592       593680 2015-08-20 17:38:00 2015-08-21 13:13:00          1   \n",
       "6595        24650 2015-08-02 02:45:00 2015-08-02 21:56:00          1   \n",
       "6599       521081 2015-08-25 10:45:00 2015-08-26 11:30:00          1   \n",
       "6602       561155 2015-07-31 19:32:00 2015-08-05 14:20:00          1   \n",
       "6609      1355283 2015-07-28 22:11:00 2015-07-29 17:56:00          1   \n",
       "6610       346060 2015-07-05 00:52:00 2015-07-09 22:33:00          1   \n",
       "6639       447365 2015-07-28 21:38:00 2015-07-30 03:55:00          1   \n",
       "6657       984263 2015-08-27 10:20:00 2015-08-30 11:59:00          1   \n",
       "...           ...                 ...                 ...        ...   \n",
       "9822       585619 2015-08-02 17:53:00 2015-08-03 22:24:00          1   \n",
       "9823       406698 2015-08-10 02:46:00 2015-08-11 19:05:00          1   \n",
       "9830       113803 2015-07-04 02:26:00 2015-07-05 12:09:00          1   \n",
       "9833       659143 2015-09-03 21:41:00 2015-09-05 10:18:00          1   \n",
       "9835      1281697 2015-08-27 09:46:00 2015-08-30 12:33:00          1   \n",
       "9839       399075 2015-06-22 18:44:00 2015-06-23 22:31:00          1   \n",
       "9842       515740 2015-08-14 10:46:00 2015-08-18 11:24:00          1   \n",
       "9846       433976 2015-07-17 13:50:00 2015-07-21 01:33:00          1   \n",
       "9861       426903 2015-07-15 02:47:00 2015-07-15 11:16:00          1   \n",
       "9864       444824 2015-07-16 20:20:00 2015-07-17 09:23:00          1   \n",
       "9869       593142 2015-09-05 22:41:00 2015-09-09 17:56:00          1   \n",
       "9874       647824 2015-09-06 04:40:00 2015-09-07 07:41:00          1   \n",
       "9877       571561 2015-08-30 22:00:00 2015-08-31 18:28:00          1   \n",
       "9884       554937 2015-08-24 13:42:00 2015-08-26 01:52:00          1   \n",
       "9886       394742 2015-07-22 10:27:00 2015-07-26 17:12:00          1   \n",
       "9887       599219 2015-08-22 01:15:00 2015-08-25 08:43:00          1   \n",
       "9895       382875 2015-07-05 09:31:00 2015-07-05 16:56:00          1   \n",
       "9897       378001 2015-07-22 18:48:00 2015-07-26 03:23:00          1   \n",
       "9898       460874 2015-07-27 08:18:00 2015-07-31 15:54:00          1   \n",
       "9907      1241939 2015-08-26 14:59:00 2015-08-28 16:37:00          1   \n",
       "9924       540705 2015-08-17 13:03:00 2015-08-20 16:22:00          1   \n",
       "9926       286928 2015-07-25 22:24:00 2015-07-29 23:29:00          1   \n",
       "9945      1224513 2015-07-31 18:03:00 2015-08-04 09:21:00          1   \n",
       "9962       341891 2015-06-29 10:05:00 2015-07-03 02:18:00          1   \n",
       "9963       490622 2015-07-26 14:42:00 2015-07-27 10:38:00          1   \n",
       "9968       481215 2015-08-05 05:37:00 2015-08-05 09:00:00          1   \n",
       "9969       546962 2015-08-19 03:22:00 2015-08-23 04:07:00          1   \n",
       "9972        22434 2015-07-07 08:34:00 2015-07-08 14:11:00          1   \n",
       "9987      1192374 2015-08-07 23:04:00 2015-08-11 15:42:00          1   \n",
       "9992       634959 2015-09-06 23:27:00 2015-09-10 02:48:00          1   \n",
       "\n",
       "      # of Orders in last 7 days  # of Orders in last 4 weeks  Monetory  \\\n",
       "6365                         0.0                          0.0        99   \n",
       "6392                         0.0                          0.0       167   \n",
       "6399                         0.0                          0.0       109   \n",
       "6408                         0.0                          0.0        86   \n",
       "6413                         0.0                          0.0       167   \n",
       "6415                         0.0                          0.0       158   \n",
       "6426                         0.0                          0.0        60   \n",
       "6459                         0.0                          0.0       158   \n",
       "6467                         0.0                          0.0        45   \n",
       "6469                         0.0                          0.0       194   \n",
       "6478                         0.0                          0.0        26   \n",
       "6493                         0.0                          0.0        60   \n",
       "6500                         0.0                          0.0        91   \n",
       "6517                         0.0                          0.0       179   \n",
       "6522                         0.0                          0.0       116   \n",
       "6530                         0.0                          0.0       114   \n",
       "6541                         0.0                          0.0        95   \n",
       "6547                         0.0                          0.0        40   \n",
       "6548                         0.0                          0.0        13   \n",
       "6553                         0.0                          0.0        16   \n",
       "6584                         0.0                          0.0         6   \n",
       "6589                         0.0                          0.0       141   \n",
       "6592                         0.0                          0.0       201   \n",
       "6595                         0.0                          0.0        54   \n",
       "6599                         0.0                          0.0        79   \n",
       "6602                         0.0                          0.0        38   \n",
       "6609                         0.0                          0.0        51   \n",
       "6610                         0.0                          0.0       211   \n",
       "6639                         0.0                          0.0         3   \n",
       "6657                         0.0                          0.0       211   \n",
       "...                          ...                          ...       ...   \n",
       "9822                         0.0                          0.0       121   \n",
       "9823                         0.0                          0.0         5   \n",
       "9830                         0.0                          0.0       131   \n",
       "9833                         0.0                          0.0       162   \n",
       "9835                         0.0                          0.0       171   \n",
       "9839                         0.0                          0.0        39   \n",
       "9842                         0.0                          0.0       194   \n",
       "9846                         0.0                          0.0       185   \n",
       "9861                         0.0                          0.0       129   \n",
       "9864                         0.0                          0.0       117   \n",
       "9869                         0.0                          0.0       115   \n",
       "9874                         0.0                          0.0       200   \n",
       "9877                         0.0                          0.0        40   \n",
       "9884                         0.0                          0.0       134   \n",
       "9886                         0.0                          0.0       117   \n",
       "9887                         0.0                          0.0        48   \n",
       "9895                         0.0                          0.0       127   \n",
       "9897                         0.0                          0.0        88   \n",
       "9898                         0.0                          0.0        15   \n",
       "9907                         0.0                          0.0        49   \n",
       "9924                         0.0                          0.0       191   \n",
       "9926                         0.0                          0.0       176   \n",
       "9945                         0.0                          0.0        54   \n",
       "9962                         0.0                          0.0       107   \n",
       "9963                         0.0                          0.0        99   \n",
       "9968                         0.0                          0.0       190   \n",
       "9969                         0.0                          0.0       205   \n",
       "9972                         0.0                          0.0       156   \n",
       "9987                         0.0                          0.0       217   \n",
       "9992                         0.0                          0.0        80   \n",
       "\n",
       "      Amount in last 7 days  Amount in last 4 weeks  \\\n",
       "6365                      0                       0   \n",
       "6392                      0                       0   \n",
       "6399                      0                       0   \n",
       "6408                      0                       0   \n",
       "6413                      0                       0   \n",
       "6415                      0                       0   \n",
       "6426                      0                       0   \n",
       "6459                      0                       0   \n",
       "6467                      0                       0   \n",
       "6469                      0                       0   \n",
       "6478                      0                       0   \n",
       "6493                      0                       0   \n",
       "6500                      0                       0   \n",
       "6517                      0                       0   \n",
       "6522                      0                       0   \n",
       "6530                      0                       0   \n",
       "6541                      0                       0   \n",
       "6547                      0                       0   \n",
       "6548                      0                       0   \n",
       "6553                      0                       0   \n",
       "6584                      0                       0   \n",
       "6589                      0                       0   \n",
       "6592                      0                       0   \n",
       "6595                      0                       0   \n",
       "6599                      0                       0   \n",
       "6602                      0                       0   \n",
       "6609                      0                       0   \n",
       "6610                      0                       0   \n",
       "6639                      0                       0   \n",
       "6657                      0                       0   \n",
       "...                     ...                     ...   \n",
       "9822                      0                       0   \n",
       "9823                      0                       0   \n",
       "9830                      0                       0   \n",
       "9833                      0                       0   \n",
       "9835                      0                       0   \n",
       "9839                      0                       0   \n",
       "9842                      0                       0   \n",
       "9846                      0                       0   \n",
       "9861                      0                       0   \n",
       "9864                      0                       0   \n",
       "9869                      0                       0   \n",
       "9874                      0                       0   \n",
       "9877                      0                       0   \n",
       "9884                      0                       0   \n",
       "9886                      0                       0   \n",
       "9887                      0                       0   \n",
       "9895                      0                       0   \n",
       "9897                      0                       0   \n",
       "9898                      0                       0   \n",
       "9907                      0                       0   \n",
       "9924                      0                       0   \n",
       "9926                      0                       0   \n",
       "9945                      0                       0   \n",
       "9962                      0                       0   \n",
       "9963                      0                       0   \n",
       "9968                      0                       0   \n",
       "9969                      0                       0   \n",
       "9972                      0                       0   \n",
       "9987                      0                       0   \n",
       "9992                      0                       0   \n",
       "\n",
       "      Avg_DistanceFromResturant  Avg_DeliveryTime  average_cost  \\\n",
       "6365                        0.9                34          99.0   \n",
       "6392                        0.4                29         167.0   \n",
       "6399                        2.0                35         109.0   \n",
       "6408                        3.7                44          86.0   \n",
       "6413                        3.7                32         167.0   \n",
       "6415                        1.1                40         158.0   \n",
       "6426                        0.6                27          60.0   \n",
       "6459                        1.3                27         158.0   \n",
       "6467                        2.6                32          45.0   \n",
       "6469                        0.9                50         194.0   \n",
       "6478                        1.2                31          26.0   \n",
       "6493                        3.9                17          60.0   \n",
       "6500                        2.4                64          91.0   \n",
       "6517                        2.2                15         179.0   \n",
       "6522                        3.0                37         116.0   \n",
       "6530                        1.9                56         114.0   \n",
       "6541                        1.6                32          95.0   \n",
       "6547                        3.1                52          40.0   \n",
       "6548                        1.7                33          13.0   \n",
       "6553                        4.0                30          16.0   \n",
       "6584                        2.9                48           6.0   \n",
       "6589                        1.8                28         141.0   \n",
       "6592                        3.5                50         201.0   \n",
       "6595                        1.4                44          54.0   \n",
       "6599                        1.8                32          79.0   \n",
       "6602                        1.3                23          38.0   \n",
       "6609                        1.8                38          51.0   \n",
       "6610                        2.7                49         211.0   \n",
       "6639                        3.3                33           3.0   \n",
       "6657                        0.2                30         211.0   \n",
       "...                         ...               ...           ...   \n",
       "9822                        2.0                22         121.0   \n",
       "9823                        1.4                22           5.0   \n",
       "9830                        1.6                52         131.0   \n",
       "9833                        2.5                54         162.0   \n",
       "9835                        1.4                27         171.0   \n",
       "9839                        4.0                39          39.0   \n",
       "9842                        0.1                30         194.0   \n",
       "9846                        3.6                64         185.0   \n",
       "9861                        2.0                32         129.0   \n",
       "9864                        2.9                55         117.0   \n",
       "9869                        2.8                15         115.0   \n",
       "9874                        0.1                41         200.0   \n",
       "9877                        2.4                55          40.0   \n",
       "9884                        2.8                28         134.0   \n",
       "9886                        2.3                28         117.0   \n",
       "9887                        1.3                17          48.0   \n",
       "9895                        1.8                47         127.0   \n",
       "9897                        0.5                59          88.0   \n",
       "9898                        1.1                53          15.0   \n",
       "9907                        2.5                37          49.0   \n",
       "9924                        0.4                21         191.0   \n",
       "9926                        1.6                17         176.0   \n",
       "9945                        2.5                30          54.0   \n",
       "9962                        3.0                31         107.0   \n",
       "9963                        0.7                56          99.0   \n",
       "9968                        3.2                37         190.0   \n",
       "9969                        1.1                34         205.0   \n",
       "9972                        2.8                70         156.0   \n",
       "9987                        1.8                18         217.0   \n",
       "9992                        1.2                22          80.0   \n",
       "\n",
       "           time_diff  Recency  R  M  F  RMF  mean  7_days_propensity  \n",
       "6365 0 days 11:50:00     1141  5  5  5  555   0.0           0.000000  \n",
       "6392 2 days 11:18:00     1118  5  5  5  555   2.0           0.003437  \n",
       "6399 2 days 20:25:00     1178  5  5  5  555   2.0           0.003437  \n",
       "6408 4 days 22:11:00     1123  5  5  5  555   4.0           0.059540  \n",
       "6413 0 days 00:58:00     1103  5  5  5  555   0.0           0.000000  \n",
       "6415 0 days 04:20:00     1186  5  5  5  555   0.0           0.000000  \n",
       "6426 4 days 16:01:00     1155  5  5  5  555   4.0           0.059540  \n",
       "6459 3 days 20:17:00     1122  5  5  5  555   3.0           0.021604  \n",
       "6467 0 days 07:48:00     1143  5  5  5  555   0.0           0.000000  \n",
       "6469 2 days 10:00:00     1177  5  5  5  555   2.0           0.003437  \n",
       "6478 0 days 09:18:00     1127  5  5  5  555   0.0           0.000000  \n",
       "6493 2 days 13:53:00     1104  5  5  5  555   2.0           0.003437  \n",
       "6500 1 days 17:13:00     1110  5  5  5  555   1.0           0.000073  \n",
       "6517 1 days 03:16:00     1162  5  5  5  555   1.0           0.000073  \n",
       "6522 1 days 17:02:00     1113  5  5  5  555   1.0           0.000073  \n",
       "6530 1 days 21:33:00     1120  5  5  5  555   1.0           0.000073  \n",
       "6541 4 days 07:10:00     1160  5  5  5  555   4.0           0.059540  \n",
       "6547 2 days 05:08:00     1151  5  5  5  555   2.0           0.003437  \n",
       "6548 2 days 05:04:00     1108  5  5  5  555   2.0           0.003437  \n",
       "6553 4 days 00:49:00     1119  5  5  5  555   4.0           0.059540  \n",
       "6584 1 days 21:54:00     1163  5  5  5  555   1.0           0.000073  \n",
       "6589 3 days 00:11:00     1131  5  5  5  555   3.0           0.021604  \n",
       "6592 0 days 19:35:00     1122  5  5  5  555   0.0           0.000000  \n",
       "6595 0 days 19:11:00     1141  5  5  5  555   0.0           0.000000  \n",
       "6599 1 days 00:45:00     1117  5  5  5  555   1.0           0.000073  \n",
       "6602 4 days 18:48:00     1138  5  5  5  555   4.0           0.059540  \n",
       "6609 0 days 19:45:00     1145  5  5  5  555   0.0           0.000000  \n",
       "6610 4 days 21:41:00     1165  5  5  5  555   4.0           0.059540  \n",
       "6639 1 days 06:17:00     1145  5  5  5  555   1.0           0.000073  \n",
       "6657 3 days 01:39:00     1113  5  5  5  555   3.0           0.021604  \n",
       "...              ...      ... .. .. ..  ...   ...                ...  \n",
       "9822 1 days 04:31:00     1140  5  5  5  555   1.0           0.000073  \n",
       "9823 1 days 16:19:00     1132  5  5  5  555   1.0           0.000073  \n",
       "9830 1 days 09:43:00     1169  5  5  5  555   1.0           0.000073  \n",
       "9833 1 days 12:37:00     1107  5  5  5  555   1.0           0.000073  \n",
       "9835 3 days 02:47:00     1113  5  5  5  555   3.0           0.021604  \n",
       "9839 1 days 03:47:00     1181  5  5  5  555   1.0           0.000073  \n",
       "9842 4 days 00:38:00     1125  5  5  5  555   4.0           0.059540  \n",
       "9846 3 days 11:43:00     1154  5  5  5  555   3.0           0.021604  \n",
       "9861 0 days 08:29:00     1159  5  5  5  555   0.0           0.000000  \n",
       "9864 0 days 13:03:00     1157  5  5  5  555   0.0           0.000000  \n",
       "9869 3 days 19:15:00     1103  5  5  5  555   3.0           0.021604  \n",
       "9874 1 days 03:01:00     1105  5  5  5  555   1.0           0.000073  \n",
       "9877 0 days 20:28:00     1112  5  5  5  555   0.0           0.000000  \n",
       "9884 1 days 12:10:00     1118  5  5  5  555   1.0           0.000073  \n",
       "9886 4 days 06:45:00     1148  5  5  5  555   4.0           0.059540  \n",
       "9887 3 days 07:28:00     1118  5  5  5  555   3.0           0.021604  \n",
       "9895 0 days 07:25:00     1169  5  5  5  555   0.0           0.000000  \n",
       "9897 3 days 08:35:00     1149  5  5  5  555   3.0           0.021604  \n",
       "9898 4 days 07:36:00     1143  5  5  5  555   4.0           0.059540  \n",
       "9907 2 days 01:38:00     1115  5  5  5  555   2.0           0.003437  \n",
       "9924 3 days 03:19:00     1123  5  5  5  555   3.0           0.021604  \n",
       "9926 4 days 01:05:00     1145  5  5  5  555   4.0           0.059540  \n",
       "9945 3 days 15:18:00     1139  5  5  5  555   3.0           0.021604  \n",
       "9962 3 days 16:13:00     1172  5  5  5  555   3.0           0.021604  \n",
       "9963 0 days 19:56:00     1147  5  5  5  555   0.0           0.000000  \n",
       "9968 0 days 03:23:00     1138  5  5  5  555   0.0           0.000000  \n",
       "9969 4 days 00:45:00     1121  5  5  5  555   4.0           0.059540  \n",
       "9972 1 days 05:37:00     1166  5  5  5  555   1.0           0.000073  \n",
       "9987 3 days 16:38:00     1132  5  5  5  555   3.0           0.021604  \n",
       "9992 3 days 03:21:00     1103  5  5  5  555   3.0           0.021604  \n",
       "\n",
       "[505 rows x 20 columns]"
      ]
     },
     "execution_count": 247,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['RMF'] == '555']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 243,
   "metadata": {},
   "outputs": [],
   "source": [
    "window = 7\n",
    "\n",
    "den = math.factorial(window)\n",
    "def buyer_propensity(mean, window):\n",
    "    return np.exp(-mean) * np.power(mean, window) / den\n",
    "\n",
    "\n",
    "df['mean'] = df.time_diff.apply(lambda x: x.days) / df.Frequency\n",
    "df['7_days_propensity'] = df['mean'].apply(lambda x : buyer_propensity(x, window))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 244,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1637, 20)"
      ]
     },
     "execution_count": 244,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['7_days_propensity'] > 0.1].shape"
   ]
  }
 ],
 "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
}