MCC_API_test.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "MCC_API_test.ipynb",
      "provenance": [],
      "authorship_tag": "ABX9TyOU6uUJ1o2yP0CGFeC7/Yxb",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/mtslaugh/Boris-Day/blob/master/MCC_API_test.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "IVSk9JmOJAd3"
      },
      "source": [
        "Basic test of API functionality, come back later and figure out how to parse and dump to google docs"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "7i-PV8A8FeZm"
      },
      "source": [
        "import requests\n",
        "from pandas import DataFrame\n",
        "import json"
      ],
      "execution_count": 9,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "XU1aue3DHlzM"
      },
      "source": [
        "mytag = 'Abogadazo'"
      ],
      "execution_count": 2,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "DmJOSA2uH6qu",
        "outputId": "9540ccca-fb81-4832-8390-2952b969e89c"
      },
      "source": [
        "latest = requests.get('https://halo.api.stdlib.com/mcc@0.1.0/games/latest/',params={'gamertag':mytag})\n",
        "print(latest.content)"
      ],
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "b'{\"gamertag\":\"Abogadazo\",\"games\":[{\"gameVariant\":\"Slayer\",\"mapId\":155,\"won\":true,\"score\":0,\"kills\":0,\"deaths\":0,\"assists\":0,\"headshots\":0,\"medals\":0,\"killDeathRatio\":0,\"headshotRate\":0,\"playedAt\":\"2021-09-23T05:13:45.015Z\",\"playedAtRecency\":\"22h 15m 57s ago\"}]}'\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 80
        },
        "id": "ecAUThKv2gRH",
        "outputId": "9471ddc7-42ae-4e10-8ff8-4504131da705"
      },
      "source": [
        "DataFrame(json.loads(latest.content.decode('utf-8'))['games'][0],index=[0])"
      ],
      "execution_count": 21,
      "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>gameVariant</th>\n",
              "      <th>mapId</th>\n",
              "      <th>won</th>\n",
              "      <th>score</th>\n",
              "      <th>kills</th>\n",
              "      <th>deaths</th>\n",
              "      <th>assists</th>\n",
              "      <th>headshots</th>\n",
              "      <th>medals</th>\n",
              "      <th>killDeathRatio</th>\n",
              "      <th>headshotRate</th>\n",
              "      <th>playedAt</th>\n",
              "      <th>playedAtRecency</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>155</td>\n",
              "      <td>True</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>2021-09-23T05:13:45.015Z</td>\n",
              "      <td>22h 15m 57s ago</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "  gameVariant  mapId  ...                  playedAt  playedAtRecency\n",
              "0      Slayer    155  ...  2021-09-23T05:13:45.015Z  22h 15m 57s ago\n",
              "\n",
              "[1 rows x 13 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 21
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Hjx0rL4BGFbV",
        "outputId": "f87e2990-89d3-4388-d2dd-13c212c6ac77"
      },
      "source": [
        "history = requests.get('https://halo.api.stdlib.com/mcc@0.1.0/games/history/',params={'gamertag':mytag})\n",
        "print(history.content)"
      ],
      "execution_count": 23,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "b'{\"gamertag\":\"Abogadazo\",\"summary\":{\"count\":25,\"kills\":143,\"deaths\":311,\"assists\":20,\"headshots\":28,\"medals\":173,\"killDeathRatio\":0.45980707395498394,\"headshotRate\":0.1958041958041958,\"killsPerGame\":5.72,\"deathsPerGame\":12.44,\"assistsPerGame\":0.8,\"headshotsPerGame\":1.12,\"medalsPerGame\":6.92},\"games\":[{\"gameVariant\":\"Slayer\",\"mapId\":155,\"won\":true,\"score\":0,\"kills\":0,\"deaths\":0,\"assists\":0,\"headshots\":0,\"medals\":0,\"killDeathRatio\":0,\"headshotRate\":0,\"playedAt\":\"2021-09-23T05:13:45.015Z\",\"playedAtRecency\":\"23h 16m 39s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":203,\"won\":false,\"score\":4,\"kills\":4,\"deaths\":11,\"assists\":0,\"headshots\":0,\"medals\":5,\"killDeathRatio\":0.36363636363636365,\"headshotRate\":0,\"playedAt\":\"2021-09-23T03:30:16.314Z\",\"playedAtRecency\":\"1d 1h 0m 8s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":221,\"won\":false,\"score\":3,\"kills\":6,\"deaths\":13,\"assists\":0,\"headshots\":0,\"medals\":4,\"killDeathRatio\":0.46153846153846156,\"headshotRate\":0,\"playedAt\":\"2021-09-23T03:22:56.264Z\",\"playedAtRecency\":\"1d 1h 7m 28s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":86,\"won\":false,\"score\":13,\"kills\":13,\"deaths\":16,\"assists\":1,\"headshots\":0,\"medals\":13,\"killDeathRatio\":0.8125,\"headshotRate\":0,\"playedAt\":\"2021-09-23T02:55:40.177Z\",\"playedAtRecency\":\"1d 1h 34m 44s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":88,\"won\":false,\"score\":6,\"kills\":6,\"deaths\":13,\"assists\":4,\"headshots\":0,\"medals\":0,\"killDeathRatio\":0.46153846153846156,\"headshotRate\":0,\"playedAt\":\"2021-09-16T05:06:51.249Z\",\"playedAtRecency\":\"7d 23h 23m 33s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":99,\"won\":false,\"score\":8,\"kills\":14,\"deaths\":25,\"assists\":0,\"headshots\":0,\"medals\":11,\"killDeathRatio\":0.56,\"headshotRate\":0,\"playedAt\":\"2021-09-16T04:59:21.869Z\",\"playedAtRecency\":\"7d 23h 31m 3s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":209,\"won\":false,\"score\":2,\"kills\":2,\"deaths\":7,\"assists\":0,\"headshots\":0,\"medals\":1,\"killDeathRatio\":0.2857142857142857,\"headshotRate\":0,\"playedAt\":\"2021-09-16T04:50:43.868Z\",\"playedAtRecency\":\"7d 23h 39m 41s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":205,\"won\":false,\"score\":4,\"kills\":4,\"deaths\":11,\"assists\":1,\"headshots\":0,\"medals\":5,\"killDeathRatio\":0.36363636363636365,\"headshotRate\":0,\"playedAt\":\"2021-09-16T04:45:26.448Z\",\"playedAtRecency\":\"7d 23h 44m 58s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":86,\"won\":false,\"score\":9,\"kills\":9,\"deaths\":12,\"assists\":0,\"headshots\":0,\"medals\":9,\"killDeathRatio\":0.75,\"headshotRate\":0,\"playedAt\":\"2021-09-16T04:01:38.636Z\",\"playedAtRecency\":\"8d 0h 28m 46s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":86,\"won\":false,\"score\":10,\"kills\":10,\"deaths\":16,\"assists\":2,\"headshots\":0,\"medals\":9,\"killDeathRatio\":0.625,\"headshotRate\":0,\"playedAt\":\"2021-08-19T03:44:24.63Z\",\"playedAtRecency\":\"36d 0h 46m 0s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":86,\"won\":false,\"score\":11,\"kills\":11,\"deaths\":10,\"assists\":1,\"headshots\":0,\"medals\":12,\"killDeathRatio\":1.1,\"headshotRate\":0,\"playedAt\":\"2021-08-12T03:12:50.749Z\",\"playedAtRecency\":\"43d 1h 17m 34s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":161,\"won\":false,\"score\":2,\"kills\":2,\"deaths\":14,\"assists\":0,\"headshots\":2,\"medals\":2,\"killDeathRatio\":0.14285714285714285,\"headshotRate\":1,\"playedAt\":\"2021-08-12T02:00:58.034Z\",\"playedAtRecency\":\"43d 2h 29m 26s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":86,\"won\":false,\"score\":7,\"kills\":7,\"deaths\":12,\"assists\":0,\"headshots\":0,\"medals\":8,\"killDeathRatio\":0.5833333333333334,\"headshotRate\":0,\"playedAt\":\"2021-07-15T04:38:16.579Z\",\"playedAtRecency\":\"70d 23h 52m 8s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":51,\"won\":true,\"score\":3,\"kills\":3,\"deaths\":11,\"assists\":1,\"headshots\":0,\"medals\":7,\"killDeathRatio\":0.2727272727272727,\"headshotRate\":0,\"playedAt\":\"2021-07-15T03:43:44.467Z\",\"playedAtRecency\":\"71d 0h 46m 40s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":200,\"won\":true,\"score\":7,\"kills\":7,\"deaths\":9,\"assists\":1,\"headshots\":3,\"medals\":12,\"killDeathRatio\":0.7777777777777778,\"headshotRate\":0.42857142857142855,\"playedAt\":\"2021-07-15T03:33:26.577Z\",\"playedAtRecency\":\"71d 0h 56m 58s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":198,\"won\":true,\"score\":4,\"kills\":4,\"deaths\":9,\"assists\":0,\"headshots\":2,\"medals\":6,\"killDeathRatio\":0.4444444444444444,\"headshotRate\":0.5,\"playedAt\":\"2021-07-15T03:17:59.231Z\",\"playedAtRecency\":\"71d 1h 12m 25s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":193,\"won\":true,\"score\":3,\"kills\":3,\"deaths\":12,\"assists\":0,\"headshots\":1,\"medals\":4,\"killDeathRatio\":0.25,\"headshotRate\":0.3333333333333333,\"playedAt\":\"2021-07-15T03:10:33.34Z\",\"playedAtRecency\":\"71d 1h 19m 51s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":192,\"won\":false,\"score\":4,\"kills\":4,\"deaths\":13,\"assists\":0,\"headshots\":3,\"medals\":6,\"killDeathRatio\":0.3076923076923077,\"headshotRate\":0.75,\"playedAt\":\"2021-07-15T03:04:08.876Z\",\"playedAtRecency\":\"71d 1h 26m 16s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":118,\"won\":false,\"score\":30,\"kills\":2,\"deaths\":16,\"assists\":0,\"headshots\":1,\"medals\":4,\"killDeathRatio\":0.125,\"headshotRate\":0.5,\"playedAt\":\"2021-07-15T02:55:05.035Z\",\"playedAtRecency\":\"71d 1h 35m 19s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":122,\"won\":false,\"score\":80,\"kills\":5,\"deaths\":13,\"assists\":2,\"headshots\":2,\"medals\":11,\"killDeathRatio\":0.38461538461538464,\"headshotRate\":0.4,\"playedAt\":\"2021-07-15T02:48:40.891Z\",\"playedAtRecency\":\"71d 1h 41m 44s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":59,\"won\":false,\"score\":4,\"kills\":4,\"deaths\":18,\"assists\":4,\"headshots\":2,\"medals\":14,\"killDeathRatio\":0.2222222222222222,\"headshotRate\":0.5,\"playedAt\":\"2021-07-08T04:10:47.011Z\",\"playedAtRecency\":\"78d 0h 19m 37s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":115,\"won\":false,\"score\":8,\"kills\":8,\"deaths\":11,\"assists\":2,\"headshots\":8,\"medals\":14,\"killDeathRatio\":0.7272727272727273,\"headshotRate\":1,\"playedAt\":\"2021-07-08T03:39:51.129Z\",\"playedAtRecency\":\"78d 0h 50m 33s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":197,\"won\":true,\"score\":7,\"kills\":7,\"deaths\":19,\"assists\":0,\"headshots\":1,\"medals\":8,\"killDeathRatio\":0.3684210526315789,\"headshotRate\":0.14285714285714285,\"playedAt\":\"2021-07-01T05:55:35.28Z\",\"playedAtRecency\":\"84d 22h 34m 49s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":203,\"won\":false,\"score\":9,\"kills\":4,\"deaths\":10,\"assists\":0,\"headshots\":3,\"medals\":6,\"killDeathRatio\":0.4,\"headshotRate\":0.75,\"playedAt\":\"2021-07-01T05:44:46.084Z\",\"playedAtRecency\":\"84d 22h 45m 38s ago\"},{\"gameVariant\":\"Slayer\",\"mapId\":194,\"won\":false,\"score\":4,\"kills\":4,\"deaths\":10,\"assists\":1,\"headshots\":0,\"medals\":2,\"killDeathRatio\":0.4,\"headshotRate\":0,\"playedAt\":\"2021-07-01T05:01:11.402Z\",\"playedAtRecency\":\"84d 23h 29m 13s ago\"}]}'\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 824
        },
        "id": "bnbmlbHy_Fym",
        "outputId": "cee10e63-ef8b-4c47-9612-c6a40f688641"
      },
      "source": [
        "DataFrame(json.loads(history.content.decode('utf-8'))['games'])"
      ],
      "execution_count": 28,
      "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>gameVariant</th>\n",
              "      <th>mapId</th>\n",
              "      <th>won</th>\n",
              "      <th>score</th>\n",
              "      <th>kills</th>\n",
              "      <th>deaths</th>\n",
              "      <th>assists</th>\n",
              "      <th>headshots</th>\n",
              "      <th>medals</th>\n",
              "      <th>killDeathRatio</th>\n",
              "      <th>headshotRate</th>\n",
              "      <th>playedAt</th>\n",
              "      <th>playedAtRecency</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>155</td>\n",
              "      <td>True</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>2021-09-23T05:13:45.015Z</td>\n",
              "      <td>23h 16m 39s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>203</td>\n",
              "      <td>False</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>11</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>5</td>\n",
              "      <td>0.363636</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>2021-09-23T03:30:16.314Z</td>\n",
              "      <td>1d 1h 0m 8s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>221</td>\n",
              "      <td>False</td>\n",
              "      <td>3</td>\n",
              "      <td>6</td>\n",
              "      <td>13</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>4</td>\n",
              "      <td>0.461538</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>2021-09-23T03:22:56.264Z</td>\n",
              "      <td>1d 1h 7m 28s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>86</td>\n",
              "      <td>False</td>\n",
              "      <td>13</td>\n",
              "      <td>13</td>\n",
              "      <td>16</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>13</td>\n",
              "      <td>0.812500</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>2021-09-23T02:55:40.177Z</td>\n",
              "      <td>1d 1h 34m 44s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>88</td>\n",
              "      <td>False</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>13</td>\n",
              "      <td>4</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.461538</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>2021-09-16T05:06:51.249Z</td>\n",
              "      <td>7d 23h 23m 33s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>99</td>\n",
              "      <td>False</td>\n",
              "      <td>8</td>\n",
              "      <td>14</td>\n",
              "      <td>25</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>11</td>\n",
              "      <td>0.560000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>2021-09-16T04:59:21.869Z</td>\n",
              "      <td>7d 23h 31m 3s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>209</td>\n",
              "      <td>False</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>7</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0.285714</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>2021-09-16T04:50:43.868Z</td>\n",
              "      <td>7d 23h 39m 41s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>205</td>\n",
              "      <td>False</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>11</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>5</td>\n",
              "      <td>0.363636</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>2021-09-16T04:45:26.448Z</td>\n",
              "      <td>7d 23h 44m 58s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>86</td>\n",
              "      <td>False</td>\n",
              "      <td>9</td>\n",
              "      <td>9</td>\n",
              "      <td>12</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>9</td>\n",
              "      <td>0.750000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>2021-09-16T04:01:38.636Z</td>\n",
              "      <td>8d 0h 28m 46s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>86</td>\n",
              "      <td>False</td>\n",
              "      <td>10</td>\n",
              "      <td>10</td>\n",
              "      <td>16</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>9</td>\n",
              "      <td>0.625000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>2021-08-19T03:44:24.63Z</td>\n",
              "      <td>36d 0h 46m 0s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>86</td>\n",
              "      <td>False</td>\n",
              "      <td>11</td>\n",
              "      <td>11</td>\n",
              "      <td>10</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>12</td>\n",
              "      <td>1.100000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>2021-08-12T03:12:50.749Z</td>\n",
              "      <td>43d 1h 17m 34s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>161</td>\n",
              "      <td>False</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>14</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>0.142857</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>2021-08-12T02:00:58.034Z</td>\n",
              "      <td>43d 2h 29m 26s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>86</td>\n",
              "      <td>False</td>\n",
              "      <td>7</td>\n",
              "      <td>7</td>\n",
              "      <td>12</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>8</td>\n",
              "      <td>0.583333</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>2021-07-15T04:38:16.579Z</td>\n",
              "      <td>70d 23h 52m 8s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>51</td>\n",
              "      <td>True</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "      <td>11</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>7</td>\n",
              "      <td>0.272727</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>2021-07-15T03:43:44.467Z</td>\n",
              "      <td>71d 0h 46m 40s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>200</td>\n",
              "      <td>True</td>\n",
              "      <td>7</td>\n",
              "      <td>7</td>\n",
              "      <td>9</td>\n",
              "      <td>1</td>\n",
              "      <td>3</td>\n",
              "      <td>12</td>\n",
              "      <td>0.777778</td>\n",
              "      <td>0.428571</td>\n",
              "      <td>2021-07-15T03:33:26.577Z</td>\n",
              "      <td>71d 0h 56m 58s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>198</td>\n",
              "      <td>True</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>9</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>6</td>\n",
              "      <td>0.444444</td>\n",
              "      <td>0.500000</td>\n",
              "      <td>2021-07-15T03:17:59.231Z</td>\n",
              "      <td>71d 1h 12m 25s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>193</td>\n",
              "      <td>True</td>\n",
              "      <td>3</td>\n",
              "      <td>3</td>\n",
              "      <td>12</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>0.250000</td>\n",
              "      <td>0.333333</td>\n",
              "      <td>2021-07-15T03:10:33.34Z</td>\n",
              "      <td>71d 1h 19m 51s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>192</td>\n",
              "      <td>False</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>13</td>\n",
              "      <td>0</td>\n",
              "      <td>3</td>\n",
              "      <td>6</td>\n",
              "      <td>0.307692</td>\n",
              "      <td>0.750000</td>\n",
              "      <td>2021-07-15T03:04:08.876Z</td>\n",
              "      <td>71d 1h 26m 16s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>118</td>\n",
              "      <td>False</td>\n",
              "      <td>30</td>\n",
              "      <td>2</td>\n",
              "      <td>16</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>0.125000</td>\n",
              "      <td>0.500000</td>\n",
              "      <td>2021-07-15T02:55:05.035Z</td>\n",
              "      <td>71d 1h 35m 19s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>122</td>\n",
              "      <td>False</td>\n",
              "      <td>80</td>\n",
              "      <td>5</td>\n",
              "      <td>13</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>11</td>\n",
              "      <td>0.384615</td>\n",
              "      <td>0.400000</td>\n",
              "      <td>2021-07-15T02:48:40.891Z</td>\n",
              "      <td>71d 1h 41m 44s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>59</td>\n",
              "      <td>False</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>18</td>\n",
              "      <td>4</td>\n",
              "      <td>2</td>\n",
              "      <td>14</td>\n",
              "      <td>0.222222</td>\n",
              "      <td>0.500000</td>\n",
              "      <td>2021-07-08T04:10:47.011Z</td>\n",
              "      <td>78d 0h 19m 37s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>115</td>\n",
              "      <td>False</td>\n",
              "      <td>8</td>\n",
              "      <td>8</td>\n",
              "      <td>11</td>\n",
              "      <td>2</td>\n",
              "      <td>8</td>\n",
              "      <td>14</td>\n",
              "      <td>0.727273</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>2021-07-08T03:39:51.129Z</td>\n",
              "      <td>78d 0h 50m 33s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>197</td>\n",
              "      <td>True</td>\n",
              "      <td>7</td>\n",
              "      <td>7</td>\n",
              "      <td>19</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>8</td>\n",
              "      <td>0.368421</td>\n",
              "      <td>0.142857</td>\n",
              "      <td>2021-07-01T05:55:35.28Z</td>\n",
              "      <td>84d 22h 34m 49s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>203</td>\n",
              "      <td>False</td>\n",
              "      <td>9</td>\n",
              "      <td>4</td>\n",
              "      <td>10</td>\n",
              "      <td>0</td>\n",
              "      <td>3</td>\n",
              "      <td>6</td>\n",
              "      <td>0.400000</td>\n",
              "      <td>0.750000</td>\n",
              "      <td>2021-07-01T05:44:46.084Z</td>\n",
              "      <td>84d 22h 45m 38s ago</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>Slayer</td>\n",
              "      <td>194</td>\n",
              "      <td>False</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>10</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>0.400000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>2021-07-01T05:01:11.402Z</td>\n",
              "      <td>84d 23h 29m 13s ago</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   gameVariant  mapId  ...                  playedAt      playedAtRecency\n",
              "0       Slayer    155  ...  2021-09-23T05:13:45.015Z      23h 16m 39s ago\n",
              "1       Slayer    203  ...  2021-09-23T03:30:16.314Z      1d 1h 0m 8s ago\n",
              "2       Slayer    221  ...  2021-09-23T03:22:56.264Z     1d 1h 7m 28s ago\n",
              "3       Slayer     86  ...  2021-09-23T02:55:40.177Z    1d 1h 34m 44s ago\n",
              "4       Slayer     88  ...  2021-09-16T05:06:51.249Z   7d 23h 23m 33s ago\n",
              "5       Slayer     99  ...  2021-09-16T04:59:21.869Z    7d 23h 31m 3s ago\n",
              "6       Slayer    209  ...  2021-09-16T04:50:43.868Z   7d 23h 39m 41s ago\n",
              "7       Slayer    205  ...  2021-09-16T04:45:26.448Z   7d 23h 44m 58s ago\n",
              "8       Slayer     86  ...  2021-09-16T04:01:38.636Z    8d 0h 28m 46s ago\n",
              "9       Slayer     86  ...   2021-08-19T03:44:24.63Z    36d 0h 46m 0s ago\n",
              "10      Slayer     86  ...  2021-08-12T03:12:50.749Z   43d 1h 17m 34s ago\n",
              "11      Slayer    161  ...  2021-08-12T02:00:58.034Z   43d 2h 29m 26s ago\n",
              "12      Slayer     86  ...  2021-07-15T04:38:16.579Z   70d 23h 52m 8s ago\n",
              "13      Slayer     51  ...  2021-07-15T03:43:44.467Z   71d 0h 46m 40s ago\n",
              "14      Slayer    200  ...  2021-07-15T03:33:26.577Z   71d 0h 56m 58s ago\n",
              "15      Slayer    198  ...  2021-07-15T03:17:59.231Z   71d 1h 12m 25s ago\n",
              "16      Slayer    193  ...   2021-07-15T03:10:33.34Z   71d 1h 19m 51s ago\n",
              "17      Slayer    192  ...  2021-07-15T03:04:08.876Z   71d 1h 26m 16s ago\n",
              "18      Slayer    118  ...  2021-07-15T02:55:05.035Z   71d 1h 35m 19s ago\n",
              "19      Slayer    122  ...  2021-07-15T02:48:40.891Z   71d 1h 41m 44s ago\n",
              "20      Slayer     59  ...  2021-07-08T04:10:47.011Z   78d 0h 19m 37s ago\n",
              "21      Slayer    115  ...  2021-07-08T03:39:51.129Z   78d 0h 50m 33s ago\n",
              "22      Slayer    197  ...   2021-07-01T05:55:35.28Z  84d 22h 34m 49s ago\n",
              "23      Slayer    203  ...  2021-07-01T05:44:46.084Z  84d 22h 45m 38s ago\n",
              "24      Slayer    194  ...  2021-07-01T05:01:11.402Z  84d 23h 29m 13s ago\n",
              "\n",
              "[25 rows x 13 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 28
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "BU_hRqtGGbPj",
        "outputId": "f5c1e9be-3b2c-4dee-f4fc-7778b365b660"
      },
      "source": [
        "stats = requests.get('https://halo.api.stdlib.com/mcc@0.1.0/stats/',params={'gamertag':mytag})\n",
        "print(stats.content)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "b'{\"gamertag\":\"Abogadazo\",\"clantag\":\"UNSC\",\"emblem\":\"https://emblems.svc.halowaypoint.com/hmcc/emblems/white_silver_mjolnir-on-steel_star\",\"playtime\":\"10h 19m 35s\",\"gamesPlayed\":69,\"wins\":14,\"losses\":55,\"winRatio\":0.2028985507246377,\"kills\":347,\"deaths\":748,\"killDeathRatio\":0.46390374331550804,\"killsPerGame\":5.028985507246377,\"deathsPerGame\":10.840579710144928,\"last20\":[0,-1,-1,-1,-1,-1,1,-1,-1,0,-1,-1,-1,-1,-1,1,-1,-1,-1,1],\"streak\":\"win 1\"}'\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "7o6cBE6PG-cz",
        "outputId": "df5f745b-c2c0-4d78-f9f2-256374816899"
      },
      "source": [
        "squad = requests.get('https://halo.api.stdlib.com/mcc@0.1.0/squad/activity',params={'gamertags':['Abogadazo','UglyCurtains']})\n",
        "print(squad.content)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "b'{\"gamertags\":[\"Abogadazo\",\"UglyCurtains\"],\"games\":[{\"gamertags\":[\"Abogadazo\"],\"gamertagsAbsent\":[\"UglyCurtains\"],\"gameVariant\":\"Slayer\",\"mapId\":155,\"squadWon\":true,\"playedAt\":\"2021-09-23T05:13:45.015Z\",\"playedAtRecency\":\"0h 18m 28s ago\",\"stats\":[{\"gamertag\":\"Abogadazo\",\"won\":true,\"score\":0,\"kills\":0,\"deaths\":0,\"assists\":0,\"headshots\":0,\"medals\":0,\"killDeathRatio\":0,\"headshotRate\":0}]},{\"gamertags\":[\"Abogadazo\"],\"gamertagsAbsent\":[\"UglyCurtains\"],\"gameVariant\":\"Infection\",\"mapId\":209,\"squadWon\":false,\"playedAt\":\"2021-09-23T04:45:32.285Z\",\"playedAtRecency\":\"0h 46m 41s ago\",\"stats\":[{\"gamertag\":\"Abogadazo\",\"won\":false,\"score\":12,\"kills\":16,\"deaths\":33,\"assists\":1,\"headshots\":0,\"medals\":18,\"killDeathRatio\":0.48484848484848486,\"headshotRate\":0}]},{\"gamertags\":[\"Abogadazo\"],\"gamertagsAbsent\":[\"UglyCurtains\"],\"gameVariant\":\"VIP\",\"mapId\":89,\"squadWon\":false,\"playedAt\":\"2021-09-23T04:26:22.733Z\",\"playedAtRecency\":\"1h 5m 51s ago\",\"stats\":[{\"gamertag\":\"Abogadazo\",\"won\":false,\"score\":5,\"kills\":0,\"deaths\":0,\"assists\":0,\"headshots\":0,\"medals\":0,\"killDeathRatio\":0,\"headshotRate\":0}]},{\"gamertags\":[\"Abogadazo\"],\"gamertagsAbsent\":[\"UglyCurtains\"],\"gameVariant\":\"VIP\",\"mapId\":92,\"squadWon\":false,\"playedAt\":\"2021-09-23T04:21:13.715Z\",\"playedAtRecency\":\"1h 11m 0s ago\",\"stats\":[{\"gamertag\":\"Abogadazo\",\"won\":false,\"score\":6,\"kills\":0,\"deaths\":0,\"assists\":0,\"headshots\":0,\"medals\":0,\"killDeathRatio\":0,\"headshotRate\":0}]},{\"gamertags\":[\"Abogadazo\"],\"gamertagsAbsent\":[\"UglyCurtains\"],\"gameVariant\":\"VIP\",\"mapId\":86,\"squadWon\":true,\"playedAt\":\"2021-09-23T04:16:28.095Z\",\"playedAtRecency\":\"1h 15m 45s ago\",\"stats\":[{\"gamertag\":\"Abogadazo\",\"won\":true,\"score\":10,\"kills\":0,\"deaths\":0,\"assists\":0,\"headshots\":0,\"medals\":0,\"killDeathRatio\":0,\"headshotRate\":0}]},{\"gamertags\":[\"Abogadazo\"],\"gamertagsAbsent\":[\"UglyCurtains\"],\"gameVariant\":\"Infection\",\"mapId\":209,\"squadWon\":false,\"playedAt\":\"2021-09-23T04:09:31.741Z\",\"playedAtRecency\":\"1h 22m 42s ago\",\"stats\":[{\"gamertag\":\"Abogadazo\",\"won\":false,\"score\":3,\"kills\":3,\"deaths\":2,\"assists\":0,\"headshots\":0,\"medals\":3,\"killDeathRatio\":1.5,\"headshotRate\":0}]},{\"gamertags\":[\"Abogadazo\"],\"gamertagsAbsent\":[\"UglyCurtains\"],\"gameVariant\":\"Infection\",\"mapId\":209,\"squadWon\":false,\"playedAt\":\"2021-09-23T04:01:05.552Z\",\"playedAtRecency\":\"1h 31m 8s ago\",\"stats\":[{\"gamertag\":\"Abogadazo\",\"won\":false,\"score\":7,\"kills\":1,\"deaths\":9,\"assists\":0,\"headshots\":0,\"medals\":7,\"killDeathRatio\":0.1111111111111111,\"headshotRate\":0}]},{\"gamertags\":[\"Abogadazo\"],\"gamertagsAbsent\":[\"UglyCurtains\"],\"gameVariant\":\"Infection\",\"mapId\":209,\"squadWon\":false,\"playedAt\":\"2021-09-23T03:46:32.187Z\",\"playedAtRecency\":\"1h 45m 41s ago\",\"stats\":[{\"gamertag\":\"Abogadazo\",\"won\":false,\"score\":0,\"kills\":0,\"deaths\":5,\"assists\":0,\"headshots\":0,\"medals\":0,\"killDeathRatio\":0,\"headshotRate\":0}]},{\"gamertags\":[\"Abogadazo\"],\"gamertagsAbsent\":[\"UglyCurtains\"],\"gameVariant\":\"Slayer\",\"mapId\":203,\"squadWon\":false,\"playedAt\":\"2021-09-23T03:30:16.314Z\",\"playedAtRecency\":\"2h 1m 57s ago\",\"stats\":[{\"gamertag\":\"Abogadazo\",\"won\":false,\"score\":4,\"kills\":4,\"deaths\":11,\"assists\":0,\"headshots\":0,\"medals\":5,\"killDeathRatio\":0.36363636363636365,\"headshotRate\":0}]},{\"gamertags\":[\"Abogadazo\"],\"gamertagsAbsent\":[\"UglyCurtains\"],\"gameVariant\":\"Slayer\",\"mapId\":221,\"squadWon\":false,\"playedAt\":\"2021-09-23T03:22:56.264Z\",\"playedAtRecency\":\"2h 9m 17s ago\",\"stats\":[{\"gamertag\":\"Abogadazo\",\"won\":false,\"score\":3,\"kills\":6,\"deaths\":13,\"assists\":0,\"headshots\":0,\"medals\":4,\"killDeathRatio\":0.46153846153846156,\"headshotRate\":0}]}]}'\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "RfQ2ih7nI7u7"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}