{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-08-25T09:22:08.115371Z",
     "start_time": "2018-08-25T09:22:07.879366Z"
    }
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from IPython.display import display\n",
    "pd.set_option('display.max_columns', 99)\n",
    "pd.set_option('display.max_rows', 200)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-08-25T09:22:08.121251Z",
     "start_time": "2018-08-25T09:22:08.117121Z"
    }
   },
   "outputs": [],
   "source": [
    "date_feature = [\n",
    "                'DAYS_BIRTH',\n",
    "                'DAYS_REGISTRATION',\n",
    "                'DAYS_ID_PUBLISH',\n",
    "                'DAYS_EMPLOYED'\n",
    "                ]\n",
    "\n",
    "other_feature = [\n",
    "                'CODE_GENDER',\n",
    "                'NAME_EDUCATION_TYPE',\n",
    "                'NAME_FAMILY_STATUS',\n",
    "                'NAME_HOUSING_TYPE'\n",
    "                ]\n",
    "\n",
    "keys = date_feature + other_feature\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-08-25T09:22:08.630159Z",
     "start_time": "2018-08-25T09:22:08.219085Z"
    }
   },
   "outputs": [],
   "source": [
    "test  = pd.read_csv('../input/application_test.csv.zip',\n",
    "                    usecols=['SK_ID_CURR']+keys)\n",
    "\n",
    "\n",
    "# new key\n",
    "test['DAYS_BIRTH-m-DAYS_REGISTRATION'] = test['DAYS_BIRTH'] - test['DAYS_REGISTRATION']\n",
    "test['DAYS_REGISTRATION-m-DAYS_ID_PUBLISH']   = test['DAYS_REGISTRATION'] - test['DAYS_ID_PUBLISH']\n",
    "test['DAYS_ID_PUBLISH-m-DAYS_EMPLOYED']   = test['DAYS_ID_PUBLISH'] - test['DAYS_EMPLOYED']\n",
    "\n",
    "keys2 = ['DAYS_BIRTH-m-DAYS_REGISTRATION', 'DAYS_REGISTRATION-m-DAYS_ID_PUBLISH',\n",
    "         'DAYS_ID_PUBLISH-m-DAYS_EMPLOYED'] + other_feature\n",
    "\n",
    "tmp = test[test.duplicated(keys2, False)].sort_values(keys2)\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# duplicated user"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-08-25T09:22:08.654665Z",
     "start_time": "2018-08-25T09:22:08.632294Z"
    }
   },
   "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>SK_ID_CURR</th>\n",
       "      <th>CODE_GENDER</th>\n",
       "      <th>NAME_EDUCATION_TYPE</th>\n",
       "      <th>NAME_FAMILY_STATUS</th>\n",
       "      <th>NAME_HOUSING_TYPE</th>\n",
       "      <th>DAYS_BIRTH</th>\n",
       "      <th>DAYS_EMPLOYED</th>\n",
       "      <th>DAYS_REGISTRATION</th>\n",
       "      <th>DAYS_ID_PUBLISH</th>\n",
       "      <th>DAYS_BIRTH-m-DAYS_REGISTRATION</th>\n",
       "      <th>DAYS_REGISTRATION-m-DAYS_ID_PUBLISH</th>\n",
       "      <th>DAYS_ID_PUBLISH-m-DAYS_EMPLOYED</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>41228</th>\n",
       "      <td>402926</td>\n",
       "      <td>F</td>\n",
       "      <td>Secondary / secondary special</td>\n",
       "      <td>Married</td>\n",
       "      <td>House / apartment</td>\n",
       "      <td>-12588</td>\n",
       "      <td>-1504</td>\n",
       "      <td>-1998.0</td>\n",
       "      <td>-4943</td>\n",
       "      <td>-10590.0</td>\n",
       "      <td>2945.0</td>\n",
       "      <td>-3439</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44778</th>\n",
       "      <td>427665</td>\n",
       "      <td>F</td>\n",
       "      <td>Secondary / secondary special</td>\n",
       "      <td>Married</td>\n",
       "      <td>House / apartment</td>\n",
       "      <td>-12620</td>\n",
       "      <td>-1536</td>\n",
       "      <td>-2030.0</td>\n",
       "      <td>-4975</td>\n",
       "      <td>-10590.0</td>\n",
       "      <td>2945.0</td>\n",
       "      <td>-3439</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24419</th>\n",
       "      <td>277874</td>\n",
       "      <td>M</td>\n",
       "      <td>Incomplete higher</td>\n",
       "      <td>Married</td>\n",
       "      <td>House / apartment</td>\n",
       "      <td>-11275</td>\n",
       "      <td>-1100</td>\n",
       "      <td>-1519.0</td>\n",
       "      <td>-3575</td>\n",
       "      <td>-9756.0</td>\n",
       "      <td>2056.0</td>\n",
       "      <td>-2475</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33319</th>\n",
       "      <td>342870</td>\n",
       "      <td>M</td>\n",
       "      <td>Incomplete higher</td>\n",
       "      <td>Married</td>\n",
       "      <td>House / apartment</td>\n",
       "      <td>-11324</td>\n",
       "      <td>-1149</td>\n",
       "      <td>-1568.0</td>\n",
       "      <td>-3624</td>\n",
       "      <td>-9756.0</td>\n",
       "      <td>2056.0</td>\n",
       "      <td>-2475</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11836</th>\n",
       "      <td>185981</td>\n",
       "      <td>M</td>\n",
       "      <td>Secondary / secondary special</td>\n",
       "      <td>Married</td>\n",
       "      <td>House / apartment</td>\n",
       "      <td>-16256</td>\n",
       "      <td>-4127</td>\n",
       "      <td>-7196.0</td>\n",
       "      <td>-4461</td>\n",
       "      <td>-9060.0</td>\n",
       "      <td>-2735.0</td>\n",
       "      <td>-334</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23895</th>\n",
       "      <td>273946</td>\n",
       "      <td>M</td>\n",
       "      <td>Secondary / secondary special</td>\n",
       "      <td>Married</td>\n",
       "      <td>House / apartment</td>\n",
       "      <td>-16239</td>\n",
       "      <td>-4110</td>\n",
       "      <td>-7179.0</td>\n",
       "      <td>-4444</td>\n",
       "      <td>-9060.0</td>\n",
       "      <td>-2735.0</td>\n",
       "      <td>-334</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       SK_ID_CURR CODE_GENDER            NAME_EDUCATION_TYPE  \\\n",
       "41228      402926           F  Secondary / secondary special   \n",
       "44778      427665           F  Secondary / secondary special   \n",
       "24419      277874           M              Incomplete higher   \n",
       "33319      342870           M              Incomplete higher   \n",
       "11836      185981           M  Secondary / secondary special   \n",
       "23895      273946           M  Secondary / secondary special   \n",
       "\n",
       "      NAME_FAMILY_STATUS  NAME_HOUSING_TYPE  DAYS_BIRTH  DAYS_EMPLOYED  \\\n",
       "41228            Married  House / apartment      -12588          -1504   \n",
       "44778            Married  House / apartment      -12620          -1536   \n",
       "24419            Married  House / apartment      -11275          -1100   \n",
       "33319            Married  House / apartment      -11324          -1149   \n",
       "11836            Married  House / apartment      -16256          -4127   \n",
       "23895            Married  House / apartment      -16239          -4110   \n",
       "\n",
       "       DAYS_REGISTRATION  DAYS_ID_PUBLISH  DAYS_BIRTH-m-DAYS_REGISTRATION  \\\n",
       "41228            -1998.0            -4943                        -10590.0   \n",
       "44778            -2030.0            -4975                        -10590.0   \n",
       "24419            -1519.0            -3575                         -9756.0   \n",
       "33319            -1568.0            -3624                         -9756.0   \n",
       "11836            -7196.0            -4461                         -9060.0   \n",
       "23895            -7179.0            -4444                         -9060.0   \n",
       "\n",
       "       DAYS_REGISTRATION-m-DAYS_ID_PUBLISH  DAYS_ID_PUBLISH-m-DAYS_EMPLOYED  \n",
       "41228                               2945.0                            -3439  \n",
       "44778                               2945.0                            -3439  \n",
       "24419                               2056.0                            -2475  \n",
       "33319                               2056.0                            -2475  \n",
       "11836                              -2735.0                             -334  \n",
       "23895                              -2735.0                             -334  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tmp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-08-25T09:22:08.658933Z",
     "start_time": "2018-08-25T09:22:08.656394Z"
    }
   },
   "outputs": [],
   "source": [
    "ix = tmp.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-08-25T09:22:09.910912Z",
     "start_time": "2018-08-25T09:22:09.059298Z"
    }
   },
   "outputs": [],
   "source": [
    "test  = pd.read_csv('../input/application_test.csv.zip')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# duplicated user( full columns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2018-08-25T09:22:10.018747Z",
     "start_time": "2018-08-25T09:22:09.938488Z"
    }
   },
   "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>SK_ID_CURR</th>\n",
       "      <th>NAME_CONTRACT_TYPE</th>\n",
       "      <th>CODE_GENDER</th>\n",
       "      <th>FLAG_OWN_CAR</th>\n",
       "      <th>FLAG_OWN_REALTY</th>\n",
       "      <th>CNT_CHILDREN</th>\n",
       "      <th>AMT_INCOME_TOTAL</th>\n",
       "      <th>AMT_CREDIT</th>\n",
       "      <th>AMT_ANNUITY</th>\n",
       "      <th>AMT_GOODS_PRICE</th>\n",
       "      <th>NAME_TYPE_SUITE</th>\n",
       "      <th>NAME_INCOME_TYPE</th>\n",
       "      <th>NAME_EDUCATION_TYPE</th>\n",
       "      <th>NAME_FAMILY_STATUS</th>\n",
       "      <th>NAME_HOUSING_TYPE</th>\n",
       "      <th>REGION_POPULATION_RELATIVE</th>\n",
       "      <th>DAYS_BIRTH</th>\n",
       "      <th>DAYS_EMPLOYED</th>\n",
       "      <th>DAYS_REGISTRATION</th>\n",
       "      <th>DAYS_ID_PUBLISH</th>\n",
       "      <th>OWN_CAR_AGE</th>\n",
       "      <th>FLAG_MOBIL</th>\n",
       "      <th>FLAG_EMP_PHONE</th>\n",
       "      <th>FLAG_WORK_PHONE</th>\n",
       "      <th>FLAG_CONT_MOBILE</th>\n",
       "      <th>FLAG_PHONE</th>\n",
       "      <th>FLAG_EMAIL</th>\n",
       "      <th>OCCUPATION_TYPE</th>\n",
       "      <th>CNT_FAM_MEMBERS</th>\n",
       "      <th>REGION_RATING_CLIENT</th>\n",
       "      <th>REGION_RATING_CLIENT_W_CITY</th>\n",
       "      <th>WEEKDAY_APPR_PROCESS_START</th>\n",
       "      <th>HOUR_APPR_PROCESS_START</th>\n",
       "      <th>REG_REGION_NOT_LIVE_REGION</th>\n",
       "      <th>REG_REGION_NOT_WORK_REGION</th>\n",
       "      <th>LIVE_REGION_NOT_WORK_REGION</th>\n",
       "      <th>REG_CITY_NOT_LIVE_CITY</th>\n",
       "      <th>REG_CITY_NOT_WORK_CITY</th>\n",
       "      <th>LIVE_CITY_NOT_WORK_CITY</th>\n",
       "      <th>ORGANIZATION_TYPE</th>\n",
       "      <th>EXT_SOURCE_1</th>\n",
       "      <th>EXT_SOURCE_2</th>\n",
       "      <th>EXT_SOURCE_3</th>\n",
       "      <th>APARTMENTS_AVG</th>\n",
       "      <th>BASEMENTAREA_AVG</th>\n",
       "      <th>YEARS_BEGINEXPLUATATION_AVG</th>\n",
       "      <th>YEARS_BUILD_AVG</th>\n",
       "      <th>COMMONAREA_AVG</th>\n",
       "      <th>ELEVATORS_AVG</th>\n",
       "      <th>...</th>\n",
       "      <th>BASEMENTAREA_MEDI</th>\n",
       "      <th>YEARS_BEGINEXPLUATATION_MEDI</th>\n",
       "      <th>YEARS_BUILD_MEDI</th>\n",
       "      <th>COMMONAREA_MEDI</th>\n",
       "      <th>ELEVATORS_MEDI</th>\n",
       "      <th>ENTRANCES_MEDI</th>\n",
       "      <th>FLOORSMAX_MEDI</th>\n",
       "      <th>FLOORSMIN_MEDI</th>\n",
       "      <th>LANDAREA_MEDI</th>\n",
       "      <th>LIVINGAPARTMENTS_MEDI</th>\n",
       "      <th>LIVINGAREA_MEDI</th>\n",
       "      <th>NONLIVINGAPARTMENTS_MEDI</th>\n",
       "      <th>NONLIVINGAREA_MEDI</th>\n",
       "      <th>FONDKAPREMONT_MODE</th>\n",
       "      <th>HOUSETYPE_MODE</th>\n",
       "      <th>TOTALAREA_MODE</th>\n",
       "      <th>WALLSMATERIAL_MODE</th>\n",
       "      <th>EMERGENCYSTATE_MODE</th>\n",
       "      <th>OBS_30_CNT_SOCIAL_CIRCLE</th>\n",
       "      <th>DEF_30_CNT_SOCIAL_CIRCLE</th>\n",
       "      <th>OBS_60_CNT_SOCIAL_CIRCLE</th>\n",
       "      <th>DEF_60_CNT_SOCIAL_CIRCLE</th>\n",
       "      <th>DAYS_LAST_PHONE_CHANGE</th>\n",
       "      <th>FLAG_DOCUMENT_2</th>\n",
       "      <th>FLAG_DOCUMENT_3</th>\n",
       "      <th>FLAG_DOCUMENT_4</th>\n",
       "      <th>FLAG_DOCUMENT_5</th>\n",
       "      <th>FLAG_DOCUMENT_6</th>\n",
       "      <th>FLAG_DOCUMENT_7</th>\n",
       "      <th>FLAG_DOCUMENT_8</th>\n",
       "      <th>FLAG_DOCUMENT_9</th>\n",
       "      <th>FLAG_DOCUMENT_10</th>\n",
       "      <th>FLAG_DOCUMENT_11</th>\n",
       "      <th>FLAG_DOCUMENT_12</th>\n",
       "      <th>FLAG_DOCUMENT_13</th>\n",
       "      <th>FLAG_DOCUMENT_14</th>\n",
       "      <th>FLAG_DOCUMENT_15</th>\n",
       "      <th>FLAG_DOCUMENT_16</th>\n",
       "      <th>FLAG_DOCUMENT_17</th>\n",
       "      <th>FLAG_DOCUMENT_18</th>\n",
       "      <th>FLAG_DOCUMENT_19</th>\n",
       "      <th>FLAG_DOCUMENT_20</th>\n",
       "      <th>FLAG_DOCUMENT_21</th>\n",
       "      <th>AMT_REQ_CREDIT_BUREAU_HOUR</th>\n",
       "      <th>AMT_REQ_CREDIT_BUREAU_DAY</th>\n",
       "      <th>AMT_REQ_CREDIT_BUREAU_WEEK</th>\n",
       "      <th>AMT_REQ_CREDIT_BUREAU_MON</th>\n",
       "      <th>AMT_REQ_CREDIT_BUREAU_QRT</th>\n",
       "      <th>AMT_REQ_CREDIT_BUREAU_YEAR</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>41228</th>\n",
       "      <td>402926</td>\n",
       "      <td>Cash loans</td>\n",
       "      <td>F</td>\n",
       "      <td>N</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>90652.5</td>\n",
       "      <td>225000.0</td>\n",
       "      <td>15903.0</td>\n",
       "      <td>225000.0</td>\n",
       "      <td>Unaccompanied</td>\n",
       "      <td>Commercial associate</td>\n",
       "      <td>Secondary / secondary special</td>\n",
       "      <td>Married</td>\n",
       "      <td>House / apartment</td>\n",
       "      <td>0.018801</td>\n",
       "      <td>-12588</td>\n",
       "      <td>-1504</td>\n",
       "      <td>-1998.0</td>\n",
       "      <td>-4943</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sales staff</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>THURSDAY</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Entity Type 3</td>\n",
       "      <td>0.744575</td>\n",
       "      <td>0.567663</td>\n",
       "      <td>0.799297</td>\n",
       "      <td>0.0825</td>\n",
       "      <td>0.0789</td>\n",
       "      <td>0.9752</td>\n",
       "      <td>0.6600</td>\n",
       "      <td>0.0102</td>\n",
       "      <td>0.16</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0789</td>\n",
       "      <td>0.9752</td>\n",
       "      <td>0.6645</td>\n",
       "      <td>0.0103</td>\n",
       "      <td>0.16</td>\n",
       "      <td>0.1379</td>\n",
       "      <td>0.1667</td>\n",
       "      <td>0.2083</td>\n",
       "      <td>0.0560</td>\n",
       "      <td>0.0684</td>\n",
       "      <td>0.0719</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>reg oper account</td>\n",
       "      <td>block of flats</td>\n",
       "      <td>0.0556</td>\n",
       "      <td>Panel</td>\n",
       "      <td>No</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-687.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44778</th>\n",
       "      <td>427665</td>\n",
       "      <td>Cash loans</td>\n",
       "      <td>F</td>\n",
       "      <td>N</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>104323.5</td>\n",
       "      <td>225000.0</td>\n",
       "      <td>15772.5</td>\n",
       "      <td>225000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Commercial associate</td>\n",
       "      <td>Secondary / secondary special</td>\n",
       "      <td>Married</td>\n",
       "      <td>House / apartment</td>\n",
       "      <td>0.018801</td>\n",
       "      <td>-12620</td>\n",
       "      <td>-1536</td>\n",
       "      <td>-2030.0</td>\n",
       "      <td>-4975</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>Sales staff</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>MONDAY</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Entity Type 3</td>\n",
       "      <td>0.763560</td>\n",
       "      <td>0.454474</td>\n",
       "      <td>0.786267</td>\n",
       "      <td>0.0825</td>\n",
       "      <td>0.0789</td>\n",
       "      <td>0.9752</td>\n",
       "      <td>0.6600</td>\n",
       "      <td>0.0102</td>\n",
       "      <td>0.16</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0789</td>\n",
       "      <td>0.9752</td>\n",
       "      <td>0.6645</td>\n",
       "      <td>0.0103</td>\n",
       "      <td>0.16</td>\n",
       "      <td>0.1379</td>\n",
       "      <td>0.1667</td>\n",
       "      <td>0.2083</td>\n",
       "      <td>0.0560</td>\n",
       "      <td>0.0684</td>\n",
       "      <td>0.0719</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>reg oper account</td>\n",
       "      <td>block of flats</td>\n",
       "      <td>0.0556</td>\n",
       "      <td>Panel</td>\n",
       "      <td>No</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-719.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24419</th>\n",
       "      <td>277874</td>\n",
       "      <td>Cash loans</td>\n",
       "      <td>M</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "      <td>2</td>\n",
       "      <td>157500.0</td>\n",
       "      <td>225000.0</td>\n",
       "      <td>11619.0</td>\n",
       "      <td>225000.0</td>\n",
       "      <td>Unaccompanied</td>\n",
       "      <td>Working</td>\n",
       "      <td>Incomplete higher</td>\n",
       "      <td>Married</td>\n",
       "      <td>House / apartment</td>\n",
       "      <td>0.019101</td>\n",
       "      <td>-11275</td>\n",
       "      <td>-1100</td>\n",
       "      <td>-1519.0</td>\n",
       "      <td>-3575</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Security staff</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>WEDNESDAY</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Security</td>\n",
       "      <td>0.269414</td>\n",
       "      <td>0.311206</td>\n",
       "      <td>0.353988</td>\n",
       "      <td>0.1134</td>\n",
       "      <td>0.1122</td>\n",
       "      <td>0.9791</td>\n",
       "      <td>0.7144</td>\n",
       "      <td>0.0467</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.1122</td>\n",
       "      <td>0.9791</td>\n",
       "      <td>0.7182</td>\n",
       "      <td>0.0470</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.2759</td>\n",
       "      <td>0.1667</td>\n",
       "      <td>0.2083</td>\n",
       "      <td>0.0904</td>\n",
       "      <td>0.0941</td>\n",
       "      <td>0.1193</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>reg oper account</td>\n",
       "      <td>block of flats</td>\n",
       "      <td>0.1177</td>\n",
       "      <td>Stone, brick</td>\n",
       "      <td>No</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-458.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33319</th>\n",
       "      <td>342870</td>\n",
       "      <td>Cash loans</td>\n",
       "      <td>M</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "      <td>2</td>\n",
       "      <td>135000.0</td>\n",
       "      <td>52128.0</td>\n",
       "      <td>5602.5</td>\n",
       "      <td>45000.0</td>\n",
       "      <td>Unaccompanied</td>\n",
       "      <td>Commercial associate</td>\n",
       "      <td>Incomplete higher</td>\n",
       "      <td>Married</td>\n",
       "      <td>House / apartment</td>\n",
       "      <td>0.019101</td>\n",
       "      <td>-11324</td>\n",
       "      <td>-1149</td>\n",
       "      <td>-1568.0</td>\n",
       "      <td>-3624</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Security staff</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>WEDNESDAY</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Security</td>\n",
       "      <td>0.302021</td>\n",
       "      <td>0.219565</td>\n",
       "      <td>0.394495</td>\n",
       "      <td>0.1134</td>\n",
       "      <td>0.1122</td>\n",
       "      <td>0.9791</td>\n",
       "      <td>0.7144</td>\n",
       "      <td>0.0467</td>\n",
       "      <td>0.00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.1122</td>\n",
       "      <td>0.9791</td>\n",
       "      <td>0.7182</td>\n",
       "      <td>0.0470</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.2759</td>\n",
       "      <td>0.1667</td>\n",
       "      <td>0.2083</td>\n",
       "      <td>0.0904</td>\n",
       "      <td>0.0941</td>\n",
       "      <td>0.1193</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>reg oper account</td>\n",
       "      <td>block of flats</td>\n",
       "      <td>0.1177</td>\n",
       "      <td>Stone, brick</td>\n",
       "      <td>No</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-507.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11836</th>\n",
       "      <td>185981</td>\n",
       "      <td>Cash loans</td>\n",
       "      <td>M</td>\n",
       "      <td>N</td>\n",
       "      <td>Y</td>\n",
       "      <td>0</td>\n",
       "      <td>90000.0</td>\n",
       "      <td>1024807.5</td>\n",
       "      <td>33187.5</td>\n",
       "      <td>832500.0</td>\n",
       "      <td>Unaccompanied</td>\n",
       "      <td>Working</td>\n",
       "      <td>Secondary / secondary special</td>\n",
       "      <td>Married</td>\n",
       "      <td>House / apartment</td>\n",
       "      <td>0.035792</td>\n",
       "      <td>-16256</td>\n",
       "      <td>-4127</td>\n",
       "      <td>-7196.0</td>\n",
       "      <td>-4461</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>Laborers</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>FRIDAY</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Entity Type 3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.665246</td>\n",
       "      <td>0.586740</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1852.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23895</th>\n",
       "      <td>273946</td>\n",
       "      <td>Cash loans</td>\n",
       "      <td>M</td>\n",
       "      <td>Y</td>\n",
       "      <td>Y</td>\n",
       "      <td>0</td>\n",
       "      <td>81000.0</td>\n",
       "      <td>139230.0</td>\n",
       "      <td>12897.0</td>\n",
       "      <td>112500.0</td>\n",
       "      <td>Unaccompanied</td>\n",
       "      <td>Working</td>\n",
       "      <td>Secondary / secondary special</td>\n",
       "      <td>Married</td>\n",
       "      <td>House / apartment</td>\n",
       "      <td>0.035792</td>\n",
       "      <td>-16239</td>\n",
       "      <td>-4110</td>\n",
       "      <td>-7179.0</td>\n",
       "      <td>-4444</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Laborers</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>TUESDAY</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Business Entity Type 3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.662122</td>\n",
       "      <td>0.511892</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-1835.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6 rows × 121 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       SK_ID_CURR NAME_CONTRACT_TYPE CODE_GENDER FLAG_OWN_CAR FLAG_OWN_REALTY  \\\n",
       "41228      402926         Cash loans           F            N               Y   \n",
       "44778      427665         Cash loans           F            N               Y   \n",
       "24419      277874         Cash loans           M            Y               Y   \n",
       "33319      342870         Cash loans           M            Y               Y   \n",
       "11836      185981         Cash loans           M            N               Y   \n",
       "23895      273946         Cash loans           M            Y               Y   \n",
       "\n",
       "       CNT_CHILDREN  AMT_INCOME_TOTAL  AMT_CREDIT  AMT_ANNUITY  \\\n",
       "41228             1           90652.5    225000.0      15903.0   \n",
       "44778             1          104323.5    225000.0      15772.5   \n",
       "24419             2          157500.0    225000.0      11619.0   \n",
       "33319             2          135000.0     52128.0       5602.5   \n",
       "11836             0           90000.0   1024807.5      33187.5   \n",
       "23895             0           81000.0    139230.0      12897.0   \n",
       "\n",
       "       AMT_GOODS_PRICE NAME_TYPE_SUITE      NAME_INCOME_TYPE  \\\n",
       "41228         225000.0   Unaccompanied  Commercial associate   \n",
       "44778         225000.0             NaN  Commercial associate   \n",
       "24419         225000.0   Unaccompanied               Working   \n",
       "33319          45000.0   Unaccompanied  Commercial associate   \n",
       "11836         832500.0   Unaccompanied               Working   \n",
       "23895         112500.0   Unaccompanied               Working   \n",
       "\n",
       "                 NAME_EDUCATION_TYPE NAME_FAMILY_STATUS  NAME_HOUSING_TYPE  \\\n",
       "41228  Secondary / secondary special            Married  House / apartment   \n",
       "44778  Secondary / secondary special            Married  House / apartment   \n",
       "24419              Incomplete higher            Married  House / apartment   \n",
       "33319              Incomplete higher            Married  House / apartment   \n",
       "11836  Secondary / secondary special            Married  House / apartment   \n",
       "23895  Secondary / secondary special            Married  House / apartment   \n",
       "\n",
       "       REGION_POPULATION_RELATIVE  DAYS_BIRTH  DAYS_EMPLOYED  \\\n",
       "41228                    0.018801      -12588          -1504   \n",
       "44778                    0.018801      -12620          -1536   \n",
       "24419                    0.019101      -11275          -1100   \n",
       "33319                    0.019101      -11324          -1149   \n",
       "11836                    0.035792      -16256          -4127   \n",
       "23895                    0.035792      -16239          -4110   \n",
       "\n",
       "       DAYS_REGISTRATION  DAYS_ID_PUBLISH  OWN_CAR_AGE  FLAG_MOBIL  \\\n",
       "41228            -1998.0            -4943          NaN           1   \n",
       "44778            -2030.0            -4975          NaN           1   \n",
       "24419            -1519.0            -3575          6.0           1   \n",
       "33319            -1568.0            -3624          6.0           1   \n",
       "11836            -7196.0            -4461          NaN           1   \n",
       "23895            -7179.0            -4444         10.0           1   \n",
       "\n",
       "       FLAG_EMP_PHONE  FLAG_WORK_PHONE  FLAG_CONT_MOBILE  FLAG_PHONE  \\\n",
       "41228               1                1                 1           1   \n",
       "44778               1                1                 1           1   \n",
       "24419               1                1                 1           0   \n",
       "33319               1                0                 1           0   \n",
       "11836               1                0                 1           0   \n",
       "23895               1                0                 1           0   \n",
       "\n",
       "       FLAG_EMAIL OCCUPATION_TYPE  CNT_FAM_MEMBERS  REGION_RATING_CLIENT  \\\n",
       "41228           0     Sales staff              3.0                     2   \n",
       "44778           0     Sales staff              3.0                     2   \n",
       "24419           0  Security staff              4.0                     2   \n",
       "33319           0  Security staff              4.0                     2   \n",
       "11836           1        Laborers              2.0                     2   \n",
       "23895           0        Laborers              2.0                     2   \n",
       "\n",
       "       REGION_RATING_CLIENT_W_CITY WEEKDAY_APPR_PROCESS_START  \\\n",
       "41228                            2                   THURSDAY   \n",
       "44778                            2                     MONDAY   \n",
       "24419                            2                  WEDNESDAY   \n",
       "33319                            2                  WEDNESDAY   \n",
       "11836                            2                     FRIDAY   \n",
       "23895                            2                    TUESDAY   \n",
       "\n",
       "       HOUR_APPR_PROCESS_START  REG_REGION_NOT_LIVE_REGION  \\\n",
       "41228                       12                           0   \n",
       "44778                        9                           0   \n",
       "24419                       15                           0   \n",
       "33319                       13                           0   \n",
       "11836                       13                           0   \n",
       "23895                        9                           0   \n",
       "\n",
       "       REG_REGION_NOT_WORK_REGION  LIVE_REGION_NOT_WORK_REGION  \\\n",
       "41228                           0                            0   \n",
       "44778                           0                            0   \n",
       "24419                           0                            0   \n",
       "33319                           0                            0   \n",
       "11836                           0                            0   \n",
       "23895                           0                            0   \n",
       "\n",
       "       REG_CITY_NOT_LIVE_CITY  REG_CITY_NOT_WORK_CITY  \\\n",
       "41228                       0                       0   \n",
       "44778                       0                       0   \n",
       "24419                       0                       1   \n",
       "33319                       0                       1   \n",
       "11836                       0                       0   \n",
       "23895                       0                       0   \n",
       "\n",
       "       LIVE_CITY_NOT_WORK_CITY       ORGANIZATION_TYPE  EXT_SOURCE_1  \\\n",
       "41228                        0  Business Entity Type 3      0.744575   \n",
       "44778                        0  Business Entity Type 3      0.763560   \n",
       "24419                        1                Security      0.269414   \n",
       "33319                        1                Security      0.302021   \n",
       "11836                        0  Business Entity Type 3           NaN   \n",
       "23895                        0  Business Entity Type 3           NaN   \n",
       "\n",
       "       EXT_SOURCE_2  EXT_SOURCE_3  APARTMENTS_AVG  BASEMENTAREA_AVG  \\\n",
       "41228      0.567663      0.799297          0.0825            0.0789   \n",
       "44778      0.454474      0.786267          0.0825            0.0789   \n",
       "24419      0.311206      0.353988          0.1134            0.1122   \n",
       "33319      0.219565      0.394495          0.1134            0.1122   \n",
       "11836      0.665246      0.586740             NaN               NaN   \n",
       "23895      0.662122      0.511892             NaN               NaN   \n",
       "\n",
       "       YEARS_BEGINEXPLUATATION_AVG  YEARS_BUILD_AVG  COMMONAREA_AVG  \\\n",
       "41228                       0.9752           0.6600          0.0102   \n",
       "44778                       0.9752           0.6600          0.0102   \n",
       "24419                       0.9791           0.7144          0.0467   \n",
       "33319                       0.9791           0.7144          0.0467   \n",
       "11836                          NaN              NaN             NaN   \n",
       "23895                          NaN              NaN             NaN   \n",
       "\n",
       "       ELEVATORS_AVG             ...              BASEMENTAREA_MEDI  \\\n",
       "41228           0.16             ...                         0.0789   \n",
       "44778           0.16             ...                         0.0789   \n",
       "24419           0.00             ...                         0.1122   \n",
       "33319           0.00             ...                         0.1122   \n",
       "11836            NaN             ...                            NaN   \n",
       "23895            NaN             ...                            NaN   \n",
       "\n",
       "       YEARS_BEGINEXPLUATATION_MEDI  YEARS_BUILD_MEDI  COMMONAREA_MEDI  \\\n",
       "41228                        0.9752            0.6645           0.0103   \n",
       "44778                        0.9752            0.6645           0.0103   \n",
       "24419                        0.9791            0.7182           0.0470   \n",
       "33319                        0.9791            0.7182           0.0470   \n",
       "11836                           NaN               NaN              NaN   \n",
       "23895                           NaN               NaN              NaN   \n",
       "\n",
       "       ELEVATORS_MEDI  ENTRANCES_MEDI  FLOORSMAX_MEDI  FLOORSMIN_MEDI  \\\n",
       "41228            0.16          0.1379          0.1667          0.2083   \n",
       "44778            0.16          0.1379          0.1667          0.2083   \n",
       "24419            0.00          0.2759          0.1667          0.2083   \n",
       "33319            0.00          0.2759          0.1667          0.2083   \n",
       "11836             NaN             NaN             NaN             NaN   \n",
       "23895             NaN             NaN             NaN             NaN   \n",
       "\n",
       "       LANDAREA_MEDI  LIVINGAPARTMENTS_MEDI  LIVINGAREA_MEDI  \\\n",
       "41228         0.0560                 0.0684           0.0719   \n",
       "44778         0.0560                 0.0684           0.0719   \n",
       "24419         0.0904                 0.0941           0.1193   \n",
       "33319         0.0904                 0.0941           0.1193   \n",
       "11836            NaN                    NaN              NaN   \n",
       "23895            NaN                    NaN              NaN   \n",
       "\n",
       "       NONLIVINGAPARTMENTS_MEDI  NONLIVINGAREA_MEDI  FONDKAPREMONT_MODE  \\\n",
       "41228                       0.0                 0.0    reg oper account   \n",
       "44778                       0.0                 0.0    reg oper account   \n",
       "24419                       0.0                 0.0    reg oper account   \n",
       "33319                       0.0                 0.0    reg oper account   \n",
       "11836                       NaN                 NaN                 NaN   \n",
       "23895                       NaN                 NaN                 NaN   \n",
       "\n",
       "       HOUSETYPE_MODE  TOTALAREA_MODE  WALLSMATERIAL_MODE  \\\n",
       "41228  block of flats          0.0556               Panel   \n",
       "44778  block of flats          0.0556               Panel   \n",
       "24419  block of flats          0.1177        Stone, brick   \n",
       "33319  block of flats          0.1177        Stone, brick   \n",
       "11836             NaN             NaN                 NaN   \n",
       "23895             NaN             NaN                 NaN   \n",
       "\n",
       "       EMERGENCYSTATE_MODE  OBS_30_CNT_SOCIAL_CIRCLE  \\\n",
       "41228                   No                       1.0   \n",
       "44778                   No                       4.0   \n",
       "24419                   No                       0.0   \n",
       "33319                   No                       0.0   \n",
       "11836                  NaN                       1.0   \n",
       "23895                  NaN                       1.0   \n",
       "\n",
       "       DEF_30_CNT_SOCIAL_CIRCLE  OBS_60_CNT_SOCIAL_CIRCLE  \\\n",
       "41228                       0.0                       1.0   \n",
       "44778                       0.0                       4.0   \n",
       "24419                       0.0                       0.0   \n",
       "33319                       0.0                       0.0   \n",
       "11836                       0.0                       1.0   \n",
       "23895                       0.0                       1.0   \n",
       "\n",
       "       DEF_60_CNT_SOCIAL_CIRCLE  DAYS_LAST_PHONE_CHANGE  FLAG_DOCUMENT_2  \\\n",
       "41228                       0.0                  -687.0                0   \n",
       "44778                       0.0                  -719.0                0   \n",
       "24419                       0.0                  -458.0                0   \n",
       "33319                       0.0                  -507.0                0   \n",
       "11836                       0.0                 -1852.0                0   \n",
       "23895                       0.0                 -1835.0                0   \n",
       "\n",
       "       FLAG_DOCUMENT_3  FLAG_DOCUMENT_4  FLAG_DOCUMENT_5  FLAG_DOCUMENT_6  \\\n",
       "41228                0                0                0                0   \n",
       "44778                0                0                0                0   \n",
       "24419                1                0                0                0   \n",
       "33319                1                0                0                0   \n",
       "11836                1                0                0                0   \n",
       "23895                1                0                0                0   \n",
       "\n",
       "       FLAG_DOCUMENT_7  FLAG_DOCUMENT_8  FLAG_DOCUMENT_9  FLAG_DOCUMENT_10  \\\n",
       "41228                0                0                0                 0   \n",
       "44778                0                0                0                 0   \n",
       "24419                0                0                0                 0   \n",
       "33319                0                0                0                 0   \n",
       "11836                0                0                0                 0   \n",
       "23895                0                0                0                 0   \n",
       "\n",
       "       FLAG_DOCUMENT_11  FLAG_DOCUMENT_12  FLAG_DOCUMENT_13  FLAG_DOCUMENT_14  \\\n",
       "41228                 1                 0                 0                 0   \n",
       "44778                 1                 0                 0                 0   \n",
       "24419                 0                 0                 0                 0   \n",
       "33319                 0                 0                 0                 0   \n",
       "11836                 0                 0                 0                 0   \n",
       "23895                 0                 0                 0                 0   \n",
       "\n",
       "      FLAG_DOCUMENT_15 FLAG_DOCUMENT_16  FLAG_DOCUMENT_17 FLAG_DOCUMENT_18  \\\n",
       "41228                0                0                 0                0   \n",
       "44778                0                0                 0                0   \n",
       "24419                0                0                 0                0   \n",
       "33319                0                0                 0                0   \n",
       "11836                0                0                 0                0   \n",
       "23895                0                0                 0                0   \n",
       "\n",
       "      FLAG_DOCUMENT_19  FLAG_DOCUMENT_20  FLAG_DOCUMENT_21  \\\n",
       "41228                0                 0                 0   \n",
       "44778                0                 0                 0   \n",
       "24419                0                 0                 0   \n",
       "33319                0                 0                 0   \n",
       "11836                0                 0                 0   \n",
       "23895                0                 0                 0   \n",
       "\n",
       "       AMT_REQ_CREDIT_BUREAU_HOUR  AMT_REQ_CREDIT_BUREAU_DAY  \\\n",
       "41228                         0.0                        0.0   \n",
       "44778                         0.0                        0.0   \n",
       "24419                         0.0                        0.0   \n",
       "33319                         0.0                        0.0   \n",
       "11836                         0.0                        0.0   \n",
       "23895                         0.0                        0.0   \n",
       "\n",
       "       AMT_REQ_CREDIT_BUREAU_WEEK  AMT_REQ_CREDIT_BUREAU_MON  \\\n",
       "41228                         0.0                        0.0   \n",
       "44778                         0.0                        0.0   \n",
       "24419                         0.0                        0.0   \n",
       "33319                         0.0                        0.0   \n",
       "11836                         0.0                        0.0   \n",
       "23895                         0.0                        0.0   \n",
       "\n",
       "       AMT_REQ_CREDIT_BUREAU_QRT  AMT_REQ_CREDIT_BUREAU_YEAR  \n",
       "41228                        0.0                         1.0  \n",
       "44778                        1.0                         1.0  \n",
       "24419                        1.0                         0.0  \n",
       "33319                        1.0                         1.0  \n",
       "11836                        0.0                         0.0  \n",
       "23895                        0.0                         0.0  \n",
       "\n",
       "[6 rows x 121 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test.iloc[ix]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
