python_script_komerce_pod_report.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "54b83339",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import glob\n",
    "import math\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "26e2f4c7",
   "metadata": {},
   "outputs": [],
   "source": [
    "search_pod=pd.concat([pd.read_csv(f, dtype=str) for f in glob.glob(\"E:\\REPORTING PARTNER IDX\\PROJECT KOMERCE\\POD Komerce/*.csv\")], ignore_index = True)\n",
    "search_pod[\"POD Recording Time\"]=pd.to_datetime(search_pod[\"POD Recording Time\"], format='%d-%m-%Y %H:%M:%S')\n",
    "search_pod[\"Shipping Date\"]=pd.to_datetime(search_pod[\"Shipping Date\"], format='%d-%m-%Y %H:%M:%S')\n",
    "#search_pos[\"Input Time\"]=search_pos[\"Input Time\"].dt.date\n",
    "search_pod=search_pod.loc[(search_pod['POD Recording Time']>='2022/07/11') & (search_pod['POD Recording Time']<='2022/07/12')]\n",
    "search_pod=search_pod.sort_values(by = [\"POD Recording Time\"])\n",
    "search_pod.drop_duplicates(subset=[\"Waybill No.\"], keep='first', inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "ca19b900",
   "metadata": {},
   "outputs": [],
   "source": [
    "search_pod.rename(columns={\"POD Recording Time\":\"POD Time\"},inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "53185055",
   "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>Waybill No.</th>\n",
       "      <th>Waybill Source</th>\n",
       "      <th>Shipping Date</th>\n",
       "      <th>Origin PDB</th>\n",
       "      <th>POD Branch</th>\n",
       "      <th>Origin City</th>\n",
       "      <th>Delivery Courier</th>\n",
       "      <th>Signer</th>\n",
       "      <th>Freight at Delivery</th>\n",
       "      <th>Payment Type</th>\n",
       "      <th>...</th>\n",
       "      <th>Weight</th>\n",
       "      <th>Input by</th>\n",
       "      <th>Destination</th>\n",
       "      <th>Destination City</th>\n",
       "      <th>Affiliated to Agent</th>\n",
       "      <th>Sign of Represented POD</th>\n",
       "      <th>Relationship with Recipient</th>\n",
       "      <th>Photo</th>\n",
       "      <th>Destination Province</th>\n",
       "      <th>Shipping Time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>172238</th>\n",
       "      <td>IDS902261887260</td>\n",
       "      <td>Shopee platform</td>\n",
       "      <td>2022-07-08 18:49:46</td>\n",
       "      <td>FB KENAIBAN</td>\n",
       "      <td>TH WATES</td>\n",
       "      <td>KLATEN</td>\n",
       "      <td>OC_RUDY AGUS PRASETYO</td>\n",
       "      <td>Sulistyaningsih</td>\n",
       "      <td>14595</td>\n",
       "      <td>Periodic</td>\n",
       "      <td>...</td>\n",
       "      <td>0.31</td>\n",
       "      <td>OC_RUDY AGUS PRASETYO</td>\n",
       "      <td>SENTOLO</td>\n",
       "      <td>KULON PROGO</td>\n",
       "      <td>MITRA SOLO</td>\n",
       "      <td>Signed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>DI YOGYAKARTA</td>\n",
       "      <td>2022-07-08 18:49:46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172236</th>\n",
       "      <td>IDS900352602301</td>\n",
       "      <td>Shopee platform</td>\n",
       "      <td>2022-07-07 21:06:33</td>\n",
       "      <td>FB KEDUNGWUNI</td>\n",
       "      <td>TH WATES</td>\n",
       "      <td>PEKALONGAN</td>\n",
       "      <td>OC_RUDY AGUS PRASETYO</td>\n",
       "      <td>Dana tri sumardiyani</td>\n",
       "      <td>15803</td>\n",
       "      <td>Periodic</td>\n",
       "      <td>...</td>\n",
       "      <td>0.525</td>\n",
       "      <td>OC_RUDY AGUS PRASETYO</td>\n",
       "      <td>SENTOLO</td>\n",
       "      <td>KULON PROGO</td>\n",
       "      <td>MITRA SOLO</td>\n",
       "      <td>Signed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>DI YOGYAKARTA</td>\n",
       "      <td>2022-07-07 21:06:33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172235</th>\n",
       "      <td>IDS903180081910</td>\n",
       "      <td>Shopee platform</td>\n",
       "      <td>2022-07-08 21:19:18</td>\n",
       "      <td>FB PANDEYAN</td>\n",
       "      <td>TH WATES</td>\n",
       "      <td>KOTA YOGYAKARTA</td>\n",
       "      <td>OC_RUDY AGUS PRASETYO</td>\n",
       "      <td>Dini Nur Istiqomah</td>\n",
       "      <td>11853</td>\n",
       "      <td>Periodic</td>\n",
       "      <td>...</td>\n",
       "      <td>0.15</td>\n",
       "      <td>OC_RUDY AGUS PRASETYO</td>\n",
       "      <td>SENTOLO</td>\n",
       "      <td>KULON PROGO</td>\n",
       "      <td>MITRA SOLO</td>\n",
       "      <td>Signed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>DI YOGYAKARTA</td>\n",
       "      <td>2022-07-08 21:19:18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172234</th>\n",
       "      <td>IDS903959789661</td>\n",
       "      <td>Shopee platform</td>\n",
       "      <td>2022-07-07 23:23:17</td>\n",
       "      <td>FB PALMERAH</td>\n",
       "      <td>TH WATES</td>\n",
       "      <td>JAKARTA BARAT</td>\n",
       "      <td>OC_RUDY AGUS PRASETYO</td>\n",
       "      <td>surono rono</td>\n",
       "      <td>26338</td>\n",
       "      <td>Periodic</td>\n",
       "      <td>...</td>\n",
       "      <td>0.25</td>\n",
       "      <td>OC_RUDY AGUS PRASETYO</td>\n",
       "      <td>SENTOLO</td>\n",
       "      <td>KULON PROGO</td>\n",
       "      <td>MITRA SOLO</td>\n",
       "      <td>Signed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>DI YOGYAKARTA</td>\n",
       "      <td>2022-07-07 23:23:17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172237</th>\n",
       "      <td>IDE005970920911</td>\n",
       "      <td>KiriminAja</td>\n",
       "      <td>2022-06-30 14:38:42</td>\n",
       "      <td>FB MELAYU</td>\n",
       "      <td>TH BANGGAE TIMUR</td>\n",
       "      <td>MAKASSAR</td>\n",
       "      <td>20721 In Amul Musthapa</td>\n",
       "      <td>Rahma Sindi</td>\n",
       "      <td>18500</td>\n",
       "      <td>Periodic</td>\n",
       "      <td>...</td>\n",
       "      <td>0.167</td>\n",
       "      <td>20721 In Amul Musthapa</td>\n",
       "      <td>TINAMBUNG</td>\n",
       "      <td>POLEWALI MANDAR</td>\n",
       "      <td>MITRA MAKASSAR</td>\n",
       "      <td>Signed</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>SULAWESI BARAT</td>\n",
       "      <td>2022-06-30 14:38:42</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Waybill No.   Waybill Source       Shipping Date     Origin PDB  \\\n",
       "172238  IDS902261887260  Shopee platform 2022-07-08 18:49:46    FB KENAIBAN   \n",
       "172236  IDS900352602301  Shopee platform 2022-07-07 21:06:33  FB KEDUNGWUNI   \n",
       "172235  IDS903180081910  Shopee platform 2022-07-08 21:19:18    FB PANDEYAN   \n",
       "172234  IDS903959789661  Shopee platform 2022-07-07 23:23:17    FB PALMERAH   \n",
       "172237  IDE005970920911       KiriminAja 2022-06-30 14:38:42      FB MELAYU   \n",
       "\n",
       "              POD Branch      Origin City        Delivery Courier  \\\n",
       "172238          TH WATES           KLATEN   OC_RUDY AGUS PRASETYO   \n",
       "172236          TH WATES       PEKALONGAN   OC_RUDY AGUS PRASETYO   \n",
       "172235          TH WATES  KOTA YOGYAKARTA   OC_RUDY AGUS PRASETYO   \n",
       "172234          TH WATES    JAKARTA BARAT   OC_RUDY AGUS PRASETYO   \n",
       "172237  TH BANGGAE TIMUR         MAKASSAR  20721 In Amul Musthapa   \n",
       "\n",
       "                      Signer Freight at Delivery Payment Type  ... Weight  \\\n",
       "172238       Sulistyaningsih               14595     Periodic  ...   0.31   \n",
       "172236  Dana tri sumardiyani               15803     Periodic  ...  0.525   \n",
       "172235    Dini Nur Istiqomah               11853     Periodic  ...   0.15   \n",
       "172234           surono rono               26338     Periodic  ...   0.25   \n",
       "172237           Rahma Sindi               18500     Periodic  ...  0.167   \n",
       "\n",
       "                      Input by Destination Destination City  \\\n",
       "172238   OC_RUDY AGUS PRASETYO     SENTOLO      KULON PROGO   \n",
       "172236   OC_RUDY AGUS PRASETYO     SENTOLO      KULON PROGO   \n",
       "172235   OC_RUDY AGUS PRASETYO     SENTOLO      KULON PROGO   \n",
       "172234   OC_RUDY AGUS PRASETYO     SENTOLO      KULON PROGO   \n",
       "172237  20721 In Amul Musthapa   TINAMBUNG  POLEWALI MANDAR   \n",
       "\n",
       "       Affiliated to Agent Sign of Represented POD  \\\n",
       "172238          MITRA SOLO                  Signed   \n",
       "172236          MITRA SOLO                  Signed   \n",
       "172235          MITRA SOLO                  Signed   \n",
       "172234          MITRA SOLO                  Signed   \n",
       "172237      MITRA MAKASSAR                  Signed   \n",
       "\n",
       "       Relationship with Recipient Photo Destination Province  \\\n",
       "172238                         NaN   Yes        DI YOGYAKARTA   \n",
       "172236                         NaN   Yes        DI YOGYAKARTA   \n",
       "172235                         NaN   Yes        DI YOGYAKARTA   \n",
       "172234                         NaN   Yes        DI YOGYAKARTA   \n",
       "172237                         NaN   Yes       SULAWESI BARAT   \n",
       "\n",
       "             Shipping Time  \n",
       "172238 2022-07-08 18:49:46  \n",
       "172236 2022-07-07 21:06:33  \n",
       "172235 2022-07-08 21:19:18  \n",
       "172234 2022-07-07 23:23:17  \n",
       "172237 2022-06-30 14:38:42  \n",
       "\n",
       "[5 rows x 27 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "search_pod['Shipping Time'] =search_pod[\"Shipping Date\"]=pd.to_datetime(search_pod[\"Shipping Date\"], format='%d-%m-%Y %H:%M:%S')\n",
    "search_pod.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "1b1c7138",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 172239 entries, 172238 to 0\n",
      "Data columns (total 27 columns):\n",
      " #   Column                       Non-Null Count   Dtype         \n",
      "---  ------                       --------------   -----         \n",
      " 0   Waybill No.                  172239 non-null  object        \n",
      " 1   Waybill Source               172239 non-null  object        \n",
      " 2   Shipping Date                172239 non-null  datetime64[ns]\n",
      " 3   Origin PDB                   172239 non-null  object        \n",
      " 4   POD Branch                   172239 non-null  object        \n",
      " 5   Origin City                  172239 non-null  object        \n",
      " 6   Delivery Courier             172239 non-null  object        \n",
      " 7   Signer                       172238 non-null  object        \n",
      " 8   Freight at Delivery          172239 non-null  object        \n",
      " 9   Payment Type                 172239 non-null  object        \n",
      " 10  VIP Username                 6485 non-null    object        \n",
      " 11  Sub-Account                  313 non-null     object        \n",
      " 12  COD Amount                   172239 non-null  object        \n",
      " 13  Cash on POD                  172239 non-null  object        \n",
      " 14  Claim Value                  172239 non-null  object        \n",
      " 15  POD Scan Time                172239 non-null  object        \n",
      " 16  POD Time                     172239 non-null  datetime64[ns]\n",
      " 17  Weight                       172239 non-null  object        \n",
      " 18  Input by                     172239 non-null  object        \n",
      " 19  Destination                  172239 non-null  object        \n",
      " 20  Destination City             172239 non-null  object        \n",
      " 21  Affiliated to Agent          172239 non-null  object        \n",
      " 22  Sign of Represented POD      172239 non-null  object        \n",
      " 23  Relationship with Recipient  15567 non-null   object        \n",
      " 24  Photo                        172239 non-null  object        \n",
      " 25  Destination Province         172239 non-null  object        \n",
      " 26  Shipping Time                172239 non-null  datetime64[ns]\n",
      "dtypes: datetime64[ns](3), object(24)\n",
      "memory usage: 36.8+ MB\n"
     ]
    }
   ],
   "source": [
    "search_pod\n",
    "search_pod.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "3e2d2962",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\User\\anaconda3\\lib\\site-packages\\pandas\\core\\frame.py:4906: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  return super().drop(\n"
     ]
    },
    {
     "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>Waybill No.</th>\n",
       "      <th>Shipping Date</th>\n",
       "      <th>Shipping Time</th>\n",
       "      <th>POD Branch</th>\n",
       "      <th>POD Time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>171169</th>\n",
       "      <td>IDE002705350814</td>\n",
       "      <td>2022-07-07 17:34:16</td>\n",
       "      <td>2022-07-07 17:34:16</td>\n",
       "      <td>TH SAMARINDA KOTA</td>\n",
       "      <td>2022-07-11 07:56:03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170984</th>\n",
       "      <td>IDE000407114735</td>\n",
       "      <td>2022-07-09 21:02:26</td>\n",
       "      <td>2022-07-09 21:02:26</td>\n",
       "      <td>TH CILEUNGSI</td>\n",
       "      <td>2022-07-11 08:01:41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170678</th>\n",
       "      <td>IDE004768533625</td>\n",
       "      <td>2022-07-09 19:48:55</td>\n",
       "      <td>2022-07-09 19:48:55</td>\n",
       "      <td>TH CIAMPEA</td>\n",
       "      <td>2022-07-11 08:08:26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170022</th>\n",
       "      <td>IDE004127489601</td>\n",
       "      <td>2022-07-09 21:06:03</td>\n",
       "      <td>2022-07-09 21:06:03</td>\n",
       "      <td>TH PULO GADUNG</td>\n",
       "      <td>2022-07-11 08:19:14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168671</th>\n",
       "      <td>IDE006684570722</td>\n",
       "      <td>2022-07-09 17:55:28</td>\n",
       "      <td>2022-07-09 17:55:28</td>\n",
       "      <td>TH SETU</td>\n",
       "      <td>2022-07-11 08:35:29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5481</th>\n",
       "      <td>IDE008146224939</td>\n",
       "      <td>2022-07-09 19:00:34</td>\n",
       "      <td>2022-07-09 19:00:34</td>\n",
       "      <td>TH MERTOYUDAN</td>\n",
       "      <td>2022-07-11 20:26:53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5298</th>\n",
       "      <td>IDE002955271066</td>\n",
       "      <td>2022-07-09 17:43:42</td>\n",
       "      <td>2022-07-09 17:43:42</td>\n",
       "      <td>TH PONOROGO</td>\n",
       "      <td>2022-07-11 20:29:57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5091</th>\n",
       "      <td>IDE007060973776</td>\n",
       "      <td>2022-07-08 17:17:37</td>\n",
       "      <td>2022-07-08 17:17:37</td>\n",
       "      <td>TH UMBULHARJO</td>\n",
       "      <td>2022-07-11 20:32:13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3015</th>\n",
       "      <td>IDE004085024647</td>\n",
       "      <td>2022-07-08 21:13:19</td>\n",
       "      <td>2022-07-08 21:13:19</td>\n",
       "      <td>TH KETAPANG</td>\n",
       "      <td>2022-07-11 21:13:33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2709</th>\n",
       "      <td>IDE004737364694</td>\n",
       "      <td>2022-07-09 21:07:12</td>\n",
       "      <td>2022-07-09 21:07:12</td>\n",
       "      <td>TH MUNGKID</td>\n",
       "      <td>2022-07-11 21:20:51</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>192 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            Waybill No.       Shipping Date       Shipping Time  \\\n",
       "171169  IDE002705350814 2022-07-07 17:34:16 2022-07-07 17:34:16   \n",
       "170984  IDE000407114735 2022-07-09 21:02:26 2022-07-09 21:02:26   \n",
       "170678  IDE004768533625 2022-07-09 19:48:55 2022-07-09 19:48:55   \n",
       "170022  IDE004127489601 2022-07-09 21:06:03 2022-07-09 21:06:03   \n",
       "168671  IDE006684570722 2022-07-09 17:55:28 2022-07-09 17:55:28   \n",
       "...                 ...                 ...                 ...   \n",
       "5481    IDE008146224939 2022-07-09 19:00:34 2022-07-09 19:00:34   \n",
       "5298    IDE002955271066 2022-07-09 17:43:42 2022-07-09 17:43:42   \n",
       "5091    IDE007060973776 2022-07-08 17:17:37 2022-07-08 17:17:37   \n",
       "3015    IDE004085024647 2022-07-08 21:13:19 2022-07-08 21:13:19   \n",
       "2709    IDE004737364694 2022-07-09 21:07:12 2022-07-09 21:07:12   \n",
       "\n",
       "               POD Branch            POD Time  \n",
       "171169  TH SAMARINDA KOTA 2022-07-11 07:56:03  \n",
       "170984       TH CILEUNGSI 2022-07-11 08:01:41  \n",
       "170678         TH CIAMPEA 2022-07-11 08:08:26  \n",
       "170022     TH PULO GADUNG 2022-07-11 08:19:14  \n",
       "168671            TH SETU 2022-07-11 08:35:29  \n",
       "...                   ...                 ...  \n",
       "5481        TH MERTOYUDAN 2022-07-11 20:26:53  \n",
       "5298          TH PONOROGO 2022-07-11 20:29:57  \n",
       "5091        TH UMBULHARJO 2022-07-11 20:32:13  \n",
       "3015          TH KETAPANG 2022-07-11 21:13:33  \n",
       "2709           TH MUNGKID 2022-07-11 21:20:51  \n",
       "\n",
       "[192 rows x 5 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "search_pod=search_pod.loc[:,[\"Waybill No.\",\"Waybill Source\",\"Shipping Date\",\"Shipping Time\",\"POD Branch\",\"POD Time\"]]\n",
    "komerce=search_pod[search_pod[\"Waybill Source\"]==\"Komerce\"]\n",
    "komerce.drop(columns=['Waybill Source'], inplace=True)\n",
    "#komerce=komerce.loc[:,[\"Waybill No.\",\"POD Recording Time\"]]\n",
    "komerce"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "40633726",
   "metadata": {},
   "outputs": [],
   "source": [
    "search_waybill=pd.concat([pd.read_csv(f, dtype=str) for f in glob.glob(\"E:\\DATABASE\\Waybill 2022/*.csv\")], ignore_index = True)\n",
    "search_waybill[\"POD Time\"]=pd.to_datetime(search_waybill[\"POD Time\"], format='%d-%m-%Y %H:%M:%S')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "0df78a6a",
   "metadata": {
    "scrolled": true
   },
   "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>Waybill No.</th>\n",
       "      <th>Shipping Date</th>\n",
       "      <th>Shipping Time</th>\n",
       "      <th>POD Branch</th>\n",
       "      <th>POD Time</th>\n",
       "      <th>Origin Branch</th>\n",
       "      <th>Pickup Time</th>\n",
       "      <th>Destination</th>\n",
       "      <th>Item Name</th>\n",
       "      <th>Calculated Weight</th>\n",
       "      <th>...</th>\n",
       "      <th>Recipient Handphone</th>\n",
       "      <th>Recipient Address</th>\n",
       "      <th>Payment Type</th>\n",
       "      <th>Express Type</th>\n",
       "      <th>POD Status</th>\n",
       "      <th>Waybill Source</th>\n",
       "      <th>Origin Province</th>\n",
       "      <th>Origin City</th>\n",
       "      <th>Destination Province</th>\n",
       "      <th>Destination City</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>IDE002705350814</td>\n",
       "      <td>2022-07-07 17:34:16</td>\n",
       "      <td>2022-07-07 17:34:16</td>\n",
       "      <td>TH SAMARINDA KOTA</td>\n",
       "      <td>2022-07-11 07:56:03</td>\n",
       "      <td>TH KROYA</td>\n",
       "      <td>07-07-2022 17:25:36</td>\n",
       "      <td>SAMARINDA ULU</td>\n",
       "      <td>TAMPALA TUNGGAL 500 GRAM</td>\n",
       "      <td>0.5</td>\n",
       "      <td>...</td>\n",
       "      <td>081952457738</td>\n",
       "      <td>DEPAN PENAGDILAN NEGERI JL. M YAMIN RUKO KAPLI...</td>\n",
       "      <td>Periodic</td>\n",
       "      <td>STD</td>\n",
       "      <td>Not Signed Yet</td>\n",
       "      <td>Komerce</td>\n",
       "      <td>JAWA TENGAH</td>\n",
       "      <td>CILACAP</td>\n",
       "      <td>KALIMANTAN TIMUR</td>\n",
       "      <td>SAMARINDA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>IDE000407114735</td>\n",
       "      <td>2022-07-09 21:02:26</td>\n",
       "      <td>2022-07-09 21:02:26</td>\n",
       "      <td>TH CILEUNGSI</td>\n",
       "      <td>2022-07-11 08:01:41</td>\n",
       "      <td>TH SUKAJADI</td>\n",
       "      <td>09-07-2022 21:02:26</td>\n",
       "      <td>GUNUNG PUTRI</td>\n",
       "      <td>INPODS I11</td>\n",
       "      <td>0.35</td>\n",
       "      <td>...</td>\n",
       "      <td>082180450108</td>\n",
       "      <td>legenda wisata zona mozart blok g.1,26 rt.03 r...</td>\n",
       "      <td>Periodic</td>\n",
       "      <td>STD</td>\n",
       "      <td>Not Signed Yet</td>\n",
       "      <td>Komerce</td>\n",
       "      <td>JAWA BARAT</td>\n",
       "      <td>KOTA BANDUNG</td>\n",
       "      <td>JAWA BARAT</td>\n",
       "      <td>BOGOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>IDE004768533625</td>\n",
       "      <td>2022-07-09 19:48:55</td>\n",
       "      <td>2022-07-09 19:48:55</td>\n",
       "      <td>TH CIAMPEA</td>\n",
       "      <td>2022-07-11 08:08:26</td>\n",
       "      <td>TH CILEDUG</td>\n",
       "      <td>09-07-2022 19:48:55</td>\n",
       "      <td>CIBUNGBULANG</td>\n",
       "      <td>TSHIRT KAOS POLOS QUALITY</td>\n",
       "      <td>0.4</td>\n",
       "      <td>...</td>\n",
       "      <td>085717227297</td>\n",
       "      <td>PERUMAHAN ARRAYA 2 BLOK. CK 02</td>\n",
       "      <td>Periodic</td>\n",
       "      <td>STD</td>\n",
       "      <td>Not Signed Yet</td>\n",
       "      <td>Komerce</td>\n",
       "      <td>BANTEN</td>\n",
       "      <td>KOTA TANGERANG</td>\n",
       "      <td>JAWA BARAT</td>\n",
       "      <td>BOGOR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>IDE004127489601</td>\n",
       "      <td>2022-07-09 21:06:03</td>\n",
       "      <td>2022-07-09 21:06:03</td>\n",
       "      <td>TH PULO GADUNG</td>\n",
       "      <td>2022-07-11 08:19:14</td>\n",
       "      <td>TH SUKAJADI</td>\n",
       "      <td>09-07-2022 21:06:03</td>\n",
       "      <td>PULO GADUNG</td>\n",
       "      <td>LAP MIKROFIBER</td>\n",
       "      <td>0.2</td>\n",
       "      <td>...</td>\n",
       "      <td>08111838448</td>\n",
       "      <td>jln. jati raya no. 29 rt.006  rw.003,</td>\n",
       "      <td>Periodic</td>\n",
       "      <td>STD</td>\n",
       "      <td>Not Signed Yet</td>\n",
       "      <td>Komerce</td>\n",
       "      <td>JAWA BARAT</td>\n",
       "      <td>KOTA BANDUNG</td>\n",
       "      <td>DKI JAKARTA</td>\n",
       "      <td>JAKARTA TIMUR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>IDE006684570722</td>\n",
       "      <td>2022-07-09 17:55:28</td>\n",
       "      <td>2022-07-09 17:55:28</td>\n",
       "      <td>TH SETU</td>\n",
       "      <td>2022-07-11 08:35:29</td>\n",
       "      <td>TH BOGOR TIMUR</td>\n",
       "      <td>03-11-2020 16:54:42</td>\n",
       "      <td>MUSTIKAJAYA</td>\n",
       "      <td>Casing Hp Custom</td>\n",
       "      <td>0.1</td>\n",
       "      <td>...</td>\n",
       "      <td>082136624303</td>\n",
       "      <td>Jl. Benda Gg. H, Nimun RT 01,01 [ mebel pak ja...</td>\n",
       "      <td>Periodic</td>\n",
       "      <td>STD</td>\n",
       "      <td>Not Signed Yet</td>\n",
       "      <td>Komerce</td>\n",
       "      <td>JAWA BARAT</td>\n",
       "      <td>KOTA BOGOR</td>\n",
       "      <td>JAWA BARAT</td>\n",
       "      <td>KOTA BEKASI</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>187</th>\n",
       "      <td>IDE008146224939</td>\n",
       "      <td>2022-07-09 19:00:34</td>\n",
       "      <td>2022-07-09 19:00:34</td>\n",
       "      <td>TH MERTOYUDAN</td>\n",
       "      <td>2022-07-11 20:26:53</td>\n",
       "      <td>TH SIDAREJA</td>\n",
       "      <td>09-07-2022 18:54:41</td>\n",
       "      <td>BANDONGAN</td>\n",
       "      <td>calistung 14 jilid</td>\n",
       "      <td>0.25</td>\n",
       "      <td>...</td>\n",
       "      <td>085643563765</td>\n",
       "      <td>Kwancen Rt 3 , Rw 1 Bandongan</td>\n",
       "      <td>Periodic</td>\n",
       "      <td>STD</td>\n",
       "      <td>Not Signed Yet</td>\n",
       "      <td>Komerce</td>\n",
       "      <td>JAWA TENGAH</td>\n",
       "      <td>CILACAP</td>\n",
       "      <td>JAWA TENGAH</td>\n",
       "      <td>MAGELANG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>IDE002955271066</td>\n",
       "      <td>2022-07-09 17:43:42</td>\n",
       "      <td>2022-07-09 17:43:42</td>\n",
       "      <td>TH PONOROGO</td>\n",
       "      <td>2022-07-11 20:29:57</td>\n",
       "      <td>TH KROYA</td>\n",
       "      <td>09-07-2022 16:20:30</td>\n",
       "      <td>JENANGAN</td>\n",
       "      <td>AKAR KUNING 1 KG</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>083130734792</td>\n",
       "      <td>DUSUN TRENCENG RT 02 RW 05</td>\n",
       "      <td>Periodic</td>\n",
       "      <td>STD</td>\n",
       "      <td>Not Signed Yet</td>\n",
       "      <td>Komerce</td>\n",
       "      <td>JAWA TENGAH</td>\n",
       "      <td>CILACAP</td>\n",
       "      <td>JAWA TIMUR</td>\n",
       "      <td>PONOROGO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>IDE007060973776</td>\n",
       "      <td>2022-07-08 17:17:37</td>\n",
       "      <td>2022-07-08 17:17:37</td>\n",
       "      <td>TH UMBULHARJO</td>\n",
       "      <td>2022-07-11 20:32:13</td>\n",
       "      <td>TH GENTENG</td>\n",
       "      <td>08-07-2022 17:17:42</td>\n",
       "      <td>BANGUNTAPAN</td>\n",
       "      <td>jam tangan kayu</td>\n",
       "      <td>0.08</td>\n",
       "      <td>...</td>\n",
       "      <td>089620995927</td>\n",
       "      <td>Jl. Gatak gg. Tulip nomor 342 , Karangbendo, J...</td>\n",
       "      <td>Periodic</td>\n",
       "      <td>STD</td>\n",
       "      <td>Not Signed Yet</td>\n",
       "      <td>Komerce</td>\n",
       "      <td>JAWA TIMUR</td>\n",
       "      <td>BANYUWANGI</td>\n",
       "      <td>DI YOGYAKARTA</td>\n",
       "      <td>BANTUL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>IDE004085024647</td>\n",
       "      <td>2022-07-08 21:13:19</td>\n",
       "      <td>2022-07-08 21:13:19</td>\n",
       "      <td>TH KETAPANG</td>\n",
       "      <td>2022-07-11 21:13:33</td>\n",
       "      <td>TH SUKAJADI</td>\n",
       "      <td>08-07-2022 21:13:19</td>\n",
       "      <td>SOKOBANAH</td>\n",
       "      <td>KOREK USB</td>\n",
       "      <td>0.2</td>\n",
       "      <td>...</td>\n",
       "      <td>085935150513</td>\n",
       "      <td>dusun.mondis laok (patokan SDN sokobanah tenga...</td>\n",
       "      <td>Periodic</td>\n",
       "      <td>STD</td>\n",
       "      <td>Not Signed Yet</td>\n",
       "      <td>Komerce</td>\n",
       "      <td>JAWA BARAT</td>\n",
       "      <td>KOTA BANDUNG</td>\n",
       "      <td>JAWA TIMUR</td>\n",
       "      <td>SAMPANG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>IDE004737364694</td>\n",
       "      <td>2022-07-09 21:07:12</td>\n",
       "      <td>2022-07-09 21:07:12</td>\n",
       "      <td>TH MUNGKID</td>\n",
       "      <td>2022-07-11 21:20:51</td>\n",
       "      <td>TH SUKAJADI</td>\n",
       "      <td>09-07-2022 21:07:12</td>\n",
       "      <td>MUNGKID</td>\n",
       "      <td>ALAT CUKUR MINI</td>\n",
       "      <td>0.15</td>\n",
       "      <td>...</td>\n",
       "      <td>085742459301</td>\n",
       "      <td>pucangan RT.03 RW.10,</td>\n",
       "      <td>Periodic</td>\n",
       "      <td>STD</td>\n",
       "      <td>Not Signed Yet</td>\n",
       "      <td>Komerce</td>\n",
       "      <td>JAWA BARAT</td>\n",
       "      <td>KOTA BANDUNG</td>\n",
       "      <td>JAWA TENGAH</td>\n",
       "      <td>MAGELANG</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>192 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         Waybill No.       Shipping Date       Shipping Time  \\\n",
       "0    IDE002705350814 2022-07-07 17:34:16 2022-07-07 17:34:16   \n",
       "1    IDE000407114735 2022-07-09 21:02:26 2022-07-09 21:02:26   \n",
       "2    IDE004768533625 2022-07-09 19:48:55 2022-07-09 19:48:55   \n",
       "3    IDE004127489601 2022-07-09 21:06:03 2022-07-09 21:06:03   \n",
       "4    IDE006684570722 2022-07-09 17:55:28 2022-07-09 17:55:28   \n",
       "..               ...                 ...                 ...   \n",
       "187  IDE008146224939 2022-07-09 19:00:34 2022-07-09 19:00:34   \n",
       "188  IDE002955271066 2022-07-09 17:43:42 2022-07-09 17:43:42   \n",
       "189  IDE007060973776 2022-07-08 17:17:37 2022-07-08 17:17:37   \n",
       "190  IDE004085024647 2022-07-08 21:13:19 2022-07-08 21:13:19   \n",
       "191  IDE004737364694 2022-07-09 21:07:12 2022-07-09 21:07:12   \n",
       "\n",
       "            POD Branch            POD Time   Origin Branch  \\\n",
       "0    TH SAMARINDA KOTA 2022-07-11 07:56:03        TH KROYA   \n",
       "1         TH CILEUNGSI 2022-07-11 08:01:41     TH SUKAJADI   \n",
       "2           TH CIAMPEA 2022-07-11 08:08:26      TH CILEDUG   \n",
       "3       TH PULO GADUNG 2022-07-11 08:19:14     TH SUKAJADI   \n",
       "4              TH SETU 2022-07-11 08:35:29  TH BOGOR TIMUR   \n",
       "..                 ...                 ...             ...   \n",
       "187      TH MERTOYUDAN 2022-07-11 20:26:53     TH SIDAREJA   \n",
       "188        TH PONOROGO 2022-07-11 20:29:57        TH KROYA   \n",
       "189      TH UMBULHARJO 2022-07-11 20:32:13      TH GENTENG   \n",
       "190        TH KETAPANG 2022-07-11 21:13:33     TH SUKAJADI   \n",
       "191         TH MUNGKID 2022-07-11 21:20:51     TH SUKAJADI   \n",
       "\n",
       "             Pickup Time    Destination                  Item Name  \\\n",
       "0    07-07-2022 17:25:36  SAMARINDA ULU   TAMPALA TUNGGAL 500 GRAM   \n",
       "1    09-07-2022 21:02:26   GUNUNG PUTRI                 INPODS I11   \n",
       "2    09-07-2022 19:48:55   CIBUNGBULANG  TSHIRT KAOS POLOS QUALITY   \n",
       "3    09-07-2022 21:06:03    PULO GADUNG             LAP MIKROFIBER   \n",
       "4    03-11-2020 16:54:42    MUSTIKAJAYA           Casing Hp Custom   \n",
       "..                   ...            ...                        ...   \n",
       "187  09-07-2022 18:54:41      BANDONGAN         calistung 14 jilid   \n",
       "188  09-07-2022 16:20:30       JENANGAN           AKAR KUNING 1 KG   \n",
       "189  08-07-2022 17:17:42    BANGUNTAPAN            jam tangan kayu   \n",
       "190  08-07-2022 21:13:19      SOKOBANAH                  KOREK USB   \n",
       "191  09-07-2022 21:07:12        MUNGKID            ALAT CUKUR MINI   \n",
       "\n",
       "    Calculated Weight  ... Recipient Handphone  \\\n",
       "0                 0.5  ...        081952457738   \n",
       "1                0.35  ...        082180450108   \n",
       "2                 0.4  ...        085717227297   \n",
       "3                 0.2  ...         08111838448   \n",
       "4                 0.1  ...        082136624303   \n",
       "..                ...  ...                 ...   \n",
       "187              0.25  ...        085643563765   \n",
       "188                 1  ...        083130734792   \n",
       "189              0.08  ...        089620995927   \n",
       "190               0.2  ...        085935150513   \n",
       "191              0.15  ...        085742459301   \n",
       "\n",
       "                                     Recipient Address Payment Type  \\\n",
       "0    DEPAN PENAGDILAN NEGERI JL. M YAMIN RUKO KAPLI...     Periodic   \n",
       "1    legenda wisata zona mozart blok g.1,26 rt.03 r...     Periodic   \n",
       "2                       PERUMAHAN ARRAYA 2 BLOK. CK 02     Periodic   \n",
       "3                jln. jati raya no. 29 rt.006  rw.003,     Periodic   \n",
       "4    Jl. Benda Gg. H, Nimun RT 01,01 [ mebel pak ja...     Periodic   \n",
       "..                                                 ...          ...   \n",
       "187                      Kwancen Rt 3 , Rw 1 Bandongan     Periodic   \n",
       "188                         DUSUN TRENCENG RT 02 RW 05     Periodic   \n",
       "189  Jl. Gatak gg. Tulip nomor 342 , Karangbendo, J...     Periodic   \n",
       "190  dusun.mondis laok (patokan SDN sokobanah tenga...     Periodic   \n",
       "191                              pucangan RT.03 RW.10,     Periodic   \n",
       "\n",
       "    Express Type      POD Status Waybill Source Origin Province  \\\n",
       "0            STD  Not Signed Yet        Komerce     JAWA TENGAH   \n",
       "1            STD  Not Signed Yet        Komerce      JAWA BARAT   \n",
       "2            STD  Not Signed Yet        Komerce          BANTEN   \n",
       "3            STD  Not Signed Yet        Komerce      JAWA BARAT   \n",
       "4            STD  Not Signed Yet        Komerce      JAWA BARAT   \n",
       "..           ...             ...            ...             ...   \n",
       "187          STD  Not Signed Yet        Komerce     JAWA TENGAH   \n",
       "188          STD  Not Signed Yet        Komerce     JAWA TENGAH   \n",
       "189          STD  Not Signed Yet        Komerce      JAWA TIMUR   \n",
       "190          STD  Not Signed Yet        Komerce      JAWA BARAT   \n",
       "191          STD  Not Signed Yet        Komerce      JAWA BARAT   \n",
       "\n",
       "        Origin City Destination Province Destination City  \n",
       "0           CILACAP     KALIMANTAN TIMUR        SAMARINDA  \n",
       "1      KOTA BANDUNG           JAWA BARAT            BOGOR  \n",
       "2    KOTA TANGERANG           JAWA BARAT            BOGOR  \n",
       "3      KOTA BANDUNG          DKI JAKARTA    JAKARTA TIMUR  \n",
       "4        KOTA BOGOR           JAWA BARAT      KOTA BEKASI  \n",
       "..              ...                  ...              ...  \n",
       "187         CILACAP          JAWA TENGAH         MAGELANG  \n",
       "188         CILACAP           JAWA TIMUR         PONOROGO  \n",
       "189      BANYUWANGI        DI YOGYAKARTA           BANTUL  \n",
       "190    KOTA BANDUNG           JAWA TIMUR          SAMPANG  \n",
       "191    KOTA BANDUNG          JAWA TENGAH         MAGELANG  \n",
       "\n",
       "[192 rows x 31 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "search_waybill=search_waybill.loc[:,[\"Waybill No.\",\"Origin Branch\",\"Pickup Time\",\"Destination\",\"Item Name\",\"Calculated Weight\",\"COD Amount\",\"Insurance Fee\",\"Standard Shipping Fee\",\"Receivable Shipping Fee\",\"Handling Fee\",\"Other Fee\",\"Total Shipping Fee\",\"VIP Username\",\"Sender\",\"Sender Handphone\",\"Recipient\",\"Recipient Handphone\",\"Recipient Address\",\"Payment Type\",\"Express Type\",\"POD Status\",\"Waybill Source\",\"Origin Province\",\"Origin City\",\"Destination Province\",\"Destination City\"]]\n",
    "search_waybill.drop_duplicates(subset=[\"Waybill No.\"], keep='first', inplace = True)\n",
    "result=komerce.merge(search_waybill,how=\"left\", on=\"Waybill No.\")\n",
    "result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "ac083d05",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 192 entries, 0 to 191\n",
      "Data columns (total 31 columns):\n",
      " #   Column                   Non-Null Count  Dtype         \n",
      "---  ------                   --------------  -----         \n",
      " 0   Waybill No.              192 non-null    object        \n",
      " 1   Shipping Date            192 non-null    datetime64[ns]\n",
      " 2   Shipping Time            192 non-null    datetime64[ns]\n",
      " 3   POD Branch               192 non-null    object        \n",
      " 4   POD Time                 192 non-null    datetime64[ns]\n",
      " 5   Origin Branch            192 non-null    object        \n",
      " 6   Pickup Time              192 non-null    object        \n",
      " 7   Destination              192 non-null    object        \n",
      " 8   Item Name                192 non-null    object        \n",
      " 9   Calculated Weight        192 non-null    object        \n",
      " 10  COD Amount               192 non-null    object        \n",
      " 11  Insurance Fee            192 non-null    object        \n",
      " 12  Standard Shipping Fee    192 non-null    object        \n",
      " 13  Receivable Shipping Fee  192 non-null    object        \n",
      " 14  Handling Fee             192 non-null    object        \n",
      " 15  Other Fee                192 non-null    object        \n",
      " 16  Total Shipping Fee       192 non-null    object        \n",
      " 17  VIP Username             0 non-null      object        \n",
      " 18  Sender                   192 non-null    object        \n",
      " 19  Sender Handphone         192 non-null    object        \n",
      " 20  Recipient                192 non-null    object        \n",
      " 21  Recipient Handphone      192 non-null    object        \n",
      " 22  Recipient Address        192 non-null    object        \n",
      " 23  Payment Type             192 non-null    object        \n",
      " 24  Express Type             192 non-null    object        \n",
      " 25  POD Status               192 non-null    object        \n",
      " 26  Waybill Source           192 non-null    object        \n",
      " 27  Origin Province          192 non-null    object        \n",
      " 28  Origin City              192 non-null    object        \n",
      " 29  Destination Province     192 non-null    object        \n",
      " 30  Destination City         192 non-null    object        \n",
      "dtypes: datetime64[ns](3), object(28)\n",
      "memory usage: 48.0+ KB\n"
     ]
    }
   ],
   "source": [
    "result.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "4fe6bcae",
   "metadata": {},
   "outputs": [],
   "source": [
    "result.to_excel(\"E:\\REPORTING PARTNER IDX\\PROJECT KOMERCE\\KOMERCE JULI RESULT/Result_20220712_BI_11 Juli 2022 Delivered Parcels - Komerce_.xlsx\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "97d8f5b7",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}