analysis/heroes_winratio/OpenDota_Picks_JSON_to_CSV_winratio.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "OpenDota_Picks_JSON_to_CSV",
      "version": "0.3.2",
      "provenance": [],
      "collapsed_sections": [],
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/marcolussetti/opendotadump-tools/blob/master/analysis%5Cwinratio%5COpenDota_Picks_JSON_to_CSV_winratio.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "metadata": {
        "id": "BQZG-9IMlrXZ",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "import datetime\n",
        "import requests\n",
        "import pandas as pd\n",
        "import numpy as np"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "5oS_fGEkgn0a",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "arguments = {}\n",
        "arguments[\"JSON_INPUT_FILE\"] = \"winratio_output.json\"\n",
        "arguments[\"--remove-low-counts\"] = True\n",
        "arguments[\"--heroes\"] = \"names\"\n",
        "arguments[\"--remove-low-counts\"] = True"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "pzh_MLes88pC",
        "colab_type": "code",
        "outputId": "5369a008-926c-4585-ff33-2cbef990df46",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 53
        }
      },
      "cell_type": "code",
      "source": [
        "print(\"Starting OpenDotaDumpTools...\")\n",
        "\n",
        "df = pd.read_json(arguments[\"JSON_INPUT_FILE\"])\n",
        "print(\"JSON input loaded\")"
      ],
      "execution_count": 67,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Starting OpenDotaDumpTools...\n",
            "JSON input loaded\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "WMXK9s6Pg5VH",
        "colab_type": "code",
        "outputId": "25cd7132-af42-4f1f-9d1e-4ff1b59cc9e9",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 236
        }
      },
      "cell_type": "code",
      "source": [
        "df.head()"
      ],
      "execution_count": 68,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>16911</th>\n",
              "      <th>16910</th>\n",
              "      <th>16909</th>\n",
              "      <th>16908</th>\n",
              "      <th>16907</th>\n",
              "      <th>16906</th>\n",
              "      <th>16905</th>\n",
              "      <th>16904</th>\n",
              "      <th>16903</th>\n",
              "      <th>16902</th>\n",
              "      <th>...</th>\n",
              "      <th>15243</th>\n",
              "      <th>15239</th>\n",
              "      <th>15179</th>\n",
              "      <th>15172</th>\n",
              "      <th>15164</th>\n",
              "      <th>15162</th>\n",
              "      <th>15159</th>\n",
              "      <th>15158</th>\n",
              "      <th>15157</th>\n",
              "      <th>0</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>[64, 122]</td>\n",
              "      <td>[17, 12]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[5, 8]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>[2196, 2816]</td>\n",
              "      <td>[527, 606]</td>\n",
              "      <td>[2, 3]</td>\n",
              "      <td>[0, 5]</td>\n",
              "      <td>[0, 2]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[2, 0]</td>\n",
              "      <td>[0, 2]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>[1, 0]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[124, 128]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>[753, 940]</td>\n",
              "      <td>[231, 199]</td>\n",
              "      <td>[0, 2]</td>\n",
              "      <td>[1, 0]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[0, 1]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[29, 40]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>100</th>\n",
              "      <td>[937, 1254]</td>\n",
              "      <td>[226, 296]</td>\n",
              "      <td>[3, 0]</td>\n",
              "      <td>[2, 0]</td>\n",
              "      <td>[1, 0]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[149, 156]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>101</th>\n",
              "      <td>[885, 989]</td>\n",
              "      <td>[228, 223]</td>\n",
              "      <td>[0, 3]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[2, 0]</td>\n",
              "      <td>[1, 0]</td>\n",
              "      <td>[1, 0]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[53, 54]</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 1645 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "            16911       16910   16909   16908   16907   16906   16905   16904  \\\n",
              "0       [64, 122]    [17, 12]     NaN     NaN     NaN     NaN     NaN     NaN   \n",
              "1    [2196, 2816]  [527, 606]  [2, 3]  [0, 5]  [0, 2]     NaN  [2, 0]  [0, 2]   \n",
              "10     [753, 940]  [231, 199]  [0, 2]  [1, 0]     NaN  [0, 1]     NaN     NaN   \n",
              "100   [937, 1254]  [226, 296]  [3, 0]  [2, 0]  [1, 0]     NaN     NaN     NaN   \n",
              "101    [885, 989]  [228, 223]  [0, 3]     NaN  [2, 0]  [1, 0]  [1, 0]     NaN   \n",
              "\n",
              "    16903 16902  ...   15243 15239 15179 15172 15164 15162 15159 15158 15157  \\\n",
              "0     NaN   NaN  ...     NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   \n",
              "1     NaN   NaN  ...  [1, 0]   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   \n",
              "10    NaN   NaN  ...     NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   \n",
              "100   NaN   NaN  ...     NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   \n",
              "101   NaN   NaN  ...     NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   NaN   \n",
              "\n",
              "          0      \n",
              "0        [5, 8]  \n",
              "1    [124, 128]  \n",
              "10     [29, 40]  \n",
              "100  [149, 156]  \n",
              "101    [53, 54]  \n",
              "\n",
              "[5 rows x 1645 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 68
        }
      ]
    },
    {
      "metadata": {
        "id": "YQirnV7_h5ip",
        "colab_type": "code",
        "outputId": "bfe7d654-dcca-49f5-a9e0-a2144dad9bd1",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        }
      },
      "cell_type": "code",
      "source": [
        "# Clean up data\n",
        "df = df.transpose()  # Rotate so rows = time\n",
        "df = df.drop(0, 0)  # Remove entries with missing date (1970)\n",
        "df = df.drop(0, 1)  # Remove entries with a missing hero (0)\n",
        "df.index = [datetime.datetime(1970, 1, 1, 0, 0) + datetime.timedelta(index - 1)\n",
        "            for index in df.index]  # Convert index (epoch days) to time\n",
        "df = df.reindex(sorted(df.columns), axis=1)  # Order columns by hero #, ascending\n",
        "df = df.sort_index(axis=0)  # Order rows by date, ascending\n",
        "print(\"Input cleaned\")"
      ],
      "execution_count": 69,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Input cleaned\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "BUY8XbsWiF_3",
        "colab_type": "code",
        "outputId": "24507cd3-2bb3-419d-fa84-2a7e028c4812",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 236
        }
      },
      "cell_type": "code",
      "source": [
        "df.head()"
      ],
      "execution_count": 70,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>1</th>\n",
              "      <th>2</th>\n",
              "      <th>3</th>\n",
              "      <th>4</th>\n",
              "      <th>5</th>\n",
              "      <th>6</th>\n",
              "      <th>7</th>\n",
              "      <th>8</th>\n",
              "      <th>9</th>\n",
              "      <th>10</th>\n",
              "      <th>...</th>\n",
              "      <th>103</th>\n",
              "      <th>104</th>\n",
              "      <th>105</th>\n",
              "      <th>106</th>\n",
              "      <th>107</th>\n",
              "      <th>109</th>\n",
              "      <th>110</th>\n",
              "      <th>111</th>\n",
              "      <th>112</th>\n",
              "      <th>113</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2011-07-01</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[0, 1]</td>\n",
              "      <td>[1, 0]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-07-02</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[1, 0]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[1, 0]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-07-03</th>\n",
              "      <td>NaN</td>\n",
              "      <td>[0, 1]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-07-06</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-07-08</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[1, 0]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 111 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "            1       2    3    4       5       6       7    8    9    10   ...  \\\n",
              "2011-07-01  NaN     NaN  NaN  NaN     NaN  [0, 1]  [1, 0]  NaN  NaN  NaN  ...   \n",
              "2011-07-02  NaN     NaN  NaN  NaN  [1, 0]     NaN  [1, 0]  NaN  NaN  NaN  ...   \n",
              "2011-07-03  NaN  [0, 1]  NaN  NaN     NaN     NaN     NaN  NaN  NaN  NaN  ...   \n",
              "2011-07-06  NaN     NaN  NaN  NaN     NaN     NaN     NaN  NaN  NaN  NaN  ...   \n",
              "2011-07-08  NaN     NaN  NaN  NaN     NaN     NaN  [1, 0]  NaN  NaN  NaN  ...   \n",
              "\n",
              "            103  104  105  106  107  109  110  111  112  113  \n",
              "2011-07-01  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
              "2011-07-02  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
              "2011-07-03  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
              "2011-07-06  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
              "2011-07-08  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
              "\n",
              "[5 rows x 111 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 70
        }
      ]
    },
    {
      "metadata": {
        "id": "lEP7O9qIi4so",
        "colab_type": "code",
        "outputId": "96ab1d7c-7069-4cb7-c08b-c05eee0d65c5",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        }
      },
      "cell_type": "code",
      "source": [
        "if arguments[\"--remove-low-counts\"]:\n",
        "    df = df.loc[df.index > '2011-11-22 00:00:00']\n",
        "    print(\"Data for days previous to 2011-11-23 removed\")"
      ],
      "execution_count": 71,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Data for days previous to 2011-11-23 removed\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "1E97Y6nhi-vO",
        "colab_type": "code",
        "outputId": "2c1f297e-aa23-447a-c02e-0f626a43b770",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 236
        }
      },
      "cell_type": "code",
      "source": [
        "df.head()"
      ],
      "execution_count": 72,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>1</th>\n",
              "      <th>2</th>\n",
              "      <th>3</th>\n",
              "      <th>4</th>\n",
              "      <th>5</th>\n",
              "      <th>6</th>\n",
              "      <th>7</th>\n",
              "      <th>8</th>\n",
              "      <th>9</th>\n",
              "      <th>10</th>\n",
              "      <th>...</th>\n",
              "      <th>103</th>\n",
              "      <th>104</th>\n",
              "      <th>105</th>\n",
              "      <th>106</th>\n",
              "      <th>107</th>\n",
              "      <th>109</th>\n",
              "      <th>110</th>\n",
              "      <th>111</th>\n",
              "      <th>112</th>\n",
              "      <th>113</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2011-11-23</th>\n",
              "      <td>[10, 11]</td>\n",
              "      <td>[5, 10]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[6, 8]</td>\n",
              "      <td>[6, 6]</td>\n",
              "      <td>[7, 10]</td>\n",
              "      <td>[9, 12]</td>\n",
              "      <td>[9, 0]</td>\n",
              "      <td>[17, 10]</td>\n",
              "      <td>[4, 5]</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-11-24</th>\n",
              "      <td>[12, 12]</td>\n",
              "      <td>[1, 9]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[3, 2]</td>\n",
              "      <td>[7, 10]</td>\n",
              "      <td>[5, 10]</td>\n",
              "      <td>[8, 13]</td>\n",
              "      <td>[3, 6]</td>\n",
              "      <td>[10, 10]</td>\n",
              "      <td>[2, 7]</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-11-25</th>\n",
              "      <td>[18, 23]</td>\n",
              "      <td>[5, 12]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[3, 9]</td>\n",
              "      <td>[11, 11]</td>\n",
              "      <td>[14, 12]</td>\n",
              "      <td>[10, 11]</td>\n",
              "      <td>[9, 4]</td>\n",
              "      <td>[15, 15]</td>\n",
              "      <td>[9, 7]</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-11-26</th>\n",
              "      <td>[12, 11]</td>\n",
              "      <td>[2, 8]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[3, 8]</td>\n",
              "      <td>[6, 3]</td>\n",
              "      <td>[12, 14]</td>\n",
              "      <td>[11, 4]</td>\n",
              "      <td>[9, 5]</td>\n",
              "      <td>[12, 10]</td>\n",
              "      <td>[6, 5]</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-11-27</th>\n",
              "      <td>[28, 17]</td>\n",
              "      <td>[8, 14]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[12, 13]</td>\n",
              "      <td>[9, 10]</td>\n",
              "      <td>[12, 9]</td>\n",
              "      <td>[14, 11]</td>\n",
              "      <td>[12, 6]</td>\n",
              "      <td>[7, 15]</td>\n",
              "      <td>[7, 5]</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 111 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                 1        2    3         4         5         6         7    \\\n",
              "2011-11-23  [10, 11]  [5, 10]  NaN    [6, 8]    [6, 6]   [7, 10]   [9, 12]   \n",
              "2011-11-24  [12, 12]   [1, 9]  NaN    [3, 2]   [7, 10]   [5, 10]   [8, 13]   \n",
              "2011-11-25  [18, 23]  [5, 12]  NaN    [3, 9]  [11, 11]  [14, 12]  [10, 11]   \n",
              "2011-11-26  [12, 11]   [2, 8]  NaN    [3, 8]    [6, 3]  [12, 14]   [11, 4]   \n",
              "2011-11-27  [28, 17]  [8, 14]  NaN  [12, 13]   [9, 10]   [12, 9]  [14, 11]   \n",
              "\n",
              "                8         9       10   ...  103  104  105  106  107  109  110  \\\n",
              "2011-11-23   [9, 0]  [17, 10]  [4, 5]  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN   \n",
              "2011-11-24   [3, 6]  [10, 10]  [2, 7]  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN   \n",
              "2011-11-25   [9, 4]  [15, 15]  [9, 7]  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN   \n",
              "2011-11-26   [9, 5]  [12, 10]  [6, 5]  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN   \n",
              "2011-11-27  [12, 6]   [7, 15]  [7, 5]  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN   \n",
              "\n",
              "            111  112  113  \n",
              "2011-11-23  NaN  NaN  NaN  \n",
              "2011-11-24  NaN  NaN  NaN  \n",
              "2011-11-25  NaN  NaN  NaN  \n",
              "2011-11-26  NaN  NaN  NaN  \n",
              "2011-11-27  NaN  NaN  NaN  \n",
              "\n",
              "[5 rows x 111 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 72
        }
      ]
    },
    {
      "metadata": {
        "id": "QXDBGKA08-ro",
        "colab_type": "code",
        "outputId": "b2c3946e-711d-418e-c8e9-7e4358d9c727",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        }
      },
      "cell_type": "code",
      "source": [
        "if arguments[\"--heroes\"] == \"names\":\n",
        "  # Fetch heroes from OpenDota API\n",
        "  heroes_json = requests.get(\"http://api.opendota.com/api/heroes/\").json()\n",
        "  heroes = {hero[\"id\"]: hero for hero in heroes_json}\n",
        "  df.columns = [heroes[column][\"localized_name\"] for column in df.columns]\n",
        "  print(\"Heroes ids replaced with heroes names\")"
      ],
      "execution_count": 73,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Heroes ids replaced with heroes names\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "PrzjuI2whkdN",
        "colab_type": "code",
        "outputId": "36ad4137-4eb6-429d-e1a8-dfa6a5c7826d",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 360
        }
      },
      "cell_type": "code",
      "source": [
        "df.head()"
      ],
      "execution_count": 74,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Anti-Mage</th>\n",
              "      <th>Axe</th>\n",
              "      <th>Bane</th>\n",
              "      <th>Bloodseeker</th>\n",
              "      <th>Crystal Maiden</th>\n",
              "      <th>Drow Ranger</th>\n",
              "      <th>Earthshaker</th>\n",
              "      <th>Juggernaut</th>\n",
              "      <th>Mirana</th>\n",
              "      <th>Morphling</th>\n",
              "      <th>...</th>\n",
              "      <th>Elder Titan</th>\n",
              "      <th>Legion Commander</th>\n",
              "      <th>Techies</th>\n",
              "      <th>Ember Spirit</th>\n",
              "      <th>Earth Spirit</th>\n",
              "      <th>Terrorblade</th>\n",
              "      <th>Phoenix</th>\n",
              "      <th>Oracle</th>\n",
              "      <th>Winter Wyvern</th>\n",
              "      <th>Arc Warden</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2011-11-23</th>\n",
              "      <td>[10, 11]</td>\n",
              "      <td>[5, 10]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[6, 8]</td>\n",
              "      <td>[6, 6]</td>\n",
              "      <td>[7, 10]</td>\n",
              "      <td>[9, 12]</td>\n",
              "      <td>[9, 0]</td>\n",
              "      <td>[17, 10]</td>\n",
              "      <td>[4, 5]</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-11-24</th>\n",
              "      <td>[12, 12]</td>\n",
              "      <td>[1, 9]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[3, 2]</td>\n",
              "      <td>[7, 10]</td>\n",
              "      <td>[5, 10]</td>\n",
              "      <td>[8, 13]</td>\n",
              "      <td>[3, 6]</td>\n",
              "      <td>[10, 10]</td>\n",
              "      <td>[2, 7]</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-11-25</th>\n",
              "      <td>[18, 23]</td>\n",
              "      <td>[5, 12]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[3, 9]</td>\n",
              "      <td>[11, 11]</td>\n",
              "      <td>[14, 12]</td>\n",
              "      <td>[10, 11]</td>\n",
              "      <td>[9, 4]</td>\n",
              "      <td>[15, 15]</td>\n",
              "      <td>[9, 7]</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-11-26</th>\n",
              "      <td>[12, 11]</td>\n",
              "      <td>[2, 8]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[3, 8]</td>\n",
              "      <td>[6, 3]</td>\n",
              "      <td>[12, 14]</td>\n",
              "      <td>[11, 4]</td>\n",
              "      <td>[9, 5]</td>\n",
              "      <td>[12, 10]</td>\n",
              "      <td>[6, 5]</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-11-27</th>\n",
              "      <td>[28, 17]</td>\n",
              "      <td>[8, 14]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[12, 13]</td>\n",
              "      <td>[9, 10]</td>\n",
              "      <td>[12, 9]</td>\n",
              "      <td>[14, 11]</td>\n",
              "      <td>[12, 6]</td>\n",
              "      <td>[7, 15]</td>\n",
              "      <td>[7, 5]</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 111 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "           Anti-Mage      Axe Bane Bloodseeker Crystal Maiden Drow Ranger  \\\n",
              "2011-11-23  [10, 11]  [5, 10]  NaN      [6, 8]         [6, 6]     [7, 10]   \n",
              "2011-11-24  [12, 12]   [1, 9]  NaN      [3, 2]        [7, 10]     [5, 10]   \n",
              "2011-11-25  [18, 23]  [5, 12]  NaN      [3, 9]       [11, 11]    [14, 12]   \n",
              "2011-11-26  [12, 11]   [2, 8]  NaN      [3, 8]         [6, 3]    [12, 14]   \n",
              "2011-11-27  [28, 17]  [8, 14]  NaN    [12, 13]        [9, 10]     [12, 9]   \n",
              "\n",
              "           Earthshaker Juggernaut    Mirana Morphling  ... Elder Titan  \\\n",
              "2011-11-23     [9, 12]     [9, 0]  [17, 10]    [4, 5]  ...         NaN   \n",
              "2011-11-24     [8, 13]     [3, 6]  [10, 10]    [2, 7]  ...         NaN   \n",
              "2011-11-25    [10, 11]     [9, 4]  [15, 15]    [9, 7]  ...         NaN   \n",
              "2011-11-26     [11, 4]     [9, 5]  [12, 10]    [6, 5]  ...         NaN   \n",
              "2011-11-27    [14, 11]    [12, 6]   [7, 15]    [7, 5]  ...         NaN   \n",
              "\n",
              "           Legion Commander Techies Ember Spirit Earth Spirit Terrorblade  \\\n",
              "2011-11-23              NaN     NaN          NaN          NaN         NaN   \n",
              "2011-11-24              NaN     NaN          NaN          NaN         NaN   \n",
              "2011-11-25              NaN     NaN          NaN          NaN         NaN   \n",
              "2011-11-26              NaN     NaN          NaN          NaN         NaN   \n",
              "2011-11-27              NaN     NaN          NaN          NaN         NaN   \n",
              "\n",
              "           Phoenix Oracle Winter Wyvern Arc Warden  \n",
              "2011-11-23     NaN    NaN           NaN        NaN  \n",
              "2011-11-24     NaN    NaN           NaN        NaN  \n",
              "2011-11-25     NaN    NaN           NaN        NaN  \n",
              "2011-11-26     NaN    NaN           NaN        NaN  \n",
              "2011-11-27     NaN    NaN           NaN        NaN  \n",
              "\n",
              "[5 rows x 111 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 74
        }
      ]
    },
    {
      "metadata": {
        "id": "IDQ0VPfuxZXC",
        "colab_type": "code",
        "outputId": "87f34f47-a289-4983-f802-ffdb27119db8",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 2029
        }
      },
      "cell_type": "code",
      "source": [
        "df_picks = df.copy(deep=True)\n",
        "df_picks = df_picks.applymap(lambda cell: sum(cell) if type(cell) == list else 0)"
      ],
      "execution_count": 75,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Anti-Mage</th>\n",
              "      <th>Axe</th>\n",
              "      <th>Bane</th>\n",
              "      <th>Bloodseeker</th>\n",
              "      <th>Crystal Maiden</th>\n",
              "      <th>Drow Ranger</th>\n",
              "      <th>Earthshaker</th>\n",
              "      <th>Juggernaut</th>\n",
              "      <th>Mirana</th>\n",
              "      <th>Morphling</th>\n",
              "      <th>...</th>\n",
              "      <th>Elder Titan</th>\n",
              "      <th>Legion Commander</th>\n",
              "      <th>Techies</th>\n",
              "      <th>Ember Spirit</th>\n",
              "      <th>Earth Spirit</th>\n",
              "      <th>Terrorblade</th>\n",
              "      <th>Phoenix</th>\n",
              "      <th>Oracle</th>\n",
              "      <th>Winter Wyvern</th>\n",
              "      <th>Arc Warden</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2011-11-23</th>\n",
              "      <td>21</td>\n",
              "      <td>15</td>\n",
              "      <td>0</td>\n",
              "      <td>14</td>\n",
              "      <td>12</td>\n",
              "      <td>17</td>\n",
              "      <td>21</td>\n",
              "      <td>9</td>\n",
              "      <td>27</td>\n",
              "      <td>9</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-11-24</th>\n",
              "      <td>24</td>\n",
              "      <td>10</td>\n",
              "      <td>0</td>\n",
              "      <td>5</td>\n",
              "      <td>17</td>\n",
              "      <td>15</td>\n",
              "      <td>21</td>\n",
              "      <td>9</td>\n",
              "      <td>20</td>\n",
              "      <td>9</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-11-25</th>\n",
              "      <td>41</td>\n",
              "      <td>17</td>\n",
              "      <td>0</td>\n",
              "      <td>12</td>\n",
              "      <td>22</td>\n",
              "      <td>26</td>\n",
              "      <td>21</td>\n",
              "      <td>13</td>\n",
              "      <td>30</td>\n",
              "      <td>16</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-11-26</th>\n",
              "      <td>23</td>\n",
              "      <td>10</td>\n",
              "      <td>0</td>\n",
              "      <td>11</td>\n",
              "      <td>9</td>\n",
              "      <td>26</td>\n",
              "      <td>15</td>\n",
              "      <td>14</td>\n",
              "      <td>22</td>\n",
              "      <td>11</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-11-27</th>\n",
              "      <td>45</td>\n",
              "      <td>22</td>\n",
              "      <td>0</td>\n",
              "      <td>25</td>\n",
              "      <td>19</td>\n",
              "      <td>21</td>\n",
              "      <td>25</td>\n",
              "      <td>18</td>\n",
              "      <td>22</td>\n",
              "      <td>12</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-11-28</th>\n",
              "      <td>35</td>\n",
              "      <td>12</td>\n",
              "      <td>0</td>\n",
              "      <td>13</td>\n",
              "      <td>17</td>\n",
              "      <td>26</td>\n",
              "      <td>31</td>\n",
              "      <td>19</td>\n",
              "      <td>36</td>\n",
              "      <td>20</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-11-29</th>\n",
              "      <td>43</td>\n",
              "      <td>12</td>\n",
              "      <td>0</td>\n",
              "      <td>22</td>\n",
              "      <td>21</td>\n",
              "      <td>37</td>\n",
              "      <td>27</td>\n",
              "      <td>15</td>\n",
              "      <td>26</td>\n",
              "      <td>8</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-11-30</th>\n",
              "      <td>39</td>\n",
              "      <td>9</td>\n",
              "      <td>0</td>\n",
              "      <td>16</td>\n",
              "      <td>15</td>\n",
              "      <td>31</td>\n",
              "      <td>25</td>\n",
              "      <td>18</td>\n",
              "      <td>30</td>\n",
              "      <td>16</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-01</th>\n",
              "      <td>37</td>\n",
              "      <td>14</td>\n",
              "      <td>0</td>\n",
              "      <td>16</td>\n",
              "      <td>11</td>\n",
              "      <td>33</td>\n",
              "      <td>30</td>\n",
              "      <td>14</td>\n",
              "      <td>38</td>\n",
              "      <td>14</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-02</th>\n",
              "      <td>55</td>\n",
              "      <td>26</td>\n",
              "      <td>0</td>\n",
              "      <td>30</td>\n",
              "      <td>23</td>\n",
              "      <td>39</td>\n",
              "      <td>34</td>\n",
              "      <td>27</td>\n",
              "      <td>50</td>\n",
              "      <td>11</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-03</th>\n",
              "      <td>54</td>\n",
              "      <td>28</td>\n",
              "      <td>0</td>\n",
              "      <td>38</td>\n",
              "      <td>27</td>\n",
              "      <td>38</td>\n",
              "      <td>35</td>\n",
              "      <td>26</td>\n",
              "      <td>45</td>\n",
              "      <td>20</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-04</th>\n",
              "      <td>47</td>\n",
              "      <td>21</td>\n",
              "      <td>0</td>\n",
              "      <td>24</td>\n",
              "      <td>24</td>\n",
              "      <td>29</td>\n",
              "      <td>26</td>\n",
              "      <td>21</td>\n",
              "      <td>40</td>\n",
              "      <td>8</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-05</th>\n",
              "      <td>34</td>\n",
              "      <td>12</td>\n",
              "      <td>0</td>\n",
              "      <td>14</td>\n",
              "      <td>14</td>\n",
              "      <td>24</td>\n",
              "      <td>30</td>\n",
              "      <td>21</td>\n",
              "      <td>29</td>\n",
              "      <td>17</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-06</th>\n",
              "      <td>46</td>\n",
              "      <td>16</td>\n",
              "      <td>0</td>\n",
              "      <td>26</td>\n",
              "      <td>14</td>\n",
              "      <td>39</td>\n",
              "      <td>39</td>\n",
              "      <td>19</td>\n",
              "      <td>33</td>\n",
              "      <td>20</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-07</th>\n",
              "      <td>35</td>\n",
              "      <td>16</td>\n",
              "      <td>0</td>\n",
              "      <td>23</td>\n",
              "      <td>12</td>\n",
              "      <td>21</td>\n",
              "      <td>28</td>\n",
              "      <td>20</td>\n",
              "      <td>30</td>\n",
              "      <td>10</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-08</th>\n",
              "      <td>68</td>\n",
              "      <td>25</td>\n",
              "      <td>0</td>\n",
              "      <td>39</td>\n",
              "      <td>20</td>\n",
              "      <td>48</td>\n",
              "      <td>44</td>\n",
              "      <td>37</td>\n",
              "      <td>46</td>\n",
              "      <td>22</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-09</th>\n",
              "      <td>59</td>\n",
              "      <td>19</td>\n",
              "      <td>0</td>\n",
              "      <td>33</td>\n",
              "      <td>34</td>\n",
              "      <td>49</td>\n",
              "      <td>33</td>\n",
              "      <td>19</td>\n",
              "      <td>45</td>\n",
              "      <td>20</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-10</th>\n",
              "      <td>67</td>\n",
              "      <td>40</td>\n",
              "      <td>0</td>\n",
              "      <td>50</td>\n",
              "      <td>36</td>\n",
              "      <td>50</td>\n",
              "      <td>42</td>\n",
              "      <td>27</td>\n",
              "      <td>62</td>\n",
              "      <td>29</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-11</th>\n",
              "      <td>72</td>\n",
              "      <td>27</td>\n",
              "      <td>0</td>\n",
              "      <td>49</td>\n",
              "      <td>15</td>\n",
              "      <td>36</td>\n",
              "      <td>41</td>\n",
              "      <td>27</td>\n",
              "      <td>49</td>\n",
              "      <td>28</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-12</th>\n",
              "      <td>54</td>\n",
              "      <td>23</td>\n",
              "      <td>0</td>\n",
              "      <td>29</td>\n",
              "      <td>24</td>\n",
              "      <td>31</td>\n",
              "      <td>31</td>\n",
              "      <td>25</td>\n",
              "      <td>37</td>\n",
              "      <td>22</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-13</th>\n",
              "      <td>15</td>\n",
              "      <td>11</td>\n",
              "      <td>0</td>\n",
              "      <td>20</td>\n",
              "      <td>4</td>\n",
              "      <td>17</td>\n",
              "      <td>17</td>\n",
              "      <td>9</td>\n",
              "      <td>19</td>\n",
              "      <td>9</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-14</th>\n",
              "      <td>70</td>\n",
              "      <td>21</td>\n",
              "      <td>0</td>\n",
              "      <td>30</td>\n",
              "      <td>26</td>\n",
              "      <td>47</td>\n",
              "      <td>42</td>\n",
              "      <td>34</td>\n",
              "      <td>52</td>\n",
              "      <td>15</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-15</th>\n",
              "      <td>51</td>\n",
              "      <td>13</td>\n",
              "      <td>0</td>\n",
              "      <td>26</td>\n",
              "      <td>36</td>\n",
              "      <td>37</td>\n",
              "      <td>34</td>\n",
              "      <td>29</td>\n",
              "      <td>48</td>\n",
              "      <td>15</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-16</th>\n",
              "      <td>55</td>\n",
              "      <td>17</td>\n",
              "      <td>0</td>\n",
              "      <td>42</td>\n",
              "      <td>35</td>\n",
              "      <td>45</td>\n",
              "      <td>44</td>\n",
              "      <td>28</td>\n",
              "      <td>45</td>\n",
              "      <td>21</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-17</th>\n",
              "      <td>58</td>\n",
              "      <td>32</td>\n",
              "      <td>0</td>\n",
              "      <td>45</td>\n",
              "      <td>37</td>\n",
              "      <td>36</td>\n",
              "      <td>50</td>\n",
              "      <td>28</td>\n",
              "      <td>50</td>\n",
              "      <td>28</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-18</th>\n",
              "      <td>45</td>\n",
              "      <td>13</td>\n",
              "      <td>0</td>\n",
              "      <td>34</td>\n",
              "      <td>26</td>\n",
              "      <td>39</td>\n",
              "      <td>37</td>\n",
              "      <td>24</td>\n",
              "      <td>51</td>\n",
              "      <td>14</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-19</th>\n",
              "      <td>63</td>\n",
              "      <td>29</td>\n",
              "      <td>0</td>\n",
              "      <td>21</td>\n",
              "      <td>25</td>\n",
              "      <td>40</td>\n",
              "      <td>35</td>\n",
              "      <td>30</td>\n",
              "      <td>38</td>\n",
              "      <td>20</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-20</th>\n",
              "      <td>50</td>\n",
              "      <td>20</td>\n",
              "      <td>0</td>\n",
              "      <td>33</td>\n",
              "      <td>23</td>\n",
              "      <td>32</td>\n",
              "      <td>32</td>\n",
              "      <td>22</td>\n",
              "      <td>36</td>\n",
              "      <td>17</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-21</th>\n",
              "      <td>60</td>\n",
              "      <td>22</td>\n",
              "      <td>0</td>\n",
              "      <td>30</td>\n",
              "      <td>29</td>\n",
              "      <td>34</td>\n",
              "      <td>41</td>\n",
              "      <td>24</td>\n",
              "      <td>43</td>\n",
              "      <td>13</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-12-22</th>\n",
              "      <td>51</td>\n",
              "      <td>18</td>\n",
              "      <td>0</td>\n",
              "      <td>29</td>\n",
              "      <td>22</td>\n",
              "      <td>32</td>\n",
              "      <td>35</td>\n",
              "      <td>21</td>\n",
              "      <td>39</td>\n",
              "      <td>21</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </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>2016-03-03</th>\n",
              "      <td>228</td>\n",
              "      <td>148</td>\n",
              "      <td>55</td>\n",
              "      <td>146</td>\n",
              "      <td>177</td>\n",
              "      <td>173</td>\n",
              "      <td>238</td>\n",
              "      <td>371</td>\n",
              "      <td>197</td>\n",
              "      <td>101</td>\n",
              "      <td>...</td>\n",
              "      <td>23</td>\n",
              "      <td>381</td>\n",
              "      <td>71</td>\n",
              "      <td>173</td>\n",
              "      <td>85</td>\n",
              "      <td>49</td>\n",
              "      <td>64</td>\n",
              "      <td>36</td>\n",
              "      <td>45</td>\n",
              "      <td>52</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-03-05</th>\n",
              "      <td>19</td>\n",
              "      <td>11</td>\n",
              "      <td>6</td>\n",
              "      <td>12</td>\n",
              "      <td>14</td>\n",
              "      <td>22</td>\n",
              "      <td>13</td>\n",
              "      <td>36</td>\n",
              "      <td>10</td>\n",
              "      <td>9</td>\n",
              "      <td>...</td>\n",
              "      <td>4</td>\n",
              "      <td>27</td>\n",
              "      <td>8</td>\n",
              "      <td>13</td>\n",
              "      <td>6</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-03-08</th>\n",
              "      <td>15</td>\n",
              "      <td>9</td>\n",
              "      <td>8</td>\n",
              "      <td>9</td>\n",
              "      <td>11</td>\n",
              "      <td>11</td>\n",
              "      <td>12</td>\n",
              "      <td>24</td>\n",
              "      <td>15</td>\n",
              "      <td>5</td>\n",
              "      <td>...</td>\n",
              "      <td>1</td>\n",
              "      <td>23</td>\n",
              "      <td>2</td>\n",
              "      <td>9</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "      <td>5</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-03-13</th>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-03-14</th>\n",
              "      <td>237</td>\n",
              "      <td>159</td>\n",
              "      <td>63</td>\n",
              "      <td>171</td>\n",
              "      <td>217</td>\n",
              "      <td>217</td>\n",
              "      <td>209</td>\n",
              "      <td>330</td>\n",
              "      <td>209</td>\n",
              "      <td>86</td>\n",
              "      <td>...</td>\n",
              "      <td>32</td>\n",
              "      <td>422</td>\n",
              "      <td>67</td>\n",
              "      <td>127</td>\n",
              "      <td>80</td>\n",
              "      <td>54</td>\n",
              "      <td>91</td>\n",
              "      <td>45</td>\n",
              "      <td>52</td>\n",
              "      <td>56</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-03-15</th>\n",
              "      <td>9</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>8</td>\n",
              "      <td>6</td>\n",
              "      <td>5</td>\n",
              "      <td>13</td>\n",
              "      <td>5</td>\n",
              "      <td>4</td>\n",
              "      <td>...</td>\n",
              "      <td>1</td>\n",
              "      <td>10</td>\n",
              "      <td>2</td>\n",
              "      <td>6</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-03-17</th>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-03-18</th>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-03-21</th>\n",
              "      <td>3</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>6</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "      <td>2</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>4</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-03-22</th>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-03-27</th>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-03-28</th>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-03-29</th>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-04-02</th>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-04-03</th>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-04-04</th>\n",
              "      <td>57</td>\n",
              "      <td>38</td>\n",
              "      <td>12</td>\n",
              "      <td>43</td>\n",
              "      <td>50</td>\n",
              "      <td>43</td>\n",
              "      <td>58</td>\n",
              "      <td>82</td>\n",
              "      <td>49</td>\n",
              "      <td>19</td>\n",
              "      <td>...</td>\n",
              "      <td>8</td>\n",
              "      <td>102</td>\n",
              "      <td>14</td>\n",
              "      <td>40</td>\n",
              "      <td>14</td>\n",
              "      <td>8</td>\n",
              "      <td>20</td>\n",
              "      <td>9</td>\n",
              "      <td>13</td>\n",
              "      <td>14</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-04-05</th>\n",
              "      <td>22</td>\n",
              "      <td>16</td>\n",
              "      <td>8</td>\n",
              "      <td>16</td>\n",
              "      <td>26</td>\n",
              "      <td>20</td>\n",
              "      <td>19</td>\n",
              "      <td>44</td>\n",
              "      <td>22</td>\n",
              "      <td>6</td>\n",
              "      <td>...</td>\n",
              "      <td>2</td>\n",
              "      <td>37</td>\n",
              "      <td>2</td>\n",
              "      <td>13</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>7</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-04-06</th>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-04-07</th>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-04-08</th>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-04-10</th>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-04-11</th>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-04-12</th>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-04-13</th>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-04-14</th>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>...</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-04-15</th>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-04-16</th>\n",
              "      <td>5</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>6</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>4</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-04-17</th>\n",
              "      <td>5</td>\n",
              "      <td>4</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>8</td>\n",
              "      <td>6</td>\n",
              "      <td>3</td>\n",
              "      <td>8</td>\n",
              "      <td>12</td>\n",
              "      <td>2</td>\n",
              "      <td>...</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-04-18</th>\n",
              "      <td>1133</td>\n",
              "      <td>744</td>\n",
              "      <td>316</td>\n",
              "      <td>924</td>\n",
              "      <td>1056</td>\n",
              "      <td>1030</td>\n",
              "      <td>1180</td>\n",
              "      <td>1762</td>\n",
              "      <td>1150</td>\n",
              "      <td>430</td>\n",
              "      <td>...</td>\n",
              "      <td>173</td>\n",
              "      <td>2347</td>\n",
              "      <td>484</td>\n",
              "      <td>830</td>\n",
              "      <td>371</td>\n",
              "      <td>259</td>\n",
              "      <td>429</td>\n",
              "      <td>213</td>\n",
              "      <td>269</td>\n",
              "      <td>286</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2016-04-19</th>\n",
              "      <td>5012</td>\n",
              "      <td>3128</td>\n",
              "      <td>1202</td>\n",
              "      <td>3618</td>\n",
              "      <td>4171</td>\n",
              "      <td>4714</td>\n",
              "      <td>4923</td>\n",
              "      <td>8134</td>\n",
              "      <td>4546</td>\n",
              "      <td>1693</td>\n",
              "      <td>...</td>\n",
              "      <td>669</td>\n",
              "      <td>10260</td>\n",
              "      <td>1787</td>\n",
              "      <td>3524</td>\n",
              "      <td>1687</td>\n",
              "      <td>1145</td>\n",
              "      <td>1635</td>\n",
              "      <td>1016</td>\n",
              "      <td>1128</td>\n",
              "      <td>1049</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1587 rows × 111 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "            Anti-Mage   Axe  Bane  Bloodseeker  Crystal Maiden  Drow Ranger  \\\n",
              "2011-11-23         21    15     0           14              12           17   \n",
              "2011-11-24         24    10     0            5              17           15   \n",
              "2011-11-25         41    17     0           12              22           26   \n",
              "2011-11-26         23    10     0           11               9           26   \n",
              "2011-11-27         45    22     0           25              19           21   \n",
              "2011-11-28         35    12     0           13              17           26   \n",
              "2011-11-29         43    12     0           22              21           37   \n",
              "2011-11-30         39     9     0           16              15           31   \n",
              "2011-12-01         37    14     0           16              11           33   \n",
              "2011-12-02         55    26     0           30              23           39   \n",
              "2011-12-03         54    28     0           38              27           38   \n",
              "2011-12-04         47    21     0           24              24           29   \n",
              "2011-12-05         34    12     0           14              14           24   \n",
              "2011-12-06         46    16     0           26              14           39   \n",
              "2011-12-07         35    16     0           23              12           21   \n",
              "2011-12-08         68    25     0           39              20           48   \n",
              "2011-12-09         59    19     0           33              34           49   \n",
              "2011-12-10         67    40     0           50              36           50   \n",
              "2011-12-11         72    27     0           49              15           36   \n",
              "2011-12-12         54    23     0           29              24           31   \n",
              "2011-12-13         15    11     0           20               4           17   \n",
              "2011-12-14         70    21     0           30              26           47   \n",
              "2011-12-15         51    13     0           26              36           37   \n",
              "2011-12-16         55    17     0           42              35           45   \n",
              "2011-12-17         58    32     0           45              37           36   \n",
              "2011-12-18         45    13     0           34              26           39   \n",
              "2011-12-19         63    29     0           21              25           40   \n",
              "2011-12-20         50    20     0           33              23           32   \n",
              "2011-12-21         60    22     0           30              29           34   \n",
              "2011-12-22         51    18     0           29              22           32   \n",
              "...               ...   ...   ...          ...             ...          ...   \n",
              "2016-03-03        228   148    55          146             177          173   \n",
              "2016-03-05         19    11     6           12              14           22   \n",
              "2016-03-08         15     9     8            9              11           11   \n",
              "2016-03-13          0     0     0            0               0            0   \n",
              "2016-03-14        237   159    63          171             217          217   \n",
              "2016-03-15          9     2     1            4               8            6   \n",
              "2016-03-17          0     0     0            0               0            1   \n",
              "2016-03-18          1     0     0            0               0            0   \n",
              "2016-03-21          3     2     0            1               6            0   \n",
              "2016-03-22          0     0     0            0               0            0   \n",
              "2016-03-27          0     0     0            0               0            1   \n",
              "2016-03-28          0     0     0            1               0            0   \n",
              "2016-03-29          0     0     0            0               0            0   \n",
              "2016-04-02          0     0     0            0               0            1   \n",
              "2016-04-03          0     0     0            0               0            0   \n",
              "2016-04-04         57    38    12           43              50           43   \n",
              "2016-04-05         22    16     8           16              26           20   \n",
              "2016-04-06          1     0     0            0               0            1   \n",
              "2016-04-07          1     0     0            0               0            0   \n",
              "2016-04-08          0     0     0            0               1            0   \n",
              "2016-04-10          0     0     0            0               1            0   \n",
              "2016-04-11          0     0     0            0               1            0   \n",
              "2016-04-12          2     0     0            1               1            0   \n",
              "2016-04-13          2     0     0            1               1            2   \n",
              "2016-04-14          0     0     0            2               1            1   \n",
              "2016-04-15          2     1     0            1               1            1   \n",
              "2016-04-16          5     1     0            1               4            1   \n",
              "2016-04-17          5     4     1            1               8            6   \n",
              "2016-04-18       1133   744   316          924            1056         1030   \n",
              "2016-04-19       5012  3128  1202         3618            4171         4714   \n",
              "\n",
              "            Earthshaker  Juggernaut  Mirana  Morphling  ...  Elder Titan  \\\n",
              "2011-11-23           21           9      27          9  ...            0   \n",
              "2011-11-24           21           9      20          9  ...            0   \n",
              "2011-11-25           21          13      30         16  ...            0   \n",
              "2011-11-26           15          14      22         11  ...            0   \n",
              "2011-11-27           25          18      22         12  ...            0   \n",
              "2011-11-28           31          19      36         20  ...            0   \n",
              "2011-11-29           27          15      26          8  ...            0   \n",
              "2011-11-30           25          18      30         16  ...            0   \n",
              "2011-12-01           30          14      38         14  ...            0   \n",
              "2011-12-02           34          27      50         11  ...            0   \n",
              "2011-12-03           35          26      45         20  ...            0   \n",
              "2011-12-04           26          21      40          8  ...            0   \n",
              "2011-12-05           30          21      29         17  ...            0   \n",
              "2011-12-06           39          19      33         20  ...            0   \n",
              "2011-12-07           28          20      30         10  ...            0   \n",
              "2011-12-08           44          37      46         22  ...            0   \n",
              "2011-12-09           33          19      45         20  ...            0   \n",
              "2011-12-10           42          27      62         29  ...            0   \n",
              "2011-12-11           41          27      49         28  ...            0   \n",
              "2011-12-12           31          25      37         22  ...            0   \n",
              "2011-12-13           17           9      19          9  ...            0   \n",
              "2011-12-14           42          34      52         15  ...            0   \n",
              "2011-12-15           34          29      48         15  ...            0   \n",
              "2011-12-16           44          28      45         21  ...            0   \n",
              "2011-12-17           50          28      50         28  ...            0   \n",
              "2011-12-18           37          24      51         14  ...            0   \n",
              "2011-12-19           35          30      38         20  ...            0   \n",
              "2011-12-20           32          22      36         17  ...            0   \n",
              "2011-12-21           41          24      43         13  ...            0   \n",
              "2011-12-22           35          21      39         21  ...            0   \n",
              "...                 ...         ...     ...        ...  ...          ...   \n",
              "2016-03-03          238         371     197        101  ...           23   \n",
              "2016-03-05           13          36      10          9  ...            4   \n",
              "2016-03-08           12          24      15          5  ...            1   \n",
              "2016-03-13            0           0       0          0  ...            0   \n",
              "2016-03-14          209         330     209         86  ...           32   \n",
              "2016-03-15            5          13       5          4  ...            1   \n",
              "2016-03-17            0           0       0          0  ...            0   \n",
              "2016-03-18            0           0       0          1  ...            0   \n",
              "2016-03-21            2           3       3          2  ...            0   \n",
              "2016-03-22            0           0       0          0  ...            0   \n",
              "2016-03-27            0           0       0          0  ...            0   \n",
              "2016-03-28            0           0       0          1  ...            0   \n",
              "2016-03-29            1           0       0          0  ...            0   \n",
              "2016-04-02            0           0       0          0  ...            0   \n",
              "2016-04-03            0           0       0          0  ...            0   \n",
              "2016-04-04           58          82      49         19  ...            8   \n",
              "2016-04-05           19          44      22          6  ...            2   \n",
              "2016-04-06            0           0       0          0  ...            1   \n",
              "2016-04-07            0           0       0          0  ...            0   \n",
              "2016-04-08            1           0       0          0  ...            0   \n",
              "2016-04-10            1           0       0          0  ...            0   \n",
              "2016-04-11            0           1       0          0  ...            0   \n",
              "2016-04-12            0           0       0          0  ...            0   \n",
              "2016-04-13            1           1       1          0  ...            0   \n",
              "2016-04-14            2           1       1          1  ...            1   \n",
              "2016-04-15            3           3       0          0  ...            0   \n",
              "2016-04-16            4           6       0          1  ...            0   \n",
              "2016-04-17            3           8      12          2  ...            1   \n",
              "2016-04-18         1180        1762    1150        430  ...          173   \n",
              "2016-04-19         4923        8134    4546       1693  ...          669   \n",
              "\n",
              "            Legion Commander  Techies  Ember Spirit  Earth Spirit  \\\n",
              "2011-11-23                 0        0             0             0   \n",
              "2011-11-24                 0        0             0             0   \n",
              "2011-11-25                 0        0             0             0   \n",
              "2011-11-26                 0        0             0             0   \n",
              "2011-11-27                 0        0             0             0   \n",
              "2011-11-28                 0        0             0             0   \n",
              "2011-11-29                 0        0             0             0   \n",
              "2011-11-30                 0        0             0             0   \n",
              "2011-12-01                 0        0             0             0   \n",
              "2011-12-02                 0        0             0             0   \n",
              "2011-12-03                 0        0             0             0   \n",
              "2011-12-04                 0        0             0             0   \n",
              "2011-12-05                 0        0             0             0   \n",
              "2011-12-06                 0        0             0             0   \n",
              "2011-12-07                 0        0             0             0   \n",
              "2011-12-08                 0        0             0             0   \n",
              "2011-12-09                 0        0             0             0   \n",
              "2011-12-10                 0        0             0             0   \n",
              "2011-12-11                 0        0             0             0   \n",
              "2011-12-12                 0        0             0             0   \n",
              "2011-12-13                 0        0             0             0   \n",
              "2011-12-14                 0        0             0             0   \n",
              "2011-12-15                 0        0             0             0   \n",
              "2011-12-16                 0        0             0             0   \n",
              "2011-12-17                 0        0             0             0   \n",
              "2011-12-18                 0        0             0             0   \n",
              "2011-12-19                 0        0             0             0   \n",
              "2011-12-20                 0        0             0             0   \n",
              "2011-12-21                 0        0             0             0   \n",
              "2011-12-22                 0        0             0             0   \n",
              "...                      ...      ...           ...           ...   \n",
              "2016-03-03               381       71           173            85   \n",
              "2016-03-05                27        8            13             6   \n",
              "2016-03-08                23        2             9             3   \n",
              "2016-03-13                 1        0             0             0   \n",
              "2016-03-14               422       67           127            80   \n",
              "2016-03-15                10        2             6             1   \n",
              "2016-03-17                 0        0             0             0   \n",
              "2016-03-18                 0        0             0             0   \n",
              "2016-03-21                 4        2             1             0   \n",
              "2016-03-22                 0        0             0             0   \n",
              "2016-03-27                 1        0             0             0   \n",
              "2016-03-28                 0        0             0             1   \n",
              "2016-03-29                 0        0             0             0   \n",
              "2016-04-02                 0        0             0             0   \n",
              "2016-04-03                 0        0             0             0   \n",
              "2016-04-04               102       14            40            14   \n",
              "2016-04-05                37        2            13             6   \n",
              "2016-04-06                 0        0             0             0   \n",
              "2016-04-07                 0        0             0             0   \n",
              "2016-04-08                 0        0             0             0   \n",
              "2016-04-10                 0        1             1             0   \n",
              "2016-04-11                 1        0             0             0   \n",
              "2016-04-12                 0        0             0             1   \n",
              "2016-04-13                 1        0             0             3   \n",
              "2016-04-14                 0        0             0             2   \n",
              "2016-04-15                 3        0             0             0   \n",
              "2016-04-16                 4        2             2             0   \n",
              "2016-04-17                 3        0             2             4   \n",
              "2016-04-18              2347      484           830           371   \n",
              "2016-04-19             10260     1787          3524          1687   \n",
              "\n",
              "            Terrorblade  Phoenix  Oracle  Winter Wyvern  Arc Warden  \n",
              "2011-11-23            0        0       0              0           0  \n",
              "2011-11-24            0        0       0              0           0  \n",
              "2011-11-25            0        0       0              0           0  \n",
              "2011-11-26            0        0       0              0           0  \n",
              "2011-11-27            0        0       0              0           0  \n",
              "2011-11-28            0        0       0              0           0  \n",
              "2011-11-29            0        0       0              0           0  \n",
              "2011-11-30            0        0       0              0           0  \n",
              "2011-12-01            0        0       0              0           0  \n",
              "2011-12-02            0        0       0              0           0  \n",
              "2011-12-03            0        0       0              0           0  \n",
              "2011-12-04            0        0       0              0           0  \n",
              "2011-12-05            0        0       0              0           0  \n",
              "2011-12-06            0        0       0              0           0  \n",
              "2011-12-07            0        0       0              0           0  \n",
              "2011-12-08            0        0       0              0           0  \n",
              "2011-12-09            0        0       0              0           0  \n",
              "2011-12-10            0        0       0              0           0  \n",
              "2011-12-11            0        0       0              0           0  \n",
              "2011-12-12            0        0       0              0           0  \n",
              "2011-12-13            0        0       0              0           0  \n",
              "2011-12-14            0        0       0              0           0  \n",
              "2011-12-15            0        0       0              0           0  \n",
              "2011-12-16            0        0       0              0           0  \n",
              "2011-12-17            0        0       0              0           0  \n",
              "2011-12-18            0        0       0              0           0  \n",
              "2011-12-19            0        0       0              0           0  \n",
              "2011-12-20            0        0       0              0           0  \n",
              "2011-12-21            0        0       0              0           0  \n",
              "2011-12-22            0        0       0              0           0  \n",
              "...                 ...      ...     ...            ...         ...  \n",
              "2016-03-03           49       64      36             45          52  \n",
              "2016-03-05            4        3       1              4           4  \n",
              "2016-03-08            3        5       2              1           3  \n",
              "2016-03-13            0        0       0              0           0  \n",
              "2016-03-14           54       91      45             52          56  \n",
              "2016-03-15            3        1       1              2           1  \n",
              "2016-03-17            0        0       0              0           0  \n",
              "2016-03-18            0        0       0              0           0  \n",
              "2016-03-21            0        1       0              1           0  \n",
              "2016-03-22            0        0       0              0           0  \n",
              "2016-03-27            0        1       0              0           0  \n",
              "2016-03-28            0        0       0              1           0  \n",
              "2016-03-29            0        0       0              0           0  \n",
              "2016-04-02            0        0       0              0           0  \n",
              "2016-04-03            0        0       0              0           0  \n",
              "2016-04-04            8       20       9             13          14  \n",
              "2016-04-05            6        7       1              5           5  \n",
              "2016-04-06            0        0       0              0           0  \n",
              "2016-04-07            0        0       0              0           1  \n",
              "2016-04-08            0        0       0              0           0  \n",
              "2016-04-10            0        1       1              0           0  \n",
              "2016-04-11            0        0       0              0           0  \n",
              "2016-04-12            0        0       0              0           0  \n",
              "2016-04-13            0        0       1              0           0  \n",
              "2016-04-14            0        0       0              0           1  \n",
              "2016-04-15            0        1       1              0           1  \n",
              "2016-04-16            0        2       3              1           3  \n",
              "2016-04-17            2        1       2              1           1  \n",
              "2016-04-18          259      429     213            269         286  \n",
              "2016-04-19         1145     1635    1016           1128        1049  \n",
              "\n",
              "[1587 rows x 111 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 75
        }
      ]
    },
    {
      "metadata": {
        "id": "2Z32qDy6jkk0",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "df_win_ratio = df.copy(deep=True)\n",
        "df_win_ratio = df_win_ratio.applymap(lambda cell: cell[0]/(cell[1]+cell[0]) if type(cell) == list else np.NaN)"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "WZtIr39MtnvT",
        "colab_type": "code",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 273
        },
        "outputId": "eb96303e-50a7-4fa6-c05e-74dd25f478ef"
      },
      "cell_type": "code",
      "source": [
        "df_win_ratio.head()"
      ],
      "execution_count": 78,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Anti-Mage</th>\n",
              "      <th>Axe</th>\n",
              "      <th>Bane</th>\n",
              "      <th>Bloodseeker</th>\n",
              "      <th>Crystal Maiden</th>\n",
              "      <th>Drow Ranger</th>\n",
              "      <th>Earthshaker</th>\n",
              "      <th>Juggernaut</th>\n",
              "      <th>Mirana</th>\n",
              "      <th>Morphling</th>\n",
              "      <th>...</th>\n",
              "      <th>Elder Titan</th>\n",
              "      <th>Legion Commander</th>\n",
              "      <th>Techies</th>\n",
              "      <th>Ember Spirit</th>\n",
              "      <th>Earth Spirit</th>\n",
              "      <th>Terrorblade</th>\n",
              "      <th>Phoenix</th>\n",
              "      <th>Oracle</th>\n",
              "      <th>Winter Wyvern</th>\n",
              "      <th>Arc Warden</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2011-11-23</th>\n",
              "      <td>0.476190</td>\n",
              "      <td>0.333333</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.428571</td>\n",
              "      <td>0.500000</td>\n",
              "      <td>0.411765</td>\n",
              "      <td>0.428571</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.629630</td>\n",
              "      <td>0.444444</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-11-24</th>\n",
              "      <td>0.500000</td>\n",
              "      <td>0.100000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.600000</td>\n",
              "      <td>0.411765</td>\n",
              "      <td>0.333333</td>\n",
              "      <td>0.380952</td>\n",
              "      <td>0.333333</td>\n",
              "      <td>0.500000</td>\n",
              "      <td>0.222222</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-11-25</th>\n",
              "      <td>0.439024</td>\n",
              "      <td>0.294118</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.250000</td>\n",
              "      <td>0.500000</td>\n",
              "      <td>0.538462</td>\n",
              "      <td>0.476190</td>\n",
              "      <td>0.692308</td>\n",
              "      <td>0.500000</td>\n",
              "      <td>0.562500</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-11-26</th>\n",
              "      <td>0.521739</td>\n",
              "      <td>0.200000</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.272727</td>\n",
              "      <td>0.666667</td>\n",
              "      <td>0.461538</td>\n",
              "      <td>0.733333</td>\n",
              "      <td>0.642857</td>\n",
              "      <td>0.545455</td>\n",
              "      <td>0.545455</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2011-11-27</th>\n",
              "      <td>0.622222</td>\n",
              "      <td>0.363636</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.480000</td>\n",
              "      <td>0.473684</td>\n",
              "      <td>0.571429</td>\n",
              "      <td>0.560000</td>\n",
              "      <td>0.666667</td>\n",
              "      <td>0.318182</td>\n",
              "      <td>0.583333</td>\n",
              "      <td>...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 111 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "            Anti-Mage       Axe  Bane  Bloodseeker  Crystal Maiden  \\\n",
              "2011-11-23   0.476190  0.333333   NaN     0.428571        0.500000   \n",
              "2011-11-24   0.500000  0.100000   NaN     0.600000        0.411765   \n",
              "2011-11-25   0.439024  0.294118   NaN     0.250000        0.500000   \n",
              "2011-11-26   0.521739  0.200000   NaN     0.272727        0.666667   \n",
              "2011-11-27   0.622222  0.363636   NaN     0.480000        0.473684   \n",
              "\n",
              "            Drow Ranger  Earthshaker  Juggernaut    Mirana  Morphling  ...  \\\n",
              "2011-11-23     0.411765     0.428571    1.000000  0.629630   0.444444  ...   \n",
              "2011-11-24     0.333333     0.380952    0.333333  0.500000   0.222222  ...   \n",
              "2011-11-25     0.538462     0.476190    0.692308  0.500000   0.562500  ...   \n",
              "2011-11-26     0.461538     0.733333    0.642857  0.545455   0.545455  ...   \n",
              "2011-11-27     0.571429     0.560000    0.666667  0.318182   0.583333  ...   \n",
              "\n",
              "            Elder Titan  Legion Commander  Techies  Ember Spirit  \\\n",
              "2011-11-23          NaN               NaN      NaN           NaN   \n",
              "2011-11-24          NaN               NaN      NaN           NaN   \n",
              "2011-11-25          NaN               NaN      NaN           NaN   \n",
              "2011-11-26          NaN               NaN      NaN           NaN   \n",
              "2011-11-27          NaN               NaN      NaN           NaN   \n",
              "\n",
              "            Earth Spirit  Terrorblade  Phoenix  Oracle  Winter Wyvern  \\\n",
              "2011-11-23           NaN          NaN      NaN     NaN            NaN   \n",
              "2011-11-24           NaN          NaN      NaN     NaN            NaN   \n",
              "2011-11-25           NaN          NaN      NaN     NaN            NaN   \n",
              "2011-11-26           NaN          NaN      NaN     NaN            NaN   \n",
              "2011-11-27           NaN          NaN      NaN     NaN            NaN   \n",
              "\n",
              "            Arc Warden  \n",
              "2011-11-23         NaN  \n",
              "2011-11-24         NaN  \n",
              "2011-11-25         NaN  \n",
              "2011-11-26         NaN  \n",
              "2011-11-27         NaN  \n",
              "\n",
              "[5 rows x 111 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 78
        }
      ]
    },
    {
      "metadata": {
        "id": "gnsJcbizj4GX",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "df_win_ratio.to_csv(\"temp_win_ratios.csv\")"
      ],
      "execution_count": 0,
      "outputs": []
    }
  ]
}