MODEL2.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Data_Mining_HW",
      "provenance": [],
      "collapsed_sections": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "metadata": {
        "id": "7a2ccUaIsTdw",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "import numpy as np\n",
        "import pandas as pd\n",
        "import matplotlib.pyplot as plt"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "4Tcy_-YKx2d9",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "data_train = pd.read_csv('aps_failure_train.csv')"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "-2iBisd20zqb",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "data_test = pd.read_csv('aps_failure_test.csv')"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "QQC90_3c1GsA",
        "colab_type": "code",
        "outputId": "3982a97a-5517-4481-8ca4-9e029dbbb0c4",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 251
        }
      },
      "source": [
        "display(data_train.head(5))"
      ],
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>class</th>\n",
              "      <th>aa_000</th>\n",
              "      <th>ab_000</th>\n",
              "      <th>ac_000</th>\n",
              "      <th>ad_000</th>\n",
              "      <th>ae_000</th>\n",
              "      <th>af_000</th>\n",
              "      <th>ag_000</th>\n",
              "      <th>ag_001</th>\n",
              "      <th>ag_002</th>\n",
              "      <th>ag_003</th>\n",
              "      <th>ag_004</th>\n",
              "      <th>ag_005</th>\n",
              "      <th>ag_006</th>\n",
              "      <th>ag_007</th>\n",
              "      <th>ag_008</th>\n",
              "      <th>ag_009</th>\n",
              "      <th>ah_000</th>\n",
              "      <th>ai_000</th>\n",
              "      <th>aj_000</th>\n",
              "      <th>ak_000</th>\n",
              "      <th>al_000</th>\n",
              "      <th>am_0</th>\n",
              "      <th>an_000</th>\n",
              "      <th>ao_000</th>\n",
              "      <th>ap_000</th>\n",
              "      <th>aq_000</th>\n",
              "      <th>ar_000</th>\n",
              "      <th>as_000</th>\n",
              "      <th>at_000</th>\n",
              "      <th>au_000</th>\n",
              "      <th>av_000</th>\n",
              "      <th>ax_000</th>\n",
              "      <th>ay_000</th>\n",
              "      <th>ay_001</th>\n",
              "      <th>ay_002</th>\n",
              "      <th>ay_003</th>\n",
              "      <th>ay_004</th>\n",
              "      <th>ay_005</th>\n",
              "      <th>ay_006</th>\n",
              "      <th>...</th>\n",
              "      <th>db_000</th>\n",
              "      <th>dc_000</th>\n",
              "      <th>dd_000</th>\n",
              "      <th>de_000</th>\n",
              "      <th>df_000</th>\n",
              "      <th>dg_000</th>\n",
              "      <th>dh_000</th>\n",
              "      <th>di_000</th>\n",
              "      <th>dj_000</th>\n",
              "      <th>dk_000</th>\n",
              "      <th>dl_000</th>\n",
              "      <th>dm_000</th>\n",
              "      <th>dn_000</th>\n",
              "      <th>do_000</th>\n",
              "      <th>dp_000</th>\n",
              "      <th>dq_000</th>\n",
              "      <th>dr_000</th>\n",
              "      <th>ds_000</th>\n",
              "      <th>dt_000</th>\n",
              "      <th>du_000</th>\n",
              "      <th>dv_000</th>\n",
              "      <th>dx_000</th>\n",
              "      <th>dy_000</th>\n",
              "      <th>dz_000</th>\n",
              "      <th>ea_000</th>\n",
              "      <th>eb_000</th>\n",
              "      <th>ec_00</th>\n",
              "      <th>ed_000</th>\n",
              "      <th>ee_000</th>\n",
              "      <th>ee_001</th>\n",
              "      <th>ee_002</th>\n",
              "      <th>ee_003</th>\n",
              "      <th>ee_004</th>\n",
              "      <th>ee_005</th>\n",
              "      <th>ee_006</th>\n",
              "      <th>ee_007</th>\n",
              "      <th>ee_008</th>\n",
              "      <th>ee_009</th>\n",
              "      <th>ef_000</th>\n",
              "      <th>eg_000</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>False</td>\n",
              "      <td>3256</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.000000e+00</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>320.0</td>\n",
              "      <td>14800.0</td>\n",
              "      <td>114044.0</td>\n",
              "      <td>64416.0</td>\n",
              "      <td>102.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>88808.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>182400.0</td>\n",
              "      <td>163802.0</td>\n",
              "      <td>27816.0</td>\n",
              "      <td>12172.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>61388.0</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>276.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1214.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2255460.0</td>\n",
              "      <td>182.00</td>\n",
              "      <td>182.0</td>\n",
              "      <td>26270.0</td>\n",
              "      <td>21514.0</td>\n",
              "      <td>7660.0</td>\n",
              "      <td>3148.0</td>\n",
              "      <td>10264.0</td>\n",
              "      <td>121464.0</td>\n",
              "      <td>2944.0</td>\n",
              "      <td>158.0</td>\n",
              "      <td>260.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>False</td>\n",
              "      <td>3474</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8.600000e+01</td>\n",
              "      <td>86.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>168.0</td>\n",
              "      <td>3360.0</td>\n",
              "      <td>165294.0</td>\n",
              "      <td>28272.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>102652.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>196058.0</td>\n",
              "      <td>182014.0</td>\n",
              "      <td>20716.0</td>\n",
              "      <td>10946.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>48.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>93644.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>165416.0</td>\n",
              "      <td>106.0</td>\n",
              "      <td>36.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1122.0</td>\n",
              "      <td>2226.0</td>\n",
              "      <td>426.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>5796.0</td>\n",
              "      <td>1202.0</td>\n",
              "      <td>9800.0</td>\n",
              "      <td>2672.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2474220.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>15902.0</td>\n",
              "      <td>26396.0</td>\n",
              "      <td>23362.0</td>\n",
              "      <td>16746.0</td>\n",
              "      <td>31190.0</td>\n",
              "      <td>25052.0</td>\n",
              "      <td>18384.0</td>\n",
              "      <td>14814.0</td>\n",
              "      <td>24894.0</td>\n",
              "      <td>354.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>False</td>\n",
              "      <td>1332</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.400000e+01</td>\n",
              "      <td>14.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>25192.0</td>\n",
              "      <td>51490.0</td>\n",
              "      <td>17666.0</td>\n",
              "      <td>3654.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>37570.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>12546.0</td>\n",
              "      <td>17598.0</td>\n",
              "      <td>74830.0</td>\n",
              "      <td>74084.0</td>\n",
              "      <td>31356.0</td>\n",
              "      <td>4420.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>94.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>370.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>73172.0</td>\n",
              "      <td>242.0</td>\n",
              "      <td>262.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>24.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1148.0</td>\n",
              "      <td>170.0</td>\n",
              "      <td>32.0</td>\n",
              "      <td>6578.0</td>\n",
              "      <td>2232.0</td>\n",
              "      <td>1798.0</td>\n",
              "      <td>258.0</td>\n",
              "      <td>3140.0</td>\n",
              "      <td>350.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>137.32</td>\n",
              "      <td>164.0</td>\n",
              "      <td>28390.0</td>\n",
              "      <td>9900.0</td>\n",
              "      <td>6520.0</td>\n",
              "      <td>3906.0</td>\n",
              "      <td>12168.0</td>\n",
              "      <td>18422.0</td>\n",
              "      <td>12824.0</td>\n",
              "      <td>5856.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>False</td>\n",
              "      <td>519842</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2.130706e+09</td>\n",
              "      <td>1154.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>8430.0</td>\n",
              "      <td>7424.0</td>\n",
              "      <td>11730124.0</td>\n",
              "      <td>10241340.0</td>\n",
              "      <td>1080276.0</td>\n",
              "      <td>32396.0</td>\n",
              "      <td>20277900.0</td>\n",
              "      <td>36756.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>36300044.0</td>\n",
              "      <td>30541976.0</td>\n",
              "      <td>8792568.0</td>\n",
              "      <td>4611126.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2044.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>330.0</td>\n",
              "      <td>126.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>39034.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>15456814.0</td>\n",
              "      <td>4816.0</td>\n",
              "      <td>72.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>386104.0</td>\n",
              "      <td>21880.0</td>\n",
              "      <td>8806.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>112888.0</td>\n",
              "      <td>24456.0</td>\n",
              "      <td>11009880.0</td>\n",
              "      <td>1209780.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>12630.02</td>\n",
              "      <td>12746.0</td>\n",
              "      <td>5591200.0</td>\n",
              "      <td>4549872.0</td>\n",
              "      <td>2847726.0</td>\n",
              "      <td>1440870.0</td>\n",
              "      <td>3660212.0</td>\n",
              "      <td>3233942.0</td>\n",
              "      <td>1023828.0</td>\n",
              "      <td>455646.0</td>\n",
              "      <td>278716.0</td>\n",
              "      <td>17978.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>False</td>\n",
              "      <td>712</td>\n",
              "      <td>8.0</td>\n",
              "      <td>3.800000e+01</td>\n",
              "      <td>28.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>6654.0</td>\n",
              "      <td>22806.0</td>\n",
              "      <td>57796.0</td>\n",
              "      <td>87004.0</td>\n",
              "      <td>2616.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>83020.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4946.0</td>\n",
              "      <td>8128.0</td>\n",
              "      <td>245656.0</td>\n",
              "      <td>224276.0</td>\n",
              "      <td>132000.0</td>\n",
              "      <td>11622.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>130.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>53642.0</td>\n",
              "      <td>330.0</td>\n",
              "      <td>228.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>380.0</td>\n",
              "      <td>156830.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2028.0</td>\n",
              "      <td>146.0</td>\n",
              "      <td>26.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2360.0</td>\n",
              "      <td>490.0</td>\n",
              "      <td>1800.0</td>\n",
              "      <td>182.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>514.52</td>\n",
              "      <td>418.0</td>\n",
              "      <td>128718.0</td>\n",
              "      <td>16464.0</td>\n",
              "      <td>8214.0</td>\n",
              "      <td>3580.0</td>\n",
              "      <td>6408.0</td>\n",
              "      <td>6366.0</td>\n",
              "      <td>3790.0</td>\n",
              "      <td>3336.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 171 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "   class  aa_000  ab_000        ac_000  ...    ee_008   ee_009  ef_000  eg_000\n",
              "0  False    3256     NaN  0.000000e+00  ...     260.0      0.0     0.0     0.0\n",
              "1  False    3474     NaN  8.600000e+01  ...   24894.0    354.0     0.0     0.0\n",
              "2  False    1332     NaN  2.400000e+01  ...      16.0      0.0     0.0     0.0\n",
              "3  False  519842     NaN  2.130706e+09  ...  278716.0  17978.0     0.0     0.0\n",
              "4  False     712     8.0  3.800000e+01  ...       0.0      0.0     0.0     0.0\n",
              "\n",
              "[5 rows x 171 columns]"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "GSHdzI_w1e0d",
        "colab_type": "code",
        "outputId": "1f5e12e7-9435-4bdc-fdca-6e5bb7079277",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 251
        }
      },
      "source": [
        "display(data_test.head(5))"
      ],
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>class</th>\n",
              "      <th>aa_000</th>\n",
              "      <th>ab_000</th>\n",
              "      <th>ac_000</th>\n",
              "      <th>ad_000</th>\n",
              "      <th>ae_000</th>\n",
              "      <th>af_000</th>\n",
              "      <th>ag_000</th>\n",
              "      <th>ag_001</th>\n",
              "      <th>ag_002</th>\n",
              "      <th>ag_003</th>\n",
              "      <th>ag_004</th>\n",
              "      <th>ag_005</th>\n",
              "      <th>ag_006</th>\n",
              "      <th>ag_007</th>\n",
              "      <th>ag_008</th>\n",
              "      <th>ag_009</th>\n",
              "      <th>ah_000</th>\n",
              "      <th>ai_000</th>\n",
              "      <th>aj_000</th>\n",
              "      <th>ak_000</th>\n",
              "      <th>al_000</th>\n",
              "      <th>am_0</th>\n",
              "      <th>an_000</th>\n",
              "      <th>ao_000</th>\n",
              "      <th>ap_000</th>\n",
              "      <th>aq_000</th>\n",
              "      <th>ar_000</th>\n",
              "      <th>as_000</th>\n",
              "      <th>at_000</th>\n",
              "      <th>au_000</th>\n",
              "      <th>av_000</th>\n",
              "      <th>ax_000</th>\n",
              "      <th>ay_000</th>\n",
              "      <th>ay_001</th>\n",
              "      <th>ay_002</th>\n",
              "      <th>ay_003</th>\n",
              "      <th>ay_004</th>\n",
              "      <th>ay_005</th>\n",
              "      <th>ay_006</th>\n",
              "      <th>...</th>\n",
              "      <th>db_000</th>\n",
              "      <th>dc_000</th>\n",
              "      <th>dd_000</th>\n",
              "      <th>de_000</th>\n",
              "      <th>df_000</th>\n",
              "      <th>dg_000</th>\n",
              "      <th>dh_000</th>\n",
              "      <th>di_000</th>\n",
              "      <th>dj_000</th>\n",
              "      <th>dk_000</th>\n",
              "      <th>dl_000</th>\n",
              "      <th>dm_000</th>\n",
              "      <th>dn_000</th>\n",
              "      <th>do_000</th>\n",
              "      <th>dp_000</th>\n",
              "      <th>dq_000</th>\n",
              "      <th>dr_000</th>\n",
              "      <th>ds_000</th>\n",
              "      <th>dt_000</th>\n",
              "      <th>du_000</th>\n",
              "      <th>dv_000</th>\n",
              "      <th>dx_000</th>\n",
              "      <th>dy_000</th>\n",
              "      <th>dz_000</th>\n",
              "      <th>ea_000</th>\n",
              "      <th>eb_000</th>\n",
              "      <th>ec_00</th>\n",
              "      <th>ed_000</th>\n",
              "      <th>ee_000</th>\n",
              "      <th>ee_001</th>\n",
              "      <th>ee_002</th>\n",
              "      <th>ee_003</th>\n",
              "      <th>ee_004</th>\n",
              "      <th>ee_005</th>\n",
              "      <th>ee_006</th>\n",
              "      <th>ee_007</th>\n",
              "      <th>ee_008</th>\n",
              "      <th>ee_009</th>\n",
              "      <th>ef_000</th>\n",
              "      <th>eg_000</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>NaN</td>\n",
              "      <td>43184</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>980.0</td>\n",
              "      <td>225340.0</td>\n",
              "      <td>2125658.0</td>\n",
              "      <td>339908.0</td>\n",
              "      <td>1974.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1365772.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>270.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2438136.0</td>\n",
              "      <td>2213144.0</td>\n",
              "      <td>380434.0</td>\n",
              "      <td>173496.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>343650.0</td>\n",
              "      <td>1259068.0</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2458.0</td>\n",
              "      <td>92.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>16830.0</td>\n",
              "      <td>33088.0</td>\n",
              "      <td>6280.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>79016.0</td>\n",
              "      <td>14646.0</td>\n",
              "      <td>2485320.0</td>\n",
              "      <td>656576.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>13183300.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>488530.0</td>\n",
              "      <td>454562.0</td>\n",
              "      <td>229646.0</td>\n",
              "      <td>110134.0</td>\n",
              "      <td>211420.0</td>\n",
              "      <td>175746.0</td>\n",
              "      <td>170688.0</td>\n",
              "      <td>190998.0</td>\n",
              "      <td>618038.0</td>\n",
              "      <td>44098.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>NaN</td>\n",
              "      <td>1230</td>\n",
              "      <td>NaN</td>\n",
              "      <td>88.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>202.0</td>\n",
              "      <td>4640.0</td>\n",
              "      <td>52958.0</td>\n",
              "      <td>31692.0</td>\n",
              "      <td>140.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>31102.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>252.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>99428.0</td>\n",
              "      <td>87122.0</td>\n",
              "      <td>31576.0</td>\n",
              "      <td>5548.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>146.0</td>\n",
              "      <td>50.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>52858.0</td>\n",
              "      <td>...</td>\n",
              "      <td>58.0</td>\n",
              "      <td>69382.0</td>\n",
              "      <td>212.0</td>\n",
              "      <td>88.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>782.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>192.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>734.0</td>\n",
              "      <td>178.0</td>\n",
              "      <td>16580.0</td>\n",
              "      <td>1704.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>228290.0</td>\n",
              "      <td>129.80</td>\n",
              "      <td>146.0</td>\n",
              "      <td>24190.0</td>\n",
              "      <td>9862.0</td>\n",
              "      <td>2666.0</td>\n",
              "      <td>1074.0</td>\n",
              "      <td>3382.0</td>\n",
              "      <td>48444.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>NaN</td>\n",
              "      <td>240</td>\n",
              "      <td>0.0</td>\n",
              "      <td>18.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2282.0</td>\n",
              "      <td>24328.0</td>\n",
              "      <td>20174.0</td>\n",
              "      <td>8466.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>19006.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4916.0</td>\n",
              "      <td>9490.0</td>\n",
              "      <td>55782.0</td>\n",
              "      <td>39600.0</td>\n",
              "      <td>78070.0</td>\n",
              "      <td>6052.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>26.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4720.0</td>\n",
              "      <td>202.0</td>\n",
              "      <td>256.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>31212.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1342.0</td>\n",
              "      <td>74.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>958.0</td>\n",
              "      <td>150.0</td>\n",
              "      <td>920.0</td>\n",
              "      <td>92.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>324.44</td>\n",
              "      <td>264.0</td>\n",
              "      <td>37854.0</td>\n",
              "      <td>7302.0</td>\n",
              "      <td>2612.0</td>\n",
              "      <td>624.0</td>\n",
              "      <td>1072.0</td>\n",
              "      <td>2592.0</td>\n",
              "      <td>1880.0</td>\n",
              "      <td>1308.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>NaN</td>\n",
              "      <td>31510</td>\n",
              "      <td>NaN</td>\n",
              "      <td>636.0</td>\n",
              "      <td>586.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>602.0</td>\n",
              "      <td>17786.0</td>\n",
              "      <td>1764998.0</td>\n",
              "      <td>370564.0</td>\n",
              "      <td>25406.0</td>\n",
              "      <td>674.0</td>\n",
              "      <td>904262.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1964614.0</td>\n",
              "      <td>1696936.0</td>\n",
              "      <td>349852.0</td>\n",
              "      <td>219378.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1558.0</td>\n",
              "      <td>218.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>732996.0</td>\n",
              "      <td>...</td>\n",
              "      <td>14.0</td>\n",
              "      <td>1860292.0</td>\n",
              "      <td>1994.0</td>\n",
              "      <td>148.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>14228.0</td>\n",
              "      <td>15894.0</td>\n",
              "      <td>2772.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>54492.0</td>\n",
              "      <td>11840.0</td>\n",
              "      <td>449700.0</td>\n",
              "      <td>54256.0</td>\n",
              "      <td>1834490.0</td>\n",
              "      <td>4544.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>3658180.0</td>\n",
              "      <td>868.88</td>\n",
              "      <td>956.0</td>\n",
              "      <td>342692.0</td>\n",
              "      <td>434804.0</td>\n",
              "      <td>303108.0</td>\n",
              "      <td>128062.0</td>\n",
              "      <td>243134.0</td>\n",
              "      <td>286760.0</td>\n",
              "      <td>165538.0</td>\n",
              "      <td>120136.0</td>\n",
              "      <td>153552.0</td>\n",
              "      <td>2244.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>NaN</td>\n",
              "      <td>384</td>\n",
              "      <td>0.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1502.0</td>\n",
              "      <td>22300.0</td>\n",
              "      <td>54882.0</td>\n",
              "      <td>22132.0</td>\n",
              "      <td>160.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>40846.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>284.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>5222.0</td>\n",
              "      <td>9888.0</td>\n",
              "      <td>102146.0</td>\n",
              "      <td>88042.0</td>\n",
              "      <td>59750.0</td>\n",
              "      <td>8152.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>60.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>31480.0</td>\n",
              "      <td>226.0</td>\n",
              "      <td>108.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>65870.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1066.0</td>\n",
              "      <td>48.0</td>\n",
              "      <td>12.0</td>\n",
              "      <td>47200.0</td>\n",
              "      <td>11192.0</td>\n",
              "      <td>1094.0</td>\n",
              "      <td>386.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>50.0</td>\n",
              "      <td>18026.0</td>\n",
              "      <td>272.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>305.40</td>\n",
              "      <td>254.0</td>\n",
              "      <td>72148.0</td>\n",
              "      <td>10702.0</td>\n",
              "      <td>5902.0</td>\n",
              "      <td>3600.0</td>\n",
              "      <td>5452.0</td>\n",
              "      <td>1144.0</td>\n",
              "      <td>1520.0</td>\n",
              "      <td>464.0</td>\n",
              "      <td>44.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 171 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "   class  aa_000  ab_000  ac_000  ...    ee_008   ee_009  ef_000  eg_000\n",
              "0    NaN   43184     NaN     0.0  ...  618038.0  44098.0     0.0     0.0\n",
              "1    NaN    1230     NaN    88.0  ...       0.0      0.0     0.0     0.0\n",
              "2    NaN     240     0.0    18.0  ...       6.0      0.0     0.0     0.0\n",
              "3    NaN   31510     NaN   636.0  ...  153552.0   2244.0     0.0     0.0\n",
              "4    NaN     384     0.0    30.0  ...      44.0      0.0     0.0     0.0\n",
              "\n",
              "[5 rows x 171 columns]"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "iKOE8Roo2h1h",
        "colab_type": "code",
        "outputId": "723878af-b1fa-4d42-b0a8-b04fdaa7b7c3",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 297
        }
      },
      "source": [
        "data_train['class'].value_counts()\n",
        "\n",
        "target_count = data_train['class'].value_counts()\n",
        "target_count.plot(kind='bar', title='Count (target)');"
      ],
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYMAAAEYCAYAAAC+xZqSAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjIsIGh0\ndHA6Ly9tYXRwbG90bGliLm9yZy8li6FKAAATp0lEQVR4nO3df5BdZX3H8feHRH5YgQTZoZIEk2rU\noi1KU4i1rbapENA2tFXEWokObaYt9JdtFVtHLIqjnbYiok6pUOOPiohWsFiZFGVaZxRYfqlIkS0p\nJmmAlQREqD8C3/5xn8XLupuwezd7N7nv18zOnvOc5znnm2Szn3uec869qSokSYNtn34XIEnqP8NA\nkmQYSJIMA0kShoEkCcNAkoRhIM2YJENJ/ivJAf2uZTJJPpnkhH7XobnHMNAeJclvJRlO8p0kW5P8\nW5Kfn4XjVpKn76LbmcAHq+r/2pirk/zO7q5tMknekuQj45rfCbytH/VobjMMtMdI8jrgXODtwGHA\nEcD7gDX9rAsgyX7AWmD8L99e9jl/pvY1pqquBQ5KsmKm9609m2GgPUKSg4GzgdOr6lNV9WBV/aCq\nPlNVf9H67Jfk3CT/277Obb+kSfKaJF8ct89HX+0n+WCS9ya5IskDSa5J8rS27T/akJvbGckrJijx\nWOC+qtrcxpwD/AJwfhtzfmt/d5JNSb6d5Pokv9BVz1uSXJrkI0m+DbwmyQFJ1ifZnuTWJK9Psrlr\nzOFt6mc0ycYkf9TaVwN/CbyiHf/mrlqvBl4yrX8I7bUMA+0png/sD/zLTvr8FbASeC5wFHAM8KYp\nHOMU4K+BhcAIcA5AVf1i235UVT2pqj4+wdifAm4bW6mqvwL+EzijjTmjbbqu1XcI8M/AJ5Ls37Wf\nNcClwALgo8BZwFLgJ4AXA7891jHJPsBngJuBRcAq4E+SHF9Vn6NzBvXxdvyjuo5xK52/H+lRhoH2\nFE8GvlVVO3bS51XA2VV1T1WN0vnF/uopHONfquradoyP0vml/XgtAB7YVaeq+khV3VtVO6rq74D9\ngGd2dflSVX26qh5p1x5OBt5eVdvbWcd5XX1/FhiqqrOr6vtVdQfwj3RCbWceaPVKj5rxOUlpN7kX\nODTJ/J0EwuHAnV3rd7a2x+uuruWHgCdNYex24MBddUry58Bpra4CDgIO7eqyadyQw8e1dS8/FTg8\nyX1dbfPonJHszIHAfbvoowHjmYH2FF8CvgectJM+/0vnF+SYI1obwIPAE8c2JPnxGa7vK8AzxrU9\n5i2B2/WB19N5tb+wqhYA9wOZbAywFVjctb6ka3kTsLGqFnR9HVhVJ06yrzE/SWdqSXqUYaA9QlXd\nD7wZeG+Sk5I8MckTkpyQ5G9at48Bb2r3+x/a+o/d3XMz8Owkz21z9G+ZYgl305m3n8y1wIIki3Yy\n5kBgBzAKzE/yZjpnBjtzCfDGJAvbvs/o2nYt8ECSN7QLzfOSPCfJz3Ydf2m7ttDthcC/7eK4GjCG\ngfYYbY79dXQuCo/SeWV8BvDp1uVtwDCdV+lfBW5obVTVN+jcjfTvwO3AY+4sehzeAqxPcl+Skyeo\n7fvAB+m6wAu8G3hZuxPoPOBK4HPAN+hMYX2XH50WGu9sYDOwsdV+KZ0zJKrqYeCldK5tbAS+BXwA\nOLiN/UT7fm+SGwBaUHyn3WIqPSp+uI00M5IM0Zmvf97Yg2e74Ri/D5xSVS+c5vhPAhdW1WdntjLt\n6QwDaQ5L8hQ6U01fApYDVwDnV9W5fS1Mex3vJpLmtn2BfwCW0bkD6GI6T11LM8ozA0mSF5AlSXvw\nNNGhhx5aS5cu7XcZkrTHuP76679VVUMTbdtjw2Dp0qUMDw/3uwxJ2mMkuXOybU4TSZIMA0mSYSBJ\nwjCQJGEYSJIwDCRJGAaSJB5HGCS5KMk9Sb7W1XZIkg1Jbm/fF7b2JDkvyUiSryQ5umvM2tb/9iRr\nu9p/JslX25jzkgRJ0qx6PGcGHwRWj2s7E7iqqpYDV7V1gBPovLPicmAd8H7ohAedD/Y+ls6HlJ81\nFiCtz+92jRt/LEnSbrbLJ5Cr6j+SLB3XvAZ4UVteD1wNvKG1f6g673735SQL2lvwvgjYUFXbAJJs\nAFYnuRo4qKq+3No/ROdjDfeKT2FaeuYV/S5hr/I/73hJv0uQ9lrTvWZwWFVtbct3AYe15UU89pOb\nNre2nbVvnqB9QknWJRlOMjw6OjrN0iVJ4/V8AbmdBczK+2BX1QVVtaKqVgwNTfheS5KkaZhuGNzd\npn/GPonpnta+BVjS1W9xa9tZ++IJ2iVJs2i6YXA5MHZH0Frgsq72U9tdRSuB+9t00pXAcUkWtgvH\nxwFXtm3fTrKy3UV0ate+JEmzZJcXkJN8jM4F4EOTbKZzV9A7gEuSnAbcCZzcun8WOBEYAR4CXgtQ\nVduSvBW4rvU7e+xiMvAHdO5YOoDOheO94uKxJO1JHs/dRK+cZNOqCfoWcPok+7kIuGiC9mHgObuq\nQ5K0+/gEsiTJMJAkGQaSJAwDSRKGgSQJw0CShGEgScIwkCRhGEiSMAwkSRgGkiQMA0kShoEkCcNA\nkoRhIEnCMJAkYRhIkjAMJEkYBpIkDANJEoaBJAnDQJKEYSBJwjCQJGEYSJIwDCRJGAaSJAwDSRKG\ngSQJw0CShGEgScIwkCTRYxgk+dMktyT5WpKPJdk/ybIk1yQZSfLxJPu2vvu19ZG2fWnXft7Y2m9L\ncnxvfyRJ0lRNOwySLAL+CFhRVc8B5gGnAO8E3lVVTwe2A6e1IacB21v7u1o/khzZxj0bWA28L8m8\n6dYlSZq6XqeJ5gMHJJkPPBHYCvwycGnbvh44qS2vaeu07auSpLVfXFXfq6qNwAhwTI91SZKmYNph\nUFVbgL8FvkknBO4Hrgfuq6odrdtmYFFbXgRsamN3tP5P7m6fYMxjJFmXZDjJ8Ojo6HRLlySN08s0\n0UI6r+qXAYcDP0Znmme3qaoLqmpFVa0YGhranYeSpIHSyzTRrwAbq2q0qn4AfAp4AbCgTRsBLAa2\ntOUtwBKAtv1g4N7u9gnGSJJmQS9h8E1gZZIntrn/VcDXgS8AL2t91gKXteXL2zpt++erqlr7Ke1u\no2XAcuDaHuqSJE3R/F13mVhVXZPkUuAGYAdwI3ABcAVwcZK3tbYL25ALgQ8nGQG20bmDiKq6Jckl\ndIJkB3B6VT083bokSVM37TAAqKqzgLPGNd/BBHcDVdV3gZdPsp9zgHN6qUWSNH0+gSxJMgwkSYaB\nJAnDQJKEYSBJwjCQJGEYSJIwDCRJGAaSJAwDSRKGgSQJw0CShGEgScIwkCRhGEiSMAwkSRgGkiQM\nA0kShoEkCcNAkoRhIEnCMJAkYRhIkjAMJEkYBpIkDANJEoaBJAnDQJKEYSBJwjCQJGEYSJIwDCRJ\n9BgGSRYkuTTJfyW5NcnzkxySZEOS29v3ha1vkpyXZCTJV5Ic3bWfta3/7UnW9vqHkiRNTa9nBu8G\nPldVzwKOAm4FzgSuqqrlwFVtHeAEYHn7Wge8HyDJIcBZwLHAMcBZYwEiSZod0w6DJAcDvwhcCFBV\n36+q+4A1wPrWbT1wUlteA3yoOr4MLEjyFOB4YENVbauq7cAGYPV065IkTV0vZwbLgFHgn5LcmOQD\nSX4MOKyqtrY+dwGHteVFwKau8Ztb22TtPyLJuiTDSYZHR0d7KF2S1K2XMJgPHA28v6qeBzzID6eE\nAKiqAqqHYzxGVV1QVSuqasXQ0NBM7VaSBl4vYbAZ2FxV17T1S+mEw91t+of2/Z62fQuwpGv84tY2\nWbskaZZMOwyq6i5gU5JntqZVwNeBy4GxO4LWApe15cuBU9tdRSuB+9t00pXAcUkWtgvHx7U2SdIs\nmd/j+D8EPppkX+AO4LV0AuaSJKcBdwInt76fBU4ERoCHWl+qaluStwLXtX5nV9W2HuuSJE1BT2FQ\nVTcBKybYtGqCvgWcPsl+LgIu6qUWSdL0+QSyJMkwkCQZBpIkDANJEoaBJAnDQJKEYSBJwjCQJGEY\nSJIwDCRJGAaSJAwDSRKGgSQJw0CShGEgScIwkCRhGEiSMAwkSRgGkiQMA0kShoEkCcNAkoRhIEnC\nMJAkYRhIkjAMJEkYBpIkDANJEoaBJAnDQJKEYSBJwjCQJDEDYZBkXpIbk/xrW1+W5JokI0k+nmTf\n1r5fWx9p25d27eONrf22JMf3WpMkaWpm4szgj4Fbu9bfCbyrqp4ObAdOa+2nAdtb+7taP5IcCZwC\nPBtYDbwvybwZqEuS9Dj1FAZJFgMvAT7Q1gP8MnBp67IeOKktr2nrtO2rWv81wMVV9b2q2giMAMf0\nUpckaWp6PTM4F3g98EhbfzJwX1XtaOubgUVteRGwCaBtv7/1f7R9gjGPkWRdkuEkw6Ojoz2WLkka\nM+0wSPJS4J6qun4G69mpqrqgqlZU1YqhoaHZOqwk7fXm9zD2BcCvJTkR2B84CHg3sCDJ/PbqfzGw\npfXfAiwBNieZDxwM3NvVPqZ7jCRpFkz7zKCq3lhVi6tqKZ0LwJ+vqlcBXwBe1rqtBS5ry5e3ddr2\nz1dVtfZT2t1Gy4DlwLXTrUuSNHW9nBlM5g3AxUneBtwIXNjaLwQ+nGQE2EYnQKiqW5JcAnwd2AGc\nXlUP74a6JEmTmJEwqKqrgavb8h1McDdQVX0XePkk488BzpmJWiRJU+cTyJIkw0CSZBhIkjAMJEkY\nBpIkDANJEoaBJAnDQJKEYSBJwjCQJGEYSJIwDCRJGAaSJAwDSRKGgSQJw0CShGEgScIwkCRhGEiS\nMAwkSRgGkiQMA0kShoEkCcNAkoRhIEnCMJAkYRhIkjAMJEkYBpIkDANJEoaBJAnDQJJED2GQZEmS\nLyT5epJbkvxxaz8kyYYkt7fvC1t7kpyXZCTJV5Ic3bWvta3/7UnW9v7HkiRNRS9nBjuAP6uqI4GV\nwOlJjgTOBK6qquXAVW0d4ARgeftaB7wfOuEBnAUcCxwDnDUWIJKk2THtMKiqrVV1Q1t+ALgVWASs\nAda3buuBk9ryGuBD1fFlYEGSpwDHAxuqaltVbQc2AKunW5ckaepm5JpBkqXA84BrgMOqamvbdBdw\nWFteBGzqGra5tU3WPtFx1iUZTjI8Ojo6E6VLkpiBMEjyJOCTwJ9U1be7t1VVAdXrMbr2d0FVraiq\nFUNDQzO1W0kaeD2FQZIn0AmCj1bVp1rz3W36h/b9nta+BVjSNXxxa5usXZI0S3q5myjAhcCtVfX3\nXZsuB8buCFoLXNbVfmq7q2glcH+bTroSOC7Jwnbh+LjWJkmaJfN7GPsC4NXAV5Pc1Nr+EngHcEmS\n04A7gZPbts8CJwIjwEPAawGqaluStwLXtX5nV9W2HuqSJE3RtMOgqr4IZJLNqyboX8Dpk+zrIuCi\n6dYiSeqNTyBLkgwDSZJhIEnCMJAkYRhIkjAMJEkYBpIkDANJEoaBJAnDQJKEYSBJwjCQJGEYSJIw\nDCRJGAaSJAwDSRKGgSQJw0CShGEgScIwkCRhGEiSMAwkSRgGkiQMA0kShoEkCcNAkoRhIEnCMJAk\nYRhIkjAMJEkYBpIkDANJEjC/3wVI6o+lZ17R7xL2Kv/zjpf0u4SezJkzgySrk9yWZCTJmf2uR5IG\nyZwIgyTzgPcCJwBHAq9McmR/q5KkwTEnwgA4Bhipqjuq6vvAxcCaPtckSQNjrlwzWARs6lrfDBw7\nvlOSdcC6tvqdJLfNQm2D4FDgW/0uYlfyzn5XoD7x53PmPHWyDXMlDB6XqroAuKDfdextkgxX1Yp+\n1yFNxJ/P2TFXpom2AEu61he3NknSLJgrYXAdsDzJsiT7AqcAl/e5JkkaGHNimqiqdiQ5A7gSmAdc\nVFW39LmsQeLUm+Yyfz5nQaqq3zVIkvpsrkwTSZL6yDCQJBkGkuamJPv1u4ZBYhhImlOSHJPkq8Dt\nbf2oJO/pc1l7PcNgQKXjt5O8ua0fkeSYftclAecBLwXuBaiqm4Ff6mtFA8AwGFzvA54PvLKtP0Dn\nzQKlftunqu4c1/ZwXyoZIHPiOQP1xbFVdXSSGwGqant74E/qt03tLLXaOxr/IfCNPte01/PMYHD9\noP1HK4AkQ8Aj/S1JAuD3gdcBRwB3Aytbm3YjHzobUEleBbwCOBpYD7wMeFNVfaKvhUnqC8NggCV5\nFrAKCHBVVd3a55Ikkvwj7Yy1W1Wtm6C7ZojXDAZUkqcBG6vqvUleBLw4ydaquq/PpUn/3rW8P/Dr\nPPbzTrQbeGYwoJLcBKwAlgJX0HmX2GdX1Yn9rEsaL8k+wBer6uf6XcvezAvIg+uRqtoB/AZwflX9\nBfCUPtckTWQZcFi/i9jbOU00uH6Q5JXAqcCvtrYn9LEeCYAk2/nhNYN9gG3Amf2raDAYBoPrtcDv\nAedU1cYky4AP97kmDbgkAY7ih590+Eg5lz0rvGYgaU5J8rWqek6/6xg0nhkMmPYGYJO+Aqiqn57F\ncqSJ3JTkeVV1Y78LGSSeGQyYJE/d2fYJ3hNGmhVJ5rePwL0FeCbw38CDdJ6Dqao6uq8F7uUMA0lz\nQpIb2vtlPW2i7VX137Nd0yBxmmhAJVkJvAf4SWBfYB7wYFUd1NfCNMgC/tLvF8NgcJ0PnAJ8gs7D\nZ6cCz+hrRRp0Q0leN9nGqvr72Sxm0PjQ2QCrqhFgXlU9XFX/BKzud00aaPOAJwEHTvKl3cgzg8H1\nUPv8gpuS/A2wFV8cqL+2VtXZ/S5iUPmff3C9ms6//xl07thYAvxmXyvSoEu/Cxhk3k00YJIcUVXf\n7Hcd0nhJDqmqbf2uY1B5ZjB4Pj22kOST/SxE6mYQ9JdhMHi6T8V/om9VSJpTDIPBU5MsSxpgXjMY\nMEke5oeP+B8APDS2ic4j/z50Jg0gw0CS5DSRJMkwkCRhGEiSMAwkScD/A6yVbhILt8LUAAAAAElF\nTkSuQmCC\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "dXWSFfuf4yys",
        "colab_type": "code",
        "outputId": "99aed24a-31de-455a-bc87-b503f4734431",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        }
      },
      "source": [
        "data_train['ab_000'].values\n",
        "data_train['af_000'].isnull().sum()"
      ],
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "438"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "wMLfARFC6bGY",
        "colab_type": "code",
        "outputId": "123f8b72-0bf0-4267-ea20-c24bdca12a7d",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 435
        }
      },
      "source": [
        "data_train.fillna(-9999)"
      ],
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>class</th>\n",
              "      <th>aa_000</th>\n",
              "      <th>ab_000</th>\n",
              "      <th>ac_000</th>\n",
              "      <th>ad_000</th>\n",
              "      <th>ae_000</th>\n",
              "      <th>af_000</th>\n",
              "      <th>ag_000</th>\n",
              "      <th>ag_001</th>\n",
              "      <th>ag_002</th>\n",
              "      <th>ag_003</th>\n",
              "      <th>ag_004</th>\n",
              "      <th>ag_005</th>\n",
              "      <th>ag_006</th>\n",
              "      <th>ag_007</th>\n",
              "      <th>ag_008</th>\n",
              "      <th>ag_009</th>\n",
              "      <th>ah_000</th>\n",
              "      <th>ai_000</th>\n",
              "      <th>aj_000</th>\n",
              "      <th>ak_000</th>\n",
              "      <th>al_000</th>\n",
              "      <th>am_0</th>\n",
              "      <th>an_000</th>\n",
              "      <th>ao_000</th>\n",
              "      <th>ap_000</th>\n",
              "      <th>aq_000</th>\n",
              "      <th>ar_000</th>\n",
              "      <th>as_000</th>\n",
              "      <th>at_000</th>\n",
              "      <th>au_000</th>\n",
              "      <th>av_000</th>\n",
              "      <th>ax_000</th>\n",
              "      <th>ay_000</th>\n",
              "      <th>ay_001</th>\n",
              "      <th>ay_002</th>\n",
              "      <th>ay_003</th>\n",
              "      <th>ay_004</th>\n",
              "      <th>ay_005</th>\n",
              "      <th>ay_006</th>\n",
              "      <th>...</th>\n",
              "      <th>db_000</th>\n",
              "      <th>dc_000</th>\n",
              "      <th>dd_000</th>\n",
              "      <th>de_000</th>\n",
              "      <th>df_000</th>\n",
              "      <th>dg_000</th>\n",
              "      <th>dh_000</th>\n",
              "      <th>di_000</th>\n",
              "      <th>dj_000</th>\n",
              "      <th>dk_000</th>\n",
              "      <th>dl_000</th>\n",
              "      <th>dm_000</th>\n",
              "      <th>dn_000</th>\n",
              "      <th>do_000</th>\n",
              "      <th>dp_000</th>\n",
              "      <th>dq_000</th>\n",
              "      <th>dr_000</th>\n",
              "      <th>ds_000</th>\n",
              "      <th>dt_000</th>\n",
              "      <th>du_000</th>\n",
              "      <th>dv_000</th>\n",
              "      <th>dx_000</th>\n",
              "      <th>dy_000</th>\n",
              "      <th>dz_000</th>\n",
              "      <th>ea_000</th>\n",
              "      <th>eb_000</th>\n",
              "      <th>ec_00</th>\n",
              "      <th>ed_000</th>\n",
              "      <th>ee_000</th>\n",
              "      <th>ee_001</th>\n",
              "      <th>ee_002</th>\n",
              "      <th>ee_003</th>\n",
              "      <th>ee_004</th>\n",
              "      <th>ee_005</th>\n",
              "      <th>ee_006</th>\n",
              "      <th>ee_007</th>\n",
              "      <th>ee_008</th>\n",
              "      <th>ee_009</th>\n",
              "      <th>ef_000</th>\n",
              "      <th>eg_000</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>False</td>\n",
              "      <td>3256</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>0.000000e+00</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>320.0</td>\n",
              "      <td>14800.0</td>\n",
              "      <td>114044.0</td>\n",
              "      <td>64416.0</td>\n",
              "      <td>102.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>88808.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>182400.0</td>\n",
              "      <td>163802.0</td>\n",
              "      <td>27816.0</td>\n",
              "      <td>12172.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>61388.0</td>\n",
              "      <td>...</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>276.0</td>\n",
              "      <td>84.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1214.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2255460.0</td>\n",
              "      <td>182.00</td>\n",
              "      <td>182.0</td>\n",
              "      <td>26270.0</td>\n",
              "      <td>21514.0</td>\n",
              "      <td>7660.0</td>\n",
              "      <td>3148.0</td>\n",
              "      <td>10264.0</td>\n",
              "      <td>121464.0</td>\n",
              "      <td>2944.0</td>\n",
              "      <td>158.0</td>\n",
              "      <td>260.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>False</td>\n",
              "      <td>3474</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>8.600000e+01</td>\n",
              "      <td>86.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>168.0</td>\n",
              "      <td>3360.0</td>\n",
              "      <td>165294.0</td>\n",
              "      <td>28272.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>102652.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>196058.0</td>\n",
              "      <td>182014.0</td>\n",
              "      <td>20716.0</td>\n",
              "      <td>10946.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>78.0</td>\n",
              "      <td>48.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>93644.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>165416.0</td>\n",
              "      <td>106.0</td>\n",
              "      <td>36.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1122.0</td>\n",
              "      <td>2226.0</td>\n",
              "      <td>426.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>5796.0</td>\n",
              "      <td>1202.0</td>\n",
              "      <td>9800.0</td>\n",
              "      <td>2672.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2474220.0</td>\n",
              "      <td>-9999.00</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>15902.0</td>\n",
              "      <td>26396.0</td>\n",
              "      <td>23362.0</td>\n",
              "      <td>16746.0</td>\n",
              "      <td>31190.0</td>\n",
              "      <td>25052.0</td>\n",
              "      <td>18384.0</td>\n",
              "      <td>14814.0</td>\n",
              "      <td>24894.0</td>\n",
              "      <td>354.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>False</td>\n",
              "      <td>1332</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>2.400000e+01</td>\n",
              "      <td>14.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>25192.0</td>\n",
              "      <td>51490.0</td>\n",
              "      <td>17666.0</td>\n",
              "      <td>3654.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>37570.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>12546.0</td>\n",
              "      <td>17598.0</td>\n",
              "      <td>74830.0</td>\n",
              "      <td>74084.0</td>\n",
              "      <td>31356.0</td>\n",
              "      <td>4420.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>94.0</td>\n",
              "      <td>82.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>370.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>73172.0</td>\n",
              "      <td>242.0</td>\n",
              "      <td>262.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>24.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1148.0</td>\n",
              "      <td>170.0</td>\n",
              "      <td>32.0</td>\n",
              "      <td>6578.0</td>\n",
              "      <td>2232.0</td>\n",
              "      <td>1798.0</td>\n",
              "      <td>258.0</td>\n",
              "      <td>3140.0</td>\n",
              "      <td>350.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>56.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>137.32</td>\n",
              "      <td>164.0</td>\n",
              "      <td>28390.0</td>\n",
              "      <td>9900.0</td>\n",
              "      <td>6520.0</td>\n",
              "      <td>3906.0</td>\n",
              "      <td>12168.0</td>\n",
              "      <td>18422.0</td>\n",
              "      <td>12824.0</td>\n",
              "      <td>5856.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>False</td>\n",
              "      <td>519842</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>2.130706e+09</td>\n",
              "      <td>1154.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>8430.0</td>\n",
              "      <td>7424.0</td>\n",
              "      <td>11730124.0</td>\n",
              "      <td>10241340.0</td>\n",
              "      <td>1080276.0</td>\n",
              "      <td>32396.0</td>\n",
              "      <td>20277900.0</td>\n",
              "      <td>36756.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>36300044.0</td>\n",
              "      <td>30541976.0</td>\n",
              "      <td>8792568.0</td>\n",
              "      <td>4611126.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2044.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>330.0</td>\n",
              "      <td>126.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>39034.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>15456814.0</td>\n",
              "      <td>4816.0</td>\n",
              "      <td>72.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>386104.0</td>\n",
              "      <td>21880.0</td>\n",
              "      <td>8806.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>112888.0</td>\n",
              "      <td>24456.0</td>\n",
              "      <td>11009880.0</td>\n",
              "      <td>1209780.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>12630.02</td>\n",
              "      <td>12746.0</td>\n",
              "      <td>5591200.0</td>\n",
              "      <td>4549872.0</td>\n",
              "      <td>2847726.0</td>\n",
              "      <td>1440870.0</td>\n",
              "      <td>3660212.0</td>\n",
              "      <td>3233942.0</td>\n",
              "      <td>1023828.0</td>\n",
              "      <td>455646.0</td>\n",
              "      <td>278716.0</td>\n",
              "      <td>17978.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>False</td>\n",
              "      <td>712</td>\n",
              "      <td>8.0</td>\n",
              "      <td>3.800000e+01</td>\n",
              "      <td>28.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>6654.0</td>\n",
              "      <td>22806.0</td>\n",
              "      <td>57796.0</td>\n",
              "      <td>87004.0</td>\n",
              "      <td>2616.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>83020.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4946.0</td>\n",
              "      <td>8128.0</td>\n",
              "      <td>245656.0</td>\n",
              "      <td>224276.0</td>\n",
              "      <td>132000.0</td>\n",
              "      <td>11622.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>130.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>53642.0</td>\n",
              "      <td>330.0</td>\n",
              "      <td>228.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>380.0</td>\n",
              "      <td>156830.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2028.0</td>\n",
              "      <td>146.0</td>\n",
              "      <td>26.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2360.0</td>\n",
              "      <td>490.0</td>\n",
              "      <td>1800.0</td>\n",
              "      <td>182.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>514.52</td>\n",
              "      <td>418.0</td>\n",
              "      <td>128718.0</td>\n",
              "      <td>16464.0</td>\n",
              "      <td>8214.0</td>\n",
              "      <td>3580.0</td>\n",
              "      <td>6408.0</td>\n",
              "      <td>6366.0</td>\n",
              "      <td>3790.0</td>\n",
              "      <td>3336.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</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",
              "      <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",
              "      <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",
              "      <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>10225</th>\n",
              "      <td>False</td>\n",
              "      <td>28</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>8.000000e+00</td>\n",
              "      <td>8.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>104.0</td>\n",
              "      <td>3270.0</td>\n",
              "      <td>6812.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>3918.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>18852.0</td>\n",
              "      <td>16628.0</td>\n",
              "      <td>4340.0</td>\n",
              "      <td>954.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>20.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>9140.0</td>\n",
              "      <td>...</td>\n",
              "      <td>22.0</td>\n",
              "      <td>5466.0</td>\n",
              "      <td>66.0</td>\n",
              "      <td>34.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>148.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>240.0</td>\n",
              "      <td>70.0</td>\n",
              "      <td>1020.0</td>\n",
              "      <td>102.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>67.78</td>\n",
              "      <td>50.0</td>\n",
              "      <td>5932.0</td>\n",
              "      <td>3652.0</td>\n",
              "      <td>440.0</td>\n",
              "      <td>90.0</td>\n",
              "      <td>50.0</td>\n",
              "      <td>22.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10226</th>\n",
              "      <td>False</td>\n",
              "      <td>10646</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>0.000000e+00</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>138.0</td>\n",
              "      <td>20800.0</td>\n",
              "      <td>182096.0</td>\n",
              "      <td>378032.0</td>\n",
              "      <td>200290.0</td>\n",
              "      <td>6906.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>320722.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>11484.0</td>\n",
              "      <td>16548.0</td>\n",
              "      <td>782222.0</td>\n",
              "      <td>769522.0</td>\n",
              "      <td>240006.0</td>\n",
              "      <td>14656.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>38958.0</td>\n",
              "      <td>26206.0</td>\n",
              "      <td>8284.0</td>\n",
              "      <td>21792.0</td>\n",
              "      <td>6152.0</td>\n",
              "      <td>58100.0</td>\n",
              "      <td>185806.0</td>\n",
              "      <td>...</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>482.0</td>\n",
              "      <td>60.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1966.0</td>\n",
              "      <td>1004.0</td>\n",
              "      <td>336.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>9646.0</td>\n",
              "      <td>1482.0</td>\n",
              "      <td>4869060.0</td>\n",
              "      <td>507902.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>834.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>9646400.0</td>\n",
              "      <td>-9999.00</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>74364.0</td>\n",
              "      <td>64126.0</td>\n",
              "      <td>508298.0</td>\n",
              "      <td>101134.0</td>\n",
              "      <td>27442.0</td>\n",
              "      <td>7574.0</td>\n",
              "      <td>3740.0</td>\n",
              "      <td>1106.0</td>\n",
              "      <td>478.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10227</th>\n",
              "      <td>False</td>\n",
              "      <td>640</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4.000000e+00</td>\n",
              "      <td>6.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>146.0</td>\n",
              "      <td>7158.0</td>\n",
              "      <td>24614.0</td>\n",
              "      <td>30188.0</td>\n",
              "      <td>270.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>26030.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>40.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1474.0</td>\n",
              "      <td>3756.0</td>\n",
              "      <td>89478.0</td>\n",
              "      <td>82212.0</td>\n",
              "      <td>51722.0</td>\n",
              "      <td>2716.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>35198.0</td>\n",
              "      <td>210.0</td>\n",
              "      <td>92.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>30.0</td>\n",
              "      <td>12760.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>670.0</td>\n",
              "      <td>106.0</td>\n",
              "      <td>28.0</td>\n",
              "      <td>21452.0</td>\n",
              "      <td>9942.0</td>\n",
              "      <td>606.0</td>\n",
              "      <td>230.0</td>\n",
              "      <td>1600.0</td>\n",
              "      <td>160.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>160.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>230.86</td>\n",
              "      <td>150.0</td>\n",
              "      <td>29476.0</td>\n",
              "      <td>5982.0</td>\n",
              "      <td>2940.0</td>\n",
              "      <td>1094.0</td>\n",
              "      <td>1822.0</td>\n",
              "      <td>3056.0</td>\n",
              "      <td>3814.0</td>\n",
              "      <td>13740.0</td>\n",
              "      <td>452.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10228</th>\n",
              "      <td>False</td>\n",
              "      <td>6</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>4.000000e+00</td>\n",
              "      <td>4.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>188.0</td>\n",
              "      <td>2660.0</td>\n",
              "      <td>2450.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1422.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>164.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>18168.0</td>\n",
              "      <td>16158.0</td>\n",
              "      <td>18476.0</td>\n",
              "      <td>350.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1530.0</td>\n",
              "      <td>28.0</td>\n",
              "      <td>52.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>50.0</td>\n",
              "      <td>114.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>120.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>62.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>1320.0</td>\n",
              "      <td>150.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>52.66</td>\n",
              "      <td>30.0</td>\n",
              "      <td>4184.0</td>\n",
              "      <td>976.0</td>\n",
              "      <td>48.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>74.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10229</th>\n",
              "      <td>False</td>\n",
              "      <td>12</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>2.000000e+00</td>\n",
              "      <td>2.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1012.0</td>\n",
              "      <td>5492.0</td>\n",
              "      <td>3824.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4256.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>68.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>494.0</td>\n",
              "      <td>758.0</td>\n",
              "      <td>14880.0</td>\n",
              "      <td>13800.0</td>\n",
              "      <td>6616.0</td>\n",
              "      <td>128.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>6.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>...</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1924.0</td>\n",
              "      <td>40.0</td>\n",
              "      <td>52.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>130.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>4670.0</td>\n",
              "      <td>552.0</td>\n",
              "      <td>50.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>-9999.00</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>8870.0</td>\n",
              "      <td>1178.0</td>\n",
              "      <td>38.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>172.0</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>-9999.0</td>\n",
              "      <td>-9999.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>10230 rows × 171 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       class  aa_000  ab_000        ac_000  ...    ee_008   ee_009  ef_000  eg_000\n",
              "0      False    3256 -9999.0  0.000000e+00  ...     260.0      0.0     0.0     0.0\n",
              "1      False    3474 -9999.0  8.600000e+01  ...   24894.0    354.0     0.0     0.0\n",
              "2      False    1332 -9999.0  2.400000e+01  ...      16.0      0.0     0.0     0.0\n",
              "3      False  519842 -9999.0  2.130706e+09  ...  278716.0  17978.0     0.0     0.0\n",
              "4      False     712     8.0  3.800000e+01  ...       0.0      0.0     0.0     0.0\n",
              "...      ...     ...     ...           ...  ...       ...      ...     ...     ...\n",
              "10225  False      28 -9999.0  8.000000e+00  ...       0.0      0.0     0.0     0.0\n",
              "10226  False   10646 -9999.0  0.000000e+00  ...     478.0      0.0     0.0     0.0\n",
              "10227  False     640     0.0  4.000000e+00  ...     452.0      0.0     0.0     0.0\n",
              "10228  False       6 -9999.0  4.000000e+00  ...       0.0      0.0     0.0     0.0\n",
              "10229  False      12 -9999.0  2.000000e+00  ...   -9999.0  -9999.0 -9999.0 -9999.0\n",
              "\n",
              "[10230 rows x 171 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "V4Lh0FxY6jFm",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "y_train = data_train['class'].copy(deep=True)\n",
        "\n",
        "X_train = data_train.copy(deep=True)\n",
        "X_train.drop(['class'], inplace=True, axis=1)\n",
        "X_train = X_train.fillna(-9999)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "S-RQfVJ1W3fc",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "class_labels_train = []\n",
        "l = len(y_train)\n",
        "\n",
        "for x in range(l):\n",
        "    if y_train[x] == False:\n",
        "        class_labels_train.append(0)\n",
        "        \n",
        "    else:\n",
        "        class_labels_train.append(1)\n",
        "\n",
        "y_train = class_labels_train   "
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "nFuobCtj6vpH",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "y_test = data_test['class'].copy(deep=True)\n",
        "X_test = data_test.copy(deep=True)\n",
        "X_test.drop(['class'], inplace=True, axis=1)\n",
        "X_test = X_test.fillna(-9999)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "lSuKR4rJ6z2X",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "from sklearn.model_selection import train_test_split"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "tCiDvMZA62pP",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "X_train, X_val, y_train, y_val = train_test_split(X_train, y_train, test_size=0.25, random_state=1)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "hs4sEajf663v",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "from sklearn.preprocessing import StandardScaler\n",
        "\n",
        "sc = StandardScaler()\n",
        "X_train = sc.fit_transform(X_train)\n",
        "X_test = sc.transform(X_test)\n",
        "X_val = sc.transform(X_val)\n"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "7McwXL808Ju2",
        "colab_type": "code",
        "outputId": "455ff95d-6db7-4a80-d3e9-8cbb6d36001a",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 243
        }
      },
      "source": [
        "X_train"
      ],
      "execution_count": 15,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array([[-3.93410591e-01,  1.82567898e+00,  2.34674444e+00, ...,\n",
              "        -1.30636639e-01,  2.20867345e-01,  2.20861731e-01],\n",
              "       [ 2.89127630e-01, -5.47830817e-01, -4.26121387e-01, ...,\n",
              "        -1.21903295e-01,  2.20867345e-01,  2.20861731e-01],\n",
              "       [-2.52816008e-01,  1.82520432e+00,  2.34674444e+00, ...,\n",
              "        -1.30636639e-01,  2.20867345e-01,  2.23710497e-01],\n",
              "       ...,\n",
              "       [-4.04859027e-01, -5.47830817e-01,  2.34674444e+00, ...,\n",
              "        -1.30636639e-01,  2.20867345e-01,  2.20861731e-01],\n",
              "       [-1.61812796e-03, -5.47830817e-01, -4.26121881e-01, ...,\n",
              "        -3.06475103e-02,  2.20867345e-01,  2.20861731e-01],\n",
              "       [-3.26709194e-01,  1.82520432e+00,  2.34674445e+00, ...,\n",
              "        -1.30636639e-01,  2.20867345e-01,  2.20861731e-01]])"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "mVGaSMdM707S",
        "colab_type": "code",
        "outputId": "5f39529b-a1e0-4caf-9f8a-c8b7983f2076",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 139
        }
      },
      "source": [
        "from sklearn.ensemble import RandomForestRegressor\n",
        "\n",
        "regressor = RandomForestRegressor(n_estimators=20, random_state=0)\n",
        "regressor.fit(X_train, y_train)"
      ],
      "execution_count": 16,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "RandomForestRegressor(bootstrap=True, criterion='mse', max_depth=None,\n",
              "                      max_features='auto', max_leaf_nodes=None,\n",
              "                      min_impurity_decrease=0.0, min_impurity_split=None,\n",
              "                      min_samples_leaf=1, min_samples_split=2,\n",
              "                      min_weight_fraction_leaf=0.0, n_estimators=20,\n",
              "                      n_jobs=None, oob_score=False, random_state=0, verbose=0,\n",
              "                      warm_start=False)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ecus93KbIHC2",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "y_pred = regressor.predict(X_val)\n",
        "\n",
        "ll = len(y_pred)\n",
        "class_labels_train1 = []\n",
        "\n",
        "\n",
        "for x in range(ll):\n",
        "    if y_pred[x] < 0.1:\n",
        "        class_labels_train1.append(0)\n",
        "        \n",
        "    else:\n",
        "        class_labels_train1.append(1) "
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Dq79sk1-IYZi",
        "colab_type": "code",
        "outputId": "37ab35d6-8864-4139-ac3e-9126e2081416",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 331
        }
      },
      "source": [
        "from sklearn.metrics import confusion_matrix\n",
        "from matplotlib import pyplot as plt\n",
        "conf_mat = confusion_matrix(y_true=y_val, y_pred=class_labels_train1)\n",
        "print('Confusion matrix:\\n', conf_mat)\n",
        "\n",
        "labels = ['Class 0', 'Class 1']\n",
        "fig = plt.figure()\n",
        "ax = fig.add_subplot(111)\n",
        "cax = ax.matshow(conf_mat, cmap=plt.cm.Blues)\n",
        "fig.colorbar(cax)\n",
        "ax.set_xticklabels([''] + labels)\n",
        "ax.set_yticklabels([''] + labels)\n",
        "plt.xlabel('Predicted')\n",
        "plt.ylabel('Expected')\n",
        "plt.show()\n"
      ],
      "execution_count": 22,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Confusion matrix:\n",
            " [[2452   62]\n",
            " [   2   42]]\n"
          ],
          "name": "stdout"
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAVwAAAEGCAYAAAApAy29AAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4xLjIsIGh0\ndHA6Ly9tYXRwbG90bGliLm9yZy8li6FKAAAXqklEQVR4nO3dfbQdVX3G8e9zbwCJBAIEYwxvCkHF\nFEKIyMJCQQSBtSzQIgJdJCDLiOIqYLWQlhYsZYm1viGKBggELW9K0VQCISsUE6lgSAgh+NLEAEKE\nhBAW7xQCv/5x9jXHm/sy994zc2bmPp+sWfecffaZvYfDfbKzZ2YfRQRmZpa/jnZ3wMxsuHDgmpkV\nxIFrZlYQB66ZWUEcuGZmBXHgmpkVxIFbUpLeLulGSb+TtETSXEl7Sdpd0oqc2txK0k2SVkm6T9Lu\nebRTR236vA6RtFTSRkkn5NGGtZYDt4QkCbgVuDsi9oiI/YEZwNicmz4DeDYi9gS+Dnw55/ZqoY2f\n1++B04Drc27HWsSBW06HAa9HxHe7CiLiwYhY1FwpjZ4WpVHOUkkHpfJxkhZKWiZphaSDJXVKujY9\nf0jSuT20eywwOz3+EXB4ChPrW1s+r4h4NCKWA2/mfYDWGiPa3QHr0URgSYZ664AjIuJVSROAG4Ap\nwCnAvIi4RFInMBKYBIyPiIkAkkb3sL/xwOMAEbFR0nPAjsD6oR5QzbXr87KKceBW2xbA5ZImAW8A\ne6XyxcAsSVsAP46IZZJWA++S9C3gNuDOtvR4ePPnNcx5SqGcHgb2z1DvXGAtsC+NkdKWABGxEDgE\nWANcK2lqRDyb6t0NnAlc1cP+1gC7AEgaAWwHPDOUAxkm2vV5WcU4cMvpLmArSdO7CiTtI+ngbvW2\nA56MiDeBU4HOVHc3YG1EXEnjF3WypDFAR0TcAlwATO6h3TnAtPT4BOCu8OpGWbTr87KKkX+fyknS\nO4Bv0Bg5vQo8CpwDvA78NCImpnnAW4AA7gDOiohtJE0DvpDqvghMBbYFrmHTX7IzIuL2bm2+Bfg+\nsB+wATgpIlbneZx10abP6/00ro7YPrX5VES8L8/jtKFx4JqZFcRTCmZmBXHgmpkVxIFrZlYQB66Z\nWUEcuDXVfImSVYM/s/pz4NaXf3mrx59ZzTlwzcwKMuyvw9WIrUNbjmp3N1ouNr6CRmzd7m7kYtJ7\nd213F3Kx/umnGbPTTu3uRi4eWLpkfUQM+uA6t90tYuMrmerGK0/Pi4ijBttWnob94jXachRbvfvE\ndnfDBuBn91zW7i7YAG27dedjQ3l/bHwl8+/pq8u+PWYobeVp2AeumVWBQNWfAXXgmln5CejobHcv\nhsyBa2bVUIMvH3HgmlkFeErBzKw4HuGamRVAeIRrZlYMeYRrZlYYX6VgZlYEnzQzMyuG8JSCmVlh\nPMI1MyuCpxTMzIohoNMnzczMiuE5XDOzInhKwcysOB7hmpkVxCNcM7MCyLf2mpkVx7f2mpkVwSfN\nzMyK4ykFM7MCeD1cM7OieErBzKw4PmlmZlYQz+GamRVAnlIwMyuOR7hmZsWQA9fMLH+Nb9hx4JqZ\n5U9CHQ5cM7NCeIRrZlYQB66ZWUEcuGZmRVDaKs6Ba2alJ1SLEW71b90ws2Gho6Mj09YfSbtI+m9J\nv5L0sKSzU/kOkuZLWpl+bp/KJekySaskLZc0uWlf01L9lZKm9XsMQzh+M7PCSMq0ZbAR+LuI2Bs4\nEDhL0t7A+cCCiJgALEjPAY4GJqRtOnBF6s8OwIXAB4ADgAu7Qro3DlwzKz8NYOtHRDwZEUvT4xeA\nXwPjgWOB2anabOC49PhY4LpouBcYLWkc8BFgfkRsiIhngfnAUX217TlcM6uEAczhjpF0f9PzmREx\ns5d97g7sB9wHjI2IJ9NLTwFj0+PxwONNb3silfVW3isHrpmV3gBPmq2PiCn97lPaBrgFOCcinm/e\nf0SEpBhUZ/vgKQUzqwR1KNOWaV/SFjTC9j8i4j9T8do0VUD6uS6VrwF2aXr7zqmst/JeOXDNrPzU\nupNmalS6Gvh1RHyt6aU5QNeVBtOAnzSVT01XKxwIPJemHuYBR0raPp0sOzKV9cpTCmZWCS28DveD\nwKnAQ5KWpbJ/AC4FbpZ0BvAYcGJ6bS5wDLAKeBk4HSAiNki6GFic6v1LRGzoq2EHrplVQqsCNyJ+\nTu/XMxzeQ/0AzuplX7OAWVnbduCaWenV5U4zB66ZVUP189aBa2YVIDLdtlt2DlwzqwRPKZiZFaX6\neevANbNqqMMIN7dJEUlvl3SjpN9JWiJprqS9JO0uaUVObW4l6aa0jNp96T5pM6u4rDc9lD2Ucwnc\ndCfHrcDdEbFHROwPzGDTYhB5OQN4NiL2BL4OfDnn9sysIA7c3h0GvB4R3+0qiIgHI2JRc6U02l0k\naWnaDkrl4yQtlLRM0gpJB0vqlHRtev6QpHN7aLd5ebUfAYer7J+AmWXSyrUU2iWvOdyJwJIM9dYB\nR0TEq5ImADcAU4BTgHkRcYmkTmAkMAkYHxETASSN7mF/f1wuLSI2SnoO2BFY31xJ0nQaCwnDFtsM\n/OjMrHB1GDu1+6TZFsDlkiYBbwB7pfLFwKy0os+PI2KZpNXAuyR9C7gNuHOwjaa1MWcCdIx8W8uX\nYDOzFlM9AjevKYWHgf0z1DsXWAvsS2NkuyVARCwEDqGx1Nm1kqamFdX3Be4GzgSu6mF/f1wuTdII\nYDvgmaEciJm1nwAp21ZmeQXuXcBW6Z/uAEjaR9LB3eptBzwZEW/SWL2nM9XdDVgbEVfSCNbJksYA\nHRFxC3ABMJnNNS+vdgJwV1p4wswqrR5XKeQypZBWSz8e+Iak84BXgUeBc7pV/Q5wi6SpwB3AS6n8\nUOALkl4HXgSm0pifvUZS118SM3po+mrg+5JWARuAk1p2UGbWVh0lPyGWRW5zuBHxBzatJ9ndxFRn\nJbBPU/l5qXw2m642aNbTqLa5zVeBjw24s2ZWbhWYLsii3SfNzMz6JTzCNTMrjEe4ZmYFKfsJsSwc\nuGZWfp7DNTMrhpAXIDczK4pHuGZmBfEcrplZETyHa2ZWjMZaCtVPXAeumVVCDfLWgWtm1eA7zczM\nilCT9XAduGZWel3r4VadA9fMKqD8a91m4cA1s0qoQd46cM2sAuSTZmZmhfB1uGZmBXLgmpkVpAZ5\n68A1s2rwCNfMrAg1Wbym+iv6mlntNRYgz7b1uy9plqR1klY0lV0kaY2kZWk7pum1GZJWSfqtpI80\nlR+VylZJOj/LcThwzawSOqRMWwbXAkf1UP71iJiUtrkAkvYGTgLel97zHUmdkjqBbwNHA3sDJ6e6\nffKUgplVQqumFCJioaTdM1Y/FrgxIv4PeETSKuCA9NqqiFjd6JtuTHV/1dfOPMI1s9JTWrwmywaM\nkXR/0zY9YzOflbQ8TTlsn8rGA4831XkilfVW3iePcM2sEgZwo9n6iJgywN1fAVwMRPr5VeATA9xH\nvxy4ZlYJed7aGxFrux5LuhL4aXq6BtilqerOqYw+ynvlKQUzKz3RuFIhy59B7V8a1/T0eKDrCoY5\nwEmStpL0TmAC8EtgMTBB0jslbUnjxNqc/trpc4Qr6XN9vR4RX+uvATOzVmjVAFfSDcChNOZ6nwAu\nBA6VNInGlMKjwKcAIuJhSTfTOBm2ETgrIt5I+/ksMA/oBGZFxMP9td3flMKo9PPdwPvZlOAfpZHy\nZmb5U+vWw42Ik3sovrqP+pcAl/RQPheYO5C2+wzciPgigKSFwOSIeCE9vwi4bSANmZkNRR3uNMt6\n0mws8FrT89dSmZlZ7gRZb2ootayBex3wS0m3pufHAbPz6ZKZ2eaGzQLkEXGJpNuBg1PR6RHxQH7d\nMjPbRDVZvGYg1+GOBJ6PiGsk7STpnRHxSF4dMzNrNmymFCRdCEyhcbXCNcAWwA+AD+bXNTOzTaof\nt9lHuMcD+wFLASLiD5JG9f0WM7PWGU4LkL8WESEpACS9Ncc+mZn9icZVCu3uxdBlDdybJX0PGC3p\nkzQWdbgqv26ZmTVRtsXFyy7rVQr/LukI4Hka87j/HBHzc+2ZmVmTYTOlIOnLEXEeML+HMjOzXNVl\nSiHramFH9FB2dCs7YmbWlwEsQF5a/a0W9mngM8AekpY3vTQK+J88O2Zm1qzcUZpNf1MK1wO3A18C\nmr+V8oWI2JBbr8zMmkjQWYM5hf5WC3sOeE7SN4ENTauFbSvpAxFxXxGdNDMr+3RBFlnncK8AXmx6\n/mIqMzMrRNd6Cv1tZZb1OlxFRHQ9iYg3Jfn70MysEEK1WEsh6wh3taS/lbRF2s4GVufZMTOzP8o4\nui17JmcdpZ4JXAZcQOM7fxYAWb/rvdT2e++u3HPf5e3uhg3AxjfebHcXrA3qMIeb9U6zdTS+ldLM\nrHACOmsQuJmmFCTtJWmBpBXp+T6SLsi3a2Zmm3Qo21ZmWedwrwRmAK8DRMRyPOI1swLVIXCzzuGO\njIhfdptD2ZhDf8zMNtM4IVbyNM0ga+Cul7QHjRNmSDoBeDK3XpmZdVP20WsWWQP3LGAm8B5Ja4BH\ngL/JrVdmZt3UYICb+SqF1cCH0zc9dHTd4mtmVgQBI2qQuFmvUthR0mXAIuBuSd+UtGO+XTMz26QO\nNz5kvUrhRuBp4K+BE9Ljm/LqlJlZM6lxa2+WrcyyzuGOi4iLm57/q6SP59EhM7OelDxLM8k6wr1T\n0kmSOtJ2IjAvz46ZmTUbTtfhfhI4B/h+et4JvCTpU0BExLZ5dM7MDNKtvWVP0wyyXqUwKu+OmJn1\nqgKj1yyyXqVwRrfnnZIuzKdLZmabU8Y/ZZZ1DvdwSXMljZM0EbiXxhdJmpnlrutr0ofFHG5EnJKu\nSngIeAk4JSLuybVnZmZNyh6mWWSdUpgAnA3cAjwGnCppZJ4dMzNrJinTlmE/sySt61puNpXtIGm+\npJXp5/apXJIuk7RK0nJJk5veMy3VXylpWpZjyDql8F/AP0XEp4C/AFYCizO+18xsSBpfk55ty+Ba\n4KhuZecDCyJiAo1vtDk/lR8NTEjbdNKX50raAbgQ+ABwAHBhV0j3JWvgHhARC6BxDVhEfBU4PuN7\nzcyGrFV3mkXEQmBDt+Jjgdnp8WzguKby61Lu3QuMljQO+AgwPyI2RMSzwHw2D/HNj6GvFyX9ferg\n85I+1u3l0/rbuZlZKwzwpNkYSfc3bVm+f3FsRHQtOfsUMDY9Hg883lTviVTWW3mf+hvhNn+rw4xu\nr/Wb5mZmrTKAxWvWR8SUpm3mQNqJiCCt/d1q/QWuennc03Mzs5yIjozbIK1NUwWkn+tS+Rpgl6Z6\nO6ey3sr71F/gRi+Pe3puZpYLkfvyjHOArisNpgE/aSqfmq5WOBB4Lk09zAOOlLR9Oll2JBnWl+nv\nOtx9JT1P43i3To9Jz98yoMMxMxsswYgWXYgr6QbgUBpzvU/QuNrgUuDmdFftY8CJqfpc4BhgFfAy\ncDpARGyQdDGbrtb6l4jofiJuM30GbkR0DvhozMxarGuE2woRcXIvLx3eQ92g8RVjPe1nFjBrIG1n\nXS3MzKytyr64eBYOXDOrhBrkrQPXzMpPZL9Lq8wcuGZWfvKUgplZIRp3mjlwzcwKUf24deCaWUXU\nYIDrwDWzKsi21m3ZOXDNrPR8lYKZWYF80szMrAjCUwpmZkXwlIKZWYE8wjUzK0j149aBa2YVIKDT\nI1wzs2LUIG8duGZWBUI1mFRw4JpZJXiEa2ZWgMZlYdVPXAeumZXf0L6RtzQcuGZWCb6118ysAI0F\nyNvdi6Fz4JpZJfgqBTOzgtRgRsGBa2bVUIcRbm4L8Eh6u6QbJf1O0hJJcyXtJWl3SStyavMQSUsl\nbZR0Qh5tmFnxuuZws2xllssIV41lfW4FZkfESalsX2As8HgebSa/B04DPp9jG2ZWNKkWVynkNcI9\nDHg9Ir7bVRARD0bEouZKabS7KI1Kl0o6KJWPk7RQ0jJJKyQdLKlT0rXp+UOSzu3eaEQ8GhHLgTdz\nOi4zaxNl3MosrzncicCSDPXWAUdExKuSJgA3AFOAU4B5EXGJpE5gJDAJGB8REwEkjR5s5yRNB6YD\n7LLrroPdjZkVpDGlUPY47V+7F1HfArhS0kPAD4G9U/li4HRJFwF/FhEvAKuBd0n6lqSjgOcH22hE\nzIyIKRExZacxOw3tCMysEHUY4eYVuA8D+2eody6wFtiXxsh2S4CIWAgcAqwBrpU0NSKeTfXuBs4E\nrmp9t82stGqQuHkF7l3AVumf7gBI2kfSwd3qbQc8GRFvAqcCnanubsDaiLiSRrBOljQG6IiIW4AL\ngMk59d3MSqgjnTjrbyuzXAI3IgI4HvhwuizsYeBLwFPdqn4HmCbpQeA9wEup/FDgQUkPAB8HvgmM\nB+6WtAz4ATCje7uS3i/pCeBjwPdSu2ZWAzUY4OZ340NE/AE4sZeXJ6Y6K4F9msrPS+Wzgdk9vK/P\nUW1ELAZ2HnBnzaz8yp6mGfhOMzMrvcbotfqJ2+6rFMzM+pfWw82yZdqd9Gi6nn+ZpPtT2Q6S5kta\nmX5un8ol6TJJqyQtlzTo80cOXDOrhBzmcA+LiEkRMSU9Px9YEBETgAXpOcDRwIS0TQeuGOwxOHDN\nrAKElG0bgmPZdO5oNnBcU/l10XAvMFrSuME04MA1s0po5ZQCEMCdaWGtrstXx0bEk+nxUzTWfoHG\nFVLNa8A8kcoGzCfNzKz0BjhdMKZrXjaZGREzu9X584hYI+ltwHxJv2l+MSJCUgy2v71x4JpZNWRP\n3PVN87I9iog16ec6SbcCBwBrJY2LiCfTlMG6VH0NsEvT23dOZQPmKQUzqwRl/NPvfqS3ShrV9Rg4\nElgBzAGmpWrTgJ+kx3OAqelqhQOB55qmHgbEI1wzq4QW3rU7Frg1nWAbAVwfEXdIWgzcLOkM4DE2\n3bg1FzgGWAW8DJw+2IYduGZWfgM7IdaniFhNYyGs7uXPAIf3UB7AWa1o24FrZpVQhzvNHLhmVnrC\n39prZlaYGuStA9fMKqIGievANbNKKPvi4lk4cM2sEqoftw5cM6uKGiSuA9fMSq8uC5A7cM2s/Fp4\n40M7OXDNrBJqkLcOXDOrgiEvLl4KDlwzq4Qa5K0D18zKbxDfV1ZKDlwzq4YaJK4D18wqwZeFmZkV\nxHO4ZmZFEHQ4cM3MilL9xHXgmlnpeQFyM7MC1SBvHbhmVg0e4ZqZFcS39pqZFaT6cevANbMKkJdn\nNDMrju80MzMrSvXz1oFrZtVQg7x14JpZFchfk25mVoS63GnW0e4OmJkNFx7hmlkl1GGE68A1s0rw\nZWFmZkXwjQ9mZsWoy0kzB66ZVYKnFMzMCuIRrplZQWqQtw5cM6uIGiSuA9fMSk9Qi1t7FRHt7kNb\nSXoaeKzd/cjBGGB9uzthA1Lnz2y3iNhpsG+WdAeN/z5ZrI+IowbbVp6GfeDWlaT7I2JKu/th2fkz\nqz+vpWBmVhAHrplZQRy49TWz3R2wAfNnVnMO3JqKiLb+8kp6Q9IySSsk/VDSyCHs61BJP02P/1LS\n+X3UHS3pM4No4yJJnx9sH1uh3Z+Z5c+Ba3l5JSImRcRE4DXgzOYX1TDg//8iYk5EXNpHldHAgAPX\nrAgOXCvCImBPSbtL+q2k64AVwC6SjpT0C0lL00h4GwBJR0n6jaSlwF917UjSaZIuT4/HSrpV0oNp\nOwi4FNgjja6/kup9QdJiScslfbFpX/8o6X8l/Rx4d2H/NWzY8o0PlitJI4CjgTtS0QRgWkTcK2kM\ncAHw4Yh4SdJ5wOck/RtwJfAhYBVwUy+7vwz4WUQcL6kT2AY4H5gYEZNS+0emNg+gcf38HEmHAC8B\nJwGTaPweLAWWtPbozf6UA9fysrWkZenxIuBq4B3AYxFxbyo/ENgbuEeNu4i2BH4BvAd4JCJWAkj6\nATC9hzY+BEwFiIg3gOckbd+tzpFpeyA934ZGAI8Cbo2Il1Mbc4Z0tGYZOHAtL690jTK7pFB9qbkI\nmB8RJ3er9yfvGyIBX4qI73Vr45wWtmGWiedwrZ3uBT4oaU8ASW+VtBfwG2B3SXukeif38v4FwKfT\nezslbQe8QGP02mUe8ImmueHxkt4GLASOk7S1pFHAR1t8bGabceBa20TE08BpwA2SlpOmEyLiVRpT\nCLelk2bretnF2cBhkh6iMf+6d0Q8Q2OKYoWkr0TEncD1wC9SvR8BoyJiKY254QeB24HFuR2oWeK1\nFMzMCuIRrplZQRy4ZmYFceCamRXEgWtmVhAHrplZQRy4ZmYFceCamRXk/wEmoghI8ixLYgAAAABJ\nRU5ErkJggg==\n",
            "text/plain": [
              "<Figure size 432x288 with 2 Axes>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ksDDs87Mb4fE",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "y_pred3 = regressor.predict(X_test)\n",
        "\n",
        "ll = len(y_pred3)\n",
        "class_labels_train2 = []\n",
        "\n",
        "\n",
        "for x in range(ll):\n",
        "    if y_pred3[x] < 0.1:\n",
        "        class_labels_train2.append('false')\n",
        "        \n",
        "    else:\n",
        "        class_labels_train2.append('true') "
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "_v7yJM12RHhc",
        "colab_type": "code",
        "colab": {}
      },
      "source": [
        "a = np.asarray(class_labels_train2)\n",
        "\n",
        "prediction = pd.DataFrame(a.T)\n",
        "prediction.index += 1\n",
        "prediction.to_csv('prediction.csv')"
      ],
      "execution_count": 0,
      "outputs": []
    }
  ]
}