RFB - Merge External Data.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Raiffeisen - Merge External Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "pd.options.display.max_columns = 400"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Read external data\n",
    "\n",
    "Most of the external data were collected from The Statistical Office of the Republic of Serbia and Open data portal of Republic of Serbia.\n",
    "\n",
    "- http://www.stat.gov.rs/en-US\n",
    "- https://data.gov.rs/sr/\n",
    "\n",
    "### Read cleaned data first"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1083919, 306)"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('RFB - Clean Data.csv', index_col=0)\n",
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>PD_MIX_ACTIVE_m1</th>\n",
       "      <th>BLACK_LIST_FLG_m1</th>\n",
       "      <th>BLACK_LIST_LEVEL_m1</th>\n",
       "      <th>LEASING_FLG_m1</th>\n",
       "      <th>RISK_BLOCKED_FLG_m1</th>\n",
       "      <th>CUSTOMER_RK</th>\n",
       "      <th>CC_DB_TXN_CNT_m1</th>\n",
       "      <th>CC_DB_TXN_AMT_m1</th>\n",
       "      <th>CC_CR_TXN_CNT_m1</th>\n",
       "      <th>CC_CR_TXN_AMT_m1</th>\n",
       "      <th>CC_EOM_BAL_AMT_m1</th>\n",
       "      <th>CC_AVG_BAL_AMT_m1</th>\n",
       "      <th>CC_ACC_USED_CNT_m1</th>\n",
       "      <th>CL_DB_TXN_CNT_m1</th>\n",
       "      <th>CL_DB_TXN_AMT_m1</th>\n",
       "      <th>CL_CR_TXN_CNT_m1</th>\n",
       "      <th>CL_CR_TXN_AMT_m1</th>\n",
       "      <th>CL_EOM_BAL_AMT_m1</th>\n",
       "      <th>CL_AVG_BAL_AMT_m1</th>\n",
       "      <th>CL_ACC_USED_CNT_m1</th>\n",
       "      <th>LEN_DB_TXN_CNT_m1</th>\n",
       "      <th>LEN_DB_TXN_AMT_m1</th>\n",
       "      <th>LEN_CR_TXN_CNT_m1</th>\n",
       "      <th>LEN_CR_TXN_AMT_m1</th>\n",
       "      <th>LEN_EOM_BAL_AMT_m1</th>\n",
       "      <th>LEN_AVG_BAL_AMT_m1</th>\n",
       "      <th>LEN_ACC_USED_CNT_m1</th>\n",
       "      <th>LM_DB_TXN_CNT_m1</th>\n",
       "      <th>LM_DB_TXN_AMT_m1</th>\n",
       "      <th>LM_CR_TXN_CNT_m1</th>\n",
       "      <th>LM_CR_TXN_AMT_m1</th>\n",
       "      <th>LM_EOM_BAL_AMT_m1</th>\n",
       "      <th>LM_AVG_BAL_AMT_m1</th>\n",
       "      <th>LM_ACC_USED_CNT_m1</th>\n",
       "      <th>SA_DB_TXN_CNT_m1</th>\n",
       "      <th>SA_DB_TXN_AMT_m1</th>\n",
       "      <th>SA_CR_TXN_CNT_m1</th>\n",
       "      <th>SA_CR_TXN_AMT_m1</th>\n",
       "      <th>SA_EOM_BAL_AMT_m1</th>\n",
       "      <th>SA_AVG_BAL_AMT_m1</th>\n",
       "      <th>SA_ACC_USED_CNT_m1</th>\n",
       "      <th>SLA_DB_TXN_CNT_m1</th>\n",
       "      <th>SLA_DB_TXN_AMT_m1</th>\n",
       "      <th>SLA_CR_TXN_CNT_m1</th>\n",
       "      <th>SLA_CR_TXN_AMT_m1</th>\n",
       "      <th>SLA_EOM_BAL_AMT_m1</th>\n",
       "      <th>SLA_AVG_BAL_AMT_m1</th>\n",
       "      <th>SLA_ACC_USED_CNT_m1</th>\n",
       "      <th>TD_DB_TXN_CNT_m1</th>\n",
       "      <th>TD_DB_TXN_AMT_m1</th>\n",
       "      <th>TD_CR_TXN_CNT_m1</th>\n",
       "      <th>TD_CR_TXN_AMT_m1</th>\n",
       "      <th>TD_EOM_BAL_AMT_m1</th>\n",
       "      <th>TD_AVG_BAL_AMT_m1</th>\n",
       "      <th>TD_ACC_USED_CNT_m1</th>\n",
       "      <th>SSP_FLG_m1</th>\n",
       "      <th>PAST_DUE_AMT_m1</th>\n",
       "      <th>OD_LIMIT_m1</th>\n",
       "      <th>DAYS_PAST_DUE_m1</th>\n",
       "      <th>INCOME_AMT_m1</th>\n",
       "      <th>SLA_INCOME_AMT_m1</th>\n",
       "      <th>DEBIT_CARD_CNT_m1</th>\n",
       "      <th>NOSTRO_TXN_AMT_m1</th>\n",
       "      <th>LORO_TXN_AMT_m1</th>\n",
       "      <th>CHEQUE_TXN_CNT_m1</th>\n",
       "      <th>CHEQUE_TXN_AMT_m1</th>\n",
       "      <th>MRCH_AIR_TXN_CNT_m1</th>\n",
       "      <th>MRCH_AIR_TXN_AMT_m1</th>\n",
       "      <th>MRCH_CASH_TXN_CNT_m1</th>\n",
       "      <th>MRCH_CASH_TXN_AMT_m1</th>\n",
       "      <th>MRCH_CHILD_TXN_CNT_m1</th>\n",
       "      <th>MRCH_CHILD_TXN_AMT_m1</th>\n",
       "      <th>MRCH_CLTH_TXN_CNT_m1</th>\n",
       "      <th>MRCH_CLTH_TXN_AMT_m1</th>\n",
       "      <th>MRCH_DEPST_TXN_CNT_m1</th>\n",
       "      <th>MRCH_DEPST_TXN_AMT_m1</th>\n",
       "      <th>MRCH_DIY_TXN_CNT_m1</th>\n",
       "      <th>MRCH_DIY_TXN_AMT_m1</th>\n",
       "      <th>MRCH_DRCTM_TXN_CNT_m1</th>\n",
       "      <th>MRCH_DRCTM_TXN_AMT_m1</th>\n",
       "      <th>MRCH_ENT_TXN_CNT_m1</th>\n",
       "      <th>MRCH_ENT_TXN_AMT_m1</th>\n",
       "      <th>MRCH_FOOD_TXN_CNT_m1</th>\n",
       "      <th>MRCH_FOOD_TXN_AMT_m1</th>\n",
       "      <th>MRCH_HTL_TXN_CNT_m1</th>\n",
       "      <th>MRCH_HTL_TXN_AMT_m1</th>\n",
       "      <th>MRCH_LGS_TXN_CNT_m1</th>\n",
       "      <th>MRCH_LGS_TXN_AMT_m1</th>\n",
       "      <th>MRCH_MED_TXN_CNT_m1</th>\n",
       "      <th>MRCH_MED_TXN_AMT_m1</th>\n",
       "      <th>MRCH_MOT_TXN_CNT_m1</th>\n",
       "      <th>MRCH_MOT_TXN_AMT_m1</th>\n",
       "      <th>MRCH_MSCS_TXN_CNT_m1</th>\n",
       "      <th>MRCH_MSCS_TXN_AMT_m1</th>\n",
       "      <th>MRCH_PET_TXN_CNT_m1</th>\n",
       "      <th>MRCH_PET_TXN_AMT_m1</th>\n",
       "      <th>MRCH_RNTC_TXN_CNT_m1</th>\n",
       "      <th>MRCH_RNTC_TXN_AMT_m1</th>\n",
       "      <th>MRCH_SRV_TXN_CNT_m1</th>\n",
       "      <th>MRCH_SRV_TXN_AMT_m1</th>\n",
       "      <th>MRCH_TRV_TXN_CNT_m1</th>\n",
       "      <th>MRCH_TRV_TXN_AMT_m1</th>\n",
       "      <th>RUBR_CD_TXN_CNT_m1</th>\n",
       "      <th>RUBR_CD_TXN_AMT_m1</th>\n",
       "      <th>RUBR_CI_TXN_CNT_m1</th>\n",
       "      <th>RUBR_CI_TXN_AMT_m1</th>\n",
       "      <th>RUBR_CU_TXN_CNT_m1</th>\n",
       "      <th>RUBR_CU_TXN_AMT_m1</th>\n",
       "      <th>RUBR_PD_TXN_CNT_m1</th>\n",
       "      <th>RUBR_PD_TXN_AMT_m1</th>\n",
       "      <th>RUBR_PI_TXN_CNT_m1</th>\n",
       "      <th>RUBR_PI_TXN_AMT_m1</th>\n",
       "      <th>RUBR_PU_TXN_CNT_m1</th>\n",
       "      <th>RUBR_PU_TXN_AMT_m1</th>\n",
       "      <th>CH_CALLC_TXN_CNT_m1</th>\n",
       "      <th>CH_CALLC_TXN_AMT_m1</th>\n",
       "      <th>CH_ATM_TXN_CNT_m1</th>\n",
       "      <th>CH_ATM_TXN_AMT_m1</th>\n",
       "      <th>CH_INT_TXN_CNT_m1</th>\n",
       "      <th>CH_INT_TXN_AMT_m1</th>\n",
       "      <th>CH_SMS_TXN_CNT_m1</th>\n",
       "      <th>CH_SMS_TXN_AMT_m1</th>\n",
       "      <th>CH_BRN_TXN_CNT_m1</th>\n",
       "      <th>CH_BRN_TXN_AMT_m1</th>\n",
       "      <th>CH_DIRM_TXN_CNT_m1</th>\n",
       "      <th>CH_DIRM_TXN_AMT_m1</th>\n",
       "      <th>CH_POS_TXN_CNT_m1</th>\n",
       "      <th>CH_POS_TXN_AMT_m1</th>\n",
       "      <th>CC_TOT_TXN_CNT_m1</th>\n",
       "      <th>CC_TOT_TXN_AMT_m1</th>\n",
       "      <th>CL_TOT_TXN_CNT_m1</th>\n",
       "      <th>CL_TOT_TXN_AMT_m1</th>\n",
       "      <th>LEN_TOT_TXN_CNT_m1</th>\n",
       "      <th>LEN_TOT_TXN_AMT_m1</th>\n",
       "      <th>LM_TOT_TXN_CNT_m1</th>\n",
       "      <th>LM_TOT_TXN_AMT_m1</th>\n",
       "      <th>SA_TOT_TXN_CNT_m1</th>\n",
       "      <th>SA_TOT_TXN_AMT_m1</th>\n",
       "      <th>SLA_TOT_TXN_CNT_m1</th>\n",
       "      <th>SLA_TOT_TXN_AMT_m1</th>\n",
       "      <th>TD_TOT_TXN_CNT_m1</th>\n",
       "      <th>TD_TOT_TXN_AMT_m1</th>\n",
       "      <th>TOT_DB_TXN_CNT_m1</th>\n",
       "      <th>TOT_DB_TXN_AMT_m1</th>\n",
       "      <th>TOT_CR_TXN_CNT_m1</th>\n",
       "      <th>TOT_CR_TXN_AMT_m1</th>\n",
       "      <th>FIRST_OPEN_PRODUCT</th>\n",
       "      <th>FIRST_CLOSED_PRODUCT_6MTH</th>\n",
       "      <th>LAST_OPEN_PRODUCT</th>\n",
       "      <th>LAST_CLOSED_PRODUCT</th>\n",
       "      <th>ACCT_OPENED_CNT</th>\n",
       "      <th>ACCT_CLOSED_CNT</th>\n",
       "      <th>EARLY_REPAYMENT_LTD_FLG</th>\n",
       "      <th>ACCT_DEP_LTD_CNT</th>\n",
       "      <th>ACCT_CRE_LTD_CNT</th>\n",
       "      <th>CCREV_FLG_EVER</th>\n",
       "      <th>CCREV_FLG</th>\n",
       "      <th>CCWEB_FLG_EVER</th>\n",
       "      <th>CCWEB_FLG</th>\n",
       "      <th>DC_FLG_EVER</th>\n",
       "      <th>DC_FLG</th>\n",
       "      <th>OD_FLG_EVER</th>\n",
       "      <th>OD_FLG</th>\n",
       "      <th>ROL_FLG_EVER</th>\n",
       "      <th>SLA_FLG_EVER</th>\n",
       "      <th>SLA_FLG</th>\n",
       "      <th>CC_ACCT_OPENED_CNT</th>\n",
       "      <th>CC_ACCT_CLOSED_CNT</th>\n",
       "      <th>CC_MAX_TENURE_MTH</th>\n",
       "      <th>CC_MIN_TENURE_MTH</th>\n",
       "      <th>CC_MTH_SINCE_LAST_OPEN</th>\n",
       "      <th>CC_FLG_EVER</th>\n",
       "      <th>CC_FLG_m1</th>\n",
       "      <th>CC_ACCT_CNT_m1</th>\n",
       "      <th>CC_ACCT_OPEN_CNT_m1</th>\n",
       "      <th>CC_ACCT_CLOSE_CNT_m1</th>\n",
       "      <th>CL_ACCT_OPENED_CNT</th>\n",
       "      <th>CL_ACCT_CLOSED_CNT</th>\n",
       "      <th>CL_MATURITY_MTH</th>\n",
       "      <th>CL_MAX_TENURE_MTH</th>\n",
       "      <th>CL_MIN_TENURE_MTH</th>\n",
       "      <th>CL_MTH_SINCE_LAST_OPEN</th>\n",
       "      <th>CL_FLG_EVER</th>\n",
       "      <th>CL_FLG_m1</th>\n",
       "      <th>CL_ACCT_CNT_m1</th>\n",
       "      <th>CL_ACCT_OPEN_CNT_m1</th>\n",
       "      <th>CL_ACCT_CLOSE_CNT_m1</th>\n",
       "      <th>LEN_ACCT_OPENED_CNT</th>\n",
       "      <th>LEN_ACCT_CLOSED_CNT</th>\n",
       "      <th>LEN_MATURITY_MTH</th>\n",
       "      <th>LEN_MAX_TENURE_MTH</th>\n",
       "      <th>LEN_MIN_TENURE_MTH</th>\n",
       "      <th>LEN_MTH_SINCE_LAST_OPEN</th>\n",
       "      <th>LEN_FLG_EVER</th>\n",
       "      <th>LEN_FLG_m1</th>\n",
       "      <th>LEN_ACCT_CNT_m1</th>\n",
       "      <th>LEN_ACCT_OPEN_CNT_m1</th>\n",
       "      <th>LEN_ACCT_CLOSE_CNT_m1</th>\n",
       "      <th>LM_ACCT_OPENED_CNT</th>\n",
       "      <th>LM_ACCT_CLOSED_CNT</th>\n",
       "      <th>LM_MATURITY_MTH</th>\n",
       "      <th>LM_MAX_TENURE_MTH</th>\n",
       "      <th>LM_MIN_TENURE_MTH</th>\n",
       "      <th>LM_MTH_SINCE_LAST_OPEN</th>\n",
       "      <th>LM_FLG_EVER</th>\n",
       "      <th>LM_FLG_m1</th>\n",
       "      <th>LM_ACCT_CNT_m1</th>\n",
       "      <th>LM_ACCT_OPEN_CNT_m1</th>\n",
       "      <th>LM_ACCT_CLOSE_CNT_m1</th>\n",
       "      <th>SA_ACCT_OPENED_CNT</th>\n",
       "      <th>SA_ACCT_CLOSED_CNT</th>\n",
       "      <th>SA_MAX_TENURE_MTH</th>\n",
       "      <th>SA_MIN_TENURE_MTH</th>\n",
       "      <th>SA_MTH_SINCE_LAST_OPEN</th>\n",
       "      <th>SA_FLG_EVER</th>\n",
       "      <th>SA_FLG_m1</th>\n",
       "      <th>SA_ACCT_CNT_m1</th>\n",
       "      <th>SA_ACCT_OPEN_CNT_m1</th>\n",
       "      <th>SA_ACCT_CLOSE_CNT_m1</th>\n",
       "      <th>SLA_ACCT_OPENED_CNT</th>\n",
       "      <th>SLA_ACCT_CLOSED_CNT</th>\n",
       "      <th>SLA_MAX_TENURE_MTH</th>\n",
       "      <th>SLA_MIN_TENURE_MTH</th>\n",
       "      <th>SLA_MTH_SINCE_LAST_OPEN</th>\n",
       "      <th>SLA_FLG_m1</th>\n",
       "      <th>SLA_ACCT_CNT_m1</th>\n",
       "      <th>SLA_ACCT_OPEN_CNT_m1</th>\n",
       "      <th>SLA_ACCT_CLOSE_CNT_m1</th>\n",
       "      <th>TD_ACCT_OPENED_CNT</th>\n",
       "      <th>TD_ACCT_CLOSED_CNT</th>\n",
       "      <th>TD_MATURITY_MTH</th>\n",
       "      <th>TD_MAX_TENURE_MTH</th>\n",
       "      <th>TD_MIN_TENURE_MTH</th>\n",
       "      <th>TD_MTH_SINCE_LAST_OPEN</th>\n",
       "      <th>TD_FLG_EVER</th>\n",
       "      <th>TD_FLG_m1</th>\n",
       "      <th>TD_ACCT_CNT_m1</th>\n",
       "      <th>TD_ACCT_OPEN_CNT_m1</th>\n",
       "      <th>TD_ACCT_CLOSE_CNT_m1</th>\n",
       "      <th>PCK_ACCT_OPENED_CNT</th>\n",
       "      <th>PCK_ACCT_CLOSED_CNT</th>\n",
       "      <th>PCK_MAX_TENURE_MTH</th>\n",
       "      <th>PCK_MIN_TENURE_MTH</th>\n",
       "      <th>PCK_MTH_SINCE_LAST_OPEN</th>\n",
       "      <th>PCK_FLG_EVER</th>\n",
       "      <th>PCK_FLG_m1</th>\n",
       "      <th>PCK_ACCT_CNT_m1</th>\n",
       "      <th>PCK_ACCT_OPEN_CNT_m1</th>\n",
       "      <th>PCK_ACCT_CLOSE_CNT_m1</th>\n",
       "      <th>ACCT_CNT_m1</th>\n",
       "      <th>PD_MIX_EVER</th>\n",
       "      <th>OD_MATURITY</th>\n",
       "      <th>PROD_CNT_m1</th>\n",
       "      <th>DAYS_SINCE_LAST_ACCOUNT_OPEN</th>\n",
       "      <th>DAYS_SINCE_LAST_ACCOUNT_CLOSED</th>\n",
       "      <th>DAYS_SINCE_FIRST_ACCOUNT_OPEN</th>\n",
       "      <th>MATURITY_MTH</th>\n",
       "      <th>TENURE_MTH</th>\n",
       "      <th>MTH_SINCE_LAST_OPEN</th>\n",
       "      <th>CITY</th>\n",
       "      <th>MOBILE_FLG</th>\n",
       "      <th>EMAIL_FLG</th>\n",
       "      <th>IS_SEGMENT_CD</th>\n",
       "      <th>BRANCH_CD</th>\n",
       "      <th>REGION_CD</th>\n",
       "      <th>GEO_REGION_CD</th>\n",
       "      <th>AGE_AT_ANALYSIS_MTH_CNT</th>\n",
       "      <th>GENDER_CD</th>\n",
       "      <th>DC_MIX</th>\n",
       "      <th>CC_MIX</th>\n",
       "      <th>ROL_flg_m1</th>\n",
       "      <th>MOB_ACTIVE</th>\n",
       "      <th>BizSeg</th>\n",
       "      <th>CC_LIMIT_m1</th>\n",
       "      <th>month</th>\n",
       "      <th>month_od</th>\n",
       "      <th>month_do</th>\n",
       "      <th>mBanking_logs_m1</th>\n",
       "      <th>eBanking_logs_m1</th>\n",
       "      <th>MARITAL_STATUS</th>\n",
       "      <th>Education_level</th>\n",
       "      <th>RESIDENCE_STATUS</th>\n",
       "      <th>EMPLOYMENT_TYPE</th>\n",
       "      <th>LM_MATURITY_MTH_MISSING</th>\n",
       "      <th>LM_MTH_SINCE_LAST_OPEN_MISSING</th>\n",
       "      <th>TD_MATURITY_MTH_MISSING</th>\n",
       "      <th>TD_MTH_SINCE_LAST_OPEN_MISSING</th>\n",
       "      <th>OD_MATURITY_MISSING</th>\n",
       "      <th>LEN_MTH_SINCE_LAST_OPEN_MISSING</th>\n",
       "      <th>LEN_MATURITY_MTH_MISSING</th>\n",
       "      <th>CL_MTH_SINCE_LAST_OPEN_MISSING</th>\n",
       "      <th>CL_MATURITY_MTH_MISSING</th>\n",
       "      <th>DAYS_SINCE_LAST_ACCOUNT_CLOSED_MISSING</th>\n",
       "      <th>MATURITY_MTH_MISSING</th>\n",
       "      <th>BLACK_LIST_LEVEL_m1_MISSING</th>\n",
       "      <th>PCK_MTH_SINCE_LAST_OPEN_MISSING</th>\n",
       "      <th>SA_MTH_SINCE_LAST_OPEN_MISSING</th>\n",
       "      <th>CC_MIX_MISSING</th>\n",
       "      <th>DC_MIX_MISSING</th>\n",
       "      <th>CC_MTH_SINCE_LAST_OPEN_MISSING</th>\n",
       "      <th>SLA_MTH_SINCE_LAST_OPEN_MISSING</th>\n",
       "      <th>MARITAL_STATUS_MISSING</th>\n",
       "      <th>REGION_CD_MISSING</th>\n",
       "      <th>MOB_ACTIVE_MISSING</th>\n",
       "      <th>GENDER_CD_MISSING</th>\n",
       "      <th>AGE_AT_ANALYSIS_MTH_CNT_MISSING</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>LEN</td>\n",
       "      <td>0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>427759</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>12266.06</td>\n",
       "      <td>2</td>\n",
       "      <td>24532.12</td>\n",
       "      <td>-196248.36</td>\n",
       "      <td>196248.3603</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12281.125686</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>36798.18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3</td>\n",
       "      <td>36798.18</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1</td>\n",
       "      <td>12266.06</td>\n",
       "      <td>2</td>\n",
       "      <td>24532.12</td>\n",
       "      <td>LEN</td>\n",
       "      <td>XXX</td>\n",
       "      <td>LEN</td>\n",
       "      <td>XXX</td>\n",
       "      <td>1</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</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-1.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.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-1.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>16.0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-1.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.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.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.0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>-1.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.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>LEN</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>116</td>\n",
       "      <td>-1.0</td>\n",
       "      <td>116</td>\n",
       "      <td>16.0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>beograd-novi beograd</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>INDV</td>\n",
       "      <td>161</td>\n",
       "      <td>Grad</td>\n",
       "      <td>BEOGRAD 1</td>\n",
       "      <td>62.0</td>\n",
       "      <td>F</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Webovci</td>\n",
       "      <td>0</td>\n",
       "      <td>201506</td>\n",
       "      <td>201503</td>\n",
       "      <td>201609</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Married</td>\n",
       "      <td>2. Elementary School</td>\n",
       "      <td>Ownership</td>\n",
       "      <td>Unemployed</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>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</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>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  PD_MIX_ACTIVE_m1  BLACK_LIST_FLG_m1  BLACK_LIST_LEVEL_m1  LEASING_FLG_m1  \\\n",
       "0              LEN                  0                 -1.0               0   \n",
       "\n",
       "   RISK_BLOCKED_FLG_m1  CUSTOMER_RK  CC_DB_TXN_CNT_m1  CC_DB_TXN_AMT_m1  \\\n",
       "0                    0       427759                 0               0.0   \n",
       "\n",
       "   CC_CR_TXN_CNT_m1  CC_CR_TXN_AMT_m1  CC_EOM_BAL_AMT_m1  CC_AVG_BAL_AMT_m1  \\\n",
       "0                 0               0.0                0.0                0.0   \n",
       "\n",
       "   CC_ACC_USED_CNT_m1  CL_DB_TXN_CNT_m1  CL_DB_TXN_AMT_m1  CL_CR_TXN_CNT_m1  \\\n",
       "0                   0                 0               0.0                 0   \n",
       "\n",
       "   CL_CR_TXN_AMT_m1  CL_EOM_BAL_AMT_m1  CL_AVG_BAL_AMT_m1  CL_ACC_USED_CNT_m1  \\\n",
       "0               0.0                0.0                0.0                   0   \n",
       "\n",
       "   LEN_DB_TXN_CNT_m1  LEN_DB_TXN_AMT_m1  LEN_CR_TXN_CNT_m1  LEN_CR_TXN_AMT_m1  \\\n",
       "0                  1           12266.06                  2           24532.12   \n",
       "\n",
       "   LEN_EOM_BAL_AMT_m1  LEN_AVG_BAL_AMT_m1  LEN_ACC_USED_CNT_m1  \\\n",
       "0          -196248.36         196248.3603                    1   \n",
       "\n",
       "   LM_DB_TXN_CNT_m1  LM_DB_TXN_AMT_m1  LM_CR_TXN_CNT_m1  LM_CR_TXN_AMT_m1  \\\n",
       "0                 0               0.0                 0               0.0   \n",
       "\n",
       "   LM_EOM_BAL_AMT_m1  LM_AVG_BAL_AMT_m1  LM_ACC_USED_CNT_m1  SA_DB_TXN_CNT_m1  \\\n",
       "0                0.0                0.0                   0                 0   \n",
       "\n",
       "   SA_DB_TXN_AMT_m1  SA_CR_TXN_CNT_m1  SA_CR_TXN_AMT_m1  SA_EOM_BAL_AMT_m1  \\\n",
       "0               0.0                 0               0.0                0.0   \n",
       "\n",
       "   SA_AVG_BAL_AMT_m1  SA_ACC_USED_CNT_m1  SLA_DB_TXN_CNT_m1  \\\n",
       "0                0.0                   0                  0   \n",
       "\n",
       "   SLA_DB_TXN_AMT_m1  SLA_CR_TXN_CNT_m1  SLA_CR_TXN_AMT_m1  \\\n",
       "0                0.0                  0                0.0   \n",
       "\n",
       "   SLA_EOM_BAL_AMT_m1  SLA_AVG_BAL_AMT_m1  SLA_ACC_USED_CNT_m1  \\\n",
       "0                 0.0                 0.0                    0   \n",
       "\n",
       "   TD_DB_TXN_CNT_m1  TD_DB_TXN_AMT_m1  TD_CR_TXN_CNT_m1  TD_CR_TXN_AMT_m1  \\\n",
       "0                 0               0.0                 0               0.0   \n",
       "\n",
       "   TD_EOM_BAL_AMT_m1  TD_AVG_BAL_AMT_m1  TD_ACC_USED_CNT_m1  SSP_FLG_m1  \\\n",
       "0                0.0                0.0                   0           0   \n",
       "\n",
       "   PAST_DUE_AMT_m1  OD_LIMIT_m1  DAYS_PAST_DUE_m1  INCOME_AMT_m1  \\\n",
       "0     12281.125686          0.0                 6            0.0   \n",
       "\n",
       "   SLA_INCOME_AMT_m1  DEBIT_CARD_CNT_m1  NOSTRO_TXN_AMT_m1  LORO_TXN_AMT_m1  \\\n",
       "0                0.0                  0                0.0              0.0   \n",
       "\n",
       "   CHEQUE_TXN_CNT_m1  CHEQUE_TXN_AMT_m1  MRCH_AIR_TXN_CNT_m1  \\\n",
       "0                  0                0.0                    0   \n",
       "\n",
       "   MRCH_AIR_TXN_AMT_m1  MRCH_CASH_TXN_CNT_m1  MRCH_CASH_TXN_AMT_m1  \\\n",
       "0                  0.0                     0                   0.0   \n",
       "\n",
       "   MRCH_CHILD_TXN_CNT_m1  MRCH_CHILD_TXN_AMT_m1  MRCH_CLTH_TXN_CNT_m1  \\\n",
       "0                      0                    0.0                     0   \n",
       "\n",
       "   MRCH_CLTH_TXN_AMT_m1  MRCH_DEPST_TXN_CNT_m1  MRCH_DEPST_TXN_AMT_m1  \\\n",
       "0                   0.0                      0                    0.0   \n",
       "\n",
       "   MRCH_DIY_TXN_CNT_m1  MRCH_DIY_TXN_AMT_m1  MRCH_DRCTM_TXN_CNT_m1  \\\n",
       "0                    0                  0.0                      0   \n",
       "\n",
       "   MRCH_DRCTM_TXN_AMT_m1  MRCH_ENT_TXN_CNT_m1  MRCH_ENT_TXN_AMT_m1  \\\n",
       "0                    0.0                    0                  0.0   \n",
       "\n",
       "   MRCH_FOOD_TXN_CNT_m1  MRCH_FOOD_TXN_AMT_m1  MRCH_HTL_TXN_CNT_m1  \\\n",
       "0                     0                   0.0                    0   \n",
       "\n",
       "   MRCH_HTL_TXN_AMT_m1  MRCH_LGS_TXN_CNT_m1  MRCH_LGS_TXN_AMT_m1  \\\n",
       "0                  0.0                    0                  0.0   \n",
       "\n",
       "   MRCH_MED_TXN_CNT_m1  MRCH_MED_TXN_AMT_m1  MRCH_MOT_TXN_CNT_m1  \\\n",
       "0                    0                  0.0                    0   \n",
       "\n",
       "   MRCH_MOT_TXN_AMT_m1  MRCH_MSCS_TXN_CNT_m1  MRCH_MSCS_TXN_AMT_m1  \\\n",
       "0                  0.0                     0                   0.0   \n",
       "\n",
       "   MRCH_PET_TXN_CNT_m1  MRCH_PET_TXN_AMT_m1  MRCH_RNTC_TXN_CNT_m1  \\\n",
       "0                    0                  0.0                     0   \n",
       "\n",
       "   MRCH_RNTC_TXN_AMT_m1  MRCH_SRV_TXN_CNT_m1  MRCH_SRV_TXN_AMT_m1  \\\n",
       "0                   0.0                    0                  0.0   \n",
       "\n",
       "   MRCH_TRV_TXN_CNT_m1  MRCH_TRV_TXN_AMT_m1  RUBR_CD_TXN_CNT_m1  \\\n",
       "0                    0                  0.0                   0   \n",
       "\n",
       "   RUBR_CD_TXN_AMT_m1  RUBR_CI_TXN_CNT_m1  RUBR_CI_TXN_AMT_m1  \\\n",
       "0                 0.0                   0                 0.0   \n",
       "\n",
       "   RUBR_CU_TXN_CNT_m1  RUBR_CU_TXN_AMT_m1  RUBR_PD_TXN_CNT_m1  \\\n",
       "0                   0                 0.0                   0   \n",
       "\n",
       "   RUBR_PD_TXN_AMT_m1  RUBR_PI_TXN_CNT_m1  RUBR_PI_TXN_AMT_m1  \\\n",
       "0                 0.0                   0                 0.0   \n",
       "\n",
       "   RUBR_PU_TXN_CNT_m1  RUBR_PU_TXN_AMT_m1  CH_CALLC_TXN_CNT_m1  \\\n",
       "0                   0                 0.0                    0   \n",
       "\n",
       "   CH_CALLC_TXN_AMT_m1  CH_ATM_TXN_CNT_m1  CH_ATM_TXN_AMT_m1  \\\n",
       "0                    0                  0                0.0   \n",
       "\n",
       "   CH_INT_TXN_CNT_m1  CH_INT_TXN_AMT_m1  CH_SMS_TXN_CNT_m1  CH_SMS_TXN_AMT_m1  \\\n",
       "0                  0                0.0                  0                0.0   \n",
       "\n",
       "   CH_BRN_TXN_CNT_m1  CH_BRN_TXN_AMT_m1  CH_DIRM_TXN_CNT_m1  \\\n",
       "0                  3           36798.18                   0   \n",
       "\n",
       "   CH_DIRM_TXN_AMT_m1  CH_POS_TXN_CNT_m1  CH_POS_TXN_AMT_m1  \\\n",
       "0                   0                  0                0.0   \n",
       "\n",
       "   CC_TOT_TXN_CNT_m1  CC_TOT_TXN_AMT_m1  CL_TOT_TXN_CNT_m1  CL_TOT_TXN_AMT_m1  \\\n",
       "0                  0                0.0                  0                0.0   \n",
       "\n",
       "   LEN_TOT_TXN_CNT_m1  LEN_TOT_TXN_AMT_m1  LM_TOT_TXN_CNT_m1  \\\n",
       "0                   3            36798.18                  0   \n",
       "\n",
       "   LM_TOT_TXN_AMT_m1  SA_TOT_TXN_CNT_m1  SA_TOT_TXN_AMT_m1  \\\n",
       "0                0.0                  0                0.0   \n",
       "\n",
       "   SLA_TOT_TXN_CNT_m1  SLA_TOT_TXN_AMT_m1  TD_TOT_TXN_CNT_m1  \\\n",
       "0                   0                 0.0                  0   \n",
       "\n",
       "   TD_TOT_TXN_AMT_m1  TOT_DB_TXN_CNT_m1  TOT_DB_TXN_AMT_m1  TOT_CR_TXN_CNT_m1  \\\n",
       "0                0.0                  1           12266.06                  2   \n",
       "\n",
       "   TOT_CR_TXN_AMT_m1 FIRST_OPEN_PRODUCT FIRST_CLOSED_PRODUCT_6MTH  \\\n",
       "0           24532.12                LEN                       XXX   \n",
       "\n",
       "  LAST_OPEN_PRODUCT LAST_CLOSED_PRODUCT  ACCT_OPENED_CNT  ACCT_CLOSED_CNT  \\\n",
       "0               LEN                 XXX                1                0   \n",
       "\n",
       "   EARLY_REPAYMENT_LTD_FLG  ACCT_DEP_LTD_CNT  ACCT_CRE_LTD_CNT  \\\n",
       "0                        0                 0                 1   \n",
       "\n",
       "   CCREV_FLG_EVER  CCREV_FLG  CCWEB_FLG_EVER  CCWEB_FLG  DC_FLG_EVER  DC_FLG  \\\n",
       "0               0          0               0          0            0       0   \n",
       "\n",
       "   OD_FLG_EVER  OD_FLG  ROL_FLG_EVER  SLA_FLG_EVER  SLA_FLG  \\\n",
       "0            0       0             0             0        0   \n",
       "\n",
       "   CC_ACCT_OPENED_CNT  CC_ACCT_CLOSED_CNT  CC_MAX_TENURE_MTH  \\\n",
       "0                   0                   0                  0   \n",
       "\n",
       "   CC_MIN_TENURE_MTH  CC_MTH_SINCE_LAST_OPEN  CC_FLG_EVER  CC_FLG_m1  \\\n",
       "0                  0                    -1.0            0          0   \n",
       "\n",
       "   CC_ACCT_CNT_m1  CC_ACCT_OPEN_CNT_m1  CC_ACCT_CLOSE_CNT_m1  \\\n",
       "0               0                    0                     0   \n",
       "\n",
       "   CL_ACCT_OPENED_CNT  CL_ACCT_CLOSED_CNT  CL_MATURITY_MTH  CL_MAX_TENURE_MTH  \\\n",
       "0                   0                   0             -1.0                  0   \n",
       "\n",
       "   CL_MIN_TENURE_MTH  CL_MTH_SINCE_LAST_OPEN  CL_FLG_EVER  CL_FLG_m1  \\\n",
       "0                  0                    -1.0            0          0   \n",
       "\n",
       "   CL_ACCT_CNT_m1  CL_ACCT_OPEN_CNT_m1  CL_ACCT_CLOSE_CNT_m1  \\\n",
       "0               0                    0                     0   \n",
       "\n",
       "   LEN_ACCT_OPENED_CNT  LEN_ACCT_CLOSED_CNT  LEN_MATURITY_MTH  \\\n",
       "0                    1                    0              16.0   \n",
       "\n",
       "   LEN_MAX_TENURE_MTH  LEN_MIN_TENURE_MTH  LEN_MTH_SINCE_LAST_OPEN  \\\n",
       "0                   4                   4                      4.0   \n",
       "\n",
       "   LEN_FLG_EVER  LEN_FLG_m1  LEN_ACCT_CNT_m1  LEN_ACCT_OPEN_CNT_m1  \\\n",
       "0             1           1                1                     0   \n",
       "\n",
       "   LEN_ACCT_CLOSE_CNT_m1  LM_ACCT_OPENED_CNT  LM_ACCT_CLOSED_CNT  \\\n",
       "0                      0                   0                   0   \n",
       "\n",
       "   LM_MATURITY_MTH  LM_MAX_TENURE_MTH  LM_MIN_TENURE_MTH  \\\n",
       "0             -1.0                  0                  0   \n",
       "\n",
       "   LM_MTH_SINCE_LAST_OPEN  LM_FLG_EVER  LM_FLG_m1  LM_ACCT_CNT_m1  \\\n",
       "0                    -1.0            0          0               0   \n",
       "\n",
       "   LM_ACCT_OPEN_CNT_m1  LM_ACCT_CLOSE_CNT_m1  SA_ACCT_OPENED_CNT  \\\n",
       "0                    0                     0                   0   \n",
       "\n",
       "   SA_ACCT_CLOSED_CNT  SA_MAX_TENURE_MTH  SA_MIN_TENURE_MTH  \\\n",
       "0                   0                  0                  0   \n",
       "\n",
       "   SA_MTH_SINCE_LAST_OPEN  SA_FLG_EVER  SA_FLG_m1  SA_ACCT_CNT_m1  \\\n",
       "0                    -1.0            0          0               0   \n",
       "\n",
       "   SA_ACCT_OPEN_CNT_m1  SA_ACCT_CLOSE_CNT_m1  SLA_ACCT_OPENED_CNT  \\\n",
       "0                    0                     0                    0   \n",
       "\n",
       "   SLA_ACCT_CLOSED_CNT  SLA_MAX_TENURE_MTH  SLA_MIN_TENURE_MTH  \\\n",
       "0                    0                   0                   0   \n",
       "\n",
       "   SLA_MTH_SINCE_LAST_OPEN  SLA_FLG_m1  SLA_ACCT_CNT_m1  SLA_ACCT_OPEN_CNT_m1  \\\n",
       "0                     -1.0           0                0                     0   \n",
       "\n",
       "   SLA_ACCT_CLOSE_CNT_m1  TD_ACCT_OPENED_CNT  TD_ACCT_CLOSED_CNT  \\\n",
       "0                      0                   0                   0   \n",
       "\n",
       "   TD_MATURITY_MTH  TD_MAX_TENURE_MTH  TD_MIN_TENURE_MTH  \\\n",
       "0             -1.0                  0                  0   \n",
       "\n",
       "   TD_MTH_SINCE_LAST_OPEN  TD_FLG_EVER  TD_FLG_m1  TD_ACCT_CNT_m1  \\\n",
       "0                    -1.0            0          0               0   \n",
       "\n",
       "   TD_ACCT_OPEN_CNT_m1  TD_ACCT_CLOSE_CNT_m1  PCK_ACCT_OPENED_CNT  \\\n",
       "0                    0                     0                    0   \n",
       "\n",
       "   PCK_ACCT_CLOSED_CNT  PCK_MAX_TENURE_MTH  PCK_MIN_TENURE_MTH  \\\n",
       "0                    0                   0                   0   \n",
       "\n",
       "   PCK_MTH_SINCE_LAST_OPEN  PCK_FLG_EVER  PCK_FLG_m1  PCK_ACCT_CNT_m1  \\\n",
       "0                     -1.0             0           0                0   \n",
       "\n",
       "   PCK_ACCT_OPEN_CNT_m1  PCK_ACCT_CLOSE_CNT_m1  ACCT_CNT_m1 PD_MIX_EVER  \\\n",
       "0                     0                      0            1         LEN   \n",
       "\n",
       "   OD_MATURITY  PROD_CNT_m1  DAYS_SINCE_LAST_ACCOUNT_OPEN  \\\n",
       "0         -1.0            1                           116   \n",
       "\n",
       "   DAYS_SINCE_LAST_ACCOUNT_CLOSED  DAYS_SINCE_FIRST_ACCOUNT_OPEN  \\\n",
       "0                            -1.0                            116   \n",
       "\n",
       "   MATURITY_MTH  TENURE_MTH  MTH_SINCE_LAST_OPEN                  CITY  \\\n",
       "0          16.0           4                    4  beograd-novi beograd   \n",
       "\n",
       "   MOBILE_FLG  EMAIL_FLG IS_SEGMENT_CD  BRANCH_CD REGION_CD GEO_REGION_CD  \\\n",
       "0           0          0          INDV        161      Grad     BEOGRAD 1   \n",
       "\n",
       "   AGE_AT_ANALYSIS_MTH_CNT GENDER_CD   DC_MIX   CC_MIX  ROL_flg_m1  \\\n",
       "0                     62.0         F  Unknown  Unknown           0   \n",
       "\n",
       "   MOB_ACTIVE   BizSeg  CC_LIMIT_m1   month  month_od  month_do  \\\n",
       "0         4.0  Webovci            0  201506    201503    201609   \n",
       "\n",
       "   mBanking_logs_m1  eBanking_logs_m1 MARITAL_STATUS       Education_level  \\\n",
       "0                 0                 0        Married  2. Elementary School   \n",
       "\n",
       "  RESIDENCE_STATUS EMPLOYMENT_TYPE  LM_MATURITY_MTH_MISSING  \\\n",
       "0        Ownership      Unemployed                        1   \n",
       "\n",
       "   LM_MTH_SINCE_LAST_OPEN_MISSING  TD_MATURITY_MTH_MISSING  \\\n",
       "0                               1                        1   \n",
       "\n",
       "   TD_MTH_SINCE_LAST_OPEN_MISSING  OD_MATURITY_MISSING  \\\n",
       "0                               1                    1   \n",
       "\n",
       "   LEN_MTH_SINCE_LAST_OPEN_MISSING  LEN_MATURITY_MTH_MISSING  \\\n",
       "0                                0                         0   \n",
       "\n",
       "   CL_MTH_SINCE_LAST_OPEN_MISSING  CL_MATURITY_MTH_MISSING  \\\n",
       "0                               1                        1   \n",
       "\n",
       "   DAYS_SINCE_LAST_ACCOUNT_CLOSED_MISSING  MATURITY_MTH_MISSING  \\\n",
       "0                                       1                     0   \n",
       "\n",
       "   BLACK_LIST_LEVEL_m1_MISSING  PCK_MTH_SINCE_LAST_OPEN_MISSING  \\\n",
       "0                            1                                1   \n",
       "\n",
       "   SA_MTH_SINCE_LAST_OPEN_MISSING  CC_MIX_MISSING  DC_MIX_MISSING  \\\n",
       "0                               1               1               1   \n",
       "\n",
       "   CC_MTH_SINCE_LAST_OPEN_MISSING  SLA_MTH_SINCE_LAST_OPEN_MISSING  \\\n",
       "0                               1                                1   \n",
       "\n",
       "   MARITAL_STATUS_MISSING  REGION_CD_MISSING  MOB_ACTIVE_MISSING  \\\n",
       "0                       0                  0                   0   \n",
       "\n",
       "   GENDER_CD_MISSING  AGE_AT_ANALYSIS_MTH_CNT_MISSING  \n",
       "0                  0                                0  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Read and merge Consumer price indices\n",
    "\n",
    "Consumer price indices measure change of products and services prices that households purchase for satisfying own needs. They are used as inflation measure."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(153, 3)"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "indeksi = pd.read_csv('RFB - Potrosacke Cene Indeksi.csv')\n",
    "indeksi.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>Godinamesec</th>\n",
       "      <th>cpi_consumer</th>\n",
       "      <th>cpi_excluding</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>200701</td>\n",
       "      <td>5.5</td>\n",
       "      <td>0.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Godinamesec  cpi_consumer  cpi_excluding\n",
       "0       200701           5.5            0.1"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "indeksi.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Read and merge Cache Loan labels\n",
    "\n",
    "We engineered 3 new labels and whether the customer took out a loan in the first 3 months, the first 6 months or did not take out a loan in the first 6 months at all."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(79966, 2)"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zajam = pd.read_csv('RFB - Prvi Zajam.csv')\n",
    "zajam.shape"
   ]
  },
  {
   "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>CUSTOMER_RK</th>\n",
       "      <th>cash_loan</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>427759</td>\n",
       "      <td>nije u prvih 6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   CUSTOMER_RK       cash_loan\n",
       "0       427759  nije u prvih 6"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "zajam.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Read structure data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(164, 6)"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imovina = pd.read_csv('RFB - Strukturna Imovina.csv')\n",
    "imovina.grad = imovina.grad.str.lower()\n",
    "imovina.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "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>grad</th>\n",
       "      <th>F</th>\n",
       "      <th>P</th>\n",
       "      <th>R</th>\n",
       "      <th>broj_prijava</th>\n",
       "      <th>broj_obveznika</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>ada</td>\n",
       "      <td>20.788</td>\n",
       "      <td>618.0</td>\n",
       "      <td>773.0</td>\n",
       "      <td>17,862</td>\n",
       "      <td>10,456</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  grad       F      P      R broj_prijava broj_obveznika\n",
       "0  ada  20.788  618.0  773.0       17,862         10,456"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "imovina.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Merge loaded data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "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>CUSTOMER_RK</th>\n",
       "      <th>CITY</th>\n",
       "      <th>month</th>\n",
       "      <th>Godinamesec</th>\n",
       "      <th>cpi_consumer</th>\n",
       "      <th>cpi_excluding</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>427759</td>\n",
       "      <td>beograd-novi beograd</td>\n",
       "      <td>201506</td>\n",
       "      <td>201506</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>429594</td>\n",
       "      <td>beograd-zvezdara</td>\n",
       "      <td>201506</td>\n",
       "      <td>201506</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>436982</td>\n",
       "      <td>grocka</td>\n",
       "      <td>201506</td>\n",
       "      <td>201506</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>449995</td>\n",
       "      <td>beograd-voždovac</td>\n",
       "      <td>201506</td>\n",
       "      <td>201506</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>459189</td>\n",
       "      <td>pančevo</td>\n",
       "      <td>201506</td>\n",
       "      <td>201506</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   CUSTOMER_RK                  CITY   month  Godinamesec  cpi_consumer  \\\n",
       "0       427759  beograd-novi beograd  201506       201506           1.9   \n",
       "1       429594      beograd-zvezdara  201506       201506           1.9   \n",
       "2       436982                grocka  201506       201506           1.9   \n",
       "3       449995      beograd-voždovac  201506       201506           1.9   \n",
       "4       459189               pančevo  201506       201506           1.9   \n",
       "\n",
       "   cpi_excluding  \n",
       "0            0.6  \n",
       "1            0.6  \n",
       "2            0.6  \n",
       "3            0.6  \n",
       "4            0.6  "
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df.merge(indeksi, left_on='month', right_on='Godinamesec')\n",
    "df[['CUSTOMER_RK', 'CITY', 'month', 'Godinamesec', 'cpi_consumer', 'cpi_excluding']].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "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>CUSTOMER_RK</th>\n",
       "      <th>CITY</th>\n",
       "      <th>month</th>\n",
       "      <th>Godinamesec</th>\n",
       "      <th>cpi_consumer</th>\n",
       "      <th>cpi_excluding</th>\n",
       "      <th>cash_loan</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>427759</td>\n",
       "      <td>beograd-novi beograd</td>\n",
       "      <td>201506</td>\n",
       "      <td>201506</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.6</td>\n",
       "      <td>nije u prvih 6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>427759</td>\n",
       "      <td>beograd-novi beograd</td>\n",
       "      <td>201607</td>\n",
       "      <td>201607</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.5</td>\n",
       "      <td>nije u prvih 6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>427759</td>\n",
       "      <td>beograd-novi beograd</td>\n",
       "      <td>201505</td>\n",
       "      <td>201505</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.1</td>\n",
       "      <td>nije u prvih 6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>427759</td>\n",
       "      <td>beograd-novi beograd</td>\n",
       "      <td>201511</td>\n",
       "      <td>201511</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.3</td>\n",
       "      <td>nije u prvih 6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>427759</td>\n",
       "      <td>beograd-novi beograd</td>\n",
       "      <td>201608</td>\n",
       "      <td>201608</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.5</td>\n",
       "      <td>nije u prvih 6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   CUSTOMER_RK                  CITY   month  Godinamesec  cpi_consumer  \\\n",
       "0       427759  beograd-novi beograd  201506       201506           1.9   \n",
       "1       427759  beograd-novi beograd  201607       201607           1.2   \n",
       "2       427759  beograd-novi beograd  201505       201505           1.5   \n",
       "3       427759  beograd-novi beograd  201511       201511           1.3   \n",
       "4       427759  beograd-novi beograd  201608       201608           1.2   \n",
       "\n",
       "   cpi_excluding       cash_loan  \n",
       "0            0.6  nije u prvih 6  \n",
       "1            0.5  nije u prvih 6  \n",
       "2            0.1  nije u prvih 6  \n",
       "3            0.3  nije u prvih 6  \n",
       "4            0.5  nije u prvih 6  "
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df.merge(zajam, left_on='CUSTOMER_RK', right_on='CUSTOMER_RK')\n",
    "df[['CUSTOMER_RK', 'CITY', 'month', 'Godinamesec', 'cpi_consumer', 'cpi_excluding', 'cash_loan']].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "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>Godinamesec</th>\n",
       "      <th>cpi_consumer</th>\n",
       "      <th>cpi_excluding</th>\n",
       "      <th>cash_loan</th>\n",
       "      <th>CITY</th>\n",
       "      <th>grad</th>\n",
       "      <th>F</th>\n",
       "      <th>P</th>\n",
       "      <th>R</th>\n",
       "      <th>broj_prijava</th>\n",
       "      <th>broj_obveznika</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>201506</td>\n",
       "      <td>1.9</td>\n",
       "      <td>0.6</td>\n",
       "      <td>nije u prvih 6</td>\n",
       "      <td>beograd-novi beograd</td>\n",
       "      <td>beograd-novi beograd</td>\n",
       "      <td>163.517</td>\n",
       "      <td>18.304</td>\n",
       "      <td>6.614</td>\n",
       "      <td>122,769</td>\n",
       "      <td>100,725</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>201607</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.5</td>\n",
       "      <td>nije u prvih 6</td>\n",
       "      <td>beograd-novi beograd</td>\n",
       "      <td>beograd-novi beograd</td>\n",
       "      <td>163.517</td>\n",
       "      <td>18.304</td>\n",
       "      <td>6.614</td>\n",
       "      <td>122,769</td>\n",
       "      <td>100,725</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>201505</td>\n",
       "      <td>1.5</td>\n",
       "      <td>0.1</td>\n",
       "      <td>nije u prvih 6</td>\n",
       "      <td>beograd-novi beograd</td>\n",
       "      <td>beograd-novi beograd</td>\n",
       "      <td>163.517</td>\n",
       "      <td>18.304</td>\n",
       "      <td>6.614</td>\n",
       "      <td>122,769</td>\n",
       "      <td>100,725</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>201511</td>\n",
       "      <td>1.3</td>\n",
       "      <td>0.3</td>\n",
       "      <td>nije u prvih 6</td>\n",
       "      <td>beograd-novi beograd</td>\n",
       "      <td>beograd-novi beograd</td>\n",
       "      <td>163.517</td>\n",
       "      <td>18.304</td>\n",
       "      <td>6.614</td>\n",
       "      <td>122,769</td>\n",
       "      <td>100,725</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>201608</td>\n",
       "      <td>1.2</td>\n",
       "      <td>0.5</td>\n",
       "      <td>nije u prvih 6</td>\n",
       "      <td>beograd-novi beograd</td>\n",
       "      <td>beograd-novi beograd</td>\n",
       "      <td>163.517</td>\n",
       "      <td>18.304</td>\n",
       "      <td>6.614</td>\n",
       "      <td>122,769</td>\n",
       "      <td>100,725</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Godinamesec  cpi_consumer  cpi_excluding       cash_loan  \\\n",
       "0       201506           1.9            0.6  nije u prvih 6   \n",
       "1       201607           1.2            0.5  nije u prvih 6   \n",
       "2       201505           1.5            0.1  nije u prvih 6   \n",
       "3       201511           1.3            0.3  nije u prvih 6   \n",
       "4       201608           1.2            0.5  nije u prvih 6   \n",
       "\n",
       "                   CITY                  grad        F       P      R  \\\n",
       "0  beograd-novi beograd  beograd-novi beograd  163.517  18.304  6.614   \n",
       "1  beograd-novi beograd  beograd-novi beograd  163.517  18.304  6.614   \n",
       "2  beograd-novi beograd  beograd-novi beograd  163.517  18.304  6.614   \n",
       "3  beograd-novi beograd  beograd-novi beograd  163.517  18.304  6.614   \n",
       "4  beograd-novi beograd  beograd-novi beograd  163.517  18.304  6.614   \n",
       "\n",
       "  broj_prijava broj_obveznika  \n",
       "0      122,769        100,725  \n",
       "1      122,769        100,725  \n",
       "2      122,769        100,725  \n",
       "3      122,769        100,725  \n",
       "4      122,769        100,725  "
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df.merge(imovina, left_on='CITY', right_on='grad')\n",
    "df[['Godinamesec', 'cpi_consumer', 'cpi_excluding', 'cash_loan', 'CITY', 'grad', 'F', 'P', 'R', 'broj_prijava', 'broj_obveznika']].head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Save data for later usage"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('RFB - Merged Data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(555844, 316)"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "141"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df.CITY.unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create table for missing data analysis\n",
    "def draw_missing_data_table(df):\n",
    "    total = df.isnull().sum().sort_values(ascending=False)\n",
    "    percent = (df.isnull().sum()/df.isnull().count()).sort_values(ascending=False)\n",
    "    missing_data = pd.concat([total, percent], axis=1, keys=['Total', 'Percent'])\n",
    "    return missing_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "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>Total</th>\n",
       "      <th>Percent</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>broj_obveznika</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>RUBR_CU_TXN_AMT_m1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>MRCH_TRV_TXN_CNT_m1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>MRCH_TRV_TXN_AMT_m1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>RUBR_CD_TXN_CNT_m1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SA_MAX_TENURE_MTH</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SA_MIN_TENURE_MTH</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SA_MTH_SINCE_LAST_OPEN</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>SA_FLG_EVER</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>PD_MIX_ACTIVE_m1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>316 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Total  Percent\n",
       "broj_obveznika              0      0.0\n",
       "RUBR_CU_TXN_AMT_m1          0      0.0\n",
       "MRCH_TRV_TXN_CNT_m1         0      0.0\n",
       "MRCH_TRV_TXN_AMT_m1         0      0.0\n",
       "RUBR_CD_TXN_CNT_m1          0      0.0\n",
       "...                       ...      ...\n",
       "SA_MAX_TENURE_MTH           0      0.0\n",
       "SA_MIN_TENURE_MTH           0      0.0\n",
       "SA_MTH_SINCE_LAST_OPEN      0      0.0\n",
       "SA_FLG_EVER                 0      0.0\n",
       "PD_MIX_ACTIVE_m1            0      0.0\n",
       "\n",
       "[316 rows x 2 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "draw_missing_data_table(df)"
   ]
  },
  {
   "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.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}