statistics_hero.ipynb

{
  "cells": [
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "id": "icyxK4lPT7jD"
      },
      "outputs": [],
      "source": [
        "import requests\n",
        "from prettytable import PrettyTable\n",
        "from typing import Dict, Optional, List"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "v6eNDoITnRln"
      },
      "source": [
        "## hero winrate and counter"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 2,
      "metadata": {
        "id": "Rk3hFooAZs60"
      },
      "outputs": [],
      "source": [
        "class FilterAPI:\n",
        "    def __init__(self, url: str, payload: Dict):\n",
        "        self.url = url\n",
        "        self.payload = payload\n",
        "\n",
        "    def fetch_data(self) -> Optional[Dict]:\n",
        "        try:\n",
        "            response = requests.post(self.url, json=self.payload)\n",
        "            response.raise_for_status()\n",
        "            return response.json()\n",
        "        except requests.exceptions.RequestException as e:\n",
        "            print(f\"An error occurred: {e}\")\n",
        "            return None\n",
        "\n",
        "class FilterFactory:\n",
        "    URLS = {\n",
        "        \"1\": \"https://api.gms.moontontech.com/api/gms/source/2669606/2756567\",\n",
        "        \"3\": \"https://api.gms.moontontech.com/api/gms/source/2669606/2756568\",\n",
        "        \"7\": \"https://api.gms.moontontech.com/api/gms/source/2669606/2756569\",\n",
        "        \"15\": \"https://api.gms.moontontech.com/api/gms/source/2669606/2756565\",\n",
        "        \"30\": \"https://api.gms.moontontech.com/api/gms/source/2669606/2756570\",\n",
        "    }\n",
        "\n",
        "    RANKS = {\n",
        "        \"glory\": {\"field\": \"bigrank\", \"operator\": \"eq\", \"value\": \"9\"},\n",
        "        \"honor\": {\"field\": \"bigrank\", \"operator\": \"eq\", \"value\": \"8\"},\n",
        "        \"mythic\": {\"field\": \"bigrank\", \"operator\": \"eq\", \"value\": \"7\"},\n",
        "        \"legend\": {\"field\": \"bigrank\", \"operator\": \"eq\", \"value\": \"6\"},\n",
        "        \"epic\": {\"field\": \"bigrank\", \"operator\": \"eq\", \"value\": \"5\"},\n",
        "        \"all\": {\"field\": \"bigrank\", \"operator\": \"eq\", \"value\": \"101\"},\n",
        "    }\n",
        "\n",
        "    @staticmethod\n",
        "    def create_filter(day_filter: str, rank_filter: str, page_size: int, page_index: int, sorts_field: str, sorts_order: str) -> Optional[FilterAPI]:\n",
        "        \"\"\"\n",
        "        Create a FilterAPI object based on the provided filter parameters.\n",
        "        Args:\n",
        "          day_filter: 1 day, 3 days, 7 days, 15 days, 30 days\n",
        "          rank_filter: all, epic, legend, mythic, honor, glory\n",
        "          page_size: 1 - 125\n",
        "          page_index: 1 - 125\n",
        "          sorts_field: main_hero_appearance_rate, main_hero_win_rate, main_hero_ban_rate\n",
        "          sorts_order: asc, desc\n",
        "\n",
        "        Returns:\n",
        "          FilterAPI object or None if invalid filter type.\n",
        "        \"\"\"\n",
        "        url = FilterFactory.URLS.get(day_filter)\n",
        "        rank = FilterFactory.RANKS.get(rank_filter)\n",
        "\n",
        "        if not url or not rank:\n",
        "            print(\"Invalid day or rank filter.\")\n",
        "            return None\n",
        "\n",
        "        payload = {\n",
        "            \"pageSize\": page_size,\n",
        "            \"filters\": [\n",
        "                rank,\n",
        "                {\"field\": \"match_type\", \"operator\": \"eq\", \"value\": \"0\"}\n",
        "            ],\n",
        "            \"sorts\": [\n",
        "                {\"data\": {\"field\": sorts_field, \"order\": sorts_order}, \"type\": \"sequence\"},\n",
        "                {\"data\": {\"field\": \"main_heroid\", \"order\": \"desc\"}, \"type\": \"sequence\"}\n",
        "            ],\n",
        "            \"pageIndex\": page_index,\n",
        "            \"fields\": [\n",
        "                \"main_hero\", \"main_hero_appearance_rate\", \"main_hero_ban_rate\",\n",
        "                \"main_hero_channel\", \"main_hero_win_rate\", \"main_heroid\",\n",
        "                \"data.sub_hero.hero\", \"data.sub_hero.hero_channel\",\n",
        "                \"data.sub_hero.increase_win_rate\", \"data.sub_hero.heroid\"\n",
        "            ]\n",
        "        }\n",
        "\n",
        "        return FilterAPI(url=url, payload=payload)\n",
        "\n",
        "def create_hero_table(data: Dict, rate_filter: Optional[Dict[str, float]] = None) -> PrettyTable:\n",
        "    table = PrettyTable()\n",
        "    table.field_names = [\n",
        "        \"Hero ID\",\n",
        "        \"Hero Name\",\n",
        "        # \"Image URL\",\n",
        "        \"Pick Rate\",\n",
        "        \"Win Rate\",\n",
        "        \"Ban Rate\",\n",
        "        \"Counter Hero\"\n",
        "    ]\n",
        "    table.align[\"Hero ID\"] = \"r\"\n",
        "    table.align[\"Hero Name\"] = \"l\"\n",
        "    table.align[\"Ban Rate\"] = \"r\"\n",
        "    table.right_padding_width = 1\n",
        "\n",
        "    hero_name_dict = {record['data']['main_heroid']: record['data']['main_hero']['data']['name']\n",
        "                      for record in data['data']['records']}\n",
        "\n",
        "    for record in data['data']['records']:\n",
        "        hero_data = record['data']['main_hero']['data']\n",
        "        pick_rate = record['data']['main_hero_appearance_rate'] # pick_rate\n",
        "        win_rate = record['data']['main_hero_win_rate']\n",
        "        ban_rate = record['data']['main_hero_ban_rate']\n",
        "\n",
        "        # Apply the filter if specified\n",
        "        if rate_filter:\n",
        "            if \"pick_rate\" in rate_filter and pick_rate < rate_filter[\"pick_rate\"]:\n",
        "                continue\n",
        "            if \"win_rate\" in rate_filter and win_rate < rate_filter[\"win_rate\"]:\n",
        "                continue\n",
        "            if \"ban_rate\" in rate_filter and ban_rate < rate_filter[\"ban_rate\"]:\n",
        "                continue\n",
        "\n",
        "        counter_hero_names = [hero_name_dict.get(hero['heroid'], \"Unknown\")\n",
        "                              for hero in record['data']['sub_hero']]\n",
        "\n",
        "        table.add_row([\n",
        "            record['data']['main_heroid'],\n",
        "            hero_data['name'],\n",
        "            # hero_data['head'],\n",
        "            f\"{pick_rate:.2%}\",\n",
        "            f\"{win_rate:.2%}\",\n",
        "            f\"{ban_rate:.2%}\",\n",
        "            ','.join(counter_hero_names)\n",
        "        ])\n",
        "\n",
        "    return table\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 3,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "collapsed": true,
        "id": "Bmcn1z4FZtQF",
        "outputId": "671a617c-c7ca-4ec1-ef88-516647d88832"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "+---------+----------------+-----------+----------+----------+----------------------------------------------+\n",
            "| Hero ID | Hero Name      | Pick Rate | Win Rate | Ban Rate |                 Counter Hero                 |\n",
            "+---------+----------------+-----------+----------+----------+----------------------------------------------+\n",
            "|     126 | Suyou          |   1.14%   |  51.65%  |   58.71% |      Belerick,Badang,Aulus,X.Borg,Alice      |\n",
            "|     125 | Zhuxin         |   0.90%   |  52.20%  |   66.67% |    Natalia,Lolita,Esmeralda,Aulus,Aldous     |\n",
            "|     124 | Chip           |   0.64%   |  56.96%  |   54.02% |      Zilong,Valentina,Hilda,Grock,Kimmy      |\n",
            "|     123 | Cici           |   0.47%   |  47.58%  |    0.42% |       Balmond,Baxia,Gloo,Aldous,Barats       |\n",
            "|     122 | Nolan          |   1.50%   |  49.44%  |   13.38% |        Bane,Lolita,Alice,Estes,Aulus         |\n",
            "|     121 | Ixia           |   0.82%   |  50.62%  |    0.45% |  Estes,Cyclops,Popol and Kupa,Badang,Lolita  |\n",
            "|     120 | Arlott         |   1.22%   |  48.67%  |    3.28% |      X.Borg,Esmeralda,Cici,Suyou,Uranus      |\n",
            "|     119 | Novaria        |   0.23%   |  45.62%  |    0.05% |      Gloo,Carmilla,Leomord,Ixia,Kadita       |\n",
            "|     118 | Joy            |   0.31%   |  51.08%  |    0.32% |      Natalia,X.Borg,Gord,Lapu-Lapu,Sun       |\n",
            "|     117 | Fredrinn       |   0.13%   |  49.73%  |    0.07% |      Cyclops,Zilong,Masha,Eudora,Saber       |\n",
            "|     116 | Julian         |   1.48%   |  51.32%  |    8.87% |     Uranus,Faramis,Aldous,Cyclops,Estes      |\n",
            "|     115 | Xavier         |   0.97%   |  49.27%  |    0.14% |   Barats,Belerick,Faramis,Vexana,Minotaur    |\n",
            "|     114 | Melissa        |   0.73%   |  52.30%  |    0.56% |   Alucard,Hilda,Sun,Faramis,Popol and Kupa   |\n",
            "|     113 | Yin            |   0.41%   |  47.92%  |    1.04% |        Floryn,Yve,Estes,Faramis,Bane         |\n",
            "|     112 | Floryn         |   0.71%   |  54.70%  |    2.65% |    Alice,Faramis,X.Borg,Carmilla,Balmond     |\n",
            "|     111 | Edith          |   1.20%   |  53.95%  |    3.37% |   Alice,Esmeralda,Eudora,Lapu-Lapu,Johnson   |\n",
            "|     110 | Valentina      |   0.80%   |  47.45%  |    0.26% |      Atlas,Carmilla,Grock,Lylia,X.Borg       |\n",
            "|     109 | Aamon          |   0.29%   |  49.12%  |    0.16% |    Zilong,Uranus,Karina,Yi Sun-shin,Ling     |\n",
            "|     108 | Aulus          |   0.11%   |  48.87%  |    0.04% |     Uranus,Faramis,Kadita,Leomord,Angela     |\n",
            "|     107 | Natan          |   1.81%   |  53.50%  |    2.57% |        Barats,Sun,Atlas,X.Borg,Zhask         |\n",
            "|     106 | Phoveus        |   1.20%   |  55.08%  |   70.30% |    Khaleed,Valentina,Hilda,Kagura,Alucard    |\n",
            "|     105 | Beatrix        |   0.77%   |  46.60%  |    0.05% |      Diggie,Barats,Minotaur,Miya,Hanabi      |\n",
            "|     104 | Gloo           |   0.14%   |  50.46%  |    0.13% |        Pharsa,Hanzo,Gord,Karina,Aamon        |\n",
            "|     103 | Paquito        |   0.44%   |  43.77%  |    0.07% |    X.Borg,Rafaela,Aulus,Guinevere,Luo Yi     |\n",
            "|     102 | Mathilda       |   1.10%   |  52.91%  |   12.65% |     Atlas,Alice,X.Borg,Carmilla,Terizla      |\n",
            "|     101 | Yve            |   0.26%   |  52.28%  |    0.05% |       Lolita,Vale,Hanabi,Karina,X.Borg       |\n",
            "|     100 | Brody          |   0.78%   |  48.63%  |    0.09% |    Natalia,Baxia,Belerick,Karina,Irithel     |\n",
            "|      99 | Barats         |   0.15%   |  48.07%  |    0.05% |    Silvanna,Alucard,Eudora,Johnson,Harley    |\n",
            "|      98 | Khaleed        |   2.31%   |  56.21%  |   25.01% |          Sun,Yve,X.Borg,Atlas,Baxia          |\n",
            "|      97 | Benedetta      |   0.82%   |  48.61%  |    0.25% |      Hanzo,Atlas,X.Borg,Carmilla,Alpha       |\n",
            "|      96 | Luo Yi         |   0.47%   |  49.73%  |    0.14% | Estes,Barats,Fredrinn,Popol and Kupa,Faramis |\n",
            "|      95 | Yu Zhong       |   1.29%   |  48.39%  |    0.45% |  Popol and Kupa,Fredrinn,Hilda,Badang,Aulus  |\n",
            "|      94 | Popol and Kupa |   0.51%   |  53.40%  |    0.57% |        Harley,Yin,Selena,Masha,Eudora        |\n",
            "|      93 | Atlas          |   0.47%   |  45.71%  |    0.49% |       Aulus,Estes,Aamon,Layla,Cyclops        |\n",
            "|      92 | Carmilla       |   0.76%   |  52.32%  |    3.02% |    Popol and Kupa,Barats,Aulus,Estes,Miya    |\n",
            "|      91 | Cecilion       |   2.32%   |  52.89%  |    4.76% |      Lolita,Barats,Baxia,Hanabi,Diggie       |\n",
            "|      90 | Silvanna       |   0.16%   |  45.79%  |    0.02% |       Rafaela,Uranus,Estes,Freya,Saber       |\n",
            "|      89 | Wanwan         |   1.27%   |  55.46%  |    5.19% |      Atlas,Yin,Ixia,Silvanna,Guinevere       |\n",
            "|      88 | Masha          |   0.19%   |  54.56%  |    0.26% |    Guinevere,Aldous,Yu Zhong,Hanzo,Fanny     |\n",
            "|      87 | Baxia          |   0.03%   |  46.38%  |    0.02% |       Kaja,Leomord,Hilda,Thamuz,Uranus       |\n",
            "|      86 | Lylia          |   0.61%   |  48.22%  |    0.09% |     Barats,Alice,Terizla,Natalia,Hanabi      |\n",
            "|      85 | Dyrroth        |   0.47%   |  45.23%  |    0.13% |     Uranus,Natalia,Alucard,Aamon,Aldous      |\n",
            "|      84 | Ling           |   2.22%   |  49.53%  |   74.29% |         Hanzo,Valir,Gloo,Atlas,Gord          |\n",
            "|      83 | X.Borg         |   0.59%   |  45.83%  |    0.18% |     Baxia,Barats,Martis,Balmond,Carmilla     |\n",
            "|      82 | Terizla        |   1.36%   |  49.28%  |    2.02% |      Silvanna,Sun,Badang,Zilong,Eudora       |\n",
            "|      81 | Esmeralda      |   0.27%   |  40.58%  |    0.13% |       Hanzo,Lolita,Hanabi,Natalia,Vale       |\n",
            "|      80 | Guinevere      |   0.19%   |  44.87%  |    0.03% |         Rafaela,Freya,Kaja,Hilda,Yve         |\n",
            "|      79 | Granger        |   0.45%   |  46.69%  |    0.06% |        Baxia,Balmond,Kaja,Bane,Alice         |\n",
            "|      78 | Khufra         |   1.02%   |  50.26%  |    1.12% |       Baxia,Alucard,Dyrroth,Eudora,Yin       |\n",
            "|      77 | Badang         |   0.13%   |  47.72%  |    0.03% |      Rafaela,Hilda,Zilong,Natalia,Masha      |\n",
            "|      76 | Faramis        |   0.37%   |  53.05%  |    0.28% |       Gloo,Sun,Guinevere,Atlas,Wanwan        |\n",
            "|      75 | Kadita         |   0.26%   |  45.98%  |    0.04% |       Baxia,Hanzo,Rafaela,Johnson,Gord       |\n",
            "|      74 | Minsitthar     |   0.54%   |  48.79%  |    3.42% |      Freya,Martis,Alucard,Hilda,Phoveus      |\n",
            "|      73 | Harith         |   0.86%   |  50.65%  |    0.40% |      Helcurt,Lolita,Uranus,Atlas,Baxia       |\n",
            "|      72 | Thamuz         |   0.26%   |  45.94%  |    0.03% |     Barats,Fredrinn,Badang,Alucard,Saber     |\n",
            "|      71 | Kimmy          |   0.19%   |  44.82%  |    0.04% |       Baxia,Hanzo,Leomord,Freya,Vexana       |\n",
            "|      70 | Belerick       |   0.58%   |  47.65%  |    3.67% |       Miya,Melissa,Aamon,Hanabi,Aulus        |\n",
            "|      69 | Hanzo          |   0.14%   |  41.87%  |    0.25% |          Diggie,Baxia,Yve,Ixia,Gord          |\n",
            "|      68 | Lunox          |   1.35%   |  49.86%  |    1.61% |       Esmeralda,Hanzo,Atlas,Joy,Harley       |\n",
            "|      67 | Leomord        |   0.25%   |  48.50%  |    0.06% |      Badang,Saber,Belerick,Layla,Eudora      |\n",
            "|      66 | Vale           |   0.27%   |  47.33%  |    0.03% |        Badang,Aamon,Gord,Freya,Odette        |\n",
            "|      65 | Claude         |   1.70%   |  46.11%  |    0.39% |        Melissa,Gord,Yve,Lolita,Atlas         |\n",
            "|      64 | Aldous         |   0.25%   |  47.78%  |    0.09% |     Hanzo,Helcurt,Xavier,Lapu-Lapu,Fanny     |\n",
            "|      63 | Selena         |   0.33%   |  43.86%  |    0.12% |      Hanzo,Balmond,Ixia,Diggie,Carmilla      |\n",
            "|      62 | Kaja           |   0.17%   |  49.53%  |    0.08% |       Hilda,Barats,Valir,Atlas,Wanwan        |\n",
            "|      61 | Chang'e        |   1.16%   |  47.67%  |    0.48% |      Hanzo,Diggie,Selena,Masha,Novaria       |\n",
            "|      60 | Hanabi         |   0.65%   |  45.02%  |    0.18% | Popol and Kupa,Saber,Cyclops,Jawhead,Eudora  |\n",
            "|      59 | Uranus         |   0.11%   |  44.54%  |    0.03% |  Diggie,Thamuz,Phoveus,Yi Sun-shin,Johnson   |\n",
            "|      58 | Martis         |   0.45%   |  46.78%  |    0.15% |   Eudora,Silvanna,Johnson,Natalia,Jawhead    |\n",
            "|      57 | Valir          |   0.30%   |  45.04%  |    0.15% |    Baxia,Balmond,Silvanna,Alucard,Barats     |\n",
            "|      56 | Gusion         |   0.61%   |  44.52%  |    0.21% |      Hanzo,Aulus,Balmond,Aamon,Natalia       |\n",
            "|      55 | Angela         |   2.19%   |  51.36%  |   11.14% |    Carmilla,Alice,Balmond,Novaria,X.Borg     |\n",
            "|      54 | Jawhead        |   0.32%   |  48.00%  |    0.07% |      Fredrinn,Baxia,Novaria,Kaja,Hilda       |\n",
            "|      53 | Lesley         |   1.23%   |  45.11%  |    0.33% |  Belerick,Claude,Gatotkaca,Natalia,Phoveus   |\n",
            "|      52 | Pharsa         |   0.21%   |  45.53%  |    0.03% |   Badang,Lolita,Rafaela,Guinevere,Melissa    |\n",
            "|      51 | Helcurt        |   0.38%   |  49.55%  |    1.94% |        Hanzo,Baxia,Layla,Bane,Granger        |\n",
            "|      50 | Zhask          |   1.20%   |  51.46%  |   13.95% |       Lolita,Zhuxin,Kaja,Saber,Harley        |\n",
            "|      49 | Hylos          |   1.50%   |  51.73%  |   24.79% |       Eudora,Fredrinn,Miya,Saber,Nana        |\n",
            "|      48 | Diggie         |   0.37%   |  57.19%  |    9.89% |      Zhuxin,Alice,Badang,Silvanna,Alpha      |\n",
            "|      47 | Lancelot       |   0.90%   |  42.28%  |    0.23% |       Atlas,Gloo,Lolita,Johnson,Hanabi       |\n",
            "|      46 | Odette         |   0.40%   |  49.15%  |    0.06% |        Baxia,Yve,Aamon,Cyclops,Masha         |\n",
            "|      45 | Argus          |   0.79%   |  52.50%  |    4.99% |      Hanzo,Saber,Guinevere,Karrie,Aamon      |\n",
            "|      44 | Grock          |   0.40%   |  47.05%  |    0.14% |  Baxia,Valir,Silvanna,Atlas,Popol and Kupa   |\n",
            "|      43 | Irithel        |   0.45%   |  50.08%  |    0.04% |   Wanwan,Badang,Argus,Benedetta,Minsitthar   |\n",
            "|      42 | Harley         |   0.37%   |  47.20%  |    0.44% |          Hanzo,Gord,Yve,Cici,Xavier          |\n",
            "|      41 | Gatotkaca      |   2.38%   |  54.20%  |   39.15% |       Odette,Miya,Eudora,Zilong,Pharsa       |\n",
            "|      40 | Karrie         |   0.78%   |  44.37%  |    0.15% |        Baxia,Akai,Gloo,Alice,Balmond         |\n",
            "|      39 | Roger          |   1.78%   |  46.65%  |    8.33% |      Harley,Eudora,Helcurt,Aamon,Gusion      |\n",
            "|      38 | Vexana         |   2.27%   |  52.37%  |    1.71% |       Gloo,Hayabusa,Baxia,Zhask,Lolita       |\n",
            "|      37 | Lapu-Lapu      |   0.29%   |  45.13%  |    0.02% |       Badang,Argus,Hanabi,Estes,Clint        |\n",
            "|      36 | Aurora         |   2.75%   |  51.71%  |   27.82% |      Lolita,Odette,Alucard,Aulus,Karina      |\n",
            "|      35 | Hilda          |   0.14%   |  46.60%  |    0.06% |      Hanzo,Granger,Nolan,Zilong,Diggie       |\n",
            "|      34 | Estes          |   0.21%   |  45.20%  |    1.00% |    Cyclops,Barats,Yi Sun-shin,Lesley,Cici    |\n",
            "|      33 | Cyclops        |   0.26%   |  47.56%  |    0.05% |       Natalia,Fanny,Joy,Wanwan,Claude        |\n",
            "|      32 | Johnson        |   0.36%   |  43.76%  |    0.33% |      Hanzo,Zilong,Layla,Saber,Guinevere      |\n",
            "|      31 | Moskov         |   1.33%   |  50.70%  |    0.26% |         Hanzo,Gloo,Yve,Joy,Esmeralda         |\n",
            "|      30 | Yi Sun-shin    |   1.48%   |  55.91%  |    3.04% |   Kadita,Benedetta,Selena,Diggie,Guinevere   |\n",
            "|      29 | Ruby           |   2.42%   |  52.88%  |   55.91% |       Sun,Masha,Gusion,Silvanna,Argus        |\n",
            "|      28 | Alpha          |   1.47%   |  48.56%  |    0.50% |      Phoveus,Hilda,Alucard,Barats,Saber      |\n",
            "|      27 | Sun            |   0.46%   |  48.20%  |    0.86% |     Masha,Hanzo,Lesley,Jawhead,Mathilda      |\n",
            "|      26 | Chou           |   1.32%   |  46.64%  |    0.45% |        Hanzo,Baxia,X.Borg,Gord,Freya         |\n",
            "|      25 | Kagura         |   0.77%   |  48.31%  |    0.16% |     Hanzo,Baxia,Guinevere,Badang,Lolita      |\n",
            "|      24 | Natalia        |   0.26%   |  48.28%  |    1.77% |      Hanzo,Gord,Xavier,Ling,Minsitthar       |\n",
            "|      23 | Gord           |   0.16%   |  46.74%  |    0.04% |      Aulus,Ixia,Brody,Fredrinn,Phoveus       |\n",
            "|      22 | Freya          |   0.64%   |  56.04%  |   26.68% |     Faramis,Diggie,Mathilda,Harith,Estes     |\n",
            "|      21 | Hayabusa       |   1.45%   |  48.39%  |   79.53% |       Hanzo,Aamon,Granger,Gord,Zhuxin        |\n",
            "|      20 | Lolita         |   0.38%   |  55.14%  |    5.18% |     Granger,Cyclops,Valir,Chang'e,Bruno      |\n",
            "|      19 | Minotaur       |   0.57%   |  50.63%  |    0.45% |     Baxia,Johnson,Karina,Silvanna,Lolita     |\n",
            "|      18 | Layla          |   0.55%   |  46.81%  |    0.50% |       Diggie,Bruno,Rafaela,Wanwan,Kaja       |\n",
            "|      17 | Fanny          |   1.36%   |  46.07%  |   53.88% |         Baxia,Hanzo,Gloo,Lolita,Yve          |\n",
            "|      16 | Zilong         |   0.28%   |  44.62%  |    0.21% |      Hanzo,X.Borg,Rafaela,Fanny,Novaria      |\n",
            "|      15 | Eudora         |   0.47%   |  47.58%  |    0.67% |     Hanzo,Natalia,Zilong,Rafaela,Irithel     |\n",
            "|      14 | Rafaela        |   0.12%   |  48.84%  |    0.08% |      Natalia,Uranus,Fredrinn,Hilda,Kaja      |\n",
            "|      13 | Clint          |   0.66%   |  47.72%  |    0.08% |      Belerick,Lolita,Freya,Bruno,Aamon       |\n",
            "|      12 | Bruno          |   1.11%   |  53.76%  |    0.20% |      Wanwan,Alice,Angela,Aulus,Mathilda      |\n",
            "|      11 | Bane           |   1.47%   |  55.65%  |    1.49% |     Belerick,Khufra,Fanny,Zhask,Faramis      |\n",
            "|      10 | Franco         |   1.94%   |  45.77%  |    4.82% |      Diggie,Freya,Angela,Fanny,Mathilda      |\n",
            "|       9 | Akai           |   0.66%   |  47.95%  |    0.51% |      Yin,Guinevere,Vale,Eudora,Silvanna      |\n",
            "|       8 | Karina         |   0.30%   |  45.28%  |    0.23% |      Baxia,Zilong,Hanzo,Natalia,Helcurt      |\n",
            "|       7 | Alucard        |   0.81%   |  51.07%  |    0.46% |   Hanzo,Rafaela,Yi Sun-shin,Saber,Mathilda   |\n",
            "|       6 | Tigreal        |   2.24%   |  46.80%  |   12.28% |     Silvanna,Alucard,Eudora,Freya,Lolita     |\n",
            "|       5 | Nana           |   0.65%   |  42.43%  |    0.56% |        Aulus,Odette,Saber,Estes,Freya        |\n",
            "|       4 | Alice          |   0.82%   |  52.25%  |   69.73% |    Johnson,Atlas,Esmeralda,Faramis,Karina    |\n",
            "|       3 | Saber          |   0.51%   |  48.75%  |   19.49% |      Hanzo,Natalia,Yve,Nolan,Benedetta       |\n",
            "|       2 | Balmond        |   0.26%   |  41.55%  |    0.14% |       Natalia,Vale,Barats,Baxia,Zhask        |\n",
            "|       1 | Miya           |   1.74%   |  53.12%  |    5.92% |       Saber,Guinevere,Sun,Freya,Moskov       |\n",
            "+---------+----------------+-----------+----------+----------+----------------------------------------------+\n"
          ]
        }
      ],
      "source": [
        "def main():\n",
        "    day_filter               = \"7\" # 1 day, 3 days, 7 days, 15 days, 30 days\n",
        "    rank_filter              = \"honor\" # all, epic, legend, mythic, honor, glory\n",
        "    page_size                = 126 # 1 - 126\n",
        "    page_index               = 1\n",
        "    type_rate, rate          = \"win_rate\", 0\n",
        "    sorts_field, sorts_order = \"main_heroid\", \"desc\"\n",
        "\n",
        "\n",
        "    filter_factory = FilterFactory.create_filter(day_filter, rank_filter, page_size, page_index, sorts_field, sorts_order)\n",
        "\n",
        "    if filter_factory:\n",
        "        data = filter_factory.fetch_data()\n",
        "        if data:\n",
        "            table = create_hero_table(data, {type_rate: rate})\n",
        "            print(table)\n",
        "        else:\n",
        "            print(\"Failed to retrieve data.\")\n",
        "    else:\n",
        "        print(\"Invalid filter type.\")\n",
        "\n",
        "if __name__ == \"__main__\":\n",
        "    main()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "x-jJTgBwnWLl"
      },
      "source": [
        "## hero best with, strong against, weak against"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 4,
      "metadata": {
        "id": "xPxhwAcEnarn"
      },
      "outputs": [],
      "source": [
        "class HeroFilterAPI:\n",
        "    def __init__(self, url: str, payload: Dict):\n",
        "        self.url = url\n",
        "        self.payload = payload\n",
        "\n",
        "    def fetch_data(self) -> Optional[Dict]:\n",
        "        try:\n",
        "            response = requests.post(self.url, json=self.payload)\n",
        "            response.raise_for_status()\n",
        "            return response.json()\n",
        "        except requests.exceptions.RequestException as e:\n",
        "            print(f\"An error occurred: {e}\")\n",
        "            return None\n",
        "\n",
        "class HeroFilterFactory:\n",
        "    @staticmethod\n",
        "    def hero_create_filter(sortid_values: List[int], roadsort_values: List[int], page_size: int, page_index: int, sorts_field: str, sorts_order: str) -> FilterAPI:\n",
        "        \"\"\"\n",
        "        Create a FilterAPI object based on the provided filter parameters.\n",
        "        Args:\n",
        "          sortid_values: List of integers representing sort IDs.\n",
        "          roadsort_values: List of integers representing roadsort values.\n",
        "          page_size: 1 - 126\n",
        "          page_index: 1 - 126\n",
        "          sorts_field: field name to sort by.\n",
        "          sorts_order: asc, desc\n",
        "\n",
        "        Returns:\n",
        "          FilterAPI object.\n",
        "        \"\"\"\n",
        "        url = \"https://api.gms.moontontech.com/api/gms/source/2669606/2681577\"\n",
        "        url_2 = \"https://api.gms.moontontech.com/api/gms/source/2669606/2756564\"\n",
        "\n",
        "        payload = {\n",
        "            \"pageSize\": page_size,\n",
        "            \"filters\": [\n",
        "                {\"field\": \"sortid\", \"operator\": \"hasAnyOf\", \"value\": sortid_values},\n",
        "                {\"field\": \"roadsort\", \"operator\": \"hasAnyOf\", \"value\": roadsort_values}\n",
        "            ],\n",
        "            \"sorts\": [{\"data\": {\"field\": sorts_field, \"order\": sorts_order}, \"type\": \"sequence\"}],\n",
        "            \"pageIndex\": page_index,\n",
        "            \"fields\": [\"roadsort\", \"channel\", \"sortid\", \"smallmap\", \"name\", \"heroid\"]\n",
        "        }\n",
        "\n",
        "        payload_2 = {\n",
        "            \"pageSize\": page_size,\n",
        "            \"filters\": [\n",
        "                { \"field\": \"<hero.data.sortid>\", \"operator\": \"hasAnyOf\", \"value\": sortid_values },\n",
        "                { \"field\": \"<hero.data.roadsort>\", \"operator\": \"hasAnyOf\", \"value\": roadsort_values }\n",
        "            ],\n",
        "            \"sorts\": [{ \"data\": { \"field\": sorts_field, \"order\": sorts_order }, \"type\": \"sequence\" }],\n",
        "            \"pageIndex\": page_index,\n",
        "            \"fields\": [\"id\", \"hero_id\", \"hero.data.name\", \"hero.data.smallmap\", \"hero.data.sortid\", \"hero.data.roadsort\"],\n",
        "            \"object\": []\n",
        "        }\n",
        "\n",
        "        return FilterAPI(url=url_2, payload=payload_2)\n",
        "\n",
        "def hero_create_hero_table(data: Dict) -> PrettyTable:\n",
        "    table = PrettyTable()\n",
        "    table.field_names = [\n",
        "        \"Hero ID\",\n",
        "        \"Hero Name\",\n",
        "        \"Best With\",\n",
        "        \"Strong Against\",\n",
        "        \"Weak Against\",\n",
        "        \"Desc Best With\",\n",
        "        \"Desc Strong Against\",\n",
        "        \"Desc Weak Against\",\n",
        "    ]\n",
        "    table.align[\"Hero ID\"] = \"r\"\n",
        "    table.align[\"Hero Name\"] = \"l\"\n",
        "\n",
        "    table.align[\"Desc Best With\"] = \"l\"\n",
        "    table.align[\"Desc Strong Against\"] = \"l\"\n",
        "    table.align[\"Desc Weak Against\"] = \"l\"\n",
        "    table.right_padding_width = 1\n",
        "\n",
        "    hero_name_dict = {\n",
        "        126: \"Suyou\",\n",
        "        125: \"Zhuxin\",\n",
        "        124: \"Chip\",\n",
        "        123: \"Cici\",\n",
        "        122: \"Nolan\",\n",
        "        121: \"Ixia\",\n",
        "        120: \"Arlott\",\n",
        "        119: \"Novaria\",\n",
        "        118: \"Joy\",\n",
        "        117: \"Fredrinn\",\n",
        "        116: \"Julian\",\n",
        "        115: \"Xavier\",\n",
        "        114: \"Melissa\",\n",
        "        113: \"Yin\",\n",
        "        112: \"Floryn\",\n",
        "        111: \"Edith\",\n",
        "        110: \"Valentina\",\n",
        "        109: \"Aamon\",\n",
        "        108: \"Aulus\",\n",
        "        107: \"Natan\",\n",
        "        106: \"Phoveus\",\n",
        "        105: \"Beatrix\",\n",
        "        104: \"Gloo\",\n",
        "        103: \"Paquito\",\n",
        "        102: \"Mathilda\",\n",
        "        101: \"Yve\",\n",
        "        100: \"Brody\",\n",
        "        99: \"Barats\",\n",
        "        98: \"Khaleed\",\n",
        "        97: \"Benedetta\",\n",
        "        96: \"Luo Yi\",\n",
        "        95: \"Yu Zhong\",\n",
        "        94: \"Popol and Kupa\",\n",
        "        93: \"Atlas\",\n",
        "        92: \"Carmilla\",\n",
        "        91: \"Cecilion\",\n",
        "        90: \"Silvanna\",\n",
        "        89: \"Wanwan\",\n",
        "        88: \"Masha\",\n",
        "        87: \"Baxia\",\n",
        "        86: \"Lylia\",\n",
        "        85: \"Dyrroth\",\n",
        "        84: \"Ling\",\n",
        "        83: \"X.Borg\",\n",
        "        82: \"Terizla\",\n",
        "        81: \"Esmeralda\",\n",
        "        80: \"Guinevere\",\n",
        "        79: \"Granger\",\n",
        "        78: \"Khufra\",\n",
        "        77: \"Badang\",\n",
        "        76: \"Faramis\",\n",
        "        75: \"Kadita\",\n",
        "        74: \"Minsitthar\",\n",
        "        73: \"Harith\",\n",
        "        72: \"Thamuz\",\n",
        "        71: \"Kimmy\",\n",
        "        70: \"Belerick\",\n",
        "        69: \"Hanzo\",\n",
        "        68: \"Lunox\",\n",
        "        67: \"Leomord\",\n",
        "        66: \"Vale\",\n",
        "        65: \"Claude\",\n",
        "        64: \"Aldous\",\n",
        "        63: \"Selena\",\n",
        "        62: \"Kaja\",\n",
        "        61: \"Chang'e\",\n",
        "        60: \"Hanabi\",\n",
        "        59: \"Uranus\",\n",
        "        58: \"Martis\",\n",
        "        57: \"Valir\",\n",
        "        56: \"Gusion\",\n",
        "        55: \"Angela\",\n",
        "        54: \"Jawhead\",\n",
        "        53: \"Lesley\",\n",
        "        52: \"Pharsa\",\n",
        "        51: \"Helcurt\",\n",
        "        50: \"Zhask\",\n",
        "        49: \"Hylos\",\n",
        "        48: \"Diggie\",\n",
        "        47: \"Lancelot\",\n",
        "        46: \"Odette\",\n",
        "        45: \"Argus\",\n",
        "        44: \"Grock\",\n",
        "        43: \"Irithel\",\n",
        "        42: \"Harley\",\n",
        "        41: \"Gatotkaca\",\n",
        "        40: \"Karrie\",\n",
        "        39: \"Roger\",\n",
        "        38: \"Vexana\",\n",
        "        37: \"Lapu-Lapu\",\n",
        "        36: \"Aurora\",\n",
        "        35: \"Hilda\",\n",
        "        34: \"Estes\",\n",
        "        33: \"Cyclops\",\n",
        "        32: \"Johnson\",\n",
        "        31: \"Moskov\",\n",
        "        30: \"Yi Sun-shin\",\n",
        "        29: \"Ruby\",\n",
        "        28: \"Alpha\",\n",
        "        27: \"Sun\",\n",
        "        26: \"Chou\",\n",
        "        25: \"Kagura\",\n",
        "        24: \"Natalia\",\n",
        "        23: \"Gord\",\n",
        "        22: \"Freya\",\n",
        "        21: \"Hayabusa\",\n",
        "        20: \"Lolita\",\n",
        "        19: \"Minotaur\",\n",
        "        18: \"Layla\",\n",
        "        17: \"Fanny\",\n",
        "        16: \"Zilong\",\n",
        "        15: \"Eudora\",\n",
        "        14: \"Rafaela\",\n",
        "        13: \"Clint\",\n",
        "        12: \"Bruno\",\n",
        "        11: \"Bane\",\n",
        "        10: \"Franco\",\n",
        "        9: \"Akai\",\n",
        "        8: \"Karina\",\n",
        "        7: \"Alucard\",\n",
        "        6: \"Tigreal\",\n",
        "        5: \"Nana\",\n",
        "        4: \"Alice\",\n",
        "        3: \"Saber\",\n",
        "        2: \"Balmond\",\n",
        "        1: \"Miya\"\n",
        "    }\n",
        "\n",
        "    # print(hero_name_dict)\n",
        "    # print(data)\n",
        "\n",
        "    datas = data['data']['records']\n",
        "\n",
        "    for record in datas:\n",
        "        hero_data = record['data'] # data/records/data\n",
        "        # relation = hero_data['channel']['data']['relation'] old\n",
        "        relation = hero_data['relation']\n",
        "\n",
        "        strong_against = ', '.join([hero_name_dict.get(hero_id, \"Unknown\") for hero_id in relation['strong']['target_hero_id']])\n",
        "        weak_against = ', '.join([hero_name_dict.get(hero_id, \"Unknown\") for hero_id in relation['weak']['target_hero_id']])\n",
        "        best_with = ', '.join([hero_name_dict.get(hero_id, \"Unknown\") for hero_id in relation['assist']['target_hero_id']])\n",
        "\n",
        "        # desc_strong_against = relation['strong']['desc']\n",
        "        # desc_weak_against = relation['weak']['desc'] old\n",
        "        # desc_best_with = relation['assist']['desc']\n",
        "\n",
        "        desc_strong_against = relation['strong']\n",
        "        desc_weak_against = relation['weak']\n",
        "        desc_best_with = relation['assist']\n",
        "\n",
        "        table.add_row([\n",
        "            hero_data['hero_id'], # data/records/data/hero_id\n",
        "            hero_data['hero']['data']['name'], \n",
        "            best_with,\n",
        "            strong_against,\n",
        "            weak_against,\n",
        "            desc_best_with['target_hero_id'],\n",
        "            desc_strong_against['target_hero_id'],\n",
        "            desc_weak_against['target_hero_id'],\n",
        "        ])\n",
        "\n",
        "    return table"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 5,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "TZ557YaSMPi8",
        "outputId": "e7993b2b-6fb0-4a8b-a6e8-cee16667a8fd"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "+---------+----------------+-------------------------------+-----------------------------------------+----------------------------------------+----------------+---------------------+-------------------+\n",
            "| Hero ID | Hero Name      |           Best With           |              Strong Against             |              Weak Against              | Desc Best With | Desc Strong Against | Desc Weak Against |\n",
            "+---------+----------------+-------------------------------+-----------------------------------------+----------------------------------------+----------------+---------------------+-------------------+\n",
            "|     126 | Suyou          |        Rafaela, Tigreal       |               Ixia, Xavier              |            Melissa, Badang             | [14, 6]        | [121, 115]          | [114, 77]         |\n",
            "|     125 | Zhuxin         |     Cici, Kimmy, Belerick     |         Cyclops, Popol and Kupa         |              Saber, Fanny              | [123, 71, 70]  | [33, 94]            | [3, 17]           |\n",
            "|      61 | Chang'e        |  Gatotkaca, Tigreal, Unknown  |     Eudora, Odette, Unknown, Unknown    |    Hanzo, Harley, Unknown, Unknown     | [41, 6, 0]     | [15, 46, 0, 0]      | [69, 42, 0, 0]    |\n",
            "|       2 | Balmond        |    Angela, Rafaela, Unknown   |          Layla, Eudora, Unknown         |        Lesley, Irithel, Unknown        | [55, 14, 0]    | [18, 15, 0]         | [53, 43, 0]       |\n",
            "|       1 | Miya           |   Tigreal, Belerick, Unknown  |            Saber, Eudora, Sun           |          Pharsa, Yve, Unknown          | [6, 70, 0]     | [3, 15, 27]         | [52, 101, 0]      |\n",
            "|       4 | Alice          |   Balmond, Dyrroth, Unknown   |        Cecilion, Chang'e, Unknown       |         Baxia, Martis, Unknown         | [2, 85, 0]     | [91, 61, 0]         | [87, 58, 0]       |\n",
            "|       5 | Nana           |    Rafaela, Franco, Unknown   |         Eudora, Kadita, Unknown         |        Zilong, Natalia, Unknown        | [14, 10, 0]    | [15, 75, 0]         | [16, 24, 0]       |\n",
            "|       6 | Tigreal        |    Vexana, Odette, Unknown    |          Zilong, Freya, Unknown         |        Chang'e, Zhask, Unknown         | [38, 46, 0]    | [16, 22, 0]         | [61, 50, 0]       |\n",
            "|       7 | Alucard        |   Gatotkaca, Xavier, Unknown  |          Harley, Aamon, Unknown         |        Franco, Johnson, Unknown        | [41, 115, 0]   | [42, 109, 0]        | [10, 32, 0]       |\n",
            "|       8 | Karina         |   Tigreal, Faramis, Unknown   |          Layla, Hanabi, Unknown         |         Akai, Khufra, Unknown          | [6, 76, 0]     | [18, 60, 0]         | [9, 78, 0]        |\n",
            "|       9 | Akai           |     Saber, Eudora, Unknown    |         Eudora, Odette, Unknown         |         Nana, Diggie, Unknown          | [3, 15, 0]     | [15, 46, 0]         | [5, 48, 0]        |\n",
            "|      12 | Bruno          |         Franco, Khufra        |               Hanabi, Miya              |          Gatotkaca, Fredrinn           | [10, 78]       | [60, 1]             | [41, 117]         |\n",
            "|      11 | Bane           |        Tigreal, Luo Yi        |             Hylos, Belerick             |              Vale, Xavier              | [6, 96]        | [49, 70]            | [66, 115]         |\n",
            "|      13 | Clint          |        Rafaela, Angela        |               Moskov, Miya              |            Melissa, Karrie             | [14, 55]       | [31, 1]             | [114, 40]         |\n",
            "|      17 | Fanny          |      Minotaur, Gatotkaca      |             Karrie, Irithel             |              Kaja, Khufra              | [19, 41]       | [40, 43]            | [62, 78]          |\n",
            "|      18 | Layla          |      Minsitthar, Belerick     |            Tigreal, Belerick            |              Karina, Ling              | [74, 70]       | [6, 70]             | [8, 84]           |\n",
            "|      19 | Minotaur       |        Granger, Melissa       |             Paquito, Julian             |             Layla, Lesley              | [79, 114]      | [103, 116]          | [18, 53]          |\n",
            "|      20 | Lolita         |         Hanabi, Layla         |              Kimmy, Cyclops             |             Ling, Paquito              | [60, 18]       | [71, 33]            | [84, 103]         |\n",
            "|      22 | Freya          |      Belerick, Gatotkaca      |               Uranus, Gloo              |           Guinevere, Martis            | [70, 41]       | [59, 104]           | [80, 58]          |\n",
            "|      23 | Gord           |        Hylos, Belerick        |             Barats, Fredrinn            |            Fanny, Lancelot             | [49, 70]       | [99, 117]           | [17, 47]          |\n",
            "|      25 | Kagura         |         Atlas, Tigreal        |              Layla, Eudora              |              Joy, Martis               | [93, 6]        | [18, 15]            | [118, 58]         |\n",
            "|      26 | Chou           |        Angela, Rafaela        |              Terizla, Alpha             |             Lesley, Pharsa             | [55, 14]       | [82, 28]            | [53, 52]          |\n",
            "|      27 | Sun            |   Belerick, Tigreal, Unknown  |   Franco, Gatotkaca, Unknown, Unknown   |    Ruby, Unknown, Unknown, Unknown     | [70, 6, 0]     | [10, 41, 0, 0]      | [29, 0, 0, 0]     |\n",
            "|      28 | Alpha          |    Vexana, Selena, Unknown    |      Layla, Ixia, Unknown, Unknown      |     Chou, Gusion, Unknown, Unknown     | [38, 63, 0]    | [18, 121, 0, 0]     | [26, 56, 0, 0]    |\n",
            "|      29 | Ruby           |    Pharsa, Kadita, Unknown    |   Aldous, Guinevere, Unknown, Unknown   |   Wanwan, Irithel, Unknown, Unknown    | [52, 75, 0]    | [64, 80, 0, 0]      | [89, 43, 0, 0]    |\n",
            "|      30 | Yi Sun-shin    |    Alpha, Khaleed, Unknown    |    Uranus, Terizla, Unknown, Unknown    |     Franco, Kaja, Unknown, Unknown     | [28, 98, 0]    | [59, 82, 0, 0]      | [10, 62, 0, 0]    |\n",
            "|      31 | Moskov         |  Fredrinn, Gatotkaca, Unknown |    Thamuz, Balmond, Unknown, Unknown    |  Lancelot, Natalia, Unknown, Unknown   | [117, 41, 0]   | [72, 2, 0, 0]       | [47, 24, 0, 0]    |\n",
            "|      32 | Johnson        |    Odette, Kadita, Unknown    |    Alucard, Zilong, Unknown, Unknown    |    Harith, Kagura, Unknown, Unknown    | [46, 75, 0]    | [7, 16, 0, 0]       | [73, 25, 0, 0]    |\n",
            "|      34 | Estes          |    Lesley, Hanabi, Unknown    |      Valir, Alice, Unknown, Unknown     |    Saber, Eudora, Unknown, Unknown     | [53, 60, 0]    | [57, 4, 0, 0]       | [3, 15, 0, 0]     |\n",
            "|      35 | Hilda          |    Rafaela, Franco, Unknown   |     Zilong, Layla, Unknown, Unknown     |    Thamuz, Uranus, Unknown, Unknown    | [14, 10, 0]    | [16, 18, 0, 0]      | [72, 59, 0, 0]    |\n",
            "|      37 | Lapu-Lapu      |    Tigreal, Atlas, Unknown    |     Layla, Eudora, Unknown, Unknown     |    Lesley, Moskov, Unknown, Unknown    | [6, 93, 0]     | [18, 15, 0, 0]      | [53, 31, 0, 0]    |\n",
            "|      38 | Vexana         |    Atlas, Beatrix, Unknown    |     Layla, Irithel, Xavier, Unknown     |     Saber, Aamon, Karina, Unknown      | [93, 105, 0]   | [18, 43, 115, 0]    | [3, 109, 8, 0]    |\n",
            "|      39 | Roger          |    Pharsa, Vexana, Unknown    |     Hanabi, Odette, Unknown, Unknown    |  Minsitthar, Khufra, Unknown, Unknown  | [52, 38, 0]    | [60, 46, 0, 0]      | [74, 78, 0, 0]    |\n",
            "|      40 | Karrie         |     Saber, Aamon, Unknown     |   Tigreal, Fredrinn, Unknown, Unknown   |      Xavier, Layla, Nana, Unknown      | [3, 109, 0]    | [6, 117, 0, 0]      | [115, 18, 5, 0]   |\n",
            "|      41 | Gatotkaca      |     Kagura, Vale, Unknown     | Layla, Popol and Kupa, Unknown, Unknown |    Diggie, Wanwan, Unknown, Unknown    | [25, 66, 0]    | [18, 94, 0, 0]      | [48, 89, 0, 0]    |\n",
            "|      42 | Harley         |     Akai, Khufra, Unknown     |     Cecilion, Ixia, Unknown, Unknown    |    Lolita, Uranus, Unknown, Unknown    | [9, 78, 0]     | [91, 121, 0, 0]     | [20, 59, 0, 0]    |\n",
            "|      43 | Irithel        |     Valir, Hylos, Unknown     |      Miya, Alpha, Unknown, Unknown      |   Badang, Silvanna, Unknown, Unknown   | [57, 49, 0]    | [1, 28, 0, 0]       | [77, 90, 0, 0]    |\n",
            "|      44 | Grock          |    Moskov, Barats, Unknown    |   Terizla, Lapu-Lapu, Unknown, Unknown  |  Novaria, Valentina, Unknown, Unknown  | [31, 99, 0]    | [82, 37, 0, 0]      | [119, 110, 0, 0]  |\n",
            "|      45 | Argus          |    Angela, Rafaela, Unknown   |      Gord, Aurora, Unknown, Unknown     |  Gatotkaca, Tigreal, Unknown, Unknown  | [55, 14, 0]    | [23, 36, 0, 0]      | [41, 6, 0, 0]     |\n",
            "|      46 | Odette         |   Johnson, Jawhead, Unknown   |     Layla, Irithel, Unknown, Unknown    |   Minotaur, Edith, Unknown, Unknown    | [32, 54, 0]    | [18, 43, 0, 0]      | [19, 111, 0, 0]   |\n",
            "|      47 | Lancelot       |    Atlas, Tigreal, Unknown    |    Cecilion, Pharsa, Unknown, Unknown   | Minsitthar, Phoveus, Unknown, Unknown  | [93, 6, 0]     | [91, 52, 0, 0]      | [74, 106, 0, 0]   |\n",
            "|      48 | Diggie         |      Layla, Miya, Unknown     |     Atlas, Lolita, Unknown, Unknown     |     Ling, Aamon, Unknown, Unknown      | [18, 1, 0]     | [93, 20, 0, 0]      | [84, 109, 0, 0]   |\n",
            "|      50 | Zhask          |   Belerick, Lolita, Unknown   |    Aldous, Paquito, Unknown, Unknown    |   Pharsa, Cecilion, Unknown, Unknown   | [70, 20, 0]    | [64, 103, 0, 0]     | [52, 91, 0, 0]    |\n",
            "|      51 | Helcurt        |  Tigreal, Esmeralda, Terizla  |      Layla, Chang'e, Vale, Unknown      | Fredrinn, Belerick, Gatotkaca, Unknown | [6, 81, 82]    | [18, 61, 66, 0]     | [117, 70, 41, 0]  |\n",
            "|      52 | Pharsa         |     Atlas, Franco, Unknown    |      Layla, Hanabi, Xavier, Unknown     |  Franco, Zilong, Minsitthar, Unknown   | [93, 10, 0]    | [18, 60, 115, 0]    | [10, 16, 74, 0]   |\n",
            "|      53 | Lesley         |    Minotaur, Baxia, Unknown   |  Gatotkaca, Fredrinn, Unknown, Unknown  |    Ling, Lancelot, Unknown, Unknown    | [19, 87, 0]    | [41, 117, 0, 0]     | [84, 47, 0, 0]    |\n",
            "|      54 | Jawhead        |   Odette, Belerick, Unknown   |     Saber, Eudora, Unknown, Unknown     |    Edith, Thamuz, Unknown, Unknown     | [46, 70, 0]    | [3, 15, 0, 0]       | [111, 72, 0, 0]   |\n",
            "|      55 | Angela         |    Lancelot, Aamon, Unknown   |    Uranus, Belerick, Unknown, Unknown   |     Ling, Harley, Unknown, Unknown     | [47, 109, 0]   | [59, 70, 0, 0]      | [84, 42, 0, 0]    |\n",
            "|      56 | Gusion         |    Vexana, Pharsa, Unknown    |     Layla, Hanabi, Unknown, Unknown     |     Franco, Kaja, Unknown, Unknown     | [38, 52, 0]    | [18, 60, 0, 0]      | [10, 62, 0, 0]    |\n",
            "|      58 | Martis         |    Alpha, Khaleed, Unknown    |     Layla, Odette, Unknown, Unknown     |   Thamuz, Fredrinn, Unknown, Unknown   | [28, 98, 0]    | [18, 46, 0, 0]      | [72, 117, 0, 0]   |\n",
            "|      59 | Uranus         |    Beatrix, Hanabi, Unknown   |    Tigreal, Franco, Unknown, Unknown    |    Layla, Lesley, Unknown, Unknown     | [105, 60, 0]   | [6, 10, 0, 0]       | [18, 53, 0, 0]    |\n",
            "|      60 | Hanabi         |    Carmilla, Atlas, Unknown   |   Tigreal, Belerick, Unknown, Unknown   |   Lancelot, Zilong, Unknown, Unknown   | [92, 93, 0]    | [6, 70, 0, 0]       | [47, 16, 0, 0]    |\n",
            "|      62 | Kaja           |     Eudora, Aamon, Unknown    |    Fanny, Lancelot, Unknown, Unknown    |    Layla, Pharsa, Unknown, Unknown     | [15, 109, 0]   | [17, 47, 0, 0]      | [18, 52, 0, 0]    |\n",
            "|      63 | Selena         |    Xavier, Beatrix, Unknown   |      Gord, Layla, Unknown, Unknown      |    Hanabi, Wanwan, Unknown, Unknown    | [115, 105, 0]  | [23, 18, 0, 0]      | [60, 89, 0, 0]    |\n",
            "|      64 | Aldous         |    Balmond, Bruno, Unknown    |    Zilong, Leomord, Unknown, Unknown    |   Martis, Dyrroth, Unknown, Unknown    | [2, 12, 0]     | [16, 67, 0, 0]      | [58, 85, 0, 0]    |\n",
            "|      65 | Claude         |    Angela, Faramis, Unknown   |     Vexana, Floryn, Unknown, Unknown    |    Eudora, Franco, Unknown, Unknown    | [55, 76, 0]    | [38, 112, 0, 0]     | [15, 10, 0, 0]    |\n",
            "|      66 | Vale           |   Lolita, Belerick, Unknown   |     Terizla, Hilda, Unknown, Unknown    |    Hayabusa, Ling, Unknown, Unknown    | [20, 70, 0]    | [82, 35, 0, 0]      | [21, 84, 0, 0]    |\n",
            "|      67 | Leomord        |    Pharsa, Vexana, Unknown    |      Odette, Pharsa, Yve, Cecilion      |      Phoveus, Franco, Akai, Nana       | [52, 38, 0]    | [46, 52, 101, 91]   | [106, 10, 9, 5]   |\n",
            "|      68 | Lunox          |   Franco, Minotaur, Unknown   |       Yve, Lylia, Unknown, Unknown      |     Nolan, Ling, Unknown, Unknown      | [10, 19, 0]    | [101, 86, 0, 0]     | [122, 84, 0, 0]   |\n",
            "|      69 | Hanzo          |    Atlas, Tigreal, Unknown    |      Xavier, Ixia, Unknown, Unknown     |     Ling, Fanny, Unknown, Unknown      | [93, 6, 0]     | [115, 121, 0, 0]    | [84, 17, 0, 0]    |\n",
            "|      70 | Belerick       |      Natan, Miya, Unknown     |     Lancelot, Ling, Unknown, Unknown    |    Valir, Xavier, Unknown, Unknown     | [107, 1, 0]    | [47, 84, 0, 0]      | [57, 115, 0, 0]   |\n",
            "|      71 | Kimmy          |    Rafaela, Angela, Unknown   |    Hylos, Carmilla, Unknown, Unknown    |    Natalia, Aamon, Unknown, Unknown    | [14, 55, 0]    | [49, 92, 0, 0]      | [24, 109, 0, 0]   |\n",
            "|      72 | Thamuz         |    Angela, Rafaela, Unknown   |      Zilong, Sun, Unknown, Unknown      |   Karrie, Irithel, Unknown, Unknown    | [55, 14, 0]    | [16, 27, 0, 0]      | [40, 43, 0, 0]    |\n",
            "|      73 | Harith         | Minsitthar, Minotaur, Unknown |   Belerick, Johnson, Unknown, Unknown   |   Novaria, Pharsa, Unknown, Unknown    | [74, 19, 0]    | [70, 32, 0, 0]      | [119, 52, 0, 0]   |\n",
            "|      75 | Kadita         |    Atlas, Tigreal, Unknown    |     Aurora, Eudora, Unknown, Unknown    |    Clint, Beatrix, Unknown, Unknown    | [93, 6, 0]     | [36, 15, 0, 0]      | [13, 105, 0, 0]   |\n",
            "|      76 | Faramis        |    Leomord, Martis, Unknown   |     Saber, Eudora, Unknown, Unknown     |   Novaria, Pharsa, Unknown, Unknown    | [67, 58, 0]    | [3, 15, 0, 0]       | [119, 52, 0, 0]   |\n",
            "|      77 | Badang         |    Tigreal, Luo Yi, Unknown   |     Layla, Odette, Unknown, Unknown     |     Wanwan, Ling, Unknown, Unknown     | [6, 96, 0]     | [18, 46, 0, 0]      | [89, 84, 0, 0]    |\n",
            "|      78 | Khufra         |    Eudora, Pharsa, Unknown    |     Joy, Lancelot, Unknown, Unknown     |    Fredrinn, Gloo, Unknown, Unknown    | [15, 52, 0]    | [118, 47, 0, 0]     | [117, 104, 0, 0]  |\n",
            "|      79 | Granger        |     Franco, Kaja, Unknown     |   Chang'e, Cecilion, Unknown, Unknown   |  Gatotkaca, Khufra, Unknown, Unknown   | [10, 62, 0]    | [61, 91, 0, 0]      | [41, 78, 0, 0]    |\n",
            "|      80 | Guinevere      |     Franco, Hylos, Unknown    |    Zilong, Silvanna, Unknown, Unknown   |     Badang, Chou, Unknown, Unknown     | [10, 49, 0]    | [16, 90, 0, 0]      | [77, 26, 0, 0]    |\n",
            "|      81 | Esmeralda      |    Atlas, Tigreal, Unknown    |      Akai, Lolita, Unknown, Unknown     |    Karrie, Lesley, Unknown, Unknown    | [93, 6, 0]     | [9, 20, 0, 0]       | [40, 53, 0, 0]    |\n",
            "|      82 | Terizla        |   Gatotkaca, Atlas, Unknown   |      Zilong, Sun, Unknown, Unknown      |    Arlott, Lesley, Unknown, Unknown    | [41, 93, 0]    | [16, 27, 0, 0]      | [120, 53, 0, 0]   |\n",
            "|      84 | Ling           |    Angela, Khufra, Unknown    |     Layla, Hanabi, Unknown, Unknown     |   Eudora, Jawhead, Unknown, Unknown    | [55, 78, 0]    | [18, 60, 0, 0]      | [15, 54, 0, 0]    |\n",
            "|      85 | Dyrroth        |     Franco, Kaja, Unknown     |      Gord, Hanabi, Unknown, Unknown     |   Vexana, Belerick, Unknown, Unknown   | [10, 62, 0]    | [23, 60, 0, 0]      | [38, 70, 0, 0]    |\n",
            "|      86 | Lylia          |   Minotaur, Franco, Unknown   |    Carmilla, Hylos, Unknown, Unknown    |     Nolan, Ling, Unknown, Unknown      | [19, 10, 0]    | [92, 49, 0, 0]      | [122, 84, 0, 0]   |\n",
            "|      87 | Baxia          |     Thamuz, Alpha, Unknown    |   Chang'e, Silvanna, Unknown, Unknown   |    Karrie, Lesley, Unknown, Unknown    | [72, 28, 0]    | [61, 90, 0, 0]      | [40, 53, 0, 0]    |\n",
            "|      88 | Masha          |    Angela, Rafaela, Unknown   |      Ixia, Layla, Unknown, Unknown      |     Cici, Thamuz, Unknown, Unknown     | [55, 14, 0]    | [121, 18, 0, 0]     | [123, 72, 0, 0]   |\n",
            "|      89 | Wanwan         |   Franco, Belerick, Unknown   |    Fredrinn, Luo Yi, Unknown, Unknown   |    Lancelot, Gord, Unknown, Unknown    | [10, 70, 0]    | [117, 96, 0, 0]     | [47, 23, 0, 0]    |\n",
            "|      90 | Silvanna       |    Atlas, Tigreal, Unknown    |      Layla, Valir, Unknown, Unknown     |   Martis, Unknown, Unknown, Unknown    | [93, 6, 0]     | [18, 57, 0, 0]      | [58, 0, 0, 0]     |\n",
            "|      91 | Cecilion       |  Carmilla, Minotaur, Unknown  |    Balmond, Terizla, Unknown, Unknown   |     Ling, Fanny, Unknown, Unknown      | [92, 19, 0]    | [2, 82, 0, 0]       | [84, 17, 0, 0]    |\n",
            "|      92 | Carmilla       |   Cecilion, Aurora, Unknown   |   Dyrroth, Lapu-Lapu, Unknown, Unknown  |    Hanabi, Wanwan, Unknown, Unknown    | [91, 36, 0]    | [85, 37, 0, 0]      | [60, 89, 0, 0]    |\n",
            "|      93 | Atlas          |      Vale, Ixia, Unknown      |     Vexana, Eudora, Unknown, Unknown    |    Valir, Moskov, Unknown, Unknown     | [66, 121, 0]   | [38, 15, 0, 0]      | [57, 31, 0, 0]    |\n",
            "|      94 | Popol and Kupa |    Alpha, Khaleed, Unknown    |     Lesley, Brody, Unknown, Unknown     |    Gusion, Karina, Unknown, Unknown    | [28, 98, 0]    | [53, 100, 0, 0]     | [56, 8, 0, 0]     |\n",
            "|      95 | Yu Zhong       |    Vexana, Xavier, Unknown    |     Aulus, Zilong, Unknown, Unknown     |    Lesley, Karrie, Unknown, Unknown    | [38, 115, 0]   | [108, 16, 0, 0]     | [53, 40, 0, 0]    |\n",
            "|      96 | Luo Yi         |     Aamon, Karina, Unknown    |      Eudora, Gord, Unknown, Unknown     |   Uranus, Fredrinn, Unknown, Unknown   | [109, 8, 0]    | [15, 23, 0, 0]      | [59, 117, 0, 0]   |\n",
            "|      97 | Benedetta      |  Johnson, Gatotkaca, Unknown  |   Jawhead, Guinevere, Unknown, Unknown  | Minsitthar, Phoveus, Unknown, Unknown  | [32, 41, 0]    | [54, 80, 0, 0]      | [74, 106, 0, 0]   |\n",
            "|      98 | Khaleed        |     Roger, Karina, Unknown    |    Cyclops, Xavier, Unknown, Unknown    |     X.Borg, Chou, Unknown, Unknown     | [39, 8, 0]     | [33, 115, 0, 0]     | [83, 26, 0, 0]    |\n",
            "|      99 | Barats         |   Mathilda, Angela, Unknown   |    Belerick, Lolita, Unknown, Unknown   |     Akai, Moskov, Unknown, Unknown     | [102, 55, 0]   | [70, 20, 0, 0]      | [9, 31, 0, 0]     |\n",
            "|     100 | Brody          |   Hylos, Minsitthar, Unknown  |       Aamon, Yin, Unknown, Unknown      |    Martis, Wanwan, Unknown, Unknown    | [49, 74, 0]    | [109, 113, 0, 0]    | [58, 89, 0, 0]    |\n",
            "|     101 | Yve            |   Minotaur, Gatotkaca, Atlas  |         Fredrinn, Barats, Aulus         |           Yin, Saber, Karina           | [19, 41, 93]   | [117, 99, 108]      | [113, 3, 8]       |\n",
            "|      74 | Minsitthar     |    Melissa, Hanabi, Unknown   |   Benedetta, Arlott, Unknown, Unknown   |    Zilong, Aulus, Unknown, Unknown     | [114, 60, 0]   | [97, 120, 0, 0]     | [16, 108, 0, 0]   |\n",
            "|     102 | Mathilda       |     Saber, Eudora, Unknown    |       Gord, Vale, Unknown, Unknown      |  Franco, Minsitthar, Unknown, Unknown  | [3, 15, 0]     | [23, 66, 0, 0]      | [10, 74, 0, 0]    |\n",
            "|     104 | Gloo           |     Eudora, Saber, Unknown    |   Cecilion, Chang'e, Unknown, Unknown   |    Karrie, Lesley, Unknown, Unknown    | [15, 3, 0]     | [91, 61, 0, 0]      | [40, 53, 0, 0]    |\n",
            "|     105 | Beatrix        |     Khufra, Atlas, Unknown    |    Hylos, Belerick, Unknown, Unknown    |     Eudora, Ling, Unknown, Unknown     | [78, 93, 0]    | [49, 70, 0, 0]      | [15, 84, 0, 0]    |\n",
            "|     106 | Phoveus        |  Gatotkaca, Minotaur, Tigreal |           Wanwan, Arlott, Chou          |         Aurora, Valir, Vexana          | [41, 19, 6]    | [89, 120, 26]       | [36, 57, 38]      |\n",
            "|     107 | Natan          |    Johnson, Alpha, Unknown    |       Tigreal, Gatotkaca, Unknown       |         Saber, Eudora, Unknown         | [32, 28, 0]    | [6, 41, 0]          | [3, 15, 0]        |\n",
            "|     108 | Aulus          |      Angela, Yve, Unknown     |            Hanabi, Yve, Gord            |        Franco, Wanwan, Unknown         | [55, 101, 0]   | [60, 101, 23]       | [10, 89, 0]       |\n",
            "|     109 | Aamon          |    Rafaela, Floryn, Unknown   |        Xavier, Cecilion, Unknown        |       Balmond, Fredrinn, Unknown       | [14, 112, 0]   | [115, 91, 0]        | [2, 117, 0]       |\n",
            "|     111 | Edith          |    Minotaur, Atlas, Unknown   |          Zilong, Aulus, Unknown         |        Hanabi, Wanwan, Unknown         | [19, 93, 0]    | [16, 108, 0]        | [60, 89, 0]       |\n",
            "|     110 | Valentina      |    Carmilla, Atlas, Unknown   |         Hanabi, Faramis, Unknown        |        Hayabusa, Natalia, Hanzo        | [92, 93, 0]    | [60, 76, 0]         | [21, 24, 69]      |\n",
            "|     112 | Floryn         |    Terizla, Thamuz, Unknown   |         Uranus, Lolita, Unknown         |         Karina, Saber, Unknown         | [82, 72, 0]    | [59, 20, 0]         | [8, 3, 0]         |\n",
            "|     113 | Yin            |   Mathilda, Rafaela, Unknown  |         Layla, Cecilion, Unknown        |       Fredrinn, Badang, Unknown        | [102, 14, 0]   | [18, 91, 0]         | [117, 77, 0]      |\n",
            "|     114 | Melissa        |   Tigreal, Minotaur, Unknown  |           Sun, Zilong, Unknown          |         Xavier, Nana, Unknown          | [6, 19, 0]     | [27, 16, 0]         | [115, 5, 0]       |\n",
            "|     115 | Xavier         |    Carmilla, Atlas, Unknown   |         Hanabi, Faramis, Unknown        |      Benedetta, Hayabusa, Natalia      | [92, 93, 0]    | [60, 76, 0]         | [97, 21, 24]      |\n",
            "|     116 | Julian         |    Angela, Diggie, Unknown    |        Cecilion, Aldous, Unknown        |              Joy, Harith               | [55, 48, 0]    | [91, 64, 0]         | [118, 73]         |\n",
            "|     117 | Fredrinn       |    Angela, Floryn, Unknown    |          Vale, Eudora, Unknown          |             Karrie, Lesley             | [55, 112, 0]   | [66, 15, 0]         | [40, 53]          |\n",
            "|     118 | Joy            |     Angela, Hylos, Unknown    |         Xavier, Vexana, Unknown         |           Minsitthar, Khufra           | [55, 49, 0]    | [115, 38, 0]        | [74, 78]          |\n",
            "|     120 | Arlott         |   Gatotkaca, Atlas, Unknown   |           Sun, Zilong, Unknown          |            Thamuz, Fredrinn            | [41, 93, 0]    | [27, 16, 0]         | [72, 117]         |\n",
            "|     119 | Novaria        |    Beatrix, Layla, Unknown    |         Eudora, Odette, Unknown         |            Saber, Hayabusa             | [105, 18, 0]   | [15, 46, 0]         | [3, 21]           |\n",
            "|     121 | Ixia           |    Fredrinn, Bane, Unknown    |         Fredrinn, Bane, Unknown         |              Saber, Aamon              | [117, 11, 0]   | [117, 11, 0]        | [3, 109]          |\n",
            "|     124 | Chip           |     Alpha, Hanabi, Kadita     |           Vexana, Layla, Ixia           |            Barats, Tigreal             | [28, 60, 75]   | [38, 18, 121]       | [99, 6]           |\n",
            "|     123 | Cici           |    Angela, Floryn, Unknown    |       Fredrinn, Minotaur, Unknown       |              Saber, Kaja               | [55, 112, 0]   | [117, 19, 0]        | [3, 62]           |\n",
            "|       3 | Saber          |    Kadita, Cyclops, Unknown   |          Layla, Eudora, Unknown         |        Estes, Faramis, Unknown         | [75, 33, 0]    | [18, 15, 0]         | [34, 76, 0]       |\n",
            "|      83 | X.Borg         |    Karina, Martis, Unknown    |     Terizla, Aulus, Unknown, Unknown    |   Martis, Dyrroth, Unknown, Unknown    | [8, 58, 0]     | [82, 108, 0, 0]     | [58, 85, 0, 0]    |\n",
            "|      36 | Aurora         |      Ixia, Freya, Karrie      |    Leomord, Thamuz, Terizla, Unknown    |    Ling, Kadita, Guinevere, Unknown    | [121, 22, 40]  | [67, 72, 82, 0]     | [84, 75, 80, 0]   |\n",
            "|      49 | Hylos          |  Terizla, Minsitthar, Unknown |      Layla, Gord, Unknown, Unknown      |    Karrie, Lesley, Unknown, Unknown    | [82, 74, 0]    | [18, 23, 0, 0]      | [40, 53, 0, 0]    |\n",
            "|      57 | Valir          |   Khaleed, Yu Zhong, Unknown  |   Balmond, Fredrinn, Unknown, Unknown   |   Lancelot, Fanny, Unknown, Unknown    | [98, 95, 0]    | [2, 117, 0, 0]      | [47, 17, 0, 0]    |\n",
            "|      10 | Franco         |      Vale, Karina, Brody      |            Vale, Estes, Layla           |         Wanwan, Fanny, Badang          | [66, 8, 100]   | [66, 34, 18]        | [89, 17, 77]      |\n",
            "|      14 | Rafaela        |        Freya, Lapu-Lapu       |              Masha, Barats              |             Ling, Hayabusa             | [22, 37]       | [88, 99]            | [84, 21]          |\n",
            "|      15 | Eudora         |        Johnson, Jawhead       |              Wanwan, Moskov             |       Fredrinn, Unknown, Unknown       | [32, 54]       | [89, 31]            | [117, 0, 0]       |\n",
            "|      16 | Zilong         |         Pharsa, Hanabi        |               Layla, Lylia              |              Franco, Nana              | [52, 60]       | [18, 86]            | [10, 5]           |\n",
            "|      21 | Hayabusa       |        Lapu-Lapu, Alpha       |            Chang'e, Cecilion            |              Franco, Kaja              | [37, 28]       | [61, 91]            | [10, 62]          |\n",
            "|      24 | Natalia        |      Yi Sun-shin, Vexana      |             Novaria, Irithel            |            Minsitthar, Kaja            | [30, 38]       | [119, 43]           | [74, 62]          |\n",
            "|      33 | Cyclops        | Belerick, Minsitthar, Unknown |     Terizla, Alpha, Unknown, Unknown    |   Lancelot, Alucard, Kagura, Unknown   | [70, 74, 0]    | [82, 28, 0, 0]      | [47, 7, 25, 0]    |\n",
            "|     103 | Paquito        |    Angela, Rafaela, Unknown   |      Gord, Layla, Unknown, Unknown      |     Franco, Kaja, Unknown, Unknown     | [55, 14, 0]    | [23, 18, 0, 0]      | [10, 62, 0, 0]    |\n",
            "|     122 | Nolan          |  Tigreal, Gatotkaca, Unknown  |         Hanabi, Eudora, Unknown         |            Thamuz, Fredrinn            | [6, 41, 0]     | [60, 15, 0]         | [72, 117]         |\n",
            "+---------+----------------+-------------------------------+-----------------------------------------+----------------------------------------+----------------+---------------------+-------------------+\n"
          ]
        }
      ],
      "source": [
        "def hero_main():\n",
        "    sortid_values          = [1, 2, 3, 4, 5, 6]\n",
        "    roadsort_values        = [1, 2, 3, 4, 5]\n",
        "    page_size              = 126\n",
        "    page_index             = 1\n",
        "    sorts_field, sorts_order = \"heroid\", \"asc\"\n",
        "\n",
        "    hero_filter_factory = HeroFilterFactory.hero_create_filter(sortid_values, roadsort_values, page_size, page_index, sorts_field, sorts_order)\n",
        "\n",
        "    data = hero_filter_factory.fetch_data()\n",
        "    # print(data)\n",
        "    if data:\n",
        "        table = hero_create_hero_table(data)\n",
        "        print(table)\n",
        "    else:\n",
        "        print(\"Failed to retrieve data.\")\n",
        "\n",
        "if __name__ == \"__main__\":\n",
        "    hero_main()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "1_WfIqxTsI1B"
      },
      "source": [
        "## hero detail"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 6,
      "metadata": {
        "id": "T370nzy7sKIR"
      },
      "outputs": [],
      "source": [
        "class HeroData:\n",
        "    HERO_NAME_DICT = {\n",
        "        \"126\": \"Suyou\",\n",
        "        125: \"Zhuxin\", 124: \"Chip\", 123: \"Cici\", 122: \"Nolan\", 121: \"Ixia\", 120: \"Arlott\", 119: \"Novaria\",\n",
        "        118: \"Joy\", 117: \"Fredrinn\", 116: \"Julian\", 115: \"Xavier\", 114: \"Melissa\", 113: \"Yin\", 112: \"Floryn\",\n",
        "        111: \"Edith\", 110: \"Valentina\", 109: \"Aamon\", 108: \"Aulus\", 107: \"Natan\", 106: \"Phoveus\", 105: \"Beatrix\",\n",
        "        104: \"Gloo\", 103: \"Paquito\", 102: \"Mathilda\", 101: \"Yve\", 100: \"Brody\", 99: \"Barats\", 98: \"Khaleed\",\n",
        "        97: \"Benedetta\", 96: \"Luo Yi\", 95: \"Yu Zhong\", 94: \"Popol and Kupa\", 93: \"Atlas\", 92: \"Carmilla\",\n",
        "        91: \"Cecilion\", 90: \"Silvanna\", 89: \"Wanwan\", 88: \"Masha\", 87: \"Baxia\", 86: \"Lylia\", 85: \"Dyrroth\",\n",
        "        84: \"Ling\", 83: \"X.Borg\", 82: \"Terizla\", 81: \"Esmeralda\", 80: \"Guinevere\", 79: \"Granger\", 78: \"Khufra\",\n",
        "        77: \"Badang\", 76: \"Faramis\", 75: \"Kadita\", 74: \"Minsitthar\", 73: \"Harith\", 72: \"Thamuz\", 71: \"Kimmy\",\n",
        "        70: \"Belerick\", 69: \"Hanzo\", 68: \"Lunox\", 67: \"Leomord\", 66: \"Vale\", 65: \"Claude\", 64: \"Aldous\",\n",
        "        63: \"Selena\", 62: \"Kaja\", 61: \"Chang'e\", 60: \"Hanabi\", 59: \"Uranus\", 58: \"Martis\", 57: \"Valir\",\n",
        "        56: \"Gusion\", 55: \"Angela\", 54: \"Jawhead\", 53: \"Lesley\", 52: \"Pharsa\", 51: \"Helcurt\", 50: \"Zhask\",\n",
        "        49: \"Hylos\", 48: \"Diggie\", 47: \"Lancelot\", 46: \"Odette\", 45: \"Argus\", 44: \"Grock\", 43: \"Irithel\",\n",
        "        42: \"Harley\", 41: \"Gatotkaca\", 40: \"Karrie\", 39: \"Roger\", 38: \"Vexana\", 37: \"Lapu-Lapu\", 36: \"Aurora\",\n",
        "        35: \"Hilda\", 34: \"Estes\", 33: \"Cyclops\", 32: \"Johnson\", 31: \"Moskov\", 30: \"Yi Sun-shin\", 29: \"Ruby\",\n",
        "        28: \"Alpha\", 27: \"Sun\", 26: \"Chou\", 25: \"Kagura\", 24: \"Natalia\", 23: \"Gord\", 22: \"Freya\", 21: \"Hayabusa\",\n",
        "        20: \"Lolita\", 19: \"Minotaur\", 18: \"Layla\", 17: \"Fanny\", 16: \"Zilong\", 15: \"Eudora\", 14: \"Rafaela\",\n",
        "        13: \"Clint\", 12: \"Bruno\", 11: \"Bane\", 10: \"Franco\", 9: \"Akai\", 8: \"Karina\", 7: \"Alucard\", 6: \"Tigreal\",\n",
        "        5: \"Nana\", 4: \"Alice\", 3: \"Saber\", 2: \"Balmond\", 1: \"Miya\"\n",
        "    }\n",
        "\n",
        "    def __init__(self, url, payload):\n",
        "        self.url = url\n",
        "        self.payload = payload\n",
        "        self.data = None\n",
        "\n",
        "    def fetch_data(self):\n",
        "        response = requests.post(self.url, json=self.payload)\n",
        "        response.raise_for_status()\n",
        "        self.data = response.json()\n",
        "\n",
        "    def display_table(self, title, rows, field_names):\n",
        "        table = PrettyTable()\n",
        "        table.field_names = field_names\n",
        "        for row in rows:\n",
        "            table.add_row(row)\n",
        "        print(f\"\\n{title}:\")\n",
        "        print(table)\n",
        "\n",
        "    def display_main_hero(self):\n",
        "        main_hero_data = self.data[\"data\"][\"records\"][0][\"data\"][\"main_hero\"][\"data\"]\n",
        "        main_hero = self.data['data']['records'][0]['data']\n",
        "        main_hero_channel = self.data['data']['records'][0]['data']['main_hero_channel']\n",
        "\n",
        "        rows = [\n",
        "            # [\"Image URL\", main_hero_data[\"head\"]],\n",
        "            [\"Hero ID\", main_hero[\"main_heroid\"]],\n",
        "            [\"Hero Name\", main_hero_data[\"name\"]],\n",
        "            # [\"Channel ID\", main_hero_channel[\"id\"]],\n",
        "            # [\"Match Type\", main_hero[\"match_type\"]],\n",
        "            # [\"Big Rank\", main_hero[\"bigrank\"]],\n",
        "            # [\"Camp Type\", main_hero[\"camp_type\"]],\n",
        "            [\"Pick Rate\", f'{main_hero[\"main_hero_appearance_rate\"] * 100:.2f}%'],\n",
        "            [\"Ban Rate\", f'{main_hero[\"main_hero_ban_rate\"] * 100:.2f}%'],\n",
        "            [\"Win Rate\", f'{main_hero[\"main_hero_win_rate\"] * 100:.2f}%'],\n",
        "        ]\n",
        "        self.display_table(\"Main Hero Information\", rows, [\"Attribute\", \"Value\"])\n",
        "\n",
        "    # counter relationship\n",
        "    def display_sub_heroes_counter_relationship(self):\n",
        "        sub_heroes = self.data[\"data\"][\"records\"][0][\"data\"][\"sub_hero\"]\n",
        "        rows = []\n",
        "        for hero in sub_heroes:\n",
        "            hero_name = self.HERO_NAME_DICT.get(hero[\"heroid\"], \"Unknown\")\n",
        "            row = [\n",
        "                # hero[\"hero\"][\"data\"][\"head\"],\n",
        "                hero[\"hero_index\"],\n",
        "                # hero[\"hero_channel\"][\"id\"],\n",
        "                hero_name,\n",
        "                f'{hero[\"increase_win_rate\"] * 100:.2f}',\n",
        "                f'{hero[\"hero_appearance_rate\"] * 100:.2f}%',\n",
        "                f'{hero[\"hero_win_rate\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate10_12\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate12_14\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate14_16\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate16_18\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate18_20\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate20\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate6\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate6_8\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate8_10\"] * 100:.2f}%'\n",
        "            ]\n",
        "            rows.append(row)\n",
        "        self.display_table(\"Best Counters\", rows, [\n",
        "            # \"Hero Image\",\n",
        "            \"Index\",\n",
        "            # \"Channel ID\",\n",
        "            \"Hero Name\",\n",
        "            \"Counter Score\",\n",
        "            \"Pick Rate\",\n",
        "            \"Win Rate\",\n",
        "            \"Win Rate 10-12\",\n",
        "            \"Win Rate 12-14\",\n",
        "            \"Win Rate 14-16\",\n",
        "            \"Win Rate 16-18\",\n",
        "            \"Win Rate 18-20\",\n",
        "            \"Win Rate 20+\",\n",
        "            \"Win Rate 6+\",\n",
        "            \"Win Rate 6-8\",\n",
        "            \"Win Rate 8-10\"\n",
        "        ])\n",
        "\n",
        "    def display_last_sub_heroes_counter_relationship(self):\n",
        "        last_sub_heroes = self.data[\"data\"][\"records\"][0][\"data\"][\"sub_hero_last\"]\n",
        "        rows = []\n",
        "        for hero in last_sub_heroes:\n",
        "            hero_name = self.HERO_NAME_DICT.get(hero[\"heroid\"], \"Unknown\")\n",
        "            row = [\n",
        "                hero[\"hero_index\"],\n",
        "                hero_name,\n",
        "                f'{hero[\"increase_win_rate\"] * 100:.2f}',\n",
        "                f'{hero[\"hero_appearance_rate\"] * 100:.2f}%',\n",
        "                f'{hero[\"hero_win_rate\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate10_12\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate12_14\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate14_16\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate16_18\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate18_20\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate20\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate6\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate6_8\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate8_10\"] * 100:.2f}%'\n",
        "            ]\n",
        "            rows.append(row)\n",
        "        self.display_table(\"Most Countered by\", rows, [\n",
        "            \"Index\",\n",
        "            \"Hero Name\",\n",
        "            \"Counter Score\",\n",
        "            \"Pick Rate\",\n",
        "            \"Win Rate\",\n",
        "            \"Win Rate 10-12\",\n",
        "            \"Win Rate 12-14\",\n",
        "            \"Win Rate 14-16\",\n",
        "            \"Win Rate 16-18\",\n",
        "            \"Win Rate 18-20\",\n",
        "            \"Win Rate 20+\",\n",
        "            \"Win Rate 6+\",\n",
        "            \"Win Rate 6-8\",\n",
        "            \"Win Rate 8-10\"\n",
        "        ])\n",
        "\n",
        "    # compatibility\n",
        "    def display_sub_heroes_compatibility(self):\n",
        "        sub_heroes = self.data[\"data\"][\"records\"][0][\"data\"][\"sub_hero\"]\n",
        "        rows = []\n",
        "        for hero in sub_heroes:\n",
        "            hero_name = self.HERO_NAME_DICT.get(hero[\"heroid\"], \"Unknown\")\n",
        "            row = [\n",
        "                # hero[\"hero\"][\"data\"][\"head\"],\n",
        "                hero[\"hero_index\"],\n",
        "                hero_name,\n",
        "                f'{hero[\"increase_win_rate\"] * 100:.2f}',\n",
        "                f'{hero[\"hero_appearance_rate\"] * 100:.2f}%',\n",
        "                # hero[\"hero_channel\"][\"id\"],\n",
        "                f'{hero[\"hero_win_rate\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate10_12\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate12_14\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate14_16\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate16_18\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate18_20\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate20\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate6\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate6_8\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate8_10\"] * 100:.2f}%'\n",
        "            ]\n",
        "            rows.append(row)\n",
        "        self.display_table(\"Compatibility\", rows, [\n",
        "            # \"Hero Image\",\n",
        "            \"Index\",\n",
        "            \"Hero Name\",\n",
        "            \"Teammate Score\",\n",
        "            \"Pick Rate\",\n",
        "            # \"Channel ID\",\n",
        "            \"Win Rate\",\n",
        "            \"Win Rate 10-12\",\n",
        "            \"Win Rate 12-14\",\n",
        "            \"Win Rate 14-16\",\n",
        "            \"Win Rate 16-18\",\n",
        "            \"Win Rate 18-20\",\n",
        "            \"Win Rate 20+\",\n",
        "            \"Win Rate 6+\",\n",
        "            \"Win Rate 6-8\",\n",
        "            \"Win Rate 8-10\"\n",
        "        ])\n",
        "\n",
        "    def display_last_sub_heroes_compatibility(self):\n",
        "        last_sub_heroes = self.data[\"data\"][\"records\"][0][\"data\"][\"sub_hero_last\"]\n",
        "        rows = []\n",
        "        for hero in last_sub_heroes:\n",
        "            hero_name = self.HERO_NAME_DICT.get(hero[\"heroid\"], \"Unknown\")\n",
        "            row = [\n",
        "                hero[\"hero_index\"],\n",
        "                hero_name,\n",
        "                f'{hero[\"increase_win_rate\"] * 100:.2f}',\n",
        "                f'{hero[\"hero_appearance_rate\"] * 100:.2f}%',\n",
        "                f'{hero[\"hero_win_rate\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate10_12\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate12_14\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate14_16\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate16_18\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate18_20\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate20\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate6\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate6_8\"] * 100:.2f}%',\n",
        "                f'{hero[\"min_win_rate8_10\"] * 100:.2f}%'\n",
        "            ]\n",
        "            rows.append(row)\n",
        "        self.display_table(\"Not Compatible\", rows, [\n",
        "            \"Index\",\n",
        "            \"Hero Name\",\n",
        "            \"Teammate Score\",\n",
        "            \"Pick Rate\",\n",
        "            \"Win Rate\",\n",
        "            \"Win Rate 10-12\",\n",
        "            \"Win Rate 12-14\",\n",
        "            \"Win Rate 14-16\",\n",
        "            \"Win Rate 16-18\",\n",
        "            \"Win Rate 18-20\",\n",
        "            \"Win Rate 20+\",\n",
        "            \"Win Rate 6+\",\n",
        "            \"Win Rate 6-8\",\n",
        "            \"Win Rate 8-10\"\n",
        "        ])"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 7,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "YFXMAtZg9OYU",
        "outputId": "68be4c05-9e45-4e79-836d-3d14fe8574f2"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "\n",
            "Main Hero Information:\n",
            "+-----------+--------+\n",
            "| Attribute | Value  |\n",
            "+-----------+--------+\n",
            "|  Hero ID  |  126   |\n",
            "| Hero Name | Suyou  |\n",
            "| Pick Rate | 1.45%  |\n",
            "|  Ban Rate | 68.05% |\n",
            "|  Win Rate | 56.20% |\n",
            "+-----------+--------+\n",
            "\n",
            "Best Counters:\n",
            "+-------+-----------+---------------+-----------+----------+----------------+----------------+----------------+----------------+----------------+--------------+-------------+--------------+---------------+\n",
            "| Index | Hero Name | Counter Score | Pick Rate | Win Rate | Win Rate 10-12 | Win Rate 12-14 | Win Rate 14-16 | Win Rate 16-18 | Win Rate 18-20 | Win Rate 20+ | Win Rate 6+ | Win Rate 6-8 | Win Rate 8-10 |\n",
            "+-------+-----------+---------------+-----------+----------+----------------+----------------+----------------+----------------+----------------+--------------+-------------+--------------+---------------+\n",
            "|   1   |   Valir   |     15.24     |   0.16%   |  40.92%  |     83.33%     |     83.33%     |     76.19%     |     69.23%     |     71.43%     |    80.00%    |   100.00%   |    0.00%     |     90.91%    |\n",
            "|   2   | Esmeralda |     11.91     |   0.18%   |  34.11%  |     96.55%     |     83.33%     |     85.00%     |     58.33%     |     50.00%     |    71.43%    |    0.00%    |    0.00%     |     85.71%    |\n",
            "|   3   |   Aulus   |      9.43     |   0.05%   |  42.66%  |     75.00%     |     71.43%     |     25.00%     |     60.00%     |    100.00%     |    66.67%    |    0.00%    |   100.00%    |    100.00%    |\n",
            "|   4   |   Thamuz  |      7.97     |   0.21%   |  44.64%  |     81.25%     |     71.43%     |     60.00%     |     59.09%     |     70.00%     |    46.67%    |    0.00%    |   100.00%    |     90.00%    |\n",
            "|   5   |   Grock   |      7.70     |   0.56%   |  48.91%  |     72.06%     |     75.00%     |     57.83%     |     63.89%     |     47.83%     |    53.85%    |    0.00%    |    80.00%    |     81.25%    |\n",
            "+-------+-----------+---------------+-----------+----------+----------------+----------------+----------------+----------------+----------------+--------------+-------------+--------------+---------------+\n",
            "\n",
            "Most Countered by:\n",
            "+-------+-----------+---------------+-----------+----------+----------------+----------------+----------------+----------------+----------------+--------------+-------------+--------------+---------------+\n",
            "| Index | Hero Name | Counter Score | Pick Rate | Win Rate | Win Rate 10-12 | Win Rate 12-14 | Win Rate 14-16 | Win Rate 16-18 | Win Rate 18-20 | Win Rate 20+ | Win Rate 6+ | Win Rate 6-8 | Win Rate 8-10 |\n",
            "+-------+-----------+---------------+-----------+----------+----------------+----------------+----------------+----------------+----------------+--------------+-------------+--------------+---------------+\n",
            "|   1   |  Balmond  |     -12.28    |   0.20%   |  30.53%  |     79.17%     |     76.47%     |     52.94%     |     42.86%     |     33.33%     |    35.29%    |    0.00%    |   100.00%    |     80.00%    |\n",
            "|   2   |   Saber   |     -9.35     |   0.32%   |  44.36%  |     67.74%     |     42.31%     |     32.56%     |     56.52%     |     50.00%     |    63.64%    |    0.00%    |    75.00%    |     85.71%    |\n",
            "|   3   |    Gord   |     -7.93     |   0.12%   |  42.72%  |    100.00%     |     63.16%     |     18.18%     |     75.00%     |     33.33%     |    27.27%    |    0.00%    |   100.00%    |    100.00%    |\n",
            "|   4   |   Baxia   |     -7.82     |   0.02%   |  44.37%  |     40.00%     |     50.00%     |     0.00%      |     0.00%      |     0.00%      |    66.67%    |    0.00%    |   100.00%    |    100.00%    |\n",
            "|   5   |   Hanzo   |     -6.69     |   0.15%   |  42.10%  |     66.67%     |     52.63%     |     46.67%     |     45.83%     |     25.00%     |    54.55%    |    0.00%    |   100.00%    |    100.00%    |\n",
            "+-------+-----------+---------------+-----------+----------+----------------+----------------+----------------+----------------+----------------+--------------+-------------+--------------+---------------+\n",
            "\n",
            "Compatibility:\n",
            "+-------+-----------+----------------+-----------+----------+----------------+----------------+----------------+----------------+----------------+--------------+-------------+--------------+---------------+\n",
            "| Index | Hero Name | Teammate Score | Pick Rate | Win Rate | Win Rate 10-12 | Win Rate 12-14 | Win Rate 14-16 | Win Rate 16-18 | Win Rate 18-20 | Win Rate 20+ | Win Rate 6+ | Win Rate 6-8 | Win Rate 8-10 |\n",
            "+-------+-----------+----------------+-----------+----------+----------------+----------------+----------------+----------------+----------------+--------------+-------------+--------------+---------------+\n",
            "|   1   |  Fredrinn |      3.27      |   0.12%   |  47.82%  |     49.45%     |     51.52%     |     56.76%     |     56.31%     |     50.70%     |    46.43%    |    0.00%    |    60.00%    |     66.67%    |\n",
            "|   2   |   Baxia   |      3.06      |   0.04%   |  47.32%  |     65.31%     |     46.05%     |     50.94%     |     52.46%     |     53.85%     |    50.00%    |    0.00%    |    50.00%    |     50.00%    |\n",
            "|   3   |   Estes   |      2.98      |   0.41%   |  47.33%  |     60.74%     |     48.13%     |     49.70%     |     44.59%     |     48.49%     |    50.00%    |    0.00%    |    77.50%    |     69.46%    |\n",
            "|   4   | Lapu-Lapu |      2.40      |   0.24%   |  46.13%  |     59.23%     |     56.81%     |     49.56%     |     42.86%     |     45.83%     |    42.01%    |    0.00%    |    60.00%    |     69.44%    |\n",
            "|   5   |  Silvanna |      2.31      |   0.40%   |  49.18%  |     60.71%     |     52.07%     |     51.37%     |     47.65%     |     54.81%     |    51.82%    |    0.00%    |    56.25%    |     70.97%    |\n",
            "+-------+-----------+----------------+-----------+----------+----------------+----------------+----------------+----------------+----------------+--------------+-------------+--------------+---------------+\n",
            "\n",
            "Not Compatible:\n",
            "+-------+-------------+----------------+-----------+----------+----------------+----------------+----------------+----------------+----------------+--------------+-------------+--------------+---------------+\n",
            "| Index |  Hero Name  | Teammate Score | Pick Rate | Win Rate | Win Rate 10-12 | Win Rate 12-14 | Win Rate 14-16 | Win Rate 16-18 | Win Rate 18-20 | Win Rate 20+ | Win Rate 6+ | Win Rate 6-8 | Win Rate 8-10 |\n",
            "+-------+-------------+----------------+-----------+----------+----------------+----------------+----------------+----------------+----------------+--------------+-------------+--------------+---------------+\n",
            "|   1   |    Hanzo    |     -5.02      |   0.19%   |  43.23%  |     34.62%     |     36.89%     |     41.15%     |     37.50%     |     45.36%     |    46.99%    |    0.00%    |    0.00%     |     41.67%    |\n",
            "|   2   |   Lancelot  |     -4.57      |   1.11%   |  42.80%  |     34.40%     |     38.60%     |     37.21%     |     40.86%     |     43.08%     |    46.47%    |    0.00%    |    39.13%    |     37.84%    |\n",
            "|   3   |    Roger    |     -4.11      |   1.85%   |  48.68%  |     46.87%     |     46.34%     |     45.81%     |     45.31%     |     45.43%     |    46.83%    |    0.00%    |    51.02%    |     51.15%    |\n",
            "|   4   | Yi Sun-shin |     -3.50      |   0.93%   |  56.53%  |     64.04%     |     56.50%     |     51.28%     |     51.64%     |     48.47%     |    52.66%    |    0.00%    |    58.33%    |     69.61%    |\n",
            "|   5   |    Nolan    |     -3.39      |   1.06%   |  47.58%  |     53.91%     |     45.66%     |     44.41%     |     39.31%     |     41.10%     |    46.85%    |    0.00%    |    57.14%    |     77.27%    |\n",
            "+-------+-------------+----------------+-----------+----------+----------------+----------------+----------------+----------------+----------------+--------------+-------------+--------------+---------------+\n"
          ]
        }
      ],
      "source": [
        "url = \"https://api.gms.moontontech.com/api/gms/source/2669606/2756567\"\n",
        "payload = {\n",
        "    \"pageSize\": 20,\n",
        "    \"filters\": [\n",
        "        {\"field\": \"main_heroid\", \"operator\": \"eq\", \"value\": 126},\n",
        "        {\"field\": \"bigrank\", \"operator\": \"eq\", \"value\": \"9\"},\n",
        "        {\"field\": \"match_type\", \"operator\": \"eq\", \"value\": \"0\"}\n",
        "    ],\n",
        "    \"sorts\": [],\n",
        "    \"pageIndex\": 1\n",
        "}\n",
        "\n",
        "hero_data = HeroData(url, payload)\n",
        "\n",
        "hero_data.fetch_data()\n",
        "\n",
        "hero_data.display_main_hero()\n",
        "hero_data.display_sub_heroes_counter_relationship()\n",
        "hero_data.display_last_sub_heroes_counter_relationship()\n",
        "\n",
        "# ============================================================\n",
        "\n",
        "payload = {\n",
        "    \"pageSize\": 20,\n",
        "    \"filters\": [\n",
        "        {\"field\": \"main_heroid\", \"operator\": \"eq\", \"value\": 126},\n",
        "        {\"field\": \"bigrank\", \"operator\": \"eq\", \"value\": \"7\"},\n",
        "        {\"field\": \"match_type\", \"operator\": \"eq\", \"value\": \"1\"}\n",
        "    ],\n",
        "    \"sorts\": [],\n",
        "    \"pageIndex\": 1\n",
        "}\n",
        "\n",
        "hero_data = HeroData(url, payload)\n",
        "\n",
        "hero_data.fetch_data()\n",
        "\n",
        "hero_data.display_sub_heroes_compatibility()\n",
        "hero_data.display_last_sub_heroes_compatibility()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "nM0u2f8xHE0K"
      },
      "outputs": [],
      "source": []
    }
  ],
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "display_name": "venv",
      "language": "python",
      "name": "python3"
    },
    "language_info": {
      "codemirror_mode": {
        "name": "ipython",
        "version": 3
      },
      "file_extension": ".py",
      "mimetype": "text/x-python",
      "name": "python",
      "nbconvert_exporter": "python",
      "pygments_lexer": "ipython3",
      "version": "3.12.1"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}