04_CF-Miner.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Jsou tendence nákupu T strany při tzv. \"eco\" kolech stejné ve všech čtvrtinách zápasu?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Cleverminer version  1.0.2  educational version. For production use (bugfixes and keeping compatibility), ask for PRO version.\n"
     ]
    }
   ],
   "source": [
    "#imports of required packages\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt\n",
    "from cleverminer import cleverminer"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "#loading of dataset\n",
    "df = pd.read_csv('./data/csgo_round_snapshots_processed.csv', sep=',')\n",
    "df_one = df.copy(deep=True)\n",
    "df_two = df.copy(deep=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "pd.set_option('display.max_columns', None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>time_left</th>\n",
       "      <th>ct_score</th>\n",
       "      <th>t_score</th>\n",
       "      <th>map</th>\n",
       "      <th>bomb_planted</th>\n",
       "      <th>ct_health</th>\n",
       "      <th>t_health</th>\n",
       "      <th>ct_armor</th>\n",
       "      <th>t_armor</th>\n",
       "      <th>ct_money</th>\n",
       "      <th>t_money</th>\n",
       "      <th>ct_helmets</th>\n",
       "      <th>t_helmets</th>\n",
       "      <th>ct_defuse_kits</th>\n",
       "      <th>ct_players_alive</th>\n",
       "      <th>t_players_alive</th>\n",
       "      <th>ct_weapon_ak47</th>\n",
       "      <th>t_weapon_ak47</th>\n",
       "      <th>ct_weapon_aug</th>\n",
       "      <th>t_weapon_aug</th>\n",
       "      <th>ct_weapon_awp</th>\n",
       "      <th>t_weapon_awp</th>\n",
       "      <th>ct_weapon_bizon</th>\n",
       "      <th>t_weapon_bizon</th>\n",
       "      <th>ct_weapon_cz75auto</th>\n",
       "      <th>t_weapon_cz75auto</th>\n",
       "      <th>ct_weapon_elite</th>\n",
       "      <th>t_weapon_elite</th>\n",
       "      <th>ct_weapon_famas</th>\n",
       "      <th>t_weapon_famas</th>\n",
       "      <th>ct_weapon_g3sg1</th>\n",
       "      <th>t_weapon_g3sg1</th>\n",
       "      <th>ct_weapon_galilar</th>\n",
       "      <th>t_weapon_galilar</th>\n",
       "      <th>ct_weapon_glock</th>\n",
       "      <th>t_weapon_glock</th>\n",
       "      <th>ct_weapon_m249</th>\n",
       "      <th>t_weapon_m249</th>\n",
       "      <th>ct_weapon_m4a1s</th>\n",
       "      <th>t_weapon_m4a1s</th>\n",
       "      <th>ct_weapon_m4a4</th>\n",
       "      <th>t_weapon_m4a4</th>\n",
       "      <th>ct_weapon_mac10</th>\n",
       "      <th>t_weapon_mac10</th>\n",
       "      <th>ct_weapon_mag7</th>\n",
       "      <th>t_weapon_mag7</th>\n",
       "      <th>ct_weapon_mp5sd</th>\n",
       "      <th>t_weapon_mp5sd</th>\n",
       "      <th>ct_weapon_mp7</th>\n",
       "      <th>t_weapon_mp7</th>\n",
       "      <th>ct_weapon_mp9</th>\n",
       "      <th>t_weapon_mp9</th>\n",
       "      <th>ct_weapon_negev</th>\n",
       "      <th>t_weapon_negev</th>\n",
       "      <th>ct_weapon_nova</th>\n",
       "      <th>t_weapon_nova</th>\n",
       "      <th>ct_weapon_p90</th>\n",
       "      <th>t_weapon_p90</th>\n",
       "      <th>ct_weapon_r8revolver</th>\n",
       "      <th>t_weapon_r8revolver</th>\n",
       "      <th>ct_weapon_sawedoff</th>\n",
       "      <th>t_weapon_sawedoff</th>\n",
       "      <th>ct_weapon_scar20</th>\n",
       "      <th>t_weapon_scar20</th>\n",
       "      <th>ct_weapon_sg553</th>\n",
       "      <th>t_weapon_sg553</th>\n",
       "      <th>ct_weapon_ssg08</th>\n",
       "      <th>t_weapon_ssg08</th>\n",
       "      <th>ct_weapon_ump45</th>\n",
       "      <th>t_weapon_ump45</th>\n",
       "      <th>ct_weapon_xm1014</th>\n",
       "      <th>t_weapon_xm1014</th>\n",
       "      <th>ct_weapon_deagle</th>\n",
       "      <th>t_weapon_deagle</th>\n",
       "      <th>ct_weapon_fiveseven</th>\n",
       "      <th>t_weapon_fiveseven</th>\n",
       "      <th>ct_weapon_usps</th>\n",
       "      <th>t_weapon_usps</th>\n",
       "      <th>ct_weapon_p250</th>\n",
       "      <th>t_weapon_p250</th>\n",
       "      <th>ct_weapon_p2000</th>\n",
       "      <th>t_weapon_p2000</th>\n",
       "      <th>ct_weapon_tec9</th>\n",
       "      <th>t_weapon_tec9</th>\n",
       "      <th>ct_grenade_hegrenade</th>\n",
       "      <th>t_grenade_hegrenade</th>\n",
       "      <th>ct_grenade_flashbang</th>\n",
       "      <th>t_grenade_flashbang</th>\n",
       "      <th>ct_grenade_smokegrenade</th>\n",
       "      <th>t_grenade_smokegrenade</th>\n",
       "      <th>ct_grenade_incendiarygrenade</th>\n",
       "      <th>t_grenade_incendiarygrenade</th>\n",
       "      <th>ct_grenade_molotovgrenade</th>\n",
       "      <th>t_grenade_molotovgrenade</th>\n",
       "      <th>ct_grenade_decoygrenade</th>\n",
       "      <th>t_grenade_decoygrenade</th>\n",
       "      <th>round_winner</th>\n",
       "      <th>t_weapon_glock_price</th>\n",
       "      <th>t_category_pistol_price</th>\n",
       "      <th>t_category_pistol_amount</th>\n",
       "      <th>t_overall_investment</th>\n",
       "      <th>ct_weapon_usps_price</th>\n",
       "      <th>ct_category_pistol_price</th>\n",
       "      <th>ct_category_pistol_amount</th>\n",
       "      <th>ct_overall_investment</th>\n",
       "      <th>ct_weapon_p2000_price</th>\n",
       "      <th>t_kevlar_price</th>\n",
       "      <th>t_kevlarhelmet_price</th>\n",
       "      <th>t_category_armor_price</th>\n",
       "      <th>ct_kevlar_price</th>\n",
       "      <th>ct_kevlarhelmet_price</th>\n",
       "      <th>ct_category_armor_price</th>\n",
       "      <th>t_grenade_smokegrenade_price</th>\n",
       "      <th>t_category_grenade_price</th>\n",
       "      <th>t_category_grenade_amount</th>\n",
       "      <th>ct_defuse_kits_price</th>\n",
       "      <th>t_weapon_p2000_price</th>\n",
       "      <th>ct_weapon_famas_price</th>\n",
       "      <th>ct_category_rifle_price</th>\n",
       "      <th>ct_category_rifle_amount</th>\n",
       "      <th>ct_weapon_ssg08_price</th>\n",
       "      <th>ct_category_sniper_price</th>\n",
       "      <th>ct_category_sniper_amount</th>\n",
       "      <th>ct_weapon_ump45_price</th>\n",
       "      <th>ct_category_smg_price</th>\n",
       "      <th>ct_category_smg_amount</th>\n",
       "      <th>ct_grenade_hegrenade_price</th>\n",
       "      <th>ct_category_grenade_price</th>\n",
       "      <th>ct_category_grenade_amount</th>\n",
       "      <th>ct_grenade_flashbang_price</th>\n",
       "      <th>ct_grenade_smokegrenade_price</th>\n",
       "      <th>ct_grenade_incendiarygrenade_price</th>\n",
       "      <th>t_weapon_famas_price</th>\n",
       "      <th>t_category_rifle_price</th>\n",
       "      <th>t_category_rifle_amount</th>\n",
       "      <th>t_weapon_ak47_price</th>\n",
       "      <th>ct_weapon_awp_price</th>\n",
       "      <th>ct_weapon_m4a4_price</th>\n",
       "      <th>t_grenade_flashbang_price</th>\n",
       "      <th>t_grenade_molotovgrenade_price</th>\n",
       "      <th>t_grenade_decoygrenade_price</th>\n",
       "      <th>t_weapon_awp_price</th>\n",
       "      <th>t_category_sniper_price</th>\n",
       "      <th>t_category_sniper_amount</th>\n",
       "      <th>ct_weapon_deagle_price</th>\n",
       "      <th>t_grenade_hegrenade_price</th>\n",
       "      <th>ct_weapon_ak47_price</th>\n",
       "      <th>t_weapon_galilar_price</th>\n",
       "      <th>t_weapon_mac10_price</th>\n",
       "      <th>t_category_smg_price</th>\n",
       "      <th>t_category_smg_amount</th>\n",
       "      <th>t_weapon_m4a4_price</th>\n",
       "      <th>t_weapon_deagle_price</th>\n",
       "      <th>ct_weapon_aug_price</th>\n",
       "      <th>t_grenade_incendiarygrenade_price</th>\n",
       "      <th>t_weapon_p250_price</th>\n",
       "      <th>ct_weapon_p250_price</th>\n",
       "      <th>t_weapon_aug_price</th>\n",
       "      <th>t_weapon_cz75auto_price</th>\n",
       "      <th>t_weapon_sg553_price</th>\n",
       "      <th>ct_weapon_sg553_price</th>\n",
       "      <th>ct_weapon_m4a1s_price</th>\n",
       "      <th>t_weapon_usps_price</th>\n",
       "      <th>ct_weapon_cz75auto_price</th>\n",
       "      <th>t_weapon_ssg08_price</th>\n",
       "      <th>ct_weapon_mp5sd_price</th>\n",
       "      <th>ct_grenade_molotovgrenade_price</th>\n",
       "      <th>t_weapon_m4a1s_price</th>\n",
       "      <th>ct_grenade_decoygrenade_price</th>\n",
       "      <th>ct_weapon_mp9_price</th>\n",
       "      <th>ct_weapon_fiveseven_price</th>\n",
       "      <th>t_weapon_ump45_price</th>\n",
       "      <th>ct_weapon_mac10_price</th>\n",
       "      <th>ct_weapon_galilar_price</th>\n",
       "      <th>t_weapon_fiveseven_price</th>\n",
       "      <th>ct_weapon_glock_price</th>\n",
       "      <th>t_weapon_tec9_price</th>\n",
       "      <th>ct_weapon_mag7_price</th>\n",
       "      <th>ct_category_shotgun_price</th>\n",
       "      <th>ct_category_shotgun_amount</th>\n",
       "      <th>t_weapon_mp9_price</th>\n",
       "      <th>t_weapon_mag7_price</th>\n",
       "      <th>t_category_shotgun_price</th>\n",
       "      <th>t_category_shotgun_amount</th>\n",
       "      <th>t_weapon_elite_price</th>\n",
       "      <th>t_weapon_g3sg1_price</th>\n",
       "      <th>ct_weapon_elite_price</th>\n",
       "      <th>ct_weapon_tec9_price</th>\n",
       "      <th>ct_weapon_xm1014_price</th>\n",
       "      <th>t_weapon_p90_price</th>\n",
       "      <th>ct_weapon_scar20_price</th>\n",
       "      <th>ct_weapon_nova_price</th>\n",
       "      <th>t_weapon_mp7_price</th>\n",
       "      <th>t_weapon_sawedoff_price</th>\n",
       "      <th>ct_weapon_mp7_price</th>\n",
       "      <th>t_weapon_mp5sd_price</th>\n",
       "      <th>t_weapon_bizon_price</th>\n",
       "      <th>t_weapon_nova_price</th>\n",
       "      <th>t_weapon_xm1014_price</th>\n",
       "      <th>t_weapon_scar20_price</th>\n",
       "      <th>t_weapon_r8revolver_price</th>\n",
       "      <th>t_weapon_negev_price</th>\n",
       "      <th>t_category_machine gun_price</th>\n",
       "      <th>t_category_machine gun_amount</th>\n",
       "      <th>ct_weapon_p90_price</th>\n",
       "      <th>ct_weapon_m249_price</th>\n",
       "      <th>ct_category_machine gun_price</th>\n",
       "      <th>ct_category_machine gun_amount</th>\n",
       "      <th>ct_players_alive_surplus</th>\n",
       "      <th>time_left_cat</th>\n",
       "      <th>players_alive</th>\n",
       "      <th>round_number</th>\n",
       "      <th>match_quarters</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>175.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>de_dust2</td>\n",
       "      <td>False</td>\n",
       "      <td>500.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.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>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>5.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>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>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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>1.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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>CT</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>200.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>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>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>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>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>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>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>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>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>early</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>156.03</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>de_dust2</td>\n",
       "      <td>False</td>\n",
       "      <td>500.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>600.0</td>\n",
       "      <td>650.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.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>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>5.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>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>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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>1.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>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>CT</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3550.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>1950.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1950.0</td>\n",
       "      <td>2600.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2600.0</td>\n",
       "      <td>600.0</td>\n",
       "      <td>600.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>400.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>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>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>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>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>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>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>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>early</td>\n",
       "      <td>10.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>96.03</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>de_dust2</td>\n",
       "      <td>False</td>\n",
       "      <td>391.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>294.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>750.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</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>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>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>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>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>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>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>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>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>CT</td>\n",
       "      <td>800.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2700.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3150.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>1950.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1950.0</td>\n",
       "      <td>600.0</td>\n",
       "      <td>600.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>400.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>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>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>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>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>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>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>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>mid</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>76.03</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>de_dust2</td>\n",
       "      <td>False</td>\n",
       "      <td>391.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>294.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>750.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</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>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>0.0</td>\n",
       "      <td>3.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>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>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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>1.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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>CT</td>\n",
       "      <td>600.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2100.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3150.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>1950.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1950.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>400.0</td>\n",
       "      <td>200.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>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>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>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>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>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>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>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>mid</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>174.97</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>de_dust2</td>\n",
       "      <td>False</td>\n",
       "      <td>500.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>192.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>18350.0</td>\n",
       "      <td>10750.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.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>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>5.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>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>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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>1.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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>CT</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>2700.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1300.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>400.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>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>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>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>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>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>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>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>early</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   time_left  ct_score  t_score       map  bomb_planted  ct_health  t_health  \\\n",
       "0     175.00       0.0      0.0  de_dust2         False      500.0     500.0   \n",
       "1     156.03       0.0      0.0  de_dust2         False      500.0     500.0   \n",
       "2      96.03       0.0      0.0  de_dust2         False      391.0     400.0   \n",
       "3      76.03       0.0      0.0  de_dust2         False      391.0     400.0   \n",
       "4     174.97       1.0      0.0  de_dust2         False      500.0     500.0   \n",
       "\n",
       "   ct_armor  t_armor  ct_money  t_money  ct_helmets  t_helmets  \\\n",
       "0       0.0      0.0    4000.0   4000.0         0.0        0.0   \n",
       "1     400.0    300.0     600.0    650.0         0.0        0.0   \n",
       "2     294.0    200.0     750.0    500.0         0.0        0.0   \n",
       "3     294.0    200.0     750.0    500.0         0.0        0.0   \n",
       "4     192.0      0.0   18350.0  10750.0         0.0        0.0   \n",
       "\n",
       "   ct_defuse_kits  ct_players_alive  t_players_alive  ct_weapon_ak47  \\\n",
       "0             0.0               5.0              5.0             0.0   \n",
       "1             1.0               5.0              5.0             0.0   \n",
       "2             1.0               4.0              4.0             0.0   \n",
       "3             1.0               4.0              4.0             0.0   \n",
       "4             1.0               5.0              5.0             0.0   \n",
       "\n",
       "   t_weapon_ak47  ct_weapon_aug  t_weapon_aug  ct_weapon_awp  t_weapon_awp  \\\n",
       "0            0.0            0.0           0.0            0.0           0.0   \n",
       "1            0.0            0.0           0.0            0.0           0.0   \n",
       "2            0.0            0.0           0.0            0.0           0.0   \n",
       "3            0.0            0.0           0.0            0.0           0.0   \n",
       "4            0.0            0.0           0.0            0.0           0.0   \n",
       "\n",
       "   ct_weapon_bizon  t_weapon_bizon  ct_weapon_cz75auto  t_weapon_cz75auto  \\\n",
       "0              0.0             0.0                 0.0                0.0   \n",
       "1              0.0             0.0                 0.0                0.0   \n",
       "2              0.0             0.0                 0.0                0.0   \n",
       "3              0.0             0.0                 0.0                0.0   \n",
       "4              0.0             0.0                 0.0                0.0   \n",
       "\n",
       "   ct_weapon_elite  t_weapon_elite  ct_weapon_famas  t_weapon_famas  \\\n",
       "0              0.0             0.0              0.0             0.0   \n",
       "1              0.0             0.0              0.0             0.0   \n",
       "2              0.0             0.0              0.0             0.0   \n",
       "3              0.0             0.0              0.0             0.0   \n",
       "4              0.0             0.0              0.0             0.0   \n",
       "\n",
       "   ct_weapon_g3sg1  t_weapon_g3sg1  ct_weapon_galilar  t_weapon_galilar  \\\n",
       "0              0.0             0.0                0.0               0.0   \n",
       "1              0.0             0.0                0.0               0.0   \n",
       "2              0.0             0.0                0.0               0.0   \n",
       "3              0.0             0.0                0.0               0.0   \n",
       "4              0.0             0.0                0.0               0.0   \n",
       "\n",
       "   ct_weapon_glock  t_weapon_glock  ct_weapon_m249  t_weapon_m249  \\\n",
       "0              0.0             5.0             0.0            0.0   \n",
       "1              0.0             5.0             0.0            0.0   \n",
       "2              0.0             4.0             0.0            0.0   \n",
       "3              0.0             3.0             0.0            0.0   \n",
       "4              0.0             5.0             0.0            0.0   \n",
       "\n",
       "   ct_weapon_m4a1s  t_weapon_m4a1s  ct_weapon_m4a4  t_weapon_m4a4  \\\n",
       "0              0.0             0.0             0.0            0.0   \n",
       "1              0.0             0.0             0.0            0.0   \n",
       "2              0.0             0.0             0.0            0.0   \n",
       "3              0.0             0.0             0.0            0.0   \n",
       "4              0.0             0.0             0.0            0.0   \n",
       "\n",
       "   ct_weapon_mac10  t_weapon_mac10  ct_weapon_mag7  t_weapon_mag7  \\\n",
       "0              0.0             0.0             0.0            0.0   \n",
       "1              0.0             0.0             0.0            0.0   \n",
       "2              0.0             0.0             0.0            0.0   \n",
       "3              0.0             0.0             0.0            0.0   \n",
       "4              0.0             0.0             0.0            0.0   \n",
       "\n",
       "   ct_weapon_mp5sd  t_weapon_mp5sd  ct_weapon_mp7  t_weapon_mp7  \\\n",
       "0              0.0             0.0            0.0           0.0   \n",
       "1              0.0             0.0            0.0           0.0   \n",
       "2              0.0             0.0            0.0           0.0   \n",
       "3              0.0             0.0            0.0           0.0   \n",
       "4              0.0             0.0            0.0           0.0   \n",
       "\n",
       "   ct_weapon_mp9  t_weapon_mp9  ct_weapon_negev  t_weapon_negev  \\\n",
       "0            0.0           0.0              0.0             0.0   \n",
       "1            0.0           0.0              0.0             0.0   \n",
       "2            0.0           0.0              0.0             0.0   \n",
       "3            0.0           0.0              0.0             0.0   \n",
       "4            0.0           0.0              0.0             0.0   \n",
       "\n",
       "   ct_weapon_nova  t_weapon_nova  ct_weapon_p90  t_weapon_p90  \\\n",
       "0             0.0            0.0            0.0           0.0   \n",
       "1             0.0            0.0            0.0           0.0   \n",
       "2             0.0            0.0            0.0           0.0   \n",
       "3             0.0            0.0            0.0           0.0   \n",
       "4             0.0            0.0            0.0           0.0   \n",
       "\n",
       "   ct_weapon_r8revolver  t_weapon_r8revolver  ct_weapon_sawedoff  \\\n",
       "0                   0.0                  0.0                 0.0   \n",
       "1                   0.0                  0.0                 0.0   \n",
       "2                   0.0                  0.0                 0.0   \n",
       "3                   0.0                  0.0                 0.0   \n",
       "4                   0.0                  0.0                 0.0   \n",
       "\n",
       "   t_weapon_sawedoff  ct_weapon_scar20  t_weapon_scar20  ct_weapon_sg553  \\\n",
       "0                0.0               0.0              0.0              0.0   \n",
       "1                0.0               0.0              0.0              0.0   \n",
       "2                0.0               0.0              0.0              0.0   \n",
       "3                0.0               0.0              0.0              0.0   \n",
       "4                0.0               0.0              0.0              0.0   \n",
       "\n",
       "   t_weapon_sg553  ct_weapon_ssg08  t_weapon_ssg08  ct_weapon_ump45  \\\n",
       "0             0.0              0.0             0.0              0.0   \n",
       "1             0.0              0.0             0.0              0.0   \n",
       "2             0.0              0.0             0.0              0.0   \n",
       "3             0.0              0.0             0.0              0.0   \n",
       "4             0.0              0.0             0.0              0.0   \n",
       "\n",
       "   t_weapon_ump45  ct_weapon_xm1014  t_weapon_xm1014  ct_weapon_deagle  \\\n",
       "0             0.0               0.0              0.0               0.0   \n",
       "1             0.0               0.0              0.0               0.0   \n",
       "2             0.0               0.0              0.0               0.0   \n",
       "3             0.0               0.0              0.0               0.0   \n",
       "4             0.0               0.0              0.0               0.0   \n",
       "\n",
       "   t_weapon_deagle  ct_weapon_fiveseven  t_weapon_fiveseven  ct_weapon_usps  \\\n",
       "0              0.0                  0.0                 0.0             4.0   \n",
       "1              0.0                  0.0                 0.0             4.0   \n",
       "2              0.0                  0.0                 0.0             4.0   \n",
       "3              0.0                  0.0                 0.0             4.0   \n",
       "4              0.0                  0.0                 0.0             4.0   \n",
       "\n",
       "   t_weapon_usps  ct_weapon_p250  t_weapon_p250  ct_weapon_p2000  \\\n",
       "0            0.0             0.0            0.0              1.0   \n",
       "1            0.0             0.0            0.0              1.0   \n",
       "2            0.0             0.0            0.0              0.0   \n",
       "3            0.0             0.0            0.0              0.0   \n",
       "4            0.0             0.0            0.0              1.0   \n",
       "\n",
       "   t_weapon_p2000  ct_weapon_tec9  t_weapon_tec9  ct_grenade_hegrenade  \\\n",
       "0             0.0             0.0            0.0                   0.0   \n",
       "1             0.0             0.0            0.0                   0.0   \n",
       "2             0.0             0.0            0.0                   0.0   \n",
       "3             1.0             0.0            0.0                   0.0   \n",
       "4             0.0             0.0            0.0                   0.0   \n",
       "\n",
       "   t_grenade_hegrenade  ct_grenade_flashbang  t_grenade_flashbang  \\\n",
       "0                  0.0                   0.0                  0.0   \n",
       "1                  0.0                   0.0                  0.0   \n",
       "2                  0.0                   0.0                  0.0   \n",
       "3                  0.0                   0.0                  0.0   \n",
       "4                  0.0                   0.0                  0.0   \n",
       "\n",
       "   ct_grenade_smokegrenade  t_grenade_smokegrenade  \\\n",
       "0                      0.0                     0.0   \n",
       "1                      0.0                     2.0   \n",
       "2                      0.0                     2.0   \n",
       "3                      0.0                     0.0   \n",
       "4                      0.0                     0.0   \n",
       "\n",
       "   ct_grenade_incendiarygrenade  t_grenade_incendiarygrenade  \\\n",
       "0                           0.0                          0.0   \n",
       "1                           0.0                          0.0   \n",
       "2                           0.0                          0.0   \n",
       "3                           0.0                          0.0   \n",
       "4                           0.0                          0.0   \n",
       "\n",
       "   ct_grenade_molotovgrenade  t_grenade_molotovgrenade  \\\n",
       "0                        0.0                       0.0   \n",
       "1                        0.0                       0.0   \n",
       "2                        0.0                       0.0   \n",
       "3                        0.0                       0.0   \n",
       "4                        0.0                       0.0   \n",
       "\n",
       "   ct_grenade_decoygrenade  t_grenade_decoygrenade round_winner  \\\n",
       "0                      0.0                     0.0           CT   \n",
       "1                      0.0                     0.0           CT   \n",
       "2                      0.0                     0.0           CT   \n",
       "3                      0.0                     0.0           CT   \n",
       "4                      0.0                     0.0           CT   \n",
       "\n",
       "   t_weapon_glock_price  t_category_pistol_price  t_category_pistol_amount  \\\n",
       "0                1000.0                   1000.0                       5.0   \n",
       "1                1000.0                   1000.0                       5.0   \n",
       "2                 800.0                    800.0                       4.0   \n",
       "3                 600.0                    800.0                       4.0   \n",
       "4                1000.0                   1000.0                       5.0   \n",
       "\n",
       "   t_overall_investment  ct_weapon_usps_price  ct_category_pistol_price  \\\n",
       "0                1000.0                 800.0                    1000.0   \n",
       "1                3550.0                 800.0                    1000.0   \n",
       "2                2700.0                 800.0                     800.0   \n",
       "3                2100.0                 800.0                     800.0   \n",
       "4                1000.0                 800.0                    1000.0   \n",
       "\n",
       "   ct_category_pistol_amount  ct_overall_investment  ct_weapon_p2000_price  \\\n",
       "0                        5.0                 1000.0                  200.0   \n",
       "1                        5.0                 4000.0                  200.0   \n",
       "2                        4.0                 3150.0                    0.0   \n",
       "3                        4.0                 3150.0                    0.0   \n",
       "4                        5.0                 2700.0                  200.0   \n",
       "\n",
       "   t_kevlar_price  t_kevlarhelmet_price  t_category_armor_price  \\\n",
       "0             0.0                   0.0                     0.0   \n",
       "1          1950.0                   0.0                  1950.0   \n",
       "2          1300.0                   0.0                  1300.0   \n",
       "3          1300.0                   0.0                  1300.0   \n",
       "4             0.0                   0.0                     0.0   \n",
       "\n",
       "   ct_kevlar_price  ct_kevlarhelmet_price  ct_category_armor_price  \\\n",
       "0              0.0                    0.0                      0.0   \n",
       "1           2600.0                    0.0                   2600.0   \n",
       "2           1950.0                    0.0                   1950.0   \n",
       "3           1950.0                    0.0                   1950.0   \n",
       "4           1300.0                    0.0                   1300.0   \n",
       "\n",
       "   t_grenade_smokegrenade_price  t_category_grenade_price  \\\n",
       "0                           0.0                       0.0   \n",
       "1                         600.0                     600.0   \n",
       "2                         600.0                     600.0   \n",
       "3                           0.0                       0.0   \n",
       "4                           0.0                       0.0   \n",
       "\n",
       "   t_category_grenade_amount  ct_defuse_kits_price  t_weapon_p2000_price  \\\n",
       "0                        0.0                   0.0                   0.0   \n",
       "1                        2.0                 400.0                   0.0   \n",
       "2                        2.0                 400.0                   0.0   \n",
       "3                        0.0                 400.0                 200.0   \n",
       "4                        0.0                 400.0                   0.0   \n",
       "\n",
       "   ct_weapon_famas_price  ct_category_rifle_price  ct_category_rifle_amount  \\\n",
       "0                    0.0                      0.0                       0.0   \n",
       "1                    0.0                      0.0                       0.0   \n",
       "2                    0.0                      0.0                       0.0   \n",
       "3                    0.0                      0.0                       0.0   \n",
       "4                    0.0                      0.0                       0.0   \n",
       "\n",
       "   ct_weapon_ssg08_price  ct_category_sniper_price  ct_category_sniper_amount  \\\n",
       "0                    0.0                       0.0                        0.0   \n",
       "1                    0.0                       0.0                        0.0   \n",
       "2                    0.0                       0.0                        0.0   \n",
       "3                    0.0                       0.0                        0.0   \n",
       "4                    0.0                       0.0                        0.0   \n",
       "\n",
       "   ct_weapon_ump45_price  ct_category_smg_price  ct_category_smg_amount  \\\n",
       "0                    0.0                    0.0                     0.0   \n",
       "1                    0.0                    0.0                     0.0   \n",
       "2                    0.0                    0.0                     0.0   \n",
       "3                    0.0                    0.0                     0.0   \n",
       "4                    0.0                    0.0                     0.0   \n",
       "\n",
       "   ct_grenade_hegrenade_price  ct_category_grenade_price  \\\n",
       "0                         0.0                        0.0   \n",
       "1                         0.0                        0.0   \n",
       "2                         0.0                        0.0   \n",
       "3                         0.0                        0.0   \n",
       "4                         0.0                        0.0   \n",
       "\n",
       "   ct_category_grenade_amount  ct_grenade_flashbang_price  \\\n",
       "0                         0.0                         0.0   \n",
       "1                         0.0                         0.0   \n",
       "2                         0.0                         0.0   \n",
       "3                         0.0                         0.0   \n",
       "4                         0.0                         0.0   \n",
       "\n",
       "   ct_grenade_smokegrenade_price  ct_grenade_incendiarygrenade_price  \\\n",
       "0                            0.0                                 0.0   \n",
       "1                            0.0                                 0.0   \n",
       "2                            0.0                                 0.0   \n",
       "3                            0.0                                 0.0   \n",
       "4                            0.0                                 0.0   \n",
       "\n",
       "   t_weapon_famas_price  t_category_rifle_price  t_category_rifle_amount  \\\n",
       "0                   0.0                     0.0                      0.0   \n",
       "1                   0.0                     0.0                      0.0   \n",
       "2                   0.0                     0.0                      0.0   \n",
       "3                   0.0                     0.0                      0.0   \n",
       "4                   0.0                     0.0                      0.0   \n",
       "\n",
       "   t_weapon_ak47_price  ct_weapon_awp_price  ct_weapon_m4a4_price  \\\n",
       "0                  0.0                  0.0                   0.0   \n",
       "1                  0.0                  0.0                   0.0   \n",
       "2                  0.0                  0.0                   0.0   \n",
       "3                  0.0                  0.0                   0.0   \n",
       "4                  0.0                  0.0                   0.0   \n",
       "\n",
       "   t_grenade_flashbang_price  t_grenade_molotovgrenade_price  \\\n",
       "0                        0.0                             0.0   \n",
       "1                        0.0                             0.0   \n",
       "2                        0.0                             0.0   \n",
       "3                        0.0                             0.0   \n",
       "4                        0.0                             0.0   \n",
       "\n",
       "   t_grenade_decoygrenade_price  t_weapon_awp_price  t_category_sniper_price  \\\n",
       "0                           0.0                 0.0                      0.0   \n",
       "1                           0.0                 0.0                      0.0   \n",
       "2                           0.0                 0.0                      0.0   \n",
       "3                           0.0                 0.0                      0.0   \n",
       "4                           0.0                 0.0                      0.0   \n",
       "\n",
       "   t_category_sniper_amount  ct_weapon_deagle_price  \\\n",
       "0                       0.0                     0.0   \n",
       "1                       0.0                     0.0   \n",
       "2                       0.0                     0.0   \n",
       "3                       0.0                     0.0   \n",
       "4                       0.0                     0.0   \n",
       "\n",
       "   t_grenade_hegrenade_price  ct_weapon_ak47_price  t_weapon_galilar_price  \\\n",
       "0                        0.0                   0.0                     0.0   \n",
       "1                        0.0                   0.0                     0.0   \n",
       "2                        0.0                   0.0                     0.0   \n",
       "3                        0.0                   0.0                     0.0   \n",
       "4                        0.0                   0.0                     0.0   \n",
       "\n",
       "   t_weapon_mac10_price  t_category_smg_price  t_category_smg_amount  \\\n",
       "0                   0.0                   0.0                    0.0   \n",
       "1                   0.0                   0.0                    0.0   \n",
       "2                   0.0                   0.0                    0.0   \n",
       "3                   0.0                   0.0                    0.0   \n",
       "4                   0.0                   0.0                    0.0   \n",
       "\n",
       "   t_weapon_m4a4_price  t_weapon_deagle_price  ct_weapon_aug_price  \\\n",
       "0                  0.0                    0.0                  0.0   \n",
       "1                  0.0                    0.0                  0.0   \n",
       "2                  0.0                    0.0                  0.0   \n",
       "3                  0.0                    0.0                  0.0   \n",
       "4                  0.0                    0.0                  0.0   \n",
       "\n",
       "   t_grenade_incendiarygrenade_price  t_weapon_p250_price  \\\n",
       "0                                0.0                  0.0   \n",
       "1                                0.0                  0.0   \n",
       "2                                0.0                  0.0   \n",
       "3                                0.0                  0.0   \n",
       "4                                0.0                  0.0   \n",
       "\n",
       "   ct_weapon_p250_price  t_weapon_aug_price  t_weapon_cz75auto_price  \\\n",
       "0                   0.0                 0.0                      0.0   \n",
       "1                   0.0                 0.0                      0.0   \n",
       "2                   0.0                 0.0                      0.0   \n",
       "3                   0.0                 0.0                      0.0   \n",
       "4                   0.0                 0.0                      0.0   \n",
       "\n",
       "   t_weapon_sg553_price  ct_weapon_sg553_price  ct_weapon_m4a1s_price  \\\n",
       "0                   0.0                    0.0                    0.0   \n",
       "1                   0.0                    0.0                    0.0   \n",
       "2                   0.0                    0.0                    0.0   \n",
       "3                   0.0                    0.0                    0.0   \n",
       "4                   0.0                    0.0                    0.0   \n",
       "\n",
       "   t_weapon_usps_price  ct_weapon_cz75auto_price  t_weapon_ssg08_price  \\\n",
       "0                  0.0                       0.0                   0.0   \n",
       "1                  0.0                       0.0                   0.0   \n",
       "2                  0.0                       0.0                   0.0   \n",
       "3                  0.0                       0.0                   0.0   \n",
       "4                  0.0                       0.0                   0.0   \n",
       "\n",
       "   ct_weapon_mp5sd_price  ct_grenade_molotovgrenade_price  \\\n",
       "0                    0.0                              0.0   \n",
       "1                    0.0                              0.0   \n",
       "2                    0.0                              0.0   \n",
       "3                    0.0                              0.0   \n",
       "4                    0.0                              0.0   \n",
       "\n",
       "   t_weapon_m4a1s_price  ct_grenade_decoygrenade_price  ct_weapon_mp9_price  \\\n",
       "0                   0.0                            0.0                  0.0   \n",
       "1                   0.0                            0.0                  0.0   \n",
       "2                   0.0                            0.0                  0.0   \n",
       "3                   0.0                            0.0                  0.0   \n",
       "4                   0.0                            0.0                  0.0   \n",
       "\n",
       "   ct_weapon_fiveseven_price  t_weapon_ump45_price  ct_weapon_mac10_price  \\\n",
       "0                        0.0                   0.0                    0.0   \n",
       "1                        0.0                   0.0                    0.0   \n",
       "2                        0.0                   0.0                    0.0   \n",
       "3                        0.0                   0.0                    0.0   \n",
       "4                        0.0                   0.0                    0.0   \n",
       "\n",
       "   ct_weapon_galilar_price  t_weapon_fiveseven_price  ct_weapon_glock_price  \\\n",
       "0                      0.0                       0.0                    0.0   \n",
       "1                      0.0                       0.0                    0.0   \n",
       "2                      0.0                       0.0                    0.0   \n",
       "3                      0.0                       0.0                    0.0   \n",
       "4                      0.0                       0.0                    0.0   \n",
       "\n",
       "   t_weapon_tec9_price  ct_weapon_mag7_price  ct_category_shotgun_price  \\\n",
       "0                  0.0                   0.0                        0.0   \n",
       "1                  0.0                   0.0                        0.0   \n",
       "2                  0.0                   0.0                        0.0   \n",
       "3                  0.0                   0.0                        0.0   \n",
       "4                  0.0                   0.0                        0.0   \n",
       "\n",
       "   ct_category_shotgun_amount  t_weapon_mp9_price  t_weapon_mag7_price  \\\n",
       "0                         0.0                 0.0                  0.0   \n",
       "1                         0.0                 0.0                  0.0   \n",
       "2                         0.0                 0.0                  0.0   \n",
       "3                         0.0                 0.0                  0.0   \n",
       "4                         0.0                 0.0                  0.0   \n",
       "\n",
       "   t_category_shotgun_price  t_category_shotgun_amount  t_weapon_elite_price  \\\n",
       "0                       0.0                        0.0                   0.0   \n",
       "1                       0.0                        0.0                   0.0   \n",
       "2                       0.0                        0.0                   0.0   \n",
       "3                       0.0                        0.0                   0.0   \n",
       "4                       0.0                        0.0                   0.0   \n",
       "\n",
       "   t_weapon_g3sg1_price  ct_weapon_elite_price  ct_weapon_tec9_price  \\\n",
       "0                   0.0                    0.0                   0.0   \n",
       "1                   0.0                    0.0                   0.0   \n",
       "2                   0.0                    0.0                   0.0   \n",
       "3                   0.0                    0.0                   0.0   \n",
       "4                   0.0                    0.0                   0.0   \n",
       "\n",
       "   ct_weapon_xm1014_price  t_weapon_p90_price  ct_weapon_scar20_price  \\\n",
       "0                     0.0                 0.0                     0.0   \n",
       "1                     0.0                 0.0                     0.0   \n",
       "2                     0.0                 0.0                     0.0   \n",
       "3                     0.0                 0.0                     0.0   \n",
       "4                     0.0                 0.0                     0.0   \n",
       "\n",
       "   ct_weapon_nova_price  t_weapon_mp7_price  t_weapon_sawedoff_price  \\\n",
       "0                   0.0                 0.0                      0.0   \n",
       "1                   0.0                 0.0                      0.0   \n",
       "2                   0.0                 0.0                      0.0   \n",
       "3                   0.0                 0.0                      0.0   \n",
       "4                   0.0                 0.0                      0.0   \n",
       "\n",
       "   ct_weapon_mp7_price  t_weapon_mp5sd_price  t_weapon_bizon_price  \\\n",
       "0                  0.0                   0.0                   0.0   \n",
       "1                  0.0                   0.0                   0.0   \n",
       "2                  0.0                   0.0                   0.0   \n",
       "3                  0.0                   0.0                   0.0   \n",
       "4                  0.0                   0.0                   0.0   \n",
       "\n",
       "   t_weapon_nova_price  t_weapon_xm1014_price  t_weapon_scar20_price  \\\n",
       "0                  0.0                    0.0                    0.0   \n",
       "1                  0.0                    0.0                    0.0   \n",
       "2                  0.0                    0.0                    0.0   \n",
       "3                  0.0                    0.0                    0.0   \n",
       "4                  0.0                    0.0                    0.0   \n",
       "\n",
       "   t_weapon_r8revolver_price  t_weapon_negev_price  \\\n",
       "0                        0.0                   0.0   \n",
       "1                        0.0                   0.0   \n",
       "2                        0.0                   0.0   \n",
       "3                        0.0                   0.0   \n",
       "4                        0.0                   0.0   \n",
       "\n",
       "   t_category_machine gun_price  t_category_machine gun_amount  \\\n",
       "0                           0.0                            0.0   \n",
       "1                           0.0                            0.0   \n",
       "2                           0.0                            0.0   \n",
       "3                           0.0                            0.0   \n",
       "4                           0.0                            0.0   \n",
       "\n",
       "   ct_weapon_p90_price  ct_weapon_m249_price  ct_category_machine gun_price  \\\n",
       "0                  0.0                   0.0                            0.0   \n",
       "1                  0.0                   0.0                            0.0   \n",
       "2                  0.0                   0.0                            0.0   \n",
       "3                  0.0                   0.0                            0.0   \n",
       "4                  0.0                   0.0                            0.0   \n",
       "\n",
       "   ct_category_machine gun_amount  ct_players_alive_surplus time_left_cat  \\\n",
       "0                             0.0                       0.0         early   \n",
       "1                             0.0                       0.0         early   \n",
       "2                             0.0                       0.0           mid   \n",
       "3                             0.0                       0.0           mid   \n",
       "4                             0.0                       0.0         early   \n",
       "\n",
       "   players_alive  round_number  match_quarters  \n",
       "0           10.0           1.0              -1  \n",
       "1           10.0           1.0              -1  \n",
       "2            8.0           1.0              -1  \n",
       "3            8.0           1.0              -1  \n",
       "4           10.0           2.0               1  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#exploring data\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(122410, 213)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_two.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_two = df_two.loc[df_two['match_quarters'] != -1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_two = df_two.loc[df_two['t_overall_investment'] < 10000]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "df_two = df_two.loc[:, ['match_quarters', 't_category_grenade_amount', 't_category_smg_amount', 't_armor', 't_helmets', \n",
    "                       't_weapon_glock', 't_category_shotgun_amount']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Cleverminer version 1.0.2. Note: This version is for personal and educational use only. If you need PRO version (support, fixing structures for compactibility in future versions for production deployment, additional development, licensing of commercial use of subroutines used), feel free to ask authors. Most of these functionalities are maintained in best-effort, as soon as this project is at given conditions for free use and rapid development is needed, they cannot be guaranteed.\n",
      "Warning: Python 3.10+ NOT detected. You should upgrade to Python 3.10 or greater to get better performance\n",
      "Starting data preparation ...\n",
      "Encoding columns into bit-form...\n",
      "Encoding columns into bit-form...done\n",
      "Data preparation finished.\n",
      "Will go for  CFMiner\n",
      "Starting to mine rules.\n",
      "Done. Total verifications : 242, rules 4,control number:0, times: prep 0.13683605194091797, processing 0.2595224380493164\n",
      "\n",
      "CleverMiner task processing summary:\n",
      "\n",
      "Task type : CFMiner\n",
      "Number of verifications : 242\n",
      "Number of rules : 4\n",
      "Total time needed : 00h 00m 00s\n",
      "Time of data preparation : 00h 00m 00s\n",
      "Time of rule mining : 00h 00m 00s\n",
      "\n",
      "\n",
      "List of rules:\n",
      "RULEID BASE  S_UP  S_DOWN Condition\n",
      "     1  1359     1     2 t_category_smg_amount(0.0) & t_helmets(1.0) & t_weapon_glock(5.0)\n",
      "     2  1359     1     2 t_category_smg_amount(0.0) & t_helmets(1.0) & t_weapon_glock(5.0) & t_category_shotgun_amount(0.0)\n",
      "     3  1386     1     2 t_helmets(1.0) & t_weapon_glock(5.0)\n",
      "     4  1386     1     2 t_helmets(1.0) & t_weapon_glock(5.0) & t_category_shotgun_amount(0.0)\n",
      "\n",
      "\n",
      "\n",
      "Rule id : 2\n",
      "\n",
      "Base :  1359  Relative base : 0.041  Steps UP (consecutive) :     1  Steps DOWN (consecutive) :     2  Steps UP (any) :     1  Steps DOWN (any) :     2  Histogram maximum :   488  Histogram minimum :   252  Histogram relative maximum : 0.359 Histogram relative minimum : 0.185\n",
      "\n",
      "Condition  : t_category_smg_amount(0.0) & t_helmets(1.0) & t_weapon_glock(5.0) & t_category_shotgun_amount(0.0)\n",
      "\n",
      "Histogram [303, 488, 316, 252]\n",
      "\n"
     ]
    }
   ],
   "source": [
    "clm = cleverminer(df=df_two,target='match_quarters',proc='CFMiner',\n",
    "               quantifiers= {'RelMax': 0.35, 'RelMin': 0.15, 'Base':1000},\n",
    "               cond ={\n",
    "                    'attributes':[\n",
    "                        {'name': 't_category_smg_amount', 'type': 'subset', 'minlen': 1, 'maxlen': 1},\n",
    "                        {'name': 't_armor', 'type': 'subset', 'minlen': 1, 'maxlen': 1},\n",
    "                        {'name': 't_helmets', 'type': 'subset', 'minlen': 1, 'maxlen': 1},\n",
    "                        {'name': 't_weapon_glock', 'type': 'subset', 'minlen': 1, 'maxlen': 1},\n",
    "                        {'name': 't_category_shotgun_amount', 'type': 'subset', 'minlen': 1, 'maxlen': 1},\n",
    "                        {'name': 't_category_grenade_amount', 'type': 'subset', 'minlen': 1, 'maxlen': 1}\n",
    "                    ], 'minlen':1, 'maxlen':4, 'type':'con'}\n",
    "               )\n",
    "\n",
    "clm.print_summary()\n",
    "clm.print_rulelist()\n",
    "clm.print_rule(2)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}