analysis_prompt_variations.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>Result</th>\n",
       "      <th>WhiteName</th>\n",
       "      <th>BlackName</th>\n",
       "      <th>WhiteElo</th>\n",
       "      <th>BlackElo</th>\n",
       "      <th>IncludeWhiteTitle</th>\n",
       "      <th>IncludeBlackTitle</th>\n",
       "      <th>Move</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1-0</td>\n",
       "      <td>Giraud, Thibaut</td>\n",
       "      <td>XXX</td>\n",
       "      <td>1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1-0</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>Giraud, Thibaut</td>\n",
       "      <td>1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1-0</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>XXX</td>\n",
       "      <td>1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1-0</td>\n",
       "      <td>XXX</td>\n",
       "      <td>Giraud, Thibaut</td>\n",
       "      <td>1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1-0</td>\n",
       "      <td>XXX</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>0-1</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>Giraud, Thibaut</td>\n",
       "      <td>1800</td>\n",
       "      <td>1800</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>315</th>\n",
       "      <td>0-1</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>XXX</td>\n",
       "      <td>1800</td>\n",
       "      <td>1800</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>318</th>\n",
       "      <td>0-1</td>\n",
       "      <td>XXX</td>\n",
       "      <td>Giraud, Thibaut</td>\n",
       "      <td>1800</td>\n",
       "      <td>1800</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>0-1</td>\n",
       "      <td>XXX</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>1800</td>\n",
       "      <td>1800</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>327</th>\n",
       "      <td>0-1</td>\n",
       "      <td>Kramnik, Vladimir</td>\n",
       "      <td>XXX</td>\n",
       "      <td>2000</td>\n",
       "      <td>2000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>64 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Result          WhiteName        BlackName  WhiteElo  BlackElo  \\\n",
       "11     1-0    Giraud, Thibaut              XXX      1000      1000   \n",
       "14     1-0     Louapre, David  Giraud, Thibaut      1000      1000   \n",
       "15     1-0     Louapre, David              XXX      1000      1000   \n",
       "18     1-0                XXX  Giraud, Thibaut      1000      1000   \n",
       "19     1-0                XXX   Louapre, David      1000      1000   \n",
       "..     ...                ...              ...       ...       ...   \n",
       "314    0-1     Louapre, David  Giraud, Thibaut      1800      1800   \n",
       "315    0-1     Louapre, David              XXX      1800      1800   \n",
       "318    0-1                XXX  Giraud, Thibaut      1800      1800   \n",
       "319    0-1                XXX   Louapre, David      1800      1800   \n",
       "327    0-1  Kramnik, Vladimir              XXX      2000      2000   \n",
       "\n",
       "     IncludeWhiteTitle  IncludeBlackTitle Move  \n",
       "11               False              False  Nf6  \n",
       "14               False              False  Nf6  \n",
       "15               False              False  Nf6  \n",
       "18               False              False  Nf6  \n",
       "19               False              False  Nf6  \n",
       "..                 ...                ...  ...  \n",
       "314              False              False  Nf6  \n",
       "315              False              False  Nf6  \n",
       "318              False              False  Nf6  \n",
       "319              False              False  Nf6  \n",
       "327              False              False  Nf6  \n",
       "\n",
       "[64 rows x 8 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.read_csv(\"prompt_variations_phi.csv\")\n",
    "df.query(\"Move == 'Nf6'\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>Result</th>\n",
       "      <th>WhiteName</th>\n",
       "      <th>BlackName</th>\n",
       "      <th>WhiteElo</th>\n",
       "      <th>BlackElo</th>\n",
       "      <th>IncludeWhiteTitle</th>\n",
       "      <th>IncludeBlackTitle</th>\n",
       "      <th>Move</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>1/2-1/2</td>\n",
       "      <td>Giraud, Thibaut</td>\n",
       "      <td>Kramnik, Vladimir</td>\n",
       "      <td>1700</td>\n",
       "      <td>1700</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>g6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1-0</td>\n",
       "      <td>Kramnik, Vladimir</td>\n",
       "      <td>Giraud, Thibaut</td>\n",
       "      <td>1400</td>\n",
       "      <td>1400</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>g6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>1/2-1/2</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>XXX</td>\n",
       "      <td>2000</td>\n",
       "      <td>2000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>g6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1-0</td>\n",
       "      <td>Nepomniachtchi, Ian</td>\n",
       "      <td>Giraud, Thibaut</td>\n",
       "      <td>1400</td>\n",
       "      <td>1400</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>g6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>198</th>\n",
       "      <td>1/2-1/2</td>\n",
       "      <td>XXX</td>\n",
       "      <td>Giraud, Thibaut</td>\n",
       "      <td>1800</td>\n",
       "      <td>1800</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>0-1</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>Giraud, Thibaut</td>\n",
       "      <td>1700</td>\n",
       "      <td>1700</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>1-0</td>\n",
       "      <td>Kramnik, Vladimir</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>2900</td>\n",
       "      <td>2900</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>g6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>1/2-1/2</td>\n",
       "      <td>Kramnik, Vladimir</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>1700</td>\n",
       "      <td>1700</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>g6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>337</th>\n",
       "      <td>0-1</td>\n",
       "      <td>XXX</td>\n",
       "      <td>Kramnik, Vladimir</td>\n",
       "      <td>2000</td>\n",
       "      <td>2000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>g6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>1-0</td>\n",
       "      <td>Kramnik, Vladimir</td>\n",
       "      <td>Nepomniachtchi, Ian</td>\n",
       "      <td>1700</td>\n",
       "      <td>1700</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>g6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>1/2-1/2</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>Giraud, Thibaut</td>\n",
       "      <td>2000</td>\n",
       "      <td>2000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>g6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282</th>\n",
       "      <td>0-1</td>\n",
       "      <td>Nepomniachtchi, Ian</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>1700</td>\n",
       "      <td>1700</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>g6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1-0</td>\n",
       "      <td>Nepomniachtchi, Ian</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>g6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>1-0</td>\n",
       "      <td>Nepomniachtchi, Ian</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>2900</td>\n",
       "      <td>2900</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>g6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>354</th>\n",
       "      <td>0-1</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>Giraud, Thibaut</td>\n",
       "      <td>2900</td>\n",
       "      <td>2900</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>g6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>1-0</td>\n",
       "      <td>XXX</td>\n",
       "      <td>Kramnik, Vladimir</td>\n",
       "      <td>1700</td>\n",
       "      <td>1700</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>g6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>1-0</td>\n",
       "      <td>Nepomniachtchi, Ian</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>1800</td>\n",
       "      <td>1800</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>1-0</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>Kramnik, Vladimir</td>\n",
       "      <td>2000</td>\n",
       "      <td>2000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>g6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>1-0</td>\n",
       "      <td>Nepomniachtchi, Ian</td>\n",
       "      <td>Kramnik, Vladimir</td>\n",
       "      <td>2000</td>\n",
       "      <td>2000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>g6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>308</th>\n",
       "      <td>0-1</td>\n",
       "      <td>Giraud, Thibaut</td>\n",
       "      <td>Nepomniachtchi, Ian</td>\n",
       "      <td>1800</td>\n",
       "      <td>1800</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>g6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      Result            WhiteName            BlackName  WhiteElo  BlackElo  \\\n",
       "169  1/2-1/2      Giraud, Thibaut    Kramnik, Vladimir      1700      1700   \n",
       "25       1-0    Kramnik, Vladimir      Giraud, Thibaut      1400      1400   \n",
       "215  1/2-1/2       Louapre, David                  XXX      2000      2000   \n",
       "21       1-0  Nepomniachtchi, Ian      Giraud, Thibaut      1400      1400   \n",
       "198  1/2-1/2                  XXX      Giraud, Thibaut      1800      1800   \n",
       "294      0-1       Louapre, David      Giraud, Thibaut      1700      1700   \n",
       "106      1-0    Kramnik, Vladimir       Louapre, David      2900      2900   \n",
       "166  1/2-1/2    Kramnik, Vladimir       Louapre, David      1700      1700   \n",
       "337      0-1                  XXX    Kramnik, Vladimir      2000      2000   \n",
       "44       1-0    Kramnik, Vladimir  Nepomniachtchi, Ian      1700      1700   \n",
       "214  1/2-1/2       Louapre, David      Giraud, Thibaut      2000      2000   \n",
       "282      0-1  Nepomniachtchi, Ian       Louapre, David      1700      1700   \n",
       "2        1-0  Nepomniachtchi, Ian       Louapre, David      1000      1000   \n",
       "102      1-0  Nepomniachtchi, Ian       Louapre, David      2900      2900   \n",
       "354      0-1       Louapre, David      Giraud, Thibaut      2900      2900   \n",
       "57       1-0                  XXX    Kramnik, Vladimir      1700      1700   \n",
       "62       1-0  Nepomniachtchi, Ian       Louapre, David      1800      1800   \n",
       "93       1-0       Louapre, David    Kramnik, Vladimir      2000      2000   \n",
       "80       1-0  Nepomniachtchi, Ian    Kramnik, Vladimir      2000      2000   \n",
       "308      0-1      Giraud, Thibaut  Nepomniachtchi, Ian      1800      1800   \n",
       "\n",
       "     IncludeWhiteTitle  IncludeBlackTitle Move  \n",
       "169              False              False   g6  \n",
       "25               False              False   g6  \n",
       "215              False              False   g6  \n",
       "21               False              False   g6  \n",
       "198              False              False  Nf6  \n",
       "294              False              False  Nf6  \n",
       "106              False              False   g6  \n",
       "166              False              False   g6  \n",
       "337              False              False   g6  \n",
       "44               False              False   g6  \n",
       "214              False              False   g6  \n",
       "282              False              False   g6  \n",
       "2                False              False   g6  \n",
       "102              False              False   g6  \n",
       "354              False              False   g6  \n",
       "57               False              False   g6  \n",
       "62               False              False  Nf6  \n",
       "93               False              False   g6  \n",
       "80               False              False   g6  \n",
       "308              False              False   g6  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# random sample of df\n",
    "df.sample(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "360"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0-1        26\n",
       "1-0        25\n",
       "1/2-1/2    13\n",
       "Name: Result, dtype: int64"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.query(\"Move == 'Nf6'\")['Result'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1800    19\n",
       "1400    16\n",
       "1000    15\n",
       "1700    13\n",
       "2000     1\n",
       "Name: BlackElo, dtype: int64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.query(\"Move == 'Nf6'\")['BlackElo'].value_counts() # White Elo is the same"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "XXX                29\n",
       "Giraud, Thibaut    20\n",
       "Louapre, David     15\n",
       "Name: BlackName, dtype: int64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.query(\"Move == 'Nf6'\")['BlackName'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "XXX                    21\n",
       "Louapre, David         19\n",
       "Giraud, Thibaut        15\n",
       "Kramnik, Vladimir       6\n",
       "Nepomniachtchi, Ian     3\n",
       "Name: WhiteName, dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.query(\"Move == 'Nf6'\")['WhiteName'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "## Petite note:\n",
    "# j'ai remarqué que jusqu'à 1800 Elo, sa sensibilité au prompt est un peu bizarre. \n",
    "# Par exemple avec \"1-0\" (Blanc gagne) il joue le coup correct g6. Mais avec \"0-1\" (Noir gagne) ou \"1/2-1/2\", il joue Nf6 (ce qui est illogique vu que Nf6 fait justement perdre les Noirs).\n",
    "# https://twitter.com/MonsieurPhi/status/1781260337754366265\n",
    "# Mais il n'a plus ce comportement bizarre quand le Elo dépasse 2000. Enfin bref ! Il faudrait faire d'autres tests pour déterminer à quel point cette information sur le niveau Elo influence son niveau de jeu, mais c'est déjà intéressant comme petite expérience.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>Result</th>\n",
       "      <th>WhiteName</th>\n",
       "      <th>BlackName</th>\n",
       "      <th>WhiteElo</th>\n",
       "      <th>BlackElo</th>\n",
       "      <th>IncludeWhiteTitle</th>\n",
       "      <th>IncludeBlackTitle</th>\n",
       "      <th>Move</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1-0</td>\n",
       "      <td>Giraud, Thibaut</td>\n",
       "      <td>XXX</td>\n",
       "      <td>1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1-0</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>Giraud, Thibaut</td>\n",
       "      <td>1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1-0</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>XXX</td>\n",
       "      <td>1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1-0</td>\n",
       "      <td>XXX</td>\n",
       "      <td>Giraud, Thibaut</td>\n",
       "      <td>1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1-0</td>\n",
       "      <td>XXX</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>1000</td>\n",
       "      <td>1000</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>311</th>\n",
       "      <td>0-1</td>\n",
       "      <td>Giraud, Thibaut</td>\n",
       "      <td>XXX</td>\n",
       "      <td>1800</td>\n",
       "      <td>1800</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>0-1</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>Giraud, Thibaut</td>\n",
       "      <td>1800</td>\n",
       "      <td>1800</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>315</th>\n",
       "      <td>0-1</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>XXX</td>\n",
       "      <td>1800</td>\n",
       "      <td>1800</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>318</th>\n",
       "      <td>0-1</td>\n",
       "      <td>XXX</td>\n",
       "      <td>Giraud, Thibaut</td>\n",
       "      <td>1800</td>\n",
       "      <td>1800</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>319</th>\n",
       "      <td>0-1</td>\n",
       "      <td>XXX</td>\n",
       "      <td>Louapre, David</td>\n",
       "      <td>1800</td>\n",
       "      <td>1800</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>Nf6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>63 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Result        WhiteName        BlackName  WhiteElo  BlackElo  \\\n",
       "11     1-0  Giraud, Thibaut              XXX      1000      1000   \n",
       "14     1-0   Louapre, David  Giraud, Thibaut      1000      1000   \n",
       "15     1-0   Louapre, David              XXX      1000      1000   \n",
       "18     1-0              XXX  Giraud, Thibaut      1000      1000   \n",
       "19     1-0              XXX   Louapre, David      1000      1000   \n",
       "..     ...              ...              ...       ...       ...   \n",
       "311    0-1  Giraud, Thibaut              XXX      1800      1800   \n",
       "314    0-1   Louapre, David  Giraud, Thibaut      1800      1800   \n",
       "315    0-1   Louapre, David              XXX      1800      1800   \n",
       "318    0-1              XXX  Giraud, Thibaut      1800      1800   \n",
       "319    0-1              XXX   Louapre, David      1800      1800   \n",
       "\n",
       "     IncludeWhiteTitle  IncludeBlackTitle Move  \n",
       "11               False              False  Nf6  \n",
       "14               False              False  Nf6  \n",
       "15               False              False  Nf6  \n",
       "18               False              False  Nf6  \n",
       "19               False              False  Nf6  \n",
       "..                 ...                ...  ...  \n",
       "311              False              False  Nf6  \n",
       "314              False              False  Nf6  \n",
       "315              False              False  Nf6  \n",
       "318              False              False  Nf6  \n",
       "319              False              False  Nf6  \n",
       "\n",
       "[63 rows x 8 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# jusqu'à 1800 Elo, sa sensibilité au prompt est un peu bizarre. \n",
    "df.query(\"Move == 'Nf6' and BlackElo <= 1800\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1-0        25\n",
       "0-1        25\n",
       "1/2-1/2    13\n",
       "Name: Result, dtype: int64"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Mais avec \"0-1\" (Noir gagne) ou \"1/2-1/2\", il joue Nf6\n",
    "df.query(\"Move == 'Nf6' and BlackElo <= 1800\")['Result'].value_counts()"
   ]
  }
 ],
 "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.19"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}