Di-Tech Train Data Generation.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Please make sure that the data files are located in the folder \"season_1/training_data/order_data/\". Then run all the cells."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from os import walk\n",
    "\n",
    "\"\"\"import the order datas into a dataframe\"\"\" \n",
    "\n",
    "# Use path to data files.\n",
    "order_path = \"season_2/training_data/order_data/\" \n",
    "_, _, filenames = next(walk(order_path), (None, None, []))\n",
    "\n",
    "mSeq = len(filenames)\n",
    "frame = pd.DataFrame()\n",
    "list_ = []\n",
    "\n",
    "# Uncomment these lines to import all the data \n",
    "for i in range(mSeq-1):\n",
    "    # White Space as Delim, import all the data file.\n",
    "    df = pd.read_csv(str(order_path) + filenames[i+1],  delim_whitespace = 1, dtype = str, header = None) \n",
    "    list_.append(df)\n",
    "orders = pd.concat(list_)\n",
    "\n",
    "# Only import the data of the first day\n",
    "# orders = pd.read_csv(str(order_path) + filenames[1], delim_whitespace = 1, dtype = str,  header = None) \n",
    "\n",
    "# Rename all the columns.\n",
    "orders.columns = ['order_id', 'driver_id', 'passenger_id', \n",
    "                  'start_district_hash', 'dest_district_hash', \n",
    "                  'price', 'date', 'time']\n",
    "# Convert the Date and Time column in orders from an object to a datetime value. \n",
    "# This makes it easier to work with as a date.\n",
    "# Extract the year and month from from date_time, and assign them to their own columns.\n",
    "orders['datetime'] = pd.to_datetime(orders['date'] + ' ' + orders['time'])\n",
    "orders = orders.drop('date', 1)\n",
    "orders = orders.drop('time', 1)\n",
    "orders['day'] = orders[\"datetime\"].dt.day\n",
    "# Every 10 minutes is considered as a time slot. It can be calculated by following fomula\n",
    "orders['time_slot'] = orders[\"datetime\"].dt.hour*6 + orders[\"datetime\"].dt.minute//10"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "\"\"\"Categorize the start and destination with its id in \"\"\"\n",
    "\n",
    "# Import the hash id into a dictionary\n",
    "cluster_path = \"season_1/training_data/cluster_map/\"\n",
    "cluster = {}\n",
    "with open(cluster_path + \"cluster_map\") as f:\n",
    "    for line in f:\n",
    "       (key, val) = line.split()\n",
    "       cluster[str(key)] = val\n",
    "        \n",
    "# Update the start and destination district ID\n",
    "orders['start_district_id'] = orders['start_district_hash'].map(cluster)\n",
    "orders['dest_district_id'] = orders['dest_district_hash'].map(cluster)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false,
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "51    1328539\n",
      "23     772902\n",
      "8      745674\n",
      "48     542984\n",
      "28     493144\n",
      "1      444405\n",
      "7      423113\n",
      "37     396614\n",
      "46     337205\n",
      "12     277499\n",
      "20     273773\n",
      "24     230680\n",
      "14     228234\n",
      "21     196781\n",
      "42     186923\n",
      "27     166409\n",
      "4      141162\n",
      "19     130188\n",
      "22     101472\n",
      "26     100346\n",
      "25      86020\n",
      "9       80919\n",
      "29      63220\n",
      "11      58683\n",
      "36      57057\n",
      "2       51832\n",
      "6       45003\n",
      "54      40992\n",
      "35      35024\n",
      "57      33598\n",
      "       ...   \n",
      "39      23536\n",
      "47      23200\n",
      "41      21286\n",
      "16      21286\n",
      "34      20383\n",
      "18      19876\n",
      "33      18385\n",
      "40      16617\n",
      "17      14444\n",
      "56      11870\n",
      "45      11208\n",
      "58       8574\n",
      "5        8192\n",
      "10       8089\n",
      "3        7803\n",
      "59       6804\n",
      "49       6719\n",
      "32       6523\n",
      "65       6183\n",
      "30       6156\n",
      "61       5387\n",
      "43       5086\n",
      "55       4242\n",
      "50       4208\n",
      "52       3257\n",
      "44       3232\n",
      "60       3119\n",
      "62       1597\n",
      "15       1291\n",
      "63       1244\n",
      "Name: start_district_id, dtype: int64\n",
      "51     142540\n",
      "49     142397\n",
      "105    137069\n",
      "48     136041\n",
      "52     135507\n",
      "50     134670\n",
      "108    124015\n",
      "106    123243\n",
      "102    121360\n",
      "104    116309\n",
      "103    114633\n",
      "107    113623\n",
      "109    113151\n",
      "47     112958\n",
      "53     106772\n",
      "110    102154\n",
      "101     98287\n",
      "46      95526\n",
      "111     94065\n",
      "54      93961\n",
      "55      90460\n",
      "126     89142\n",
      "99      88994\n",
      "100     88746\n",
      "127     87536\n",
      "112     86257\n",
      "123     85188\n",
      "98      84748\n",
      "128     83776\n",
      "120     82525\n",
      "        ...  \n",
      "39      17295\n",
      "10      16348\n",
      "11      14611\n",
      "12      14020\n",
      "13      13185\n",
      "14      11818\n",
      "38      11608\n",
      "15      10643\n",
      "37       9565\n",
      "16       9445\n",
      "17       8835\n",
      "36       8735\n",
      "18       8317\n",
      "19       7365\n",
      "20       6514\n",
      "35       6479\n",
      "21       6324\n",
      "34       5803\n",
      "22       5557\n",
      "23       5432\n",
      "24       5334\n",
      "33       5220\n",
      "32       4953\n",
      "25       4918\n",
      "26       4838\n",
      "27       4687\n",
      "31       4585\n",
      "28       4578\n",
      "29       4279\n",
      "30       4270\n",
      "Name: time_slot, dtype: int64\n"
     ]
    }
   ],
   "source": [
    "# Take a look at the data. The number of the data collected in each district\n",
    "# is not evenly distributed. District 51 can be considered as a high occupancied\n",
    "# zone. We're more likely to dig into this kind of areas.\n",
    "# Also, interstingly there are more orders in from 12am to 1am, which is not expected.\n",
    "# Probably because of in this period there are still demands but not enough taxis or \n",
    "# other public transportation.\n",
    "\n",
    "print(orders[\"start_district_id\"].value_counts())\n",
    "print(orders[\"time_slot\"].value_counts())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# Now try to generate the gap data. We're looking for the orders which were not answered by a driver.\n",
    "# Hence we extract the orders with missing driver and count the number of them in each distrct and time slot.\n",
    "# The number of the not answered orders should be the gap we're looking for\n",
    "\n",
    "gaporders = orders[pd.isnull(orders['driver_id'])]\n",
    "gap = pd.DataFrame({'gap' : gaporders.groupby( ['day', 'start_district_id', 'time_slot'] ).size()}).reset_index()\n",
    "gap['key'] = gap.day.astype(str).str.cat(gap.start_district_id.astype(str), sep='_').str.cat(gap.time_slot.astype(str), sep='_')\n",
    "gap[\"district_id\"] = gap['start_district_id']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "144 66 66 21\n",
      "day: 1\n",
      "day: 2\n",
      "day: 3\n",
      "day: 4\n",
      "day: 5\n",
      "day: 6\n",
      "day: 7\n",
      "day: 8\n",
      "day: 9\n",
      "day: 10\n",
      "day: 11\n",
      "day: 12\n",
      "day: 13\n",
      "day: 14\n",
      "day: 15\n",
      "day: 16\n",
      "day: 17\n",
      "day: 18\n",
      "day: 19\n",
      "day: 20\n",
      "day: 21\n"
     ]
    }
   ],
   "source": [
    "# Create a new DataFrame to save the useful information\n",
    "time_slot = pd.DataFrame({'stat' : orders.groupby([\"time_slot\"]).size()})\n",
    "szone = pd.DataFrame({'stat' : orders.groupby([\"start_district_id\"]).size()})\n",
    "ezone = pd.DataFrame({'stat' : orders.groupby([\"dest_district_id\"]).size()})\n",
    "day = pd.DataFrame({'stat' : orders.groupby([\"day\"]).size()})\n",
    "print (len(time_slot),len(szone), len(ezone), len(day))\n",
    "in_d = pd.DataFrame(columns=['day', 'start_district_id', 'time_slot',\"gap\"])\n",
    "n = 1\n",
    "for d in day.index.values:    \n",
    "    date = d\n",
    "    print('day: '+ str(d))\n",
    "    for z in szone.index.values:\n",
    "        start = z\n",
    "        for t in time_slot.index.values:\n",
    "            time = t\n",
    "            in_d.loc[n]=[date, start, time, 0.0]\n",
    "            n+=1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "in_d.to_csv('in_d.txt', sep = ' ')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "in_da = pd.read_csv('in_d.txt', delim_whitespace = 1, dtype = float) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Create a new column called key which combines day, start district id and time slot. \n",
    "in_d['key'] = in_d[\"day\"]\n",
    "in_d['key'] = in_d.day.astype(int).astype(str).str.cat(in_d.start_district_id.astype(str), sep='_').str.cat(in_d.time_slot.astype(int).astype(str), sep='_')\n",
    "in_d[\"district_id\"] = in_d[\"start_district_id\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# Generate demand, supply and future supply (which depends on the destination of each order). Our naive model \n",
    "# will be based on these variables. Future supply will be an interesting attribute to dig in,\n",
    "\n",
    "demand = pd.DataFrame({'demand' : orders.groupby( ['day', 'start_district_id', 'time_slot'] ).size()}).reset_index()\n",
    "supply = pd.DataFrame({'demand' : orders.groupby( ['day', 'driver_id', 'time_slot'] ).size()}).reset_index()\n",
    "fsupply = pd.DataFrame({'future_supply' : orders.groupby( ['day', 'dest_district_id', 'time_slot'] ).size()}).reset_index()\n",
    "demand[\"district_id\"] = demand['start_district_id']\n",
    "fsupply[\"district_id\"] = fsupply['dest_district_id']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "            day  demand district_id  future_supply     gap  time_slot  \\\n",
      "key                                                                     \n",
      "1_51_5      1.0  4362.0          51         1119.0  3872.0        5.0   \n",
      "1_51_4      1.0  4296.0          51         1131.0  3784.0        4.0   \n",
      "1_51_6      1.0  4056.0          51          984.0  3602.0        6.0   \n",
      "1_51_7      1.0  3988.0          51          866.0  3514.0        7.0   \n",
      "1_51_8      1.0  3611.0          51          826.0  3149.0        8.0   \n",
      "1_51_3      1.0  3620.0          51         1018.0  3096.0        3.0   \n",
      "1_51_9      1.0  3367.0          51          717.0  2947.0        9.0   \n",
      "1_51_10     1.0  2821.0          51          586.0  2392.0       10.0   \n",
      "1_51_11     1.0  2224.0          51          473.0  1839.0       11.0   \n",
      "1_51_2      1.0  2363.0          51          741.0  1698.0        2.0   \n",
      "1_51_12     1.0  1859.0          51          411.0  1603.0       12.0   \n",
      "1_51_13     1.0  1669.0          51          434.0  1455.0       13.0   \n",
      "16_51_132  16.0  1715.0          51          902.0  1341.0      132.0   \n",
      "1_51_14     1.0  1477.0          51          373.0  1310.0       14.0   \n",
      "16_51_133  16.0  1657.0          51          778.0  1308.0      133.0   \n",
      "5_28_52     5.0  1763.0          28         1015.0  1249.0       52.0   \n",
      "5_28_51     5.0  1702.0          28         1124.0  1219.0       51.0   \n",
      "21_51_103  21.0  1863.0          51         1083.0  1215.0      103.0   \n",
      "1_23_4      1.0  1564.0          23          855.0  1198.0        4.0   \n",
      "1_23_5      1.0  1539.0          23          835.0  1161.0        5.0   \n",
      "16_51_134  16.0  1505.0          51          715.0  1151.0      134.0   \n",
      "21_51_105  21.0  1764.0          51         1192.0  1109.0      105.0   \n",
      "13_51_105  13.0  1601.0          51         1140.0  1081.0      105.0   \n",
      "11_51_104  11.0  1509.0          51         1001.0  1069.0      104.0   \n",
      "8_51_105    8.0  1592.0          51         1190.0  1065.0      105.0   \n",
      "11_28_49   11.0  1466.0          28          921.0  1057.0       49.0   \n",
      "21_51_102  21.0  1813.0          51         1097.0  1046.0      102.0   \n",
      "1_51_15     1.0  1192.0          51          306.0  1037.0       15.0   \n",
      "11_28_48   11.0  1450.0          28          907.0  1033.0       48.0   \n",
      "19_51_105  19.0  1520.0          51         1252.0  1013.0      105.0   \n",
      "...         ...     ...         ...            ...     ...        ...   \n",
      "10_41_142  10.0     2.0          41            2.0     0.0      142.0   \n",
      "10_42_29   10.0     3.0          42            4.0     0.0       29.0   \n",
      "10_42_28   10.0     3.0          42            5.0     0.0       28.0   \n",
      "10_42_27   10.0     6.0          42            5.0     0.0       27.0   \n",
      "10_42_26   10.0    10.0          42            1.0     0.0       26.0   \n",
      "10_42_24   10.0     5.0          42            3.0     0.0       24.0   \n",
      "10_42_20   10.0    10.0          42            5.0     0.0       20.0   \n",
      "10_42_19   10.0    12.0          42            7.0     0.0       19.0   \n",
      "10_42_14   10.0    14.0          42           13.0     0.0       14.0   \n",
      "10_42_12   10.0    17.0          42           18.0     0.0       12.0   \n",
      "10_42_11   10.0    17.0          42           13.0     0.0       11.0   \n",
      "10_42_9    10.0    18.0          42           13.0     0.0        9.0   \n",
      "10_42_8    10.0    23.0          42           16.0     0.0        8.0   \n",
      "10_41_143  10.0     3.0          41            6.0     0.0      143.0   \n",
      "10_41_141  10.0     1.0          41            7.0     0.0      141.0   \n",
      "10_41_124  10.0     5.0          41            8.0     0.0      124.0   \n",
      "10_41_140  10.0     3.0          41            1.0     0.0      140.0   \n",
      "10_41_138  10.0     1.0          41            5.0     0.0      138.0   \n",
      "10_41_137  10.0     1.0          41            5.0     0.0      137.0   \n",
      "10_41_136  10.0     3.0          41            2.0     0.0      136.0   \n",
      "10_41_135  10.0     6.0          41            7.0     0.0      135.0   \n",
      "10_41_134  10.0     3.0          41            8.0     0.0      134.0   \n",
      "10_41_133  10.0     4.0          41            6.0     0.0      133.0   \n",
      "10_41_132  10.0     2.0          41            3.0     0.0      132.0   \n",
      "10_41_130  10.0     3.0          41            6.0     0.0      130.0   \n",
      "10_41_129  10.0     3.0          41           12.0     0.0      129.0   \n",
      "10_41_128  10.0     3.0          41           10.0     0.0      128.0   \n",
      "10_41_127  10.0     2.0          41           11.0     0.0      127.0   \n",
      "10_41_125  10.0     3.0          41            6.0     0.0      125.0   \n",
      "21_9_143   21.0     6.0           9            9.0     0.0      143.0   \n",
      "\n",
      "                time  supply  \n",
      "key                           \n",
      "1_51_5      0.833333   490.0  \n",
      "1_51_4      0.666667   512.0  \n",
      "1_51_6      1.000000   454.0  \n",
      "1_51_7      1.166667   474.0  \n",
      "1_51_8      1.333333   462.0  \n",
      "1_51_3      0.500000   524.0  \n",
      "1_51_9      1.500000   420.0  \n",
      "1_51_10     1.666667   429.0  \n",
      "1_51_11     1.833333   385.0  \n",
      "1_51_2      0.333333   665.0  \n",
      "1_51_12     2.000000   256.0  \n",
      "1_51_13     2.166667   214.0  \n",
      "16_51_132  22.000000   374.0  \n",
      "1_51_14     2.333333   167.0  \n",
      "16_51_133  22.166667   349.0  \n",
      "5_28_52     8.666667   514.0  \n",
      "5_28_51     8.500000   483.0  \n",
      "21_51_103  17.166667   648.0  \n",
      "1_23_4      0.666667   366.0  \n",
      "1_23_5      0.833333   378.0  \n",
      "16_51_134  22.333333   354.0  \n",
      "21_51_105  17.500000   655.0  \n",
      "13_51_105  17.500000   520.0  \n",
      "11_51_104  17.333333   440.0  \n",
      "8_51_105   17.500000   527.0  \n",
      "11_28_49    8.166667   409.0  \n",
      "21_51_102  17.000000   767.0  \n",
      "1_51_15     2.500000   155.0  \n",
      "11_28_48    8.000000   417.0  \n",
      "19_51_105  17.500000   507.0  \n",
      "...              ...     ...  \n",
      "10_41_142  23.666667     2.0  \n",
      "10_42_29    4.833333     3.0  \n",
      "10_42_28    4.666667     3.0  \n",
      "10_42_27    4.500000     6.0  \n",
      "10_42_26    4.333333    10.0  \n",
      "10_42_24    4.000000     5.0  \n",
      "10_42_20    3.333333    10.0  \n",
      "10_42_19    3.166667    12.0  \n",
      "10_42_14    2.333333    14.0  \n",
      "10_42_12    2.000000    17.0  \n",
      "10_42_11    1.833333    17.0  \n",
      "10_42_9     1.500000    18.0  \n",
      "10_42_8     1.333333    23.0  \n",
      "10_41_143  23.833333     3.0  \n",
      "10_41_141  23.500000     1.0  \n",
      "10_41_124  20.666667     5.0  \n",
      "10_41_140  23.333333     3.0  \n",
      "10_41_138  23.000000     1.0  \n",
      "10_41_137  22.833333     1.0  \n",
      "10_41_136  22.666667     3.0  \n",
      "10_41_135  22.500000     6.0  \n",
      "10_41_134  22.333333     3.0  \n",
      "10_41_133  22.166667     4.0  \n",
      "10_41_132  22.000000     2.0  \n",
      "10_41_130  21.666667     3.0  \n",
      "10_41_129  21.500000     3.0  \n",
      "10_41_128  21.333333     3.0  \n",
      "10_41_127  21.166667     2.0  \n",
      "10_41_125  20.833333     3.0  \n",
      "21_9_143   23.833333     6.0  \n",
      "\n",
      "[199584 rows x 8 columns]\n"
     ]
    }
   ],
   "source": [
    "# fill in the table with the information generated.\n",
    "\n",
    "def join_value(left, right, key):\n",
    "    left['key'] = left.day.astype(int).astype(str).str.cat(left.district_id.astype(int).astype(str), sep='_').str.cat(left.time_slot.astype(int).astype(str), sep='_')\n",
    "    right['key'] = right.day.astype(int).astype(str).str.cat(right.district_id.astype(int).astype(str), sep='_').str.cat(right.time_slot.astype(int).astype(str), sep='_')\n",
    "    left_a = left.set_index(key)\n",
    "    right_a = right.set_index(key)\n",
    "\n",
    "    res = left_a.loc[:, left_a.columns.union(right_a.columns)]\n",
    "    res.update(right_a)\n",
    "    return res\n",
    "\n",
    "res = join_value(in_d, gap, \"key\")\n",
    "res = join_value(res, demand, \"key\")\n",
    "res = join_value(res, fsupply, \"key\")\n",
    "res[\"time\"] = res[\"time_slot\"]/144*24\n",
    "res.drop([\"dest_district_id\", \"start_district_id\"], axis=1,inplace=True) \n",
    "res[\"supply\"] = res[\"demand\"]-res[\"gap\"]\n",
    "\n",
    "print (res.sort_values([\"gap\"], ascending=False))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "res['fri'] = res['day']==1\n",
    "res['sat'] = res['day']==2\n",
    "res['sun'] = res['day']==3\n",
    "res['mon'] = res['day']==4\n",
    "res['tue'] = res['day']==5\n",
    "res['wed'] = res['day']==6\n",
    "res['thu'] = res['day']==7\n",
    "\n",
    "res['gap_slot'] = res['gap']\n",
    "res['gap_max'] = 100\n",
    "res['gap_slot'] = res[['gap_slot', 'gap_max']].min(axis=1)\n",
    "res['gap_slot'] = res['gap_slot']//5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "input = pd.DataFrame(res[['day', 'district_id', 'gap', 'time_slot']])\n",
    "output = pd.DataFrame(res[['day', 'time_slot', 'gap', 'gap_slot']])\n",
    "\n",
    "output = output.ix[1:]\n",
    "input = input.ix[:(input.shape[0]-1)]\n",
    "time_slot_dummies = pd.get_dummies(input['time_slot'])\n",
    "for i in range(142):\n",
    "    input['time_slot_'+str(i)] = time_slot_dummies[float(i)]\n",
    "district_dummies = pd.get_dummies(input['district_id'])\n",
    "for i in range(65):\n",
    "    input['district_id_'+str(i+1)] = district_dummies[str(i+1)]\n",
    "input['fri'] = input['day']//7==1\n",
    "input['sat'] = input['day']//7==2\n",
    "input['sun'] = input['day']//7==3\n",
    "input['mon'] = input['day']//7==4\n",
    "input['tue'] = input['day']//7==5\n",
    "input['wed'] = input['day']//7==6\n",
    "input.drop('district_id', axis=1, inplace=True)\n",
    "input.drop('time_slot', axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>day</th>\n",
       "      <th>gap</th>\n",
       "      <th>time_slot_0</th>\n",
       "      <th>time_slot_1</th>\n",
       "      <th>time_slot_2</th>\n",
       "      <th>time_slot_3</th>\n",
       "      <th>time_slot_4</th>\n",
       "      <th>time_slot_5</th>\n",
       "      <th>time_slot_6</th>\n",
       "      <th>time_slot_7</th>\n",
       "      <th>...</th>\n",
       "      <th>district_id_62</th>\n",
       "      <th>district_id_63</th>\n",
       "      <th>district_id_64</th>\n",
       "      <th>district_id_65</th>\n",
       "      <th>fri</th>\n",
       "      <th>sat</th>\n",
       "      <th>sun</th>\n",
       "      <th>mon</th>\n",
       "      <th>tue</th>\n",
       "      <th>wed</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>key</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1_1_0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>7.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_2</th>\n",
       "      <td>1.0</td>\n",
       "      <td>10.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_3</th>\n",
       "      <td>1.0</td>\n",
       "      <td>5.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_4</th>\n",
       "      <td>1.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>1.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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_5</th>\n",
       "      <td>1.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>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_6</th>\n",
       "      <td>1.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>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_7</th>\n",
       "      <td>1.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>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_8</th>\n",
       "      <td>1.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>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_9</th>\n",
       "      <td>1.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>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_10</th>\n",
       "      <td>1.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>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_11</th>\n",
       "      <td>1.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_12</th>\n",
       "      <td>1.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_13</th>\n",
       "      <td>1.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_14</th>\n",
       "      <td>1.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_15</th>\n",
       "      <td>1.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_16</th>\n",
       "      <td>1.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_17</th>\n",
       "      <td>1.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_18</th>\n",
       "      <td>1.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_19</th>\n",
       "      <td>1.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>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_20</th>\n",
       "      <td>1.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>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_21</th>\n",
       "      <td>1.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_22</th>\n",
       "      <td>1.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_23</th>\n",
       "      <td>1.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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_24</th>\n",
       "      <td>1.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_25</th>\n",
       "      <td>1.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_26</th>\n",
       "      <td>1.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_27</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_28</th>\n",
       "      <td>1.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_29</th>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_113</th>\n",
       "      <td>21.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_114</th>\n",
       "      <td>21.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_115</th>\n",
       "      <td>21.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_116</th>\n",
       "      <td>21.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_117</th>\n",
       "      <td>21.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_118</th>\n",
       "      <td>21.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>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_119</th>\n",
       "      <td>21.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>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_120</th>\n",
       "      <td>21.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_121</th>\n",
       "      <td>21.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_122</th>\n",
       "      <td>21.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_123</th>\n",
       "      <td>21.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_124</th>\n",
       "      <td>21.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_125</th>\n",
       "      <td>21.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_126</th>\n",
       "      <td>21.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_127</th>\n",
       "      <td>21.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_128</th>\n",
       "      <td>21.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>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_129</th>\n",
       "      <td>21.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>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_130</th>\n",
       "      <td>21.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>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_131</th>\n",
       "      <td>21.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_132</th>\n",
       "      <td>21.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>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_133</th>\n",
       "      <td>21.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>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_134</th>\n",
       "      <td>21.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_135</th>\n",
       "      <td>21.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_136</th>\n",
       "      <td>21.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_137</th>\n",
       "      <td>21.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_138</th>\n",
       "      <td>21.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_139</th>\n",
       "      <td>21.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>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_140</th>\n",
       "      <td>21.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>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_141</th>\n",
       "      <td>21.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_142</th>\n",
       "      <td>21.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>199583 rows × 215 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           day   gap  time_slot_0  time_slot_1  time_slot_2  time_slot_3  \\\n",
       "key                                                                        \n",
       "1_1_0      1.0   9.0          1.0          0.0          0.0          0.0   \n",
       "1_1_1      1.0   7.0          0.0          1.0          0.0          0.0   \n",
       "1_1_2      1.0  10.0          0.0          0.0          1.0          0.0   \n",
       "1_1_3      1.0   5.0          0.0          0.0          0.0          1.0   \n",
       "1_1_4      1.0   1.0          0.0          0.0          0.0          0.0   \n",
       "1_1_5      1.0   1.0          0.0          0.0          0.0          0.0   \n",
       "1_1_6      1.0   6.0          0.0          0.0          0.0          0.0   \n",
       "1_1_7      1.0   2.0          0.0          0.0          0.0          0.0   \n",
       "1_1_8      1.0   6.0          0.0          0.0          0.0          0.0   \n",
       "1_1_9      1.0   6.0          0.0          0.0          0.0          0.0   \n",
       "1_1_10     1.0   2.0          0.0          0.0          0.0          0.0   \n",
       "1_1_11     1.0   3.0          0.0          0.0          0.0          0.0   \n",
       "1_1_12     1.0   1.0          0.0          0.0          0.0          0.0   \n",
       "1_1_13     1.0   4.0          0.0          0.0          0.0          0.0   \n",
       "1_1_14     1.0   3.0          0.0          0.0          0.0          0.0   \n",
       "1_1_15     1.0  11.0          0.0          0.0          0.0          0.0   \n",
       "1_1_16     1.0  20.0          0.0          0.0          0.0          0.0   \n",
       "1_1_17     1.0  18.0          0.0          0.0          0.0          0.0   \n",
       "1_1_18     1.0  11.0          0.0          0.0          0.0          0.0   \n",
       "1_1_19     1.0   6.0          0.0          0.0          0.0          0.0   \n",
       "1_1_20     1.0   2.0          0.0          0.0          0.0          0.0   \n",
       "1_1_21     1.0   1.0          0.0          0.0          0.0          0.0   \n",
       "1_1_22     1.0   3.0          0.0          0.0          0.0          0.0   \n",
       "1_1_23     1.0   8.0          0.0          0.0          0.0          0.0   \n",
       "1_1_24     1.0   1.0          0.0          0.0          0.0          0.0   \n",
       "1_1_25     1.0   1.0          0.0          0.0          0.0          0.0   \n",
       "1_1_26     1.0   5.0          0.0          0.0          0.0          0.0   \n",
       "1_1_27     1.0   0.0          0.0          0.0          0.0          0.0   \n",
       "1_1_28     1.0   4.0          0.0          0.0          0.0          0.0   \n",
       "1_1_29     1.0  13.0          0.0          0.0          0.0          0.0   \n",
       "...        ...   ...          ...          ...          ...          ...   \n",
       "21_9_113  21.0   3.0          0.0          0.0          0.0          0.0   \n",
       "21_9_114  21.0   1.0          0.0          0.0          0.0          0.0   \n",
       "21_9_115  21.0   1.0          0.0          0.0          0.0          0.0   \n",
       "21_9_116  21.0   0.0          0.0          0.0          0.0          0.0   \n",
       "21_9_117  21.0   1.0          0.0          0.0          0.0          0.0   \n",
       "21_9_118  21.0   2.0          0.0          0.0          0.0          0.0   \n",
       "21_9_119  21.0   2.0          0.0          0.0          0.0          0.0   \n",
       "21_9_120  21.0   1.0          0.0          0.0          0.0          0.0   \n",
       "21_9_121  21.0   0.0          0.0          0.0          0.0          0.0   \n",
       "21_9_122  21.0   3.0          0.0          0.0          0.0          0.0   \n",
       "21_9_123  21.0   3.0          0.0          0.0          0.0          0.0   \n",
       "21_9_124  21.0   4.0          0.0          0.0          0.0          0.0   \n",
       "21_9_125  21.0   5.0          0.0          0.0          0.0          0.0   \n",
       "21_9_126  21.0   3.0          0.0          0.0          0.0          0.0   \n",
       "21_9_127  21.0   1.0          0.0          0.0          0.0          0.0   \n",
       "21_9_128  21.0   2.0          0.0          0.0          0.0          0.0   \n",
       "21_9_129  21.0   6.0          0.0          0.0          0.0          0.0   \n",
       "21_9_130  21.0   2.0          0.0          0.0          0.0          0.0   \n",
       "21_9_131  21.0   1.0          0.0          0.0          0.0          0.0   \n",
       "21_9_132  21.0   2.0          0.0          0.0          0.0          0.0   \n",
       "21_9_133  21.0   2.0          0.0          0.0          0.0          0.0   \n",
       "21_9_134  21.0   3.0          0.0          0.0          0.0          0.0   \n",
       "21_9_135  21.0   3.0          0.0          0.0          0.0          0.0   \n",
       "21_9_136  21.0   0.0          0.0          0.0          0.0          0.0   \n",
       "21_9_137  21.0   0.0          0.0          0.0          0.0          0.0   \n",
       "21_9_138  21.0   1.0          0.0          0.0          0.0          0.0   \n",
       "21_9_139  21.0   2.0          0.0          0.0          0.0          0.0   \n",
       "21_9_140  21.0   6.0          0.0          0.0          0.0          0.0   \n",
       "21_9_141  21.0   1.0          0.0          0.0          0.0          0.0   \n",
       "21_9_142  21.0   4.0          0.0          0.0          0.0          0.0   \n",
       "\n",
       "          time_slot_4  time_slot_5  time_slot_6  time_slot_7  ...    \\\n",
       "key                                                           ...     \n",
       "1_1_0             0.0          0.0          0.0          0.0  ...     \n",
       "1_1_1             0.0          0.0          0.0          0.0  ...     \n",
       "1_1_2             0.0          0.0          0.0          0.0  ...     \n",
       "1_1_3             0.0          0.0          0.0          0.0  ...     \n",
       "1_1_4             1.0          0.0          0.0          0.0  ...     \n",
       "1_1_5             0.0          1.0          0.0          0.0  ...     \n",
       "1_1_6             0.0          0.0          1.0          0.0  ...     \n",
       "1_1_7             0.0          0.0          0.0          1.0  ...     \n",
       "1_1_8             0.0          0.0          0.0          0.0  ...     \n",
       "1_1_9             0.0          0.0          0.0          0.0  ...     \n",
       "1_1_10            0.0          0.0          0.0          0.0  ...     \n",
       "1_1_11            0.0          0.0          0.0          0.0  ...     \n",
       "1_1_12            0.0          0.0          0.0          0.0  ...     \n",
       "1_1_13            0.0          0.0          0.0          0.0  ...     \n",
       "1_1_14            0.0          0.0          0.0          0.0  ...     \n",
       "1_1_15            0.0          0.0          0.0          0.0  ...     \n",
       "1_1_16            0.0          0.0          0.0          0.0  ...     \n",
       "1_1_17            0.0          0.0          0.0          0.0  ...     \n",
       "1_1_18            0.0          0.0          0.0          0.0  ...     \n",
       "1_1_19            0.0          0.0          0.0          0.0  ...     \n",
       "1_1_20            0.0          0.0          0.0          0.0  ...     \n",
       "1_1_21            0.0          0.0          0.0          0.0  ...     \n",
       "1_1_22            0.0          0.0          0.0          0.0  ...     \n",
       "1_1_23            0.0          0.0          0.0          0.0  ...     \n",
       "1_1_24            0.0          0.0          0.0          0.0  ...     \n",
       "1_1_25            0.0          0.0          0.0          0.0  ...     \n",
       "1_1_26            0.0          0.0          0.0          0.0  ...     \n",
       "1_1_27            0.0          0.0          0.0          0.0  ...     \n",
       "1_1_28            0.0          0.0          0.0          0.0  ...     \n",
       "1_1_29            0.0          0.0          0.0          0.0  ...     \n",
       "...               ...          ...          ...          ...  ...     \n",
       "21_9_113          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_114          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_115          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_116          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_117          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_118          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_119          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_120          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_121          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_122          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_123          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_124          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_125          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_126          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_127          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_128          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_129          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_130          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_131          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_132          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_133          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_134          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_135          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_136          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_137          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_138          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_139          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_140          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_141          0.0          0.0          0.0          0.0  ...     \n",
       "21_9_142          0.0          0.0          0.0          0.0  ...     \n",
       "\n",
       "          district_id_62  district_id_63  district_id_64  district_id_65  \\\n",
       "key                                                                        \n",
       "1_1_0                0.0             0.0             0.0             0.0   \n",
       "1_1_1                0.0             0.0             0.0             0.0   \n",
       "1_1_2                0.0             0.0             0.0             0.0   \n",
       "1_1_3                0.0             0.0             0.0             0.0   \n",
       "1_1_4                0.0             0.0             0.0             0.0   \n",
       "1_1_5                0.0             0.0             0.0             0.0   \n",
       "1_1_6                0.0             0.0             0.0             0.0   \n",
       "1_1_7                0.0             0.0             0.0             0.0   \n",
       "1_1_8                0.0             0.0             0.0             0.0   \n",
       "1_1_9                0.0             0.0             0.0             0.0   \n",
       "1_1_10               0.0             0.0             0.0             0.0   \n",
       "1_1_11               0.0             0.0             0.0             0.0   \n",
       "1_1_12               0.0             0.0             0.0             0.0   \n",
       "1_1_13               0.0             0.0             0.0             0.0   \n",
       "1_1_14               0.0             0.0             0.0             0.0   \n",
       "1_1_15               0.0             0.0             0.0             0.0   \n",
       "1_1_16               0.0             0.0             0.0             0.0   \n",
       "1_1_17               0.0             0.0             0.0             0.0   \n",
       "1_1_18               0.0             0.0             0.0             0.0   \n",
       "1_1_19               0.0             0.0             0.0             0.0   \n",
       "1_1_20               0.0             0.0             0.0             0.0   \n",
       "1_1_21               0.0             0.0             0.0             0.0   \n",
       "1_1_22               0.0             0.0             0.0             0.0   \n",
       "1_1_23               0.0             0.0             0.0             0.0   \n",
       "1_1_24               0.0             0.0             0.0             0.0   \n",
       "1_1_25               0.0             0.0             0.0             0.0   \n",
       "1_1_26               0.0             0.0             0.0             0.0   \n",
       "1_1_27               0.0             0.0             0.0             0.0   \n",
       "1_1_28               0.0             0.0             0.0             0.0   \n",
       "1_1_29               0.0             0.0             0.0             0.0   \n",
       "...                  ...             ...             ...             ...   \n",
       "21_9_113             0.0             0.0             0.0             0.0   \n",
       "21_9_114             0.0             0.0             0.0             0.0   \n",
       "21_9_115             0.0             0.0             0.0             0.0   \n",
       "21_9_116             0.0             0.0             0.0             0.0   \n",
       "21_9_117             0.0             0.0             0.0             0.0   \n",
       "21_9_118             0.0             0.0             0.0             0.0   \n",
       "21_9_119             0.0             0.0             0.0             0.0   \n",
       "21_9_120             0.0             0.0             0.0             0.0   \n",
       "21_9_121             0.0             0.0             0.0             0.0   \n",
       "21_9_122             0.0             0.0             0.0             0.0   \n",
       "21_9_123             0.0             0.0             0.0             0.0   \n",
       "21_9_124             0.0             0.0             0.0             0.0   \n",
       "21_9_125             0.0             0.0             0.0             0.0   \n",
       "21_9_126             0.0             0.0             0.0             0.0   \n",
       "21_9_127             0.0             0.0             0.0             0.0   \n",
       "21_9_128             0.0             0.0             0.0             0.0   \n",
       "21_9_129             0.0             0.0             0.0             0.0   \n",
       "21_9_130             0.0             0.0             0.0             0.0   \n",
       "21_9_131             0.0             0.0             0.0             0.0   \n",
       "21_9_132             0.0             0.0             0.0             0.0   \n",
       "21_9_133             0.0             0.0             0.0             0.0   \n",
       "21_9_134             0.0             0.0             0.0             0.0   \n",
       "21_9_135             0.0             0.0             0.0             0.0   \n",
       "21_9_136             0.0             0.0             0.0             0.0   \n",
       "21_9_137             0.0             0.0             0.0             0.0   \n",
       "21_9_138             0.0             0.0             0.0             0.0   \n",
       "21_9_139             0.0             0.0             0.0             0.0   \n",
       "21_9_140             0.0             0.0             0.0             0.0   \n",
       "21_9_141             0.0             0.0             0.0             0.0   \n",
       "21_9_142             0.0             0.0             0.0             0.0   \n",
       "\n",
       "            fri    sat    sun    mon    tue    wed  \n",
       "key                                                 \n",
       "1_1_0     False  False  False  False  False  False  \n",
       "1_1_1     False  False  False  False  False  False  \n",
       "1_1_2     False  False  False  False  False  False  \n",
       "1_1_3     False  False  False  False  False  False  \n",
       "1_1_4     False  False  False  False  False  False  \n",
       "1_1_5     False  False  False  False  False  False  \n",
       "1_1_6     False  False  False  False  False  False  \n",
       "1_1_7     False  False  False  False  False  False  \n",
       "1_1_8     False  False  False  False  False  False  \n",
       "1_1_9     False  False  False  False  False  False  \n",
       "1_1_10    False  False  False  False  False  False  \n",
       "1_1_11    False  False  False  False  False  False  \n",
       "1_1_12    False  False  False  False  False  False  \n",
       "1_1_13    False  False  False  False  False  False  \n",
       "1_1_14    False  False  False  False  False  False  \n",
       "1_1_15    False  False  False  False  False  False  \n",
       "1_1_16    False  False  False  False  False  False  \n",
       "1_1_17    False  False  False  False  False  False  \n",
       "1_1_18    False  False  False  False  False  False  \n",
       "1_1_19    False  False  False  False  False  False  \n",
       "1_1_20    False  False  False  False  False  False  \n",
       "1_1_21    False  False  False  False  False  False  \n",
       "1_1_22    False  False  False  False  False  False  \n",
       "1_1_23    False  False  False  False  False  False  \n",
       "1_1_24    False  False  False  False  False  False  \n",
       "1_1_25    False  False  False  False  False  False  \n",
       "1_1_26    False  False  False  False  False  False  \n",
       "1_1_27    False  False  False  False  False  False  \n",
       "1_1_28    False  False  False  False  False  False  \n",
       "1_1_29    False  False  False  False  False  False  \n",
       "...         ...    ...    ...    ...    ...    ...  \n",
       "21_9_113  False  False   True  False  False  False  \n",
       "21_9_114  False  False   True  False  False  False  \n",
       "21_9_115  False  False   True  False  False  False  \n",
       "21_9_116  False  False   True  False  False  False  \n",
       "21_9_117  False  False   True  False  False  False  \n",
       "21_9_118  False  False   True  False  False  False  \n",
       "21_9_119  False  False   True  False  False  False  \n",
       "21_9_120  False  False   True  False  False  False  \n",
       "21_9_121  False  False   True  False  False  False  \n",
       "21_9_122  False  False   True  False  False  False  \n",
       "21_9_123  False  False   True  False  False  False  \n",
       "21_9_124  False  False   True  False  False  False  \n",
       "21_9_125  False  False   True  False  False  False  \n",
       "21_9_126  False  False   True  False  False  False  \n",
       "21_9_127  False  False   True  False  False  False  \n",
       "21_9_128  False  False   True  False  False  False  \n",
       "21_9_129  False  False   True  False  False  False  \n",
       "21_9_130  False  False   True  False  False  False  \n",
       "21_9_131  False  False   True  False  False  False  \n",
       "21_9_132  False  False   True  False  False  False  \n",
       "21_9_133  False  False   True  False  False  False  \n",
       "21_9_134  False  False   True  False  False  False  \n",
       "21_9_135  False  False   True  False  False  False  \n",
       "21_9_136  False  False   True  False  False  False  \n",
       "21_9_137  False  False   True  False  False  False  \n",
       "21_9_138  False  False   True  False  False  False  \n",
       "21_9_139  False  False   True  False  False  False  \n",
       "21_9_140  False  False   True  False  False  False  \n",
       "21_9_141  False  False   True  False  False  False  \n",
       "21_9_142  False  False   True  False  False  False  \n",
       "\n",
       "[199583 rows x 215 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "input"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>day</th>\n",
       "      <th>time_slot</th>\n",
       "      <th>gap</th>\n",
       "      <th>gap_slot</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>key</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1_1_1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_2</th>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_3</th>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_4</th>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_5</th>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_6</th>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_7</th>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_8</th>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_9</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_10</th>\n",
       "      <td>1.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_11</th>\n",
       "      <td>1.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_12</th>\n",
       "      <td>1.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_13</th>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_14</th>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_15</th>\n",
       "      <td>1.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_16</th>\n",
       "      <td>1.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_17</th>\n",
       "      <td>1.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_18</th>\n",
       "      <td>1.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_19</th>\n",
       "      <td>1.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_20</th>\n",
       "      <td>1.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_21</th>\n",
       "      <td>1.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_22</th>\n",
       "      <td>1.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_23</th>\n",
       "      <td>1.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_24</th>\n",
       "      <td>1.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_25</th>\n",
       "      <td>1.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_26</th>\n",
       "      <td>1.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_27</th>\n",
       "      <td>1.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_28</th>\n",
       "      <td>1.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_29</th>\n",
       "      <td>1.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_30</th>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_114</th>\n",
       "      <td>21.0</td>\n",
       "      <td>114.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_115</th>\n",
       "      <td>21.0</td>\n",
       "      <td>115.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_116</th>\n",
       "      <td>21.0</td>\n",
       "      <td>116.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_117</th>\n",
       "      <td>21.0</td>\n",
       "      <td>117.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_118</th>\n",
       "      <td>21.0</td>\n",
       "      <td>118.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_119</th>\n",
       "      <td>21.0</td>\n",
       "      <td>119.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_120</th>\n",
       "      <td>21.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_121</th>\n",
       "      <td>21.0</td>\n",
       "      <td>121.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_122</th>\n",
       "      <td>21.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_123</th>\n",
       "      <td>21.0</td>\n",
       "      <td>123.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_124</th>\n",
       "      <td>21.0</td>\n",
       "      <td>124.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_125</th>\n",
       "      <td>21.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_126</th>\n",
       "      <td>21.0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_127</th>\n",
       "      <td>21.0</td>\n",
       "      <td>127.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_128</th>\n",
       "      <td>21.0</td>\n",
       "      <td>128.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_129</th>\n",
       "      <td>21.0</td>\n",
       "      <td>129.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_130</th>\n",
       "      <td>21.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_131</th>\n",
       "      <td>21.0</td>\n",
       "      <td>131.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_132</th>\n",
       "      <td>21.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_133</th>\n",
       "      <td>21.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_134</th>\n",
       "      <td>21.0</td>\n",
       "      <td>134.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_135</th>\n",
       "      <td>21.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_136</th>\n",
       "      <td>21.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_137</th>\n",
       "      <td>21.0</td>\n",
       "      <td>137.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_138</th>\n",
       "      <td>21.0</td>\n",
       "      <td>138.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_139</th>\n",
       "      <td>21.0</td>\n",
       "      <td>139.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_140</th>\n",
       "      <td>21.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_141</th>\n",
       "      <td>21.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_142</th>\n",
       "      <td>21.0</td>\n",
       "      <td>142.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_143</th>\n",
       "      <td>21.0</td>\n",
       "      <td>143.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>199583 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           day  time_slot   gap  gap_slot\n",
       "key                                      \n",
       "1_1_1      1.0        1.0   7.0       1.0\n",
       "1_1_2      1.0        2.0  10.0       2.0\n",
       "1_1_3      1.0        3.0   5.0       1.0\n",
       "1_1_4      1.0        4.0   1.0       0.0\n",
       "1_1_5      1.0        5.0   1.0       0.0\n",
       "1_1_6      1.0        6.0   6.0       1.0\n",
       "1_1_7      1.0        7.0   2.0       0.0\n",
       "1_1_8      1.0        8.0   6.0       1.0\n",
       "1_1_9      1.0        9.0   6.0       1.0\n",
       "1_1_10     1.0       10.0   2.0       0.0\n",
       "1_1_11     1.0       11.0   3.0       0.0\n",
       "1_1_12     1.0       12.0   1.0       0.0\n",
       "1_1_13     1.0       13.0   4.0       0.0\n",
       "1_1_14     1.0       14.0   3.0       0.0\n",
       "1_1_15     1.0       15.0  11.0       2.0\n",
       "1_1_16     1.0       16.0  20.0       4.0\n",
       "1_1_17     1.0       17.0  18.0       3.0\n",
       "1_1_18     1.0       18.0  11.0       2.0\n",
       "1_1_19     1.0       19.0   6.0       1.0\n",
       "1_1_20     1.0       20.0   2.0       0.0\n",
       "1_1_21     1.0       21.0   1.0       0.0\n",
       "1_1_22     1.0       22.0   3.0       0.0\n",
       "1_1_23     1.0       23.0   8.0       1.0\n",
       "1_1_24     1.0       24.0   1.0       0.0\n",
       "1_1_25     1.0       25.0   1.0       0.0\n",
       "1_1_26     1.0       26.0   5.0       1.0\n",
       "1_1_27     1.0       27.0   0.0      -0.0\n",
       "1_1_28     1.0       28.0   4.0       0.0\n",
       "1_1_29     1.0       29.0  13.0       2.0\n",
       "1_1_30     1.0       30.0  28.0       5.0\n",
       "...        ...        ...   ...       ...\n",
       "21_9_114  21.0      114.0   1.0       0.0\n",
       "21_9_115  21.0      115.0   1.0       0.0\n",
       "21_9_116  21.0      116.0   0.0      -0.0\n",
       "21_9_117  21.0      117.0   1.0       0.0\n",
       "21_9_118  21.0      118.0   2.0       0.0\n",
       "21_9_119  21.0      119.0   2.0       0.0\n",
       "21_9_120  21.0      120.0   1.0       0.0\n",
       "21_9_121  21.0      121.0   0.0      -0.0\n",
       "21_9_122  21.0      122.0   3.0       0.0\n",
       "21_9_123  21.0      123.0   3.0       0.0\n",
       "21_9_124  21.0      124.0   4.0       0.0\n",
       "21_9_125  21.0      125.0   5.0       1.0\n",
       "21_9_126  21.0      126.0   3.0       0.0\n",
       "21_9_127  21.0      127.0   1.0       0.0\n",
       "21_9_128  21.0      128.0   2.0       0.0\n",
       "21_9_129  21.0      129.0   6.0       1.0\n",
       "21_9_130  21.0      130.0   2.0       0.0\n",
       "21_9_131  21.0      131.0   1.0       0.0\n",
       "21_9_132  21.0      132.0   2.0       0.0\n",
       "21_9_133  21.0      133.0   2.0       0.0\n",
       "21_9_134  21.0      134.0   3.0       0.0\n",
       "21_9_135  21.0      135.0   3.0       0.0\n",
       "21_9_136  21.0      136.0   0.0      -0.0\n",
       "21_9_137  21.0      137.0   0.0      -0.0\n",
       "21_9_138  21.0      138.0   1.0       0.0\n",
       "21_9_139  21.0      139.0   2.0       0.0\n",
       "21_9_140  21.0      140.0   6.0       1.0\n",
       "21_9_141  21.0      141.0   1.0       0.0\n",
       "21_9_142  21.0      142.0   4.0       0.0\n",
       "21_9_143  21.0      143.0   0.0      -0.0\n",
       "\n",
       "[199583 rows x 4 columns]"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "output"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# Convert the data we need into np array for training network\n",
    "import numpy as np\n",
    "train_x = input.as_matrix().astype(float)\n",
    "train_y = output['gap'].as_matrix().astype(float)\n",
    "train_y_class = output['gap_slot'].as_matrix().astype(float)\n",
    "train_y_class1 = output['class'].as_matrix().astype(float)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "train_y_diff = train_y.copy()\n",
    "for i in range(train_y_diff.shape[0]-1):\n",
    "    train_y_diff[i] = train_y_diff[i+1] - train_y_diff[i]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "res"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Export the np array and dataframe as txt for future convenience"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "print(train_x.shape, train_y.shape, train_y_class.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "np.savetxt('train_x.txt', train_x, fmt='%.18e', delimiter=' ', newline='\\n', header='', footer='', comments='# ')\n",
    "np.savetxt('train_y.txt', train_y, fmt='%.18e', delimiter=' ', newline='\\n', header='', footer='', comments='# ')\n",
    "np.savetxt('train_y_class.txt', train_y_class, fmt='%.18e', delimiter=' ', newline='\\n', header='', footer='', comments='# ')\n",
    "# np.savetxt('train_y_diff.txt', train_y_diff, fmt='%.18e', delimiter=' ', newline='\\n', header='', footer='', comments='# ')\n",
    "np.savetxt('train_y_class1.txt', train_y_class1, fmt='%.18e', delimiter=' ', newline='\\n', header='', footer='', comments='# ')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "res.to_csv('res.txt', sep = ' ')\n",
    "input.to_csv('input.txt', sep=' ')\n",
    "output.to_csv('output.txt', sep=' ')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Direct read the modified dataframe from csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "res = pd.read_csv('res.txt',  delim_whitespace = 1, ) \n",
    "input = pd.read_csv('input.txt',  delim_whitespace = 1,) \n",
    "output = pd.read_csv('output.txt',  delim_whitespace = 1,) "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "input.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "input = pd.DataFrame(res[['day', 'district_id', 'gap', 'time_slot']])\n",
    "output = pd.DataFrame(res[['day', 'time_slot', 'gap', 'gap_slot']])\n",
    "\n",
    "input = input.ix[1:]\n",
    "output = output.ix[:(output.shape[0]-2)]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "input.drop('key', axis=1, inplace=True)\n",
    "output.drop('key', axis=1, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "output"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "train_y = output['gap'].as_matrix().astype(float)\n",
    "train_y_diff = train_y.copy()\n",
    "for i in range(train_y_diff.shape[0]-1):\n",
    "    train_y_diff[i] = train_y_diff[i+1] - train_y_diff[i]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "input = input.reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "output.loc[(output['gap']==0),'class'] = 0\n",
    "output.loc[(output['gap']==1),'class'] = 1\n",
    "output.loc[(output['gap']==2),'class'] = 2\n",
    "output.loc[(output['gap']==3),'class'] = 3\n",
    "output.loc[(output['gap']==4),'class'] = 4\n",
    "output.loc[(output['gap']>4),'class'] = 5"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0\n",
      "5000\n",
      "10000\n",
      "15000\n",
      "20000\n",
      "25000\n",
      "30000\n",
      "35000\n",
      "40000\n",
      "45000\n",
      "50000\n",
      "55000\n",
      "60000\n",
      "65000\n",
      "70000\n",
      "75000\n",
      "80000\n",
      "85000\n",
      "90000\n",
      "95000\n",
      "100000\n",
      "105000\n",
      "110000\n",
      "115000\n",
      "120000\n",
      "125000\n",
      "130000\n",
      "135000\n",
      "140000\n",
      "145000\n",
      "150000\n",
      "155000\n",
      "160000\n",
      "165000\n",
      "170000\n",
      "175000\n",
      "180000\n",
      "185000\n",
      "190000\n",
      "195000\n"
     ]
    }
   ],
   "source": [
    "for i in range(input.shape[0]-2):\n",
    "    if i%5000==0:\n",
    "        print(i)\n",
    "    input.loc[i+1, 'gap_past1'] = input.loc[i, 'gap']\n",
    "    input.loc[i+2, 'gap_past2'] = input.loc[i, 'gap']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "31821"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np.sum(train_y==1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>day</th>\n",
       "      <th>time_slot</th>\n",
       "      <th>gap</th>\n",
       "      <th>gap_slot</th>\n",
       "      <th>class</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>key</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1_1_1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_2</th>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_3</th>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_4</th>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_5</th>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_6</th>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_7</th>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_8</th>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_9</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_10</th>\n",
       "      <td>1.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_11</th>\n",
       "      <td>1.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_12</th>\n",
       "      <td>1.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_13</th>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_14</th>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_15</th>\n",
       "      <td>1.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_16</th>\n",
       "      <td>1.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_17</th>\n",
       "      <td>1.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_18</th>\n",
       "      <td>1.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_19</th>\n",
       "      <td>1.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_20</th>\n",
       "      <td>1.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_21</th>\n",
       "      <td>1.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_22</th>\n",
       "      <td>1.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_23</th>\n",
       "      <td>1.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_24</th>\n",
       "      <td>1.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_25</th>\n",
       "      <td>1.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_26</th>\n",
       "      <td>1.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_27</th>\n",
       "      <td>1.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_28</th>\n",
       "      <td>1.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_29</th>\n",
       "      <td>1.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_30</th>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5.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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_114</th>\n",
       "      <td>21.0</td>\n",
       "      <td>114.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_115</th>\n",
       "      <td>21.0</td>\n",
       "      <td>115.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_116</th>\n",
       "      <td>21.0</td>\n",
       "      <td>116.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_117</th>\n",
       "      <td>21.0</td>\n",
       "      <td>117.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_118</th>\n",
       "      <td>21.0</td>\n",
       "      <td>118.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_119</th>\n",
       "      <td>21.0</td>\n",
       "      <td>119.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_120</th>\n",
       "      <td>21.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_121</th>\n",
       "      <td>21.0</td>\n",
       "      <td>121.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_122</th>\n",
       "      <td>21.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_123</th>\n",
       "      <td>21.0</td>\n",
       "      <td>123.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_124</th>\n",
       "      <td>21.0</td>\n",
       "      <td>124.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_125</th>\n",
       "      <td>21.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_126</th>\n",
       "      <td>21.0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_127</th>\n",
       "      <td>21.0</td>\n",
       "      <td>127.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_128</th>\n",
       "      <td>21.0</td>\n",
       "      <td>128.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_129</th>\n",
       "      <td>21.0</td>\n",
       "      <td>129.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_130</th>\n",
       "      <td>21.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_131</th>\n",
       "      <td>21.0</td>\n",
       "      <td>131.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_132</th>\n",
       "      <td>21.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_133</th>\n",
       "      <td>21.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_134</th>\n",
       "      <td>21.0</td>\n",
       "      <td>134.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_135</th>\n",
       "      <td>21.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_136</th>\n",
       "      <td>21.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_137</th>\n",
       "      <td>21.0</td>\n",
       "      <td>137.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_138</th>\n",
       "      <td>21.0</td>\n",
       "      <td>138.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_139</th>\n",
       "      <td>21.0</td>\n",
       "      <td>139.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_140</th>\n",
       "      <td>21.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_141</th>\n",
       "      <td>21.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_142</th>\n",
       "      <td>21.0</td>\n",
       "      <td>142.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_143</th>\n",
       "      <td>21.0</td>\n",
       "      <td>143.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>199583 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           day  time_slot   gap  gap_slot  class\n",
       "key                                             \n",
       "1_1_1      1.0        1.0   7.0       1.0    5.0\n",
       "1_1_2      1.0        2.0  10.0       2.0    5.0\n",
       "1_1_3      1.0        3.0   5.0       1.0    5.0\n",
       "1_1_4      1.0        4.0   1.0       0.0    1.0\n",
       "1_1_5      1.0        5.0   1.0       0.0    1.0\n",
       "1_1_6      1.0        6.0   6.0       1.0    5.0\n",
       "1_1_7      1.0        7.0   2.0       0.0    2.0\n",
       "1_1_8      1.0        8.0   6.0       1.0    5.0\n",
       "1_1_9      1.0        9.0   6.0       1.0    5.0\n",
       "1_1_10     1.0       10.0   2.0       0.0    2.0\n",
       "1_1_11     1.0       11.0   3.0       0.0    3.0\n",
       "1_1_12     1.0       12.0   1.0       0.0    1.0\n",
       "1_1_13     1.0       13.0   4.0       0.0    4.0\n",
       "1_1_14     1.0       14.0   3.0       0.0    3.0\n",
       "1_1_15     1.0       15.0  11.0       2.0    5.0\n",
       "1_1_16     1.0       16.0  20.0       4.0    5.0\n",
       "1_1_17     1.0       17.0  18.0       3.0    5.0\n",
       "1_1_18     1.0       18.0  11.0       2.0    5.0\n",
       "1_1_19     1.0       19.0   6.0       1.0    5.0\n",
       "1_1_20     1.0       20.0   2.0       0.0    2.0\n",
       "1_1_21     1.0       21.0   1.0       0.0    1.0\n",
       "1_1_22     1.0       22.0   3.0       0.0    3.0\n",
       "1_1_23     1.0       23.0   8.0       1.0    5.0\n",
       "1_1_24     1.0       24.0   1.0       0.0    1.0\n",
       "1_1_25     1.0       25.0   1.0       0.0    1.0\n",
       "1_1_26     1.0       26.0   5.0       1.0    5.0\n",
       "1_1_27     1.0       27.0   0.0      -0.0    0.0\n",
       "1_1_28     1.0       28.0   4.0       0.0    4.0\n",
       "1_1_29     1.0       29.0  13.0       2.0    5.0\n",
       "1_1_30     1.0       30.0  28.0       5.0    5.0\n",
       "...        ...        ...   ...       ...    ...\n",
       "21_9_114  21.0      114.0   1.0       0.0    1.0\n",
       "21_9_115  21.0      115.0   1.0       0.0    1.0\n",
       "21_9_116  21.0      116.0   0.0      -0.0    0.0\n",
       "21_9_117  21.0      117.0   1.0       0.0    1.0\n",
       "21_9_118  21.0      118.0   2.0       0.0    2.0\n",
       "21_9_119  21.0      119.0   2.0       0.0    2.0\n",
       "21_9_120  21.0      120.0   1.0       0.0    1.0\n",
       "21_9_121  21.0      121.0   0.0      -0.0    0.0\n",
       "21_9_122  21.0      122.0   3.0       0.0    3.0\n",
       "21_9_123  21.0      123.0   3.0       0.0    3.0\n",
       "21_9_124  21.0      124.0   4.0       0.0    4.0\n",
       "21_9_125  21.0      125.0   5.0       1.0    5.0\n",
       "21_9_126  21.0      126.0   3.0       0.0    3.0\n",
       "21_9_127  21.0      127.0   1.0       0.0    1.0\n",
       "21_9_128  21.0      128.0   2.0       0.0    2.0\n",
       "21_9_129  21.0      129.0   6.0       1.0    5.0\n",
       "21_9_130  21.0      130.0   2.0       0.0    2.0\n",
       "21_9_131  21.0      131.0   1.0       0.0    1.0\n",
       "21_9_132  21.0      132.0   2.0       0.0    2.0\n",
       "21_9_133  21.0      133.0   2.0       0.0    2.0\n",
       "21_9_134  21.0      134.0   3.0       0.0    3.0\n",
       "21_9_135  21.0      135.0   3.0       0.0    3.0\n",
       "21_9_136  21.0      136.0   0.0      -0.0    0.0\n",
       "21_9_137  21.0      137.0   0.0      -0.0    0.0\n",
       "21_9_138  21.0      138.0   1.0       0.0    1.0\n",
       "21_9_139  21.0      139.0   2.0       0.0    2.0\n",
       "21_9_140  21.0      140.0   6.0       1.0    5.0\n",
       "21_9_141  21.0      141.0   1.0       0.0    1.0\n",
       "21_9_142  21.0      142.0   4.0       0.0    4.0\n",
       "21_9_143  21.0      143.0   0.0      -0.0    0.0\n",
       "\n",
       "[199583 rows x 5 columns]"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "output"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "input.loc[199582, 'gap_past1'] = 1.0\n",
    "input.loc[0, 'gap_past1'] = 0\n",
    "input.loc[0, 'gap_past2'] = 0\n",
    "input.loc[1, 'gap_past2'] = 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "input = input.drop('key', 1)\n",
    "input = input.drop('day', 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>gap</th>\n",
       "      <th>time_slot_0</th>\n",
       "      <th>time_slot_1</th>\n",
       "      <th>time_slot_2</th>\n",
       "      <th>time_slot_3</th>\n",
       "      <th>time_slot_4</th>\n",
       "      <th>time_slot_5</th>\n",
       "      <th>time_slot_6</th>\n",
       "      <th>time_slot_7</th>\n",
       "      <th>time_slot_8</th>\n",
       "      <th>...</th>\n",
       "      <th>district_id_64</th>\n",
       "      <th>district_id_65</th>\n",
       "      <th>fri</th>\n",
       "      <th>sat</th>\n",
       "      <th>sun</th>\n",
       "      <th>mon</th>\n",
       "      <th>tue</th>\n",
       "      <th>wed</th>\n",
       "      <th>gap_past1</th>\n",
       "      <th>gap_past2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>9.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>7.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>7.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5.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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>10.0</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\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>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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>5.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\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>1.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>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\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>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\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>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\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>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>20.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>11.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>20.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>11.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>18.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>11.0</td>\n",
       "      <td>18.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>6.0</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>8.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>13.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>4.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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199553</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199554</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199555</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199556</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199557</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199558</th>\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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199559</th>\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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199560</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199561</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199562</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199563</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199564</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199565</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199566</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>5.0</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199567</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199568</th>\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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199569</th>\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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199570</th>\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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199571</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>2.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199572</th>\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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199573</th>\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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199574</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199575</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199576</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199577</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.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>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199578</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199579</th>\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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199580</th>\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>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199581</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>6.0</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>199582</th>\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>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>199583 rows × 216 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         gap  time_slot_0  time_slot_1  time_slot_2  time_slot_3  time_slot_4  \\\n",
       "0        9.0          1.0          0.0          0.0          0.0          0.0   \n",
       "1        7.0          0.0          1.0          0.0          0.0          0.0   \n",
       "2       10.0          0.0          0.0          1.0          0.0          0.0   \n",
       "3        5.0          0.0          0.0          0.0          1.0          0.0   \n",
       "4        1.0          0.0          0.0          0.0          0.0          1.0   \n",
       "5        1.0          0.0          0.0          0.0          0.0          0.0   \n",
       "6        6.0          0.0          0.0          0.0          0.0          0.0   \n",
       "7        2.0          0.0          0.0          0.0          0.0          0.0   \n",
       "8        6.0          0.0          0.0          0.0          0.0          0.0   \n",
       "9        6.0          0.0          0.0          0.0          0.0          0.0   \n",
       "10       2.0          0.0          0.0          0.0          0.0          0.0   \n",
       "11       3.0          0.0          0.0          0.0          0.0          0.0   \n",
       "12       1.0          0.0          0.0          0.0          0.0          0.0   \n",
       "13       4.0          0.0          0.0          0.0          0.0          0.0   \n",
       "14       3.0          0.0          0.0          0.0          0.0          0.0   \n",
       "15      11.0          0.0          0.0          0.0          0.0          0.0   \n",
       "16      20.0          0.0          0.0          0.0          0.0          0.0   \n",
       "17      18.0          0.0          0.0          0.0          0.0          0.0   \n",
       "18      11.0          0.0          0.0          0.0          0.0          0.0   \n",
       "19       6.0          0.0          0.0          0.0          0.0          0.0   \n",
       "20       2.0          0.0          0.0          0.0          0.0          0.0   \n",
       "21       1.0          0.0          0.0          0.0          0.0          0.0   \n",
       "22       3.0          0.0          0.0          0.0          0.0          0.0   \n",
       "23       8.0          0.0          0.0          0.0          0.0          0.0   \n",
       "24       1.0          0.0          0.0          0.0          0.0          0.0   \n",
       "25       1.0          0.0          0.0          0.0          0.0          0.0   \n",
       "26       5.0          0.0          0.0          0.0          0.0          0.0   \n",
       "27       0.0          0.0          0.0          0.0          0.0          0.0   \n",
       "28       4.0          0.0          0.0          0.0          0.0          0.0   \n",
       "29      13.0          0.0          0.0          0.0          0.0          0.0   \n",
       "...      ...          ...          ...          ...          ...          ...   \n",
       "199553   3.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199554   1.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199555   1.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199556   0.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199557   1.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199558   2.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199559   2.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199560   1.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199561   0.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199562   3.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199563   3.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199564   4.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199565   5.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199566   3.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199567   1.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199568   2.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199569   6.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199570   2.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199571   1.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199572   2.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199573   2.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199574   3.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199575   3.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199576   0.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199577   0.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199578   1.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199579   2.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199580   6.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199581   1.0          0.0          0.0          0.0          0.0          0.0   \n",
       "199582   4.0          0.0          0.0          0.0          0.0          0.0   \n",
       "\n",
       "        time_slot_5  time_slot_6  time_slot_7  time_slot_8    ...      \\\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",
       "5               1.0          0.0          0.0          0.0    ...       \n",
       "6               0.0          1.0          0.0          0.0    ...       \n",
       "7               0.0          0.0          1.0          0.0    ...       \n",
       "8               0.0          0.0          0.0          1.0    ...       \n",
       "9               0.0          0.0          0.0          0.0    ...       \n",
       "10              0.0          0.0          0.0          0.0    ...       \n",
       "11              0.0          0.0          0.0          0.0    ...       \n",
       "12              0.0          0.0          0.0          0.0    ...       \n",
       "13              0.0          0.0          0.0          0.0    ...       \n",
       "14              0.0          0.0          0.0          0.0    ...       \n",
       "15              0.0          0.0          0.0          0.0    ...       \n",
       "16              0.0          0.0          0.0          0.0    ...       \n",
       "17              0.0          0.0          0.0          0.0    ...       \n",
       "18              0.0          0.0          0.0          0.0    ...       \n",
       "19              0.0          0.0          0.0          0.0    ...       \n",
       "20              0.0          0.0          0.0          0.0    ...       \n",
       "21              0.0          0.0          0.0          0.0    ...       \n",
       "22              0.0          0.0          0.0          0.0    ...       \n",
       "23              0.0          0.0          0.0          0.0    ...       \n",
       "24              0.0          0.0          0.0          0.0    ...       \n",
       "25              0.0          0.0          0.0          0.0    ...       \n",
       "26              0.0          0.0          0.0          0.0    ...       \n",
       "27              0.0          0.0          0.0          0.0    ...       \n",
       "28              0.0          0.0          0.0          0.0    ...       \n",
       "29              0.0          0.0          0.0          0.0    ...       \n",
       "...             ...          ...          ...          ...    ...       \n",
       "199553          0.0          0.0          0.0          0.0    ...       \n",
       "199554          0.0          0.0          0.0          0.0    ...       \n",
       "199555          0.0          0.0          0.0          0.0    ...       \n",
       "199556          0.0          0.0          0.0          0.0    ...       \n",
       "199557          0.0          0.0          0.0          0.0    ...       \n",
       "199558          0.0          0.0          0.0          0.0    ...       \n",
       "199559          0.0          0.0          0.0          0.0    ...       \n",
       "199560          0.0          0.0          0.0          0.0    ...       \n",
       "199561          0.0          0.0          0.0          0.0    ...       \n",
       "199562          0.0          0.0          0.0          0.0    ...       \n",
       "199563          0.0          0.0          0.0          0.0    ...       \n",
       "199564          0.0          0.0          0.0          0.0    ...       \n",
       "199565          0.0          0.0          0.0          0.0    ...       \n",
       "199566          0.0          0.0          0.0          0.0    ...       \n",
       "199567          0.0          0.0          0.0          0.0    ...       \n",
       "199568          0.0          0.0          0.0          0.0    ...       \n",
       "199569          0.0          0.0          0.0          0.0    ...       \n",
       "199570          0.0          0.0          0.0          0.0    ...       \n",
       "199571          0.0          0.0          0.0          0.0    ...       \n",
       "199572          0.0          0.0          0.0          0.0    ...       \n",
       "199573          0.0          0.0          0.0          0.0    ...       \n",
       "199574          0.0          0.0          0.0          0.0    ...       \n",
       "199575          0.0          0.0          0.0          0.0    ...       \n",
       "199576          0.0          0.0          0.0          0.0    ...       \n",
       "199577          0.0          0.0          0.0          0.0    ...       \n",
       "199578          0.0          0.0          0.0          0.0    ...       \n",
       "199579          0.0          0.0          0.0          0.0    ...       \n",
       "199580          0.0          0.0          0.0          0.0    ...       \n",
       "199581          0.0          0.0          0.0          0.0    ...       \n",
       "199582          0.0          0.0          0.0          0.0    ...       \n",
       "\n",
       "        district_id_64  district_id_65    fri    sat    sun    mon    tue  \\\n",
       "0                  0.0             0.0  False  False  False  False  False   \n",
       "1                  0.0             0.0  False  False  False  False  False   \n",
       "2                  0.0             0.0  False  False  False  False  False   \n",
       "3                  0.0             0.0  False  False  False  False  False   \n",
       "4                  0.0             0.0  False  False  False  False  False   \n",
       "5                  0.0             0.0  False  False  False  False  False   \n",
       "6                  0.0             0.0  False  False  False  False  False   \n",
       "7                  0.0             0.0  False  False  False  False  False   \n",
       "8                  0.0             0.0  False  False  False  False  False   \n",
       "9                  0.0             0.0  False  False  False  False  False   \n",
       "10                 0.0             0.0  False  False  False  False  False   \n",
       "11                 0.0             0.0  False  False  False  False  False   \n",
       "12                 0.0             0.0  False  False  False  False  False   \n",
       "13                 0.0             0.0  False  False  False  False  False   \n",
       "14                 0.0             0.0  False  False  False  False  False   \n",
       "15                 0.0             0.0  False  False  False  False  False   \n",
       "16                 0.0             0.0  False  False  False  False  False   \n",
       "17                 0.0             0.0  False  False  False  False  False   \n",
       "18                 0.0             0.0  False  False  False  False  False   \n",
       "19                 0.0             0.0  False  False  False  False  False   \n",
       "20                 0.0             0.0  False  False  False  False  False   \n",
       "21                 0.0             0.0  False  False  False  False  False   \n",
       "22                 0.0             0.0  False  False  False  False  False   \n",
       "23                 0.0             0.0  False  False  False  False  False   \n",
       "24                 0.0             0.0  False  False  False  False  False   \n",
       "25                 0.0             0.0  False  False  False  False  False   \n",
       "26                 0.0             0.0  False  False  False  False  False   \n",
       "27                 0.0             0.0  False  False  False  False  False   \n",
       "28                 0.0             0.0  False  False  False  False  False   \n",
       "29                 0.0             0.0  False  False  False  False  False   \n",
       "...                ...             ...    ...    ...    ...    ...    ...   \n",
       "199553             0.0             0.0  False  False   True  False  False   \n",
       "199554             0.0             0.0  False  False   True  False  False   \n",
       "199555             0.0             0.0  False  False   True  False  False   \n",
       "199556             0.0             0.0  False  False   True  False  False   \n",
       "199557             0.0             0.0  False  False   True  False  False   \n",
       "199558             0.0             0.0  False  False   True  False  False   \n",
       "199559             0.0             0.0  False  False   True  False  False   \n",
       "199560             0.0             0.0  False  False   True  False  False   \n",
       "199561             0.0             0.0  False  False   True  False  False   \n",
       "199562             0.0             0.0  False  False   True  False  False   \n",
       "199563             0.0             0.0  False  False   True  False  False   \n",
       "199564             0.0             0.0  False  False   True  False  False   \n",
       "199565             0.0             0.0  False  False   True  False  False   \n",
       "199566             0.0             0.0  False  False   True  False  False   \n",
       "199567             0.0             0.0  False  False   True  False  False   \n",
       "199568             0.0             0.0  False  False   True  False  False   \n",
       "199569             0.0             0.0  False  False   True  False  False   \n",
       "199570             0.0             0.0  False  False   True  False  False   \n",
       "199571             0.0             0.0  False  False   True  False  False   \n",
       "199572             0.0             0.0  False  False   True  False  False   \n",
       "199573             0.0             0.0  False  False   True  False  False   \n",
       "199574             0.0             0.0  False  False   True  False  False   \n",
       "199575             0.0             0.0  False  False   True  False  False   \n",
       "199576             0.0             0.0  False  False   True  False  False   \n",
       "199577             0.0             0.0  False  False   True  False  False   \n",
       "199578             0.0             0.0  False  False   True  False  False   \n",
       "199579             0.0             0.0  False  False   True  False  False   \n",
       "199580             0.0             0.0  False  False   True  False  False   \n",
       "199581             0.0             0.0  False  False   True  False  False   \n",
       "199582             0.0             0.0  False  False   True  False  False   \n",
       "\n",
       "          wed  gap_past1  gap_past2  \n",
       "0       False        0.0        0.0  \n",
       "1       False        9.0        0.0  \n",
       "2       False        7.0        9.0  \n",
       "3       False       10.0        7.0  \n",
       "4       False        5.0       10.0  \n",
       "5       False        1.0        5.0  \n",
       "6       False        1.0        1.0  \n",
       "7       False        6.0        1.0  \n",
       "8       False        2.0        6.0  \n",
       "9       False        6.0        2.0  \n",
       "10      False        6.0        6.0  \n",
       "11      False        2.0        6.0  \n",
       "12      False        3.0        2.0  \n",
       "13      False        1.0        3.0  \n",
       "14      False        4.0        1.0  \n",
       "15      False        3.0        4.0  \n",
       "16      False       11.0        3.0  \n",
       "17      False       20.0       11.0  \n",
       "18      False       18.0       20.0  \n",
       "19      False       11.0       18.0  \n",
       "20      False        6.0       11.0  \n",
       "21      False        2.0        6.0  \n",
       "22      False        1.0        2.0  \n",
       "23      False        3.0        1.0  \n",
       "24      False        8.0        3.0  \n",
       "25      False        1.0        8.0  \n",
       "26      False        1.0        1.0  \n",
       "27      False        5.0        1.0  \n",
       "28      False        0.0        5.0  \n",
       "29      False        4.0        0.0  \n",
       "...       ...        ...        ...  \n",
       "199553  False        3.0        1.0  \n",
       "199554  False        3.0        3.0  \n",
       "199555  False        1.0        3.0  \n",
       "199556  False        1.0        1.0  \n",
       "199557  False        0.0        1.0  \n",
       "199558  False        1.0        0.0  \n",
       "199559  False        2.0        1.0  \n",
       "199560  False        2.0        2.0  \n",
       "199561  False        1.0        2.0  \n",
       "199562  False        0.0        1.0  \n",
       "199563  False        3.0        0.0  \n",
       "199564  False        3.0        3.0  \n",
       "199565  False        4.0        3.0  \n",
       "199566  False        5.0        4.0  \n",
       "199567  False        3.0        5.0  \n",
       "199568  False        1.0        3.0  \n",
       "199569  False        2.0        1.0  \n",
       "199570  False        6.0        2.0  \n",
       "199571  False        2.0        6.0  \n",
       "199572  False        1.0        2.0  \n",
       "199573  False        2.0        1.0  \n",
       "199574  False        2.0        2.0  \n",
       "199575  False        3.0        2.0  \n",
       "199576  False        3.0        3.0  \n",
       "199577  False        0.0        3.0  \n",
       "199578  False        0.0        0.0  \n",
       "199579  False        1.0        0.0  \n",
       "199580  False        2.0        1.0  \n",
       "199581  False        6.0        2.0  \n",
       "199582  False        1.0        6.0  \n",
       "\n",
       "[199583 rows x 216 columns]"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "input"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "list(input.columns.values)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "input"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>day</th>\n",
       "      <th>time_slot</th>\n",
       "      <th>gap</th>\n",
       "      <th>gap_slot</th>\n",
       "      <th>L1</th>\n",
       "      <th>L2</th>\n",
       "      <th>L3</th>\n",
       "      <th>L4</th>\n",
       "      <th>class</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>key</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1_1_1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1399</td>\n",
       "      <td>318</td>\n",
       "      <td>102</td>\n",
       "      <td>94</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_2</th>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1491</td>\n",
       "      <td>322</td>\n",
       "      <td>99</td>\n",
       "      <td>64</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_3</th>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1490</td>\n",
       "      <td>287</td>\n",
       "      <td>98</td>\n",
       "      <td>78</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_4</th>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1425</td>\n",
       "      <td>302</td>\n",
       "      <td>95</td>\n",
       "      <td>51</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_5</th>\n",
       "      <td>1.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1327</td>\n",
       "      <td>313</td>\n",
       "      <td>94</td>\n",
       "      <td>66</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_6</th>\n",
       "      <td>1.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1361</td>\n",
       "      <td>258</td>\n",
       "      <td>68</td>\n",
       "      <td>55</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_7</th>\n",
       "      <td>1.0</td>\n",
       "      <td>7.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1395</td>\n",
       "      <td>280</td>\n",
       "      <td>97</td>\n",
       "      <td>69</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_8</th>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1348</td>\n",
       "      <td>272</td>\n",
       "      <td>93</td>\n",
       "      <td>97</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_9</th>\n",
       "      <td>1.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1417</td>\n",
       "      <td>236</td>\n",
       "      <td>93</td>\n",
       "      <td>53</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_10</th>\n",
       "      <td>1.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1316</td>\n",
       "      <td>241</td>\n",
       "      <td>82</td>\n",
       "      <td>64</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_11</th>\n",
       "      <td>1.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1393</td>\n",
       "      <td>254</td>\n",
       "      <td>65</td>\n",
       "      <td>65</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_12</th>\n",
       "      <td>1.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1339</td>\n",
       "      <td>241</td>\n",
       "      <td>87</td>\n",
       "      <td>69</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_13</th>\n",
       "      <td>1.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1390</td>\n",
       "      <td>198</td>\n",
       "      <td>69</td>\n",
       "      <td>47</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_14</th>\n",
       "      <td>1.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1303</td>\n",
       "      <td>199</td>\n",
       "      <td>65</td>\n",
       "      <td>51</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_15</th>\n",
       "      <td>1.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1296</td>\n",
       "      <td>190</td>\n",
       "      <td>60</td>\n",
       "      <td>60</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_16</th>\n",
       "      <td>1.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1259</td>\n",
       "      <td>131</td>\n",
       "      <td>50</td>\n",
       "      <td>50</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_17</th>\n",
       "      <td>1.0</td>\n",
       "      <td>17.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1277</td>\n",
       "      <td>161</td>\n",
       "      <td>47</td>\n",
       "      <td>52</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_18</th>\n",
       "      <td>1.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1211</td>\n",
       "      <td>143</td>\n",
       "      <td>54</td>\n",
       "      <td>51</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_19</th>\n",
       "      <td>1.0</td>\n",
       "      <td>19.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1160</td>\n",
       "      <td>163</td>\n",
       "      <td>39</td>\n",
       "      <td>51</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_20</th>\n",
       "      <td>1.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1165</td>\n",
       "      <td>153</td>\n",
       "      <td>48</td>\n",
       "      <td>51</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_21</th>\n",
       "      <td>1.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1115</td>\n",
       "      <td>140</td>\n",
       "      <td>49</td>\n",
       "      <td>47</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_22</th>\n",
       "      <td>1.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1118</td>\n",
       "      <td>126</td>\n",
       "      <td>52</td>\n",
       "      <td>46</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_23</th>\n",
       "      <td>1.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1061</td>\n",
       "      <td>141</td>\n",
       "      <td>34</td>\n",
       "      <td>38</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_24</th>\n",
       "      <td>1.0</td>\n",
       "      <td>24.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1026</td>\n",
       "      <td>129</td>\n",
       "      <td>47</td>\n",
       "      <td>57</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_25</th>\n",
       "      <td>1.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1120</td>\n",
       "      <td>129</td>\n",
       "      <td>44</td>\n",
       "      <td>48</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_26</th>\n",
       "      <td>1.0</td>\n",
       "      <td>26.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>982</td>\n",
       "      <td>145</td>\n",
       "      <td>45</td>\n",
       "      <td>40</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_27</th>\n",
       "      <td>1.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>918</td>\n",
       "      <td>116</td>\n",
       "      <td>52</td>\n",
       "      <td>43</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_28</th>\n",
       "      <td>1.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>978</td>\n",
       "      <td>139</td>\n",
       "      <td>54</td>\n",
       "      <td>43</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_29</th>\n",
       "      <td>1.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>13.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1029</td>\n",
       "      <td>126</td>\n",
       "      <td>42</td>\n",
       "      <td>49</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1_1_30</th>\n",
       "      <td>1.0</td>\n",
       "      <td>30.0</td>\n",
       "      <td>28.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1018</td>\n",
       "      <td>117</td>\n",
       "      <td>43</td>\n",
       "      <td>58</td>\n",
       "      <td>5.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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_114</th>\n",
       "      <td>21.0</td>\n",
       "      <td>114.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>685</td>\n",
       "      <td>153</td>\n",
       "      <td>30</td>\n",
       "      <td>34</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_115</th>\n",
       "      <td>21.0</td>\n",
       "      <td>115.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>633</td>\n",
       "      <td>153</td>\n",
       "      <td>49</td>\n",
       "      <td>27</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_116</th>\n",
       "      <td>21.0</td>\n",
       "      <td>116.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>635</td>\n",
       "      <td>192</td>\n",
       "      <td>54</td>\n",
       "      <td>39</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_117</th>\n",
       "      <td>21.0</td>\n",
       "      <td>117.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>654</td>\n",
       "      <td>155</td>\n",
       "      <td>62</td>\n",
       "      <td>26</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_118</th>\n",
       "      <td>21.0</td>\n",
       "      <td>118.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>739</td>\n",
       "      <td>133</td>\n",
       "      <td>53</td>\n",
       "      <td>27</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_119</th>\n",
       "      <td>21.0</td>\n",
       "      <td>119.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>679</td>\n",
       "      <td>143</td>\n",
       "      <td>50</td>\n",
       "      <td>29</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_120</th>\n",
       "      <td>21.0</td>\n",
       "      <td>120.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>650</td>\n",
       "      <td>132</td>\n",
       "      <td>45</td>\n",
       "      <td>29</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_121</th>\n",
       "      <td>21.0</td>\n",
       "      <td>121.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>600</td>\n",
       "      <td>160</td>\n",
       "      <td>36</td>\n",
       "      <td>40</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_122</th>\n",
       "      <td>21.0</td>\n",
       "      <td>122.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>619</td>\n",
       "      <td>140</td>\n",
       "      <td>49</td>\n",
       "      <td>18</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_123</th>\n",
       "      <td>21.0</td>\n",
       "      <td>123.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>658</td>\n",
       "      <td>135</td>\n",
       "      <td>46</td>\n",
       "      <td>38</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_124</th>\n",
       "      <td>21.0</td>\n",
       "      <td>124.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>667</td>\n",
       "      <td>147</td>\n",
       "      <td>43</td>\n",
       "      <td>17</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_125</th>\n",
       "      <td>21.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>656</td>\n",
       "      <td>97</td>\n",
       "      <td>41</td>\n",
       "      <td>27</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_126</th>\n",
       "      <td>21.0</td>\n",
       "      <td>126.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>618</td>\n",
       "      <td>140</td>\n",
       "      <td>48</td>\n",
       "      <td>22</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_127</th>\n",
       "      <td>21.0</td>\n",
       "      <td>127.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>625</td>\n",
       "      <td>118</td>\n",
       "      <td>45</td>\n",
       "      <td>42</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_128</th>\n",
       "      <td>21.0</td>\n",
       "      <td>128.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>677</td>\n",
       "      <td>110</td>\n",
       "      <td>27</td>\n",
       "      <td>24</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_129</th>\n",
       "      <td>21.0</td>\n",
       "      <td>129.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>601</td>\n",
       "      <td>114</td>\n",
       "      <td>39</td>\n",
       "      <td>19</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_130</th>\n",
       "      <td>21.0</td>\n",
       "      <td>130.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>624</td>\n",
       "      <td>128</td>\n",
       "      <td>46</td>\n",
       "      <td>26</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_131</th>\n",
       "      <td>21.0</td>\n",
       "      <td>131.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>630</td>\n",
       "      <td>102</td>\n",
       "      <td>20</td>\n",
       "      <td>39</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_132</th>\n",
       "      <td>21.0</td>\n",
       "      <td>132.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>649</td>\n",
       "      <td>143</td>\n",
       "      <td>37</td>\n",
       "      <td>24</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_133</th>\n",
       "      <td>21.0</td>\n",
       "      <td>133.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>629</td>\n",
       "      <td>97</td>\n",
       "      <td>33</td>\n",
       "      <td>35</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_134</th>\n",
       "      <td>21.0</td>\n",
       "      <td>134.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>607</td>\n",
       "      <td>108</td>\n",
       "      <td>43</td>\n",
       "      <td>25</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_135</th>\n",
       "      <td>21.0</td>\n",
       "      <td>135.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>586</td>\n",
       "      <td>101</td>\n",
       "      <td>24</td>\n",
       "      <td>17</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_136</th>\n",
       "      <td>21.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>622</td>\n",
       "      <td>113</td>\n",
       "      <td>33</td>\n",
       "      <td>41</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_137</th>\n",
       "      <td>21.0</td>\n",
       "      <td>137.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>613</td>\n",
       "      <td>107</td>\n",
       "      <td>29</td>\n",
       "      <td>25</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_138</th>\n",
       "      <td>21.0</td>\n",
       "      <td>138.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>593</td>\n",
       "      <td>90</td>\n",
       "      <td>31</td>\n",
       "      <td>24</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_139</th>\n",
       "      <td>21.0</td>\n",
       "      <td>139.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>541</td>\n",
       "      <td>84</td>\n",
       "      <td>36</td>\n",
       "      <td>18</td>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_140</th>\n",
       "      <td>21.0</td>\n",
       "      <td>140.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>496</td>\n",
       "      <td>85</td>\n",
       "      <td>35</td>\n",
       "      <td>19</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_141</th>\n",
       "      <td>21.0</td>\n",
       "      <td>141.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>547</td>\n",
       "      <td>104</td>\n",
       "      <td>23</td>\n",
       "      <td>10</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_142</th>\n",
       "      <td>21.0</td>\n",
       "      <td>142.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>592</td>\n",
       "      <td>64</td>\n",
       "      <td>31</td>\n",
       "      <td>15</td>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21_9_143</th>\n",
       "      <td>21.0</td>\n",
       "      <td>143.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>-0.0</td>\n",
       "      <td>542</td>\n",
       "      <td>83</td>\n",
       "      <td>23</td>\n",
       "      <td>18</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>199583 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           day  time_slot   gap  gap_slot    L1   L2   L3  L4  class\n",
       "key                                                                 \n",
       "1_1_1      1.0        1.0   7.0       1.0  1399  318  102  94    5.0\n",
       "1_1_2      1.0        2.0  10.0       2.0  1491  322   99  64    5.0\n",
       "1_1_3      1.0        3.0   5.0       1.0  1490  287   98  78    5.0\n",
       "1_1_4      1.0        4.0   1.0       0.0  1425  302   95  51    1.0\n",
       "1_1_5      1.0        5.0   1.0       0.0  1327  313   94  66    1.0\n",
       "1_1_6      1.0        6.0   6.0       1.0  1361  258   68  55    5.0\n",
       "1_1_7      1.0        7.0   2.0       0.0  1395  280   97  69    2.0\n",
       "1_1_8      1.0        8.0   6.0       1.0  1348  272   93  97    5.0\n",
       "1_1_9      1.0        9.0   6.0       1.0  1417  236   93  53    5.0\n",
       "1_1_10     1.0       10.0   2.0       0.0  1316  241   82  64    2.0\n",
       "1_1_11     1.0       11.0   3.0       0.0  1393  254   65  65    3.0\n",
       "1_1_12     1.0       12.0   1.0       0.0  1339  241   87  69    1.0\n",
       "1_1_13     1.0       13.0   4.0       0.0  1390  198   69  47    4.0\n",
       "1_1_14     1.0       14.0   3.0       0.0  1303  199   65  51    3.0\n",
       "1_1_15     1.0       15.0  11.0       2.0  1296  190   60  60    5.0\n",
       "1_1_16     1.0       16.0  20.0       4.0  1259  131   50  50    5.0\n",
       "1_1_17     1.0       17.0  18.0       3.0  1277  161   47  52    5.0\n",
       "1_1_18     1.0       18.0  11.0       2.0  1211  143   54  51    5.0\n",
       "1_1_19     1.0       19.0   6.0       1.0  1160  163   39  51    5.0\n",
       "1_1_20     1.0       20.0   2.0       0.0  1165  153   48  51    2.0\n",
       "1_1_21     1.0       21.0   1.0       0.0  1115  140   49  47    1.0\n",
       "1_1_22     1.0       22.0   3.0       0.0  1118  126   52  46    3.0\n",
       "1_1_23     1.0       23.0   8.0       1.0  1061  141   34  38    5.0\n",
       "1_1_24     1.0       24.0   1.0       0.0  1026  129   47  57    1.0\n",
       "1_1_25     1.0       25.0   1.0       0.0  1120  129   44  48    1.0\n",
       "1_1_26     1.0       26.0   5.0       1.0   982  145   45  40    5.0\n",
       "1_1_27     1.0       27.0   0.0      -0.0   918  116   52  43    0.0\n",
       "1_1_28     1.0       28.0   4.0       0.0   978  139   54  43    4.0\n",
       "1_1_29     1.0       29.0  13.0       2.0  1029  126   42  49    5.0\n",
       "1_1_30     1.0       30.0  28.0       5.0  1018  117   43  58    5.0\n",
       "...        ...        ...   ...       ...   ...  ...  ...  ..    ...\n",
       "21_9_114  21.0      114.0   1.0       0.0   685  153   30  34    1.0\n",
       "21_9_115  21.0      115.0   1.0       0.0   633  153   49  27    1.0\n",
       "21_9_116  21.0      116.0   0.0      -0.0   635  192   54  39    0.0\n",
       "21_9_117  21.0      117.0   1.0       0.0   654  155   62  26    1.0\n",
       "21_9_118  21.0      118.0   2.0       0.0   739  133   53  27    2.0\n",
       "21_9_119  21.0      119.0   2.0       0.0   679  143   50  29    2.0\n",
       "21_9_120  21.0      120.0   1.0       0.0   650  132   45  29    1.0\n",
       "21_9_121  21.0      121.0   0.0      -0.0   600  160   36  40    0.0\n",
       "21_9_122  21.0      122.0   3.0       0.0   619  140   49  18    3.0\n",
       "21_9_123  21.0      123.0   3.0       0.0   658  135   46  38    3.0\n",
       "21_9_124  21.0      124.0   4.0       0.0   667  147   43  17    4.0\n",
       "21_9_125  21.0      125.0   5.0       1.0   656   97   41  27    5.0\n",
       "21_9_126  21.0      126.0   3.0       0.0   618  140   48  22    3.0\n",
       "21_9_127  21.0      127.0   1.0       0.0   625  118   45  42    1.0\n",
       "21_9_128  21.0      128.0   2.0       0.0   677  110   27  24    2.0\n",
       "21_9_129  21.0      129.0   6.0       1.0   601  114   39  19    5.0\n",
       "21_9_130  21.0      130.0   2.0       0.0   624  128   46  26    2.0\n",
       "21_9_131  21.0      131.0   1.0       0.0   630  102   20  39    1.0\n",
       "21_9_132  21.0      132.0   2.0       0.0   649  143   37  24    2.0\n",
       "21_9_133  21.0      133.0   2.0       0.0   629   97   33  35    2.0\n",
       "21_9_134  21.0      134.0   3.0       0.0   607  108   43  25    3.0\n",
       "21_9_135  21.0      135.0   3.0       0.0   586  101   24  17    3.0\n",
       "21_9_136  21.0      136.0   0.0      -0.0   622  113   33  41    0.0\n",
       "21_9_137  21.0      137.0   0.0      -0.0   613  107   29  25    0.0\n",
       "21_9_138  21.0      138.0   1.0       0.0   593   90   31  24    1.0\n",
       "21_9_139  21.0      139.0   2.0       0.0   541   84   36  18    2.0\n",
       "21_9_140  21.0      140.0   6.0       1.0   496   85   35  19    5.0\n",
       "21_9_141  21.0      141.0   1.0       0.0   547  104   23  10    1.0\n",
       "21_9_142  21.0      142.0   4.0       0.0   592   64   31  15    4.0\n",
       "21_9_143  21.0      143.0   0.0      -0.0   542   83   23  18    0.0\n",
       "\n",
       "[199583 rows x 9 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "output"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.1"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}