Data Plots.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "d3742a29",
   "metadata": {},
   "source": [
    "# Data Plots"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "id": "77cd3014",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Game ID</th>\n",
       "      <th>Player 1</th>\n",
       "      <th>Player 2</th>\n",
       "      <th>Player 1 Type</th>\n",
       "      <th>Player 2 Type</th>\n",
       "      <th>Winner</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Bot 1</td>\n",
       "      <td>Bot 2</td>\n",
       "      <td>Bot</td>\n",
       "      <td>Bot</td>\n",
       "      <td>Bot 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Bot 1</td>\n",
       "      <td>Bot 2</td>\n",
       "      <td>Bot</td>\n",
       "      <td>Bot</td>\n",
       "      <td>Bot 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Harry</td>\n",
       "      <td>Bot 2</td>\n",
       "      <td>Human</td>\n",
       "      <td>Bot</td>\n",
       "      <td>Harry</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Harry</td>\n",
       "      <td>Jason</td>\n",
       "      <td>Human</td>\n",
       "      <td>Human</td>\n",
       "      <td>Harry</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Jack</td>\n",
       "      <td>Jason</td>\n",
       "      <td>Human</td>\n",
       "      <td>Human</td>\n",
       "      <td>Jack</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>Jason</td>\n",
       "      <td>Jack</td>\n",
       "      <td>Human</td>\n",
       "      <td>Human</td>\n",
       "      <td>Jack</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>Jason</td>\n",
       "      <td>Bot 2</td>\n",
       "      <td>Human</td>\n",
       "      <td>Bot</td>\n",
       "      <td>Jason</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>Jack</td>\n",
       "      <td>Bot 2</td>\n",
       "      <td>Human</td>\n",
       "      <td>Bot</td>\n",
       "      <td>Bot 2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>Bot 1</td>\n",
       "      <td>Bot 2</td>\n",
       "      <td>Bot</td>\n",
       "      <td>Bot</td>\n",
       "      <td>Bot 1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>Jack</td>\n",
       "      <td>Harry</td>\n",
       "      <td>Human</td>\n",
       "      <td>Human</td>\n",
       "      <td>Harry</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>Jason</td>\n",
       "      <td>Jack</td>\n",
       "      <td>Human</td>\n",
       "      <td>Human</td>\n",
       "      <td>Jason</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>Jones</td>\n",
       "      <td>Jason</td>\n",
       "      <td>Human</td>\n",
       "      <td>Human</td>\n",
       "      <td>Draw</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>Jason</td>\n",
       "      <td>Bot 2</td>\n",
       "      <td>Human</td>\n",
       "      <td>Bot</td>\n",
       "      <td>Bot 2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>Jack</td>\n",
       "      <td>Bot 2</td>\n",
       "      <td>Human</td>\n",
       "      <td>Bot</td>\n",
       "      <td>Bot 2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Game ID Player 1 Player 2 Player 1 Type Player 2 Type Winner\n",
       "0         1    Bot 1    Bot 2           Bot           Bot  Bot 1\n",
       "1         2    Bot 1    Bot 2           Bot           Bot  Bot 1\n",
       "2         3    Harry    Bot 2         Human           Bot  Harry\n",
       "3         4    Harry    Jason         Human         Human  Harry\n",
       "4         5     Jack    Jason         Human         Human   Jack\n",
       "5         6    Jason     Jack         Human         Human   Jack\n",
       "6         7    Jason    Bot 2         Human           Bot  Jason\n",
       "7         8     Jack    Bot 2         Human           Bot  Bot 2\n",
       "8         9    Bot 1    Bot 2           Bot           Bot  Bot 1\n",
       "9        10     Jack    Harry         Human         Human  Harry\n",
       "10       11    Jason     Jack         Human         Human  Jason\n",
       "11       12    Jones    Jason         Human         Human   Draw\n",
       "12       13    Jason    Bot 2         Human           Bot  Bot 2\n",
       "13       14     Jack    Bot 2         Human           Bot  Bot 2"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "filename = 'GameSave.csv'\n",
    "\n",
    "try:\n",
    "    games = pd.read_csv(filename, index_col=0)\n",
    "except FileNotFoundError:\n",
    "    games = pd.DataFrame(columns=[\n",
    "        \"Game ID\",\n",
    "        \"Player 1\",\n",
    "        \"Player 2\",\n",
    "        \"Player 1 Type\",\n",
    "        \"Player 2 Type\",\n",
    "        \"Winner\",\n",
    "])\n",
    "\n",
    "games"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "110b30ae",
   "metadata": {},
   "source": [
    "## Plot 1: Win Rate for Bots\n",
    "\n",
    "From the graph, we can see that the winning rate for Bot 1 is significantly higher than Bot 2."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "id": "580a5ba3",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "  Player  Win Rate\n",
      "0  Bot 1  0.500000\n",
      "1  Bot 2  0.272727\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXQAAAD1CAYAAABA+A6aAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/YYfK9AAAACXBIWXMAAAsTAAALEwEAmpwYAAAPZ0lEQVR4nO3df4zX9X3A8efLQ0rjGItA1spJwZaGUorQnghHk42mBrWr2MxktMuqU0P4gxn7Iy21wT/aLNHENESlI2QhZP8M27K1V3ubTU0W1xyNnOvNiki9OMUvOAtMsO1UDnztjzvZt9fvcZ+7+x5f7+3zkZB8P5/P+/v9viDnk48fPve9yEwkSVPfRa0eQJLUHAZdkgph0CWpEAZdkgph0CWpEAZdkgoxrVVvPGfOnFywYEGr3l6SpqQnnnjieGbObXSsZUFfsGABvb29rXp7SZqSIuKFkY55yUWSCmHQJakQBl2SCtGya+iSyjYwMECtVuP1119v9ShT0owZM2hvb+fiiy+u/ByDLmlS1Go1Zs6cyYIFC4iIVo8zpWQmJ06coFarsXDhwsrPq3TJJSKujYhDEdEfEVsaHP/TiDgVEX1Dv+4ew+ySCvT6668ze/ZsYz4OEcHs2bPH/H83o56hR0QbsB24BqgB+yOiKzOfHrb03zPzz8b07pKKZszHbzx/dlXO0FcC/Zn5XGaeBvYA68f8TpJ0AX3hC19g27Zt57bXrVvH7bfffm77S1/6Et/61rfo6urinnvuGdNrt7W1sXz5cpYuXcqnP/1pTp48ed71fX19dHd3j+k9xqPKNfR5wIt12zXg6gbrVkfEfwJHgS9n5oHhCyJiI7ARYP78+WOftgUWbPlRq0coyvP3fKrVI6hFmv3f0mhfS52dnXz3u9/lzjvv5M033+T48eO8+uqr54739PSwbds2rr76am644YYxvfe73/1u+vr6ALj55pvZvn07X//610dc39fXR29vL9dff/2Y3mesqpyhNzrvH/5jjv4DeF9mXgk8AHy/0Qtl5s7M7MjMjrlzG37nqiQ1xZo1a+jp6QHgwIEDLF26lJkzZ/LKK6/wxhtvcPDgQVasWMHu3bvZvHkzALfccgt33HEHnZ2dXHHFFXzve98b9X1Wr17NkSNHAHj88cfp7OxkxYoVdHZ2cujQIU6fPs3dd9/NQw89xPLly3nooYf47W9/y6233spVV13FihUr+MEPftCU33OVM/QacHnddjuDZ+HnZOardY+7I+LbETEnM483ZUpJGqPLLruMadOmcfjwYXp6es6Fd9++fcyaNYtly5Yxffr033veSy+9xE9/+lOeeeYZbrjhBm666aYR3+Ps2bM8+uij3HbbbQAsXryYxx57jGnTpvGTn/yEu+66i7179/KNb3yD3t5eHnzwQQDuuusuPvGJT7Br1y5OnjzJypUr+eQnP8kll1wyod9zlaDvBxZFxELgCLAB+Fz9goh4D/ByZmZErGTwzP/EhCaTpAl66yy9p6eHL37xixw5coSenh5mzZpFZ2dnw+fceOONXHTRRSxZsoSXX3654ZrXXnuN5cuX8/zzz/Oxj32Ma665BoBTp05x88038+yzzxIRDAwMNHz+j3/8Y7q6urjvvvuAwTuCDh8+zIc+9KEJ/X5HveSSmWeAzcAjwEHgO5l5ICI2RcSmoWU3AU8NXUO/H9iQ/vRpSS3W2dlJT08Pv/jFL1i6dCmrVq1i37599PT0sGbNmobPede73nXu8UgZe+sa+gsvvMDp06fZvn07AFu3bmXt2rU89dRT/PCHPxzxtsPMZO/evfT19dHX19eUmEPF+9AzszszP5iZ78/Mvx3atyMzdww9fjAzP5yZV2bmqszsmfBkkjRBa9as4eGHH+bSSy+lra2NSy+9lJMnT7Jv3z5Wr1494defNWsW999/P/fddx8DAwOcOnWKefPmAbB79+5z62bOnMmvf/3rc9vr1q3jgQceOPcXxs9//vMJzwJ+loukgn3kIx/h+PHjrFq16nf2zZo1izlz5jTlPVasWMGVV17Jnj17+MpXvsLXvvY11qxZw9mzZ8+tWbt2LU8//fS5fxTdunUrAwMDLFu2jKVLl7J169amzBKtujLS0dGRU+Hz0L1tsbm8bfGd4+DBg025jPBO1ujPMCKeyMyORus9Q5ekQhh0SSqEQZekQhh0SZPGu5fHbzx/dgZd0qSYMWMGJ06cMOrj8Nbnoc+YMWNMz/MHXEiaFO3t7dRqNY4dO9bqUaakt35i0VgYdEmT4uKLLx7TT9vRxHnJRZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKUSnoEXFtRByKiP6I2HKedVdFxNmIuKl5I0qSqhg16BHRBmwHrgOWAJ+NiCUjrLsXeKTZQ0qSRlflDH0l0J+Zz2XmaWAPsL7Bur8B9gK/auJ8kqSKqgR9HvBi3XZtaN85ETEP+Aywo3mjSZLGokrQo8G+HLa9DfhqZp497wtFbIyI3ojoPXbsWMURJUlVTKuwpgZcXrfdDhwdtqYD2BMRAHOA6yPiTGZ+v35RZu4EdgJ0dHQM/0tBkjQBVYK+H1gUEQuBI8AG4HP1CzJz4VuPI2I38PDwmEuSJteoQc/MMxGxmcG7V9qAXZl5ICI2DR33urkkvQ1UOUMnM7uB7mH7GoY8M2+Z+FiSpLHyO0UlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKYdAlqRAGXZIKUSnoEXFtRByKiP6I2NLg+PqIeDIi+iKiNyI+3vxRJUnnM220BRHRBmwHrgFqwP6I6MrMp+uWPQp0ZWZGxDLgO8DiyRhYktRYlTP0lUB/Zj6XmaeBPcD6+gWZ+ZvMzKHNS4BEknRBVQn6PODFuu3a0L7fERGfiYhngB8BtzZnPElSVVWCHg32/d4ZeGb+c2YuBm4EvtnwhSI2Dl1j7z127NiYBpUknV+VoNeAy+u224GjIy3OzMeA90fEnAbHdmZmR2Z2zJ07d8zDSpJGViXo+4FFEbEwIqYDG4Cu+gUR8YGIiKHHHwWmAyeaPawkaWSj3uWSmWciYjPwCNAG7MrMAxGxaej4DuDPgc9HxADwGvAXdf9IKkm6AEYNOkBmdgPdw/btqHt8L3Bvc0eTJI2F3ykqSYUw6JJUCIMuSYUw6JJUCIMuSYUw6JJUiEq3LUp6+1mw5UetHqEoz9/zqVaPMGGeoUtSIQy6JBXCoEtSIQy6JBXCoEtSIQy6JBXCoEtSIQy6JBXCoEtSIQy6JBXCoEtSIQy6JBXCoEtSIQy6JBXCoEtSIQy6JBXCoEtSIQy6JBXCoEtSIQy6JBXCoEtSIQy6JBXCoEtSIQy6JBXCoEtSIQy6JBWiUtAj4tqIOBQR/RGxpcHxv4yIJ4d+9UTElc0fVZJ0PqMGPSLagO3AdcAS4LMRsWTYsv8C/iQzlwHfBHY2e1BJ0vlVOUNfCfRn5nOZeRrYA6yvX5CZPZn5ytDmz4D25o4pSRpNlaDPA16s264N7RvJbcC/TGQoSdLYTauwJhrsy4YLI9YyGPSPj3B8I7ARYP78+RVHlCRVUeUMvQZcXrfdDhwdvigilgF/D6zPzBONXigzd2ZmR2Z2zJ07dzzzSpJGUCXo+4FFEbEwIqYDG4Cu+gURMR/4J+CvMvOXzR9TkjSaUS+5ZOaZiNgMPAK0Absy80BEbBo6vgO4G5gNfDsiAM5kZsfkjS1JGq7KNXQysxvoHrZvR93j24HbmzuaJGks/E5RSSqEQZekQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQlQKekRcGxGHIqI/IrY0OL44IvZFxBsR8eXmjylJGs200RZERBuwHbgGqAH7I6IrM5+uW/Y/wB3AjZMxpCRpdFXO0FcC/Zn5XGaeBvYA6+sXZOavMnM/MDAJM0qSKqgS9HnAi3XbtaF9kqS3kSpBjwb7cjxvFhEbI6I3InqPHTs2npeQJI2gStBrwOV12+3A0fG8WWbuzMyOzOyYO3fueF5CkjSCKkHfDyyKiIURMR3YAHRN7liSpLEa9S6XzDwTEZuBR4A2YFdmHoiITUPHd0TEe4Be4A+BNyPiTmBJZr46eaNLkuqNGnSAzOwGuoft21H3+L8ZvBQjSWoRv1NUkgph0CWpEAZdkgph0CWpEAZdkgph0CWpEAZdkgph0CWpEAZdkgph0CWpEAZdkgph0CWpEAZdkgph0CWpEAZdkgph0CWpEAZdkgph0CWpEAZdkgph0CWpEAZdkgph0CWpEAZdkgph0CWpEAZdkgph0CWpEAZdkgph0CWpEAZdkgph0CWpEAZdkgph0CWpEAZdkgpRKegRcW1EHIqI/ojY0uB4RMT9Q8efjIiPNn9USdL5jBr0iGgDtgPXAUuAz0bEkmHLrgMWDf3aCPxdk+eUJI2iyhn6SqA/M5/LzNPAHmD9sDXrgX/IQT8D/igi3tvkWSVJ5zGtwpp5wIt12zXg6gpr5gEv1S+KiI0MnsED/CYiDo1pWp3PHOB4q4cYTdzb6gnUAn5tNtf7RjpQJejRYF+OYw2ZuRPYWeE9NUYR0ZuZHa2eQxrOr80Lp8ollxpwed12O3B0HGskSZOoStD3A4siYmFETAc2AF3D1nQBnx+622UVcCozXxr+QpKkyTPqJZfMPBMRm4FHgDZgV2YeiIhNQ8d3AN3A9UA/8L/AX0/eyBqBl7L0duXX5gUSmb93qVuSNAX5naKSVAiDLkmFMOiSVIgq96HrbSgiFjP4HbrzGLzn/yjQlZkHWzqYpJbxDH0KioivMvgRDAE8zuCtpQH8Y6MPT5PeDiLCu98mmXe5TEER8Uvgw5k5MGz/dOBAZi5qzWTSyCLicGbOb/UcJfOSy9T0JnAZ8MKw/e8dOia1REQ8OdIh4I8v5CzvRAZ9aroTeDQinuX/PxRtPvABYHOrhpIYjPY64JVh+wPoufDjvLMY9CkoM/81Ij7I4Ecbz2PwP5YasD8zz7Z0OL3TPQz8QWb2DT8QEf92wad5h/EauiQVwrtcJKkQBl2SCmHQJakQBl2SCmHQJakQ/wc1PhHadF16wQAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "check_bot = games[['Player 1', 'Player 2', 'Winner']]\n",
    "check_bot_1 = check_bot.loc[(check_bot['Player 1'] == 'Bot 1') | (check_bot['Player 2'] == 'Bot 1')]\n",
    "check_bot_2 = check_bot.loc[(check_bot['Player 1'] == 'Bot 2') | (check_bot['Player 2'] == 'Bot 2')]\n",
    "\n",
    "check_bot_1 = check_bot_1.replace('Bot 1', 1)\n",
    "check_bot_1 = check_bot_1.replace('Bot 2', 2)\n",
    "check_bot_2 = check_bot_2.replace('Bot 1', 1)\n",
    "check_bot_2 = check_bot_2.replace('Bot 2', 2)\n",
    "\n",
    "check_bot_1_winner = check_bot_1[check_bot_1['Winner'] == 1]\n",
    "check_bot_2_winner = check_bot_2[check_bot_2['Winner'] == 2]\n",
    "\n",
    "check_bot_1_winner_rate = len(check_bot_1_winner) / (len(check_bot_1) + len(check_bot_1_winner))\n",
    "check_bot_2_winner_rate = len(check_bot_2_winner) / (len(check_bot_2) + len(check_bot_2_winner))\n",
    "\n",
    "check_bot_rate = pd.DataFrame(columns=[\n",
    "    'Player',\n",
    "    'Win Rate',\n",
    "])\n",
    "\n",
    "check_bot_rate.loc[len(check_bot_rate)] = {\n",
    "    'Player': 'Bot 1',\n",
    "    'Win Rate': check_bot_1_winner_rate,\n",
    "}\n",
    "\n",
    "check_bot_rate.loc[len(check_bot_rate)] = {\n",
    "    'Player': 'Bot 2',\n",
    "    'Win Rate': check_bot_2_winner_rate,\n",
    "}\n",
    "\n",
    "print(check_bot_rate)\n",
    "\n",
    "check_bot_rate.plot(kind='bar')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8801b307",
   "metadata": {},
   "source": [
    "## Plot 2: Number of Wins and Draws\n",
    "The graph shows the number of wins (game that has a winner) and number of draws."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "id": "0fbde431",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "  Result  Numbers\n",
      "0    Win       13\n",
      "1  Draws        1\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXAAAAD1CAYAAABJE67gAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/YYfK9AAAACXBIWXMAAAsTAAALEwEAmpwYAAANs0lEQVR4nO3db5BVhXnH8d9vWWSLf0iAW0ck6YIBauqicRZs61iG0KgtmdAXGUYtVdPgvjFt6CAC0xdxfGWmTv2DHZQJNmHKGEek6ug0VWwxdpqKuwQjZo0IbswWqxvasS0dBOTpi103yxV3795z3OuzfD8zDHvPPfec5+4sX86ePfeuI0IAgHyaGj0AAKA+BBwAkiLgAJAUAQeApAg4ACRFwAEgqeax3Nn06dOjtbV1LHcJAOl1dXX9MiIq1cvHNOCtra3q7Owcy10CQHq2f36q5ZxCAYCkCDgAJEXAASCpMT0HDmB8O3bsmHp7e3XkyJFGj5JSS0uLZs6cqYkTJ9a0PgEHUJre3l6dffbZam1tle1Gj5NKROjQoUPq7e3VrFmzanoMp1AAlObIkSOaNm0a8a6DbU2bNm1U370QcAClIt71G+3njoADGDdsa/Xq1YO377zzTt12222lbPvGG2/Utm3bStlWWTgHfgqt655q9AjjSs8dSxs9Ahqk7H9LI30tTZo0Sdu3b9f69es1ffr0UvddxPvvv68JEyaUvl2OwAGMG83Nzero6NBdd931ofuqj6DPOussSdLOnTu1aNEiLV++XHPnztW6deu0detWLVy4UG1tbdq/f//gY3bs2KErrrhCc+fO1ZNPPimpP85r1qzRggULNH/+fD3wwAOD2128eLGuu+46tbW16fDhw1q6dKkuvvhiXXTRRXr44YeLP9/CWwCAT5Cbb75Z8+fP16233lrzY1566SV1d3dr6tSpmj17tlauXKldu3bpnnvu0YYNG3T33XdLknp6evTcc89p//79Wrx4sV5//XVt2bJFU6ZM0Ysvvqj33ntPl19+ua688kpJ0q5du7R3717NmjVLjz76qGbMmKGnnur/ruTdd98t/Fw5Agcwrpxzzjm6/vrrde+999b8mAULFui8887TpEmTdMEFFwwGuK2tTT09PYPrLV++XE1NTZozZ45mz56tV199VU8//bS2bNmiSy65RJdddpkOHTqkffv2SZIWLlw4eElgW1ubduzYobVr1+r555/XlClTCj9XAg5g3Fm1apU2b96sw4cPDy5rbm7WiRMnJPVfc3306NHB+yZNmjT4cVNT0+DtpqYmHT9+fPC+6qtEbCsitGHDBu3Zs0d79uzRG2+8MfgfwJlnnjm47ty5c9XV1aW2tjatX79et99+e+HnScABjDtTp07V8uXLtXnz5sFlra2t6urqkiQ9/vjjOnbs2Ki3+8gjj+jEiRPav3+/Dhw4oHnz5umqq67Sxo0bB7f32muvnfQfxwcOHjyoyZMna8WKFbrlllu0e/fuOp/dr3AOHMC4tHr1at13332Dt2+66SYtW7ZMCxcu1JIlS046Oq7VvHnztGjRIr399tu6//771dLSopUrV6qnp0eXXnqpIkKVSkWPPfbYhx778ssva82aNWpqatLEiRO1cePGIk9PkuSIKLyRWrW3t0eG9wPnMsJycRnh6aO7u1sXXnhho8dI7VSfQ9tdEdFevS6nUAAgKQIOAEkRcABIioADKNVY/lxtvBnt527EgNt+0PY7tvcOWfZXtl+1/RPbf2/7U6MfFcB409LSokOHDhHxOnzwfuAtLS01P6aWywi/K+k+SVuGLHtG0vqIOG7725LWS1o7ilkBjEMzZ85Ub2+v+vr6Gj1KSh/8Rp5ajRjwiPih7daqZU8Puflvkr5a8x4BjFsTJ06s+bfJoLgyzoH/qaR/KGE7AIBRKBRw238p6bikrcOs02G703Yn31YBQHnqDrjtGyR9WdIfxzA/sYiITRHRHhHtlUql3t0BAKrU9V4otq9W/w8tF0XE/5U7EgCgFrVcRviQpB9Jmme71/bX1X9VytmSnrG9x/b9H/OcAIAqtVyFcu0pFm8+xTIAwBjilZgAkBQBB4CkCDgAJEXAASApAg4ASRFwAEiKgANAUgQcAJIi4ACQFAEHgKQIOAAkRcABICkCDgBJEXAASIqAA0BSBBwAkiLgAJAUAQeApAg4ACRFwAEgKQIOAEkRcABIioADQFIjBtz2g7bfsb13yLKptp+xvW/g709/vGMCAKrVcgT+XUlXVy1bJ+nZiJgj6dmB2wCAMTRiwCPih5L+s2rxMknfG/j4e5L+qNyxAAAjqfcc+LkR8ZYkDfz96+WNBACoxcf+Q0zbHbY7bXf29fV93LsDgNNGvQF/2/Z5kjTw9zsftWJEbIqI9ohor1Qqde4OAFCt3oA/IemGgY9vkPR4OeMAAGpVy2WED0n6kaR5tnttf13SHZK+ZHufpC8N3AYAjKHmkVaIiGs/4q4lJc8CABgFXokJAEkRcABIioADQFIEHACSIuAAkBQBB4CkCDgAJEXAASApAg4ASRFwAEiKgANAUgQcAJIi4ACQFAEHgKQIOAAkRcABICkCDgBJEXAASIqAA0BSBBwAkiLgAJAUAQeApAg4ACRVKOC2/8L2K7b32n7IdktZgwEAhld3wG2fL+nPJbVHxEWSJki6pqzBAADDK3oKpVnSr9luljRZ0sHiIwEAalF3wCPi3yXdKelNSW9Jejcini5rMADA8IqcQvm0pGWSZkmaIelM2ytOsV6H7U7bnX19ffVPCgA4SZFTKL8v6Y2I6IuIY5K2S/rd6pUiYlNEtEdEe6VSKbA7AMBQRQL+pqTftj3ZtiUtkdRdzlgAgJEUOQf+gqRtknZLenlgW5tKmgsAMILmIg+OiG9J+lZJswAARoFXYgJAUgQcAJIi4ACQFAEHgKQIOAAkRcABICkCDgBJEXAASIqAA0BSBBwAkiLgAJAUAQeApAg4ACRFwAEgKQIOAEkRcABIioADQFIEHACSIuAAkBQBB4CkCDgAJEXAASApAg4ASRUKuO1P2d5m+1Xb3bZ/p6zBAADDay74+Hsk/SAivmr7DEmTS5gJAFCDugNu+xxJvyfpRkmKiKOSjpYzFgBgJEVOocyW1Cfpb23/2PZ3bJ9Z0lwAgBEUCXizpEslbYyIL0g6LGld9Uq2O2x32u7s6+srsDsAwFBFAt4rqTciXhi4vU39QT9JRGyKiPaIaK9UKgV2BwAYqu6AR8R/SPqF7XkDi5ZI+mkpUwEARlT0KpQ/k7R14AqUA5K+VnwkAEAtCgU8IvZIai9nFADAaPBKTABIioADQFIEHACSIuAAkBQBB4CkCDgAJEXAASApAg4ASRFwAEiKgANAUgQcAJIi4ACQFAEHgKQIOAAkRcABICkCDgBJEXAASIqAA0BSBBwAkiLgAJAUAQeApAg4ACRFwAEgqcIBtz3B9o9tP1nGQACA2pRxBP5NSd0lbAcAMAqFAm57pqSlkr5TzjgAgFoVPQK/W9Ktkk4UHwUAMBp1B9z2lyW9ExFdI6zXYbvTdmdfX1+9uwMAVClyBH65pK/Y7pH0fUlftP131StFxKaIaI+I9kqlUmB3AICh6g54RKyPiJkR0SrpGkn/FBErSpsMADAsrgMHgKSay9hIROyUtLOMbQEAasMROAAkRcABICkCDgBJEXAASIqAA0BSBBwAkiLgAJAUAQeApAg4ACRFwAEgKQIOAEkRcABIioADQFIEHACSIuAAkBQBB4CkCDgAJEXAASApAg4ASRFwAEiKgANAUgQcAJIi4ACQVN0Bt/0Z2/9su9v2K7a/WeZgAIDhNRd47HFJqyNit+2zJXXZfiYiflrSbACAYdR9BB4Rb0XE7oGP/0dSt6TzyxoMADC8Us6B226V9AVJL5SxPQDAyAoH3PZZkh6VtCoi/vsU93fY7rTd2dfXV3R3AIABhQJue6L64701Irafap2I2BQR7RHRXqlUiuwOADBEkatQLGmzpO6I+OvyRgIA1KLIEfjlkv5E0hdt7xn484clzQUAGEHdlxFGxL9IcomzAABGgVdiAkBSBBwAkiLgAJAUAQeApAg4ACRFwAEgKQIOAEkRcABIioADQFIEHACSKvIbeQCMsdZ1TzV6hHGl546ljR6hEI7AASApAg4ASRFwAEiKgANAUgQcAJIi4ACQFAEHgKQIOAAkRcABICkCDgBJEXAASIqAA0BShQJu+2rbP7P9uu11ZQ0FABhZ3QG3PUHS30j6A0mfl3St7c+XNRgAYHhFjsAXSno9Ig5ExFFJ35e0rJyxAAAjKfJ+4OdL+sWQ272SLqteyXaHpI6Bm/9r+2cF9omTTZf0y0YPMRJ/u9EToAH42izXb5xqYZGA+xTL4kMLIjZJ2lRgP/gItjsjor3RcwDV+NocG0VOofRK+syQ2zMlHSw2DgCgVkUC/qKkObZn2T5D0jWSnihnLADASOo+hRIRx21/Q9I/Spog6cGIeKW0yVALTk3hk4qvzTHgiA+dtgYAJMArMQEgKQIOAEkRcABIqsh14BhDtn9T/a90PV/919sflPRERHQ3dDAADcMReAK216r/rQosaZf6L+G0pId4EzF8ktn+WqNnGM+4CiUB269J+q2IOFa1/AxJr0TEnMZMBgzP9psR8dlGzzFecQolhxOSZkj6edXy8wbuAxrG9k8+6i5J547lLKcbAp7DKknP2t6nX72B2GclfU7SNxo1FDDgXElXSfqvquWW9K9jP87pg4AnEBE/sD1X/W/he776/2H0SnoxIt5v6HCA9KSksyJiT/UdtneO+TSnEc6BA0BSXIUCAEkRcABIioADQFIEHACSIuAAkNT/AytCE2VH4fQJAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "win_or_draw = pd.DataFrame(columns=[\n",
    "    'Result',\n",
    "    'Numbers',\n",
    "])\n",
    "\n",
    "number_wins = len(games[games['Winner'] != 'Draw'])\n",
    "number_draws = len(games[games['Winner'] == 'Draw'])\n",
    "\n",
    "win_or_draw.loc[len(win_or_draw)] = {\n",
    "    'Result': 'Win',\n",
    "    'Numbers': number_wins,\n",
    "}\n",
    "\n",
    "win_or_draw.loc[len(win_or_draw)] = {\n",
    "    'Result': 'Draws',\n",
    "    'Numbers': number_draws,\n",
    "}\n",
    "\n",
    "print(win_or_draw)\n",
    "\n",
    "win_or_draw.plot(kind='bar')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "eb05568b",
   "metadata": {},
   "source": [
    "## Plot 3: Win rate for Human against Bots\n",
    "The graphs shows the win rate for each human against bots"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "b877f5f2",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "  Player  Win Rate\n",
      "0  Harry       1.0\n",
      "1  Jason       0.5\n",
      "2   Jack       0.0\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:>"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXQAAAD1CAYAAABA+A6aAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/YYfK9AAAACXBIWXMAAAsTAAALEwEAmpwYAAAP/klEQVR4nO3db5BV9XnA8e/jAsEmlFSgGd2VQloSpYgQV4SlnYYkFjSNpDO+0HQaTXQYpiHWJDMJMYMvkpmOmdgMNZJQmjJM+iI4kUxdDdVMnEmdzGJlHbcqEuIOUbxgEyBCEhvDH5++2JXeXO/u3oW7XPfn9zPDzJ5zfveeBxa+HA5370ZmIkka/85p9QCSpOYw6JJUCIMuSYUw6JJUCIMuSYUw6JJUiAmtOvH06dNz1qxZrTq9JI1Ljz/++KHMnFHvWMuCPmvWLHp7e1t1ekkalyLi+aGOectFkgph0CWpEAZdkgrRsnvoksp2/PhxKpUKr7zySqtHGZcmT55MR0cHEydObPgxBl3SmKhUKkyZMoVZs2YREa0eZ1zJTA4fPkylUmH27NkNP27EWy4RsTkifh4RTw9xPCLirojoj4gnI+I9o5hbUqFeeeUVpk2bZsxPQ0Qwbdq0Uf/rppF76FuAFcMcvwqYM/hjFfCNUU0gqVjG/PSdzq/diEHPzEeAXwyzZCXwrRzwKPD2iDh/1JNIUhN96lOfYv369ae2ly9fzs0333xq+zOf+Qxf/epX6e7u5o477hjVc7e1tbFgwQLmzZvHhz70IY4cOTLs+r6+PrZv3z6qc5yOZtxDbwdeqNquDO57sXZhRKxi4CqemTNnNuHUjZu19ntn9Xxn23N3fLDVI0jDavafwZF+z3d1dfGd73yHW2+9lVdffZVDhw7xy1/+8tTxnp4e1q9fzxVXXME111wzqnOfe+659PX1AXDDDTewYcMGvvCFLwy5vq+vj97eXq6++upRnWe0mvGyxXr/Lqj7bZAyc1NmdmZm54wZdb9yVZKaYunSpfT09ACwa9cu5s2bx5QpU3jppZf47W9/y+7du1m4cCFbtmxhzZo1ANx4443ccsstdHV18c53vpN77713xPMsWbKE/fv3A/DYY4/R1dXFwoUL6erqYs+ePRw7dozbb7+de+65hwULFnDPPffw8ssv8/GPf5zLL7+chQsXct999zXl59yMK/QKcGHVdgdwoAnPK0mn7YILLmDChAns27ePnp6eU+HdsWMHU6dOZf78+UyaNOl1j3vxxRf50Y9+xI9//GOuueYarr322iHPcfLkSR5++GFuuukmAC666CIeeeQRJkyYwA9+8ANuu+02tm3bxhe/+EV6e3u5++67Abjtttt43/vex+bNmzly5AiLFi3iAx/4AG9961vP6OfcjKB3A2siYitwBXA0M193u0WSzrbXrtJ7enr49Kc/zf79++np6WHq1Kl0dXXVfcyHP/xhzjnnHObOncvPfvazumt+85vfsGDBAp577jkuu+wyrrzySgCOHj3KDTfcwLPPPktEcPz48bqP//73v093dzd33nknMPCKoH379nHxxRef0c+3kZctfhvYAbw7IioRcVNErI6I1YNLtgN7gX7gX4C/O6OJJKlJurq66Onp4amnnmLevHksXryYHTt20NPTw9KlS+s+5i1vecupjzPr3j0+dQ/9+eef59ixY2zYsAGAdevWsWzZMp5++mnuv//+IV92mJls27aNvr4++vr6mhJzaOxVLtdn5vmZOTEzOzLzXzNzY2ZuHDyemfmJzPzjzLwkM30LRUlvCEuXLuWBBx7gvPPOo62tjfPOO48jR46wY8cOlixZcsbPP3XqVO666y7uvPNOjh8/ztGjR2lvbwdgy5Ytp9ZNmTKFX/3qV6e2ly9fzte+9rVTf2E88cQTZzwL+F4ukgp2ySWXcOjQIRYvXvw7+6ZOncr06dObco6FCxdy6aWXsnXrVj772c/y+c9/nqVLl3Ly5MlTa5YtW8Yzzzxz6j9F161bx/Hjx5k/fz7z5s1j3bp1TZklhvonxVjr7OzMs/l+6L5sUTq7du/e3ZTbCG9m9X4NI+LxzOyst94rdEkqhEGXpEIYdEkqhEGXNGZa9X90JTidXzuDLmlMTJ48mcOHDxv10/Da+6FPnjx5VI/zG1xIGhMdHR1UKhUOHjzY6lHGpde+Y9FoGHRJY2LixImj+m47OnPecpGkQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQhh0SSqEQZekQjQU9IhYERF7IqI/ItbWOT41Iu6PiP+OiF0R8bHmjypJGs6IQY+INmADcBUwF7g+IubWLPsE8ExmXgq8F/jHiJjU5FklScNo5Ap9EdCfmXsz8xiwFVhZsyaBKRERwNuAXwAnmjqpJGlYjQS9HXiharsyuK/a3cDFwAHgKeDvM/PVpkwoSWpII0GPOvuyZns50AdcACwA7o6I33/dE0WsiojeiOg9ePDgKEeVJA2nkaBXgAurtjsYuBKv9jHguzmgH/gpcFHtE2XmpszszMzOGTNmnO7MkqQ6Ggn6TmBORMwe/I/O64DumjX7gPcDRMQ7gHcDe5s5qCRpeBNGWpCZJyJiDfAQ0AZszsxdEbF68PhG4EvAloh4ioFbNJ/LzENjOLckqcaIQQfIzO3A9pp9G6s+PgD8ZXNHkySNhl8pKkmFMOiSVAiDLkmFMOiSVAiDLkmFMOiSVAiDLkmFMOiSVAiDLkmFMOiSVAiDLkmFMOiSVAiDLkmFMOiSVAiDLkmFMOiSVAiDLkmFMOiSVAiDLkmFMOiSVAiDLkmFMOiSVAiDLkmFMOiSVAiDLkmFMOiSVAiDLkmFMOiSVAiDLkmFMOiSVAiDLkmFMOiSVIiGgh4RKyJiT0T0R8TaIda8NyL6ImJXRPxnc8eUJI1kwkgLIqIN2ABcCVSAnRHRnZnPVK15O/B1YEVm7ouIPxyjeSVJQ2jkCn0R0J+ZezPzGLAVWFmz5iPAdzNzH0Bm/ry5Y0qSRtJI0NuBF6q2K4P7qr0L+IOI+GFEPB4RH23WgJKkxox4ywWIOvuyzvNcBrwfOBfYERGPZuZPfueJIlYBqwBmzpw5+mklSUNq5Aq9AlxYtd0BHKiz5sHMfDkzDwGPAJfWPlFmbsrMzszsnDFjxunOLEmqo5Gg7wTmRMTsiJgEXAd016y5D/jziJgQEb8HXAHsbu6okqThjHjLJTNPRMQa4CGgDdicmbsiYvXg8Y2ZuTsiHgSeBF4FvpmZT4/l4JKk39XIPXQyczuwvWbfxprtrwBfad5okqTR8CtFJakQBl2SCmHQJakQBl2SCmHQJakQBl2SCmHQJakQBl2SCmHQJakQBl2SCmHQJakQBl2SCmHQJakQBl2SCmHQJakQBl2SCtHQN7iQWm3W2u+1eoQx9dwdH2z1CCqAV+iSVAiDLkmFMOiSVAiDLkmFMOiSVAiDLkmFMOiSVAiDLkmFMOiSVAiDLkmFMOiSVAiDLkmFMOiSVAiDLkmFMOiSVAiDLkmFaCjoEbEiIvZERH9ErB1m3eURcTIirm3eiJKkRowY9IhoAzYAVwFzgesjYu4Q674MPNTsISVJI2vkCn0R0J+ZezPzGLAVWFln3SeBbcDPmzifJKlBjQS9HXiharsyuO+UiGgH/hrY2LzRJEmj0UjQo86+rNleD3wuM08O+0QRqyKiNyJ6Dx482OCIkqRGTGhgTQW4sGq7AzhQs6YT2BoRANOBqyPiRGb+e/WizNwEbALo7Oys/UtBknQGGgn6TmBORMwG9gPXAR+pXpCZs1/7OCK2AA/UxlySNLZGDHpmnoiINQy8eqUN2JyZuyJi9eBx75tL0htAI1foZOZ2YHvNvrohz8wbz3wsSdJo+ZWiklQIgy5JhTDoklQIgy5JhTDoklQIgy5JhTDoklQIgy5JhTDoklQIgy5JhTDoklQIgy5JhTDoklQIgy5JhTDoklQIgy5JhTDoklQIgy5JhTDoklQIgy5JhTDoklQIgy5JhTDoklQIgy5JhTDoklQIgy5JhTDoklQIgy5JhTDoklQIgy5JhTDoklQIgy5JhWgo6BGxIiL2RER/RKytc/xvIuLJwR89EXFp80eVJA1nxKBHRBuwAbgKmAtcHxFza5b9FPiLzJwPfAnY1OxBJUnDa+QKfRHQn5l7M/MYsBVYWb0gM3sy86XBzUeBjuaOKUkaSSNBbwdeqNquDO4byk3Af5zJUJKk0ZvQwJqosy/rLoxYxkDQ/2yI46uAVQAzZ85scERJUiMauUKvABdWbXcAB2oXRcR84JvAysw8XO+JMnNTZnZmZueMGTNOZ15J0hAaCfpOYE5EzI6IScB1QHf1goiYCXwX+NvM/Enzx5QkjWTEWy6ZeSIi1gAPAW3A5szcFRGrB49vBG4HpgFfjwiAE5nZOXZjS5JqNXIPnczcDmyv2bex6uObgZubO5okaTT8SlFJKoRBl6RCGHRJKoRBl6RCGHRJKoRBl6RCGHRJKoRBl6RCGHRJKoRBl6RCGHRJKoRBl6RCGHRJKoRBl6RCGHRJKoRBl6RCGHRJKoRBl6RCGHRJKoRBl6RCGHRJKoRBl6RCGHRJKoRBl6RCGHRJKoRBl6RCGHRJKoRBl6RCGHRJKoRBl6RCGHRJKoRBl6RCGHRJKkRDQY+IFRGxJyL6I2JtneMREXcNHn8yIt7T/FElScMZMegR0QZsAK4C5gLXR8TcmmVXAXMGf6wCvtHkOSVJI2jkCn0R0J+ZezPzGLAVWFmzZiXwrRzwKPD2iDi/ybNKkoYxoYE17cALVdsV4IoG1rQDL1YviohVDFzBA/w6IvaMatrxZTpw6GydLL58ts70puHnb/w6q5+7FvijoQ40EvSosy9PYw2ZuQnY1MA5x72I6M3MzlbPodPj52/8ejN/7hq55VIBLqza7gAOnMYaSdIYaiToO4E5ETE7IiYB1wHdNWu6gY8OvtplMXA0M1+sfSJJ0tgZ8ZZLZp6IiDXAQ0AbsDkzd0XE6sHjG4HtwNVAP/C/wMfGbuRx401xa6lgfv7Grzft5y4yX3erW5I0DvmVopJUCIMuSYUw6JJUiEZeh64GRMRFDHzFbDsDr8E/AHRn5u6WDiYVbvDPXjvwX5n566r9KzLzwdZNdvZ5hd4EEfE5Bt4SIYDHGHipZwDfrvdmZho/IsJXbL2BRcQtwH3AJ4GnI6L6bUn+oTVTtY6vcmmCiPgJ8KeZebxm/yRgV2bOac1kOlMRsS8zZ7Z6DtUXEU8BSzLz1xExC7gX+LfM/KeIeCIzF7Z2wrPLWy7N8SpwAfB8zf7zB4/pDSwinhzqEPCOszmLRq3ttdssmflcRLwXuDci/oj6b0lSNIPeHLcCD0fEs/z/m5TNBP4EWNOqodSwdwDLgZdq9gfQc/bH0Sj8T0QsyMw+gMEr9b8CNgOXtHSyFjDoTZCZD0bEuxh4q+F2BkJQAXZm5smWDqdGPAC87bUoVIuIH571aTQaHwVOVO/IzBMMvBXJP7dmpNbxHrokFcJXuUhSIQy6JBXCoEtSIQy6JBXCoEtSIf4P/AQ1qZCHyp0AAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "bot_games = games.loc[(games['Player 1'] != 'Bot 1') & (games['Player 2'] == 'Bot 2')]\n",
    "unique_players = bot_games['Player 1'].unique()\n",
    "\n",
    "win_rates = pd.DataFrame(columns=[\n",
    "    'Player',\n",
    "    'Win Rate',\n",
    "])\n",
    "\n",
    "for player in unique_players:\n",
    "    player_games = bot_games[bot_games['Player 1'] == player]\n",
    "    number_of_games = len(player_games)\n",
    "    win_games = len(player_games[player_games['Winner'] == player])\n",
    "    lose_games = len(player_games[player_games['Winner'] == 'Bot 2'])\n",
    "    \n",
    "    win_rate = win_games / max(1, (win_games + lose_games))\n",
    "    \n",
    "    win_rates.loc[len(win_rates)] = {\n",
    "        'Player': player,\n",
    "        'Win Rate': win_rate,\n",
    "    }\n",
    "    \n",
    "print(win_rates)\n",
    "    \n",
    "win_rates.plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "5b119bdb",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}