Data Acquisition & Analysis on a Real Amazon Order History.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "amazon_order = pd.read_csv(\"sayandip_amazon_order_history.csv\")"
   ]
  },
  {
   "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>order id</th>\n",
       "      <th>items</th>\n",
       "      <th>to</th>\n",
       "      <th>date</th>\n",
       "      <th>total</th>\n",
       "      <th>shipping</th>\n",
       "      <th>shipping_refund</th>\n",
       "      <th>gift</th>\n",
       "      <th>VAT</th>\n",
       "      <th>refund</th>\n",
       "      <th>payments</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>405-0003762-5437921</td>\n",
       "      <td>NESCAFÉ The Ultimate Coffee Kit - Nescafe Clas...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-12-17</td>\n",
       "      <td>Rs.665.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>408-7891735-2418709</td>\n",
       "      <td>Amazon Pay balance: Money (Cash-load);</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-12-05</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>405-9078959-7873142</td>\n",
       "      <td>Dr Trust USA Gold Standard Blood Glucose Test ...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-11-30</td>\n",
       "      <td>Rs.749.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>405-9733244-4955544</td>\n",
       "      <td>Jik Store Back-Flow Monk Ganesh Incense Burner...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-11-11</td>\n",
       "      <td>Rs.168.00</td>\n",
       "      <td>Rs. 45.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>405-5267364-3897943</td>\n",
       "      <td>BETALA FRAGRANCE backflow incense dhoop cones,...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-11-11</td>\n",
       "      <td>Rs.260.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              order id                                              items  \\\n",
       "0  405-0003762-5437921  NESCAFÉ The Ultimate Coffee Kit - Nescafe Clas...   \n",
       "1  408-7891735-2418709            Amazon Pay balance: Money (Cash-load);    \n",
       "2  405-9078959-7873142  Dr Trust USA Gold Standard Blood Glucose Test ...   \n",
       "3  405-9733244-4955544  Jik Store Back-Flow Monk Ganesh Incense Burner...   \n",
       "4  405-5267364-3897943  BETALA FRAGRANCE backflow incense dhoop cones,...   \n",
       "\n",
       "              to        date      total   shipping shipping_refund gift VAT  \\\n",
       "0  SAYANDIP JANA  2021-12-17  Rs.665.00  Rs. 40.00               0    0   0   \n",
       "1              0  2021-12-05          0          0               0    0   0   \n",
       "2  SAYANDIP JANA  2021-11-30  Rs.749.00  Rs. 40.00               0    0   0   \n",
       "3  SAYANDIP JANA  2021-11-11  Rs.168.00  Rs. 45.00               0    0   0   \n",
       "4  SAYANDIP JANA  2021-11-11  Rs.260.00   Rs. 0.00               0    0   0   \n",
       "\n",
       "  refund   payments  \n",
       "0      0  UNKNOWN;   \n",
       "1      0  UNKNOWN;   \n",
       "2      0  UNKNOWN;   \n",
       "3      0  UNKNOWN;   \n",
       "4      0  UNKNOWN;   "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_order.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(41, 11)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_order.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['order id', 'items', 'to', 'date', 'total', 'shipping',\n",
       "       'shipping_refund', 'gift', 'VAT', 'refund', 'payments'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_order.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "amazon_order.columns = ['OrderId', 'PurchasedItems', 'CoustomerName', 'OrderDate', 'AmountPaid', 'ShippingCharges', 'RefundOnShippingCharges', 'Gift', 'Vat', 'TotalRefund', 'PaymentsMethod']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['OrderId', 'PurchasedItems', 'CoustomerName', 'OrderDate', 'AmountPaid',\n",
       "       'ShippingCharges', 'RefundOnShippingCharges', 'Gift', 'Vat',\n",
       "       'TotalRefund', 'PaymentsMethod'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_order.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>OrderId</th>\n",
       "      <th>PurchasedItems</th>\n",
       "      <th>CoustomerName</th>\n",
       "      <th>OrderDate</th>\n",
       "      <th>AmountPaid</th>\n",
       "      <th>ShippingCharges</th>\n",
       "      <th>RefundOnShippingCharges</th>\n",
       "      <th>Vat</th>\n",
       "      <th>TotalRefund</th>\n",
       "      <th>PaymentsMethod</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>405-0003762-5437921</td>\n",
       "      <td>NESCAFÉ The Ultimate Coffee Kit - Nescafe Clas...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-12-17</td>\n",
       "      <td>Rs.665.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>408-7891735-2418709</td>\n",
       "      <td>Amazon Pay balance: Money (Cash-load);</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-12-05</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>405-9078959-7873142</td>\n",
       "      <td>Dr Trust USA Gold Standard Blood Glucose Test ...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-11-30</td>\n",
       "      <td>Rs.749.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>405-9733244-4955544</td>\n",
       "      <td>Jik Store Back-Flow Monk Ganesh Incense Burner...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-11-11</td>\n",
       "      <td>Rs.168.00</td>\n",
       "      <td>Rs. 45.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>405-5267364-3897943</td>\n",
       "      <td>BETALA FRAGRANCE backflow incense dhoop cones,...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-11-11</td>\n",
       "      <td>Rs.260.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>405-6165870-5850763</td>\n",
       "      <td>Steelbird Helmet Visor Compatible for All SBA-...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-11-05</td>\n",
       "      <td>Rs.719.00</td>\n",
       "      <td>Rs. 80.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>405-0677865-3480309</td>\n",
       "      <td>Noise Flair in-Ear Wireless Bluetooth Smart Ne...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-09-25</td>\n",
       "      <td>Rs.1,799.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>408-7762891-3816341</td>\n",
       "      <td>Amazon Pay balance: Money (Cash-load);</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-07-10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>405-9623015-8633136</td>\n",
       "      <td>BVB mart 46 in 1 Pcs Tool Kit &amp; Screwdriver an...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-07-04</td>\n",
       "      <td>Rs.999.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>408-6188597-7267506</td>\n",
       "      <td>Gadget Deals 5W - USB Light Emergencey use USB...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-07-04</td>\n",
       "      <td>Rs.0.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>405-3319950-0533926</td>\n",
       "      <td>Mobile Prepaid Recharge; Recharge Again;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-04-18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>405-5416197-2397960</td>\n",
       "      <td>RiaTech 2 Pack (290mm x 240mm x 2mm) Mouse Pad...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-04-13</td>\n",
       "      <td>Rs.658.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>405-5418433-1773156</td>\n",
       "      <td>MTT Designer Pattern Printed Soft Jelly Back c...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-04-12</td>\n",
       "      <td>Rs.199.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Rs. 199.00</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>405-2704243-0424331</td>\n",
       "      <td>Happilo Premium Californian Roasted &amp; Salted P...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-04-07</td>\n",
       "      <td>Rs.613.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>405-1687112-2865951</td>\n",
       "      <td>Mobile Prepaid Recharge; Recharge Again;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-04-07</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>405-3624305-1269168</td>\n",
       "      <td>Amazon Pay balance: Money;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-04-07</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>405-8765460-7178760</td>\n",
       "      <td>Electricity bill payment; Pay Another Bill;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-04-06</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>405-3653656-3354736</td>\n",
       "      <td>Electricity bill payment; Pay Another Bill;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-03-29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>405-6338929-6177908</td>\n",
       "      <td>Amazon Pay balance: Money;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-03-27</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>405-1558231-8669929</td>\n",
       "      <td>Electricity bill payment; Pay Another Bill;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-03-27</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>405-7749663-6305152</td>\n",
       "      <td>Mobile Prepaid Recharge; Recharge Again;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-03-27</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>405-8034669-2665163</td>\n",
       "      <td>Mobile Prepaid Recharge; Recharge Again;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-03-27</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>405-0262912-6651577</td>\n",
       "      <td>Amazon Pay balance: Money;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-03-24</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>405-2557853-3225134</td>\n",
       "      <td>SLOVIC Premium Resistance Band/Tubes with Foam...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-03-19</td>\n",
       "      <td>Rs.1,999.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>408-8762498-8158757</td>\n",
       "      <td>Amazon Pay balance: Money (Cash-load);</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-02-25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>405-6678336-7939555</td>\n",
       "      <td>Mivi ThunderBeats Bluetooth Earphones Wireless...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-02-23</td>\n",
       "      <td>Rs.1,199.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Rs. 1,199.00</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>405-3466032-7690750</td>\n",
       "      <td>Head &amp; Shoulders 2-in-1 Cool Menthol Anti Dand...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-02-23</td>\n",
       "      <td>Rs.730.00</td>\n",
       "      <td>Rs. 80.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>405-4199925-1997962</td>\n",
       "      <td>Neuherbs Green Coffee Beans powder For Weight ...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-02-15</td>\n",
       "      <td>Rs.389.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>405-3242053-3508358</td>\n",
       "      <td>CLAW Shoot Bluetooth Mobile Gamepad Controller...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-02-11</td>\n",
       "      <td>Rs.1,790.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>405-5960454-1305915</td>\n",
       "      <td>Noise ColorFit Pro 3 Smart Watch with 1.55\" HD...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-02-10</td>\n",
       "      <td>Rs.3,999.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>408-2078289-8142761</td>\n",
       "      <td>Amazon Pay balance: Money (Cash-load);</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>405-5528265-6595514</td>\n",
       "      <td>Gadget Deals 5W - USB Light Emergencey use USB...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-06-29</td>\n",
       "      <td>Rs.269.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>405-5394347-8821920</td>\n",
       "      <td>Myprotein Impact Whey Isolate, Mango, 500gm;</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-06-26</td>\n",
       "      <td>Rs.1,300.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>405-8576024-3514741</td>\n",
       "      <td>amiciVision Metal LED Torch Flashlight XML T6 ...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-06-21</td>\n",
       "      <td>Rs.1,199.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>405-5706951-6205969</td>\n",
       "      <td>BVB mart 46 in 1 Pcs Tool Kit &amp; Screwdriver an...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-06-21</td>\n",
       "      <td>Rs.999.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>405-8623079-6509966</td>\n",
       "      <td>Panasonic eneloop BQ-CC61N Portable Charger wi...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>Rs.680.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>405-0391270-2368329</td>\n",
       "      <td>Mtt Designer Pattern Printed Soft Jelly Back C...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-04-27</td>\n",
       "      <td>Rs.239.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Rs. 239.00</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>405-7122023-0730725</td>\n",
       "      <td>Amazon Pay balance: Money;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-04-20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>405-4770625-7145915</td>\n",
       "      <td>Amazon Pay balance: Money;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-04-20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>408-8986572-2209160</td>\n",
       "      <td>MTT Designer Pattern Printed Soft Jelly Back c...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-04-18</td>\n",
       "      <td>Rs.0.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>order id</td>\n",
       "      <td>items</td>\n",
       "      <td>to</td>\n",
       "      <td>date</td>\n",
       "      <td>total</td>\n",
       "      <td>shipping</td>\n",
       "      <td>shipping_refund</td>\n",
       "      <td>VAT</td>\n",
       "      <td>refund</td>\n",
       "      <td>payments</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                OrderId                                     PurchasedItems  \\\n",
       "0   405-0003762-5437921  NESCAFÉ The Ultimate Coffee Kit - Nescafe Clas...   \n",
       "1   408-7891735-2418709            Amazon Pay balance: Money (Cash-load);    \n",
       "2   405-9078959-7873142  Dr Trust USA Gold Standard Blood Glucose Test ...   \n",
       "3   405-9733244-4955544  Jik Store Back-Flow Monk Ganesh Incense Burner...   \n",
       "4   405-5267364-3897943  BETALA FRAGRANCE backflow incense dhoop cones,...   \n",
       "5   405-6165870-5850763  Steelbird Helmet Visor Compatible for All SBA-...   \n",
       "6   405-0677865-3480309  Noise Flair in-Ear Wireless Bluetooth Smart Ne...   \n",
       "7   408-7762891-3816341            Amazon Pay balance: Money (Cash-load);    \n",
       "8   405-9623015-8633136  BVB mart 46 in 1 Pcs Tool Kit & Screwdriver an...   \n",
       "9   408-6188597-7267506  Gadget Deals 5W - USB Light Emergencey use USB...   \n",
       "10  405-3319950-0533926          Mobile Prepaid Recharge; Recharge Again;    \n",
       "11  405-5416197-2397960  RiaTech 2 Pack (290mm x 240mm x 2mm) Mouse Pad...   \n",
       "12  405-5418433-1773156  MTT Designer Pattern Printed Soft Jelly Back c...   \n",
       "13  405-2704243-0424331  Happilo Premium Californian Roasted & Salted P...   \n",
       "14  405-1687112-2865951          Mobile Prepaid Recharge; Recharge Again;    \n",
       "15  405-3624305-1269168                        Amazon Pay balance: Money;    \n",
       "16  405-8765460-7178760       Electricity bill payment; Pay Another Bill;    \n",
       "17  405-3653656-3354736       Electricity bill payment; Pay Another Bill;    \n",
       "18  405-6338929-6177908                        Amazon Pay balance: Money;    \n",
       "19  405-1558231-8669929       Electricity bill payment; Pay Another Bill;    \n",
       "20  405-7749663-6305152          Mobile Prepaid Recharge; Recharge Again;    \n",
       "21  405-8034669-2665163          Mobile Prepaid Recharge; Recharge Again;    \n",
       "22  405-0262912-6651577                        Amazon Pay balance: Money;    \n",
       "23  405-2557853-3225134  SLOVIC Premium Resistance Band/Tubes with Foam...   \n",
       "24  408-8762498-8158757            Amazon Pay balance: Money (Cash-load);    \n",
       "25  405-6678336-7939555  Mivi ThunderBeats Bluetooth Earphones Wireless...   \n",
       "26  405-3466032-7690750  Head & Shoulders 2-in-1 Cool Menthol Anti Dand...   \n",
       "27  405-4199925-1997962  Neuherbs Green Coffee Beans powder For Weight ...   \n",
       "28  405-3242053-3508358  CLAW Shoot Bluetooth Mobile Gamepad Controller...   \n",
       "29  405-5960454-1305915  Noise ColorFit Pro 3 Smart Watch with 1.55\" HD...   \n",
       "30  408-2078289-8142761            Amazon Pay balance: Money (Cash-load);    \n",
       "31  405-5528265-6595514  Gadget Deals 5W - USB Light Emergencey use USB...   \n",
       "32  405-5394347-8821920      Myprotein Impact Whey Isolate, Mango, 500gm;    \n",
       "33  405-8576024-3514741  amiciVision Metal LED Torch Flashlight XML T6 ...   \n",
       "34  405-5706951-6205969  BVB mart 46 in 1 Pcs Tool Kit & Screwdriver an...   \n",
       "35  405-8623079-6509966  Panasonic eneloop BQ-CC61N Portable Charger wi...   \n",
       "36  405-0391270-2368329  Mtt Designer Pattern Printed Soft Jelly Back C...   \n",
       "37  405-7122023-0730725                        Amazon Pay balance: Money;    \n",
       "38  405-4770625-7145915                        Amazon Pay balance: Money;    \n",
       "39  408-8986572-2209160  MTT Designer Pattern Printed Soft Jelly Back c...   \n",
       "40             order id                                              items   \n",
       "\n",
       "    CoustomerName   OrderDate   AmountPaid ShippingCharges  \\\n",
       "0   SAYANDIP JANA  2021-12-17    Rs.665.00       Rs. 40.00   \n",
       "1               0  2021-12-05            0               0   \n",
       "2   SAYANDIP JANA  2021-11-30    Rs.749.00       Rs. 40.00   \n",
       "3   SAYANDIP JANA  2021-11-11    Rs.168.00       Rs. 45.00   \n",
       "4   SAYANDIP JANA  2021-11-11    Rs.260.00        Rs. 0.00   \n",
       "5   SAYANDIP JANA  2021-11-05    Rs.719.00       Rs. 80.00   \n",
       "6   SAYANDIP JANA  2021-09-25  Rs.1,799.00       Rs. 40.00   \n",
       "7               0  2021-07-10            0               0   \n",
       "8   SAYANDIP JANA  2021-07-04    Rs.999.00        Rs. 0.00   \n",
       "9   SAYANDIP JANA  2021-07-04      Rs.0.00        Rs. 0.00   \n",
       "10              0  2021-04-18            0               0   \n",
       "11  SAYANDIP JANA  2021-04-13    Rs.658.00        Rs. 0.00   \n",
       "12  SAYANDIP JANA  2021-04-12    Rs.199.00        Rs. 0.00   \n",
       "13  SAYANDIP JANA  2021-04-07    Rs.613.00        Rs. 0.00   \n",
       "14              0  2021-04-07            0               0   \n",
       "15              0  2021-04-07            0               0   \n",
       "16              0  2021-04-06            0               0   \n",
       "17              0  2021-03-29            0               0   \n",
       "18              0  2021-03-27            0               0   \n",
       "19              0  2021-03-27            0               0   \n",
       "20              0  2021-03-27            0               0   \n",
       "21              0  2021-03-27            0               0   \n",
       "22              0  2021-03-24            0               0   \n",
       "23  SAYANDIP JANA  2021-03-19  Rs.1,999.00       Rs. 40.00   \n",
       "24              0  2021-02-25            0               0   \n",
       "25  SAYANDIP JANA  2021-02-23  Rs.1,199.00       Rs. 40.00   \n",
       "26  SAYANDIP JANA  2021-02-23    Rs.730.00       Rs. 80.00   \n",
       "27  SAYANDIP JANA  2021-02-15    Rs.389.00       Rs. 40.00   \n",
       "28  SAYANDIP JANA  2021-02-11  Rs.1,790.00        Rs. 0.00   \n",
       "29  SAYANDIP JANA  2021-02-10  Rs.3,999.00       Rs. 40.00   \n",
       "30              0  2021-07-01            0               0   \n",
       "31  SAYANDIP JANA  2021-06-29    Rs.269.00        Rs. 0.00   \n",
       "32  SAYANDIP JANA  2021-06-26  Rs.1,300.00       Rs. 40.00   \n",
       "33  SAYANDIP JANA  2021-06-21  Rs.1,199.00       Rs. 40.00   \n",
       "34  SAYANDIP JANA  2021-06-21    Rs.999.00        Rs. 0.00   \n",
       "35  SAYANDIP JANA  2021-05-08    Rs.680.00       Rs. 40.00   \n",
       "36  SAYANDIP JANA  2021-04-27    Rs.239.00       Rs. 40.00   \n",
       "37              0  2021-04-20            0               0   \n",
       "38              0  2021-04-20            0               0   \n",
       "39  SAYANDIP JANA  2021-04-18      Rs.0.00        Rs. 0.00   \n",
       "40             to        date        total        shipping   \n",
       "\n",
       "   RefundOnShippingCharges  Vat   TotalRefund PaymentsMethod  \n",
       "0                        0    0             0      UNKNOWN;   \n",
       "1                        0    0             0      UNKNOWN;   \n",
       "2                        0    0             0      UNKNOWN;   \n",
       "3                        0    0             0      UNKNOWN;   \n",
       "4                        0    0             0      UNKNOWN;   \n",
       "5                        0    0             0      UNKNOWN;   \n",
       "6                        0    0             0      UNKNOWN;   \n",
       "7                        0    0             0      UNKNOWN;   \n",
       "8                        0    0             0      UNKNOWN;   \n",
       "9                        0    0             0      UNKNOWN;   \n",
       "10                       0    0             0      UNKNOWN;   \n",
       "11                       0    0             0      UNKNOWN;   \n",
       "12                       0    0    Rs. 199.00      UNKNOWN;   \n",
       "13                       0    0             0      UNKNOWN;   \n",
       "14                       0    0             0      UNKNOWN;   \n",
       "15                       0    0             0      UNKNOWN;   \n",
       "16                       0    0             0      UNKNOWN;   \n",
       "17                       0    0             0      UNKNOWN;   \n",
       "18                       0    0             0      UNKNOWN;   \n",
       "19                       0    0             0      UNKNOWN;   \n",
       "20                       0    0             0      UNKNOWN;   \n",
       "21                       0    0             0      UNKNOWN;   \n",
       "22                       0    0             0      UNKNOWN;   \n",
       "23                       0    0             0      UNKNOWN;   \n",
       "24                       0    0             0      UNKNOWN;   \n",
       "25                       0    0  Rs. 1,199.00      UNKNOWN;   \n",
       "26                       0    0             0      UNKNOWN;   \n",
       "27                       0    0             0      UNKNOWN;   \n",
       "28                       0    0             0      UNKNOWN;   \n",
       "29                       0    0             0      UNKNOWN;   \n",
       "30                       0    0             0      UNKNOWN;   \n",
       "31                       0    0             0      UNKNOWN;   \n",
       "32                       0    0             0      UNKNOWN;   \n",
       "33                       0    0             0      UNKNOWN;   \n",
       "34                       0    0             0      UNKNOWN;   \n",
       "35                       0    0             0      UNKNOWN;   \n",
       "36                       0    0    Rs. 239.00      UNKNOWN;   \n",
       "37                       0    0             0      UNKNOWN;   \n",
       "38                       0    0             0      UNKNOWN;   \n",
       "39                       0    0             0      UNKNOWN;   \n",
       "40         shipping_refund  VAT        refund       payments  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_order.drop(\"Gift\", axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>OrderId</th>\n",
       "      <th>PurchasedItems</th>\n",
       "      <th>CoustomerName</th>\n",
       "      <th>OrderDate</th>\n",
       "      <th>AmountPaid</th>\n",
       "      <th>ShippingCharges</th>\n",
       "      <th>RefundOnShippingCharges</th>\n",
       "      <th>Gift</th>\n",
       "      <th>Vat</th>\n",
       "      <th>TotalRefund</th>\n",
       "      <th>PaymentsMethod</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>405-0003762-5437921</td>\n",
       "      <td>NESCAFÉ The Ultimate Coffee Kit - Nescafe Clas...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-12-17</td>\n",
       "      <td>Rs.665.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>408-7891735-2418709</td>\n",
       "      <td>Amazon Pay balance: Money (Cash-load);</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-12-05</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>405-9078959-7873142</td>\n",
       "      <td>Dr Trust USA Gold Standard Blood Glucose Test ...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-11-30</td>\n",
       "      <td>Rs.749.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>405-9733244-4955544</td>\n",
       "      <td>Jik Store Back-Flow Monk Ganesh Incense Burner...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-11-11</td>\n",
       "      <td>Rs.168.00</td>\n",
       "      <td>Rs. 45.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>405-5267364-3897943</td>\n",
       "      <td>BETALA FRAGRANCE backflow incense dhoop cones,...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-11-11</td>\n",
       "      <td>Rs.260.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>405-6165870-5850763</td>\n",
       "      <td>Steelbird Helmet Visor Compatible for All SBA-...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-11-05</td>\n",
       "      <td>Rs.719.00</td>\n",
       "      <td>Rs. 80.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>405-0677865-3480309</td>\n",
       "      <td>Noise Flair in-Ear Wireless Bluetooth Smart Ne...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-09-25</td>\n",
       "      <td>Rs.1,799.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>408-7762891-3816341</td>\n",
       "      <td>Amazon Pay balance: Money (Cash-load);</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-07-10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>405-9623015-8633136</td>\n",
       "      <td>BVB mart 46 in 1 Pcs Tool Kit &amp; Screwdriver an...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-07-04</td>\n",
       "      <td>Rs.999.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>408-6188597-7267506</td>\n",
       "      <td>Gadget Deals 5W - USB Light Emergencey use USB...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-07-04</td>\n",
       "      <td>Rs.0.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>405-3319950-0533926</td>\n",
       "      <td>Mobile Prepaid Recharge; Recharge Again;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-04-18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>405-5416197-2397960</td>\n",
       "      <td>RiaTech 2 Pack (290mm x 240mm x 2mm) Mouse Pad...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-04-13</td>\n",
       "      <td>Rs.658.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>405-5418433-1773156</td>\n",
       "      <td>MTT Designer Pattern Printed Soft Jelly Back c...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-04-12</td>\n",
       "      <td>Rs.199.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Rs. 199.00</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>405-2704243-0424331</td>\n",
       "      <td>Happilo Premium Californian Roasted &amp; Salted P...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-04-07</td>\n",
       "      <td>Rs.613.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>405-1687112-2865951</td>\n",
       "      <td>Mobile Prepaid Recharge; Recharge Again;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-04-07</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>405-3624305-1269168</td>\n",
       "      <td>Amazon Pay balance: Money;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-04-07</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>405-8765460-7178760</td>\n",
       "      <td>Electricity bill payment; Pay Another Bill;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-04-06</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>405-3653656-3354736</td>\n",
       "      <td>Electricity bill payment; Pay Another Bill;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-03-29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>405-6338929-6177908</td>\n",
       "      <td>Amazon Pay balance: Money;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-03-27</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>405-1558231-8669929</td>\n",
       "      <td>Electricity bill payment; Pay Another Bill;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-03-27</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>405-7749663-6305152</td>\n",
       "      <td>Mobile Prepaid Recharge; Recharge Again;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-03-27</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>405-8034669-2665163</td>\n",
       "      <td>Mobile Prepaid Recharge; Recharge Again;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-03-27</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>405-0262912-6651577</td>\n",
       "      <td>Amazon Pay balance: Money;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-03-24</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>405-2557853-3225134</td>\n",
       "      <td>SLOVIC Premium Resistance Band/Tubes with Foam...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-03-19</td>\n",
       "      <td>Rs.1,999.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>408-8762498-8158757</td>\n",
       "      <td>Amazon Pay balance: Money (Cash-load);</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-02-25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>405-6678336-7939555</td>\n",
       "      <td>Mivi ThunderBeats Bluetooth Earphones Wireless...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-02-23</td>\n",
       "      <td>Rs.1,199.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Rs. 1,199.00</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>405-3466032-7690750</td>\n",
       "      <td>Head &amp; Shoulders 2-in-1 Cool Menthol Anti Dand...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-02-23</td>\n",
       "      <td>Rs.730.00</td>\n",
       "      <td>Rs. 80.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>405-4199925-1997962</td>\n",
       "      <td>Neuherbs Green Coffee Beans powder For Weight ...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-02-15</td>\n",
       "      <td>Rs.389.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>405-3242053-3508358</td>\n",
       "      <td>CLAW Shoot Bluetooth Mobile Gamepad Controller...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-02-11</td>\n",
       "      <td>Rs.1,790.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>405-5960454-1305915</td>\n",
       "      <td>Noise ColorFit Pro 3 Smart Watch with 1.55\" HD...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-02-10</td>\n",
       "      <td>Rs.3,999.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>408-2078289-8142761</td>\n",
       "      <td>Amazon Pay balance: Money (Cash-load);</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-07-01</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>405-5528265-6595514</td>\n",
       "      <td>Gadget Deals 5W - USB Light Emergencey use USB...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-06-29</td>\n",
       "      <td>Rs.269.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>405-5394347-8821920</td>\n",
       "      <td>Myprotein Impact Whey Isolate, Mango, 500gm;</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-06-26</td>\n",
       "      <td>Rs.1,300.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>405-8576024-3514741</td>\n",
       "      <td>amiciVision Metal LED Torch Flashlight XML T6 ...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-06-21</td>\n",
       "      <td>Rs.1,199.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>405-5706951-6205969</td>\n",
       "      <td>BVB mart 46 in 1 Pcs Tool Kit &amp; Screwdriver an...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-06-21</td>\n",
       "      <td>Rs.999.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>405-8623079-6509966</td>\n",
       "      <td>Panasonic eneloop BQ-CC61N Portable Charger wi...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-05-08</td>\n",
       "      <td>Rs.680.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>405-0391270-2368329</td>\n",
       "      <td>Mtt Designer Pattern Printed Soft Jelly Back C...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-04-27</td>\n",
       "      <td>Rs.239.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Rs. 239.00</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>405-7122023-0730725</td>\n",
       "      <td>Amazon Pay balance: Money;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-04-20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>405-4770625-7145915</td>\n",
       "      <td>Amazon Pay balance: Money;</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-04-20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>408-8986572-2209160</td>\n",
       "      <td>MTT Designer Pattern Printed Soft Jelly Back c...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-04-18</td>\n",
       "      <td>Rs.0.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                OrderId                                     PurchasedItems  \\\n",
       "0   405-0003762-5437921  NESCAFÉ The Ultimate Coffee Kit - Nescafe Clas...   \n",
       "1   408-7891735-2418709            Amazon Pay balance: Money (Cash-load);    \n",
       "2   405-9078959-7873142  Dr Trust USA Gold Standard Blood Glucose Test ...   \n",
       "3   405-9733244-4955544  Jik Store Back-Flow Monk Ganesh Incense Burner...   \n",
       "4   405-5267364-3897943  BETALA FRAGRANCE backflow incense dhoop cones,...   \n",
       "5   405-6165870-5850763  Steelbird Helmet Visor Compatible for All SBA-...   \n",
       "6   405-0677865-3480309  Noise Flair in-Ear Wireless Bluetooth Smart Ne...   \n",
       "7   408-7762891-3816341            Amazon Pay balance: Money (Cash-load);    \n",
       "8   405-9623015-8633136  BVB mart 46 in 1 Pcs Tool Kit & Screwdriver an...   \n",
       "9   408-6188597-7267506  Gadget Deals 5W - USB Light Emergencey use USB...   \n",
       "10  405-3319950-0533926          Mobile Prepaid Recharge; Recharge Again;    \n",
       "11  405-5416197-2397960  RiaTech 2 Pack (290mm x 240mm x 2mm) Mouse Pad...   \n",
       "12  405-5418433-1773156  MTT Designer Pattern Printed Soft Jelly Back c...   \n",
       "13  405-2704243-0424331  Happilo Premium Californian Roasted & Salted P...   \n",
       "14  405-1687112-2865951          Mobile Prepaid Recharge; Recharge Again;    \n",
       "15  405-3624305-1269168                        Amazon Pay balance: Money;    \n",
       "16  405-8765460-7178760       Electricity bill payment; Pay Another Bill;    \n",
       "17  405-3653656-3354736       Electricity bill payment; Pay Another Bill;    \n",
       "18  405-6338929-6177908                        Amazon Pay balance: Money;    \n",
       "19  405-1558231-8669929       Electricity bill payment; Pay Another Bill;    \n",
       "20  405-7749663-6305152          Mobile Prepaid Recharge; Recharge Again;    \n",
       "21  405-8034669-2665163          Mobile Prepaid Recharge; Recharge Again;    \n",
       "22  405-0262912-6651577                        Amazon Pay balance: Money;    \n",
       "23  405-2557853-3225134  SLOVIC Premium Resistance Band/Tubes with Foam...   \n",
       "24  408-8762498-8158757            Amazon Pay balance: Money (Cash-load);    \n",
       "25  405-6678336-7939555  Mivi ThunderBeats Bluetooth Earphones Wireless...   \n",
       "26  405-3466032-7690750  Head & Shoulders 2-in-1 Cool Menthol Anti Dand...   \n",
       "27  405-4199925-1997962  Neuherbs Green Coffee Beans powder For Weight ...   \n",
       "28  405-3242053-3508358  CLAW Shoot Bluetooth Mobile Gamepad Controller...   \n",
       "29  405-5960454-1305915  Noise ColorFit Pro 3 Smart Watch with 1.55\" HD...   \n",
       "30  408-2078289-8142761            Amazon Pay balance: Money (Cash-load);    \n",
       "31  405-5528265-6595514  Gadget Deals 5W - USB Light Emergencey use USB...   \n",
       "32  405-5394347-8821920      Myprotein Impact Whey Isolate, Mango, 500gm;    \n",
       "33  405-8576024-3514741  amiciVision Metal LED Torch Flashlight XML T6 ...   \n",
       "34  405-5706951-6205969  BVB mart 46 in 1 Pcs Tool Kit & Screwdriver an...   \n",
       "35  405-8623079-6509966  Panasonic eneloop BQ-CC61N Portable Charger wi...   \n",
       "36  405-0391270-2368329  Mtt Designer Pattern Printed Soft Jelly Back C...   \n",
       "37  405-7122023-0730725                        Amazon Pay balance: Money;    \n",
       "38  405-4770625-7145915                        Amazon Pay balance: Money;    \n",
       "39  408-8986572-2209160  MTT Designer Pattern Printed Soft Jelly Back c...   \n",
       "\n",
       "    CoustomerName   OrderDate   AmountPaid ShippingCharges  \\\n",
       "0   SAYANDIP JANA  2021-12-17    Rs.665.00       Rs. 40.00   \n",
       "1               0  2021-12-05            0               0   \n",
       "2   SAYANDIP JANA  2021-11-30    Rs.749.00       Rs. 40.00   \n",
       "3   SAYANDIP JANA  2021-11-11    Rs.168.00       Rs. 45.00   \n",
       "4   SAYANDIP JANA  2021-11-11    Rs.260.00        Rs. 0.00   \n",
       "5   SAYANDIP JANA  2021-11-05    Rs.719.00       Rs. 80.00   \n",
       "6   SAYANDIP JANA  2021-09-25  Rs.1,799.00       Rs. 40.00   \n",
       "7               0  2021-07-10            0               0   \n",
       "8   SAYANDIP JANA  2021-07-04    Rs.999.00        Rs. 0.00   \n",
       "9   SAYANDIP JANA  2021-07-04      Rs.0.00        Rs. 0.00   \n",
       "10              0  2021-04-18            0               0   \n",
       "11  SAYANDIP JANA  2021-04-13    Rs.658.00        Rs. 0.00   \n",
       "12  SAYANDIP JANA  2021-04-12    Rs.199.00        Rs. 0.00   \n",
       "13  SAYANDIP JANA  2021-04-07    Rs.613.00        Rs. 0.00   \n",
       "14              0  2021-04-07            0               0   \n",
       "15              0  2021-04-07            0               0   \n",
       "16              0  2021-04-06            0               0   \n",
       "17              0  2021-03-29            0               0   \n",
       "18              0  2021-03-27            0               0   \n",
       "19              0  2021-03-27            0               0   \n",
       "20              0  2021-03-27            0               0   \n",
       "21              0  2021-03-27            0               0   \n",
       "22              0  2021-03-24            0               0   \n",
       "23  SAYANDIP JANA  2021-03-19  Rs.1,999.00       Rs. 40.00   \n",
       "24              0  2021-02-25            0               0   \n",
       "25  SAYANDIP JANA  2021-02-23  Rs.1,199.00       Rs. 40.00   \n",
       "26  SAYANDIP JANA  2021-02-23    Rs.730.00       Rs. 80.00   \n",
       "27  SAYANDIP JANA  2021-02-15    Rs.389.00       Rs. 40.00   \n",
       "28  SAYANDIP JANA  2021-02-11  Rs.1,790.00        Rs. 0.00   \n",
       "29  SAYANDIP JANA  2021-02-10  Rs.3,999.00       Rs. 40.00   \n",
       "30              0  2021-07-01            0               0   \n",
       "31  SAYANDIP JANA  2021-06-29    Rs.269.00        Rs. 0.00   \n",
       "32  SAYANDIP JANA  2021-06-26  Rs.1,300.00       Rs. 40.00   \n",
       "33  SAYANDIP JANA  2021-06-21  Rs.1,199.00       Rs. 40.00   \n",
       "34  SAYANDIP JANA  2021-06-21    Rs.999.00        Rs. 0.00   \n",
       "35  SAYANDIP JANA  2021-05-08    Rs.680.00       Rs. 40.00   \n",
       "36  SAYANDIP JANA  2021-04-27    Rs.239.00       Rs. 40.00   \n",
       "37              0  2021-04-20            0               0   \n",
       "38              0  2021-04-20            0               0   \n",
       "39  SAYANDIP JANA  2021-04-18      Rs.0.00        Rs. 0.00   \n",
       "\n",
       "   RefundOnShippingCharges Gift Vat   TotalRefund PaymentsMethod  \n",
       "0                        0    0   0             0      UNKNOWN;   \n",
       "1                        0    0   0             0      UNKNOWN;   \n",
       "2                        0    0   0             0      UNKNOWN;   \n",
       "3                        0    0   0             0      UNKNOWN;   \n",
       "4                        0    0   0             0      UNKNOWN;   \n",
       "5                        0    0   0             0      UNKNOWN;   \n",
       "6                        0    0   0             0      UNKNOWN;   \n",
       "7                        0    0   0             0      UNKNOWN;   \n",
       "8                        0    0   0             0      UNKNOWN;   \n",
       "9                        0    0   0             0      UNKNOWN;   \n",
       "10                       0    0   0             0      UNKNOWN;   \n",
       "11                       0    0   0             0      UNKNOWN;   \n",
       "12                       0    0   0    Rs. 199.00      UNKNOWN;   \n",
       "13                       0    0   0             0      UNKNOWN;   \n",
       "14                       0    0   0             0      UNKNOWN;   \n",
       "15                       0    0   0             0      UNKNOWN;   \n",
       "16                       0    0   0             0      UNKNOWN;   \n",
       "17                       0    0   0             0      UNKNOWN;   \n",
       "18                       0    0   0             0      UNKNOWN;   \n",
       "19                       0    0   0             0      UNKNOWN;   \n",
       "20                       0    0   0             0      UNKNOWN;   \n",
       "21                       0    0   0             0      UNKNOWN;   \n",
       "22                       0    0   0             0      UNKNOWN;   \n",
       "23                       0    0   0             0      UNKNOWN;   \n",
       "24                       0    0   0             0      UNKNOWN;   \n",
       "25                       0    0   0  Rs. 1,199.00      UNKNOWN;   \n",
       "26                       0    0   0             0      UNKNOWN;   \n",
       "27                       0    0   0             0      UNKNOWN;   \n",
       "28                       0    0   0             0      UNKNOWN;   \n",
       "29                       0    0   0             0      UNKNOWN;   \n",
       "30                       0    0   0             0      UNKNOWN;   \n",
       "31                       0    0   0             0      UNKNOWN;   \n",
       "32                       0    0   0             0      UNKNOWN;   \n",
       "33                       0    0   0             0      UNKNOWN;   \n",
       "34                       0    0   0             0      UNKNOWN;   \n",
       "35                       0    0   0             0      UNKNOWN;   \n",
       "36                       0    0   0    Rs. 239.00      UNKNOWN;   \n",
       "37                       0    0   0             0      UNKNOWN;   \n",
       "38                       0    0   0             0      UNKNOWN;   \n",
       "39                       0    0   0             0      UNKNOWN;   "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_order[0 : 40]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "amazon_order_details = amazon_order[0 : 40]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>OrderId</th>\n",
       "      <th>PurchasedItems</th>\n",
       "      <th>CoustomerName</th>\n",
       "      <th>OrderDate</th>\n",
       "      <th>AmountPaid</th>\n",
       "      <th>ShippingCharges</th>\n",
       "      <th>RefundOnShippingCharges</th>\n",
       "      <th>Gift</th>\n",
       "      <th>Vat</th>\n",
       "      <th>TotalRefund</th>\n",
       "      <th>PaymentsMethod</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>405-0003762-5437921</td>\n",
       "      <td>NESCAFÉ The Ultimate Coffee Kit - Nescafe Clas...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-12-17</td>\n",
       "      <td>Rs.665.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>408-7891735-2418709</td>\n",
       "      <td>Amazon Pay balance: Money (Cash-load);</td>\n",
       "      <td>0</td>\n",
       "      <td>2021-12-05</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>405-9078959-7873142</td>\n",
       "      <td>Dr Trust USA Gold Standard Blood Glucose Test ...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-11-30</td>\n",
       "      <td>Rs.749.00</td>\n",
       "      <td>Rs. 40.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>405-9733244-4955544</td>\n",
       "      <td>Jik Store Back-Flow Monk Ganesh Incense Burner...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-11-11</td>\n",
       "      <td>Rs.168.00</td>\n",
       "      <td>Rs. 45.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>405-5267364-3897943</td>\n",
       "      <td>BETALA FRAGRANCE backflow incense dhoop cones,...</td>\n",
       "      <td>SAYANDIP JANA</td>\n",
       "      <td>2021-11-11</td>\n",
       "      <td>Rs.260.00</td>\n",
       "      <td>Rs. 0.00</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>UNKNOWN;</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               OrderId                                     PurchasedItems  \\\n",
       "0  405-0003762-5437921  NESCAFÉ The Ultimate Coffee Kit - Nescafe Clas...   \n",
       "1  408-7891735-2418709            Amazon Pay balance: Money (Cash-load);    \n",
       "2  405-9078959-7873142  Dr Trust USA Gold Standard Blood Glucose Test ...   \n",
       "3  405-9733244-4955544  Jik Store Back-Flow Monk Ganesh Incense Burner...   \n",
       "4  405-5267364-3897943  BETALA FRAGRANCE backflow incense dhoop cones,...   \n",
       "\n",
       "   CoustomerName   OrderDate AmountPaid ShippingCharges  \\\n",
       "0  SAYANDIP JANA  2021-12-17  Rs.665.00       Rs. 40.00   \n",
       "1              0  2021-12-05          0               0   \n",
       "2  SAYANDIP JANA  2021-11-30  Rs.749.00       Rs. 40.00   \n",
       "3  SAYANDIP JANA  2021-11-11  Rs.168.00       Rs. 45.00   \n",
       "4  SAYANDIP JANA  2021-11-11  Rs.260.00        Rs. 0.00   \n",
       "\n",
       "  RefundOnShippingCharges Gift Vat TotalRefund PaymentsMethod  \n",
       "0                       0    0   0           0      UNKNOWN;   \n",
       "1                       0    0   0           0      UNKNOWN;   \n",
       "2                       0    0   0           0      UNKNOWN;   \n",
       "3                       0    0   0           0      UNKNOWN;   \n",
       "4                       0    0   0           0      UNKNOWN;   "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_order_details.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-15-d240c867360a>:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\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",
      "  amazon_order_details[\"AmountPaid\"] = amazon_order_details[\"AmountPaid\"].str.replace(\"Rs.\", \"\").str.replace(\",\", \"\")\n"
     ]
    }
   ],
   "source": [
    "amazon_order_details[\"AmountPaid\"] = amazon_order_details[\"AmountPaid\"].str.replace(\"Rs.\", \"\").str.replace(\",\", \"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0      665.0\n",
       "1        0.0\n",
       "2      749.0\n",
       "3      168.0\n",
       "4      260.0\n",
       "5      719.0\n",
       "6     1799.0\n",
       "7        0.0\n",
       "8      999.0\n",
       "9        0.0\n",
       "10       0.0\n",
       "11     658.0\n",
       "12     199.0\n",
       "13     613.0\n",
       "14       0.0\n",
       "15       0.0\n",
       "16       0.0\n",
       "17       0.0\n",
       "18       0.0\n",
       "19       0.0\n",
       "20       0.0\n",
       "21       0.0\n",
       "22       0.0\n",
       "23    1999.0\n",
       "24       0.0\n",
       "25    1199.0\n",
       "26     730.0\n",
       "27     389.0\n",
       "28    1790.0\n",
       "29    3999.0\n",
       "30       0.0\n",
       "31     269.0\n",
       "32    1300.0\n",
       "33    1199.0\n",
       "34     999.0\n",
       "35     680.0\n",
       "36     239.0\n",
       "37       0.0\n",
       "38       0.0\n",
       "39       0.0\n",
       "Name: AmountPaid, dtype: float64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_order_details[\"AmountPaid\"].astype(float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'665.000749.00168.00260.00719.001799.000999.000.000658.00199.00613.000000000001999.0001199.00730.00389.001790.003999.000269.001300.001199.00999.00680.00239.00000.00'"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_order_details[\"AmountPaid\"].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-21-a6e3fa1af6c3>:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\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",
      "  amazon_order_details[\"AmountPaid\"] = amazon_order_details[\"AmountPaid\"].astype(float)\n"
     ]
    }
   ],
   "source": [
    "amazon_order_details[\"AmountPaid\"] = amazon_order_details[\"AmountPaid\"].astype(float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "21621.0"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_order_details[\"AmountPaid\"].sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "540.525"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_order_details[\"AmountPaid\"].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "219.0"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_order_details[\"AmountPaid\"].median()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3999.0"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "amazon_order_details[\"AmountPaid\"].max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}