ranking_info.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Get Ranking Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import sys\n",
    "import json\n",
    "import time\n",
    "import datetime\n",
    "from importlib import reload\n",
    "\n",
    "import requests\n",
    "\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "import external as ext"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('telemetry_data/2020-04-09/pc/4c76d82b-90f7-4fd1-9ceb-97b99347e94e.json', 'r') as file:\n",
    "    json_data = file.read()\n",
    "    file.close()\n",
    "data = []\n",
    "matchdef = []\n",
    "for i in json.loads(json_data):\n",
    "    if i[\"_T\"] in (\"LogMatchEnd\"):\n",
    "        data.append(i)\n",
    "    if i[\"_T\"] in (\"LogMatchDefinition\"):\n",
    "        matchdef.append(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'MatchId': 'match.bro.official.pc-2018-06.steam.squad.na.2020.04.08.22.4c76d82b-90f7-4fd1-9ceb-97b99347e94e',\n",
       " 'PingQuality': '',\n",
       " 'SeasonState': 'progress',\n",
       " '_D': '2020-04-08T22:34:53.6992989Z',\n",
       " '_T': 'LogMatchDefinition'}"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "matchdef[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'characters': [{'character': {'name': 'OMGNOWAYTHATSBS',\n",
       "     'teamId': 8,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 7,\n",
       "     'accountId': 'account.54a138a899ea43919a51de65323d9287',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Cadenn',\n",
       "     'teamId': 7,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 19,\n",
       "     'accountId': 'account.fa20a446eea64586b4033135908d921a',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'LOCKLOAD007',\n",
       "     'teamId': 8,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 7,\n",
       "     'accountId': 'account.749c1f3bc22841ccb17fd9aa3e65bccf',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Kev1nMo',\n",
       "     'teamId': 6,\n",
       "     'health': 28.304319381713867,\n",
       "     'location': {'x': 542791.9375, 'y': 235284.71875, 'z': 8026.48974609375},\n",
       "     'ranking': 1,\n",
       "     'accountId': 'account.6c124c8a6df840308d5ccd5324871b44',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': 'WeapSCAR-L_C',\n",
       "    'primaryWeaponSecond': 'WeapKar98k_C',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Diesvtfocus',\n",
       "     'teamId': 27,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 17,\n",
       "     'accountId': 'account.41435623c76a4bae90077cbce53601a3',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'LDrai29',\n",
       "     'teamId': 27,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 17,\n",
       "     'accountId': 'account.d9863a055ddd4cf8b192fc7a094692c3',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'FriedeggMan',\n",
       "     'teamId': 15,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 17,\n",
       "     'accountId': 'account.39ce2adafa4340fca6a983d59ed8a307',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'GoatStalker',\n",
       "     'teamId': 17,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 9,\n",
       "     'accountId': 'account.fc9fa62d67d84a33a25f29383d392e94',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'DeathSs_LiuDeHua',\n",
       "     'teamId': 5,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 13,\n",
       "     'accountId': 'account.93785a3f37e041ed8fe9221f9e8b9ca5',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'AEPs4O4',\n",
       "     'teamId': 6,\n",
       "     'health': 0,\n",
       "     'location': {'x': 540085.9375, 'y': 233765.859375, 'z': 8134.33984375},\n",
       "     'ranking': 1,\n",
       "     'accountId': 'account.acd6626ba55f4f128e3395a627b4d2da',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': 'WeapAK47_C',\n",
       "    'primaryWeaponSecond': 'WeapKar98k_C',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'molahhh',\n",
       "     'teamId': 9,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 3,\n",
       "     'accountId': 'account.e6798bd0974349519ff0437fffc4e25f',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'KQ_ZhanDouJi',\n",
       "     'teamId': 22,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 2,\n",
       "     'accountId': 'account.22528554f5594e39aa5f7c150d7a97a0',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Odmin',\n",
       "     'teamId': 2,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 6,\n",
       "     'accountId': 'account.038f96e8563f4e03af57d48c684d7773',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': '10Baerini',\n",
       "     'teamId': 9,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 3,\n",
       "     'accountId': 'account.5698432e17984521aad0f1c62923d24a',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'spekture',\n",
       "     'teamId': 1,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 20,\n",
       "     'accountId': 'account.6b46d60583254839bf6e8c3df814f115',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'ChiWoDaDiao-',\n",
       "     'teamId': 5,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 13,\n",
       "     'accountId': 'account.c2200a42a77349e582788e9a6081aeb4',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Bubbabear85',\n",
       "     'teamId': 8,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 7,\n",
       "     'accountId': 'account.50adcc0db4de465aa9ae3b726498f5c7',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Mac_1205',\n",
       "     'teamId': 1,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 20,\n",
       "     'accountId': 'account.aae7ef8724284447953034a9ccbe89aa',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Youlaoban',\n",
       "     'teamId': 5,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 13,\n",
       "     'accountId': 'account.c3d2339935824cdc9e55f9c7b575e355',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Neal_No1',\n",
       "     'teamId': 2,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 10,\n",
       "     'accountId': 'account.98a361b6ee494c9c8ae2c3f739415a84',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Dyrand',\n",
       "     'teamId': 12,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 20,\n",
       "     'accountId': 'account.c83a131297394d01a64a9a080e03372e',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Asin_Sira',\n",
       "     'teamId': 1,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 20,\n",
       "     'accountId': 'account.154d4fd125a348e9a1f8df2daaabd9cb',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Jubly',\n",
       "     'teamId': 12,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 18,\n",
       "     'accountId': 'account.b0f435dcdede464e9beca298f4e6b90c',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'duoduobaby0613',\n",
       "     'teamId': 22,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 2,\n",
       "     'accountId': 'account.dfdb53bf20534cffa29b7207076923d2',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'THE_IRONMAFIA',\n",
       "     'teamId': 2,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 12,\n",
       "     'accountId': 'account.c7c9bf6dae124f5cb98cf581e0ce2c6d',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'BIU-DDDSJ',\n",
       "     'teamId': 10,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 21,\n",
       "     'accountId': 'account.e60bd0f0cc8040b6a5c0a49d5ad1cdc3',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'AhYeahAhYeah',\n",
       "     'teamId': 7,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 19,\n",
       "     'accountId': 'account.38fab72c58f74955b1cc6b780b1c7417',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'YEzi_YearSzy',\n",
       "     'teamId': 6,\n",
       "     'health': 22.356653213500977,\n",
       "     'location': {'x': 542912.0625, 'y': 232125.53125, 'z': 7308.6396484375},\n",
       "     'ranking': 1,\n",
       "     'accountId': 'account.9f0da77bfcab40149791be996d9e2e59',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': 'WeapM24_C',\n",
       "    'primaryWeaponSecond': 'WeapHK416_C',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'wvwi21',\n",
       "     'teamId': 10,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 21,\n",
       "     'accountId': 'account.24b7ed5249a44a968e20d5b3387a951c',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'HotDoggHands',\n",
       "     'teamId': 27,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 17,\n",
       "     'accountId': 'account.1b9f91fb61504402b9774fcfa430e57e',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Landpuss',\n",
       "     'teamId': 12,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 18,\n",
       "     'accountId': 'account.b2875d9ab5484d1aa41cbf9ba8e8ae2e',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'DougDimmadab',\n",
       "     'teamId': 12,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 18,\n",
       "     'accountId': 'account.c9c4480e5fa348dfa7d1a14a29ba87dc',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'heysasa',\n",
       "     'teamId': 7,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 19,\n",
       "     'accountId': 'account.e4464ed974c441bbaf5d75342810bcad',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'L4_Desweet',\n",
       "     'teamId': 7,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 19,\n",
       "     'accountId': 'account.4b0e221bb7b441218123956666fcc5c5',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'AKA447',\n",
       "     'teamId': 9,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 3,\n",
       "     'accountId': 'account.4b3dcc0c663846c59981fb53f61eaf19',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'HITECHPLUMBER69',\n",
       "     'teamId': 2,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 6,\n",
       "     'accountId': 'account.08c1815b804c4b1494002f149c6d6601',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'KillerDong7',\n",
       "     'teamId': 13,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 12,\n",
       "     'accountId': 'account.0261932f6e834d23a1e5af9641e81a07',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'GGHumannn',\n",
       "     'teamId': 13,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 12,\n",
       "     'accountId': 'account.1c38aec23e5e4a458a210a6d16c8eca5',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'ReaPer_LiQAQ',\n",
       "     'teamId': 14,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 8,\n",
       "     'accountId': 'account.79208548b044413bb761d34f19783a49',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': '7ooc_-_',\n",
       "     'teamId': 14,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 8,\n",
       "     'accountId': 'account.79c2f8876c4840a3a8de76d5be3ddf71',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Thursty1991',\n",
       "     'teamId': 13,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 4,\n",
       "     'accountId': 'account.a2fd712cae2241179afc28e05170e306',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'XxGoldenFlashxX',\n",
       "     'teamId': 15,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 12,\n",
       "     'accountId': 'account.3a5ff17681354a0982a7e8caa7b74b17',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'SneakyFokker',\n",
       "     'teamId': 13,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 4,\n",
       "     'accountId': 'account.6161f979fe184888bb9b733cc18960c7',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'VX15872277853',\n",
       "     'teamId': 14,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 8,\n",
       "     'accountId': 'account.542278ff8be14ac08a1b3de2877b4a7c',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'SLyx7cIOs',\n",
       "     'teamId': 6,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 1,\n",
       "     'accountId': 'account.e4d70b1f31ce451fa55e46eb95278715',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'guibum',\n",
       "     'teamId': 15,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 17,\n",
       "     'accountId': 'account.7fc7e4f15d65427790dea654a9b86c69',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Noir_Fox',\n",
       "     'teamId': 16,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 16,\n",
       "     'accountId': 'account.4c781ea0678c46ce8b27dc6c66d543b6',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'ptz251zb',\n",
       "     'teamId': 16,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 16,\n",
       "     'accountId': 'account.0fdde91555614333a012cc93f30d1372',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'chewy7318',\n",
       "     'teamId': 16,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 16,\n",
       "     'accountId': 'account.385a9f5436af46cf968ffff7219bc696',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'SQ46',\n",
       "     'teamId': 16,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 16,\n",
       "     'accountId': 'account.1b8f4326cdb44cd6ac1c99a3d2182e5d',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'jtbullet',\n",
       "     'teamId': 17,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 12,\n",
       "     'accountId': 'account.bdc00b85422c4807bdc3de91d56be5d6',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'mattbarn',\n",
       "     'teamId': 27,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 17,\n",
       "     'accountId': 'account.1093943b709c4a39b37343249ac8a65d',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'MiracleMan74',\n",
       "     'teamId': 19,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 15,\n",
       "     'accountId': 'account.0d8958712dab4d8da4ac5183f2c2385a',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'riteintheas',\n",
       "     'teamId': 17,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 12,\n",
       "     'accountId': 'account.1d52dff3cfbf4e5b95020a71f84f0c63',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Ryjack22',\n",
       "     'teamId': 19,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 19,\n",
       "     'accountId': 'account.62d34dd73cf54e41b2447d172c9609f3',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': '8255',\n",
       "     'teamId': 20,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 5,\n",
       "     'accountId': 'account.f3c3476295344033b5f098651acc73e7',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'G7_WenG',\n",
       "     'teamId': 20,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 5,\n",
       "     'accountId': 'account.0b4c6fd0d4d84cb69ad625fc35c87721',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': '8344',\n",
       "     'teamId': 20,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 5,\n",
       "     'accountId': 'account.ff1ec4f49b224de8a8107bc73fae0081',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'KILLer___AJ',\n",
       "     'teamId': 20,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 5,\n",
       "     'accountId': 'account.824eb122d6a543d9a0e372ffc9657ecd',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'kfox7197',\n",
       "     'teamId': 21,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 10,\n",
       "     'accountId': 'account.6edabfe353ef4a12835f740fcf198c76',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Lavinn-',\n",
       "     'teamId': 17,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 12,\n",
       "     'accountId': 'account.1f660c04029a489d92822e0282be22a0',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'CALLAHYM',\n",
       "     'teamId': 19,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 15,\n",
       "     'accountId': 'account.5adf56e2126c495ebbe51050b77fba5d',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Badbart314',\n",
       "     'teamId': 19,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 15,\n",
       "     'accountId': 'account.3354b9d270014aa2828dd4f5a12b2776',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Elessare',\n",
       "     'teamId': 22,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 2,\n",
       "     'accountId': 'account.1750c61aa81441f6a9dcf81ed98196b6',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': '7Burial',\n",
       "     'teamId': 22,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 2,\n",
       "     'accountId': 'account.3759e2262f4c492cbd989527b78345b5',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'The_Bryonic_Man',\n",
       "     'teamId': 21,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 15,\n",
       "     'accountId': 'account.e5be34fde69841ab9cf6b6681482d9d2',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Bob_Roberts',\n",
       "     'teamId': 21,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 10,\n",
       "     'accountId': 'account.aaccc75f95d5416ebf19960691dc13c6',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Solomon5968',\n",
       "     'teamId': 21,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 15,\n",
       "     'accountId': 'account.d22cd0ef458c411caef12c9f5db9ea27',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'INOV77',\n",
       "     'teamId': 23,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 14,\n",
       "     'accountId': 'account.ffad5b1280314f6dab6a48d6cf8cdf54',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Azarothe',\n",
       "     'teamId': 23,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 14,\n",
       "     'accountId': 'account.c54691c19cfd49c1bbd3ce003104dc49',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Faxe99',\n",
       "     'teamId': 23,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 17,\n",
       "     'accountId': 'account.eedb2af394cf40c2bc5809264a43df99',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Mondoja',\n",
       "     'teamId': 25,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 11,\n",
       "     'accountId': 'account.430e7112176d4d849d2a873e19ec199e',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'dxnub',\n",
       "     'teamId': 1,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 20,\n",
       "     'accountId': 'account.f41a6e2001664439b818784d15ffc124',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Dancingly',\n",
       "     'teamId': 25,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 11,\n",
       "     'accountId': 'account.c4f12abe7d2143bdbb3d4a9ea4ccd31e',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'BLAVKMUSIKPCXB',\n",
       "     'teamId': 23,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 18,\n",
       "     'accountId': 'account.c3baffb7b59f424cb8e0234e8a3d5542',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0},\n",
       "   {'character': {'name': 'Fudorin',\n",
       "     'teamId': 25,\n",
       "     'health': 0,\n",
       "     'location': {'x': 0, 'y': 0, 'z': 0},\n",
       "     'ranking': 11,\n",
       "     'accountId': 'account.6122a9daf65d448b930772a88651b53c',\n",
       "     'isInBlueZone': False,\n",
       "     'isInRedZone': False,\n",
       "     'zone': []},\n",
       "    'primaryWeaponFirst': '',\n",
       "    'primaryWeaponSecond': '',\n",
       "    'secondaryWeapon': '',\n",
       "    'spawnKitIndex': 0}],\n",
       "  'gameResultOnFinished': {'results': [{'rank': 1,\n",
       "     'gameResult': '',\n",
       "     'teamId': 6,\n",
       "     'stats': {'killCount': 7,\n",
       "      'distanceOnFoot': 5550.08251953125,\n",
       "      'distanceOnSwim': 0,\n",
       "      'distanceOnVehicle': 409.9908752441406,\n",
       "      'distanceOnParachute': 368.70751953125,\n",
       "      'distanceOnFreefall': 1545.1412353515625},\n",
       "     'accountId': 'account.6c124c8a6df840308d5ccd5324871b44'},\n",
       "    {'rank': 1,\n",
       "     'gameResult': '',\n",
       "     'teamId': 6,\n",
       "     'stats': {'killCount': 0,\n",
       "      'distanceOnFoot': 6798.39501953125,\n",
       "      'distanceOnSwim': 0,\n",
       "      'distanceOnVehicle': 381.4901428222656,\n",
       "      'distanceOnParachute': 388.16644287109375,\n",
       "      'distanceOnFreefall': 1352.78759765625},\n",
       "     'accountId': 'account.acd6626ba55f4f128e3395a627b4d2da'},\n",
       "    {'rank': 1,\n",
       "     'gameResult': '',\n",
       "     'teamId': 6,\n",
       "     'stats': {'killCount': 5,\n",
       "      'distanceOnFoot': 5154.17724609375,\n",
       "      'distanceOnSwim': 0,\n",
       "      'distanceOnVehicle': 1267.192626953125,\n",
       "      'distanceOnParachute': 244.7891387939453,\n",
       "      'distanceOnFreefall': 1176.1556396484375},\n",
       "     'accountId': 'account.9f0da77bfcab40149791be996d9e2e59'},\n",
       "    {'rank': 1,\n",
       "     'gameResult': '',\n",
       "     'teamId': 6,\n",
       "     'stats': {'killCount': 6,\n",
       "      'distanceOnFoot': 5183.30517578125,\n",
       "      'distanceOnSwim': 0,\n",
       "      'distanceOnVehicle': 2536.70751953125,\n",
       "      'distanceOnParachute': 336.32806396484375,\n",
       "      'distanceOnFreefall': 1277.30126953125},\n",
       "     'accountId': 'account.e4d70b1f31ce451fa55e46eb95278715'}]},\n",
       "  'common': {'isGame': 7},\n",
       "  '_D': '2020-04-08T23:04:33.680Z',\n",
       "  '_T': 'LogMatchEnd'}]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "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>matchId</th>\n",
       "      <th>teamId</th>\n",
       "      <th>ranking</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>5</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>7</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>7</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>10</td>\n",
       "      <td>21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>12</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>13</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>14</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>11</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>15</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>12</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>13</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>17</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>14</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>19</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>15</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>20</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>16</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>21</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>17</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>22</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>18</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>23</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>19</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>25</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>20</td>\n",
       "      <td>match.bro.official.pc-2018-06.steam.squad.na.2...</td>\n",
       "      <td>27</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              matchId  teamId  ranking\n",
       "0   match.bro.official.pc-2018-06.steam.squad.na.2...       1       20\n",
       "1   match.bro.official.pc-2018-06.steam.squad.na.2...       2        6\n",
       "2   match.bro.official.pc-2018-06.steam.squad.na.2...       5       13\n",
       "3   match.bro.official.pc-2018-06.steam.squad.na.2...       6        1\n",
       "4   match.bro.official.pc-2018-06.steam.squad.na.2...       7       19\n",
       "5   match.bro.official.pc-2018-06.steam.squad.na.2...       8        7\n",
       "6   match.bro.official.pc-2018-06.steam.squad.na.2...       9        3\n",
       "7   match.bro.official.pc-2018-06.steam.squad.na.2...      10       21\n",
       "8   match.bro.official.pc-2018-06.steam.squad.na.2...      12       18\n",
       "9   match.bro.official.pc-2018-06.steam.squad.na.2...      13        4\n",
       "10  match.bro.official.pc-2018-06.steam.squad.na.2...      14        8\n",
       "11  match.bro.official.pc-2018-06.steam.squad.na.2...      15       12\n",
       "12  match.bro.official.pc-2018-06.steam.squad.na.2...      16       16\n",
       "13  match.bro.official.pc-2018-06.steam.squad.na.2...      17        9\n",
       "14  match.bro.official.pc-2018-06.steam.squad.na.2...      19       15\n",
       "15  match.bro.official.pc-2018-06.steam.squad.na.2...      20        5\n",
       "16  match.bro.official.pc-2018-06.steam.squad.na.2...      21       10\n",
       "17  match.bro.official.pc-2018-06.steam.squad.na.2...      22        2\n",
       "18  match.bro.official.pc-2018-06.steam.squad.na.2...      23       14\n",
       "19  match.bro.official.pc-2018-06.steam.squad.na.2...      25       11\n",
       "20  match.bro.official.pc-2018-06.steam.squad.na.2...      27       17"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "team = []\n",
    "rank  = []\n",
    "for i in data[0]['characters']:\n",
    "    team.append(i['character']['teamId'])\n",
    "    rank.append(i['character']['ranking'])\n",
    "    \n",
    "ranking = pd.DataFrame()\n",
    "ranking = pd.concat((pd.DataFrame(team, columns=['teamId']), pd.DataFrame(rank, columns = ['ranking'])), axis=1)\n",
    "ranking = ranking.drop_duplicates().sort_values(by='teamId').reset_index().drop(['index'], axis=1)\n",
    "indexes = []\n",
    "for team in ranking.teamId.unique():\n",
    "    indexes.append(ranking[ranking['teamId'] == team]['ranking'].idxmin())\n",
    "ranking = ranking[ranking.index.isin(indexes)].reset_index().drop(['index'], axis=1)\n",
    "ranking['matchId'] = matchdef[0][\"MatchId\"]\n",
    "ranking = ranking.reindex(columns = [\"matchId\", \"teamId\", \"ranking\"])\n",
    "ranking"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Get Full Match Id"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'MatchId': 'match.bro.official.pc-2018-06.steam.squad.na.2020.04.08.22.4c76d82b-90f7-4fd1-9ceb-97b99347e94e',\n",
       "  'PingQuality': '',\n",
       "  'SeasonState': 'progress',\n",
       "  '_D': '2020-04-08T22:34:53.6992989Z',\n",
       "  '_T': 'LogMatchDefinition'}]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "with open('telemetry_data/2020-04-09/pc/4c76d82b-90f7-4fd1-9ceb-97b99347e94e.json', 'r') as file:\n",
    "    json_data = file.read()\n",
    "    file.close()\n",
    "data = []\n",
    "for i in json.loads(json_data):\n",
    "    if i[\"_T\"] in (\"LogMatchDefinition\"):\n",
    "        data.append(i)\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}