golden-Copy1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/home/ekka/anaconda3/lib/python3.6/site-packages/IPython/core/interactiveshell.py:2717: DtypeWarning: Columns (19) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    }
   ],
   "source": [
    "train_data = pd.read_csv(\"./data/Training_dataset_Original.csv\")\n",
    "leaderboard_data = pd.read_csv(\"./data/Leaderboard_dataset.csv\")\n",
    "test_data = pd.read_csv(\"./data/Evaluation_dataset.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "train_data_original = train_data.copy()\n",
    "leaderboard_data_original = leaderboard_data.copy()\n",
    "test_data_original = test_data.copy()"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "'DataFrame' object has no attribute 'isna'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-4-7f7c70b80030>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mtest_data\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0misna\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msum\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m/home/ekka/anaconda3/lib/python3.6/site-packages/pandas/core/generic.py\u001b[0m in \u001b[0;36m__getattr__\u001b[0;34m(self, name)\u001b[0m\n\u001b[1;32m   2968\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mname\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_info_axis\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2969\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mname\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2970\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mobject\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m__getattribute__\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mname\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2971\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2972\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m__setattr__\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mname\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mAttributeError\u001b[0m: 'DataFrame' object has no attribute 'isna'"
     ]
    }
   ],
   "source": [
    "test_data.isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7fee9806f278>"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_data.plot(x = 'mvar1',y = 'mvar2')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7fee982359e8>"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_data.boxplot(column = \"mvar2\",by = \"default_ind\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "55439"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_data['mvar2'][train_data['default_ind'] == 0].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "bx = train_data.boxplot(column = 'mvar3',return_type = \"both\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "19872"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_data['mvar3'][train_data['mvar3'] > 6.447].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    61098.000000\n",
       "mean        69.981834\n",
       "std        300.080442\n",
       "min          0.000000\n",
       "25%          9.892500\n",
       "50%         40.440000\n",
       "75%         76.540000\n",
       "max      27867.400000\n",
       "Name: mvar24, dtype: float64"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_data['mvar24'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "4460"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_data['mvar21'][train_data['mvar21'] > 100].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "train_data['mvar1'] = pd.to_numeric(train_data['mvar1'], errors='coerce')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count    76361.000000\n",
       "mean      1745.971085\n",
       "std         94.537617\n",
       "min       1493.000000\n",
       "25%       1679.000000\n",
       "50%       1742.000000\n",
       "75%       1810.000000\n",
       "max       1950.000000\n",
       "Name: mvar1, dtype: float64"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_data['mvar1'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x7fee97fd7cf8>"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_data.boxplot(column = 'mvar1',by = 'default_ind')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "train_data['mvar6'] = pd.to_numeric(train_data['mvar6'], errors='coerce')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "count     61036.000000\n",
       "mean       1606.702372\n",
       "std        3703.654127\n",
       "min           0.000000\n",
       "25%          36.000000\n",
       "50%         297.000000\n",
       "75%        1343.250000\n",
       "max      136595.000000\n",
       "Name: mvar6, dtype: float64"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_data['mvar6'].describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "for column in train_data.columns:\n",
    "    if column != 'application_key':\n",
    "        train_data[column] = pd.to_numeric(train_data[column], errors='coerce')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>application_key</th>\n",
       "      <th>mvar1</th>\n",
       "      <th>mvar2</th>\n",
       "      <th>mvar3</th>\n",
       "      <th>mvar4</th>\n",
       "      <th>mvar5</th>\n",
       "      <th>mvar6</th>\n",
       "      <th>mvar7</th>\n",
       "      <th>mvar8</th>\n",
       "      <th>mvar9</th>\n",
       "      <th>...</th>\n",
       "      <th>mvar39</th>\n",
       "      <th>mvar40</th>\n",
       "      <th>mvar41</th>\n",
       "      <th>mvar42</th>\n",
       "      <th>mvar43</th>\n",
       "      <th>mvar44</th>\n",
       "      <th>mvar45</th>\n",
       "      <th>mvar46</th>\n",
       "      <th>mvar47</th>\n",
       "      <th>default_ind</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>80000.000000</td>\n",
       "      <td>76361.000000</td>\n",
       "      <td>74447.000000</td>\n",
       "      <td>79499.000000</td>\n",
       "      <td>79499.000000</td>\n",
       "      <td>79499.00000</td>\n",
       "      <td>61036.000000</td>\n",
       "      <td>7.260600e+04</td>\n",
       "      <td>61036.00000</td>\n",
       "      <td>6.859200e+04</td>\n",
       "      <td>...</td>\n",
       "      <td>73960.000000</td>\n",
       "      <td>17443.000000</td>\n",
       "      <td>25422.000000</td>\n",
       "      <td>78099.000000</td>\n",
       "      <td>79182.000000</td>\n",
       "      <td>72255.000000</td>\n",
       "      <td>35145.000000</td>\n",
       "      <td>57211.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>80000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>270031.500000</td>\n",
       "      <td>1745.971085</td>\n",
       "      <td>1.105629</td>\n",
       "      <td>5.280955</td>\n",
       "      <td>0.474516</td>\n",
       "      <td>1.12472</td>\n",
       "      <td>1606.702372</td>\n",
       "      <td>1.759581e+04</td>\n",
       "      <td>6773.68666</td>\n",
       "      <td>3.409744e+04</td>\n",
       "      <td>...</td>\n",
       "      <td>0.090819</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.335142</td>\n",
       "      <td>6.552777</td>\n",
       "      <td>0.705285</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.096135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.246213</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>23094.155105</td>\n",
       "      <td>94.537617</td>\n",
       "      <td>1.645299</td>\n",
       "      <td>10.815463</td>\n",
       "      <td>1.796261</td>\n",
       "      <td>5.99545</td>\n",
       "      <td>3703.654127</td>\n",
       "      <td>4.708164e+04</td>\n",
       "      <td>10127.74526</td>\n",
       "      <td>5.337692e+04</td>\n",
       "      <td>...</td>\n",
       "      <td>0.419301</td>\n",
       "      <td>29.762399</td>\n",
       "      <td>24.442156</td>\n",
       "      <td>0.375656</td>\n",
       "      <td>6.311087</td>\n",
       "      <td>0.245879</td>\n",
       "      <td>0.287365</td>\n",
       "      <td>0.346109</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.430806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>230032.000000</td>\n",
       "      <td>1493.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.014000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.060660</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>250031.750000</td>\n",
       "      <td>1679.000000</td>\n",
       "      <td>0.140100</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>36.000000</td>\n",
       "      <td>1.756000e+03</td>\n",
       "      <td>490.00000</td>\n",
       "      <td>3.498000e+03</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>90.689000</td>\n",
       "      <td>58.153000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.515220</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>270031.500000</td>\n",
       "      <td>1742.000000</td>\n",
       "      <td>0.538900</td>\n",
       "      <td>0.300000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>297.000000</td>\n",
       "      <td>6.967000e+03</td>\n",
       "      <td>2478.00000</td>\n",
       "      <td>1.417100e+04</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>78.883500</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.737030</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>290031.250000</td>\n",
       "      <td>1810.000000</td>\n",
       "      <td>1.445050</td>\n",
       "      <td>6.447000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>1343.250000</td>\n",
       "      <td>1.805575e+04</td>\n",
       "      <td>9684.25000</td>\n",
       "      <td>4.385375e+04</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>111.698000</td>\n",
       "      <td>91.639750</td>\n",
       "      <td>0.571430</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>0.943475</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>310031.000000</td>\n",
       "      <td>1950.000000</td>\n",
       "      <td>44.630100</td>\n",
       "      <td>286.858000</td>\n",
       "      <td>114.696000</td>\n",
       "      <td>226.52700</td>\n",
       "      <td>136595.000000</td>\n",
       "      <td>5.549600e+06</td>\n",
       "      <td>291810.00000</td>\n",
       "      <td>3.711880e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>21.000000</td>\n",
       "      <td>430.300000</td>\n",
       "      <td>170.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>91.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>19.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 49 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       application_key         mvar1         mvar2         mvar3  \\\n",
       "count     80000.000000  76361.000000  74447.000000  79499.000000   \n",
       "mean     270031.500000   1745.971085      1.105629      5.280955   \n",
       "std       23094.155105     94.537617      1.645299     10.815463   \n",
       "min      230032.000000   1493.000000      0.000000      0.000000   \n",
       "25%      250031.750000   1679.000000      0.140100      0.000000   \n",
       "50%      270031.500000   1742.000000      0.538900      0.300000   \n",
       "75%      290031.250000   1810.000000      1.445050      6.447000   \n",
       "max      310031.000000   1950.000000     44.630100    286.858000   \n",
       "\n",
       "              mvar4        mvar5          mvar6         mvar7         mvar8  \\\n",
       "count  79499.000000  79499.00000   61036.000000  7.260600e+04   61036.00000   \n",
       "mean       0.474516      1.12472    1606.702372  1.759581e+04    6773.68666   \n",
       "std        1.796261      5.99545    3703.654127  4.708164e+04   10127.74526   \n",
       "min        0.000000      0.00000       0.000000  0.000000e+00       0.00000   \n",
       "25%        0.000000      0.00000      36.000000  1.756000e+03     490.00000   \n",
       "50%        0.000000      0.00000     297.000000  6.967000e+03    2478.00000   \n",
       "75%        0.000000      0.00000    1343.250000  1.805575e+04    9684.25000   \n",
       "max      114.696000    226.52700  136595.000000  5.549600e+06  291810.00000   \n",
       "\n",
       "              mvar9      ...             mvar39        mvar40        mvar41  \\\n",
       "count  6.859200e+04      ...       73960.000000  17443.000000  25422.000000   \n",
       "mean   3.409744e+04      ...           0.090819     98.497452     72.096758   \n",
       "std    5.337692e+04      ...           0.419301     29.762399     24.442156   \n",
       "min    0.000000e+00      ...           0.000000      0.014000      0.000000   \n",
       "25%    3.498000e+03      ...           0.000000     90.689000     58.153000   \n",
       "50%    1.417100e+04      ...           0.000000    100.000000     78.883500   \n",
       "75%    4.385375e+04      ...           0.000000    111.698000     91.639750   \n",
       "max    3.711880e+06      ...          21.000000    430.300000    170.000000   \n",
       "\n",
       "             mvar42        mvar43        mvar44        mvar45        mvar46  \\\n",
       "count  78099.000000  79182.000000  72255.000000  35145.000000  57211.000000   \n",
       "mean       0.335142      6.552777      0.705285      0.070736      0.096135   \n",
       "std        0.375656      6.311087      0.245879      0.287365      0.346109   \n",
       "min        0.000000      0.000000      0.060660      0.000000      0.000000   \n",
       "25%        0.000000      2.000000      0.515220      0.000000      0.000000   \n",
       "50%        0.200000      5.000000      0.737030      0.000000      0.000000   \n",
       "75%        0.571430     10.000000      0.943475      0.000000      0.000000   \n",
       "max        2.000000     91.000000      1.000000      5.000000     19.000000   \n",
       "\n",
       "       mvar47   default_ind  \n",
       "count     0.0  80000.000000  \n",
       "mean      NaN      0.246213  \n",
       "std       NaN      0.430806  \n",
       "min       NaN      0.000000  \n",
       "25%       NaN      0.000000  \n",
       "50%       NaN      0.000000  \n",
       "75%       NaN      0.000000  \n",
       "max       NaN      1.000000  \n",
       "\n",
       "[8 rows x 49 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_data.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 164,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "application_key        0\n",
       "mvar1               3639\n",
       "mvar2               5553\n",
       "mvar3                501\n",
       "mvar4                501\n",
       "mvar5                501\n",
       "mvar6              18964\n",
       "mvar7               7394\n",
       "mvar8              18964\n",
       "mvar9              11408\n",
       "mvar10               502\n",
       "mvar11             44819\n",
       "mvar12             14078\n",
       "mvar13              8352\n",
       "mvar14                 0\n",
       "mvar15             32067\n",
       "mvar16             18510\n",
       "mvar17             15846\n",
       "mvar18             14771\n",
       "mvar19                 4\n",
       "mvar20               502\n",
       "mvar21             22561\n",
       "mvar22             29124\n",
       "mvar23             40248\n",
       "mvar24             18902\n",
       "mvar25              7706\n",
       "mvar26             10610\n",
       "mvar27             13209\n",
       "mvar28               502\n",
       "mvar29               502\n",
       "mvar30             36417\n",
       "mvar31             56218\n",
       "mvar32              7706\n",
       "mvar33              1751\n",
       "mvar34               502\n",
       "mvar35             33014\n",
       "mvar36              2898\n",
       "mvar37              7706\n",
       "mvar38               502\n",
       "mvar39              6040\n",
       "mvar40             62557\n",
       "mvar41             54578\n",
       "mvar42              1901\n",
       "mvar43               818\n",
       "mvar44              7745\n",
       "mvar45             44855\n",
       "mvar46             22789\n",
       "mvar47             80000\n",
       "default_ind            0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 164,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_data.isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>application_key</th>\n",
       "      <th>mvar1</th>\n",
       "      <th>mvar2</th>\n",
       "      <th>mvar3</th>\n",
       "      <th>mvar4</th>\n",
       "      <th>mvar5</th>\n",
       "      <th>mvar6</th>\n",
       "      <th>mvar7</th>\n",
       "      <th>mvar8</th>\n",
       "      <th>mvar9</th>\n",
       "      <th>...</th>\n",
       "      <th>mvar39</th>\n",
       "      <th>mvar40</th>\n",
       "      <th>mvar41</th>\n",
       "      <th>mvar42</th>\n",
       "      <th>mvar43</th>\n",
       "      <th>mvar44</th>\n",
       "      <th>mvar45</th>\n",
       "      <th>mvar46</th>\n",
       "      <th>mvar47</th>\n",
       "      <th>default_ind</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>230032</td>\n",
       "      <td>1696.000000</td>\n",
       "      <td>1.654100</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6015.000000</td>\n",
       "      <td>322.00000</td>\n",
       "      <td>40369.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>73.780000</td>\n",
       "      <td>82.547000</td>\n",
       "      <td>0.086960</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>0.638990</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>230033</td>\n",
       "      <td>1846.000000</td>\n",
       "      <td>0.809500</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>102.000000</td>\n",
       "      <td>7532.000000</td>\n",
       "      <td>3171.00000</td>\n",
       "      <td>18234.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>99.129000</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>0.638360</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.096135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>230034</td>\n",
       "      <td>1745.000000</td>\n",
       "      <td>0.400100</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>1606.702372</td>\n",
       "      <td>2536.000000</td>\n",
       "      <td>6773.68666</td>\n",
       "      <td>34097.436013</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>29.290000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>230035</td>\n",
       "      <td>1739.000000</td>\n",
       "      <td>0.219300</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>1982.000000</td>\n",
       "      <td>26440.000000</td>\n",
       "      <td>4955.00000</td>\n",
       "      <td>20316.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>96.272000</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.153850</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>0.532410</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>230036</td>\n",
       "      <td>1787.000000</td>\n",
       "      <td>0.011800</td>\n",
       "      <td>0.225000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>5451.000000</td>\n",
       "      <td>5494.000000</td>\n",
       "      <td>5494.00000</td>\n",
       "      <td>7987.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>115.019000</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.926650</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.096135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>230037</td>\n",
       "      <td>1579.000000</td>\n",
       "      <td>1.105629</td>\n",
       "      <td>3.502000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>1606.702372</td>\n",
       "      <td>17595.807537</td>\n",
       "      <td>6773.68666</td>\n",
       "      <td>34097.436013</td>\n",
       "      <td>...</td>\n",
       "      <td>0.090819</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.705285</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.096135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>230038</td>\n",
       "      <td>1818.000000</td>\n",
       "      <td>0.400100</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>1606.702372</td>\n",
       "      <td>1088.000000</td>\n",
       "      <td>6773.68666</td>\n",
       "      <td>1536.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>88.171000</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.872240</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>230039</td>\n",
       "      <td>1745.971085</td>\n",
       "      <td>1.105629</td>\n",
       "      <td>5.280955</td>\n",
       "      <td>0.474516</td>\n",
       "      <td>1.12472</td>\n",
       "      <td>1606.702372</td>\n",
       "      <td>17595.807537</td>\n",
       "      <td>6773.68666</td>\n",
       "      <td>34097.436013</td>\n",
       "      <td>...</td>\n",
       "      <td>0.090819</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.335142</td>\n",
       "      <td>6.552777</td>\n",
       "      <td>0.705285</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.096135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>230040</td>\n",
       "      <td>1836.000000</td>\n",
       "      <td>0.135800</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>347.000000</td>\n",
       "      <td>38964.000000</td>\n",
       "      <td>17828.00000</td>\n",
       "      <td>70729.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>0.898680</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>230041</td>\n",
       "      <td>1839.000000</td>\n",
       "      <td>0.198100</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>793.000000</td>\n",
       "      <td>6131.000000</td>\n",
       "      <td>6045.00000</td>\n",
       "      <td>48959.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>45.590000</td>\n",
       "      <td>0.088240</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>0.338340</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>230042</td>\n",
       "      <td>1903.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>22.000000</td>\n",
       "      <td>19518.000000</td>\n",
       "      <td>9910.00000</td>\n",
       "      <td>90618.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>0.806200</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>230043</td>\n",
       "      <td>1681.000000</td>\n",
       "      <td>1.588800</td>\n",
       "      <td>5.685000</td>\n",
       "      <td>3.566000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>93.000000</td>\n",
       "      <td>3554.000000</td>\n",
       "      <td>439.00000</td>\n",
       "      <td>2527.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.611110</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>0.811720</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>230044</td>\n",
       "      <td>1841.000000</td>\n",
       "      <td>0.538800</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>1487.000000</td>\n",
       "      <td>19449.000000</td>\n",
       "      <td>19449.00000</td>\n",
       "      <td>6739.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.980310</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.096135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>230045</td>\n",
       "      <td>1794.000000</td>\n",
       "      <td>1.968400</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>856.000000</td>\n",
       "      <td>8609.000000</td>\n",
       "      <td>8609.00000</td>\n",
       "      <td>60545.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>0.357240</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>230046</td>\n",
       "      <td>1669.000000</td>\n",
       "      <td>3.855800</td>\n",
       "      <td>18.465000</td>\n",
       "      <td>6.292000</td>\n",
       "      <td>1.20000</td>\n",
       "      <td>1606.702372</td>\n",
       "      <td>142.000000</td>\n",
       "      <td>6773.68666</td>\n",
       "      <td>38.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>107.825000</td>\n",
       "      <td>98.664000</td>\n",
       "      <td>0.560000</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>0.291690</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>230047</td>\n",
       "      <td>1583.000000</td>\n",
       "      <td>3.028400</td>\n",
       "      <td>16.325000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>1606.702372</td>\n",
       "      <td>17595.807537</td>\n",
       "      <td>6773.68666</td>\n",
       "      <td>51450.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.323530</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.705285</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.096135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>230048</td>\n",
       "      <td>1899.000000</td>\n",
       "      <td>0.097000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>1015.000000</td>\n",
       "      <td>13379.000000</td>\n",
       "      <td>13379.00000</td>\n",
       "      <td>246906.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.384000</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>19.000000</td>\n",
       "      <td>0.474800</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>230049</td>\n",
       "      <td>1690.000000</td>\n",
       "      <td>8.774700</td>\n",
       "      <td>10.437000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>122.000000</td>\n",
       "      <td>623.000000</td>\n",
       "      <td>299.00000</td>\n",
       "      <td>1140.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.636360</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.949510</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>230050</td>\n",
       "      <td>1599.000000</td>\n",
       "      <td>0.860100</td>\n",
       "      <td>1.525000</td>\n",
       "      <td>1.525000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>1606.702372</td>\n",
       "      <td>878.000000</td>\n",
       "      <td>6773.68666</td>\n",
       "      <td>34097.436013</td>\n",
       "      <td>...</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>91.175000</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>230051</td>\n",
       "      <td>1859.000000</td>\n",
       "      <td>0.015500</td>\n",
       "      <td>0.368000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>424.000000</td>\n",
       "      <td>86509.000000</td>\n",
       "      <td>12451.00000</td>\n",
       "      <td>86635.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>0.347300</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>230052</td>\n",
       "      <td>1880.000000</td>\n",
       "      <td>2.610100</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>19252.000000</td>\n",
       "      <td>6342.00000</td>\n",
       "      <td>59601.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.497000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>0.287080</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>230053</td>\n",
       "      <td>1852.000000</td>\n",
       "      <td>3.620100</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>799.000000</td>\n",
       "      <td>16515.000000</td>\n",
       "      <td>16515.00000</td>\n",
       "      <td>110651.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>0.753490</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.096135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>230054</td>\n",
       "      <td>1655.000000</td>\n",
       "      <td>3.026800</td>\n",
       "      <td>14.748000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>48.000000</td>\n",
       "      <td>48.000000</td>\n",
       "      <td>48.00000</td>\n",
       "      <td>198.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.096135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>230055</td>\n",
       "      <td>1863.000000</td>\n",
       "      <td>0.040100</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>1487.000000</td>\n",
       "      <td>4955.000000</td>\n",
       "      <td>4955.00000</td>\n",
       "      <td>22902.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>96.895000</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>0.408530</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>230056</td>\n",
       "      <td>1753.000000</td>\n",
       "      <td>0.225100</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>1124.000000</td>\n",
       "      <td>1124.000000</td>\n",
       "      <td>1124.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.335142</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.096135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>230057</td>\n",
       "      <td>1894.000000</td>\n",
       "      <td>0.031800</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>4655.000000</td>\n",
       "      <td>7433.000000</td>\n",
       "      <td>7433.00000</td>\n",
       "      <td>25667.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>0.994190</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>230058</td>\n",
       "      <td>1803.000000</td>\n",
       "      <td>0.399300</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>496.000000</td>\n",
       "      <td>10505.000000</td>\n",
       "      <td>496.00000</td>\n",
       "      <td>991.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>91.752000</td>\n",
       "      <td>87.306000</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.752890</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>230059</td>\n",
       "      <td>1932.000000</td>\n",
       "      <td>0.327600</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>6982.000000</td>\n",
       "      <td>21569.000000</td>\n",
       "      <td>18829.00000</td>\n",
       "      <td>187209.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>0.997100</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>230060</td>\n",
       "      <td>1714.000000</td>\n",
       "      <td>5.190400</td>\n",
       "      <td>0.770000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1889.000000</td>\n",
       "      <td>595.00000</td>\n",
       "      <td>12574.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.357140</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.850820</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>230061</td>\n",
       "      <td>1745.971085</td>\n",
       "      <td>2.045700</td>\n",
       "      <td>4.514000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>1606.702372</td>\n",
       "      <td>17595.807537</td>\n",
       "      <td>6773.68666</td>\n",
       "      <td>34097.436013</td>\n",
       "      <td>...</td>\n",
       "      <td>0.090819</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>1.166670</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.705285</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.096135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79970</th>\n",
       "      <td>310002</td>\n",
       "      <td>1834.000000</td>\n",
       "      <td>1.216400</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>2212.000000</td>\n",
       "      <td>5244.000000</td>\n",
       "      <td>4203.00000</td>\n",
       "      <td>16743.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>97.398000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>0.580400</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79971</th>\n",
       "      <td>310003</td>\n",
       "      <td>1729.000000</td>\n",
       "      <td>1.369600</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>356.000000</td>\n",
       "      <td>4218.000000</td>\n",
       "      <td>1982.00000</td>\n",
       "      <td>18657.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>83.663000</td>\n",
       "      <td>0.090910</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.626320</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79972</th>\n",
       "      <td>310004</td>\n",
       "      <td>1753.000000</td>\n",
       "      <td>5.828300</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>180.000000</td>\n",
       "      <td>4014.000000</td>\n",
       "      <td>617.00000</td>\n",
       "      <td>3667.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>87.094000</td>\n",
       "      <td>0.111110</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>0.593640</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79973</th>\n",
       "      <td>310005</td>\n",
       "      <td>1748.000000</td>\n",
       "      <td>1.963500</td>\n",
       "      <td>0.642000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>291.000000</td>\n",
       "      <td>3469.000000</td>\n",
       "      <td>3469.00000</td>\n",
       "      <td>13131.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>92.244000</td>\n",
       "      <td>0.440000</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>0.838090</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79974</th>\n",
       "      <td>310006</td>\n",
       "      <td>1771.000000</td>\n",
       "      <td>1.758800</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>66.000000</td>\n",
       "      <td>12626.000000</td>\n",
       "      <td>6433.00000</td>\n",
       "      <td>27946.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>40.477000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>0.468630</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79975</th>\n",
       "      <td>310007</td>\n",
       "      <td>1766.000000</td>\n",
       "      <td>0.954000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>1140.000000</td>\n",
       "      <td>10207.000000</td>\n",
       "      <td>10207.00000</td>\n",
       "      <td>55001.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.050000</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>0.547540</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.096135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79976</th>\n",
       "      <td>310008</td>\n",
       "      <td>1822.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.853000</td>\n",
       "      <td>1.853000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>2581.000000</td>\n",
       "      <td>13361.000000</td>\n",
       "      <td>5946.00000</td>\n",
       "      <td>31018.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>73.611000</td>\n",
       "      <td>44.656000</td>\n",
       "      <td>0.034480</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>0.231770</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79977</th>\n",
       "      <td>310009</td>\n",
       "      <td>1824.000000</td>\n",
       "      <td>0.563400</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>3964.000000</td>\n",
       "      <td>4683.000000</td>\n",
       "      <td>4683.00000</td>\n",
       "      <td>34097.436013</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.335142</td>\n",
       "      <td>6.552777</td>\n",
       "      <td>0.672220</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.096135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79978</th>\n",
       "      <td>310010</td>\n",
       "      <td>1914.000000</td>\n",
       "      <td>0.054400</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>3469.000000</td>\n",
       "      <td>20424.000000</td>\n",
       "      <td>20424.00000</td>\n",
       "      <td>78774.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79979</th>\n",
       "      <td>310011</td>\n",
       "      <td>1600.000000</td>\n",
       "      <td>2.664900</td>\n",
       "      <td>18.282000</td>\n",
       "      <td>1.078000</td>\n",
       "      <td>2.67800</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7205.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>956.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>132.335000</td>\n",
       "      <td>56.867000</td>\n",
       "      <td>0.552630</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>0.117630</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79980</th>\n",
       "      <td>310012</td>\n",
       "      <td>1822.000000</td>\n",
       "      <td>0.585100</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>23685.000000</td>\n",
       "      <td>23685.00000</td>\n",
       "      <td>208174.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>17.000000</td>\n",
       "      <td>0.814380</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.096135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79981</th>\n",
       "      <td>310013</td>\n",
       "      <td>1693.000000</td>\n",
       "      <td>0.182800</td>\n",
       "      <td>17.767000</td>\n",
       "      <td>2.024000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>114.000000</td>\n",
       "      <td>27514.000000</td>\n",
       "      <td>384.00000</td>\n",
       "      <td>2329.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>74.814000</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.178570</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.533400</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79982</th>\n",
       "      <td>310014</td>\n",
       "      <td>1735.000000</td>\n",
       "      <td>3.170100</td>\n",
       "      <td>0.260000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>117.000000</td>\n",
       "      <td>892.000000</td>\n",
       "      <td>117.00000</td>\n",
       "      <td>3766.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>99.026000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.967470</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79983</th>\n",
       "      <td>310015</td>\n",
       "      <td>1671.000000</td>\n",
       "      <td>0.138000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>1606.702372</td>\n",
       "      <td>491.000000</td>\n",
       "      <td>6773.68666</td>\n",
       "      <td>34097.436013</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.096135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79984</th>\n",
       "      <td>310016</td>\n",
       "      <td>1924.000000</td>\n",
       "      <td>0.122100</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>2478.000000</td>\n",
       "      <td>266683.000000</td>\n",
       "      <td>266683.00000</td>\n",
       "      <td>405300.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>70.799000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>0.753220</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79985</th>\n",
       "      <td>310017</td>\n",
       "      <td>1670.000000</td>\n",
       "      <td>0.034700</td>\n",
       "      <td>9.836000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>212.000000</td>\n",
       "      <td>7848.000000</td>\n",
       "      <td>491.00000</td>\n",
       "      <td>29785.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>78.700000</td>\n",
       "      <td>0.136360</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>0.857710</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79986</th>\n",
       "      <td>310018</td>\n",
       "      <td>1901.000000</td>\n",
       "      <td>0.178200</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>4955.000000</td>\n",
       "      <td>21753.000000</td>\n",
       "      <td>12673.00000</td>\n",
       "      <td>70293.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>61.301000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>0.863560</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79987</th>\n",
       "      <td>310019</td>\n",
       "      <td>1835.000000</td>\n",
       "      <td>0.537200</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>29723.000000</td>\n",
       "      <td>3964.00000</td>\n",
       "      <td>66770.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>0.416850</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79988</th>\n",
       "      <td>310020</td>\n",
       "      <td>1927.000000</td>\n",
       "      <td>0.041000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>22000.000000</td>\n",
       "      <td>30046.000000</td>\n",
       "      <td>24165.00000</td>\n",
       "      <td>75019.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>19.444000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>0.537500</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79989</th>\n",
       "      <td>310021</td>\n",
       "      <td>1745.971085</td>\n",
       "      <td>0.145100</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>1606.702372</td>\n",
       "      <td>17595.807537</td>\n",
       "      <td>6773.68666</td>\n",
       "      <td>34097.436013</td>\n",
       "      <td>...</td>\n",
       "      <td>0.090819</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.705285</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.096135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79990</th>\n",
       "      <td>310022</td>\n",
       "      <td>1941.000000</td>\n",
       "      <td>0.483400</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>10846.000000</td>\n",
       "      <td>52806.000000</td>\n",
       "      <td>35478.00000</td>\n",
       "      <td>136461.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.058820</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>0.841700</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79991</th>\n",
       "      <td>310023</td>\n",
       "      <td>1899.000000</td>\n",
       "      <td>1.105629</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>7310.000000</td>\n",
       "      <td>14519.000000</td>\n",
       "      <td>14519.00000</td>\n",
       "      <td>5252.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>0.446150</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.096135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79992</th>\n",
       "      <td>310024</td>\n",
       "      <td>1761.000000</td>\n",
       "      <td>2.099900</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>47.000000</td>\n",
       "      <td>13477.000000</td>\n",
       "      <td>1814.00000</td>\n",
       "      <td>9320.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.125000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.736400</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79993</th>\n",
       "      <td>310025</td>\n",
       "      <td>1700.000000</td>\n",
       "      <td>0.383100</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>344.000000</td>\n",
       "      <td>344.000000</td>\n",
       "      <td>344.00000</td>\n",
       "      <td>991.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.666670</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.973740</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79994</th>\n",
       "      <td>310026</td>\n",
       "      <td>1910.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>4955.000000</td>\n",
       "      <td>47306.000000</td>\n",
       "      <td>47306.00000</td>\n",
       "      <td>88124.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>0.798670</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.096135</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79995</th>\n",
       "      <td>310027</td>\n",
       "      <td>1736.000000</td>\n",
       "      <td>2.174000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>11.000000</td>\n",
       "      <td>4248.000000</td>\n",
       "      <td>1577.00000</td>\n",
       "      <td>13379.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>78.378000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>0.438290</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79996</th>\n",
       "      <td>310028</td>\n",
       "      <td>1724.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.108000</td>\n",
       "      <td>0.768000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>1606.702372</td>\n",
       "      <td>64041.000000</td>\n",
       "      <td>6773.68666</td>\n",
       "      <td>10926.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>38.325000</td>\n",
       "      <td>0.166670</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>0.579310</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79997</th>\n",
       "      <td>310029</td>\n",
       "      <td>1605.000000</td>\n",
       "      <td>0.290100</td>\n",
       "      <td>11.561000</td>\n",
       "      <td>0.937000</td>\n",
       "      <td>2.97600</td>\n",
       "      <td>1606.702372</td>\n",
       "      <td>2277.000000</td>\n",
       "      <td>6773.68666</td>\n",
       "      <td>3964.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>101.850000</td>\n",
       "      <td>93.142000</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>0.420690</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79998</th>\n",
       "      <td>310030</td>\n",
       "      <td>1780.000000</td>\n",
       "      <td>1.187400</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6356.000000</td>\n",
       "      <td>4802.00000</td>\n",
       "      <td>3206.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.497452</td>\n",
       "      <td>77.022000</td>\n",
       "      <td>0.060610</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>0.532510</td>\n",
       "      <td>0.070736</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79999</th>\n",
       "      <td>310031</td>\n",
       "      <td>1727.000000</td>\n",
       "      <td>1.928800</td>\n",
       "      <td>1.441000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>25773.000000</td>\n",
       "      <td>2869.00000</td>\n",
       "      <td>132985.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>32.400000</td>\n",
       "      <td>72.096758</td>\n",
       "      <td>0.071430</td>\n",
       "      <td>12.000000</td>\n",
       "      <td>0.684820</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>80000 rows × 49 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       application_key        mvar1     mvar2      mvar3     mvar4    mvar5  \\\n",
       "0               230032  1696.000000  1.654100   0.000000  0.000000  0.00000   \n",
       "1               230033  1846.000000  0.809500   0.000000  0.000000  0.00000   \n",
       "2               230034  1745.000000  0.400100   0.000000  0.000000  0.00000   \n",
       "3               230035  1739.000000  0.219300   0.000000  0.000000  0.00000   \n",
       "4               230036  1787.000000  0.011800   0.225000  0.000000  0.00000   \n",
       "5               230037  1579.000000  1.105629   3.502000  0.000000  0.00000   \n",
       "6               230038  1818.000000  0.400100   0.000000  0.000000  0.00000   \n",
       "7               230039  1745.971085  1.105629   5.280955  0.474516  1.12472   \n",
       "8               230040  1836.000000  0.135800   0.000000  0.000000  0.00000   \n",
       "9               230041  1839.000000  0.198100   0.000000  0.000000  0.00000   \n",
       "10              230042  1903.000000  0.000000   0.000000  0.000000  0.00000   \n",
       "11              230043  1681.000000  1.588800   5.685000  3.566000  0.00000   \n",
       "12              230044  1841.000000  0.538800   0.000000  0.000000  0.00000   \n",
       "13              230045  1794.000000  1.968400   0.000000  0.000000  0.00000   \n",
       "14              230046  1669.000000  3.855800  18.465000  6.292000  1.20000   \n",
       "15              230047  1583.000000  3.028400  16.325000  0.000000  0.00000   \n",
       "16              230048  1899.000000  0.097000   0.000000  0.000000  0.00000   \n",
       "17              230049  1690.000000  8.774700  10.437000  0.000000  0.00000   \n",
       "18              230050  1599.000000  0.860100   1.525000  1.525000  0.00000   \n",
       "19              230051  1859.000000  0.015500   0.368000  0.000000  0.00000   \n",
       "20              230052  1880.000000  2.610100   0.000000  0.000000  0.00000   \n",
       "21              230053  1852.000000  3.620100   0.000000  0.000000  0.00000   \n",
       "22              230054  1655.000000  3.026800  14.748000  0.000000  0.00000   \n",
       "23              230055  1863.000000  0.040100   0.000000  0.000000  0.00000   \n",
       "24              230056  1753.000000  0.225100   0.000000  0.000000  0.00000   \n",
       "25              230057  1894.000000  0.031800   0.000000  0.000000  0.00000   \n",
       "26              230058  1803.000000  0.399300   0.000000  0.000000  0.00000   \n",
       "27              230059  1932.000000  0.327600   0.000000  0.000000  0.00000   \n",
       "28              230060  1714.000000  5.190400   0.770000  0.000000  0.00000   \n",
       "29              230061  1745.971085  2.045700   4.514000  0.000000  0.00000   \n",
       "...                ...          ...       ...        ...       ...      ...   \n",
       "79970           310002  1834.000000  1.216400   0.000000  0.000000  0.00000   \n",
       "79971           310003  1729.000000  1.369600   0.000000  0.000000  0.00000   \n",
       "79972           310004  1753.000000  5.828300   0.000000  0.000000  0.00000   \n",
       "79973           310005  1748.000000  1.963500   0.642000  0.000000  0.00000   \n",
       "79974           310006  1771.000000  1.758800   0.000000  0.000000  0.00000   \n",
       "79975           310007  1766.000000  0.954000   0.000000  0.000000  0.00000   \n",
       "79976           310008  1822.000000  0.000000   1.853000  1.853000  0.00000   \n",
       "79977           310009  1824.000000  0.563400   0.000000  0.000000  0.00000   \n",
       "79978           310010  1914.000000  0.054400   0.000000  0.000000  0.00000   \n",
       "79979           310011  1600.000000  2.664900  18.282000  1.078000  2.67800   \n",
       "79980           310012  1822.000000  0.585100   0.000000  0.000000  0.00000   \n",
       "79981           310013  1693.000000  0.182800  17.767000  2.024000  0.00000   \n",
       "79982           310014  1735.000000  3.170100   0.260000  0.000000  0.00000   \n",
       "79983           310015  1671.000000  0.138000   0.000000  0.000000  0.00000   \n",
       "79984           310016  1924.000000  0.122100   0.000000  0.000000  0.00000   \n",
       "79985           310017  1670.000000  0.034700   9.836000  0.000000  0.00000   \n",
       "79986           310018  1901.000000  0.178200   0.000000  0.000000  0.00000   \n",
       "79987           310019  1835.000000  0.537200   0.000000  0.000000  0.00000   \n",
       "79988           310020  1927.000000  0.041000   0.000000  0.000000  0.00000   \n",
       "79989           310021  1745.971085  0.145100   0.000000  0.000000  0.00000   \n",
       "79990           310022  1941.000000  0.483400   0.000000  0.000000  0.00000   \n",
       "79991           310023  1899.000000  1.105629   0.000000  0.000000  0.00000   \n",
       "79992           310024  1761.000000  2.099900   0.000000  0.000000  0.00000   \n",
       "79993           310025  1700.000000  0.383100   0.000000  0.000000  0.00000   \n",
       "79994           310026  1910.000000  0.000000   0.000000  0.000000  0.00000   \n",
       "79995           310027  1736.000000  2.174000   0.000000  0.000000  0.00000   \n",
       "79996           310028  1724.000000  0.000000   1.108000  0.768000  0.00000   \n",
       "79997           310029  1605.000000  0.290100  11.561000  0.937000  2.97600   \n",
       "79998           310030  1780.000000  1.187400   0.000000  0.000000  0.00000   \n",
       "79999           310031  1727.000000  1.928800   1.441000  0.000000  0.00000   \n",
       "\n",
       "              mvar6          mvar7         mvar8          mvar9     ...       \\\n",
       "0          0.000000    6015.000000     322.00000   40369.000000     ...        \n",
       "1        102.000000    7532.000000    3171.00000   18234.000000     ...        \n",
       "2       1606.702372    2536.000000    6773.68666   34097.436013     ...        \n",
       "3       1982.000000   26440.000000    4955.00000   20316.000000     ...        \n",
       "4       5451.000000    5494.000000    5494.00000    7987.000000     ...        \n",
       "5       1606.702372   17595.807537    6773.68666   34097.436013     ...        \n",
       "6       1606.702372    1088.000000    6773.68666    1536.000000     ...        \n",
       "7       1606.702372   17595.807537    6773.68666   34097.436013     ...        \n",
       "8        347.000000   38964.000000   17828.00000   70729.000000     ...        \n",
       "9        793.000000    6131.000000    6045.00000   48959.000000     ...        \n",
       "10        22.000000   19518.000000    9910.00000   90618.000000     ...        \n",
       "11        93.000000    3554.000000     439.00000    2527.000000     ...        \n",
       "12      1487.000000   19449.000000   19449.00000    6739.000000     ...        \n",
       "13       856.000000    8609.000000    8609.00000   60545.000000     ...        \n",
       "14      1606.702372     142.000000    6773.68666      38.000000     ...        \n",
       "15      1606.702372   17595.807537    6773.68666   51450.000000     ...        \n",
       "16      1015.000000   13379.000000   13379.00000  246906.000000     ...        \n",
       "17       122.000000     623.000000     299.00000    1140.000000     ...        \n",
       "18      1606.702372     878.000000    6773.68666   34097.436013     ...        \n",
       "19       424.000000   86509.000000   12451.00000   86635.000000     ...        \n",
       "20         0.000000   19252.000000    6342.00000   59601.000000     ...        \n",
       "21       799.000000   16515.000000   16515.00000  110651.000000     ...        \n",
       "22        48.000000      48.000000      48.00000     198.000000     ...        \n",
       "23      1487.000000    4955.000000    4955.00000   22902.000000     ...        \n",
       "24      1124.000000    1124.000000    1124.00000       0.000000     ...        \n",
       "25      4655.000000    7433.000000    7433.00000   25667.000000     ...        \n",
       "26       496.000000   10505.000000     496.00000     991.000000     ...        \n",
       "27      6982.000000   21569.000000   18829.00000  187209.000000     ...        \n",
       "28         0.000000    1889.000000     595.00000   12574.000000     ...        \n",
       "29      1606.702372   17595.807537    6773.68666   34097.436013     ...        \n",
       "...             ...            ...           ...            ...     ...        \n",
       "79970   2212.000000    5244.000000    4203.00000   16743.000000     ...        \n",
       "79971    356.000000    4218.000000    1982.00000   18657.000000     ...        \n",
       "79972    180.000000    4014.000000     617.00000    3667.000000     ...        \n",
       "79973    291.000000    3469.000000    3469.00000   13131.000000     ...        \n",
       "79974     66.000000   12626.000000    6433.00000   27946.000000     ...        \n",
       "79975   1140.000000   10207.000000   10207.00000   55001.000000     ...        \n",
       "79976   2581.000000   13361.000000    5946.00000   31018.000000     ...        \n",
       "79977   3964.000000    4683.000000    4683.00000   34097.436013     ...        \n",
       "79978   3469.000000   20424.000000   20424.00000   78774.000000     ...        \n",
       "79979      0.000000    7205.000000       0.00000     956.000000     ...        \n",
       "79980      0.000000   23685.000000   23685.00000  208174.000000     ...        \n",
       "79981    114.000000   27514.000000     384.00000    2329.000000     ...        \n",
       "79982    117.000000     892.000000     117.00000    3766.000000     ...        \n",
       "79983   1606.702372     491.000000    6773.68666   34097.436013     ...        \n",
       "79984   2478.000000  266683.000000  266683.00000  405300.000000     ...        \n",
       "79985    212.000000    7848.000000     491.00000   29785.000000     ...        \n",
       "79986   4955.000000   21753.000000   12673.00000   70293.000000     ...        \n",
       "79987      0.000000   29723.000000    3964.00000   66770.000000     ...        \n",
       "79988  22000.000000   30046.000000   24165.00000   75019.000000     ...        \n",
       "79989   1606.702372   17595.807537    6773.68666   34097.436013     ...        \n",
       "79990  10846.000000   52806.000000   35478.00000  136461.000000     ...        \n",
       "79991   7310.000000   14519.000000   14519.00000    5252.000000     ...        \n",
       "79992     47.000000   13477.000000    1814.00000    9320.000000     ...        \n",
       "79993    344.000000     344.000000     344.00000     991.000000     ...        \n",
       "79994   4955.000000   47306.000000   47306.00000   88124.000000     ...        \n",
       "79995     11.000000    4248.000000    1577.00000   13379.000000     ...        \n",
       "79996   1606.702372   64041.000000    6773.68666   10926.000000     ...        \n",
       "79997   1606.702372    2277.000000    6773.68666    3964.000000     ...        \n",
       "79998      0.000000    6356.000000    4802.00000    3206.000000     ...        \n",
       "79999      0.000000   25773.000000    2869.00000  132985.000000     ...        \n",
       "\n",
       "         mvar39      mvar40     mvar41    mvar42     mvar43    mvar44  \\\n",
       "0      1.000000   73.780000  82.547000  0.086960  10.000000  0.638990   \n",
       "1      0.000000   99.129000  72.096758  0.000000  13.000000  0.638360   \n",
       "2      0.000000   98.497452  29.290000  0.000000   1.000000  1.000000   \n",
       "3      0.000000   96.272000  72.096758  0.153850   3.000000  0.532410   \n",
       "4      0.000000  115.019000  72.096758  0.000000   1.000000  0.926650   \n",
       "5      0.090819   98.497452  72.096758  1.500000   0.000000  0.705285   \n",
       "6      0.000000   88.171000  72.096758  0.000000   2.000000  0.872240   \n",
       "7      0.090819   98.497452  72.096758  0.335142   6.552777  0.705285   \n",
       "8      0.000000   98.497452  72.096758  0.000000  10.000000  0.898680   \n",
       "9      0.000000   98.497452  45.590000  0.088240  14.000000  0.338340   \n",
       "10     0.000000   98.497452  72.096758  0.000000  17.000000  0.806200   \n",
       "11     1.000000   98.497452  72.096758  0.611110   7.000000  0.811720   \n",
       "12     0.000000   98.497452  72.096758  0.000000   5.000000  0.980310   \n",
       "13     0.000000   98.497452  72.096758  0.000000  13.000000  0.357240   \n",
       "14     0.000000  107.825000  98.664000  0.560000  11.000000  0.291690   \n",
       "15     0.000000   98.497452  72.096758  0.323530   2.000000  0.705285   \n",
       "16     0.000000   10.384000  72.096758  0.000000  19.000000  0.474800   \n",
       "17     0.000000   98.497452  72.096758  0.636360   5.000000  0.949510   \n",
       "18     1.000000   98.497452  91.175000  0.800000   0.000000  1.000000   \n",
       "19     0.000000   98.497452  72.096758  0.000000  12.000000  0.347300   \n",
       "20     0.000000   98.497452  72.497000  0.000000  14.000000  0.287080   \n",
       "21     0.000000   98.497452  72.096758  0.000000  13.000000  0.753490   \n",
       "22     0.000000   98.497452  72.096758  1.000000   1.000000  1.000000   \n",
       "23     0.000000   96.895000  72.096758  0.000000  12.000000  0.408530   \n",
       "24     0.000000   98.497452  72.096758  0.335142   0.000000  1.000000   \n",
       "25     0.000000   98.497452   0.000000  0.000000   3.000000  0.994190   \n",
       "26     0.000000   91.752000  87.306000  0.200000   5.000000  0.752890   \n",
       "27     0.000000   98.497452  72.096758  0.000000  11.000000  0.997100   \n",
       "28     0.000000   98.497452  72.096758  0.357140   6.000000  0.850820   \n",
       "29     0.090819   98.497452  72.096758  1.166670   0.000000  0.705285   \n",
       "...         ...         ...        ...       ...        ...       ...   \n",
       "79970  0.000000   98.497452  97.398000  0.000000   8.000000  0.580400   \n",
       "79971  0.000000   98.497452  83.663000  0.090910   6.000000  0.626320   \n",
       "79972  0.000000   98.497452  87.094000  0.111110   9.000000  0.593640   \n",
       "79973  0.000000   98.497452  92.244000  0.440000  14.000000  0.838090   \n",
       "79974  0.000000   98.497452  40.477000  0.000000  10.000000  0.468630   \n",
       "79975  0.000000   98.497452  72.096758  0.050000  14.000000  0.547540   \n",
       "79976  0.000000   73.611000  44.656000  0.034480  20.000000  0.231770   \n",
       "79977  0.000000   98.497452  72.096758  0.335142   6.552777  0.672220   \n",
       "79978  0.000000   98.497452  72.096758  0.000000   8.000000  1.000000   \n",
       "79979  1.000000  132.335000  56.867000  0.552630  14.000000  0.117630   \n",
       "79980  0.000000   98.497452  72.096758  0.000000  17.000000  0.814380   \n",
       "79981  0.000000   74.814000  72.096758  0.178570   5.000000  0.533400   \n",
       "79982  0.000000   98.497452  99.026000  0.000000   2.000000  0.967470   \n",
       "79983  0.000000   98.497452  72.096758  0.800000   2.000000  1.000000   \n",
       "79984  0.000000   98.497452  70.799000  0.000000  13.000000  0.753220   \n",
       "79985  0.000000   98.497452  78.700000  0.136360  10.000000  0.857710   \n",
       "79986  0.000000   98.497452  61.301000  0.000000  10.000000  0.863560   \n",
       "79987  0.000000   98.497452  72.096758  0.000000   9.000000  0.416850   \n",
       "79988  0.000000   98.497452  19.444000  0.000000   7.000000  0.537500   \n",
       "79989  0.090819   98.497452  72.096758  1.500000   0.000000  0.705285   \n",
       "79990  0.000000   98.497452  72.096758  0.058820   8.000000  0.841700   \n",
       "79991  0.000000   98.497452  72.096758  0.000000   3.000000  0.446150   \n",
       "79992  0.000000   98.497452  72.096758  0.125000   5.000000  0.736400   \n",
       "79993  0.000000   98.497452  72.096758  0.666670   2.000000  0.973740   \n",
       "79994  0.000000   98.497452  72.096758  0.000000   4.000000  0.798670   \n",
       "79995  0.000000   98.497452  78.378000  0.000000   4.000000  0.438290   \n",
       "79996  0.000000   98.497452  38.325000  0.166670  14.000000  0.579310   \n",
       "79997  2.000000  101.850000  93.142000  0.500000   4.000000  0.420690   \n",
       "79998  0.000000   98.497452  77.022000  0.060610   9.000000  0.532510   \n",
       "79999  0.000000   32.400000  72.096758  0.071430  12.000000  0.684820   \n",
       "\n",
       "         mvar45    mvar46  mvar47  default_ind  \n",
       "0      0.070736  0.000000     NaN            0  \n",
       "1      0.070736  0.096135     NaN            1  \n",
       "2      0.070736  0.000000     NaN            1  \n",
       "3      0.000000  0.000000     NaN            0  \n",
       "4      0.070736  0.096135     NaN            0  \n",
       "5      0.070736  0.096135     NaN            1  \n",
       "6      0.070736  0.000000     NaN            1  \n",
       "7      0.070736  0.096135     NaN            0  \n",
       "8      0.000000  0.000000     NaN            0  \n",
       "9      0.070736  0.000000     NaN            0  \n",
       "10     0.000000  0.000000     NaN            0  \n",
       "11     0.000000  0.000000     NaN            0  \n",
       "12     0.070736  0.096135     NaN            0  \n",
       "13     0.070736  0.000000     NaN            0  \n",
       "14     0.070736  1.000000     NaN            0  \n",
       "15     0.000000  0.096135     NaN            0  \n",
       "16     0.000000  0.000000     NaN            0  \n",
       "17     0.070736  0.000000     NaN            0  \n",
       "18     0.070736  0.000000     NaN            1  \n",
       "19     0.000000  0.000000     NaN            0  \n",
       "20     0.070736  0.000000     NaN            0  \n",
       "21     0.070736  0.096135     NaN            0  \n",
       "22     0.070736  0.096135     NaN            1  \n",
       "23     0.070736  0.000000     NaN            0  \n",
       "24     0.070736  0.096135     NaN            1  \n",
       "25     0.000000  0.000000     NaN            0  \n",
       "26     0.000000  0.000000     NaN            0  \n",
       "27     0.000000  0.000000     NaN            0  \n",
       "28     0.000000  0.000000     NaN            0  \n",
       "29     0.070736  0.096135     NaN            0  \n",
       "...         ...       ...     ...          ...  \n",
       "79970  0.070736  0.000000     NaN            0  \n",
       "79971  0.000000  0.000000     NaN            0  \n",
       "79972  0.070736  0.000000     NaN            0  \n",
       "79973  0.000000  0.000000     NaN            0  \n",
       "79974  0.070736  0.000000     NaN            0  \n",
       "79975  0.070736  0.096135     NaN            0  \n",
       "79976  0.070736  0.000000     NaN            0  \n",
       "79977  0.070736  0.096135     NaN            0  \n",
       "79978  0.000000  0.000000     NaN            0  \n",
       "79979  0.070736  0.000000     NaN            1  \n",
       "79980  0.000000  0.096135     NaN            0  \n",
       "79981  0.070736  0.000000     NaN            0  \n",
       "79982  0.070736  0.000000     NaN            1  \n",
       "79983  0.070736  0.096135     NaN            0  \n",
       "79984  0.000000  0.000000     NaN            0  \n",
       "79985  0.070736  0.000000     NaN            0  \n",
       "79986  0.000000  0.000000     NaN            0  \n",
       "79987  0.000000  0.000000     NaN            0  \n",
       "79988  0.000000  0.000000     NaN            0  \n",
       "79989  0.070736  0.096135     NaN            0  \n",
       "79990  0.000000  0.000000     NaN            0  \n",
       "79991  0.070736  0.096135     NaN            0  \n",
       "79992  0.000000  0.000000     NaN            1  \n",
       "79993  0.000000  0.000000     NaN            1  \n",
       "79994  0.070736  0.096135     NaN            0  \n",
       "79995  0.070736  0.000000     NaN            0  \n",
       "79996  0.000000  0.000000     NaN            0  \n",
       "79997  0.070736  0.000000     NaN            1  \n",
       "79998  0.070736  0.000000     NaN            0  \n",
       "79999  0.000000  0.000000     NaN            1  \n",
       "\n",
       "[80000 rows x 49 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "train_data.fillna(train_data.mean(),inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "'DataFrame' object has no attribute 'isna'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-30-7c5796586134>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mtrain_data\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0misna\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msum\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m/home/ekka/anaconda3/lib/python3.6/site-packages/pandas/core/generic.py\u001b[0m in \u001b[0;36m__getattr__\u001b[0;34m(self, name)\u001b[0m\n\u001b[1;32m   2968\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mname\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_info_axis\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2969\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mname\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2970\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mobject\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m__getattribute__\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mname\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2971\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2972\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m__setattr__\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mname\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mAttributeError\u001b[0m: 'DataFrame' object has no attribute 'isna'"
     ]
    }
   ],
   "source": [
    "train_data.isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'0.20.1'"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.__version__"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "train_data['mvar47'] = pd.get_dummies(train_data_original['mvar47'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "x_train = train_data.loc[:,'mvar1':'mvar47']\n",
    "y_train = train_data['default_ind']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>application_key</th>\n",
       "      <th>mvar2</th>\n",
       "      <th>mvar3</th>\n",
       "      <th>mvar4</th>\n",
       "      <th>mvar5</th>\n",
       "      <th>mvar14</th>\n",
       "      <th>mvar21</th>\n",
       "      <th>mvar22</th>\n",
       "      <th>mvar23</th>\n",
       "      <th>mvar24</th>\n",
       "      <th>mvar33</th>\n",
       "      <th>mvar44</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>25000.000000</td>\n",
       "      <td>23294.000000</td>\n",
       "      <td>24842.000000</td>\n",
       "      <td>24842.000000</td>\n",
       "      <td>24842.000000</td>\n",
       "      <td>2.500000e+04</td>\n",
       "      <td>18106.000000</td>\n",
       "      <td>15919.000000</td>\n",
       "      <td>12359.000000</td>\n",
       "      <td>19223.000000</td>\n",
       "      <td>24461.000000</td>\n",
       "      <td>22538.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>362552.500000</td>\n",
       "      <td>1.118127</td>\n",
       "      <td>5.243267</td>\n",
       "      <td>0.463290</td>\n",
       "      <td>1.080183</td>\n",
       "      <td>1.523549e+05</td>\n",
       "      <td>57.885791</td>\n",
       "      <td>4427.876770</td>\n",
       "      <td>4270.918441</td>\n",
       "      <td>72.500520</td>\n",
       "      <td>6.920566</td>\n",
       "      <td>0.702558</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>7217.022701</td>\n",
       "      <td>1.658707</td>\n",
       "      <td>10.605688</td>\n",
       "      <td>1.688155</td>\n",
       "      <td>5.813250</td>\n",
       "      <td>6.337980e+06</td>\n",
       "      <td>35.344775</td>\n",
       "      <td>3813.637964</td>\n",
       "      <td>3774.419701</td>\n",
       "      <td>305.673992</td>\n",
       "      <td>7.655343</td>\n",
       "      <td>0.246612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>350053.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.117000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.083300</td>\n",
       "      <td>0.072760</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>356302.750000</td>\n",
       "      <td>0.142725</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>4.261300e+04</td>\n",
       "      <td>27.244750</td>\n",
       "      <td>750.845000</td>\n",
       "      <td>532.705000</td>\n",
       "      <td>10.345000</td>\n",
       "      <td>1.166700</td>\n",
       "      <td>0.509132</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>362552.500000</td>\n",
       "      <td>0.542400</td>\n",
       "      <td>0.286000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7.234300e+04</td>\n",
       "      <td>59.569500</td>\n",
       "      <td>3978.570000</td>\n",
       "      <td>3707.500000</td>\n",
       "      <td>41.220000</td>\n",
       "      <td>3.833300</td>\n",
       "      <td>0.732740</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>368802.250000</td>\n",
       "      <td>1.469375</td>\n",
       "      <td>6.480000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.238750e+05</td>\n",
       "      <td>86.366500</td>\n",
       "      <td>7523.980000</td>\n",
       "      <td>7405.470000</td>\n",
       "      <td>76.250000</td>\n",
       "      <td>10.500000</td>\n",
       "      <td>0.942372</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>375052.000000</td>\n",
       "      <td>31.018100</td>\n",
       "      <td>167.740000</td>\n",
       "      <td>21.245200</td>\n",
       "      <td>156.878000</td>\n",
       "      <td>9.910000e+08</td>\n",
       "      <td>565.800000</td>\n",
       "      <td>99800.000000</td>\n",
       "      <td>41737.500000</td>\n",
       "      <td>22621.130000</td>\n",
       "      <td>76.500000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       application_key         mvar2         mvar3         mvar4  \\\n",
       "count     25000.000000  23294.000000  24842.000000  24842.000000   \n",
       "mean     362552.500000      1.118127      5.243267      0.463290   \n",
       "std        7217.022701      1.658707     10.605688      1.688155   \n",
       "min      350053.000000      0.000000      0.000000      0.000000   \n",
       "25%      356302.750000      0.142725      0.000000      0.000000   \n",
       "50%      362552.500000      0.542400      0.286000      0.000000   \n",
       "75%      368802.250000      1.469375      6.480000      0.000000   \n",
       "max      375052.000000     31.018100    167.740000     21.245200   \n",
       "\n",
       "              mvar5        mvar14        mvar21        mvar22        mvar23  \\\n",
       "count  24842.000000  2.500000e+04  18106.000000  15919.000000  12359.000000   \n",
       "mean       1.080183  1.523549e+05     57.885791   4427.876770   4270.918441   \n",
       "std        5.813250  6.337980e+06     35.344775   3813.637964   3774.419701   \n",
       "min        0.000000  0.000000e+00      0.117000      0.000000      0.000000   \n",
       "25%        0.000000  4.261300e+04     27.244750    750.845000    532.705000   \n",
       "50%        0.000000  7.234300e+04     59.569500   3978.570000   3707.500000   \n",
       "75%        0.000000  1.238750e+05     86.366500   7523.980000   7405.470000   \n",
       "max      156.878000  9.910000e+08    565.800000  99800.000000  41737.500000   \n",
       "\n",
       "             mvar24        mvar33        mvar44  \n",
       "count  19223.000000  24461.000000  22538.000000  \n",
       "mean      72.500520      6.920566      0.702558  \n",
       "std      305.673992      7.655343      0.246612  \n",
       "min        0.000000      0.083300      0.072760  \n",
       "25%       10.345000      1.166700      0.509132  \n",
       "50%       41.220000      3.833300      0.732740  \n",
       "75%       76.250000     10.500000      0.942372  \n",
       "max    22621.130000     76.500000      1.000000  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "leaderboard_data.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "for column in leaderboard_data.columns:\n",
    "    if column != 'application_key':\n",
    "        leaderboard_data[column] = pd.to_numeric(leaderboard_data[column], errors='coerce')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>application_key</th>\n",
       "      <th>mvar1</th>\n",
       "      <th>mvar2</th>\n",
       "      <th>mvar3</th>\n",
       "      <th>mvar4</th>\n",
       "      <th>mvar5</th>\n",
       "      <th>mvar6</th>\n",
       "      <th>mvar7</th>\n",
       "      <th>mvar8</th>\n",
       "      <th>mvar9</th>\n",
       "      <th>...</th>\n",
       "      <th>mvar38</th>\n",
       "      <th>mvar39</th>\n",
       "      <th>mvar40</th>\n",
       "      <th>mvar41</th>\n",
       "      <th>mvar42</th>\n",
       "      <th>mvar43</th>\n",
       "      <th>mvar44</th>\n",
       "      <th>mvar45</th>\n",
       "      <th>mvar46</th>\n",
       "      <th>mvar47</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>25000.000000</td>\n",
       "      <td>23850.000000</td>\n",
       "      <td>23294.000000</td>\n",
       "      <td>24842.000000</td>\n",
       "      <td>24842.000000</td>\n",
       "      <td>24842.000000</td>\n",
       "      <td>19193.000000</td>\n",
       "      <td>2.269400e+04</td>\n",
       "      <td>19193.000000</td>\n",
       "      <td>21523.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>24842.000000</td>\n",
       "      <td>23078.000000</td>\n",
       "      <td>5458.000000</td>\n",
       "      <td>7748.000000</td>\n",
       "      <td>24367.000000</td>\n",
       "      <td>24723.000000</td>\n",
       "      <td>22538.000000</td>\n",
       "      <td>11027.000000</td>\n",
       "      <td>17851.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>362552.500000</td>\n",
       "      <td>1746.901551</td>\n",
       "      <td>1.118127</td>\n",
       "      <td>5.243267</td>\n",
       "      <td>0.463290</td>\n",
       "      <td>1.080183</td>\n",
       "      <td>1624.069192</td>\n",
       "      <td>1.775037e+04</td>\n",
       "      <td>6753.202313</td>\n",
       "      <td>33825.554662</td>\n",
       "      <td>...</td>\n",
       "      <td>4.251349</td>\n",
       "      <td>0.089912</td>\n",
       "      <td>98.491140</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.331992</td>\n",
       "      <td>6.546091</td>\n",
       "      <td>0.702558</td>\n",
       "      <td>0.071280</td>\n",
       "      <td>0.092712</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>7217.022701</td>\n",
       "      <td>94.088195</td>\n",
       "      <td>1.658707</td>\n",
       "      <td>10.605688</td>\n",
       "      <td>1.688155</td>\n",
       "      <td>5.813250</td>\n",
       "      <td>3588.247900</td>\n",
       "      <td>5.485979e+04</td>\n",
       "      <td>10133.583639</td>\n",
       "      <td>51781.414456</td>\n",
       "      <td>...</td>\n",
       "      <td>3.870975</td>\n",
       "      <td>0.444250</td>\n",
       "      <td>30.488996</td>\n",
       "      <td>24.806054</td>\n",
       "      <td>0.374753</td>\n",
       "      <td>6.260583</td>\n",
       "      <td>0.246612</td>\n",
       "      <td>0.302654</td>\n",
       "      <td>0.321896</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>350053.000000</td>\n",
       "      <td>1477.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.018000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.072760</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>356302.750000</td>\n",
       "      <td>1680.000000</td>\n",
       "      <td>0.142725</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>36.000000</td>\n",
       "      <td>1.701000e+03</td>\n",
       "      <td>494.000000</td>\n",
       "      <td>3518.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>91.338250</td>\n",
       "      <td>58.179500</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>0.509132</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>362552.500000</td>\n",
       "      <td>1742.000000</td>\n",
       "      <td>0.542400</td>\n",
       "      <td>0.286000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>297.000000</td>\n",
       "      <td>7.011500e+03</td>\n",
       "      <td>2503.000000</td>\n",
       "      <td>14072.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>79.123000</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>0.732740</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>368802.250000</td>\n",
       "      <td>1811.000000</td>\n",
       "      <td>1.469375</td>\n",
       "      <td>6.480000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1371.000000</td>\n",
       "      <td>1.803575e+04</td>\n",
       "      <td>9595.000000</td>\n",
       "      <td>43009.500000</td>\n",
       "      <td>...</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>112.237500</td>\n",
       "      <td>91.666000</td>\n",
       "      <td>0.561950</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>0.942372</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>375052.000000</td>\n",
       "      <td>1950.000000</td>\n",
       "      <td>31.018100</td>\n",
       "      <td>167.740000</td>\n",
       "      <td>21.245200</td>\n",
       "      <td>156.878000</td>\n",
       "      <td>59192.000000</td>\n",
       "      <td>5.637108e+06</td>\n",
       "      <td>223123.000000</td>\n",
       "      <td>840658.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>73.000000</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>631.360000</td>\n",
       "      <td>182.111000</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>63.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 48 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       application_key         mvar1         mvar2         mvar3  \\\n",
       "count     25000.000000  23850.000000  23294.000000  24842.000000   \n",
       "mean     362552.500000   1746.901551      1.118127      5.243267   \n",
       "std        7217.022701     94.088195      1.658707     10.605688   \n",
       "min      350053.000000   1477.000000      0.000000      0.000000   \n",
       "25%      356302.750000   1680.000000      0.142725      0.000000   \n",
       "50%      362552.500000   1742.000000      0.542400      0.286000   \n",
       "75%      368802.250000   1811.000000      1.469375      6.480000   \n",
       "max      375052.000000   1950.000000     31.018100    167.740000   \n",
       "\n",
       "              mvar4         mvar5         mvar6         mvar7          mvar8  \\\n",
       "count  24842.000000  24842.000000  19193.000000  2.269400e+04   19193.000000   \n",
       "mean       0.463290      1.080183   1624.069192  1.775037e+04    6753.202313   \n",
       "std        1.688155      5.813250   3588.247900  5.485979e+04   10133.583639   \n",
       "min        0.000000      0.000000      0.000000  0.000000e+00       0.000000   \n",
       "25%        0.000000      0.000000     36.000000  1.701000e+03     494.000000   \n",
       "50%        0.000000      0.000000    297.000000  7.011500e+03    2503.000000   \n",
       "75%        0.000000      0.000000   1371.000000  1.803575e+04    9595.000000   \n",
       "max       21.245200    156.878000  59192.000000  5.637108e+06  223123.000000   \n",
       "\n",
       "               mvar9   ...          mvar38        mvar39       mvar40  \\\n",
       "count   21523.000000   ...    24842.000000  23078.000000  5458.000000   \n",
       "mean    33825.554662   ...        4.251349      0.089912    98.491140   \n",
       "std     51781.414456   ...        3.870975      0.444250    30.488996   \n",
       "min         0.000000   ...        0.000000      0.000000     0.018000   \n",
       "25%      3518.000000   ...        2.000000      0.000000    91.338250   \n",
       "50%     14072.000000   ...        3.000000      0.000000   100.000000   \n",
       "75%     43009.500000   ...        6.000000      0.000000   112.237500   \n",
       "max    840658.000000   ...       73.000000     20.000000   631.360000   \n",
       "\n",
       "            mvar41        mvar42        mvar43        mvar44        mvar45  \\\n",
       "count  7748.000000  24367.000000  24723.000000  22538.000000  11027.000000   \n",
       "mean     71.990942      0.331992      6.546091      0.702558      0.071280   \n",
       "std      24.806054      0.374753      6.260583      0.246612      0.302654   \n",
       "min       0.000000      0.000000      0.000000      0.072760      0.000000   \n",
       "25%      58.179500      0.000000      2.000000      0.509132      0.000000   \n",
       "50%      79.123000      0.200000      5.000000      0.732740      0.000000   \n",
       "75%      91.666000      0.561950     10.000000      0.942372      0.000000   \n",
       "max     182.111000      2.000000     63.000000      1.000000      7.000000   \n",
       "\n",
       "             mvar46  mvar47  \n",
       "count  17851.000000     0.0  \n",
       "mean       0.092712     NaN  \n",
       "std        0.321896     NaN  \n",
       "min        0.000000     NaN  \n",
       "25%        0.000000     NaN  \n",
       "50%        0.000000     NaN  \n",
       "75%        0.000000     NaN  \n",
       "max        3.000000     NaN  \n",
       "\n",
       "[8 rows x 48 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "leaderboard_data.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "leaderboard_data['mvar47'] = pd.get_dummies(leaderboard_data_original['mvar47'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>application_key</th>\n",
       "      <th>mvar1</th>\n",
       "      <th>mvar2</th>\n",
       "      <th>mvar3</th>\n",
       "      <th>mvar4</th>\n",
       "      <th>mvar5</th>\n",
       "      <th>mvar6</th>\n",
       "      <th>mvar7</th>\n",
       "      <th>mvar8</th>\n",
       "      <th>mvar9</th>\n",
       "      <th>...</th>\n",
       "      <th>mvar38</th>\n",
       "      <th>mvar39</th>\n",
       "      <th>mvar40</th>\n",
       "      <th>mvar41</th>\n",
       "      <th>mvar42</th>\n",
       "      <th>mvar43</th>\n",
       "      <th>mvar44</th>\n",
       "      <th>mvar45</th>\n",
       "      <th>mvar46</th>\n",
       "      <th>mvar47</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>350053</td>\n",
       "      <td>1753.0</td>\n",
       "      <td>0.500100</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>206.000000</td>\n",
       "      <td>19179.000000</td>\n",
       "      <td>206.000000</td>\n",
       "      <td>14221.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>20.551000</td>\n",
       "      <td>0.42105</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.856610</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>350054</td>\n",
       "      <td>1894.0</td>\n",
       "      <td>1.970100</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>297.000000</td>\n",
       "      <td>19820.000000</td>\n",
       "      <td>19820.000000</td>\n",
       "      <td>176895.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>63.047000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.943910</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>350055</td>\n",
       "      <td>1774.0</td>\n",
       "      <td>0.171800</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>197.000000</td>\n",
       "      <td>2563.000000</td>\n",
       "      <td>877.000000</td>\n",
       "      <td>8869.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>83.797000</td>\n",
       "      <td>0.33333</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.764670</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>350056</td>\n",
       "      <td>1586.0</td>\n",
       "      <td>0.112300</td>\n",
       "      <td>5.299</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1624.069192</td>\n",
       "      <td>17750.368864</td>\n",
       "      <td>6753.202313</td>\n",
       "      <td>33825.554662</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.089912</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>1.50000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.702558</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.092712</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>350057</td>\n",
       "      <td>1832.0</td>\n",
       "      <td>1.444200</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>179.000000</td>\n",
       "      <td>7577.000000</td>\n",
       "      <td>179.000000</td>\n",
       "      <td>21059.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>96.05200</td>\n",
       "      <td>66.665000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.791900</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>350058</td>\n",
       "      <td>1838.0</td>\n",
       "      <td>0.054400</td>\n",
       "      <td>0.241</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>882.000000</td>\n",
       "      <td>14039.000000</td>\n",
       "      <td>10976.000000</td>\n",
       "      <td>278941.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>77.780000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>21.0</td>\n",
       "      <td>0.924620</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>350059</td>\n",
       "      <td>1743.0</td>\n",
       "      <td>1.075300</td>\n",
       "      <td>0.272</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>397.000000</td>\n",
       "      <td>16141.000000</td>\n",
       "      <td>3568.000000</td>\n",
       "      <td>69482.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>67.159000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.713470</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>350060</td>\n",
       "      <td>1935.0</td>\n",
       "      <td>0.560100</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>496.000000</td>\n",
       "      <td>44919.000000</td>\n",
       "      <td>17115.000000</td>\n",
       "      <td>124814.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.924030</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>350061</td>\n",
       "      <td>1885.0</td>\n",
       "      <td>0.081100</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>7369.000000</td>\n",
       "      <td>19264.000000</td>\n",
       "      <td>19264.000000</td>\n",
       "      <td>59956.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.897600</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.092712</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>350062</td>\n",
       "      <td>1730.0</td>\n",
       "      <td>0.744400</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>2103.000000</td>\n",
       "      <td>582.000000</td>\n",
       "      <td>16429.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.05882</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.405290</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>350063</td>\n",
       "      <td>1731.0</td>\n",
       "      <td>0.509700</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2433.000000</td>\n",
       "      <td>8673.000000</td>\n",
       "      <td>8673.000000</td>\n",
       "      <td>6739.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.23529</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.642420</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.092712</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>350064</td>\n",
       "      <td>1755.0</td>\n",
       "      <td>0.301300</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>261.000000</td>\n",
       "      <td>4051.000000</td>\n",
       "      <td>261.000000</td>\n",
       "      <td>297.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.33333</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.991420</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>350065</td>\n",
       "      <td>1739.0</td>\n",
       "      <td>2.290900</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7620.000000</td>\n",
       "      <td>7620.000000</td>\n",
       "      <td>64983.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>95.000000</td>\n",
       "      <td>0.05882</td>\n",
       "      <td>16.0</td>\n",
       "      <td>0.441670</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>350066</td>\n",
       "      <td>1562.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>34.611</td>\n",
       "      <td>3.7845</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1624.069192</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>6753.202313</td>\n",
       "      <td>198.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>124.91000</td>\n",
       "      <td>99.934000</td>\n",
       "      <td>0.87500</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.845920</td>\n",
       "      <td>1.00000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>350067</td>\n",
       "      <td>1798.0</td>\n",
       "      <td>5.082500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>259.000000</td>\n",
       "      <td>3359.000000</td>\n",
       "      <td>2973.000000</td>\n",
       "      <td>22099.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>76.881000</td>\n",
       "      <td>0.05882</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.433650</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>350068</td>\n",
       "      <td>1684.0</td>\n",
       "      <td>1.547900</td>\n",
       "      <td>1.338</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1624.069192</td>\n",
       "      <td>17750.368864</td>\n",
       "      <td>6753.202313</td>\n",
       "      <td>33825.554662</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.089912</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>1.50000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.702558</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.092712</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>350069</td>\n",
       "      <td>1789.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.428</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2478.000000</td>\n",
       "      <td>13874.000000</td>\n",
       "      <td>13874.000000</td>\n",
       "      <td>98011.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.05000</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.512310</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.092712</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>350070</td>\n",
       "      <td>1862.0</td>\n",
       "      <td>0.240100</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1487.000000</td>\n",
       "      <td>12310.000000</td>\n",
       "      <td>3964.000000</td>\n",
       "      <td>7928.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>77.419000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.566850</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>350071</td>\n",
       "      <td>1767.0</td>\n",
       "      <td>0.300100</td>\n",
       "      <td>1.514</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>991.000000</td>\n",
       "      <td>2478.000000</td>\n",
       "      <td>2478.000000</td>\n",
       "      <td>8790.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.10000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.702558</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.092712</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>350072</td>\n",
       "      <td>1802.0</td>\n",
       "      <td>0.636400</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>96.000000</td>\n",
       "      <td>18759.000000</td>\n",
       "      <td>10905.000000</td>\n",
       "      <td>51037.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>58.972000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.594090</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>350073</td>\n",
       "      <td>1780.0</td>\n",
       "      <td>1.955900</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>191.000000</td>\n",
       "      <td>12525.000000</td>\n",
       "      <td>12525.000000</td>\n",
       "      <td>18932.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.927520</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>350074</td>\n",
       "      <td>1714.0</td>\n",
       "      <td>2.266400</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>31.000000</td>\n",
       "      <td>1671.000000</td>\n",
       "      <td>57.000000</td>\n",
       "      <td>396.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>91.666000</td>\n",
       "      <td>0.37500</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.348360</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>350075</td>\n",
       "      <td>1923.0</td>\n",
       "      <td>0.088000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>5946.000000</td>\n",
       "      <td>53893.000000</td>\n",
       "      <td>24739.000000</td>\n",
       "      <td>128435.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>90.429000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.885540</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>350076</td>\n",
       "      <td>1743.0</td>\n",
       "      <td>1.720800</td>\n",
       "      <td>2.295</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>159.000000</td>\n",
       "      <td>3621.000000</td>\n",
       "      <td>2323.000000</td>\n",
       "      <td>9018.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>82.323000</td>\n",
       "      <td>0.10000</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.594420</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>350077</td>\n",
       "      <td>1700.0</td>\n",
       "      <td>1.660500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1037.000000</td>\n",
       "      <td>46.000000</td>\n",
       "      <td>892.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.20000</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.948260</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>350078</td>\n",
       "      <td>1922.0</td>\n",
       "      <td>1.118127</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>4524.000000</td>\n",
       "      <td>15530.000000</td>\n",
       "      <td>14819.000000</td>\n",
       "      <td>116154.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.915500</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>350079</td>\n",
       "      <td>1777.0</td>\n",
       "      <td>0.412000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>369.000000</td>\n",
       "      <td>6201.000000</td>\n",
       "      <td>6201.000000</td>\n",
       "      <td>66477.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.03846</td>\n",
       "      <td>23.0</td>\n",
       "      <td>0.151590</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.092712</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>350080</td>\n",
       "      <td>1811.0</td>\n",
       "      <td>0.911700</td>\n",
       "      <td>0.410</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.410</td>\n",
       "      <td>297.000000</td>\n",
       "      <td>27717.000000</td>\n",
       "      <td>9815.000000</td>\n",
       "      <td>110001.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>74.996000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.566710</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>350081</td>\n",
       "      <td>1658.0</td>\n",
       "      <td>2.382900</td>\n",
       "      <td>37.127</td>\n",
       "      <td>10.3678</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>396.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6566.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.57692</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.353390</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>350082</td>\n",
       "      <td>1827.0</td>\n",
       "      <td>0.280100</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>678.000000</td>\n",
       "      <td>1189.000000</td>\n",
       "      <td>1189.000000</td>\n",
       "      <td>892.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.092712</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24970</th>\n",
       "      <td>375023</td>\n",
       "      <td>1734.0</td>\n",
       "      <td>0.927900</td>\n",
       "      <td>0.520</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>256.000000</td>\n",
       "      <td>11643.000000</td>\n",
       "      <td>1524.000000</td>\n",
       "      <td>16748.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.380780</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24971</th>\n",
       "      <td>375024</td>\n",
       "      <td>1849.0</td>\n",
       "      <td>1.830500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2251.000000</td>\n",
       "      <td>33275.000000</td>\n",
       "      <td>7505.000000</td>\n",
       "      <td>44843.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>91.701000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.921110</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24972</th>\n",
       "      <td>375025</td>\n",
       "      <td>1739.0</td>\n",
       "      <td>1.525100</td>\n",
       "      <td>2.727</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>2.727</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>2129.000000</td>\n",
       "      <td>720.000000</td>\n",
       "      <td>5896.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>109.25100</td>\n",
       "      <td>94.127000</td>\n",
       "      <td>0.36842</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.529030</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24973</th>\n",
       "      <td>375026</td>\n",
       "      <td>1642.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>3.353</td>\n",
       "      <td>1.2114</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1624.069192</td>\n",
       "      <td>6290.000000</td>\n",
       "      <td>6753.202313</td>\n",
       "      <td>33825.554662</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>37.890000</td>\n",
       "      <td>0.83333</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24974</th>\n",
       "      <td>375027</td>\n",
       "      <td>1709.0</td>\n",
       "      <td>3.680100</td>\n",
       "      <td>7.583</td>\n",
       "      <td>3.1371</td>\n",
       "      <td>0.000</td>\n",
       "      <td>297.000000</td>\n",
       "      <td>8132.000000</td>\n",
       "      <td>297.000000</td>\n",
       "      <td>1041.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>32.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>81.02900</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.59459</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.426800</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24975</th>\n",
       "      <td>375028</td>\n",
       "      <td>1890.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1982.000000</td>\n",
       "      <td>15162.000000</td>\n",
       "      <td>15162.000000</td>\n",
       "      <td>68181.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.04300</td>\n",
       "      <td>55.197000</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.271430</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24976</th>\n",
       "      <td>375029</td>\n",
       "      <td>1727.0</td>\n",
       "      <td>1.844800</td>\n",
       "      <td>15.181</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>2234.000000</td>\n",
       "      <td>2754.000000</td>\n",
       "      <td>2234.000000</td>\n",
       "      <td>2676.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.66667</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.878900</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24977</th>\n",
       "      <td>375030</td>\n",
       "      <td>1789.0</td>\n",
       "      <td>1.299400</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>364.000000</td>\n",
       "      <td>17838.000000</td>\n",
       "      <td>17838.000000</td>\n",
       "      <td>8424.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>109.30700</td>\n",
       "      <td>75.052000</td>\n",
       "      <td>0.15385</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.696940</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24978</th>\n",
       "      <td>375031</td>\n",
       "      <td>1706.0</td>\n",
       "      <td>0.499700</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>297.000000</td>\n",
       "      <td>98.000000</td>\n",
       "      <td>546.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.66667</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24979</th>\n",
       "      <td>375032</td>\n",
       "      <td>1638.0</td>\n",
       "      <td>4.680200</td>\n",
       "      <td>16.751</td>\n",
       "      <td>2.6642</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1624.069192</td>\n",
       "      <td>7937.000000</td>\n",
       "      <td>6753.202313</td>\n",
       "      <td>3032.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>102.70900</td>\n",
       "      <td>13.882000</td>\n",
       "      <td>0.50000</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.726400</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24980</th>\n",
       "      <td>375033</td>\n",
       "      <td>1855.0</td>\n",
       "      <td>1.996500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>350.000000</td>\n",
       "      <td>30203.000000</td>\n",
       "      <td>22656.000000</td>\n",
       "      <td>168999.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.741060</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.092712</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24981</th>\n",
       "      <td>375034</td>\n",
       "      <td>1790.0</td>\n",
       "      <td>0.205000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>237.000000</td>\n",
       "      <td>18018.000000</td>\n",
       "      <td>13297.000000</td>\n",
       "      <td>3914.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.20000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.415820</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24982</th>\n",
       "      <td>375035</td>\n",
       "      <td>1546.0</td>\n",
       "      <td>0.349100</td>\n",
       "      <td>50.803</td>\n",
       "      <td>4.2695</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1624.069192</td>\n",
       "      <td>17750.368864</td>\n",
       "      <td>6753.202313</td>\n",
       "      <td>3330.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.70370</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.00000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24983</th>\n",
       "      <td>375036</td>\n",
       "      <td>1777.0</td>\n",
       "      <td>3.962900</td>\n",
       "      <td>0.968</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>23707.000000</td>\n",
       "      <td>23707.000000</td>\n",
       "      <td>33432.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>80.934000</td>\n",
       "      <td>0.04000</td>\n",
       "      <td>15.0</td>\n",
       "      <td>0.647520</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24984</th>\n",
       "      <td>375037</td>\n",
       "      <td>1943.0</td>\n",
       "      <td>1.118127</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>24775.000000</td>\n",
       "      <td>24775.000000</td>\n",
       "      <td>80772.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.970680</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.092712</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24985</th>\n",
       "      <td>375038</td>\n",
       "      <td>1691.0</td>\n",
       "      <td>0.166300</td>\n",
       "      <td>1.979</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>9591.000000</td>\n",
       "      <td>2627.000000</td>\n",
       "      <td>46903.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>84.80100</td>\n",
       "      <td>63.855000</td>\n",
       "      <td>0.03448</td>\n",
       "      <td>14.0</td>\n",
       "      <td>0.434410</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24986</th>\n",
       "      <td>375039</td>\n",
       "      <td>1681.0</td>\n",
       "      <td>0.173900</td>\n",
       "      <td>9.006</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>6.568</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>3004.000000</td>\n",
       "      <td>2251.000000</td>\n",
       "      <td>6818.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>96.30900</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.71429</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.889080</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24987</th>\n",
       "      <td>375040</td>\n",
       "      <td>1723.0</td>\n",
       "      <td>1.057000</td>\n",
       "      <td>0.285</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>248.000000</td>\n",
       "      <td>28479.000000</td>\n",
       "      <td>28479.000000</td>\n",
       "      <td>16352.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.723440</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24988</th>\n",
       "      <td>375041</td>\n",
       "      <td>1693.0</td>\n",
       "      <td>1.214500</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>18.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>991.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.366190</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.092712</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24989</th>\n",
       "      <td>375042</td>\n",
       "      <td>1592.0</td>\n",
       "      <td>6.480500</td>\n",
       "      <td>5.250</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>1.204</td>\n",
       "      <td>1624.069192</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6753.202313</td>\n",
       "      <td>33825.554662</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>100.00000</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>1.00000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.506490</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.092712</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24990</th>\n",
       "      <td>375043</td>\n",
       "      <td>1641.0</td>\n",
       "      <td>0.660100</td>\n",
       "      <td>8.614</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1624.069192</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6753.202313</td>\n",
       "      <td>33825.554662</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>100.00000</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>1.00000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.092712</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24991</th>\n",
       "      <td>375044</td>\n",
       "      <td>1740.0</td>\n",
       "      <td>0.390100</td>\n",
       "      <td>4.322</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>490.000000</td>\n",
       "      <td>29460.000000</td>\n",
       "      <td>9449.000000</td>\n",
       "      <td>42047.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.20000</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.889570</td>\n",
       "      <td>1.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24992</th>\n",
       "      <td>375045</td>\n",
       "      <td>1651.0</td>\n",
       "      <td>2.490900</td>\n",
       "      <td>1.335</td>\n",
       "      <td>0.9108</td>\n",
       "      <td>0.000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>3163.000000</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>1982.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>82.382000</td>\n",
       "      <td>0.61538</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.937450</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24993</th>\n",
       "      <td>375046</td>\n",
       "      <td>1729.0</td>\n",
       "      <td>1.360100</td>\n",
       "      <td>0.218</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5675.000000</td>\n",
       "      <td>167.000000</td>\n",
       "      <td>15071.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.23810</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.718660</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24994</th>\n",
       "      <td>375047</td>\n",
       "      <td>1730.0</td>\n",
       "      <td>1.670100</td>\n",
       "      <td>5.554</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>104.000000</td>\n",
       "      <td>5692.000000</td>\n",
       "      <td>496.000000</td>\n",
       "      <td>4410.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>79.485000</td>\n",
       "      <td>0.30769</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.933120</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24995</th>\n",
       "      <td>375048</td>\n",
       "      <td>1715.0</td>\n",
       "      <td>12.000200</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1624.069192</td>\n",
       "      <td>991.000000</td>\n",
       "      <td>6753.202313</td>\n",
       "      <td>8751.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.07692</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.702558</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24996</th>\n",
       "      <td>375049</td>\n",
       "      <td>1800.0</td>\n",
       "      <td>0.055100</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>5946.000000</td>\n",
       "      <td>14867.000000</td>\n",
       "      <td>9613.000000</td>\n",
       "      <td>46490.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.05882</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.998590</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24997</th>\n",
       "      <td>375050</td>\n",
       "      <td>1686.0</td>\n",
       "      <td>1.330100</td>\n",
       "      <td>2.025</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>2.025</td>\n",
       "      <td>1624.069192</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>6753.202313</td>\n",
       "      <td>4582.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>124.17100</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.30000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.775190</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.092712</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24998</th>\n",
       "      <td>375051</td>\n",
       "      <td>1826.0</td>\n",
       "      <td>1.118127</td>\n",
       "      <td>0.428</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>3568.000000</td>\n",
       "      <td>26277.000000</td>\n",
       "      <td>9058.000000</td>\n",
       "      <td>72739.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>50.119000</td>\n",
       "      <td>0.03333</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.403430</td>\n",
       "      <td>0.07128</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24999</th>\n",
       "      <td>375052</td>\n",
       "      <td>1916.0</td>\n",
       "      <td>0.139400</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>18889.000000</td>\n",
       "      <td>18889.000000</td>\n",
       "      <td>18889.000000</td>\n",
       "      <td>28343.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>98.49114</td>\n",
       "      <td>71.990942</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.996630</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25000 rows × 48 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       application_key   mvar1      mvar2   mvar3    mvar4  mvar5  \\\n",
       "0               350053  1753.0   0.500100   0.000   0.0000  0.000   \n",
       "1               350054  1894.0   1.970100   0.000   0.0000  0.000   \n",
       "2               350055  1774.0   0.171800   0.000   0.0000  0.000   \n",
       "3               350056  1586.0   0.112300   5.299   0.0000  0.000   \n",
       "4               350057  1832.0   1.444200   0.000   0.0000  0.000   \n",
       "5               350058  1838.0   0.054400   0.241   0.0000  0.000   \n",
       "6               350059  1743.0   1.075300   0.272   0.0000  0.000   \n",
       "7               350060  1935.0   0.560100   0.000   0.0000  0.000   \n",
       "8               350061  1885.0   0.081100   0.000   0.0000  0.000   \n",
       "9               350062  1730.0   0.744400   0.000   0.0000  0.000   \n",
       "10              350063  1731.0   0.509700   0.000   0.0000  0.000   \n",
       "11              350064  1755.0   0.301300   0.000   0.0000  0.000   \n",
       "12              350065  1739.0   2.290900   0.000   0.0000  0.000   \n",
       "13              350066  1562.0   0.000000  34.611   3.7845  0.000   \n",
       "14              350067  1798.0   5.082500   0.000   0.0000  0.000   \n",
       "15              350068  1684.0   1.547900   1.338   0.0000  0.000   \n",
       "16              350069  1789.0   0.000000   1.428   0.0000  0.000   \n",
       "17              350070  1862.0   0.240100   0.000   0.0000  0.000   \n",
       "18              350071  1767.0   0.300100   1.514   0.0000  0.000   \n",
       "19              350072  1802.0   0.636400   0.000   0.0000  0.000   \n",
       "20              350073  1780.0   1.955900   0.000   0.0000  0.000   \n",
       "21              350074  1714.0   2.266400   0.000   0.0000  0.000   \n",
       "22              350075  1923.0   0.088000   0.000   0.0000  0.000   \n",
       "23              350076  1743.0   1.720800   2.295   0.0000  0.000   \n",
       "24              350077  1700.0   1.660500   0.000   0.0000  0.000   \n",
       "25              350078  1922.0   1.118127   0.000   0.0000  0.000   \n",
       "26              350079  1777.0   0.412000   0.000   0.0000  0.000   \n",
       "27              350080  1811.0   0.911700   0.410   0.0000  0.410   \n",
       "28              350081  1658.0   2.382900  37.127  10.3678  0.000   \n",
       "29              350082  1827.0   0.280100   0.000   0.0000  0.000   \n",
       "...                ...     ...        ...     ...      ...    ...   \n",
       "24970           375023  1734.0   0.927900   0.520   0.0000  0.000   \n",
       "24971           375024  1849.0   1.830500   0.000   0.0000  0.000   \n",
       "24972           375025  1739.0   1.525100   2.727   0.0000  2.727   \n",
       "24973           375026  1642.0   0.000000   3.353   1.2114  0.000   \n",
       "24974           375027  1709.0   3.680100   7.583   3.1371  0.000   \n",
       "24975           375028  1890.0   0.000000   0.000   0.0000  0.000   \n",
       "24976           375029  1727.0   1.844800  15.181   0.0000  0.000   \n",
       "24977           375030  1789.0   1.299400   0.000   0.0000  0.000   \n",
       "24978           375031  1706.0   0.499700   0.000   0.0000  0.000   \n",
       "24979           375032  1638.0   4.680200  16.751   2.6642  0.000   \n",
       "24980           375033  1855.0   1.996500   0.000   0.0000  0.000   \n",
       "24981           375034  1790.0   0.205000   0.000   0.0000  0.000   \n",
       "24982           375035  1546.0   0.349100  50.803   4.2695  0.000   \n",
       "24983           375036  1777.0   3.962900   0.968   0.0000  0.000   \n",
       "24984           375037  1943.0   1.118127   0.000   0.0000  0.000   \n",
       "24985           375038  1691.0   0.166300   1.979   0.0000  0.000   \n",
       "24986           375039  1681.0   0.173900   9.006   0.0000  6.568   \n",
       "24987           375040  1723.0   1.057000   0.285   0.0000  0.000   \n",
       "24988           375041  1693.0   1.214500   0.000   0.0000  0.000   \n",
       "24989           375042  1592.0   6.480500   5.250   0.0000  1.204   \n",
       "24990           375043  1641.0   0.660100   8.614   0.0000  0.000   \n",
       "24991           375044  1740.0   0.390100   4.322   0.0000  0.000   \n",
       "24992           375045  1651.0   2.490900   1.335   0.9108  0.000   \n",
       "24993           375046  1729.0   1.360100   0.218   0.0000  0.000   \n",
       "24994           375047  1730.0   1.670100   5.554   0.0000  0.000   \n",
       "24995           375048  1715.0  12.000200   0.000   0.0000  0.000   \n",
       "24996           375049  1800.0   0.055100   0.000   0.0000  0.000   \n",
       "24997           375050  1686.0   1.330100   2.025   0.0000  2.025   \n",
       "24998           375051  1826.0   1.118127   0.428   0.0000  0.000   \n",
       "24999           375052  1916.0   0.139400   0.000   0.0000  0.000   \n",
       "\n",
       "              mvar6         mvar7         mvar8          mvar9   ...    \\\n",
       "0        206.000000  19179.000000    206.000000   14221.000000   ...     \n",
       "1        297.000000  19820.000000  19820.000000  176895.000000   ...     \n",
       "2        197.000000   2563.000000    877.000000    8869.000000   ...     \n",
       "3       1624.069192  17750.368864   6753.202313   33825.554662   ...     \n",
       "4        179.000000   7577.000000    179.000000   21059.000000   ...     \n",
       "5        882.000000  14039.000000  10976.000000  278941.000000   ...     \n",
       "6        397.000000  16141.000000   3568.000000   69482.000000   ...     \n",
       "7        496.000000  44919.000000  17115.000000  124814.000000   ...     \n",
       "8       7369.000000  19264.000000  19264.000000   59956.000000   ...     \n",
       "9          0.000000   2103.000000    582.000000   16429.000000   ...     \n",
       "10      2433.000000   8673.000000   8673.000000    6739.000000   ...     \n",
       "11       261.000000   4051.000000    261.000000     297.000000   ...     \n",
       "12         0.000000   7620.000000   7620.000000   64983.000000   ...     \n",
       "13      1624.069192     18.000000   6753.202313     198.000000   ...     \n",
       "14       259.000000   3359.000000   2973.000000   22099.000000   ...     \n",
       "15      1624.069192  17750.368864   6753.202313   33825.554662   ...     \n",
       "16      2478.000000  13874.000000  13874.000000   98011.000000   ...     \n",
       "17      1487.000000  12310.000000   3964.000000    7928.000000   ...     \n",
       "18       991.000000   2478.000000   2478.000000    8790.000000   ...     \n",
       "19        96.000000  18759.000000  10905.000000   51037.000000   ...     \n",
       "20       191.000000  12525.000000  12525.000000   18932.000000   ...     \n",
       "21        31.000000   1671.000000     57.000000     396.000000   ...     \n",
       "22      5946.000000  53893.000000  24739.000000  128435.000000   ...     \n",
       "23       159.000000   3621.000000   2323.000000    9018.000000   ...     \n",
       "24         0.000000   1037.000000     46.000000     892.000000   ...     \n",
       "25      4524.000000  15530.000000  14819.000000  116154.000000   ...     \n",
       "26       369.000000   6201.000000   6201.000000   66477.000000   ...     \n",
       "27       297.000000  27717.000000   9815.000000  110001.000000   ...     \n",
       "28         0.000000    396.000000      0.000000    6566.000000   ...     \n",
       "29       678.000000   1189.000000   1189.000000     892.000000   ...     \n",
       "...             ...           ...           ...            ...   ...     \n",
       "24970    256.000000  11643.000000   1524.000000   16748.000000   ...     \n",
       "24971   2251.000000  33275.000000   7505.000000   44843.000000   ...     \n",
       "24972      8.000000   2129.000000    720.000000    5896.000000   ...     \n",
       "24973   1624.069192   6290.000000   6753.202313   33825.554662   ...     \n",
       "24974    297.000000   8132.000000    297.000000    1041.000000   ...     \n",
       "24975   1982.000000  15162.000000  15162.000000   68181.000000   ...     \n",
       "24976   2234.000000   2754.000000   2234.000000    2676.000000   ...     \n",
       "24977    364.000000  17838.000000  17838.000000    8424.000000   ...     \n",
       "24978     98.000000    297.000000     98.000000     546.000000   ...     \n",
       "24979   1624.069192   7937.000000   6753.202313    3032.000000   ...     \n",
       "24980    350.000000  30203.000000  22656.000000  168999.000000   ...     \n",
       "24981    237.000000  18018.000000  13297.000000    3914.000000   ...     \n",
       "24982   1624.069192  17750.368864   6753.202313    3330.000000   ...     \n",
       "24983     14.000000  23707.000000  23707.000000   33432.000000   ...     \n",
       "24984      0.000000  24775.000000  24775.000000   80772.000000   ...     \n",
       "24985      0.000000   9591.000000   2627.000000   46903.000000   ...     \n",
       "24986      0.000000   3004.000000   2251.000000    6818.000000   ...     \n",
       "24987    248.000000  28479.000000  28479.000000   16352.000000   ...     \n",
       "24988     18.000000    100.000000    100.000000     991.000000   ...     \n",
       "24989   1624.069192      0.000000   6753.202313   33825.554662   ...     \n",
       "24990   1624.069192      0.000000   6753.202313   33825.554662   ...     \n",
       "24991    490.000000  29460.000000   9449.000000   42047.000000   ...     \n",
       "24992      4.000000   3163.000000      4.000000    1982.000000   ...     \n",
       "24993      0.000000   5675.000000    167.000000   15071.000000   ...     \n",
       "24994    104.000000   5692.000000    496.000000    4410.000000   ...     \n",
       "24995   1624.069192    991.000000   6753.202313    8751.000000   ...     \n",
       "24996   5946.000000  14867.000000   9613.000000   46490.000000   ...     \n",
       "24997   1624.069192      0.000000   6753.202313    4582.000000   ...     \n",
       "24998   3568.000000  26277.000000   9058.000000   72739.000000   ...     \n",
       "24999  18889.000000  18889.000000  18889.000000   28343.000000   ...     \n",
       "\n",
       "       mvar38    mvar39     mvar40      mvar41   mvar42  mvar43    mvar44  \\\n",
       "0         1.0  0.000000   98.49114   20.551000  0.42105     3.0  0.856610   \n",
       "1         3.0  0.000000   98.49114   63.047000  0.00000    15.0  0.943910   \n",
       "2         1.0  0.000000   98.49114   83.797000  0.33333     3.0  0.764670   \n",
       "3         1.0  0.089912   98.49114   71.990942  1.50000     0.0  0.702558   \n",
       "4         3.0  0.000000   96.05200   66.665000  0.00000    23.0  0.791900   \n",
       "5         4.0  0.000000   98.49114   77.780000  0.00000    21.0  0.924620   \n",
       "6         6.0  0.000000   98.49114   67.159000  0.00000    14.0  0.713470   \n",
       "7         9.0  0.000000   98.49114   71.990942  0.00000    15.0  0.924030   \n",
       "8         1.0  0.000000   98.49114   71.990942  0.00000     5.0  0.897600   \n",
       "9         9.0  0.000000   98.49114   71.990942  0.05882    14.0  0.405290   \n",
       "10        2.0  0.000000   98.49114   71.990942  0.23529     1.0  0.642420   \n",
       "11        3.0  0.000000   98.49114   71.990942  0.33333     2.0  0.991420   \n",
       "12       11.0  0.000000   98.49114   95.000000  0.05882    16.0  0.441670   \n",
       "13        7.0  1.000000  124.91000   99.934000  0.87500     1.0  0.845920   \n",
       "14        5.0  0.000000   98.49114   76.881000  0.05882    13.0  0.433650   \n",
       "15        3.0  0.089912   98.49114   71.990942  1.50000     0.0  0.702558   \n",
       "16        4.0  0.000000   98.49114   71.990942  0.05000    13.0  0.512310   \n",
       "17        6.0  0.000000   98.49114   77.419000  0.00000     7.0  0.566850   \n",
       "18        1.0  0.000000   98.49114   71.990942  0.10000     3.0  0.702558   \n",
       "19        3.0  0.000000   98.49114   58.972000  0.00000     9.0  0.594090   \n",
       "20        7.0  0.000000   98.49114  100.000000  0.00000     7.0  0.927520   \n",
       "21        6.0  0.000000   98.49114   91.666000  0.37500     5.0  0.348360   \n",
       "22        2.0  0.000000   98.49114   90.429000  0.00000     9.0  0.885540   \n",
       "23        8.0  0.000000   98.49114   82.323000  0.10000     9.0  0.594420   \n",
       "24        5.0  0.000000   98.49114   71.990942  0.20000     5.0  0.948260   \n",
       "25        3.0  0.000000   98.49114   71.990942  0.00000    12.0  0.915500   \n",
       "26       12.0  0.000000   98.49114   71.990942  0.03846    23.0  0.151590   \n",
       "27        3.0  0.000000   98.49114   74.996000  0.00000    15.0  0.566710   \n",
       "28       14.0  0.000000   98.49114   71.990942  0.57692     8.0  0.353390   \n",
       "29        3.0  0.000000   98.49114   71.990942  0.00000     2.0  1.000000   \n",
       "...       ...       ...        ...         ...      ...     ...       ...   \n",
       "24970     7.0  0.000000   98.49114   71.990942  0.00000    10.0  0.380780   \n",
       "24971     2.0  0.000000   98.49114   91.701000  0.00000     4.0  0.921110   \n",
       "24972     6.0  0.000000  109.25100   94.127000  0.36842    12.0  0.529030   \n",
       "24973     1.0  0.000000   98.49114   37.890000  0.83333     0.0  1.000000   \n",
       "24974    32.0  0.000000   81.02900   71.990942  0.59459    11.0  0.426800   \n",
       "24975     2.0  0.000000   98.04300   55.197000  0.00000    15.0  0.271430   \n",
       "24976     4.0  0.000000   98.49114   71.990942  0.66667     5.0  0.878900   \n",
       "24977     5.0  0.000000  109.30700   75.052000  0.15385     8.0  0.696940   \n",
       "24978     7.0  0.000000   98.49114   71.990942  0.66667     4.0  1.000000   \n",
       "24979     3.0  1.000000  102.70900   13.882000  0.50000     4.0  0.726400   \n",
       "24980     2.0  0.000000   98.49114   71.990942  0.00000    12.0  0.741060   \n",
       "24981     5.0  0.000000   98.49114   71.990942  0.20000     2.0  0.415820   \n",
       "24982     8.0  0.000000   98.49114   71.990942  0.70370     2.0  1.000000   \n",
       "24983    12.0  0.000000   98.49114   80.934000  0.04000    15.0  0.647520   \n",
       "24984     0.0  0.000000   98.49114   71.990942  0.00000     6.0  0.970680   \n",
       "24985     5.0  0.000000   84.80100   63.855000  0.03448    14.0  0.434410   \n",
       "24986     1.0  1.000000   96.30900   71.990942  0.71429     2.0  0.889080   \n",
       "24987     7.0  0.000000   98.49114   71.990942  0.00000     6.0  0.723440   \n",
       "24988     3.0  0.000000   98.49114   71.990942  0.00000     3.0  0.366190   \n",
       "24989     3.0  0.000000  100.00000   71.990942  1.00000     1.0  0.506490   \n",
       "24990     3.0  0.000000  100.00000   71.990942  1.00000     1.0  1.000000   \n",
       "24991     3.0  0.000000   98.49114   71.990942  0.20000     4.0  0.889570   \n",
       "24992    10.0  0.000000   98.49114   82.382000  0.61538     3.0  0.937450   \n",
       "24993     5.0  0.000000   98.49114   71.990942  0.23810    13.0  0.718660   \n",
       "24994     5.0  0.000000   98.49114   79.485000  0.30769     4.0  0.933120   \n",
       "24995     1.0  0.000000   98.49114   71.990942  0.07692     4.0  0.702558   \n",
       "24996     4.0  0.000000   98.49114   71.990942  0.05882     8.0  0.998590   \n",
       "24997     0.0  0.000000  124.17100   71.990942  0.30000     2.0  0.775190   \n",
       "24998     2.0  0.000000   98.49114   50.119000  0.03333    11.0  0.403430   \n",
       "24999     0.0  0.000000   98.49114   71.990942  0.00000     5.0  0.996630   \n",
       "\n",
       "        mvar45    mvar46  mvar47  \n",
       "0      0.07128  0.000000       0  \n",
       "1      0.00000  0.000000       1  \n",
       "2      0.00000  0.000000       1  \n",
       "3      0.07128  0.092712       1  \n",
       "4      0.00000  0.000000       0  \n",
       "5      0.00000  0.000000       0  \n",
       "6      0.00000  0.000000       0  \n",
       "7      0.00000  0.000000       0  \n",
       "8      0.00000  0.092712       0  \n",
       "9      0.07128  0.000000       1  \n",
       "10     0.00000  0.092712       1  \n",
       "11     0.07128  0.000000       1  \n",
       "12     0.07128  0.000000       1  \n",
       "13     1.00000  1.000000       1  \n",
       "14     0.00000  0.000000       1  \n",
       "15     0.07128  0.092712       1  \n",
       "16     0.07128  0.092712       0  \n",
       "17     0.00000  0.000000       1  \n",
       "18     0.07128  0.092712       1  \n",
       "19     0.00000  0.000000       1  \n",
       "20     0.00000  0.000000       1  \n",
       "21     0.07128  0.000000       1  \n",
       "22     0.00000  0.000000       1  \n",
       "23     0.07128  0.000000       1  \n",
       "24     0.07128  0.000000       0  \n",
       "25     0.00000  0.000000       0  \n",
       "26     0.07128  0.092712       1  \n",
       "27     0.00000  0.000000       1  \n",
       "28     0.07128  2.000000       1  \n",
       "29     0.07128  0.092712       1  \n",
       "...        ...       ...     ...  \n",
       "24970  0.07128  0.000000       0  \n",
       "24971  0.00000  0.000000       0  \n",
       "24972  0.07128  0.000000       1  \n",
       "24973  0.07128  0.000000       1  \n",
       "24974  0.07128  2.000000       1  \n",
       "24975  0.07128  0.000000       1  \n",
       "24976  0.00000  0.000000       1  \n",
       "24977  0.00000  0.000000       0  \n",
       "24978  0.07128  0.000000       1  \n",
       "24979  0.07128  0.000000       1  \n",
       "24980  0.00000  0.092712       0  \n",
       "24981  0.07128  0.000000       1  \n",
       "24982  1.00000  1.000000       1  \n",
       "24983  0.07128  0.000000       0  \n",
       "24984  0.00000  0.092712       1  \n",
       "24985  0.07128  0.000000       1  \n",
       "24986  0.00000  0.000000       1  \n",
       "24987  0.07128  0.000000       1  \n",
       "24988  0.07128  0.092712       1  \n",
       "24989  0.07128  0.092712       1  \n",
       "24990  0.07128  0.092712       0  \n",
       "24991  1.00000  0.000000       0  \n",
       "24992  0.07128  0.000000       0  \n",
       "24993  0.07128  0.000000       1  \n",
       "24994  0.07128  0.000000       1  \n",
       "24995  0.07128  0.000000       1  \n",
       "24996  0.00000  0.000000       0  \n",
       "24997  0.07128  0.092712       0  \n",
       "24998  0.07128  0.000000       1  \n",
       "24999  0.00000  0.000000       1  \n",
       "\n",
       "[25000 rows x 48 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "leaderboard_data.fillna(leaderboard_data.mean(),inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "x_test = leaderboard_data.loc[:,'mvar1':]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "LogisticRegression(C=1.0, class_weight=None, dual=False, fit_intercept=True,\n",
       "          intercept_scaling=1, max_iter=100, multi_class='ovr', n_jobs=1,\n",
       "          penalty='l2', random_state=None, solver='liblinear', tol=0.0001,\n",
       "          verbose=0, warm_start=False)"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn.linear_model import LogisticRegression\n",
    "clf = LogisticRegression()\n",
    "clf.fit(x_train,y_train)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "pred = clf.predict_proba(x_test)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "pred = pd.DataFrame(pred)\n",
    "pred['application_key'] = leaderboard_data['application_key']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(25000, 3)"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pred.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "pred = pred.sort_values(by = 0,kind = 'mergesort',ascending = False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "cols = pred.columns.tolist()\n",
    "cols = cols[-1:] + cols[:-1]\n",
    "pred = pred[cols]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "pred = pred.loc[:,'application_key':]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "submit = pred['application_key'][:10000]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "submit = pd.DataFrame(submit)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "submit"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "submit[0] = 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 183,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "submit.to_csv('flabbergasted_IITGuwahati_34.csv',header = False, index = False)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "'Series' object has no attribute 'columns'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-57-ca57f0e55a1c>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0msubmit\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m~/anaconda3/lib/python3.6/site-packages/pandas/core/generic.py\u001b[0m in \u001b[0;36m__getattr__\u001b[0;34m(self, name)\u001b[0m\n\u001b[1;32m   3608\u001b[0m         if (name in self._internal_names_set or name in self._metadata or\n\u001b[1;32m   3609\u001b[0m                 name in self._accessors):\n\u001b[0;32m-> 3610\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mobject\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m__getattribute__\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mname\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   3611\u001b[0m         \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3612\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mname\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_info_axis\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mAttributeError\u001b[0m: 'Series' object has no attribute 'columns'"
     ]
    }
   ],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}