Import data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "layout_dir = 'LH-Upimium/2 Warehouse Layout/'\n",
    "data_dir = 'LH-Upimium/ob_stats_20200204b/'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>wave</th>\n",
       "      <th>sub-wave</th>\n",
       "      <th>created</th>\n",
       "      <th>zone</th>\n",
       "      <th>bin</th>\n",
       "      <th>item</th>\n",
       "      <th>order_qty</th>\n",
       "      <th>pick_qty</th>\n",
       "      <th>status</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AZOYA</td>\n",
       "      <td>AZOYA.1</td>\n",
       "      <td>2019-10-19 08:27:45.350</td>\n",
       "      <td>FAST</td>\n",
       "      <td>16.05.1.04</td>\n",
       "      <td>10001929</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>AZOYA</td>\n",
       "      <td>AZOYA.2</td>\n",
       "      <td>2019-10-19 08:27:45.393</td>\n",
       "      <td>FAST</td>\n",
       "      <td>15.03.3.03</td>\n",
       "      <td>1000040</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>AZOYA</td>\n",
       "      <td>AZOYA.3</td>\n",
       "      <td>2019-10-19 08:27:45.440</td>\n",
       "      <td>FAST</td>\n",
       "      <td>15.03.3.03</td>\n",
       "      <td>1000040</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>AZOYA</td>\n",
       "      <td>AZOYA.4</td>\n",
       "      <td>2019-10-19 08:27:45.490</td>\n",
       "      <td>FAST</td>\n",
       "      <td>12.08.1.2</td>\n",
       "      <td>933830</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>AZOYA</td>\n",
       "      <td>AZOYA.4</td>\n",
       "      <td>2019-10-19 08:27:45.490</td>\n",
       "      <td>FAST</td>\n",
       "      <td>15.02.1.05</td>\n",
       "      <td>1000489</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>C</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215286</th>\n",
       "      <td>67632</td>\n",
       "      <td>67632.4</td>\n",
       "      <td>2020-02-04 09:09:21.687</td>\n",
       "      <td>FAST</td>\n",
       "      <td>18.04.1.09</td>\n",
       "      <td>10001455</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215287</th>\n",
       "      <td>67632</td>\n",
       "      <td>67632.4</td>\n",
       "      <td>2020-02-04 09:09:21.687</td>\n",
       "      <td>FAST</td>\n",
       "      <td>DISPENSARY</td>\n",
       "      <td>PERF502</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215288</th>\n",
       "      <td>67632</td>\n",
       "      <td>67632.4</td>\n",
       "      <td>2020-02-04 09:09:21.687</td>\n",
       "      <td>FAST</td>\n",
       "      <td>22.10.3.02</td>\n",
       "      <td>848030</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215289</th>\n",
       "      <td>67632</td>\n",
       "      <td>67632.4</td>\n",
       "      <td>2020-02-04 09:09:21.687</td>\n",
       "      <td>FAST</td>\n",
       "      <td>22.07.6.15</td>\n",
       "      <td>10002907</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215290</th>\n",
       "      <td>67632</td>\n",
       "      <td>67632.4</td>\n",
       "      <td>2020-02-04 09:09:21.687</td>\n",
       "      <td>FAST</td>\n",
       "      <td>DISPENSARY</td>\n",
       "      <td>PERF80</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>215291 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         wave sub-wave                 created  zone         bin      item  \\\n",
       "0       AZOYA  AZOYA.1 2019-10-19 08:27:45.350  FAST  16.05.1.04  10001929   \n",
       "1       AZOYA  AZOYA.2 2019-10-19 08:27:45.393  FAST  15.03.3.03   1000040   \n",
       "2       AZOYA  AZOYA.3 2019-10-19 08:27:45.440  FAST  15.03.3.03   1000040   \n",
       "3       AZOYA  AZOYA.4 2019-10-19 08:27:45.490  FAST   12.08.1.2    933830   \n",
       "4       AZOYA  AZOYA.4 2019-10-19 08:27:45.490  FAST  15.02.1.05   1000489   \n",
       "...       ...      ...                     ...   ...         ...       ...   \n",
       "215286  67632  67632.4 2020-02-04 09:09:21.687  FAST  18.04.1.09  10001455   \n",
       "215287  67632  67632.4 2020-02-04 09:09:21.687  FAST  DISPENSARY   PERF502   \n",
       "215288  67632  67632.4 2020-02-04 09:09:21.687  FAST  22.10.3.02    848030   \n",
       "215289  67632  67632.4 2020-02-04 09:09:21.687  FAST  22.07.6.15  10002907   \n",
       "215290  67632  67632.4 2020-02-04 09:09:21.687  FAST  DISPENSARY    PERF80   \n",
       "\n",
       "        order_qty  pick_qty status  \n",
       "0               1         1      C  \n",
       "1               2         2      C  \n",
       "2               1         1      C  \n",
       "3               1         1      C  \n",
       "4               1         1      C  \n",
       "...           ...       ...    ...  \n",
       "215286          4         0      O  \n",
       "215287          2         0      O  \n",
       "215288          8         0      O  \n",
       "215289          1         0      O  \n",
       "215290          1         0      O  \n",
       "\n",
       "[215291 rows x 9 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_multi_batch_pick_task = pd.read_csv(data_dir + 'multi_batch_pick_task.csv', names=['wave', 'sub-wave', 'created', 'zone', 'bin', 'item', 'order_qty', 'pick_qty', 'status'])\n",
    "df_multi_batch_pick_task.created = pd.to_datetime(df_multi_batch_pick_task.created)\n",
    "df_multi_batch_pick_task = df_multi_batch_pick_task.sort_values(['created']).reset_index(drop=True)\n",
    "df_multi_batch_pick_task"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>picked</th>\n",
       "      <th>user</th>\n",
       "      <th>subwave</th>\n",
       "      <th>wave</th>\n",
       "      <th>wave_created</th>\n",
       "      <th>zone</th>\n",
       "      <th>bin</th>\n",
       "      <th>item</th>\n",
       "      <th>qty</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2019-10-19 10:22:03.667</td>\n",
       "      <td>Andy</td>\n",
       "      <td>AZOYA.1</td>\n",
       "      <td>AZOYA</td>\n",
       "      <td>2019-10-19 08:27:45.350</td>\n",
       "      <td>FAST</td>\n",
       "      <td>16.05.1.04</td>\n",
       "      <td>10001929</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2019-10-19 10:21:07.687</td>\n",
       "      <td>Andy</td>\n",
       "      <td>AZOYA.2</td>\n",
       "      <td>AZOYA</td>\n",
       "      <td>2019-10-19 08:27:45.393</td>\n",
       "      <td>FAST</td>\n",
       "      <td>15.03.3.03</td>\n",
       "      <td>1000040</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2019-10-19 10:21:07.687</td>\n",
       "      <td>Andy</td>\n",
       "      <td>AZOYA.3</td>\n",
       "      <td>AZOYA</td>\n",
       "      <td>2019-10-19 08:27:45.440</td>\n",
       "      <td>FAST</td>\n",
       "      <td>15.03.3.03</td>\n",
       "      <td>1000040</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2019-10-19 10:01:47.160</td>\n",
       "      <td>Andy</td>\n",
       "      <td>AZOYA.4</td>\n",
       "      <td>AZOYA</td>\n",
       "      <td>2019-10-19 08:27:45.490</td>\n",
       "      <td>FAST</td>\n",
       "      <td>12.08.1.2</td>\n",
       "      <td>933830</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2019-10-19 10:35:12.387</td>\n",
       "      <td>Andy</td>\n",
       "      <td>AZOYA.4</td>\n",
       "      <td>AZOYA</td>\n",
       "      <td>2019-10-19 08:27:45.490</td>\n",
       "      <td>FAST</td>\n",
       "      <td>15.02.1.05</td>\n",
       "      <td>1000489</td>\n",
       "      <td>1</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214194</th>\n",
       "      <td>2020-02-04 09:20:00.253</td>\n",
       "      <td>Out2</td>\n",
       "      <td>67631.20</td>\n",
       "      <td>67631</td>\n",
       "      <td>2020-02-04 08:24:19.773</td>\n",
       "      <td>FAST</td>\n",
       "      <td>14.09.4.04</td>\n",
       "      <td>252255</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214195</th>\n",
       "      <td>2020-02-04 08:48:48.490</td>\n",
       "      <td>Out2</td>\n",
       "      <td>67631.20</td>\n",
       "      <td>67631</td>\n",
       "      <td>2020-02-04 08:24:19.773</td>\n",
       "      <td>FAST</td>\n",
       "      <td>10.09.1.1</td>\n",
       "      <td>269409</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214196</th>\n",
       "      <td>2020-02-04 09:07:55.963</td>\n",
       "      <td>Out2</td>\n",
       "      <td>67631.20</td>\n",
       "      <td>67631</td>\n",
       "      <td>2020-02-04 08:24:19.773</td>\n",
       "      <td>FAST</td>\n",
       "      <td>11.02.1.1</td>\n",
       "      <td>5022</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214197</th>\n",
       "      <td>2020-02-04 09:26:19.793</td>\n",
       "      <td>Out2</td>\n",
       "      <td>67631.20</td>\n",
       "      <td>67631</td>\n",
       "      <td>2020-02-04 08:24:19.773</td>\n",
       "      <td>FAST</td>\n",
       "      <td>19.08.2.03</td>\n",
       "      <td>406333</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214198</th>\n",
       "      <td>2020-02-04 08:54:10.203</td>\n",
       "      <td>Out2</td>\n",
       "      <td>67631.20</td>\n",
       "      <td>67631</td>\n",
       "      <td>2020-02-04 08:24:19.773</td>\n",
       "      <td>FAST</td>\n",
       "      <td>10.07.1.1</td>\n",
       "      <td>377279</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>214199 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        picked  user   subwave   wave            wave_created  \\\n",
       "0      2019-10-19 10:22:03.667  Andy   AZOYA.1  AZOYA 2019-10-19 08:27:45.350   \n",
       "1      2019-10-19 10:21:07.687  Andy   AZOYA.2  AZOYA 2019-10-19 08:27:45.393   \n",
       "2      2019-10-19 10:21:07.687  Andy   AZOYA.3  AZOYA 2019-10-19 08:27:45.440   \n",
       "3      2019-10-19 10:01:47.160  Andy   AZOYA.4  AZOYA 2019-10-19 08:27:45.490   \n",
       "4      2019-10-19 10:35:12.387  Andy   AZOYA.4  AZOYA 2019-10-19 08:27:45.490   \n",
       "...                        ...   ...       ...    ...                     ...   \n",
       "214194 2020-02-04 09:20:00.253  Out2  67631.20  67631 2020-02-04 08:24:19.773   \n",
       "214195 2020-02-04 08:48:48.490  Out2  67631.20  67631 2020-02-04 08:24:19.773   \n",
       "214196 2020-02-04 09:07:55.963  Out2  67631.20  67631 2020-02-04 08:24:19.773   \n",
       "214197 2020-02-04 09:26:19.793  Out2  67631.20  67631 2020-02-04 08:24:19.773   \n",
       "214198 2020-02-04 08:54:10.203  Out2  67631.20  67631 2020-02-04 08:24:19.773   \n",
       "\n",
       "        zone         bin      item  qty  \n",
       "0       FAST  16.05.1.04  10001929    1  \n",
       "1       FAST  15.03.3.03   1000040    2  \n",
       "2       FAST  15.03.3.03   1000040    1  \n",
       "3       FAST   12.08.1.2    933830    1  \n",
       "4       FAST  15.02.1.05   1000489    1  \n",
       "...      ...         ...       ...  ...  \n",
       "214194  FAST  14.09.4.04    252255    1  \n",
       "214195  FAST   10.09.1.1    269409    1  \n",
       "214196  FAST   11.02.1.1      5022    1  \n",
       "214197  FAST  19.08.2.03    406333    1  \n",
       "214198  FAST   10.07.1.1    377279    2  \n",
       "\n",
       "[214199 rows x 9 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_multi_batch_pick_transaction_log = pd.read_csv(data_dir + 'multi_batch_pick_transaction_log.csv', names=['picked', 'user', 'subwave', 'wave', 'wave_created', 'zone', 'bin', 'item', 'qty'])\n",
    "df_multi_batch_pick_transaction_log.wave_created = pd.to_datetime(df_multi_batch_pick_transaction_log.wave_created)\n",
    "df_multi_batch_pick_transaction_log.picked = pd.to_datetime(df_multi_batch_pick_transaction_log.picked)\n",
    "df_multi_batch_pick_transaction_log = df_multi_batch_pick_transaction_log.sort_values(['wave_created']).reset_index(drop=True)\n",
    "df_multi_batch_pick_transaction_log"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>wave</th>\n",
       "      <th>created</th>\n",
       "      <th>zone</th>\n",
       "      <th>bin</th>\n",
       "      <th>item</th>\n",
       "      <th>order_qty</th>\n",
       "      <th>pick_qty</th>\n",
       "      <th>status</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>SYD2016103329</td>\n",
       "      <td>2019-10-18 19:02:31.807</td>\n",
       "      <td>FAST</td>\n",
       "      <td>23.08.3.13</td>\n",
       "      <td>403903</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>PICKUP</td>\n",
       "      <td>2019-10-29 11:34:55.093</td>\n",
       "      <td>FAST</td>\n",
       "      <td>23.06.3.04</td>\n",
       "      <td>10001849</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>PICKUP</td>\n",
       "      <td>2019-10-29 11:34:55.093</td>\n",
       "      <td>FAST</td>\n",
       "      <td>16.03.3.04</td>\n",
       "      <td>10002769</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>PICKUP</td>\n",
       "      <td>2019-10-29 11:34:55.093</td>\n",
       "      <td>FAST</td>\n",
       "      <td>23.08.5.18</td>\n",
       "      <td>263591</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>C</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>PICKUP</td>\n",
       "      <td>2019-10-29 11:34:55.093</td>\n",
       "      <td>FAST</td>\n",
       "      <td>17.08.3.03</td>\n",
       "      <td>753947</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>C</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24539</th>\n",
       "      <td>67666</td>\n",
       "      <td>2020-02-04 10:08:22.003</td>\n",
       "      <td>FAST</td>\n",
       "      <td>15.07.2.07</td>\n",
       "      <td>10001364</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24540</th>\n",
       "      <td>67666</td>\n",
       "      <td>2020-02-04 10:08:22.003</td>\n",
       "      <td>FAST</td>\n",
       "      <td>15.07.2.07</td>\n",
       "      <td>10001364</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24541</th>\n",
       "      <td>67666</td>\n",
       "      <td>2020-02-04 10:08:22.003</td>\n",
       "      <td>FAST</td>\n",
       "      <td>15.07.2.07</td>\n",
       "      <td>10001364</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24542</th>\n",
       "      <td>67666</td>\n",
       "      <td>2020-02-04 10:08:22.003</td>\n",
       "      <td>FAST</td>\n",
       "      <td>15.07.2.07</td>\n",
       "      <td>10001364</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24543</th>\n",
       "      <td>67666</td>\n",
       "      <td>2020-02-04 10:08:22.003</td>\n",
       "      <td>FAST</td>\n",
       "      <td>15.07.2.07</td>\n",
       "      <td>10001364</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>O</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>24544 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                wave                 created  zone         bin      item  \\\n",
       "0      SYD2016103329 2019-10-18 19:02:31.807  FAST  23.08.3.13    403903   \n",
       "1             PICKUP 2019-10-29 11:34:55.093  FAST  23.06.3.04  10001849   \n",
       "2             PICKUP 2019-10-29 11:34:55.093  FAST  16.03.3.04  10002769   \n",
       "3             PICKUP 2019-10-29 11:34:55.093  FAST  23.08.5.18    263591   \n",
       "4             PICKUP 2019-10-29 11:34:55.093  FAST  17.08.3.03    753947   \n",
       "...              ...                     ...   ...         ...       ...   \n",
       "24539          67666 2020-02-04 10:08:22.003  FAST  15.07.2.07  10001364   \n",
       "24540          67666 2020-02-04 10:08:22.003  FAST  15.07.2.07  10001364   \n",
       "24541          67666 2020-02-04 10:08:22.003  FAST  15.07.2.07  10001364   \n",
       "24542          67666 2020-02-04 10:08:22.003  FAST  15.07.2.07  10001364   \n",
       "24543          67666 2020-02-04 10:08:22.003  FAST  15.07.2.07  10001364   \n",
       "\n",
       "       order_qty  pick_qty status  \n",
       "0              4         4      C  \n",
       "1              1         1      C  \n",
       "2              1         1      C  \n",
       "3              7         7      C  \n",
       "4             16        16      C  \n",
       "...          ...       ...    ...  \n",
       "24539          1         0      O  \n",
       "24540          1         0      O  \n",
       "24541          5         0      O  \n",
       "24542          1         0      O  \n",
       "24543          1         0      O  \n",
       "\n",
       "[24544 rows x 8 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_multi_carton_pick_task = pd.read_csv(data_dir + 'multi_carton_pick_task.csv', names=['wave', 'created', 'zone', 'bin', 'item', 'order_qty', 'pick_qty', 'status'])\n",
    "df_multi_carton_pick_task.created = pd.to_datetime(df_multi_carton_pick_task.created)\n",
    "df_multi_carton_pick_task = df_multi_carton_pick_task.sort_values(['created']).reset_index(drop=True)\n",
    "df_multi_carton_pick_task"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>picked</th>\n",
       "      <th>user</th>\n",
       "      <th>order</th>\n",
       "      <th>zone</th>\n",
       "      <th>bin</th>\n",
       "      <th>item</th>\n",
       "      <th>qty</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2019-10-18 19:12:04.310</td>\n",
       "      <td>sysadmin</td>\n",
       "      <td>AR41090650-65088</td>\n",
       "      <td>FAST</td>\n",
       "      <td>23.08.3.13</td>\n",
       "      <td>403903</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2019-10-29 11:47:31.577</td>\n",
       "      <td>Andy</td>\n",
       "      <td>AR41118814-65210</td>\n",
       "      <td>FAST</td>\n",
       "      <td>16.09.5.13</td>\n",
       "      <td>10002772</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2019-10-29 11:47:55.857</td>\n",
       "      <td>Andy</td>\n",
       "      <td>AR41118814-65210</td>\n",
       "      <td>FAST</td>\n",
       "      <td>16.03.3.04</td>\n",
       "      <td>10002769</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2019-10-29 11:48:12.023</td>\n",
       "      <td>Andy</td>\n",
       "      <td>AR41118814-65210</td>\n",
       "      <td>FAST</td>\n",
       "      <td>P1.03.3.01</td>\n",
       "      <td>BONUS10002732</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2019-10-29 11:48:25.637</td>\n",
       "      <td>Andy</td>\n",
       "      <td>AR41118814-65210</td>\n",
       "      <td>FAST</td>\n",
       "      <td>P1.03.4.01</td>\n",
       "      <td>BONUS10003651</td>\n",
       "      <td>1</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24035</th>\n",
       "      <td>2020-02-04 10:51:58.150</td>\n",
       "      <td>Khey</td>\n",
       "      <td>AR41163143-67640</td>\n",
       "      <td>FAST</td>\n",
       "      <td>PENDING</td>\n",
       "      <td>10003358</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24036</th>\n",
       "      <td>2020-02-04 10:51:58.163</td>\n",
       "      <td>Khey</td>\n",
       "      <td>AR41161393-67640</td>\n",
       "      <td>FAST</td>\n",
       "      <td>PENDING</td>\n",
       "      <td>10003358</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24037</th>\n",
       "      <td>2020-02-04 10:51:58.163</td>\n",
       "      <td>Khey</td>\n",
       "      <td>AR41164504-67640</td>\n",
       "      <td>FAST</td>\n",
       "      <td>PENDING</td>\n",
       "      <td>10003358</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24038</th>\n",
       "      <td>2020-02-04 10:51:58.163</td>\n",
       "      <td>Khey</td>\n",
       "      <td>AR41164126-67640</td>\n",
       "      <td>FAST</td>\n",
       "      <td>PENDING</td>\n",
       "      <td>10003358</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24039</th>\n",
       "      <td>2020-02-04 10:51:58.180</td>\n",
       "      <td>Khey</td>\n",
       "      <td>AR41164223-67640</td>\n",
       "      <td>FAST</td>\n",
       "      <td>PENDING</td>\n",
       "      <td>10003358</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>24040 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       picked      user             order  zone         bin  \\\n",
       "0     2019-10-18 19:12:04.310  sysadmin  AR41090650-65088  FAST  23.08.3.13   \n",
       "1     2019-10-29 11:47:31.577      Andy  AR41118814-65210  FAST  16.09.5.13   \n",
       "2     2019-10-29 11:47:55.857      Andy  AR41118814-65210  FAST  16.03.3.04   \n",
       "3     2019-10-29 11:48:12.023      Andy  AR41118814-65210  FAST  P1.03.3.01   \n",
       "4     2019-10-29 11:48:25.637      Andy  AR41118814-65210  FAST  P1.03.4.01   \n",
       "...                       ...       ...               ...   ...         ...   \n",
       "24035 2020-02-04 10:51:58.150      Khey  AR41163143-67640  FAST     PENDING   \n",
       "24036 2020-02-04 10:51:58.163      Khey  AR41161393-67640  FAST     PENDING   \n",
       "24037 2020-02-04 10:51:58.163      Khey  AR41164504-67640  FAST     PENDING   \n",
       "24038 2020-02-04 10:51:58.163      Khey  AR41164126-67640  FAST     PENDING   \n",
       "24039 2020-02-04 10:51:58.180      Khey  AR41164223-67640  FAST     PENDING   \n",
       "\n",
       "                item  qty  \n",
       "0             403903    4  \n",
       "1           10002772    1  \n",
       "2           10002769    1  \n",
       "3      BONUS10002732    1  \n",
       "4      BONUS10003651    1  \n",
       "...              ...  ...  \n",
       "24035       10003358    4  \n",
       "24036       10003358    4  \n",
       "24037       10003358    3  \n",
       "24038       10003358    4  \n",
       "24039       10003358    2  \n",
       "\n",
       "[24040 rows x 7 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_multi_carton_pick_transaction_log = pd.read_csv(data_dir + 'multi_carton_pick_transaction_log.csv', names=['picked', 'user', 'order', 'zone', 'bin', 'item', 'qty'])\n",
    "df_multi_carton_pick_transaction_log.picked = pd.to_datetime(df_multi_carton_pick_transaction_log.picked)\n",
    "df_multi_carton_pick_transaction_log = df_multi_carton_pick_transaction_log.sort_values(['picked']).reset_index(drop=True)\n",
    "df_multi_carton_pick_transaction_log"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>order</th>\n",
       "      <th>freight</th>\n",
       "      <th>order_type</th>\n",
       "      <th>status</th>\n",
       "      <th>subwave</th>\n",
       "      <th>created</th>\n",
       "      <th>wave</th>\n",
       "      <th>item</th>\n",
       "      <th>qty_ordered</th>\n",
       "      <th>qty_picked</th>\n",
       "      <th>qty_packed</th>\n",
       "      <th>qty_shipped</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AR41090650-65088</td>\n",
       "      <td>POL_AUSPOST</td>\n",
       "      <td>AR</td>\n",
       "      <td>S</td>\n",
       "      <td>SYD2016103329</td>\n",
       "      <td>2019-10-18 19:02:32.133</td>\n",
       "      <td>NaN</td>\n",
       "      <td>403903</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SO10890444-65091</td>\n",
       "      <td>POL_EWE_PACKAGE</td>\n",
       "      <td>SO</td>\n",
       "      <td>S</td>\n",
       "      <td>AZOYA.1</td>\n",
       "      <td>2019-10-19 08:27:45.350</td>\n",
       "      <td>AZOYA</td>\n",
       "      <td>10001929</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SO10891601-65091</td>\n",
       "      <td>POL_EWE_PACKAGE</td>\n",
       "      <td>SO</td>\n",
       "      <td>S</td>\n",
       "      <td>AZOYA.2</td>\n",
       "      <td>2019-10-19 08:27:45.393</td>\n",
       "      <td>AZOYA</td>\n",
       "      <td>1000040</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SO10891611-65091</td>\n",
       "      <td>POL_EWE_PACKAGE</td>\n",
       "      <td>SO</td>\n",
       "      <td>S</td>\n",
       "      <td>AZOYA.3</td>\n",
       "      <td>2019-10-19 08:27:45.440</td>\n",
       "      <td>AZOYA</td>\n",
       "      <td>1000040</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SO10891500-65091</td>\n",
       "      <td>POL_EWE_PACKAGE</td>\n",
       "      <td>SO</td>\n",
       "      <td>S</td>\n",
       "      <td>AZOYA.4</td>\n",
       "      <td>2019-10-19 08:27:45.490</td>\n",
       "      <td>AZOYA</td>\n",
       "      <td>1000489</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250646</th>\n",
       "      <td>AR41163920-67690</td>\n",
       "      <td>POL_INTL</td>\n",
       "      <td>AR</td>\n",
       "      <td>P</td>\n",
       "      <td>67690</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19981</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250647</th>\n",
       "      <td>AR41163884-67690</td>\n",
       "      <td>POL_INTL</td>\n",
       "      <td>AR</td>\n",
       "      <td>P</td>\n",
       "      <td>67690</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>120275</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250648</th>\n",
       "      <td>AR41163920-67690</td>\n",
       "      <td>POL_INTL</td>\n",
       "      <td>AR</td>\n",
       "      <td>P</td>\n",
       "      <td>67690</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>267422</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250649</th>\n",
       "      <td>AR41163920-67690</td>\n",
       "      <td>POL_INTL</td>\n",
       "      <td>AR</td>\n",
       "      <td>P</td>\n",
       "      <td>67690</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>247588</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250650</th>\n",
       "      <td>AR41164150-67690</td>\n",
       "      <td>POL_INTL</td>\n",
       "      <td>AR</td>\n",
       "      <td>P</td>\n",
       "      <td>67690</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>307831</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>250651 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   order          freight order_type status        subwave  \\\n",
       "0       AR41090650-65088      POL_AUSPOST         AR      S  SYD2016103329   \n",
       "1       SO10890444-65091  POL_EWE_PACKAGE         SO      S        AZOYA.1   \n",
       "2       SO10891601-65091  POL_EWE_PACKAGE         SO      S        AZOYA.2   \n",
       "3       SO10891611-65091  POL_EWE_PACKAGE         SO      S        AZOYA.3   \n",
       "4       SO10891500-65091  POL_EWE_PACKAGE         SO      S        AZOYA.4   \n",
       "...                  ...              ...        ...    ...            ...   \n",
       "250646  AR41163920-67690         POL_INTL         AR      P          67690   \n",
       "250647  AR41163884-67690         POL_INTL         AR      P          67690   \n",
       "250648  AR41163920-67690         POL_INTL         AR      P          67690   \n",
       "250649  AR41163920-67690         POL_INTL         AR      P          67690   \n",
       "250650  AR41164150-67690         POL_INTL         AR      P          67690   \n",
       "\n",
       "                       created   wave      item  qty_ordered  qty_picked  \\\n",
       "0      2019-10-18 19:02:32.133    NaN    403903            4           4   \n",
       "1      2019-10-19 08:27:45.350  AZOYA  10001929            1           1   \n",
       "2      2019-10-19 08:27:45.393  AZOYA   1000040            2           2   \n",
       "3      2019-10-19 08:27:45.440  AZOYA   1000040            1           1   \n",
       "4      2019-10-19 08:27:45.490  AZOYA   1000489            1           1   \n",
       "...                        ...    ...       ...          ...         ...   \n",
       "250646                     NaT    NaN     19981            1           0   \n",
       "250647                     NaT    NaN    120275            4           0   \n",
       "250648                     NaT    NaN    267422            1           0   \n",
       "250649                     NaT    NaN    247588            1           0   \n",
       "250650                     NaT    NaN    307831            6           0   \n",
       "\n",
       "        qty_packed  qty_shipped  \n",
       "0                4            4  \n",
       "1                1            1  \n",
       "2                2            2  \n",
       "3                1            1  \n",
       "4                1            1  \n",
       "...            ...          ...  \n",
       "250646           0            0  \n",
       "250647           0            0  \n",
       "250648           0            0  \n",
       "250649           0            0  \n",
       "250650           0            0  \n",
       "\n",
       "[250651 rows x 12 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_order_line_detail = pd.read_csv(data_dir + 'order_line_detail.csv', names=['order', 'freight', 'order_type', 'status', 'subwave', 'created', 'wave', 'item', 'qty_ordered', 'qty_picked', 'qty_packed', 'qty_shipped'])\n",
    "df_order_line_detail.created = pd.to_datetime(df_order_line_detail.created)\n",
    "df_order_line_detail = df_order_line_detail.sort_values(['created']).reset_index(drop=True)\n",
    "df_order_line_detail"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>order</th>\n",
       "      <th>freight</th>\n",
       "      <th>order_type</th>\n",
       "      <th>status</th>\n",
       "      <th>subwave</th>\n",
       "      <th>created</th>\n",
       "      <th>wave</th>\n",
       "      <th>imported</th>\n",
       "      <th>released</th>\n",
       "      <th>picked</th>\n",
       "      <th>packed</th>\n",
       "      <th>shipped</th>\n",
       "      <th>cancel</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>AR41090650-65088</td>\n",
       "      <td>POL_AUSPOST</td>\n",
       "      <td>AR</td>\n",
       "      <td>S</td>\n",
       "      <td>SYD2016103329</td>\n",
       "      <td>2019-10-18 19:02:32.133</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019-10-18 19:01:30.480</td>\n",
       "      <td>2019-10-18 19:02:32.070</td>\n",
       "      <td>2019-10-18 19:14:42.580</td>\n",
       "      <td>2019-10-18 19:20:31.743</td>\n",
       "      <td>2019-10-18 19:20:41.667</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>SO10890444-65091</td>\n",
       "      <td>POL_EWE_PACKAGE</td>\n",
       "      <td>SO</td>\n",
       "      <td>S</td>\n",
       "      <td>AZOYA.1</td>\n",
       "      <td>2019-10-19 08:27:45.350</td>\n",
       "      <td>AZOYA</td>\n",
       "      <td>2019-10-19 08:26:35.487</td>\n",
       "      <td>2019-10-19 08:27:45.020</td>\n",
       "      <td>2019-10-19 10:29:08.393</td>\n",
       "      <td>2019-10-19 10:29:55.750</td>\n",
       "      <td>2019-10-19 10:32:24.040</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>SO10891601-65091</td>\n",
       "      <td>POL_EWE_PACKAGE</td>\n",
       "      <td>SO</td>\n",
       "      <td>S</td>\n",
       "      <td>AZOYA.2</td>\n",
       "      <td>2019-10-19 08:27:45.393</td>\n",
       "      <td>AZOYA</td>\n",
       "      <td>2019-10-19 08:26:36.487</td>\n",
       "      <td>2019-10-19 08:27:45.380</td>\n",
       "      <td>2019-10-19 10:43:16.377</td>\n",
       "      <td>2019-10-19 10:44:32.207</td>\n",
       "      <td>2019-10-19 10:44:35.207</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>SO10891611-65091</td>\n",
       "      <td>POL_EWE_PACKAGE</td>\n",
       "      <td>SO</td>\n",
       "      <td>S</td>\n",
       "      <td>AZOYA.3</td>\n",
       "      <td>2019-10-19 08:27:45.440</td>\n",
       "      <td>AZOYA</td>\n",
       "      <td>2019-10-19 08:26:36.987</td>\n",
       "      <td>2019-10-19 08:27:45.427</td>\n",
       "      <td>2019-10-19 10:46:01.903</td>\n",
       "      <td>2019-10-19 10:46:26.430</td>\n",
       "      <td>2019-10-19 10:46:34.310</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>SO10891500-65091</td>\n",
       "      <td>POL_EWE_PACKAGE</td>\n",
       "      <td>SO</td>\n",
       "      <td>S</td>\n",
       "      <td>AZOYA.4</td>\n",
       "      <td>2019-10-19 08:27:45.490</td>\n",
       "      <td>AZOYA</td>\n",
       "      <td>2019-10-19 08:26:35.987</td>\n",
       "      <td>2019-10-19 08:27:45.473</td>\n",
       "      <td>2019-10-19 10:38:33.680</td>\n",
       "      <td>2019-10-19 10:39:15.290</td>\n",
       "      <td>2019-10-19 10:39:52.250</td>\n",
       "      <td>NaT</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95609</th>\n",
       "      <td>AR41161857-67690</td>\n",
       "      <td>POL_INTL</td>\n",
       "      <td>AR</td>\n",
       "      <td>P</td>\n",
       "      <td>67690</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-02-04 15:07:31.147</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95610</th>\n",
       "      <td>AR41163814-67690</td>\n",
       "      <td>POL_INTL</td>\n",
       "      <td>AR</td>\n",
       "      <td>P</td>\n",
       "      <td>67690</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-02-04 15:07:35.143</td>\n",
       "      <td>2020-02-04 15:08:03.303</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95611</th>\n",
       "      <td>AR41163966-67690</td>\n",
       "      <td>POL_INTL</td>\n",
       "      <td>AR</td>\n",
       "      <td>P</td>\n",
       "      <td>67690</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-02-04 15:07:38.137</td>\n",
       "      <td>2020-02-04 15:08:03.460</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95612</th>\n",
       "      <td>AR41163990-67690</td>\n",
       "      <td>POL_INTL</td>\n",
       "      <td>AR</td>\n",
       "      <td>P</td>\n",
       "      <td>67690</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-02-04 15:07:38.637</td>\n",
       "      <td>2020-02-04 15:08:03.490</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95613</th>\n",
       "      <td>AR41164618-67690</td>\n",
       "      <td>POL_INTL</td>\n",
       "      <td>AR</td>\n",
       "      <td>P</td>\n",
       "      <td>67690</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-02-04 15:07:47.137</td>\n",
       "      <td>2020-02-04 15:08:03.897</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>95614 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  order          freight order_type status        subwave  \\\n",
       "0      AR41090650-65088      POL_AUSPOST         AR      S  SYD2016103329   \n",
       "1      SO10890444-65091  POL_EWE_PACKAGE         SO      S        AZOYA.1   \n",
       "2      SO10891601-65091  POL_EWE_PACKAGE         SO      S        AZOYA.2   \n",
       "3      SO10891611-65091  POL_EWE_PACKAGE         SO      S        AZOYA.3   \n",
       "4      SO10891500-65091  POL_EWE_PACKAGE         SO      S        AZOYA.4   \n",
       "...                 ...              ...        ...    ...            ...   \n",
       "95609  AR41161857-67690         POL_INTL         AR      P          67690   \n",
       "95610  AR41163814-67690         POL_INTL         AR      P          67690   \n",
       "95611  AR41163966-67690         POL_INTL         AR      P          67690   \n",
       "95612  AR41163990-67690         POL_INTL         AR      P          67690   \n",
       "95613  AR41164618-67690         POL_INTL         AR      P          67690   \n",
       "\n",
       "                      created   wave                imported  \\\n",
       "0     2019-10-18 19:02:32.133    NaN 2019-10-18 19:01:30.480   \n",
       "1     2019-10-19 08:27:45.350  AZOYA 2019-10-19 08:26:35.487   \n",
       "2     2019-10-19 08:27:45.393  AZOYA 2019-10-19 08:26:36.487   \n",
       "3     2019-10-19 08:27:45.440  AZOYA 2019-10-19 08:26:36.987   \n",
       "4     2019-10-19 08:27:45.490  AZOYA 2019-10-19 08:26:35.987   \n",
       "...                       ...    ...                     ...   \n",
       "95609                     NaT    NaN 2020-02-04 15:07:31.147   \n",
       "95610                     NaT    NaN 2020-02-04 15:07:35.143   \n",
       "95611                     NaT    NaN 2020-02-04 15:07:38.137   \n",
       "95612                     NaT    NaN 2020-02-04 15:07:38.637   \n",
       "95613                     NaT    NaN 2020-02-04 15:07:47.137   \n",
       "\n",
       "                     released                  picked                  packed  \\\n",
       "0     2019-10-18 19:02:32.070 2019-10-18 19:14:42.580 2019-10-18 19:20:31.743   \n",
       "1     2019-10-19 08:27:45.020 2019-10-19 10:29:08.393 2019-10-19 10:29:55.750   \n",
       "2     2019-10-19 08:27:45.380 2019-10-19 10:43:16.377 2019-10-19 10:44:32.207   \n",
       "3     2019-10-19 08:27:45.427 2019-10-19 10:46:01.903 2019-10-19 10:46:26.430   \n",
       "4     2019-10-19 08:27:45.473 2019-10-19 10:38:33.680 2019-10-19 10:39:15.290   \n",
       "...                       ...                     ...                     ...   \n",
       "95609                     NaT                     NaT                     NaT   \n",
       "95610 2020-02-04 15:08:03.303                     NaT                     NaT   \n",
       "95611 2020-02-04 15:08:03.460                     NaT                     NaT   \n",
       "95612 2020-02-04 15:08:03.490                     NaT                     NaT   \n",
       "95613 2020-02-04 15:08:03.897                     NaT                     NaT   \n",
       "\n",
       "                      shipped cancel  \n",
       "0     2019-10-18 19:20:41.667    NaT  \n",
       "1     2019-10-19 10:32:24.040    NaT  \n",
       "2     2019-10-19 10:44:35.207    NaT  \n",
       "3     2019-10-19 10:46:34.310    NaT  \n",
       "4     2019-10-19 10:39:52.250    NaT  \n",
       "...                       ...    ...  \n",
       "95609                     NaT    NaT  \n",
       "95610                     NaT    NaT  \n",
       "95611                     NaT    NaT  \n",
       "95612                     NaT    NaT  \n",
       "95613                     NaT    NaT  \n",
       "\n",
       "[95614 rows x 13 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_order_milestone = pd.read_csv(data_dir + 'order_milestone.csv', names=['order', 'freight', 'order_type', 'status', 'subwave', 'created', 'wave', 'imported', 'released', 'picked', 'packed', 'shipped', 'cancel'])\n",
    "df_order_milestone.created = pd.to_datetime(df_order_milestone.created)\n",
    "df_order_milestone.imported = pd.to_datetime(df_order_milestone.imported)\n",
    "df_order_milestone.released = pd.to_datetime(df_order_milestone.released)\n",
    "df_order_milestone.picked = pd.to_datetime(df_order_milestone.picked)\n",
    "df_order_milestone.packed = pd.to_datetime(df_order_milestone.packed)\n",
    "df_order_milestone.shipped = pd.to_datetime(df_order_milestone.shipped)\n",
    "df_order_milestone.cancel = pd.to_datetime(df_order_milestone.cancel)\n",
    "df_order_milestone = df_order_milestone.sort_values(['created']).reset_index(drop=True)\n",
    "df_order_milestone"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>row</th>\n",
       "      <th>rack</th>\n",
       "      <th>bay</th>\n",
       "      <th>level</th>\n",
       "      <th>slot_y</th>\n",
       "      <th>slot_z</th>\n",
       "      <th>separator</th>\n",
       "      <th>bin_location</th>\n",
       "      <th>level_alpha</th>\n",
       "      <th>alpha_bin_location</th>\n",
       "      <th>...</th>\n",
       "      <th>slot_width</th>\n",
       "      <th>slot_depth</th>\n",
       "      <th>slot_height</th>\n",
       "      <th>slot_volume</th>\n",
       "      <th>x</th>\n",
       "      <th>y</th>\n",
       "      <th>z</th>\n",
       "      <th>asc_desc</th>\n",
       "      <th>rack_sequence</th>\n",
       "      <th>travel_sequence</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>.</td>\n",
       "      <td>10.01.1.1</td>\n",
       "      <td>A</td>\n",
       "      <td>10.01.A.1</td>\n",
       "      <td>...</td>\n",
       "      <td>1295</td>\n",
       "      <td>1165</td>\n",
       "      <td>1410</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.84</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>D</td>\n",
       "      <td>1</td>\n",
       "      <td>3999</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>.</td>\n",
       "      <td>10.01.1.2</td>\n",
       "      <td>A</td>\n",
       "      <td>10.01.A.2</td>\n",
       "      <td>...</td>\n",
       "      <td>1295</td>\n",
       "      <td>1165</td>\n",
       "      <td>1410</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.84</td>\n",
       "      <td>1.295</td>\n",
       "      <td>0.00</td>\n",
       "      <td>D</td>\n",
       "      <td>1</td>\n",
       "      <td>3994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>.</td>\n",
       "      <td>10.01.2.1</td>\n",
       "      <td>B</td>\n",
       "      <td>10.01.B.1</td>\n",
       "      <td>...</td>\n",
       "      <td>1295</td>\n",
       "      <td>1165</td>\n",
       "      <td>1410</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.84</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.60</td>\n",
       "      <td>D</td>\n",
       "      <td>1</td>\n",
       "      <td>3998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>.</td>\n",
       "      <td>10.01.2.2</td>\n",
       "      <td>B</td>\n",
       "      <td>10.01.B.2</td>\n",
       "      <td>...</td>\n",
       "      <td>1295</td>\n",
       "      <td>1165</td>\n",
       "      <td>1410</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.84</td>\n",
       "      <td>1.295</td>\n",
       "      <td>1.60</td>\n",
       "      <td>D</td>\n",
       "      <td>1</td>\n",
       "      <td>3993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>.</td>\n",
       "      <td>10.01.3.1</td>\n",
       "      <td>C</td>\n",
       "      <td>10.01.C.1</td>\n",
       "      <td>...</td>\n",
       "      <td>1295</td>\n",
       "      <td>1165</td>\n",
       "      <td>1410</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.84</td>\n",
       "      <td>0.000</td>\n",
       "      <td>3.20</td>\n",
       "      <td>D</td>\n",
       "      <td>1</td>\n",
       "      <td>3997</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12970</th>\n",
       "      <td>75</td>\n",
       "      <td>PH</td>\n",
       "      <td>16</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>.</td>\n",
       "      <td>PH.16.07.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>600</td>\n",
       "      <td>200</td>\n",
       "      <td>200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.00</td>\n",
       "      <td>-7.000</td>\n",
       "      <td>0.15</td>\n",
       "      <td>A</td>\n",
       "      <td>30</td>\n",
       "      <td>60156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12971</th>\n",
       "      <td>75</td>\n",
       "      <td>PH</td>\n",
       "      <td>16</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>.</td>\n",
       "      <td>PH.16.08.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>600</td>\n",
       "      <td>200</td>\n",
       "      <td>200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.00</td>\n",
       "      <td>-7.000</td>\n",
       "      <td>0.15</td>\n",
       "      <td>A</td>\n",
       "      <td>30</td>\n",
       "      <td>60157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12972</th>\n",
       "      <td>75</td>\n",
       "      <td>PH</td>\n",
       "      <td>16</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>.</td>\n",
       "      <td>PH.16.09.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>600</td>\n",
       "      <td>200</td>\n",
       "      <td>200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.00</td>\n",
       "      <td>-7.000</td>\n",
       "      <td>0.15</td>\n",
       "      <td>A</td>\n",
       "      <td>30</td>\n",
       "      <td>60158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12973</th>\n",
       "      <td>75</td>\n",
       "      <td>PH</td>\n",
       "      <td>16</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>.</td>\n",
       "      <td>PH.16.10.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>600</td>\n",
       "      <td>200</td>\n",
       "      <td>200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.00</td>\n",
       "      <td>-7.000</td>\n",
       "      <td>0.15</td>\n",
       "      <td>A</td>\n",
       "      <td>30</td>\n",
       "      <td>60159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12974</th>\n",
       "      <td>76</td>\n",
       "      <td>PH</td>\n",
       "      <td>17</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>.</td>\n",
       "      <td>PH.17.10.1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>600</td>\n",
       "      <td>200</td>\n",
       "      <td>200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.00</td>\n",
       "      <td>-7.000</td>\n",
       "      <td>0.15</td>\n",
       "      <td>A</td>\n",
       "      <td>31</td>\n",
       "      <td>60160</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12975 rows × 37 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       row rack  bay  level  slot_y  slot_z separator bin_location  \\\n",
       "0        3   10    1      1       1     NaN         .    10.01.1.1   \n",
       "1        3   10    1      1       2     NaN         .    10.01.1.2   \n",
       "2        3   10    1      2       1     NaN         .    10.01.2.1   \n",
       "3        3   10    1      2       2     NaN         .    10.01.2.2   \n",
       "4        3   10    1      3       1     NaN         .    10.01.3.1   \n",
       "...    ...  ...  ...    ...     ...     ...       ...          ...   \n",
       "12970   75   PH   16      7       1     NaN         .   PH.16.07.1   \n",
       "12971   75   PH   16      8       1     NaN         .   PH.16.08.1   \n",
       "12972   75   PH   16      9       1     NaN         .   PH.16.09.1   \n",
       "12973   75   PH   16     10       1     NaN         .   PH.16.10.1   \n",
       "12974   76   PH   17     10       1     NaN         .   PH.17.10.1   \n",
       "\n",
       "      level_alpha alpha_bin_location  ...  slot_width  slot_depth slot_height  \\\n",
       "0               A          10.01.A.1  ...        1295        1165        1410   \n",
       "1               A          10.01.A.2  ...        1295        1165        1410   \n",
       "2               B          10.01.B.1  ...        1295        1165        1410   \n",
       "3               B          10.01.B.2  ...        1295        1165        1410   \n",
       "4               C          10.01.C.1  ...        1295        1165        1410   \n",
       "...           ...                ...  ...         ...         ...         ...   \n",
       "12970         NaN                NaN  ...         600         200         200   \n",
       "12971         NaN                NaN  ...         600         200         200   \n",
       "12972         NaN                NaN  ...         600         200         200   \n",
       "12973         NaN                NaN  ...         600         200         200   \n",
       "12974         NaN                NaN  ...         600         200         200   \n",
       "\n",
       "      slot_volume      x      y     z asc_desc rack_sequence travel_sequence  \n",
       "0             NaN   0.84  0.000  0.00        D             1            3999  \n",
       "1             NaN   0.84  1.295  0.00        D             1            3994  \n",
       "2             NaN   0.84  0.000  1.60        D             1            3998  \n",
       "3             NaN   0.84  1.295  1.60        D             1            3993  \n",
       "4             NaN   0.84  0.000  3.20        D             1            3997  \n",
       "...           ...    ...    ...   ...      ...           ...             ...  \n",
       "12970         NaN  31.00 -7.000  0.15        A            30           60156  \n",
       "12971         NaN  31.00 -7.000  0.15        A            30           60157  \n",
       "12972         NaN  31.00 -7.000  0.15        A            30           60158  \n",
       "12973         NaN  31.00 -7.000  0.15        A            30           60159  \n",
       "12974         NaN  31.00 -7.000  0.15        A            31           60160  \n",
       "\n",
       "[12975 rows x 37 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_layout = pd.read_excel(layout_dir + 'Bin Location configuration xyz.xlsx')\n",
    "df_layout.columns = ['row', 'rack', 'bay', 'level', 'slot_y', 'slot_z', 'separator', 'bin_location', 'level_alpha', 'alpha_bin_location', 'check_digit', 'barcode', 'active', 'locator_description', 'pick_zone', 'put_zone', 'equipment_zone', 'locator_type', 'storage_type_id', 'storage_type', 'stock_lpn', 'stock_item', 'status', 'slot_sequence', 'slot_size', 'slot_type', 'slot_size_description', 'slot_width', 'slot_depth', 'slot_height', 'slot_volume', 'x', 'y', 'z', 'asc_desc', 'rack_sequence', 'travel_sequence']\n",
    "df_layout"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "lh-data-mining",
   "language": "python",
   "name": "lh-data-mining"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}