SBAnalysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Populating the interactive namespace from numpy and matplotlib\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sb\n",
    "import pyodbc\n",
    "import cx_Oracle\n",
    "\n",
    "from lifelines.plotting import plot_lifetimes      # Lifeline package for the Survival Analysis\n",
    "%pylab inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\5029874\\AppData\\Local\\Continuum\\anaconda3\\envs\\trainingenv\\lib\\site-packages\\IPython\\core\\interactiveshell.py:3020: DtypeWarning: Columns (9,10,11,12,15,39,50,61,71,95,106,107,110,125,138,147,148,151,156,163,164,166,167,168,184,185,186,187,188,205,207,210,211,212,213,214,215,217,218,219,220,221,223) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n",
      "C:\\Users\\5029874\\AppData\\Local\\Continuum\\anaconda3\\envs\\trainingenv\\lib\\site-packages\\IPython\\core\\interactiveshell.py:3020: DtypeWarning: Columns (42,43,48,51) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    }
   ],
   "source": [
    "cust_data = pd.read_csv(\"D:\\TBL_TRN_CUSTOMER_DETAILS.csv\")\n",
    "coll_data = pd.read_csv(\"D:\\TBL_TRN_COLLECTION_DETAILS.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import gc"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "gc.collect()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "cust_data = cust_data[['AGMTNO', 'AGMT_DATE', 'PORTFOLIO', 'CHANNEL', 'PAYMENT_TYPE',\n",
    "       'AREA_CODE', 'DEALER_TYPE', 'DEALER_CODE', 'MAINDEALER_CODE',\n",
    "       'EXECUTIVE_CODE', 'PRODUCT_CODE', 'MODEL_CODE', 'SCHEME_TYPE',\n",
    "       'SCHEME_CODE', 'ADVANCE_EMI_COUNT', 'TENUR', 'ROI', 'EMI',\n",
    "       'PORCESSING_FEE', 'STAMPING_CHARGES', 'ASSET_COST', 'LOAN_AMOUNT',\n",
    "       'DOWN_PAYMENT', 'INITITAL_HIRE', 'LTV', 'AMORT_IRR', 'CUSTOMER_IRR',\n",
    "       'NET_IRR', 'VECHICAL_INSURANCE_AMT', 'SPECIAL_INSURANCE',\n",
    "       'SPECIAL_INSURANCE_FOR', 'SPECIAL_INSURANCE_PRODUCT',\n",
    "       'SPECIAL_INSURANCE_AMOUNT', 'GENDER', 'PANNO', 'DRIVING_LICENSE',\n",
    "       'PASSPORT', 'AADHAR', 'RATION', 'EXISTING_CUSTOMER', 'EMPLOYMENT_TYPE',\n",
    "       'CUSTOMER_PROFILE_CODE', 'RESIDENT_TYPE', 'BANK_ACCOUNT', 'PINCODE',\n",
    "       'CITY', 'STATE', 'TRN_MONTH', 'TRN_YEAR', 'FIN_YEAR',\n",
    "       'ACTUAL_LOAN_AMOUNT', 'PRODUCT_CUST_IRR',\n",
    "       'PRODUCT_AMORT_IRR', 'PRODUCT_TENUR', 'PF_SERVICE_TAX',\n",
    "       'CIBIL_SCORE', 'COBORROWER', 'GUARANTOR', 'RELIGION',\n",
    "       'CIBIL_HIT', 'CIBIL_OVERDUE', 'CIBIL_SCORE_COBORROWER',\n",
    "       'CIBIL_SCORE_GURANTOR', 'LAST_EMI_DATE','FIRST_EMI_DATE', 'STATUS', 'ADDRESS_TYPE',\n",
    "       'ADDRESS_SLNO', 'SUB_STATUS', 'DOB','APP_SCORE_DESC']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>AGMTNO</th>\n",
       "      <th>AGMT_DATE</th>\n",
       "      <th>PORTFOLIO</th>\n",
       "      <th>CHANNEL</th>\n",
       "      <th>PAYMENT_TYPE</th>\n",
       "      <th>AREA_CODE</th>\n",
       "      <th>DEALER_TYPE</th>\n",
       "      <th>DEALER_CODE</th>\n",
       "      <th>MAINDEALER_CODE</th>\n",
       "      <th>EXECUTIVE_CODE</th>\n",
       "      <th>...</th>\n",
       "      <th>CIBIL_SCORE_COBORROWER</th>\n",
       "      <th>CIBIL_SCORE_GURANTOR</th>\n",
       "      <th>LAST_EMI_DATE</th>\n",
       "      <th>FIRST_EMI_DATE</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>ADDRESS_TYPE</th>\n",
       "      <th>ADDRESS_SLNO</th>\n",
       "      <th>SUB_STATUS</th>\n",
       "      <th>DOB</th>\n",
       "      <th>APP_SCORE_DESC</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>TN3000TW0039449</td>\n",
       "      <td>2016-01-02</td>\n",
       "      <td>TW</td>\n",
       "      <td>ECF</td>\n",
       "      <td>ECS</td>\n",
       "      <td>3000</td>\n",
       "      <td>DEALER</td>\n",
       "      <td>1001</td>\n",
       "      <td>1001</td>\n",
       "      <td>5008949</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2016-11-07</td>\n",
       "      <td>2016-02-07</td>\n",
       "      <td>M</td>\n",
       "      <td>RS</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1990-03-01</td>\n",
       "      <td>LOW RISK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>GJ3031TW10471</td>\n",
       "      <td>2015-06-19</td>\n",
       "      <td>TW</td>\n",
       "      <td>ECF</td>\n",
       "      <td>ELC</td>\n",
       "      <td>3031</td>\n",
       "      <td>DEALER</td>\n",
       "      <td>1774</td>\n",
       "      <td>1774</td>\n",
       "      <td>5009503</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2016-07-07</td>\n",
       "      <td>2015-08-07</td>\n",
       "      <td>M</td>\n",
       "      <td>RS</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1978-06-12</td>\n",
       "      <td>LOW RISK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>GJ3031TW0012554</td>\n",
       "      <td>2015-12-04</td>\n",
       "      <td>TW</td>\n",
       "      <td>ECF</td>\n",
       "      <td>ELC</td>\n",
       "      <td>3031</td>\n",
       "      <td>DEALER</td>\n",
       "      <td>3008</td>\n",
       "      <td>3008</td>\n",
       "      <td>5012511</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2016-12-07</td>\n",
       "      <td>2016-01-07</td>\n",
       "      <td>M</td>\n",
       "      <td>RS</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1977-05-09</td>\n",
       "      <td>LOW RISK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>GJ3031TW10521</td>\n",
       "      <td>2015-06-23</td>\n",
       "      <td>TW</td>\n",
       "      <td>ECF</td>\n",
       "      <td>ELC</td>\n",
       "      <td>3031</td>\n",
       "      <td>DEALER</td>\n",
       "      <td>1774</td>\n",
       "      <td>1774</td>\n",
       "      <td>5009503</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2016-07-07</td>\n",
       "      <td>2015-08-07</td>\n",
       "      <td>M</td>\n",
       "      <td>RO</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1978-12-31</td>\n",
       "      <td>MEDIUM RISK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>TN3000TW0039724</td>\n",
       "      <td>2016-01-11</td>\n",
       "      <td>TW</td>\n",
       "      <td>ECF</td>\n",
       "      <td>ELC</td>\n",
       "      <td>3000</td>\n",
       "      <td>DEALER</td>\n",
       "      <td>1001</td>\n",
       "      <td>1001</td>\n",
       "      <td>5008949</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2018-07-07</td>\n",
       "      <td>2016-02-07</td>\n",
       "      <td>M</td>\n",
       "      <td>RS</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1993-06-13</td>\n",
       "      <td>MEDIUM RISK</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 71 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            AGMTNO   AGMT_DATE PORTFOLIO CHANNEL PAYMENT_TYPE  AREA_CODE  \\\n",
       "0  TN3000TW0039449  2016-01-02        TW     ECF          ECS       3000   \n",
       "1    GJ3031TW10471  2015-06-19        TW     ECF          ELC       3031   \n",
       "2  GJ3031TW0012554  2015-12-04        TW     ECF          ELC       3031   \n",
       "3    GJ3031TW10521  2015-06-23        TW     ECF          ELC       3031   \n",
       "4  TN3000TW0039724  2016-01-11        TW     ECF          ELC       3000   \n",
       "\n",
       "  DEALER_TYPE DEALER_CODE MAINDEALER_CODE EXECUTIVE_CODE       ...        \\\n",
       "0      DEALER        1001            1001        5008949       ...         \n",
       "1      DEALER        1774            1774        5009503       ...         \n",
       "2      DEALER        3008            3008        5012511       ...         \n",
       "3      DEALER        1774            1774        5009503       ...         \n",
       "4      DEALER        1001            1001        5008949       ...         \n",
       "\n",
       "  CIBIL_SCORE_COBORROWER CIBIL_SCORE_GURANTOR LAST_EMI_DATE FIRST_EMI_DATE  \\\n",
       "0                    NaN                  0.0    2016-11-07     2016-02-07   \n",
       "1                    NaN                  0.0    2016-07-07     2015-08-07   \n",
       "2                    NaN                  0.0    2016-12-07     2016-01-07   \n",
       "3                    NaN                  0.0    2016-07-07     2015-08-07   \n",
       "4                    NaN                  0.0    2018-07-07     2016-02-07   \n",
       "\n",
       "   STATUS  ADDRESS_TYPE  ADDRESS_SLNO  SUB_STATUS         DOB  APP_SCORE_DESC  \n",
       "0       M            RS             1         NaN  1990-03-01        LOW RISK  \n",
       "1       M            RS             1         NaN  1978-06-12        LOW RISK  \n",
       "2       M            RS             1         NaN  1977-05-09        LOW RISK  \n",
       "3       M            RO             1         NaN  1978-12-31     MEDIUM RISK  \n",
       "4       M            RS             1         NaN  1993-06-13     MEDIUM RISK  \n",
       "\n",
       "[5 rows x 71 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#cust_data.info(max_cols=300)\n",
    "cust_data.head()"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "for i in cust_data.columns:\n",
    "    #if data[i].isnull().sum() != 0:\n",
    "    print(\"column {} has ---unique----> {} ---null----> {} \".format(i,cust_data[i].unique().size, cust_data[i].isnull().sum()))"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "cust_data.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "cust_data['AGMT_DATE'] = cust_data['AGMT_DATE'].apply(lambda x: datetime.datetime.strptime(x, \"%Y-%m-%d\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "def Mark_DOB(row):\n",
    "    if isinstance(row['DOB'], str):\n",
    "        return datetime.datetime.strptime(row['DOB'], \"%Y-%m-%d\")\n",
    "    else:\n",
    "        return row['AGMT_DATE']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "cust_data['DOB'] = cust_data.apply(Mark_DOB, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "from dateutil.relativedelta import relativedelta"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_age(row):\n",
    "    return relativedelta(row['AGMT_DATE'],  row['DOB']).years"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "cust_data['AGE'] = cust_data.apply(get_age, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "cust_data = cust_data[cust_data.FIRST_EMI_DATE.notnull()]\n",
    "cust_data = cust_data[cust_data.LAST_EMI_DATE.notnull()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "cust_data['LAST_EMI_DATE'] = cust_data['LAST_EMI_DATE'].apply(lambda x: datetime.datetime.strptime(x, \"%Y-%m-%d\"))\n",
    "cust_data['FIRST_EMI_DATE'] = cust_data['FIRST_EMI_DATE'].apply(lambda x: datetime.datetime.strptime(x, \"%Y-%m-%d\"))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_duration(row):\n",
    "    return relativedelta(row['LAST_EMI_DATE'], row['FIRST_EMI_DATE']).months"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "cust_data['LOAN_DURATION'] = cust_data.apply(get_duration, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "cust_data = cust_data[['AGMTNO', 'AGMT_DATE', 'PORTFOLIO', 'CHANNEL', 'PAYMENT_TYPE',\n",
    "       'AREA_CODE', 'DEALER_TYPE', 'DEALER_CODE', 'MAINDEALER_CODE',\n",
    "       'EXECUTIVE_CODE', 'PRODUCT_CODE', 'MODEL_CODE', 'SCHEME_TYPE',\n",
    "       'SCHEME_CODE', 'ADVANCE_EMI_COUNT', 'TENUR', 'ROI', 'EMI',\n",
    "       'PORCESSING_FEE', 'STAMPING_CHARGES', 'ASSET_COST', 'LOAN_AMOUNT',\n",
    "       'DOWN_PAYMENT', 'INITITAL_HIRE', 'LTV', 'AMORT_IRR', 'CUSTOMER_IRR',\n",
    "       'NET_IRR', 'VECHICAL_INSURANCE_AMT', 'SPECIAL_INSURANCE',\n",
    "       'SPECIAL_INSURANCE_FOR', 'SPECIAL_INSURANCE_PRODUCT',\n",
    "       'SPECIAL_INSURANCE_AMOUNT', 'GENDER', 'PANNO', 'DRIVING_LICENSE',\n",
    "       'PASSPORT', 'AADHAR', 'RATION', 'EXISTING_CUSTOMER', 'EMPLOYMENT_TYPE',\n",
    "       'CUSTOMER_PROFILE_CODE', 'RESIDENT_TYPE', 'BANK_ACCOUNT', 'PINCODE',\n",
    "       'CITY', 'STATE', 'TRN_MONTH', 'TRN_YEAR', 'FIN_YEAR',\n",
    "       'ACTUAL_LOAN_AMOUNT', 'PRODUCT_CUST_IRR',\n",
    "       'PRODUCT_AMORT_IRR', 'PRODUCT_TENUR', 'PF_SERVICE_TAX',\n",
    "       'CIBIL_SCORE', 'COBORROWER', 'GUARANTOR', 'RELIGION',\n",
    "       'CIBIL_HIT', 'CIBIL_OVERDUE', 'CIBIL_SCORE_COBORROWER',\n",
    "       'CIBIL_SCORE_GURANTOR', 'LOAN_DURATION', 'STATUS', 'ADDRESS_TYPE',\n",
    "       'ADDRESS_SLNO', 'SUB_STATUS', 'AGE', 'APP_SCORE_DESC']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "cust_data = cust_data[cust_data.CHANNEL.notnull()]\n",
    "cust_data = cust_data[cust_data.DOWN_PAYMENT.notnull()]\n",
    "cust_data = cust_data[cust_data.ROI.notnull()]\n",
    "cust_data = cust_data[cust_data.GENDER.notnull()]\n",
    "cust_data = cust_data[cust_data.EMPLOYMENT_TYPE.notnull()]\n",
    "cust_data = cust_data[cust_data.CUSTOMER_PROFILE_CODE.notnull()]\n",
    "cust_data = cust_data[cust_data.CITY.notnull()]\n",
    "cust_data = cust_data[cust_data.RELIGION.notnull()]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "cust_data['VECHICAL_INSURANCE_AMT'].fillna(0, inplace=True)\n",
    "cust_data['SPECIAL_INSURANCE_FOR'].fillna('N/A', inplace=True)\n",
    "cust_data['SPECIAL_INSURANCE_PRODUCT'].fillna('N/A', inplace=True)\n",
    "cust_data['SPECIAL_INSURANCE_AMOUNT'].fillna(0, inplace=True)\n",
    "cust_data['EXISTING_CUSTOMER'].fillna('N/A', inplace=True)\n",
    "cust_data['RESIDENT_TYPE'].fillna('N/A', inplace=True)\n",
    "cust_data['CIBIL_SCORE'].fillna(0, inplace=True)\n",
    "cust_data['CIBIL_HIT'].fillna('N/A', inplace=True)\n",
    "cust_data['CIBIL_SCORE_COBORROWER'].fillna(0, inplace=True)\n",
    "cust_data['CIBIL_SCORE_GURANTOR'].fillna(0, inplace=True)\n",
    "cust_data['SUB_STATUS'].fillna('L', inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "cust_data = cust_data.dropna()"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "cust_data[['TENUR','AGMTNO']].groupby(['TENUR']).count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [],
   "source": [
    "def age_bin(row):\n",
    "    if row['AGE'] <= 25:\n",
    "        return 1\n",
    "    elif row['AGE'] > 25 & row['AGE'] <= 35:\n",
    "        return 2\n",
    "    elif row['AGE'] > 35 & row['AGE'] <= 45:\n",
    "        return 3\n",
    "    elif row['AGE'] > 45 & row['AGE'] <= 55:\n",
    "        return 4\n",
    "    else:\n",
    "        return 5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "cust_data['AGE_BIN'] = cust_data.apply(age_bin, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "coll_data = coll_data[['AGMTNO', 'MOB', 'STATUS']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "coll_data = coll_data[coll_data['AGMTNO'].str.contains(\"TW\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "coll_data = coll_data.groupby(['AGMTNO'], sort=False)['MOB'].max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "coll_data = pd.DataFrame({'AGMTNO':coll_data.index, 'MOB':coll_data.values})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [],
   "source": [
    "Final_data = pd.merge(cust_data, coll_data, on='AGMTNO', how='left')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "Final_data[\"MOB\"] = Final_data[\"MOB\"].fillna(0.0).astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "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>AGMTNO</th>\n",
       "      <th>AGMT_DATE</th>\n",
       "      <th>PORTFOLIO</th>\n",
       "      <th>CHANNEL</th>\n",
       "      <th>PAYMENT_TYPE</th>\n",
       "      <th>AREA_CODE</th>\n",
       "      <th>DEALER_TYPE</th>\n",
       "      <th>DEALER_CODE</th>\n",
       "      <th>MAINDEALER_CODE</th>\n",
       "      <th>EXECUTIVE_CODE</th>\n",
       "      <th>...</th>\n",
       "      <th>CIBIL_SCORE_GURANTOR</th>\n",
       "      <th>LOAN_DURATION</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>ADDRESS_TYPE</th>\n",
       "      <th>ADDRESS_SLNO</th>\n",
       "      <th>SUB_STATUS</th>\n",
       "      <th>AGE</th>\n",
       "      <th>APP_SCORE_DESC</th>\n",
       "      <th>MOB</th>\n",
       "      <th>Target</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>TN3000TW0039449</td>\n",
       "      <td>2016-01-02</td>\n",
       "      <td>TW</td>\n",
       "      <td>ECF</td>\n",
       "      <td>ECS</td>\n",
       "      <td>3000</td>\n",
       "      <td>DEALER</td>\n",
       "      <td>1001</td>\n",
       "      <td>1001</td>\n",
       "      <td>5008949</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9</td>\n",
       "      <td>M</td>\n",
       "      <td>RS</td>\n",
       "      <td>1</td>\n",
       "      <td>L</td>\n",
       "      <td>25</td>\n",
       "      <td>LOW RISK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>GJ3031TW10471</td>\n",
       "      <td>2015-06-19</td>\n",
       "      <td>TW</td>\n",
       "      <td>ECF</td>\n",
       "      <td>ELC</td>\n",
       "      <td>3031</td>\n",
       "      <td>DEALER</td>\n",
       "      <td>1774</td>\n",
       "      <td>1774</td>\n",
       "      <td>5009503</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>M</td>\n",
       "      <td>RS</td>\n",
       "      <td>1</td>\n",
       "      <td>L</td>\n",
       "      <td>37</td>\n",
       "      <td>LOW RISK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>GJ3031TW0012554</td>\n",
       "      <td>2015-12-04</td>\n",
       "      <td>TW</td>\n",
       "      <td>ECF</td>\n",
       "      <td>ELC</td>\n",
       "      <td>3031</td>\n",
       "      <td>DEALER</td>\n",
       "      <td>3008</td>\n",
       "      <td>3008</td>\n",
       "      <td>5012511</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>M</td>\n",
       "      <td>RS</td>\n",
       "      <td>1</td>\n",
       "      <td>L</td>\n",
       "      <td>38</td>\n",
       "      <td>LOW RISK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>GJ3031TW10521</td>\n",
       "      <td>2015-06-23</td>\n",
       "      <td>TW</td>\n",
       "      <td>ECF</td>\n",
       "      <td>ELC</td>\n",
       "      <td>3031</td>\n",
       "      <td>DEALER</td>\n",
       "      <td>1774</td>\n",
       "      <td>1774</td>\n",
       "      <td>5009503</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>M</td>\n",
       "      <td>RO</td>\n",
       "      <td>1</td>\n",
       "      <td>L</td>\n",
       "      <td>36</td>\n",
       "      <td>MEDIUM RISK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>TN3000TW0039724</td>\n",
       "      <td>2016-01-11</td>\n",
       "      <td>TW</td>\n",
       "      <td>ECF</td>\n",
       "      <td>ELC</td>\n",
       "      <td>3000</td>\n",
       "      <td>DEALER</td>\n",
       "      <td>1001</td>\n",
       "      <td>1001</td>\n",
       "      <td>5008949</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>M</td>\n",
       "      <td>RS</td>\n",
       "      <td>1</td>\n",
       "      <td>L</td>\n",
       "      <td>22</td>\n",
       "      <td>MEDIUM RISK</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 72 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            AGMTNO  AGMT_DATE PORTFOLIO CHANNEL PAYMENT_TYPE  AREA_CODE  \\\n",
       "0  TN3000TW0039449 2016-01-02        TW     ECF          ECS       3000   \n",
       "1    GJ3031TW10471 2015-06-19        TW     ECF          ELC       3031   \n",
       "2  GJ3031TW0012554 2015-12-04        TW     ECF          ELC       3031   \n",
       "3    GJ3031TW10521 2015-06-23        TW     ECF          ELC       3031   \n",
       "4  TN3000TW0039724 2016-01-11        TW     ECF          ELC       3000   \n",
       "\n",
       "  DEALER_TYPE DEALER_CODE MAINDEALER_CODE EXECUTIVE_CODE   ...    \\\n",
       "0      DEALER        1001            1001        5008949   ...     \n",
       "1      DEALER        1774            1774        5009503   ...     \n",
       "2      DEALER        3008            3008        5012511   ...     \n",
       "3      DEALER        1774            1774        5009503   ...     \n",
       "4      DEALER        1001            1001        5008949   ...     \n",
       "\n",
       "  CIBIL_SCORE_GURANTOR LOAN_DURATION STATUS ADDRESS_TYPE  ADDRESS_SLNO  \\\n",
       "0                  0.0             9      M           RS             1   \n",
       "1                  0.0            11      M           RS             1   \n",
       "2                  0.0            11      M           RS             1   \n",
       "3                  0.0            11      M           RO             1   \n",
       "4                  0.0             5      M           RS             1   \n",
       "\n",
       "   SUB_STATUS  AGE  APP_SCORE_DESC  MOB  Target  \n",
       "0           L   25        LOW RISK    0       0  \n",
       "1           L   37        LOW RISK    0       0  \n",
       "2           L   38        LOW RISK    0       0  \n",
       "3           L   36     MEDIUM RISK    0       0  \n",
       "4           L   22     MEDIUM RISK    0       0  \n",
       "\n",
       "[5 rows x 72 columns]"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Final_data.head()"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "Final_data.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [],
   "source": [
    "def mark_target(row):\n",
    "    if row['MOB'] == 0:\n",
    "        return 0\n",
    "    else:\n",
    "        return 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "Final_data['Target'] = Final_data.apply(mark_target, axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "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>Target</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>APP_SCORE_DESC</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>HIGH RISK</th>\n",
       "      <td>26671</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>LOW RISK</th>\n",
       "      <td>134321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>MEDIUM RISK</th>\n",
       "      <td>179795</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Target\n",
       "APP_SCORE_DESC        \n",
       "HIGH RISK        26671\n",
       "LOW RISK        134321\n",
       "MEDIUM RISK     179795"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Final_data[['APP_SCORE_DESC','Target']].loc[(Final_data['Target'] == 1)].groupby(['APP_SCORE_DESC']).count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "Final_data.to_csv(\"D:\\cust_coll_data.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Timestamp('2014-08-01 00:00:00')"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Final_data.AGMT_DATE.min()\n",
    "# 2010> 2345717"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.metrics.pairwise import cosine_similarity"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [],
   "source": [
    "from scipy import spatial"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "-0.5"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#cosine_similarity([1, 0, -1], [-1,-1, 0])\n",
    "1 - spatial.distance.cosine(X_Norm_avg, [-1,-1, 0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [],
   "source": [
    "Final_train = Final_data.loc[Final_data['AGMT_DATE'] < datetime.datetime.strptime(\"2018-01-01\", \"%Y-%m-%d\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [],
   "source": [
    "Final_train = Final_train.drop(['APP_SCORE_DESC'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [],
   "source": [
    "Final_train = Final_train.drop(['AGMT_DATE'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [],
   "source": [
    "Final_train = Final_train.drop(['AGMTNO'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [],
   "source": [
    "Final_train = Final_train.drop(['PORTFOLIO'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [],
   "source": [
    "Final_test = Final_data.loc[Final_data['AGMT_DATE'] >= datetime.datetime.strptime(\"2018-01-01\", \"%Y-%m-%d\")]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [],
   "source": [
    "Final_test = Final_test.drop(['APP_SCORE_DESC'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [],
   "source": [
    "Final_test = Final_test.drop(['AGMT_DATE'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "metadata": {},
   "outputs": [],
   "source": [
    "Final_test = Final_test.drop(['AGMTNO'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "Final_test = Final_test.drop(['PORTFOLIO'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "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>sum</th>\n",
       "      <th>count</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cluster_no</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>29844</td>\n",
       "      <td>140039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>104693</td>\n",
       "      <td>523464</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>61998</td>\n",
       "      <td>263859</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>95637</td>\n",
       "      <td>481572</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>31209</td>\n",
       "      <td>248167</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               sum   count\n",
       "cluster_no                \n",
       "0            29844  140039\n",
       "1           104693  523464\n",
       "2            61998  263859\n",
       "3            95637  481572\n",
       "4            31209  248167"
      ]
     },
     "execution_count": 147,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Final_train[['cluster_no', 'Target']].groupby(['cluster_no'])['Target'].agg(['sum','count']) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 180,
   "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>AGMTNO</th>\n",
       "      <th>CHANNEL</th>\n",
       "      <th>PAYMENT_TYPE</th>\n",
       "      <th>AREA_CODE</th>\n",
       "      <th>DEALER_TYPE</th>\n",
       "      <th>DEALER_CODE</th>\n",
       "      <th>MAINDEALER_CODE</th>\n",
       "      <th>EXECUTIVE_CODE</th>\n",
       "      <th>PRODUCT_CODE</th>\n",
       "      <th>MODEL_CODE</th>\n",
       "      <th>...</th>\n",
       "      <th>CIBIL_SCORE_GURANTOR</th>\n",
       "      <th>LOAN_DURATION</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>ADDRESS_TYPE</th>\n",
       "      <th>ADDRESS_SLNO</th>\n",
       "      <th>SUB_STATUS</th>\n",
       "      <th>AGE</th>\n",
       "      <th>MOB</th>\n",
       "      <th>Target</th>\n",
       "      <th>cluster_no</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>35086</th>\n",
       "      <td>PB3089TW0002724</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3089</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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35151</th>\n",
       "      <td>MH3028TW0041575</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3028</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53806</th>\n",
       "      <td>PB3050TW0009195</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3050</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70445</th>\n",
       "      <td>UP3033TW0022251</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3033</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>41</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75697</th>\n",
       "      <td>AP3042TW0073412</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3042</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92237</th>\n",
       "      <td>MH3061TW0016319</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3061</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101451</th>\n",
       "      <td>AP3019TW0074854</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3019</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101452</th>\n",
       "      <td>MH3061TW0016838</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3061</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112873</th>\n",
       "      <td>UP3033TW0023517</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3033</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>66</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119430</th>\n",
       "      <td>JH3053TW0036101</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3053</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>26</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119465</th>\n",
       "      <td>BR3058TW0096288</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3058</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>49</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143914</th>\n",
       "      <td>KA3009TW0133064</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3009</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143915</th>\n",
       "      <td>KA3009TW0132548</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3009</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150017</th>\n",
       "      <td>KA3009TW0131907</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3009</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150019</th>\n",
       "      <td>KA3009TW0132024</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3009</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>14</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>62</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150804</th>\n",
       "      <td>KA3009TW0154335</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3009</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150806</th>\n",
       "      <td>AP3042TW0077554</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3042</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153566</th>\n",
       "      <td>MP3014TW0042111</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3014</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160102</th>\n",
       "      <td>RJ3036TW0025766</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3036</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160103</th>\n",
       "      <td>RJ3016TW0026407</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3016</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209414</th>\n",
       "      <td>KA3009TW0133192</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3009</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>56</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215238</th>\n",
       "      <td>TN3007TW0096989</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3007</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>21</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216268</th>\n",
       "      <td>TN3008TW0051090</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3008</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>22</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222343</th>\n",
       "      <td>BR3058TW0062547</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3058</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227489</th>\n",
       "      <td>BR3058TW0059397</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3058</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>34</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227817</th>\n",
       "      <td>KE3023TW0027228</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3023</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>24</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228754</th>\n",
       "      <td>JH3053TW0037093</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3053</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>26</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228808</th>\n",
       "      <td>HP3091TW0004022</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3091</td>\n",
       "      <td>0</td>\n",
       "      <td>26</td>\n",
       "      <td>26</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228809</th>\n",
       "      <td>UP3038TW0037378</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3038</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>54</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235032</th>\n",
       "      <td>AS3072TW0014981</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3072</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>28</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</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>2345687</th>\n",
       "      <td>JH3053TW0054775</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3053</td>\n",
       "      <td>1</td>\n",
       "      <td>426</td>\n",
       "      <td>350</td>\n",
       "      <td>5610</td>\n",
       "      <td>2</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345688</th>\n",
       "      <td>AP3042TW0080117</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3042</td>\n",
       "      <td>1</td>\n",
       "      <td>2160</td>\n",
       "      <td>1300</td>\n",
       "      <td>5076</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345689</th>\n",
       "      <td>UP3035TW0027579</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3035</td>\n",
       "      <td>1</td>\n",
       "      <td>2186</td>\n",
       "      <td>1088</td>\n",
       "      <td>4552</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>53</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345690</th>\n",
       "      <td>PB3046TW0026251</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3046</td>\n",
       "      <td>0</td>\n",
       "      <td>1651</td>\n",
       "      <td>1115</td>\n",
       "      <td>3602</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345691</th>\n",
       "      <td>TN3004TW0086902</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3004</td>\n",
       "      <td>1</td>\n",
       "      <td>2639</td>\n",
       "      <td>1097</td>\n",
       "      <td>4303</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345692</th>\n",
       "      <td>KE3023TW0033261</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3023</td>\n",
       "      <td>0</td>\n",
       "      <td>1668</td>\n",
       "      <td>1680</td>\n",
       "      <td>4273</td>\n",
       "      <td>2</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>47</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345693</th>\n",
       "      <td>UP3064TW0028012</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3064</td>\n",
       "      <td>1</td>\n",
       "      <td>2771</td>\n",
       "      <td>540</td>\n",
       "      <td>5302</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345694</th>\n",
       "      <td>UP3064TW0028026</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3064</td>\n",
       "      <td>1</td>\n",
       "      <td>2496</td>\n",
       "      <td>107</td>\n",
       "      <td>3898</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>44</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345695</th>\n",
       "      <td>UP3064TW0028016</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3064</td>\n",
       "      <td>1</td>\n",
       "      <td>2496</td>\n",
       "      <td>107</td>\n",
       "      <td>3898</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345696</th>\n",
       "      <td>OR3051TW0118049</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3051</td>\n",
       "      <td>0</td>\n",
       "      <td>2113</td>\n",
       "      <td>1112</td>\n",
       "      <td>6001</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345697</th>\n",
       "      <td>OR3051TW0118007</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3051</td>\n",
       "      <td>0</td>\n",
       "      <td>2113</td>\n",
       "      <td>1112</td>\n",
       "      <td>6001</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345698</th>\n",
       "      <td>OR3051TW0117978</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3051</td>\n",
       "      <td>1</td>\n",
       "      <td>3379</td>\n",
       "      <td>1402</td>\n",
       "      <td>6019</td>\n",
       "      <td>2</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>49</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345699</th>\n",
       "      <td>OR3051TW0118005</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3051</td>\n",
       "      <td>1</td>\n",
       "      <td>2071</td>\n",
       "      <td>340</td>\n",
       "      <td>5585</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345700</th>\n",
       "      <td>OR3051TW0118517</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3051</td>\n",
       "      <td>1</td>\n",
       "      <td>6915</td>\n",
       "      <td>340</td>\n",
       "      <td>7081</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345701</th>\n",
       "      <td>OR3051TW0118502</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3051</td>\n",
       "      <td>1</td>\n",
       "      <td>1361</td>\n",
       "      <td>1402</td>\n",
       "      <td>4432</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345702</th>\n",
       "      <td>UP3065TW0026762</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3065</td>\n",
       "      <td>1</td>\n",
       "      <td>79</td>\n",
       "      <td>75</td>\n",
       "      <td>3067</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345703</th>\n",
       "      <td>OR3051TW0118336</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3051</td>\n",
       "      <td>1</td>\n",
       "      <td>6915</td>\n",
       "      <td>340</td>\n",
       "      <td>7081</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345704</th>\n",
       "      <td>OR3051TW0118491</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3051</td>\n",
       "      <td>1</td>\n",
       "      <td>260</td>\n",
       "      <td>340</td>\n",
       "      <td>3340</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345705</th>\n",
       "      <td>OR3051TW0118460</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3051</td>\n",
       "      <td>0</td>\n",
       "      <td>2520</td>\n",
       "      <td>1515</td>\n",
       "      <td>3627</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345706</th>\n",
       "      <td>UP3065TW0026700</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3065</td>\n",
       "      <td>1</td>\n",
       "      <td>262</td>\n",
       "      <td>121</td>\n",
       "      <td>3515</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345707</th>\n",
       "      <td>BR3058TW0105219</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3058</td>\n",
       "      <td>0</td>\n",
       "      <td>4654</td>\n",
       "      <td>1729</td>\n",
       "      <td>3670</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345708</th>\n",
       "      <td>GO3086TW0002473</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3086</td>\n",
       "      <td>0</td>\n",
       "      <td>1365</td>\n",
       "      <td>916</td>\n",
       "      <td>3227</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345709</th>\n",
       "      <td>GJ3032TW0007479</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3032</td>\n",
       "      <td>0</td>\n",
       "      <td>522</td>\n",
       "      <td>428</td>\n",
       "      <td>3419</td>\n",
       "      <td>2</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345710</th>\n",
       "      <td>BR3058TW0105380</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3058</td>\n",
       "      <td>0</td>\n",
       "      <td>4059</td>\n",
       "      <td>1613</td>\n",
       "      <td>4386</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345711</th>\n",
       "      <td>TR3087TW0003455</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3087</td>\n",
       "      <td>1</td>\n",
       "      <td>1801</td>\n",
       "      <td>366</td>\n",
       "      <td>4172</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345712</th>\n",
       "      <td>TR3087TW0003430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3087</td>\n",
       "      <td>0</td>\n",
       "      <td>440</td>\n",
       "      <td>366</td>\n",
       "      <td>3395</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345713</th>\n",
       "      <td>OR3088TW0029837</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3088</td>\n",
       "      <td>1</td>\n",
       "      <td>2874</td>\n",
       "      <td>60</td>\n",
       "      <td>6757</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345714</th>\n",
       "      <td>TR3087TW0003446</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3087</td>\n",
       "      <td>1</td>\n",
       "      <td>2556</td>\n",
       "      <td>366</td>\n",
       "      <td>4337</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>46</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345715</th>\n",
       "      <td>JH3053TW0055998</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3053</td>\n",
       "      <td>0</td>\n",
       "      <td>581</td>\n",
       "      <td>350</td>\n",
       "      <td>3423</td>\n",
       "      <td>2</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345716</th>\n",
       "      <td>JH3053TW0055918</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3053</td>\n",
       "      <td>1</td>\n",
       "      <td>1815</td>\n",
       "      <td>338</td>\n",
       "      <td>3277</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>688616 rows × 70 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  AGMTNO  CHANNEL  PAYMENT_TYPE  AREA_CODE  DEALER_TYPE  \\\n",
       "35086    PB3089TW0002724        0             0       3089            0   \n",
       "35151    MH3028TW0041575        0             1       3028            1   \n",
       "53806    PB3050TW0009195        0             0       3050            0   \n",
       "70445    UP3033TW0022251        0             0       3033            1   \n",
       "75697    AP3042TW0073412        0             1       3042            1   \n",
       "92237    MH3061TW0016319        0             1       3061            0   \n",
       "101451   AP3019TW0074854        0             1       3019            0   \n",
       "101452   MH3061TW0016838        0             1       3061            0   \n",
       "112873   UP3033TW0023517        0             0       3033            1   \n",
       "119430   JH3053TW0036101        0             0       3053            1   \n",
       "119465   BR3058TW0096288        0             2       3058            1   \n",
       "143914   KA3009TW0133064        0             0       3009            0   \n",
       "143915   KA3009TW0132548        0             1       3009            0   \n",
       "150017   KA3009TW0131907        0             0       3009            1   \n",
       "150019   KA3009TW0132024        0             2       3009            0   \n",
       "150804   KA3009TW0154335        0             1       3009            1   \n",
       "150806   AP3042TW0077554        0             2       3042            1   \n",
       "153566   MP3014TW0042111        0             0       3014            1   \n",
       "160102   RJ3036TW0025766        0             0       3036            0   \n",
       "160103   RJ3016TW0026407        0             0       3016            0   \n",
       "209414   KA3009TW0133192        0             2       3009            1   \n",
       "215238   TN3007TW0096989        0             1       3007            1   \n",
       "216268   TN3008TW0051090        0             2       3008            0   \n",
       "222343   BR3058TW0062547        0             0       3058            0   \n",
       "227489   BR3058TW0059397        0             1       3058            1   \n",
       "227817   KE3023TW0027228        0             0       3023            1   \n",
       "228754   JH3053TW0037093        0             0       3053            1   \n",
       "228808   HP3091TW0004022        0             0       3091            0   \n",
       "228809   UP3038TW0037378        0             0       3038            0   \n",
       "235032   AS3072TW0014981        0             1       3072            1   \n",
       "...                  ...      ...           ...        ...          ...   \n",
       "2345687  JH3053TW0054775        0             0       3053            1   \n",
       "2345688  AP3042TW0080117        0             2       3042            1   \n",
       "2345689  UP3035TW0027579        0             0       3035            1   \n",
       "2345690  PB3046TW0026251        0             0       3046            0   \n",
       "2345691  TN3004TW0086902        0             0       3004            1   \n",
       "2345692  KE3023TW0033261        0             0       3023            0   \n",
       "2345693  UP3064TW0028012        0             2       3064            1   \n",
       "2345694  UP3064TW0028026        0             2       3064            1   \n",
       "2345695  UP3064TW0028016        0             0       3064            1   \n",
       "2345696  OR3051TW0118049        0             0       3051            0   \n",
       "2345697  OR3051TW0118007        0             0       3051            0   \n",
       "2345698  OR3051TW0117978        0             0       3051            1   \n",
       "2345699  OR3051TW0118005        0             0       3051            1   \n",
       "2345700  OR3051TW0118517        0             1       3051            1   \n",
       "2345701  OR3051TW0118502        0             0       3051            1   \n",
       "2345702  UP3065TW0026762        0             0       3065            1   \n",
       "2345703  OR3051TW0118336        0             1       3051            1   \n",
       "2345704  OR3051TW0118491        0             0       3051            1   \n",
       "2345705  OR3051TW0118460        0             0       3051            0   \n",
       "2345706  UP3065TW0026700        0             0       3065            1   \n",
       "2345707  BR3058TW0105219        0             0       3058            0   \n",
       "2345708  GO3086TW0002473        0             1       3086            0   \n",
       "2345709  GJ3032TW0007479        0             0       3032            0   \n",
       "2345710  BR3058TW0105380        0             0       3058            0   \n",
       "2345711  TR3087TW0003455        0             0       3087            1   \n",
       "2345712  TR3087TW0003430        0             0       3087            0   \n",
       "2345713  OR3088TW0029837        0             0       3088            1   \n",
       "2345714  TR3087TW0003446        0             0       3087            1   \n",
       "2345715  JH3053TW0055998        0             0       3053            0   \n",
       "2345716  JH3053TW0055918        0             0       3053            1   \n",
       "\n",
       "         DEALER_CODE  MAINDEALER_CODE  EXECUTIVE_CODE  PRODUCT_CODE  \\\n",
       "35086              0                0               0             0   \n",
       "35151              1                1               1             0   \n",
       "53806              2                2               2             1   \n",
       "70445              3                3               3             0   \n",
       "75697              4                4               4             1   \n",
       "92237              5                5               5             1   \n",
       "101451             6                6               6             2   \n",
       "101452             7                7               7             0   \n",
       "112873             8                8               8             0   \n",
       "119430             9                9               9             1   \n",
       "119465            10               10              10             0   \n",
       "143914            11               11              11             0   \n",
       "143915            12               12              12             2   \n",
       "150017            13               13              13             0   \n",
       "150019            12               12              14             2   \n",
       "150804            14               14              15             1   \n",
       "150806            15               15              16             0   \n",
       "153566            16               16              17             0   \n",
       "160102            17               17              18             1   \n",
       "160103            18               18              19             1   \n",
       "209414            19               19              20             0   \n",
       "215238            20               20              21             2   \n",
       "216268            21               21              22             2   \n",
       "222343            22               22              23             0   \n",
       "227489            23               23              24             1   \n",
       "227817            24               24              25             1   \n",
       "228754            25               25              26             2   \n",
       "228808            26               26              27             1   \n",
       "228809            27               27              28             0   \n",
       "235032            28               28              29             0   \n",
       "...              ...              ...             ...           ...   \n",
       "2345687          426              350            5610             2   \n",
       "2345688         2160             1300            5076             1   \n",
       "2345689         2186             1088            4552             2   \n",
       "2345690         1651             1115            3602             1   \n",
       "2345691         2639             1097            4303             0   \n",
       "2345692         1668             1680            4273             2   \n",
       "2345693         2771              540            5302             0   \n",
       "2345694         2496              107            3898             2   \n",
       "2345695         2496              107            3898             0   \n",
       "2345696         2113             1112            6001             1   \n",
       "2345697         2113             1112            6001             1   \n",
       "2345698         3379             1402            6019             2   \n",
       "2345699         2071              340            5585             2   \n",
       "2345700         6915              340            7081             1   \n",
       "2345701         1361             1402            4432             0   \n",
       "2345702           79               75            3067             0   \n",
       "2345703         6915              340            7081             1   \n",
       "2345704          260              340            3340             0   \n",
       "2345705         2520             1515            3627             0   \n",
       "2345706          262              121            3515             0   \n",
       "2345707         4654             1729            3670             2   \n",
       "2345708         1365              916            3227             1   \n",
       "2345709          522              428            3419             2   \n",
       "2345710         4059             1613            4386             0   \n",
       "2345711         1801              366            4172             0   \n",
       "2345712          440              366            3395             1   \n",
       "2345713         2874               60            6757             0   \n",
       "2345714         2556              366            4337             0   \n",
       "2345715          581              350            3423             2   \n",
       "2345716         1815              338            3277             0   \n",
       "\n",
       "         MODEL_CODE     ...      CIBIL_SCORE_GURANTOR  LOAN_DURATION  STATUS  \\\n",
       "35086             0     ...                       0.0              5       0   \n",
       "35151             1     ...                       0.0              5       0   \n",
       "53806             2     ...                       0.0             11       0   \n",
       "70445             3     ...                       0.0             11       1   \n",
       "75697             2     ...                       0.0             11       0   \n",
       "92237             4     ...                       0.0             11       0   \n",
       "101451            5     ...                       0.0              5       0   \n",
       "101452            6     ...                       0.0             11       0   \n",
       "112873            0     ...                       0.0              2       0   \n",
       "119430            2     ...                       0.0             11       2   \n",
       "119465            1     ...                       0.0             11       0   \n",
       "143914            7     ...                       0.0             11       0   \n",
       "143915            5     ...                       0.0             11       0   \n",
       "150017            8     ...                       0.0             11       0   \n",
       "150019            5     ...                       0.0              2       1   \n",
       "150804            9     ...                       0.0              5       0   \n",
       "150806           10     ...                       0.0             11       0   \n",
       "153566            8     ...                       0.0             11       1   \n",
       "160102            2     ...                       0.0             11       0   \n",
       "160103            4     ...                       0.0             11       0   \n",
       "209414           11     ...                       0.0             11       0   \n",
       "215238            5     ...                       0.0             11       0   \n",
       "216268            5     ...                       0.0              0       0   \n",
       "222343            1     ...                       0.0             11       0   \n",
       "227489            2     ...                       0.0             11       2   \n",
       "227817            4     ...                       0.0             11       0   \n",
       "228754            5     ...                       0.0             11       0   \n",
       "228808            2     ...                       0.0             11       0   \n",
       "228809           12     ...                       0.0              5       0   \n",
       "235032           13     ...                       0.0             11       0   \n",
       "...             ...     ...                       ...            ...     ...   \n",
       "2345687          19     ...                       0.0             11       0   \n",
       "2345688           2     ...                       0.0             11       0   \n",
       "2345689           5     ...                       0.0             11       0   \n",
       "2345690           2     ...                       0.0             11       0   \n",
       "2345691          22     ...                       0.0             11       0   \n",
       "2345692          19     ...                       0.0             11       0   \n",
       "2345693           0     ...                       0.0              5       0   \n",
       "2345694           5     ...                       0.0             11       0   \n",
       "2345695          17     ...                       0.0              5       0   \n",
       "2345696          20     ...                       0.0              5       0   \n",
       "2345697          21     ...                       0.0              5       0   \n",
       "2345698          19     ...                       0.0             11       0   \n",
       "2345699           5     ...                       0.0             11       0   \n",
       "2345700          18     ...                       0.0              5       0   \n",
       "2345701          15     ...                       0.0             11       0   \n",
       "2345702           0     ...                       0.0             11       0   \n",
       "2345703          20     ...                       0.0              5       0   \n",
       "2345704          22     ...                       0.0             11       0   \n",
       "2345705          12     ...                       0.0             11       0   \n",
       "2345706          22     ...                       0.0             11       0   \n",
       "2345707           5     ...                       0.0             11       0   \n",
       "2345708           2     ...                       0.0             11       0   \n",
       "2345709          19     ...                       0.0              5       0   \n",
       "2345710          12     ...                       0.0             11       0   \n",
       "2345711          12     ...                       0.0             11       0   \n",
       "2345712          20     ...                       0.0             11       0   \n",
       "2345713           8     ...                       0.0              5       0   \n",
       "2345714          12     ...                       0.0             11       0   \n",
       "2345715          19     ...                       0.0             11       0   \n",
       "2345716           1     ...                       0.0             11       0   \n",
       "\n",
       "         ADDRESS_TYPE  ADDRESS_SLNO  SUB_STATUS  AGE  MOB  Target  cluster_no  \n",
       "35086               0             1           0   33    0       0           4  \n",
       "35151               1             1           0   29    0       0           2  \n",
       "53806               1             1           0   50    0       0           0  \n",
       "70445               0             1           0   41    0       0           4  \n",
       "75697               0             1           0   33    0       0           3  \n",
       "92237               0             1           0   25    0       0           0  \n",
       "101451              0             1           0   30    0       0           1  \n",
       "101452              1             1           0   31    0       0           2  \n",
       "112873              1             1           0   66    0       0           4  \n",
       "119430              1             1           1   26   12       1           3  \n",
       "119465              0             1           0   49    0       0           2  \n",
       "143914              1             1           0   40    0       0           2  \n",
       "143915              1             1           0   38    0       0           1  \n",
       "150017              1             1           0   45    0       0           0  \n",
       "150019              1             1           0   62    0       0           4  \n",
       "150804              0             1           0   38    0       0           0  \n",
       "150806              0             1           0   35    0       0           2  \n",
       "153566              0             1           0   38    0       0           4  \n",
       "160102              0             1           0   32    0       0           3  \n",
       "160103              0             1           0   34    0       0           0  \n",
       "209414              1             1           0   56    0       0           2  \n",
       "215238              0             1           0   45    0       0           1  \n",
       "216268              0             1           0   43    0       0           1  \n",
       "222343              1             1           0   21    0       0           3  \n",
       "227489              1             1           1   34    5       1           3  \n",
       "227817              1             1           0   23    0       0           0  \n",
       "228754              1             1           0   30    0       0           1  \n",
       "228808              0             1           0   29    0       0           0  \n",
       "228809              1             1           0   54    0       0           0  \n",
       "235032              1             1           0   43    0       0           0  \n",
       "...               ...           ...         ...  ...  ...     ...         ...  \n",
       "2345687             0             1           0   33    0       0           3  \n",
       "2345688             0             1           0   35    0       0           2  \n",
       "2345689             0             1           0   53    0       0           3  \n",
       "2345690             0             1           0   31    0       0           0  \n",
       "2345691             0             1           0   48    0       0           2  \n",
       "2345692             0             1           0   47    0       0           3  \n",
       "2345693             0             1           0   36    0       0           3  \n",
       "2345694             0             1           0   44    0       0           3  \n",
       "2345695             0             1           0   27    0       0           1  \n",
       "2345696             0             1           0   38    0       0           1  \n",
       "2345697             0             1           0   33    0       0           1  \n",
       "2345698             0             1           0   49    0       0           3  \n",
       "2345699             0             1           0   37    0       0           1  \n",
       "2345700             0             1           0   23    0       0           0  \n",
       "2345701             0             1           0   27    0       0           0  \n",
       "2345702             0             1           0   33    0       0           3  \n",
       "2345703             0             1           0   34    0       0           0  \n",
       "2345704             0             1           0   20    0       0           2  \n",
       "2345705             0             1           0   29    0       0           0  \n",
       "2345706             0             1           0   31    0       0           3  \n",
       "2345707             0             1           0   24    0       0           1  \n",
       "2345708             0             1           0   25    0       0           0  \n",
       "2345709             0             1           0   34    0       0           1  \n",
       "2345710             0             1           0   21    0       0           0  \n",
       "2345711             0             1           0   35    0       0           2  \n",
       "2345712             0             1           0   45    0       0           0  \n",
       "2345713             0             1           0   43    0       0           0  \n",
       "2345714             0             1           0   46    0       0           0  \n",
       "2345715             0             1           0   38    0       0           3  \n",
       "2345716             0             1           0   52    0       0           2  \n",
       "\n",
       "[688616 rows x 70 columns]"
      ]
     },
     "execution_count": 180,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Final_test#.loc[Final_train['cluster_no'] == 1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [],
   "source": [
    "from pandas.api.types import is_string_dtype"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in Final_train.columns:\n",
    "    if is_string_dtype(Final_train[i]):\n",
    "        Final_train[i] = pd.factorize(Final_train[i])[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 160,
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in Final_test.columns:\n",
    "    if is_string_dtype(Final_test[i]):\n",
    "        Final_test[i] = pd.factorize(Final_test[i])[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 187,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "column CHANNEL has ---unique----> 2 ---null----> 0 \n",
      "column PAYMENT_TYPE has ---unique----> 8 ---null----> 0 \n",
      "column DEALER_TYPE has ---unique----> 2 ---null----> 0 \n",
      "column PRODUCT_CODE has ---unique----> 3 ---null----> 0 \n",
      "column SCHEME_TYPE has ---unique----> 3 ---null----> 0 \n",
      "column ADVANCE_EMI_COUNT has ---unique----> 8 ---null----> 0 \n",
      "column SPECIAL_INSURANCE has ---unique----> 2 ---null----> 0 \n",
      "column SPECIAL_INSURANCE_FOR has ---unique----> 3 ---null----> 0 \n",
      "column SPECIAL_INSURANCE_PRODUCT has ---unique----> 3 ---null----> 0 \n",
      "column SPECIAL_INSURANCE_AMOUNT has ---unique----> 5 ---null----> 0 \n",
      "column GENDER has ---unique----> 2 ---null----> 0 \n",
      "column PANNO has ---unique----> 2 ---null----> 0 \n",
      "column DRIVING_LICENSE has ---unique----> 2 ---null----> 0 \n",
      "column PASSPORT has ---unique----> 2 ---null----> 0 \n",
      "column AADHAR has ---unique----> 2 ---null----> 0 \n",
      "column RATION has ---unique----> 2 ---null----> 0 \n",
      "column EXISTING_CUSTOMER has ---unique----> 3 ---null----> 0 \n",
      "column EMPLOYMENT_TYPE has ---unique----> 5 ---null----> 0 \n",
      "column RESIDENT_TYPE has ---unique----> 4 ---null----> 0 \n",
      "column BANK_ACCOUNT has ---unique----> 2 ---null----> 0 \n",
      "column TRN_MONTH has ---unique----> 12 ---null----> 0 \n",
      "column TRN_YEAR has ---unique----> 4 ---null----> 0 \n",
      "column FIN_YEAR has ---unique----> 4 ---null----> 0 \n",
      "column COBORROWER has ---unique----> 2 ---null----> 0 \n",
      "column GUARANTOR has ---unique----> 2 ---null----> 0 \n",
      "column RELIGION has ---unique----> 6 ---null----> 0 \n",
      "column CIBIL_HIT has ---unique----> 3 ---null----> 0 \n",
      "column LOAN_DURATION has ---unique----> 12 ---null----> 0 \n",
      "column STATUS has ---unique----> 5 ---null----> 0 \n",
      "column ADDRESS_TYPE has ---unique----> 4 ---null----> 0 \n",
      "column ADDRESS_SLNO has ---unique----> 8 ---null----> 0 \n",
      "column SUB_STATUS has ---unique----> 5 ---null----> 0 \n",
      "column Target has ---unique----> 2 ---null----> 0 \n",
      "column cluster_no has ---unique----> 5 ---null----> 0 \n"
     ]
    }
   ],
   "source": [
    "for i in Final_train.columns:\n",
    "    #if data[i].isnull().sum() != 0:\n",
    "    if Final_train[i].unique().size < 15:\n",
    "        print(\"column {} has ---unique----> {} ---null----> {} \".format(i,Final_train[i].unique().size, Final_train[i].isnull().sum()))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "Final_train.loc[(Final_Train['Target'] == 1)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.model_selection import train_test_split\n",
    "\n",
    "X_train, X_test, y_train, y_test = train_test_split(X, y, test_size=0.2, random_state=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "metadata": {},
   "outputs": [],
   "source": [
    "X_Norm = Final_train.loc[(Final_train['Target'] == 0)].iloc[:, 0:67]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 96,
   "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>CHANNEL</th>\n",
       "      <th>PAYMENT_TYPE</th>\n",
       "      <th>AREA_CODE</th>\n",
       "      <th>DEALER_TYPE</th>\n",
       "      <th>DEALER_CODE</th>\n",
       "      <th>MAINDEALER_CODE</th>\n",
       "      <th>EXECUTIVE_CODE</th>\n",
       "      <th>PRODUCT_CODE</th>\n",
       "      <th>MODEL_CODE</th>\n",
       "      <th>SCHEME_TYPE</th>\n",
       "      <th>...</th>\n",
       "      <th>CIBIL_OVERDUE</th>\n",
       "      <th>CIBIL_SCORE_COBORROWER</th>\n",
       "      <th>CIBIL_SCORE_GURANTOR</th>\n",
       "      <th>LOAN_DURATION</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>ADDRESS_TYPE</th>\n",
       "      <th>ADDRESS_SLNO</th>\n",
       "      <th>SUB_STATUS</th>\n",
       "      <th>AGE</th>\n",
       "      <th>MOB</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3000</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>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3031</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3031</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3031</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 67 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   CHANNEL  PAYMENT_TYPE  AREA_CODE  DEALER_TYPE  DEALER_CODE  \\\n",
       "0        0             0       3000            0            0   \n",
       "1        0             1       3031            0            1   \n",
       "2        0             1       3031            0            2   \n",
       "3        0             1       3031            0            1   \n",
       "4        0             1       3000            0            0   \n",
       "\n",
       "   MAINDEALER_CODE  EXECUTIVE_CODE  PRODUCT_CODE  MODEL_CODE  SCHEME_TYPE  \\\n",
       "0                0               0             0           0            0   \n",
       "1                1               1             0           1            0   \n",
       "2                2               2             0           1            1   \n",
       "3                1               1             1           2            0   \n",
       "4                0               0             1           3            1   \n",
       "\n",
       "  ...   CIBIL_OVERDUE  CIBIL_SCORE_COBORROWER  CIBIL_SCORE_GURANTOR  \\\n",
       "0 ...             0.0                     0.0                   0.0   \n",
       "1 ...             0.0                     0.0                   0.0   \n",
       "2 ...             0.0                     0.0                   0.0   \n",
       "3 ...             0.0                     0.0                   0.0   \n",
       "4 ...             0.0                     0.0                   0.0   \n",
       "\n",
       "   LOAN_DURATION  STATUS  ADDRESS_TYPE  ADDRESS_SLNO  SUB_STATUS  AGE  MOB  \n",
       "0              9       0             0             1           0   25    0  \n",
       "1             11       0             0             1           0   37    0  \n",
       "2             11       0             0             1           0   38    0  \n",
       "3             11       0             1             1           0   36    0  \n",
       "4              5       0             0             1           0   22    0  \n",
       "\n",
       "[5 rows x 67 columns]"
      ]
     },
     "execution_count": 96,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "X_Norm.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 97,
   "metadata": {},
   "outputs": [],
   "source": [
    "Y_Norm = Final_train.loc[(Final_train['Target'] == 1)].iloc[:, 0:67]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 98,
   "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>CHANNEL</th>\n",
       "      <th>PAYMENT_TYPE</th>\n",
       "      <th>AREA_CODE</th>\n",
       "      <th>DEALER_TYPE</th>\n",
       "      <th>DEALER_CODE</th>\n",
       "      <th>MAINDEALER_CODE</th>\n",
       "      <th>EXECUTIVE_CODE</th>\n",
       "      <th>PRODUCT_CODE</th>\n",
       "      <th>MODEL_CODE</th>\n",
       "      <th>SCHEME_TYPE</th>\n",
       "      <th>...</th>\n",
       "      <th>CIBIL_OVERDUE</th>\n",
       "      <th>CIBIL_SCORE_COBORROWER</th>\n",
       "      <th>CIBIL_SCORE_GURANTOR</th>\n",
       "      <th>LOAN_DURATION</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>ADDRESS_TYPE</th>\n",
       "      <th>ADDRESS_SLNO</th>\n",
       "      <th>SUB_STATUS</th>\n",
       "      <th>AGE</th>\n",
       "      <th>MOB</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3009</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3006</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>3</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>56</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3006</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>44</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3007</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>12</td>\n",
       "      <td>16</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>29</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3007</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>12</td>\n",
       "      <td>16</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 67 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    CHANNEL  PAYMENT_TYPE  AREA_CODE  DEALER_TYPE  DEALER_CODE  \\\n",
       "7         0             2       3009            0            4   \n",
       "16        0             1       3006            0           11   \n",
       "21        0             1       3006            0           11   \n",
       "22        0             1       3007            0           14   \n",
       "25        0             2       3007            0           14   \n",
       "\n",
       "    MAINDEALER_CODE  EXECUTIVE_CODE  PRODUCT_CODE  MODEL_CODE  SCHEME_TYPE  \\\n",
       "7                 4               5             2           5            2   \n",
       "16                3              12             0           8            2   \n",
       "21                3              15             0           0            2   \n",
       "22               12              16             2           4            2   \n",
       "25               12              16             2           9            2   \n",
       "\n",
       "   ...   CIBIL_OVERDUE  CIBIL_SCORE_COBORROWER  CIBIL_SCORE_GURANTOR  \\\n",
       "7  ...             0.0                     0.0                   0.0   \n",
       "16 ...             0.0                     0.0                   0.0   \n",
       "21 ...             0.0                     0.0                   0.0   \n",
       "22 ...             0.0                     0.0                   0.0   \n",
       "25 ...             0.0                     0.0                   0.0   \n",
       "\n",
       "    LOAN_DURATION  STATUS  ADDRESS_TYPE  ADDRESS_SLNO  SUB_STATUS  AGE  MOB  \n",
       "7               6       1             1             1           1   32   14  \n",
       "16              5       1             1             1           1   56   11  \n",
       "21             11       1             1             1           1   44    6  \n",
       "22              5       1             1             1           2   29   13  \n",
       "25             11       1             0             1           1   28   10  \n",
       "\n",
       "[5 rows x 67 columns]"
      ]
     },
     "execution_count": 98,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Y_Norm.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 100,
   "metadata": {},
   "outputs": [],
   "source": [
    "X_Norm_avg = []\n",
    "for i in X_Norm.columns:\n",
    "    X_Norm_avg.append(X_Norm[i].unique().mean())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 101,
   "metadata": {},
   "outputs": [],
   "source": [
    "Y_Norm_avg = []\n",
    "for i in Y_Norm.columns:\n",
    "    Y_Norm_avg.append(Y_Norm[i].unique().mean())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0.35945588485439606"
      ]
     },
     "execution_count": 111,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "1-spatial.distance.cosine([2,3,5,6], [0.2,56,0.8,0.13])"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "import numpy as np\n",
    "\n",
    "# Example data\n",
    "A = X_Norm.values\n",
    "B = Y_Norm.values\n",
    "\n",
    "# There may be a proper numpy method for this function, but it won't be much faster.\n",
    "def normalise(A):\n",
    "    lengths = (A**2).sum(axis=1, keepdims=True)**.5\n",
    "    return A/lengths\n",
    "\n",
    "A = normalise(A)\n",
    "B = normalise(B)\n",
    "\n",
    "results = []\n",
    "\n",
    "\"\"\"rows_in_slice = 100\n",
    "\n",
    "slice_start = 0\n",
    "slice_end = slice_start + rows_in_slice\n",
    "\n",
    "while slice_end <= A.shape[0]:\n",
    "\n",
    "    results.append(A[slice_start:slice_end].dot(B.T).max(axis=1))\n",
    "\n",
    "    slice_start += rows_in_slice\n",
    "    slice_end = slice_start + rows_in_slice\n",
    "\n",
    "result = np.concatenate(results)\"\"\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "metadata": {},
   "outputs": [],
   "source": [
    "%matplotlib inline\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns; sns.set()  # for plot styling\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 124,
   "metadata": {},
   "outputs": [],
   "source": [
    "from sklearn.cluster import KMeans\n",
    "from sklearn.preprocessing import LabelEncoder\n",
    "from sklearn.preprocessing import MinMaxScaler"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Process Stopped\n"
     ]
    }
   ],
   "source": [
    "try:\n",
    "    for k in range (1, 11):\n",
    "        # Create a kmeans model on our data, using k clusters.  random_state helps ensure that the algorithm returns the same results each time.\n",
    "        kmeans_model = KMeans(n_clusters=k, random_state=1).fit(Final_train.iloc[:, :])\n",
    "\n",
    "        # These are our fitted labels for clusters -- the first cluster has label 0, and the second has label 1.\n",
    "        labels = kmeans_model.labels_\n",
    " \n",
    "        # Sum of distances of samples to their closest cluster center\n",
    "        interia = kmeans_model.inertia_\n",
    "        print(\"k:,{},  cost: {}\".format(k,interia))\n",
    "except:\n",
    "    print(\"Process Stopped\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "metadata": {},
   "outputs": [],
   "source": [
    "model3=KMeans(n_clusters=5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "KMeans(algorithm='auto', copy_x=True, init='k-means++', max_iter=300,\n",
       "    n_clusters=5, n_init=10, n_jobs=None, precompute_distances='auto',\n",
       "    random_state=None, tol=0.0001, verbose=0)"
      ]
     },
     "execution_count": 131,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "model3.fit(Final_train)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "metadata": {},
   "outputs": [],
   "source": [
    "clusassign=model3.predict(Final_train)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "numpy.ndarray"
      ]
     },
     "execution_count": 134,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(clusassign)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "metadata": {},
   "outputs": [],
   "source": [
    "Final_train['cluster_no'] =  clusassign"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 162,
   "metadata": {},
   "outputs": [],
   "source": [
    "clusassign_test=model3.predict(Final_test)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 164,
   "metadata": {},
   "outputs": [],
   "source": [
    "Final_test['cluster_no'] =  clusassign_test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 151,
   "metadata": {},
   "outputs": [],
   "source": [
    "Finaltrain_AGMTNO = Final_data.loc[Final_data['AGMT_DATE'] < datetime.datetime.strptime(\"2018-01-01\", \"%Y-%m-%d\")]['AGMTNO']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 156,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "numpy.ndarray"
      ]
     },
     "execution_count": 156,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(Finaltrain_AGMTNO.values)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 167,
   "metadata": {},
   "outputs": [],
   "source": [
    "Final_train['AGMTNO'] = Finaltrain_AGMTNO.values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 168,
   "metadata": {},
   "outputs": [],
   "source": [
    "Finaltest_AGMTNO = Final_data.loc[Final_data['AGMT_DATE'] >= datetime.datetime.strptime(\"2018-01-01\", \"%Y-%m-%d\")]['AGMTNO']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 170,
   "metadata": {},
   "outputs": [],
   "source": [
    "Final_test['AGMTNO'] = Finaltest_AGMTNO.values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 188,
   "metadata": {},
   "outputs": [],
   "source": [
    "Final_train = Final_train[['AGMTNO','CHANNEL', 'PAYMENT_TYPE', 'AREA_CODE', 'DEALER_TYPE', 'DEALER_CODE',\n",
    "       'MAINDEALER_CODE', 'EXECUTIVE_CODE', 'PRODUCT_CODE', 'MODEL_CODE',\n",
    "       'SCHEME_TYPE', 'SCHEME_CODE', 'ADVANCE_EMI_COUNT', 'TENUR', 'ROI',\n",
    "       'EMI', 'PORCESSING_FEE', 'STAMPING_CHARGES', 'ASSET_COST',\n",
    "       'LOAN_AMOUNT', 'DOWN_PAYMENT', 'INITITAL_HIRE', 'LTV', 'AMORT_IRR',\n",
    "       'CUSTOMER_IRR', 'NET_IRR', 'VECHICAL_INSURANCE_AMT',\n",
    "       'SPECIAL_INSURANCE', 'SPECIAL_INSURANCE_FOR',\n",
    "       'SPECIAL_INSURANCE_PRODUCT', 'SPECIAL_INSURANCE_AMOUNT', 'GENDER',\n",
    "       'PANNO', 'DRIVING_LICENSE', 'PASSPORT', 'AADHAR', 'RATION',\n",
    "       'EXISTING_CUSTOMER', 'EMPLOYMENT_TYPE', 'CUSTOMER_PROFILE_CODE',\n",
    "       'RESIDENT_TYPE', 'BANK_ACCOUNT', 'PINCODE', 'CITY', 'STATE',\n",
    "       'ACTUAL_LOAN_AMOUNT',\n",
    "       'PRODUCT_CUST_IRR', 'PRODUCT_AMORT_IRR', 'PRODUCT_TENUR',\n",
    "       'PF_SERVICE_TAX', 'CIBIL_SCORE', 'COBORROWER', 'GUARANTOR', 'RELIGION',\n",
    "       'CIBIL_HIT', 'CIBIL_OVERDUE', 'CIBIL_SCORE_COBORROWER',\n",
    "       'CIBIL_SCORE_GURANTOR', 'LOAN_DURATION', 'STATUS', 'ADDRESS_TYPE',\n",
    "       'ADDRESS_SLNO', 'SUB_STATUS', 'AGE', 'MOB', 'Target', 'cluster_no']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 189,
   "metadata": {},
   "outputs": [],
   "source": [
    "Final_test = Final_test[['AGMTNO','CHANNEL', 'PAYMENT_TYPE', 'AREA_CODE', 'DEALER_TYPE', 'DEALER_CODE',\n",
    "       'MAINDEALER_CODE', 'EXECUTIVE_CODE', 'PRODUCT_CODE', 'MODEL_CODE',\n",
    "       'SCHEME_TYPE', 'SCHEME_CODE', 'ADVANCE_EMI_COUNT', 'TENUR', 'ROI',\n",
    "       'EMI', 'PORCESSING_FEE', 'STAMPING_CHARGES', 'ASSET_COST',\n",
    "       'LOAN_AMOUNT', 'DOWN_PAYMENT', 'INITITAL_HIRE', 'LTV', 'AMORT_IRR',\n",
    "       'CUSTOMER_IRR', 'NET_IRR', 'VECHICAL_INSURANCE_AMT',\n",
    "       'SPECIAL_INSURANCE', 'SPECIAL_INSURANCE_FOR',\n",
    "       'SPECIAL_INSURANCE_PRODUCT', 'SPECIAL_INSURANCE_AMOUNT', 'GENDER',\n",
    "       'PANNO', 'DRIVING_LICENSE', 'PASSPORT', 'AADHAR', 'RATION',\n",
    "       'EXISTING_CUSTOMER', 'EMPLOYMENT_TYPE', 'CUSTOMER_PROFILE_CODE',\n",
    "       'RESIDENT_TYPE', 'BANK_ACCOUNT', 'PINCODE', 'CITY', 'STATE',\n",
    "       'ACTUAL_LOAN_AMOUNT',\n",
    "       'PRODUCT_CUST_IRR', 'PRODUCT_AMORT_IRR', 'PRODUCT_TENUR',\n",
    "       'PF_SERVICE_TAX', 'CIBIL_SCORE', 'COBORROWER', 'GUARANTOR', 'RELIGION',\n",
    "       'CIBIL_HIT', 'CIBIL_OVERDUE', 'CIBIL_SCORE_COBORROWER',\n",
    "       'CIBIL_SCORE_GURANTOR', 'LOAN_DURATION', 'STATUS', 'ADDRESS_TYPE',\n",
    "       'ADDRESS_SLNO', 'SUB_STATUS', 'AGE', 'MOB', 'Target', 'cluster_no']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 190,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_Data_cluster = pd.concat([Final_train,Final_test], axis=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 191,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_Data_cluster.to_csv(\"D:\\cust_coll_data_cluster.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 192,
   "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>AGMTNO</th>\n",
       "      <th>CHANNEL</th>\n",
       "      <th>PAYMENT_TYPE</th>\n",
       "      <th>AREA_CODE</th>\n",
       "      <th>DEALER_TYPE</th>\n",
       "      <th>DEALER_CODE</th>\n",
       "      <th>MAINDEALER_CODE</th>\n",
       "      <th>EXECUTIVE_CODE</th>\n",
       "      <th>PRODUCT_CODE</th>\n",
       "      <th>MODEL_CODE</th>\n",
       "      <th>...</th>\n",
       "      <th>CIBIL_SCORE_GURANTOR</th>\n",
       "      <th>LOAN_DURATION</th>\n",
       "      <th>STATUS</th>\n",
       "      <th>ADDRESS_TYPE</th>\n",
       "      <th>ADDRESS_SLNO</th>\n",
       "      <th>SUB_STATUS</th>\n",
       "      <th>AGE</th>\n",
       "      <th>MOB</th>\n",
       "      <th>Target</th>\n",
       "      <th>cluster_no</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>TN3000TW0039449</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3000</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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>GJ3031TW10471</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3031</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>GJ3031TW0012554</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3031</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>GJ3031TW10521</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3031</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>TN3000TW0039724</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>TN3006TW0071627</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3006</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>TN3000TW0039601</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>KA3009TW0095215</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3009</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>GJ3031TW10624</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3031</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>GJ3031TW10538</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3031</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>GJ3031TW10546</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3031</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>GJ3031TW10491</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3031</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>GJ3031TW10527</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>3031</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>GJ3031TW10559</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3031</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>KA3025TW0054143</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3110</td>\n",
       "      <td>0</td>\n",
       "      <td>10</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>TN3000TW0039346</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>50</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>TN3006TW56678</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3006</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>3</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>56</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>TN3006TW56740</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3006</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>3</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>TN3006TW56792</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3006</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>10</td>\n",
       "      <td>13</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>TN3006TW56633</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3006</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>10</td>\n",
       "      <td>13</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>TN3007TW54111</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3007</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>11</td>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>TN3006TW56818</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3006</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>44</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>TN3007TW54042</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3007</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>12</td>\n",
       "      <td>16</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>29</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>TN3007TW54258</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3007</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>12</td>\n",
       "      <td>17</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>TN3007TW54020</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3007</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>12</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>TN3007TW54021</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3007</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>12</td>\n",
       "      <td>16</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>TN3007TW54140</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3007</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>12</td>\n",
       "      <td>17</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>TN3007TW54067</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3007</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>12</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>TN3007TW54367</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3007</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>11</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>TN3007TW54311</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3007</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>11</td>\n",
       "      <td>21</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <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>2345687</th>\n",
       "      <td>JH3053TW0054775</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3053</td>\n",
       "      <td>1</td>\n",
       "      <td>426</td>\n",
       "      <td>350</td>\n",
       "      <td>5610</td>\n",
       "      <td>2</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345688</th>\n",
       "      <td>AP3042TW0080117</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3042</td>\n",
       "      <td>1</td>\n",
       "      <td>2160</td>\n",
       "      <td>1300</td>\n",
       "      <td>5076</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345689</th>\n",
       "      <td>UP3035TW0027579</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3035</td>\n",
       "      <td>1</td>\n",
       "      <td>2186</td>\n",
       "      <td>1088</td>\n",
       "      <td>4552</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>53</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345690</th>\n",
       "      <td>PB3046TW0026251</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3046</td>\n",
       "      <td>0</td>\n",
       "      <td>1651</td>\n",
       "      <td>1115</td>\n",
       "      <td>3602</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345691</th>\n",
       "      <td>TN3004TW0086902</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3004</td>\n",
       "      <td>1</td>\n",
       "      <td>2639</td>\n",
       "      <td>1097</td>\n",
       "      <td>4303</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>48</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345692</th>\n",
       "      <td>KE3023TW0033261</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3023</td>\n",
       "      <td>0</td>\n",
       "      <td>1668</td>\n",
       "      <td>1680</td>\n",
       "      <td>4273</td>\n",
       "      <td>2</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>47</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345693</th>\n",
       "      <td>UP3064TW0028012</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3064</td>\n",
       "      <td>1</td>\n",
       "      <td>2771</td>\n",
       "      <td>540</td>\n",
       "      <td>5302</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345694</th>\n",
       "      <td>UP3064TW0028026</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>3064</td>\n",
       "      <td>1</td>\n",
       "      <td>2496</td>\n",
       "      <td>107</td>\n",
       "      <td>3898</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>44</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345695</th>\n",
       "      <td>UP3064TW0028016</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3064</td>\n",
       "      <td>1</td>\n",
       "      <td>2496</td>\n",
       "      <td>107</td>\n",
       "      <td>3898</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345696</th>\n",
       "      <td>OR3051TW0118049</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3051</td>\n",
       "      <td>0</td>\n",
       "      <td>2113</td>\n",
       "      <td>1112</td>\n",
       "      <td>6001</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345697</th>\n",
       "      <td>OR3051TW0118007</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3051</td>\n",
       "      <td>0</td>\n",
       "      <td>2113</td>\n",
       "      <td>1112</td>\n",
       "      <td>6001</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345698</th>\n",
       "      <td>OR3051TW0117978</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3051</td>\n",
       "      <td>1</td>\n",
       "      <td>3379</td>\n",
       "      <td>1402</td>\n",
       "      <td>6019</td>\n",
       "      <td>2</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>49</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345699</th>\n",
       "      <td>OR3051TW0118005</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3051</td>\n",
       "      <td>1</td>\n",
       "      <td>2071</td>\n",
       "      <td>340</td>\n",
       "      <td>5585</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345700</th>\n",
       "      <td>OR3051TW0118517</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3051</td>\n",
       "      <td>1</td>\n",
       "      <td>6915</td>\n",
       "      <td>340</td>\n",
       "      <td>7081</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345701</th>\n",
       "      <td>OR3051TW0118502</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3051</td>\n",
       "      <td>1</td>\n",
       "      <td>1361</td>\n",
       "      <td>1402</td>\n",
       "      <td>4432</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345702</th>\n",
       "      <td>UP3065TW0026762</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3065</td>\n",
       "      <td>1</td>\n",
       "      <td>79</td>\n",
       "      <td>75</td>\n",
       "      <td>3067</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345703</th>\n",
       "      <td>OR3051TW0118336</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3051</td>\n",
       "      <td>1</td>\n",
       "      <td>6915</td>\n",
       "      <td>340</td>\n",
       "      <td>7081</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345704</th>\n",
       "      <td>OR3051TW0118491</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3051</td>\n",
       "      <td>1</td>\n",
       "      <td>260</td>\n",
       "      <td>340</td>\n",
       "      <td>3340</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345705</th>\n",
       "      <td>OR3051TW0118460</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3051</td>\n",
       "      <td>0</td>\n",
       "      <td>2520</td>\n",
       "      <td>1515</td>\n",
       "      <td>3627</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345706</th>\n",
       "      <td>UP3065TW0026700</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3065</td>\n",
       "      <td>1</td>\n",
       "      <td>262</td>\n",
       "      <td>121</td>\n",
       "      <td>3515</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345707</th>\n",
       "      <td>BR3058TW0105219</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3058</td>\n",
       "      <td>0</td>\n",
       "      <td>4654</td>\n",
       "      <td>1729</td>\n",
       "      <td>3670</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345708</th>\n",
       "      <td>GO3086TW0002473</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3086</td>\n",
       "      <td>0</td>\n",
       "      <td>1365</td>\n",
       "      <td>916</td>\n",
       "      <td>3227</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345709</th>\n",
       "      <td>GJ3032TW0007479</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3032</td>\n",
       "      <td>0</td>\n",
       "      <td>522</td>\n",
       "      <td>428</td>\n",
       "      <td>3419</td>\n",
       "      <td>2</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>34</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345710</th>\n",
       "      <td>BR3058TW0105380</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3058</td>\n",
       "      <td>0</td>\n",
       "      <td>4059</td>\n",
       "      <td>1613</td>\n",
       "      <td>4386</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345711</th>\n",
       "      <td>TR3087TW0003455</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3087</td>\n",
       "      <td>1</td>\n",
       "      <td>1801</td>\n",
       "      <td>366</td>\n",
       "      <td>4172</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>35</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345712</th>\n",
       "      <td>TR3087TW0003430</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3087</td>\n",
       "      <td>0</td>\n",
       "      <td>440</td>\n",
       "      <td>366</td>\n",
       "      <td>3395</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>45</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345713</th>\n",
       "      <td>OR3088TW0029837</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3088</td>\n",
       "      <td>1</td>\n",
       "      <td>2874</td>\n",
       "      <td>60</td>\n",
       "      <td>6757</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>43</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345714</th>\n",
       "      <td>TR3087TW0003446</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3087</td>\n",
       "      <td>1</td>\n",
       "      <td>2556</td>\n",
       "      <td>366</td>\n",
       "      <td>4337</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>46</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345715</th>\n",
       "      <td>JH3053TW0055998</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3053</td>\n",
       "      <td>0</td>\n",
       "      <td>581</td>\n",
       "      <td>350</td>\n",
       "      <td>3423</td>\n",
       "      <td>2</td>\n",
       "      <td>19</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>38</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2345716</th>\n",
       "      <td>JH3053TW0055918</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>3053</td>\n",
       "      <td>1</td>\n",
       "      <td>1815</td>\n",
       "      <td>338</td>\n",
       "      <td>3277</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2345717 rows × 67 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  AGMTNO  CHANNEL  PAYMENT_TYPE  AREA_CODE  DEALER_TYPE  \\\n",
       "0        TN3000TW0039449        0             0       3000            0   \n",
       "1          GJ3031TW10471        0             1       3031            0   \n",
       "2        GJ3031TW0012554        0             1       3031            0   \n",
       "3          GJ3031TW10521        0             1       3031            0   \n",
       "4        TN3000TW0039724        0             1       3000            0   \n",
       "5        TN3006TW0071627        0             2       3006            1   \n",
       "6        TN3000TW0039601        0             0       3000            0   \n",
       "7        KA3009TW0095215        0             2       3009            0   \n",
       "8          GJ3031TW10624        0             3       3031            1   \n",
       "9          GJ3031TW10538        0             1       3031            0   \n",
       "10         GJ3031TW10546        0             1       3031            0   \n",
       "11         GJ3031TW10491        0             3       3031            0   \n",
       "12         GJ3031TW10527        0             3       3031            0   \n",
       "13         GJ3031TW10559        0             1       3031            0   \n",
       "14       KA3025TW0054143        0             1       3110            0   \n",
       "15       TN3000TW0039346        0             0       3000            0   \n",
       "16         TN3006TW56678        0             1       3006            0   \n",
       "17         TN3006TW56740        0             2       3006            0   \n",
       "18         TN3006TW56792        0             2       3006            0   \n",
       "19         TN3006TW56633        0             2       3006            0   \n",
       "20         TN3007TW54111        0             2       3007            1   \n",
       "21         TN3006TW56818        0             1       3006            0   \n",
       "22         TN3007TW54042        0             1       3007            0   \n",
       "23         TN3007TW54258        0             2       3007            1   \n",
       "24         TN3007TW54020        0             2       3007            0   \n",
       "25         TN3007TW54021        0             2       3007            0   \n",
       "26         TN3007TW54140        0             2       3007            1   \n",
       "27         TN3007TW54067        0             2       3007            1   \n",
       "28         TN3007TW54367        0             1       3007            1   \n",
       "29         TN3007TW54311        0             2       3007            1   \n",
       "...                  ...      ...           ...        ...          ...   \n",
       "2345687  JH3053TW0054775        0             0       3053            1   \n",
       "2345688  AP3042TW0080117        0             2       3042            1   \n",
       "2345689  UP3035TW0027579        0             0       3035            1   \n",
       "2345690  PB3046TW0026251        0             0       3046            0   \n",
       "2345691  TN3004TW0086902        0             0       3004            1   \n",
       "2345692  KE3023TW0033261        0             0       3023            0   \n",
       "2345693  UP3064TW0028012        0             2       3064            1   \n",
       "2345694  UP3064TW0028026        0             2       3064            1   \n",
       "2345695  UP3064TW0028016        0             0       3064            1   \n",
       "2345696  OR3051TW0118049        0             0       3051            0   \n",
       "2345697  OR3051TW0118007        0             0       3051            0   \n",
       "2345698  OR3051TW0117978        0             0       3051            1   \n",
       "2345699  OR3051TW0118005        0             0       3051            1   \n",
       "2345700  OR3051TW0118517        0             1       3051            1   \n",
       "2345701  OR3051TW0118502        0             0       3051            1   \n",
       "2345702  UP3065TW0026762        0             0       3065            1   \n",
       "2345703  OR3051TW0118336        0             1       3051            1   \n",
       "2345704  OR3051TW0118491        0             0       3051            1   \n",
       "2345705  OR3051TW0118460        0             0       3051            0   \n",
       "2345706  UP3065TW0026700        0             0       3065            1   \n",
       "2345707  BR3058TW0105219        0             0       3058            0   \n",
       "2345708  GO3086TW0002473        0             1       3086            0   \n",
       "2345709  GJ3032TW0007479        0             0       3032            0   \n",
       "2345710  BR3058TW0105380        0             0       3058            0   \n",
       "2345711  TR3087TW0003455        0             0       3087            1   \n",
       "2345712  TR3087TW0003430        0             0       3087            0   \n",
       "2345713  OR3088TW0029837        0             0       3088            1   \n",
       "2345714  TR3087TW0003446        0             0       3087            1   \n",
       "2345715  JH3053TW0055998        0             0       3053            0   \n",
       "2345716  JH3053TW0055918        0             0       3053            1   \n",
       "\n",
       "         DEALER_CODE  MAINDEALER_CODE  EXECUTIVE_CODE  PRODUCT_CODE  \\\n",
       "0                  0                0               0             0   \n",
       "1                  1                1               1             0   \n",
       "2                  2                2               2             0   \n",
       "3                  1                1               1             1   \n",
       "4                  0                0               0             1   \n",
       "5                  3                3               3             2   \n",
       "6                  0                0               4             0   \n",
       "7                  4                4               5             2   \n",
       "8                  5                1               1             0   \n",
       "9                  1                1               6             1   \n",
       "10                 6                5               7             0   \n",
       "11                 7                6               8             0   \n",
       "12                 8                7               9             0   \n",
       "13                 9                8              10             2   \n",
       "14                10                9              11             1   \n",
       "15                 0                0               4             1   \n",
       "16                11                3              12             0   \n",
       "17                11                3              12             0   \n",
       "18                12               10              13             2   \n",
       "19                12               10              13             2   \n",
       "20                13               11              14             1   \n",
       "21                11                3              15             0   \n",
       "22                14               12              16             2   \n",
       "23                15               12              17             2   \n",
       "24                14               12              18             2   \n",
       "25                14               12              16             2   \n",
       "26                15               12              17             2   \n",
       "27                16               12              19             0   \n",
       "28                17               11              20             0   \n",
       "29                18               11              21             2   \n",
       "...              ...              ...             ...           ...   \n",
       "2345687          426              350            5610             2   \n",
       "2345688         2160             1300            5076             1   \n",
       "2345689         2186             1088            4552             2   \n",
       "2345690         1651             1115            3602             1   \n",
       "2345691         2639             1097            4303             0   \n",
       "2345692         1668             1680            4273             2   \n",
       "2345693         2771              540            5302             0   \n",
       "2345694         2496              107            3898             2   \n",
       "2345695         2496              107            3898             0   \n",
       "2345696         2113             1112            6001             1   \n",
       "2345697         2113             1112            6001             1   \n",
       "2345698         3379             1402            6019             2   \n",
       "2345699         2071              340            5585             2   \n",
       "2345700         6915              340            7081             1   \n",
       "2345701         1361             1402            4432             0   \n",
       "2345702           79               75            3067             0   \n",
       "2345703         6915              340            7081             1   \n",
       "2345704          260              340            3340             0   \n",
       "2345705         2520             1515            3627             0   \n",
       "2345706          262              121            3515             0   \n",
       "2345707         4654             1729            3670             2   \n",
       "2345708         1365              916            3227             1   \n",
       "2345709          522              428            3419             2   \n",
       "2345710         4059             1613            4386             0   \n",
       "2345711         1801              366            4172             0   \n",
       "2345712          440              366            3395             1   \n",
       "2345713         2874               60            6757             0   \n",
       "2345714         2556              366            4337             0   \n",
       "2345715          581              350            3423             2   \n",
       "2345716         1815              338            3277             0   \n",
       "\n",
       "         MODEL_CODE     ...      CIBIL_SCORE_GURANTOR  LOAN_DURATION  STATUS  \\\n",
       "0                 0     ...                       0.0              9       0   \n",
       "1                 1     ...                       0.0             11       0   \n",
       "2                 1     ...                       0.0             11       0   \n",
       "3                 2     ...                       0.0             11       0   \n",
       "4                 3     ...                       0.0              5       0   \n",
       "5                 4     ...                       0.0             11       0   \n",
       "6                 0     ...                       0.0             11       0   \n",
       "7                 5     ...                       0.0              6       1   \n",
       "8                 1     ...                       0.0             11       2   \n",
       "9                 6     ...                       0.0             11       0   \n",
       "10                7     ...                       0.0             11       0   \n",
       "11                1     ...                       0.0              5       0   \n",
       "12                0     ...                       0.0              5       0   \n",
       "13                4     ...                       0.0              5       0   \n",
       "14                2     ...                       0.0              4       2   \n",
       "15                2     ...                       0.0             11       0   \n",
       "16                8     ...                       0.0              5       1   \n",
       "17                0     ...                       0.0             11       0   \n",
       "18                4     ...                       0.0             11       0   \n",
       "19                4     ...                       0.0             11       0   \n",
       "20                2     ...                       0.0             11       0   \n",
       "21                0     ...                       0.0             11       1   \n",
       "22                4     ...                       0.0              5       1   \n",
       "23                4     ...                       0.0             11       0   \n",
       "24                4     ...                       0.0              5       0   \n",
       "25                9     ...                       0.0             11       1   \n",
       "26                4     ...                       0.0             11       0   \n",
       "27                0     ...                       0.0             11       0   \n",
       "28                7     ...                       0.0             11       0   \n",
       "29                4     ...                       0.0             11       1   \n",
       "...             ...     ...                       ...            ...     ...   \n",
       "2345687          19     ...                       0.0             11       0   \n",
       "2345688           2     ...                       0.0             11       0   \n",
       "2345689           5     ...                       0.0             11       0   \n",
       "2345690           2     ...                       0.0             11       0   \n",
       "2345691          22     ...                       0.0             11       0   \n",
       "2345692          19     ...                       0.0             11       0   \n",
       "2345693           0     ...                       0.0              5       0   \n",
       "2345694           5     ...                       0.0             11       0   \n",
       "2345695          17     ...                       0.0              5       0   \n",
       "2345696          20     ...                       0.0              5       0   \n",
       "2345697          21     ...                       0.0              5       0   \n",
       "2345698          19     ...                       0.0             11       0   \n",
       "2345699           5     ...                       0.0             11       0   \n",
       "2345700          18     ...                       0.0              5       0   \n",
       "2345701          15     ...                       0.0             11       0   \n",
       "2345702           0     ...                       0.0             11       0   \n",
       "2345703          20     ...                       0.0              5       0   \n",
       "2345704          22     ...                       0.0             11       0   \n",
       "2345705          12     ...                       0.0             11       0   \n",
       "2345706          22     ...                       0.0             11       0   \n",
       "2345707           5     ...                       0.0             11       0   \n",
       "2345708           2     ...                       0.0             11       0   \n",
       "2345709          19     ...                       0.0              5       0   \n",
       "2345710          12     ...                       0.0             11       0   \n",
       "2345711          12     ...                       0.0             11       0   \n",
       "2345712          20     ...                       0.0             11       0   \n",
       "2345713           8     ...                       0.0              5       0   \n",
       "2345714          12     ...                       0.0             11       0   \n",
       "2345715          19     ...                       0.0             11       0   \n",
       "2345716           1     ...                       0.0             11       0   \n",
       "\n",
       "         ADDRESS_TYPE  ADDRESS_SLNO  SUB_STATUS  AGE  MOB  Target  cluster_no  \n",
       "0                   0             1           0   25    0       0           4  \n",
       "1                   0             1           0   37    0       0           4  \n",
       "2                   0             1           0   38    0       0           4  \n",
       "3                   1             1           0   36    0       0           4  \n",
       "4                   0             1           0   22    0       0           0  \n",
       "5                   1             1           0   50    0       0           1  \n",
       "6                   0             1           0   26    0       0           3  \n",
       "7                   1             1           1   32   14       1           1  \n",
       "8                   1             1           0   48    0       0           4  \n",
       "9                   0             1           0   32    0       0           3  \n",
       "10                  0             1           0   35    0       0           3  \n",
       "11                  0             1           0   37    0       0           1  \n",
       "12                  0             1           0   32    0       0           1  \n",
       "13                  1             1           0   42    0       0           1  \n",
       "14                  1             1           0   31    0       0           3  \n",
       "15                  1             1           0   50    0       0           3  \n",
       "16                  1             1           1   56   11       1           1  \n",
       "17                  1             1           0   34    0       0           2  \n",
       "18                  1             1           0   43    0       0           1  \n",
       "19                  1             1           0   23    0       0           1  \n",
       "20                  0             1           0   36    0       0           1  \n",
       "21                  1             1           1   44    6       1           3  \n",
       "22                  1             1           2   29   13       1           4  \n",
       "23                  0             1           0   45    0       0           1  \n",
       "24                  1             1           0   34    0       0           4  \n",
       "25                  0             1           1   28   10       1           1  \n",
       "26                  1             1           0   40    0       0           1  \n",
       "27                  0             1           0   36    0       0           2  \n",
       "28                  1             1           0   29    0       0           3  \n",
       "29                  0             1           1   32   14       1           1  \n",
       "...               ...           ...         ...  ...  ...     ...         ...  \n",
       "2345687             0             1           0   33    0       0           3  \n",
       "2345688             0             1           0   35    0       0           2  \n",
       "2345689             0             1           0   53    0       0           3  \n",
       "2345690             0             1           0   31    0       0           0  \n",
       "2345691             0             1           0   48    0       0           2  \n",
       "2345692             0             1           0   47    0       0           3  \n",
       "2345693             0             1           0   36    0       0           3  \n",
       "2345694             0             1           0   44    0       0           3  \n",
       "2345695             0             1           0   27    0       0           1  \n",
       "2345696             0             1           0   38    0       0           1  \n",
       "2345697             0             1           0   33    0       0           1  \n",
       "2345698             0             1           0   49    0       0           3  \n",
       "2345699             0             1           0   37    0       0           1  \n",
       "2345700             0             1           0   23    0       0           0  \n",
       "2345701             0             1           0   27    0       0           0  \n",
       "2345702             0             1           0   33    0       0           3  \n",
       "2345703             0             1           0   34    0       0           0  \n",
       "2345704             0             1           0   20    0       0           2  \n",
       "2345705             0             1           0   29    0       0           0  \n",
       "2345706             0             1           0   31    0       0           3  \n",
       "2345707             0             1           0   24    0       0           1  \n",
       "2345708             0             1           0   25    0       0           0  \n",
       "2345709             0             1           0   34    0       0           1  \n",
       "2345710             0             1           0   21    0       0           0  \n",
       "2345711             0             1           0   35    0       0           2  \n",
       "2345712             0             1           0   45    0       0           0  \n",
       "2345713             0             1           0   43    0       0           0  \n",
       "2345714             0             1           0   46    0       0           0  \n",
       "2345715             0             1           0   38    0       0           3  \n",
       "2345716             0             1           0   52    0       0           2  \n",
       "\n",
       "[2345717 rows x 67 columns]"
      ]
     },
     "execution_count": 192,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_Data_cluster"
   ]
  },
  {
   "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.6.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}