ches_db_exploration.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('chessdb0-1')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>Unnamed: 0</th>\n",
       "      <th>Opening</th>\n",
       "      <th>Colour</th>\n",
       "      <th>Num Games</th>\n",
       "      <th>ECO</th>\n",
       "      <th>Last Played</th>\n",
       "      <th>Perf Rating</th>\n",
       "      <th>Avg Player</th>\n",
       "      <th>Player Win %</th>\n",
       "      <th>Draw %</th>\n",
       "      <th>...</th>\n",
       "      <th>move2b</th>\n",
       "      <th>move3w</th>\n",
       "      <th>move3b</th>\n",
       "      <th>move4w</th>\n",
       "      <th>move4b</th>\n",
       "      <th>White_win%</th>\n",
       "      <th>Black_win%</th>\n",
       "      <th>White_odds</th>\n",
       "      <th>White_Wins</th>\n",
       "      <th>Black_Wins</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Alekhine Defense, Balogh Variation</td>\n",
       "      <td>white</td>\n",
       "      <td>692</td>\n",
       "      <td>B03</td>\n",
       "      <td>2018-06-22</td>\n",
       "      <td>2247</td>\n",
       "      <td>2225</td>\n",
       "      <td>40.8</td>\n",
       "      <td>24.3</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>d4</td>\n",
       "      <td>d6</td>\n",
       "      <td>Bc4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.8</td>\n",
       "      <td>35.0</td>\n",
       "      <td>1.165714</td>\n",
       "      <td>282.336</td>\n",
       "      <td>242.200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>Alekhine Defense, Brooklyn Variation</td>\n",
       "      <td>black</td>\n",
       "      <td>228</td>\n",
       "      <td>B02</td>\n",
       "      <td>2018-06-27</td>\n",
       "      <td>2145</td>\n",
       "      <td>2193</td>\n",
       "      <td>29.8</td>\n",
       "      <td>22.4</td>\n",
       "      <td>...</td>\n",
       "      <td>Ng8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>47.8</td>\n",
       "      <td>29.8</td>\n",
       "      <td>1.604027</td>\n",
       "      <td>108.984</td>\n",
       "      <td>67.944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>Alekhine Defense, Exchange Variation</td>\n",
       "      <td>white</td>\n",
       "      <td>6485</td>\n",
       "      <td>B03</td>\n",
       "      <td>2018-07-06</td>\n",
       "      <td>2244</td>\n",
       "      <td>2194</td>\n",
       "      <td>40.8</td>\n",
       "      <td>27.7</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>d4</td>\n",
       "      <td>d6</td>\n",
       "      <td>c4</td>\n",
       "      <td>Nb6</td>\n",
       "      <td>40.8</td>\n",
       "      <td>31.5</td>\n",
       "      <td>1.295238</td>\n",
       "      <td>2645.880</td>\n",
       "      <td>2042.775</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>Alekhine Defense, Four Pawns Attack</td>\n",
       "      <td>white</td>\n",
       "      <td>881</td>\n",
       "      <td>B03</td>\n",
       "      <td>2018-06-20</td>\n",
       "      <td>2187</td>\n",
       "      <td>2130</td>\n",
       "      <td>39.7</td>\n",
       "      <td>23.2</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>d4</td>\n",
       "      <td>d6</td>\n",
       "      <td>c4</td>\n",
       "      <td>Nb6</td>\n",
       "      <td>39.7</td>\n",
       "      <td>37.1</td>\n",
       "      <td>1.070081</td>\n",
       "      <td>349.757</td>\n",
       "      <td>326.851</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>Alekhine Defense, Four Pawns Attack, Fianchett...</td>\n",
       "      <td>black</td>\n",
       "      <td>259</td>\n",
       "      <td>B03</td>\n",
       "      <td>2018-05-20</td>\n",
       "      <td>2122</td>\n",
       "      <td>2178</td>\n",
       "      <td>37.8</td>\n",
       "      <td>21.2</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>d4</td>\n",
       "      <td>d6</td>\n",
       "      <td>c4</td>\n",
       "      <td>Nb6</td>\n",
       "      <td>40.9</td>\n",
       "      <td>37.8</td>\n",
       "      <td>1.082011</td>\n",
       "      <td>105.931</td>\n",
       "      <td>97.902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>Alekhine Defense, Four Pawns Attack, Main Line</td>\n",
       "      <td>white</td>\n",
       "      <td>1207</td>\n",
       "      <td>B03</td>\n",
       "      <td>2018-07-01</td>\n",
       "      <td>2243</td>\n",
       "      <td>2190</td>\n",
       "      <td>41.0</td>\n",
       "      <td>25.9</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>d4</td>\n",
       "      <td>d6</td>\n",
       "      <td>c4</td>\n",
       "      <td>Nb6</td>\n",
       "      <td>41.0</td>\n",
       "      <td>33.1</td>\n",
       "      <td>1.238671</td>\n",
       "      <td>494.870</td>\n",
       "      <td>399.517</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>Alekhine Defense, Four Pawns Attack, Trifunovi...</td>\n",
       "      <td>black</td>\n",
       "      <td>323</td>\n",
       "      <td>B03</td>\n",
       "      <td>2018-05-10</td>\n",
       "      <td>2231</td>\n",
       "      <td>2277</td>\n",
       "      <td>35.9</td>\n",
       "      <td>24.8</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>d4</td>\n",
       "      <td>d6</td>\n",
       "      <td>c4</td>\n",
       "      <td>Nb6</td>\n",
       "      <td>39.3</td>\n",
       "      <td>35.9</td>\n",
       "      <td>1.094708</td>\n",
       "      <td>126.939</td>\n",
       "      <td>115.957</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>Alekhine Defense, General</td>\n",
       "      <td>black</td>\n",
       "      <td>524</td>\n",
       "      <td>B02</td>\n",
       "      <td>2018-06-29</td>\n",
       "      <td>2032</td>\n",
       "      <td>2077</td>\n",
       "      <td>42.2</td>\n",
       "      <td>25.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32.8</td>\n",
       "      <td>42.2</td>\n",
       "      <td>0.777251</td>\n",
       "      <td>171.872</td>\n",
       "      <td>221.128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>Alekhine Defense, Hunt Variation, Lasker Simul...</td>\n",
       "      <td>white</td>\n",
       "      <td>334</td>\n",
       "      <td>B02</td>\n",
       "      <td>2018-06-27</td>\n",
       "      <td>2205</td>\n",
       "      <td>2178</td>\n",
       "      <td>34.1</td>\n",
       "      <td>23.6</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>c4</td>\n",
       "      <td>Nb6</td>\n",
       "      <td>c5</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>34.1</td>\n",
       "      <td>42.2</td>\n",
       "      <td>0.808057</td>\n",
       "      <td>113.894</td>\n",
       "      <td>140.948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>Alekhine Defense, Maroczy Variation</td>\n",
       "      <td>white</td>\n",
       "      <td>931</td>\n",
       "      <td>B02</td>\n",
       "      <td>2018-07-09</td>\n",
       "      <td>2174</td>\n",
       "      <td>2174</td>\n",
       "      <td>36.6</td>\n",
       "      <td>25.7</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36.6</td>\n",
       "      <td>37.7</td>\n",
       "      <td>0.970822</td>\n",
       "      <td>340.746</td>\n",
       "      <td>350.987</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>Alekhine Defense, Modern Variation</td>\n",
       "      <td>white</td>\n",
       "      <td>501</td>\n",
       "      <td>B04</td>\n",
       "      <td>2018-06-25</td>\n",
       "      <td>2397</td>\n",
       "      <td>2336</td>\n",
       "      <td>43.5</td>\n",
       "      <td>31.7</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>d4</td>\n",
       "      <td>d6</td>\n",
       "      <td>Nf3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43.5</td>\n",
       "      <td>24.8</td>\n",
       "      <td>1.754032</td>\n",
       "      <td>217.935</td>\n",
       "      <td>124.248</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>Alekhine Defense, Modern Variation, Alburt Var...</td>\n",
       "      <td>black</td>\n",
       "      <td>2626</td>\n",
       "      <td>B04</td>\n",
       "      <td>2018-06-30</td>\n",
       "      <td>2250</td>\n",
       "      <td>2294</td>\n",
       "      <td>28.3</td>\n",
       "      <td>30.3</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>d4</td>\n",
       "      <td>d6</td>\n",
       "      <td>Nf3</td>\n",
       "      <td>g6</td>\n",
       "      <td>41.4</td>\n",
       "      <td>28.3</td>\n",
       "      <td>1.462898</td>\n",
       "      <td>1087.164</td>\n",
       "      <td>743.158</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>Alekhine Defense, Modern Variation, Alekhine G...</td>\n",
       "      <td>white</td>\n",
       "      <td>120</td>\n",
       "      <td>B04</td>\n",
       "      <td>2018-06-11</td>\n",
       "      <td>2097</td>\n",
       "      <td>2081</td>\n",
       "      <td>36.7</td>\n",
       "      <td>22.5</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>d4</td>\n",
       "      <td>d6</td>\n",
       "      <td>Nf3</td>\n",
       "      <td>Bg4</td>\n",
       "      <td>36.7</td>\n",
       "      <td>40.8</td>\n",
       "      <td>0.899510</td>\n",
       "      <td>44.040</td>\n",
       "      <td>48.960</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>Alekhine Defense, Modern Variation, Keres Vari...</td>\n",
       "      <td>white</td>\n",
       "      <td>269</td>\n",
       "      <td>B04</td>\n",
       "      <td>2018-03-04</td>\n",
       "      <td>2442</td>\n",
       "      <td>2383</td>\n",
       "      <td>45.7</td>\n",
       "      <td>36.4</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>d4</td>\n",
       "      <td>d6</td>\n",
       "      <td>Nf3</td>\n",
       "      <td>g6</td>\n",
       "      <td>45.7</td>\n",
       "      <td>17.8</td>\n",
       "      <td>2.567416</td>\n",
       "      <td>122.933</td>\n",
       "      <td>47.882</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>Alekhine Defense, Modern Variation, Larsen Var...</td>\n",
       "      <td>black</td>\n",
       "      <td>1187</td>\n",
       "      <td>B04</td>\n",
       "      <td>2018-06-21</td>\n",
       "      <td>2243</td>\n",
       "      <td>2283</td>\n",
       "      <td>22.8</td>\n",
       "      <td>35.7</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>d4</td>\n",
       "      <td>d6</td>\n",
       "      <td>Nf3</td>\n",
       "      <td>dxe5</td>\n",
       "      <td>41.5</td>\n",
       "      <td>22.8</td>\n",
       "      <td>1.820175</td>\n",
       "      <td>492.605</td>\n",
       "      <td>270.636</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>Alekhine Defense, Modern Variation, Larsen Var...</td>\n",
       "      <td>black</td>\n",
       "      <td>1481</td>\n",
       "      <td>B04</td>\n",
       "      <td>2018-06-18</td>\n",
       "      <td>2273</td>\n",
       "      <td>2306</td>\n",
       "      <td>25.9</td>\n",
       "      <td>35.9</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>d4</td>\n",
       "      <td>d6</td>\n",
       "      <td>Nf3</td>\n",
       "      <td>dxe5</td>\n",
       "      <td>38.2</td>\n",
       "      <td>25.9</td>\n",
       "      <td>1.474903</td>\n",
       "      <td>565.742</td>\n",
       "      <td>383.579</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>Alekhine Defense, Modern Variation, Larsen-Haa...</td>\n",
       "      <td>black</td>\n",
       "      <td>685</td>\n",
       "      <td>B04</td>\n",
       "      <td>2018-06-25</td>\n",
       "      <td>2171</td>\n",
       "      <td>2193</td>\n",
       "      <td>32.3</td>\n",
       "      <td>21.5</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>d4</td>\n",
       "      <td>d6</td>\n",
       "      <td>Nf3</td>\n",
       "      <td>Nc6</td>\n",
       "      <td>46.3</td>\n",
       "      <td>32.3</td>\n",
       "      <td>1.433437</td>\n",
       "      <td>317.155</td>\n",
       "      <td>221.255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>Alekhine Defense, Modern Variation, Main Line</td>\n",
       "      <td>black</td>\n",
       "      <td>5096</td>\n",
       "      <td>B05</td>\n",
       "      <td>2018-07-02</td>\n",
       "      <td>2209</td>\n",
       "      <td>2269</td>\n",
       "      <td>25.1</td>\n",
       "      <td>30.2</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>d4</td>\n",
       "      <td>d6</td>\n",
       "      <td>Nf3</td>\n",
       "      <td>Bg4</td>\n",
       "      <td>44.8</td>\n",
       "      <td>25.1</td>\n",
       "      <td>1.784861</td>\n",
       "      <td>2283.008</td>\n",
       "      <td>1279.096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>Alekhine Defense, Modern Variation, Panov Vari...</td>\n",
       "      <td>white</td>\n",
       "      <td>183</td>\n",
       "      <td>B05</td>\n",
       "      <td>2018-05-31</td>\n",
       "      <td>2305</td>\n",
       "      <td>2269</td>\n",
       "      <td>44.3</td>\n",
       "      <td>22.4</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>d4</td>\n",
       "      <td>d6</td>\n",
       "      <td>Nf3</td>\n",
       "      <td>Bg4</td>\n",
       "      <td>44.3</td>\n",
       "      <td>33.3</td>\n",
       "      <td>1.330330</td>\n",
       "      <td>81.069</td>\n",
       "      <td>60.939</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>Alekhine Defense, Modern Variation, Schmid Var...</td>\n",
       "      <td>black</td>\n",
       "      <td>688</td>\n",
       "      <td>B04</td>\n",
       "      <td>2018-07-04</td>\n",
       "      <td>2300</td>\n",
       "      <td>2333</td>\n",
       "      <td>31.7</td>\n",
       "      <td>34.3</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>d4</td>\n",
       "      <td>d6</td>\n",
       "      <td>Nf3</td>\n",
       "      <td>Nb6</td>\n",
       "      <td>34.0</td>\n",
       "      <td>31.7</td>\n",
       "      <td>1.072555</td>\n",
       "      <td>233.920</td>\n",
       "      <td>218.096</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>Alekhine Defense, Normal Variation</td>\n",
       "      <td>black</td>\n",
       "      <td>981</td>\n",
       "      <td>B02</td>\n",
       "      <td>2018-06-30</td>\n",
       "      <td>2142</td>\n",
       "      <td>2173</td>\n",
       "      <td>34.0</td>\n",
       "      <td>26.7</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>39.3</td>\n",
       "      <td>34.0</td>\n",
       "      <td>1.155882</td>\n",
       "      <td>385.533</td>\n",
       "      <td>333.540</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>Alekhine Defense, Normal Variation</td>\n",
       "      <td>black</td>\n",
       "      <td>1178</td>\n",
       "      <td>B03</td>\n",
       "      <td>2018-06-27</td>\n",
       "      <td>2128</td>\n",
       "      <td>2159</td>\n",
       "      <td>41.3</td>\n",
       "      <td>26.8</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>d4</td>\n",
       "      <td>d6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.8</td>\n",
       "      <td>41.3</td>\n",
       "      <td>0.769976</td>\n",
       "      <td>374.604</td>\n",
       "      <td>486.514</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>Alekhine Defense, Saemisch Attack</td>\n",
       "      <td>white</td>\n",
       "      <td>1452</td>\n",
       "      <td>B02</td>\n",
       "      <td>2018-07-06</td>\n",
       "      <td>2244</td>\n",
       "      <td>2212</td>\n",
       "      <td>37.0</td>\n",
       "      <td>29.9</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>Nc3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37.0</td>\n",
       "      <td>33.1</td>\n",
       "      <td>1.117825</td>\n",
       "      <td>537.240</td>\n",
       "      <td>480.612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>Alekhine Defense, Scandinavian Variation</td>\n",
       "      <td>black</td>\n",
       "      <td>4898</td>\n",
       "      <td>B02</td>\n",
       "      <td>2018-06-24</td>\n",
       "      <td>2133</td>\n",
       "      <td>2153</td>\n",
       "      <td>39.4</td>\n",
       "      <td>28.4</td>\n",
       "      <td>...</td>\n",
       "      <td>d5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32.2</td>\n",
       "      <td>39.4</td>\n",
       "      <td>0.817259</td>\n",
       "      <td>1577.156</td>\n",
       "      <td>1929.812</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>Alekhine Defense, Spielmann Gambit</td>\n",
       "      <td>white</td>\n",
       "      <td>140</td>\n",
       "      <td>B02</td>\n",
       "      <td>2017-11-19</td>\n",
       "      <td>2260</td>\n",
       "      <td>2208</td>\n",
       "      <td>40.0</td>\n",
       "      <td>17.9</td>\n",
       "      <td>...</td>\n",
       "      <td>d5</td>\n",
       "      <td>e5</td>\n",
       "      <td>Nfd7</td>\n",
       "      <td>e6</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.0</td>\n",
       "      <td>42.1</td>\n",
       "      <td>0.950119</td>\n",
       "      <td>56.000</td>\n",
       "      <td>58.940</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>Alekhine Defense, Two Pawn Attack</td>\n",
       "      <td>white</td>\n",
       "      <td>397</td>\n",
       "      <td>B02</td>\n",
       "      <td>2018-06-23</td>\n",
       "      <td>1981</td>\n",
       "      <td>1958</td>\n",
       "      <td>36.0</td>\n",
       "      <td>18.4</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>c4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36.0</td>\n",
       "      <td>45.6</td>\n",
       "      <td>0.789474</td>\n",
       "      <td>142.920</td>\n",
       "      <td>181.032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>Alekhine Defense, Two Pawn Attack, Lasker Vari...</td>\n",
       "      <td>white</td>\n",
       "      <td>964</td>\n",
       "      <td>B02</td>\n",
       "      <td>2018-06-30</td>\n",
       "      <td>2209</td>\n",
       "      <td>2202</td>\n",
       "      <td>32.9</td>\n",
       "      <td>30.3</td>\n",
       "      <td>...</td>\n",
       "      <td>Nd5</td>\n",
       "      <td>c4</td>\n",
       "      <td>Nb6</td>\n",
       "      <td>c5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32.9</td>\n",
       "      <td>36.8</td>\n",
       "      <td>0.894022</td>\n",
       "      <td>317.156</td>\n",
       "      <td>354.752</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>Anderssen Opening, General</td>\n",
       "      <td>white</td>\n",
       "      <td>1308</td>\n",
       "      <td>A00</td>\n",
       "      <td>2018-06-25</td>\n",
       "      <td>2124</td>\n",
       "      <td>2126</td>\n",
       "      <td>35.7</td>\n",
       "      <td>25.6</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.7</td>\n",
       "      <td>38.7</td>\n",
       "      <td>0.922481</td>\n",
       "      <td>466.956</td>\n",
       "      <td>506.196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>Benko Gambit, Accepted, Central Storming Varia...</td>\n",
       "      <td>white</td>\n",
       "      <td>209</td>\n",
       "      <td>A57</td>\n",
       "      <td>2018-02-01</td>\n",
       "      <td>2265</td>\n",
       "      <td>2245</td>\n",
       "      <td>39.2</td>\n",
       "      <td>22.5</td>\n",
       "      <td>...</td>\n",
       "      <td>c5</td>\n",
       "      <td>d5</td>\n",
       "      <td>b5</td>\n",
       "      <td>cxb5</td>\n",
       "      <td>a6</td>\n",
       "      <td>39.2</td>\n",
       "      <td>38.3</td>\n",
       "      <td>1.023499</td>\n",
       "      <td>81.928</td>\n",
       "      <td>80.047</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>Benko Gambit, Accepted, Dlugy Variation</td>\n",
       "      <td>white</td>\n",
       "      <td>1526</td>\n",
       "      <td>A57</td>\n",
       "      <td>2018-06-24</td>\n",
       "      <td>2290</td>\n",
       "      <td>2271</td>\n",
       "      <td>42.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>...</td>\n",
       "      <td>c5</td>\n",
       "      <td>d5</td>\n",
       "      <td>b5</td>\n",
       "      <td>cxb5</td>\n",
       "      <td>a6</td>\n",
       "      <td>42.0</td>\n",
       "      <td>33.0</td>\n",
       "      <td>1.272727</td>\n",
       "      <td>640.920</td>\n",
       "      <td>503.580</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",
       "      <td>...</td>\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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1854</th>\n",
       "      <td>1854</td>\n",
       "      <td>Vienna Game, Vienna Gambit, Breyer Variation</td>\n",
       "      <td>black</td>\n",
       "      <td>546</td>\n",
       "      <td>C29</td>\n",
       "      <td>2018-07-06</td>\n",
       "      <td>2235</td>\n",
       "      <td>2259</td>\n",
       "      <td>34.6</td>\n",
       "      <td>31.1</td>\n",
       "      <td>...</td>\n",
       "      <td>Nf6</td>\n",
       "      <td>f4</td>\n",
       "      <td>d5</td>\n",
       "      <td>fxe5</td>\n",
       "      <td>Nxe4</td>\n",
       "      <td>34.3</td>\n",
       "      <td>34.6</td>\n",
       "      <td>0.991329</td>\n",
       "      <td>187.278</td>\n",
       "      <td>188.916</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1855</th>\n",
       "      <td>1855</td>\n",
       "      <td>Vienna Game, Vienna Gambit, Kaufmann Variation</td>\n",
       "      <td>white</td>\n",
       "      <td>102</td>\n",
       "      <td>C29</td>\n",
       "      <td>2018-06-26</td>\n",
       "      <td>2321</td>\n",
       "      <td>2225</td>\n",
       "      <td>48.0</td>\n",
       "      <td>29.4</td>\n",
       "      <td>...</td>\n",
       "      <td>Nf6</td>\n",
       "      <td>f4</td>\n",
       "      <td>d5</td>\n",
       "      <td>fxe5</td>\n",
       "      <td>Nxe4</td>\n",
       "      <td>48.0</td>\n",
       "      <td>22.6</td>\n",
       "      <td>2.123894</td>\n",
       "      <td>48.960</td>\n",
       "      <td>23.052</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1856</th>\n",
       "      <td>1856</td>\n",
       "      <td>Vienna Game, Vienna Gambit, Main Line</td>\n",
       "      <td>black</td>\n",
       "      <td>865</td>\n",
       "      <td>C29</td>\n",
       "      <td>2018-07-09</td>\n",
       "      <td>2179</td>\n",
       "      <td>2193</td>\n",
       "      <td>39.4</td>\n",
       "      <td>24.2</td>\n",
       "      <td>...</td>\n",
       "      <td>Nf6</td>\n",
       "      <td>f4</td>\n",
       "      <td>d5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36.4</td>\n",
       "      <td>39.4</td>\n",
       "      <td>0.923858</td>\n",
       "      <td>314.860</td>\n",
       "      <td>340.810</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1857</th>\n",
       "      <td>1857</td>\n",
       "      <td>Vienna Game, Vienna Gambit, Modern Variation</td>\n",
       "      <td>white</td>\n",
       "      <td>523</td>\n",
       "      <td>C29</td>\n",
       "      <td>2018-07-01</td>\n",
       "      <td>2189</td>\n",
       "      <td>2159</td>\n",
       "      <td>33.6</td>\n",
       "      <td>26.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Nf6</td>\n",
       "      <td>f4</td>\n",
       "      <td>d5</td>\n",
       "      <td>fxe5</td>\n",
       "      <td>Nxe4</td>\n",
       "      <td>33.6</td>\n",
       "      <td>40.3</td>\n",
       "      <td>0.833747</td>\n",
       "      <td>175.728</td>\n",
       "      <td>210.769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1858</th>\n",
       "      <td>1858</td>\n",
       "      <td>Vienna Game, Vienna Gambit, Paulsen Attack</td>\n",
       "      <td>white</td>\n",
       "      <td>251</td>\n",
       "      <td>C29</td>\n",
       "      <td>2018-06-24</td>\n",
       "      <td>2278</td>\n",
       "      <td>2200</td>\n",
       "      <td>43.8</td>\n",
       "      <td>28.7</td>\n",
       "      <td>...</td>\n",
       "      <td>Nf6</td>\n",
       "      <td>f4</td>\n",
       "      <td>d5</td>\n",
       "      <td>fxe5</td>\n",
       "      <td>Nxe4</td>\n",
       "      <td>43.8</td>\n",
       "      <td>27.5</td>\n",
       "      <td>1.592727</td>\n",
       "      <td>109.938</td>\n",
       "      <td>69.025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1859</th>\n",
       "      <td>1859</td>\n",
       "      <td>Vienna Game, Vienna Gambit, Steinitz Gambit, K...</td>\n",
       "      <td>white</td>\n",
       "      <td>191</td>\n",
       "      <td>C25</td>\n",
       "      <td>2018-04-01</td>\n",
       "      <td>2137</td>\n",
       "      <td>2113</td>\n",
       "      <td>44.0</td>\n",
       "      <td>22.5</td>\n",
       "      <td>...</td>\n",
       "      <td>Nc6</td>\n",
       "      <td>f4</td>\n",
       "      <td>exf4</td>\n",
       "      <td>Nf3</td>\n",
       "      <td>NaN</td>\n",
       "      <td>44.0</td>\n",
       "      <td>33.5</td>\n",
       "      <td>1.313433</td>\n",
       "      <td>84.040</td>\n",
       "      <td>63.985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1860</th>\n",
       "      <td>1860</td>\n",
       "      <td>Wade Defense, General</td>\n",
       "      <td>black</td>\n",
       "      <td>5081</td>\n",
       "      <td>A41</td>\n",
       "      <td>2018-07-07</td>\n",
       "      <td>2295</td>\n",
       "      <td>2337</td>\n",
       "      <td>28.6</td>\n",
       "      <td>35.0</td>\n",
       "      <td>...</td>\n",
       "      <td>Bg4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36.4</td>\n",
       "      <td>28.6</td>\n",
       "      <td>1.272727</td>\n",
       "      <td>1849.484</td>\n",
       "      <td>1453.166</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1861</th>\n",
       "      <td>1861</td>\n",
       "      <td>Zukertort Opening, Black Mustang Defense</td>\n",
       "      <td>black</td>\n",
       "      <td>1035</td>\n",
       "      <td>A04</td>\n",
       "      <td>2018-07-08</td>\n",
       "      <td>1986</td>\n",
       "      <td>1992</td>\n",
       "      <td>31.0</td>\n",
       "      <td>22.7</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>46.3</td>\n",
       "      <td>31.0</td>\n",
       "      <td>1.493548</td>\n",
       "      <td>479.205</td>\n",
       "      <td>320.850</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1862</th>\n",
       "      <td>1862</td>\n",
       "      <td>Zukertort Opening, Double Fianchetto Attack</td>\n",
       "      <td>white</td>\n",
       "      <td>249</td>\n",
       "      <td>A49</td>\n",
       "      <td>2018-06-18</td>\n",
       "      <td>2209</td>\n",
       "      <td>2199</td>\n",
       "      <td>38.5</td>\n",
       "      <td>27.7</td>\n",
       "      <td>...</td>\n",
       "      <td>g6</td>\n",
       "      <td>Bb2</td>\n",
       "      <td>Bg7</td>\n",
       "      <td>g3</td>\n",
       "      <td>O-O</td>\n",
       "      <td>38.5</td>\n",
       "      <td>33.7</td>\n",
       "      <td>1.142433</td>\n",
       "      <td>95.865</td>\n",
       "      <td>83.913</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1863</th>\n",
       "      <td>1863</td>\n",
       "      <td>Zukertort Opening, Dutch Variation</td>\n",
       "      <td>black</td>\n",
       "      <td>6773</td>\n",
       "      <td>A04</td>\n",
       "      <td>2018-07-09</td>\n",
       "      <td>2212</td>\n",
       "      <td>2246</td>\n",
       "      <td>27.7</td>\n",
       "      <td>29.7</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42.6</td>\n",
       "      <td>27.7</td>\n",
       "      <td>1.537906</td>\n",
       "      <td>2885.298</td>\n",
       "      <td>1876.121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1864</th>\n",
       "      <td>1864</td>\n",
       "      <td>Zukertort Opening, Grünfeld Reversed</td>\n",
       "      <td>white</td>\n",
       "      <td>852</td>\n",
       "      <td>A49</td>\n",
       "      <td>2018-06-24</td>\n",
       "      <td>2345</td>\n",
       "      <td>2299</td>\n",
       "      <td>45.4</td>\n",
       "      <td>34.3</td>\n",
       "      <td>...</td>\n",
       "      <td>d5</td>\n",
       "      <td>Bg2</td>\n",
       "      <td>Nc6</td>\n",
       "      <td>d4</td>\n",
       "      <td>e6</td>\n",
       "      <td>45.4</td>\n",
       "      <td>20.3</td>\n",
       "      <td>2.236453</td>\n",
       "      <td>386.808</td>\n",
       "      <td>172.956</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1865</th>\n",
       "      <td>1865</td>\n",
       "      <td>Zukertort Opening, Kingside Fianchetto</td>\n",
       "      <td>black</td>\n",
       "      <td>8899</td>\n",
       "      <td>A04</td>\n",
       "      <td>2018-07-08</td>\n",
       "      <td>2265</td>\n",
       "      <td>2292</td>\n",
       "      <td>34.3</td>\n",
       "      <td>30.9</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34.8</td>\n",
       "      <td>34.3</td>\n",
       "      <td>1.014577</td>\n",
       "      <td>3096.852</td>\n",
       "      <td>3052.357</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1866</th>\n",
       "      <td>1866</td>\n",
       "      <td>Zukertort Opening, Lisitsyn Gambit Deferred</td>\n",
       "      <td>white</td>\n",
       "      <td>306</td>\n",
       "      <td>A04</td>\n",
       "      <td>2018-06-27</td>\n",
       "      <td>2295</td>\n",
       "      <td>2261</td>\n",
       "      <td>58.5</td>\n",
       "      <td>20.6</td>\n",
       "      <td>...</td>\n",
       "      <td>Nf6</td>\n",
       "      <td>e4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>58.5</td>\n",
       "      <td>20.9</td>\n",
       "      <td>2.799043</td>\n",
       "      <td>179.010</td>\n",
       "      <td>63.954</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1867</th>\n",
       "      <td>1867</td>\n",
       "      <td>Zukertort Opening, Lisitsyn Gambit</td>\n",
       "      <td>white</td>\n",
       "      <td>637</td>\n",
       "      <td>A04</td>\n",
       "      <td>2018-05-11</td>\n",
       "      <td>2258</td>\n",
       "      <td>2232</td>\n",
       "      <td>41.9</td>\n",
       "      <td>24.2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>41.9</td>\n",
       "      <td>33.9</td>\n",
       "      <td>1.235988</td>\n",
       "      <td>266.903</td>\n",
       "      <td>215.943</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1868</th>\n",
       "      <td>1868</td>\n",
       "      <td>Zukertort Opening, Nimzo-Larsen Variation</td>\n",
       "      <td>white</td>\n",
       "      <td>5579</td>\n",
       "      <td>A04</td>\n",
       "      <td>2018-07-02</td>\n",
       "      <td>2220</td>\n",
       "      <td>2209</td>\n",
       "      <td>34.8</td>\n",
       "      <td>32.7</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34.8</td>\n",
       "      <td>32.5</td>\n",
       "      <td>1.070769</td>\n",
       "      <td>1941.492</td>\n",
       "      <td>1813.175</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1869</th>\n",
       "      <td>1869</td>\n",
       "      <td>Zukertort Opening, Old Indian Attack</td>\n",
       "      <td>white</td>\n",
       "      <td>747</td>\n",
       "      <td>A06</td>\n",
       "      <td>2018-07-06</td>\n",
       "      <td>2140</td>\n",
       "      <td>2133</td>\n",
       "      <td>37.0</td>\n",
       "      <td>24.1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37.0</td>\n",
       "      <td>39.0</td>\n",
       "      <td>0.948718</td>\n",
       "      <td>276.390</td>\n",
       "      <td>291.330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1870</th>\n",
       "      <td>1870</td>\n",
       "      <td>Zukertort Opening, Pirc Invitation</td>\n",
       "      <td>black</td>\n",
       "      <td>3309</td>\n",
       "      <td>A04</td>\n",
       "      <td>2018-06-30</td>\n",
       "      <td>2199</td>\n",
       "      <td>2223</td>\n",
       "      <td>33.7</td>\n",
       "      <td>27.4</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>38.9</td>\n",
       "      <td>33.7</td>\n",
       "      <td>1.154303</td>\n",
       "      <td>1287.201</td>\n",
       "      <td>1115.133</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1871</th>\n",
       "      <td>1871</td>\n",
       "      <td>Zukertort Opening, Polish Defense</td>\n",
       "      <td>black</td>\n",
       "      <td>572</td>\n",
       "      <td>A04</td>\n",
       "      <td>2018-06-16</td>\n",
       "      <td>2229</td>\n",
       "      <td>2266</td>\n",
       "      <td>32.5</td>\n",
       "      <td>28.7</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>38.8</td>\n",
       "      <td>32.5</td>\n",
       "      <td>1.193846</td>\n",
       "      <td>221.936</td>\n",
       "      <td>185.900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1872</th>\n",
       "      <td>1872</td>\n",
       "      <td>Zukertort Opening, Queen Pawn Defense</td>\n",
       "      <td>black</td>\n",
       "      <td>1832</td>\n",
       "      <td>A06</td>\n",
       "      <td>2018-07-09</td>\n",
       "      <td>2262</td>\n",
       "      <td>2276</td>\n",
       "      <td>28.6</td>\n",
       "      <td>33.5</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37.9</td>\n",
       "      <td>28.6</td>\n",
       "      <td>1.325175</td>\n",
       "      <td>694.328</td>\n",
       "      <td>523.952</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1873</th>\n",
       "      <td>1873</td>\n",
       "      <td>Zukertort Opening, Queen's Gambit Invitation</td>\n",
       "      <td>black</td>\n",
       "      <td>3596</td>\n",
       "      <td>A04</td>\n",
       "      <td>2018-07-08</td>\n",
       "      <td>2163</td>\n",
       "      <td>2195</td>\n",
       "      <td>26.4</td>\n",
       "      <td>27.2</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>46.4</td>\n",
       "      <td>26.4</td>\n",
       "      <td>1.757576</td>\n",
       "      <td>1668.544</td>\n",
       "      <td>949.344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1874</th>\n",
       "      <td>1874</td>\n",
       "      <td>Zukertort Opening, Queenside Fianchetto Variation</td>\n",
       "      <td>black</td>\n",
       "      <td>1434</td>\n",
       "      <td>A04</td>\n",
       "      <td>2018-07-08</td>\n",
       "      <td>2193</td>\n",
       "      <td>2237</td>\n",
       "      <td>29.3</td>\n",
       "      <td>30.4</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>40.3</td>\n",
       "      <td>29.3</td>\n",
       "      <td>1.375427</td>\n",
       "      <td>577.902</td>\n",
       "      <td>420.162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1875</th>\n",
       "      <td>1875</td>\n",
       "      <td>Zukertort Opening, Quiet system</td>\n",
       "      <td>white</td>\n",
       "      <td>895</td>\n",
       "      <td>A04</td>\n",
       "      <td>2018-07-09</td>\n",
       "      <td>2254</td>\n",
       "      <td>2253</td>\n",
       "      <td>35.2</td>\n",
       "      <td>31.6</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.2</td>\n",
       "      <td>33.2</td>\n",
       "      <td>1.060241</td>\n",
       "      <td>315.040</td>\n",
       "      <td>297.140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1876</th>\n",
       "      <td>1876</td>\n",
       "      <td>Zukertort Opening, Reversed Mexican Defense</td>\n",
       "      <td>white</td>\n",
       "      <td>120</td>\n",
       "      <td>A06</td>\n",
       "      <td>2018-06-27</td>\n",
       "      <td>2104</td>\n",
       "      <td>2168</td>\n",
       "      <td>32.5</td>\n",
       "      <td>22.5</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32.5</td>\n",
       "      <td>45.0</td>\n",
       "      <td>0.722222</td>\n",
       "      <td>39.000</td>\n",
       "      <td>54.000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1877</th>\n",
       "      <td>1877</td>\n",
       "      <td>Zukertort Opening, Reversed Queen's Gambit</td>\n",
       "      <td>black</td>\n",
       "      <td>2316</td>\n",
       "      <td>D02</td>\n",
       "      <td>2018-06-25</td>\n",
       "      <td>2200</td>\n",
       "      <td>2217</td>\n",
       "      <td>34.9</td>\n",
       "      <td>29.5</td>\n",
       "      <td>...</td>\n",
       "      <td>c5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>35.5</td>\n",
       "      <td>34.9</td>\n",
       "      <td>1.017192</td>\n",
       "      <td>822.180</td>\n",
       "      <td>808.284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1878</th>\n",
       "      <td>1878</td>\n",
       "      <td>Zukertort Opening, Santasiere's Folly</td>\n",
       "      <td>white</td>\n",
       "      <td>262</td>\n",
       "      <td>A06</td>\n",
       "      <td>2018-06-17</td>\n",
       "      <td>2125</td>\n",
       "      <td>2155</td>\n",
       "      <td>32.8</td>\n",
       "      <td>29.4</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32.8</td>\n",
       "      <td>37.8</td>\n",
       "      <td>0.867725</td>\n",
       "      <td>85.936</td>\n",
       "      <td>99.036</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1879</th>\n",
       "      <td>1879</td>\n",
       "      <td>Zukertort Opening, Sicilian Invitation</td>\n",
       "      <td>black</td>\n",
       "      <td>20045</td>\n",
       "      <td>A04</td>\n",
       "      <td>2018-07-09</td>\n",
       "      <td>2274</td>\n",
       "      <td>2293</td>\n",
       "      <td>31.4</td>\n",
       "      <td>33.9</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>34.7</td>\n",
       "      <td>31.4</td>\n",
       "      <td>1.105096</td>\n",
       "      <td>6955.615</td>\n",
       "      <td>6294.130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1880</th>\n",
       "      <td>1880</td>\n",
       "      <td>Zukertort Opening, Slav Invitation</td>\n",
       "      <td>black</td>\n",
       "      <td>463</td>\n",
       "      <td>A04</td>\n",
       "      <td>2018-07-05</td>\n",
       "      <td>2031</td>\n",
       "      <td>2025</td>\n",
       "      <td>27.0</td>\n",
       "      <td>26.1</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>46.9</td>\n",
       "      <td>27.0</td>\n",
       "      <td>1.737037</td>\n",
       "      <td>217.147</td>\n",
       "      <td>125.010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1881</th>\n",
       "      <td>1881</td>\n",
       "      <td>Zukertort Opening, Symmetrical Variation</td>\n",
       "      <td>black</td>\n",
       "      <td>15625</td>\n",
       "      <td>A04</td>\n",
       "      <td>2018-07-09</td>\n",
       "      <td>2235</td>\n",
       "      <td>2257</td>\n",
       "      <td>28.4</td>\n",
       "      <td>34.4</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>37.1</td>\n",
       "      <td>28.4</td>\n",
       "      <td>1.306338</td>\n",
       "      <td>5796.875</td>\n",
       "      <td>4437.500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1882</th>\n",
       "      <td>1882</td>\n",
       "      <td>Zukertort Opening, Tennison Gambit</td>\n",
       "      <td>white</td>\n",
       "      <td>139</td>\n",
       "      <td>A06</td>\n",
       "      <td>2018-05-19</td>\n",
       "      <td>1936</td>\n",
       "      <td>1976</td>\n",
       "      <td>36.7</td>\n",
       "      <td>19.4</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36.7</td>\n",
       "      <td>43.9</td>\n",
       "      <td>0.835991</td>\n",
       "      <td>51.013</td>\n",
       "      <td>61.021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1883</th>\n",
       "      <td>1883</td>\n",
       "      <td>Zukertort Opening, Wade Defense, Chigorin Plan</td>\n",
       "      <td>black</td>\n",
       "      <td>217</td>\n",
       "      <td>A41</td>\n",
       "      <td>2018-02-10</td>\n",
       "      <td>2307</td>\n",
       "      <td>2380</td>\n",
       "      <td>21.7</td>\n",
       "      <td>34.1</td>\n",
       "      <td>...</td>\n",
       "      <td>Bg4</td>\n",
       "      <td>c4</td>\n",
       "      <td>Nd7</td>\n",
       "      <td>Qb3</td>\n",
       "      <td>Rb8</td>\n",
       "      <td>44.2</td>\n",
       "      <td>21.7</td>\n",
       "      <td>2.036866</td>\n",
       "      <td>95.914</td>\n",
       "      <td>47.089</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1884 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0                                            Opening Colour  \\\n",
       "0              0                 Alekhine Defense, Balogh Variation  white   \n",
       "1              1               Alekhine Defense, Brooklyn Variation  black   \n",
       "2              2               Alekhine Defense, Exchange Variation  white   \n",
       "3              3                Alekhine Defense, Four Pawns Attack  white   \n",
       "4              4  Alekhine Defense, Four Pawns Attack, Fianchett...  black   \n",
       "5              5     Alekhine Defense, Four Pawns Attack, Main Line  white   \n",
       "6              6  Alekhine Defense, Four Pawns Attack, Trifunovi...  black   \n",
       "7              7                          Alekhine Defense, General  black   \n",
       "8              8  Alekhine Defense, Hunt Variation, Lasker Simul...  white   \n",
       "9              9                Alekhine Defense, Maroczy Variation  white   \n",
       "10            10                 Alekhine Defense, Modern Variation  white   \n",
       "11            11  Alekhine Defense, Modern Variation, Alburt Var...  black   \n",
       "12            12  Alekhine Defense, Modern Variation, Alekhine G...  white   \n",
       "13            13  Alekhine Defense, Modern Variation, Keres Vari...  white   \n",
       "14            14  Alekhine Defense, Modern Variation, Larsen Var...  black   \n",
       "15            15  Alekhine Defense, Modern Variation, Larsen Var...  black   \n",
       "16            16  Alekhine Defense, Modern Variation, Larsen-Haa...  black   \n",
       "17            17      Alekhine Defense, Modern Variation, Main Line  black   \n",
       "18            18  Alekhine Defense, Modern Variation, Panov Vari...  white   \n",
       "19            19  Alekhine Defense, Modern Variation, Schmid Var...  black   \n",
       "20            20                 Alekhine Defense, Normal Variation  black   \n",
       "21            21                 Alekhine Defense, Normal Variation  black   \n",
       "22            22                  Alekhine Defense, Saemisch Attack  white   \n",
       "23            23           Alekhine Defense, Scandinavian Variation  black   \n",
       "24            24                 Alekhine Defense, Spielmann Gambit  white   \n",
       "25            25                  Alekhine Defense, Two Pawn Attack  white   \n",
       "26            26  Alekhine Defense, Two Pawn Attack, Lasker Vari...  white   \n",
       "27            27                         Anderssen Opening, General  white   \n",
       "28            28  Benko Gambit, Accepted, Central Storming Varia...  white   \n",
       "29            29            Benko Gambit, Accepted, Dlugy Variation  white   \n",
       "...          ...                                                ...    ...   \n",
       "1854        1854       Vienna Game, Vienna Gambit, Breyer Variation  black   \n",
       "1855        1855     Vienna Game, Vienna Gambit, Kaufmann Variation  white   \n",
       "1856        1856              Vienna Game, Vienna Gambit, Main Line  black   \n",
       "1857        1857       Vienna Game, Vienna Gambit, Modern Variation  white   \n",
       "1858        1858         Vienna Game, Vienna Gambit, Paulsen Attack  white   \n",
       "1859        1859  Vienna Game, Vienna Gambit, Steinitz Gambit, K...  white   \n",
       "1860        1860                              Wade Defense, General  black   \n",
       "1861        1861           Zukertort Opening, Black Mustang Defense  black   \n",
       "1862        1862        Zukertort Opening, Double Fianchetto Attack  white   \n",
       "1863        1863                 Zukertort Opening, Dutch Variation  black   \n",
       "1864        1864               Zukertort Opening, Grünfeld Reversed  white   \n",
       "1865        1865             Zukertort Opening, Kingside Fianchetto  black   \n",
       "1866        1866        Zukertort Opening, Lisitsyn Gambit Deferred  white   \n",
       "1867        1867                 Zukertort Opening, Lisitsyn Gambit  white   \n",
       "1868        1868          Zukertort Opening, Nimzo-Larsen Variation  white   \n",
       "1869        1869               Zukertort Opening, Old Indian Attack  white   \n",
       "1870        1870                 Zukertort Opening, Pirc Invitation  black   \n",
       "1871        1871                  Zukertort Opening, Polish Defense  black   \n",
       "1872        1872              Zukertort Opening, Queen Pawn Defense  black   \n",
       "1873        1873       Zukertort Opening, Queen's Gambit Invitation  black   \n",
       "1874        1874  Zukertort Opening, Queenside Fianchetto Variation  black   \n",
       "1875        1875                    Zukertort Opening, Quiet system  white   \n",
       "1876        1876        Zukertort Opening, Reversed Mexican Defense  white   \n",
       "1877        1877         Zukertort Opening, Reversed Queen's Gambit  black   \n",
       "1878        1878              Zukertort Opening, Santasiere's Folly  white   \n",
       "1879        1879             Zukertort Opening, Sicilian Invitation  black   \n",
       "1880        1880                 Zukertort Opening, Slav Invitation  black   \n",
       "1881        1881           Zukertort Opening, Symmetrical Variation  black   \n",
       "1882        1882                 Zukertort Opening, Tennison Gambit  white   \n",
       "1883        1883     Zukertort Opening, Wade Defense, Chigorin Plan  black   \n",
       "\n",
       "      Num Games  ECO Last Played  Perf Rating  Avg Player  Player Win %  \\\n",
       "0           692  B03  2018-06-22         2247        2225          40.8   \n",
       "1           228  B02  2018-06-27         2145        2193          29.8   \n",
       "2          6485  B03  2018-07-06         2244        2194          40.8   \n",
       "3           881  B03  2018-06-20         2187        2130          39.7   \n",
       "4           259  B03  2018-05-20         2122        2178          37.8   \n",
       "5          1207  B03  2018-07-01         2243        2190          41.0   \n",
       "6           323  B03  2018-05-10         2231        2277          35.9   \n",
       "7           524  B02  2018-06-29         2032        2077          42.2   \n",
       "8           334  B02  2018-06-27         2205        2178          34.1   \n",
       "9           931  B02  2018-07-09         2174        2174          36.6   \n",
       "10          501  B04  2018-06-25         2397        2336          43.5   \n",
       "11         2626  B04  2018-06-30         2250        2294          28.3   \n",
       "12          120  B04  2018-06-11         2097        2081          36.7   \n",
       "13          269  B04  2018-03-04         2442        2383          45.7   \n",
       "14         1187  B04  2018-06-21         2243        2283          22.8   \n",
       "15         1481  B04  2018-06-18         2273        2306          25.9   \n",
       "16          685  B04  2018-06-25         2171        2193          32.3   \n",
       "17         5096  B05  2018-07-02         2209        2269          25.1   \n",
       "18          183  B05  2018-05-31         2305        2269          44.3   \n",
       "19          688  B04  2018-07-04         2300        2333          31.7   \n",
       "20          981  B02  2018-06-30         2142        2173          34.0   \n",
       "21         1178  B03  2018-06-27         2128        2159          41.3   \n",
       "22         1452  B02  2018-07-06         2244        2212          37.0   \n",
       "23         4898  B02  2018-06-24         2133        2153          39.4   \n",
       "24          140  B02  2017-11-19         2260        2208          40.0   \n",
       "25          397  B02  2018-06-23         1981        1958          36.0   \n",
       "26          964  B02  2018-06-30         2209        2202          32.9   \n",
       "27         1308  A00  2018-06-25         2124        2126          35.7   \n",
       "28          209  A57  2018-02-01         2265        2245          39.2   \n",
       "29         1526  A57  2018-06-24         2290        2271          42.0   \n",
       "...         ...  ...         ...          ...         ...           ...   \n",
       "1854        546  C29  2018-07-06         2235        2259          34.6   \n",
       "1855        102  C29  2018-06-26         2321        2225          48.0   \n",
       "1856        865  C29  2018-07-09         2179        2193          39.4   \n",
       "1857        523  C29  2018-07-01         2189        2159          33.6   \n",
       "1858        251  C29  2018-06-24         2278        2200          43.8   \n",
       "1859        191  C25  2018-04-01         2137        2113          44.0   \n",
       "1860       5081  A41  2018-07-07         2295        2337          28.6   \n",
       "1861       1035  A04  2018-07-08         1986        1992          31.0   \n",
       "1862        249  A49  2018-06-18         2209        2199          38.5   \n",
       "1863       6773  A04  2018-07-09         2212        2246          27.7   \n",
       "1864        852  A49  2018-06-24         2345        2299          45.4   \n",
       "1865       8899  A04  2018-07-08         2265        2292          34.3   \n",
       "1866        306  A04  2018-06-27         2295        2261          58.5   \n",
       "1867        637  A04  2018-05-11         2258        2232          41.9   \n",
       "1868       5579  A04  2018-07-02         2220        2209          34.8   \n",
       "1869        747  A06  2018-07-06         2140        2133          37.0   \n",
       "1870       3309  A04  2018-06-30         2199        2223          33.7   \n",
       "1871        572  A04  2018-06-16         2229        2266          32.5   \n",
       "1872       1832  A06  2018-07-09         2262        2276          28.6   \n",
       "1873       3596  A04  2018-07-08         2163        2195          26.4   \n",
       "1874       1434  A04  2018-07-08         2193        2237          29.3   \n",
       "1875        895  A04  2018-07-09         2254        2253          35.2   \n",
       "1876        120  A06  2018-06-27         2104        2168          32.5   \n",
       "1877       2316  D02  2018-06-25         2200        2217          34.9   \n",
       "1878        262  A06  2018-06-17         2125        2155          32.8   \n",
       "1879      20045  A04  2018-07-09         2274        2293          31.4   \n",
       "1880        463  A04  2018-07-05         2031        2025          27.0   \n",
       "1881      15625  A04  2018-07-09         2235        2257          28.4   \n",
       "1882        139  A06  2018-05-19         1936        1976          36.7   \n",
       "1883        217  A41  2018-02-10         2307        2380          21.7   \n",
       "\n",
       "      Draw %    ...      move2b move3w move3b move4w move4b White_win%  \\\n",
       "0       24.3    ...         Nd5     d4     d6    Bc4    NaN       40.8   \n",
       "1       22.4    ...         Ng8    NaN    NaN    NaN    NaN       47.8   \n",
       "2       27.7    ...         Nd5     d4     d6     c4    Nb6       40.8   \n",
       "3       23.2    ...         Nd5     d4     d6     c4    Nb6       39.7   \n",
       "4       21.2    ...         Nd5     d4     d6     c4    Nb6       40.9   \n",
       "5       25.9    ...         Nd5     d4     d6     c4    Nb6       41.0   \n",
       "6       24.8    ...         Nd5     d4     d6     c4    Nb6       39.3   \n",
       "7       25.0    ...         NaN    NaN    NaN    NaN    NaN       32.8   \n",
       "8       23.6    ...         Nd5     c4    Nb6     c5    Nd5       34.1   \n",
       "9       25.7    ...         NaN    NaN    NaN    NaN    NaN       36.6   \n",
       "10      31.7    ...         Nd5     d4     d6    Nf3    NaN       43.5   \n",
       "11      30.3    ...         Nd5     d4     d6    Nf3     g6       41.4   \n",
       "12      22.5    ...         Nd5     d4     d6    Nf3    Bg4       36.7   \n",
       "13      36.4    ...         Nd5     d4     d6    Nf3     g6       45.7   \n",
       "14      35.7    ...         Nd5     d4     d6    Nf3   dxe5       41.5   \n",
       "15      35.9    ...         Nd5     d4     d6    Nf3   dxe5       38.2   \n",
       "16      21.5    ...         Nd5     d4     d6    Nf3    Nc6       46.3   \n",
       "17      30.2    ...         Nd5     d4     d6    Nf3    Bg4       44.8   \n",
       "18      22.4    ...         Nd5     d4     d6    Nf3    Bg4       44.3   \n",
       "19      34.3    ...         Nd5     d4     d6    Nf3    Nb6       34.0   \n",
       "20      26.7    ...         Nd5    NaN    NaN    NaN    NaN       39.3   \n",
       "21      26.8    ...         Nd5     d4     d6    NaN    NaN       31.8   \n",
       "22      29.9    ...         Nd5    Nc3    NaN    NaN    NaN       37.0   \n",
       "23      28.4    ...          d5    NaN    NaN    NaN    NaN       32.2   \n",
       "24      17.9    ...          d5     e5   Nfd7     e6    NaN       40.0   \n",
       "25      18.4    ...         Nd5     c4    NaN    NaN    NaN       36.0   \n",
       "26      30.3    ...         Nd5     c4    Nb6     c5    NaN       32.9   \n",
       "27      25.6    ...         NaN    NaN    NaN    NaN    NaN       35.7   \n",
       "28      22.5    ...          c5     d5     b5   cxb5     a6       39.2   \n",
       "29      25.0    ...          c5     d5     b5   cxb5     a6       42.0   \n",
       "...      ...    ...         ...    ...    ...    ...    ...        ...   \n",
       "1854    31.1    ...         Nf6     f4     d5   fxe5   Nxe4       34.3   \n",
       "1855    29.4    ...         Nf6     f4     d5   fxe5   Nxe4       48.0   \n",
       "1856    24.2    ...         Nf6     f4     d5    NaN    NaN       36.4   \n",
       "1857    26.0    ...         Nf6     f4     d5   fxe5   Nxe4       33.6   \n",
       "1858    28.7    ...         Nf6     f4     d5   fxe5   Nxe4       43.8   \n",
       "1859    22.5    ...         Nc6     f4   exf4    Nf3    NaN       44.0   \n",
       "1860    35.0    ...         Bg4    NaN    NaN    NaN    NaN       36.4   \n",
       "1861    22.7    ...         NaN    NaN    NaN    NaN    NaN       46.3   \n",
       "1862    27.7    ...          g6    Bb2    Bg7     g3    O-O       38.5   \n",
       "1863    29.7    ...         NaN    NaN    NaN    NaN    NaN       42.6   \n",
       "1864    34.3    ...          d5    Bg2    Nc6     d4     e6       45.4   \n",
       "1865    30.9    ...         NaN    NaN    NaN    NaN    NaN       34.8   \n",
       "1866    20.6    ...         Nf6     e4    NaN    NaN    NaN       58.5   \n",
       "1867    24.2    ...         NaN    NaN    NaN    NaN    NaN       41.9   \n",
       "1868    32.7    ...         NaN    NaN    NaN    NaN    NaN       34.8   \n",
       "1869    24.1    ...         NaN    NaN    NaN    NaN    NaN       37.0   \n",
       "1870    27.4    ...         NaN    NaN    NaN    NaN    NaN       38.9   \n",
       "1871    28.7    ...         NaN    NaN    NaN    NaN    NaN       38.8   \n",
       "1872    33.5    ...         NaN    NaN    NaN    NaN    NaN       37.9   \n",
       "1873    27.2    ...         NaN    NaN    NaN    NaN    NaN       46.4   \n",
       "1874    30.4    ...         NaN    NaN    NaN    NaN    NaN       40.3   \n",
       "1875    31.6    ...         NaN    NaN    NaN    NaN    NaN       35.2   \n",
       "1876    22.5    ...         NaN    NaN    NaN    NaN    NaN       32.5   \n",
       "1877    29.5    ...          c5    NaN    NaN    NaN    NaN       35.5   \n",
       "1878    29.4    ...         NaN    NaN    NaN    NaN    NaN       32.8   \n",
       "1879    33.9    ...         NaN    NaN    NaN    NaN    NaN       34.7   \n",
       "1880    26.1    ...         NaN    NaN    NaN    NaN    NaN       46.9   \n",
       "1881    34.4    ...         NaN    NaN    NaN    NaN    NaN       37.1   \n",
       "1882    19.4    ...         NaN    NaN    NaN    NaN    NaN       36.7   \n",
       "1883    34.1    ...         Bg4     c4    Nd7    Qb3    Rb8       44.2   \n",
       "\n",
       "     Black_win% White_odds White_Wins Black_Wins  \n",
       "0          35.0   1.165714    282.336    242.200  \n",
       "1          29.8   1.604027    108.984     67.944  \n",
       "2          31.5   1.295238   2645.880   2042.775  \n",
       "3          37.1   1.070081    349.757    326.851  \n",
       "4          37.8   1.082011    105.931     97.902  \n",
       "5          33.1   1.238671    494.870    399.517  \n",
       "6          35.9   1.094708    126.939    115.957  \n",
       "7          42.2   0.777251    171.872    221.128  \n",
       "8          42.2   0.808057    113.894    140.948  \n",
       "9          37.7   0.970822    340.746    350.987  \n",
       "10         24.8   1.754032    217.935    124.248  \n",
       "11         28.3   1.462898   1087.164    743.158  \n",
       "12         40.8   0.899510     44.040     48.960  \n",
       "13         17.8   2.567416    122.933     47.882  \n",
       "14         22.8   1.820175    492.605    270.636  \n",
       "15         25.9   1.474903    565.742    383.579  \n",
       "16         32.3   1.433437    317.155    221.255  \n",
       "17         25.1   1.784861   2283.008   1279.096  \n",
       "18         33.3   1.330330     81.069     60.939  \n",
       "19         31.7   1.072555    233.920    218.096  \n",
       "20         34.0   1.155882    385.533    333.540  \n",
       "21         41.3   0.769976    374.604    486.514  \n",
       "22         33.1   1.117825    537.240    480.612  \n",
       "23         39.4   0.817259   1577.156   1929.812  \n",
       "24         42.1   0.950119     56.000     58.940  \n",
       "25         45.6   0.789474    142.920    181.032  \n",
       "26         36.8   0.894022    317.156    354.752  \n",
       "27         38.7   0.922481    466.956    506.196  \n",
       "28         38.3   1.023499     81.928     80.047  \n",
       "29         33.0   1.272727    640.920    503.580  \n",
       "...         ...        ...        ...        ...  \n",
       "1854       34.6   0.991329    187.278    188.916  \n",
       "1855       22.6   2.123894     48.960     23.052  \n",
       "1856       39.4   0.923858    314.860    340.810  \n",
       "1857       40.3   0.833747    175.728    210.769  \n",
       "1858       27.5   1.592727    109.938     69.025  \n",
       "1859       33.5   1.313433     84.040     63.985  \n",
       "1860       28.6   1.272727   1849.484   1453.166  \n",
       "1861       31.0   1.493548    479.205    320.850  \n",
       "1862       33.7   1.142433     95.865     83.913  \n",
       "1863       27.7   1.537906   2885.298   1876.121  \n",
       "1864       20.3   2.236453    386.808    172.956  \n",
       "1865       34.3   1.014577   3096.852   3052.357  \n",
       "1866       20.9   2.799043    179.010     63.954  \n",
       "1867       33.9   1.235988    266.903    215.943  \n",
       "1868       32.5   1.070769   1941.492   1813.175  \n",
       "1869       39.0   0.948718    276.390    291.330  \n",
       "1870       33.7   1.154303   1287.201   1115.133  \n",
       "1871       32.5   1.193846    221.936    185.900  \n",
       "1872       28.6   1.325175    694.328    523.952  \n",
       "1873       26.4   1.757576   1668.544    949.344  \n",
       "1874       29.3   1.375427    577.902    420.162  \n",
       "1875       33.2   1.060241    315.040    297.140  \n",
       "1876       45.0   0.722222     39.000     54.000  \n",
       "1877       34.9   1.017192    822.180    808.284  \n",
       "1878       37.8   0.867725     85.936     99.036  \n",
       "1879       31.4   1.105096   6955.615   6294.130  \n",
       "1880       27.0   1.737037    217.147    125.010  \n",
       "1881       28.4   1.306338   5796.875   4437.500  \n",
       "1882       43.9   0.835991     51.013     61.021  \n",
       "1883       21.7   2.036866     95.914     47.089  \n",
       "\n",
       "[1884 rows x 26 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "e4 = df[df['move1w']=='e4'].groupby('move1b').agg({'Num Games': np.sum, 'White_Wins' : np.sum, 'Black_Wins':np.sum})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "e4['White_odds'] = e4['White_Wins'] / e4['Black_Wins']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>Num Games</th>\n",
       "      <th>White_Wins</th>\n",
       "      <th>Black_Wins</th>\n",
       "      <th>White_odds</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>move1b</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>c5</th>\n",
       "      <td>737822</td>\n",
       "      <td>271864.285</td>\n",
       "      <td>251594.138</td>\n",
       "      <td>1.080567</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>g6</th>\n",
       "      <td>56518</td>\n",
       "      <td>21882.592</td>\n",
       "      <td>19685.018</td>\n",
       "      <td>1.111637</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nc6</th>\n",
       "      <td>9318</td>\n",
       "      <td>3910.606</td>\n",
       "      <td>3241.965</td>\n",
       "      <td>1.206246</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nf6</th>\n",
       "      <td>34710</td>\n",
       "      <td>13577.389</td>\n",
       "      <td>11229.260</td>\n",
       "      <td>1.209108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>e6</th>\n",
       "      <td>228091</td>\n",
       "      <td>89953.946</td>\n",
       "      <td>69003.473</td>\n",
       "      <td>1.303615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>c6</th>\n",
       "      <td>129053</td>\n",
       "      <td>49686.826</td>\n",
       "      <td>37970.724</td>\n",
       "      <td>1.308556</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>d6</th>\n",
       "      <td>68605</td>\n",
       "      <td>28091.144</td>\n",
       "      <td>21004.152</td>\n",
       "      <td>1.337409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>e5</th>\n",
       "      <td>370196</td>\n",
       "      <td>147469.924</td>\n",
       "      <td>105405.333</td>\n",
       "      <td>1.399075</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>d5</th>\n",
       "      <td>51575</td>\n",
       "      <td>21701.516</td>\n",
       "      <td>15505.605</td>\n",
       "      <td>1.399592</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>a6</th>\n",
       "      <td>1283</td>\n",
       "      <td>613.935</td>\n",
       "      <td>420.875</td>\n",
       "      <td>1.458711</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>b6</th>\n",
       "      <td>4594</td>\n",
       "      <td>2140.804</td>\n",
       "      <td>1451.704</td>\n",
       "      <td>1.474684</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Num Games  White_Wins  Black_Wins  White_odds\n",
       "move1b                                               \n",
       "c5         737822  271864.285  251594.138    1.080567\n",
       "g6          56518   21882.592   19685.018    1.111637\n",
       "Nc6          9318    3910.606    3241.965    1.206246\n",
       "Nf6         34710   13577.389   11229.260    1.209108\n",
       "e6         228091   89953.946   69003.473    1.303615\n",
       "c6         129053   49686.826   37970.724    1.308556\n",
       "d6          68605   28091.144   21004.152    1.337409\n",
       "e5         370196  147469.924  105405.333    1.399075\n",
       "d5          51575   21701.516   15505.605    1.399592\n",
       "a6           1283     613.935     420.875    1.458711\n",
       "b6           4594    2140.804    1451.704    1.474684"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "e4.sort_values('White_odds')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "e4 = df[df['move1w']=='e4'].agg({'Num Games': np.sum, 'White_Wins' : np.sum, 'Black_Wins':np.sum})\n",
    "e4['White_odds'] = e4['White_Wins'] / e4['Black_Wins']\n",
    "e4['white_win_%'] = e4['White_Wins'] / e4['Num Games']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1.213193120268138"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "e4['Whit-e_odds']"
   ]
  },
  {
   "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.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}