abrar_vehicleloan_oversample.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "4d96f313",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt\n",
    "from sklearn import metrics"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "fad92b88",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(233154, 41)\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>UNIQUEID</th>\n",
       "      <th>DISBURSED_AMOUNT</th>\n",
       "      <th>ASSET_COST</th>\n",
       "      <th>LTV</th>\n",
       "      <th>BRANCH_ID</th>\n",
       "      <th>SUPPLIER_ID</th>\n",
       "      <th>MANUFACTURER_ID</th>\n",
       "      <th>CURRENT_PINCODE_ID</th>\n",
       "      <th>DATE_OF_BIRTH</th>\n",
       "      <th>EMPLOYMENT_TYPE</th>\n",
       "      <th>...</th>\n",
       "      <th>SEC_SANCTIONED_AMOUNT</th>\n",
       "      <th>SEC_DISBURSED_AMOUNT</th>\n",
       "      <th>PRIMARY_INSTAL_AMT</th>\n",
       "      <th>SEC_INSTAL_AMT</th>\n",
       "      <th>NEW_ACCTS_IN_LAST_SIX_MONTHS</th>\n",
       "      <th>DELINQUENT_ACCTS_IN_LAST_SIX_MONTHS</th>\n",
       "      <th>AVERAGE_ACCT_AGE</th>\n",
       "      <th>CREDIT_HISTORY_LENGTH</th>\n",
       "      <th>NO_OF_INQUIRIES</th>\n",
       "      <th>LOAN_DEFAULT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>420825</td>\n",
       "      <td>50578</td>\n",
       "      <td>58400</td>\n",
       "      <td>89.55</td>\n",
       "      <td>67</td>\n",
       "      <td>22807</td>\n",
       "      <td>45</td>\n",
       "      <td>1441</td>\n",
       "      <td>01-01-1984</td>\n",
       "      <td>Salaried</td>\n",
       "      <td>...</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>0yrs 0mon</td>\n",
       "      <td>0yrs 0mon</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>537409</td>\n",
       "      <td>47145</td>\n",
       "      <td>65550</td>\n",
       "      <td>73.23</td>\n",
       "      <td>67</td>\n",
       "      <td>22807</td>\n",
       "      <td>45</td>\n",
       "      <td>1502</td>\n",
       "      <td>31-07-1985</td>\n",
       "      <td>Self employed</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1991</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1yrs 11mon</td>\n",
       "      <td>1yrs 11mon</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>417566</td>\n",
       "      <td>53278</td>\n",
       "      <td>61360</td>\n",
       "      <td>89.63</td>\n",
       "      <td>67</td>\n",
       "      <td>22807</td>\n",
       "      <td>45</td>\n",
       "      <td>1497</td>\n",
       "      <td>24-08-1985</td>\n",
       "      <td>Self employed</td>\n",
       "      <td>...</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>0yrs 0mon</td>\n",
       "      <td>0yrs 0mon</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>624493</td>\n",
       "      <td>57513</td>\n",
       "      <td>66113</td>\n",
       "      <td>88.48</td>\n",
       "      <td>67</td>\n",
       "      <td>22807</td>\n",
       "      <td>45</td>\n",
       "      <td>1501</td>\n",
       "      <td>30-12-1993</td>\n",
       "      <td>Self employed</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0yrs 8mon</td>\n",
       "      <td>1yrs 3mon</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>539055</td>\n",
       "      <td>52378</td>\n",
       "      <td>60300</td>\n",
       "      <td>88.39</td>\n",
       "      <td>67</td>\n",
       "      <td>22807</td>\n",
       "      <td>45</td>\n",
       "      <td>1495</td>\n",
       "      <td>09-12-1977</td>\n",
       "      <td>Self employed</td>\n",
       "      <td>...</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>0yrs 0mon</td>\n",
       "      <td>0yrs 0mon</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 41 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   UNIQUEID  DISBURSED_AMOUNT  ASSET_COST    LTV  BRANCH_ID  SUPPLIER_ID  \\\n",
       "0    420825             50578       58400  89.55         67        22807   \n",
       "1    537409             47145       65550  73.23         67        22807   \n",
       "2    417566             53278       61360  89.63         67        22807   \n",
       "3    624493             57513       66113  88.48         67        22807   \n",
       "4    539055             52378       60300  88.39         67        22807   \n",
       "\n",
       "   MANUFACTURER_ID  CURRENT_PINCODE_ID DATE_OF_BIRTH EMPLOYMENT_TYPE  ...  \\\n",
       "0               45                1441    01-01-1984        Salaried  ...   \n",
       "1               45                1502    31-07-1985   Self employed  ...   \n",
       "2               45                1497    24-08-1985   Self employed  ...   \n",
       "3               45                1501    30-12-1993   Self employed  ...   \n",
       "4               45                1495    09-12-1977   Self employed  ...   \n",
       "\n",
       "  SEC_SANCTIONED_AMOUNT  SEC_DISBURSED_AMOUNT  PRIMARY_INSTAL_AMT  \\\n",
       "0                     0                     0                   0   \n",
       "1                     0                     0                1991   \n",
       "2                     0                     0                   0   \n",
       "3                     0                     0                  31   \n",
       "4                     0                     0                   0   \n",
       "\n",
       "   SEC_INSTAL_AMT  NEW_ACCTS_IN_LAST_SIX_MONTHS  \\\n",
       "0               0                             0   \n",
       "1               0                             0   \n",
       "2               0                             0   \n",
       "3               0                             0   \n",
       "4               0                             0   \n",
       "\n",
       "   DELINQUENT_ACCTS_IN_LAST_SIX_MONTHS  AVERAGE_ACCT_AGE  \\\n",
       "0                                    0         0yrs 0mon   \n",
       "1                                    1        1yrs 11mon   \n",
       "2                                    0         0yrs 0mon   \n",
       "3                                    0         0yrs 8mon   \n",
       "4                                    0         0yrs 0mon   \n",
       "\n",
       "   CREDIT_HISTORY_LENGTH  NO_OF_INQUIRIES  LOAN_DEFAULT  \n",
       "0              0yrs 0mon                0             0  \n",
       "1             1yrs 11mon                0             1  \n",
       "2              0yrs 0mon                0             0  \n",
       "3              1yrs 3mon                1             1  \n",
       "4              0yrs 0mon                1             1  \n",
       "\n",
       "[5 rows x 41 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"vehicle_loan_train.csv\")\n",
    "print(df.shape)\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "18873192-3187-49c0-b8fd-677a5f750c0c",
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"DATE_OF_BIRTH\"] = df[\"DATE_OF_BIRTH\"].str.replace(\"-\", \"/\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "676b618a-9e00-45f3-b01c-3e67326de9fd",
   "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>UNIQUEID</th>\n",
       "      <th>DISBURSED_AMOUNT</th>\n",
       "      <th>ASSET_COST</th>\n",
       "      <th>LTV</th>\n",
       "      <th>BRANCH_ID</th>\n",
       "      <th>SUPPLIER_ID</th>\n",
       "      <th>MANUFACTURER_ID</th>\n",
       "      <th>CURRENT_PINCODE_ID</th>\n",
       "      <th>DATE_OF_BIRTH</th>\n",
       "      <th>EMPLOYMENT_TYPE</th>\n",
       "      <th>...</th>\n",
       "      <th>SEC_SANCTIONED_AMOUNT</th>\n",
       "      <th>SEC_DISBURSED_AMOUNT</th>\n",
       "      <th>PRIMARY_INSTAL_AMT</th>\n",
       "      <th>SEC_INSTAL_AMT</th>\n",
       "      <th>NEW_ACCTS_IN_LAST_SIX_MONTHS</th>\n",
       "      <th>DELINQUENT_ACCTS_IN_LAST_SIX_MONTHS</th>\n",
       "      <th>AVERAGE_ACCT_AGE</th>\n",
       "      <th>CREDIT_HISTORY_LENGTH</th>\n",
       "      <th>NO_OF_INQUIRIES</th>\n",
       "      <th>LOAN_DEFAULT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>420825</td>\n",
       "      <td>50578</td>\n",
       "      <td>58400</td>\n",
       "      <td>89.55</td>\n",
       "      <td>67</td>\n",
       "      <td>22807</td>\n",
       "      <td>45</td>\n",
       "      <td>1441</td>\n",
       "      <td>01/01/1984</td>\n",
       "      <td>Salaried</td>\n",
       "      <td>...</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>0yrs 0mon</td>\n",
       "      <td>0yrs 0mon</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>537409</td>\n",
       "      <td>47145</td>\n",
       "      <td>65550</td>\n",
       "      <td>73.23</td>\n",
       "      <td>67</td>\n",
       "      <td>22807</td>\n",
       "      <td>45</td>\n",
       "      <td>1502</td>\n",
       "      <td>31/07/1985</td>\n",
       "      <td>Self employed</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1991</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1yrs 11mon</td>\n",
       "      <td>1yrs 11mon</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>417566</td>\n",
       "      <td>53278</td>\n",
       "      <td>61360</td>\n",
       "      <td>89.63</td>\n",
       "      <td>67</td>\n",
       "      <td>22807</td>\n",
       "      <td>45</td>\n",
       "      <td>1497</td>\n",
       "      <td>24/08/1985</td>\n",
       "      <td>Self employed</td>\n",
       "      <td>...</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>0yrs 0mon</td>\n",
       "      <td>0yrs 0mon</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>624493</td>\n",
       "      <td>57513</td>\n",
       "      <td>66113</td>\n",
       "      <td>88.48</td>\n",
       "      <td>67</td>\n",
       "      <td>22807</td>\n",
       "      <td>45</td>\n",
       "      <td>1501</td>\n",
       "      <td>30/12/1993</td>\n",
       "      <td>Self employed</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0yrs 8mon</td>\n",
       "      <td>1yrs 3mon</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>539055</td>\n",
       "      <td>52378</td>\n",
       "      <td>60300</td>\n",
       "      <td>88.39</td>\n",
       "      <td>67</td>\n",
       "      <td>22807</td>\n",
       "      <td>45</td>\n",
       "      <td>1495</td>\n",
       "      <td>09/12/1977</td>\n",
       "      <td>Self employed</td>\n",
       "      <td>...</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>0yrs 0mon</td>\n",
       "      <td>0yrs 0mon</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>233149</th>\n",
       "      <td>626432</td>\n",
       "      <td>63213</td>\n",
       "      <td>105405</td>\n",
       "      <td>60.72</td>\n",
       "      <td>34</td>\n",
       "      <td>20700</td>\n",
       "      <td>48</td>\n",
       "      <td>1050</td>\n",
       "      <td>01/08/1988</td>\n",
       "      <td>Salaried</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4084</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1yrs 9mon</td>\n",
       "      <td>3yrs 3mon</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233150</th>\n",
       "      <td>606141</td>\n",
       "      <td>73651</td>\n",
       "      <td>100600</td>\n",
       "      <td>74.95</td>\n",
       "      <td>34</td>\n",
       "      <td>23775</td>\n",
       "      <td>51</td>\n",
       "      <td>990</td>\n",
       "      <td>05/12/1988</td>\n",
       "      <td>Self employed</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1565</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0yrs 6mon</td>\n",
       "      <td>0yrs 6mon</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233151</th>\n",
       "      <td>613658</td>\n",
       "      <td>33484</td>\n",
       "      <td>71212</td>\n",
       "      <td>48.45</td>\n",
       "      <td>77</td>\n",
       "      <td>22186</td>\n",
       "      <td>86</td>\n",
       "      <td>2299</td>\n",
       "      <td>01/06/1976</td>\n",
       "      <td>Salaried</td>\n",
       "      <td>...</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>0yrs 0mon</td>\n",
       "      <td>0yrs 0mon</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233152</th>\n",
       "      <td>548084</td>\n",
       "      <td>34259</td>\n",
       "      <td>73286</td>\n",
       "      <td>49.10</td>\n",
       "      <td>77</td>\n",
       "      <td>22186</td>\n",
       "      <td>86</td>\n",
       "      <td>2299</td>\n",
       "      <td>26/03/1994</td>\n",
       "      <td>Salaried</td>\n",
       "      <td>...</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>0yrs 0mon</td>\n",
       "      <td>0yrs 0mon</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233153</th>\n",
       "      <td>630213</td>\n",
       "      <td>75751</td>\n",
       "      <td>116009</td>\n",
       "      <td>66.81</td>\n",
       "      <td>77</td>\n",
       "      <td>22186</td>\n",
       "      <td>86</td>\n",
       "      <td>2299</td>\n",
       "      <td>18/02/1984</td>\n",
       "      <td>Salaried</td>\n",
       "      <td>...</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>0yrs 0mon</td>\n",
       "      <td>0yrs 0mon</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>233154 rows × 41 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        UNIQUEID  DISBURSED_AMOUNT  ASSET_COST    LTV  BRANCH_ID  SUPPLIER_ID  \\\n",
       "0         420825             50578       58400  89.55         67        22807   \n",
       "1         537409             47145       65550  73.23         67        22807   \n",
       "2         417566             53278       61360  89.63         67        22807   \n",
       "3         624493             57513       66113  88.48         67        22807   \n",
       "4         539055             52378       60300  88.39         67        22807   \n",
       "...          ...               ...         ...    ...        ...          ...   \n",
       "233149    626432             63213      105405  60.72         34        20700   \n",
       "233150    606141             73651      100600  74.95         34        23775   \n",
       "233151    613658             33484       71212  48.45         77        22186   \n",
       "233152    548084             34259       73286  49.10         77        22186   \n",
       "233153    630213             75751      116009  66.81         77        22186   \n",
       "\n",
       "        MANUFACTURER_ID  CURRENT_PINCODE_ID DATE_OF_BIRTH EMPLOYMENT_TYPE  \\\n",
       "0                    45                1441    01/01/1984        Salaried   \n",
       "1                    45                1502    31/07/1985   Self employed   \n",
       "2                    45                1497    24/08/1985   Self employed   \n",
       "3                    45                1501    30/12/1993   Self employed   \n",
       "4                    45                1495    09/12/1977   Self employed   \n",
       "...                 ...                 ...           ...             ...   \n",
       "233149               48                1050    01/08/1988        Salaried   \n",
       "233150               51                 990    05/12/1988   Self employed   \n",
       "233151               86                2299    01/06/1976        Salaried   \n",
       "233152               86                2299    26/03/1994        Salaried   \n",
       "233153               86                2299    18/02/1984        Salaried   \n",
       "\n",
       "        ... SEC_SANCTIONED_AMOUNT  SEC_DISBURSED_AMOUNT  PRIMARY_INSTAL_AMT  \\\n",
       "0       ...                     0                     0                   0   \n",
       "1       ...                     0                     0                1991   \n",
       "2       ...                     0                     0                   0   \n",
       "3       ...                     0                     0                  31   \n",
       "4       ...                     0                     0                   0   \n",
       "...     ...                   ...                   ...                 ...   \n",
       "233149  ...                     0                     0                4084   \n",
       "233150  ...                     0                     0                1565   \n",
       "233151  ...                     0                     0                   0   \n",
       "233152  ...                     0                     0                   0   \n",
       "233153  ...                     0                     0                   0   \n",
       "\n",
       "        SEC_INSTAL_AMT  NEW_ACCTS_IN_LAST_SIX_MONTHS  \\\n",
       "0                    0                             0   \n",
       "1                    0                             0   \n",
       "2                    0                             0   \n",
       "3                    0                             0   \n",
       "4                    0                             0   \n",
       "...                ...                           ...   \n",
       "233149               0                             0   \n",
       "233150               0                             0   \n",
       "233151               0                             0   \n",
       "233152               0                             0   \n",
       "233153               0                             0   \n",
       "\n",
       "        DELINQUENT_ACCTS_IN_LAST_SIX_MONTHS  AVERAGE_ACCT_AGE  \\\n",
       "0                                         0         0yrs 0mon   \n",
       "1                                         1        1yrs 11mon   \n",
       "2                                         0         0yrs 0mon   \n",
       "3                                         0         0yrs 8mon   \n",
       "4                                         0         0yrs 0mon   \n",
       "...                                     ...               ...   \n",
       "233149                                    0         1yrs 9mon   \n",
       "233150                                    0         0yrs 6mon   \n",
       "233151                                    0         0yrs 0mon   \n",
       "233152                                    0         0yrs 0mon   \n",
       "233153                                    0         0yrs 0mon   \n",
       "\n",
       "        CREDIT_HISTORY_LENGTH  NO_OF_INQUIRIES  LOAN_DEFAULT  \n",
       "0                   0yrs 0mon                0             0  \n",
       "1                  1yrs 11mon                0             1  \n",
       "2                   0yrs 0mon                0             0  \n",
       "3                   1yrs 3mon                1             1  \n",
       "4                   0yrs 0mon                1             1  \n",
       "...                       ...              ...           ...  \n",
       "233149              3yrs 3mon                0             0  \n",
       "233150              0yrs 6mon                0             0  \n",
       "233151              0yrs 0mon                0             0  \n",
       "233152              0yrs 0mon                0             0  \n",
       "233153              0yrs 0mon                0             0  \n",
       "\n",
       "[233154 rows x 41 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "d4390589-be9c-4684-94cf-de64c5dd4978",
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"DATE_OF_BIRTH\"] = pd.to_datetime(df[\"DATE_OF_BIRTH\"], infer_datetime_format=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "22f8877d-ba1e-45d6-b327-e89ca7a03b57",
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"DATE_OF_BIRTH\"] = df[\"DATE_OF_BIRTH\"].dt.year"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "49824318-f129-47ee-9cb1-bee3a4ad8ed3",
   "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>UNIQUEID</th>\n",
       "      <th>DISBURSED_AMOUNT</th>\n",
       "      <th>ASSET_COST</th>\n",
       "      <th>LTV</th>\n",
       "      <th>BRANCH_ID</th>\n",
       "      <th>SUPPLIER_ID</th>\n",
       "      <th>MANUFACTURER_ID</th>\n",
       "      <th>CURRENT_PINCODE_ID</th>\n",
       "      <th>DATE_OF_BIRTH</th>\n",
       "      <th>EMPLOYMENT_TYPE</th>\n",
       "      <th>...</th>\n",
       "      <th>SEC_SANCTIONED_AMOUNT</th>\n",
       "      <th>SEC_DISBURSED_AMOUNT</th>\n",
       "      <th>PRIMARY_INSTAL_AMT</th>\n",
       "      <th>SEC_INSTAL_AMT</th>\n",
       "      <th>NEW_ACCTS_IN_LAST_SIX_MONTHS</th>\n",
       "      <th>DELINQUENT_ACCTS_IN_LAST_SIX_MONTHS</th>\n",
       "      <th>AVERAGE_ACCT_AGE</th>\n",
       "      <th>CREDIT_HISTORY_LENGTH</th>\n",
       "      <th>NO_OF_INQUIRIES</th>\n",
       "      <th>LOAN_DEFAULT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>420825</td>\n",
       "      <td>50578</td>\n",
       "      <td>58400</td>\n",
       "      <td>89.55</td>\n",
       "      <td>67</td>\n",
       "      <td>22807</td>\n",
       "      <td>45</td>\n",
       "      <td>1441</td>\n",
       "      <td>1984</td>\n",
       "      <td>Salaried</td>\n",
       "      <td>...</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>0yrs 0mon</td>\n",
       "      <td>0yrs 0mon</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>537409</td>\n",
       "      <td>47145</td>\n",
       "      <td>65550</td>\n",
       "      <td>73.23</td>\n",
       "      <td>67</td>\n",
       "      <td>22807</td>\n",
       "      <td>45</td>\n",
       "      <td>1502</td>\n",
       "      <td>1985</td>\n",
       "      <td>Self employed</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1991</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1yrs 11mon</td>\n",
       "      <td>1yrs 11mon</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>417566</td>\n",
       "      <td>53278</td>\n",
       "      <td>61360</td>\n",
       "      <td>89.63</td>\n",
       "      <td>67</td>\n",
       "      <td>22807</td>\n",
       "      <td>45</td>\n",
       "      <td>1497</td>\n",
       "      <td>1985</td>\n",
       "      <td>Self employed</td>\n",
       "      <td>...</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>0yrs 0mon</td>\n",
       "      <td>0yrs 0mon</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>624493</td>\n",
       "      <td>57513</td>\n",
       "      <td>66113</td>\n",
       "      <td>88.48</td>\n",
       "      <td>67</td>\n",
       "      <td>22807</td>\n",
       "      <td>45</td>\n",
       "      <td>1501</td>\n",
       "      <td>1993</td>\n",
       "      <td>Self employed</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0yrs 8mon</td>\n",
       "      <td>1yrs 3mon</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>539055</td>\n",
       "      <td>52378</td>\n",
       "      <td>60300</td>\n",
       "      <td>88.39</td>\n",
       "      <td>67</td>\n",
       "      <td>22807</td>\n",
       "      <td>45</td>\n",
       "      <td>1495</td>\n",
       "      <td>1977</td>\n",
       "      <td>Self employed</td>\n",
       "      <td>...</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>0yrs 0mon</td>\n",
       "      <td>0yrs 0mon</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>233149</th>\n",
       "      <td>626432</td>\n",
       "      <td>63213</td>\n",
       "      <td>105405</td>\n",
       "      <td>60.72</td>\n",
       "      <td>34</td>\n",
       "      <td>20700</td>\n",
       "      <td>48</td>\n",
       "      <td>1050</td>\n",
       "      <td>1988</td>\n",
       "      <td>Salaried</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>4084</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1yrs 9mon</td>\n",
       "      <td>3yrs 3mon</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233150</th>\n",
       "      <td>606141</td>\n",
       "      <td>73651</td>\n",
       "      <td>100600</td>\n",
       "      <td>74.95</td>\n",
       "      <td>34</td>\n",
       "      <td>23775</td>\n",
       "      <td>51</td>\n",
       "      <td>990</td>\n",
       "      <td>1988</td>\n",
       "      <td>Self employed</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1565</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0yrs 6mon</td>\n",
       "      <td>0yrs 6mon</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233151</th>\n",
       "      <td>613658</td>\n",
       "      <td>33484</td>\n",
       "      <td>71212</td>\n",
       "      <td>48.45</td>\n",
       "      <td>77</td>\n",
       "      <td>22186</td>\n",
       "      <td>86</td>\n",
       "      <td>2299</td>\n",
       "      <td>1976</td>\n",
       "      <td>Salaried</td>\n",
       "      <td>...</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>0yrs 0mon</td>\n",
       "      <td>0yrs 0mon</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233152</th>\n",
       "      <td>548084</td>\n",
       "      <td>34259</td>\n",
       "      <td>73286</td>\n",
       "      <td>49.10</td>\n",
       "      <td>77</td>\n",
       "      <td>22186</td>\n",
       "      <td>86</td>\n",
       "      <td>2299</td>\n",
       "      <td>1994</td>\n",
       "      <td>Salaried</td>\n",
       "      <td>...</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>0yrs 0mon</td>\n",
       "      <td>0yrs 0mon</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233153</th>\n",
       "      <td>630213</td>\n",
       "      <td>75751</td>\n",
       "      <td>116009</td>\n",
       "      <td>66.81</td>\n",
       "      <td>77</td>\n",
       "      <td>22186</td>\n",
       "      <td>86</td>\n",
       "      <td>2299</td>\n",
       "      <td>1984</td>\n",
       "      <td>Salaried</td>\n",
       "      <td>...</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>0yrs 0mon</td>\n",
       "      <td>0yrs 0mon</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>233154 rows × 41 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        UNIQUEID  DISBURSED_AMOUNT  ASSET_COST    LTV  BRANCH_ID  SUPPLIER_ID  \\\n",
       "0         420825             50578       58400  89.55         67        22807   \n",
       "1         537409             47145       65550  73.23         67        22807   \n",
       "2         417566             53278       61360  89.63         67        22807   \n",
       "3         624493             57513       66113  88.48         67        22807   \n",
       "4         539055             52378       60300  88.39         67        22807   \n",
       "...          ...               ...         ...    ...        ...          ...   \n",
       "233149    626432             63213      105405  60.72         34        20700   \n",
       "233150    606141             73651      100600  74.95         34        23775   \n",
       "233151    613658             33484       71212  48.45         77        22186   \n",
       "233152    548084             34259       73286  49.10         77        22186   \n",
       "233153    630213             75751      116009  66.81         77        22186   \n",
       "\n",
       "        MANUFACTURER_ID  CURRENT_PINCODE_ID  DATE_OF_BIRTH EMPLOYMENT_TYPE  \\\n",
       "0                    45                1441           1984        Salaried   \n",
       "1                    45                1502           1985   Self employed   \n",
       "2                    45                1497           1985   Self employed   \n",
       "3                    45                1501           1993   Self employed   \n",
       "4                    45                1495           1977   Self employed   \n",
       "...                 ...                 ...            ...             ...   \n",
       "233149               48                1050           1988        Salaried   \n",
       "233150               51                 990           1988   Self employed   \n",
       "233151               86                2299           1976        Salaried   \n",
       "233152               86                2299           1994        Salaried   \n",
       "233153               86                2299           1984        Salaried   \n",
       "\n",
       "        ... SEC_SANCTIONED_AMOUNT  SEC_DISBURSED_AMOUNT  PRIMARY_INSTAL_AMT  \\\n",
       "0       ...                     0                     0                   0   \n",
       "1       ...                     0                     0                1991   \n",
       "2       ...                     0                     0                   0   \n",
       "3       ...                     0                     0                  31   \n",
       "4       ...                     0                     0                   0   \n",
       "...     ...                   ...                   ...                 ...   \n",
       "233149  ...                     0                     0                4084   \n",
       "233150  ...                     0                     0                1565   \n",
       "233151  ...                     0                     0                   0   \n",
       "233152  ...                     0                     0                   0   \n",
       "233153  ...                     0                     0                   0   \n",
       "\n",
       "        SEC_INSTAL_AMT  NEW_ACCTS_IN_LAST_SIX_MONTHS  \\\n",
       "0                    0                             0   \n",
       "1                    0                             0   \n",
       "2                    0                             0   \n",
       "3                    0                             0   \n",
       "4                    0                             0   \n",
       "...                ...                           ...   \n",
       "233149               0                             0   \n",
       "233150               0                             0   \n",
       "233151               0                             0   \n",
       "233152               0                             0   \n",
       "233153               0                             0   \n",
       "\n",
       "        DELINQUENT_ACCTS_IN_LAST_SIX_MONTHS  AVERAGE_ACCT_AGE  \\\n",
       "0                                         0         0yrs 0mon   \n",
       "1                                         1        1yrs 11mon   \n",
       "2                                         0         0yrs 0mon   \n",
       "3                                         0         0yrs 8mon   \n",
       "4                                         0         0yrs 0mon   \n",
       "...                                     ...               ...   \n",
       "233149                                    0         1yrs 9mon   \n",
       "233150                                    0         0yrs 6mon   \n",
       "233151                                    0         0yrs 0mon   \n",
       "233152                                    0         0yrs 0mon   \n",
       "233153                                    0         0yrs 0mon   \n",
       "\n",
       "        CREDIT_HISTORY_LENGTH  NO_OF_INQUIRIES  LOAN_DEFAULT  \n",
       "0                   0yrs 0mon                0             0  \n",
       "1                  1yrs 11mon                0             1  \n",
       "2                   0yrs 0mon                0             0  \n",
       "3                   1yrs 3mon                1             1  \n",
       "4                   0yrs 0mon                1             1  \n",
       "...                       ...              ...           ...  \n",
       "233149              3yrs 3mon                0             0  \n",
       "233150              0yrs 6mon                0             0  \n",
       "233151              0yrs 0mon                0             0  \n",
       "233152              0yrs 0mon                0             0  \n",
       "233153              0yrs 0mon                0             0  \n",
       "\n",
       "[233154 rows x 41 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "b9ec486a-18fe-4498-bf66-44fe975bb700",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['UNIQUEID',\n",
       " 'DISBURSED_AMOUNT',\n",
       " 'ASSET_COST',\n",
       " 'LTV',\n",
       " 'BRANCH_ID',\n",
       " 'SUPPLIER_ID',\n",
       " 'MANUFACTURER_ID',\n",
       " 'CURRENT_PINCODE_ID',\n",
       " 'DATE_OF_BIRTH',\n",
       " 'STATE_ID',\n",
       " 'EMPLOYEE_CODE_ID',\n",
       " 'MOBILENO_AVL_FLAG',\n",
       " 'AADHAR_FLAG',\n",
       " 'PAN_FLAG',\n",
       " 'VOTERID_FLAG',\n",
       " 'DRIVING_FLAG',\n",
       " 'PASSPORT_FLAG',\n",
       " 'PERFORM_CNS_SCORE',\n",
       " 'PRI_NO_OF_ACCTS',\n",
       " 'PRI_ACTIVE_ACCTS',\n",
       " 'PRI_OVERDUE_ACCTS',\n",
       " 'PRI_CURRENT_BALANCE',\n",
       " 'PRI_SANCTIONED_AMOUNT',\n",
       " 'PRI_DISBURSED_AMOUNT',\n",
       " 'SEC_NO_OF_ACCTS',\n",
       " 'SEC_ACTIVE_ACCTS',\n",
       " 'SEC_OVERDUE_ACCTS',\n",
       " 'SEC_CURRENT_BALANCE',\n",
       " 'SEC_SANCTIONED_AMOUNT',\n",
       " 'SEC_DISBURSED_AMOUNT',\n",
       " 'PRIMARY_INSTAL_AMT',\n",
       " 'SEC_INSTAL_AMT',\n",
       " 'NEW_ACCTS_IN_LAST_SIX_MONTHS',\n",
       " 'DELINQUENT_ACCTS_IN_LAST_SIX_MONTHS',\n",
       " 'NO_OF_INQUIRIES',\n",
       " 'LOAN_DEFAULT']"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(df._get_numeric_data().columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "85672ae3-691a-4516-b375-a9f1ab88dfb3",
   "metadata": {},
   "outputs": [],
   "source": [
    "num_columns = [\n",
    " 'DISBURSED_AMOUNT',\n",
    " 'ASSET_COST',\n",
    " 'LTV',\n",
    " 'MANUFACTURER_ID',\n",
    " 'CURRENT_PINCODE_ID',\n",
    " 'EMPLOYEE_CODE_ID',\n",
    " 'MOBILENO_AVL_FLAG',\n",
    " 'AADHAR_FLAG',\n",
    " 'PAN_FLAG',\n",
    " 'VOTERID_FLAG',\n",
    " 'DRIVING_FLAG',\n",
    " 'PASSPORT_FLAG',\n",
    " 'PERFORM_CNS_SCORE',\n",
    " 'PRI_NO_OF_ACCTS',\n",
    " 'PRI_ACTIVE_ACCTS',\n",
    " 'PRI_OVERDUE_ACCTS',\n",
    " 'PRI_CURRENT_BALANCE',\n",
    " 'PRI_SANCTIONED_AMOUNT',\n",
    " 'PRI_DISBURSED_AMOUNT',\n",
    " 'SEC_NO_OF_ACCTS',\n",
    " 'SEC_ACTIVE_ACCTS',\n",
    " 'SEC_OVERDUE_ACCTS',\n",
    " 'SEC_CURRENT_BALANCE',\n",
    " 'SEC_SANCTIONED_AMOUNT',\n",
    " 'SEC_DISBURSED_AMOUNT',\n",
    " 'PRIMARY_INSTAL_AMT',\n",
    " 'SEC_INSTAL_AMT',\n",
    " 'NEW_ACCTS_IN_LAST_SIX_MONTHS',\n",
    " 'DELINQUENT_ACCTS_IN_LAST_SIX_MONTHS',\n",
    " 'AVERAGE_ACCT_AGE',\n",
    " 'CREDIT_HISTORY_LENGTH',\n",
    " 'NO_OF_INQUIRIES',\n",
    " 'LOAN_DEFAULT']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "0ebf0ec8",
   "metadata": {},
   "outputs": [],
   "source": [
    "cat_columns = ['AVERAGE_ACCT_AGE', 'EMPLOYMENT_TYPE', 'CREDIT_HISTORY_LENGTH', 'DATE_OF_BIRTH']b"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "id": "7676ff08-6b9b-4eba-8f95-6a2a594750a5",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['AVERAGE_ACCT_AGE'] = df['AVERAGE_ACCT_AGE'].str.replace('yrs ','.',regex=False)\n",
    "df['AVERAGE_ACCT_AGE'] = df['AVERAGE_ACCT_AGE'].str.replace('mon','',regex=False).astype(float)\n",
    "df['CREDIT_HISTORY_LENGTH'] = df['CREDIT_HISTORY_LENGTH'].str.replace('yrs ','.',regex=False)\n",
    "df['CREDIT_HISTORY_LENGTH'] = df['CREDIT_HISTORY_LENGTH'].str.replace('mon','',regex=False).astype(float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "id": "8d3c1354-0490-49f5-b4b5-cb7ce4fcc223",
   "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>AVERAGE_ACCT_AGE</th>\n",
       "      <th>CREDIT_HISTORY_LENGTH</th>\n",
       "      <th>DATE_OF_BIRTH</th>\n",
       "      <th>EMPLOYMENT_TYPE_Salaried</th>\n",
       "      <th>EMPLOYMENT_TYPE_Self employed</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1850</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1993</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20434</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1993</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55614</th>\n",
       "      <td>0.11</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1974</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150207</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1994</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195787</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1976</td>\n",
       "      <td>0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18800</th>\n",
       "      <td>0.10</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1975</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44681</th>\n",
       "      <td>0.90</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1994</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208332</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1994</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112202</th>\n",
       "      <td>1.40</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1992</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175387</th>\n",
       "      <td>1.10</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1990</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>233154 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        AVERAGE_ACCT_AGE  CREDIT_HISTORY_LENGTH  DATE_OF_BIRTH  \\\n",
       "1850                0.00                    0.0           1993   \n",
       "20434               0.00                    0.0           1993   \n",
       "55614               0.11                    1.0           1974   \n",
       "150207              0.00                    0.0           1994   \n",
       "195787              0.00                    0.0           1976   \n",
       "...                  ...                    ...            ...   \n",
       "18800               0.10                    0.2           1975   \n",
       "44681               0.90                    2.1           1994   \n",
       "208332              0.00                    0.0           1994   \n",
       "112202              1.40                    3.0           1992   \n",
       "175387              1.10                    2.1           1990   \n",
       "\n",
       "        EMPLOYMENT_TYPE_Salaried  EMPLOYMENT_TYPE_Self employed  \n",
       "1850                           1                              0  \n",
       "20434                          0                              1  \n",
       "55614                          1                              0  \n",
       "150207                         0                              1  \n",
       "195787                         0                              1  \n",
       "...                          ...                            ...  \n",
       "18800                          0                              1  \n",
       "44681                          1                              0  \n",
       "208332                         1                              0  \n",
       "112202                         1                              0  \n",
       "175387                         0                              1  \n",
       "\n",
       "[233154 rows x 5 columns]"
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cat = df[cat_columns]\n",
    "cat = pd.get_dummies(cat)\n",
    "cat"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "id": "c863e2c1-be12-47b6-8f3c-d5d12f18c4ba",
   "metadata": {},
   "outputs": [],
   "source": [
    "new_df = pd.concat([cat, df[num_columns]], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "id": "2fc2346f-0e27-48a6-8597-c847ec57ce92",
   "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>AVERAGE_ACCT_AGE</th>\n",
       "      <th>CREDIT_HISTORY_LENGTH</th>\n",
       "      <th>DATE_OF_BIRTH</th>\n",
       "      <th>EMPLOYMENT_TYPE_Salaried</th>\n",
       "      <th>EMPLOYMENT_TYPE_Self employed</th>\n",
       "      <th>DISBURSED_AMOUNT</th>\n",
       "      <th>ASSET_COST</th>\n",
       "      <th>LTV</th>\n",
       "      <th>MANUFACTURER_ID</th>\n",
       "      <th>CURRENT_PINCODE_ID</th>\n",
       "      <th>...</th>\n",
       "      <th>SEC_SANCTIONED_AMOUNT</th>\n",
       "      <th>SEC_DISBURSED_AMOUNT</th>\n",
       "      <th>PRIMARY_INSTAL_AMT</th>\n",
       "      <th>SEC_INSTAL_AMT</th>\n",
       "      <th>NEW_ACCTS_IN_LAST_SIX_MONTHS</th>\n",
       "      <th>DELINQUENT_ACCTS_IN_LAST_SIX_MONTHS</th>\n",
       "      <th>AVERAGE_ACCT_AGE</th>\n",
       "      <th>CREDIT_HISTORY_LENGTH</th>\n",
       "      <th>NO_OF_INQUIRIES</th>\n",
       "      <th>LOAN_DEFAULT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1850</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1993</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>35939</td>\n",
       "      <td>68412</td>\n",
       "      <td>54.08</td>\n",
       "      <td>86</td>\n",
       "      <td>7102</td>\n",
       "      <td>...</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.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20434</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1993</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>52333</td>\n",
       "      <td>78500</td>\n",
       "      <td>71.34</td>\n",
       "      <td>45</td>\n",
       "      <td>5650</td>\n",
       "      <td>...</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.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55614</th>\n",
       "      <td>0.11</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1974</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>55159</td>\n",
       "      <td>71386</td>\n",
       "      <td>79.15</td>\n",
       "      <td>45</td>\n",
       "      <td>1446</td>\n",
       "      <td>...</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.11</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150207</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1994</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>49803</td>\n",
       "      <td>64866</td>\n",
       "      <td>78.62</td>\n",
       "      <td>45</td>\n",
       "      <td>116</td>\n",
       "      <td>...</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.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195787</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1976</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>52303</td>\n",
       "      <td>69472</td>\n",
       "      <td>76.29</td>\n",
       "      <td>86</td>\n",
       "      <td>1043</td>\n",
       "      <td>...</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.00</td>\n",
       "      <td>0.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>18800</th>\n",
       "      <td>0.10</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1975</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>63947</td>\n",
       "      <td>73000</td>\n",
       "      <td>89.04</td>\n",
       "      <td>86</td>\n",
       "      <td>1711</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12361</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0.10</td>\n",
       "      <td>0.2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44681</th>\n",
       "      <td>0.90</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1994</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>43594</td>\n",
       "      <td>68572</td>\n",
       "      <td>65.62</td>\n",
       "      <td>86</td>\n",
       "      <td>1828</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1565</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0.90</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208332</th>\n",
       "      <td>0.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1994</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>67069</td>\n",
       "      <td>85985</td>\n",
       "      <td>79.67</td>\n",
       "      <td>45</td>\n",
       "      <td>1510</td>\n",
       "      <td>...</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.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112202</th>\n",
       "      <td>1.40</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1992</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>39394</td>\n",
       "      <td>56322</td>\n",
       "      <td>72.80</td>\n",
       "      <td>45</td>\n",
       "      <td>88</td>\n",
       "      <td>...</td>\n",
       "      <td>85543</td>\n",
       "      <td>85543</td>\n",
       "      <td>0</td>\n",
       "      <td>7373</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1.40</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175387</th>\n",
       "      <td>1.10</td>\n",
       "      <td>2.1</td>\n",
       "      <td>1990</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>52303</td>\n",
       "      <td>69786</td>\n",
       "      <td>75.95</td>\n",
       "      <td>51</td>\n",
       "      <td>2406</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>2372</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1.10</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>233154 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        AVERAGE_ACCT_AGE  CREDIT_HISTORY_LENGTH  DATE_OF_BIRTH  \\\n",
       "1850                0.00                    0.0           1993   \n",
       "20434               0.00                    0.0           1993   \n",
       "55614               0.11                    1.0           1974   \n",
       "150207              0.00                    0.0           1994   \n",
       "195787              0.00                    0.0           1976   \n",
       "...                  ...                    ...            ...   \n",
       "18800               0.10                    0.2           1975   \n",
       "44681               0.90                    2.1           1994   \n",
       "208332              0.00                    0.0           1994   \n",
       "112202              1.40                    3.0           1992   \n",
       "175387              1.10                    2.1           1990   \n",
       "\n",
       "        EMPLOYMENT_TYPE_Salaried  EMPLOYMENT_TYPE_Self employed  \\\n",
       "1850                           1                              0   \n",
       "20434                          0                              1   \n",
       "55614                          1                              0   \n",
       "150207                         0                              1   \n",
       "195787                         0                              1   \n",
       "...                          ...                            ...   \n",
       "18800                          0                              1   \n",
       "44681                          1                              0   \n",
       "208332                         1                              0   \n",
       "112202                         1                              0   \n",
       "175387                         0                              1   \n",
       "\n",
       "        DISBURSED_AMOUNT  ASSET_COST    LTV  MANUFACTURER_ID  \\\n",
       "1850               35939       68412  54.08               86   \n",
       "20434              52333       78500  71.34               45   \n",
       "55614              55159       71386  79.15               45   \n",
       "150207             49803       64866  78.62               45   \n",
       "195787             52303       69472  76.29               86   \n",
       "...                  ...         ...    ...              ...   \n",
       "18800              63947       73000  89.04               86   \n",
       "44681              43594       68572  65.62               86   \n",
       "208332             67069       85985  79.67               45   \n",
       "112202             39394       56322  72.80               45   \n",
       "175387             52303       69786  75.95               51   \n",
       "\n",
       "        CURRENT_PINCODE_ID  ...  SEC_SANCTIONED_AMOUNT  SEC_DISBURSED_AMOUNT  \\\n",
       "1850                  7102  ...                      0                     0   \n",
       "20434                 5650  ...                      0                     0   \n",
       "55614                 1446  ...                      0                     0   \n",
       "150207                 116  ...                      0                     0   \n",
       "195787                1043  ...                      0                     0   \n",
       "...                    ...  ...                    ...                   ...   \n",
       "18800                 1711  ...                      0                     0   \n",
       "44681                 1828  ...                      0                     0   \n",
       "208332                1510  ...                      0                     0   \n",
       "112202                  88  ...                  85543                 85543   \n",
       "175387                2406  ...                      0                     0   \n",
       "\n",
       "        PRIMARY_INSTAL_AMT  SEC_INSTAL_AMT  NEW_ACCTS_IN_LAST_SIX_MONTHS  \\\n",
       "1850                     0               0                             0   \n",
       "20434                    0               0                             0   \n",
       "55614                    0               0                             0   \n",
       "150207                   0               0                             0   \n",
       "195787                   0               0                             0   \n",
       "...                    ...             ...                           ...   \n",
       "18800                12361               0                             2   \n",
       "44681                 1565               0                             2   \n",
       "208332                   0               0                             0   \n",
       "112202                   0            7373                             2   \n",
       "175387                2372               0                             1   \n",
       "\n",
       "        DELINQUENT_ACCTS_IN_LAST_SIX_MONTHS  AVERAGE_ACCT_AGE  \\\n",
       "1850                                      0              0.00   \n",
       "20434                                     0              0.00   \n",
       "55614                                     0              0.11   \n",
       "150207                                    0              0.00   \n",
       "195787                                    0              0.00   \n",
       "...                                     ...               ...   \n",
       "18800                                     0              0.10   \n",
       "44681                                     0              0.90   \n",
       "208332                                    0              0.00   \n",
       "112202                                    0              1.40   \n",
       "175387                                    0              1.10   \n",
       "\n",
       "        CREDIT_HISTORY_LENGTH  NO_OF_INQUIRIES  LOAN_DEFAULT  \n",
       "1850                      0.0                0             1  \n",
       "20434                     0.0                0             0  \n",
       "55614                     1.0                0             0  \n",
       "150207                    0.0                1             1  \n",
       "195787                    0.0                0             0  \n",
       "...                       ...              ...           ...  \n",
       "18800                     0.2                1             0  \n",
       "44681                     2.1                0             0  \n",
       "208332                    0.0                0             1  \n",
       "112202                    3.0                0             0  \n",
       "175387                    2.1                0             0  \n",
       "\n",
       "[233154 rows x 38 columns]"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#df[\"EMPLOYMENT_TYPE\"].fillna(\"None\", inplace = True)\n",
    "new_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "id": "bfaea3ee",
   "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>AVERAGE_ACCT_AGE</th>\n",
       "      <th>CREDIT_HISTORY_LENGTH</th>\n",
       "      <th>DATE_OF_BIRTH</th>\n",
       "      <th>EMPLOYMENT_TYPE_Salaried</th>\n",
       "      <th>EMPLOYMENT_TYPE_Self employed</th>\n",
       "      <th>DISBURSED_AMOUNT</th>\n",
       "      <th>ASSET_COST</th>\n",
       "      <th>LTV</th>\n",
       "      <th>MANUFACTURER_ID</th>\n",
       "      <th>CURRENT_PINCODE_ID</th>\n",
       "      <th>...</th>\n",
       "      <th>SEC_SANCTIONED_AMOUNT</th>\n",
       "      <th>SEC_DISBURSED_AMOUNT</th>\n",
       "      <th>PRIMARY_INSTAL_AMT</th>\n",
       "      <th>SEC_INSTAL_AMT</th>\n",
       "      <th>NEW_ACCTS_IN_LAST_SIX_MONTHS</th>\n",
       "      <th>DELINQUENT_ACCTS_IN_LAST_SIX_MONTHS</th>\n",
       "      <th>AVERAGE_ACCT_AGE</th>\n",
       "      <th>CREDIT_HISTORY_LENGTH</th>\n",
       "      <th>NO_OF_INQUIRIES</th>\n",
       "      <th>LOAN_DEFAULT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>67970</th>\n",
       "      <td>0.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>1993</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>53139</td>\n",
       "      <td>101518</td>\n",
       "      <td>55.16</td>\n",
       "      <td>86</td>\n",
       "      <td>2686</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>11860</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1.9</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147741</th>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1993</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>57259</td>\n",
       "      <td>68684</td>\n",
       "      <td>84.44</td>\n",
       "      <td>86</td>\n",
       "      <td>2991</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1797</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.9</td>\n",
       "      <td>0.9</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12802</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1991</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>50203</td>\n",
       "      <td>68880</td>\n",
       "      <td>74.77</td>\n",
       "      <td>45</td>\n",
       "      <td>1512</td>\n",
       "      <td>...</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.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69632</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1997</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>52078</td>\n",
       "      <td>70193</td>\n",
       "      <td>76.22</td>\n",
       "      <td>86</td>\n",
       "      <td>1730</td>\n",
       "      <td>...</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.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105732</th>\n",
       "      <td>0.7</td>\n",
       "      <td>0.8</td>\n",
       "      <td>1996</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>52479</td>\n",
       "      <td>72679</td>\n",
       "      <td>77.05</td>\n",
       "      <td>86</td>\n",
       "      <td>3392</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>17032</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0.7</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 38 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        AVERAGE_ACCT_AGE  CREDIT_HISTORY_LENGTH  DATE_OF_BIRTH  \\\n",
       "67970                0.8                    1.9           1993   \n",
       "147741               0.9                    0.9           1993   \n",
       "12802                0.0                    0.0           1991   \n",
       "69632                0.0                    0.0           1997   \n",
       "105732               0.7                    0.8           1996   \n",
       "\n",
       "        EMPLOYMENT_TYPE_Salaried  EMPLOYMENT_TYPE_Self employed  \\\n",
       "67970                          1                              0   \n",
       "147741                         1                              0   \n",
       "12802                          1                              0   \n",
       "69632                          1                              0   \n",
       "105732                         1                              0   \n",
       "\n",
       "        DISBURSED_AMOUNT  ASSET_COST    LTV  MANUFACTURER_ID  \\\n",
       "67970              53139      101518  55.16               86   \n",
       "147741             57259       68684  84.44               86   \n",
       "12802              50203       68880  74.77               45   \n",
       "69632              52078       70193  76.22               86   \n",
       "105732             52479       72679  77.05               86   \n",
       "\n",
       "        CURRENT_PINCODE_ID  ...  SEC_SANCTIONED_AMOUNT  SEC_DISBURSED_AMOUNT  \\\n",
       "67970                 2686  ...                      0                     0   \n",
       "147741                2991  ...                      0                     0   \n",
       "12802                 1512  ...                      0                     0   \n",
       "69632                 1730  ...                      0                     0   \n",
       "105732                3392  ...                      0                     0   \n",
       "\n",
       "        PRIMARY_INSTAL_AMT  SEC_INSTAL_AMT  NEW_ACCTS_IN_LAST_SIX_MONTHS  \\\n",
       "67970                11860               0                             3   \n",
       "147741                1797               0                             0   \n",
       "12802                    0               0                             0   \n",
       "69632                    0               0                             0   \n",
       "105732               17032               0                             0   \n",
       "\n",
       "        DELINQUENT_ACCTS_IN_LAST_SIX_MONTHS  AVERAGE_ACCT_AGE  \\\n",
       "67970                                     0               0.8   \n",
       "147741                                    1               0.9   \n",
       "12802                                     0               0.0   \n",
       "69632                                     0               0.0   \n",
       "105732                                    1               0.7   \n",
       "\n",
       "        CREDIT_HISTORY_LENGTH  NO_OF_INQUIRIES  LOAN_DEFAULT  \n",
       "67970                     1.9                2             0  \n",
       "147741                    0.9                1             0  \n",
       "12802                     0.0                0             1  \n",
       "69632                     0.0                0             1  \n",
       "105732                    0.8                0             0  \n",
       "\n",
       "[5 rows x 38 columns]"
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Over sampling to resolve imbalance\n",
    "df = df.sample(frac=1)\n",
    "loan_default_1 = new_df.loc[df['LOAN_DEFAULT'] == 1]\n",
    "loan_default_0 = new_df.loc[df['LOAN_DEFAULT'] == 0]\n",
    "\n",
    "normal_distributed_df = pd.concat([loan_default_1, loan_default_1, loan_default_1, loan_default_0])\n",
    "\n",
    "# Shuffle dataframe rows\n",
    "new_df = normal_distributed_df.sample(frac=1, random_state=42)\n",
    "new_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "id": "ab343fd3",
   "metadata": {},
   "outputs": [],
   "source": [
    "X = new_df.drop('LOAN_DEFAULT', axis=1)\n",
    "y = new_df['LOAN_DEFAULT'].copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "id": "3bf4c78c-b96f-4318-889a-e2be338df47b",
   "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.25, random_state = 42)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "id": "95b004fc-a2fd-4c01-81d0-1189c2744cf7",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "X_train size:  (250782, 37)\n",
      "X_test size:  (83594, 37)\n"
     ]
    }
   ],
   "source": [
    "print(\"X_train size: \", X_train.shape)\n",
    "print(\"X_test size: \", X_test.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "id": "bcde3c6b-057c-4ecb-9824-2c167d0a60ee",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Model accuracy score with 100 decision-trees : 0.9248\n"
     ]
    }
   ],
   "source": [
    "# import Random Forest classifier\n",
    "\n",
    "from sklearn.ensemble import RandomForestClassifier\n",
    "\n",
    "# instantiate the classifier \n",
    "\n",
    "rfc = RandomForestClassifier(random_state=42)\n",
    "\n",
    "# fit the model\n",
    "\n",
    "rfc.fit(X_train, y_train)\n",
    "\n",
    "# Predict the Test set results\n",
    "\n",
    "y_pred = rfc.predict(X_test)\n",
    "\n",
    "# Check accuracy score \n",
    "\n",
    "from sklearn.metrics import accuracy_score\n",
    "\n",
    "print('Model accuracy score with 100 decision-trees : {0:0.4f}'. format(accuracy_score(y_test, y_pred)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "id": "a6a79a85-a4c2-4a8e-96cd-7828ef934d47",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAVgAAAEGCAYAAAAg6I3HAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/YYfK9AAAACXBIWXMAAAsTAAALEwEAmpwYAAAokElEQVR4nO3deZhU1Z3/8feHbvZNVkVAQcEFjaIY4hJXHDUmGXVGJ6hRZsIENSQmE52MOibRZMjoL3E0JsHELaJZFLdojEYd1BgzKKJBURTtKAKKsoogWy/f3x/3tBRtd3U1dHXR3Z/X89ynb506595TNHw5de5ZFBGYmVnz61DqCpiZtVUOsGZmReIAa2ZWJA6wZmZF4gBrZlYk5aWuQDH071sWw4Z2LHU1rAlef7lnqatgTfRB9fLlETFgW65x/NHdY8XK6oLyPvfixocj4oRtuV9La5MBdtjQjsx6eGipq2FNcOI+R5e6CtZED6+84a1tvcbyldU88/CQgvJ2HPS3/tt6v5bWJgOsmbUWQXXUlLoSReMAa2YlE0ANbXeykwOsmZVUDW7Bmpk1uyCobMNdBB6mZWYlE0A1UdBRCEllkv4q6YH0uq+kRyW9nn72ycl7saQKSfMlHZ+TPkbS3PTetZKU0jtLuiOlPyNpWGP1cYA1s5KqIQo6CvR14JWc1xcBMyJiJDAjvUbSKGA8sA9wAjBVUlkqcx0wCRiZjtqhYROBVRExArgauLKxyjjAmlnJBFAdUdDRGElDgM8CN+YknwRMS+fTgJNz0m+PiI0R8SZQAYyVNAjoFREzI1tq8NY6ZWqvdRcwrrZ12xAHWDMrqZoCD6C/pNk5x6Q6l7oG+Nbm7ADsGBFLANLPgSl9MLAoJ9/ilDY4nddN36JMRFQBq4F++T6bH3KZWclEE/pXgeURcVB9b0j6HLA0Ip6TdFQB16qv5Rl50vOVaZADrJmVTARUNs8w2MOAv5d0ItAF6CXpV8B7kgZFxJL09X9pyr8YyJ3uOQR4J6UPqSc9t8xiSeVAb2Blvkq5i8DMSkhUF3jkExEXR8SQiBhG9vDqsYj4InA/MCFlmwDcl87vB8ankQHDyR5mzUrdCGskHZz6V8+uU6b2Wqeme7gFa2bbpwBqijuR6wpguqSJwELgNICIeFnSdGAeUAVMjojaVWfOA24BugIPpQPgJuA2SRVkLdfxjd3cAdbMSqqx1mlTRcQTwBPpfAUwroF8U4Ap9aTPBvatJ30DKUAXygHWzEomm2jQvAF2e+IAa2YlE0BltN1HQQ6wZlYygahuw8/aHWDNrKRqwl0EZmbNzn2wZmZFI6rdB2tm1vyyHQ0cYM3Mml2E2BRljWdspRxgzaykatwHa2bW/LKHXO4iMDMrAj/kMjMrCj/kMjMrompPNDAza36BqIy2G4ba7iczs+2eH3KZmRVJIHcRmJkVix9ymZkVQQQepmVmVgzZQ662O1W27f7XYWatQjUdCjrykdRF0ixJL0h6WdLlKf0ySW9LmpOOE3PKXCypQtJ8ScfnpI+RNDe9d23aXZa0A+0dKf0ZScMa+2xuwZpZyQRqrgW3NwLHRMRaSR2BpyTV7gZ7dUT8KDezpFFku8LuA+wM/K+kPdLOstcBk4CngQeBE8h2lp0IrIqIEZLGA1cCX8hXKbdgzaykmqMFG5m16WXHdOTbEPwk4PaI2BgRbwIVwFhJg4BeETEzIgK4FTg5p8y0dH4XMK62ddsQB1gzK5kAaqJDQQfQX9LsnGNS7rUklUmaAywFHo2IZ9JbX5X0oqSbJfVJaYOBRTnFF6e0wem8bvoWZSKiClgN9Mv3+RxgzayERHWBB7A8Ig7KOa7PvVJEVEfEaGAIWWt0X7Kv+7sDo4ElwFUf3fjjIk96vjINcoA1s5LJtu0uK+go+JoR7wNPACdExHsp8NYANwBjU7bFwNCcYkOAd1L6kHrStygjqRzoDazMVxcHWDMrmQg1pYugQZIGSNohnXcFjgVeTX2qtU4BXkrn9wPj08iA4cBIYFZELAHWSDo49a+eDdyXU2ZCOj8VeCz10zbIowjMrKSaaaLBIGCapDKyhuP0iHhA0m2SRpM1lhcA5wBExMuSpgPzgCpgchpBAHAecAvQlWz0QO1ohJuA2yRVkLVcxzdWKQdYMyuZbD3YbR+mFREvAgfUk35WnjJTgCn1pM8G9q0nfQNwWlPq5QBrZiXkHQ3MzIoiG6bl1bTMzJpdW1+LwAHWzErKyxWamRVBtlyhuwjMzIrCfbBmZkWQrablLgIzs2aXTZVtuwG27X6y7Vx1NXzl7/bg22cPB+DJ3/fmy0ftyQmD9+e1F7p+lO/dRZ34/G77cd6xe3LesXvy4//YPE368Xt34Jxj9uTccXtyyRm7sXpF9jR27tPdmXzcHnxm6P78+YHeLfvB2okOHYKf3DWby372IgCfPm4p1903iwfmPsHIfT74KN8Bh6zkx9NnM/XeZ/nx9Nns/6lVH7vWd346l6m/m9VSVd/ONM9U2e1V0VqwkqqBuTlJJ0fEggbyro2IHsWqy/bodzcOYOjIjaxbm/3FGbbXBr5z4wKu/Y+hH8s7aNeNXPe/87dIq66C674zmBueeJXe/aq58fuDuP+XAzjrwncZMLiSC65ZyF0/H9gin6U9OumsxSx6oxvdulcB8FZFd/7r6/vyte9u+Xtavaojl0/+BCuXdWbXEWv5/vUvcvYxh370/qHHLmPDurY7TKkQzTGTa3tVzP8W1kfE6JxjQRHv1aose6cjs2b04jNnrPgobZeRGxk6YmPB14gAQmxY34EI+HBtGf12qgRgp6Gb2G3UBjq0zv/0t3v9dtzAJ49YwcN3b15HZNEb3Xl7QbeP5X3j1Z6sXNYZyIJwp841lHesAaBLtypOmbCI3/5i15ap+HaodhRBIUdr1GL/BCX1kDRD0vNpv5uT6skzSNKTae+clyQdntKPkzQzlb1TUqtu7f78u4P510vfQQX+6b+7sBNf+bs9uPAfRjD3me4AlHeEr12xiHOP2YszDtiHha914fjTVzRyJWsO51xUwc1X7U5NTdPKHXbcMv72Sg+qKrNf/FlfW8A9twxl4/r2/T9hW+4iKGatu+ZsNHYvsAE4JSIOBI4Grqpnu4UzgIfTorn7A3Mk9QcuBY5NZWcD36x7M0mTalc6X7aiuu7b242nH+3FDv2rGLnf+oLy9x1Yya+encfUR1/jnMve5oqv7MqHazpQVQkP3Nqfnz0yn9/89WWG772eO36yY5Frb2OPXM77KztRMa9nk8rtsvuHfOnf3uAnl+8JwG57rWHnXdYzc8aAYlSz1ajdk6uQozUq5iiC9SlQApA2IvuBpCOAGrLtF3YE3s0p8yxwc8r7u4iYI+lIYBTwlxSPOwEz694srW5+PcBB+3fJu0ZjKc17tjtPP9KLZ2eMYtNGsW5NGVd+dRf+46cL683fqXPQqXP2H8bI/daz87BNvP1GZ2pXodx52CYAjvz797njpw6wxTbqgA84+KjlfPLwFXTsXEO37tVceMU8fnTRqAbL9NtxA9++9iWuumRv3l2UPcDca/8PGDFqDb98ZCZlZUHvfpVc8cu/ctG/fGxBqDYtgKpW2jotREsO0zoTGACMiYhKSQuALrkZIuLJFIA/S7bu4g+BVWT765zegnUtmi9dsoQvXbIEgBf+rwd3/XxAg8EV4P0VZfTcoZqyMljyVifefrMTO+2yicqNYuFrXXh/RRk79Kvm+Sd7MnTkhpb6GO3WLdfsxi3X7AbAJz65in/850V5g2v3npVcft1cbrlmN+b9dfOIjgfvGMyDd2RbPQ3ceT2XTZ3b7oJrrdb69b8QLRlgewNLU3A9GvhYz76kXYG3I+IGSd2BA8nWa/yZpBERUSGpGzAkIl5rwboX3V8e6s3USwezekU53z5rN3bfZz0/+O0bzH26B7f+cCfKyqGsQ3D+FYvp1Sdr0Z75zXe58JSRlHcMBg7exIXXZIF6/pyufG/icNa8X8bTj/bi1h/txA1PzM93e9tGh4xbxnmXvE7vvpVcNnUub8zvwbcn7c/nz3ibnYeuZ/y5Cxh/7gIALv3y/qxe2am0Fd5etOKv/4VQIzsebP2F6wy9Sn2pvyfbTncOcBjwmYhYUJtX0gTg34FKYC1wdkS8KekYsj3IO6fLXRoR9zd074P27xKzHv74cCfbfp24z9GlroI10cMrb3guIg7almv02WtgHHPzqQXlveew67b5fi2taC3YuuNaI2I5cEi+vBExjc37jue+/xjwySJU08xKrC23YNtu54eZbfdqF9ze1lEEkrpImiXpBUkvS7o8pfeV9Kik19PPPjllLpZUIWm+pONz0sekoaQVkq6tHe2UNki8I6U/I2lYY5/PAdbMSiYQVTUdCjoasRE4JiL2B0YDJ0g6GLgImBERI4EZ6TWSRpFtWrgPcAIwNW2YCHAdMIlsp9mR6X2AicCqiBgBXE3WbZmXA6yZlVQNKujIJzJr08uO6QjgJDZ3O04DTk7nJwG3R8TGiHgTqADGpm2+e0XEzLQl9611ytRe6y5gXD1j+bfgAGtmpRNN6iLoXzuZKB2Tci8lqUzSHGAp2dDOZ4AdI2IJQPpZu0DHYGBRTvHFKW1wOq+bvkWZiKgCVgP98n08L1doZiXTxE0Pl+cbRRAR1cBoSTsA90r62NbbOeq7aeRJz1emQW7BmllJNfdU2Yh4H3iCrO/0vfS1n/Rzacq2GMgdyzkEeCelD6knfYsyksrJxvavzFcXB1gzK5lAVNd0KOjIR9KA1HJFUlfgWOBV4H5gQso2Abgvnd8PjE8jA4aTPcyalboR1kg6OPWvnl2nTO21TgUei0YmEriLwMxKqpnWgx0ETEsjAToA0yPiAUkzgemSJgILgdMAIuJlSdOBeUAVMDl1MQCcB9wCdAUeSgfATWRT+CvIWq7jG6uUA6yZlUxE80w0iIgXgY8t5hARK4BxDZSZQjYVv276bOBj/bcRsYEUoAvlAGtmJRVteCaXA6yZlVDbXuzFAdbMSsotWDOzIoiA6hoHWDOzomjLu8o6wJpZyQTuIjAzKxI/5DIzK5oibaqyXXCANbOScheBmVkRZKMI2u6SKA6wZlZS7iIwMysSdxGYmRVBIAdYM7NiacM9BA6wZlZCAeGpsmZmxeEuAjOzImmXowgk/YQ83SMRcX5RamRm7UZ7XotgdovVwszapwDaY4CNiGm5ryV1j4gPi18lM2tPmqOLQNJQ4FZgJ6AGuD4ifizpMuDLwLKU9ZKIeDCVuRiYCFQD50fEwyl9DJs3PXwQ+HpEhKTO6R5jgBXAFyJiQb56NTpHTdIhkuYBr6TX+0uaWvhHNzNriIiawo5GVAEXRMTewMHAZEmj0ntXR8TodNQG11Fku8LuA5wATE070gJcB0wi28p7ZHofsmC8KiJGAFcDVzZWqUImAV8DHE8WsYmIF4AjCihnZta4KPDId4mIJRHxfDpfQ9YgHJynyEnA7RGxMSLeBCqAsZIGAb0iYmZEBFmL9eScMrXf7O8CxknKG/kLWmUhIhbVSaquN6OZWVNE9pCrkAPoL2l2zjGpvktKGka2hfczKemrkl6UdLOkPiltMJAb1xantMHpvG76FmUiogpYDfTL9/EKCbCLJB0KhKROki4kdReYmW2zwluwyyPioJzj+rqXktQDuBv4RkR8QPZ1f3dgNLAEuKo2awM1aSg9X5kGFRJgzwUmk0Xvt1NFJxdQzsysACrwaOQqUkey4PrriLgHICLei4jqiKgBbgDGpuyLgaE5xYcA76T0IfWkb1FGUjnQG1iZr06NBtiIWB4RZ0bEjhExICK+GBErGitnZlaQmgKPPFJf6E3AKxHxPznpg3KynQK8lM7vB8ZL6ixpONnDrFkRsQRYI+ngdM2zgftyykxI56cCj6V+2gY1OpNL0m7Aj8mezAUwE/i3iHijsbJmZnk13zjYw4CzgLmS5qS0S4DTJY1Od1oAnAMQES9Lmg7MIxuBMDkiap8tncfmYVoPpQOyAH6bpAqyluv4xipVyFTZ3wA/I4v+pIv+FvhUAWXNzPJqjnGwEfEU9fcjPJinzBRgSj3ps4F960nfAJzWlHoV0geriLgtIqrS8Sva9gpjZtaSmmGY1vYq31oEfdPp45IuAm4n+5hfAP7QAnUzs/agPU6VBZ5jy2EL5+S8F8D3i1UpM2s/1Epbp4XItxbB8JasiJm1QyFo7wtuS9oXGAV0qU2LiFuLVSkza0faYwu2lqTvAkeRBdgHgc8AT5HN0TUz2zZtOMAWMorgVGAc8G5E/AuwP9C5qLUys/ajPY4iyLE+ImokVUnqBSwFdityvcysPWivC27nmC1pB7J5vM8Ba4FZxayUmbUf7XIUQa2I+Eo6/bmkP5KtlfhicatlZu1Gewywkg7M917t4rZmZtuivbZgr8rzXgDHNHNdms1rL3bj+J1Hl7oa1gT/9IqXGG5tHt6rmS7UHvtgI+LolqyImbVDrXiEQCEKmmhgZlY0DrBmZsWhRhbTbs0cYM2stNpwC7bRmVzKfFHSd9LrXSSNbaycmVljFIUfrVEhU2WnAocAp6fXa8h2ODAz23ahwo5WqJAA+6mImAxsAIiIVUCnotbKzNqPZliLQNJQSY9LekXSy5K+ntL7SnpU0uvpZ5+cMhdLqpA0X9LxOeljJM1N712bNj8kbZB4R0p/RtKwxj5aIQG2UlJZ7UeUNIBG93g0MytMM3URVAEXRMTeZBu0TpY0CrgImBERI4EZ6TXpvfHAPsAJwNQU5wCuAyaR7TQ7Mr0PMBFYFREjgKuBKxurVCEB9lrgXmCgpClkSxX+oIByZmb5RTaKoJAj72UiltTOLo2INcArwGDgJGBayjYNODmdnwTcHhEbI+JNoAIYm7b57hURM9OW3LfWKVN7rbuAcbWt24YUshbBryU9R7ZkoYCTI8LTbsyseRT+AKu/pNk5r6+PiOvrZkpf3Q8AngF2jIglkAVhSQNTtsHA0znFFqe0ynReN722zKJ0rSpJq4F+wPKGKlzIgtu7AOuA3+emRcTCxsqamTWq8AC7PCIOypdBUg/gbuAbEfFBngZmfW9EnvR8ZRpUyDjYP+TcuAswHJhP1ndhZrZNmmsIlqSOZMH11xFxT0p+T9Kg1HodRLaeNWQt06E5xYcA76T0IfWk55ZZLKkc6A2szFenRvtgI+ITEbFf+jkSGEvWD2tmtl1IfaE3Aa9ExP/kvHU/MCGdTwDuy0kfn0YGDCd7mDUrdSeskXRwuubZdcrUXutU4LHUT9ugJs/kiojnJX2yqeXMzOrVPC3Yw4CzgLmS5qS0S4ArgOmSJgILgdMAIuJlSdOBeWQjECZHRHUqdx5wC9AVeCgdkAXw2yRVkLVcxzdWqUL6YL+Z87IDcCCwrLFyZmaNiuZZiyAinqL+PlLIHtDXV2YKMKWe9NnAvvWkbyAF6EIV0oLtmXNeRdYne3dTbmJm1qBWOg22EHkDbBp42yMi/r2F6mNm7YhovesMFCLfljHlaaxXg1vHmJlts/YYYMl2jj0QmCPpfuBO4MPaN3OGQZiZbZ1WvFJWIQrpg+0LrCDbg6t2PGwADrBmtu3a8Mom+QLswDSC4CU+PsOhDf+fY2Ytqb22YMuAHmzF9DAzs4K14WiSL8AuiYjvtVhNzKz9ace7yrbOJcTNrFVpr10E9c5+MDNrVu0xwEZE3lVizMyag7ftNjMrhnbcB2tmVlSibT/scYA1s9JyC9bMrDja6ygCM7Pic4A1MyuCZlpwe3vlAGtmpeUWrJlZcbTlPthGd5U1MyuqKPBohKSbJS2V9FJO2mWS3pY0Jx0n5rx3saQKSfMlHZ+TPkbS3PTetWl3WdIOtHek9GckDWusTg6wZlZSisKOAtwCnFBP+tURMTodDwJIGkW2K+w+qczUtEUWwHXAJLKtvEfmXHMisCoiRgBXA1c2ViEHWDMrnSBbcLuQo7FLRTxJtp12IU4Cbo+IjRHxJlABjJU0COgVETMjIoBbgZNzykxL53cB42pbtw1xgDWzkqnd9LDAFmx/SbNzjkkF3uarkl5MXQh9UtpgYFFOnsUpbXA6r5u+RZmIqAJWA/3y3dgB1sxKq/A+2OURcVDOcX0BV78O2B0YDSwBrkrpDW0kkG+DgSZvPuAAa2YlpYiCjq0REe9FRHVE1AA3AGPTW4uBoTlZhwDvpPQh9aRvUUZSOdCbRrokHGDNrHQKbb1u5VCu1Kda6xSyPQYB7gfGp5EBw8keZs2KiCXAGkkHp/7Vs4H7cspMSOenAo+lftoGeRysmZVUc42DlfRb4CiyvtrFwHeBoySNJgvRC4BzACLiZUnTgXlAFTA5IqrTpc4jG5HQFXgoHQA3AbdJqiBruY5vrE4OsGZWUs01VTYiTq8n+aY8+acAU+pJnw3sW0/6BuC0ptTJAdbMSqsNz+RygDWz0il8EkGr5ABrZqXlAGtm1vxqJxq0VQ6wZlZSqmm7EdYB1sxKx7vKWjEN2HkT//7jhfQZWEXUwIO/6sfvbhrA4Z97n7MueJehIzdy/okjef3Fbh+VGb73es6/cjHde1ZTUyO+duJIKjd2oLxjDZOnvM1+h6wlQtxyxU489eAOpftwbUT1Rnj8rL5UbxJRBUOO38i+X1vLSz/twZt3dqVz32yc0Se+sYZBR27ird93Yf7N3T8q//78cv7u7hX0HFbFzG/swNpF5ahDsPPRG9nvgrUAVNzelb/9phsqg/JuwZjLV9N7RHW99WlrvKPBNpLUD5iRXu4EVAPL0uuxEbGpJeqxPaquEtd/b2cq5naja/dqfvrH13j+yZ4seLUL3/vXYZx/5eIt8ncoC771k4X88PxdeGNeV3r2qaK6MpsiffrXl/L+8nImHr43UtCzT/v4B1psHTrBkb9cRcfuQU0lPPbFvgw6vCMAIyd8yF5fWrdF/l0/v4FdP78BgPdfK+cvk3egz95VVK2HPb+0joGf2kT1JvjTl/qy5MlODDpiE7t+bgMjxq8H4O3HOvPClb044oZVLftBS8Ut2G0TESvIFltA0mXA2oj4Ue37ksrT6jTtzsqlHVm5NPvHuv7DMhZVdKH/oEqef7JnvfnHHLmGN1/pwhvzugKwZtXmX+Hx41cy8fA9AYgQH6z0F5TmIEHH7lkUqKmCmkrVv+xHPRb+oQu7fDYLtuVdYeCnsrZEWSfoM6qSde9mS5B27LE5ylSvL/z6bYEfchWBpFvIppsdADwvaQ05gTetSv65iFgg6YvA+UAn4BngKznT2tqMHYdsYvd91/Pq890azDNkt41EiCm/+Ru9+1Xzp/t24M6pA+neK/vjmPCtd9nv0A9ZsqATP/vPwby/vGNLVb9Nq6mG/z21H2sXlrH76evot38lS/7cmYpfd+et+7rSZ99KRn9rDZ16bxktFj3UhU//9P2PXW/TB+Kdxzsz8qzNrd/Xf92N16Z1o6ZSHPXLQpc1beUC2MqFXFqDUi/2sgdwbERc0FAGSXsDXwAOi4jRZN0LZ9aTb1LtOpGVbCxWfYumS7dqvn3jAn7+nZ1Zt7aswXxl5cG+Yz/kyq/uygUnj+DQE1Yz+tNrKCsPBuxcybxnu/PV4/fglee68+XvLGnBT9C2dSiD4+5dweceX8bKuR1Z/Vo5I8av48RHlnHcvSvoOqCGOf9vy28dK17oSHmXoPceW345q6mCpy/cgZFfXEePoZvbCSPPXMdnH1nOfhesYd7Pe7TI59oeqKawozUqdYC9s4CW6DhgDPCspDnp9W51M0XE9bXrRHakc/PXtIjKyoNv37iAx+7pw18e2iFv3mVLOvLizO58sLKcjes78OxjvRjxifV8sLKMDes68JeHegPw5wd6M/IT6/Jey5quU69g4NhNLHmqE13619ChDNQBdjttPStf3PLbwsIHuzA0dQ/kmv3dXvTYtYo9JtT/+9nlxA28M6N1/R3eWk1ccLvVKXWA/TDnvIot69Ml/RQwLWdPnT0j4rKWqmDxBd+8ahGLXu/CPdcPaDT3c0/0ZPioDXTuWkOHsmC/Q9ay8LUugHj60V7sd2j2VHr0p9fy1mtd8l/MCrJhpdj0QdYpWrUB3pvZmV7Dq1m/dPNf18WPdqb3yM0t1aiBxQ93YZcTtwywc6/pQeWaDhxw8Zot0tcs2PytZcmfOtNj1zbXA1a/iMKPVmh7egqyAPgcgKQDgeEpfQZwn6SrI2KppL5Az4h4qzTVbF77jP2QY09bxRvzujD10fkA/PK/B9GxU/CV/3qb3v2q+P5tb/K3l7vwn2fsztrV5dzziwH85MHXiBCzHuvJrBm9ALjpvwbxrZ8s5NzL32H1inKu+ubQfLe2Am1YVsasi3sT1VngHHrCBnY+eiPPfKs3779aDoLug6sZc9kHH5VZNrsTXXes3qILYN27HXjlFz3ouVsVj/5jttPIiDPWsdtp66n4TTfe+79OdOgIHXvVMPa/V7f45yyV1to6LYQaWS+2+W+YRhGQLQf2QETcldK7ki1sOxB4Fvg08Jn0kOsLwMVkLdxKsrUbn27oHr3UNz6lcUX9HNa8/umVd0tdBWuiSXs99VxEHLQt1+i5w5A44IivF5T3z7//1jbfr6W1eAu2oa/3EbEeOK6B9+4A7ihitcysRNpyC3Z76iIws/YmgOq2G2EdYM2spNpyC7bUowjMrL1rplEEkm6WtDRNUqpN6yvpUUmvp599ct67WFKFpPmSjs9JHyNpbnrv2rT5IWmDxDtS+jOShjVWJwdYMyupZhwHewtwQp20i4AZETGSbETSRQCSRpFtWrhPKjNVUu1YueuASWQ7zY7MueZEYFVEjACuBq5srEIOsGZWOs24bXdEPEk2/T7XScC0dD4NODkn/faI2BgRbwIVwNi0zXeviJiZtuS+tU6Z2mvdBYyrbd02xH2wZlYyAlTch1w7RsQSgIhYImlgSh8M5A71XJzSKtN53fTaMovStaokrQb6AcsburkDrJmVlAofi99f0uyc19dHxPVbe9t60iJPer4yDXKANbPSadqOBsu3YqLBe5IGpdbrIGBpSl8M5E51HAK8k9KH1JOeW2axpHKgNx/vktiC+2DNrISKvhbB/cCEdD6BbLZobfr4NDJgONnDrFmpO2GNpINT/+rZdcrUXutU4LFoZCqsW7BmVlLNNQ5W0m+Bo8i6EhYD3wWuAKZLmggsBE4DiIiXJU0H5pEtNDU5Z2W/88hGJHQFHkoHwE3AbZIqyFqu4xurkwOsmZVWM62HEhGnN/BWvQuTRMQUYEo96bPJ1kqpm76BFKAL5QBrZqUTRR9FUFIOsGZWWm03vjrAmllpNWGYVqvjAGtmpeUAa2ZWBAG00g0NC+EAa2YlI8JdBGZmRVPTdpuwDrBmVjruIjAzKx53EZiZFYsDrJlZMWzTQi7bPQdYMysd7yprZlY87oM1MysWB1gzsyIIoMYB1sysCPyQy8yseBxgzcyKIIDqtjuVywHWzEooINpugPWusmZWWs20q6ykBZLmSpojaXZK6yvpUUmvp599cvJfLKlC0nxJx+ekj0nXqZB0bdpddqs4wJpZ6dSOIijkKMzRETE6Ig5Kry8CZkTESGBGeo2kUWS7wu4DnABMlVSWylwHTCLbyntken+rOMCaWWk1Uwu2AScB09L5NODknPTbI2JjRLwJVABjJQ0CekXEzIgI4NacMk3mAGtmpVV4gO0vaXbOManulYBHJD2X896OEbEku00sAQam9MHAopyyi1Pa4HReN32r+CGXmZVOBFRXF5p7ec5X//ocFhHvSBoIPCrp1Tx56+tXjTzpW8UtWDMrrWbqIoiId9LPpcC9wFjgvfS1n/Rzacq+GBiaU3wI8E5KH1JP+lZxgDWz0mqGACupu6SetefAccBLwP3AhJRtAnBfOr8fGC+ps6ThZA+zZqVuhDWSDk6jB87OKdNk7iIwsxJq0giBfHYE7k0jqsqB30TEHyU9C0yXNBFYCJwGEBEvS5oOzAOqgMkRUdtXcR5wC9AVeCgdW8UB1sxKJyCaYaJBRLwB7F9P+gpgXANlpgBT6kmfDey7zZXCAdbMSs1TZc3MiiDC23abmRWNV9MyMyuOcAvWzKwYvOC2mVlxeMsYM7PiCCAKnyrb6jjAmlnpRNtecNsB1sxKKtxFYGZWJG24Batog0/wJC0D3ip1PYqkP7C81JWwJmmrv7NdI2LAtlxA0h/J/nwKsTwitnp3gVJokwG2LZM0u5E1MW07499Z++XlCs3MisQB1sysSBxgW5/rS10BazL/ztop98GamRWJW7BmZkXiAGtmViSeaFBikqqBuTlJJ0fEggbyro2IHi1SMctLUj9gRnq5E1ANLEuvx0bEppJUzLYr7oMtsaYETQfY7ZOky4C1EfGjnLTyiKgqXa1se+Augu2MpB6SZkh6XtJcSSfVk2eQpCclzZH0kqTDU/pxkmamsndKcjBuQZJukfQ/kh4HrpR0maQLc95/SdKwdP5FSbPS7/AXkspKVW8rHgfY0uua/pHNkXQvsAE4JSIOBI4Grkr7s+c6A3g4IkaT7aQ5R1J/4FLg2FR2NvDNFvsUVmsPst/BBQ1lkLQ38AXgsPQ7rAbObJnqWUtyH2zprU//yACQ1BH4gaQjgBpgMNme7+/mlHkWuDnl/V1EzJF0JDAK+EuKx52AmS3zESzHnRHR2AKn44AxwLPpd9UVWFrsilnLc4Dd/pwJDADGRESlpAVAl9wMEfFkCsCfBW6T9ENgFfBoRJze0hW2LXyYc17Flt8Sa3+PAqZFxMUtVisrCXcRbH96A0tTcD0a2LVuBkm7pjw3ADcBBwJPA4dJGpHydJO0RwvW2z5uAdnvBkkHAsNT+gzgVEkD03t90+/U2hi3YLc/vwZ+L2k2MAd4tZ48RwH/LqkSWAucHRHLJP0z8FtJnVO+S4HXil5ja8jdwNmS5pB167wGEBHzJF0KPCKpA1AJTKbtLrHZbnmYlplZkbiLwMysSBxgzcyKxAHWzKxIHGDNzIrEAdbMrEgcYNspSdU5axncKanbNlzrFkmnpvMbJY3Kk/coSYduxT0WpOnABaXXybO2iffaYg0Bs63lANt+rY+I0RGxL7AJODf3za1dfCQi/jUi5uXJchTQ5ABr1ho5wBrAn4ERqXX5uKTfAHMllUn6oaRnJb0o6RwAZX4qaZ6kPwADay8k6QlJB6XzE9LKXi+kFcKGkQXyf0ut58MlDZB0d7rHs5IOS2X7SXpE0l8l/YJsemlekn4n6TlJL0uaVOe9q1JdZkgakNJ2l/THVObPkvZqlj9Ns8Qzudo5SeXAZ4A/pqSxwL4R8WYKUqsj4pNpdthfJD0CHADsCXyCbCGaecDNda47ALgBOCJdq29ErJT0c3LWTk3B/OqIeErSLsDDwN7Ad4GnIuJ7kj4LbBEwG/CldI+uZAup3B0RK4DuwPMRcYGk76Rrf5VsM8JzI+J1SZ8CpgLHbMUfo1m9HGDbr65pCidkLdibyL66z4qIN1P6ccB+tf2rZOskjASOAH6bVo16R9Jj9Vz/YODJ2mtFxMoG6nEsMCpnRcZeknqme/xDKvsHSasK+EznSzolnQ9NdV1BtirZHSn9V8A9ytbKPRS4M+fenTFrRg6w7dcWyyQCpECTuxqUgK9FxMN18p0INDbHWgXkgayb6pCIWF9PXQqexy3pKLJgfUhErJP0BHVWIcsR6b7v1/0zMGtO7oO1fB4GzkvrziJpD0ndgSeB8amPdhDZwuB1zQSOlDQ8le2b0tcAPXPyPUL2dZ2Ub3Q6fZK0CLWkzwB9Gqlrb2BVCq57kbWga3UAalvhZ5B1PXwAvCnptHQPSdq/kXuYNYkDrOVzI1n/6vOSXgJ+Qfat517gdbLNGq8D/lS3YEQsI+s3vUfSC2z+iv574JTah1zA+cBB6SHaPDaPZrgcOELS82RdFQsbqesfgXJJLwLfJ1u+sdaHwD6SniPrY/1eSj8TmJjq9zLwse15zLaFV9MyMysSt2DNzIrEAdbMrEgcYM3MisQB1sysSBxgzcyKxAHWzKxIHGDNzIrk/wOT9hUGFds22wAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 2 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "confusion_matrix = metrics.confusion_matrix(y_test, y_pred)\n",
    "cm_display = metrics.ConfusionMatrixDisplay(confusion_matrix = confusion_matrix, display_labels = [False, True])\n",
    "cm_display.plot()\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "id": "04b1cf8e-19dd-4381-b1c5-e407aebd6bb1",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "              precision    recall  f1-score   support\n",
      "\n",
      "           0       0.95      0.91      0.93     45705\n",
      "           1       0.90      0.94      0.92     37889\n",
      "\n",
      "    accuracy                           0.92     83594\n",
      "   macro avg       0.92      0.93      0.92     83594\n",
      "weighted avg       0.93      0.92      0.92     83594\n",
      "\n"
     ]
    }
   ],
   "source": [
    "from sklearn.metrics import classification_report\n",
    "print(classification_report(y_test, y_pred))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a7649027-92e9-40a2-a5c0-82b3d8b0036d",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}