cbt.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-06T02:06:52.697467Z",
     "start_time": "2020-11-06T02:06:52.139059Z"
    }
   },
   "outputs": [],
   "source": [
    "import catboost as cbt\n",
    "from sklearn.model_selection import StratifiedKFold\n",
    "from sklearn.metrics import roc_auc_score\n",
    "import warnings\n",
    "from sklearn.preprocessing import LabelEncoder\n",
    "import pandas as pd\n",
    "import gc\n",
    "import os\n",
    "\n",
    "warnings.simplefilter('ignore')\n",
    "%matplotlib inline\n",
    "\n",
    "pd.set_option('max_columns', None)\n",
    "pd.set_option('max_rows', None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-06T02:06:52.703700Z",
     "start_time": "2020-11-06T02:06:52.700715Z"
    }
   },
   "outputs": [],
   "source": [
    "seed = 2020"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-06T02:06:52.757616Z",
     "start_time": "2020-11-06T02:06:52.706043Z"
    }
   },
   "outputs": [],
   "source": [
    "# !pip install lightgbm"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-06T02:06:54.959831Z",
     "start_time": "2020-11-06T02:06:52.759986Z"
    }
   },
   "outputs": [],
   "source": [
    "df_feature = pd.read_pickle('data/feature.pkl')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-06T02:06:55.098327Z",
     "start_time": "2020-11-06T02:06:54.961528Z"
    }
   },
   "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>annualIncome</th>\n",
       "      <th>applicationType</th>\n",
       "      <th>delinquency_2years</th>\n",
       "      <th>dti</th>\n",
       "      <th>earliesCreditLine</th>\n",
       "      <th>employmentLength</th>\n",
       "      <th>employmentTitle</th>\n",
       "      <th>ficoRangeHigh</th>\n",
       "      <th>ficoRangeLow</th>\n",
       "      <th>grade</th>\n",
       "      <th>homeOwnership</th>\n",
       "      <th>id</th>\n",
       "      <th>initialListStatus</th>\n",
       "      <th>installment</th>\n",
       "      <th>interestRate</th>\n",
       "      <th>isDefault</th>\n",
       "      <th>issueDate</th>\n",
       "      <th>loanAmnt</th>\n",
       "      <th>n0</th>\n",
       "      <th>n1</th>\n",
       "      <th>n10</th>\n",
       "      <th>n11</th>\n",
       "      <th>n12</th>\n",
       "      <th>n13</th>\n",
       "      <th>n14</th>\n",
       "      <th>n2</th>\n",
       "      <th>n3</th>\n",
       "      <th>n4</th>\n",
       "      <th>n5</th>\n",
       "      <th>n6</th>\n",
       "      <th>n7</th>\n",
       "      <th>n8</th>\n",
       "      <th>n9</th>\n",
       "      <th>openAcc</th>\n",
       "      <th>postCode</th>\n",
       "      <th>pubRec</th>\n",
       "      <th>pubRecBankruptcies</th>\n",
       "      <th>purpose</th>\n",
       "      <th>regionCode</th>\n",
       "      <th>revolBal</th>\n",
       "      <th>revolUtil</th>\n",
       "      <th>subGrade</th>\n",
       "      <th>term</th>\n",
       "      <th>title</th>\n",
       "      <th>totalAcc</th>\n",
       "      <th>verificationStatus</th>\n",
       "      <th>issueDate_year</th>\n",
       "      <th>earliesCreditLine_year</th>\n",
       "      <th>issueDate_year_earliesCreditLine_year_minus</th>\n",
       "      <th>debt_ratio_year</th>\n",
       "      <th>applicationType_cnt</th>\n",
       "      <th>employmentLength_cnt</th>\n",
       "      <th>employmentTitle_cnt</th>\n",
       "      <th>grade_cnt</th>\n",
       "      <th>homeOwnership_cnt</th>\n",
       "      <th>initialListStatus_cnt</th>\n",
       "      <th>postCode_cnt</th>\n",
       "      <th>purpose_cnt</th>\n",
       "      <th>regionCode_cnt</th>\n",
       "      <th>subGrade_cnt</th>\n",
       "      <th>title_cnt</th>\n",
       "      <th>verificationStatus_cnt</th>\n",
       "      <th>applicationType_employmentLength_cnt</th>\n",
       "      <th>applicationType_employmentTitle_cnt</th>\n",
       "      <th>applicationType_grade_cnt</th>\n",
       "      <th>applicationType_homeOwnership_cnt</th>\n",
       "      <th>applicationType_initialListStatus_cnt</th>\n",
       "      <th>applicationType_postCode_cnt</th>\n",
       "      <th>applicationType_purpose_cnt</th>\n",
       "      <th>applicationType_regionCode_cnt</th>\n",
       "      <th>applicationType_subGrade_cnt</th>\n",
       "      <th>applicationType_title_cnt</th>\n",
       "      <th>applicationType_verificationStatus_cnt</th>\n",
       "      <th>employmentLength_applicationType_cnt</th>\n",
       "      <th>employmentLength_employmentTitle_cnt</th>\n",
       "      <th>employmentLength_grade_cnt</th>\n",
       "      <th>employmentLength_homeOwnership_cnt</th>\n",
       "      <th>employmentLength_initialListStatus_cnt</th>\n",
       "      <th>employmentLength_postCode_cnt</th>\n",
       "      <th>employmentLength_purpose_cnt</th>\n",
       "      <th>employmentLength_regionCode_cnt</th>\n",
       "      <th>employmentLength_subGrade_cnt</th>\n",
       "      <th>employmentLength_title_cnt</th>\n",
       "      <th>employmentLength_verificationStatus_cnt</th>\n",
       "      <th>employmentTitle_applicationType_cnt</th>\n",
       "      <th>employmentTitle_employmentLength_cnt</th>\n",
       "      <th>employmentTitle_grade_cnt</th>\n",
       "      <th>employmentTitle_homeOwnership_cnt</th>\n",
       "      <th>employmentTitle_initialListStatus_cnt</th>\n",
       "      <th>employmentTitle_postCode_cnt</th>\n",
       "      <th>employmentTitle_purpose_cnt</th>\n",
       "      <th>employmentTitle_regionCode_cnt</th>\n",
       "      <th>employmentTitle_subGrade_cnt</th>\n",
       "      <th>employmentTitle_title_cnt</th>\n",
       "      <th>employmentTitle_verificationStatus_cnt</th>\n",
       "      <th>grade_applicationType_cnt</th>\n",
       "      <th>grade_employmentLength_cnt</th>\n",
       "      <th>grade_employmentTitle_cnt</th>\n",
       "      <th>grade_homeOwnership_cnt</th>\n",
       "      <th>grade_initialListStatus_cnt</th>\n",
       "      <th>grade_postCode_cnt</th>\n",
       "      <th>grade_purpose_cnt</th>\n",
       "      <th>grade_regionCode_cnt</th>\n",
       "      <th>grade_subGrade_cnt</th>\n",
       "      <th>grade_title_cnt</th>\n",
       "      <th>grade_verificationStatus_cnt</th>\n",
       "      <th>homeOwnership_applicationType_cnt</th>\n",
       "      <th>homeOwnership_employmentLength_cnt</th>\n",
       "      <th>homeOwnership_employmentTitle_cnt</th>\n",
       "      <th>homeOwnership_grade_cnt</th>\n",
       "      <th>homeOwnership_initialListStatus_cnt</th>\n",
       "      <th>homeOwnership_postCode_cnt</th>\n",
       "      <th>homeOwnership_purpose_cnt</th>\n",
       "      <th>homeOwnership_regionCode_cnt</th>\n",
       "      <th>homeOwnership_subGrade_cnt</th>\n",
       "      <th>homeOwnership_title_cnt</th>\n",
       "      <th>homeOwnership_verificationStatus_cnt</th>\n",
       "      <th>initialListStatus_applicationType_cnt</th>\n",
       "      <th>initialListStatus_employmentLength_cnt</th>\n",
       "      <th>initialListStatus_employmentTitle_cnt</th>\n",
       "      <th>initialListStatus_grade_cnt</th>\n",
       "      <th>initialListStatus_homeOwnership_cnt</th>\n",
       "      <th>initialListStatus_postCode_cnt</th>\n",
       "      <th>initialListStatus_purpose_cnt</th>\n",
       "      <th>initialListStatus_regionCode_cnt</th>\n",
       "      <th>initialListStatus_subGrade_cnt</th>\n",
       "      <th>initialListStatus_title_cnt</th>\n",
       "      <th>initialListStatus_verificationStatus_cnt</th>\n",
       "      <th>postCode_applicationType_cnt</th>\n",
       "      <th>postCode_employmentLength_cnt</th>\n",
       "      <th>postCode_employmentTitle_cnt</th>\n",
       "      <th>postCode_grade_cnt</th>\n",
       "      <th>postCode_homeOwnership_cnt</th>\n",
       "      <th>postCode_initialListStatus_cnt</th>\n",
       "      <th>postCode_purpose_cnt</th>\n",
       "      <th>postCode_regionCode_cnt</th>\n",
       "      <th>postCode_subGrade_cnt</th>\n",
       "      <th>postCode_title_cnt</th>\n",
       "      <th>postCode_verificationStatus_cnt</th>\n",
       "      <th>purpose_applicationType_cnt</th>\n",
       "      <th>purpose_employmentLength_cnt</th>\n",
       "      <th>purpose_employmentTitle_cnt</th>\n",
       "      <th>purpose_grade_cnt</th>\n",
       "      <th>purpose_homeOwnership_cnt</th>\n",
       "      <th>purpose_initialListStatus_cnt</th>\n",
       "      <th>purpose_postCode_cnt</th>\n",
       "      <th>purpose_regionCode_cnt</th>\n",
       "      <th>purpose_subGrade_cnt</th>\n",
       "      <th>purpose_title_cnt</th>\n",
       "      <th>purpose_verificationStatus_cnt</th>\n",
       "      <th>regionCode_applicationType_cnt</th>\n",
       "      <th>regionCode_employmentLength_cnt</th>\n",
       "      <th>regionCode_employmentTitle_cnt</th>\n",
       "      <th>regionCode_grade_cnt</th>\n",
       "      <th>regionCode_homeOwnership_cnt</th>\n",
       "      <th>regionCode_initialListStatus_cnt</th>\n",
       "      <th>regionCode_postCode_cnt</th>\n",
       "      <th>regionCode_purpose_cnt</th>\n",
       "      <th>regionCode_subGrade_cnt</th>\n",
       "      <th>regionCode_title_cnt</th>\n",
       "      <th>regionCode_verificationStatus_cnt</th>\n",
       "      <th>subGrade_applicationType_cnt</th>\n",
       "      <th>subGrade_employmentLength_cnt</th>\n",
       "      <th>subGrade_employmentTitle_cnt</th>\n",
       "      <th>subGrade_grade_cnt</th>\n",
       "      <th>subGrade_homeOwnership_cnt</th>\n",
       "      <th>subGrade_initialListStatus_cnt</th>\n",
       "      <th>subGrade_postCode_cnt</th>\n",
       "      <th>subGrade_purpose_cnt</th>\n",
       "      <th>subGrade_regionCode_cnt</th>\n",
       "      <th>subGrade_title_cnt</th>\n",
       "      <th>subGrade_verificationStatus_cnt</th>\n",
       "      <th>title_applicationType_cnt</th>\n",
       "      <th>title_employmentLength_cnt</th>\n",
       "      <th>title_employmentTitle_cnt</th>\n",
       "      <th>title_grade_cnt</th>\n",
       "      <th>title_homeOwnership_cnt</th>\n",
       "      <th>title_initialListStatus_cnt</th>\n",
       "      <th>title_postCode_cnt</th>\n",
       "      <th>title_purpose_cnt</th>\n",
       "      <th>title_regionCode_cnt</th>\n",
       "      <th>title_subGrade_cnt</th>\n",
       "      <th>title_verificationStatus_cnt</th>\n",
       "      <th>verificationStatus_applicationType_cnt</th>\n",
       "      <th>verificationStatus_employmentLength_cnt</th>\n",
       "      <th>verificationStatus_employmentTitle_cnt</th>\n",
       "      <th>verificationStatus_grade_cnt</th>\n",
       "      <th>verificationStatus_homeOwnership_cnt</th>\n",
       "      <th>verificationStatus_initialListStatus_cnt</th>\n",
       "      <th>verificationStatus_postCode_cnt</th>\n",
       "      <th>verificationStatus_purpose_cnt</th>\n",
       "      <th>verificationStatus_regionCode_cnt</th>\n",
       "      <th>verificationStatus_subGrade_cnt</th>\n",
       "      <th>verificationStatus_title_cnt</th>\n",
       "      <th>applicationType_default_ratio</th>\n",
       "      <th>employmentLength_default_ratio</th>\n",
       "      <th>employmentTitle_default_ratio</th>\n",
       "      <th>grade_default_ratio</th>\n",
       "      <th>homeOwnership_default_ratio</th>\n",
       "      <th>initialListStatus_default_ratio</th>\n",
       "      <th>postCode_default_ratio</th>\n",
       "      <th>purpose_default_ratio</th>\n",
       "      <th>regionCode_default_ratio</th>\n",
       "      <th>subGrade_default_ratio</th>\n",
       "      <th>title_default_ratio</th>\n",
       "      <th>verificationStatus_default_ratio</th>\n",
       "      <th>applicationType_employmentLength_default_ratio</th>\n",
       "      <th>applicationType_employmentTitle_default_ratio</th>\n",
       "      <th>applicationType_grade_default_ratio</th>\n",
       "      <th>applicationType_homeOwnership_default_ratio</th>\n",
       "      <th>applicationType_initialListStatus_default_ratio</th>\n",
       "      <th>applicationType_postCode_default_ratio</th>\n",
       "      <th>applicationType_purpose_default_ratio</th>\n",
       "      <th>applicationType_regionCode_default_ratio</th>\n",
       "      <th>applicationType_subGrade_default_ratio</th>\n",
       "      <th>applicationType_title_default_ratio</th>\n",
       "      <th>applicationType_verificationStatus_default_ratio</th>\n",
       "      <th>employmentLength_applicationType_default_ratio</th>\n",
       "      <th>employmentLength_employmentTitle_default_ratio</th>\n",
       "      <th>employmentLength_grade_default_ratio</th>\n",
       "      <th>employmentLength_homeOwnership_default_ratio</th>\n",
       "      <th>employmentLength_initialListStatus_default_ratio</th>\n",
       "      <th>employmentLength_postCode_default_ratio</th>\n",
       "      <th>employmentLength_purpose_default_ratio</th>\n",
       "      <th>employmentLength_regionCode_default_ratio</th>\n",
       "      <th>employmentLength_subGrade_default_ratio</th>\n",
       "      <th>employmentLength_title_default_ratio</th>\n",
       "      <th>employmentLength_verificationStatus_default_ratio</th>\n",
       "      <th>employmentTitle_applicationType_default_ratio</th>\n",
       "      <th>employmentTitle_employmentLength_default_ratio</th>\n",
       "      <th>employmentTitle_grade_default_ratio</th>\n",
       "      <th>employmentTitle_homeOwnership_default_ratio</th>\n",
       "      <th>employmentTitle_initialListStatus_default_ratio</th>\n",
       "      <th>employmentTitle_postCode_default_ratio</th>\n",
       "      <th>employmentTitle_purpose_default_ratio</th>\n",
       "      <th>employmentTitle_regionCode_default_ratio</th>\n",
       "      <th>employmentTitle_subGrade_default_ratio</th>\n",
       "      <th>employmentTitle_title_default_ratio</th>\n",
       "      <th>employmentTitle_verificationStatus_default_ratio</th>\n",
       "      <th>grade_applicationType_default_ratio</th>\n",
       "      <th>grade_employmentLength_default_ratio</th>\n",
       "      <th>grade_employmentTitle_default_ratio</th>\n",
       "      <th>grade_homeOwnership_default_ratio</th>\n",
       "      <th>grade_initialListStatus_default_ratio</th>\n",
       "      <th>grade_postCode_default_ratio</th>\n",
       "      <th>grade_purpose_default_ratio</th>\n",
       "      <th>grade_regionCode_default_ratio</th>\n",
       "      <th>grade_subGrade_default_ratio</th>\n",
       "      <th>grade_title_default_ratio</th>\n",
       "      <th>grade_verificationStatus_default_ratio</th>\n",
       "      <th>homeOwnership_applicationType_default_ratio</th>\n",
       "      <th>homeOwnership_employmentLength_default_ratio</th>\n",
       "      <th>homeOwnership_employmentTitle_default_ratio</th>\n",
       "      <th>homeOwnership_grade_default_ratio</th>\n",
       "      <th>homeOwnership_initialListStatus_default_ratio</th>\n",
       "      <th>homeOwnership_postCode_default_ratio</th>\n",
       "      <th>homeOwnership_purpose_default_ratio</th>\n",
       "      <th>homeOwnership_regionCode_default_ratio</th>\n",
       "      <th>homeOwnership_subGrade_default_ratio</th>\n",
       "      <th>homeOwnership_title_default_ratio</th>\n",
       "      <th>homeOwnership_verificationStatus_default_ratio</th>\n",
       "      <th>initialListStatus_applicationType_default_ratio</th>\n",
       "      <th>initialListStatus_employmentLength_default_ratio</th>\n",
       "      <th>initialListStatus_employmentTitle_default_ratio</th>\n",
       "      <th>initialListStatus_grade_default_ratio</th>\n",
       "      <th>initialListStatus_homeOwnership_default_ratio</th>\n",
       "      <th>initialListStatus_postCode_default_ratio</th>\n",
       "      <th>initialListStatus_purpose_default_ratio</th>\n",
       "      <th>initialListStatus_regionCode_default_ratio</th>\n",
       "      <th>initialListStatus_subGrade_default_ratio</th>\n",
       "      <th>initialListStatus_title_default_ratio</th>\n",
       "      <th>initialListStatus_verificationStatus_default_ratio</th>\n",
       "      <th>postCode_applicationType_default_ratio</th>\n",
       "      <th>postCode_employmentLength_default_ratio</th>\n",
       "      <th>postCode_employmentTitle_default_ratio</th>\n",
       "      <th>postCode_grade_default_ratio</th>\n",
       "      <th>postCode_homeOwnership_default_ratio</th>\n",
       "      <th>postCode_initialListStatus_default_ratio</th>\n",
       "      <th>postCode_purpose_default_ratio</th>\n",
       "      <th>postCode_regionCode_default_ratio</th>\n",
       "      <th>postCode_subGrade_default_ratio</th>\n",
       "      <th>postCode_title_default_ratio</th>\n",
       "      <th>postCode_verificationStatus_default_ratio</th>\n",
       "      <th>purpose_applicationType_default_ratio</th>\n",
       "      <th>purpose_employmentLength_default_ratio</th>\n",
       "      <th>purpose_employmentTitle_default_ratio</th>\n",
       "      <th>purpose_grade_default_ratio</th>\n",
       "      <th>purpose_homeOwnership_default_ratio</th>\n",
       "      <th>purpose_initialListStatus_default_ratio</th>\n",
       "      <th>purpose_postCode_default_ratio</th>\n",
       "      <th>purpose_regionCode_default_ratio</th>\n",
       "      <th>purpose_subGrade_default_ratio</th>\n",
       "      <th>purpose_title_default_ratio</th>\n",
       "      <th>purpose_verificationStatus_default_ratio</th>\n",
       "      <th>regionCode_applicationType_default_ratio</th>\n",
       "      <th>regionCode_employmentLength_default_ratio</th>\n",
       "      <th>regionCode_employmentTitle_default_ratio</th>\n",
       "      <th>regionCode_grade_default_ratio</th>\n",
       "      <th>regionCode_homeOwnership_default_ratio</th>\n",
       "      <th>regionCode_initialListStatus_default_ratio</th>\n",
       "      <th>regionCode_postCode_default_ratio</th>\n",
       "      <th>regionCode_purpose_default_ratio</th>\n",
       "      <th>regionCode_subGrade_default_ratio</th>\n",
       "      <th>regionCode_title_default_ratio</th>\n",
       "      <th>regionCode_verificationStatus_default_ratio</th>\n",
       "      <th>subGrade_applicationType_default_ratio</th>\n",
       "      <th>subGrade_employmentLength_default_ratio</th>\n",
       "      <th>subGrade_employmentTitle_default_ratio</th>\n",
       "      <th>subGrade_grade_default_ratio</th>\n",
       "      <th>subGrade_homeOwnership_default_ratio</th>\n",
       "      <th>subGrade_initialListStatus_default_ratio</th>\n",
       "      <th>subGrade_postCode_default_ratio</th>\n",
       "      <th>subGrade_purpose_default_ratio</th>\n",
       "      <th>subGrade_regionCode_default_ratio</th>\n",
       "      <th>subGrade_title_default_ratio</th>\n",
       "      <th>subGrade_verificationStatus_default_ratio</th>\n",
       "      <th>title_applicationType_default_ratio</th>\n",
       "      <th>title_employmentLength_default_ratio</th>\n",
       "      <th>title_employmentTitle_default_ratio</th>\n",
       "      <th>title_grade_default_ratio</th>\n",
       "      <th>title_homeOwnership_default_ratio</th>\n",
       "      <th>title_initialListStatus_default_ratio</th>\n",
       "      <th>title_postCode_default_ratio</th>\n",
       "      <th>title_purpose_default_ratio</th>\n",
       "      <th>title_regionCode_default_ratio</th>\n",
       "      <th>title_subGrade_default_ratio</th>\n",
       "      <th>title_verificationStatus_default_ratio</th>\n",
       "      <th>verificationStatus_applicationType_default_ratio</th>\n",
       "      <th>verificationStatus_employmentLength_default_ratio</th>\n",
       "      <th>verificationStatus_employmentTitle_default_ratio</th>\n",
       "      <th>verificationStatus_grade_default_ratio</th>\n",
       "      <th>verificationStatus_homeOwnership_default_ratio</th>\n",
       "      <th>verificationStatus_initialListStatus_default_ratio</th>\n",
       "      <th>verificationStatus_postCode_default_ratio</th>\n",
       "      <th>verificationStatus_purpose_default_ratio</th>\n",
       "      <th>verificationStatus_regionCode_default_ratio</th>\n",
       "      <th>verificationStatus_subGrade_default_ratio</th>\n",
       "      <th>verificationStatus_title_default_ratio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>46000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>27.83</td>\n",
       "      <td>May-2002</td>\n",
       "      <td>5.0</td>\n",
       "      <td>219843.0</td>\n",
       "      <td>704.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>461.90</td>\n",
       "      <td>18.49</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2012-08-01</td>\n",
       "      <td>18000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13.0</td>\n",
       "      <td>156.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>15096.0</td>\n",
       "      <td>38.9</td>\n",
       "      <td>21</td>\n",
       "      <td>5</td>\n",
       "      <td>1723.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2012</td>\n",
       "      <td>2002</td>\n",
       "      <td>10</td>\n",
       "      <td>0.078261</td>\n",
       "      <td>980693</td>\n",
       "      <td>62645.0</td>\n",
       "      <td>151.0</td>\n",
       "      <td>149377</td>\n",
       "      <td>494678</td>\n",
       "      <td>416892</td>\n",
       "      <td>4751.0</td>\n",
       "      <td>580226</td>\n",
       "      <td>21572</td>\n",
       "      <td>33241</td>\n",
       "      <td>37.0</td>\n",
       "      <td>311132</td>\n",
       "      <td>61706.0</td>\n",
       "      <td>151.0</td>\n",
       "      <td>145912</td>\n",
       "      <td>481648</td>\n",
       "      <td>413022</td>\n",
       "      <td>4662.0</td>\n",
       "      <td>568237</td>\n",
       "      <td>21064</td>\n",
       "      <td>32426</td>\n",
       "      <td>37.0</td>\n",
       "      <td>303690</td>\n",
       "      <td>61706.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9312.0</td>\n",
       "      <td>28984.0</td>\n",
       "      <td>27473.0</td>\n",
       "      <td>314.0</td>\n",
       "      <td>35846.0</td>\n",
       "      <td>1335.0</td>\n",
       "      <td>2085.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>18362.0</td>\n",
       "      <td>151.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>121.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>145912</td>\n",
       "      <td>9312.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>67798</td>\n",
       "      <td>73095</td>\n",
       "      <td>655.0</td>\n",
       "      <td>93490</td>\n",
       "      <td>3213</td>\n",
       "      <td>33241</td>\n",
       "      <td>8.0</td>\n",
       "      <td>59182</td>\n",
       "      <td>481648</td>\n",
       "      <td>28984.0</td>\n",
       "      <td>83.0</td>\n",
       "      <td>67798</td>\n",
       "      <td>199082</td>\n",
       "      <td>2128.0</td>\n",
       "      <td>287217</td>\n",
       "      <td>10719</td>\n",
       "      <td>14925</td>\n",
       "      <td>23.0</td>\n",
       "      <td>160130</td>\n",
       "      <td>413022</td>\n",
       "      <td>27473.0</td>\n",
       "      <td>121.0</td>\n",
       "      <td>73095</td>\n",
       "      <td>199082</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>243152</td>\n",
       "      <td>9080</td>\n",
       "      <td>16525</td>\n",
       "      <td>31.0</td>\n",
       "      <td>146424</td>\n",
       "      <td>4662.0</td>\n",
       "      <td>314.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>655.0</td>\n",
       "      <td>2128.0</td>\n",
       "      <td>2020.0</td>\n",
       "      <td>2790.0</td>\n",
       "      <td>4747.0</td>\n",
       "      <td>145.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1592.0</td>\n",
       "      <td>568237</td>\n",
       "      <td>35846.0</td>\n",
       "      <td>92.0</td>\n",
       "      <td>93490</td>\n",
       "      <td>287217</td>\n",
       "      <td>243152</td>\n",
       "      <td>2790.0</td>\n",
       "      <td>12902</td>\n",
       "      <td>20770</td>\n",
       "      <td>27.0</td>\n",
       "      <td>189929</td>\n",
       "      <td>21064</td>\n",
       "      <td>1335.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3213</td>\n",
       "      <td>10719</td>\n",
       "      <td>9080</td>\n",
       "      <td>4747.0</td>\n",
       "      <td>12902</td>\n",
       "      <td>700</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7009</td>\n",
       "      <td>32426</td>\n",
       "      <td>2085.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>33241</td>\n",
       "      <td>14925</td>\n",
       "      <td>16525</td>\n",
       "      <td>145.0</td>\n",
       "      <td>20770</td>\n",
       "      <td>700</td>\n",
       "      <td>2.0</td>\n",
       "      <td>12593</td>\n",
       "      <td>37.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>31.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>303690</td>\n",
       "      <td>18362.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>59182</td>\n",
       "      <td>160130</td>\n",
       "      <td>146424</td>\n",
       "      <td>1592.0</td>\n",
       "      <td>189929</td>\n",
       "      <td>7009</td>\n",
       "      <td>12593</td>\n",
       "      <td>24.0</td>\n",
       "      <td>0.198519</td>\n",
       "      <td>0.196500</td>\n",
       "      <td>0.182796</td>\n",
       "      <td>0.302938</td>\n",
       "      <td>0.171817</td>\n",
       "      <td>0.196211</td>\n",
       "      <td>0.156353</td>\n",
       "      <td>0.211100</td>\n",
       "      <td>0.159035</td>\n",
       "      <td>0.294491</td>\n",
       "      <td>0.095238</td>\n",
       "      <td>0.238263</td>\n",
       "      <td>0.196008</td>\n",
       "      <td>0.182796</td>\n",
       "      <td>0.302257</td>\n",
       "      <td>0.170799</td>\n",
       "      <td>0.195492</td>\n",
       "      <td>0.156639</td>\n",
       "      <td>0.210028</td>\n",
       "      <td>0.159301</td>\n",
       "      <td>0.294651</td>\n",
       "      <td>0.095238</td>\n",
       "      <td>0.237194</td>\n",
       "      <td>0.196008</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.295359</td>\n",
       "      <td>0.170428</td>\n",
       "      <td>0.191164</td>\n",
       "      <td>0.131707</td>\n",
       "      <td>0.205548</td>\n",
       "      <td>0.153396</td>\n",
       "      <td>0.294297</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.237850</td>\n",
       "      <td>0.182796</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.266667</td>\n",
       "      <td>0.260870</td>\n",
       "      <td>0.219178</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.236364</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.175439</td>\n",
       "      <td>0.302257</td>\n",
       "      <td>0.295359</td>\n",
       "      <td>0.266667</td>\n",
       "      <td>0.274273</td>\n",
       "      <td>0.277774</td>\n",
       "      <td>0.226601</td>\n",
       "      <td>0.309783</td>\n",
       "      <td>0.242454</td>\n",
       "      <td>0.294491</td>\n",
       "      <td>0.250000</td>\n",
       "      <td>0.311324</td>\n",
       "      <td>0.170799</td>\n",
       "      <td>0.170428</td>\n",
       "      <td>0.260870</td>\n",
       "      <td>0.274273</td>\n",
       "      <td>0.170545</td>\n",
       "      <td>0.092038</td>\n",
       "      <td>0.183384</td>\n",
       "      <td>0.114618</td>\n",
       "      <td>0.260709</td>\n",
       "      <td>0.076923</td>\n",
       "      <td>0.207866</td>\n",
       "      <td>0.195492</td>\n",
       "      <td>0.191164</td>\n",
       "      <td>0.219178</td>\n",
       "      <td>0.277774</td>\n",
       "      <td>0.170545</td>\n",
       "      <td>0.161663</td>\n",
       "      <td>0.206971</td>\n",
       "      <td>0.170041</td>\n",
       "      <td>0.271423</td>\n",
       "      <td>0.125000</td>\n",
       "      <td>0.226760</td>\n",
       "      <td>0.156639</td>\n",
       "      <td>0.131707</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.226601</td>\n",
       "      <td>0.092038</td>\n",
       "      <td>0.161663</td>\n",
       "      <td>0.169022</td>\n",
       "      <td>0.156404</td>\n",
       "      <td>0.213483</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.185185</td>\n",
       "      <td>0.210028</td>\n",
       "      <td>0.205548</td>\n",
       "      <td>0.236364</td>\n",
       "      <td>0.309783</td>\n",
       "      <td>0.183384</td>\n",
       "      <td>0.206971</td>\n",
       "      <td>0.169022</td>\n",
       "      <td>0.167394</td>\n",
       "      <td>0.299375</td>\n",
       "      <td>0.133333</td>\n",
       "      <td>0.248802</td>\n",
       "      <td>0.159301</td>\n",
       "      <td>0.153396</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.242454</td>\n",
       "      <td>0.114618</td>\n",
       "      <td>0.170041</td>\n",
       "      <td>0.156404</td>\n",
       "      <td>0.167394</td>\n",
       "      <td>0.249438</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.192325</td>\n",
       "      <td>0.294651</td>\n",
       "      <td>0.294297</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.294491</td>\n",
       "      <td>0.260709</td>\n",
       "      <td>0.271423</td>\n",
       "      <td>0.213483</td>\n",
       "      <td>0.299375</td>\n",
       "      <td>0.249438</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.301380</td>\n",
       "      <td>0.095238</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.250000</td>\n",
       "      <td>0.076923</td>\n",
       "      <td>0.125000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.133333</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.071429</td>\n",
       "      <td>0.237194</td>\n",
       "      <td>0.237850</td>\n",
       "      <td>0.175439</td>\n",
       "      <td>0.311324</td>\n",
       "      <td>0.207866</td>\n",
       "      <td>0.226760</td>\n",
       "      <td>0.185185</td>\n",
       "      <td>0.248802</td>\n",
       "      <td>0.192325</td>\n",
       "      <td>0.301380</td>\n",
       "      <td>0.071429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>47500.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>24.36</td>\n",
       "      <td>Mar-2000</td>\n",
       "      <td>4.0</td>\n",
       "      <td>386.0</td>\n",
       "      <td>669.0</td>\n",
       "      <td>665.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>684.33</td>\n",
       "      <td>14.08</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2018-01-01</td>\n",
       "      <td>20000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>226.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9</td>\n",
       "      <td>21</td>\n",
       "      <td>19497.0</td>\n",
       "      <td>53.1</td>\n",
       "      <td>17</td>\n",
       "      <td>3</td>\n",
       "      <td>10.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2018</td>\n",
       "      <td>2000</td>\n",
       "      <td>18</td>\n",
       "      <td>0.140351</td>\n",
       "      <td>980693</td>\n",
       "      <td>59818.0</td>\n",
       "      <td>275.0</td>\n",
       "      <td>283819</td>\n",
       "      <td>397051</td>\n",
       "      <td>583108</td>\n",
       "      <td>2429.0</td>\n",
       "      <td>11560</td>\n",
       "      <td>71163</td>\n",
       "      <td>55769</td>\n",
       "      <td>10103.0</td>\n",
       "      <td>387568</td>\n",
       "      <td>58878.0</td>\n",
       "      <td>273.0</td>\n",
       "      <td>277596</td>\n",
       "      <td>392585</td>\n",
       "      <td>567671</td>\n",
       "      <td>2363.0</td>\n",
       "      <td>11232</td>\n",
       "      <td>69827</td>\n",
       "      <td>54572</td>\n",
       "      <td>9780.0</td>\n",
       "      <td>382010</td>\n",
       "      <td>58878.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>16913.0</td>\n",
       "      <td>27208.0</td>\n",
       "      <td>34001.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>694.0</td>\n",
       "      <td>4413.0</td>\n",
       "      <td>3303.0</td>\n",
       "      <td>600.0</td>\n",
       "      <td>23854.0</td>\n",
       "      <td>273.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>189.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>277596</td>\n",
       "      <td>16913.0</td>\n",
       "      <td>81.0</td>\n",
       "      <td>118735</td>\n",
       "      <td>171020</td>\n",
       "      <td>687.0</td>\n",
       "      <td>3591</td>\n",
       "      <td>20563</td>\n",
       "      <td>55769</td>\n",
       "      <td>3276.0</td>\n",
       "      <td>114416</td>\n",
       "      <td>392585</td>\n",
       "      <td>27208.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>118735</td>\n",
       "      <td>221907</td>\n",
       "      <td>951.0</td>\n",
       "      <td>4960</td>\n",
       "      <td>28919</td>\n",
       "      <td>23222</td>\n",
       "      <td>4288.0</td>\n",
       "      <td>161834</td>\n",
       "      <td>567671</td>\n",
       "      <td>34001.0</td>\n",
       "      <td>189.0</td>\n",
       "      <td>171020</td>\n",
       "      <td>221907</td>\n",
       "      <td>1457.0</td>\n",
       "      <td>6604</td>\n",
       "      <td>41589</td>\n",
       "      <td>33842</td>\n",
       "      <td>6377.0</td>\n",
       "      <td>239409</td>\n",
       "      <td>2363.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>687.0</td>\n",
       "      <td>951.0</td>\n",
       "      <td>1457.0</td>\n",
       "      <td>44.0</td>\n",
       "      <td>2426.0</td>\n",
       "      <td>114.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>954.0</td>\n",
       "      <td>11232</td>\n",
       "      <td>694.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3591</td>\n",
       "      <td>4960</td>\n",
       "      <td>6604</td>\n",
       "      <td>44.0</td>\n",
       "      <td>842</td>\n",
       "      <td>723</td>\n",
       "      <td>10082.0</td>\n",
       "      <td>4383</td>\n",
       "      <td>69827</td>\n",
       "      <td>4413.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>20563</td>\n",
       "      <td>28919</td>\n",
       "      <td>41589</td>\n",
       "      <td>2426.0</td>\n",
       "      <td>842</td>\n",
       "      <td>3992</td>\n",
       "      <td>742.0</td>\n",
       "      <td>28042</td>\n",
       "      <td>54572</td>\n",
       "      <td>3303.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>55769</td>\n",
       "      <td>23222</td>\n",
       "      <td>33842</td>\n",
       "      <td>114.0</td>\n",
       "      <td>723</td>\n",
       "      <td>3992</td>\n",
       "      <td>667.0</td>\n",
       "      <td>22517</td>\n",
       "      <td>9780.0</td>\n",
       "      <td>600.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3276.0</td>\n",
       "      <td>4288.0</td>\n",
       "      <td>6377.0</td>\n",
       "      <td>41.0</td>\n",
       "      <td>10082.0</td>\n",
       "      <td>742.0</td>\n",
       "      <td>667.0</td>\n",
       "      <td>3966.0</td>\n",
       "      <td>382010</td>\n",
       "      <td>23854.0</td>\n",
       "      <td>98.0</td>\n",
       "      <td>114416</td>\n",
       "      <td>161834</td>\n",
       "      <td>239409</td>\n",
       "      <td>954.0</td>\n",
       "      <td>4383</td>\n",
       "      <td>28042</td>\n",
       "      <td>22517</td>\n",
       "      <td>3966.0</td>\n",
       "      <td>0.198519</td>\n",
       "      <td>0.198453</td>\n",
       "      <td>0.151685</td>\n",
       "      <td>0.225775</td>\n",
       "      <td>0.231709</td>\n",
       "      <td>0.201877</td>\n",
       "      <td>0.194000</td>\n",
       "      <td>0.218425</td>\n",
       "      <td>0.214701</td>\n",
       "      <td>0.224439</td>\n",
       "      <td>0.226599</td>\n",
       "      <td>0.209223</td>\n",
       "      <td>0.197877</td>\n",
       "      <td>0.152542</td>\n",
       "      <td>0.224810</td>\n",
       "      <td>0.230400</td>\n",
       "      <td>0.200725</td>\n",
       "      <td>0.192360</td>\n",
       "      <td>0.215227</td>\n",
       "      <td>0.213953</td>\n",
       "      <td>0.223881</td>\n",
       "      <td>0.223194</td>\n",
       "      <td>0.208617</td>\n",
       "      <td>0.197877</td>\n",
       "      <td>0.222222</td>\n",
       "      <td>0.220896</td>\n",
       "      <td>0.224315</td>\n",
       "      <td>0.200330</td>\n",
       "      <td>0.170213</td>\n",
       "      <td>0.221973</td>\n",
       "      <td>0.223918</td>\n",
       "      <td>0.218584</td>\n",
       "      <td>0.228205</td>\n",
       "      <td>0.211291</td>\n",
       "      <td>0.152542</td>\n",
       "      <td>0.222222</td>\n",
       "      <td>0.232143</td>\n",
       "      <td>0.183673</td>\n",
       "      <td>0.147541</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.400000</td>\n",
       "      <td>0.166667</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.079365</td>\n",
       "      <td>0.224810</td>\n",
       "      <td>0.220896</td>\n",
       "      <td>0.232143</td>\n",
       "      <td>0.251310</td>\n",
       "      <td>0.239951</td>\n",
       "      <td>0.250000</td>\n",
       "      <td>0.231771</td>\n",
       "      <td>0.241694</td>\n",
       "      <td>0.224439</td>\n",
       "      <td>0.236717</td>\n",
       "      <td>0.233434</td>\n",
       "      <td>0.230400</td>\n",
       "      <td>0.224315</td>\n",
       "      <td>0.183673</td>\n",
       "      <td>0.251310</td>\n",
       "      <td>0.238970</td>\n",
       "      <td>0.245378</td>\n",
       "      <td>0.254660</td>\n",
       "      <td>0.257456</td>\n",
       "      <td>0.253778</td>\n",
       "      <td>0.263620</td>\n",
       "      <td>0.242804</td>\n",
       "      <td>0.200725</td>\n",
       "      <td>0.200330</td>\n",
       "      <td>0.147541</td>\n",
       "      <td>0.239951</td>\n",
       "      <td>0.238970</td>\n",
       "      <td>0.199546</td>\n",
       "      <td>0.223273</td>\n",
       "      <td>0.214066</td>\n",
       "      <td>0.240328</td>\n",
       "      <td>0.225104</td>\n",
       "      <td>0.209710</td>\n",
       "      <td>0.192360</td>\n",
       "      <td>0.170213</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.250000</td>\n",
       "      <td>0.245378</td>\n",
       "      <td>0.199546</td>\n",
       "      <td>0.115385</td>\n",
       "      <td>0.192924</td>\n",
       "      <td>0.243243</td>\n",
       "      <td>0.080000</td>\n",
       "      <td>0.230104</td>\n",
       "      <td>0.215227</td>\n",
       "      <td>0.221973</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.231771</td>\n",
       "      <td>0.254660</td>\n",
       "      <td>0.223273</td>\n",
       "      <td>0.115385</td>\n",
       "      <td>0.217636</td>\n",
       "      <td>0.208520</td>\n",
       "      <td>0.226865</td>\n",
       "      <td>0.223001</td>\n",
       "      <td>0.213953</td>\n",
       "      <td>0.223918</td>\n",
       "      <td>0.400000</td>\n",
       "      <td>0.241694</td>\n",
       "      <td>0.257456</td>\n",
       "      <td>0.214066</td>\n",
       "      <td>0.192924</td>\n",
       "      <td>0.217636</td>\n",
       "      <td>0.231346</td>\n",
       "      <td>0.227660</td>\n",
       "      <td>0.223165</td>\n",
       "      <td>0.223881</td>\n",
       "      <td>0.218584</td>\n",
       "      <td>0.166667</td>\n",
       "      <td>0.224439</td>\n",
       "      <td>0.253778</td>\n",
       "      <td>0.240328</td>\n",
       "      <td>0.243243</td>\n",
       "      <td>0.208520</td>\n",
       "      <td>0.231346</td>\n",
       "      <td>0.216019</td>\n",
       "      <td>0.234065</td>\n",
       "      <td>0.223194</td>\n",
       "      <td>0.228205</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.236717</td>\n",
       "      <td>0.263620</td>\n",
       "      <td>0.225104</td>\n",
       "      <td>0.080000</td>\n",
       "      <td>0.226865</td>\n",
       "      <td>0.227660</td>\n",
       "      <td>0.216019</td>\n",
       "      <td>0.229604</td>\n",
       "      <td>0.208617</td>\n",
       "      <td>0.211291</td>\n",
       "      <td>0.079365</td>\n",
       "      <td>0.233434</td>\n",
       "      <td>0.242804</td>\n",
       "      <td>0.209710</td>\n",
       "      <td>0.230104</td>\n",
       "      <td>0.223001</td>\n",
       "      <td>0.223165</td>\n",
       "      <td>0.234065</td>\n",
       "      <td>0.229604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>40000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>12.57</td>\n",
       "      <td>Apr-2000</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2780.0</td>\n",
       "      <td>669.0</td>\n",
       "      <td>665.0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>266.31</td>\n",
       "      <td>8.59</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2016-08-01</td>\n",
       "      <td>8425.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>245.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>26</td>\n",
       "      <td>7993.0</td>\n",
       "      <td>33.9</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0</td>\n",
       "      <td>2016</td>\n",
       "      <td>2000</td>\n",
       "      <td>16</td>\n",
       "      <td>0.070208</td>\n",
       "      <td>980693</td>\n",
       "      <td>328525.0</td>\n",
       "      <td>149.0</td>\n",
       "      <td>174588</td>\n",
       "      <td>494678</td>\n",
       "      <td>583108</td>\n",
       "      <td>2546.0</td>\n",
       "      <td>580226</td>\n",
       "      <td>23086</td>\n",
       "      <td>47674</td>\n",
       "      <td>491400.0</td>\n",
       "      <td>301300</td>\n",
       "      <td>323591.0</td>\n",
       "      <td>143.0</td>\n",
       "      <td>171997</td>\n",
       "      <td>481648</td>\n",
       "      <td>567671</td>\n",
       "      <td>2504.0</td>\n",
       "      <td>568237</td>\n",
       "      <td>22724</td>\n",
       "      <td>47016</td>\n",
       "      <td>479722.0</td>\n",
       "      <td>294993</td>\n",
       "      <td>323591.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>59278.0</td>\n",
       "      <td>199068.0</td>\n",
       "      <td>197111.0</td>\n",
       "      <td>896.0</td>\n",
       "      <td>195388.0</td>\n",
       "      <td>7451.0</td>\n",
       "      <td>15968.0</td>\n",
       "      <td>167561.0</td>\n",
       "      <td>98538.0</td>\n",
       "      <td>143.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>171997</td>\n",
       "      <td>59278.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>100381</td>\n",
       "      <td>117213</td>\n",
       "      <td>528.0</td>\n",
       "      <td>85590</td>\n",
       "      <td>4991</td>\n",
       "      <td>47674</td>\n",
       "      <td>72704.0</td>\n",
       "      <td>80620</td>\n",
       "      <td>481648</td>\n",
       "      <td>199068.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>100381</td>\n",
       "      <td>295596</td>\n",
       "      <td>1151.0</td>\n",
       "      <td>287217</td>\n",
       "      <td>10362</td>\n",
       "      <td>25652</td>\n",
       "      <td>243453.0</td>\n",
       "      <td>152373</td>\n",
       "      <td>567671</td>\n",
       "      <td>197111.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>117213</td>\n",
       "      <td>295596</td>\n",
       "      <td>1483.0</td>\n",
       "      <td>337074</td>\n",
       "      <td>13626</td>\n",
       "      <td>31821</td>\n",
       "      <td>316922.0</td>\n",
       "      <td>178991</td>\n",
       "      <td>2504.0</td>\n",
       "      <td>896.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>528.0</td>\n",
       "      <td>1151.0</td>\n",
       "      <td>1483.0</td>\n",
       "      <td>1511.0</td>\n",
       "      <td>2542.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>1253.0</td>\n",
       "      <td>793.0</td>\n",
       "      <td>568237</td>\n",
       "      <td>195388.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>85590</td>\n",
       "      <td>287217</td>\n",
       "      <td>337074</td>\n",
       "      <td>1511.0</td>\n",
       "      <td>13584</td>\n",
       "      <td>25078</td>\n",
       "      <td>490766.0</td>\n",
       "      <td>164687</td>\n",
       "      <td>22724</td>\n",
       "      <td>7451.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>4991</td>\n",
       "      <td>10362</td>\n",
       "      <td>13626</td>\n",
       "      <td>2542.0</td>\n",
       "      <td>13584</td>\n",
       "      <td>1289</td>\n",
       "      <td>11262.0</td>\n",
       "      <td>7322</td>\n",
       "      <td>47016</td>\n",
       "      <td>15968.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>47674</td>\n",
       "      <td>25652</td>\n",
       "      <td>31821</td>\n",
       "      <td>133.0</td>\n",
       "      <td>25078</td>\n",
       "      <td>1289</td>\n",
       "      <td>21210.0</td>\n",
       "      <td>18138</td>\n",
       "      <td>479722.0</td>\n",
       "      <td>167561.0</td>\n",
       "      <td>85.0</td>\n",
       "      <td>72704.0</td>\n",
       "      <td>243453.0</td>\n",
       "      <td>316922.0</td>\n",
       "      <td>1253.0</td>\n",
       "      <td>490766.0</td>\n",
       "      <td>11262.0</td>\n",
       "      <td>21210.0</td>\n",
       "      <td>137836.0</td>\n",
       "      <td>294993</td>\n",
       "      <td>98538.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>80620</td>\n",
       "      <td>152373</td>\n",
       "      <td>178991</td>\n",
       "      <td>793.0</td>\n",
       "      <td>164687</td>\n",
       "      <td>7322</td>\n",
       "      <td>18138</td>\n",
       "      <td>137836.0</td>\n",
       "      <td>0.198519</td>\n",
       "      <td>0.186543</td>\n",
       "      <td>0.260417</td>\n",
       "      <td>0.060166</td>\n",
       "      <td>0.171817</td>\n",
       "      <td>0.201877</td>\n",
       "      <td>0.186118</td>\n",
       "      <td>0.211100</td>\n",
       "      <td>0.186601</td>\n",
       "      <td>0.085050</td>\n",
       "      <td>0.217787</td>\n",
       "      <td>0.147101</td>\n",
       "      <td>0.186093</td>\n",
       "      <td>0.268817</td>\n",
       "      <td>0.059663</td>\n",
       "      <td>0.170799</td>\n",
       "      <td>0.200725</td>\n",
       "      <td>0.185741</td>\n",
       "      <td>0.210028</td>\n",
       "      <td>0.185530</td>\n",
       "      <td>0.084435</td>\n",
       "      <td>0.216663</td>\n",
       "      <td>0.145717</td>\n",
       "      <td>0.186093</td>\n",
       "      <td>0.409091</td>\n",
       "      <td>0.057594</td>\n",
       "      <td>0.163327</td>\n",
       "      <td>0.187522</td>\n",
       "      <td>0.151304</td>\n",
       "      <td>0.197594</td>\n",
       "      <td>0.176768</td>\n",
       "      <td>0.083480</td>\n",
       "      <td>0.201481</td>\n",
       "      <td>0.137693</td>\n",
       "      <td>0.268817</td>\n",
       "      <td>0.409091</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.166667</td>\n",
       "      <td>0.300000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.355932</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.355932</td>\n",
       "      <td>0.100000</td>\n",
       "      <td>0.059663</td>\n",
       "      <td>0.057594</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.051730</td>\n",
       "      <td>0.060572</td>\n",
       "      <td>0.051051</td>\n",
       "      <td>0.060805</td>\n",
       "      <td>0.056116</td>\n",
       "      <td>0.085050</td>\n",
       "      <td>0.061423</td>\n",
       "      <td>0.053647</td>\n",
       "      <td>0.170799</td>\n",
       "      <td>0.163327</td>\n",
       "      <td>0.166667</td>\n",
       "      <td>0.051730</td>\n",
       "      <td>0.172674</td>\n",
       "      <td>0.132000</td>\n",
       "      <td>0.183384</td>\n",
       "      <td>0.153858</td>\n",
       "      <td>0.075746</td>\n",
       "      <td>0.187677</td>\n",
       "      <td>0.126693</td>\n",
       "      <td>0.200725</td>\n",
       "      <td>0.187522</td>\n",
       "      <td>0.300000</td>\n",
       "      <td>0.060572</td>\n",
       "      <td>0.172674</td>\n",
       "      <td>0.170082</td>\n",
       "      <td>0.214088</td>\n",
       "      <td>0.191439</td>\n",
       "      <td>0.085033</td>\n",
       "      <td>0.215492</td>\n",
       "      <td>0.148568</td>\n",
       "      <td>0.185741</td>\n",
       "      <td>0.151304</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.051051</td>\n",
       "      <td>0.132000</td>\n",
       "      <td>0.170082</td>\n",
       "      <td>0.198953</td>\n",
       "      <td>0.186232</td>\n",
       "      <td>0.107143</td>\n",
       "      <td>0.205736</td>\n",
       "      <td>0.099609</td>\n",
       "      <td>0.210028</td>\n",
       "      <td>0.197594</td>\n",
       "      <td>0.355932</td>\n",
       "      <td>0.060805</td>\n",
       "      <td>0.183384</td>\n",
       "      <td>0.214088</td>\n",
       "      <td>0.198953</td>\n",
       "      <td>0.196315</td>\n",
       "      <td>0.084761</td>\n",
       "      <td>0.217780</td>\n",
       "      <td>0.155872</td>\n",
       "      <td>0.185530</td>\n",
       "      <td>0.176768</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.056116</td>\n",
       "      <td>0.153858</td>\n",
       "      <td>0.191439</td>\n",
       "      <td>0.186232</td>\n",
       "      <td>0.196315</td>\n",
       "      <td>0.087282</td>\n",
       "      <td>0.203198</td>\n",
       "      <td>0.138766</td>\n",
       "      <td>0.084435</td>\n",
       "      <td>0.083480</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.085050</td>\n",
       "      <td>0.075746</td>\n",
       "      <td>0.085033</td>\n",
       "      <td>0.107143</td>\n",
       "      <td>0.084761</td>\n",
       "      <td>0.087282</td>\n",
       "      <td>0.086222</td>\n",
       "      <td>0.080819</td>\n",
       "      <td>0.216663</td>\n",
       "      <td>0.201481</td>\n",
       "      <td>0.355932</td>\n",
       "      <td>0.061423</td>\n",
       "      <td>0.187677</td>\n",
       "      <td>0.215492</td>\n",
       "      <td>0.205736</td>\n",
       "      <td>0.217780</td>\n",
       "      <td>0.203198</td>\n",
       "      <td>0.086222</td>\n",
       "      <td>0.160245</td>\n",
       "      <td>0.145717</td>\n",
       "      <td>0.137693</td>\n",
       "      <td>0.100000</td>\n",
       "      <td>0.053647</td>\n",
       "      <td>0.126693</td>\n",
       "      <td>0.148568</td>\n",
       "      <td>0.099609</td>\n",
       "      <td>0.155872</td>\n",
       "      <td>0.138766</td>\n",
       "      <td>0.080819</td>\n",
       "      <td>0.160245</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>30000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>20.20</td>\n",
       "      <td>Jul-2007</td>\n",
       "      <td>5.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>689.0</td>\n",
       "      <td>685.0</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>32</td>\n",
       "      <td>1</td>\n",
       "      <td>349.55</td>\n",
       "      <td>15.59</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2015-01-01</td>\n",
       "      <td>10000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>413.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>37</td>\n",
       "      <td>6772.0</td>\n",
       "      <td>41.3</td>\n",
       "      <td>20</td>\n",
       "      <td>3</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2015</td>\n",
       "      <td>2007</td>\n",
       "      <td>8</td>\n",
       "      <td>0.111111</td>\n",
       "      <td>980693</td>\n",
       "      <td>62645.0</td>\n",
       "      <td>3315.0</td>\n",
       "      <td>149377</td>\n",
       "      <td>107910</td>\n",
       "      <td>416892</td>\n",
       "      <td>521.0</td>\n",
       "      <td>580226</td>\n",
       "      <td>7470</td>\n",
       "      <td>38205</td>\n",
       "      <td>491400.0</td>\n",
       "      <td>387568</td>\n",
       "      <td>61706.0</td>\n",
       "      <td>3279.0</td>\n",
       "      <td>145912</td>\n",
       "      <td>106101</td>\n",
       "      <td>413022</td>\n",
       "      <td>511.0</td>\n",
       "      <td>568237</td>\n",
       "      <td>7272</td>\n",
       "      <td>37450</td>\n",
       "      <td>479722.0</td>\n",
       "      <td>382010</td>\n",
       "      <td>61706.0</td>\n",
       "      <td>229.0</td>\n",
       "      <td>9312.0</td>\n",
       "      <td>6455.0</td>\n",
       "      <td>27473.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>35846.0</td>\n",
       "      <td>446.0</td>\n",
       "      <td>2360.0</td>\n",
       "      <td>29106.0</td>\n",
       "      <td>24332.0</td>\n",
       "      <td>3279.0</td>\n",
       "      <td>229.0</td>\n",
       "      <td>592.0</td>\n",
       "      <td>407.0</td>\n",
       "      <td>1270.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1903.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>1825.0</td>\n",
       "      <td>1440.0</td>\n",
       "      <td>145912</td>\n",
       "      <td>9312.0</td>\n",
       "      <td>592.0</td>\n",
       "      <td>16499</td>\n",
       "      <td>73095</td>\n",
       "      <td>90.0</td>\n",
       "      <td>93490</td>\n",
       "      <td>1198</td>\n",
       "      <td>38205</td>\n",
       "      <td>80256.0</td>\n",
       "      <td>58554</td>\n",
       "      <td>106101</td>\n",
       "      <td>6455.0</td>\n",
       "      <td>407.0</td>\n",
       "      <td>16499</td>\n",
       "      <td>42474</td>\n",
       "      <td>82.0</td>\n",
       "      <td>56828</td>\n",
       "      <td>1104</td>\n",
       "      <td>4142</td>\n",
       "      <td>49910.0</td>\n",
       "      <td>43454</td>\n",
       "      <td>413022</td>\n",
       "      <td>27473.0</td>\n",
       "      <td>1270.0</td>\n",
       "      <td>73095</td>\n",
       "      <td>42474</td>\n",
       "      <td>224.0</td>\n",
       "      <td>243152</td>\n",
       "      <td>3103</td>\n",
       "      <td>19184</td>\n",
       "      <td>174478.0</td>\n",
       "      <td>148159</td>\n",
       "      <td>511.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>82.0</td>\n",
       "      <td>224.0</td>\n",
       "      <td>320.0</td>\n",
       "      <td>521.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>279.0</td>\n",
       "      <td>192.0</td>\n",
       "      <td>568237</td>\n",
       "      <td>35846.0</td>\n",
       "      <td>1903.0</td>\n",
       "      <td>93490</td>\n",
       "      <td>56828</td>\n",
       "      <td>243152</td>\n",
       "      <td>320.0</td>\n",
       "      <td>4257</td>\n",
       "      <td>23842</td>\n",
       "      <td>490766.0</td>\n",
       "      <td>225610</td>\n",
       "      <td>7272</td>\n",
       "      <td>446.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>1198</td>\n",
       "      <td>1104</td>\n",
       "      <td>3103</td>\n",
       "      <td>521.0</td>\n",
       "      <td>4257</td>\n",
       "      <td>305</td>\n",
       "      <td>3588.0</td>\n",
       "      <td>2931</td>\n",
       "      <td>37450</td>\n",
       "      <td>2360.0</td>\n",
       "      <td>162.0</td>\n",
       "      <td>38205</td>\n",
       "      <td>4142</td>\n",
       "      <td>19184</td>\n",
       "      <td>29.0</td>\n",
       "      <td>23842</td>\n",
       "      <td>305</td>\n",
       "      <td>20365.0</td>\n",
       "      <td>15212</td>\n",
       "      <td>479722.0</td>\n",
       "      <td>29106.0</td>\n",
       "      <td>1825.0</td>\n",
       "      <td>80256.0</td>\n",
       "      <td>49910.0</td>\n",
       "      <td>174478.0</td>\n",
       "      <td>279.0</td>\n",
       "      <td>490766.0</td>\n",
       "      <td>3588.0</td>\n",
       "      <td>20365.0</td>\n",
       "      <td>204118.0</td>\n",
       "      <td>382010</td>\n",
       "      <td>24332.0</td>\n",
       "      <td>1440.0</td>\n",
       "      <td>58554</td>\n",
       "      <td>43454</td>\n",
       "      <td>148159</td>\n",
       "      <td>192.0</td>\n",
       "      <td>225610</td>\n",
       "      <td>2931</td>\n",
       "      <td>15212</td>\n",
       "      <td>204118.0</td>\n",
       "      <td>0.198519</td>\n",
       "      <td>0.196500</td>\n",
       "      <td>0.268362</td>\n",
       "      <td>0.302938</td>\n",
       "      <td>0.207853</td>\n",
       "      <td>0.196211</td>\n",
       "      <td>0.278788</td>\n",
       "      <td>0.211100</td>\n",
       "      <td>0.245263</td>\n",
       "      <td>0.277955</td>\n",
       "      <td>0.217787</td>\n",
       "      <td>0.209223</td>\n",
       "      <td>0.196008</td>\n",
       "      <td>0.267016</td>\n",
       "      <td>0.302257</td>\n",
       "      <td>0.206263</td>\n",
       "      <td>0.195492</td>\n",
       "      <td>0.277778</td>\n",
       "      <td>0.210028</td>\n",
       "      <td>0.243918</td>\n",
       "      <td>0.277690</td>\n",
       "      <td>0.216663</td>\n",
       "      <td>0.208617</td>\n",
       "      <td>0.196008</td>\n",
       "      <td>0.319444</td>\n",
       "      <td>0.295359</td>\n",
       "      <td>0.198097</td>\n",
       "      <td>0.191164</td>\n",
       "      <td>0.142857</td>\n",
       "      <td>0.205548</td>\n",
       "      <td>0.240283</td>\n",
       "      <td>0.273629</td>\n",
       "      <td>0.215190</td>\n",
       "      <td>0.210716</td>\n",
       "      <td>0.267016</td>\n",
       "      <td>0.319444</td>\n",
       "      <td>0.352785</td>\n",
       "      <td>0.188976</td>\n",
       "      <td>0.280788</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.285366</td>\n",
       "      <td>0.052632</td>\n",
       "      <td>0.324074</td>\n",
       "      <td>0.284139</td>\n",
       "      <td>0.285246</td>\n",
       "      <td>0.302257</td>\n",
       "      <td>0.295359</td>\n",
       "      <td>0.352785</td>\n",
       "      <td>0.305109</td>\n",
       "      <td>0.277774</td>\n",
       "      <td>0.396552</td>\n",
       "      <td>0.309783</td>\n",
       "      <td>0.342140</td>\n",
       "      <td>0.277955</td>\n",
       "      <td>0.318708</td>\n",
       "      <td>0.313129</td>\n",
       "      <td>0.206263</td>\n",
       "      <td>0.198097</td>\n",
       "      <td>0.188976</td>\n",
       "      <td>0.305109</td>\n",
       "      <td>0.207478</td>\n",
       "      <td>0.387755</td>\n",
       "      <td>0.219285</td>\n",
       "      <td>0.253879</td>\n",
       "      <td>0.283979</td>\n",
       "      <td>0.224909</td>\n",
       "      <td>0.215086</td>\n",
       "      <td>0.195492</td>\n",
       "      <td>0.191164</td>\n",
       "      <td>0.280788</td>\n",
       "      <td>0.277774</td>\n",
       "      <td>0.207478</td>\n",
       "      <td>0.244444</td>\n",
       "      <td>0.206971</td>\n",
       "      <td>0.224849</td>\n",
       "      <td>0.253801</td>\n",
       "      <td>0.221935</td>\n",
       "      <td>0.208437</td>\n",
       "      <td>0.277778</td>\n",
       "      <td>0.142857</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.396552</td>\n",
       "      <td>0.387755</td>\n",
       "      <td>0.244444</td>\n",
       "      <td>0.274038</td>\n",
       "      <td>0.278788</td>\n",
       "      <td>0.466667</td>\n",
       "      <td>0.288043</td>\n",
       "      <td>0.299145</td>\n",
       "      <td>0.210028</td>\n",
       "      <td>0.205548</td>\n",
       "      <td>0.285366</td>\n",
       "      <td>0.309783</td>\n",
       "      <td>0.219285</td>\n",
       "      <td>0.206971</td>\n",
       "      <td>0.274038</td>\n",
       "      <td>0.252119</td>\n",
       "      <td>0.281452</td>\n",
       "      <td>0.217780</td>\n",
       "      <td>0.219645</td>\n",
       "      <td>0.243918</td>\n",
       "      <td>0.240283</td>\n",
       "      <td>0.052632</td>\n",
       "      <td>0.342140</td>\n",
       "      <td>0.253879</td>\n",
       "      <td>0.224849</td>\n",
       "      <td>0.278788</td>\n",
       "      <td>0.252119</td>\n",
       "      <td>0.302198</td>\n",
       "      <td>0.265359</td>\n",
       "      <td>0.272537</td>\n",
       "      <td>0.277690</td>\n",
       "      <td>0.273629</td>\n",
       "      <td>0.324074</td>\n",
       "      <td>0.277955</td>\n",
       "      <td>0.283979</td>\n",
       "      <td>0.253801</td>\n",
       "      <td>0.466667</td>\n",
       "      <td>0.281452</td>\n",
       "      <td>0.302198</td>\n",
       "      <td>0.289248</td>\n",
       "      <td>0.290678</td>\n",
       "      <td>0.216663</td>\n",
       "      <td>0.215190</td>\n",
       "      <td>0.284139</td>\n",
       "      <td>0.318708</td>\n",
       "      <td>0.224909</td>\n",
       "      <td>0.221935</td>\n",
       "      <td>0.288043</td>\n",
       "      <td>0.217780</td>\n",
       "      <td>0.265359</td>\n",
       "      <td>0.289248</td>\n",
       "      <td>0.223279</td>\n",
       "      <td>0.208617</td>\n",
       "      <td>0.210716</td>\n",
       "      <td>0.285246</td>\n",
       "      <td>0.313129</td>\n",
       "      <td>0.215086</td>\n",
       "      <td>0.208437</td>\n",
       "      <td>0.299145</td>\n",
       "      <td>0.219645</td>\n",
       "      <td>0.272537</td>\n",
       "      <td>0.290678</td>\n",
       "      <td>0.223279</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>52000.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18.44</td>\n",
       "      <td>Jul-2004</td>\n",
       "      <td>10.0</td>\n",
       "      <td>81832.0</td>\n",
       "      <td>709.0</td>\n",
       "      <td>705.0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>42</td>\n",
       "      <td>1</td>\n",
       "      <td>298.13</td>\n",
       "      <td>13.35</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2014-10-01</td>\n",
       "      <td>13000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>524.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4</td>\n",
       "      <td>20</td>\n",
       "      <td>17703.0</td>\n",
       "      <td>38.8</td>\n",
       "      <td>16</td>\n",
       "      <td>5</td>\n",
       "      <td>4.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>1</td>\n",
       "      <td>2014</td>\n",
       "      <td>2004</td>\n",
       "      <td>10</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>980693</td>\n",
       "      <td>328525.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>283819</td>\n",
       "      <td>397051</td>\n",
       "      <td>416892</td>\n",
       "      <td>1190.0</td>\n",
       "      <td>219331</td>\n",
       "      <td>11454</td>\n",
       "      <td>58859</td>\n",
       "      <td>185386.0</td>\n",
       "      <td>387568</td>\n",
       "      <td>323591.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>277596</td>\n",
       "      <td>392585</td>\n",
       "      <td>413022</td>\n",
       "      <td>1180.0</td>\n",
       "      <td>216045</td>\n",
       "      <td>11237</td>\n",
       "      <td>57751</td>\n",
       "      <td>182191.0</td>\n",
       "      <td>382010</td>\n",
       "      <td>323591.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>92220.0</td>\n",
       "      <td>92526.0</td>\n",
       "      <td>131414.0</td>\n",
       "      <td>299.0</td>\n",
       "      <td>68507.0</td>\n",
       "      <td>3717.0</td>\n",
       "      <td>19146.0</td>\n",
       "      <td>58340.0</td>\n",
       "      <td>126358.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>277596</td>\n",
       "      <td>92220.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>118735</td>\n",
       "      <td>112799</td>\n",
       "      <td>296.0</td>\n",
       "      <td>54829</td>\n",
       "      <td>3224</td>\n",
       "      <td>58859</td>\n",
       "      <td>46251.0</td>\n",
       "      <td>114416</td>\n",
       "      <td>392585</td>\n",
       "      <td>92526.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>118735</td>\n",
       "      <td>175144</td>\n",
       "      <td>579.0</td>\n",
       "      <td>90618</td>\n",
       "      <td>2940</td>\n",
       "      <td>24964</td>\n",
       "      <td>76076.0</td>\n",
       "      <td>161834</td>\n",
       "      <td>413022</td>\n",
       "      <td>131414.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>112799</td>\n",
       "      <td>175144</td>\n",
       "      <td>529.0</td>\n",
       "      <td>85758</td>\n",
       "      <td>4769</td>\n",
       "      <td>24400</td>\n",
       "      <td>60380.0</td>\n",
       "      <td>148159</td>\n",
       "      <td>1180.0</td>\n",
       "      <td>299.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>296.0</td>\n",
       "      <td>579.0</td>\n",
       "      <td>529.0</td>\n",
       "      <td>265.0</td>\n",
       "      <td>1189.0</td>\n",
       "      <td>70.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>487.0</td>\n",
       "      <td>216045</td>\n",
       "      <td>68507.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>54829</td>\n",
       "      <td>90618</td>\n",
       "      <td>85758</td>\n",
       "      <td>265.0</td>\n",
       "      <td>2262</td>\n",
       "      <td>11828</td>\n",
       "      <td>185061.0</td>\n",
       "      <td>84936</td>\n",
       "      <td>11237</td>\n",
       "      <td>3717.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3224</td>\n",
       "      <td>2940</td>\n",
       "      <td>4769</td>\n",
       "      <td>1189.0</td>\n",
       "      <td>2262</td>\n",
       "      <td>675</td>\n",
       "      <td>1887.0</td>\n",
       "      <td>4729</td>\n",
       "      <td>57751</td>\n",
       "      <td>19146.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>58859</td>\n",
       "      <td>24964</td>\n",
       "      <td>24400</td>\n",
       "      <td>70.0</td>\n",
       "      <td>11828</td>\n",
       "      <td>675</td>\n",
       "      <td>9930.0</td>\n",
       "      <td>23481</td>\n",
       "      <td>182191.0</td>\n",
       "      <td>58340.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>46251.0</td>\n",
       "      <td>76076.0</td>\n",
       "      <td>60380.0</td>\n",
       "      <td>220.0</td>\n",
       "      <td>185061.0</td>\n",
       "      <td>1887.0</td>\n",
       "      <td>9930.0</td>\n",
       "      <td>76647.0</td>\n",
       "      <td>382010</td>\n",
       "      <td>126358.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>114416</td>\n",
       "      <td>161834</td>\n",
       "      <td>148159</td>\n",
       "      <td>487.0</td>\n",
       "      <td>84936</td>\n",
       "      <td>4729</td>\n",
       "      <td>23481</td>\n",
       "      <td>76647.0</td>\n",
       "      <td>0.198519</td>\n",
       "      <td>0.186543</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.225775</td>\n",
       "      <td>0.231709</td>\n",
       "      <td>0.196211</td>\n",
       "      <td>0.196335</td>\n",
       "      <td>0.169704</td>\n",
       "      <td>0.234083</td>\n",
       "      <td>0.206614</td>\n",
       "      <td>0.176027</td>\n",
       "      <td>0.209223</td>\n",
       "      <td>0.186093</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.224810</td>\n",
       "      <td>0.230400</td>\n",
       "      <td>0.195492</td>\n",
       "      <td>0.194188</td>\n",
       "      <td>0.169266</td>\n",
       "      <td>0.231709</td>\n",
       "      <td>0.205435</td>\n",
       "      <td>0.175586</td>\n",
       "      <td>0.208617</td>\n",
       "      <td>0.186093</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.209869</td>\n",
       "      <td>0.236903</td>\n",
       "      <td>0.185077</td>\n",
       "      <td>0.195980</td>\n",
       "      <td>0.161127</td>\n",
       "      <td>0.218491</td>\n",
       "      <td>0.196421</td>\n",
       "      <td>0.166206</td>\n",
       "      <td>0.195361</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.224810</td>\n",
       "      <td>0.209869</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.251310</td>\n",
       "      <td>0.204216</td>\n",
       "      <td>0.198895</td>\n",
       "      <td>0.231318</td>\n",
       "      <td>0.257762</td>\n",
       "      <td>0.206614</td>\n",
       "      <td>0.242309</td>\n",
       "      <td>0.233434</td>\n",
       "      <td>0.230400</td>\n",
       "      <td>0.236903</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.251310</td>\n",
       "      <td>0.222544</td>\n",
       "      <td>0.222222</td>\n",
       "      <td>0.196344</td>\n",
       "      <td>0.253123</td>\n",
       "      <td>0.229465</td>\n",
       "      <td>0.205132</td>\n",
       "      <td>0.242804</td>\n",
       "      <td>0.195492</td>\n",
       "      <td>0.185077</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.204216</td>\n",
       "      <td>0.222544</td>\n",
       "      <td>0.190202</td>\n",
       "      <td>0.163872</td>\n",
       "      <td>0.215349</td>\n",
       "      <td>0.187063</td>\n",
       "      <td>0.178506</td>\n",
       "      <td>0.208437</td>\n",
       "      <td>0.194188</td>\n",
       "      <td>0.195980</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.198895</td>\n",
       "      <td>0.222222</td>\n",
       "      <td>0.190202</td>\n",
       "      <td>0.147239</td>\n",
       "      <td>0.196592</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.151079</td>\n",
       "      <td>0.207547</td>\n",
       "      <td>0.169266</td>\n",
       "      <td>0.161127</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.231318</td>\n",
       "      <td>0.196344</td>\n",
       "      <td>0.163872</td>\n",
       "      <td>0.147239</td>\n",
       "      <td>0.204752</td>\n",
       "      <td>0.212917</td>\n",
       "      <td>0.175973</td>\n",
       "      <td>0.180280</td>\n",
       "      <td>0.231709</td>\n",
       "      <td>0.218491</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.257762</td>\n",
       "      <td>0.253123</td>\n",
       "      <td>0.215349</td>\n",
       "      <td>0.196592</td>\n",
       "      <td>0.204752</td>\n",
       "      <td>0.262651</td>\n",
       "      <td>0.215232</td>\n",
       "      <td>0.248682</td>\n",
       "      <td>0.205435</td>\n",
       "      <td>0.196421</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.206614</td>\n",
       "      <td>0.229465</td>\n",
       "      <td>0.187063</td>\n",
       "      <td>0.190476</td>\n",
       "      <td>0.212917</td>\n",
       "      <td>0.262651</td>\n",
       "      <td>0.222153</td>\n",
       "      <td>0.212162</td>\n",
       "      <td>0.175586</td>\n",
       "      <td>0.166206</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.242309</td>\n",
       "      <td>0.205132</td>\n",
       "      <td>0.178506</td>\n",
       "      <td>0.151079</td>\n",
       "      <td>0.175973</td>\n",
       "      <td>0.215232</td>\n",
       "      <td>0.222153</td>\n",
       "      <td>0.184116</td>\n",
       "      <td>0.208617</td>\n",
       "      <td>0.195361</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.233434</td>\n",
       "      <td>0.242804</td>\n",
       "      <td>0.208437</td>\n",
       "      <td>0.207547</td>\n",
       "      <td>0.180280</td>\n",
       "      <td>0.248682</td>\n",
       "      <td>0.212162</td>\n",
       "      <td>0.184116</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   annualIncome  applicationType  delinquency_2years    dti earliesCreditLine  \\\n",
       "0       46000.0                0                 0.0  27.83          May-2002   \n",
       "1       47500.0                0                 0.0  24.36          Mar-2000   \n",
       "2       40000.0                0                 2.0  12.57          Apr-2000   \n",
       "3       30000.0                0                 0.0  20.20          Jul-2007   \n",
       "4       52000.0                0                 0.0  18.44          Jul-2004   \n",
       "\n",
       "   employmentLength  employmentTitle  ficoRangeHigh  ficoRangeLow  grade  \\\n",
       "0               5.0         219843.0          704.0         700.0      4   \n",
       "1               4.0            386.0          669.0         665.0      3   \n",
       "2              10.0           2780.0          669.0         665.0      1   \n",
       "3               5.0            132.0          689.0         685.0      4   \n",
       "4              10.0          81832.0          709.0         705.0      3   \n",
       "\n",
       "   homeOwnership  id  initialListStatus  installment  interestRate  isDefault  \\\n",
       "0              0   1                  1       461.90         18.49        0.0   \n",
       "1              1  23                  0       684.33         14.08        1.0   \n",
       "2              0  28                  0       266.31          8.59        0.0   \n",
       "3              2  32                  1       349.55         15.59        0.0   \n",
       "4              1  42                  1       298.13         13.35        1.0   \n",
       "\n",
       "    issueDate  loanAmnt   n0   n1   n10  n11  n12  n13  n14   n2   n3    n4  \\\n",
       "0  2012-08-01   18000.0  NaN  NaN  13.0  NaN  NaN  NaN  NaN  NaN  NaN  10.0   \n",
       "1  2018-01-01   20000.0  0.0  4.0   7.0  0.0  0.0  0.0  1.0  4.0  4.0   4.0   \n",
       "2  2016-08-01    8425.0  0.0  5.0  17.0  0.0  0.0  0.0  1.0  9.0  9.0   8.0   \n",
       "3  2015-01-01   10000.0  0.0  2.0   7.0  0.0  0.0  0.0  4.0  3.0  3.0   3.0   \n",
       "4  2014-10-01   13000.0  0.0  3.0   7.0  0.0  0.0  0.0  1.0  5.0  5.0   4.0   \n",
       "\n",
       "    n5   n6    n7    n8   n9  openAcc  postCode  pubRec  pubRecBankruptcies  \\\n",
       "0  NaN  NaN   NaN   NaN  NaN     13.0     156.0     0.0                 0.0   \n",
       "1  7.0  9.0   6.0  10.0  4.0      7.0     226.0     0.0                 0.0   \n",
       "2  8.0  5.0  17.0  18.0  9.0     17.0     245.0     1.0                 1.0   \n",
       "3  4.0  9.0   6.0   8.0  3.0      7.0     413.0     0.0                 0.0   \n",
       "4  5.0  5.0   6.0   8.0  5.0      7.0     524.0     0.0                 0.0   \n",
       "\n",
       "   purpose  regionCode  revolBal  revolUtil  subGrade  term   title  totalAcc  \\\n",
       "0        0          18   15096.0       38.9        21     5  1723.0      18.0   \n",
       "1        9          21   19497.0       53.1        17     3    10.0      19.0   \n",
       "2        0          26    7993.0       33.9         9     3     0.0      23.0   \n",
       "3        0          37    6772.0       41.3        20     3     0.0      17.0   \n",
       "4        4          20   17703.0       38.8        16     5     4.0      13.0   \n",
       "\n",
       "   verificationStatus  issueDate_year  earliesCreditLine_year  \\\n",
       "0                   2            2012                    2002   \n",
       "1                   1            2018                    2000   \n",
       "2                   0            2016                    2000   \n",
       "3                   1            2015                    2007   \n",
       "4                   1            2014                    2004   \n",
       "\n",
       "   issueDate_year_earliesCreditLine_year_minus  debt_ratio_year  \\\n",
       "0                                           10         0.078261   \n",
       "1                                           18         0.140351   \n",
       "2                                           16         0.070208   \n",
       "3                                            8         0.111111   \n",
       "4                                           10         0.050000   \n",
       "\n",
       "   applicationType_cnt  employmentLength_cnt  employmentTitle_cnt  grade_cnt  \\\n",
       "0               980693               62645.0                151.0     149377   \n",
       "1               980693               59818.0                275.0     283819   \n",
       "2               980693              328525.0                149.0     174588   \n",
       "3               980693               62645.0               3315.0     149377   \n",
       "4               980693              328525.0                  3.0     283819   \n",
       "\n",
       "   homeOwnership_cnt  initialListStatus_cnt  postCode_cnt  purpose_cnt  \\\n",
       "0             494678                 416892        4751.0       580226   \n",
       "1             397051                 583108        2429.0        11560   \n",
       "2             494678                 583108        2546.0       580226   \n",
       "3             107910                 416892         521.0       580226   \n",
       "4             397051                 416892        1190.0       219331   \n",
       "\n",
       "   regionCode_cnt  subGrade_cnt  title_cnt  verificationStatus_cnt  \\\n",
       "0           21572         33241       37.0                  311132   \n",
       "1           71163         55769    10103.0                  387568   \n",
       "2           23086         47674   491400.0                  301300   \n",
       "3            7470         38205   491400.0                  387568   \n",
       "4           11454         58859   185386.0                  387568   \n",
       "\n",
       "   applicationType_employmentLength_cnt  applicationType_employmentTitle_cnt  \\\n",
       "0                               61706.0                                151.0   \n",
       "1                               58878.0                                273.0   \n",
       "2                              323591.0                                143.0   \n",
       "3                               61706.0                               3279.0   \n",
       "4                              323591.0                                  3.0   \n",
       "\n",
       "   applicationType_grade_cnt  applicationType_homeOwnership_cnt  \\\n",
       "0                     145912                             481648   \n",
       "1                     277596                             392585   \n",
       "2                     171997                             481648   \n",
       "3                     145912                             106101   \n",
       "4                     277596                             392585   \n",
       "\n",
       "   applicationType_initialListStatus_cnt  applicationType_postCode_cnt  \\\n",
       "0                                 413022                        4662.0   \n",
       "1                                 567671                        2363.0   \n",
       "2                                 567671                        2504.0   \n",
       "3                                 413022                         511.0   \n",
       "4                                 413022                        1180.0   \n",
       "\n",
       "   applicationType_purpose_cnt  applicationType_regionCode_cnt  \\\n",
       "0                       568237                           21064   \n",
       "1                        11232                           69827   \n",
       "2                       568237                           22724   \n",
       "3                       568237                            7272   \n",
       "4                       216045                           11237   \n",
       "\n",
       "   applicationType_subGrade_cnt  applicationType_title_cnt  \\\n",
       "0                         32426                       37.0   \n",
       "1                         54572                     9780.0   \n",
       "2                         47016                   479722.0   \n",
       "3                         37450                   479722.0   \n",
       "4                         57751                   182191.0   \n",
       "\n",
       "   applicationType_verificationStatus_cnt  \\\n",
       "0                                  303690   \n",
       "1                                  382010   \n",
       "2                                  294993   \n",
       "3                                  382010   \n",
       "4                                  382010   \n",
       "\n",
       "   employmentLength_applicationType_cnt  employmentLength_employmentTitle_cnt  \\\n",
       "0                               61706.0                                   7.0   \n",
       "1                               58878.0                                  29.0   \n",
       "2                              323591.0                                  40.0   \n",
       "3                               61706.0                                 229.0   \n",
       "4                              323591.0                                   1.0   \n",
       "\n",
       "   employmentLength_grade_cnt  employmentLength_homeOwnership_cnt  \\\n",
       "0                      9312.0                             28984.0   \n",
       "1                     16913.0                             27208.0   \n",
       "2                     59278.0                            199068.0   \n",
       "3                      9312.0                              6455.0   \n",
       "4                     92220.0                             92526.0   \n",
       "\n",
       "   employmentLength_initialListStatus_cnt  employmentLength_postCode_cnt  \\\n",
       "0                                 27473.0                          314.0   \n",
       "1                                 34001.0                          140.0   \n",
       "2                                197111.0                          896.0   \n",
       "3                                 27473.0                           26.0   \n",
       "4                                131414.0                          299.0   \n",
       "\n",
       "   employmentLength_purpose_cnt  employmentLength_regionCode_cnt  \\\n",
       "0                       35846.0                           1335.0   \n",
       "1                         694.0                           4413.0   \n",
       "2                      195388.0                           7451.0   \n",
       "3                       35846.0                            446.0   \n",
       "4                       68507.0                           3717.0   \n",
       "\n",
       "   employmentLength_subGrade_cnt  employmentLength_title_cnt  \\\n",
       "0                         2085.0                         4.0   \n",
       "1                         3303.0                       600.0   \n",
       "2                        15968.0                    167561.0   \n",
       "3                         2360.0                     29106.0   \n",
       "4                        19146.0                     58340.0   \n",
       "\n",
       "   employmentLength_verificationStatus_cnt  \\\n",
       "0                                  18362.0   \n",
       "1                                  23854.0   \n",
       "2                                  98538.0   \n",
       "3                                  24332.0   \n",
       "4                                 126358.0   \n",
       "\n",
       "   employmentTitle_applicationType_cnt  employmentTitle_employmentLength_cnt  \\\n",
       "0                                151.0                                   7.0   \n",
       "1                                273.0                                  29.0   \n",
       "2                                143.0                                  40.0   \n",
       "3                               3279.0                                 229.0   \n",
       "4                                  3.0                                   1.0   \n",
       "\n",
       "   employmentTitle_grade_cnt  employmentTitle_homeOwnership_cnt  \\\n",
       "0                       20.0                               83.0   \n",
       "1                       81.0                               70.0   \n",
       "2                       14.0                               49.0   \n",
       "3                      592.0                              407.0   \n",
       "4                        2.0                                3.0   \n",
       "\n",
       "   employmentTitle_initialListStatus_cnt  employmentTitle_postCode_cnt  \\\n",
       "0                                  121.0                           2.0   \n",
       "1                                  189.0                           1.0   \n",
       "2                                   95.0                           1.0   \n",
       "3                                 1270.0                           6.0   \n",
       "4                                    3.0                           1.0   \n",
       "\n",
       "   employmentTitle_purpose_cnt  employmentTitle_regionCode_cnt  \\\n",
       "0                         92.0                             5.0   \n",
       "1                          2.0                            13.0   \n",
       "2                         85.0                             7.0   \n",
       "3                       1903.0                            28.0   \n",
       "4                          1.0                             1.0   \n",
       "\n",
       "   employmentTitle_subGrade_cnt  employmentTitle_title_cnt  \\\n",
       "0                           4.0                        1.0   \n",
       "1                          16.0                        2.0   \n",
       "2                           8.0                       85.0   \n",
       "3                         162.0                     1825.0   \n",
       "4                           1.0                        1.0   \n",
       "\n",
       "   employmentTitle_verificationStatus_cnt  grade_applicationType_cnt  \\\n",
       "0                                    90.0                     145912   \n",
       "1                                    98.0                     277596   \n",
       "2                                    40.0                     171997   \n",
       "3                                  1440.0                     145912   \n",
       "4                                     2.0                     277596   \n",
       "\n",
       "   grade_employmentLength_cnt  grade_employmentTitle_cnt  \\\n",
       "0                      9312.0                       20.0   \n",
       "1                     16913.0                       81.0   \n",
       "2                     59278.0                       14.0   \n",
       "3                      9312.0                      592.0   \n",
       "4                     92220.0                        2.0   \n",
       "\n",
       "   grade_homeOwnership_cnt  grade_initialListStatus_cnt  grade_postCode_cnt  \\\n",
       "0                    67798                        73095               655.0   \n",
       "1                   118735                       171020               687.0   \n",
       "2                   100381                       117213               528.0   \n",
       "3                    16499                        73095                90.0   \n",
       "4                   118735                       112799               296.0   \n",
       "\n",
       "   grade_purpose_cnt  grade_regionCode_cnt  grade_subGrade_cnt  \\\n",
       "0              93490                  3213               33241   \n",
       "1               3591                 20563               55769   \n",
       "2              85590                  4991               47674   \n",
       "3              93490                  1198               38205   \n",
       "4              54829                  3224               58859   \n",
       "\n",
       "   grade_title_cnt  grade_verificationStatus_cnt  \\\n",
       "0              8.0                         59182   \n",
       "1           3276.0                        114416   \n",
       "2          72704.0                         80620   \n",
       "3          80256.0                         58554   \n",
       "4          46251.0                        114416   \n",
       "\n",
       "   homeOwnership_applicationType_cnt  homeOwnership_employmentLength_cnt  \\\n",
       "0                             481648                             28984.0   \n",
       "1                             392585                             27208.0   \n",
       "2                             481648                            199068.0   \n",
       "3                             106101                              6455.0   \n",
       "4                             392585                             92526.0   \n",
       "\n",
       "   homeOwnership_employmentTitle_cnt  homeOwnership_grade_cnt  \\\n",
       "0                               83.0                    67798   \n",
       "1                               70.0                   118735   \n",
       "2                               49.0                   100381   \n",
       "3                              407.0                    16499   \n",
       "4                                3.0                   118735   \n",
       "\n",
       "   homeOwnership_initialListStatus_cnt  homeOwnership_postCode_cnt  \\\n",
       "0                               199082                      2128.0   \n",
       "1                               221907                       951.0   \n",
       "2                               295596                      1151.0   \n",
       "3                                42474                        82.0   \n",
       "4                               175144                       579.0   \n",
       "\n",
       "   homeOwnership_purpose_cnt  homeOwnership_regionCode_cnt  \\\n",
       "0                     287217                         10719   \n",
       "1                       4960                         28919   \n",
       "2                     287217                         10362   \n",
       "3                      56828                          1104   \n",
       "4                      90618                          2940   \n",
       "\n",
       "   homeOwnership_subGrade_cnt  homeOwnership_title_cnt  \\\n",
       "0                       14925                     23.0   \n",
       "1                       23222                   4288.0   \n",
       "2                       25652                 243453.0   \n",
       "3                        4142                  49910.0   \n",
       "4                       24964                  76076.0   \n",
       "\n",
       "   homeOwnership_verificationStatus_cnt  \\\n",
       "0                                160130   \n",
       "1                                161834   \n",
       "2                                152373   \n",
       "3                                 43454   \n",
       "4                                161834   \n",
       "\n",
       "   initialListStatus_applicationType_cnt  \\\n",
       "0                                 413022   \n",
       "1                                 567671   \n",
       "2                                 567671   \n",
       "3                                 413022   \n",
       "4                                 413022   \n",
       "\n",
       "   initialListStatus_employmentLength_cnt  \\\n",
       "0                                 27473.0   \n",
       "1                                 34001.0   \n",
       "2                                197111.0   \n",
       "3                                 27473.0   \n",
       "4                                131414.0   \n",
       "\n",
       "   initialListStatus_employmentTitle_cnt  initialListStatus_grade_cnt  \\\n",
       "0                                  121.0                        73095   \n",
       "1                                  189.0                       171020   \n",
       "2                                   95.0                       117213   \n",
       "3                                 1270.0                        73095   \n",
       "4                                    3.0                       112799   \n",
       "\n",
       "   initialListStatus_homeOwnership_cnt  initialListStatus_postCode_cnt  \\\n",
       "0                               199082                          2020.0   \n",
       "1                               221907                          1457.0   \n",
       "2                               295596                          1483.0   \n",
       "3                                42474                           224.0   \n",
       "4                               175144                           529.0   \n",
       "\n",
       "   initialListStatus_purpose_cnt  initialListStatus_regionCode_cnt  \\\n",
       "0                         243152                              9080   \n",
       "1                           6604                             41589   \n",
       "2                         337074                             13626   \n",
       "3                         243152                              3103   \n",
       "4                          85758                              4769   \n",
       "\n",
       "   initialListStatus_subGrade_cnt  initialListStatus_title_cnt  \\\n",
       "0                           16525                         31.0   \n",
       "1                           33842                       6377.0   \n",
       "2                           31821                     316922.0   \n",
       "3                           19184                     174478.0   \n",
       "4                           24400                      60380.0   \n",
       "\n",
       "   initialListStatus_verificationStatus_cnt  postCode_applicationType_cnt  \\\n",
       "0                                    146424                        4662.0   \n",
       "1                                    239409                        2363.0   \n",
       "2                                    178991                        2504.0   \n",
       "3                                    148159                         511.0   \n",
       "4                                    148159                        1180.0   \n",
       "\n",
       "   postCode_employmentLength_cnt  postCode_employmentTitle_cnt  \\\n",
       "0                          314.0                           2.0   \n",
       "1                          140.0                           1.0   \n",
       "2                          896.0                           1.0   \n",
       "3                           26.0                           6.0   \n",
       "4                          299.0                           1.0   \n",
       "\n",
       "   postCode_grade_cnt  postCode_homeOwnership_cnt  \\\n",
       "0               655.0                      2128.0   \n",
       "1               687.0                       951.0   \n",
       "2               528.0                      1151.0   \n",
       "3                90.0                        82.0   \n",
       "4               296.0                       579.0   \n",
       "\n",
       "   postCode_initialListStatus_cnt  postCode_purpose_cnt  \\\n",
       "0                          2020.0                2790.0   \n",
       "1                          1457.0                  44.0   \n",
       "2                          1483.0                1511.0   \n",
       "3                           224.0                 320.0   \n",
       "4                           529.0                 265.0   \n",
       "\n",
       "   postCode_regionCode_cnt  postCode_subGrade_cnt  postCode_title_cnt  \\\n",
       "0                   4747.0                  145.0                 1.0   \n",
       "1                   2426.0                  114.0                41.0   \n",
       "2                   2542.0                  133.0              1253.0   \n",
       "3                    521.0                   29.0               279.0   \n",
       "4                   1189.0                   70.0               220.0   \n",
       "\n",
       "   postCode_verificationStatus_cnt  purpose_applicationType_cnt  \\\n",
       "0                           1592.0                       568237   \n",
       "1                            954.0                        11232   \n",
       "2                            793.0                       568237   \n",
       "3                            192.0                       568237   \n",
       "4                            487.0                       216045   \n",
       "\n",
       "   purpose_employmentLength_cnt  purpose_employmentTitle_cnt  \\\n",
       "0                       35846.0                         92.0   \n",
       "1                         694.0                          2.0   \n",
       "2                      195388.0                         85.0   \n",
       "3                       35846.0                       1903.0   \n",
       "4                       68507.0                          1.0   \n",
       "\n",
       "   purpose_grade_cnt  purpose_homeOwnership_cnt  \\\n",
       "0              93490                     287217   \n",
       "1               3591                       4960   \n",
       "2              85590                     287217   \n",
       "3              93490                      56828   \n",
       "4              54829                      90618   \n",
       "\n",
       "   purpose_initialListStatus_cnt  purpose_postCode_cnt  \\\n",
       "0                         243152                2790.0   \n",
       "1                           6604                  44.0   \n",
       "2                         337074                1511.0   \n",
       "3                         243152                 320.0   \n",
       "4                          85758                 265.0   \n",
       "\n",
       "   purpose_regionCode_cnt  purpose_subGrade_cnt  purpose_title_cnt  \\\n",
       "0                   12902                 20770               27.0   \n",
       "1                     842                   723            10082.0   \n",
       "2                   13584                 25078           490766.0   \n",
       "3                    4257                 23842           490766.0   \n",
       "4                    2262                 11828           185061.0   \n",
       "\n",
       "   purpose_verificationStatus_cnt  regionCode_applicationType_cnt  \\\n",
       "0                          189929                           21064   \n",
       "1                            4383                           69827   \n",
       "2                          164687                           22724   \n",
       "3                          225610                            7272   \n",
       "4                           84936                           11237   \n",
       "\n",
       "   regionCode_employmentLength_cnt  regionCode_employmentTitle_cnt  \\\n",
       "0                           1335.0                             5.0   \n",
       "1                           4413.0                            13.0   \n",
       "2                           7451.0                             7.0   \n",
       "3                            446.0                            28.0   \n",
       "4                           3717.0                             1.0   \n",
       "\n",
       "   regionCode_grade_cnt  regionCode_homeOwnership_cnt  \\\n",
       "0                  3213                         10719   \n",
       "1                 20563                         28919   \n",
       "2                  4991                         10362   \n",
       "3                  1198                          1104   \n",
       "4                  3224                          2940   \n",
       "\n",
       "   regionCode_initialListStatus_cnt  regionCode_postCode_cnt  \\\n",
       "0                              9080                   4747.0   \n",
       "1                             41589                   2426.0   \n",
       "2                             13626                   2542.0   \n",
       "3                              3103                    521.0   \n",
       "4                              4769                   1189.0   \n",
       "\n",
       "   regionCode_purpose_cnt  regionCode_subGrade_cnt  regionCode_title_cnt  \\\n",
       "0                   12902                      700                   3.0   \n",
       "1                     842                     3992                 742.0   \n",
       "2                   13584                     1289               11262.0   \n",
       "3                    4257                      305                3588.0   \n",
       "4                    2262                      675                1887.0   \n",
       "\n",
       "   regionCode_verificationStatus_cnt  subGrade_applicationType_cnt  \\\n",
       "0                               7009                         32426   \n",
       "1                              28042                         54572   \n",
       "2                               7322                         47016   \n",
       "3                               2931                         37450   \n",
       "4                               4729                         57751   \n",
       "\n",
       "   subGrade_employmentLength_cnt  subGrade_employmentTitle_cnt  \\\n",
       "0                         2085.0                           4.0   \n",
       "1                         3303.0                          16.0   \n",
       "2                        15968.0                           8.0   \n",
       "3                         2360.0                         162.0   \n",
       "4                        19146.0                           1.0   \n",
       "\n",
       "   subGrade_grade_cnt  subGrade_homeOwnership_cnt  \\\n",
       "0               33241                       14925   \n",
       "1               55769                       23222   \n",
       "2               47674                       25652   \n",
       "3               38205                        4142   \n",
       "4               58859                       24964   \n",
       "\n",
       "   subGrade_initialListStatus_cnt  subGrade_postCode_cnt  \\\n",
       "0                           16525                  145.0   \n",
       "1                           33842                  114.0   \n",
       "2                           31821                  133.0   \n",
       "3                           19184                   29.0   \n",
       "4                           24400                   70.0   \n",
       "\n",
       "   subGrade_purpose_cnt  subGrade_regionCode_cnt  subGrade_title_cnt  \\\n",
       "0                 20770                      700                 2.0   \n",
       "1                   723                     3992               667.0   \n",
       "2                 25078                     1289             21210.0   \n",
       "3                 23842                      305             20365.0   \n",
       "4                 11828                      675              9930.0   \n",
       "\n",
       "   subGrade_verificationStatus_cnt  title_applicationType_cnt  \\\n",
       "0                            12593                       37.0   \n",
       "1                            22517                     9780.0   \n",
       "2                            18138                   479722.0   \n",
       "3                            15212                   479722.0   \n",
       "4                            23481                   182191.0   \n",
       "\n",
       "   title_employmentLength_cnt  title_employmentTitle_cnt  title_grade_cnt  \\\n",
       "0                         4.0                        1.0              8.0   \n",
       "1                       600.0                        2.0           3276.0   \n",
       "2                    167561.0                       85.0          72704.0   \n",
       "3                     29106.0                     1825.0          80256.0   \n",
       "4                     58340.0                        1.0          46251.0   \n",
       "\n",
       "   title_homeOwnership_cnt  title_initialListStatus_cnt  title_postCode_cnt  \\\n",
       "0                     23.0                         31.0                 1.0   \n",
       "1                   4288.0                       6377.0                41.0   \n",
       "2                 243453.0                     316922.0              1253.0   \n",
       "3                  49910.0                     174478.0               279.0   \n",
       "4                  76076.0                      60380.0               220.0   \n",
       "\n",
       "   title_purpose_cnt  title_regionCode_cnt  title_subGrade_cnt  \\\n",
       "0               27.0                   3.0                 2.0   \n",
       "1            10082.0                 742.0               667.0   \n",
       "2           490766.0               11262.0             21210.0   \n",
       "3           490766.0                3588.0             20365.0   \n",
       "4           185061.0                1887.0              9930.0   \n",
       "\n",
       "   title_verificationStatus_cnt  verificationStatus_applicationType_cnt  \\\n",
       "0                          24.0                                  303690   \n",
       "1                        3966.0                                  382010   \n",
       "2                      137836.0                                  294993   \n",
       "3                      204118.0                                  382010   \n",
       "4                       76647.0                                  382010   \n",
       "\n",
       "   verificationStatus_employmentLength_cnt  \\\n",
       "0                                  18362.0   \n",
       "1                                  23854.0   \n",
       "2                                  98538.0   \n",
       "3                                  24332.0   \n",
       "4                                 126358.0   \n",
       "\n",
       "   verificationStatus_employmentTitle_cnt  verificationStatus_grade_cnt  \\\n",
       "0                                    90.0                         59182   \n",
       "1                                    98.0                        114416   \n",
       "2                                    40.0                         80620   \n",
       "3                                  1440.0                         58554   \n",
       "4                                     2.0                        114416   \n",
       "\n",
       "   verificationStatus_homeOwnership_cnt  \\\n",
       "0                                160130   \n",
       "1                                161834   \n",
       "2                                152373   \n",
       "3                                 43454   \n",
       "4                                161834   \n",
       "\n",
       "   verificationStatus_initialListStatus_cnt  verificationStatus_postCode_cnt  \\\n",
       "0                                    146424                           1592.0   \n",
       "1                                    239409                            954.0   \n",
       "2                                    178991                            793.0   \n",
       "3                                    148159                            192.0   \n",
       "4                                    148159                            487.0   \n",
       "\n",
       "   verificationStatus_purpose_cnt  verificationStatus_regionCode_cnt  \\\n",
       "0                          189929                               7009   \n",
       "1                            4383                              28042   \n",
       "2                          164687                               7322   \n",
       "3                          225610                               2931   \n",
       "4                           84936                               4729   \n",
       "\n",
       "   verificationStatus_subGrade_cnt  verificationStatus_title_cnt  \\\n",
       "0                            12593                          24.0   \n",
       "1                            22517                        3966.0   \n",
       "2                            18138                      137836.0   \n",
       "3                            15212                      204118.0   \n",
       "4                            23481                       76647.0   \n",
       "\n",
       "   applicationType_default_ratio  employmentLength_default_ratio  \\\n",
       "0                       0.198519                        0.196500   \n",
       "1                       0.198519                        0.198453   \n",
       "2                       0.198519                        0.186543   \n",
       "3                       0.198519                        0.196500   \n",
       "4                       0.198519                        0.186543   \n",
       "\n",
       "   employmentTitle_default_ratio  grade_default_ratio  \\\n",
       "0                       0.182796             0.302938   \n",
       "1                       0.151685             0.225775   \n",
       "2                       0.260417             0.060166   \n",
       "3                       0.268362             0.302938   \n",
       "4                       0.500000             0.225775   \n",
       "\n",
       "   homeOwnership_default_ratio  initialListStatus_default_ratio  \\\n",
       "0                     0.171817                         0.196211   \n",
       "1                     0.231709                         0.201877   \n",
       "2                     0.171817                         0.201877   \n",
       "3                     0.207853                         0.196211   \n",
       "4                     0.231709                         0.196211   \n",
       "\n",
       "   postCode_default_ratio  purpose_default_ratio  regionCode_default_ratio  \\\n",
       "0                0.156353               0.211100                  0.159035   \n",
       "1                0.194000               0.218425                  0.214701   \n",
       "2                0.186118               0.211100                  0.186601   \n",
       "3                0.278788               0.211100                  0.245263   \n",
       "4                0.196335               0.169704                  0.234083   \n",
       "\n",
       "   subGrade_default_ratio  title_default_ratio  \\\n",
       "0                0.294491             0.095238   \n",
       "1                0.224439             0.226599   \n",
       "2                0.085050             0.217787   \n",
       "3                0.277955             0.217787   \n",
       "4                0.206614             0.176027   \n",
       "\n",
       "   verificationStatus_default_ratio  \\\n",
       "0                          0.238263   \n",
       "1                          0.209223   \n",
       "2                          0.147101   \n",
       "3                          0.209223   \n",
       "4                          0.209223   \n",
       "\n",
       "   applicationType_employmentLength_default_ratio  \\\n",
       "0                                        0.196008   \n",
       "1                                        0.197877   \n",
       "2                                        0.186093   \n",
       "3                                        0.196008   \n",
       "4                                        0.186093   \n",
       "\n",
       "   applicationType_employmentTitle_default_ratio  \\\n",
       "0                                       0.182796   \n",
       "1                                       0.152542   \n",
       "2                                       0.268817   \n",
       "3                                       0.267016   \n",
       "4                                       0.500000   \n",
       "\n",
       "   applicationType_grade_default_ratio  \\\n",
       "0                             0.302257   \n",
       "1                             0.224810   \n",
       "2                             0.059663   \n",
       "3                             0.302257   \n",
       "4                             0.224810   \n",
       "\n",
       "   applicationType_homeOwnership_default_ratio  \\\n",
       "0                                     0.170799   \n",
       "1                                     0.230400   \n",
       "2                                     0.170799   \n",
       "3                                     0.206263   \n",
       "4                                     0.230400   \n",
       "\n",
       "   applicationType_initialListStatus_default_ratio  \\\n",
       "0                                         0.195492   \n",
       "1                                         0.200725   \n",
       "2                                         0.200725   \n",
       "3                                         0.195492   \n",
       "4                                         0.195492   \n",
       "\n",
       "   applicationType_postCode_default_ratio  \\\n",
       "0                                0.156639   \n",
       "1                                0.192360   \n",
       "2                                0.185741   \n",
       "3                                0.277778   \n",
       "4                                0.194188   \n",
       "\n",
       "   applicationType_purpose_default_ratio  \\\n",
       "0                               0.210028   \n",
       "1                               0.215227   \n",
       "2                               0.210028   \n",
       "3                               0.210028   \n",
       "4                               0.169266   \n",
       "\n",
       "   applicationType_regionCode_default_ratio  \\\n",
       "0                                  0.159301   \n",
       "1                                  0.213953   \n",
       "2                                  0.185530   \n",
       "3                                  0.243918   \n",
       "4                                  0.231709   \n",
       "\n",
       "   applicationType_subGrade_default_ratio  \\\n",
       "0                                0.294651   \n",
       "1                                0.223881   \n",
       "2                                0.084435   \n",
       "3                                0.277690   \n",
       "4                                0.205435   \n",
       "\n",
       "   applicationType_title_default_ratio  \\\n",
       "0                             0.095238   \n",
       "1                             0.223194   \n",
       "2                             0.216663   \n",
       "3                             0.216663   \n",
       "4                             0.175586   \n",
       "\n",
       "   applicationType_verificationStatus_default_ratio  \\\n",
       "0                                          0.237194   \n",
       "1                                          0.208617   \n",
       "2                                          0.145717   \n",
       "3                                          0.208617   \n",
       "4                                          0.208617   \n",
       "\n",
       "   employmentLength_applicationType_default_ratio  \\\n",
       "0                                        0.196008   \n",
       "1                                        0.197877   \n",
       "2                                        0.186093   \n",
       "3                                        0.196008   \n",
       "4                                        0.186093   \n",
       "\n",
       "   employmentLength_employmentTitle_default_ratio  \\\n",
       "0                                        0.000000   \n",
       "1                                        0.222222   \n",
       "2                                        0.409091   \n",
       "3                                        0.319444   \n",
       "4                                             NaN   \n",
       "\n",
       "   employmentLength_grade_default_ratio  \\\n",
       "0                              0.295359   \n",
       "1                              0.220896   \n",
       "2                              0.057594   \n",
       "3                              0.295359   \n",
       "4                              0.209869   \n",
       "\n",
       "   employmentLength_homeOwnership_default_ratio  \\\n",
       "0                                      0.170428   \n",
       "1                                      0.224315   \n",
       "2                                      0.163327   \n",
       "3                                      0.198097   \n",
       "4                                      0.236903   \n",
       "\n",
       "   employmentLength_initialListStatus_default_ratio  \\\n",
       "0                                          0.191164   \n",
       "1                                          0.200330   \n",
       "2                                          0.187522   \n",
       "3                                          0.191164   \n",
       "4                                          0.185077   \n",
       "\n",
       "   employmentLength_postCode_default_ratio  \\\n",
       "0                                 0.131707   \n",
       "1                                 0.170213   \n",
       "2                                 0.151304   \n",
       "3                                 0.142857   \n",
       "4                                 0.195980   \n",
       "\n",
       "   employmentLength_purpose_default_ratio  \\\n",
       "0                                0.205548   \n",
       "1                                0.221973   \n",
       "2                                0.197594   \n",
       "3                                0.205548   \n",
       "4                                0.161127   \n",
       "\n",
       "   employmentLength_regionCode_default_ratio  \\\n",
       "0                                   0.153396   \n",
       "1                                   0.223918   \n",
       "2                                   0.176768   \n",
       "3                                   0.240283   \n",
       "4                                   0.218491   \n",
       "\n",
       "   employmentLength_subGrade_default_ratio  \\\n",
       "0                                 0.294297   \n",
       "1                                 0.218584   \n",
       "2                                 0.083480   \n",
       "3                                 0.273629   \n",
       "4                                 0.196421   \n",
       "\n",
       "   employmentLength_title_default_ratio  \\\n",
       "0                              0.000000   \n",
       "1                              0.228205   \n",
       "2                              0.201481   \n",
       "3                              0.215190   \n",
       "4                              0.166206   \n",
       "\n",
       "   employmentLength_verificationStatus_default_ratio  \\\n",
       "0                                           0.237850   \n",
       "1                                           0.211291   \n",
       "2                                           0.137693   \n",
       "3                                           0.210716   \n",
       "4                                           0.195361   \n",
       "\n",
       "   employmentTitle_applicationType_default_ratio  \\\n",
       "0                                       0.182796   \n",
       "1                                       0.152542   \n",
       "2                                       0.268817   \n",
       "3                                       0.267016   \n",
       "4                                       0.500000   \n",
       "\n",
       "   employmentTitle_employmentLength_default_ratio  \\\n",
       "0                                        0.000000   \n",
       "1                                        0.222222   \n",
       "2                                        0.409091   \n",
       "3                                        0.319444   \n",
       "4                                             NaN   \n",
       "\n",
       "   employmentTitle_grade_default_ratio  \\\n",
       "0                             0.266667   \n",
       "1                             0.232143   \n",
       "2                             0.000000   \n",
       "3                             0.352785   \n",
       "4                             0.000000   \n",
       "\n",
       "   employmentTitle_homeOwnership_default_ratio  \\\n",
       "0                                     0.260870   \n",
       "1                                     0.183673   \n",
       "2                                     0.166667   \n",
       "3                                     0.188976   \n",
       "4                                     0.500000   \n",
       "\n",
       "   employmentTitle_initialListStatus_default_ratio  \\\n",
       "0                                         0.219178   \n",
       "1                                         0.147541   \n",
       "2                                         0.300000   \n",
       "3                                         0.280788   \n",
       "4                                         0.500000   \n",
       "\n",
       "   employmentTitle_postCode_default_ratio  \\\n",
       "0                                     NaN   \n",
       "1                                     NaN   \n",
       "2                                     NaN   \n",
       "3                                     0.0   \n",
       "4                                     NaN   \n",
       "\n",
       "   employmentTitle_purpose_default_ratio  \\\n",
       "0                               0.236364   \n",
       "1                               1.000000   \n",
       "2                               0.355932   \n",
       "3                               0.285366   \n",
       "4                                    NaN   \n",
       "\n",
       "   employmentTitle_regionCode_default_ratio  \\\n",
       "0                                  0.000000   \n",
       "1                                  0.400000   \n",
       "2                                  0.500000   \n",
       "3                                  0.052632   \n",
       "4                                       NaN   \n",
       "\n",
       "   employmentTitle_subGrade_default_ratio  \\\n",
       "0                                0.000000   \n",
       "1                                0.166667   \n",
       "2                                0.000000   \n",
       "3                                0.324074   \n",
       "4                                     NaN   \n",
       "\n",
       "   employmentTitle_title_default_ratio  \\\n",
       "0                                  NaN   \n",
       "1                             1.000000   \n",
       "2                             0.355932   \n",
       "3                             0.284139   \n",
       "4                                  NaN   \n",
       "\n",
       "   employmentTitle_verificationStatus_default_ratio  \\\n",
       "0                                          0.175439   \n",
       "1                                          0.079365   \n",
       "2                                          0.100000   \n",
       "3                                          0.285246   \n",
       "4                                          0.000000   \n",
       "\n",
       "   grade_applicationType_default_ratio  grade_employmentLength_default_ratio  \\\n",
       "0                             0.302257                              0.295359   \n",
       "1                             0.224810                              0.220896   \n",
       "2                             0.059663                              0.057594   \n",
       "3                             0.302257                              0.295359   \n",
       "4                             0.224810                              0.209869   \n",
       "\n",
       "   grade_employmentTitle_default_ratio  grade_homeOwnership_default_ratio  \\\n",
       "0                             0.266667                           0.274273   \n",
       "1                             0.232143                           0.251310   \n",
       "2                             0.000000                           0.051730   \n",
       "3                             0.352785                           0.305109   \n",
       "4                             0.000000                           0.251310   \n",
       "\n",
       "   grade_initialListStatus_default_ratio  grade_postCode_default_ratio  \\\n",
       "0                               0.277774                      0.226601   \n",
       "1                               0.239951                      0.250000   \n",
       "2                               0.060572                      0.051051   \n",
       "3                               0.277774                      0.396552   \n",
       "4                               0.204216                      0.198895   \n",
       "\n",
       "   grade_purpose_default_ratio  grade_regionCode_default_ratio  \\\n",
       "0                     0.309783                        0.242454   \n",
       "1                     0.231771                        0.241694   \n",
       "2                     0.060805                        0.056116   \n",
       "3                     0.309783                        0.342140   \n",
       "4                     0.231318                        0.257762   \n",
       "\n",
       "   grade_subGrade_default_ratio  grade_title_default_ratio  \\\n",
       "0                      0.294491                   0.250000   \n",
       "1                      0.224439                   0.236717   \n",
       "2                      0.085050                   0.061423   \n",
       "3                      0.277955                   0.318708   \n",
       "4                      0.206614                   0.242309   \n",
       "\n",
       "   grade_verificationStatus_default_ratio  \\\n",
       "0                                0.311324   \n",
       "1                                0.233434   \n",
       "2                                0.053647   \n",
       "3                                0.313129   \n",
       "4                                0.233434   \n",
       "\n",
       "   homeOwnership_applicationType_default_ratio  \\\n",
       "0                                     0.170799   \n",
       "1                                     0.230400   \n",
       "2                                     0.170799   \n",
       "3                                     0.206263   \n",
       "4                                     0.230400   \n",
       "\n",
       "   homeOwnership_employmentLength_default_ratio  \\\n",
       "0                                      0.170428   \n",
       "1                                      0.224315   \n",
       "2                                      0.163327   \n",
       "3                                      0.198097   \n",
       "4                                      0.236903   \n",
       "\n",
       "   homeOwnership_employmentTitle_default_ratio  \\\n",
       "0                                     0.260870   \n",
       "1                                     0.183673   \n",
       "2                                     0.166667   \n",
       "3                                     0.188976   \n",
       "4                                     0.500000   \n",
       "\n",
       "   homeOwnership_grade_default_ratio  \\\n",
       "0                           0.274273   \n",
       "1                           0.251310   \n",
       "2                           0.051730   \n",
       "3                           0.305109   \n",
       "4                           0.251310   \n",
       "\n",
       "   homeOwnership_initialListStatus_default_ratio  \\\n",
       "0                                       0.170545   \n",
       "1                                       0.238970   \n",
       "2                                       0.172674   \n",
       "3                                       0.207478   \n",
       "4                                       0.222544   \n",
       "\n",
       "   homeOwnership_postCode_default_ratio  homeOwnership_purpose_default_ratio  \\\n",
       "0                              0.092038                             0.183384   \n",
       "1                              0.245378                             0.254660   \n",
       "2                              0.132000                             0.183384   \n",
       "3                              0.387755                             0.219285   \n",
       "4                              0.222222                             0.196344   \n",
       "\n",
       "   homeOwnership_regionCode_default_ratio  \\\n",
       "0                                0.114618   \n",
       "1                                0.257456   \n",
       "2                                0.153858   \n",
       "3                                0.253879   \n",
       "4                                0.253123   \n",
       "\n",
       "   homeOwnership_subGrade_default_ratio  homeOwnership_title_default_ratio  \\\n",
       "0                              0.260709                           0.076923   \n",
       "1                              0.253778                           0.263620   \n",
       "2                              0.075746                           0.187677   \n",
       "3                              0.283979                           0.224909   \n",
       "4                              0.229465                           0.205132   \n",
       "\n",
       "   homeOwnership_verificationStatus_default_ratio  \\\n",
       "0                                        0.207866   \n",
       "1                                        0.242804   \n",
       "2                                        0.126693   \n",
       "3                                        0.215086   \n",
       "4                                        0.242804   \n",
       "\n",
       "   initialListStatus_applicationType_default_ratio  \\\n",
       "0                                         0.195492   \n",
       "1                                         0.200725   \n",
       "2                                         0.200725   \n",
       "3                                         0.195492   \n",
       "4                                         0.195492   \n",
       "\n",
       "   initialListStatus_employmentLength_default_ratio  \\\n",
       "0                                          0.191164   \n",
       "1                                          0.200330   \n",
       "2                                          0.187522   \n",
       "3                                          0.191164   \n",
       "4                                          0.185077   \n",
       "\n",
       "   initialListStatus_employmentTitle_default_ratio  \\\n",
       "0                                         0.219178   \n",
       "1                                         0.147541   \n",
       "2                                         0.300000   \n",
       "3                                         0.280788   \n",
       "4                                         0.500000   \n",
       "\n",
       "   initialListStatus_grade_default_ratio  \\\n",
       "0                               0.277774   \n",
       "1                               0.239951   \n",
       "2                               0.060572   \n",
       "3                               0.277774   \n",
       "4                               0.204216   \n",
       "\n",
       "   initialListStatus_homeOwnership_default_ratio  \\\n",
       "0                                       0.170545   \n",
       "1                                       0.238970   \n",
       "2                                       0.172674   \n",
       "3                                       0.207478   \n",
       "4                                       0.222544   \n",
       "\n",
       "   initialListStatus_postCode_default_ratio  \\\n",
       "0                                  0.161663   \n",
       "1                                  0.199546   \n",
       "2                                  0.170082   \n",
       "3                                  0.244444   \n",
       "4                                  0.190202   \n",
       "\n",
       "   initialListStatus_purpose_default_ratio  \\\n",
       "0                                 0.206971   \n",
       "1                                 0.223273   \n",
       "2                                 0.214088   \n",
       "3                                 0.206971   \n",
       "4                                 0.163872   \n",
       "\n",
       "   initialListStatus_regionCode_default_ratio  \\\n",
       "0                                    0.170041   \n",
       "1                                    0.214066   \n",
       "2                                    0.191439   \n",
       "3                                    0.224849   \n",
       "4                                    0.215349   \n",
       "\n",
       "   initialListStatus_subGrade_default_ratio  \\\n",
       "0                                  0.271423   \n",
       "1                                  0.240328   \n",
       "2                                  0.085033   \n",
       "3                                  0.253801   \n",
       "4                                  0.187063   \n",
       "\n",
       "   initialListStatus_title_default_ratio  \\\n",
       "0                               0.125000   \n",
       "1                               0.225104   \n",
       "2                               0.215492   \n",
       "3                               0.221935   \n",
       "4                               0.178506   \n",
       "\n",
       "   initialListStatus_verificationStatus_default_ratio  \\\n",
       "0                                           0.226760    \n",
       "1                                           0.209710    \n",
       "2                                           0.148568    \n",
       "3                                           0.208437    \n",
       "4                                           0.208437    \n",
       "\n",
       "   postCode_applicationType_default_ratio  \\\n",
       "0                                0.156639   \n",
       "1                                0.192360   \n",
       "2                                0.185741   \n",
       "3                                0.277778   \n",
       "4                                0.194188   \n",
       "\n",
       "   postCode_employmentLength_default_ratio  \\\n",
       "0                                 0.131707   \n",
       "1                                 0.170213   \n",
       "2                                 0.151304   \n",
       "3                                 0.142857   \n",
       "4                                 0.195980   \n",
       "\n",
       "   postCode_employmentTitle_default_ratio  postCode_grade_default_ratio  \\\n",
       "0                                     NaN                      0.226601   \n",
       "1                                     NaN                      0.250000   \n",
       "2                                     NaN                      0.051051   \n",
       "3                                     0.0                      0.396552   \n",
       "4                                     NaN                      0.198895   \n",
       "\n",
       "   postCode_homeOwnership_default_ratio  \\\n",
       "0                              0.092038   \n",
       "1                              0.245378   \n",
       "2                              0.132000   \n",
       "3                              0.387755   \n",
       "4                              0.222222   \n",
       "\n",
       "   postCode_initialListStatus_default_ratio  postCode_purpose_default_ratio  \\\n",
       "0                                  0.161663                        0.169022   \n",
       "1                                  0.199546                        0.115385   \n",
       "2                                  0.170082                        0.198953   \n",
       "3                                  0.244444                        0.274038   \n",
       "4                                  0.190202                        0.147239   \n",
       "\n",
       "   postCode_regionCode_default_ratio  postCode_subGrade_default_ratio  \\\n",
       "0                           0.156404                         0.213483   \n",
       "1                           0.192924                         0.243243   \n",
       "2                           0.186232                         0.107143   \n",
       "3                           0.278788                         0.466667   \n",
       "4                           0.196592                         0.190476   \n",
       "\n",
       "   postCode_title_default_ratio  postCode_verificationStatus_default_ratio  \\\n",
       "0                           NaN                                   0.185185   \n",
       "1                      0.080000                                   0.230104   \n",
       "2                      0.205736                                   0.099609   \n",
       "3                      0.288043                                   0.299145   \n",
       "4                      0.151079                                   0.207547   \n",
       "\n",
       "   purpose_applicationType_default_ratio  \\\n",
       "0                               0.210028   \n",
       "1                               0.215227   \n",
       "2                               0.210028   \n",
       "3                               0.210028   \n",
       "4                               0.169266   \n",
       "\n",
       "   purpose_employmentLength_default_ratio  \\\n",
       "0                                0.205548   \n",
       "1                                0.221973   \n",
       "2                                0.197594   \n",
       "3                                0.205548   \n",
       "4                                0.161127   \n",
       "\n",
       "   purpose_employmentTitle_default_ratio  purpose_grade_default_ratio  \\\n",
       "0                               0.236364                     0.309783   \n",
       "1                               1.000000                     0.231771   \n",
       "2                               0.355932                     0.060805   \n",
       "3                               0.285366                     0.309783   \n",
       "4                                    NaN                     0.231318   \n",
       "\n",
       "   purpose_homeOwnership_default_ratio  \\\n",
       "0                             0.183384   \n",
       "1                             0.254660   \n",
       "2                             0.183384   \n",
       "3                             0.219285   \n",
       "4                             0.196344   \n",
       "\n",
       "   purpose_initialListStatus_default_ratio  purpose_postCode_default_ratio  \\\n",
       "0                                 0.206971                        0.169022   \n",
       "1                                 0.223273                        0.115385   \n",
       "2                                 0.214088                        0.198953   \n",
       "3                                 0.206971                        0.274038   \n",
       "4                                 0.163872                        0.147239   \n",
       "\n",
       "   purpose_regionCode_default_ratio  purpose_subGrade_default_ratio  \\\n",
       "0                          0.167394                        0.299375   \n",
       "1                          0.217636                        0.208520   \n",
       "2                          0.196315                        0.084761   \n",
       "3                          0.252119                        0.281452   \n",
       "4                          0.204752                        0.212917   \n",
       "\n",
       "   purpose_title_default_ratio  purpose_verificationStatus_default_ratio  \\\n",
       "0                     0.133333                                  0.248802   \n",
       "1                     0.226865                                  0.223001   \n",
       "2                     0.217780                                  0.155872   \n",
       "3                     0.217780                                  0.219645   \n",
       "4                     0.175973                                  0.180280   \n",
       "\n",
       "   regionCode_applicationType_default_ratio  \\\n",
       "0                                  0.159301   \n",
       "1                                  0.213953   \n",
       "2                                  0.185530   \n",
       "3                                  0.243918   \n",
       "4                                  0.231709   \n",
       "\n",
       "   regionCode_employmentLength_default_ratio  \\\n",
       "0                                   0.153396   \n",
       "1                                   0.223918   \n",
       "2                                   0.176768   \n",
       "3                                   0.240283   \n",
       "4                                   0.218491   \n",
       "\n",
       "   regionCode_employmentTitle_default_ratio  regionCode_grade_default_ratio  \\\n",
       "0                                  0.000000                        0.242454   \n",
       "1                                  0.400000                        0.241694   \n",
       "2                                  0.500000                        0.056116   \n",
       "3                                  0.052632                        0.342140   \n",
       "4                                       NaN                        0.257762   \n",
       "\n",
       "   regionCode_homeOwnership_default_ratio  \\\n",
       "0                                0.114618   \n",
       "1                                0.257456   \n",
       "2                                0.153858   \n",
       "3                                0.253879   \n",
       "4                                0.253123   \n",
       "\n",
       "   regionCode_initialListStatus_default_ratio  \\\n",
       "0                                    0.170041   \n",
       "1                                    0.214066   \n",
       "2                                    0.191439   \n",
       "3                                    0.224849   \n",
       "4                                    0.215349   \n",
       "\n",
       "   regionCode_postCode_default_ratio  regionCode_purpose_default_ratio  \\\n",
       "0                           0.156404                          0.167394   \n",
       "1                           0.192924                          0.217636   \n",
       "2                           0.186232                          0.196315   \n",
       "3                           0.278788                          0.252119   \n",
       "4                           0.196592                          0.204752   \n",
       "\n",
       "   regionCode_subGrade_default_ratio  regionCode_title_default_ratio  \\\n",
       "0                           0.249438                        1.000000   \n",
       "1                           0.231346                        0.227660   \n",
       "2                           0.087282                        0.203198   \n",
       "3                           0.302198                        0.265359   \n",
       "4                           0.262651                        0.215232   \n",
       "\n",
       "   regionCode_verificationStatus_default_ratio  \\\n",
       "0                                     0.192325   \n",
       "1                                     0.223165   \n",
       "2                                     0.138766   \n",
       "3                                     0.272537   \n",
       "4                                     0.248682   \n",
       "\n",
       "   subGrade_applicationType_default_ratio  \\\n",
       "0                                0.294651   \n",
       "1                                0.223881   \n",
       "2                                0.084435   \n",
       "3                                0.277690   \n",
       "4                                0.205435   \n",
       "\n",
       "   subGrade_employmentLength_default_ratio  \\\n",
       "0                                 0.294297   \n",
       "1                                 0.218584   \n",
       "2                                 0.083480   \n",
       "3                                 0.273629   \n",
       "4                                 0.196421   \n",
       "\n",
       "   subGrade_employmentTitle_default_ratio  subGrade_grade_default_ratio  \\\n",
       "0                                0.000000                      0.294491   \n",
       "1                                0.166667                      0.224439   \n",
       "2                                0.000000                      0.085050   \n",
       "3                                0.324074                      0.277955   \n",
       "4                                     NaN                      0.206614   \n",
       "\n",
       "   subGrade_homeOwnership_default_ratio  \\\n",
       "0                              0.260709   \n",
       "1                              0.253778   \n",
       "2                              0.075746   \n",
       "3                              0.283979   \n",
       "4                              0.229465   \n",
       "\n",
       "   subGrade_initialListStatus_default_ratio  subGrade_postCode_default_ratio  \\\n",
       "0                                  0.271423                         0.213483   \n",
       "1                                  0.240328                         0.243243   \n",
       "2                                  0.085033                         0.107143   \n",
       "3                                  0.253801                         0.466667   \n",
       "4                                  0.187063                         0.190476   \n",
       "\n",
       "   subGrade_purpose_default_ratio  subGrade_regionCode_default_ratio  \\\n",
       "0                        0.299375                           0.249438   \n",
       "1                        0.208520                           0.231346   \n",
       "2                        0.084761                           0.087282   \n",
       "3                        0.281452                           0.302198   \n",
       "4                        0.212917                           0.262651   \n",
       "\n",
       "   subGrade_title_default_ratio  subGrade_verificationStatus_default_ratio  \\\n",
       "0                      1.000000                                   0.301380   \n",
       "1                      0.216019                                   0.234065   \n",
       "2                      0.086222                                   0.080819   \n",
       "3                      0.289248                                   0.290678   \n",
       "4                      0.222153                                   0.212162   \n",
       "\n",
       "   title_applicationType_default_ratio  title_employmentLength_default_ratio  \\\n",
       "0                             0.095238                              0.000000   \n",
       "1                             0.223194                              0.228205   \n",
       "2                             0.216663                              0.201481   \n",
       "3                             0.216663                              0.215190   \n",
       "4                             0.175586                              0.166206   \n",
       "\n",
       "   title_employmentTitle_default_ratio  title_grade_default_ratio  \\\n",
       "0                                  NaN                   0.250000   \n",
       "1                             1.000000                   0.236717   \n",
       "2                             0.355932                   0.061423   \n",
       "3                             0.284139                   0.318708   \n",
       "4                                  NaN                   0.242309   \n",
       "\n",
       "   title_homeOwnership_default_ratio  title_initialListStatus_default_ratio  \\\n",
       "0                           0.076923                               0.125000   \n",
       "1                           0.263620                               0.225104   \n",
       "2                           0.187677                               0.215492   \n",
       "3                           0.224909                               0.221935   \n",
       "4                           0.205132                               0.178506   \n",
       "\n",
       "   title_postCode_default_ratio  title_purpose_default_ratio  \\\n",
       "0                           NaN                     0.133333   \n",
       "1                      0.080000                     0.226865   \n",
       "2                      0.205736                     0.217780   \n",
       "3                      0.288043                     0.217780   \n",
       "4                      0.151079                     0.175973   \n",
       "\n",
       "   title_regionCode_default_ratio  title_subGrade_default_ratio  \\\n",
       "0                        1.000000                      1.000000   \n",
       "1                        0.227660                      0.216019   \n",
       "2                        0.203198                      0.086222   \n",
       "3                        0.265359                      0.289248   \n",
       "4                        0.215232                      0.222153   \n",
       "\n",
       "   title_verificationStatus_default_ratio  \\\n",
       "0                                0.071429   \n",
       "1                                0.229604   \n",
       "2                                0.160245   \n",
       "3                                0.223279   \n",
       "4                                0.184116   \n",
       "\n",
       "   verificationStatus_applicationType_default_ratio  \\\n",
       "0                                          0.237194   \n",
       "1                                          0.208617   \n",
       "2                                          0.145717   \n",
       "3                                          0.208617   \n",
       "4                                          0.208617   \n",
       "\n",
       "   verificationStatus_employmentLength_default_ratio  \\\n",
       "0                                           0.237850   \n",
       "1                                           0.211291   \n",
       "2                                           0.137693   \n",
       "3                                           0.210716   \n",
       "4                                           0.195361   \n",
       "\n",
       "   verificationStatus_employmentTitle_default_ratio  \\\n",
       "0                                          0.175439   \n",
       "1                                          0.079365   \n",
       "2                                          0.100000   \n",
       "3                                          0.285246   \n",
       "4                                          0.000000   \n",
       "\n",
       "   verificationStatus_grade_default_ratio  \\\n",
       "0                                0.311324   \n",
       "1                                0.233434   \n",
       "2                                0.053647   \n",
       "3                                0.313129   \n",
       "4                                0.233434   \n",
       "\n",
       "   verificationStatus_homeOwnership_default_ratio  \\\n",
       "0                                        0.207866   \n",
       "1                                        0.242804   \n",
       "2                                        0.126693   \n",
       "3                                        0.215086   \n",
       "4                                        0.242804   \n",
       "\n",
       "   verificationStatus_initialListStatus_default_ratio  \\\n",
       "0                                           0.226760    \n",
       "1                                           0.209710    \n",
       "2                                           0.148568    \n",
       "3                                           0.208437    \n",
       "4                                           0.208437    \n",
       "\n",
       "   verificationStatus_postCode_default_ratio  \\\n",
       "0                                   0.185185   \n",
       "1                                   0.230104   \n",
       "2                                   0.099609   \n",
       "3                                   0.299145   \n",
       "4                                   0.207547   \n",
       "\n",
       "   verificationStatus_purpose_default_ratio  \\\n",
       "0                                  0.248802   \n",
       "1                                  0.223001   \n",
       "2                                  0.155872   \n",
       "3                                  0.219645   \n",
       "4                                  0.180280   \n",
       "\n",
       "   verificationStatus_regionCode_default_ratio  \\\n",
       "0                                     0.192325   \n",
       "1                                     0.223165   \n",
       "2                                     0.138766   \n",
       "3                                     0.272537   \n",
       "4                                     0.248682   \n",
       "\n",
       "   verificationStatus_subGrade_default_ratio  \\\n",
       "0                                   0.301380   \n",
       "1                                   0.234065   \n",
       "2                                   0.080819   \n",
       "3                                   0.290678   \n",
       "4                                   0.212162   \n",
       "\n",
       "   verificationStatus_title_default_ratio  \n",
       "0                                0.071429  \n",
       "1                                0.229604  \n",
       "2                                0.160245  \n",
       "3                                0.223279  \n",
       "4                                0.184116  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_feature.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-06T02:06:55.466237Z",
     "start_time": "2020-11-06T02:06:55.099365Z"
    }
   },
   "outputs": [],
   "source": [
    "for f in df_feature.select_dtypes('object').columns:\n",
    "    lbl = LabelEncoder()\n",
    "    df_feature[f] = lbl.fit_transform(df_feature[f].astype(str))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-06T02:06:57.175602Z",
     "start_time": "2020-11-06T02:06:55.467986Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "((800000, 338), (200000, 338))"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_train = df_feature[df_feature.isDefault.notna()].copy()\n",
    "df_test = df_feature[df_feature.isDefault.isna()].copy()\n",
    "\n",
    "df_train.shape, df_test.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-06T02:18:46.032858Z",
     "start_time": "2020-11-06T02:06:57.176847Z"
    },
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "Fold_1 Training ================================\n",
      "\n",
      "0:\ttest: 0.6914790\tbest: 0.6914790 (0)\ttotal: 154ms\tremaining: 25m 43s\n",
      "100:\ttest: 0.7317571\tbest: 0.7317571 (100)\ttotal: 8.24s\tremaining: 13m 28s\n",
      "200:\ttest: 0.7366752\tbest: 0.7366752 (200)\ttotal: 16.1s\tremaining: 13m 4s\n",
      "300:\ttest: 0.7391045\tbest: 0.7391045 (300)\ttotal: 24.3s\tremaining: 13m 2s\n",
      "400:\ttest: 0.7408054\tbest: 0.7408054 (400)\ttotal: 32s\tremaining: 12m 46s\n",
      "500:\ttest: 0.7417540\tbest: 0.7417540 (500)\ttotal: 39.4s\tremaining: 12m 26s\n",
      "600:\ttest: 0.7424202\tbest: 0.7424202 (600)\ttotal: 46.7s\tremaining: 12m 10s\n",
      "700:\ttest: 0.7428760\tbest: 0.7428760 (700)\ttotal: 53.7s\tremaining: 11m 52s\n",
      "800:\ttest: 0.7432039\tbest: 0.7432039 (800)\ttotal: 1m\tremaining: 11m 38s\n",
      "900:\ttest: 0.7435303\tbest: 0.7435310 (897)\ttotal: 1m 7s\tremaining: 11m 26s\n",
      "1000:\ttest: 0.7437611\tbest: 0.7437679 (996)\ttotal: 1m 15s\tremaining: 11m 15s\n",
      "1100:\ttest: 0.7439505\tbest: 0.7439553 (1096)\ttotal: 1m 22s\tremaining: 11m 4s\n",
      "1200:\ttest: 0.7441318\tbest: 0.7441318 (1200)\ttotal: 1m 29s\tremaining: 10m 54s\n",
      "1300:\ttest: 0.7442712\tbest: 0.7442712 (1300)\ttotal: 1m 36s\tremaining: 10m 44s\n",
      "1400:\ttest: 0.7443785\tbest: 0.7443933 (1396)\ttotal: 1m 43s\tremaining: 10m 35s\n",
      "1500:\ttest: 0.7445359\tbest: 0.7445359 (1500)\ttotal: 1m 50s\tremaining: 10m 25s\n",
      "1600:\ttest: 0.7446254\tbest: 0.7446329 (1598)\ttotal: 1m 57s\tremaining: 10m 16s\n",
      "1700:\ttest: 0.7447249\tbest: 0.7447341 (1691)\ttotal: 2m 4s\tremaining: 10m 8s\n",
      "Stopped by overfitting detector  (50 iterations wait)\n",
      "\n",
      "bestTest = 0.7447529977\n",
      "bestIteration = 1713\n",
      "\n",
      "Shrink model to first 1714 iterations.\n",
      "\n",
      "Fold_2 Training ================================\n",
      "\n",
      "0:\ttest: 0.6904421\tbest: 0.6904421 (0)\ttotal: 97.5ms\tremaining: 16m 15s\n",
      "100:\ttest: 0.7306241\tbest: 0.7306241 (100)\ttotal: 8.11s\tremaining: 13m 15s\n",
      "200:\ttest: 0.7353206\tbest: 0.7353206 (200)\ttotal: 15.6s\tremaining: 12m 42s\n",
      "300:\ttest: 0.7377473\tbest: 0.7377473 (300)\ttotal: 23.1s\tremaining: 12m 23s\n",
      "400:\ttest: 0.7392621\tbest: 0.7392621 (400)\ttotal: 30.4s\tremaining: 12m 8s\n",
      "500:\ttest: 0.7401935\tbest: 0.7401935 (500)\ttotal: 37.6s\tremaining: 11m 52s\n",
      "600:\ttest: 0.7408204\tbest: 0.7408218 (595)\ttotal: 44.8s\tremaining: 11m 41s\n",
      "700:\ttest: 0.7414017\tbest: 0.7414017 (700)\ttotal: 52.1s\tremaining: 11m 30s\n",
      "800:\ttest: 0.7417621\tbest: 0.7417621 (800)\ttotal: 59.2s\tremaining: 11m 19s\n",
      "900:\ttest: 0.7420056\tbest: 0.7420076 (898)\ttotal: 1m 6s\tremaining: 11m 8s\n",
      "1000:\ttest: 0.7422040\tbest: 0.7422040 (1000)\ttotal: 1m 13s\tremaining: 10m 58s\n",
      "1100:\ttest: 0.7423860\tbest: 0.7423860 (1100)\ttotal: 1m 20s\tremaining: 10m 48s\n",
      "1200:\ttest: 0.7424993\tbest: 0.7425010 (1198)\ttotal: 1m 27s\tremaining: 10m 39s\n",
      "1300:\ttest: 0.7426527\tbest: 0.7426658 (1290)\ttotal: 1m 34s\tremaining: 10m 31s\n",
      "1400:\ttest: 0.7427754\tbest: 0.7427767 (1392)\ttotal: 1m 41s\tremaining: 10m 22s\n",
      "1500:\ttest: 0.7428627\tbest: 0.7428628 (1499)\ttotal: 1m 48s\tremaining: 10m 14s\n",
      "1600:\ttest: 0.7429709\tbest: 0.7429709 (1600)\ttotal: 1m 55s\tremaining: 10m 5s\n",
      "1700:\ttest: 0.7430858\tbest: 0.7430858 (1700)\ttotal: 2m 2s\tremaining: 9m 57s\n",
      "1800:\ttest: 0.7431845\tbest: 0.7431870 (1797)\ttotal: 2m 9s\tremaining: 9m 49s\n",
      "1900:\ttest: 0.7432464\tbest: 0.7432483 (1895)\ttotal: 2m 16s\tremaining: 9m 41s\n",
      "2000:\ttest: 0.7433482\tbest: 0.7433547 (1997)\ttotal: 2m 23s\tremaining: 9m 33s\n",
      "2100:\ttest: 0.7433681\tbest: 0.7433822 (2079)\ttotal: 2m 30s\tremaining: 9m 25s\n",
      "Stopped by overfitting detector  (50 iterations wait)\n",
      "\n",
      "bestTest = 0.7433821801\n",
      "bestIteration = 2079\n",
      "\n",
      "Shrink model to first 2080 iterations.\n",
      "\n",
      "Fold_3 Training ================================\n",
      "\n",
      "0:\ttest: 0.6899937\tbest: 0.6899937 (0)\ttotal: 99.1ms\tremaining: 16m 30s\n",
      "100:\ttest: 0.7315343\tbest: 0.7315343 (100)\ttotal: 8.04s\tremaining: 13m 7s\n",
      "200:\ttest: 0.7364206\tbest: 0.7364206 (200)\ttotal: 15.6s\tremaining: 12m 42s\n",
      "300:\ttest: 0.7393383\tbest: 0.7393383 (300)\ttotal: 23.1s\tremaining: 12m 25s\n",
      "400:\ttest: 0.7410909\tbest: 0.7410909 (400)\ttotal: 30.5s\tremaining: 12m 10s\n",
      "500:\ttest: 0.7419790\tbest: 0.7419790 (500)\ttotal: 37.7s\tremaining: 11m 53s\n",
      "600:\ttest: 0.7426814\tbest: 0.7426814 (600)\ttotal: 44.8s\tremaining: 11m 40s\n",
      "700:\ttest: 0.7431310\tbest: 0.7431310 (700)\ttotal: 51.9s\tremaining: 11m 29s\n",
      "800:\ttest: 0.7435480\tbest: 0.7435480 (800)\ttotal: 59.1s\tremaining: 11m 18s\n",
      "900:\ttest: 0.7437969\tbest: 0.7437969 (900)\ttotal: 1m 6s\tremaining: 11m 6s\n",
      "1000:\ttest: 0.7440663\tbest: 0.7440667 (999)\ttotal: 1m 13s\tremaining: 10m 57s\n",
      "1100:\ttest: 0.7442803\tbest: 0.7442803 (1100)\ttotal: 1m 20s\tremaining: 10m 47s\n",
      "1200:\ttest: 0.7444902\tbest: 0.7444946 (1199)\ttotal: 1m 27s\tremaining: 10m 38s\n",
      "1300:\ttest: 0.7445897\tbest: 0.7445910 (1297)\ttotal: 1m 34s\tremaining: 10m 29s\n",
      "1400:\ttest: 0.7447250\tbest: 0.7447281 (1395)\ttotal: 1m 41s\tremaining: 10m 21s\n",
      "1500:\ttest: 0.7448935\tbest: 0.7449011 (1496)\ttotal: 1m 48s\tremaining: 10m 12s\n",
      "1600:\ttest: 0.7449447\tbest: 0.7449554 (1596)\ttotal: 1m 55s\tremaining: 10m 3s\n",
      "1700:\ttest: 0.7450710\tbest: 0.7450789 (1698)\ttotal: 2m 2s\tremaining: 9m 55s\n",
      "Stopped by overfitting detector  (50 iterations wait)\n",
      "\n",
      "bestTest = 0.7450788713\n",
      "bestIteration = 1698\n",
      "\n",
      "Shrink model to first 1699 iterations.\n",
      "\n",
      "Fold_4 Training ================================\n",
      "\n",
      "0:\ttest: 0.6885953\tbest: 0.6885953 (0)\ttotal: 97.1ms\tremaining: 16m 10s\n",
      "100:\ttest: 0.7279041\tbest: 0.7279041 (100)\ttotal: 8.19s\tremaining: 13m 23s\n",
      "200:\ttest: 0.7324394\tbest: 0.7324394 (200)\ttotal: 15.9s\tremaining: 12m 53s\n",
      "300:\ttest: 0.7348064\tbest: 0.7348064 (300)\ttotal: 23.3s\tremaining: 12m 30s\n",
      "400:\ttest: 0.7365359\tbest: 0.7365359 (400)\ttotal: 30.7s\tremaining: 12m 16s\n",
      "500:\ttest: 0.7374497\tbest: 0.7374497 (500)\ttotal: 38s\tremaining: 12m\n",
      "600:\ttest: 0.7380163\tbest: 0.7380204 (599)\ttotal: 45.1s\tremaining: 11m 45s\n",
      "700:\ttest: 0.7384714\tbest: 0.7384723 (699)\ttotal: 52.2s\tremaining: 11m 32s\n",
      "800:\ttest: 0.7389024\tbest: 0.7389024 (800)\ttotal: 59.3s\tremaining: 11m 21s\n",
      "900:\ttest: 0.7391183\tbest: 0.7391183 (900)\ttotal: 1m 6s\tremaining: 11m 11s\n",
      "1000:\ttest: 0.7393410\tbest: 0.7393410 (1000)\ttotal: 1m 13s\tremaining: 11m\n",
      "1100:\ttest: 0.7395757\tbest: 0.7395771 (1099)\ttotal: 1m 20s\tremaining: 10m 49s\n",
      "1200:\ttest: 0.7396821\tbest: 0.7396821 (1200)\ttotal: 1m 27s\tremaining: 10m 39s\n",
      "1300:\ttest: 0.7398208\tbest: 0.7398208 (1300)\ttotal: 1m 34s\tremaining: 10m 30s\n",
      "1400:\ttest: 0.7399006\tbest: 0.7399018 (1365)\ttotal: 1m 41s\tremaining: 10m 22s\n",
      "1500:\ttest: 0.7400030\tbest: 0.7400030 (1500)\ttotal: 1m 48s\tremaining: 10m 13s\n",
      "1600:\ttest: 0.7400389\tbest: 0.7400505 (1573)\ttotal: 1m 55s\tremaining: 10m 5s\n",
      "1700:\ttest: 0.7401209\tbest: 0.7401209 (1700)\ttotal: 2m 2s\tremaining: 9m 57s\n",
      "1800:\ttest: 0.7402181\tbest: 0.7402181 (1800)\ttotal: 2m 9s\tremaining: 9m 49s\n",
      "1900:\ttest: 0.7402672\tbest: 0.7402765 (1892)\ttotal: 2m 16s\tremaining: 9m 42s\n",
      "2000:\ttest: 0.7403484\tbest: 0.7403484 (2000)\ttotal: 2m 23s\tremaining: 9m 34s\n",
      "2100:\ttest: 0.7404115\tbest: 0.7404233 (2088)\ttotal: 2m 30s\tremaining: 9m 27s\n",
      "Stopped by overfitting detector  (50 iterations wait)\n",
      "\n",
      "bestTest = 0.7404233344\n",
      "bestIteration = 2088\n",
      "\n",
      "Shrink model to first 2089 iterations.\n",
      "\n",
      "Fold_5 Training ================================\n",
      "\n",
      "0:\ttest: 0.6873929\tbest: 0.6873929 (0)\ttotal: 98.6ms\tremaining: 16m 25s\n",
      "100:\ttest: 0.7309468\tbest: 0.7309468 (100)\ttotal: 8.08s\tremaining: 13m 11s\n",
      "200:\ttest: 0.7356532\tbest: 0.7356532 (200)\ttotal: 15.7s\tremaining: 12m 46s\n",
      "300:\ttest: 0.7378834\tbest: 0.7378834 (300)\ttotal: 23.1s\tremaining: 12m 24s\n",
      "400:\ttest: 0.7393743\tbest: 0.7393743 (400)\ttotal: 30.5s\tremaining: 12m 10s\n",
      "500:\ttest: 0.7402779\tbest: 0.7402779 (500)\ttotal: 37.7s\tremaining: 11m 54s\n",
      "600:\ttest: 0.7408038\tbest: 0.7408056 (597)\ttotal: 44.8s\tremaining: 11m 41s\n",
      "700:\ttest: 0.7412021\tbest: 0.7412021 (700)\ttotal: 52s\tremaining: 11m 30s\n",
      "800:\ttest: 0.7415270\tbest: 0.7415270 (800)\ttotal: 59s\tremaining: 11m 17s\n",
      "900:\ttest: 0.7417358\tbest: 0.7417450 (894)\ttotal: 1m 5s\tremaining: 11m 5s\n",
      "1000:\ttest: 0.7419708\tbest: 0.7419708 (1000)\ttotal: 1m 13s\tremaining: 10m 56s\n",
      "1100:\ttest: 0.7421907\tbest: 0.7421907 (1100)\ttotal: 1m 20s\tremaining: 10m 47s\n",
      "1200:\ttest: 0.7423708\tbest: 0.7423777 (1197)\ttotal: 1m 27s\tremaining: 10m 38s\n",
      "1300:\ttest: 0.7424858\tbest: 0.7424898 (1293)\ttotal: 1m 34s\tremaining: 10m 30s\n",
      "1400:\ttest: 0.7425556\tbest: 0.7425716 (1394)\ttotal: 1m 41s\tremaining: 10m 21s\n",
      "1500:\ttest: 0.7426495\tbest: 0.7426495 (1500)\ttotal: 1m 48s\tremaining: 10m 13s\n",
      "1600:\ttest: 0.7427699\tbest: 0.7427699 (1600)\ttotal: 1m 55s\tremaining: 10m 5s\n",
      "1700:\ttest: 0.7428462\tbest: 0.7428473 (1699)\ttotal: 2m 2s\tremaining: 9m 56s\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1800:\ttest: 0.7428844\tbest: 0.7428950 (1768)\ttotal: 2m 9s\tremaining: 9m 48s\n",
      "Stopped by overfitting detector  (50 iterations wait)\n",
      "\n",
      "bestTest = 0.7428949698\n",
      "bestIteration = 1768\n",
      "\n",
      "Shrink model to first 1769 iterations.\n"
     ]
    }
   ],
   "source": [
    "ycol = 'isDefault'\n",
    "feature_names = list(\n",
    "    filter(lambda x: x not in [ycol, 'id'], df_train.columns))\n",
    "\n",
    "model = cbt.CatBoostClassifier(eval_metric='AUC',\n",
    "                               max_depth=6,\n",
    "                               learning_rate=0.05,\n",
    "                               n_estimators=10000,\n",
    "                               reg_lambda=12,\n",
    "                               #                                task_type='GPU',\n",
    "                               random_state=seed)\n",
    "\n",
    "df_oof = df_train[['id', ycol]].copy()\n",
    "df_oof['prob'] = 0\n",
    "prediction = df_test[['id']]\n",
    "prediction['prob'] = 0\n",
    "df_importance_list = []\n",
    "\n",
    "kfold = StratifiedKFold(n_splits=5, shuffle=True, random_state=seed)\n",
    "for fold_id, (trn_idx, val_idx) in enumerate(\n",
    "        kfold.split(df_train[feature_names], df_train[ycol])):\n",
    "    X_train = df_train.iloc[trn_idx][feature_names]\n",
    "    Y_train = df_train.iloc[trn_idx][ycol]\n",
    "\n",
    "    X_val = df_train.iloc[val_idx][feature_names]\n",
    "    Y_val = df_train.iloc[val_idx][ycol]\n",
    "\n",
    "    print('\\nFold_{} Training ================================\\n'.format(\n",
    "        fold_id + 1))\n",
    "\n",
    "    cbt_model = model.fit(X_train,\n",
    "                          Y_train,\n",
    "                          eval_set=[(X_val, Y_val)],\n",
    "                          verbose=100,\n",
    "                          early_stopping_rounds=50)\n",
    "\n",
    "    pred_val = cbt_model.predict_proba(\n",
    "        X_val)[:, 1]\n",
    "    df_oof.loc[val_idx, 'prob'] = pred_val\n",
    "\n",
    "    pred_test = cbt_model.predict_proba(\n",
    "        df_test[feature_names])[:, 1]\n",
    "    prediction['prob'] += pred_test / kfold.n_splits\n",
    "\n",
    "    df_importance = pd.DataFrame({\n",
    "        'column': feature_names,\n",
    "        'importance': cbt_model.feature_importances_,\n",
    "    })\n",
    "    df_importance_list.append(df_importance)\n",
    "\n",
    "    del cbt_model, pred_val, pred_test, X_train, Y_train, X_val, Y_val\n",
    "    gc.collect()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-06T02:18:46.056016Z",
     "start_time": "2020-11-06T02:18:46.034666Z"
    },
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>column</th>\n",
       "      <th>importance</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>issueDate</td>\n",
       "      <td>6.585232</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>term</td>\n",
       "      <td>5.133756</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>revolBal</td>\n",
       "      <td>2.964523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>dti</td>\n",
       "      <td>2.863236</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>debt_ratio_year</td>\n",
       "      <td>2.537758</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>annualIncome</td>\n",
       "      <td>1.997595</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>purpose_subGrade_default_ratio</td>\n",
       "      <td>1.906145</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>loanAmnt</td>\n",
       "      <td>1.739254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>revolUtil</td>\n",
       "      <td>1.598138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>n14</td>\n",
       "      <td>1.574796</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>ficoRangeHigh</td>\n",
       "      <td>1.499479</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>employmentTitle_postCode_default_ratio</td>\n",
       "      <td>1.435079</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>ficoRangeLow</td>\n",
       "      <td>1.286435</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>issueDate_year</td>\n",
       "      <td>1.210408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>installment</td>\n",
       "      <td>1.206632</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>subGrade_default_ratio</td>\n",
       "      <td>1.191838</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>regionCode_subGrade_default_ratio</td>\n",
       "      <td>1.143965</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>totalAcc</td>\n",
       "      <td>1.097126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>issueDate_year_earliesCreditLine_year_minus</td>\n",
       "      <td>1.048987</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>homeOwnership_postCode_default_ratio</td>\n",
       "      <td>1.040296</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>postCode_homeOwnership_default_ratio</td>\n",
       "      <td>1.001764</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>postCode_employmentTitle_default_ratio</td>\n",
       "      <td>1.000478</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>n9</td>\n",
       "      <td>0.986352</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>subGrade</td>\n",
       "      <td>0.962564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>subGrade_regionCode_default_ratio</td>\n",
       "      <td>0.933310</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>subGrade_initialListStatus_default_ratio</td>\n",
       "      <td>0.924671</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>n6</td>\n",
       "      <td>0.908899</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>title_subGrade_default_ratio</td>\n",
       "      <td>0.880344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>interestRate</td>\n",
       "      <td>0.869449</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>homeOwnership_regionCode_default_ratio</td>\n",
       "      <td>0.842799</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>grade_subGrade_cnt</td>\n",
       "      <td>0.798771</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>grade_homeOwnership_default_ratio</td>\n",
       "      <td>0.773732</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>n3</td>\n",
       "      <td>0.757318</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>n8</td>\n",
       "      <td>0.717593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>regionCode_homeOwnership_default_ratio</td>\n",
       "      <td>0.687437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>employmentTitle_homeOwnership_default_ratio</td>\n",
       "      <td>0.671982</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>subGrade_purpose_default_ratio</td>\n",
       "      <td>0.670311</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>n11</td>\n",
       "      <td>0.669057</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>n2</td>\n",
       "      <td>0.659391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>title_homeOwnership_default_ratio</td>\n",
       "      <td>0.645043</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>subGrade_title_default_ratio</td>\n",
       "      <td>0.643561</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>earliesCreditLine_year</td>\n",
       "      <td>0.641214</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>initialListStatus_subGrade_default_ratio</td>\n",
       "      <td>0.617380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>employmentTitle_default_ratio</td>\n",
       "      <td>0.606088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>grade_subGrade_default_ratio</td>\n",
       "      <td>0.588778</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>postCode_employmentTitle_cnt</td>\n",
       "      <td>0.584912</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>employmentTitle_postCode_cnt</td>\n",
       "      <td>0.548787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>subGrade_applicationType_default_ratio</td>\n",
       "      <td>0.525476</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>n5</td>\n",
       "      <td>0.521961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>employmentTitle_regionCode_default_ratio</td>\n",
       "      <td>0.517934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>subGrade_homeOwnership_default_ratio</td>\n",
       "      <td>0.517099</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>applicationType_employmentTitle_default_ratio</td>\n",
       "      <td>0.503021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>homeOwnership_subGrade_default_ratio</td>\n",
       "      <td>0.493963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>subGrade_grade_cnt</td>\n",
       "      <td>0.480097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>employmentTitle_applicationType_default_ratio</td>\n",
       "      <td>0.465564</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>grade_title_default_ratio</td>\n",
       "      <td>0.456111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>title_grade_default_ratio</td>\n",
       "      <td>0.451126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>postCode_subGrade_default_ratio</td>\n",
       "      <td>0.427175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>earliesCreditLine</td>\n",
       "      <td>0.419712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>delinquency_2years</td>\n",
       "      <td>0.418728</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>postCode_grade_default_ratio</td>\n",
       "      <td>0.408059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>applicationType_grade_cnt</td>\n",
       "      <td>0.387432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>homeOwnership_employmentTitle_default_ratio</td>\n",
       "      <td>0.385779</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>grade_regionCode_default_ratio</td>\n",
       "      <td>0.385452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>postCode_verificationStatus_default_ratio</td>\n",
       "      <td>0.374882</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>employmentTitle_regionCode_cnt</td>\n",
       "      <td>0.363191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>applicationType_grade_default_ratio</td>\n",
       "      <td>0.357048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>employmentTitle</td>\n",
       "      <td>0.353761</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>applicationType_subGrade_default_ratio</td>\n",
       "      <td>0.353139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>grade_postCode_default_ratio</td>\n",
       "      <td>0.350034</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>homeOwnership_grade_default_ratio</td>\n",
       "      <td>0.348103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>verificationStatus_subGrade_default_ratio</td>\n",
       "      <td>0.347558</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>regionCode_grade_default_ratio</td>\n",
       "      <td>0.347005</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>employmentTitle_initialListStatus_default_ratio</td>\n",
       "      <td>0.336963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>n0</td>\n",
       "      <td>0.332522</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>employmentLength_postCode_default_ratio</td>\n",
       "      <td>0.329761</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>employmentTitle_verificationStatus_default_ratio</td>\n",
       "      <td>0.328119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>n7</td>\n",
       "      <td>0.323418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>postCode</td>\n",
       "      <td>0.315543</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>openAcc</td>\n",
       "      <td>0.308270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>n10</td>\n",
       "      <td>0.299875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>regionCode_employmentTitle_default_ratio</td>\n",
       "      <td>0.291892</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>grade_purpose_default_ratio</td>\n",
       "      <td>0.279280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>n1</td>\n",
       "      <td>0.275566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>postCode_title_default_ratio</td>\n",
       "      <td>0.274191</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>verificationStatus_employmentTitle_default_ratio</td>\n",
       "      <td>0.269693</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>employmentLength_regionCode_default_ratio</td>\n",
       "      <td>0.269642</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>homeOwnership_postCode_cnt</td>\n",
       "      <td>0.262959</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>subGrade_verificationStatus_default_ratio</td>\n",
       "      <td>0.259004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>applicationType_postCode_default_ratio</td>\n",
       "      <td>0.259004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>homeOwnership_purpose_default_ratio</td>\n",
       "      <td>0.258847</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>regionCode_default_ratio</td>\n",
       "      <td>0.258484</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>homeOwnership_verificationStatus_default_ratio</td>\n",
       "      <td>0.256448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>postCode_purpose_default_ratio</td>\n",
       "      <td>0.255768</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>verificationStatus_grade_default_ratio</td>\n",
       "      <td>0.254473</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>title_verificationStatus_default_ratio</td>\n",
       "      <td>0.252562</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>grade_applicationType_default_ratio</td>\n",
       "      <td>0.250711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>pubRec</td>\n",
       "      <td>0.249955</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>subGrade_applicationType_cnt</td>\n",
       "      <td>0.243418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>employmentTitle_cnt</td>\n",
       "      <td>0.240107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>initialListStatus_postCode_default_ratio</td>\n",
       "      <td>0.236359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>employmentLength_homeOwnership_default_ratio</td>\n",
       "      <td>0.236007</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>grade_initialListStatus_default_ratio</td>\n",
       "      <td>0.235690</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>regionCode</td>\n",
       "      <td>0.235286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>homeOwnership_initialListStatus_default_ratio</td>\n",
       "      <td>0.234254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>employmentTitle_subGrade_default_ratio</td>\n",
       "      <td>0.232663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>regionCode_verificationStatus_default_ratio</td>\n",
       "      <td>0.231770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>regionCode_employmentTitle_cnt</td>\n",
       "      <td>0.231237</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>homeOwnership_title_default_ratio</td>\n",
       "      <td>0.230669</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>employmentLength_employmentTitle_default_ratio</td>\n",
       "      <td>0.230364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>employmentLength</td>\n",
       "      <td>0.215009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>employmentTitle_grade_default_ratio</td>\n",
       "      <td>0.212842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>purpose_grade_default_ratio</td>\n",
       "      <td>0.210878</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>employmentLength_verificationStatus_default_ratio</td>\n",
       "      <td>0.210743</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>subGrade_grade_default_ratio</td>\n",
       "      <td>0.208892</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>grade</td>\n",
       "      <td>0.203942</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>purpose_regionCode_default_ratio</td>\n",
       "      <td>0.199453</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>pubRecBankruptcies</td>\n",
       "      <td>0.198987</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>applicationType_employmentTitle_cnt</td>\n",
       "      <td>0.191993</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>n4</td>\n",
       "      <td>0.188681</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>employmentLength_default_ratio</td>\n",
       "      <td>0.187396</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>initialListStatus_regionCode_default_ratio</td>\n",
       "      <td>0.182170</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>initialListStatus_purpose_default_ratio</td>\n",
       "      <td>0.179867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>employmentLength_purpose_default_ratio</td>\n",
       "      <td>0.179484</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>grade_initialListStatus_cnt</td>\n",
       "      <td>0.177917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>postCode_default_ratio</td>\n",
       "      <td>0.177254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>postCode_purpose_cnt</td>\n",
       "      <td>0.176270</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>regionCode_title_default_ratio</td>\n",
       "      <td>0.176159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>employmentLength_grade_cnt</td>\n",
       "      <td>0.174739</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>applicationType_regionCode_default_ratio</td>\n",
       "      <td>0.172023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>employmentLength_regionCode_cnt</td>\n",
       "      <td>0.170022</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>title_employmentTitle_default_ratio</td>\n",
       "      <td>0.168620</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>postCode_subGrade_cnt</td>\n",
       "      <td>0.164863</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>employmentLength_employmentTitle_cnt</td>\n",
       "      <td>0.164383</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>employmentLength_title_default_ratio</td>\n",
       "      <td>0.163948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>initialListStatus_grade_default_ratio</td>\n",
       "      <td>0.163725</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>136</th>\n",
       "      <td>initialListStatus_postCode_cnt</td>\n",
       "      <td>0.160402</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>employmentTitle_title_default_ratio</td>\n",
       "      <td>0.159630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>138</th>\n",
       "      <td>employmentTitle_applicationType_cnt</td>\n",
       "      <td>0.159020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>139</th>\n",
       "      <td>homeOwnership_default_ratio</td>\n",
       "      <td>0.157332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>140</th>\n",
       "      <td>employmentLength_initialListStatus_default_ratio</td>\n",
       "      <td>0.157024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>employmentLength_grade_default_ratio</td>\n",
       "      <td>0.156846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>142</th>\n",
       "      <td>postCode_applicationType_default_ratio</td>\n",
       "      <td>0.152487</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>143</th>\n",
       "      <td>grade_verificationStatus_default_ratio</td>\n",
       "      <td>0.152035</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>144</th>\n",
       "      <td>regionCode_subGrade_cnt</td>\n",
       "      <td>0.150098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>145</th>\n",
       "      <td>employmentLength_subGrade_cnt</td>\n",
       "      <td>0.148420</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>purpose_subGrade_cnt</td>\n",
       "      <td>0.147416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>147</th>\n",
       "      <td>employmentTitle_purpose_default_ratio</td>\n",
       "      <td>0.145982</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>postCode_regionCode_default_ratio</td>\n",
       "      <td>0.141165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>employmentLength_postCode_cnt</td>\n",
       "      <td>0.140904</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>150</th>\n",
       "      <td>employmentTitle_homeOwnership_cnt</td>\n",
       "      <td>0.138000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>applicationType_employmentLength_default_ratio</td>\n",
       "      <td>0.136263</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>152</th>\n",
       "      <td>applicationType_homeOwnership_default_ratio</td>\n",
       "      <td>0.130042</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153</th>\n",
       "      <td>initialListStatus_title_default_ratio</td>\n",
       "      <td>0.127604</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>154</th>\n",
       "      <td>title</td>\n",
       "      <td>0.124828</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>subGrade_verificationStatus_cnt</td>\n",
       "      <td>0.124336</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>156</th>\n",
       "      <td>homeOwnership_regionCode_cnt</td>\n",
       "      <td>0.122009</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>157</th>\n",
       "      <td>initialListStatus_employmentTitle_default_ratio</td>\n",
       "      <td>0.121349</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>158</th>\n",
       "      <td>employmentTitle_employmentLength_default_ratio</td>\n",
       "      <td>0.120566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>applicationType_title_default_ratio</td>\n",
       "      <td>0.119875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>postCode_employmentLength_default_ratio</td>\n",
       "      <td>0.119606</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>161</th>\n",
       "      <td>applicationType_purpose_default_ratio</td>\n",
       "      <td>0.119241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>162</th>\n",
       "      <td>subGrade_postCode_default_ratio</td>\n",
       "      <td>0.113447</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>subGrade_cnt</td>\n",
       "      <td>0.113230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>purpose_verificationStatus_default_ratio</td>\n",
       "      <td>0.111640</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>initialListStatus_regionCode_cnt</td>\n",
       "      <td>0.110775</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>purpose_regionCode_cnt</td>\n",
       "      <td>0.110505</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>employmentLength_subGrade_default_ratio</td>\n",
       "      <td>0.110403</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>postCode_initialListStatus_default_ratio</td>\n",
       "      <td>0.107821</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>subGrade_employmentLength_cnt</td>\n",
       "      <td>0.107647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>grade_regionCode_cnt</td>\n",
       "      <td>0.107366</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>postCode_verificationStatus_cnt</td>\n",
       "      <td>0.104879</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>grade_employmentLength_cnt</td>\n",
       "      <td>0.104095</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>initialListStatus_subGrade_cnt</td>\n",
       "      <td>0.103708</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>purpose_title_default_ratio</td>\n",
       "      <td>0.101264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>n13</td>\n",
       "      <td>0.101112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>purpose_homeOwnership_default_ratio</td>\n",
       "      <td>0.101089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>homeOwnership_grade_cnt</td>\n",
       "      <td>0.100864</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>regionCode_verificationStatus_cnt</td>\n",
       "      <td>0.098633</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>purpose_default_ratio</td>\n",
       "      <td>0.097929</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>homeOwnership_employmentTitle_cnt</td>\n",
       "      <td>0.096961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>grade_postCode_cnt</td>\n",
       "      <td>0.096410</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>employmentTitle_verificationStatus_cnt</td>\n",
       "      <td>0.096380</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>homeOwnership_purpose_cnt</td>\n",
       "      <td>0.094839</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>employmentTitle_initialListStatus_cnt</td>\n",
       "      <td>0.094374</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>applicationType_verificationStatus_default_ratio</td>\n",
       "      <td>0.093566</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>employmentLength_title_cnt</td>\n",
       "      <td>0.093288</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>initialListStatus_verificationStatus_default_r...</td>\n",
       "      <td>0.091961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>initialListStatus_homeOwnership_default_ratio</td>\n",
       "      <td>0.091957</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>initialListStatus_purpose_cnt</td>\n",
       "      <td>0.089107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>verificationStatus_employmentTitle_cnt</td>\n",
       "      <td>0.087881</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>applicationType_postCode_cnt</td>\n",
       "      <td>0.087866</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>title_default_ratio</td>\n",
       "      <td>0.087039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>homeOwnership_applicationType_default_ratio</td>\n",
       "      <td>0.085394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>194</th>\n",
       "      <td>applicationType_subGrade_cnt</td>\n",
       "      <td>0.085059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>195</th>\n",
       "      <td>postCode_title_cnt</td>\n",
       "      <td>0.084994</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>196</th>\n",
       "      <td>homeOwnership_subGrade_cnt</td>\n",
       "      <td>0.084494</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>197</th>\n",
       "      <td>purpose</td>\n",
       "      <td>0.083947</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>title_employmentLength_default_ratio</td>\n",
       "      <td>0.083692</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199</th>\n",
       "      <td>regionCode_employmentLength_default_ratio</td>\n",
       "      <td>0.083636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>200</th>\n",
       "      <td>verificationStatus_homeOwnership_default_ratio</td>\n",
       "      <td>0.082416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>201</th>\n",
       "      <td>purpose_applicationType_default_ratio</td>\n",
       "      <td>0.082377</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>202</th>\n",
       "      <td>employmentLength_homeOwnership_cnt</td>\n",
       "      <td>0.082249</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>203</th>\n",
       "      <td>employmentTitle_purpose_cnt</td>\n",
       "      <td>0.079493</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>204</th>\n",
       "      <td>postCode_homeOwnership_cnt</td>\n",
       "      <td>0.077910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>205</th>\n",
       "      <td>applicationType_purpose_cnt</td>\n",
       "      <td>0.077822</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>employmentLength_purpose_cnt</td>\n",
       "      <td>0.077809</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>applicationType_regionCode_cnt</td>\n",
       "      <td>0.075286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>purpose_cnt</td>\n",
       "      <td>0.073937</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>subGrade_employmentLength_default_ratio</td>\n",
       "      <td>0.073800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>title_employmentLength_cnt</td>\n",
       "      <td>0.073014</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>verificationStatus_postCode_default_ratio</td>\n",
       "      <td>0.072906</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>employmentTitle_title_cnt</td>\n",
       "      <td>0.072570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>postCode_cnt</td>\n",
       "      <td>0.069523</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>applicationType_initialListStatus_default_ratio</td>\n",
       "      <td>0.068580</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>initialListStatus_employmentLength_default_ratio</td>\n",
       "      <td>0.067261</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>postCode_regionCode_cnt</td>\n",
       "      <td>0.067082</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>regionCode_homeOwnership_cnt</td>\n",
       "      <td>0.064788</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>subGrade_title_cnt</td>\n",
       "      <td>0.064485</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>verificationStatus_employmentLength_default_ratio</td>\n",
       "      <td>0.062240</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>grade_purpose_cnt</td>\n",
       "      <td>0.062164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>homeOwnership_employmentLength_default_ratio</td>\n",
       "      <td>0.062078</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>regionCode_applicationType_default_ratio</td>\n",
       "      <td>0.061108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>employmentTitle_subGrade_cnt</td>\n",
       "      <td>0.060773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>title_verificationStatus_cnt</td>\n",
       "      <td>0.060705</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>regionCode_initialListStatus_default_ratio</td>\n",
       "      <td>0.060353</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>employmentLength_applicationType_default_ratio</td>\n",
       "      <td>0.059857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>purpose_initialListStatus_default_ratio</td>\n",
       "      <td>0.059816</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>purpose_verificationStatus_cnt</td>\n",
       "      <td>0.059742</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>verificationStatus_regionCode_default_ratio</td>\n",
       "      <td>0.059102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>homeOwnership_verificationStatus_cnt</td>\n",
       "      <td>0.058859</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>employmentLength_verificationStatus_cnt</td>\n",
       "      <td>0.058803</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>purpose_postCode_default_ratio</td>\n",
       "      <td>0.058425</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>regionCode_title_cnt</td>\n",
       "      <td>0.056032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>title_applicationType_default_ratio</td>\n",
       "      <td>0.054997</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>applicationType_homeOwnership_cnt</td>\n",
       "      <td>0.054779</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>employmentTitle_grade_cnt</td>\n",
       "      <td>0.054329</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>verificationStatus_title_default_ratio</td>\n",
       "      <td>0.053595</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>purpose_homeOwnership_cnt</td>\n",
       "      <td>0.053312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>verificationStatus_subGrade_cnt</td>\n",
       "      <td>0.053102</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>grade_cnt</td>\n",
       "      <td>0.053030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>homeOwnership_title_cnt</td>\n",
       "      <td>0.053017</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>purpose_postCode_cnt</td>\n",
       "      <td>0.052736</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>employmentTitle_employmentLength_cnt</td>\n",
       "      <td>0.052447</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>subGrade_initialListStatus_cnt</td>\n",
       "      <td>0.050343</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>purpose_employmentLength_cnt</td>\n",
       "      <td>0.049919</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>title_regionCode_default_ratio</td>\n",
       "      <td>0.049642</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>subGrade_purpose_cnt</td>\n",
       "      <td>0.049311</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>regionCode_postCode_default_ratio</td>\n",
       "      <td>0.049288</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>verificationStatus_default_ratio</td>\n",
       "      <td>0.049121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>applicationType_default_ratio</td>\n",
       "      <td>0.048418</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>subGrade_employmentTitle_default_ratio</td>\n",
       "      <td>0.047419</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>applicationType_employmentLength_cnt</td>\n",
       "      <td>0.046360</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>employmentLength_initialListStatus_cnt</td>\n",
       "      <td>0.045828</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>grade_default_ratio</td>\n",
       "      <td>0.045570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>regionCode_cnt</td>\n",
       "      <td>0.045460</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>grade_title_cnt</td>\n",
       "      <td>0.045275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>title_postCode_default_ratio</td>\n",
       "      <td>0.044502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>purpose_employmentLength_default_ratio</td>\n",
       "      <td>0.043067</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>purpose_initialListStatus_cnt</td>\n",
       "      <td>0.042917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>260</th>\n",
       "      <td>subGrade_postCode_cnt</td>\n",
       "      <td>0.042350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>261</th>\n",
       "      <td>regionCode_employmentLength_cnt</td>\n",
       "      <td>0.042141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>262</th>\n",
       "      <td>title_initialListStatus_default_ratio</td>\n",
       "      <td>0.042030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>263</th>\n",
       "      <td>purpose_applicationType_cnt</td>\n",
       "      <td>0.041963</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>264</th>\n",
       "      <td>regionCode_purpose_default_ratio</td>\n",
       "      <td>0.039324</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>265</th>\n",
       "      <td>initialListStatus_title_cnt</td>\n",
       "      <td>0.037917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>266</th>\n",
       "      <td>initialListStatus_employmentTitle_cnt</td>\n",
       "      <td>0.037857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>267</th>\n",
       "      <td>grade_homeOwnership_cnt</td>\n",
       "      <td>0.037135</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>268</th>\n",
       "      <td>postCode_initialListStatus_cnt</td>\n",
       "      <td>0.036309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>269</th>\n",
       "      <td>verificationStatus_purpose_default_ratio</td>\n",
       "      <td>0.036154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>270</th>\n",
       "      <td>homeOwnership_applicationType_cnt</td>\n",
       "      <td>0.034927</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271</th>\n",
       "      <td>grade_employmentTitle_default_ratio</td>\n",
       "      <td>0.034924</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272</th>\n",
       "      <td>homeOwnership</td>\n",
       "      <td>0.034558</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273</th>\n",
       "      <td>employmentLength_cnt</td>\n",
       "      <td>0.034432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274</th>\n",
       "      <td>regionCode_applicationType_cnt</td>\n",
       "      <td>0.032798</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>275</th>\n",
       "      <td>regionCode_grade_cnt</td>\n",
       "      <td>0.032735</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276</th>\n",
       "      <td>purpose_employmentTitle_default_ratio</td>\n",
       "      <td>0.032039</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277</th>\n",
       "      <td>grade_employmentLength_default_ratio</td>\n",
       "      <td>0.031763</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>postCode_employmentLength_cnt</td>\n",
       "      <td>0.030853</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>verificationStatus_applicationType_default_ratio</td>\n",
       "      <td>0.030506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>280</th>\n",
       "      <td>homeOwnership_initialListStatus_cnt</td>\n",
       "      <td>0.030393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281</th>\n",
       "      <td>title_postCode_cnt</td>\n",
       "      <td>0.030121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282</th>\n",
       "      <td>grade_employmentTitle_cnt</td>\n",
       "      <td>0.030072</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>283</th>\n",
       "      <td>verificationStatus_title_cnt</td>\n",
       "      <td>0.029813</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284</th>\n",
       "      <td>initialListStatus_default_ratio</td>\n",
       "      <td>0.029180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285</th>\n",
       "      <td>title_employmentTitle_cnt</td>\n",
       "      <td>0.028603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286</th>\n",
       "      <td>title_subGrade_cnt</td>\n",
       "      <td>0.028593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287</th>\n",
       "      <td>homeOwnership_cnt</td>\n",
       "      <td>0.028591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>288</th>\n",
       "      <td>initialListStatus_applicationType_default_ratio</td>\n",
       "      <td>0.027875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289</th>\n",
       "      <td>title_purpose_default_ratio</td>\n",
       "      <td>0.027746</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>290</th>\n",
       "      <td>regionCode_initialListStatus_cnt</td>\n",
       "      <td>0.025676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291</th>\n",
       "      <td>subGrade_regionCode_cnt</td>\n",
       "      <td>0.025663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>292</th>\n",
       "      <td>regionCode_purpose_cnt</td>\n",
       "      <td>0.025598</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293</th>\n",
       "      <td>verificationStatus_regionCode_cnt</td>\n",
       "      <td>0.025470</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>subGrade_employmentTitle_cnt</td>\n",
       "      <td>0.025393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>295</th>\n",
       "      <td>grade_verificationStatus_cnt</td>\n",
       "      <td>0.025281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296</th>\n",
       "      <td>postCode_applicationType_cnt</td>\n",
       "      <td>0.025082</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297</th>\n",
       "      <td>verificationStatus_homeOwnership_cnt</td>\n",
       "      <td>0.024982</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>verificationStatus_initialListStatus_default_r...</td>\n",
       "      <td>0.024571</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>initialListStatus_verificationStatus_cnt</td>\n",
       "      <td>0.024358</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300</th>\n",
       "      <td>applicationType_title_cnt</td>\n",
       "      <td>0.023872</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>301</th>\n",
       "      <td>verificationStatus_postCode_cnt</td>\n",
       "      <td>0.023707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>302</th>\n",
       "      <td>applicationType_verificationStatus_cnt</td>\n",
       "      <td>0.023559</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>303</th>\n",
       "      <td>purpose_grade_cnt</td>\n",
       "      <td>0.023557</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>304</th>\n",
       "      <td>initialListStatus_employmentLength_cnt</td>\n",
       "      <td>0.023402</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>305</th>\n",
       "      <td>title_applicationType_cnt</td>\n",
       "      <td>0.022369</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>306</th>\n",
       "      <td>purpose_employmentTitle_cnt</td>\n",
       "      <td>0.022120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>307</th>\n",
       "      <td>purpose_title_cnt</td>\n",
       "      <td>0.021573</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>308</th>\n",
       "      <td>n12</td>\n",
       "      <td>0.021433</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>309</th>\n",
       "      <td>grade_applicationType_cnt</td>\n",
       "      <td>0.021147</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>310</th>\n",
       "      <td>verificationStatus_employmentLength_cnt</td>\n",
       "      <td>0.020315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>311</th>\n",
       "      <td>regionCode_postCode_cnt</td>\n",
       "      <td>0.019687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>312</th>\n",
       "      <td>employmentLength_applicationType_cnt</td>\n",
       "      <td>0.019506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>313</th>\n",
       "      <td>homeOwnership_employmentLength_cnt</td>\n",
       "      <td>0.019176</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>postCode_grade_cnt</td>\n",
       "      <td>0.018431</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>315</th>\n",
       "      <td>subGrade_homeOwnership_cnt</td>\n",
       "      <td>0.017318</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>316</th>\n",
       "      <td>verificationStatus_purpose_cnt</td>\n",
       "      <td>0.017011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>317</th>\n",
       "      <td>title_homeOwnership_cnt</td>\n",
       "      <td>0.016444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>318</th>\n",
       "      <td>title_initialListStatus_cnt</td>\n",
       "      <td>0.012745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>title_grade_cnt</td>\n",
       "      <td>0.012037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>320</th>\n",
       "      <td>title_cnt</td>\n",
       "      <td>0.011811</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>321</th>\n",
       "      <td>verificationStatus_cnt</td>\n",
       "      <td>0.011532</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>322</th>\n",
       "      <td>title_regionCode_cnt</td>\n",
       "      <td>0.010779</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>323</th>\n",
       "      <td>initialListStatus_grade_cnt</td>\n",
       "      <td>0.009981</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>324</th>\n",
       "      <td>verificationStatus_grade_cnt</td>\n",
       "      <td>0.009875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>325</th>\n",
       "      <td>initialListStatus_homeOwnership_cnt</td>\n",
       "      <td>0.009848</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>326</th>\n",
       "      <td>verificationStatus</td>\n",
       "      <td>0.009448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>327</th>\n",
       "      <td>verificationStatus_applicationType_cnt</td>\n",
       "      <td>0.009190</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>328</th>\n",
       "      <td>title_purpose_cnt</td>\n",
       "      <td>0.008878</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>329</th>\n",
       "      <td>applicationType_initialListStatus_cnt</td>\n",
       "      <td>0.007877</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>330</th>\n",
       "      <td>initialListStatus_applicationType_cnt</td>\n",
       "      <td>0.006600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>331</th>\n",
       "      <td>verificationStatus_initialListStatus_cnt</td>\n",
       "      <td>0.001511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>332</th>\n",
       "      <td>applicationType_cnt</td>\n",
       "      <td>0.001511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>333</th>\n",
       "      <td>initialListStatus</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>334</th>\n",
       "      <td>initialListStatus_cnt</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>335</th>\n",
       "      <td>applicationType</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                column  importance\n",
       "0                                            issueDate    6.585232\n",
       "1                                                 term    5.133756\n",
       "2                                             revolBal    2.964523\n",
       "3                                                  dti    2.863236\n",
       "4                                      debt_ratio_year    2.537758\n",
       "5                                         annualIncome    1.997595\n",
       "6                       purpose_subGrade_default_ratio    1.906145\n",
       "7                                             loanAmnt    1.739254\n",
       "8                                            revolUtil    1.598138\n",
       "9                                                  n14    1.574796\n",
       "10                                       ficoRangeHigh    1.499479\n",
       "11              employmentTitle_postCode_default_ratio    1.435079\n",
       "12                                        ficoRangeLow    1.286435\n",
       "13                                      issueDate_year    1.210408\n",
       "14                                         installment    1.206632\n",
       "15                              subGrade_default_ratio    1.191838\n",
       "16                   regionCode_subGrade_default_ratio    1.143965\n",
       "17                                            totalAcc    1.097126\n",
       "18         issueDate_year_earliesCreditLine_year_minus    1.048987\n",
       "19                homeOwnership_postCode_default_ratio    1.040296\n",
       "20                postCode_homeOwnership_default_ratio    1.001764\n",
       "21              postCode_employmentTitle_default_ratio    1.000478\n",
       "22                                                  n9    0.986352\n",
       "23                                            subGrade    0.962564\n",
       "24                   subGrade_regionCode_default_ratio    0.933310\n",
       "25            subGrade_initialListStatus_default_ratio    0.924671\n",
       "26                                                  n6    0.908899\n",
       "27                        title_subGrade_default_ratio    0.880344\n",
       "28                                        interestRate    0.869449\n",
       "29              homeOwnership_regionCode_default_ratio    0.842799\n",
       "30                                  grade_subGrade_cnt    0.798771\n",
       "31                   grade_homeOwnership_default_ratio    0.773732\n",
       "32                                                  n3    0.757318\n",
       "33                                                  n8    0.717593\n",
       "34              regionCode_homeOwnership_default_ratio    0.687437\n",
       "35         employmentTitle_homeOwnership_default_ratio    0.671982\n",
       "36                      subGrade_purpose_default_ratio    0.670311\n",
       "37                                                 n11    0.669057\n",
       "38                                                  n2    0.659391\n",
       "39                   title_homeOwnership_default_ratio    0.645043\n",
       "40                        subGrade_title_default_ratio    0.643561\n",
       "41                              earliesCreditLine_year    0.641214\n",
       "42            initialListStatus_subGrade_default_ratio    0.617380\n",
       "43                       employmentTitle_default_ratio    0.606088\n",
       "44                        grade_subGrade_default_ratio    0.588778\n",
       "45                        postCode_employmentTitle_cnt    0.584912\n",
       "46                        employmentTitle_postCode_cnt    0.548787\n",
       "47              subGrade_applicationType_default_ratio    0.525476\n",
       "48                                                  n5    0.521961\n",
       "49            employmentTitle_regionCode_default_ratio    0.517934\n",
       "50                subGrade_homeOwnership_default_ratio    0.517099\n",
       "51       applicationType_employmentTitle_default_ratio    0.503021\n",
       "52                homeOwnership_subGrade_default_ratio    0.493963\n",
       "53                                  subGrade_grade_cnt    0.480097\n",
       "54       employmentTitle_applicationType_default_ratio    0.465564\n",
       "55                           grade_title_default_ratio    0.456111\n",
       "56                           title_grade_default_ratio    0.451126\n",
       "57                     postCode_subGrade_default_ratio    0.427175\n",
       "58                                   earliesCreditLine    0.419712\n",
       "59                                  delinquency_2years    0.418728\n",
       "60                        postCode_grade_default_ratio    0.408059\n",
       "61                           applicationType_grade_cnt    0.387432\n",
       "62         homeOwnership_employmentTitle_default_ratio    0.385779\n",
       "63                      grade_regionCode_default_ratio    0.385452\n",
       "64           postCode_verificationStatus_default_ratio    0.374882\n",
       "65                      employmentTitle_regionCode_cnt    0.363191\n",
       "66                 applicationType_grade_default_ratio    0.357048\n",
       "67                                     employmentTitle    0.353761\n",
       "68              applicationType_subGrade_default_ratio    0.353139\n",
       "69                        grade_postCode_default_ratio    0.350034\n",
       "70                   homeOwnership_grade_default_ratio    0.348103\n",
       "71           verificationStatus_subGrade_default_ratio    0.347558\n",
       "72                      regionCode_grade_default_ratio    0.347005\n",
       "73     employmentTitle_initialListStatus_default_ratio    0.336963\n",
       "74                                                  n0    0.332522\n",
       "75             employmentLength_postCode_default_ratio    0.329761\n",
       "76    employmentTitle_verificationStatus_default_ratio    0.328119\n",
       "77                                                  n7    0.323418\n",
       "78                                            postCode    0.315543\n",
       "79                                             openAcc    0.308270\n",
       "80                                                 n10    0.299875\n",
       "81            regionCode_employmentTitle_default_ratio    0.291892\n",
       "82                         grade_purpose_default_ratio    0.279280\n",
       "83                                                  n1    0.275566\n",
       "84                        postCode_title_default_ratio    0.274191\n",
       "85    verificationStatus_employmentTitle_default_ratio    0.269693\n",
       "86           employmentLength_regionCode_default_ratio    0.269642\n",
       "87                          homeOwnership_postCode_cnt    0.262959\n",
       "88           subGrade_verificationStatus_default_ratio    0.259004\n",
       "89              applicationType_postCode_default_ratio    0.259004\n",
       "90                 homeOwnership_purpose_default_ratio    0.258847\n",
       "91                            regionCode_default_ratio    0.258484\n",
       "92      homeOwnership_verificationStatus_default_ratio    0.256448\n",
       "93                      postCode_purpose_default_ratio    0.255768\n",
       "94              verificationStatus_grade_default_ratio    0.254473\n",
       "95              title_verificationStatus_default_ratio    0.252562\n",
       "96                 grade_applicationType_default_ratio    0.250711\n",
       "97                                              pubRec    0.249955\n",
       "98                        subGrade_applicationType_cnt    0.243418\n",
       "99                                 employmentTitle_cnt    0.240107\n",
       "100           initialListStatus_postCode_default_ratio    0.236359\n",
       "101       employmentLength_homeOwnership_default_ratio    0.236007\n",
       "102              grade_initialListStatus_default_ratio    0.235690\n",
       "103                                         regionCode    0.235286\n",
       "104      homeOwnership_initialListStatus_default_ratio    0.234254\n",
       "105             employmentTitle_subGrade_default_ratio    0.232663\n",
       "106        regionCode_verificationStatus_default_ratio    0.231770\n",
       "107                     regionCode_employmentTitle_cnt    0.231237\n",
       "108                  homeOwnership_title_default_ratio    0.230669\n",
       "109     employmentLength_employmentTitle_default_ratio    0.230364\n",
       "110                                   employmentLength    0.215009\n",
       "111                employmentTitle_grade_default_ratio    0.212842\n",
       "112                        purpose_grade_default_ratio    0.210878\n",
       "113  employmentLength_verificationStatus_default_ratio    0.210743\n",
       "114                       subGrade_grade_default_ratio    0.208892\n",
       "115                                              grade    0.203942\n",
       "116                   purpose_regionCode_default_ratio    0.199453\n",
       "117                                 pubRecBankruptcies    0.198987\n",
       "118                applicationType_employmentTitle_cnt    0.191993\n",
       "119                                                 n4    0.188681\n",
       "120                     employmentLength_default_ratio    0.187396\n",
       "121         initialListStatus_regionCode_default_ratio    0.182170\n",
       "122            initialListStatus_purpose_default_ratio    0.179867\n",
       "123             employmentLength_purpose_default_ratio    0.179484\n",
       "124                        grade_initialListStatus_cnt    0.177917\n",
       "125                             postCode_default_ratio    0.177254\n",
       "126                               postCode_purpose_cnt    0.176270\n",
       "127                     regionCode_title_default_ratio    0.176159\n",
       "128                         employmentLength_grade_cnt    0.174739\n",
       "129           applicationType_regionCode_default_ratio    0.172023\n",
       "130                    employmentLength_regionCode_cnt    0.170022\n",
       "131                title_employmentTitle_default_ratio    0.168620\n",
       "132                              postCode_subGrade_cnt    0.164863\n",
       "133               employmentLength_employmentTitle_cnt    0.164383\n",
       "134               employmentLength_title_default_ratio    0.163948\n",
       "135              initialListStatus_grade_default_ratio    0.163725\n",
       "136                     initialListStatus_postCode_cnt    0.160402\n",
       "137                employmentTitle_title_default_ratio    0.159630\n",
       "138                employmentTitle_applicationType_cnt    0.159020\n",
       "139                        homeOwnership_default_ratio    0.157332\n",
       "140   employmentLength_initialListStatus_default_ratio    0.157024\n",
       "141               employmentLength_grade_default_ratio    0.156846\n",
       "142             postCode_applicationType_default_ratio    0.152487\n",
       "143             grade_verificationStatus_default_ratio    0.152035\n",
       "144                            regionCode_subGrade_cnt    0.150098\n",
       "145                      employmentLength_subGrade_cnt    0.148420\n",
       "146                               purpose_subGrade_cnt    0.147416\n",
       "147              employmentTitle_purpose_default_ratio    0.145982\n",
       "148                  postCode_regionCode_default_ratio    0.141165\n",
       "149                      employmentLength_postCode_cnt    0.140904\n",
       "150                  employmentTitle_homeOwnership_cnt    0.138000\n",
       "151     applicationType_employmentLength_default_ratio    0.136263\n",
       "152        applicationType_homeOwnership_default_ratio    0.130042\n",
       "153              initialListStatus_title_default_ratio    0.127604\n",
       "154                                              title    0.124828\n",
       "155                    subGrade_verificationStatus_cnt    0.124336\n",
       "156                       homeOwnership_regionCode_cnt    0.122009\n",
       "157    initialListStatus_employmentTitle_default_ratio    0.121349\n",
       "158     employmentTitle_employmentLength_default_ratio    0.120566\n",
       "159                applicationType_title_default_ratio    0.119875\n",
       "160            postCode_employmentLength_default_ratio    0.119606\n",
       "161              applicationType_purpose_default_ratio    0.119241\n",
       "162                    subGrade_postCode_default_ratio    0.113447\n",
       "163                                       subGrade_cnt    0.113230\n",
       "164           purpose_verificationStatus_default_ratio    0.111640\n",
       "165                   initialListStatus_regionCode_cnt    0.110775\n",
       "166                             purpose_regionCode_cnt    0.110505\n",
       "167            employmentLength_subGrade_default_ratio    0.110403\n",
       "168           postCode_initialListStatus_default_ratio    0.107821\n",
       "169                      subGrade_employmentLength_cnt    0.107647\n",
       "170                               grade_regionCode_cnt    0.107366\n",
       "171                    postCode_verificationStatus_cnt    0.104879\n",
       "172                         grade_employmentLength_cnt    0.104095\n",
       "173                     initialListStatus_subGrade_cnt    0.103708\n",
       "174                        purpose_title_default_ratio    0.101264\n",
       "175                                                n13    0.101112\n",
       "176                purpose_homeOwnership_default_ratio    0.101089\n",
       "177                            homeOwnership_grade_cnt    0.100864\n",
       "178                  regionCode_verificationStatus_cnt    0.098633\n",
       "179                              purpose_default_ratio    0.097929\n",
       "180                  homeOwnership_employmentTitle_cnt    0.096961\n",
       "181                                 grade_postCode_cnt    0.096410\n",
       "182             employmentTitle_verificationStatus_cnt    0.096380\n",
       "183                          homeOwnership_purpose_cnt    0.094839\n",
       "184              employmentTitle_initialListStatus_cnt    0.094374\n",
       "185   applicationType_verificationStatus_default_ratio    0.093566\n",
       "186                         employmentLength_title_cnt    0.093288\n",
       "187  initialListStatus_verificationStatus_default_r...    0.091961\n",
       "188      initialListStatus_homeOwnership_default_ratio    0.091957\n",
       "189                      initialListStatus_purpose_cnt    0.089107\n",
       "190             verificationStatus_employmentTitle_cnt    0.087881\n",
       "191                       applicationType_postCode_cnt    0.087866\n",
       "192                                title_default_ratio    0.087039\n",
       "193        homeOwnership_applicationType_default_ratio    0.085394\n",
       "194                       applicationType_subGrade_cnt    0.085059\n",
       "195                                 postCode_title_cnt    0.084994\n",
       "196                         homeOwnership_subGrade_cnt    0.084494\n",
       "197                                            purpose    0.083947\n",
       "198               title_employmentLength_default_ratio    0.083692\n",
       "199          regionCode_employmentLength_default_ratio    0.083636\n",
       "200     verificationStatus_homeOwnership_default_ratio    0.082416\n",
       "201              purpose_applicationType_default_ratio    0.082377\n",
       "202                 employmentLength_homeOwnership_cnt    0.082249\n",
       "203                        employmentTitle_purpose_cnt    0.079493\n",
       "204                         postCode_homeOwnership_cnt    0.077910\n",
       "205                        applicationType_purpose_cnt    0.077822\n",
       "206                       employmentLength_purpose_cnt    0.077809\n",
       "207                     applicationType_regionCode_cnt    0.075286\n",
       "208                                        purpose_cnt    0.073937\n",
       "209            subGrade_employmentLength_default_ratio    0.073800\n",
       "210                         title_employmentLength_cnt    0.073014\n",
       "211          verificationStatus_postCode_default_ratio    0.072906\n",
       "212                          employmentTitle_title_cnt    0.072570\n",
       "213                                       postCode_cnt    0.069523\n",
       "214    applicationType_initialListStatus_default_ratio    0.068580\n",
       "215   initialListStatus_employmentLength_default_ratio    0.067261\n",
       "216                            postCode_regionCode_cnt    0.067082\n",
       "217                       regionCode_homeOwnership_cnt    0.064788\n",
       "218                                 subGrade_title_cnt    0.064485\n",
       "219  verificationStatus_employmentLength_default_ratio    0.062240\n",
       "220                                  grade_purpose_cnt    0.062164\n",
       "221       homeOwnership_employmentLength_default_ratio    0.062078\n",
       "222           regionCode_applicationType_default_ratio    0.061108\n",
       "223                       employmentTitle_subGrade_cnt    0.060773\n",
       "224                       title_verificationStatus_cnt    0.060705\n",
       "225         regionCode_initialListStatus_default_ratio    0.060353\n",
       "226     employmentLength_applicationType_default_ratio    0.059857\n",
       "227            purpose_initialListStatus_default_ratio    0.059816\n",
       "228                     purpose_verificationStatus_cnt    0.059742\n",
       "229        verificationStatus_regionCode_default_ratio    0.059102\n",
       "230               homeOwnership_verificationStatus_cnt    0.058859\n",
       "231            employmentLength_verificationStatus_cnt    0.058803\n",
       "232                     purpose_postCode_default_ratio    0.058425\n",
       "233                               regionCode_title_cnt    0.056032\n",
       "234                title_applicationType_default_ratio    0.054997\n",
       "235                  applicationType_homeOwnership_cnt    0.054779\n",
       "236                          employmentTitle_grade_cnt    0.054329\n",
       "237             verificationStatus_title_default_ratio    0.053595\n",
       "238                          purpose_homeOwnership_cnt    0.053312\n",
       "239                    verificationStatus_subGrade_cnt    0.053102\n",
       "240                                          grade_cnt    0.053030\n",
       "241                            homeOwnership_title_cnt    0.053017\n",
       "242                               purpose_postCode_cnt    0.052736\n",
       "243               employmentTitle_employmentLength_cnt    0.052447\n",
       "244                     subGrade_initialListStatus_cnt    0.050343\n",
       "245                       purpose_employmentLength_cnt    0.049919\n",
       "246                     title_regionCode_default_ratio    0.049642\n",
       "247                               subGrade_purpose_cnt    0.049311\n",
       "248                  regionCode_postCode_default_ratio    0.049288\n",
       "249                   verificationStatus_default_ratio    0.049121\n",
       "250                      applicationType_default_ratio    0.048418\n",
       "251             subGrade_employmentTitle_default_ratio    0.047419\n",
       "252               applicationType_employmentLength_cnt    0.046360\n",
       "253             employmentLength_initialListStatus_cnt    0.045828\n",
       "254                                grade_default_ratio    0.045570\n",
       "255                                     regionCode_cnt    0.045460\n",
       "256                                    grade_title_cnt    0.045275\n",
       "257                       title_postCode_default_ratio    0.044502\n",
       "258             purpose_employmentLength_default_ratio    0.043067\n",
       "259                      purpose_initialListStatus_cnt    0.042917\n",
       "260                              subGrade_postCode_cnt    0.042350\n",
       "261                    regionCode_employmentLength_cnt    0.042141\n",
       "262              title_initialListStatus_default_ratio    0.042030\n",
       "263                        purpose_applicationType_cnt    0.041963\n",
       "264                   regionCode_purpose_default_ratio    0.039324\n",
       "265                        initialListStatus_title_cnt    0.037917\n",
       "266              initialListStatus_employmentTitle_cnt    0.037857\n",
       "267                            grade_homeOwnership_cnt    0.037135\n",
       "268                     postCode_initialListStatus_cnt    0.036309\n",
       "269           verificationStatus_purpose_default_ratio    0.036154\n",
       "270                  homeOwnership_applicationType_cnt    0.034927\n",
       "271                grade_employmentTitle_default_ratio    0.034924\n",
       "272                                      homeOwnership    0.034558\n",
       "273                               employmentLength_cnt    0.034432\n",
       "274                     regionCode_applicationType_cnt    0.032798\n",
       "275                               regionCode_grade_cnt    0.032735\n",
       "276              purpose_employmentTitle_default_ratio    0.032039\n",
       "277               grade_employmentLength_default_ratio    0.031763\n",
       "278                      postCode_employmentLength_cnt    0.030853\n",
       "279   verificationStatus_applicationType_default_ratio    0.030506\n",
       "280                homeOwnership_initialListStatus_cnt    0.030393\n",
       "281                                 title_postCode_cnt    0.030121\n",
       "282                          grade_employmentTitle_cnt    0.030072\n",
       "283                       verificationStatus_title_cnt    0.029813\n",
       "284                    initialListStatus_default_ratio    0.029180\n",
       "285                          title_employmentTitle_cnt    0.028603\n",
       "286                                 title_subGrade_cnt    0.028593\n",
       "287                                  homeOwnership_cnt    0.028591\n",
       "288    initialListStatus_applicationType_default_ratio    0.027875\n",
       "289                        title_purpose_default_ratio    0.027746\n",
       "290                   regionCode_initialListStatus_cnt    0.025676\n",
       "291                            subGrade_regionCode_cnt    0.025663\n",
       "292                             regionCode_purpose_cnt    0.025598\n",
       "293                  verificationStatus_regionCode_cnt    0.025470\n",
       "294                       subGrade_employmentTitle_cnt    0.025393\n",
       "295                       grade_verificationStatus_cnt    0.025281\n",
       "296                       postCode_applicationType_cnt    0.025082\n",
       "297               verificationStatus_homeOwnership_cnt    0.024982\n",
       "298  verificationStatus_initialListStatus_default_r...    0.024571\n",
       "299           initialListStatus_verificationStatus_cnt    0.024358\n",
       "300                          applicationType_title_cnt    0.023872\n",
       "301                    verificationStatus_postCode_cnt    0.023707\n",
       "302             applicationType_verificationStatus_cnt    0.023559\n",
       "303                                  purpose_grade_cnt    0.023557\n",
       "304             initialListStatus_employmentLength_cnt    0.023402\n",
       "305                          title_applicationType_cnt    0.022369\n",
       "306                        purpose_employmentTitle_cnt    0.022120\n",
       "307                                  purpose_title_cnt    0.021573\n",
       "308                                                n12    0.021433\n",
       "309                          grade_applicationType_cnt    0.021147\n",
       "310            verificationStatus_employmentLength_cnt    0.020315\n",
       "311                            regionCode_postCode_cnt    0.019687\n",
       "312               employmentLength_applicationType_cnt    0.019506\n",
       "313                 homeOwnership_employmentLength_cnt    0.019176\n",
       "314                                 postCode_grade_cnt    0.018431\n",
       "315                         subGrade_homeOwnership_cnt    0.017318\n",
       "316                     verificationStatus_purpose_cnt    0.017011\n",
       "317                            title_homeOwnership_cnt    0.016444\n",
       "318                        title_initialListStatus_cnt    0.012745\n",
       "319                                    title_grade_cnt    0.012037\n",
       "320                                          title_cnt    0.011811\n",
       "321                             verificationStatus_cnt    0.011532\n",
       "322                               title_regionCode_cnt    0.010779\n",
       "323                        initialListStatus_grade_cnt    0.009981\n",
       "324                       verificationStatus_grade_cnt    0.009875\n",
       "325                initialListStatus_homeOwnership_cnt    0.009848\n",
       "326                                 verificationStatus    0.009448\n",
       "327             verificationStatus_applicationType_cnt    0.009190\n",
       "328                                  title_purpose_cnt    0.008878\n",
       "329              applicationType_initialListStatus_cnt    0.007877\n",
       "330              initialListStatus_applicationType_cnt    0.006600\n",
       "331           verificationStatus_initialListStatus_cnt    0.001511\n",
       "332                                applicationType_cnt    0.001511\n",
       "333                                  initialListStatus    0.000000\n",
       "334                              initialListStatus_cnt    0.000000\n",
       "335                                    applicationType    0.000000"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_importance = pd.concat(df_importance_list)\n",
    "df_importance = df_importance.groupby([\n",
    "    'column'\n",
    "])['importance'].agg('mean').sort_values(ascending=False).reset_index()\n",
    "df_importance"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-06T02:18:46.295468Z",
     "start_time": "2020-11-06T02:18:46.057051Z"
    },
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "auc: 0.7433005718659207\n"
     ]
    }
   ],
   "source": [
    "auc = roc_auc_score(df_oof[ycol], df_oof['prob'])\n",
    "print('auc:', auc)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-06T02:18:46.724876Z",
     "start_time": "2020-11-06T02:18:46.297625Z"
    }
   },
   "outputs": [],
   "source": [
    "os.makedirs('sub', exist_ok=True)\n",
    "\n",
    "sub = prediction[['id', 'prob']].copy()\n",
    "sub.columns = ['id', 'isDefault']\n",
    "sub.to_csv('sub/jiedai_{}.csv'.format(auc), index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-06T02:18:48.934850Z",
     "start_time": "2020-11-06T02:18:46.726216Z"
    }
   },
   "outputs": [],
   "source": [
    "os.makedirs('prob', exist_ok=True)\n",
    "\n",
    "prediction.to_csv('prob/sub_cbt.csv', index=False)\n",
    "df_oof[['id', 'prob', ycol]].to_csv('prob/oof_cbt.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-06T02:18:48.941809Z",
     "start_time": "2020-11-06T02:18:48.936117Z"
    }
   },
   "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>id</th>\n",
       "      <th>isDefault</th>\n",
       "      <th>prob</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.231715</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>23</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.309012</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>28</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.127430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>32</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.322757</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>42</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.299982</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   id  isDefault      prob\n",
       "0   1        0.0  0.231715\n",
       "1  23        1.0  0.309012\n",
       "2  28        0.0  0.127430\n",
       "3  32        0.0  0.322757\n",
       "4  42        1.0  0.299982"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_oof.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2020-11-06T02:18:48.962370Z",
     "start_time": "2020-11-06T02:18:48.942857Z"
    }
   },
   "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>id</th>\n",
       "      <th>prob</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>800000</th>\n",
       "      <td>800000</td>\n",
       "      <td>0.055286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>800001</th>\n",
       "      <td>800001</td>\n",
       "      <td>0.338298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>800002</th>\n",
       "      <td>800002</td>\n",
       "      <td>0.332441</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>800003</th>\n",
       "      <td>800003</td>\n",
       "      <td>0.300399</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>800004</th>\n",
       "      <td>800004</td>\n",
       "      <td>0.404484</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            id      prob\n",
       "800000  800000  0.055286\n",
       "800001  800001  0.338298\n",
       "800002  800002  0.332441\n",
       "800003  800003  0.300399\n",
       "800004  800004  0.404484"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "prediction.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python [conda env:dm]",
   "language": "python",
   "name": "conda-env-dm-py"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}