analysis/heroes_winratio/OpenDota_Picks_JSON_to_CSV.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/heroes_winratio/OpenDota_Picks_JSON_to_CSV.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\"] = \"https://raw.githubusercontent.com/marcolussetti/opendotadump-tools/master/data/condensed_matches_data/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": "2a9579cb-e727-470a-afe9-8a7b89d3dc13",
        "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": 4,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Starting OpenDotaDumpTools...\n",
            "JSON input loaded\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "WMXK9s6Pg5VH",
        "colab_type": "code",
        "outputId": "26d52bd1-a0e7-4d64-8527-860bcf47417a",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 270
        }
      },
      "cell_type": "code",
      "source": [
        "df.head()"
      ],
      "execution_count": 5,
      "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>15283</th>\n",
              "      <th>15282</th>\n",
              "      <th>15281</th>\n",
              "      <th>15280</th>\n",
              "      <th>15279</th>\n",
              "      <th>15278</th>\n",
              "      <th>15277</th>\n",
              "      <th>15276</th>\n",
              "      <th>15275</th>\n",
              "      <th>15274</th>\n",
              "      <th>...</th>\n",
              "      <th>15293</th>\n",
              "      <th>15292</th>\n",
              "      <th>15291</th>\n",
              "      <th>15290</th>\n",
              "      <th>15289</th>\n",
              "      <th>15288</th>\n",
              "      <th>15287</th>\n",
              "      <th>15286</th>\n",
              "      <th>15285</th>\n",
              "      <th>15284</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</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>1</th>\n",
              "      <td>[237, 203]</td>\n",
              "      <td>[182, 157]</td>\n",
              "      <td>[190, 170]</td>\n",
              "      <td>[137, 111]</td>\n",
              "      <td>[133, 108]</td>\n",
              "      <td>[146, 105]</td>\n",
              "      <td>[114, 112]</td>\n",
              "      <td>[120, 127]</td>\n",
              "      <td>[122, 117]</td>\n",
              "      <td>[131, 102]</td>\n",
              "      <td>...</td>\n",
              "      <td>[713, 550]</td>\n",
              "      <td>[655, 538]</td>\n",
              "      <td>[742, 563]</td>\n",
              "      <td>[666, 549]</td>\n",
              "      <td>[565, 472]</td>\n",
              "      <td>[430, 351]</td>\n",
              "      <td>[273, 205]</td>\n",
              "      <td>[185, 172]</td>\n",
              "      <td>[206, 179]</td>\n",
              "      <td>[205, 196]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>[67, 89]</td>\n",
              "      <td>[63, 81]</td>\n",
              "      <td>[50, 71]</td>\n",
              "      <td>[42, 43]</td>\n",
              "      <td>[35, 50]</td>\n",
              "      <td>[41, 54]</td>\n",
              "      <td>[50, 49]</td>\n",
              "      <td>[33, 54]</td>\n",
              "      <td>[35, 40]</td>\n",
              "      <td>[46, 54]</td>\n",
              "      <td>...</td>\n",
              "      <td>[194, 328]</td>\n",
              "      <td>[202, 285]</td>\n",
              "      <td>[205, 295]</td>\n",
              "      <td>[207, 284]</td>\n",
              "      <td>[162, 243]</td>\n",
              "      <td>[145, 187]</td>\n",
              "      <td>[72, 109]</td>\n",
              "      <td>[63, 105]</td>\n",
              "      <td>[58, 69]</td>\n",
              "      <td>[71, 72]</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>100</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>101</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",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 1870 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "          15283       15282       15281       15280       15279       15278  \\\n",
              "0           NaN         NaN         NaN         NaN         NaN         NaN   \n",
              "1    [237, 203]  [182, 157]  [190, 170]  [137, 111]  [133, 108]  [146, 105]   \n",
              "10     [67, 89]    [63, 81]    [50, 71]    [42, 43]    [35, 50]    [41, 54]   \n",
              "100         NaN         NaN         NaN         NaN         NaN         NaN   \n",
              "101         NaN         NaN         NaN         NaN         NaN         NaN   \n",
              "\n",
              "          15277       15276       15275       15274  ...       15293  \\\n",
              "0           NaN         NaN         NaN         NaN  ...         NaN   \n",
              "1    [114, 112]  [120, 127]  [122, 117]  [131, 102]  ...  [713, 550]   \n",
              "10     [50, 49]    [33, 54]    [35, 40]    [46, 54]  ...  [194, 328]   \n",
              "100         NaN         NaN         NaN         NaN  ...         NaN   \n",
              "101         NaN         NaN         NaN         NaN  ...         NaN   \n",
              "\n",
              "          15292       15291       15290       15289       15288       15287  \\\n",
              "0           NaN         NaN         NaN         NaN         NaN         NaN   \n",
              "1    [655, 538]  [742, 563]  [666, 549]  [565, 472]  [430, 351]  [273, 205]   \n",
              "10   [202, 285]  [205, 295]  [207, 284]  [162, 243]  [145, 187]   [72, 109]   \n",
              "100         NaN         NaN         NaN         NaN         NaN         NaN   \n",
              "101         NaN         NaN         NaN         NaN         NaN         NaN   \n",
              "\n",
              "          15286       15285       15284  \n",
              "0           NaN         NaN         NaN  \n",
              "1    [185, 172]  [206, 179]  [205, 196]  \n",
              "10    [63, 105]    [58, 69]    [71, 72]  \n",
              "100         NaN         NaN         NaN  \n",
              "101         NaN         NaN         NaN  \n",
              "\n",
              "[5 rows x 1870 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "metadata": {
        "id": "YQirnV7_h5ip",
        "colab_type": "code",
        "outputId": "12c9ba98-d6bc-489d-86da-102db036e0b9",
        "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": 6,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Input cleaned\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "BUY8XbsWiF_3",
        "colab_type": "code",
        "outputId": "c661620c-ec4a-4aec-a354-501a4c4c9d9a",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 236
        }
      },
      "cell_type": "code",
      "source": [
        "df.head()"
      ],
      "execution_count": 7,
      "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-03-02</th>\n",
              "      <td>NaN</td>\n",
              "      <td>[2, 0]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[1, 1]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[1, 0]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[0, 1]</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-03-03</th>\n",
              "      <td>NaN</td>\n",
              "      <td>[1, 2]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[2, 0]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[1, 1]</td>\n",
              "      <td>[2, 1]</td>\n",
              "      <td>[0, 4]</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-03-04</th>\n",
              "      <td>NaN</td>\n",
              "      <td>[0, 2]</td>\n",
              "      <td>[0, 2]</td>\n",
              "      <td>[1, 0]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[0, 1]</td>\n",
              "      <td>[0, 2]</td>\n",
              "      <td>[1, 1]</td>\n",
              "      <td>[0, 1]</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-03-06</th>\n",
              "      <td>NaN</td>\n",
              "      <td>[1, 1]</td>\n",
              "      <td>[2, 1]</td>\n",
              "      <td>[1, 0]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[1, 1]</td>\n",
              "      <td>[2, 2]</td>\n",
              "      <td>[1, 0]</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-03-08</th>\n",
              "      <td>NaN</td>\n",
              "      <td>[1, 0]</td>\n",
              "      <td>[0, 1]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[0, 1]</td>\n",
              "      <td>[3, 1]</td>\n",
              "      <td>[1, 1]</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    \\\n",
              "2011-03-02  NaN  [2, 0]     NaN  [1, 1]  NaN     NaN     NaN  [1, 0]     NaN   \n",
              "2011-03-03  NaN  [1, 2]     NaN  [2, 0]  NaN  [1, 1]  [2, 1]  [0, 4]     NaN   \n",
              "2011-03-04  NaN  [0, 2]  [0, 2]  [1, 0]  NaN  [0, 1]  [0, 2]  [1, 1]  [0, 1]   \n",
              "2011-03-06  NaN  [1, 1]  [2, 1]  [1, 0]  NaN     NaN  [1, 1]  [2, 2]  [1, 0]   \n",
              "2011-03-08  NaN  [1, 0]  [0, 1]     NaN  NaN     NaN  [0, 1]  [3, 1]  [1, 1]   \n",
              "\n",
              "               10   ...  103  104  105  106  107  109  110  111  112  113  \n",
              "2011-03-02  [0, 1]  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
              "2011-03-03     NaN  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
              "2011-03-04     NaN  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
              "2011-03-06     NaN  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
              "2011-03-08     NaN  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
              "\n",
              "[5 rows x 111 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 7
        }
      ]
    },
    {
      "metadata": {
        "id": "lEP7O9qIi4so",
        "colab_type": "code",
        "outputId": "bed1fcbe-36e0-44ab-fd75-41928ccf274a",
        "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": 8,
      "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": "1856a3b8-13cb-4f60-d589-c166b541c50f",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 236
        }
      },
      "cell_type": "code",
      "source": [
        "df.head()"
      ],
      "execution_count": 9,
      "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>[1807, 1460]</td>\n",
              "      <td>[711, 1066]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[949, 976]</td>\n",
              "      <td>[942, 878]</td>\n",
              "      <td>[1312, 1424]</td>\n",
              "      <td>[1277, 1226]</td>\n",
              "      <td>[986, 950]</td>\n",
              "      <td>[1663, 1551]</td>\n",
              "      <td>[552, 819]</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>[1978, 1745]</td>\n",
              "      <td>[820, 1166]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[1211, 1133]</td>\n",
              "      <td>[1074, 985]</td>\n",
              "      <td>[1526, 1609]</td>\n",
              "      <td>[1419, 1379]</td>\n",
              "      <td>[1069, 1116]</td>\n",
              "      <td>[1970, 1727]</td>\n",
              "      <td>[643, 977]</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>[2261, 2010]</td>\n",
              "      <td>[848, 1278]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[1271, 1268]</td>\n",
              "      <td>[1192, 1171]</td>\n",
              "      <td>[1739, 1874]</td>\n",
              "      <td>[1584, 1527]</td>\n",
              "      <td>[1173, 1184]</td>\n",
              "      <td>[2050, 1919]</td>\n",
              "      <td>[686, 1082]</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>[1804, 1471]</td>\n",
              "      <td>[653, 974]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[940, 914]</td>\n",
              "      <td>[928, 882]</td>\n",
              "      <td>[1398, 1478]</td>\n",
              "      <td>[1264, 1120]</td>\n",
              "      <td>[979, 975]</td>\n",
              "      <td>[1604, 1532]</td>\n",
              "      <td>[564, 824]</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>[2328, 1904]</td>\n",
              "      <td>[838, 1210]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[1304, 1218]</td>\n",
              "      <td>[1192, 1084]</td>\n",
              "      <td>[1561, 1806]</td>\n",
              "      <td>[1485, 1533]</td>\n",
              "      <td>[1110, 1209]</td>\n",
              "      <td>[2064, 1948]</td>\n",
              "      <td>[679, 987]</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    \\\n",
              "2011-11-23  [1807, 1460]  [711, 1066]  NaN    [949, 976]    [942, 878]   \n",
              "2011-11-24  [1978, 1745]  [820, 1166]  NaN  [1211, 1133]   [1074, 985]   \n",
              "2011-11-25  [2261, 2010]  [848, 1278]  NaN  [1271, 1268]  [1192, 1171]   \n",
              "2011-11-26  [1804, 1471]   [653, 974]  NaN    [940, 914]    [928, 882]   \n",
              "2011-11-27  [2328, 1904]  [838, 1210]  NaN  [1304, 1218]  [1192, 1084]   \n",
              "\n",
              "                     6             7             8             9    \\\n",
              "2011-11-23  [1312, 1424]  [1277, 1226]    [986, 950]  [1663, 1551]   \n",
              "2011-11-24  [1526, 1609]  [1419, 1379]  [1069, 1116]  [1970, 1727]   \n",
              "2011-11-25  [1739, 1874]  [1584, 1527]  [1173, 1184]  [2050, 1919]   \n",
              "2011-11-26  [1398, 1478]  [1264, 1120]    [979, 975]  [1604, 1532]   \n",
              "2011-11-27  [1561, 1806]  [1485, 1533]  [1110, 1209]  [2064, 1948]   \n",
              "\n",
              "                    10   ...  103  104  105  106  107  109  110  111  112  113  \n",
              "2011-11-23   [552, 819]  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
              "2011-11-24   [643, 977]  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
              "2011-11-25  [686, 1082]  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
              "2011-11-26   [564, 824]  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
              "2011-11-27   [679, 987]  ...  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  NaN  \n",
              "\n",
              "[5 rows x 111 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "metadata": {
        "id": "QXDBGKA08-ro",
        "colab_type": "code",
        "outputId": "392b6c14-3e17-422e-8072-e78d4d4ea233",
        "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": 10,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Heroes ids replaced with heroes names\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "metadata": {
        "id": "PrzjuI2whkdN",
        "colab_type": "code",
        "outputId": "d4489f40-5252-4fa6-8377-f0e3bb50ebbb",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 360
        }
      },
      "cell_type": "code",
      "source": [
        "df.head()"
      ],
      "execution_count": 11,
      "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>[1807, 1460]</td>\n",
              "      <td>[711, 1066]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[949, 976]</td>\n",
              "      <td>[942, 878]</td>\n",
              "      <td>[1312, 1424]</td>\n",
              "      <td>[1277, 1226]</td>\n",
              "      <td>[986, 950]</td>\n",
              "      <td>[1663, 1551]</td>\n",
              "      <td>[552, 819]</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>[1978, 1745]</td>\n",
              "      <td>[820, 1166]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[1211, 1133]</td>\n",
              "      <td>[1074, 985]</td>\n",
              "      <td>[1526, 1609]</td>\n",
              "      <td>[1419, 1379]</td>\n",
              "      <td>[1069, 1116]</td>\n",
              "      <td>[1970, 1727]</td>\n",
              "      <td>[643, 977]</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>[2261, 2010]</td>\n",
              "      <td>[848, 1278]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[1271, 1268]</td>\n",
              "      <td>[1192, 1171]</td>\n",
              "      <td>[1739, 1874]</td>\n",
              "      <td>[1584, 1527]</td>\n",
              "      <td>[1173, 1184]</td>\n",
              "      <td>[2050, 1919]</td>\n",
              "      <td>[686, 1082]</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>[1804, 1471]</td>\n",
              "      <td>[653, 974]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[940, 914]</td>\n",
              "      <td>[928, 882]</td>\n",
              "      <td>[1398, 1478]</td>\n",
              "      <td>[1264, 1120]</td>\n",
              "      <td>[979, 975]</td>\n",
              "      <td>[1604, 1532]</td>\n",
              "      <td>[564, 824]</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>[2328, 1904]</td>\n",
              "      <td>[838, 1210]</td>\n",
              "      <td>NaN</td>\n",
              "      <td>[1304, 1218]</td>\n",
              "      <td>[1192, 1084]</td>\n",
              "      <td>[1561, 1806]</td>\n",
              "      <td>[1485, 1533]</td>\n",
              "      <td>[1110, 1209]</td>\n",
              "      <td>[2064, 1948]</td>\n",
              "      <td>[679, 987]</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  [1807, 1460]  [711, 1066]  NaN    [949, 976]     [942, 878]   \n",
              "2011-11-24  [1978, 1745]  [820, 1166]  NaN  [1211, 1133]    [1074, 985]   \n",
              "2011-11-25  [2261, 2010]  [848, 1278]  NaN  [1271, 1268]   [1192, 1171]   \n",
              "2011-11-26  [1804, 1471]   [653, 974]  NaN    [940, 914]     [928, 882]   \n",
              "2011-11-27  [2328, 1904]  [838, 1210]  NaN  [1304, 1218]   [1192, 1084]   \n",
              "\n",
              "             Drow Ranger   Earthshaker    Juggernaut        Mirana  \\\n",
              "2011-11-23  [1312, 1424]  [1277, 1226]    [986, 950]  [1663, 1551]   \n",
              "2011-11-24  [1526, 1609]  [1419, 1379]  [1069, 1116]  [1970, 1727]   \n",
              "2011-11-25  [1739, 1874]  [1584, 1527]  [1173, 1184]  [2050, 1919]   \n",
              "2011-11-26  [1398, 1478]  [1264, 1120]    [979, 975]  [1604, 1532]   \n",
              "2011-11-27  [1561, 1806]  [1485, 1533]  [1110, 1209]  [2064, 1948]   \n",
              "\n",
              "              Morphling  ... Elder Titan Legion Commander Techies  \\\n",
              "2011-11-23   [552, 819]  ...         NaN              NaN     NaN   \n",
              "2011-11-24   [643, 977]  ...         NaN              NaN     NaN   \n",
              "2011-11-25  [686, 1082]  ...         NaN              NaN     NaN   \n",
              "2011-11-26   [564, 824]  ...         NaN              NaN     NaN   \n",
              "2011-11-27   [679, 987]  ...         NaN              NaN     NaN   \n",
              "\n",
              "           Ember Spirit Earth Spirit Terrorblade Phoenix Oracle Winter Wyvern  \\\n",
              "2011-11-23          NaN          NaN         NaN     NaN    NaN           NaN   \n",
              "2011-11-24          NaN          NaN         NaN     NaN    NaN           NaN   \n",
              "2011-11-25          NaN          NaN         NaN     NaN    NaN           NaN   \n",
              "2011-11-26          NaN          NaN         NaN     NaN    NaN           NaN   \n",
              "2011-11-27          NaN          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": 11
        }
      ]
    },
    {
      "metadata": {
        "id": "IDQ0VPfuxZXC",
        "colab_type": "code",
        "colab": {}
      },
      "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": 0,
      "outputs": []
    },
    {
      "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",
        "outputId": "c921a4ad-b2db-4757-8ae6-122d811c4432",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 273
        }
      },
      "cell_type": "code",
      "source": [
        "df_win_ratio.head()"
      ],
      "execution_count": 15,
      "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.553107</td>\n",
              "      <td>0.400113</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.492987</td>\n",
              "      <td>0.517582</td>\n",
              "      <td>0.479532</td>\n",
              "      <td>0.510188</td>\n",
              "      <td>0.509298</td>\n",
              "      <td>0.517424</td>\n",
              "      <td>0.402626</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.531292</td>\n",
              "      <td>0.412890</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.516638</td>\n",
              "      <td>0.521612</td>\n",
              "      <td>0.486762</td>\n",
              "      <td>0.507148</td>\n",
              "      <td>0.489245</td>\n",
              "      <td>0.532864</td>\n",
              "      <td>0.396914</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.529384</td>\n",
              "      <td>0.398871</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.500591</td>\n",
              "      <td>0.504444</td>\n",
              "      <td>0.481317</td>\n",
              "      <td>0.509161</td>\n",
              "      <td>0.497667</td>\n",
              "      <td>0.516503</td>\n",
              "      <td>0.388009</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.550840</td>\n",
              "      <td>0.401352</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.507012</td>\n",
              "      <td>0.512707</td>\n",
              "      <td>0.486092</td>\n",
              "      <td>0.530201</td>\n",
              "      <td>0.501024</td>\n",
              "      <td>0.511480</td>\n",
              "      <td>0.406340</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.550095</td>\n",
              "      <td>0.409180</td>\n",
              "      <td>NaN</td>\n",
              "      <td>0.517050</td>\n",
              "      <td>0.523726</td>\n",
              "      <td>0.463617</td>\n",
              "      <td>0.492048</td>\n",
              "      <td>0.478655</td>\n",
              "      <td>0.514457</td>\n",
              "      <td>0.407563</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.553107  0.400113   NaN     0.492987        0.517582   \n",
              "2011-11-24   0.531292  0.412890   NaN     0.516638        0.521612   \n",
              "2011-11-25   0.529384  0.398871   NaN     0.500591        0.504444   \n",
              "2011-11-26   0.550840  0.401352   NaN     0.507012        0.512707   \n",
              "2011-11-27   0.550095  0.409180   NaN     0.517050        0.523726   \n",
              "\n",
              "            Drow Ranger  Earthshaker  Juggernaut    Mirana  Morphling  ...  \\\n",
              "2011-11-23     0.479532     0.510188    0.509298  0.517424   0.402626  ...   \n",
              "2011-11-24     0.486762     0.507148    0.489245  0.532864   0.396914  ...   \n",
              "2011-11-25     0.481317     0.509161    0.497667  0.516503   0.388009  ...   \n",
              "2011-11-26     0.486092     0.530201    0.501024  0.511480   0.406340  ...   \n",
              "2011-11-27     0.463617     0.492048    0.478655  0.514457   0.407563  ...   \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": 15
        }
      ]
    },
    {
      "metadata": {
        "id": "gnsJcbizj4GX",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        "df_win_ratio.to_csv(\"win_ratios.csv\")"
      ],
      "execution_count": 0,
      "outputs": []
    },
    {
      "metadata": {
        "id": "OptdtRn3WjaL",
        "colab_type": "code",
        "colab": {}
      },
      "cell_type": "code",
      "source": [
        ""
      ],
      "execution_count": 0,
      "outputs": []
    }
  ]
}