prev_check1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['prev_check2_clean.csv',\n",
       " 'application_test.csv',\n",
       " '.DS_Store',\n",
       " 'HomeCredit_columns_description.csv',\n",
       " 'POS_CASH_balance.csv',\n",
       " 'credit_card_balance.csv',\n",
       " 'installments_payments.csv',\n",
       " 'application_train.csv',\n",
       " 'bureau.csv',\n",
       " 'bu_clean.csv',\n",
       " 'prev_check1_clean.csv',\n",
       " 'previous_application.csv',\n",
       " 'HomeCredit_columns_description.xls',\n",
       " 'bureau_balance.csv',\n",
       " 'sample_submission.csv']"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import os\n",
    "cwd = os.getcwd()\n",
    "data_dir = cwd + '/dataset'\n",
    "os.listdir(data_dir)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import plotly.offline as py\n",
    "import plotly.graph_objs as go\n",
    "import plotly.tools as tls\n",
    "pd.set_option('max_columns',500)\n",
    "pd.set_option('max_rows',500)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "prev_appli_data = pd.read_csv(data_dir + '/previous_application.csv')\n",
    "instal_pay_data = pd.read_csv(data_dir + '/installments_payments.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>SK_ID_PREV</th>\n",
       "      <th>SK_ID_CURR</th>\n",
       "      <th>NAME_CONTRACT_TYPE</th>\n",
       "      <th>AMT_ANNUITY</th>\n",
       "      <th>AMT_APPLICATION</th>\n",
       "      <th>AMT_CREDIT</th>\n",
       "      <th>AMT_DOWN_PAYMENT</th>\n",
       "      <th>AMT_GOODS_PRICE</th>\n",
       "      <th>WEEKDAY_APPR_PROCESS_START</th>\n",
       "      <th>HOUR_APPR_PROCESS_START</th>\n",
       "      <th>FLAG_LAST_APPL_PER_CONTRACT</th>\n",
       "      <th>NFLAG_LAST_APPL_IN_DAY</th>\n",
       "      <th>RATE_DOWN_PAYMENT</th>\n",
       "      <th>RATE_INTEREST_PRIMARY</th>\n",
       "      <th>RATE_INTEREST_PRIVILEGED</th>\n",
       "      <th>NAME_CASH_LOAN_PURPOSE</th>\n",
       "      <th>NAME_CONTRACT_STATUS</th>\n",
       "      <th>DAYS_DECISION</th>\n",
       "      <th>NAME_PAYMENT_TYPE</th>\n",
       "      <th>CODE_REJECT_REASON</th>\n",
       "      <th>NAME_TYPE_SUITE</th>\n",
       "      <th>NAME_CLIENT_TYPE</th>\n",
       "      <th>NAME_GOODS_CATEGORY</th>\n",
       "      <th>NAME_PORTFOLIO</th>\n",
       "      <th>NAME_PRODUCT_TYPE</th>\n",
       "      <th>CHANNEL_TYPE</th>\n",
       "      <th>SELLERPLACE_AREA</th>\n",
       "      <th>NAME_SELLER_INDUSTRY</th>\n",
       "      <th>CNT_PAYMENT</th>\n",
       "      <th>NAME_YIELD_GROUP</th>\n",
       "      <th>PRODUCT_COMBINATION</th>\n",
       "      <th>DAYS_FIRST_DRAWING</th>\n",
       "      <th>DAYS_FIRST_DUE</th>\n",
       "      <th>DAYS_LAST_DUE_1ST_VERSION</th>\n",
       "      <th>DAYS_LAST_DUE</th>\n",
       "      <th>DAYS_TERMINATION</th>\n",
       "      <th>NFLAG_INSURED_ON_APPROVAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2030495</td>\n",
       "      <td>271877</td>\n",
       "      <td>Consumer loans</td>\n",
       "      <td>1730.430</td>\n",
       "      <td>17145.0</td>\n",
       "      <td>17145.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17145.0</td>\n",
       "      <td>SATURDAY</td>\n",
       "      <td>15</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.182832</td>\n",
       "      <td>0.867336</td>\n",
       "      <td>XAP</td>\n",
       "      <td>Approved</td>\n",
       "      <td>-73</td>\n",
       "      <td>Cash through the bank</td>\n",
       "      <td>XAP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Repeater</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>POS</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Country-wide</td>\n",
       "      <td>35</td>\n",
       "      <td>Connectivity</td>\n",
       "      <td>12.0</td>\n",
       "      <td>middle</td>\n",
       "      <td>POS mobile with interest</td>\n",
       "      <td>365243.0</td>\n",
       "      <td>-42.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>-42.0</td>\n",
       "      <td>-37.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2802425</td>\n",
       "      <td>108129</td>\n",
       "      <td>Cash loans</td>\n",
       "      <td>25188.615</td>\n",
       "      <td>607500.0</td>\n",
       "      <td>679671.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>607500.0</td>\n",
       "      <td>THURSDAY</td>\n",
       "      <td>11</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Approved</td>\n",
       "      <td>-164</td>\n",
       "      <td>XNA</td>\n",
       "      <td>XAP</td>\n",
       "      <td>Unaccompanied</td>\n",
       "      <td>Repeater</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Cash</td>\n",
       "      <td>x-sell</td>\n",
       "      <td>Contact center</td>\n",
       "      <td>-1</td>\n",
       "      <td>XNA</td>\n",
       "      <td>36.0</td>\n",
       "      <td>low_action</td>\n",
       "      <td>Cash X-Sell: low</td>\n",
       "      <td>365243.0</td>\n",
       "      <td>-134.0</td>\n",
       "      <td>916.0</td>\n",
       "      <td>365243.0</td>\n",
       "      <td>365243.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2523466</td>\n",
       "      <td>122040</td>\n",
       "      <td>Cash loans</td>\n",
       "      <td>15060.735</td>\n",
       "      <td>112500.0</td>\n",
       "      <td>136444.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>112500.0</td>\n",
       "      <td>TUESDAY</td>\n",
       "      <td>11</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Approved</td>\n",
       "      <td>-301</td>\n",
       "      <td>Cash through the bank</td>\n",
       "      <td>XAP</td>\n",
       "      <td>Spouse, partner</td>\n",
       "      <td>Repeater</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Cash</td>\n",
       "      <td>x-sell</td>\n",
       "      <td>Credit and cash offices</td>\n",
       "      <td>-1</td>\n",
       "      <td>XNA</td>\n",
       "      <td>12.0</td>\n",
       "      <td>high</td>\n",
       "      <td>Cash X-Sell: high</td>\n",
       "      <td>365243.0</td>\n",
       "      <td>-271.0</td>\n",
       "      <td>59.0</td>\n",
       "      <td>365243.0</td>\n",
       "      <td>365243.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   SK_ID_PREV  SK_ID_CURR NAME_CONTRACT_TYPE  AMT_ANNUITY  AMT_APPLICATION  \\\n",
       "0     2030495      271877     Consumer loans     1730.430          17145.0   \n",
       "1     2802425      108129         Cash loans    25188.615         607500.0   \n",
       "2     2523466      122040         Cash loans    15060.735         112500.0   \n",
       "\n",
       "   AMT_CREDIT  AMT_DOWN_PAYMENT  AMT_GOODS_PRICE WEEKDAY_APPR_PROCESS_START  \\\n",
       "0     17145.0               0.0          17145.0                   SATURDAY   \n",
       "1    679671.0               NaN         607500.0                   THURSDAY   \n",
       "2    136444.5               NaN         112500.0                    TUESDAY   \n",
       "\n",
       "   HOUR_APPR_PROCESS_START FLAG_LAST_APPL_PER_CONTRACT  \\\n",
       "0                       15                           Y   \n",
       "1                       11                           Y   \n",
       "2                       11                           Y   \n",
       "\n",
       "   NFLAG_LAST_APPL_IN_DAY  RATE_DOWN_PAYMENT  RATE_INTEREST_PRIMARY  \\\n",
       "0                       1                0.0               0.182832   \n",
       "1                       1                NaN                    NaN   \n",
       "2                       1                NaN                    NaN   \n",
       "\n",
       "   RATE_INTEREST_PRIVILEGED NAME_CASH_LOAN_PURPOSE NAME_CONTRACT_STATUS  \\\n",
       "0                  0.867336                    XAP             Approved   \n",
       "1                       NaN                    XNA             Approved   \n",
       "2                       NaN                    XNA             Approved   \n",
       "\n",
       "   DAYS_DECISION      NAME_PAYMENT_TYPE CODE_REJECT_REASON  NAME_TYPE_SUITE  \\\n",
       "0            -73  Cash through the bank                XAP              NaN   \n",
       "1           -164                    XNA                XAP    Unaccompanied   \n",
       "2           -301  Cash through the bank                XAP  Spouse, partner   \n",
       "\n",
       "  NAME_CLIENT_TYPE NAME_GOODS_CATEGORY NAME_PORTFOLIO NAME_PRODUCT_TYPE  \\\n",
       "0         Repeater              Mobile            POS               XNA   \n",
       "1         Repeater                 XNA           Cash            x-sell   \n",
       "2         Repeater                 XNA           Cash            x-sell   \n",
       "\n",
       "              CHANNEL_TYPE  SELLERPLACE_AREA NAME_SELLER_INDUSTRY  \\\n",
       "0             Country-wide                35         Connectivity   \n",
       "1           Contact center                -1                  XNA   \n",
       "2  Credit and cash offices                -1                  XNA   \n",
       "\n",
       "   CNT_PAYMENT NAME_YIELD_GROUP       PRODUCT_COMBINATION  DAYS_FIRST_DRAWING  \\\n",
       "0         12.0           middle  POS mobile with interest            365243.0   \n",
       "1         36.0       low_action          Cash X-Sell: low            365243.0   \n",
       "2         12.0             high         Cash X-Sell: high            365243.0   \n",
       "\n",
       "   DAYS_FIRST_DUE  DAYS_LAST_DUE_1ST_VERSION  DAYS_LAST_DUE  DAYS_TERMINATION  \\\n",
       "0           -42.0                      300.0          -42.0             -37.0   \n",
       "1          -134.0                      916.0       365243.0          365243.0   \n",
       "2          -271.0                       59.0       365243.0          365243.0   \n",
       "\n",
       "   NFLAG_INSURED_ON_APPROVAL  \n",
       "0                        0.0  \n",
       "1                        1.0  \n",
       "2                        1.0  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#print(set(prev_appli_data[\"NAME_CONTRACT_TYPE\"]))\n",
    "prev_appli_data.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "#prev_appli_data.loc[prev_appli_data[\"SK_ID_CURR\"]==108129]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'Refused', 'Approved', 'Canceled', 'Unused offer'}\n"
     ]
    }
   ],
   "source": [
    "print(set(prev_appli_data[\"NAME_CONTRACT_STATUS\"].values))\n",
    "#prev_appli_data.loc[prev_appli_data[\"NAME_CONTRACT_STATUS\"]=='Unused offer'].head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'XAP', 'SCO', 'LIMIT', 'XNA', 'SCOFR', 'SYSTEM', 'HC', 'VERIF'}\n",
      "{'Refreshed', 'New', 'Repeater', 'XNA'}\n",
      "{'Cash', 'XNA', 'Cars', 'POS', 'Cards'}\n",
      "{'walk-in', 'XNA', 'x-sell'}\n",
      "{'Channel of corporate sales', 'Country-wide', 'Regional / Local', 'Credit and cash offices', 'Car dealer', 'AP+ (Cash loan)', 'Stone', 'Contact center'}\n",
      "{'XNA', 'high', 'low_action', 'middle', 'low_normal'}\n",
      "{'Cash X-Sell: high', 'Cash X-Sell: middle', 'Cash Street: high', 'POS household with interest', 'Card X-Sell', 'Cash Street: middle', 'Cash X-Sell: low', nan, 'POS other with interest', 'POS mobile without interest', 'Cash Street: low', 'POS others without interest', 'POS household without interest', 'POS industry without interest', 'POS mobile with interest', 'Cash', 'POS industry with interest', 'Card Street'}\n"
     ]
    }
   ],
   "source": [
    "print(set(prev_appli_data.loc[prev_appli_data[\"NAME_CONTRACT_STATUS\"]=='Refused',\"CODE_REJECT_REASON\"].values))\n",
    "print(set(prev_appli_data[\"NAME_CLIENT_TYPE\"].values))\n",
    "print(set(prev_appli_data[\"NAME_PORTFOLIO\"].values))\n",
    "print(set(prev_appli_data[\"NAME_PRODUCT_TYPE\"].values))\n",
    "print(set(prev_appli_data[\"CHANNEL_TYPE\"].values))\n",
    "print(set(prev_appli_data[\"NAME_YIELD_GROUP\"].values))\n",
    "print(set(prev_appli_data[\"PRODUCT_COMBINATION\"].values))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'nan'}"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "set(prev_appli_data.loc[prev_appli_data[\"NAME_CONTRACT_STATUS\"]=='Unused offer',\\\n",
    "                        \"NFLAG_INSURED_ON_APPROVAL\"].apply(str).values)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 13605401 entries, 0 to 13605400\n",
      "Data columns (total 8 columns):\n",
      "SK_ID_PREV                int64\n",
      "SK_ID_CURR                int64\n",
      "NUM_INSTALMENT_VERSION    float64\n",
      "NUM_INSTALMENT_NUMBER     int64\n",
      "DAYS_INSTALMENT           float64\n",
      "DAYS_ENTRY_PAYMENT        float64\n",
      "AMT_INSTALMENT            float64\n",
      "AMT_PAYMENT               float64\n",
      "dtypes: float64(5), int64(3)\n",
      "memory usage: 830.4 MB\n"
     ]
    }
   ],
   "source": [
    "instal_pay_data.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "#instal_pay_data.loc[instal_pay_data[\"SK_ID_PREV\"]==2802425].head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>SK_ID_PREV</th>\n",
       "      <th>SK_ID_CURR</th>\n",
       "      <th>NAME_CONTRACT_TYPE</th>\n",
       "      <th>AMT_ANNUITY</th>\n",
       "      <th>AMT_APPLICATION</th>\n",
       "      <th>AMT_CREDIT</th>\n",
       "      <th>AMT_DOWN_PAYMENT</th>\n",
       "      <th>AMT_GOODS_PRICE</th>\n",
       "      <th>WEEKDAY_APPR_PROCESS_START</th>\n",
       "      <th>HOUR_APPR_PROCESS_START</th>\n",
       "      <th>FLAG_LAST_APPL_PER_CONTRACT</th>\n",
       "      <th>NFLAG_LAST_APPL_IN_DAY</th>\n",
       "      <th>RATE_DOWN_PAYMENT</th>\n",
       "      <th>RATE_INTEREST_PRIMARY</th>\n",
       "      <th>RATE_INTEREST_PRIVILEGED</th>\n",
       "      <th>NAME_CASH_LOAN_PURPOSE</th>\n",
       "      <th>NAME_CONTRACT_STATUS</th>\n",
       "      <th>DAYS_DECISION</th>\n",
       "      <th>NAME_PAYMENT_TYPE</th>\n",
       "      <th>CODE_REJECT_REASON</th>\n",
       "      <th>NAME_TYPE_SUITE</th>\n",
       "      <th>NAME_CLIENT_TYPE</th>\n",
       "      <th>NAME_GOODS_CATEGORY</th>\n",
       "      <th>NAME_PORTFOLIO</th>\n",
       "      <th>NAME_PRODUCT_TYPE</th>\n",
       "      <th>CHANNEL_TYPE</th>\n",
       "      <th>SELLERPLACE_AREA</th>\n",
       "      <th>NAME_SELLER_INDUSTRY</th>\n",
       "      <th>CNT_PAYMENT</th>\n",
       "      <th>NAME_YIELD_GROUP</th>\n",
       "      <th>PRODUCT_COMBINATION</th>\n",
       "      <th>DAYS_FIRST_DRAWING</th>\n",
       "      <th>DAYS_FIRST_DUE</th>\n",
       "      <th>DAYS_LAST_DUE_1ST_VERSION</th>\n",
       "      <th>DAYS_LAST_DUE</th>\n",
       "      <th>DAYS_TERMINATION</th>\n",
       "      <th>NFLAG_INSURED_ON_APPROVAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>161591</th>\n",
       "      <td>1740877</td>\n",
       "      <td>371185</td>\n",
       "      <td>Revolving loans</td>\n",
       "      <td>5625.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>112500.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TUESDAY</td>\n",
       "      <td>9</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>XAP</td>\n",
       "      <td>Approved</td>\n",
       "      <td>-1108</td>\n",
       "      <td>XNA</td>\n",
       "      <td>XAP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Repeater</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Cards</td>\n",
       "      <td>x-sell</td>\n",
       "      <td>Credit and cash offices</td>\n",
       "      <td>-1</td>\n",
       "      <td>XNA</td>\n",
       "      <td>0.0</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Card X-Sell</td>\n",
       "      <td>-1106.0</td>\n",
       "      <td>-1082.0</td>\n",
       "      <td>365243.0</td>\n",
       "      <td>365243.0</td>\n",
       "      <td>365243.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        SK_ID_PREV  SK_ID_CURR NAME_CONTRACT_TYPE  AMT_ANNUITY  \\\n",
       "161591     1740877      371185    Revolving loans       5625.0   \n",
       "\n",
       "        AMT_APPLICATION  AMT_CREDIT  AMT_DOWN_PAYMENT  AMT_GOODS_PRICE  \\\n",
       "161591              0.0    112500.0               NaN              NaN   \n",
       "\n",
       "       WEEKDAY_APPR_PROCESS_START  HOUR_APPR_PROCESS_START  \\\n",
       "161591                    TUESDAY                        9   \n",
       "\n",
       "       FLAG_LAST_APPL_PER_CONTRACT  NFLAG_LAST_APPL_IN_DAY  RATE_DOWN_PAYMENT  \\\n",
       "161591                           Y                       1                NaN   \n",
       "\n",
       "        RATE_INTEREST_PRIMARY  RATE_INTEREST_PRIVILEGED  \\\n",
       "161591                    NaN                       NaN   \n",
       "\n",
       "       NAME_CASH_LOAN_PURPOSE NAME_CONTRACT_STATUS  DAYS_DECISION  \\\n",
       "161591                    XAP             Approved          -1108   \n",
       "\n",
       "       NAME_PAYMENT_TYPE CODE_REJECT_REASON NAME_TYPE_SUITE NAME_CLIENT_TYPE  \\\n",
       "161591               XNA                XAP             NaN         Repeater   \n",
       "\n",
       "       NAME_GOODS_CATEGORY NAME_PORTFOLIO NAME_PRODUCT_TYPE  \\\n",
       "161591                 XNA          Cards            x-sell   \n",
       "\n",
       "                   CHANNEL_TYPE  SELLERPLACE_AREA NAME_SELLER_INDUSTRY  \\\n",
       "161591  Credit and cash offices                -1                  XNA   \n",
       "\n",
       "        CNT_PAYMENT NAME_YIELD_GROUP PRODUCT_COMBINATION  DAYS_FIRST_DRAWING  \\\n",
       "161591          0.0              XNA         Card X-Sell             -1106.0   \n",
       "\n",
       "        DAYS_FIRST_DUE  DAYS_LAST_DUE_1ST_VERSION  DAYS_LAST_DUE  \\\n",
       "161591         -1082.0                   365243.0       365243.0   \n",
       "\n",
       "        DAYS_TERMINATION  NFLAG_INSURED_ON_APPROVAL  \n",
       "161591          365243.0                        0.0  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "prev_appli_data.loc[prev_appli_data[\"SK_ID_PREV\"]==1740877]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 清理数据"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** 整理每个id_curr下的approved 与refused 的贷款数量**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = prev_appli_data[[\"SK_ID_CURR\",\\\n",
    "                      \"NAME_CONTRACT_STATUS\",\\\n",
    "                      \"NAME_CONTRACT_TYPE\"]\\\n",
    "                    ].groupby([\"SK_ID_CURR\",\\\n",
    "                               \"NAME_CONTRACT_STATUS\"\\\n",
    "                              ]).count()\n",
    "df = df.unstack(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"4\" halign=\"left\">NAME_CONTRACT_TYPE</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NAME_CONTRACT_STATUS</th>\n",
       "      <th>Approved</th>\n",
       "      <th>Canceled</th>\n",
       "      <th>Refused</th>\n",
       "      <th>Unused offer</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SK_ID_CURR</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>100001</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100002</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100003</th>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                     NAME_CONTRACT_TYPE                              \n",
       "NAME_CONTRACT_STATUS           Approved Canceled Refused Unused offer\n",
       "SK_ID_CURR                                                           \n",
       "100001                              1.0      NaN     NaN          NaN\n",
       "100002                              1.0      NaN     NaN          NaN\n",
       "100003                              3.0      NaN     NaN          NaN"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "cnt_approved = df['NAME_CONTRACT_TYPE']['Approved']\n",
    "cnt_canceled = df['NAME_CONTRACT_TYPE']['Canceled']\n",
    "cnt_refused = df['NAME_CONTRACT_TYPE']['Refused']\n",
    "cnt_unused = df['NAME_CONTRACT_TYPE']['Unused offer']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** 每个curr_id下approved 的最大最小AMT_CREDT与REFUSED最大最小AMT_CREDT **"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = prev_appli_data[[\"SK_ID_CURR\",\\\n",
    "                      \"NAME_CONTRACT_STATUS\",\\\n",
    "                      \"AMT_CREDIT\"]\\\n",
    "                    ].groupby([\"SK_ID_CURR\",\\\n",
    "                      \"NAME_CONTRACT_STATUS\"]).max()\n",
    "df = df.unstack(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "amt_credit_max_approved = df['AMT_CREDIT']['Approved']\n",
    "amt_credit_max_refused = df['AMT_CREDIT']['Refused']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = prev_appli_data[[\"SK_ID_CURR\",\\\n",
    "                      \"NAME_CONTRACT_STATUS\",\\\n",
    "                      \"AMT_CREDIT\"]\\\n",
    "                    ].groupby([\"SK_ID_CURR\",\\\n",
    "                      \"NAME_CONTRACT_STATUS\"]).min()\n",
    "df = df.unstack(1)\n",
    "amt_credit_min_approved = df['AMT_CREDIT']['Approved']\n",
    "amt_credit_min_refused = df['AMT_CREDIT']['Refused']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** 找到最后Approved的时间与Refused的时间 **"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = prev_appli_data[[\"SK_ID_CURR\",\\\n",
    "                      \"NAME_CONTRACT_STATUS\",\\\n",
    "                      \"DAYS_DECISION\"]\\\n",
    "                    ].groupby([\"SK_ID_CURR\",\\\n",
    "                      \"NAME_CONTRACT_STATUS\"]).max()\n",
    "df = df.unstack(1)\n",
    "days_last_approved = df['DAYS_DECISION']['Approved']\n",
    "days_last_refused = df['DAYS_DECISION']['Refused']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** 最后的DUE与最后的Ternimation时间**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = prev_appli_data[[\"SK_ID_CURR\",\"DAYS_LAST_DUE\"]].groupby(\"SK_ID_CURR\").max()\n",
    "days_last_due = df['DAYS_LAST_DUE']\n",
    "df = prev_appli_data[[\"SK_ID_CURR\",\"DAYS_TERMINATION\"]].groupby(\"SK_ID_CURR\").max()\n",
    "days_last_termination = df['DAYS_TERMINATION']\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "** 求出总的installments_payments中的借还款情况 **"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = instal_pay_data[['SK_ID_CURR','AMT_INSTALMENT','AMT_PAYMENT']].groupby(\"SK_ID_CURR\").sum()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 339587 entries, 100001 to 456255\n",
      "Data columns (total 2 columns):\n",
      "AMT_INSTALMENT    339587 non-null float64\n",
      "AMT_PAYMENT       339587 non-null float64\n",
      "dtypes: float64(2)\n",
      "memory usage: 7.8 MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "clean_data = pd.DataFrame({\"CNT_APPROVED\":cnt_approved,\n",
    "                           \"CNT_CANCELED\":cnt_canceled,\n",
    "                           \"CNT_REFUSED\":cnt_refused,\n",
    "                           \"CNT_UNUSED\":cnt_unused,\n",
    "                           \"AMT_MAX_APPROVED\":amt_credit_max_approved,\n",
    "                           \"AMT_MIN_APPROVED\":amt_credit_min_approved,\n",
    "                           \"AMT_MAX_REFUSED\":amt_credit_max_refused,\n",
    "                           \"AMT_MIN_REFUSED\":amt_credit_min_refused,\n",
    "                           \"DAYS_LAST_APPROVED\":days_last_approved,\n",
    "                           \"DAYS_LAST_REFUSED\":days_last_refused,\n",
    "                           \"DAYS_LAST_DUE\":days_last_due,\n",
    "                           \"DAYS_TERMINATION\":days_last_termination})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = pd.concat([clean_data,df], axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "result.to_csv(data_dir + '/prev_check1_clean.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 340649 entries, 100001 to 456255\n",
      "Data columns (total 14 columns):\n",
      "AMT_MAX_APPROVED      337698 non-null float64\n",
      "AMT_MAX_REFUSED       118277 non-null float64\n",
      "AMT_MIN_APPROVED      337698 non-null float64\n",
      "AMT_MIN_REFUSED       118277 non-null float64\n",
      "CNT_APPROVED          337698 non-null float64\n",
      "CNT_CANCELED          132694 non-null float64\n",
      "CNT_REFUSED           118277 non-null float64\n",
      "CNT_UNUSED            22079 non-null float64\n",
      "DAYS_LAST_APPROVED    337698 non-null float64\n",
      "DAYS_LAST_DUE         337340 non-null float64\n",
      "DAYS_LAST_REFUSED     118277 non-null float64\n",
      "DAYS_TERMINATION      337340 non-null float64\n",
      "AMT_INSTALMENT        339587 non-null float64\n",
      "AMT_PAYMENT           339587 non-null float64\n",
      "dtypes: float64(14)\n",
      "memory usage: 39.0 MB\n"
     ]
    }
   ],
   "source": [
    "result.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>SK_ID_PREV</th>\n",
       "      <th>SK_ID_CURR</th>\n",
       "      <th>NAME_CONTRACT_TYPE</th>\n",
       "      <th>AMT_ANNUITY</th>\n",
       "      <th>AMT_APPLICATION</th>\n",
       "      <th>AMT_CREDIT</th>\n",
       "      <th>AMT_DOWN_PAYMENT</th>\n",
       "      <th>AMT_GOODS_PRICE</th>\n",
       "      <th>WEEKDAY_APPR_PROCESS_START</th>\n",
       "      <th>HOUR_APPR_PROCESS_START</th>\n",
       "      <th>FLAG_LAST_APPL_PER_CONTRACT</th>\n",
       "      <th>NFLAG_LAST_APPL_IN_DAY</th>\n",
       "      <th>RATE_DOWN_PAYMENT</th>\n",
       "      <th>RATE_INTEREST_PRIMARY</th>\n",
       "      <th>RATE_INTEREST_PRIVILEGED</th>\n",
       "      <th>NAME_CASH_LOAN_PURPOSE</th>\n",
       "      <th>NAME_CONTRACT_STATUS</th>\n",
       "      <th>DAYS_DECISION</th>\n",
       "      <th>NAME_PAYMENT_TYPE</th>\n",
       "      <th>CODE_REJECT_REASON</th>\n",
       "      <th>NAME_TYPE_SUITE</th>\n",
       "      <th>NAME_CLIENT_TYPE</th>\n",
       "      <th>NAME_GOODS_CATEGORY</th>\n",
       "      <th>NAME_PORTFOLIO</th>\n",
       "      <th>NAME_PRODUCT_TYPE</th>\n",
       "      <th>CHANNEL_TYPE</th>\n",
       "      <th>SELLERPLACE_AREA</th>\n",
       "      <th>NAME_SELLER_INDUSTRY</th>\n",
       "      <th>CNT_PAYMENT</th>\n",
       "      <th>NAME_YIELD_GROUP</th>\n",
       "      <th>PRODUCT_COMBINATION</th>\n",
       "      <th>DAYS_FIRST_DRAWING</th>\n",
       "      <th>DAYS_FIRST_DUE</th>\n",
       "      <th>DAYS_LAST_DUE_1ST_VERSION</th>\n",
       "      <th>DAYS_LAST_DUE</th>\n",
       "      <th>DAYS_TERMINATION</th>\n",
       "      <th>NFLAG_INSURED_ON_APPROVAL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>109476</th>\n",
       "      <td>2249277</td>\n",
       "      <td>456018</td>\n",
       "      <td>Revolving loans</td>\n",
       "      <td>4500.000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>90000.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TUESDAY</td>\n",
       "      <td>11</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>XAP</td>\n",
       "      <td>Approved</td>\n",
       "      <td>-1204</td>\n",
       "      <td>XNA</td>\n",
       "      <td>XAP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Refreshed</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Cards</td>\n",
       "      <td>x-sell</td>\n",
       "      <td>Country-wide</td>\n",
       "      <td>144</td>\n",
       "      <td>Consumer electronics</td>\n",
       "      <td>0.0</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Card X-Sell</td>\n",
       "      <td>-1201.0</td>\n",
       "      <td>-1165.0</td>\n",
       "      <td>365243.0</td>\n",
       "      <td>365243.0</td>\n",
       "      <td>365243.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>153701</th>\n",
       "      <td>1622362</td>\n",
       "      <td>456018</td>\n",
       "      <td>Cash loans</td>\n",
       "      <td>21274.650</td>\n",
       "      <td>202500.0</td>\n",
       "      <td>202500.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>202500.0</td>\n",
       "      <td>WEDNESDAY</td>\n",
       "      <td>18</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Refused</td>\n",
       "      <td>-1196</td>\n",
       "      <td>Cash through the bank</td>\n",
       "      <td>LIMIT</td>\n",
       "      <td>Unaccompanied</td>\n",
       "      <td>Repeater</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Cash</td>\n",
       "      <td>x-sell</td>\n",
       "      <td>AP+ (Cash loan)</td>\n",
       "      <td>8</td>\n",
       "      <td>XNA</td>\n",
       "      <td>12.0</td>\n",
       "      <td>middle</td>\n",
       "      <td>Cash X-Sell: middle</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211924</th>\n",
       "      <td>2420717</td>\n",
       "      <td>456018</td>\n",
       "      <td>Cash loans</td>\n",
       "      <td>22544.550</td>\n",
       "      <td>450000.0</td>\n",
       "      <td>533160.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>450000.0</td>\n",
       "      <td>TUESDAY</td>\n",
       "      <td>12</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Refused</td>\n",
       "      <td>-952</td>\n",
       "      <td>Cash through the bank</td>\n",
       "      <td>LIMIT</td>\n",
       "      <td>Unaccompanied</td>\n",
       "      <td>Repeater</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Cash</td>\n",
       "      <td>walk-in</td>\n",
       "      <td>Credit and cash offices</td>\n",
       "      <td>-1</td>\n",
       "      <td>XNA</td>\n",
       "      <td>48.0</td>\n",
       "      <td>middle</td>\n",
       "      <td>Cash Street: middle</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>701956</th>\n",
       "      <td>1190262</td>\n",
       "      <td>456018</td>\n",
       "      <td>Consumer loans</td>\n",
       "      <td>4536.810</td>\n",
       "      <td>29965.5</td>\n",
       "      <td>28750.5</td>\n",
       "      <td>2997.0</td>\n",
       "      <td>29965.5</td>\n",
       "      <td>SUNDAY</td>\n",
       "      <td>13</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>0.102811</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>XAP</td>\n",
       "      <td>Approved</td>\n",
       "      <td>-2249</td>\n",
       "      <td>Cash through the bank</td>\n",
       "      <td>XAP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>New</td>\n",
       "      <td>Mobile</td>\n",
       "      <td>POS</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Country-wide</td>\n",
       "      <td>31</td>\n",
       "      <td>Connectivity</td>\n",
       "      <td>8.0</td>\n",
       "      <td>high</td>\n",
       "      <td>POS mobile with interest</td>\n",
       "      <td>365243.0</td>\n",
       "      <td>-2186.0</td>\n",
       "      <td>-1976.0</td>\n",
       "      <td>-1976.0</td>\n",
       "      <td>-1969.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>708586</th>\n",
       "      <td>2767422</td>\n",
       "      <td>456018</td>\n",
       "      <td>Cash loans</td>\n",
       "      <td>44694.810</td>\n",
       "      <td>967500.0</td>\n",
       "      <td>1051789.5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>967500.0</td>\n",
       "      <td>TUESDAY</td>\n",
       "      <td>17</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Repairs</td>\n",
       "      <td>Refused</td>\n",
       "      <td>-567</td>\n",
       "      <td>Cash through the bank</td>\n",
       "      <td>HC</td>\n",
       "      <td>Unaccompanied</td>\n",
       "      <td>Repeater</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Cash</td>\n",
       "      <td>walk-in</td>\n",
       "      <td>Credit and cash offices</td>\n",
       "      <td>-1</td>\n",
       "      <td>XNA</td>\n",
       "      <td>36.0</td>\n",
       "      <td>low_normal</td>\n",
       "      <td>Cash Street: low</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>928035</th>\n",
       "      <td>2577090</td>\n",
       "      <td>456018</td>\n",
       "      <td>Cash loans</td>\n",
       "      <td>41585.625</td>\n",
       "      <td>900000.0</td>\n",
       "      <td>978408.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>900000.0</td>\n",
       "      <td>TUESDAY</td>\n",
       "      <td>19</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Repairs</td>\n",
       "      <td>Refused</td>\n",
       "      <td>-574</td>\n",
       "      <td>Cash through the bank</td>\n",
       "      <td>HC</td>\n",
       "      <td>Unaccompanied</td>\n",
       "      <td>Repeater</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Cash</td>\n",
       "      <td>walk-in</td>\n",
       "      <td>Credit and cash offices</td>\n",
       "      <td>-1</td>\n",
       "      <td>XNA</td>\n",
       "      <td>36.0</td>\n",
       "      <td>low_normal</td>\n",
       "      <td>Cash Street: low</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1333267</th>\n",
       "      <td>1914488</td>\n",
       "      <td>456018</td>\n",
       "      <td>Consumer loans</td>\n",
       "      <td>8505.045</td>\n",
       "      <td>97155.0</td>\n",
       "      <td>112545.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>97155.0</td>\n",
       "      <td>THURSDAY</td>\n",
       "      <td>17</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>XAP</td>\n",
       "      <td>Approved</td>\n",
       "      <td>-565</td>\n",
       "      <td>Cash through the bank</td>\n",
       "      <td>XAP</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Repeater</td>\n",
       "      <td>Computers</td>\n",
       "      <td>POS</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Country-wide</td>\n",
       "      <td>30</td>\n",
       "      <td>Consumer electronics</td>\n",
       "      <td>18.0</td>\n",
       "      <td>middle</td>\n",
       "      <td>POS household with interest</td>\n",
       "      <td>365243.0</td>\n",
       "      <td>-534.0</td>\n",
       "      <td>-24.0</td>\n",
       "      <td>-54.0</td>\n",
       "      <td>-51.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1412166</th>\n",
       "      <td>1065971</td>\n",
       "      <td>456018</td>\n",
       "      <td>Cash loans</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TUESDAY</td>\n",
       "      <td>14</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Refused</td>\n",
       "      <td>-210</td>\n",
       "      <td>XNA</td>\n",
       "      <td>HC</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Repeater</td>\n",
       "      <td>XNA</td>\n",
       "      <td>XNA</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Credit and cash offices</td>\n",
       "      <td>-1</td>\n",
       "      <td>XNA</td>\n",
       "      <td>NaN</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Cash</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1423973</th>\n",
       "      <td>1186532</td>\n",
       "      <td>456018</td>\n",
       "      <td>Cash loans</td>\n",
       "      <td>16830.855</td>\n",
       "      <td>252000.0</td>\n",
       "      <td>292914.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>252000.0</td>\n",
       "      <td>TUESDAY</td>\n",
       "      <td>12</td>\n",
       "      <td>Y</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Approved</td>\n",
       "      <td>-952</td>\n",
       "      <td>Cash through the bank</td>\n",
       "      <td>XAP</td>\n",
       "      <td>Unaccompanied</td>\n",
       "      <td>Repeater</td>\n",
       "      <td>XNA</td>\n",
       "      <td>Cash</td>\n",
       "      <td>x-sell</td>\n",
       "      <td>Credit and cash offices</td>\n",
       "      <td>-1</td>\n",
       "      <td>XNA</td>\n",
       "      <td>36.0</td>\n",
       "      <td>high</td>\n",
       "      <td>Cash X-Sell: high</td>\n",
       "      <td>365243.0</td>\n",
       "      <td>-922.0</td>\n",
       "      <td>128.0</td>\n",
       "      <td>365243.0</td>\n",
       "      <td>365243.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         SK_ID_PREV  SK_ID_CURR NAME_CONTRACT_TYPE  AMT_ANNUITY  \\\n",
       "109476      2249277      456018    Revolving loans     4500.000   \n",
       "153701      1622362      456018         Cash loans    21274.650   \n",
       "211924      2420717      456018         Cash loans    22544.550   \n",
       "701956      1190262      456018     Consumer loans     4536.810   \n",
       "708586      2767422      456018         Cash loans    44694.810   \n",
       "928035      2577090      456018         Cash loans    41585.625   \n",
       "1333267     1914488      456018     Consumer loans     8505.045   \n",
       "1412166     1065971      456018         Cash loans          NaN   \n",
       "1423973     1186532      456018         Cash loans    16830.855   \n",
       "\n",
       "         AMT_APPLICATION  AMT_CREDIT  AMT_DOWN_PAYMENT  AMT_GOODS_PRICE  \\\n",
       "109476               0.0     90000.0               NaN              NaN   \n",
       "153701          202500.0    202500.0               NaN         202500.0   \n",
       "211924          450000.0    533160.0               NaN         450000.0   \n",
       "701956           29965.5     28750.5            2997.0          29965.5   \n",
       "708586          967500.0   1051789.5               NaN         967500.0   \n",
       "928035          900000.0    978408.0               NaN         900000.0   \n",
       "1333267          97155.0    112545.0               0.0          97155.0   \n",
       "1412166              0.0         0.0               NaN              NaN   \n",
       "1423973         252000.0    292914.0               NaN         252000.0   \n",
       "\n",
       "        WEEKDAY_APPR_PROCESS_START  HOUR_APPR_PROCESS_START  \\\n",
       "109476                     TUESDAY                       11   \n",
       "153701                   WEDNESDAY                       18   \n",
       "211924                     TUESDAY                       12   \n",
       "701956                      SUNDAY                       13   \n",
       "708586                     TUESDAY                       17   \n",
       "928035                     TUESDAY                       19   \n",
       "1333267                   THURSDAY                       17   \n",
       "1412166                    TUESDAY                       14   \n",
       "1423973                    TUESDAY                       12   \n",
       "\n",
       "        FLAG_LAST_APPL_PER_CONTRACT  NFLAG_LAST_APPL_IN_DAY  \\\n",
       "109476                            Y                       1   \n",
       "153701                            Y                       1   \n",
       "211924                            Y                       1   \n",
       "701956                            Y                       1   \n",
       "708586                            Y                       1   \n",
       "928035                            Y                       1   \n",
       "1333267                           Y                       1   \n",
       "1412166                           Y                       1   \n",
       "1423973                           Y                       1   \n",
       "\n",
       "         RATE_DOWN_PAYMENT  RATE_INTEREST_PRIMARY  RATE_INTEREST_PRIVILEGED  \\\n",
       "109476                 NaN                    NaN                       NaN   \n",
       "153701                 NaN                    NaN                       NaN   \n",
       "211924                 NaN                    NaN                       NaN   \n",
       "701956            0.102811                    NaN                       NaN   \n",
       "708586                 NaN                    NaN                       NaN   \n",
       "928035                 NaN                    NaN                       NaN   \n",
       "1333267           0.000000                    NaN                       NaN   \n",
       "1412166                NaN                    NaN                       NaN   \n",
       "1423973                NaN                    NaN                       NaN   \n",
       "\n",
       "        NAME_CASH_LOAN_PURPOSE NAME_CONTRACT_STATUS  DAYS_DECISION  \\\n",
       "109476                     XAP             Approved          -1204   \n",
       "153701                     XNA              Refused          -1196   \n",
       "211924                     XNA              Refused           -952   \n",
       "701956                     XAP             Approved          -2249   \n",
       "708586                 Repairs              Refused           -567   \n",
       "928035                 Repairs              Refused           -574   \n",
       "1333267                    XAP             Approved           -565   \n",
       "1412166                    XNA              Refused           -210   \n",
       "1423973                    XNA             Approved           -952   \n",
       "\n",
       "             NAME_PAYMENT_TYPE CODE_REJECT_REASON NAME_TYPE_SUITE  \\\n",
       "109476                     XNA                XAP             NaN   \n",
       "153701   Cash through the bank              LIMIT   Unaccompanied   \n",
       "211924   Cash through the bank              LIMIT   Unaccompanied   \n",
       "701956   Cash through the bank                XAP             NaN   \n",
       "708586   Cash through the bank                 HC   Unaccompanied   \n",
       "928035   Cash through the bank                 HC   Unaccompanied   \n",
       "1333267  Cash through the bank                XAP             NaN   \n",
       "1412166                    XNA                 HC             NaN   \n",
       "1423973  Cash through the bank                XAP   Unaccompanied   \n",
       "\n",
       "        NAME_CLIENT_TYPE NAME_GOODS_CATEGORY NAME_PORTFOLIO NAME_PRODUCT_TYPE  \\\n",
       "109476         Refreshed                 XNA          Cards            x-sell   \n",
       "153701          Repeater                 XNA           Cash            x-sell   \n",
       "211924          Repeater                 XNA           Cash           walk-in   \n",
       "701956               New              Mobile            POS               XNA   \n",
       "708586          Repeater                 XNA           Cash           walk-in   \n",
       "928035          Repeater                 XNA           Cash           walk-in   \n",
       "1333267         Repeater           Computers            POS               XNA   \n",
       "1412166         Repeater                 XNA            XNA               XNA   \n",
       "1423973         Repeater                 XNA           Cash            x-sell   \n",
       "\n",
       "                    CHANNEL_TYPE  SELLERPLACE_AREA  NAME_SELLER_INDUSTRY  \\\n",
       "109476              Country-wide               144  Consumer electronics   \n",
       "153701           AP+ (Cash loan)                 8                   XNA   \n",
       "211924   Credit and cash offices                -1                   XNA   \n",
       "701956              Country-wide                31          Connectivity   \n",
       "708586   Credit and cash offices                -1                   XNA   \n",
       "928035   Credit and cash offices                -1                   XNA   \n",
       "1333267             Country-wide                30  Consumer electronics   \n",
       "1412166  Credit and cash offices                -1                   XNA   \n",
       "1423973  Credit and cash offices                -1                   XNA   \n",
       "\n",
       "         CNT_PAYMENT NAME_YIELD_GROUP          PRODUCT_COMBINATION  \\\n",
       "109476           0.0              XNA                  Card X-Sell   \n",
       "153701          12.0           middle          Cash X-Sell: middle   \n",
       "211924          48.0           middle          Cash Street: middle   \n",
       "701956           8.0             high     POS mobile with interest   \n",
       "708586          36.0       low_normal             Cash Street: low   \n",
       "928035          36.0       low_normal             Cash Street: low   \n",
       "1333267         18.0           middle  POS household with interest   \n",
       "1412166          NaN              XNA                         Cash   \n",
       "1423973         36.0             high            Cash X-Sell: high   \n",
       "\n",
       "         DAYS_FIRST_DRAWING  DAYS_FIRST_DUE  DAYS_LAST_DUE_1ST_VERSION  \\\n",
       "109476              -1201.0         -1165.0                   365243.0   \n",
       "153701                  NaN             NaN                        NaN   \n",
       "211924                  NaN             NaN                        NaN   \n",
       "701956             365243.0         -2186.0                    -1976.0   \n",
       "708586                  NaN             NaN                        NaN   \n",
       "928035                  NaN             NaN                        NaN   \n",
       "1333267            365243.0          -534.0                      -24.0   \n",
       "1412166                 NaN             NaN                        NaN   \n",
       "1423973            365243.0          -922.0                      128.0   \n",
       "\n",
       "         DAYS_LAST_DUE  DAYS_TERMINATION  NFLAG_INSURED_ON_APPROVAL  \n",
       "109476        365243.0          365243.0                        0.0  \n",
       "153701             NaN               NaN                        NaN  \n",
       "211924             NaN               NaN                        NaN  \n",
       "701956         -1976.0           -1969.0                        0.0  \n",
       "708586             NaN               NaN                        NaN  \n",
       "928035             NaN               NaN                        NaN  \n",
       "1333267          -54.0             -51.0                        0.0  \n",
       "1412166            NaN               NaN                        NaN  \n",
       "1423973       365243.0          365243.0                        1.0  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "prev_appli_data.loc[prev_appli_data['SK_ID_CURR']==456018]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "#instal_pay_data.loc[instal_pay_data['']]"
   ]
  },
  {
   "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.5.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}