analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Game.py                       allStrategiesOnce_modeP.csv\r\n",
      "Player.py                     allStrategiesRandom.csv\r\n",
      "README.md                     allStrategiesRandom_modeP.csv\r\n",
      "Strategy.py                   analysis.ipynb\r\n",
      "Tournament.py                 montecarlo_simulation.py\r\n",
      "\u001b[34m__pycache__\u001b[m\u001b[m                   presentation.pdf\r\n",
      "allStrategiesOnce.csv         results.csv\r\n"
     ]
    }
   ],
   "source": [
    "!ls"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "r1 = pd.read_csv('allStrategiesOnce.csv')\n",
    "r2 = pd.read_csv('allStrategiesRandom.csv')\n",
    "r3 = pd.read_csv('allStrategiesOnce_modeP.csv')\n",
    "r4 = pd.read_csv('allStrategiesRandom_modeP.csv')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Tournament Rankings when all strategies are played once, mode = misimplementation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "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>PlayerScore</th>\n",
       "      <th>PlayerWinRate</th>\n",
       "      <th>PlayerLossRate</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PlayerStrategy</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>SM</th>\n",
       "      <td>2.432403</td>\n",
       "      <td>0.295933</td>\n",
       "      <td>0.552800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TFTT</th>\n",
       "      <td>2.418197</td>\n",
       "      <td>0.189467</td>\n",
       "      <td>0.668800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GRAD</th>\n",
       "      <td>2.415195</td>\n",
       "      <td>0.468533</td>\n",
       "      <td>0.383733</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TFT</th>\n",
       "      <td>2.392473</td>\n",
       "      <td>0.439867</td>\n",
       "      <td>0.405000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AllC</th>\n",
       "      <td>2.392350</td>\n",
       "      <td>0.120200</td>\n",
       "      <td>0.752533</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SGRIM</th>\n",
       "      <td>2.373892</td>\n",
       "      <td>0.469933</td>\n",
       "      <td>0.398000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FBF</th>\n",
       "      <td>2.373591</td>\n",
       "      <td>0.314600</td>\n",
       "      <td>0.545000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TTFT</th>\n",
       "      <td>2.366413</td>\n",
       "      <td>0.552467</td>\n",
       "      <td>0.322200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HTFT</th>\n",
       "      <td>2.364063</td>\n",
       "      <td>0.598933</td>\n",
       "      <td>0.274267</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PAV</th>\n",
       "      <td>2.362387</td>\n",
       "      <td>0.423733</td>\n",
       "      <td>0.440533</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GRIM</th>\n",
       "      <td>2.356973</td>\n",
       "      <td>0.614400</td>\n",
       "      <td>0.261933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HM</th>\n",
       "      <td>2.343752</td>\n",
       "      <td>0.480000</td>\n",
       "      <td>0.447600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>STFT</th>\n",
       "      <td>2.309837</td>\n",
       "      <td>0.501200</td>\n",
       "      <td>0.436667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RAND</th>\n",
       "      <td>2.302271</td>\n",
       "      <td>0.486667</td>\n",
       "      <td>0.471667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AllD</th>\n",
       "      <td>2.284411</td>\n",
       "      <td>0.685200</td>\n",
       "      <td>0.273800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RTFT</th>\n",
       "      <td>2.262317</td>\n",
       "      <td>0.475267</td>\n",
       "      <td>0.481867</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                PlayerScore  PlayerWinRate  PlayerLossRate\n",
       "PlayerStrategy                                            \n",
       "SM                 2.432403       0.295933        0.552800\n",
       "TFTT               2.418197       0.189467        0.668800\n",
       "GRAD               2.415195       0.468533        0.383733\n",
       "TFT                2.392473       0.439867        0.405000\n",
       "AllC               2.392350       0.120200        0.752533\n",
       "SGRIM              2.373892       0.469933        0.398000\n",
       "FBF                2.373591       0.314600        0.545000\n",
       "TTFT               2.366413       0.552467        0.322200\n",
       "HTFT               2.364063       0.598933        0.274267\n",
       "PAV                2.362387       0.423733        0.440533\n",
       "GRIM               2.356973       0.614400        0.261933\n",
       "HM                 2.343752       0.480000        0.447600\n",
       "STFT               2.309837       0.501200        0.436667\n",
       "RAND               2.302271       0.486667        0.471667\n",
       "AllD               2.284411       0.685200        0.273800\n",
       "RTFT               2.262317       0.475267        0.481867"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "players1 = r1.groupby('PlayerStrategy').agg({'PlayerScore': 'mean', 'PlayerWinRate': 'mean', 'PlayerLossRate': 'mean'})\n",
    "players1 = players1.sort_values(by='PlayerScore', ascending=False)\n",
    "players1"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Tournament Rankings when all strategies are played 2-5 times, mode = misimplementation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "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>PlayerStrategy</th>\n",
       "      <th>PlayerScore</th>\n",
       "      <th>PlayerWinRate</th>\n",
       "      <th>PlayerLossRate</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PlayerStrategy</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>SM</th>\n",
       "      <td>2500</td>\n",
       "      <td>2.449829</td>\n",
       "      <td>0.283828</td>\n",
       "      <td>0.561297</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TFTT</th>\n",
       "      <td>2000</td>\n",
       "      <td>2.436147</td>\n",
       "      <td>0.193241</td>\n",
       "      <td>0.658155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AllC</th>\n",
       "      <td>1000</td>\n",
       "      <td>2.425721</td>\n",
       "      <td>0.122983</td>\n",
       "      <td>0.740845</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GRAD</th>\n",
       "      <td>2500</td>\n",
       "      <td>2.423274</td>\n",
       "      <td>0.475055</td>\n",
       "      <td>0.372793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TFT</th>\n",
       "      <td>2000</td>\n",
       "      <td>2.388992</td>\n",
       "      <td>0.433862</td>\n",
       "      <td>0.405276</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SGRIM</th>\n",
       "      <td>1500</td>\n",
       "      <td>2.383329</td>\n",
       "      <td>0.471655</td>\n",
       "      <td>0.387391</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FBF</th>\n",
       "      <td>1500</td>\n",
       "      <td>2.379059</td>\n",
       "      <td>0.307046</td>\n",
       "      <td>0.543322</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TTFT</th>\n",
       "      <td>2500</td>\n",
       "      <td>2.371472</td>\n",
       "      <td>0.549014</td>\n",
       "      <td>0.311972</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PAV</th>\n",
       "      <td>2500</td>\n",
       "      <td>2.367882</td>\n",
       "      <td>0.414428</td>\n",
       "      <td>0.434545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HTFT</th>\n",
       "      <td>2000</td>\n",
       "      <td>2.367504</td>\n",
       "      <td>0.606078</td>\n",
       "      <td>0.261698</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GRIM</th>\n",
       "      <td>1000</td>\n",
       "      <td>2.359877</td>\n",
       "      <td>0.615534</td>\n",
       "      <td>0.253638</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HM</th>\n",
       "      <td>1000</td>\n",
       "      <td>2.338781</td>\n",
       "      <td>0.466448</td>\n",
       "      <td>0.458483</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>STFT</th>\n",
       "      <td>2500</td>\n",
       "      <td>2.312152</td>\n",
       "      <td>0.498352</td>\n",
       "      <td>0.434262</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RAND</th>\n",
       "      <td>1500</td>\n",
       "      <td>2.287843</td>\n",
       "      <td>0.477632</td>\n",
       "      <td>0.476621</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AllD</th>\n",
       "      <td>1000</td>\n",
       "      <td>2.277941</td>\n",
       "      <td>0.689724</td>\n",
       "      <td>0.268793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RTFT</th>\n",
       "      <td>2500</td>\n",
       "      <td>2.252179</td>\n",
       "      <td>0.471428</td>\n",
       "      <td>0.482248</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                PlayerStrategy  PlayerScore  PlayerWinRate  PlayerLossRate\n",
       "PlayerStrategy                                                            \n",
       "SM                        2500     2.449829       0.283828        0.561297\n",
       "TFTT                      2000     2.436147       0.193241        0.658155\n",
       "AllC                      1000     2.425721       0.122983        0.740845\n",
       "GRAD                      2500     2.423274       0.475055        0.372793\n",
       "TFT                       2000     2.388992       0.433862        0.405276\n",
       "SGRIM                     1500     2.383329       0.471655        0.387391\n",
       "FBF                       1500     2.379059       0.307046        0.543322\n",
       "TTFT                      2500     2.371472       0.549014        0.311972\n",
       "PAV                       2500     2.367882       0.414428        0.434545\n",
       "HTFT                      2000     2.367504       0.606078        0.261698\n",
       "GRIM                      1000     2.359877       0.615534        0.253638\n",
       "HM                        1000     2.338781       0.466448        0.458483\n",
       "STFT                      2500     2.312152       0.498352        0.434262\n",
       "RAND                      1500     2.287843       0.477632        0.476621\n",
       "AllD                      1000     2.277941       0.689724        0.268793\n",
       "RTFT                      2500     2.252179       0.471428        0.482248"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "players2 = r2.groupby('PlayerStrategy').agg({'PlayerStrategy': 'count', 'PlayerScore': 'mean', 'PlayerWinRate': 'mean', 'PlayerLossRate': 'mean'})\n",
    "players2 = players2.sort_values(by='PlayerScore', ascending=False)\n",
    "players2"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Tournament Rankings when all strategies are played once, mode = misperception"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "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>PlayerScore</th>\n",
       "      <th>PlayerWinRate</th>\n",
       "      <th>PlayerLossRate</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PlayerStrategy</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>SM</th>\n",
       "      <td>2.426642</td>\n",
       "      <td>0.288600</td>\n",
       "      <td>0.564467</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GRAD</th>\n",
       "      <td>2.418489</td>\n",
       "      <td>0.477667</td>\n",
       "      <td>0.377933</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TFTT</th>\n",
       "      <td>2.414021</td>\n",
       "      <td>0.187000</td>\n",
       "      <td>0.671400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AllC</th>\n",
       "      <td>2.397311</td>\n",
       "      <td>0.120200</td>\n",
       "      <td>0.754867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TFT</th>\n",
       "      <td>2.385474</td>\n",
       "      <td>0.438933</td>\n",
       "      <td>0.410000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FBF</th>\n",
       "      <td>2.376789</td>\n",
       "      <td>0.318467</td>\n",
       "      <td>0.539467</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TTFT</th>\n",
       "      <td>2.376445</td>\n",
       "      <td>0.553533</td>\n",
       "      <td>0.317000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SGRIM</th>\n",
       "      <td>2.372927</td>\n",
       "      <td>0.471333</td>\n",
       "      <td>0.395200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HTFT</th>\n",
       "      <td>2.367511</td>\n",
       "      <td>0.600200</td>\n",
       "      <td>0.270733</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PAV</th>\n",
       "      <td>2.361555</td>\n",
       "      <td>0.429733</td>\n",
       "      <td>0.434067</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GRIM</th>\n",
       "      <td>2.356944</td>\n",
       "      <td>0.613400</td>\n",
       "      <td>0.260267</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HM</th>\n",
       "      <td>2.345416</td>\n",
       "      <td>0.476267</td>\n",
       "      <td>0.449400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>STFT</th>\n",
       "      <td>2.311049</td>\n",
       "      <td>0.499200</td>\n",
       "      <td>0.440800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RAND</th>\n",
       "      <td>2.299724</td>\n",
       "      <td>0.486467</td>\n",
       "      <td>0.471867</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AllD</th>\n",
       "      <td>2.283681</td>\n",
       "      <td>0.683933</td>\n",
       "      <td>0.271267</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RTFT</th>\n",
       "      <td>2.259061</td>\n",
       "      <td>0.470267</td>\n",
       "      <td>0.486467</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                PlayerScore  PlayerWinRate  PlayerLossRate\n",
       "PlayerStrategy                                            \n",
       "SM                 2.426642       0.288600        0.564467\n",
       "GRAD               2.418489       0.477667        0.377933\n",
       "TFTT               2.414021       0.187000        0.671400\n",
       "AllC               2.397311       0.120200        0.754867\n",
       "TFT                2.385474       0.438933        0.410000\n",
       "FBF                2.376789       0.318467        0.539467\n",
       "TTFT               2.376445       0.553533        0.317000\n",
       "SGRIM              2.372927       0.471333        0.395200\n",
       "HTFT               2.367511       0.600200        0.270733\n",
       "PAV                2.361555       0.429733        0.434067\n",
       "GRIM               2.356944       0.613400        0.260267\n",
       "HM                 2.345416       0.476267        0.449400\n",
       "STFT               2.311049       0.499200        0.440800\n",
       "RAND               2.299724       0.486467        0.471867\n",
       "AllD               2.283681       0.683933        0.271267\n",
       "RTFT               2.259061       0.470267        0.486467"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "players3 = r3.groupby('PlayerStrategy').agg({'PlayerScore': 'mean', 'PlayerWinRate': 'mean', 'PlayerLossRate': 'mean'})\n",
    "players3 = players3.sort_values(by='PlayerScore', ascending=False)\n",
    "players3"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Tournament Rankings when all strategies are played 2-5 times, mode = misperception"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "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>PlayerStrategy</th>\n",
       "      <th>PlayerScore</th>\n",
       "      <th>PlayerWinRate</th>\n",
       "      <th>PlayerLossRate</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PlayerStrategy</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>SM</th>\n",
       "      <td>400</td>\n",
       "      <td>2.459208</td>\n",
       "      <td>0.286019</td>\n",
       "      <td>0.549630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TFTT</th>\n",
       "      <td>400</td>\n",
       "      <td>2.453872</td>\n",
       "      <td>0.204861</td>\n",
       "      <td>0.641435</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AllC</th>\n",
       "      <td>400</td>\n",
       "      <td>2.451083</td>\n",
       "      <td>0.135185</td>\n",
       "      <td>0.718843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GRAD</th>\n",
       "      <td>400</td>\n",
       "      <td>2.426289</td>\n",
       "      <td>0.466343</td>\n",
       "      <td>0.381296</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TFT</th>\n",
       "      <td>200</td>\n",
       "      <td>2.407124</td>\n",
       "      <td>0.446667</td>\n",
       "      <td>0.393056</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>FBF</th>\n",
       "      <td>300</td>\n",
       "      <td>2.400353</td>\n",
       "      <td>0.330309</td>\n",
       "      <td>0.520123</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SGRIM</th>\n",
       "      <td>500</td>\n",
       "      <td>2.392287</td>\n",
       "      <td>0.467185</td>\n",
       "      <td>0.389481</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>PAV</th>\n",
       "      <td>400</td>\n",
       "      <td>2.388359</td>\n",
       "      <td>0.419491</td>\n",
       "      <td>0.425139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>TTFT</th>\n",
       "      <td>200</td>\n",
       "      <td>2.377678</td>\n",
       "      <td>0.536389</td>\n",
       "      <td>0.322870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HTFT</th>\n",
       "      <td>500</td>\n",
       "      <td>2.373919</td>\n",
       "      <td>0.599926</td>\n",
       "      <td>0.264741</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GRIM</th>\n",
       "      <td>400</td>\n",
       "      <td>2.355293</td>\n",
       "      <td>0.602176</td>\n",
       "      <td>0.266111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>HM</th>\n",
       "      <td>200</td>\n",
       "      <td>2.350557</td>\n",
       "      <td>0.486667</td>\n",
       "      <td>0.442870</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>STFT</th>\n",
       "      <td>500</td>\n",
       "      <td>2.330937</td>\n",
       "      <td>0.512556</td>\n",
       "      <td>0.420370</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RAND</th>\n",
       "      <td>300</td>\n",
       "      <td>2.312262</td>\n",
       "      <td>0.491728</td>\n",
       "      <td>0.465309</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>AllD</th>\n",
       "      <td>200</td>\n",
       "      <td>2.279747</td>\n",
       "      <td>0.684259</td>\n",
       "      <td>0.274630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RTFT</th>\n",
       "      <td>200</td>\n",
       "      <td>2.263251</td>\n",
       "      <td>0.477593</td>\n",
       "      <td>0.478981</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                PlayerStrategy  PlayerScore  PlayerWinRate  PlayerLossRate\n",
       "PlayerStrategy                                                            \n",
       "SM                         400     2.459208       0.286019        0.549630\n",
       "TFTT                       400     2.453872       0.204861        0.641435\n",
       "AllC                       400     2.451083       0.135185        0.718843\n",
       "GRAD                       400     2.426289       0.466343        0.381296\n",
       "TFT                        200     2.407124       0.446667        0.393056\n",
       "FBF                        300     2.400353       0.330309        0.520123\n",
       "SGRIM                      500     2.392287       0.467185        0.389481\n",
       "PAV                        400     2.388359       0.419491        0.425139\n",
       "TTFT                       200     2.377678       0.536389        0.322870\n",
       "HTFT                       500     2.373919       0.599926        0.264741\n",
       "GRIM                       400     2.355293       0.602176        0.266111\n",
       "HM                         200     2.350557       0.486667        0.442870\n",
       "STFT                       500     2.330937       0.512556        0.420370\n",
       "RAND                       300     2.312262       0.491728        0.465309\n",
       "AllD                       200     2.279747       0.684259        0.274630\n",
       "RTFT                       200     2.263251       0.477593        0.478981"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "players4 = r4.groupby('PlayerStrategy').agg({'PlayerStrategy': 'count', 'PlayerScore': 'mean', 'PlayerWinRate': 'mean', 'PlayerLossRate': 'mean'})\n",
    "players4 = players4.sort_values(by='PlayerScore', ascending=False)\n",
    "players4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}