corelation_buerau_with_amt_credit_sum.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "ran\n"
     ]
    }
   ],
   "source": [
    "import  pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "print('ran')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Shape of training data: (1716428, 17)\n"
     ]
    }
   ],
   "source": [
    "bureau=pd.read_csv(\"C:\\\\Users\\\\dbda\\\\Desktop\\\\bureau.csv\")\n",
    "print(\"Shape of training data: {}\".format(bureau.shape))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Shape of training data: (1716428, 15)\n"
     ]
    }
   ],
   "source": [
    "bureau.drop('SK_ID_CURR', inplace=True, axis=1)\n",
    "bureau.drop('SK_ID_BUREAU', inplace=True, axis=1)\n",
    "print(\"Shape of training data: {}\".format(bureau.shape))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame(bureau)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CREDIT_ACTIVE</th>\n",
       "      <th>CREDIT_CURRENCY</th>\n",
       "      <th>DAYS_CREDIT</th>\n",
       "      <th>CREDIT_DAY_OVERDUE</th>\n",
       "      <th>DAYS_CREDIT_ENDDATE</th>\n",
       "      <th>DAYS_ENDDATE_FACT</th>\n",
       "      <th>AMT_CREDIT_MAX_OVERDUE</th>\n",
       "      <th>CNT_CREDIT_PROLONG</th>\n",
       "      <th>AMT_CREDIT_SUM</th>\n",
       "      <th>AMT_CREDIT_SUM_DEBT</th>\n",
       "      <th>AMT_CREDIT_SUM_LIMIT</th>\n",
       "      <th>AMT_CREDIT_SUM_OVERDUE</th>\n",
       "      <th>CREDIT_TYPE</th>\n",
       "      <th>DAYS_CREDIT_UPDATE</th>\n",
       "      <th>AMT_ANNUITY</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-497</td>\n",
       "      <td>0</td>\n",
       "      <td>-153.0</td>\n",
       "      <td>-153.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>91323.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-131</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-208</td>\n",
       "      <td>0</td>\n",
       "      <td>1075.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>225000.000</td>\n",
       "      <td>171342.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-20</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-203</td>\n",
       "      <td>0</td>\n",
       "      <td>528.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>464323.500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-16</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-203</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>90000.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-16</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-629</td>\n",
       "      <td>0</td>\n",
       "      <td>1197.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>77674.500</td>\n",
       "      <td>0</td>\n",
       "      <td>2700000.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-21</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-273</td>\n",
       "      <td>0</td>\n",
       "      <td>27460.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>180000.000</td>\n",
       "      <td>71017.380</td>\n",
       "      <td>108982.620</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-31</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-43</td>\n",
       "      <td>0</td>\n",
       "      <td>79.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>42103.800</td>\n",
       "      <td>42103.800</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-22</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1896</td>\n",
       "      <td>0</td>\n",
       "      <td>-1684.0</td>\n",
       "      <td>-1710.0</td>\n",
       "      <td>14985.000</td>\n",
       "      <td>0</td>\n",
       "      <td>76878.450</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-1710</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1146</td>\n",
       "      <td>0</td>\n",
       "      <td>-811.0</td>\n",
       "      <td>-840.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>103007.700</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-840</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1146</td>\n",
       "      <td>0</td>\n",
       "      <td>-484.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>4500.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-690</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1146</td>\n",
       "      <td>0</td>\n",
       "      <td>-180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>337500.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-690</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2456</td>\n",
       "      <td>0</td>\n",
       "      <td>-629.0</td>\n",
       "      <td>-825.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>675000.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-706</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-277</td>\n",
       "      <td>0</td>\n",
       "      <td>5261.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>7033500.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Mortgage</td>\n",
       "      <td>-31</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-96</td>\n",
       "      <td>0</td>\n",
       "      <td>269.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>89910.000</td>\n",
       "      <td>76905.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-22</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-318</td>\n",
       "      <td>0</td>\n",
       "      <td>-187.0</td>\n",
       "      <td>-187.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-185</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2911</td>\n",
       "      <td>0</td>\n",
       "      <td>-2607.0</td>\n",
       "      <td>-2604.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>48555.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-2601</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2148</td>\n",
       "      <td>0</td>\n",
       "      <td>-1595.0</td>\n",
       "      <td>-987.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>135000.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-984</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-381</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>450000.000</td>\n",
       "      <td>520920.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-4</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-95</td>\n",
       "      <td>0</td>\n",
       "      <td>1720.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>67500.000</td>\n",
       "      <td>8131.500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-7</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-444</td>\n",
       "      <td>0</td>\n",
       "      <td>-77.0</td>\n",
       "      <td>-77.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>107184.060</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-71</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-392</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>252000.000</td>\n",
       "      <td>23679.000</td>\n",
       "      <td>228320.100</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-22</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-784</td>\n",
       "      <td>0</td>\n",
       "      <td>1008.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-411.615</td>\n",
       "      <td>411.615</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-694</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-774</td>\n",
       "      <td>0</td>\n",
       "      <td>625.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>127840.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-210</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-395</td>\n",
       "      <td>0</td>\n",
       "      <td>1431.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>1350000.000</td>\n",
       "      <td>1185493.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-24</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2744</td>\n",
       "      <td>0</td>\n",
       "      <td>-2561.0</td>\n",
       "      <td>-2559.0</td>\n",
       "      <td>310.500</td>\n",
       "      <td>0</td>\n",
       "      <td>18157.500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-2559</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1103</td>\n",
       "      <td>0</td>\n",
       "      <td>-7.0</td>\n",
       "      <td>-343.0</td>\n",
       "      <td>20493.270</td>\n",
       "      <td>0</td>\n",
       "      <td>675000.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-343</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-315</td>\n",
       "      <td>0</td>\n",
       "      <td>1512.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88821.000</td>\n",
       "      <td>0</td>\n",
       "      <td>3709552.500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Car loan</td>\n",
       "      <td>-32</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1331</td>\n",
       "      <td>0</td>\n",
       "      <td>-994.0</td>\n",
       "      <td>-1023.0</td>\n",
       "      <td>1350.000</td>\n",
       "      <td>0</td>\n",
       "      <td>39433.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-1023</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2534</td>\n",
       "      <td>0</td>\n",
       "      <td>-2352.0</td>\n",
       "      <td>-2347.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>38830.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-2345</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-845</td>\n",
       "      <td>0</td>\n",
       "      <td>-480.0</td>\n",
       "      <td>-480.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>67500.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-480</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716398</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1529</td>\n",
       "      <td>0</td>\n",
       "      <td>-829.0</td>\n",
       "      <td>-829.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>209898.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-824</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716399</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-613</td>\n",
       "      <td>0</td>\n",
       "      <td>721.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>972000.000</td>\n",
       "      <td>886297.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-42</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716400</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-815</td>\n",
       "      <td>0</td>\n",
       "      <td>1011.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>147150.000</td>\n",
       "      <td>105358.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-70</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716401</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2333</td>\n",
       "      <td>0</td>\n",
       "      <td>-2027.0</td>\n",
       "      <td>-1984.0</td>\n",
       "      <td>173.070</td>\n",
       "      <td>0</td>\n",
       "      <td>35032.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-1984</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716402</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1714</td>\n",
       "      <td>0</td>\n",
       "      <td>-1530.0</td>\n",
       "      <td>-1564.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>35271.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-1532</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716403</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-765</td>\n",
       "      <td>0</td>\n",
       "      <td>1061.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>1431000.000</td>\n",
       "      <td>1092226.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-126</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716404</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-99</td>\n",
       "      <td>0</td>\n",
       "      <td>997.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>450000.000</td>\n",
       "      <td>432787.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-7</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716405</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2390</td>\n",
       "      <td>0</td>\n",
       "      <td>-2053.0</td>\n",
       "      <td>-2082.0</td>\n",
       "      <td>11317.590</td>\n",
       "      <td>0</td>\n",
       "      <td>112204.350</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-2082</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716406</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2517</td>\n",
       "      <td>0</td>\n",
       "      <td>-660.0</td>\n",
       "      <td>-2363.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>473940.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Car loan</td>\n",
       "      <td>-2363</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716407</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1990</td>\n",
       "      <td>0</td>\n",
       "      <td>-1244.0</td>\n",
       "      <td>-1248.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>90000.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-1248</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716408</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-434</td>\n",
       "      <td>0</td>\n",
       "      <td>-344.0</td>\n",
       "      <td>-344.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>234000.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-336</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716409</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1705</td>\n",
       "      <td>0</td>\n",
       "      <td>-582.0</td>\n",
       "      <td>-582.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-582</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716410</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-575</td>\n",
       "      <td>0</td>\n",
       "      <td>813.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>67500.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-46</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716411</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-821</td>\n",
       "      <td>0</td>\n",
       "      <td>-425.0</td>\n",
       "      <td>-545.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>108765.720</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-545</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716412</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-541</td>\n",
       "      <td>0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>225000.000</td>\n",
       "      <td>10971.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-11</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716413</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-463</td>\n",
       "      <td>0</td>\n",
       "      <td>-36.0</td>\n",
       "      <td>-36.0</td>\n",
       "      <td>6863.715</td>\n",
       "      <td>0</td>\n",
       "      <td>110878.470</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-33</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716414</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1628</td>\n",
       "      <td>0</td>\n",
       "      <td>-1320.0</td>\n",
       "      <td>-1320.0</td>\n",
       "      <td>5693.625</td>\n",
       "      <td>0</td>\n",
       "      <td>57834.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-1320</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716415</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1970</td>\n",
       "      <td>0</td>\n",
       "      <td>-1577.0</td>\n",
       "      <td>-1577.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>93955.500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-1577</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716416</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1100</td>\n",
       "      <td>0</td>\n",
       "      <td>-732.0</td>\n",
       "      <td>-731.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>98775.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-720</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716417</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-740</td>\n",
       "      <td>0</td>\n",
       "      <td>31128.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>67500.000</td>\n",
       "      <td>2466.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-433</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716418</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1389</td>\n",
       "      <td>0</td>\n",
       "      <td>-1299.0</td>\n",
       "      <td>-1299.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>334158.435</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-1299</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716419</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1808</td>\n",
       "      <td>0</td>\n",
       "      <td>-1596.0</td>\n",
       "      <td>-1625.0</td>\n",
       "      <td>8100.000</td>\n",
       "      <td>0</td>\n",
       "      <td>28248.840</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-1625</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716420</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-99</td>\n",
       "      <td>0</td>\n",
       "      <td>-83.0</td>\n",
       "      <td>-98.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>27000.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-18</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716421</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1335</td>\n",
       "      <td>0</td>\n",
       "      <td>-1152.0</td>\n",
       "      <td>-1152.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>195408.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-1139</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716422</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2648</td>\n",
       "      <td>0</td>\n",
       "      <td>31129.0</td>\n",
       "      <td>-189.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>202500.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Credit card</td>\n",
       "      <td>-109</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716423</th>\n",
       "      <td>Active</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-44</td>\n",
       "      <td>0</td>\n",
       "      <td>-30.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>11250.000</td>\n",
       "      <td>11250.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Microloan</td>\n",
       "      <td>-19</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716424</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-2648</td>\n",
       "      <td>0</td>\n",
       "      <td>-2433.0</td>\n",
       "      <td>-2493.0</td>\n",
       "      <td>5476.500</td>\n",
       "      <td>0</td>\n",
       "      <td>38130.840</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-2493</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716425</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1809</td>\n",
       "      <td>0</td>\n",
       "      <td>-1628.0</td>\n",
       "      <td>-970.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>15570.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-967</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716426</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-1878</td>\n",
       "      <td>0</td>\n",
       "      <td>-1513.0</td>\n",
       "      <td>-1513.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>36000.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Consumer credit</td>\n",
       "      <td>-1508</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716427</th>\n",
       "      <td>Closed</td>\n",
       "      <td>currency 1</td>\n",
       "      <td>-463</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-387.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>22500.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Microloan</td>\n",
       "      <td>-387</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1716428 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        CREDIT_ACTIVE CREDIT_CURRENCY  DAYS_CREDIT  CREDIT_DAY_OVERDUE  \\\n",
       "0              Closed      currency 1         -497                   0   \n",
       "1              Active      currency 1         -208                   0   \n",
       "2              Active      currency 1         -203                   0   \n",
       "3              Active      currency 1         -203                   0   \n",
       "4              Active      currency 1         -629                   0   \n",
       "5              Active      currency 1         -273                   0   \n",
       "6              Active      currency 1          -43                   0   \n",
       "7              Closed      currency 1        -1896                   0   \n",
       "8              Closed      currency 1        -1146                   0   \n",
       "9              Active      currency 1        -1146                   0   \n",
       "10             Active      currency 1        -1146                   0   \n",
       "11             Closed      currency 1        -2456                   0   \n",
       "12             Active      currency 1         -277                   0   \n",
       "13             Active      currency 1          -96                   0   \n",
       "14             Closed      currency 1         -318                   0   \n",
       "15             Closed      currency 1        -2911                   0   \n",
       "16             Closed      currency 1        -2148                   0   \n",
       "17             Active      currency 1         -381                   0   \n",
       "18             Active      currency 1          -95                   0   \n",
       "19             Closed      currency 1         -444                   0   \n",
       "20             Active      currency 1         -392                   0   \n",
       "21             Active      currency 1         -784                   0   \n",
       "22             Active      currency 1         -774                   0   \n",
       "23             Active      currency 1         -395                   0   \n",
       "24             Closed      currency 1        -2744                   0   \n",
       "25             Closed      currency 1        -1103                   0   \n",
       "26             Active      currency 1         -315                   0   \n",
       "27             Closed      currency 1        -1331                   0   \n",
       "28             Closed      currency 1        -2534                   0   \n",
       "29             Closed      currency 1         -845                   0   \n",
       "...               ...             ...          ...                 ...   \n",
       "1716398        Closed      currency 1        -1529                   0   \n",
       "1716399        Active      currency 1         -613                   0   \n",
       "1716400        Active      currency 1         -815                   0   \n",
       "1716401        Closed      currency 1        -2333                   0   \n",
       "1716402        Closed      currency 1        -1714                   0   \n",
       "1716403        Active      currency 1         -765                   0   \n",
       "1716404        Active      currency 1          -99                   0   \n",
       "1716405        Closed      currency 1        -2390                   0   \n",
       "1716406        Closed      currency 1        -2517                   0   \n",
       "1716407        Closed      currency 1        -1990                   0   \n",
       "1716408        Closed      currency 1         -434                   0   \n",
       "1716409        Closed      currency 1        -1705                   0   \n",
       "1716410        Active      currency 1         -575                   0   \n",
       "1716411        Closed      currency 1         -821                   0   \n",
       "1716412        Active      currency 1         -541                   0   \n",
       "1716413        Closed      currency 1         -463                   0   \n",
       "1716414        Closed      currency 1        -1628                   0   \n",
       "1716415        Closed      currency 1        -1970                   0   \n",
       "1716416        Closed      currency 1        -1100                   0   \n",
       "1716417        Active      currency 1         -740                   0   \n",
       "1716418        Closed      currency 1        -1389                   0   \n",
       "1716419        Closed      currency 1        -1808                   0   \n",
       "1716420        Closed      currency 1          -99                   0   \n",
       "1716421        Closed      currency 1        -1335                   0   \n",
       "1716422        Closed      currency 1        -2648                   0   \n",
       "1716423        Active      currency 1          -44                   0   \n",
       "1716424        Closed      currency 1        -2648                   0   \n",
       "1716425        Closed      currency 1        -1809                   0   \n",
       "1716426        Closed      currency 1        -1878                   0   \n",
       "1716427        Closed      currency 1         -463                   0   \n",
       "\n",
       "         DAYS_CREDIT_ENDDATE  DAYS_ENDDATE_FACT  AMT_CREDIT_MAX_OVERDUE  \\\n",
       "0                     -153.0             -153.0                     NaN   \n",
       "1                     1075.0                NaN                     NaN   \n",
       "2                      528.0                NaN                     NaN   \n",
       "3                        NaN                NaN                     NaN   \n",
       "4                     1197.0                NaN               77674.500   \n",
       "5                    27460.0                NaN                   0.000   \n",
       "6                       79.0                NaN                   0.000   \n",
       "7                    -1684.0            -1710.0               14985.000   \n",
       "8                     -811.0             -840.0                   0.000   \n",
       "9                     -484.0                NaN                   0.000   \n",
       "10                    -180.0                NaN                   0.000   \n",
       "11                    -629.0             -825.0                     NaN   \n",
       "12                    5261.0                NaN                   0.000   \n",
       "13                     269.0                NaN                   0.000   \n",
       "14                    -187.0             -187.0                     NaN   \n",
       "15                   -2607.0            -2604.0                     NaN   \n",
       "16                   -1595.0             -987.0                     NaN   \n",
       "17                       NaN                NaN                     NaN   \n",
       "18                    1720.0                NaN                     NaN   \n",
       "19                     -77.0              -77.0                   0.000   \n",
       "20                       NaN                NaN                   0.000   \n",
       "21                    1008.0                NaN                   0.000   \n",
       "22                     625.0                NaN                     NaN   \n",
       "23                    1431.0                NaN                     NaN   \n",
       "24                   -2561.0            -2559.0                 310.500   \n",
       "25                      -7.0             -343.0               20493.270   \n",
       "26                    1512.0                NaN               88821.000   \n",
       "27                    -994.0            -1023.0                1350.000   \n",
       "28                   -2352.0            -2347.0                     NaN   \n",
       "29                    -480.0             -480.0                   0.000   \n",
       "...                      ...                ...                     ...   \n",
       "1716398               -829.0             -829.0                     NaN   \n",
       "1716399                721.0                NaN                     NaN   \n",
       "1716400               1011.0                NaN                     NaN   \n",
       "1716401              -2027.0            -1984.0                 173.070   \n",
       "1716402              -1530.0            -1564.0                     NaN   \n",
       "1716403               1061.0                NaN                     NaN   \n",
       "1716404                997.0                NaN                   0.000   \n",
       "1716405              -2053.0            -2082.0               11317.590   \n",
       "1716406               -660.0            -2363.0                   0.000   \n",
       "1716407              -1244.0            -1248.0                     NaN   \n",
       "1716408               -344.0             -344.0                     NaN   \n",
       "1716409               -582.0             -582.0                   0.000   \n",
       "1716410                813.0                NaN                     NaN   \n",
       "1716411               -425.0             -545.0                   0.000   \n",
       "1716412                  7.0                NaN                     NaN   \n",
       "1716413                -36.0              -36.0                6863.715   \n",
       "1716414              -1320.0            -1320.0                5693.625   \n",
       "1716415              -1577.0            -1577.0                     NaN   \n",
       "1716416               -732.0             -731.0                     NaN   \n",
       "1716417              31128.0                NaN                     NaN   \n",
       "1716418              -1299.0            -1299.0                   0.000   \n",
       "1716419              -1596.0            -1625.0                8100.000   \n",
       "1716420                -83.0              -98.0                     NaN   \n",
       "1716421              -1152.0            -1152.0                     NaN   \n",
       "1716422              31129.0             -189.0                     NaN   \n",
       "1716423                -30.0                NaN                   0.000   \n",
       "1716424              -2433.0            -2493.0                5476.500   \n",
       "1716425              -1628.0             -970.0                     NaN   \n",
       "1716426              -1513.0            -1513.0                     NaN   \n",
       "1716427                  NaN             -387.0                     NaN   \n",
       "\n",
       "         CNT_CREDIT_PROLONG  AMT_CREDIT_SUM  AMT_CREDIT_SUM_DEBT  \\\n",
       "0                         0       91323.000                0.000   \n",
       "1                         0      225000.000           171342.000   \n",
       "2                         0      464323.500                  NaN   \n",
       "3                         0       90000.000                  NaN   \n",
       "4                         0     2700000.000                  NaN   \n",
       "5                         0      180000.000            71017.380   \n",
       "6                         0       42103.800            42103.800   \n",
       "7                         0       76878.450                0.000   \n",
       "8                         0      103007.700                0.000   \n",
       "9                         0        4500.000                0.000   \n",
       "10                        0      337500.000                0.000   \n",
       "11                        0      675000.000                0.000   \n",
       "12                        0     7033500.000                  NaN   \n",
       "13                        0       89910.000            76905.000   \n",
       "14                        0           0.000                0.000   \n",
       "15                        0       48555.000                  NaN   \n",
       "16                        0      135000.000                  NaN   \n",
       "17                        0      450000.000           520920.000   \n",
       "18                        0       67500.000             8131.500   \n",
       "19                        0      107184.060                0.000   \n",
       "20                        0      252000.000            23679.000   \n",
       "21                        0           0.000             -411.615   \n",
       "22                        0      127840.500                0.000   \n",
       "23                        0     1350000.000          1185493.500   \n",
       "24                        0       18157.500                  NaN   \n",
       "25                        0      675000.000                0.000   \n",
       "26                        0     3709552.500                  NaN   \n",
       "27                        0       39433.500                0.000   \n",
       "28                        0       38830.500                0.000   \n",
       "29                        0       67500.000                0.000   \n",
       "...                     ...             ...                  ...   \n",
       "1716398                   0      209898.000                0.000   \n",
       "1716399                   0      972000.000           886297.500   \n",
       "1716400                   0      147150.000           105358.500   \n",
       "1716401                   0       35032.500                0.000   \n",
       "1716402                   0       35271.000                0.000   \n",
       "1716403                   0     1431000.000          1092226.500   \n",
       "1716404                   0      450000.000           432787.500   \n",
       "1716405                   0      112204.350                0.000   \n",
       "1716406                   0      473940.000                0.000   \n",
       "1716407                   0       90000.000                  NaN   \n",
       "1716408                   0      234000.000                0.000   \n",
       "1716409                   0           0.000                0.000   \n",
       "1716410                   0       67500.000                0.000   \n",
       "1716411                   0      108765.720                0.000   \n",
       "1716412                   0      225000.000            10971.000   \n",
       "1716413                   0      110878.470                0.000   \n",
       "1716414                   0       57834.000                0.000   \n",
       "1716415                   0       93955.500                  NaN   \n",
       "1716416                   0       98775.000                0.000   \n",
       "1716417                   0       67500.000             2466.000   \n",
       "1716418                   0      334158.435                0.000   \n",
       "1716419                   0       28248.840                0.000   \n",
       "1716420                   0       27000.000                0.000   \n",
       "1716421                   0      195408.000                0.000   \n",
       "1716422                   0      202500.000                0.000   \n",
       "1716423                   0       11250.000            11250.000   \n",
       "1716424                   0       38130.840                0.000   \n",
       "1716425                   0       15570.000                  NaN   \n",
       "1716426                   0       36000.000                0.000   \n",
       "1716427                   0       22500.000                0.000   \n",
       "\n",
       "         AMT_CREDIT_SUM_LIMIT  AMT_CREDIT_SUM_OVERDUE      CREDIT_TYPE  \\\n",
       "0                         NaN                     0.0  Consumer credit   \n",
       "1                         NaN                     0.0      Credit card   \n",
       "2                         NaN                     0.0  Consumer credit   \n",
       "3                         NaN                     0.0      Credit card   \n",
       "4                         NaN                     0.0  Consumer credit   \n",
       "5                  108982.620                     0.0      Credit card   \n",
       "6                       0.000                     0.0  Consumer credit   \n",
       "7                       0.000                     0.0  Consumer credit   \n",
       "8                       0.000                     0.0  Consumer credit   \n",
       "9                       0.000                     0.0      Credit card   \n",
       "10                      0.000                     0.0      Credit card   \n",
       "11                      0.000                     0.0  Consumer credit   \n",
       "12                        NaN                     0.0         Mortgage   \n",
       "13                      0.000                     0.0  Consumer credit   \n",
       "14                      0.000                     0.0      Credit card   \n",
       "15                        NaN                     0.0  Consumer credit   \n",
       "16                        NaN                     0.0  Consumer credit   \n",
       "17                        NaN                     0.0  Consumer credit   \n",
       "18                        NaN                     0.0      Credit card   \n",
       "19                      0.000                     0.0  Consumer credit   \n",
       "20                 228320.100                     0.0      Credit card   \n",
       "21                    411.615                     0.0      Credit card   \n",
       "22                      0.000                     0.0      Credit card   \n",
       "23                      0.000                     0.0  Consumer credit   \n",
       "24                        NaN                     0.0  Consumer credit   \n",
       "25                      0.000                     0.0  Consumer credit   \n",
       "26                        NaN                     0.0         Car loan   \n",
       "27                      0.000                     0.0  Consumer credit   \n",
       "28                      0.000                     0.0  Consumer credit   \n",
       "29                      0.000                     0.0  Consumer credit   \n",
       "...                       ...                     ...              ...   \n",
       "1716398                   NaN                     0.0  Consumer credit   \n",
       "1716399                 0.000                     0.0      Credit card   \n",
       "1716400                 0.000                     0.0  Consumer credit   \n",
       "1716401                 0.000                     0.0  Consumer credit   \n",
       "1716402                 0.000                     0.0  Consumer credit   \n",
       "1716403                 0.000                     0.0  Consumer credit   \n",
       "1716404                 0.000                     0.0  Consumer credit   \n",
       "1716405                 0.000                     0.0  Consumer credit   \n",
       "1716406                 0.000                     0.0         Car loan   \n",
       "1716407                   NaN                     0.0  Consumer credit   \n",
       "1716408                   NaN                     0.0      Credit card   \n",
       "1716409                 0.000                     0.0      Credit card   \n",
       "1716410                 0.000                     0.0      Credit card   \n",
       "1716411                 0.000                     0.0  Consumer credit   \n",
       "1716412                 0.000                     0.0  Consumer credit   \n",
       "1716413                 0.000                     0.0  Consumer credit   \n",
       "1716414                 0.000                     0.0  Consumer credit   \n",
       "1716415                   NaN                     0.0  Consumer credit   \n",
       "1716416                 0.000                     0.0  Consumer credit   \n",
       "1716417                   NaN                     0.0      Credit card   \n",
       "1716418                 0.000                     0.0  Consumer credit   \n",
       "1716419                 0.000                     0.0  Consumer credit   \n",
       "1716420                 0.000                     0.0  Consumer credit   \n",
       "1716421                   NaN                     0.0  Consumer credit   \n",
       "1716422                   NaN                     0.0      Credit card   \n",
       "1716423                 0.000                     0.0        Microloan   \n",
       "1716424                 0.000                     0.0  Consumer credit   \n",
       "1716425                   NaN                     0.0  Consumer credit   \n",
       "1716426                 0.000                     0.0  Consumer credit   \n",
       "1716427                   NaN                     0.0        Microloan   \n",
       "\n",
       "         DAYS_CREDIT_UPDATE  AMT_ANNUITY  \n",
       "0                      -131          NaN  \n",
       "1                       -20          NaN  \n",
       "2                       -16          NaN  \n",
       "3                       -16          NaN  \n",
       "4                       -21          NaN  \n",
       "5                       -31          NaN  \n",
       "6                       -22          NaN  \n",
       "7                     -1710          NaN  \n",
       "8                      -840          NaN  \n",
       "9                      -690          NaN  \n",
       "10                     -690          NaN  \n",
       "11                     -706          NaN  \n",
       "12                      -31          NaN  \n",
       "13                      -22          NaN  \n",
       "14                     -185          NaN  \n",
       "15                    -2601          NaN  \n",
       "16                     -984          NaN  \n",
       "17                       -4          NaN  \n",
       "18                       -7          NaN  \n",
       "19                      -71          NaN  \n",
       "20                      -22          NaN  \n",
       "21                     -694          NaN  \n",
       "22                     -210          NaN  \n",
       "23                      -24          NaN  \n",
       "24                    -2559          NaN  \n",
       "25                     -343          NaN  \n",
       "26                      -32          NaN  \n",
       "27                    -1023          NaN  \n",
       "28                    -2345          NaN  \n",
       "29                     -480          NaN  \n",
       "...                     ...          ...  \n",
       "1716398                -824          NaN  \n",
       "1716399                 -42          NaN  \n",
       "1716400                 -70          NaN  \n",
       "1716401               -1984          NaN  \n",
       "1716402               -1532          NaN  \n",
       "1716403                -126          NaN  \n",
       "1716404                  -7          NaN  \n",
       "1716405               -2082          NaN  \n",
       "1716406               -2363          NaN  \n",
       "1716407               -1248          NaN  \n",
       "1716408                -336          NaN  \n",
       "1716409                -582          NaN  \n",
       "1716410                 -46          NaN  \n",
       "1716411                -545          NaN  \n",
       "1716412                 -11          NaN  \n",
       "1716413                 -33          NaN  \n",
       "1716414               -1320          NaN  \n",
       "1716415               -1577          NaN  \n",
       "1716416                -720          NaN  \n",
       "1716417                -433          NaN  \n",
       "1716418               -1299          NaN  \n",
       "1716419               -1625          NaN  \n",
       "1716420                 -18          NaN  \n",
       "1716421               -1139          NaN  \n",
       "1716422                -109          NaN  \n",
       "1716423                 -19          NaN  \n",
       "1716424               -2493          NaN  \n",
       "1716425                -967          NaN  \n",
       "1716426               -1508          NaN  \n",
       "1716427                -387          NaN  \n",
       "\n",
       "[1716428 rows x 15 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['CREDIT_ACTIVE'] =df['CREDIT_ACTIVE'].astype('category').cat.codes\n",
    "df['CREDIT_CURRENCY'] =df['CREDIT_CURRENCY'].astype('category').cat.codes\n",
    "df['CREDIT_TYPE'] =df['CREDIT_TYPE'].astype('category').cat.codes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>CREDIT_ACTIVE</th>\n",
       "      <th>CREDIT_CURRENCY</th>\n",
       "      <th>DAYS_CREDIT</th>\n",
       "      <th>CREDIT_DAY_OVERDUE</th>\n",
       "      <th>DAYS_CREDIT_ENDDATE</th>\n",
       "      <th>DAYS_ENDDATE_FACT</th>\n",
       "      <th>AMT_CREDIT_MAX_OVERDUE</th>\n",
       "      <th>CNT_CREDIT_PROLONG</th>\n",
       "      <th>AMT_CREDIT_SUM</th>\n",
       "      <th>AMT_CREDIT_SUM_DEBT</th>\n",
       "      <th>AMT_CREDIT_SUM_LIMIT</th>\n",
       "      <th>AMT_CREDIT_SUM_OVERDUE</th>\n",
       "      <th>CREDIT_TYPE</th>\n",
       "      <th>DAYS_CREDIT_UPDATE</th>\n",
       "      <th>AMT_ANNUITY</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-497</td>\n",
       "      <td>0</td>\n",
       "      <td>-153.0</td>\n",
       "      <td>-153.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>91323.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-131</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-208</td>\n",
       "      <td>0</td>\n",
       "      <td>1075.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>225000.000</td>\n",
       "      <td>171342.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4</td>\n",
       "      <td>-20</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-203</td>\n",
       "      <td>0</td>\n",
       "      <td>528.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>464323.500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-16</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-203</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>90000.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4</td>\n",
       "      <td>-16</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-629</td>\n",
       "      <td>0</td>\n",
       "      <td>1197.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>77674.500</td>\n",
       "      <td>0</td>\n",
       "      <td>2700000.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-21</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-273</td>\n",
       "      <td>0</td>\n",
       "      <td>27460.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>180000.000</td>\n",
       "      <td>71017.380</td>\n",
       "      <td>108982.620</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4</td>\n",
       "      <td>-31</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-43</td>\n",
       "      <td>0</td>\n",
       "      <td>79.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>42103.800</td>\n",
       "      <td>42103.800</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-22</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-1896</td>\n",
       "      <td>0</td>\n",
       "      <td>-1684.0</td>\n",
       "      <td>-1710.0</td>\n",
       "      <td>14985.000</td>\n",
       "      <td>0</td>\n",
       "      <td>76878.450</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-1710</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-1146</td>\n",
       "      <td>0</td>\n",
       "      <td>-811.0</td>\n",
       "      <td>-840.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>103007.700</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-840</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-1146</td>\n",
       "      <td>0</td>\n",
       "      <td>-484.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>4500.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4</td>\n",
       "      <td>-690</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-1146</td>\n",
       "      <td>0</td>\n",
       "      <td>-180.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>337500.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4</td>\n",
       "      <td>-690</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-2456</td>\n",
       "      <td>0</td>\n",
       "      <td>-629.0</td>\n",
       "      <td>-825.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>675000.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-706</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-277</td>\n",
       "      <td>0</td>\n",
       "      <td>5261.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>7033500.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>12</td>\n",
       "      <td>-31</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-96</td>\n",
       "      <td>0</td>\n",
       "      <td>269.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>89910.000</td>\n",
       "      <td>76905.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-22</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-318</td>\n",
       "      <td>0</td>\n",
       "      <td>-187.0</td>\n",
       "      <td>-187.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4</td>\n",
       "      <td>-185</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-2911</td>\n",
       "      <td>0</td>\n",
       "      <td>-2607.0</td>\n",
       "      <td>-2604.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>48555.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-2601</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-2148</td>\n",
       "      <td>0</td>\n",
       "      <td>-1595.0</td>\n",
       "      <td>-987.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>135000.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-984</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-381</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>450000.000</td>\n",
       "      <td>520920.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-4</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-95</td>\n",
       "      <td>0</td>\n",
       "      <td>1720.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>67500.000</td>\n",
       "      <td>8131.500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4</td>\n",
       "      <td>-7</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-444</td>\n",
       "      <td>0</td>\n",
       "      <td>-77.0</td>\n",
       "      <td>-77.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>107184.060</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-71</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-392</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>252000.000</td>\n",
       "      <td>23679.000</td>\n",
       "      <td>228320.100</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4</td>\n",
       "      <td>-22</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-784</td>\n",
       "      <td>0</td>\n",
       "      <td>1008.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-411.615</td>\n",
       "      <td>411.615</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4</td>\n",
       "      <td>-694</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-774</td>\n",
       "      <td>0</td>\n",
       "      <td>625.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>127840.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4</td>\n",
       "      <td>-210</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-395</td>\n",
       "      <td>0</td>\n",
       "      <td>1431.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>1350000.000</td>\n",
       "      <td>1185493.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-24</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-2744</td>\n",
       "      <td>0</td>\n",
       "      <td>-2561.0</td>\n",
       "      <td>-2559.0</td>\n",
       "      <td>310.500</td>\n",
       "      <td>0</td>\n",
       "      <td>18157.500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-2559</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-1103</td>\n",
       "      <td>0</td>\n",
       "      <td>-7.0</td>\n",
       "      <td>-343.0</td>\n",
       "      <td>20493.270</td>\n",
       "      <td>0</td>\n",
       "      <td>675000.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-343</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-315</td>\n",
       "      <td>0</td>\n",
       "      <td>1512.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>88821.000</td>\n",
       "      <td>0</td>\n",
       "      <td>3709552.500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>-32</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-1331</td>\n",
       "      <td>0</td>\n",
       "      <td>-994.0</td>\n",
       "      <td>-1023.0</td>\n",
       "      <td>1350.000</td>\n",
       "      <td>0</td>\n",
       "      <td>39433.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-1023</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-2534</td>\n",
       "      <td>0</td>\n",
       "      <td>-2352.0</td>\n",
       "      <td>-2347.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>38830.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-2345</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-845</td>\n",
       "      <td>0</td>\n",
       "      <td>-480.0</td>\n",
       "      <td>-480.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>67500.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-480</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716398</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-1529</td>\n",
       "      <td>0</td>\n",
       "      <td>-829.0</td>\n",
       "      <td>-829.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>209898.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-824</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716399</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-613</td>\n",
       "      <td>0</td>\n",
       "      <td>721.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>972000.000</td>\n",
       "      <td>886297.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4</td>\n",
       "      <td>-42</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716400</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-815</td>\n",
       "      <td>0</td>\n",
       "      <td>1011.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>147150.000</td>\n",
       "      <td>105358.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-70</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716401</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-2333</td>\n",
       "      <td>0</td>\n",
       "      <td>-2027.0</td>\n",
       "      <td>-1984.0</td>\n",
       "      <td>173.070</td>\n",
       "      <td>0</td>\n",
       "      <td>35032.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-1984</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716402</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-1714</td>\n",
       "      <td>0</td>\n",
       "      <td>-1530.0</td>\n",
       "      <td>-1564.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>35271.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-1532</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716403</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-765</td>\n",
       "      <td>0</td>\n",
       "      <td>1061.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>1431000.000</td>\n",
       "      <td>1092226.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-126</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716404</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-99</td>\n",
       "      <td>0</td>\n",
       "      <td>997.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>450000.000</td>\n",
       "      <td>432787.500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-7</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716405</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-2390</td>\n",
       "      <td>0</td>\n",
       "      <td>-2053.0</td>\n",
       "      <td>-2082.0</td>\n",
       "      <td>11317.590</td>\n",
       "      <td>0</td>\n",
       "      <td>112204.350</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-2082</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716406</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-2517</td>\n",
       "      <td>0</td>\n",
       "      <td>-660.0</td>\n",
       "      <td>-2363.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>473940.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>-2363</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716407</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-1990</td>\n",
       "      <td>0</td>\n",
       "      <td>-1244.0</td>\n",
       "      <td>-1248.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>90000.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-1248</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716408</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-434</td>\n",
       "      <td>0</td>\n",
       "      <td>-344.0</td>\n",
       "      <td>-344.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>234000.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4</td>\n",
       "      <td>-336</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716409</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-1705</td>\n",
       "      <td>0</td>\n",
       "      <td>-582.0</td>\n",
       "      <td>-582.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4</td>\n",
       "      <td>-582</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716410</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-575</td>\n",
       "      <td>0</td>\n",
       "      <td>813.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>67500.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4</td>\n",
       "      <td>-46</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716411</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-821</td>\n",
       "      <td>0</td>\n",
       "      <td>-425.0</td>\n",
       "      <td>-545.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>108765.720</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-545</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716412</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-541</td>\n",
       "      <td>0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>225000.000</td>\n",
       "      <td>10971.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-11</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716413</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-463</td>\n",
       "      <td>0</td>\n",
       "      <td>-36.0</td>\n",
       "      <td>-36.0</td>\n",
       "      <td>6863.715</td>\n",
       "      <td>0</td>\n",
       "      <td>110878.470</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-33</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716414</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-1628</td>\n",
       "      <td>0</td>\n",
       "      <td>-1320.0</td>\n",
       "      <td>-1320.0</td>\n",
       "      <td>5693.625</td>\n",
       "      <td>0</td>\n",
       "      <td>57834.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-1320</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716415</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-1970</td>\n",
       "      <td>0</td>\n",
       "      <td>-1577.0</td>\n",
       "      <td>-1577.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>93955.500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-1577</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716416</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-1100</td>\n",
       "      <td>0</td>\n",
       "      <td>-732.0</td>\n",
       "      <td>-731.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>98775.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-720</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716417</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-740</td>\n",
       "      <td>0</td>\n",
       "      <td>31128.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>67500.000</td>\n",
       "      <td>2466.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4</td>\n",
       "      <td>-433</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716418</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-1389</td>\n",
       "      <td>0</td>\n",
       "      <td>-1299.0</td>\n",
       "      <td>-1299.0</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>334158.435</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-1299</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716419</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-1808</td>\n",
       "      <td>0</td>\n",
       "      <td>-1596.0</td>\n",
       "      <td>-1625.0</td>\n",
       "      <td>8100.000</td>\n",
       "      <td>0</td>\n",
       "      <td>28248.840</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-1625</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716420</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-99</td>\n",
       "      <td>0</td>\n",
       "      <td>-83.0</td>\n",
       "      <td>-98.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>27000.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-18</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716421</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-1335</td>\n",
       "      <td>0</td>\n",
       "      <td>-1152.0</td>\n",
       "      <td>-1152.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>195408.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-1139</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716422</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-2648</td>\n",
       "      <td>0</td>\n",
       "      <td>31129.0</td>\n",
       "      <td>-189.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>202500.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4</td>\n",
       "      <td>-109</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716423</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-44</td>\n",
       "      <td>0</td>\n",
       "      <td>-30.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0</td>\n",
       "      <td>11250.000</td>\n",
       "      <td>11250.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10</td>\n",
       "      <td>-19</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716424</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-2648</td>\n",
       "      <td>0</td>\n",
       "      <td>-2433.0</td>\n",
       "      <td>-2493.0</td>\n",
       "      <td>5476.500</td>\n",
       "      <td>0</td>\n",
       "      <td>38130.840</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-2493</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716425</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-1809</td>\n",
       "      <td>0</td>\n",
       "      <td>-1628.0</td>\n",
       "      <td>-970.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>15570.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-967</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716426</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-1878</td>\n",
       "      <td>0</td>\n",
       "      <td>-1513.0</td>\n",
       "      <td>-1513.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>36000.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>-1508</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1716427</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>-463</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>-387.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>22500.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10</td>\n",
       "      <td>-387</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1716428 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         CREDIT_ACTIVE  CREDIT_CURRENCY  DAYS_CREDIT  CREDIT_DAY_OVERDUE  \\\n",
       "0                    2                0         -497                   0   \n",
       "1                    0                0         -208                   0   \n",
       "2                    0                0         -203                   0   \n",
       "3                    0                0         -203                   0   \n",
       "4                    0                0         -629                   0   \n",
       "5                    0                0         -273                   0   \n",
       "6                    0                0          -43                   0   \n",
       "7                    2                0        -1896                   0   \n",
       "8                    2                0        -1146                   0   \n",
       "9                    0                0        -1146                   0   \n",
       "10                   0                0        -1146                   0   \n",
       "11                   2                0        -2456                   0   \n",
       "12                   0                0         -277                   0   \n",
       "13                   0                0          -96                   0   \n",
       "14                   2                0         -318                   0   \n",
       "15                   2                0        -2911                   0   \n",
       "16                   2                0        -2148                   0   \n",
       "17                   0                0         -381                   0   \n",
       "18                   0                0          -95                   0   \n",
       "19                   2                0         -444                   0   \n",
       "20                   0                0         -392                   0   \n",
       "21                   0                0         -784                   0   \n",
       "22                   0                0         -774                   0   \n",
       "23                   0                0         -395                   0   \n",
       "24                   2                0        -2744                   0   \n",
       "25                   2                0        -1103                   0   \n",
       "26                   0                0         -315                   0   \n",
       "27                   2                0        -1331                   0   \n",
       "28                   2                0        -2534                   0   \n",
       "29                   2                0         -845                   0   \n",
       "...                ...              ...          ...                 ...   \n",
       "1716398              2                0        -1529                   0   \n",
       "1716399              0                0         -613                   0   \n",
       "1716400              0                0         -815                   0   \n",
       "1716401              2                0        -2333                   0   \n",
       "1716402              2                0        -1714                   0   \n",
       "1716403              0                0         -765                   0   \n",
       "1716404              0                0          -99                   0   \n",
       "1716405              2                0        -2390                   0   \n",
       "1716406              2                0        -2517                   0   \n",
       "1716407              2                0        -1990                   0   \n",
       "1716408              2                0         -434                   0   \n",
       "1716409              2                0        -1705                   0   \n",
       "1716410              0                0         -575                   0   \n",
       "1716411              2                0         -821                   0   \n",
       "1716412              0                0         -541                   0   \n",
       "1716413              2                0         -463                   0   \n",
       "1716414              2                0        -1628                   0   \n",
       "1716415              2                0        -1970                   0   \n",
       "1716416              2                0        -1100                   0   \n",
       "1716417              0                0         -740                   0   \n",
       "1716418              2                0        -1389                   0   \n",
       "1716419              2                0        -1808                   0   \n",
       "1716420              2                0          -99                   0   \n",
       "1716421              2                0        -1335                   0   \n",
       "1716422              2                0        -2648                   0   \n",
       "1716423              0                0          -44                   0   \n",
       "1716424              2                0        -2648                   0   \n",
       "1716425              2                0        -1809                   0   \n",
       "1716426              2                0        -1878                   0   \n",
       "1716427              2                0         -463                   0   \n",
       "\n",
       "         DAYS_CREDIT_ENDDATE  DAYS_ENDDATE_FACT  AMT_CREDIT_MAX_OVERDUE  \\\n",
       "0                     -153.0             -153.0                     NaN   \n",
       "1                     1075.0                NaN                     NaN   \n",
       "2                      528.0                NaN                     NaN   \n",
       "3                        NaN                NaN                     NaN   \n",
       "4                     1197.0                NaN               77674.500   \n",
       "5                    27460.0                NaN                   0.000   \n",
       "6                       79.0                NaN                   0.000   \n",
       "7                    -1684.0            -1710.0               14985.000   \n",
       "8                     -811.0             -840.0                   0.000   \n",
       "9                     -484.0                NaN                   0.000   \n",
       "10                    -180.0                NaN                   0.000   \n",
       "11                    -629.0             -825.0                     NaN   \n",
       "12                    5261.0                NaN                   0.000   \n",
       "13                     269.0                NaN                   0.000   \n",
       "14                    -187.0             -187.0                     NaN   \n",
       "15                   -2607.0            -2604.0                     NaN   \n",
       "16                   -1595.0             -987.0                     NaN   \n",
       "17                       NaN                NaN                     NaN   \n",
       "18                    1720.0                NaN                     NaN   \n",
       "19                     -77.0              -77.0                   0.000   \n",
       "20                       NaN                NaN                   0.000   \n",
       "21                    1008.0                NaN                   0.000   \n",
       "22                     625.0                NaN                     NaN   \n",
       "23                    1431.0                NaN                     NaN   \n",
       "24                   -2561.0            -2559.0                 310.500   \n",
       "25                      -7.0             -343.0               20493.270   \n",
       "26                    1512.0                NaN               88821.000   \n",
       "27                    -994.0            -1023.0                1350.000   \n",
       "28                   -2352.0            -2347.0                     NaN   \n",
       "29                    -480.0             -480.0                   0.000   \n",
       "...                      ...                ...                     ...   \n",
       "1716398               -829.0             -829.0                     NaN   \n",
       "1716399                721.0                NaN                     NaN   \n",
       "1716400               1011.0                NaN                     NaN   \n",
       "1716401              -2027.0            -1984.0                 173.070   \n",
       "1716402              -1530.0            -1564.0                     NaN   \n",
       "1716403               1061.0                NaN                     NaN   \n",
       "1716404                997.0                NaN                   0.000   \n",
       "1716405              -2053.0            -2082.0               11317.590   \n",
       "1716406               -660.0            -2363.0                   0.000   \n",
       "1716407              -1244.0            -1248.0                     NaN   \n",
       "1716408               -344.0             -344.0                     NaN   \n",
       "1716409               -582.0             -582.0                   0.000   \n",
       "1716410                813.0                NaN                     NaN   \n",
       "1716411               -425.0             -545.0                   0.000   \n",
       "1716412                  7.0                NaN                     NaN   \n",
       "1716413                -36.0              -36.0                6863.715   \n",
       "1716414              -1320.0            -1320.0                5693.625   \n",
       "1716415              -1577.0            -1577.0                     NaN   \n",
       "1716416               -732.0             -731.0                     NaN   \n",
       "1716417              31128.0                NaN                     NaN   \n",
       "1716418              -1299.0            -1299.0                   0.000   \n",
       "1716419              -1596.0            -1625.0                8100.000   \n",
       "1716420                -83.0              -98.0                     NaN   \n",
       "1716421              -1152.0            -1152.0                     NaN   \n",
       "1716422              31129.0             -189.0                     NaN   \n",
       "1716423                -30.0                NaN                   0.000   \n",
       "1716424              -2433.0            -2493.0                5476.500   \n",
       "1716425              -1628.0             -970.0                     NaN   \n",
       "1716426              -1513.0            -1513.0                     NaN   \n",
       "1716427                  NaN             -387.0                     NaN   \n",
       "\n",
       "         CNT_CREDIT_PROLONG  AMT_CREDIT_SUM  AMT_CREDIT_SUM_DEBT  \\\n",
       "0                         0       91323.000                0.000   \n",
       "1                         0      225000.000           171342.000   \n",
       "2                         0      464323.500                  NaN   \n",
       "3                         0       90000.000                  NaN   \n",
       "4                         0     2700000.000                  NaN   \n",
       "5                         0      180000.000            71017.380   \n",
       "6                         0       42103.800            42103.800   \n",
       "7                         0       76878.450                0.000   \n",
       "8                         0      103007.700                0.000   \n",
       "9                         0        4500.000                0.000   \n",
       "10                        0      337500.000                0.000   \n",
       "11                        0      675000.000                0.000   \n",
       "12                        0     7033500.000                  NaN   \n",
       "13                        0       89910.000            76905.000   \n",
       "14                        0           0.000                0.000   \n",
       "15                        0       48555.000                  NaN   \n",
       "16                        0      135000.000                  NaN   \n",
       "17                        0      450000.000           520920.000   \n",
       "18                        0       67500.000             8131.500   \n",
       "19                        0      107184.060                0.000   \n",
       "20                        0      252000.000            23679.000   \n",
       "21                        0           0.000             -411.615   \n",
       "22                        0      127840.500                0.000   \n",
       "23                        0     1350000.000          1185493.500   \n",
       "24                        0       18157.500                  NaN   \n",
       "25                        0      675000.000                0.000   \n",
       "26                        0     3709552.500                  NaN   \n",
       "27                        0       39433.500                0.000   \n",
       "28                        0       38830.500                0.000   \n",
       "29                        0       67500.000                0.000   \n",
       "...                     ...             ...                  ...   \n",
       "1716398                   0      209898.000                0.000   \n",
       "1716399                   0      972000.000           886297.500   \n",
       "1716400                   0      147150.000           105358.500   \n",
       "1716401                   0       35032.500                0.000   \n",
       "1716402                   0       35271.000                0.000   \n",
       "1716403                   0     1431000.000          1092226.500   \n",
       "1716404                   0      450000.000           432787.500   \n",
       "1716405                   0      112204.350                0.000   \n",
       "1716406                   0      473940.000                0.000   \n",
       "1716407                   0       90000.000                  NaN   \n",
       "1716408                   0      234000.000                0.000   \n",
       "1716409                   0           0.000                0.000   \n",
       "1716410                   0       67500.000                0.000   \n",
       "1716411                   0      108765.720                0.000   \n",
       "1716412                   0      225000.000            10971.000   \n",
       "1716413                   0      110878.470                0.000   \n",
       "1716414                   0       57834.000                0.000   \n",
       "1716415                   0       93955.500                  NaN   \n",
       "1716416                   0       98775.000                0.000   \n",
       "1716417                   0       67500.000             2466.000   \n",
       "1716418                   0      334158.435                0.000   \n",
       "1716419                   0       28248.840                0.000   \n",
       "1716420                   0       27000.000                0.000   \n",
       "1716421                   0      195408.000                0.000   \n",
       "1716422                   0      202500.000                0.000   \n",
       "1716423                   0       11250.000            11250.000   \n",
       "1716424                   0       38130.840                0.000   \n",
       "1716425                   0       15570.000                  NaN   \n",
       "1716426                   0       36000.000                0.000   \n",
       "1716427                   0       22500.000                0.000   \n",
       "\n",
       "         AMT_CREDIT_SUM_LIMIT  AMT_CREDIT_SUM_OVERDUE  CREDIT_TYPE  \\\n",
       "0                         NaN                     0.0            3   \n",
       "1                         NaN                     0.0            4   \n",
       "2                         NaN                     0.0            3   \n",
       "3                         NaN                     0.0            4   \n",
       "4                         NaN                     0.0            3   \n",
       "5                  108982.620                     0.0            4   \n",
       "6                       0.000                     0.0            3   \n",
       "7                       0.000                     0.0            3   \n",
       "8                       0.000                     0.0            3   \n",
       "9                       0.000                     0.0            4   \n",
       "10                      0.000                     0.0            4   \n",
       "11                      0.000                     0.0            3   \n",
       "12                        NaN                     0.0           12   \n",
       "13                      0.000                     0.0            3   \n",
       "14                      0.000                     0.0            4   \n",
       "15                        NaN                     0.0            3   \n",
       "16                        NaN                     0.0            3   \n",
       "17                        NaN                     0.0            3   \n",
       "18                        NaN                     0.0            4   \n",
       "19                      0.000                     0.0            3   \n",
       "20                 228320.100                     0.0            4   \n",
       "21                    411.615                     0.0            4   \n",
       "22                      0.000                     0.0            4   \n",
       "23                      0.000                     0.0            3   \n",
       "24                        NaN                     0.0            3   \n",
       "25                      0.000                     0.0            3   \n",
       "26                        NaN                     0.0            1   \n",
       "27                      0.000                     0.0            3   \n",
       "28                      0.000                     0.0            3   \n",
       "29                      0.000                     0.0            3   \n",
       "...                       ...                     ...          ...   \n",
       "1716398                   NaN                     0.0            3   \n",
       "1716399                 0.000                     0.0            4   \n",
       "1716400                 0.000                     0.0            3   \n",
       "1716401                 0.000                     0.0            3   \n",
       "1716402                 0.000                     0.0            3   \n",
       "1716403                 0.000                     0.0            3   \n",
       "1716404                 0.000                     0.0            3   \n",
       "1716405                 0.000                     0.0            3   \n",
       "1716406                 0.000                     0.0            1   \n",
       "1716407                   NaN                     0.0            3   \n",
       "1716408                   NaN                     0.0            4   \n",
       "1716409                 0.000                     0.0            4   \n",
       "1716410                 0.000                     0.0            4   \n",
       "1716411                 0.000                     0.0            3   \n",
       "1716412                 0.000                     0.0            3   \n",
       "1716413                 0.000                     0.0            3   \n",
       "1716414                 0.000                     0.0            3   \n",
       "1716415                   NaN                     0.0            3   \n",
       "1716416                 0.000                     0.0            3   \n",
       "1716417                   NaN                     0.0            4   \n",
       "1716418                 0.000                     0.0            3   \n",
       "1716419                 0.000                     0.0            3   \n",
       "1716420                 0.000                     0.0            3   \n",
       "1716421                   NaN                     0.0            3   \n",
       "1716422                   NaN                     0.0            4   \n",
       "1716423                 0.000                     0.0           10   \n",
       "1716424                 0.000                     0.0            3   \n",
       "1716425                   NaN                     0.0            3   \n",
       "1716426                 0.000                     0.0            3   \n",
       "1716427                   NaN                     0.0           10   \n",
       "\n",
       "         DAYS_CREDIT_UPDATE  AMT_ANNUITY  \n",
       "0                      -131          NaN  \n",
       "1                       -20          NaN  \n",
       "2                       -16          NaN  \n",
       "3                       -16          NaN  \n",
       "4                       -21          NaN  \n",
       "5                       -31          NaN  \n",
       "6                       -22          NaN  \n",
       "7                     -1710          NaN  \n",
       "8                      -840          NaN  \n",
       "9                      -690          NaN  \n",
       "10                     -690          NaN  \n",
       "11                     -706          NaN  \n",
       "12                      -31          NaN  \n",
       "13                      -22          NaN  \n",
       "14                     -185          NaN  \n",
       "15                    -2601          NaN  \n",
       "16                     -984          NaN  \n",
       "17                       -4          NaN  \n",
       "18                       -7          NaN  \n",
       "19                      -71          NaN  \n",
       "20                      -22          NaN  \n",
       "21                     -694          NaN  \n",
       "22                     -210          NaN  \n",
       "23                      -24          NaN  \n",
       "24                    -2559          NaN  \n",
       "25                     -343          NaN  \n",
       "26                      -32          NaN  \n",
       "27                    -1023          NaN  \n",
       "28                    -2345          NaN  \n",
       "29                     -480          NaN  \n",
       "...                     ...          ...  \n",
       "1716398                -824          NaN  \n",
       "1716399                 -42          NaN  \n",
       "1716400                 -70          NaN  \n",
       "1716401               -1984          NaN  \n",
       "1716402               -1532          NaN  \n",
       "1716403                -126          NaN  \n",
       "1716404                  -7          NaN  \n",
       "1716405               -2082          NaN  \n",
       "1716406               -2363          NaN  \n",
       "1716407               -1248          NaN  \n",
       "1716408                -336          NaN  \n",
       "1716409                -582          NaN  \n",
       "1716410                 -46          NaN  \n",
       "1716411                -545          NaN  \n",
       "1716412                 -11          NaN  \n",
       "1716413                 -33          NaN  \n",
       "1716414               -1320          NaN  \n",
       "1716415               -1577          NaN  \n",
       "1716416                -720          NaN  \n",
       "1716417                -433          NaN  \n",
       "1716418               -1299          NaN  \n",
       "1716419               -1625          NaN  \n",
       "1716420                 -18          NaN  \n",
       "1716421               -1139          NaN  \n",
       "1716422                -109          NaN  \n",
       "1716423                 -19          NaN  \n",
       "1716424               -2493          NaN  \n",
       "1716425                -967          NaN  \n",
       "1716426               -1508          NaN  \n",
       "1716427                -387          NaN  \n",
       "\n",
       "[1716428 rows x 15 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "CREDIT_CURRENCY           0.100223\n",
       "DAYS_CREDIT               0.050883\n",
       "CREDIT_DAY_OVERDUE       -0.003292\n",
       "DAYS_CREDIT_ENDDATE       0.055424\n",
       "DAYS_ENDDATE_FACT         0.059096\n",
       "AMT_CREDIT_MAX_OVERDUE    0.081663\n",
       "CNT_CREDIT_PROLONG       -0.008345\n",
       "AMT_CREDIT_SUM            1.000000\n",
       "AMT_CREDIT_SUM_DEBT       0.683419\n",
       "AMT_CREDIT_SUM_LIMIT      0.003756\n",
       "AMT_CREDIT_SUM_OVERDUE    0.006342\n",
       "CREDIT_TYPE               0.286320\n",
       "DAYS_CREDIT_UPDATE        0.104629\n",
       "AMT_ANNUITY               0.049146\n",
       "Name: AMT_CREDIT_SUM, dtype: float64"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df.columns[1:]].corr()['AMT_CREDIT_SUM'][:]"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}