data_analysis.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "c7b1fbc9",
   "metadata": {},
   "source": [
    "# Analyzing the Data\n",
    "- **Name: Andrew Angulo**\n",
    "- **Data Systems Project**\n",
    "\n",
    "The purpose of Analyzing the data is to visualize and represent the information we have stored within SQL, doing this further allows us to answer our central question: **are some characters are better than others based on their stats, and how much would the player have to invest in the game to acquire that character?**"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0ca1cdf4",
   "metadata": {},
   "source": [
    "---\n",
    "### Description of Imports:\n",
    "\n",
    "- we use **pandas** to represent our data from SQL into a tabular dataframe\n",
    "\n",
    "\n",
    "- we use **os.path** in order to obtain the file based on the location specificed within the computer\n",
    "\n",
    "\n",
    "- we use **json** so we are able to load data from a JSON files such as creds.json\n",
    "\n",
    "\n",
    "- we use **sqlalchemy** so we are able to interact with the SQL database\n",
    "\n",
    "\n",
    "- we use **math** so we can round numbers and are able to perform more mathematical abilities\n",
    "\n",
    "\n",
    "- we use **random** so we are able to retrieve a random set of numbers\n",
    "\n",
    "\n",
    "- we use **numpy** so we can use it in helping us displaying our data onto matplotlib\n",
    "\n",
    "\n",
    "- we use **matplotlib.pyplot** so we can print out a picture of our data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "ad33499d",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import os.path\n",
    "import json\n",
    "import sqlalchemy as sa\n",
    "import math\n",
    "import random\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "%load_ext sql"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e91eae0c",
   "metadata": {},
   "source": [
    "---\n",
    "### Utilizing the functions\n",
    "Below are functions that help us retrieve information in order to help us interact with the SQL database\n",
    "- **getsqlite_creds** : strings\n",
    "    - returns strings of the specificed content within creds.json\n",
    "    \n",
    "    \n",
    "- **buildConnectionString** : string\n",
    "    - returns a string with the specified path of the database file based on the previouse function"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "c1226613",
   "metadata": {},
   "outputs": [],
   "source": [
    "def getsqlite_creds(dirname=\".\",filename=\"creds.json\",source=\"sqlite\"):\n",
    "    \"\"\" Using directory and filename parameters, open a credentials file\n",
    "        and obtain the two parts needed for a connection string to\n",
    "        a local provider using the \"sqlite\" dictionary within\n",
    "        an outer dictionary.  \n",
    "        \n",
    "        Return a scheme and a dbfile\n",
    "    \"\"\"\n",
    "    assert os.path.isfile(os.path.join(dirname, filename))\n",
    "    with open(os.path.join(dirname, filename)) as f:\n",
    "        D = json.load(f)\n",
    "    sqlite = D[source]\n",
    "    return sqlite[\"scheme\"], sqlite[\"dbdir\"], sqlite[\"database\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "f8d4b1db",
   "metadata": {},
   "outputs": [],
   "source": [
    "def buildConnectionString(source):\n",
    "    scheme, dbdir, database = getsqlite_creds(source=source)\n",
    "    template = '{}:///{}/{}.db'\n",
    "    return template.format(scheme, dbdir, database)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b6ed2934",
   "metadata": {},
   "source": [
    "### Connecting to the SQL Database\n",
    "\n",
    "With all of the functions utilized above we are finally allowed to\n",
    "connect to the SQL database as if everything passed we connect to the engine"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "4a73f337",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Connection string: sqlite:///dbfile/arknights.db\n"
     ]
    }
   ],
   "source": [
    "# Build the conection string\n",
    "cstring = buildConnectionString(\"sqlite_arknights\")\n",
    "print(\"Connection string:\", cstring)\n",
    "\n",
    "# Connect to the database\n",
    "engine = sa.create_engine(cstring)\n",
    "connection = engine.connect()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "50630239",
   "metadata": {},
   "outputs": [],
   "source": [
    "%sql $cstring"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8c766cf8",
   "metadata": {},
   "source": [
    "### How is the data stored?\n",
    "Currently all of the data we are retrieving from the SQL database is stored in a **.db file** within the folder **dbfile**. Entering this file presents us with all of the tables that it contains. The tables within this database files also contains constraints which allows certain values to have a certain condition set to them\n",
    "\n",
    "### What Queries will I create?\n",
    "The queries I will create will be the following\n",
    "\n",
    "- **Query 1:**\n",
    "    - The first query will inner join operators table and banners table so it can present all of the characters stats of that upcoming banner\n",
    "    \n",
    "- **Query 2:**\n",
    "    - The second query will also do an inner join on operators table and popular table so it can show all of the stats  of the current popular characters\n",
    "    \n",
    "- **Query 3:**\n",
    "    - The third query will do an inner join on popular, banners, and operators so that it presents any of the popular characters that possibly come within the upcoming banners with their stats.\n",
    "    \n",
    "- **Query 4:**\n",
    "    - The forth and final query will do an inner join on operators and banners while grouping by characterID and bannerName and       filtering to see if their are characters upcoming with the specific result within their stats\n",
    "    \n",
    "### Does it adhere to the principles of good database design?\n",
    "Yes it does! Each column represent their own distinctive value, the databases are divided so our information are into subject-based tables. Our information also provides access to use inner joins from table to table. The attributes are used strictly for identification purposes such as identifying an operator and their stats! Overrall this database does apply with the principles of good database design!"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b73d28f0",
   "metadata": {},
   "source": [
    "---\n",
    "### Query1\n",
    "\n",
    "Now that we are connected to the SQL Database we are able to perform querys.\n",
    "Below is a query where it inner joins operators table and the banner table using characterID as the primary key. Looking at this SQL database allows us to visually think about if an upcoming character within the specific banner is worth to pull for based on their stats."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "db8bb934",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///dbfile/arknights.db\n",
      "Done.\n"
     ]
    },
    {
     "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>characterID</th>\n",
       "      <th>HP</th>\n",
       "      <th>ATK</th>\n",
       "      <th>DEF</th>\n",
       "      <th>COST</th>\n",
       "      <th>RES</th>\n",
       "      <th>BLOCK</th>\n",
       "      <th>REDEPLOY</th>\n",
       "      <th>INTERVAL</th>\n",
       "      <th>TARGET</th>\n",
       "      <th>DMG</th>\n",
       "      <th>ROLE</th>\n",
       "      <th>bannerName</th>\n",
       "      <th>ChineseDate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Blue Poison</td>\n",
       "      <td>1230</td>\n",
       "      <td>610</td>\n",
       "      <td>130</td>\n",
       "      <td>13</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Sniper</td>\n",
       "      <td>Dissonanzen</td>\n",
       "      <td>2022-06-09 - 2022-06-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ptilopsis</td>\n",
       "      <td>1610</td>\n",
       "      <td>390</td>\n",
       "      <td>150</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.85</td>\n",
       "      <td>3</td>\n",
       "      <td>Healing</td>\n",
       "      <td>Medic</td>\n",
       "      <td>Pathfinder of Sands</td>\n",
       "      <td>2022-07-05 - 2022-07-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Gavial the Invincible</td>\n",
       "      <td>2906</td>\n",
       "      <td>816</td>\n",
       "      <td>451</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>70</td>\n",
       "      <td>1.20</td>\n",
       "      <td>AoE</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Guard</td>\n",
       "      <td>Great Axe and Pen Nib - [Summer] Series Limite...</td>\n",
       "      <td>2022-08-11 - 2022-08-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Skyfire</td>\n",
       "      <td>1620</td>\n",
       "      <td>874</td>\n",
       "      <td>122</td>\n",
       "      <td>33</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.90</td>\n",
       "      <td>AoE</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Caster</td>\n",
       "      <td>Joint Operation 7</td>\n",
       "      <td>2022-08-25 - 2022-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Franka</td>\n",
       "      <td>3768</td>\n",
       "      <td>1011</td>\n",
       "      <td>260</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.50</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Guard</td>\n",
       "      <td>Never Vowed</td>\n",
       "      <td>2022-09-08 - 2022-09-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Jackie</td>\n",
       "      <td>2378</td>\n",
       "      <td>589</td>\n",
       "      <td>308</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>0.78</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Guard</td>\n",
       "      <td>The Front That Was</td>\n",
       "      <td>2022-09-27 - 2022-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Cliffheart</td>\n",
       "      <td>1970</td>\n",
       "      <td>835</td>\n",
       "      <td>340</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>70</td>\n",
       "      <td>1.80</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Specialist</td>\n",
       "      <td>Bearing and Sparks</td>\n",
       "      <td>2022-10-11 - 2022-10-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Texas the Omertosa</td>\n",
       "      <td>1598</td>\n",
       "      <td>659</td>\n",
       "      <td>320</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>0.93</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Specialist</td>\n",
       "      <td>Chop the Thorns: Open Circuits - Celebration S...</td>\n",
       "      <td>2022-11-01 - 2022-11-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Sora</td>\n",
       "      <td>1356</td>\n",
       "      <td>385</td>\n",
       "      <td>258</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1</td>\n",
       "      <td>Healing</td>\n",
       "      <td>Supporter</td>\n",
       "      <td>Joint Operation 8</td>\n",
       "      <td>2022-11-15 - 2022-11-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Pramanix</td>\n",
       "      <td>1605</td>\n",
       "      <td>495</td>\n",
       "      <td>102</td>\n",
       "      <td>12</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Supporter</td>\n",
       "      <td>Edelweiss' Vow Rerun</td>\n",
       "      <td>2022-12-01 - 2022-12-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Hibiscus the Purifier</td>\n",
       "      <td>1508</td>\n",
       "      <td>571</td>\n",
       "      <td>109</td>\n",
       "      <td>17</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Medic</td>\n",
       "      <td>Dissonanzen</td>\n",
       "      <td>2022-06-09 - 2022-06-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Greyy the Lightningbearer</td>\n",
       "      <td>1880</td>\n",
       "      <td>688</td>\n",
       "      <td>240</td>\n",
       "      <td>24</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.10</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Sniper</td>\n",
       "      <td>Pathfinder of Sands</td>\n",
       "      <td>2022-07-05 - 2022-07-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Pozyomka (Позёмка)</td>\n",
       "      <td>1802</td>\n",
       "      <td>946</td>\n",
       "      <td>223</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Sniper</td>\n",
       "      <td>Great Axe and Pen Nib - [Summer] Series Limite...</td>\n",
       "      <td>2022-08-11 - 2022-08-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Magallan</td>\n",
       "      <td>1403</td>\n",
       "      <td>509</td>\n",
       "      <td>140</td>\n",
       "      <td>12</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Supporter</td>\n",
       "      <td>Joint Operation 7</td>\n",
       "      <td>2022-08-25 - 2022-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Proviso</td>\n",
       "      <td>1298</td>\n",
       "      <td>578</td>\n",
       "      <td>102</td>\n",
       "      <td>15</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.90</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Supporter</td>\n",
       "      <td>Never Vowed</td>\n",
       "      <td>2022-09-08 - 2022-09-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Mudrock</td>\n",
       "      <td>4428</td>\n",
       "      <td>882</td>\n",
       "      <td>662</td>\n",
       "      <td>36</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>70</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Defender</td>\n",
       "      <td>The Front That Was</td>\n",
       "      <td>2022-09-27 - 2022-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Totter</td>\n",
       "      <td>1550</td>\n",
       "      <td>970</td>\n",
       "      <td>145</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.40</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Sniper</td>\n",
       "      <td>Bearing and Sparks</td>\n",
       "      <td>2022-10-11 - 2022-10-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Penance</td>\n",
       "      <td>4655</td>\n",
       "      <td>916</td>\n",
       "      <td>616</td>\n",
       "      <td>36</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>70</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Defender</td>\n",
       "      <td>Chop the Thorns: Open Circuits - Celebration S...</td>\n",
       "      <td>2022-11-01 - 2022-11-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Sesa</td>\n",
       "      <td>1655</td>\n",
       "      <td>918</td>\n",
       "      <td>123</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.80</td>\n",
       "      <td>AoE</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Sniper</td>\n",
       "      <td>Joint Operation 8</td>\n",
       "      <td>2022-11-15 - 2022-11-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Aurora</td>\n",
       "      <td>4027</td>\n",
       "      <td>956</td>\n",
       "      <td>695</td>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Defender</td>\n",
       "      <td>Edelweiss' Vow Rerun</td>\n",
       "      <td>2022-12-01 - 2022-12-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Ebenholz</td>\n",
       "      <td>1678</td>\n",
       "      <td>1550</td>\n",
       "      <td>135</td>\n",
       "      <td>25</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>3.00</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Caster</td>\n",
       "      <td>Dissonanzen</td>\n",
       "      <td>2022-06-09 - 2022-06-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Dorothy</td>\n",
       "      <td>1502</td>\n",
       "      <td>661</td>\n",
       "      <td>172</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>0.85</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Specialist</td>\n",
       "      <td>Pathfinder of Sands</td>\n",
       "      <td>2022-07-05 - 2022-07-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Cantabile</td>\n",
       "      <td>1917</td>\n",
       "      <td>590</td>\n",
       "      <td>297</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>35</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Vanguard</td>\n",
       "      <td>Great Axe and Pen Nib - [Summer] Series Limite...</td>\n",
       "      <td>2022-08-11 - 2022-08-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Bagpipe</td>\n",
       "      <td>2484</td>\n",
       "      <td>671</td>\n",
       "      <td>382</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Vanguard</td>\n",
       "      <td>Joint Operation 7</td>\n",
       "      <td>2022-08-25 - 2022-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Młynar</td>\n",
       "      <td>4266</td>\n",
       "      <td>385</td>\n",
       "      <td>502</td>\n",
       "      <td>12</td>\n",
       "      <td>15</td>\n",
       "      <td>3</td>\n",
       "      <td>70</td>\n",
       "      <td>1.20</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Guard</td>\n",
       "      <td>Never Vowed</td>\n",
       "      <td>2022-09-08 - 2022-09-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Whisperain</td>\n",
       "      <td>1632</td>\n",
       "      <td>532</td>\n",
       "      <td>119</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.85</td>\n",
       "      <td>1</td>\n",
       "      <td>Healing</td>\n",
       "      <td>Medic</td>\n",
       "      <td>The Front That Was</td>\n",
       "      <td>2022-09-27 - 2022-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Paprika</td>\n",
       "      <td>1866</td>\n",
       "      <td>489</td>\n",
       "      <td>171</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.85</td>\n",
       "      <td>1</td>\n",
       "      <td>Healing</td>\n",
       "      <td>Medic</td>\n",
       "      <td>Bearing and Sparks</td>\n",
       "      <td>2022-10-11 - 2022-10-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Lunacub</td>\n",
       "      <td>1836</td>\n",
       "      <td>1074</td>\n",
       "      <td>155</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.70</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Sniper</td>\n",
       "      <td>Chop the Thorns: Open Circuits - Celebration S...</td>\n",
       "      <td>2022-11-01 - 2022-11-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Ayerscarpe</td>\n",
       "      <td>2420</td>\n",
       "      <td>745</td>\n",
       "      <td>375</td>\n",
       "      <td>19</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>70</td>\n",
       "      <td>1.30</td>\n",
       "      <td>AoE</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Guard</td>\n",
       "      <td>Joint Operation 8</td>\n",
       "      <td>2022-11-15 - 2022-11-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Gnosis</td>\n",
       "      <td>2035</td>\n",
       "      <td>535</td>\n",
       "      <td>132</td>\n",
       "      <td>13</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Supporter</td>\n",
       "      <td>Edelweiss' Vow Rerun</td>\n",
       "      <td>2022-12-01 - 2022-12-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Shamare</td>\n",
       "      <td>1728</td>\n",
       "      <td>473</td>\n",
       "      <td>105</td>\n",
       "      <td>12</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Supporter</td>\n",
       "      <td>Joint Operation 7</td>\n",
       "      <td>2022-08-25 - 2022-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Roberta</td>\n",
       "      <td>2470</td>\n",
       "      <td>570</td>\n",
       "      <td>450</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>70</td>\n",
       "      <td>1.50</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Supporter</td>\n",
       "      <td>The Front That Was</td>\n",
       "      <td>2022-09-27 - 2022-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Stainless</td>\n",
       "      <td>2723</td>\n",
       "      <td>633</td>\n",
       "      <td>461</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>70</td>\n",
       "      <td>1.50</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Supporter</td>\n",
       "      <td>Bearing and Sparks</td>\n",
       "      <td>2022-10-11 - 2022-10-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Suzuran</td>\n",
       "      <td>1480</td>\n",
       "      <td>596</td>\n",
       "      <td>128</td>\n",
       "      <td>16</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.90</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Supporter</td>\n",
       "      <td>Joint Operation 8</td>\n",
       "      <td>2022-11-15 - 2022-11-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Mr. Nothing</td>\n",
       "      <td>2598</td>\n",
       "      <td>765</td>\n",
       "      <td>396</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Specialist</td>\n",
       "      <td>Joint Operation 7</td>\n",
       "      <td>2022-08-25 - 2022-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Mulberry</td>\n",
       "      <td>1517</td>\n",
       "      <td>423</td>\n",
       "      <td>99</td>\n",
       "      <td>15</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.85</td>\n",
       "      <td>1</td>\n",
       "      <td>Healing</td>\n",
       "      <td>Medic</td>\n",
       "      <td>The Front That Was</td>\n",
       "      <td>2022-09-27 - 2022-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Eunectes</td>\n",
       "      <td>4468</td>\n",
       "      <td>1077</td>\n",
       "      <td>685</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Defender</td>\n",
       "      <td>Joint Operation 8</td>\n",
       "      <td>2022-11-15 - 2022-11-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Toddifons</td>\n",
       "      <td>1667</td>\n",
       "      <td>1049</td>\n",
       "      <td>123</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.40</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Sniper</td>\n",
       "      <td>Joint Operation 7</td>\n",
       "      <td>2022-08-25 - 2022-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Saileach</td>\n",
       "      <td>1835</td>\n",
       "      <td>586</td>\n",
       "      <td>407</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.30</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Vanguard</td>\n",
       "      <td>The Front That Was</td>\n",
       "      <td>2022-09-27 - 2022-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Ashlock</td>\n",
       "      <td>3207</td>\n",
       "      <td>915</td>\n",
       "      <td>591</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>70</td>\n",
       "      <td>2.80</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Defender</td>\n",
       "      <td>Joint Operation 8</td>\n",
       "      <td>2022-11-15 - 2022-11-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Passenger</td>\n",
       "      <td>1558</td>\n",
       "      <td>774</td>\n",
       "      <td>130</td>\n",
       "      <td>33</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.30</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Caster</td>\n",
       "      <td>Joint Operation 7</td>\n",
       "      <td>2022-08-25 - 2022-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Chestnut</td>\n",
       "      <td>1237</td>\n",
       "      <td>424</td>\n",
       "      <td>101</td>\n",
       "      <td>14</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.85</td>\n",
       "      <td>1</td>\n",
       "      <td>Healing</td>\n",
       "      <td>Medic</td>\n",
       "      <td>The Front That Was</td>\n",
       "      <td>2022-09-27 - 2022-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Fartooth</td>\n",
       "      <td>1522</td>\n",
       "      <td>1296</td>\n",
       "      <td>163</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.70</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Sniper</td>\n",
       "      <td>Joint Operation 8</td>\n",
       "      <td>2022-11-15 - 2022-11-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Carnelian</td>\n",
       "      <td>2106</td>\n",
       "      <td>926</td>\n",
       "      <td>258</td>\n",
       "      <td>24</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.00</td>\n",
       "      <td>AoE</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Caster</td>\n",
       "      <td>Joint Operation 7</td>\n",
       "      <td>2022-08-25 - 2022-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>Rockrock</td>\n",
       "      <td>1468</td>\n",
       "      <td>380</td>\n",
       "      <td>123</td>\n",
       "      <td>21</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>80</td>\n",
       "      <td>1.30</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Caster</td>\n",
       "      <td>The Front That Was</td>\n",
       "      <td>2022-09-27 - 2022-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>Corroserum</td>\n",
       "      <td>1572</td>\n",
       "      <td>850</td>\n",
       "      <td>120</td>\n",
       "      <td>33</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.90</td>\n",
       "      <td>AoE</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Caster</td>\n",
       "      <td>Joint Operation 8</td>\n",
       "      <td>2022-11-15 - 2022-11-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>La Pluma</td>\n",
       "      <td>2250</td>\n",
       "      <td>725</td>\n",
       "      <td>452</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>70</td>\n",
       "      <td>1.30</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Guard</td>\n",
       "      <td>Joint Operation 7</td>\n",
       "      <td>2022-08-25 - 2022-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Horn</td>\n",
       "      <td>3367</td>\n",
       "      <td>1006</td>\n",
       "      <td>620</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>70</td>\n",
       "      <td>2.80</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Defender</td>\n",
       "      <td>The Front That Was</td>\n",
       "      <td>2022-09-27 - 2022-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>Goldenglow</td>\n",
       "      <td>1480</td>\n",
       "      <td>391</td>\n",
       "      <td>125</td>\n",
       "      <td>22</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.30</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Caster</td>\n",
       "      <td>Joint Operation 8</td>\n",
       "      <td>2022-11-15 - 2022-11-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>Mulberry</td>\n",
       "      <td>1517</td>\n",
       "      <td>423</td>\n",
       "      <td>99</td>\n",
       "      <td>15</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.85</td>\n",
       "      <td>1</td>\n",
       "      <td>Healing</td>\n",
       "      <td>Medic</td>\n",
       "      <td>Joint Operation 7</td>\n",
       "      <td>2022-08-25 - 2022-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Kazemaru</td>\n",
       "      <td>2372</td>\n",
       "      <td>772</td>\n",
       "      <td>318</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>70</td>\n",
       "      <td>1.20</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Specialist</td>\n",
       "      <td>Joint Operation 8</td>\n",
       "      <td>2022-11-15 - 2022-11-29</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  characterID    HP   ATK  DEF  COST  RES  BLOCK  REDEPLOY  \\\n",
       "0                 Blue Poison  1230   610  130    13    5      1        70   \n",
       "1                   Ptilopsis  1610   390  150    17    0      1        70   \n",
       "2       Gavial the Invincible  2906   816  451    24    0      3        70   \n",
       "3                     Skyfire  1620   874  122    33   20      1        70   \n",
       "4                      Franka  3768  1011  260    18    0      1        70   \n",
       "5                      Jackie  2378   589  308     9    0      1        70   \n",
       "6                  Cliffheart  1970   835  340    13    0      2        70   \n",
       "7          Texas the Omertosa  1598   659  320    10    0      1        18   \n",
       "8                        Sora  1356   385  258     7    0      1        70   \n",
       "9                    Pramanix  1605   495  102    12   25      1        70   \n",
       "10      Hibiscus the Purifier  1508   571  109    17   20      1        70   \n",
       "11  Greyy the Lightningbearer  1880   688  240    24   15      1        70   \n",
       "12         Pozyomka (Позёмка)  1802   946  223    20    0      1        70   \n",
       "13                   Magallan  1403   509  140    12   20      1        70   \n",
       "14                    Proviso  1298   578  102    15   20      1        70   \n",
       "15                    Mudrock  4428   882  662    36   10      3        70   \n",
       "16                     Totter  1550   970  145    22    0      1        70   \n",
       "17                    Penance  4655   916  616    36   10      3        70   \n",
       "18                       Sesa  1655   918  123    28    0      1        70   \n",
       "19                     Aurora  4027   956  695    32    0      1        70   \n",
       "20                   Ebenholz  1678  1550  135    25   20      1        70   \n",
       "21                    Dorothy  1502   661  172    12    0      1        70   \n",
       "22                  Cantabile  1917   590  297    10    0      1        35   \n",
       "23                    Bagpipe  2484   671  382    13    0      1        70   \n",
       "24                     Młynar  4266   385  502    12   15      3        70   \n",
       "25                 Whisperain  1632   532  119    20   10      1        70   \n",
       "26                    Paprika  1866   489  171    18    0      1        70   \n",
       "27                    Lunacub  1836  1074  155    21    0      1        70   \n",
       "28                 Ayerscarpe  2420   745  375    19   10      2        70   \n",
       "29                     Gnosis  2035   535  132    13   25      1        70   \n",
       "30                    Shamare  1728   473  105    12   25      1        70   \n",
       "31                    Roberta  2470   570  450    17    0      2        70   \n",
       "32                  Stainless  2723   633  461    19    0      2        70   \n",
       "33                    Suzuran  1480   596  128    16   25      1        70   \n",
       "34                Mr. Nothing  2598   765  396     8    0      1        25   \n",
       "35                   Mulberry  1517   423   99    15   10      1        70   \n",
       "36                   Eunectes  4468  1077  685    33    0      1        70   \n",
       "37                  Toddifons  1667  1049  123    23    0      1        70   \n",
       "38                   Saileach  1835   586  407    12    0      1        70   \n",
       "39                    Ashlock  3207   915  591    27    0      3        70   \n",
       "40                  Passenger  1558   774  130    33   20      1        70   \n",
       "41                   Chestnut  1237   424  101    14   10      1        70   \n",
       "42                   Fartooth  1522  1296  163    22    0      1        70   \n",
       "43                  Carnelian  2106   926  258    24   15      1        70   \n",
       "44                   Rockrock  1468   380  123    21   20      1        80   \n",
       "45                 Corroserum  1572   850  120    33   20      1        70   \n",
       "46                   La Pluma  2250   725  452    22    0      2        70   \n",
       "47                       Horn  3367  1006  620    28    0      3        70   \n",
       "48                 Goldenglow  1480   391  125    22   20      1        70   \n",
       "49                   Mulberry  1517   423   99    15   10      1        70   \n",
       "50                   Kazemaru  2372   772  318    15    0      2        70   \n",
       "\n",
       "    INTERVAL TARGET       DMG        ROLE  \\\n",
       "0       1.00      1  Physical      Sniper   \n",
       "1       2.85      3   Healing       Medic   \n",
       "2       1.20    AoE  Physical       Guard   \n",
       "3       2.90    AoE      Arts      Caster   \n",
       "4       1.50      1  Physical       Guard   \n",
       "5       0.78      1  Physical       Guard   \n",
       "6       1.80      1  Physical  Specialist   \n",
       "7       0.93      1  Physical  Specialist   \n",
       "8       1.00      1   Healing   Supporter   \n",
       "9       1.60      1      Arts   Supporter   \n",
       "10      1.60      1      Arts       Medic   \n",
       "11      2.10      1  Physical      Sniper   \n",
       "12      1.60      1  Physical      Sniper   \n",
       "13      1.60      1      Arts   Supporter   \n",
       "14      1.90      1      Arts   Supporter   \n",
       "15      1.60      1  Physical    Defender   \n",
       "16      2.40      1  Physical      Sniper   \n",
       "17      1.60      1  Physical    Defender   \n",
       "18      2.80    AoE  Physical      Sniper   \n",
       "19      1.60      1  Physical    Defender   \n",
       "20      3.00      1      Arts      Caster   \n",
       "21      0.85      1  Physical  Specialist   \n",
       "22      1.00      1  Physical    Vanguard   \n",
       "23      1.00      1  Physical    Vanguard   \n",
       "24      1.20      1  Physical       Guard   \n",
       "25      2.85      1   Healing       Medic   \n",
       "26      2.85      1   Healing       Medic   \n",
       "27      2.70      1  Physical      Sniper   \n",
       "28      1.30    AoE  Physical       Guard   \n",
       "29      1.60      1      Arts   Supporter   \n",
       "30      1.60      1      Arts   Supporter   \n",
       "31      1.50      1  Physical   Supporter   \n",
       "32      1.50      1  Physical   Supporter   \n",
       "33      1.90      1      Arts   Supporter   \n",
       "34      1.00      1  Physical  Specialist   \n",
       "35      2.85      1   Healing       Medic   \n",
       "36      1.60      1  Physical    Defender   \n",
       "37      2.40      1  Physical      Sniper   \n",
       "38      1.30      1  Physical    Vanguard   \n",
       "39      2.80      1  Physical    Defender   \n",
       "40      2.30      1      Arts      Caster   \n",
       "41      2.85      1   Healing       Medic   \n",
       "42      2.70      1  Physical      Sniper   \n",
       "43      2.00    AoE      Arts      Caster   \n",
       "44      1.30      1      Arts      Caster   \n",
       "45      2.90    AoE      Arts      Caster   \n",
       "46      1.30      1  Physical       Guard   \n",
       "47      2.80      1  Physical    Defender   \n",
       "48      1.30      1      Arts      Caster   \n",
       "49      2.85      1   Healing       Medic   \n",
       "50      1.20      1  Physical  Specialist   \n",
       "\n",
       "                                           bannerName              ChineseDate  \n",
       "0                                         Dissonanzen  2022-06-09 - 2022-06-23  \n",
       "1                                 Pathfinder of Sands  2022-07-05 - 2022-07-19  \n",
       "2   Great Axe and Pen Nib - [Summer] Series Limite...  2022-08-11 - 2022-08-25  \n",
       "3                                   Joint Operation 7  2022-08-25 - 2022-09-08  \n",
       "4                                         Never Vowed  2022-09-08 - 2022-09-22  \n",
       "5                                  The Front That Was  2022-09-27 - 2022-10-11  \n",
       "6                                  Bearing and Sparks  2022-10-11 - 2022-10-25  \n",
       "7   Chop the Thorns: Open Circuits - Celebration S...  2022-11-01 - 2022-11-15  \n",
       "8                                   Joint Operation 8  2022-11-15 - 2022-11-29  \n",
       "9                                Edelweiss' Vow Rerun  2022-12-01 - 2022-12-15  \n",
       "10                                        Dissonanzen  2022-06-09 - 2022-06-23  \n",
       "11                                Pathfinder of Sands  2022-07-05 - 2022-07-19  \n",
       "12  Great Axe and Pen Nib - [Summer] Series Limite...  2022-08-11 - 2022-08-25  \n",
       "13                                  Joint Operation 7  2022-08-25 - 2022-09-08  \n",
       "14                                        Never Vowed  2022-09-08 - 2022-09-22  \n",
       "15                                 The Front That Was  2022-09-27 - 2022-10-11  \n",
       "16                                 Bearing and Sparks  2022-10-11 - 2022-10-25  \n",
       "17  Chop the Thorns: Open Circuits - Celebration S...  2022-11-01 - 2022-11-15  \n",
       "18                                  Joint Operation 8  2022-11-15 - 2022-11-29  \n",
       "19                               Edelweiss' Vow Rerun  2022-12-01 - 2022-12-15  \n",
       "20                                        Dissonanzen  2022-06-09 - 2022-06-23  \n",
       "21                                Pathfinder of Sands  2022-07-05 - 2022-07-19  \n",
       "22  Great Axe and Pen Nib - [Summer] Series Limite...  2022-08-11 - 2022-08-25  \n",
       "23                                  Joint Operation 7  2022-08-25 - 2022-09-08  \n",
       "24                                        Never Vowed  2022-09-08 - 2022-09-22  \n",
       "25                                 The Front That Was  2022-09-27 - 2022-10-11  \n",
       "26                                 Bearing and Sparks  2022-10-11 - 2022-10-25  \n",
       "27  Chop the Thorns: Open Circuits - Celebration S...  2022-11-01 - 2022-11-15  \n",
       "28                                  Joint Operation 8  2022-11-15 - 2022-11-29  \n",
       "29                               Edelweiss' Vow Rerun  2022-12-01 - 2022-12-15  \n",
       "30                                  Joint Operation 7  2022-08-25 - 2022-09-08  \n",
       "31                                 The Front That Was  2022-09-27 - 2022-10-11  \n",
       "32                                 Bearing and Sparks  2022-10-11 - 2022-10-25  \n",
       "33                                  Joint Operation 8  2022-11-15 - 2022-11-29  \n",
       "34                                  Joint Operation 7  2022-08-25 - 2022-09-08  \n",
       "35                                 The Front That Was  2022-09-27 - 2022-10-11  \n",
       "36                                  Joint Operation 8  2022-11-15 - 2022-11-29  \n",
       "37                                  Joint Operation 7  2022-08-25 - 2022-09-08  \n",
       "38                                 The Front That Was  2022-09-27 - 2022-10-11  \n",
       "39                                  Joint Operation 8  2022-11-15 - 2022-11-29  \n",
       "40                                  Joint Operation 7  2022-08-25 - 2022-09-08  \n",
       "41                                 The Front That Was  2022-09-27 - 2022-10-11  \n",
       "42                                  Joint Operation 8  2022-11-15 - 2022-11-29  \n",
       "43                                  Joint Operation 7  2022-08-25 - 2022-09-08  \n",
       "44                                 The Front That Was  2022-09-27 - 2022-10-11  \n",
       "45                                  Joint Operation 8  2022-11-15 - 2022-11-29  \n",
       "46                                  Joint Operation 7  2022-08-25 - 2022-09-08  \n",
       "47                                 The Front That Was  2022-09-27 - 2022-10-11  \n",
       "48                                  Joint Operation 8  2022-11-15 - 2022-11-29  \n",
       "49                                  Joint Operation 7  2022-08-25 - 2022-09-08  \n",
       "50                                  Joint Operation 8  2022-11-15 - 2022-11-29  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "query1 = \"\"\"\n",
    "SELECT *\n",
    "FROM operators AS op INNER JOIN banners AS ban USING(characterID)\n",
    "\"\"\"\n",
    "\n",
    "\n",
    "resultset1 = %sql $query1\n",
    "resultdf1 = resultset1.DataFrame()\n",
    "\n",
    "resultdf1"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "47d6b238",
   "metadata": {},
   "source": [
    "### Query2\n",
    "\n",
    "Query 2 uses INNER JOIN within operators table and the popular table, thus results in returning a pandas datframe translated from SQL. The goal of this query is that it shows the top characters that are popular in the present day but at the same time it also presents the stats of that specific character. This helps us answer our central question because this allows the player to further assume if other characters are better than other characters they possibly had in mind"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "788303bb",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///dbfile/arknights.db\n",
      "Done.\n"
     ]
    },
    {
     "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>characterID</th>\n",
       "      <th>HP</th>\n",
       "      <th>ATK</th>\n",
       "      <th>DEF</th>\n",
       "      <th>COST</th>\n",
       "      <th>RES</th>\n",
       "      <th>BLOCK</th>\n",
       "      <th>REDEPLOY</th>\n",
       "      <th>INTERVAL</th>\n",
       "      <th>TARGET</th>\n",
       "      <th>DMG</th>\n",
       "      <th>ROLE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Skadi</td>\n",
       "      <td>3866</td>\n",
       "      <td>1095</td>\n",
       "      <td>303</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.50</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Guard</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Erato</td>\n",
       "      <td>1798</td>\n",
       "      <td>1027</td>\n",
       "      <td>125</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.40</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Sniper</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Mudrock</td>\n",
       "      <td>4428</td>\n",
       "      <td>882</td>\n",
       "      <td>662</td>\n",
       "      <td>36</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>70</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Defender</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Gladiia</td>\n",
       "      <td>2309</td>\n",
       "      <td>851</td>\n",
       "      <td>381</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>80</td>\n",
       "      <td>1.80</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Specialist</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Specter the Unchained</td>\n",
       "      <td>2803</td>\n",
       "      <td>817</td>\n",
       "      <td>322</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>70</td>\n",
       "      <td>1.20</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Specialist</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Surtr</td>\n",
       "      <td>2916</td>\n",
       "      <td>772</td>\n",
       "      <td>414</td>\n",
       "      <td>21</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.25</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Guard</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>La Pluma</td>\n",
       "      <td>2250</td>\n",
       "      <td>725</td>\n",
       "      <td>452</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>70</td>\n",
       "      <td>1.30</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Guard</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Irene</td>\n",
       "      <td>2935</td>\n",
       "      <td>701</td>\n",
       "      <td>369</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>70</td>\n",
       "      <td>1.30</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Guard</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Texas the Omertosa</td>\n",
       "      <td>1598</td>\n",
       "      <td>659</td>\n",
       "      <td>320</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>0.93</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Specialist</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Lumen</td>\n",
       "      <td>1825</td>\n",
       "      <td>585</td>\n",
       "      <td>141</td>\n",
       "      <td>23</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>80</td>\n",
       "      <td>2.85</td>\n",
       "      <td>1</td>\n",
       "      <td>Healing</td>\n",
       "      <td>Medic</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             characterID    HP   ATK  DEF  COST  RES  BLOCK  REDEPLOY  \\\n",
       "0                  Skadi  3866  1095  303    19    0      1        70   \n",
       "1                  Erato  1798  1027  125    23    0      1        70   \n",
       "2                Mudrock  4428   882  662    36   10      3        70   \n",
       "3                Gladiia  2309   851  381    16    0      2        80   \n",
       "4  Specter the Unchained  2803   817  322    16    0      2        70   \n",
       "5                  Surtr  2916   772  414    21   15      1        70   \n",
       "6               La Pluma  2250   725  452    22    0      2        70   \n",
       "7                  Irene  2935   701  369    23    0      2        70   \n",
       "8     Texas the Omertosa  1598   659  320    10    0      1        18   \n",
       "9                  Lumen  1825   585  141    23   10      1        80   \n",
       "\n",
       "   INTERVAL TARGET       DMG        ROLE  \n",
       "0      1.50      1  Physical       Guard  \n",
       "1      2.40      1  Physical      Sniper  \n",
       "2      1.60      1  Physical    Defender  \n",
       "3      1.80      1  Physical  Specialist  \n",
       "4      1.20      1  Physical  Specialist  \n",
       "5      1.25      1      Arts       Guard  \n",
       "6      1.30      1  Physical       Guard  \n",
       "7      1.30      1  Physical       Guard  \n",
       "8      0.93      1  Physical  Specialist  \n",
       "9      2.85      1   Healing       Medic  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "query2 = \"\"\"\n",
    "SELECT *\n",
    "FROM operators AS op INNER JOIN popular AS pop USING(characterID)\n",
    "ORDER BY ATK DESC\n",
    "\"\"\"\n",
    "\n",
    "\n",
    "resultset2 = %sql $query2\n",
    "resultdf2 = resultset2.DataFrame()\n",
    "\n",
    "resultdf2"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e1b1663d",
   "metadata": {},
   "source": [
    "### Query3\n",
    "\n",
    "Query 3 uses an INNER JOIN within the popular table and the banners table. The goal of this is to represent if any of the popular characters users are interested today are going to be available within the upcoming banners, this will allow users to question if they should save their resources for this upcoming banner to pull the desired operator."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "f177c09b",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///dbfile/arknights.db\n",
      "Done.\n"
     ]
    },
    {
     "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>characterID</th>\n",
       "      <th>bannerName</th>\n",
       "      <th>ChineseDate</th>\n",
       "      <th>HP</th>\n",
       "      <th>ATK</th>\n",
       "      <th>DEF</th>\n",
       "      <th>COST</th>\n",
       "      <th>RES</th>\n",
       "      <th>BLOCK</th>\n",
       "      <th>REDEPLOY</th>\n",
       "      <th>INTERVAL</th>\n",
       "      <th>TARGET</th>\n",
       "      <th>DMG</th>\n",
       "      <th>ROLE</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Texas the Omertosa</td>\n",
       "      <td>Chop the Thorns: Open Circuits - Celebration S...</td>\n",
       "      <td>2022-11-01 - 2022-11-15</td>\n",
       "      <td>1598</td>\n",
       "      <td>659</td>\n",
       "      <td>320</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>0.93</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Specialist</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Mudrock</td>\n",
       "      <td>The Front That Was</td>\n",
       "      <td>2022-09-27 - 2022-10-11</td>\n",
       "      <td>4428</td>\n",
       "      <td>882</td>\n",
       "      <td>662</td>\n",
       "      <td>36</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>70</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Defender</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>La Pluma</td>\n",
       "      <td>Joint Operation 7</td>\n",
       "      <td>2022-08-25 - 2022-09-08</td>\n",
       "      <td>2250</td>\n",
       "      <td>725</td>\n",
       "      <td>452</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>70</td>\n",
       "      <td>1.30</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Guard</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          characterID                                         bannerName  \\\n",
       "0  Texas the Omertosa  Chop the Thorns: Open Circuits - Celebration S...   \n",
       "1             Mudrock                                 The Front That Was   \n",
       "2            La Pluma                                  Joint Operation 7   \n",
       "\n",
       "               ChineseDate    HP  ATK  DEF  COST  RES  BLOCK  REDEPLOY  \\\n",
       "0  2022-11-01 - 2022-11-15  1598  659  320    10    0      1        18   \n",
       "1  2022-09-27 - 2022-10-11  4428  882  662    36   10      3        70   \n",
       "2  2022-08-25 - 2022-09-08  2250  725  452    22    0      2        70   \n",
       "\n",
       "   INTERVAL TARGET       DMG        ROLE  \n",
       "0      0.93      1  Physical  Specialist  \n",
       "1      1.60      1  Physical    Defender  \n",
       "2      1.30      1  Physical       Guard  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "query3 = \"\"\"\n",
    "SELECT *\n",
    "FROM popular AS pop INNER JOIN  banners AS ban USING(characterID) INNER JOIN operators as op USING(characterID)\n",
    "\"\"\"\n",
    "\n",
    "\n",
    "resultset3 = %sql $query3\n",
    "resultdf3 = resultset3.DataFrame()\n",
    "\n",
    "resultdf3"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "504c4f41",
   "metadata": {},
   "source": [
    "### Query4\n",
    "\n",
    "Query 4 uses an INNER JOIN between operators table and banners table while grouping by those two columns and filtering where the ATK an HP of a certain character is greater than a certain value. This allows us to see which characters within the upcoming banners are actually \"strong\" characters, this allows the user to consider getting these characters as they provide an edge at completing levels faster."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "8cdf920f",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///dbfile/arknights.db\n",
      "Done.\n"
     ]
    },
    {
     "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>characterID</th>\n",
       "      <th>HP</th>\n",
       "      <th>ATK</th>\n",
       "      <th>DEF</th>\n",
       "      <th>COST</th>\n",
       "      <th>RES</th>\n",
       "      <th>BLOCK</th>\n",
       "      <th>REDEPLOY</th>\n",
       "      <th>INTERVAL</th>\n",
       "      <th>TARGET</th>\n",
       "      <th>DMG</th>\n",
       "      <th>ROLE</th>\n",
       "      <th>bannerName</th>\n",
       "      <th>ChineseDate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ashlock</td>\n",
       "      <td>3207</td>\n",
       "      <td>915</td>\n",
       "      <td>591</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>70</td>\n",
       "      <td>2.80</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Defender</td>\n",
       "      <td>Joint Operation 8</td>\n",
       "      <td>2022-11-15 - 2022-11-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Aurora</td>\n",
       "      <td>4027</td>\n",
       "      <td>956</td>\n",
       "      <td>695</td>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Defender</td>\n",
       "      <td>Edelweiss' Vow Rerun</td>\n",
       "      <td>2022-12-01 - 2022-12-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ayerscarpe</td>\n",
       "      <td>2420</td>\n",
       "      <td>745</td>\n",
       "      <td>375</td>\n",
       "      <td>19</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>70</td>\n",
       "      <td>1.30</td>\n",
       "      <td>AoE</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Guard</td>\n",
       "      <td>Joint Operation 8</td>\n",
       "      <td>2022-11-15 - 2022-11-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Bagpipe</td>\n",
       "      <td>2484</td>\n",
       "      <td>671</td>\n",
       "      <td>382</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Vanguard</td>\n",
       "      <td>Joint Operation 7</td>\n",
       "      <td>2022-08-25 - 2022-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Blue Poison</td>\n",
       "      <td>1230</td>\n",
       "      <td>610</td>\n",
       "      <td>130</td>\n",
       "      <td>13</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Sniper</td>\n",
       "      <td>Dissonanzen</td>\n",
       "      <td>2022-06-09 - 2022-06-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Cantabile</td>\n",
       "      <td>1917</td>\n",
       "      <td>590</td>\n",
       "      <td>297</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>35</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Vanguard</td>\n",
       "      <td>Great Axe and Pen Nib - [Summer] Series Limite...</td>\n",
       "      <td>2022-08-11 - 2022-08-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Carnelian</td>\n",
       "      <td>2106</td>\n",
       "      <td>926</td>\n",
       "      <td>258</td>\n",
       "      <td>24</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.00</td>\n",
       "      <td>AoE</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Caster</td>\n",
       "      <td>Joint Operation 7</td>\n",
       "      <td>2022-08-25 - 2022-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Chestnut</td>\n",
       "      <td>1237</td>\n",
       "      <td>424</td>\n",
       "      <td>101</td>\n",
       "      <td>14</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.85</td>\n",
       "      <td>1</td>\n",
       "      <td>Healing</td>\n",
       "      <td>Medic</td>\n",
       "      <td>The Front That Was</td>\n",
       "      <td>2022-09-27 - 2022-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Cliffheart</td>\n",
       "      <td>1970</td>\n",
       "      <td>835</td>\n",
       "      <td>340</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>70</td>\n",
       "      <td>1.80</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Specialist</td>\n",
       "      <td>Bearing and Sparks</td>\n",
       "      <td>2022-10-11 - 2022-10-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Corroserum</td>\n",
       "      <td>1572</td>\n",
       "      <td>850</td>\n",
       "      <td>120</td>\n",
       "      <td>33</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.90</td>\n",
       "      <td>AoE</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Caster</td>\n",
       "      <td>Joint Operation 8</td>\n",
       "      <td>2022-11-15 - 2022-11-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Dorothy</td>\n",
       "      <td>1502</td>\n",
       "      <td>661</td>\n",
       "      <td>172</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>0.85</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Specialist</td>\n",
       "      <td>Pathfinder of Sands</td>\n",
       "      <td>2022-07-05 - 2022-07-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Gavial the Invincible</td>\n",
       "      <td>2906</td>\n",
       "      <td>816</td>\n",
       "      <td>451</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>70</td>\n",
       "      <td>1.20</td>\n",
       "      <td>AoE</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Guard</td>\n",
       "      <td>Great Axe and Pen Nib - [Summer] Series Limite...</td>\n",
       "      <td>2022-08-11 - 2022-08-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Gnosis</td>\n",
       "      <td>2035</td>\n",
       "      <td>535</td>\n",
       "      <td>132</td>\n",
       "      <td>13</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Supporter</td>\n",
       "      <td>Edelweiss' Vow Rerun</td>\n",
       "      <td>2022-12-01 - 2022-12-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Goldenglow</td>\n",
       "      <td>1480</td>\n",
       "      <td>391</td>\n",
       "      <td>125</td>\n",
       "      <td>22</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.30</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Caster</td>\n",
       "      <td>Joint Operation 8</td>\n",
       "      <td>2022-11-15 - 2022-11-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Greyy the Lightningbearer</td>\n",
       "      <td>1880</td>\n",
       "      <td>688</td>\n",
       "      <td>240</td>\n",
       "      <td>24</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.10</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Sniper</td>\n",
       "      <td>Pathfinder of Sands</td>\n",
       "      <td>2022-07-05 - 2022-07-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Hibiscus the Purifier</td>\n",
       "      <td>1508</td>\n",
       "      <td>571</td>\n",
       "      <td>109</td>\n",
       "      <td>17</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Medic</td>\n",
       "      <td>Dissonanzen</td>\n",
       "      <td>2022-06-09 - 2022-06-23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Jackie</td>\n",
       "      <td>2378</td>\n",
       "      <td>589</td>\n",
       "      <td>308</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>0.78</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Guard</td>\n",
       "      <td>The Front That Was</td>\n",
       "      <td>2022-09-27 - 2022-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Kazemaru</td>\n",
       "      <td>2372</td>\n",
       "      <td>772</td>\n",
       "      <td>318</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>70</td>\n",
       "      <td>1.20</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Specialist</td>\n",
       "      <td>Joint Operation 8</td>\n",
       "      <td>2022-11-15 - 2022-11-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>La Pluma</td>\n",
       "      <td>2250</td>\n",
       "      <td>725</td>\n",
       "      <td>452</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>70</td>\n",
       "      <td>1.30</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Guard</td>\n",
       "      <td>Joint Operation 7</td>\n",
       "      <td>2022-08-25 - 2022-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Magallan</td>\n",
       "      <td>1403</td>\n",
       "      <td>509</td>\n",
       "      <td>140</td>\n",
       "      <td>12</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Supporter</td>\n",
       "      <td>Joint Operation 7</td>\n",
       "      <td>2022-08-25 - 2022-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Mr. Nothing</td>\n",
       "      <td>2598</td>\n",
       "      <td>765</td>\n",
       "      <td>396</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Specialist</td>\n",
       "      <td>Joint Operation 7</td>\n",
       "      <td>2022-08-25 - 2022-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Mudrock</td>\n",
       "      <td>4428</td>\n",
       "      <td>882</td>\n",
       "      <td>662</td>\n",
       "      <td>36</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>70</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Defender</td>\n",
       "      <td>The Front That Was</td>\n",
       "      <td>2022-09-27 - 2022-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Mulberry</td>\n",
       "      <td>1517</td>\n",
       "      <td>423</td>\n",
       "      <td>99</td>\n",
       "      <td>15</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.85</td>\n",
       "      <td>1</td>\n",
       "      <td>Healing</td>\n",
       "      <td>Medic</td>\n",
       "      <td>Joint Operation 7</td>\n",
       "      <td>2022-08-25 - 2022-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Mulberry</td>\n",
       "      <td>1517</td>\n",
       "      <td>423</td>\n",
       "      <td>99</td>\n",
       "      <td>15</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.85</td>\n",
       "      <td>1</td>\n",
       "      <td>Healing</td>\n",
       "      <td>Medic</td>\n",
       "      <td>The Front That Was</td>\n",
       "      <td>2022-09-27 - 2022-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Młynar</td>\n",
       "      <td>4266</td>\n",
       "      <td>385</td>\n",
       "      <td>502</td>\n",
       "      <td>12</td>\n",
       "      <td>15</td>\n",
       "      <td>3</td>\n",
       "      <td>70</td>\n",
       "      <td>1.20</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Guard</td>\n",
       "      <td>Never Vowed</td>\n",
       "      <td>2022-09-08 - 2022-09-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Paprika</td>\n",
       "      <td>1866</td>\n",
       "      <td>489</td>\n",
       "      <td>171</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.85</td>\n",
       "      <td>1</td>\n",
       "      <td>Healing</td>\n",
       "      <td>Medic</td>\n",
       "      <td>Bearing and Sparks</td>\n",
       "      <td>2022-10-11 - 2022-10-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Passenger</td>\n",
       "      <td>1558</td>\n",
       "      <td>774</td>\n",
       "      <td>130</td>\n",
       "      <td>33</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.30</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Caster</td>\n",
       "      <td>Joint Operation 7</td>\n",
       "      <td>2022-08-25 - 2022-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Penance</td>\n",
       "      <td>4655</td>\n",
       "      <td>916</td>\n",
       "      <td>616</td>\n",
       "      <td>36</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>70</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Defender</td>\n",
       "      <td>Chop the Thorns: Open Circuits - Celebration S...</td>\n",
       "      <td>2022-11-01 - 2022-11-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Pozyomka (Позёмка)</td>\n",
       "      <td>1802</td>\n",
       "      <td>946</td>\n",
       "      <td>223</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Sniper</td>\n",
       "      <td>Great Axe and Pen Nib - [Summer] Series Limite...</td>\n",
       "      <td>2022-08-11 - 2022-08-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Pramanix</td>\n",
       "      <td>1605</td>\n",
       "      <td>495</td>\n",
       "      <td>102</td>\n",
       "      <td>12</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Supporter</td>\n",
       "      <td>Edelweiss' Vow Rerun</td>\n",
       "      <td>2022-12-01 - 2022-12-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Proviso</td>\n",
       "      <td>1298</td>\n",
       "      <td>578</td>\n",
       "      <td>102</td>\n",
       "      <td>15</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.90</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Supporter</td>\n",
       "      <td>Never Vowed</td>\n",
       "      <td>2022-09-08 - 2022-09-22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Ptilopsis</td>\n",
       "      <td>1610</td>\n",
       "      <td>390</td>\n",
       "      <td>150</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.85</td>\n",
       "      <td>3</td>\n",
       "      <td>Healing</td>\n",
       "      <td>Medic</td>\n",
       "      <td>Pathfinder of Sands</td>\n",
       "      <td>2022-07-05 - 2022-07-19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Roberta</td>\n",
       "      <td>2470</td>\n",
       "      <td>570</td>\n",
       "      <td>450</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>70</td>\n",
       "      <td>1.50</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Supporter</td>\n",
       "      <td>The Front That Was</td>\n",
       "      <td>2022-09-27 - 2022-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Rockrock</td>\n",
       "      <td>1468</td>\n",
       "      <td>380</td>\n",
       "      <td>123</td>\n",
       "      <td>21</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>80</td>\n",
       "      <td>1.30</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Caster</td>\n",
       "      <td>The Front That Was</td>\n",
       "      <td>2022-09-27 - 2022-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Saileach</td>\n",
       "      <td>1835</td>\n",
       "      <td>586</td>\n",
       "      <td>407</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.30</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Vanguard</td>\n",
       "      <td>The Front That Was</td>\n",
       "      <td>2022-09-27 - 2022-10-11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Sesa</td>\n",
       "      <td>1655</td>\n",
       "      <td>918</td>\n",
       "      <td>123</td>\n",
       "      <td>28</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.80</td>\n",
       "      <td>AoE</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Sniper</td>\n",
       "      <td>Joint Operation 8</td>\n",
       "      <td>2022-11-15 - 2022-11-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Shamare</td>\n",
       "      <td>1728</td>\n",
       "      <td>473</td>\n",
       "      <td>105</td>\n",
       "      <td>12</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Supporter</td>\n",
       "      <td>Joint Operation 7</td>\n",
       "      <td>2022-08-25 - 2022-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Skyfire</td>\n",
       "      <td>1620</td>\n",
       "      <td>874</td>\n",
       "      <td>122</td>\n",
       "      <td>33</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.90</td>\n",
       "      <td>AoE</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Caster</td>\n",
       "      <td>Joint Operation 7</td>\n",
       "      <td>2022-08-25 - 2022-09-08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Sora</td>\n",
       "      <td>1356</td>\n",
       "      <td>385</td>\n",
       "      <td>258</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1</td>\n",
       "      <td>Healing</td>\n",
       "      <td>Supporter</td>\n",
       "      <td>Joint Operation 8</td>\n",
       "      <td>2022-11-15 - 2022-11-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Stainless</td>\n",
       "      <td>2723</td>\n",
       "      <td>633</td>\n",
       "      <td>461</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>70</td>\n",
       "      <td>1.50</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Supporter</td>\n",
       "      <td>Bearing and Sparks</td>\n",
       "      <td>2022-10-11 - 2022-10-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Suzuran</td>\n",
       "      <td>1480</td>\n",
       "      <td>596</td>\n",
       "      <td>128</td>\n",
       "      <td>16</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>1.90</td>\n",
       "      <td>1</td>\n",
       "      <td>Arts</td>\n",
       "      <td>Supporter</td>\n",
       "      <td>Joint Operation 8</td>\n",
       "      <td>2022-11-15 - 2022-11-29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Texas the Omertosa</td>\n",
       "      <td>1598</td>\n",
       "      <td>659</td>\n",
       "      <td>320</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>0.93</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Specialist</td>\n",
       "      <td>Chop the Thorns: Open Circuits - Celebration S...</td>\n",
       "      <td>2022-11-01 - 2022-11-15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Totter</td>\n",
       "      <td>1550</td>\n",
       "      <td>970</td>\n",
       "      <td>145</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.40</td>\n",
       "      <td>1</td>\n",
       "      <td>Physical</td>\n",
       "      <td>Sniper</td>\n",
       "      <td>Bearing and Sparks</td>\n",
       "      <td>2022-10-11 - 2022-10-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Whisperain</td>\n",
       "      <td>1632</td>\n",
       "      <td>532</td>\n",
       "      <td>119</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>70</td>\n",
       "      <td>2.85</td>\n",
       "      <td>1</td>\n",
       "      <td>Healing</td>\n",
       "      <td>Medic</td>\n",
       "      <td>The Front That Was</td>\n",
       "      <td>2022-09-27 - 2022-10-11</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  characterID    HP  ATK  DEF  COST  RES  BLOCK  REDEPLOY  \\\n",
       "0                     Ashlock  3207  915  591    27    0      3        70   \n",
       "1                      Aurora  4027  956  695    32    0      1        70   \n",
       "2                  Ayerscarpe  2420  745  375    19   10      2        70   \n",
       "3                     Bagpipe  2484  671  382    13    0      1        70   \n",
       "4                 Blue Poison  1230  610  130    13    5      1        70   \n",
       "5                   Cantabile  1917  590  297    10    0      1        35   \n",
       "6                   Carnelian  2106  926  258    24   15      1        70   \n",
       "7                    Chestnut  1237  424  101    14   10      1        70   \n",
       "8                  Cliffheart  1970  835  340    13    0      2        70   \n",
       "9                  Corroserum  1572  850  120    33   20      1        70   \n",
       "10                    Dorothy  1502  661  172    12    0      1        70   \n",
       "11      Gavial the Invincible  2906  816  451    24    0      3        70   \n",
       "12                     Gnosis  2035  535  132    13   25      1        70   \n",
       "13                 Goldenglow  1480  391  125    22   20      1        70   \n",
       "14  Greyy the Lightningbearer  1880  688  240    24   15      1        70   \n",
       "15      Hibiscus the Purifier  1508  571  109    17   20      1        70   \n",
       "16                     Jackie  2378  589  308     9    0      1        70   \n",
       "17                   Kazemaru  2372  772  318    15    0      2        70   \n",
       "18                   La Pluma  2250  725  452    22    0      2        70   \n",
       "19                   Magallan  1403  509  140    12   20      1        70   \n",
       "20                Mr. Nothing  2598  765  396     8    0      1        25   \n",
       "21                    Mudrock  4428  882  662    36   10      3        70   \n",
       "22                   Mulberry  1517  423   99    15   10      1        70   \n",
       "23                   Mulberry  1517  423   99    15   10      1        70   \n",
       "24                     Młynar  4266  385  502    12   15      3        70   \n",
       "25                    Paprika  1866  489  171    18    0      1        70   \n",
       "26                  Passenger  1558  774  130    33   20      1        70   \n",
       "27                    Penance  4655  916  616    36   10      3        70   \n",
       "28         Pozyomka (Позёмка)  1802  946  223    20    0      1        70   \n",
       "29                   Pramanix  1605  495  102    12   25      1        70   \n",
       "30                    Proviso  1298  578  102    15   20      1        70   \n",
       "31                  Ptilopsis  1610  390  150    17    0      1        70   \n",
       "32                    Roberta  2470  570  450    17    0      2        70   \n",
       "33                   Rockrock  1468  380  123    21   20      1        80   \n",
       "34                   Saileach  1835  586  407    12    0      1        70   \n",
       "35                       Sesa  1655  918  123    28    0      1        70   \n",
       "36                    Shamare  1728  473  105    12   25      1        70   \n",
       "37                    Skyfire  1620  874  122    33   20      1        70   \n",
       "38                       Sora  1356  385  258     7    0      1        70   \n",
       "39                  Stainless  2723  633  461    19    0      2        70   \n",
       "40                    Suzuran  1480  596  128    16   25      1        70   \n",
       "41         Texas the Omertosa  1598  659  320    10    0      1        18   \n",
       "42                     Totter  1550  970  145    22    0      1        70   \n",
       "43                 Whisperain  1632  532  119    20   10      1        70   \n",
       "\n",
       "    INTERVAL TARGET       DMG        ROLE  \\\n",
       "0       2.80      1  Physical    Defender   \n",
       "1       1.60      1  Physical    Defender   \n",
       "2       1.30    AoE  Physical       Guard   \n",
       "3       1.00      1  Physical    Vanguard   \n",
       "4       1.00      1  Physical      Sniper   \n",
       "5       1.00      1  Physical    Vanguard   \n",
       "6       2.00    AoE      Arts      Caster   \n",
       "7       2.85      1   Healing       Medic   \n",
       "8       1.80      1  Physical  Specialist   \n",
       "9       2.90    AoE      Arts      Caster   \n",
       "10      0.85      1  Physical  Specialist   \n",
       "11      1.20    AoE  Physical       Guard   \n",
       "12      1.60      1      Arts   Supporter   \n",
       "13      1.30      1      Arts      Caster   \n",
       "14      2.10      1  Physical      Sniper   \n",
       "15      1.60      1      Arts       Medic   \n",
       "16      0.78      1  Physical       Guard   \n",
       "17      1.20      1  Physical  Specialist   \n",
       "18      1.30      1  Physical       Guard   \n",
       "19      1.60      1      Arts   Supporter   \n",
       "20      1.00      1  Physical  Specialist   \n",
       "21      1.60      1  Physical    Defender   \n",
       "22      2.85      1   Healing       Medic   \n",
       "23      2.85      1   Healing       Medic   \n",
       "24      1.20      1  Physical       Guard   \n",
       "25      2.85      1   Healing       Medic   \n",
       "26      2.30      1      Arts      Caster   \n",
       "27      1.60      1  Physical    Defender   \n",
       "28      1.60      1  Physical      Sniper   \n",
       "29      1.60      1      Arts   Supporter   \n",
       "30      1.90      1      Arts   Supporter   \n",
       "31      2.85      3   Healing       Medic   \n",
       "32      1.50      1  Physical   Supporter   \n",
       "33      1.30      1      Arts      Caster   \n",
       "34      1.30      1  Physical    Vanguard   \n",
       "35      2.80    AoE  Physical      Sniper   \n",
       "36      1.60      1      Arts   Supporter   \n",
       "37      2.90    AoE      Arts      Caster   \n",
       "38      1.00      1   Healing   Supporter   \n",
       "39      1.50      1  Physical   Supporter   \n",
       "40      1.90      1      Arts   Supporter   \n",
       "41      0.93      1  Physical  Specialist   \n",
       "42      2.40      1  Physical      Sniper   \n",
       "43      2.85      1   Healing       Medic   \n",
       "\n",
       "                                           bannerName              ChineseDate  \n",
       "0                                   Joint Operation 8  2022-11-15 - 2022-11-29  \n",
       "1                                Edelweiss' Vow Rerun  2022-12-01 - 2022-12-15  \n",
       "2                                   Joint Operation 8  2022-11-15 - 2022-11-29  \n",
       "3                                   Joint Operation 7  2022-08-25 - 2022-09-08  \n",
       "4                                         Dissonanzen  2022-06-09 - 2022-06-23  \n",
       "5   Great Axe and Pen Nib - [Summer] Series Limite...  2022-08-11 - 2022-08-25  \n",
       "6                                   Joint Operation 7  2022-08-25 - 2022-09-08  \n",
       "7                                  The Front That Was  2022-09-27 - 2022-10-11  \n",
       "8                                  Bearing and Sparks  2022-10-11 - 2022-10-25  \n",
       "9                                   Joint Operation 8  2022-11-15 - 2022-11-29  \n",
       "10                                Pathfinder of Sands  2022-07-05 - 2022-07-19  \n",
       "11  Great Axe and Pen Nib - [Summer] Series Limite...  2022-08-11 - 2022-08-25  \n",
       "12                               Edelweiss' Vow Rerun  2022-12-01 - 2022-12-15  \n",
       "13                                  Joint Operation 8  2022-11-15 - 2022-11-29  \n",
       "14                                Pathfinder of Sands  2022-07-05 - 2022-07-19  \n",
       "15                                        Dissonanzen  2022-06-09 - 2022-06-23  \n",
       "16                                 The Front That Was  2022-09-27 - 2022-10-11  \n",
       "17                                  Joint Operation 8  2022-11-15 - 2022-11-29  \n",
       "18                                  Joint Operation 7  2022-08-25 - 2022-09-08  \n",
       "19                                  Joint Operation 7  2022-08-25 - 2022-09-08  \n",
       "20                                  Joint Operation 7  2022-08-25 - 2022-09-08  \n",
       "21                                 The Front That Was  2022-09-27 - 2022-10-11  \n",
       "22                                  Joint Operation 7  2022-08-25 - 2022-09-08  \n",
       "23                                 The Front That Was  2022-09-27 - 2022-10-11  \n",
       "24                                        Never Vowed  2022-09-08 - 2022-09-22  \n",
       "25                                 Bearing and Sparks  2022-10-11 - 2022-10-25  \n",
       "26                                  Joint Operation 7  2022-08-25 - 2022-09-08  \n",
       "27  Chop the Thorns: Open Circuits - Celebration S...  2022-11-01 - 2022-11-15  \n",
       "28  Great Axe and Pen Nib - [Summer] Series Limite...  2022-08-11 - 2022-08-25  \n",
       "29                               Edelweiss' Vow Rerun  2022-12-01 - 2022-12-15  \n",
       "30                                        Never Vowed  2022-09-08 - 2022-09-22  \n",
       "31                                Pathfinder of Sands  2022-07-05 - 2022-07-19  \n",
       "32                                 The Front That Was  2022-09-27 - 2022-10-11  \n",
       "33                                 The Front That Was  2022-09-27 - 2022-10-11  \n",
       "34                                 The Front That Was  2022-09-27 - 2022-10-11  \n",
       "35                                  Joint Operation 8  2022-11-15 - 2022-11-29  \n",
       "36                                  Joint Operation 7  2022-08-25 - 2022-09-08  \n",
       "37                                  Joint Operation 7  2022-08-25 - 2022-09-08  \n",
       "38                                  Joint Operation 8  2022-11-15 - 2022-11-29  \n",
       "39                                 Bearing and Sparks  2022-10-11 - 2022-10-25  \n",
       "40                                  Joint Operation 8  2022-11-15 - 2022-11-29  \n",
       "41  Chop the Thorns: Open Circuits - Celebration S...  2022-11-01 - 2022-11-15  \n",
       "42                                 Bearing and Sparks  2022-10-11 - 2022-10-25  \n",
       "43                                 The Front That Was  2022-09-27 - 2022-10-11  "
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "query4 = \"\"\"\n",
    "SELECT *\n",
    "FROM operators AS op INNER JOIN  banners AS ban USING(characterID)\n",
    "GROUP BY characterID, bannerName\n",
    "HAVING ATK <= 1000 AND HP > 1000\n",
    "\"\"\"\n",
    "\n",
    "\n",
    "resultset4 = %sql $query4\n",
    "resultdf4 = resultset4.DataFrame()\n",
    "\n",
    "resultdf4"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c458f3d1",
   "metadata": {},
   "source": [
    "---\n",
    "### Creating Functions to compare and analyze our data\n",
    "\n",
    "In order to analyze out data further and further come to the conclusion to our central question to see **if some operators are better than other ones** building these functions will help us organize our data and allow us to come to our conclusion relatively simpler"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "4d1542a4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///dbfile/arknights.db\n",
      "Done.\n",
      "['Whisperain', 'Fang', 'Ayerscarpe', 'Firewatch', 'Shirayuki', 'Cardigan', 'Mulberry', 'Shirayuki', 'Bubble', 'Sesa', 'May', 'Greyy', 'Deepcolor', 'Gummy', 'Magallan', 'Matoimaru', 'Kafka', 'Deepcolor', 'Blue Poison', 'Greyy', 'Rope', 'Scavenger', 'Ansel', 'Mousse', 'Provence', 'Skyfire', 'Waai Fu', 'Beehunter', 'Beagle', 'Frostleaf', 'GreyThroat', 'Glaucus', 'Vigna']\n"
     ]
    }
   ],
   "source": [
    "def compareOperator(operator1, operator2):\n",
    "    \"\"\"\n",
    "    Returns a string of which\n",
    "    operator is better than one another\n",
    "    while grabbing data from a pandas dataframe taken\n",
    "    from a SQL database\n",
    "    \n",
    "    Parameters\n",
    "    ----------\n",
    "    operator1 : string\n",
    "        - The first parameter\n",
    "    operator2 : string\n",
    "        - The second parameter\n",
    "        \n",
    "    Returns\n",
    "    -------\n",
    "    String : String\n",
    "        - A string indicating which operator is better\n",
    "    \"\"\"\n",
    "    resultDict = {operator1: 0, operator2: 0}\n",
    "    character1 = resultdf1['characterID'].values == operator1\n",
    "    df_op1 = resultdf1.loc[character1]\n",
    "    character2 = resultdf1['characterID'].values == operator2\n",
    "    df_op2 = resultdf1.loc[character2]\n",
    "    compareDF = pd.concat([df_op1, df_op2]).set_index('characterID')\n",
    "    compareDict = pd.DataFrame.to_dict(compareDF)\n",
    "    for i in compareDict:\n",
    "        D = []\n",
    "        if(i == \"TARGET\"):\n",
    "            break\n",
    "        for j in list(compareDict[i].values()):\n",
    "            D.append(j)\n",
    "            if(len(D) >= 2):\n",
    "                if(D[0] > D[1]):\n",
    "                    resultDict[operator1] += 1\n",
    "                elif(D[0] == D[1]):\n",
    "                    resultDict[operator1] += 1\n",
    "                    resultDict[operator2] += 1\n",
    "                else:\n",
    "                    resultDict[operator2] += 1\n",
    "    if(resultDict[operator1] > resultDict[operator2]):\n",
    "        return operator1 + \" is better compared to \" + operator2\n",
    "    elif(resultDict[operator1] == resultDict[operator2]):\n",
    "        return operator1 + \" and \" + operator2 + \" are both equally good\"\n",
    "    return operator2 + \" is better compared to \" + operator1\n",
    "\n",
    "#-------------------------------------------------------------------------------#\n",
    "def orundumCalculator(current, days, daily_missions=True, monthlycard=False, weekly_annihilation=False):\n",
    "    \"\"\"\n",
    "    Returns the amount of orundums a user \n",
    "    will have after x amount of days\n",
    "    \n",
    "    Parameters\n",
    "    ----------\n",
    "    current : int\n",
    "        - The first parameter\n",
    "    days : int\n",
    "        - The second parameter\n",
    "    daily_missions : boolean\n",
    "        - The third parameter\n",
    "    monthlycard : boolean\n",
    "        - The fourth parameter\n",
    "    weekly_annihilation : boolean\n",
    "        - The fifth parameter\n",
    "        \n",
    "    Returns\n",
    "    -------\n",
    "    current : int\n",
    "        - An integer value of how much orundum the user\n",
    "          will have based on the amount of days and the rest of the parameters\n",
    "    \"\"\"\n",
    "    if(daily_missions == True and monthlycard == False and weekly_annihilation == False):\n",
    "        current += (100 * days)\n",
    "        return current\n",
    "    elif(daily_missions == False and monthlycard == False and weekly_annihilation == False):\n",
    "        return current\n",
    "    elif(daily_missions == True and monthlycard == True and weekly_annihilation == False):\n",
    "        current += (300 * days)\n",
    "        return current\n",
    "    elif(daily_missions == True and monthlycard == True and weekly_annihilation == True):\n",
    "        current += (300 * days) + (1750 * math.floor((days/7)))\n",
    "        return current\n",
    "    elif(daily_missions == False and monthlycard == True and weekly_annihilation == False):\n",
    "        current += (200 * days)\n",
    "        return current\n",
    "    elif(daily_missions == False and monthlycard == False and weekly_annihilation == True):\n",
    "        current += (1750 * math.floor((days/7)))\n",
    "        return current\n",
    "    return current\n",
    "#-------------------------------------------------------------------------------#\n",
    "def bannerReleaseDate(bannerName):\n",
    "    \"\"\"\n",
    "    Returns a string of when that banner has released\n",
    "    in the China Servers\n",
    "    \n",
    "    Parameters\n",
    "    ----------\n",
    "    bannerName : string\n",
    "        - The first parameter\n",
    "        \n",
    "    Returns\n",
    "    -------\n",
    "    String : String\n",
    "        - A string indicating the date of the\n",
    "          upcoming banner\n",
    "    \"\"\"\n",
    "    assert isinstance(bannerName, str)\n",
    "    queryRD = \"\"\"\n",
    "    SELECT ChineseDate\n",
    "    FROM banners\n",
    "    WHERE bannerName = '{}'\n",
    "    GROUP BY bannerName\n",
    "    \"\"\".format(bannerName)\n",
    "\n",
    "\n",
    "    resultRD = %sql $queryRD\n",
    "    BRD = resultRD.DataFrame()\n",
    "\n",
    "    return \"The banner releases: \" + BRD.iloc[0,0]\n",
    "#-------------------------------------------------------------------------------#\n",
    "def getCharacter(character):\n",
    "    \"\"\"\n",
    "    Returns a pandas dataframe\n",
    "    from a SQL database of that specific character\n",
    "    \n",
    "    Parameters\n",
    "    ----------\n",
    "    character : string\n",
    "        - The first parameter\n",
    "        \n",
    "    Returns\n",
    "    -------\n",
    "    CH : pandas Dataframe\n",
    "        - A pandas dataframe of all the information the character has\n",
    "    \"\"\"\n",
    "    assert isinstance(character, str)\n",
    "    queryCharacter = \"\"\"\n",
    "    Select *\n",
    "    FROM operators\n",
    "    WHERE characterID = '{}'\n",
    "    \"\"\".format(character)\n",
    "    \n",
    "    character = %sql $queryCharacter\n",
    "    CH = character.DataFrame()\n",
    "    \n",
    "    return CH\n",
    "#-------------------------------------------------------------------------------#\n",
    "def roleCharacters(role):\n",
    "    \"\"\"\n",
    "    Returns all of the characters based on the role\n",
    "    \n",
    "    Parameters\n",
    "    ----------\n",
    "    role : string\n",
    "        - The first parameter\n",
    "        \n",
    "    Returns\n",
    "    -------\n",
    "    RoleDF : pandas Dataframe\n",
    "        - A pandas dataframe of all the information the character\n",
    "          has based on the role parameter\n",
    "    \"\"\"\n",
    "    assert isinstance(role, str)\n",
    "    queryRole = \"\"\"\n",
    "    Select *\n",
    "    FROM operators\n",
    "    WHERE ROLE = '{}'\n",
    "    \"\"\".format(role)\n",
    "    \n",
    "    ROLE = %sql $queryRole\n",
    "    RoleDF = ROLE.DataFrame()\n",
    "    \n",
    "    return RoleDF\n",
    "#-------------------------------------------------------------------------------#\n",
    "def roleSize(role):\n",
    "    \"\"\"\n",
    "    Returns the amount of rows within\n",
    "    the given role\n",
    "    \n",
    "    Parameters\n",
    "    ----------\n",
    "    role : string\n",
    "        - The first parameter\n",
    "        \n",
    "    Returns\n",
    "    -------\n",
    "    int : int\n",
    "        - A integer of how many characters are\n",
    "          for the specific role specified within the\n",
    "          parameter\n",
    "    \"\"\"\n",
    "    return len(list(roleCharacters(role).index))\n",
    "#-------------------------------------------------------------------------------#\n",
    "def averageStatValue(stat):\n",
    "    \"\"\"\n",
    "    Returns the average stat value\n",
    "    \n",
    "    Parameters\n",
    "    ----------\n",
    "    stat : string\n",
    "        - The first parameter\n",
    "        \n",
    "    Returns\n",
    "    -------\n",
    "    int : int\n",
    "        - returns the average stat value\n",
    "          based on the given parameter\n",
    "    \"\"\"\n",
    "    queryStat = \"\"\"\n",
    "    SELECT {}\n",
    "    FROM operators\n",
    "    \"\"\".format(stat)\n",
    "    queryStat = %sql $queryStat\n",
    "    StatDF = queryStat.DataFrame()\n",
    "    \n",
    "    return round(StatDF.stack().mean())\n",
    "#-------------------------------------------------------------------------------#\n",
    "def shouldYouPull(orundum, banner):\n",
    "    \"\"\"\n",
    "    Does a simulation of pulling on an in-game\n",
    "    banner and returns what you can possibly\n",
    "    obtain with the amount of orundums a player\n",
    "    has in their account.\n",
    "    \n",
    "    Parameters\n",
    "    ----------\n",
    "    orundum : int\n",
    "        - The first parameter\n",
    "    banner : string\n",
    "        - The second parameter\n",
    "        \n",
    "    Returns\n",
    "    -------\n",
    "    ObtainedCharacters : List\n",
    "        - Returns the characters you've obtained\n",
    "          based on the simulation and stores them\n",
    "          all inside a List\n",
    "    \"\"\"\n",
    "    if(orundum < 600):\n",
    "        raise Exception(\"Insufficient Orundum\")\n",
    "    queryStat = \"\"\"\n",
    "    SELECT characterID\n",
    "    FROM banners\n",
    "    WHERE bannerName = '{}'\n",
    "    \"\"\".format(banner)\n",
    "    \n",
    "    queryStat = %sql $queryStat\n",
    "    StatDF = queryStat.DataFrame()\n",
    "    characterFromBanner = list(StatDF['characterID'].values) #Characters we want\n",
    "    randomCharacters = [[\"Exusiai\", \"Siege\", \"Ifrit\", \"Eyjafalla\", \"Angelina\", \"Shining\", \"Nightingale\", \"Hoshiguma\", \"Saria\", \"SilverAsh\", \"Skadi\", \"Ch'en\", \"Magallan\", \"Hellagur\", \"Schwarz\", \"Mostima\", \"Blaze\", \"Aak\", \"Ceobe\", \"Bagpipe\", \"Rosa\", \"Suzuran\", \"Phantom\", \"Weedy\", \"Thorns\", \"Eunectus\", \"Surtr\", \"Mudrock\", \"Mountain\", \"Archetto\", \"Blemishine\", \"Saga\", \"Passenger\", \"Kal'tsit\", \"Carnelian\", \"Pallas\", \"Mizuki\",\"Saileach\", \"Fartooth\", \"Flametail\", \"Gnosis\", \"Lee\", \"Goldenglow\", \"Fiammetta\", \"Horn\", \"Irene\"], [\"Ptilopsis\", \"Zima\", \"Texas\", \"Franka\", \"Lappland\", \"Specter\", \"Blue Poison\", \"Platinum\", \"Meteorite\", \"Skyfire\", \"Mayer\", \"Silence\", \"Warfarin\", \"Nearl\", \"Projekt Red\", \"Liskarm\", \"Croissant\", \"Provence\", \"Firewatch\", \"Cliffheart\", \"Pramanix\", \"Istina\", \"Sora\", \"Manticore\", \"FEater\", \"Nightmare\", \"Swire\", \"Executor\", \"Astesia\", \"Glaucus\", \"Waai Fu\", \"GreyThroat\", \"Reed\", \"Broce\", \"Hung\", \"Leizi\", \"Sesa\", \"Leonhardt\", \"Ayerscarpe\", \"Asbestos\", \"Tsukinogi\", \"Beeswax\", \"Chiave\", \"Shamare\", \"Elysium\", \"Andreana\", \"Flint\", \"April\", \"Whisperain\", \"Kafka\", \"Iris\", \"Aosta\", \"Mr. Nothing\", \"Toddifons\", \"Akafuyu\", \"Kiara\", \"La Pluma\", \"Mulberry\", \"Ashlock\", \"Corroserum\", \"Aurora\", \"Blacknight\", \"Quercus\", \"Kazemaru\", \"Rockrock\", \"Windflit\"], [\"Haze\", \"Gitano\", \"Meteor\", \"Shirayuki\", \"Scavenger\", \"Vigna\", \"Dobermann\", \"Matoimaru\", \"Frostleaf\", \"Mousse\", \"Gravel\", \"Rope\", \"Myrhh\", \"Perfumer\", \"Matterhorn\", \"Cuora\", \"Gummy\", \"Deepcolor\", \"Earthspirit\", \"Shaw\", \"Beehunter\", \"Greyy\", \"Vermeil\", \"Myrtle\", \"Sussuro\", \"May\", \"Ambriel\", \"Utage\", \"Podenco\", \"Click\", \"Cutter\", \"Jaye\", \"Aciddrop\", \"Arene\", \"Jackie\", \"Pinecone\", \"Beanstalk\", \"Bubble\", \"Indigo\", \"Roberta\", \"Chestnut\"], [\"Fang\", \"Vanilla\", \"Plume\", \"Melantha\", \"Cardigan\", \"Beagle\", \"Kroos\", \"Lava\", \"Hibiscus\", \"Ansel\", \"Steward\", \"Orchid\", \"Catapult\", \"Midnight\", \"Spot\", \"Popukar\"]]\n",
    "    #My buddy on Discord(Ryzu#8591) helped create the data randomCharacters based on the in-game banner details\n",
    "    ObtainedCharacters = []\n",
    "    while(orundum >= 600):\n",
    "        if(orundum >= 6000):\n",
    "            for i in range(10):\n",
    "                randomInt = int(random.random() * 100)\n",
    "                if(randomInt < 2):\n",
    "                    ObtainedCharacters.append(characterFromBanner[random.randint(0, len(characterFromBanner)-1)])\n",
    "                elif(randomInt < 8 and randomInt > 2):\n",
    "                    ObtainedCharacters.append(randomCharacters[0][random.randint(0, len(randomCharacters[0])-1)])\n",
    "                elif(randomInt <= 50 and randomInt > 8):\n",
    "                    ObtainedCharacters.append(randomCharacters[1][random.randint(0, len(randomCharacters[1])-1)])\n",
    "                elif(randomInt > 50 and randomInt < 90):\n",
    "                    ObtainedCharacters.append(randomCharacters[2][random.randint(0, len(randomCharacters[2])-1)])\n",
    "                else:\n",
    "                    ObtainedCharacters.append(randomCharacters[3][random.randint(0, len(randomCharacters[3])-1)])\n",
    "            orundum = orundum - 6000\n",
    "        else:\n",
    "\n",
    "            randomInt = int(random.random() * 100)\n",
    "            if(randomInt < 2):\n",
    "                ObtainedCharacters.append(characterFromBanner[random.randint(0, len(characterFromBanner)-1)])\n",
    "            elif(randomInt < 8 and randomInt > 2):\n",
    "                ObtainedCharacters.append(randomCharacters[0][random.randint(0, len(randomCharacters[0])-1)])\n",
    "            elif(randomInt <= 50 and randomInt > 8):\n",
    "                ObtainedCharacters.append(randomCharacters[1][random.randint(0, len(randomCharacters[1])-1)])\n",
    "            elif(randomInt > 50 and randomInt < 90):\n",
    "                ObtainedCharacters.append(randomCharacters[2][random.randint(0, len(randomCharacters[2])-1)])\n",
    "            else:\n",
    "                ObtainedCharacters.append(randomCharacters[3][random.randint(0, len(randomCharacters[3])-1)])\n",
    "            orundum = orundum - 600\n",
    "    return ObtainedCharacters"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3adac042",
   "metadata": {},
   "source": [
    "---\n",
    "### Using functions to compare characters\n",
    "\n",
    "Now that we have created the functions we can now utilize them to start comparing characters and stats between one another"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "05e93911",
   "metadata": {},
   "source": [
    "### Creating a matplotlib\n",
    "\n",
    "Below we are creating a matplotlib based on the average stats with every character in arknights, utilizing this information tells us what characters have a better edge within the game if they are higher in Attack or Defense, etc."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "6adf1865",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///dbfile/arknights.db\n",
      "Done.\n",
      " * sqlite:///dbfile/arknights.db\n",
      "Done.\n",
      " * sqlite:///dbfile/arknights.db\n",
      "Done.\n",
      " * sqlite:///dbfile/arknights.db\n",
      "Done.\n",
      " * sqlite:///dbfile/arknights.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAmoAAAJcCAYAAABJ8YjPAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAAAvlUlEQVR4nO3dfbxlZV338c9XQMQHVGRAYJBBQg1IUSZ8LpRSNBO8NYVKMS3StDStxJ6cSsq7NLvJxDAILQUpNdBQQXxADcRBkUdREJSBCcY0BDUS+N1/rOvI8nDOmQPOPvuamc/79Vqvs/a1rrXWb68N53znWmvtlapCkiRJ/bnbtAuQJEnS3AxqkiRJnTKoSZIkdcqgJkmS1CmDmiRJUqcMapIkSZ0yqEmSJHXKoCZ1KsknknwrydbTrmVDSLJXklOT3JDkxiQfT/K4KdZzQpLXb+Bt7p3k9Pa5/XeS85I8vS07IMmaO7m9SvJjG7LGWds/NskRk9r+XTGJz0XamBnUpA4lWQE8ESjgmRPY/pYbepvr2d8ewGeAC4HdgZ2B9wOnJ3nsBPY38feXZIs5mj8AnAHsCOwA/Bbw7UnX8iM4CDhtqXY2xc9F2nhVlZOTU2cT8McMweavgQ+2tq2B/wb2GfVbBnwP2KG9fgZwfuv3H8DDR32vAl4DXADcDGwJHAlcAdwIXAI8a9R/C+BNwDeAK4GXMwTHLdvy+wLHAWuBa4DXA1vM837+CThtjvZjgLPa/Iq2/SOAa9t2Xz3qe7dRvf8FnAxsN2vdFwNfH23zX4D/BG4AzgL2bu1HAN8H/he4CfhAa/9x4BPt+F0MPHO0/xNavacB3wF+ZtZ72b7VcL853ue92ud0W9vfTQxhdX/g7La/tcBbgLu3dc5q2/tO6/+8to8Ptv7fBD4F3G2eY14MQfGr7TP8q3Ff4OHABaNj+4fA14DrgXcC990UPhcnp419mnoBTk5Od5yAy4HfAPZrf7h2bO3HA0eN+r0M+HCbf1T7I/tohpB1OEM427otv4ohxO0KbNPafqEFhru1IPAdYKe27CUM4W05cH/go/xwUPs34O8ZQsgOwLnAr8/zfv4T+JU52p8E3Arcc/RH/cS2zZ8A1s384QVeCZzT6tm67fvEtmxm3Xe2dWfe34uA+7T+fwOcP9r3CcDrR6+3asf994G7A09mCLAPHfW/AXh8O173mPVeAnyFIUgdMvOZjZYfAKyZ1bYf8BiG0LwCuBR45Wh5AT82ev0XwNtarVsxjLpmnmNewMeB7YAHAV8GfnW0/EjgL0bH6XLgwcC9gfcB/zTr2G6Un4uT08Y+Tb0AJyenH56AJzCEs+3b6y8Bv93mfwb46qjvZ4AXtPljgD+bta3LgJ9u81cBL1rPvs8HDm7zH2MUvNq+q4WKHRlG5bYZLT8M+Pg8270FOGiO9oe1be4y+qP+sNHyvwSOa/OXAgeOlu3UjtOWo3UfvMB7u1/rc9/2enYgeCJDoByPOp0IrBr1f+d6jt9yhlGxKxhGz84C9mzLDmBWUJtj/VcC7x+9nh3U/hQ4Zdy2wLZqfMwZgv+Zo9efAp7Y5s8EfmO07KFzHNuN9nNxctqYJ69Rk/pzOHB6VX2jvX53a4MhPG2T5NFJdgP2ZbjWC2A34NXtIvb/TvLfDKNnO4+2ffV4R0lekOT8Uf99GE6v0da7ep51d2MY6Vg7WvfvGUbW5vINhj/gs+3EEGi+Nc9+vjaqfzfg/aP9XcowGrfjXOsm2SLJG5JckeTbDEGV0fubbWfg6qq6bdb+d5mntjuoqjVV9fKq2qPV+x2G0aQ5JXlIkg8m+c9W458vUB8Mpy8vZ7i276tJjlyoHuY5lknuxxCS/6Mt27ktH/edCeQLbouN4HORNmYGNakjSbYBngv8dPvj/Z/AbwOPSPKI9sfqZIbRq19kuH7txrb61QynRe83mu5ZVSeOdlGjfe0GvJ3h2rMHVNX9gIsYTuHBcC3S8tG6u47mr2YYUdt+tK9tq2rved7aRxlOs872XODsqvruPPt5EMN1UTP7fNqs93ePqrpmrvfHcHwOZhgJvC/D6A6j9zfuS9vPrknGvxcfxHD93VzbX1BVXQ38HUP4nW/dYxhGTPesqm0ZTu9ljn4z27yxql5dVQ8Gfh54VZIDFyhjvmP5VIbRtVvb62sZAte47y3AdYvY1kb1uUgbG4Oa1JdDGEYj9mIYLduX4ULqTwEvaH3ezXA92S+1+RlvB17SRtuS5F5Jfi7JfebZ170Y/sCtA0jyK9weKmAIhK9IsksbgXnNzIKqWgucDrwpybZJ7pZkjyQ/Pc++/gR4XJKjkmyX5D5JfrO9p9fM6vtHSe6ZZG/gV4D3tPa3AUe1gEmSZUkOnmd/MFwDdTPDBe73ZBitGruO4ZqsGZ9lGAH7vSRbJTmAIQydtMA+fiDJ/ZP8SZIfa8dje4Zrsc4Z7e8BSe47q8ZvAzcleRjw0oVqTPKMtv209W5t03x+t9W1K/AKbj+WP8cP3+15IvDbSXZPcm+GY/Weqrpl1Gej/FykjZ1BTerL4cA/VtXXq+o/ZyaG655+KcmWVTXzh2tn4EMzK1bVauDXWt9vMZwie+F8O6qqSxju6jyb4Y/jTzBc8zbj7Qxh7ALgCwx/2G/h9mDwAoaLuy9p+/tX5j69SVV9heHau0cwnOpaCzwbeGpVfWZW90+22s8E3lhVp7f2/wecynDa70aGAPTo+d4fwynHrzGMvFzC7YFpxnHAXu2U3b9V1f8yfBXK0xhO1b6V4fq/Ly2wj7H/ZRgd+ihDiLqIIZC8sB2DLzEEoq+2fe4M/A7DCNONDMf7PbO2uQp4R+v/XGDPtv2bGD63t1bVJxao6RTgPIZrD/8dOK6FvJ8FPjzqdzzDnblnMdzh+z/Ab87a1sb6uUgbtVQ5Yixp/ZI8DXhbVe223s53bfsrGELCVrNGcnQXJCmGU6qXz2rfH3hLVe2/yO2swM9FmhpH1CTNKck2SZ6eZMskuwCv4/YbF7Rxe920C5C0OEv67eSSNiphuLbsPQxf1vrvDF/Eq41YVZ077RokLZ6nPiVJkjrlqU9JkqRObbKnPrfffvtasWLFtMuQJElar/POO+8bVbVsdvsmG9RWrFjB6tWrp12GJEnSeiX52lztnvqUJEnqlEFNkiSpUwY1SZKkThnUJEmSOmVQkyRJ6pRBTZIkqVMGNUmSpE4Z1CRJkjplUJMkSeqUQU2SJKlTBjVJkqROGdQkSZI6ZVCTJEnqlEFNkiSpUwY1SZKkThnUJEmSOmVQkyRJ6pRBTZIkqVMGNUmSpE4Z1CRJkjplUJMkSeqUQU2SJKlTBjVJkqROGdQkSZI6ZVCTtMlZ/sDlJNnopuUPXD7tQyepM1tOuwBJ2tCuue4aVrFq2mXcaauuWzXtEiR1xhE1SZKkThnUJEmSOmVQkyRJ6pRBTZIkqVMGNUmSpE4Z1CRJkjplUJMkSeqUQU2SJKlTBjVJkqROGdQkSZI6ZVCTJEnqlEFNkiSpUwY1SZKkThnUJEmSOmVQkyRJ6tTEglqSXZN8PMmlSS5O8orWvl2SM5J8pf28/2id1ya5PMllSZ46at8vyYVt2dFJMqm6JUmSejHJEbVbgFdX1Y8DjwFelmQv4EjgzKraEzizvaYtOxTYGzgIeGuSLdq2jgGOAPZs00ETrFuSJKkLEwtqVbW2qj7f5m8ELgV2AQ4G3tG6vQM4pM0fDJxUVTdX1ZXA5cD+SXYCtq2qs6uqgHeO1pEkSdpkLck1aklWAI8EPgvsWFVrYQhzwA6t2y7A1aPV1rS2Xdr87Pa59nNEktVJVq9bt26DvgdJkqSlNvGgluTewHuBV1bVtxfqOkdbLdB+x8aqY6tqZVWtXLZs2Z0vVpIkqSMTDWpJtmIIae+qqve15uva6Uzaz+tb+xpg19Hqy4FrW/vyOdolSZI2aZO86zPAccClVfXXo0WnAoe3+cOBU0bthybZOsnuDDcNnNtOj96Y5DFtmy8YrSNJkrTJ2nKC23488HzgwiTnt7bfB94AnJzkxcDXgV8AqKqLk5wMXMJwx+jLqurWtt5LgROAbYAPtUmSJGmTNrGgVlWfZu7rywAOnGedo4Cj5mhfDeyz4aqTJEnqn08mkCRJ6pRBTZIkqVMGNUmSpE4Z1CRJkjplUJMkSeqUQU2SJKlTBjVJkqROGdQkSZI6ZVCTJEnqlEFNkiSpUwY1SZKkThnUJEmSOmVQkyRJ6pRBTZIkqVMGNUmSpE4Z1CRJkjplUJMkSeqUQU2SJKlTBjVJkqROGdQkSZI6ZVCTJEnqlEFNkiSpUwY1SZKkThnUJEmSOmVQkyRJ6pRBTZIkqVMGNUmSpE4Z1CRJkjplUJMkSeqUQU2SJKlTBjVJkqROGdQkSZI6ZVCTJEnqlEFNkiSpUwY1SZKkThnUJEmSOmVQkyRJ6pRBTZIkqVMGNUmSpE4Z1CRJkjplUJMkSeqUQU2SJKlTBjVJkqROGdQkSZI6ZVCTJEnqlEFNkiSpUwY1SZKkThnUJEmSOmVQkyRJ6pRBTZIkqVMGNUmSpE4Z1CRJkjplUJMkSerUxIJakuOTXJ/kolHbe5Kc36arkpzf2lck+d5o2dtG6+yX5MIklyc5OkkmVbMkSVJPtpzgtk8A3gK8c6ahqp43M5/kTcANo/5XVNW+c2znGOAI4BzgNOAg4EMbvlxJkqS+TGxErarOAr4517I2KvZc4MSFtpFkJ2Dbqjq7qooh9B2ygUuVJEnq0rSuUXsicF1VfWXUtnuSLyT5ZJIntrZdgDWjPmta25ySHJFkdZLV69at2/BVS5IkLaFpBbXD+OHRtLXAg6rqkcCrgHcn2RaY63q0mm+jVXVsVa2sqpXLli3boAVLkiQttUleozanJFsC/wfYb6atqm4Gbm7z5yW5AngIwwja8tHqy4Frl65aSZKk6ZnGiNrPAF+qqh+c0kyyLMkWbf7BwJ7AV6tqLXBjkse069peAJwyhZolSZKW3CS/nuNE4GzgoUnWJHlxW3Qod7yJ4KeAC5J8EfhX4CVVNXMjwkuBfwAuB67AOz4lSdJmYmKnPqvqsHnaXzhH23uB987TfzWwzwYtTpIkaSPgkwkkSZI6ZVCTJEnqlEFNkiSpUwY1SZKkThnUJEmSOmVQkyRJ6pRBTZIkqVMGNUmSpE4Z1CRJkjplUJMkSeqUQU2SJKlTBjVJkqROGdQkSZI6ZVCTJEnqlEFNkiSpUwY1SZKkThnUJEmSOmVQkyRJ6pRBTZIkqVMGNUmSpE4Z1CRJkjplUJMkSeqUQU2SJKlTBjVJkqROGdQkSZI6ZVCTJEnqlEFNkiSpUwY1SZKkThnUJEmSOmVQkyRJ6pRBTZIkqVMGNUmSpE4Z1CRJkjplUJMkSeqUQU2SJKlTBjVJkqROGdQkSZI6ZVCTJEnqlEFNkiSpUwY1SZKkThnUJEmSOmVQkyRJ6pRBTZIkqVMGNUmSpE4Z1CRJkjplUJMkSeqUQU2SJKlTBjVJkqROGdQkSZI6ZVCTJEnqlEFNkiSpUwY1SZKkThnUJEmSOjWxoJbk+CTXJ7lo1LYqyTVJzm/T00fLXpvk8iSXJXnqqH2/JBe2ZUcnyaRqliRJ6skkR9ROAA6ao/3NVbVvm04DSLIXcCiwd1vnrUm2aP2PAY4A9mzTXNuUJEna5EwsqFXVWcA3F9n9YOCkqrq5qq4ELgf2T7ITsG1VnV1VBbwTOGQiBUuSJHVmGteovTzJBe3U6P1b2y7A1aM+a1rbLm1+dvuckhyRZHWS1evWrdvQdUuSJC2ppQ5qxwB7APsCa4E3tfa5rjurBdrnVFXHVtXKqlq5bNmyH7FUSZKk6VrSoFZV11XVrVV1G/B2YP+2aA2w66jrcuDa1r58jnZJkqRN3pIGtXbN2YxnATN3hJ4KHJpk6yS7M9w0cG5VrQVuTPKYdrfnC4BTlrJmSZKkadlyUhtOciJwALB9kjXA64ADkuzLcPryKuDXAarq4iQnA5cAtwAvq6pb26ZeynAH6TbAh9okSZK0yZtYUKuqw+ZoPm6B/kcBR83RvhrYZwOWJkmStFHwyQSSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqkiRJnTKoSZIkdcqgJkmS1CmDmiRJUqcMapIkSZ0yqEmSJHXKoCZJktQpg5okSVKnDGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqkiRJnTKoSZIkdcqgJkmS1CmDmiRJUqcMapIkSZ0yqEmSJHXKoCZJktQpg5okSVKnDGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqkiRJnTKoSZIkdcqgJkmS1CmDmiRJUqcMapIkSZ0yqEmSJHXKoCZJktQpg5okSVKnDGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqkiRJnTKoSZIkdcqgJkmS1CmDmiRJUqcMapIkSZ0yqEmSJHXKoCZJktQpg5okSVKnDGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqkiRJnTKoSZIkdWpiQS3J8UmuT3LRqO2vknwpyQVJ3p/kfq19RZLvJTm/TW8brbNfkguTXJ7k6CSZVM2SJEk9meSI2gnAQbPazgD2qaqHA18GXjtadkVV7duml4zajwGOAPZs0+xtSpIkbZImFtSq6izgm7PaTq+qW9rLc4DlC20jyU7AtlV1dlUV8E7gkAmUK0mS1J1pXqP2IuBDo9e7J/lCkk8meWJr2wVYM+qzprXNKckRSVYnWb1u3boNX7EkSdISmkpQS/IHwC3Au1rTWuBBVfVI4FXAu5NsC8x1PVrNt92qOraqVlbVymXLlm3osiVJkpbUlku9wySHA88ADmynM6mqm4Gb2/x5Sa4AHsIwgjY+PbocuHZpK5YkSZqOJR1RS3IQ8BrgmVX13VH7siRbtPkHM9w08NWqWgvcmOQx7W7PFwCnLGXNkiRJ0zKxEbUkJwIHANsnWQO8juEuz62BM9q3bJzT7vD8KeBPk9wC3Aq8pKpmbkR4KcMdpNswXNM2vq5NkiRpkzWxoFZVh83RfNw8fd8LvHeeZauBfTZgaZIkSRsFn0wgSZLUKYOaJElSpwxqkiRJnTKoSZIkdcqgJkmS1CmDmiRJUqcMapIkSZ0yqEmSJHXKoCZJktSp9Qa1JI9fTJskSZI2rMWMqP3tItskSZK0Ac37rM8kjwUeByxL8qrRom2BLSZdmCRJ0uZuoYey3x24d+tzn1H7t4HnTLIoSZIkLRDUquqTwCeTnFBVX1vCmiRJksTCI2ozvpvkr4C9gXvMNFbVkydWlSRJkhZ1M8G7gC8BuwN/AlwFfG6CNUmSJInFBbUHVNVxwPer6pNV9SLgMROuS5IkabO3mFOf328/1yb5OeBaYPnkSpIkSRIsLqi9Psl9gVczfH/atsArJ1mUJEmSFhfUvlVVNwA3AE8Cn0wgSZK0FHwygSRJUqd8MoEkSVKnfDKBJElSp+7UkwmS3A24d1V9e6kKlCRJ2lwt5hq1v0iybZJ7AZcAlyX53QnXJUmStNlbTFDbq42gHQKcBjwIeP4ki5IkSdLigtpWSbZiCGqnVNX3gZpoVZIkSVpUUPt7hud73gs4K8luDDcUSJIkaYLWG9Sq6uiq2qWqnl5VBXyd9sW3kiRJmpzFPJngh7SwdssEapEkSdLIYk59SpIkaQoWDGpJ7pbkcUtVjCRJkm63YFCrqtuANy1RLZIkSRpZzKnP05M8O0kmXo0kSZJ+YDE3E7yK4as5bk3yPSAM9xRsO9HKJEmSNnPrDWpVdZ/19ZEkSdKGt95Tnxn8cpI/aq93TbL/5EuTJEnavC3mGrW3Ao8FfrG9vgn4u4lVJEmSJGBx16g9uqoeleQLAFX1rSR3n3BdkiRJm73FjKh9P8kWtAexJ1kG3DbRqiRJkrSooHY08H5gxyRHAZ8G/nyiVUmSJGlRd32+K8l5wIGt6ZCqunSyZUmSJGmxD2W/JzBz+nObyZUjSZKkGYv5eo4/Bt4BbAdsD/xjkj+cdGGSJEmbu8WMqB0GPLKq/gcgyRuAzwOvn2RhkiRJm7vF3ExwFXCP0eutgSsmUo0kSZJ+YDEjajcDFyc5g+EatZ8FPp3kaICq+q0J1idJkrTZWkxQe3+bZnxiMqVIkiRpbN6gluRY4EPA+6rqxqUrSZIkSbDwNWrHA48ATktyZpLXJHnEEtUlSZK02Zt3RK2qzgHOAVYleQDwFODVSX4C+ALw4ao6eWnKlCRJ2vws6gtvq+q/gBPbRJL9gIMmWJckSdJmbzFfePuHo/mtAarqvKo6apKFSZIkbe7mDWpJfi/JY4HnjJrPXuyGkxyf5PokF43atktyRpKvtJ/3Hy17bZLLk1yW5Kmj9v2SXNiWHZ0ki397kiRJG6+FRtQuA34BeHCST7W7QB+Q5KGL3PYJ3PH06JHAmVW1J3Bme02SvYBDgb3bOm9NskVb5xjgCGDPNnnKVZIkbRYWCmrfAn4fuBw4ADi6tR+Z5D/Wt+GqOgv45qzmgxmeG0r7ecio/aSqurmqrmz73D/JTsC2VXV2VRXwztE6kiRJm7SFgtpBwL8DewB/DewPfKeqfqWqHncX97djVa0FaD93aO27AFeP+q1pbbu0+dntc0pyRJLVSVavW7fuLpYoSZLUh3mDWlX9flUdyPCsz39muEN0WZJPJ/nABq5jruvOaoH2OVXVsVW1sqpWLlu2bIMVJ0mSNA2L+XqOj1TV54DPJXlpVT0hyfZ3cX/XJdmpqta205rXt/Y1wK6jfsuBa1v78jnaJUmSNnnr/XqOqvq90csXtrZv3MX9nQoc3uYPB04ZtR+aZOskuzPcNHBuOz16Y5LHtLs9XzBaR5IkaZO2qC+8nVFVX1xs3yQnMtyEsH2SNcDrgDcAJyd5MfB1hrtKqaqLk5wMXALcArysqm5tm3opwx2k2zA8e/RDd6ZmSZKkjdWdCmp3RlUdNs+iA+fpfxRwhy/RrarVwD4bsDRJkqSNwnpPfUqSJGk6DGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqkiRJnTKoSZIkdcqgJkmS1CmDmiRJUqcMapIkSZ0yqEmSJHXKoCZJktQpg5okSVKnDGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqkiRJnTKoSZIkdcqgJkmS1CmDmiRJUqcMapIkSZ0yqEmSJHXKoCZJktQpg5okSVKnDGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqkiRJnTKoSZIkdcqgJkmS1CmDmiRJUqcMapIkSZ0yqEmSJHXKoCZJktQpg5okSVKnDGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqkiRJnTKoSZIkdcqgJkmS1CmDmiRJUqcMapIkSZ0yqEmSJHXKoCZJktQpg5okSVKnDGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSp5Y8qCV5aJLzR9O3k7wyyaok14zanz5a57VJLk9yWZKnLnXNkiRJ07DlUu+wqi4D9gVIsgVwDfB+4FeAN1fVG8f9k+wFHArsDewMfDTJQ6rq1qWsW5IkaalN+9TngcAVVfW1BfocDJxUVTdX1ZXA5cD+S1KdJEnSFE07qB0KnDh6/fIkFyQ5Psn9W9suwNWjPmta2x0kOSLJ6iSr161bN5mKJUmSlsjUglqSuwPPBP6lNR0D7MFwWnQt8KaZrnOsXnNts6qOraqVVbVy2bJlG7ZgSZKkJTbNEbWnAZ+vqusAquq6qrq1qm4D3s7tpzfXALuO1lsOXLuklUqSJE3BNIPaYYxOeybZabTsWcBFbf5U4NAkWyfZHdgTOHfJqpQkSZqSJb/rEyDJPYGfBX591PyXSfZlOK151cyyqro4ycnAJcAtwMu841OSJG0OphLUquq7wANmtT1/gf5HAUdNui5JkqSeTPuuT0mSJM3DoCZJktQpg5okSVKnDGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqkiRJnTKoSZIkdcqgJkmS1CmDmiRJUqcMapIkSZ0yqEmSJHXKoCZJktQpg5okSVKnDGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqP4LlD1xOko1uWv7A5dM+dJIkaRG2nHYBG7NrrruGVayadhl32qrrVk27BEmStAiOqEmSJHXKoCZJktQpg5okSVKnDGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqkiRJnTKoSZIkdcqgJkmS1CmDmiRJUqcMapIkSZ0yqEmSJHXKoCZJktQpg5okSVKnDGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqkiRJnTKoSZIkdcqgJkmS1CmDmiRJUqcMapIkSZ0yqEmSJHXKoCZJktQpg5okSVKnDGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqkiRJnZpKUEtyVZILk5yfZHVr2y7JGUm+0n7ef9T/tUkuT3JZkqdOo2ZJkqSlNs0RtSdV1b5VtbK9PhI4s6r2BM5sr0myF3AosDdwEPDWJFtMo2BJkqSl1NOpz4OBd7T5dwCHjNpPqqqbq+pK4HJg/6UvT5IkaWlNK6gVcHqS85Ic0dp2rKq1AO3nDq19F+Dq0bprWtsdJDkiyeokq9etWzeh0iVJkpbGllPa7+Or6tokOwBnJPnSAn0zR1vN1bGqjgWOBVi5cuWcfSRJkjYWUxlRq6pr28/rgfcznMq8LslOAO3n9a37GmDX0erLgWuXrlpJkqTpWPKgluReSe4zMw88BbgIOBU4vHU7HDilzZ8KHJpk6yS7A3sC5y5t1ZIkSUtvGqc+dwTen2Rm/++uqg8n+RxwcpIXA18HfgGgqi5OcjJwCXAL8LKqunUKdUuSJC2pJQ9qVfVV4BFztP8XcOA86xwFHDXh0iRJkrrS09dzSJIkacSgJkmS1CmDmiRJUqcMapIkSZ0yqEmSJHXKoCZJktQpg5okSVKnDGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqkiRJnTKoSZIkdcqgJkmS1CmDmiRJUqcMapIkSZ0yqEmSJHXKoCZJktQpg5okSVKnDGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqkiRJnTKoSZIkdcqgJkmS1CmDmiRJUqcMapIkSZ0yqEmSJHXKoCZJktQpg5okSVKnDGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqkiRJnTKoSZIkdcqgJkmS1CmDmiRJUqcMapIkSZ0yqEmSJHXKoCZJktQpg5okSVKnDGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqkiRJnTKoSZIkdcqgJkmS1CmDmgQsf+Bykmx00/IHLp/2oZMkTdCW0y5A6sE1113DKlZNu4w7bdV1q6ZdgiRpghxRkyRJ6pRBTZIkqVNLHtSS7Jrk40kuTXJxkle09lVJrklyfpuePlrntUkuT3JZkqcudc2SJEnTMI1r1G4BXl1Vn09yH+C8JGe0ZW+uqjeOOyfZCzgU2BvYGfhokodU1a1LWrUkSdISW/IRtapaW1Wfb/M3ApcCuyywysHASVV1c1VdCVwO7D/5SiVJkqZrqteoJVkBPBL4bGt6eZILkhyf5P6tbRfg6tFqa5gn2CU5IsnqJKvXrVs3qbIlSZKWxNSCWpJ7A+8FXllV3waOAfYA9gXWAm+a6TrH6jXXNqvq2KpaWVUrly1btuGLliRJWkJTCWpJtmIIae+qqvcBVNV1VXVrVd0GvJ3bT2+uAXYdrb4cuHYp65UkSZqGadz1GeA44NKq+utR+06jbs8CLmrzpwKHJtk6ye7AnsC5S1WvJEnStEzjrs/HA88HLkxyfmv7feCwJPsynNa8Cvh1gKq6OMnJwCUMd4y+zDs+JUnS5mDJg1pVfZq5rzs7bYF1jgKOmlhRkiRJHfLJBJIkSZ0yqEmSJHXKoCZJktQpg5okSVKnDGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqkiRJnTKoSZIkdcqgJkmS1CmDmiRJUqcMapIkSZ0yqEmSJHXKoCZJktQpg5okSVKnDGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqkiRJnTKoSZIkdcqgJkmS1CmDmiRJUqcMapIkSZ0yqEmSJHXKoCZJktQpg5okSVKnDGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqkiRJnTKoSZIkdcqgJkmS1CmDmiRJUqcMapIkSZ0yqEmSJHXKoCZJktQpg5okSVKnDGqSJEmdMqhJkiR1yqAmSZLUKYOaJElSpwxqkiRJnTKoSZIkdcqgJkmS1CmDmiRJUqcMapIkSZ0yqEmSJHXKoCZJktQpg5okqVvLH7icJBvdtPyBy6d96LSJ2HLaBUiSNJ9rrruGVayadhl32qrrVk27BG0iNpoRtSQHJbksyeVJjpx2PZIkSZO2UQS1JFsAfwc8DdgLOCzJXtOtSpIkLZanse+ajeXU5/7A5VX1VYAkJwEHA5dMtSpJkrQonsa+a1JVUy1gMZI8Bzioqn61vX4+8OiqevmsfkcAR7SXDwUuW9JCN6ztgW9MuwhtEH6WmxY/z02Hn+WmY1P4LHerqmWzGzeWEbXM0XaHhFlVxwLHTr6cyUuyuqpWTrsO/ej8LDctfp6bDj/LTcem/FluFNeoAWuAXUevlwPXTqkWSZKkJbGxBLXPAXsm2T3J3YFDgVOnXJMkSdJEbRSnPqvqliQvBz4CbAEcX1UXT7msSdskTuEK8LPc1Ph5bjr8LDcdm+xnuVHcTCBJkrQ52lhOfUqSJG12DGqSJEmdMqhNUZJnJakkD0vy2STnJ/l6knVt/vwkK5JclWT7ts5+Sa5M8shp169BklvbZ3Vxki8meVWSu7VlByS5YfR5np/kZ2at94PPeqpvRD8kyU2zXr8wyVva/Kok17TP7aIkz5xOlRpL8sAkJyW5IsklSU5L8pAkeyf5WJIvJ/lKkj9KkrbOjkk+2P7fnVnnJ0b/X36z/c49P8lHp/0eN1ej35cXJflAkvu19hVJvjfrd+kL2rIXJbkwyQVtvYOn+ibuoo3iZoJN2GHAp4FDq+rRMPwxAFaOv8y3/T4hycOBfwWeV1VfWPJqNZ/vVdW+AEl2AN4N3Bd4XVv+qap6xkLraaP05qp6Y5IfBz6VZIequm3aRW2uWvB6P/COqjq0te0L7AicALy0qk5Pck/gvcBvMDya8E+BM6rq/7V1Hl5VFwL7ttcnAB+sqn9dyvejOxj/nn0H8DLgqLbsitm/S5MsB/4AeFRV3ZDk3sAdvkx2Y+CI2pS0/2geD7yY4etG1ufHgX8Dnl9V506wNP0Iqup6hqdjvHzmX+zatFXVpcAtDN+Mrul5EvD9qnrbTENVnQ88BPhMVZ3e2r4LvBw4snXbieG7OmfWuWCpCtZddjawy3r67ADcCNwEUFU3VdWVky5sEhxRm55DgA9X1Zfb0PqjqurzC/Q/Bfjlqvr00pSnu6qqvtpOfe7Qmp6Y5PxRl2dX1RXANqP2K6vqWUtYptZvm1mf23bM8f2NSR4N3AasW6K6NLd9gPPmaN97dntVXZHk3km2ZRhVe0/7CqiPAv9YVX6heqeSbAEcCBw3at5j1v+rvwn8B3AdcGWSM4H3VdUHlqzQDcigNj2HAX/T5k9qrxcKah8FfjXJR6rq1gnXph/deDTNU58bpx/6fGYuSxgt/+0kv8zwr/bnld911KswxyMHm6qqjyR5MHAQ8DTgC0n2qSqDd19m/uG0giF4nzFadodTnwBJDgJ+kiHYvTnJflW1auKVbmCe+pyCJA8Angz8Q5KrgN8FnreeU2Uz16y9dcLl6UfUfunfClw/7Vo0UW+uqn2r6olV9alpFyMuBvabp/2HngHZ/h+9qapuBKiqb1bVu6vq+QxPwvmpSRerO23mH067AXdnuEZtQTU4t6r+guESo2dPtsTJMKhNx3OAd1bVblW1oqp2Ba4EnrDAOrcxjLo9NMmfLkWRuvOSLAPeBrzFERZpSX0M2DrJr800JPlJ4CvAE0Z3W28DHA38ZXv95HaDAUnuA+wBfH2Ja9ciVdUNwG8Bv5Nkq/n6Jdk5yaNGTfsCX5tweRNhUJuOwxjuThp7L/CLC61UVTcDBwPPTLLef01oyWwz8/UcDKeoTwf+ZLT8ibNuHX/OdMqUNl3tH0bPAn62fT3HxcAq4FqG35t/mOQy4EKGUbO3tFX3A1YnuYDhIvV/qKrPLXX9Wrz2rQdf5PYb8faY9Tv2t4CtgDcm+VI7Zfo84BXTqfhH4yOkJEmSOuWImiRJUqcMapIkSZ0yqEmSJHXKoCZJktQpg5okSVKnDGrSZi7Js5JUkodNu5b1SfKiJBcmuSDJRUkObu0vTLLzItZfVL9FbGfrJB9tXwXwvIX2keSqJHf5OaBJ9k7ysSRfTvKVJH+0FM+RTfLKme8XkzQ9BjVJhwGf5vbvJPqRtGfxbXBJlgN/ADyhqh4OPAaYeYD2C4HFBLDF9lufRwJbtScTvGdC+5j5ctZTgTdU1UOARwCPA35jA2w77Zm083klcKeC2qQ+e2lzZlCTNmNJ7g08HngxLagleVqSk0d9DkjygTb/lCRnJ/l8kn9p68+MGv1xkk8Dv5Dk15J8LskXk7x39M3veyQ5py370yQ3jfbzu639giTjLwyesQPDczVvAqiqm6rqyvYFwiuBd7URrm1aLZ9ro27HtlAyV783JLmk7fONcxyf7ZL8W1t+TpKHJ9kB+Gdg37adPUb977CPtug32zG7cGbkMsm9khzf6vzCzOjgLL8IfKaqTm/v+bsMj5M7sm1jVZJ/aiNuX8kPfyv/HY5nkhVJLk3yVoZnC++a5Jgkq5NcPOr3Wwxh8+NJPt7aDmv1X5Tk/472c1P7LD8LPHZ9x1TSnVRVTk5Om+kE/DJwXJv/D+BRwJYMj9C5V2s/pvXbHjhr1P4a4I/b/FXA7422+4DR/OuB32zzHwQOa/MvYXjeIsBTgGMZHqB9t9bvp2bVugXwkVbbPwI/P1r2CWDl6PV2o/l/muk77gdsB1zG7V/8fb85js/fAq9r808Gzm/zBwAfnOeYzq7lqtH7/w2Gb74H+HPgl2f2DXx55tiO1v1r4BVz7ONbwLYM37z/RWCb9vlczRCw5jyeDA+0vg14zOxj1Y7vJ4CHj+revs3v3I77svbfx8eAQ9qyAp672GPq5OR05yZH1KTN22HASW3+JIYQdQvwYeDnk2wJ/BxwCsOpxr2Az2R4JMvhDA9InjE+BbhPkk8luRD4JWDv1v5Y4F/a/LtH/Z/Spi8wjPQ8DNhzXGhV3QocxPCs3C8Db06yap739aQkn237f/Jo/2PfBv4H+Ick/wf47hx9nsAQ9KiqjwEPSHLfefa5kPe1n+cxhCUY3u+R7Vh+ArgH8KBZ64UhCM1lpv2UqvpeVX0D+DiwPwsfz69V1Tmj7Tw3yedb370ZPuPZfhL4RFWta/99vIvbH1x+K8Mj8GBxx1TSnbDltAuQNB1JHsAQYvZJUgwjKpXk9xhC18uAbwKfq6ob2wXsZ1TVYfNs8juj+RMYRly+mOSFDCNQC5YD/EVV/f1CnaqqgHOBc5OcwTCytmrW+7oH8FaGUa2rW5i7xxzbuiXJ/sCBDKd9X85wPGbXdYdV1/Ne5nJz+3krt//eDfDsqrpsgfUu5vZANKyUPJhhJPLG4SO5Qz3FPMczyQpGn1OS3YHfAX6yqr6V5ATmOFbMfRxm/E8L0Ys9ppLuBEfUpM3Xc4B3VtVuVbWiqnYFrmQYRfoEw2nQX+P2kbJzgMcn+TGAJPdM8pB5tn0fYG2SrRhG1GacAzy7zY9vXvgI8KLRNW+7tGvBfiDJzkkeNWraF/ham7+x7RNuDxrfaNt7zmidH/Rry+5bVacxXDi/7xzv46yZ+pMcAHyjqr49z3u+wz7W4yMM166lbf+Rc/R5F/CEJD/T+mwDHA385ajPwUnu0YL3AQwPHF/v8Wy2ZQhuNyTZEXjaPO/js8BPJ9k+ww0DhwGfnL2xRR5TSXeCI2rS5usw4A2z2t4L/GJVfSrJBxnuYDwcoKrWtdGxE5Ns3fr/IcNpyNn+iOGP+9eAC7n9D/4rgX9O8mrg34Eb2rZPT/LjwNktt9zEcF3c9aNtbgW8McNXX/wPsI7hOjcYRvDeluR7DKdX3972exVDcGGOfk8DTmkjcAF+e473sQr4xyQXMJzGO3yOPrPNrmU+fwb8DXBBC2tXAc8Yd6iq77WbDP42yd8xjHr+E/CWUbdzGY7lg4A/q6prgWvnOZ63ztr+F5N8gWHk7qvAZ0aLjwU+lGRtVT0pyWsZTq0GOK2qTpnjPd2H9R9TSXfCzAWfkjRxGe7+/F5VVZJDGa6Jm+tuRy1CO617U1V5d6W0iXJETdJS2g94SxtB+m/gRdMtR5L65oiaJElSp7yZQJIkqVMGNUmSpE4Z1CRJkjplUJMkSeqUQU2SJKlT/x/Aq3yhyz8UWwAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 720x720 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "data = {'ATK': averageStatValue(\"ATK\"), 'DEF': averageStatValue(\"DEF\"), 'HP': averageStatValue(\"HP\"), 'COST': averageStatValue(\"COST\"), 'RES': averageStatValue(\"RES\")}\n",
    "\n",
    "roles = list(data.keys())\n",
    "values = list(data.values())\n",
    "\n",
    "plt.bar(roles, values, color ='purple', width = 0.4, edgecolor='black')\n",
    " \n",
    "plt.xlabel(\"Average Stats of the Operators\")\n",
    "plt.ylabel(\"#/per stat\")\n",
    "plt.title(\"Average Operator Stats p/operator\")\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "4804f161",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      " * sqlite:///dbfile/arknights.db\n",
      "Done.\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAmcAAAKNCAYAAABlbcz1AAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuNCwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8QVMy6AAAACXBIWXMAAAsTAAALEwEAmpwYAABjs0lEQVR4nO3dd7hsVX3/8feHotjAAnYQCxYsoF6xYQSjUWPvYIsVTSwxmp8xxh6NaZrYCYmAFY0FRWONvaFeFHsjNhAL2EDEAn5/f6w93LnnnrL3mTPnbjjv1/PMc87sPXvNmv7dq3xXqgpJkiSNww7buwKSJEnawuBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kLSvNUUl+nuQz27s+0qyS7J2kkuzUXf9wkkds73pJEwZn0oy6L/afJ7nw9q7LYpI8JMnHZyjiQOB2wJWr6oA1qtZcJDk6yXO3dz0kaRYGZ9IMkuwN3Aoo4K7btzZzcxXgu1V11vasxKSVY873seO872OtrMfzMRYb6bFKYHAmzerBwPHA0cCfTe/oWnFenuTdSX6V5BNJLp/k37uWtq8nueHU7a/TtcL9IslXktx1at9W3S4LW8O6LppHJ/lWV/bLuu7I6wCHAzfv6vCLxR5EkismOS7Jz5KclOSR3faHA/81dfyzFzl2hyRPS/K9JD9J8uoku3X7Jt1HhyU5NckPkzxpwbFPSfJ/SX6a5L+TXHrBsQ9P8n3gg932NyX5UZJfJvlokut22w8DHgA8uavrO3o8r0cneUWSdyU5Czg4yZ8m+WqSM5P8IMlfL/GcLfm4u/0HJvlkd78nJ3lIt/0iSV7QHffLJB/vth2U5JQF9/HdJLft/n9WkjcneW2SM4CHJDkgyae6+/hhkpcmudBK74up/Y9M8rXusX41yY2m3g9vSXJaku8kefzUMQck2ZzkjCQ/TvLCJZ6fg5KckuSpSU7vHssDpvZfOMm/Jvl+V87hSS6y4Ni/SfIj4KhFyn9I2mfqJd3z+PUkf7zYczf1/L12sbpKo1NVXrx4WeUFOAn4C+DGwO+By03tOxo4vdu3Cy24+A4toNsReC7woe62O3dlPRW4EHAb4EzgWt3+DwOPmCr7IcDHp64X8E7gksBewGnAHRa77RKP4yPAy7t67t8d/8d9jgce1tX9asDFgbcCr+n27d3V7RjgYsD1u7Jv2+1/Ai24vTJwYeA/gGMWHPvq7tiLTN3fJbrb/ztw4oLn/LlT11d6Xo8GfgncknayugvwQ+BW3f5LATdaxePeq7ufQ7s6XAbYv9v3su71vFL3PrhF91gOAk5ZcB/fnXqunkV7j929q+tFaO+tmwE7dc/X14An9Hxf3Af4AXATIMA1aK2kOwAnAM/onrOrAd8Gbt8d9yngQd3/FwdutsTzcxBwDvDC7vHdGjhr6rn/d+A44NLd6/kO4PkLjv2n7tiLLFL+Q7rb/FX3HN+vey0vvfC5m3r+XrvgvbXTYp8vL16292W7V8CLl/PrhTYW6/fA7t31rwN/NbX/aOA/p64/Dvja1PXrA7/o/r8V8CNgh6n9xwDP6v7f6seDxYOzA6eu/zfwlMVuu8jj2BM4F7jE1LbnA0f3PP4DwF9MXb9W97xMAoYCrj21/5+BV3b/f40uCOyuX2GRY6+2zH1fsrvNblPP+XRwttLzejTw6gVlfh94FLDrCq//co/7b4FjFzlmB+BsYL9F9h3EysHZR1eo0xOm73eF98V7gb9cpIybAt9fsO1vgaO6/z8KPJvufb9MXQ6iBU8XW3D/T6cFg2cBV5/ad3PgO1PH/g7YZZnyHwKcCmRq22fYEjie99xNPX8GZ17OFxe7NaXV+zPgfVV1enf99Szo2gR+PPX/2Ytcv3j3/xWBk6vqD1P7v0drXenrR1P//3qq7JVcEfhZVZ25yvu+Ynf76WN3Ai43te3kBfuv2P1/FeDYrlvuF7Rg7dyljk2yY5J/7LpBz6D9AAPsvkzdVnpeT976EO4F/CnwvSQfSXLzZcpe6nHvCfzfIsfsTmudW2xfH1vVNck1k7yz6+Y9A/gHtn0ulnpfLFXHqwBXnLwm3evyVLa8Jg8Hrgl8Pclnk9x5mfr+vLYeqzh57fcALgqcMHUf7+m2T5xWVb9ZpmyAH1RVLVK+dL5mcCatQjc25r7Arbsfxh/Rulf2S7LfKoo8FdgzyfRnci9atxO0VoaLTu27/ICya4X9pwKXTnKJJe57JafSftCnjz2HrQPRPRfsP7X7/2TgjlV1yanLLlU1fd/T9b8/cDfgtsButBYQaC0xC287qdtyz+s2x1TVZ6vqbsBlgbfRWnsWs9zjPhm4+iLHnA78Zol9W73GaZMT9lhwm4WP7xW0Ftt9qmpXWhAV+lmqjifTWrCmX5NLVNWfAlTVt6rqUNrz80/Am5NcbIn7uNSCfZPX/nTaycl1p+5jt6qaPqFY6X0LcKXpMXRs/d6a5TMjbVcGZ9Lq3J3WwrMvbYzW/sB1gI/RxpQN9Wnaj8mTk+yc5CDgLsAbuv0nAvdMctEk16C1XvT1Y+DK0wPFp1XVycAngecn2SXJDbryX9ez/GOAv0py1SQXp7XevLGqzpm6zdO7ul8XeCjwxm774cDzklwFIMkeSe62zH1dAvgt8FPaD+8/LPJYrzZ1faXndStJLpTkAUl2q6rfA2fQXuehj/t1wG2T3DfJTkkuk2T/rgXvSOCF3aD7HZPcPC0NyzeBXZLcKcnOwNNo462Wc4mujr9Kcm3gz1e4/bT/Av46yY3TXKN7HT4DnNENxr9IV8frJblJ9xw9MMke3WP5RVfWUs8RwLO75/VWwJ2BN3XH/ifwb0ku25V7pSS3H1B/aAHi47vX9j60z+C7un0nAod0+zYB9x5YtrTdGJxJq/NntDE436+qH00uwEuBB2Tg1P+q+h0tFccdaa0KLwceXFVf727yb7QxOD8GXkX/wAnaRISvAD9KcvoStzmU1gp1KnAs8Myqen/P8o8EXkMbi/QdWsvQ4xbc5iO0wfMfAP61qt7XbX8RbVD4+5KcSZsccNNl7uvVtK6rHwBf7W4/7ZXAvl1X2dt6PK+LeRDw3a6b8NHAA4c+7qr6Pq1r9EnAz2iBwqRF9a+BLwGf7fb9E21M3C9pk0v+q3t8ZwFbzd5cxF/TWhPPpAU7b1z+5ltU1ZuA59G648+ktRJeuqrOpQWw+3eP6/SuTpOZqHcAvpLkV7TX75Bluh9/BPyc9r56HfDoqef+b2jvieO75/p/aeP2hvg0sE9Xx+cB966qn3b7nk5rGfw5bYzc6weWLW032bq7XpLWTloeuO8AOy9oSdMFXNdK+dqquvKcyn8IbRD/gfMoX9qebDmTJEkaEYMzSZKkEbFbU5IkaURsOZMkSRqRC9Risrvvvnvtvffe27sakiRJKzrhhBNOr6qF+QwvWMHZ3nvvzebNm7d3NSRJklaU5HuLbbdbU5IkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlE5hacJdkzyYeSfC3JV5L85SK3SZIXJzkpyReT3Ghq3x2SfKPb95R51VOSJGlM5tlydg7wpKq6DnAz4DFJ9l1wmzsC+3SXw4BXACTZEXhZt39f4NBFjpUkSbrAmVtwVlU/rKrPdf+fCXwNuNKCm90NeHU1xwOXTHIF4ADgpKr6dlX9DnhDd1tJkqQLtHUZc5Zkb+CGwKcX7LoScPLU9VO6bUttX6zsw5JsTrL5tNNOW7M6a2WX33tvkmxzufzee2/vqklaI0t9zv2sS/Oz07zvIMnFgbcAT6iqMxbuXuSQWmb7thurjgCOANi0adOit9F8/Ph734Pa9in/cRZ7+SSdHy31OQc/69K8zDU4S7IzLTB7XVW9dZGbnALsOXX9ysCpwIWW2C5JknSBNs/ZmgFeCXytql64xM2OAx7czdq8GfDLqvoh8FlgnyRXTXIh4JDutpIkSRdo82w5uyXwIOBLSU7stj0V2Augqg4H3gX8KXAS8Gvgod2+c5I8FngvsCNwZFV9ZY51lSRJGoW5BWdV9XEWHzs2fZsCHrPEvnfRgjdJkqQNwxUCJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUR2mlfBSY4E7gz8pKqut8j+/wc8YKoe1wH2qKqfJfkucCZwLnBOVW2aVz0lSZLGZJ4tZ0cDd1hqZ1X9S1XtX1X7A38LfKSqfjZ1k4O7/QZmkiRpw5hbcFZVHwV+tuINm0OBY+ZVF0mSpPOL7T7mLMlFaS1sb5naXMD7kpyQ5LAVjj8syeYkm0877bR5VlWSJGnutntwBtwF+MSCLs1bVtWNgDsCj0nyR0sdXFVHVNWmqtq0xx57zLuukiRJczWG4OwQFnRpVtWp3d+fAMcCB2yHekmSJK277RqcJdkNuDXw9qltF0tyicn/wJ8AX94+NZQkSVpf80ylcQxwELB7klOAZwI7A1TV4d3N7gG8r6rOmjr0csCxSSb1e31VvWde9ZQkSRqTuQVnVXVoj9scTUu5Mb3t28B+86mVJEnSuI1hzJkkSZI6BmeSJEkjYnAmSZI0IgZnkiRJI2JwJkmSNCIGZ5IkSSNicCZJkjQiBmeSJEkjYnAmSZI0IgZnkiRJI2JwJkmSNCIGZ5IkSSNicCZJkjQiBmeSJEkjYnAmSZI0IgZnkiRJI2JwJkmSNCIGZ5IkSSNicCZJkjQiBmeSJEkjYnAmSZI0IgZnkiRJI2JwJkmSNCIGZ5IkSSNicCZJkjQiBmeSJEkjYnAmSZI0IgZnkiRJI2JwJkmSNCIGZ5IkSSNicCZJkjQiBmeSJEkjYnAmSZI0IgZnkiRJI2JwJkmSNCIGZ5IkSSNicCZJkjQiBmeSJEkjYnAmSZI0IgZnkiRJI2JwJkmSNCIGZ5IkSSNicCZJkjQiBmeSJEkjYnAmSZI0IgZnkiRJI2JwJkmSNCIGZ5IkSSNicCZJkjQiBmeSJEkjYnAmSZI0IgZnkiRJI2JwJkmSNCIGZ5IkSSNicCZJkjQiBmeSJEkjMrfgLMmRSX6S5MtL7D8oyS+TnNhdnjG17w5JvpHkpCRPmVcdJUmSxmaeLWdHA3dY4TYfq6r9u8tzAJLsCLwMuCOwL3Bokn3nWE9JkqTRmFtwVlUfBX62ikMPAE6qqm9X1e+ANwB3W9PKSZIkjdT2HnN28yRfSPLuJNfttl0JOHnqNqd02xaV5LAkm5NsPu200+ZZV0mSpLnbnsHZ54CrVNV+wEuAt3Xbs8hta6lCquqIqtpUVZv22GOPta+lJEnSOtpuwVlVnVFVv+r+fxewc5LdaS1le07d9MrAqduhipIkSetuuwVnSS6fJN3/B3R1+SnwWWCfJFdNciHgEOC47VVPSZKk9bTTvApOcgxwELB7klOAZwI7A1TV4cC9gT9Pcg5wNnBIVRVwTpLHAu8FdgSOrKqvzKuekiRJY5IWD10wbNq0qTZv3ry9q7FhJIHF3j8JF6T3lbSRLfk5bzv9rEszSHJCVW1auH17z9aUJEnSFIMzSZKkETE4kyRJGhGDM0mSpBExOJMkSRoRgzNJkqQRMTiTJEkaEYMzSZKkETE4kyRJGhGDM0mSpBExOJMkSRoRgzNJkqQRMTiTJEkaEYMzSZKkETE4kyRJGhGDM0mSpBExOJMkSRoRgzNJkqQRMTiTJEkaEYMzSZKkETE4kyRJGhGDM0mSpBExOJMkSRqRnZbakeSeyx1YVW9d++pIkiRtbEsGZ8Bdur+XBW4BfLC7fjDwYcDgTJIkaY0tGZxV1UMBkrwT2LeqfthdvwLwsvWpniRJ0sbSZ8zZ3pPArPNj4Jpzqo8kSdKGtly35sSHk7wXOAYo4BDgQ3OtlSRJ0ga1YnBWVY9Ncg/gj7pNR1TVsfOtliRJ0sbUp+UM4HPAmVX1v0kumuQSVXXmPCsmSZK0Ea045izJI4E3A//RbboS8LY51kmSJGnD6jMh4DHALYEzAKrqW7T0GpIkSVpjfYKz31bV7yZXkuxEmxggSZKkNdYnOPtIkqcCF0lyO+BNwDvmWy1JkqSNqU9w9hTgNOBLwKOAdwFPm2elJEmSNqo+qTT+APxnd5EkSdIcrRicJbkl8CzgKt3tA1RVXW2+VZMkSdp4+uQ5eyXwV8AJwLnzrY4kSdLG1ic4+2VVvXvuNZEkSVKv4OxDSf4FeCvw28nGqvrc3GolSZK0QfUJzm7a/d00ta2A26x9dSRJkja2PrM1D16PikiSJGmZ4CzJA6vqtUmeuNj+qnrh/KolSZK0MS3Xcnax7u8l1qMikiRJWiY4q6r/6P4+e/2qI0mStLH1SUK7C/Bw4LrALpPtVfWwOdZLkiRpQ+qztuZrgMsDtwc+AlwZOHOelZIkSdqo+gRn16iqpwNnVdWrgDsB159vtSRJkjamPsHZ77u/v0hyPWA3YO+51UiSJGkD65OE9ogklwKeBhwHXBx4+lxrJUmStEH1Cc4+UFU/Bz4KXA0gyVXnWitJkqQNqk+35lsW2fbmta6IJEmSll8h4Nq09Bm7Jbnn1K5dmUqpIUmSpLWzXLfmtYA7A5cE7jK1/UzgkXOskyRJ0oa13AoBbwfenuTmVfWpdayTJEnShtVnzNmPk7wjyWlJfpLk7UmuttJBSY7sbv/lJfY/IMkXu8snk+w3te+7Sb6U5MQkmwc8HkmSpPO1PsHZ64H/Bq4AXBF4E3BMj+OOBu6wzP7vALeuqhsAfw8csWD/wVW1f1Vt6nFfkiRJFwh9grNU1Wuq6pzu8lqgVjqoqj4K/GyZ/Z/sUnQAHE9bFkqSJGlDWzI4S3LpJJcGPpTkKUn2TnKVJE8G/meN6/Fw4N1T1wt4X5ITkhy23IFJDkuyOcnm0047bY2rJUmStL6Wm615Ai1ISnf9UVP7itYVObMkB9OCswOnNt+yqk5Nclng/Um+3rXEbaOqjqDrEt20adOKLXqSJEljttxszbmvApDkBsB/AXesqp9O3fep3d+fJDkWOIC2QoEkSdIF2opjzpLsnOTxSd7cXR6bZOdZ7zjJXsBbgQdV1Tentl8sySUm/wN/Aiw641OSJOmCps/amq8AdgZe3l1/ULftEcsdlOQY4CBg9ySnAM/syqGqDgeeAVwGeHkSgHO6mZmXA47ttu0EvL6q3jPoUUmSJJ1P9QnOblJV+01d/2CSL6x0UFUdusL+R7BIgFdV3wb22/YISZKkC74+qTTOTXL1yZUuAe2586uSJEnSxtWn5ez/0dJpfJs2c/MqwEPnWitJkqQNasXgrKo+kGQf2kLoAb5eVb+de80kSZI2oD4tZ3TB2BfnXBdJkqQNr8+YM0mSJK0TgzNJkqQR6ZOENkkemOQZ3fW9khww/6pJkiRtPH1azl4O3ByY5C07E3jZ3GokSZK0gfWZEHDTqrpRks8DVNXPk1xozvWSJEnakPq0nP0+yY5AASTZA/jDXGslSZK0QfUJzl4MHAtcNsnzgI8D/zDXWkmSJG1Qy3ZrJtkB+A7wZOCPaUlo715VX1uHukmSJG04ywZnVfWHJC+oqpsDX1+nOkmSJG1Yfbo135fkXkky99pIkiRtcH1maz4RuBhwbpKzaV2bVVW7zrVmkiRJG1Cfhc8vsR4VkSRJ0rAVAp7eXd/TFQIkSZLmY8gKAffvrv8KVwiQJEmaC1cIkCRJGhFXCJAkSRoRVwiQJEkakT6zNV+X5ARcIUCSJGnuVgzOkjwH+BhwdFWdNf8qSZIkbVx9ujW/CxwKbE7ymSQvSHK3+VZLkiRpY1oxOKuqI6vqYcDBwGuB+3R/JUmStMb6dGv+F7Av8GNa9+a9gc/NuV6SJEkbUp9uzcsAOwK/AH4GnF5V58yzUpIkSRtVn9ma9wBIch3g9sCHkuxYVVeed+UkSZI2mj7dmncGbgX8EXAp4IO07k1JkiStsT7LN90R+Cjwoqo6dc71kSRJ2tD6dGs+Zj0qIkmSpH4TAiRJkrRODM4kSZJGZFBwluRSSW4wr8pIkiRtdCsGZ0k+nGTXJJcGvgAcleSF86+aJEnSxtOn5Wy3qjoDuCdwVFXdGLjtfKslSZK0MfUJznZKcgXgvsA751wfSZKkDa1PcPZs4L3ASVX12SRXA74132pJkiRtTMvmOUuyI7BnVZ03CaCqvg3ca94VkyRJ2oiWbTmrqnOBu65TXSRJkja8Pss3fTLJS4E3AmdNNlbV5+ZWK0mSpA2qT3B2i+7vc6a2FXCbta+OJEnSxtZnbc2D16MikiRJ6peEdrckL0yyubu8IMlu61E5SZKkjaZPKo0jgTNpec7uC5wBHDXPSkmSJG1UfcacXb2qplNnPDvJiXOqjyRJ0obWp+Xs7CQHTq4kuSVw9vyqJEmStHH1aTl7NPDqqXFmPwf+bH5VkiRJ2rj6BGdnVNV+SXYFqKozklx1zvWSJEnakPp0a74FWlBWVWd02948vypJkiRtXEu2nCW5NnBdYLck95zatSuwy7wrJkmStBEt1615LeDOwCWBu0xtPxN45BzrJEmStGEtGZxV1duBtye5eVV9ah3rJEmStGH1mRDw+SSPoXVxntedWVUPm1utJEmSNqg+EwJeA1weuD3wEeDKtK5NSZIkrbE+wdk1qurpwFlV9SrgTsD151stSZKkjalPcPb77u8vklwP2A3Ye6WDkhyZ5CdJvrzE/iR5cZKTknwxyY2m9t0hyTe6fU/pUUdJkqQLhD7B2RFJLgU8DTgO+CrwTz2OOxq4wzL77wjs010OA14BkGRH4GXd/n2BQ5Ps2+P+JEmSzveWnRCQZAfaCgE/Bz4KXK1vwVX10SR7L3OTuwGvrqoCjk9yySRXoLXKnVRV3+7q8Ibutl/te9+SJEnnV8u2nFXVH4DHzum+rwScPHX9lG7bUtsXleSwJJuTbD7ttNPmUtFpl997b5Isern83nvPVMasx693GbMay+O4oLweF/TH4XNx/vycL1ePMTyX57fXw8exPmWs5+djMWkNV8vcIHk6cDbwRuCsyfaq+tmKhbeWs3dW1fUW2fc/wPOr6uPd9Q8AT6a1zt2+qh7RbX8QcEBVPW6l+9u0aVNt3rx5pZvNJAks9ZwlrPR8LlvGrMePpYwx1GEtyhhDHdaijDHUYSxljKEOa1HGGOqwFmWMoQ5rUcYY6rAWZYyhDmMpo+fxs0pyQlVtWri9T56zST6zx0xtKwZ0cS7hFGDPqetXBk4FLrTEdkmSpAu8FYOzqrrqnO77OOCxaWPKbgr8sqp+mOQ0YJ8kVwV+ABwC3H9OdZAkSRqVFYOzJBcFngjsVVWHJdkHuFZVvXOF444BDgJ2T3IK8ExgZ4CqOhx4F/CnwEnAr4GHdvvOSfJY4L3AjsCRVfWV1T08SZKk85c+3ZpHAScAt+iunwK8CVg2OKuqQ1fYX2zdVTq971204E2SJGlD6ZPn7OpV9c90yWir6mwgc62VJEnSBtUnOPtdkovQJgGQ5OrAb+daK0mSpA2qT7fmM4H3AHsmeR1wS+Ah86yUJEnSRtVntub7k3wOuBmtO/Mvq+r0uddMkiRpA+rTcgZwa+BAWtfmzsCxc6uRJEnSBrbimLMkLwceDXwJ+DLwqCQvm3fFJEmSNqI+LWe3Bq7Xpb4gyatogZokSZLWWJ/Zmt8A9pq6vifwxflUR5IkaWPr03J2GeBrST7TXb8J8KkkxwFU1V3nVTlJkqSNpk9w9oy510KSJElAv+Ds+8B1aTM1v1ZV355vlSRJkjauJYOzJLsC/wXcGPgCLcfZfklOAB5eVWesTxUlSZI2juUmBLwY+CqwT1Xds6ruAVydNlPzpetROUmSpI1muW7NW1bVQ6Y3dOk0npPkW3OtlSRJ0ga1XMtZ1q0WkiRJApYPzj6R5BlJtgrSkjwdOH6+1ZIkSdqYluvWfBzwSuCkJCfSZmveEPg88PD5V02SJGnjWTI462Zj3ifJ1YF9ad2cf1NV/7delZMkSdpoVsxz1gVjBmSSJEnroM/ampIkSVonBmeSJEkjsmJwluTqSS7c/X9QkscnueTcayZJkrQB9Wk5ewtwbpJr0GZvXhV4/VxrJUmStEH1Cc7+UFXnAPcA/r2q/gq4wnyrJUmStDH1Cc5+n+RQ4M+Ad3bbdp5flSRJkjauPsHZQ4GbA8+rqu8kuSrw2vlWS5IkaWPqk+fsq0n+Btiru/4d4B/nXTFJkqSNqM9szbsAJwLv6a7vn+S4OddLkiRpQ+rTrfks4ADgFwBVdSJtxqYkSZLWWJ/g7Jyq+uWCbTWPykiSJG10K445A76c5P7Ajkn2AR4PfHK+1ZIkSdqY+rScPQ64LvBb4BjgDOAJc6yTJEnShtVntuavgb/rLpIkSZqjFYOzJJuApwJ7T9++qm4wv2pJkiRtTH3GnL0O+H/Al4A/zLc6kiRJG1uf4Oy0qjKvmSRJ0jroE5w9M8l/AR+gTQoAoKreOrdaSZIkbVB9grOHAtemLXY+6dYswOBMkiRpjfUJzvarquvPvSaSJEnqlefs+CT7zr0mkiRJ6tVydiDwZ0m+QxtzFqBMpSFJkrT2+gRnd5h7LSRJkgQsE5wl2bWqzgDOXMf6SJIkbWjLtZy9HrgzcAJtdmam9hVwtTnWS5IkaUNaMjirqjt3f6+6ftWRJEna2FacrZnkA322SZIkaXbLjTnbBbgosHuSS7GlW3NX4IrrUDdJkqQNZ7kxZ48CnkALxE5gS3B2BvCy+VZLkiRpY1puzNmLgBcleVxVvWQd6yRJkrRhrTjmzMBMkiRp/fRZvkmSJEnrZMngLMktu78XXr/qSJIkbWzLtZy9uPv7qfWoiCRJkpafrfn7JEcBV0ry4oU7q+rx86uWJEnSxrRccHZn4LbAbWipNCRJkjRny6XSOB14Q5KvVdUX1rFOkiRJG1af2Zo/TXJskp8k+XGStyS5cp/Ck9whyTeSnJTkKYvs/39JTuwuX05ybpJLd/u+m+RL3b7NAx+XJEnS+VKf4Owo4DjaSgFXAt7RbVtWkh1pKwncEdgXODTJvtO3qap/qar9q2p/4G+Bj1TVz6ZucnC3f1OfByNJknR+1yc4u2xVHVVV53SXo4E9ehx3AHBSVX27qn4HvAG42zK3PxQ4pke5kiRJF1h9grPTkjwwyY7d5YHAT3scdyXg5Knrp3TbtpHkosAdgLdMbS7gfUlOSHLYUneS5LAkm5NsPu2003pUS5Ikabz6BGcPA+4L/Aj4IXDvbttKssi2WuK2dwE+saBL85ZVdSNat+hjkvzRYgdW1RFVtamqNu2xR58GPUmSpPFaLpUGAFX1feCuqyj7FGDPqetXBk5d4raHsKBLs6pO7f7+JMmxtG7Sj66iHpIkSecb81xb87PAPkmumuRCtADsuIU3SrIbcGvg7VPbLpbkEpP/gT8BvjzHukqSJI3Cii1nq1VV5yR5LPBeYEfgyKr6SpJHd/sP7256D+B9VXXW1OGXA45NMqnj66vqPfOqqyRJ0ljMLTgDqKp3Ae9asO3wBdePBo5esO3bwH7zrJskSdIYrditmeRpU/9feL7VkSRJ2tiWDM6SPDnJzWmzMyc+Nf8qSZIkbVzLdWt+A7gPcLUkHwO+BlwmybWq6hvrUjtJkqQNZrluzZ8DTwVOAg4CXtxtf0qST865XpIkSRvSci1ndwCeCVwdeCHwBeCsqnroelRMkiRpI1qy5ayqnlpVfwx8F3gtLZDbI8nHk7xjneonSZK0ofRJpfHeqvos8Nkkf15VBybZfd4VkyRJ2ohWTKVRVU+euvqQbtvp86qQJEnSRjZo+aaq+sK8KiJJkqT5rq0pSZKkgQzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkZkrsFZkjsk+UaSk5I8ZZH9ByX5ZZITu8sz+h4rSZJ0QbTTvApOsiPwMuB2wCnAZ5McV1VfXXDTj1XVnVd5rCRJ0gXKPFvODgBOqqpvV9XvgDcAd1uHYyVJks635hmcXQk4eer6Kd22hW6e5AtJ3p3kugOPJclhSTYn2XzaaaetRb0lSZK2m3kGZ1lkWy24/jngKlW1H/AS4G0Djm0bq46oqk1VtWmPPfZYbV0lSZJGYZ7B2SnAnlPXrwycOn2Dqjqjqn7V/f8uYOcku/c5VpIk6YJonsHZZ4F9klw1yYWAQ4Djpm+Q5PJJ0v1/QFefn/Y5VpIk6YJobrM1q+qcJI8F3gvsCBxZVV9J8uhu/+HAvYE/T3IOcDZwSFUVsOix86qrJEnSWMwtOIPzuirftWDb4VP/vxR4ad9jJUmSLuhcIUCSJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGZK7BWZI7JPlGkpOSPGWR/Q9I8sXu8skk+03t+26SLyU5McnmedZTkiRpLHaaV8FJdgReBtwOOAX4bJLjquqrUzf7DnDrqvp5kjsCRwA3ndp/cFWdPq86SpIkjc08W84OAE6qqm9X1e+ANwB3m75BVX2yqn7eXT0euPIc6yNJkjR68wzOrgScPHX9lG7bUh4OvHvqegHvS3JCksOWOijJYUk2J9l82mmnzVRhSZKk7W1u3ZpAFtlWi94wOZgWnB04tfmWVXVqkssC70/y9ar66DYFVh1B6w5l06ZNi5YvSZJ0fjHPlrNTgD2nrl8ZOHXhjZLcAPgv4G5V9dPJ9qo6tfv7E+BYWjepJEnSBdo8g7PPAvskuWqSCwGHAMdN3yDJXsBbgQdV1Tentl8sySUm/wN/Anx5jnWVJEkahbl1a1bVOUkeC7wX2BE4sqq+kuTR3f7DgWcAlwFengTgnKraBFwOOLbbthPw+qp6z7zqKkmSNBbzHHNGVb0LeNeCbYdP/f8I4BGLHPdtYL+F2yVJki7oXCFAkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRsTgTJIkaUQMziRJkkbE4EySJGlEDM4kSZJGxOBMkiRpRAzOJEmSRmSuwVmSOyT5RpKTkjxlkf1J8uJu/xeT3KjvsZIkSRdEcwvOkuwIvAy4I7AvcGiSfRfc7I7APt3lMOAVA46VJEm6wJlny9kBwElV9e2q+h3wBuBuC25zN+DV1RwPXDLJFXoeK0mSdIGz0xzLvhJw8tT1U4Cb9rjNlXoeC0CSw2itbgC/SvKNGercTzL5b3fg9AX1mamMVRy/FmX4OHwcC48fSxkXlOfCx+HjWHj8WpRxQXkca1HG9nsuZnOVxTbOMzhb7FFVz9v0ObZtrDoCOGJY1dZGks1Vten8XsYY6rAWZYyhDmtRxhjqMJYyxlCHtShjDHVYizLGUIe1KGMMdViLMsZQh7GUMYY6rKV5BmenAHtOXb8ycGrP21yox7GSJEkXOPMcc/ZZYJ8kV01yIeAQ4LgFtzkOeHA3a/NmwC+r6oc9j5UkSbrAmVvLWVWdk+SxwHuBHYEjq+orSR7d7T8ceBfwp8BJwK+Bhy537LzqOoO16E4dQxljqMNalDGGOqxFGWOow1jKGEMd1qKMMdRhLcoYQx3Woowx1GEtyhhDHcZSxhjqsGZStehQLkmSJG0HrhAgSZI0IgZnkiRJI2JwJkmSNCIGZ+ssyQ5J7jtjGVfts03S9pPkPn22XdB133m3GEE9Dkzy0O7/Pfp+Zya5Tff3notd5lnnseoyLOy58i3XR5KLbe86rDUnBAzUfbm+p6rOTPI04EbAc6vqcwPK+GhV/dEMdfhcVd1owbYTqurGqy1zlfXYBXg4cF1gl8n2qnpYz+MfBnysqr41Qx1uBBxIS1L8iSGvw1QZlwP+AbhiVd2xW8f15lX1yoHl7Afcqrv6sar6woBjLwzcC9ibqVnUVfWcgXW4wSJlvHXA8dekrXF7uaq6XlfeXavquUPqMYskd6yqdy/Y9uhuhnef4y8KPAnYq6oemWQf4FpV9c45VHe5eiz2Od1mW49y7sS2n7Gh74vLLjj++wOPvwqwT1X9b5KLADtV1ZkDjv9UVd18yH0uUc4t2Pb9/eoexz0T2ER7H1wzyRWBN1XVLXsc++yqemaSoxbZXX2+75Jcern9VfWzlcqYKusDVfXHK21boYzXVNWDVtq2Qhkz/+Z076W9qmpVK/t074f/Ai5eVXt138GPqqq/6Hn8jsB7q+q2q7n/eZpnEtoLqqdX1ZuSHAjcHvhX2o/ZostLLeH9Sf4aeCNw1mTjSh/QJNemfUnvtuCMbVemvnj7SPIdFll1oaquNqCY1wBfpz0PzwEeAHxtwPF7Aw/svvhPAD5GC2pO7HNwkmcA9wEmwcdRSd60ikDiaOAo4O+669+kvTa9g7Mkfwk8cqour01yRFW9pGcRbwd+SXseftv3fhfU4UjgBsBXgD90m2uqTn38J/D/gP8AqKovJnk90Os57QKh5wP7snUwMOR99fQkv62qD3Zl/g1wENArOKO9licAk2DgFOBNwIrBWZIvscRqJABVdYMeZdyRliLoSklePLVrV+CclY5fUNbhwEWBg2k/QvcGPjPg+LsCLwCuCPyEtlTM12jfI33LeCRtibxLA1enJQU/HOgdDADvS3Iv4K21yhaBJK/p7v9E4NxucwErBmfAPYAbAp8DqKpTk1yiz/1W1TO7vw8dWOVpJ7D86jcrfj66k+GLArsnudRUWbvSXt8htnr9uyBlaKB1fJKbVNVnBx43uc+70H4/LwRcNcn+wHOq6q4Divk32u/PcQBV9YUkvRs+qurcJL9OsltV/XLA/c6dwdlwky+FOwGvqKq3J3nWwDImZ1qPmdrW5wN6LeDOwCWBu0xtP5MWGAwxvUTFLrQgZ9mzu0Vco6ruk+RuVfWq7kf8vX0PrqpnwHlnT4+kBQX/Tstt18ehwA2r6jddOf9I+/IdGpztXlX/neRvu3qdk+TclQ5a4OHATavqrK4u/wR8CugbnF25qu4w8D4XullV7TtjGRetqs9k6zXlhgQURwHPpH1pHkzLXTh0gbq7Au9M8v+AOwDX7rb1dfWqul+SQwGq6uyk9yJ5d+7+Tj6br+n+PoCWi7GPU2k/xnft/k6cCfxVzzImblFVN0jyxap6dpIXMCzY/nvgZsD/VtUNkxxM+9wM8RjgAODTAFX1ra4lbognAhcDzk1yNu09UVW164AyNgH7rjK4+11VVZKC1XWDJXniIpt/CZyw0gllVa3FsJNHAU+gBWLTPQRnAC/rU0D3HfdU4CJJzphsBn7H8BxfBwOPSvI9WiPD5DVd8QSm8yza++rDtANPTLL3wDpQVScv+HgP/e7+DfClJO9n68aSxw+ty1oyOBvuB0n+A7gt8E9dd9SgsXur/aBW1duBtye5eVV9ajVlTJX10wWb/j3Jx4FnDCjm993fXyS5HvAjWmtYL1238C2BiwOfB/6a1nrW13dpgeVvuusXBv5vwPETZyW5DF2LSbrVKgaWEbb+UjiXYUHJJ5Ncv6q+NPB+p30qyb5V9dUZyjg9ydXZ8lzcG/jhgOMvUlUfSJKq+h7wrCQfowVsvVTV6V2Lz//Sgpt7D/xB/l0X8E8ew9Xp2RrZ1Zkkt1zQ5fWUJJ+gtRCvVMYXgC8keV1V/X6l26/g7O7vr7uuuJ8CQ74/fl9VP00b97VDVX2oO3EY4rdV9bvJD2CSnVimdXExVdWrlWoFXwYuz7D348R/d9/bl+xaAh9GayUeYlN3eUd3/U601Wwe3bXY//NSBya5dlV9PW0Yxjb6DMeoqhcBL0ryuAEt8gvLeD7w/CTPr6q/XU0ZU+444/HnVNUv+583Lerkrmuz0lYTejzDem8A/qe7jIrB2XD3pZ3N/2tV/SLJFWgtPr2ljYl5Iq2v/bD0HBOT5CVs+cHZ5ux3SKS/4EtiB9qXztAv0CO65vWn05qVL86w4O6etFaZ/wE+Ahw/aQXr6bfAV7ozngJuB3x80pU04Pl4Iq3+V+9+gPegdR8NcRTw6STHdtfvzoBuUdq4uYd03c2/ZfhZKMCraAHaj2Yo4zG0M+hrJ/kB8B3ggQOO/02SHYBvpa3y8QOgVytLkjPZ0vVTtO6OqwH3brFe71aWZwHvAfZM8jraCcBDBjwGgIslObCqPt7V7Ra0lp8VTXeNLvbDM/D1eGeSSwL/QmstKVr3Zl+/SHJx4KPA65L8hIFdq8BHkkxaW24H/AVbApReupbLBwBXraq/TxtMfoWqWrGLNsk7aI/7EsBXk3yGqWC7TzdYVf1rV/czaD0Qz6iq9w95DMBlgBtV1a+6ej0TeDPwR7STiCWDM9p3zGG0LuZtqgfcZkA9fpnkwdsU0mPs3dRt/zbJlWjd3NPj9z46oIzJicxW4xkH+HKS+wM7dr+Bjwc+ObCMRwMvAq5EG77wPrbukVpR1+tzIeCa3aZvrMFJ1cycEDBQkr0W2z5kgG2SN9I+zA+uNuj6IsCnqmr/FY77s+X2V9WrBtThQ1NXz6H9CL9gtQMzVytt3MeB3eW+wI+r6sCex878fKSNtXg8rfvxWrTAYFUfzmyZnBDgo1X1+Z7HhTaR4HsL902+AHuWcxLtR+BLbBlzNqiMqbIuBuxQAwZ9d8fdhHbmeklal9puwD9X1fFD6zCLriX0ZrTX4viqOn3g8TcGjqTVH+AXwMP6tHCkjaGEJbpGa+Bg/qlyLwzsMmRsTPc6/ob2PDyA9nhet0jL+XJl7EDrtv+Trpz3VtWgVqckr6C9J29TVdfpTureV1U36XHsrZfbX1Uf6VHGY2mP++d967xIGV8D9quq33XXLwyc2D2ez1fVDVc4fgfaRKNPrLYOXTnTrWa70Mb+fa6qep9Qpg0BOQT4KlPj94aM98oS4xmrqtd4xq6R4u+Yel8Bfz/wBH1mSQ6indh+t6vHnsCfDQlU58HgbKCps+LQPhhXpf2YDxlgu7mqNk1/oJN8oar2m0ult73/HYD7VNUbZyznksCD2Xb2VK8Wq64r9FbArWktdyfTJgT0bn1bizOeJB+uqoOGHregjJsBX5kEM13QuW9Vfbrn8Wsx8+mDVTXkDHz62MXG05ynql64ijJ3oM2iOmPFG2993D2AD06CkO59dlBVva3n8ccBxwDHVTcGcLWS7Er7nhw8WDjJJxZ0jS66rUc5q5qhuFaSPAh423SgnuTOK7X0Lyjjc1V1o+34nfdcWjDyOVrQ/d6BXeUkeTptYsHbad//d6a1uL8AOKKqHtCjjDWZtbqgzN2A1wwMrL4B3KCqVjX5qCvjC7QWv63GM1bVYQPL2ZUWGA46EeyO/WfaGOOzaa3l+wFPqKrXDijjBOD+k4aJtBnrx8z6fTwr85wNVFXXr6obdH/3oQ1o/PjAYlY9Jqa7/YeSfHDhZcBj+AMDm36X8C7aj8aXaC2Bk0tf/0SbafRi4DpVdfDAwOwg4Fu0wbAvB76ZATN1pnwiyUuT3CrJjSaXgWW8AvjV1PWzum19Hd+1Os3i60len+TQDM/DdIkVLr10979r12LzVeAbaQP7h3jmdDBUVb9gwJg12o/lrWhdYG9Kcu+0mW4rSvLA7u8Tu4D1EcDDp64PcbG0Wd2Tsnt3jU4d8xrajLYDgZt0l03LHrT18fdM8q0kv0xyRpIzs2UgeF8vAT6W5DpT24a2/v2+a6WefOftwVTrbh+zPJaqehqwD22owUNo3e7/0H339lJVf0+buPSL7vLoqnpOVZ3VJzDrvC/JvbrW8rXya9pjG+LbwM4z3u/vuxbY88YzAvv3PTjJTbrGji/SBuR/oWuxHuJPupO/O9O6Na/JwGFGwM7TPUZV9U1mf25m5pizGVXV51bxo/osth0TM2Sa9l9P/b8LLT/W0HEkq0rnscAuVTX0B+s8VXWnqZavayUZ2vL1AtqHc6szHoZPCZ8kyJz+wRk6DiTTZ+JV9Ye0gdN9HUwbWPxdVjfzCeAitCD/T6a29UqlUVXPHnA/y9m3qs5I8gBa8P43tID9XwaUsdhJY+/nsuvm+kgXDNyG9oN6JO1EYCWT4GktBrA/jJbeZTfa6/BLtszU7muWGYrQxkHdpaqGDpKe9h1at+abkzyrqt7E8Bm4LwaOBS6b5Hm0MZ1PH1jGTI+lqiptPOaPaN+Xl6I9pvdX1ZN7FnMOLagstkyIGmLmWavZMgYP2mdlX+C/ex47Gbf8a+DEJB9g6/F7Q2Yozjqe8ZXAX1TVx7q6HUgbuzvkO28SRP0prbXrZ6uIezcneSVbDz8Y0sgwF3ZrDrTg7HkHWhLay1TV7QeWM9OYmEXK+0hVLTs2Y8Htv7PI5qoB+aiS/BWtteidbP0B7xXgpY0leTWr7OtPSy9wg5W2rYckb6VNCZ+0lv0FcHBV3b3n8VdZbPtqxovNIlvn5Zr4JbC52mzhlY7/Cu3s+fXAS6vqI0O7r9Lytf2C1iJawOOAS1XVQwaUcRFaupn70T6j76yqx/U9flZdYPj4qvq3GbtG39SVs5oZiqvqRl2kjEmX5O60k58v0E6KBn3O0vI0/jHts/6BoUHWLI8lyeOBPwNOp02oeFtV/T7d5JWqWrEFLVtyGb6F9hjuQevOXNXMydXK1mPwzgG+V1Wn9Dx2LcctLzae8bUDvv9n7vZPGzt3d1q35gG0sa7vrKreeUfTxg4+hqnxwsDLqhtbuL0YnA2UNkNn4hxaYPGWGjCIMTNmeM7W2aZ3oLUUvbiqrtW3DmshyWOA59F+SCdvpN4BXmbs60/L2P0Htj7j2akGJovsWjaeSZt1BW3m6HOG/JimzVh6Ma2lpoAP0MY+/GRAGateYaA7/igWTyzcu7UmyRG0vGJv6jbdi5bUdk/g21X1hBWOfzyttewLtFQDe9G+sG+13HELyrgYrVXltrQvy/fRVuHoNX4sbcLNTWmt0/8NfLjryu+t63Z7JNuO9RryXK7FWMZJV9HgGYrd8S+ipZ9424Ljh6wa8T9Vdafu/x1owxGeVFW9h8Vkhoz0U13zt2aVjyXJc4BXLnayk+Q6fQLFJF+kDeif5DK8GG0i19Ag9Z5sWdXkY9VzLOXYJHl4LVhFJck/VtVTeh7/b7SkusfQnov7AT+nBb+90ot05VwKOKNaQtmLArtW1Y8GPI6/rJamZNlt683gbB1lS4bnD9Eynk9neH53VV1niUMXljPJ7h+2zLR8TnXT/gfU53psm8m990DjJP9HS7y6qla/WVu+ljjjeXkNHOSa5C20HEqTs8YH0WZlrdu6edl2hYHBZ+VpGdgndunKOHVIV0Xa2MU/qapzuus70YKj2wFfqlUkuU2y06S89ZDkDsD7q2poMsrpMj5Jy7l3AlP566rqLQPKeB6tNWHh0IEhS70t2hpePWYodsevesmhtZQFy1Z1LYu93k9LPIaJQY8lMyxj1Y2PukltSXq9C/DZqrr+gDJeDlyDFpBAC0j+r6p6jwHugrt/oqWoCavrGl1sJYxfAptpJ0IrzuZN8m7aidfruusvow11eXjPOnxomd1VPSY3ZW2WU1xsmbXP1wqzb+fN4GygtJxa96k2SHkStb+hT7dm9wP8BNrU4x+wJTg7A/jPqnrpPOq8RF2eSQsQ96WNDboj8PEaNh37OOCQquqbOX3h8UfSviAGt3x1Z/BfrKrrrea+F5R1Yi1IY7LYthXKmKmlZa3OyheUuQNtJlXvsXNps7gOqC0zJXcDPl1V1+7zhZUZ1ilN8u9V9YRsPabmPH1bi7qyZj3xGPT6L1HGYj8+vX50xqR7b/8N2z6ffX48z8tIz5YVFs7LSF89E6F2wdw/VtXQwd6T4+8CvJBVpn3oyngirWt0Opfh0VX17wPK+Apwvep+eLvP6JcG1uMkZhxHmDbL8Vza8ANoM1lDC9AOrKq7LHXsVBkXoc1WPZL2+/GzlVrWp47dgZZcutdYuWXK+WK1FTQOpC0b96/AU/t0a6blCr0/7eR+Ovn5JYBzazuvt+mEgOH2mARmAFX18/RcyqTWIMMznHfG9hdsaRr/OG0pqSH5Ye5Nm3b8+ap6aPejOiS5JbQP94ndj9BqBpX+Oa3l6/FMtXz1ObDagPsvJNlryNnvEs7O1glHb8mWzOx9vZ32Af9fhi8fAsy8wsBi9qF1Kw7xz7TX9MPd/f8R8A9dsPi/PY4/mtWvUzoJ0v91QH23sdSJB/3WYJx4Z5I/rap3rbYeVXXwao9N8vGqOjBbEvOet4serSRJnlxV/5ypxNUL6jZk4PfraK/hnWhJP/8MOK3PgbVGGem7LquhM6inPZcZl7Gqqhcm+QhtAleAh1bPXIZTvkH7TE66V/ekzVYc4sezBGadhStgfCndeK90M5aXkq2H1TyC1s38CeA5SS5dPcacdd/fj6XnRIZlzLKc4idpq03sztbJgc9k+Guy5gzOhjt3OiBIG8g9dCmTl2S23EWvpr2BJgHeobQftvsMqMbZ3QfknLQByz+hx+K7C7ytu6xK1/34wu6yGlegrRDwGbbuNhqyDiO0IPFVXSsRtHEPDxlYxkWr6m8GHjNt1hUGyLYZ9n9Ea/HorapemeRdtMG1oZ2Fntrt7tNqsep1SqvqhO5vry67Zaz6xGPBc/jUJL+lzcob3HXUlXcn2iLT0y1OfZaAOrD7u9pZo5Mf782rPH7aZbr3xV/WlpmwQ1+jz2RqcekMzF3XObFrrX8TW3/e+4yfW4tlrKAtuv5Duu/tVZwcXgb4WvedBS01yqe6x9X3u2tz2rjKt7HKcYTAxZPctLo8jEkOoK3wAivPuJxexH3y907dpej/O7IWGQNWvZxitfGH3wPWNO/cWjE4G+6ptCWCJl9Of0RblqO3tNxFV6d90M/Lzkz/M/tr1daz3z6UlhBwiM3dF+R/0j5sv6INOu6tBszsmbbEeIfpcvt25a1J+odqixbv1wWp1MCkqZ2ZWlrW4qx8hh/yhX5D+wHaBbhGkmtU/2zZq16ndA3fF6s+8VjD55Akh9PGmB5MCw7vzcDPWFY5kL6q3tH9XdVndIFJyogfdsHmqcCVB5bxzKqanHhQbem7ZzLs5O7StLVFp7tTe6WKYUvah4+xymWskjyONnHox2xp2S6GpX6YzuMYWu/HobSekL52pXURD06ZM+URwJHdcxLa0JpHdC3kz1/uwFqbRdxhS1qZ6fF2Q4I7WJvlFKdbpy9ES89x1tATsbXmmLMBJv3kwAfZkgbjUzV8aZivMUPuoiRHA4dXtyROkpvSUlAM+YBPl7c3bYZLr6bcJP9dVfdd6sd0pR/RLJE2Yur49U4f8Q+0JYZ+0V2/FG022tMGlHEmLX/R77rLagbp7ghcjq1bU1c8K88aLKo8VdYjgL+k/fieSHuff6rvOKmuDi8BrkebZLEHbWzJiu+ttPX1LkdbKWLaVWgTG07qWYeX006iDgGeRDvxOLEGzOLNjKsUdMdMxsNM/l4ceGtV/cmKB28pY+FA+p1oYy2XHUifJcbtTQxpXU5yZ1pQsyfttd0VeHZVHTegjMUm/3yphg2m79VltsSxF2VL2ocH0h7D64aUlzbW66Y1YOmrJcrZnzbW6b60yVxvHTLMJckta8ESUItt61nWbrQ44BerOHab9T1h3VevmHk5xUXKvDtt3O1TV1vGWjA4GyjJR6tqNVnop8uYNXfR12jrQE7egHvRujH+wIDEpUluwLZdq32mpR9aVccsEWTdr6qWWwB4ZouMw9nKKrqePl8LBrov/FGct6XOyvu8lkmOqKrDsgYD0LuA+ya03Hv7p+WmenZV3W+F424CnFxVP+oCiEfR0nB8lbbI9Io/gkneSetG/eKC7ZtoLS8rDlJepMy9GXDiMXXcYpNEtnmfrFDGp6vqpkmOB+5Ja/X5crWVRVY6dqaB9FmD9SjXUtYmd923aCcMR9Fmt6/447XEd8VkLOdvgP8D/q6qPtCjrA8Bt6tVzDxOSxN0CK2V7Ke0rry/rqplT1SXKGux2YW9vq+SPLCqXpslVruoAcu0ZW3W+Jx14s7MyykuUe7xVXWzWcqYld2aw61FP/nutKVlVpW7iNaMO5Puy/IGtBxWkxxQfZvGX5vkMOCBVfWDBeUeQhtU3qcOi31xTqZzP6mqvr3YcZOup7TcRT+ijbebJEJcTbfUjkkuXF0KjrRZSBceUkCSyf1ftar+PsmewBWqqm831l/SuqsHn5VXt5ZdzTAAfcpvquo3Seiek68n6ZM/bzLuA9qKC39H+wHeHziC1uK8kr0XC6KqanMXZC1ruRbEJDca0oLIjKsUdN7Ztbj9C21Nx6Ln2LeacSD9dPDVvZ/3qqklavrIEpMJpu5jyKSCx9Fy103W830f0LtlunNN2nvsYcBL0sZdHV1tuZ2l6rjk90HXUn092oSHPrO+vw18OMn/sPX3dp+A5uu01se7TFqA05J495bk5rTP1h4LgqtdgR17FrNmK2DUgqTOXSvca5a4+TayBhN3Fra8dp/9R/U9vjtmOmXSDrRVObZ7q5XB2XBr0U/+rFkqMOn2yww5e4CbrdQ1sowv0qZgH5/kidWWc5kYMsPwhbTxK6/vjjuElmTyG7Tp2QetcPzta+sp069I8ml6BodTXgt8IFuSuD6MLTnP+no5Lci9DfD3tK60l9Faofo4mZ5js5aSxXP+/H0NG7t2ShdQvI12IvJz2mu0kh2nTlDuR2vdeQvwliQn9rzv5da/vEiP459IG//5gkX2FcOW49qc5IVs3dIzaEmXamsxQnsO3knLATX0NX5nkotV1Vlps+huBLyob9d/WgqJf6WNpblq16X2nJ4ngtOTCZ7NsPVNt1ItRcxTkly8qn614gGLl1HA+2nvy4Npn9u/SBtv+5Sq+tTA8s4FvrCgBWg53+8uF+ouQ9yL9v32oSTvAd7AsO9Kuvu8OO13ezq4OoN+Jz9U1X90f9dqubZpQ9f4XIuMAVup1S2nON0iP0ksf7dZ6rEW7NY8H0pyV9oP0Cw5e14JvKCqvrqK+58s53JN2lnnl4HHVNWvh3QHTrp9Fmw7vqpulh5L/qQlCn0Z7YuuaF0Gj6mqWyx33BJl3ZEtS8u8r6reO/D4yXNyXtdXz8cwOQO+Lq2rejVn5ZOyVp3zZ4nybk1LovqeWmEpkyRfBvavNjvz68Bh1U0iSPLl6pGPLskxtHFe/7lg+8NpiXGX7VpdS9l6lQJoLT3Pq56rFEyVM8usbNLy3+1Ha+V+DW0G7z2r51Jtaatw3Ia2SsLkfTl4ibOhXbqLHH8L2g/vxatqr7TVMB5VA8bJpk00eSAtSfSPac/FcbTW2TfV2g1Un5vufXV32nfVbWgngcdW1fsGlHGVqRP0HWjP6aBJTFmbFTCmxzXuCFwH+O/qv0LAZ6rqgO49ejAtA8GXB/6OTbcg7sAql1McI1vOBkobWPpEWjfBYWmDmK9VVe8cUMass0P+nhlz9tC+FD6VthDwbxkwxmmiqr7ZNbU/F/h8lhgguow/JLkv8Obu+vTZX5+zhvsDL+ouRcu1c/+BdWh3VvVu4N2rObbz+66bZDJLcQ+2dBcvZ3IG/D1Wf1Y+MUvOn/N0wd0+VXVU9ziuRBu4vJxjaCkWTqfliJssZnwN+rcIPgE4Nm3R9Ekr1Sba83GPgY9h1UFR9zq+vWZMQpnZZ2UDnFNVleRutBazV2aF9REXOf6XGb4Y9EKznsX/G3B7WjBFVX0hydCxu5+iBah3r63XktycNjN2LrKGyZG74P51tBmjl6alP3oKLfjv6/lJHk17T50A7JbkhVX1LwPKmDUvI2ydj3DQGp+dmTMGsHUL4jm0k9veq3gAJHkV8Je19YSwFwwJVOfBlrOBunEOJwAPrqrrdeM5PlUzZBPPwNkhSTZX1aauOf+G1dIGfKaqDhhwnyfRgswvMRVE9OkuWewsOslBtK7IPZYb57HgmKvRAqub0770jgf+irZ6wo1r4HJUQ2XGRJ8LynoAWxbZfhUt0Hzagi7fpY7dEXhVVS2b/LFHOe+kPXe3pa23ejbwmZVa7xaU8UxaQHStqrpmkivSWiVWXIw4LW3GFWgtj5OVDq5JO7MfMmP0YLaMAfpKVX2w77Hd8YsGRUPGSKXlnXrQKrohp8uYaVZ2V8ZHaGuEPpSWtuc02szTXrMcuxbyD9ACgHvREj7vXFWPHliPmSbIZMvkiEEtywvKyCzP5WoluXFVnZAZl9Jaw/qcWG2yzgNon/O/AU4YcmKdNVgBoyvn8rSciEVbyqr3mpYLytmbVUzcmTr+ErTP+OAu8yV+z2ZqKV4LtpwNd/Wqul/a0g9U1dmZ8bS0qt6WpFdTcOcXadPyP8oqc/YA368BU+EX2Ga8QlV9OMmNGTAYs9qA/6Vm4C0ZmGWNBirX7Ik+p8t6Xdc8P+kavXv1zOJdLfv5HkkutFL34QpmzvlDa6G6IW0AO1V1avfFt6LqUrss2LbkYO1lyvkQbf3Z1drEjEERbSbfl9KWa5ue+DNkEPyXaWMoVzUru3M/Wmvww6vNhN2LNsGgr8fRJmf8lta6+V5ay/uKFpy0XDTJpOtsNQl5T+5aMyvJhWhBYq/PRxcoT/7fZv+QlqvVqC45MvCrqf8n9Rk8g3gN7JxkZ1r36Eur6vdJhr7XZ14BIy3tzjNoqaVCm6TxnKo6sufx56WrqarvJrlkkrvXsHQ116O1pl66u346La3Ulwc8lB2SXKqqft6VcWlGEBvZcjZQ2jinPwY+UW2M0dWBYwa2Wi02O+TWVdUrU3E3buHs7tgH0MYFvbaG5ex5OXBJ4B2sPsv0TFY77mGqW+eWtJk+kxlg96GdQQ6dBbWqRJ/d7S693P6+r0lalusb0bp9poOBIWPO/hU4qqq+0veYRcqYjAOZjKGbeY3P9ZYZU9V0Zfw57T35B1rr29nQL6nrVPfXJWjjoVY7K/sCI8nutFby29K+t95L60rqs8D2abQJM8cAn2bBQPr1arlK8jnaD/+XuuuHAk+oVY7pnKEej6e1ln2BNoRhL9r3/60GlDHJy7jqFTDS1uG9xeQ1TBsT+Mmq6jO7e9HWu6EtVt3v8d91J3STHpx/qAHjjtOG4/wtbXhN0U5yn1dVvWeezsN2jw7Ph55J62bYM8nraAHCQwaWMevskGdUWyroD3SzCtOWIhmyVM9FaB/MWbJMz2pV4x4mP5BJHgIcXFW/764fzrCxGxNbDUBNy9N1457HTi9lshdt6afQAt/v0/Lu9HFqd9mB1U9z/zpwRFf/o2gnDUO75f67CxQvmeSRtJmr/7nCMaOwIChaVaqa7rn7B9rj/h7t9diT9nz2TUo509qgXT2WyuU36Ed0iXFSk3Q1/1HD1uNdtWqJuh+wysMvD9yONq72/rRxRcfMchKySvcG3tx1Jx4IPJitvz/XRVW9GHjx1KbvdUMBhpSxzXfMKnqATqEN4p84k20TSC9nLdLVXGwSmMF5PTgXW+6Aharq1Uk20yZohDbhZvBEubVmy9kqdGcIkxUCjq+BKwSswf0vloRw8Ays7W3WcQ/dmdvNJ61TaQM5jx9w5jZTos8FZR0OHDfpJkib/XnbqnpS3zK64y5WA2cELlLGtWhjlA6lTZL4z+kvsB7H3472oxPgvVX1/lnqs166YPJydJMRptwa+EFVrbhWaZJ/owV3f1VVZ3bbdqUFXL+uqiesaaXnLMmLaKs0HNNtuh8tN+BFaGN8VmwdXqN6TMaX3owWLH6K9hwvmstwmXIuTHtf/wstJUjvzPproRtD+TZaEHL3qjp7Pe+/q8PlaCcQV6yqOybZl/Y92Hst3q778RlT13cAXlNVvQPoJK8Grk87yS5aA8NngG/Cyq3+WZvExMfShmBMWrkeCGyqqrv3LaMrZ+EkqItX1UqToObK4GygLDHDqPqvPThLd96f09Zguxots/XEJWjdrCsOKE/y5Kr656XGbQ0cUzOTJM+lNYOvatxDkofScsZNAo9bA8/q0/W0oJxVJfpcUMYJVXXjBds2V9WmnsffnJYaYNWpBrpydgTuTAvO9gT+m3aWf1ZVHTKwrN2Bn844dmvdZA1WGEjLQn/NhY+5e16/Xj2y+08dc0/gn4DL0gLd1YzVmkkWWdFksi3JV2rGTOoD6nE87Ud4EiQeAjyub5dgF5TdiRaY7U3r/j+yFiTBnodsu0zdZWmtj78Fhqz5ulb1eTetJffvqmq/rrX38zVsKayjaZn0n989t2+iZfd/1oAyls17VyvkUsvW6WpC6/V47pCT0+6E/Nm077jQxmE/azJ+rGcZq54ENU8GZwN13QQTu9BmqpxQw5bI+STt7P4EprrzqiXtXO643YBL0XJYTU8gOHPA2Ka7VNU7ssR0/KGBzSyyNutRXh6YfMF/ulY/W+hKtHxx08HykID7vbTX9LW0L/IHAn9UPfPtpCXPvTet9W0ym61XfrCpMl4I3JU2O++VNbU6QZJvLNeimDbT8h+Bn9EGjL+GtpLFDrSZye/pW4/tZbnnKz3XcUzyzaq65tB9S9z+JFpG+F4D3+chbcbo7atLUJ02oeA9VbXv0PE9M9ZjyZyGPY59FW327ruBN9Swwd4zy/jWAv5sVd0kW898HdQL0XVhvo42W/9g2nJY/7bK+qx6puRUGTvSuigH5WtbC2lJsm9IC05XnQtwrTnmbKCFZ99py/QMzUh/0W7M2ND7/iXtjO3Q7r4nKwRcPC3z9oorBFTVO7q/k3FbM3+wVmuxcQ99ZNtleibjHK6Y5Io1bJkekvwj7Uz+q2ydj6p3cEZ7TZ4JHNtd/ygDc89V1ckLhn0MzT/0ZVr6jl8vsm+lCSsvpXXx7kabfXXHqjo+bW3NY2jjLMdu1hUGoI1Ve3AtyImWlp3/6wPr8+PtGZh1ngR8PMn/0U5+rkrLqn8xhq+CMYsPpc1InySMvh/wP+km1Kxwcvkg2iSZawKPn/qMrEtLZG1J+LroItvbwVnd0JpJTsWb0TOXYLZe2uxFtGXXPkHLUThoibMsPlPywdVzLGCS1wOryteWqRm8i6lhk25+V1WVbsbr0DFr82LL2Yy6M5AvDmxSnrU77y60pY9mWSFg+oMVWv6k3h+stdA9d4PXo8waLvTdlfcN4AbVra05i2580h+GBrtJ3kx7TV9KG5fzeNrYiRW7IrPIWpLT+nzhTp95J/laVV1nat+6tbDMImuwwkDXgvpW2uzMyWSPm9CCu3sM6UZLG+91edoYpe0yI7qrx4WBa9M+51+vdZoEsKAOk/E7kx+c6bOQqqohy99tF5nTIturqMeNgJfQWhO/TBtTeO+F3flLHLvc2NNB352ZcaZkZsjXljWcwZu2VvY+tEknz6dNBjqm2sSL7cbgbKAFY7V2oDWHfqf6jfeazMAKM3TnpSWfvQ0LVgiobgHsnmXMPAV5VkleQbceZVVdpxs/8L6qGro22qz1eDdwnxmb5a9Py/w+Sa0xKN9Otk41MBl/8fg+3dVr8YWbqUkmWTDhZOH1sUobKH0s7TO1zQoDQ7q8k9yGNos3tES4H1hFfY5aZHPVOmcez4xLSM143zcBTp48991winvRZqg/q+9wjDHqgqRHVdWghbbX6L53oi33FlqA+PvtUIdtkggvtm2Z479CSzXzelq+to/0Pb7rBp3M4L0BM87gzQgnQRmcDZTkMbR1xAB+Cny3qj6xznVYixUCZvpgrYWscj3KqeMfA7yutl5249CqevnAeryFtn7hB9i6hWNIRvlZzyJvufB9tNi2eUlyLq3rKGw7e3WXqtp5PeqxFjLjCgMXJFmD1RJmvP/P0WYt/yxtMtUbaLPy9geuU1W9Fuweq+114jJrwJ3kH4B/XvDd+aSqetqAMmaaKZnkcbSx06vO19aVM9MM3iQPr6mZrl3g97Saz+LwvTnmrKe0jMz/Qstt813aj9Zlac3Ln0hyw6r6fM+yVtWdN+UXmX2FgG8neTpbf7DWe+rwatejnHhkVb1scqWqfp6WTmFQcEab+bXa1RImZs238xJaEtqVtm0j3Qzc7v/71NSSUUn+oXosC1ZVO650m/OLmn2FgTWR5Mq01/CWtPf4x2mJV4esPzirtVgtYRY7TrWO3Y+WouYtwFvSBmKfb2TbRbZvTBsOst71WIs1W+84/b3QfXf+KdA7OKN1/z2bLbkxP0qbJb6itNQdP66qK01t+z5tckIv2XYG74tZXZ7OP05yL+DhwGVoM2HXdUmuxRic9fcC4KLAVWpB/qOue+4O9E84+nK67jzazLhf0aaZL9udl7aI9OVo+WTOpq1D+QDamLPHDXw8i32wHjKwjFm9mNYNddkkz6Nbj3LA8TskW9bb6wK9wYuG19rMUF1VsJuWQuMWwB4Lvvx3ZUsL7UoOYcuklL+lTYufuAP9k6dqbR1F67K5T3f9gd22261jHdZiCalZ7Jhkp6o6h7ayyvTQi/Pb78/CRbbfycBFttfIWgTcOya58GScbdoa0Rfuc2CSXWgD+a9Bm+35pKHdql1vz2NpqX4m24qejQzZegbvs/sOH1miLvdPcj/aY/k1rfdlXXvDFnN++3BsT39KS1J33geiqs5Iyz12OnDHAWXddNKd15Xz87T15lby77Q8TpM8MH8AXpWWx+lZLL1O5WJuu7BrI8l92PqHfa5qhvUoO++lZbQ/nHbm+Gjah3WQJPvQBoLuy9SMv4GDlFd7Fnkh4OK0z+L0l/8ZtGC1jyzx/2LXtX72qKrpcWdHJ3nCOtdhd7ZdLaGqasiKJLM4hjYT8HTaCeXH4LwTzaGrV2xX091cXcvPxWs7TK5gbQLu1wIf6MZFFu37q+9J6qtoSz59jPa7dx3gCauow/u7wfhvZOsl6/qMQ1yzGbzd9/9f0gLt6wAP6obaLDbrfd0YnPX3h8XOVKotWn1aLbLo8zJW2523dy0yI6eqNifZe8D9w7YtLEttW3PZej3Kn7AlMSVJLj1gkPDf0M7E/5z2ofw8cIVVVOkoWhqMf6M1qz+UnkHNrGeR1WYVfSTJ2ZOuyamy7wN8q08xS/y/2HWtn9PTUnBM3t+H0saprqdnTf0fWrLOQSleZlFVz0vyAdrn8n1T36E7MLy1f7vKDKkf1uj+Z16ebOq2/5w2+3RyYvz3VfXenofvW112giSvpK0KsBqTiTGPma4aLcn6sqpqsaWfVusdwGOq6gPdkKMnAp9lwbJ+683grL/l8h8NzWU06c673MDuvJnzOKUtK/SnwJWSTE8V3pXh49ZWa03Wo+yaxo+nfZjvR5spuZpuhotMPpjVcho9K8nHaAHbStbqLHK6a3Kib7C8X5Iz6Abzd//Dlin/2j4eRkuN8m+09/sn2fKDtC66GXD709akvC+tq/3wda7DNieuVfXN9azDLKa6ZfftekseALyLLvUDbSzyejiOZZYnG1pYVb2bVfQ00L7vJmWck8FLcp53bN9hQPN2QHXJb7uThxdkhTxq68HgrL/HAG9N8jAWyX80pKAZuvM+m+SRtXgepxOWOGahU2mLHt91wTFn0sawzd3kQ5kl1qNc6fi09e0OYUtLxBu7cgct/jvlN103xbe6cRA/oE326GOms8i1CJYvSIP5L0iqJYUekgxzzSzxGckMn5GN7DO0iTk7dxPD7k5L/fD71QYmq3Q3Fl+e7CzaieSQtTVvRpusch3a0IodaUu89ekO3G/BCeBFpk4Oe3cpJrkorZVqr2p5K/ehLaH0zr6PYxaTiVRdwL3VRCpa78l2HatrKo2Bsgb5j7pyBi+0mrXN47Tz0EGcay2rXI8yyR9oZ48Pr6qTum3fHjhGbLq8m9BaPy9Jm6CxG22a+Ypd1ZkxJ1jaGpr7A88BnjG160zgQzVgjTiNSxcgvQK4XFVdL8kNgLtW1XPX4b7X9DOykXXjj26Ylvrhb4AvMkPqhxnqMfPyZFO330wL3t9E+w15MHCNqvq7Nalsvzq8kfY79uDu83ER4FM1YBmqGe9/1LkdDc62g8y40GrWII/TGg2Cn0lWuR5lknvQvlhuQVtW6A3Af22PZvJsyQ8GW+cIG3oWud2DZa2tJB8B/h/wH7XK9VJnuO/RfEbO75KcQlu9A7aMRS3auLmqqhesUz1OqqprDN23xO0nuTLPW0MyySdrfZOQT+rw+VpFnss1uP/p+z3v/8Wubw92a24f96BbaBWgqk5NW+Oyl1qbPE6rHgS/hla1HmVVHQscm5ZH7O607tjLpaU0Obaq3tfnzlcaV9BngO0adinunWS7Bstacxetqs8s6Ppal3Gda/UZEdC6/C7O4t+P69m6sRbDWiZ+nZYh4MQk/0yb+bnea0r+rmstm0yMuzpTExzWwagnUtlyth2ky+afLRnyL0Zrzl1xTbE1rMMJVXXj6ebwJB9bryb6tdbNAL0PcL/quT5c1nB9tlkl+ThbguW70AXLVdVnUoJGKG1ZsMfSWsVvlOTetG7GIWl31rI+gz8jGkcXV1ePtRzWchXaTPmdaYH7bsDLJ13g6yHJnwB/RzshfR8tWfNDqurD63T/o14VxeBsO8jiC62+vgYuOzFjHT4B3Ap4M/BB2iD4f6yqa63DfU+mhC+qT4vVGtVjTddnm7EuF6hgWZDkasARtK7Fn9NmSj6g2oxgnU+MoYtr2loMaxmLJJcBbkYLiI6vqtO3c5VGw+BsO8l2Xmh1lkHwa3Dft15u/3q2WE1kxvXZ1uD+t1uwrPnqWsZ3qKozkzyhqv59e9dJ/WVY7sVRS8ttttyJ8Xr23rwZOBJ4T1UNWbZvQzA4286S7A78tDboC9GNe7hmd/Ub6z0oPtuuz3YccGRVDc4bNGM9tluwrPWT5PtVtdf2roc2pq47c0nr2aqb5La04Rs3o80aPbqqvr5e9z92BmfrqMst84/Az2g/wK+hLa+yA2068XvWoQ4zD4Jfw7ocREvi+l1aC+KewJ9V1UfX6f6n12d7Q82wPpvUR5KTq2rP7V0PaWJ7NxAk2Y12cvx3tDHA/0lLUbKhZ68bnK2jLrfMU2mtIkcAd6yq45NcmzbWae7jGkY2CP4E4P5V9Y3u+jVpz8ONlz9yze7/D2xJgzH9QRi8PtsMdRhNsKz5s+VM29MYGggW1OcytHUyH0hLkP462hJj16+qg9azLmNjKo31tdNkCnuS50y6rKrq61m/TNOXZ8sg+PuzHQfBAztPAjNoS7qkZeBeF7W267Ot1s1ZJljW+U+SM1l8XM9kVpi0vbyULQ0EH2RBAwEtJ966SPJW4Nq0APEuwNWBQ6vqMV1DxoZmcLa+pgc9nr1g37o0YVbVubQP4HumBsF/uAsW13UQPLA5bcmj13TXH8jwfD3nd2MKlrUGqqp3zkJpnY2hgWDipcAvaMmSP0WbzfyWrj7LrhKzERicra9RLFC9yCD4FwNvXa/7n/LntDVLH0d7Dj4KvHw71GO7GVmwLOmCbbs3EMR1X3txzNkGM4ZB8EnuBly5ql7WXf8MsAfty+HJVfXm9a7T9jSWGaOSLtjGkHg1rvvai8HZBjOSQfCfAA6pqpO76ycCt6EtkXJUVf3xvOswFmMIliVpvbjuaz8GZ1p3ST5bVTeZuv7Sqnps9//xVXWz7Ve79TWGYFmS1tvUuq+H0k7OX4Xrvp7H4EzrLslJVXWNJfb9X1Vdfb3rJEnaPlz3dVtjSCWgjefTSR65cGOSRwGf2Q71kSRtJ1X1s6r6DwOzLWw507pLclngbcBvgc91m28MXBi4e1X9eDtVTZKk7c7gTNtNktsA1+2ufqWqPrg96yNJ0hgYnEmSJI2IY84kSZJGxOBMkiRpRAzOJJ3vJblykrcn+VaS/0vyoiQXmvN9PiTJFed5H5I2JoMzSedraSs2vxV4W1XtA1yTttrE89ag7B2X2f0QYFBwtkJ5kgS48Lmk87/bAL+pqqOgLSaf5K+A7yT5DnB7WpqWqwKvr6pnAyR5IPB44ELAp4G/6I79FfDC7rgndbOK70Jbi/CTwKOAewGbgNclORu4OW05mn+lfa9+Fvjzqvptku8CRwJ/Ary0SyXzaOAc4KtVdchcnx1J5zu2nEk6v7sucML0hqo6A/g+LVA6AHgAsD9wnySbklwHuB9wy6raHzi3uw3AxYAvV9VNq+rjwEur6iZVdT1agHbnqnozsBl4QHd8AUfTMpxfv7vfP5+q0m+q6sCqegPwFOCGVXUDWpAmSVsxOJN0fhe2Xpd04fb3V9VPq+psWvfngcAf0xIffzbJid31q3XHnQu8Zaqcg5N8OsmXaK1012Vb1wK+U1Xf7K6/Cvijqf1vnPr/i7QWtwfSWs8kaSt2a0o6v/sKrZvxPEl2BfakBVoLA7eiBW6vqqq/XaS831TVuV05uwAvBzZV1clJngXsssgxWaGOZ039fyda4HZX4OlJrltVBmmSzmPLmaTzuw8AF03yYDhv0P0LaN2MvwZul+TSSS4C3B34RHfMvbvxX3T7r7JI2ZNA7PQkFwfuPbXvTOAS3f9fB/ZOco3u+oOAjywsLMkOwJ5V9SHgycAlaZMXJOk8BmeSzteqLXNyD9p4sm8B3wR+Azy1u8nHgdcAJwJvqarNVfVV4GnA+5J8EXg/cIVFyv4F8J/Al2jrwX52avfRwOFdt2iAhwJv6ro//wAcvkh1dwRe293m88C/dfchSedx+SZJF1hJHkLrknzs9q6LJPVly5kkSdKI2HImSZI0IracSZIkjYjBmSRJ0ogYnEmSJI2IwZkkSdKIGJxJkiSNyP8HiRzvByoxDDEAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 720x720 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "items = shouldYouPull(20300, \"Joint Operation 7\")\n",
    "counts = {}\n",
    "\n",
    "for item in items:\n",
    "    if item in counts:\n",
    "        counts[item] += 1\n",
    "    else:\n",
    "        counts[item] = 1\n",
    "        \n",
    "operatornames = list(counts.keys())\n",
    "pullvalues = list(counts.values())\n",
    "\n",
    "\n",
    "plt.bar(range(len(counts)), pullvalues, tick_label=operatornames, color ='cyan', width = 0.4, edgecolor='black')\n",
    "\n",
    " \n",
    "plt.xlabel(\"Operators\")\n",
    "plt.ylabel(\"# of times Operators were obtained\")\n",
    "plt.title(\"Amount of operators occurances per pull\")\n",
    "plt.xticks(rotation=90)\n",
    "plt.rcParams[\"figure.figsize\"] = (10,10)\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a5498881",
   "metadata": {},
   "source": [
    "---\n",
    "## Answering our Central Question:\n",
    "\n",
    "All in all based on the functions we have created and even the bar plots shown above, we can confidently say that some characters are better than other based on their stats and the investment cost of the user to obtain a 6-star is immense as proven within our **ShouldYouPull** function, it takes quite a while just to obtain a top notch operator from the specified banner.\n",
    "\n",
    "By doing this we can finally let the player know that if they really want a specific character they should start to save up their in-game currency and save it up for an operator they enjoy"
   ]
  }
 ],
 "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.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}