Bulk importing board game data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "from bs4 import BeautifulSoup\n",
    "import pandas as pd\n",
    "import re"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "top_games = pd.read_csv(\"top_games.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "l =list(top_games['ID'])"
   ]
  },
  {
   "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>Name</th>\n",
       "      <th>Rank</th>\n",
       "      <th>ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Gloomhaven</td>\n",
       "      <td>1</td>\n",
       "      <td>174430</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Pandemic Legacy: Season 1</td>\n",
       "      <td>2</td>\n",
       "      <td>161936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Through the Ages: A New Story of Civilization</td>\n",
       "      <td>3</td>\n",
       "      <td>182028</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Terraforming Mars</td>\n",
       "      <td>4</td>\n",
       "      <td>167791</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Twilight Struggle</td>\n",
       "      <td>5</td>\n",
       "      <td>12333</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            Name  Rank      ID\n",
       "0                                     Gloomhaven     1  174430\n",
       "1                      Pandemic Legacy: Season 1     2  161936\n",
       "2  Through the Ages: A New Story of Civilization     3  182028\n",
       "3                              Terraforming Mars     4  167791\n",
       "4                              Twilight Struggle     5   12333"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_games.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "100\n",
      "1.0\n",
      "174430\n",
      "2.0\n",
      "161936\n",
      "3.0\n",
      "182028\n",
      "4.0\n",
      "167791\n",
      "5.0\n",
      "12333\n",
      "6.0\n",
      "187645\n",
      "7.0\n",
      "169786\n",
      "8.0\n",
      "220308\n",
      "9.0\n",
      "193738\n",
      "10.0\n",
      "120677\n",
      "11.0\n",
      "84876\n",
      "12.0\n",
      "115746\n",
      "13.0\n",
      "173346\n",
      "14.0\n",
      "180263\n",
      "15.0\n",
      "233078\n",
      "16.0\n",
      "3076\n",
      "17.0\n",
      "102794\n",
      "18.0\n",
      "205637\n",
      "19.0\n",
      "183394\n",
      "20.0\n",
      "124361\n",
      "21.0\n",
      "31260\n",
      "22.0\n",
      "96848\n",
      "23.0\n",
      "162886\n",
      "24.0\n",
      "205059\n",
      "25.0\n",
      "28720\n",
      "26.0\n",
      "164928\n",
      "27.0\n",
      "170216\n",
      "28.0\n",
      "175914\n",
      "29.0\n",
      "209010\n",
      "30.0\n",
      "177736\n",
      "31.0\n",
      "164153\n",
      "32.0\n",
      "25613\n",
      "33.0\n",
      "2651\n",
      "34.0\n",
      "55690\n",
      "35.0\n",
      "221107\n",
      "36.0\n",
      "72125\n",
      "37.0\n",
      "230802\n",
      "38.0\n",
      "126163\n",
      "39.0\n",
      "35677\n",
      "40.0\n",
      "121921\n",
      "41.0\n",
      "171623\n",
      "42.0\n",
      "124742\n",
      "43.0\n",
      "224517\n",
      "44.0\n",
      "68448\n",
      "45.0\n",
      "122515\n",
      "46.0\n",
      "216132\n",
      "47.0\n",
      "18602\n",
      "48.0\n",
      "28143\n",
      "49.0\n",
      "62219\n",
      "50.0\n",
      "12493\n",
      "51.0\n",
      "159675\n",
      "52.0\n",
      "178900\n",
      "53.0\n",
      "146021\n",
      "54.0\n",
      "110327\n",
      "55.0\n",
      "157354\n",
      "56.0\n",
      "205896\n",
      "57.0\n",
      "93\n",
      "58.0\n",
      "146508\n",
      "59.0\n",
      "163412\n",
      "60.0\n",
      "40834\n",
      "61.0\n",
      "201808\n",
      "62.0\n",
      "132531\n",
      "63.0\n",
      "185343\n",
      "64.0\n",
      "125153\n",
      "65.0\n",
      "172386\n",
      "66.0\n",
      "37111\n",
      "67.0\n",
      "2511\n",
      "68.0\n",
      "73439\n",
      "69.0\n",
      "103885\n",
      "70.0\n",
      "144733\n",
      "71.0\n",
      "42\n",
      "72.0\n",
      "150376\n",
      "73.0\n",
      "102680\n",
      "74.0\n",
      "36218\n",
      "75.0\n",
      "30549\n",
      "76.0\n",
      "127023\n",
      "77.0\n",
      "521\n",
      "78.0\n",
      "198928\n",
      "79.0\n",
      "104162\n",
      "80.0\n",
      "34635\n",
      "81.0\n",
      "194655\n",
      "82.0\n",
      "175155\n",
      "83.0\n",
      "161970\n",
      "84.0\n",
      "9609\n",
      "85.0\n",
      "155426\n",
      "86.0\n",
      "146652\n",
      "87.0\n",
      "147020\n",
      "88.0\n",
      "128882\n",
      "89.0\n",
      "103343\n",
      "90.0\n",
      "148949\n",
      "91.0\n",
      "161533\n",
      "92.0\n",
      "196340\n",
      "93.0\n",
      "70149\n",
      "94.0\n",
      "155068\n",
      "95.0\n",
      "14996\n",
      "96.0\n",
      "200680\n",
      "97.0\n",
      "17133\n",
      "98.0\n",
      "43111\n",
      "99.0\n",
      "123260\n",
      "100.0\n",
      "182874\n",
      "200\n",
      "101.0\n",
      "174430\n",
      "102.0\n",
      "161936\n",
      "103.0\n",
      "182028\n",
      "104.0\n",
      "167791\n",
      "105.0\n",
      "12333\n",
      "106.0\n",
      "187645\n",
      "107.0\n",
      "169786\n",
      "108.0\n",
      "220308\n",
      "109.0\n",
      "193738\n",
      "110.0\n",
      "120677\n",
      "111.0\n",
      "84876\n",
      "112.0\n",
      "115746\n",
      "113.0\n",
      "173346\n",
      "114.0\n",
      "180263\n",
      "115.0\n",
      "233078\n",
      "116.0\n",
      "3076\n",
      "117.0\n",
      "102794\n",
      "118.0\n",
      "205637\n",
      "119.0\n",
      "183394\n",
      "120.0\n",
      "124361\n",
      "121.0\n",
      "31260\n",
      "122.0\n",
      "96848\n",
      "123.0\n",
      "162886\n",
      "124.0\n",
      "205059\n",
      "125.0\n",
      "28720\n",
      "126.0\n",
      "164928\n",
      "127.0\n",
      "170216\n",
      "128.0\n",
      "175914\n",
      "129.0\n",
      "209010\n",
      "130.0\n",
      "177736\n",
      "131.0\n",
      "164153\n",
      "132.0\n",
      "25613\n",
      "133.0\n",
      "2651\n",
      "134.0\n",
      "55690\n",
      "135.0\n",
      "221107\n",
      "136.0\n",
      "72125\n",
      "137.0\n",
      "230802\n",
      "138.0\n",
      "126163\n",
      "139.0\n",
      "35677\n",
      "140.0\n",
      "121921\n",
      "141.0\n",
      "171623\n",
      "142.0\n",
      "124742\n",
      "143.0\n",
      "224517\n",
      "144.0\n",
      "68448\n",
      "145.0\n",
      "122515\n",
      "146.0\n",
      "216132\n",
      "147.0\n",
      "18602\n",
      "148.0\n",
      "28143\n",
      "149.0\n",
      "62219\n",
      "150.0\n",
      "12493\n",
      "151.0\n",
      "159675\n",
      "152.0\n",
      "178900\n",
      "153.0\n",
      "146021\n",
      "154.0\n",
      "110327\n",
      "155.0\n",
      "157354\n",
      "156.0\n",
      "205896\n",
      "157.0\n",
      "93\n",
      "158.0\n",
      "146508\n",
      "159.0\n",
      "163412\n",
      "160.0\n",
      "40834\n",
      "161.0\n",
      "201808\n",
      "162.0\n",
      "132531\n",
      "163.0\n",
      "185343\n",
      "164.0\n",
      "125153\n",
      "165.0\n",
      "172386\n",
      "166.0\n",
      "37111\n",
      "167.0\n",
      "2511\n",
      "168.0\n",
      "73439\n",
      "169.0\n",
      "103885\n",
      "170.0\n",
      "144733\n",
      "171.0\n",
      "42\n",
      "172.0\n",
      "150376\n",
      "173.0\n",
      "102680\n",
      "174.0\n",
      "36218\n",
      "175.0\n",
      "30549\n",
      "176.0\n",
      "127023\n",
      "177.0\n",
      "521\n",
      "178.0\n",
      "198928\n",
      "179.0\n",
      "104162\n",
      "180.0\n",
      "34635\n",
      "181.0\n",
      "194655\n",
      "182.0\n",
      "175155\n",
      "183.0\n",
      "161970\n",
      "184.0\n",
      "9609\n",
      "185.0\n",
      "155426\n",
      "186.0\n",
      "146652\n",
      "187.0\n",
      "147020\n",
      "188.0\n",
      "128882\n",
      "189.0\n",
      "103343\n",
      "190.0\n",
      "148949\n",
      "191.0\n",
      "161533\n",
      "192.0\n",
      "196340\n",
      "193.0\n",
      "70149\n",
      "194.0\n",
      "155068\n",
      "195.0\n",
      "14996\n",
      "196.0\n",
      "200680\n",
      "197.0\n",
      "17133\n",
      "198.0\n",
      "43111\n",
      "199.0\n",
      "123260\n",
      "200.0\n",
      "182874\n",
      "201.0\n",
      "14105\n",
      "202.0\n",
      "172287\n",
      "203.0\n",
      "170042\n",
      "204.0\n",
      "126042\n",
      "205.0\n",
      "171131\n",
      "206.0\n",
      "21050\n",
      "207.0\n",
      "155821\n",
      "208.0\n",
      "91\n",
      "209.0\n",
      "77423\n",
      "210.0\n",
      "39463\n",
      "211.0\n",
      "224037\n",
      "212.0\n",
      "54043\n",
      "213.0\n",
      "237182\n",
      "214.0\n",
      "43015\n",
      "215.0\n",
      "10630\n",
      "216.0\n",
      "104006\n",
      "217.0\n",
      "9216\n",
      "218.0\n",
      "31627\n",
      "219.0\n",
      "4098\n",
      "220.0\n",
      "195421\n",
      "221.0\n",
      "197376\n",
      "222.0\n",
      "27833\n",
      "223.0\n",
      "146886\n",
      "224.0\n",
      "148228\n",
      "225.0\n",
      "176189\n",
      "226.0\n",
      "215\n",
      "227.0\n",
      "555\n",
      "228.0\n",
      "128621\n",
      "229.0\n",
      "203993\n",
      "230.0\n",
      "188\n",
      "231.0\n",
      "129437\n",
      "232.0\n",
      "191189\n",
      "233.0\n",
      "9209\n",
      "234.0\n",
      "199561\n",
      "235.0\n",
      "20551\n",
      "236.0\n",
      "31481\n",
      "237.0\n",
      "12\n",
      "238.0\n",
      "118048\n",
      "239.0\n",
      "25021\n",
      "240.0\n",
      "54998\n",
      "241.0\n",
      "233371\n",
      "242.0\n",
      "822\n",
      "243.0\n",
      "154203\n",
      "244.0\n",
      "7854\n",
      "245.0\n",
      "22545\n",
      "246.0\n",
      "24181\n",
      "247.0\n",
      "97207\n",
      "248.0\n",
      "140620\n",
      "249.0\n",
      "192291\n",
      "250.0\n",
      "155873\n",
      "251.0\n",
      "234\n",
      "252.0\n",
      "146439\n",
      "253.0\n",
      "463\n",
      "254.0\n",
      "175640\n",
      "255.0\n",
      "182631\n",
      "256.0\n",
      "19857\n",
      "257.0\n",
      "93260\n",
      "258.0\n",
      "59294\n",
      "259.0\n",
      "27708\n",
      "260.0\n",
      "176494\n",
      "261.0\n",
      "188920\n",
      "262.0\n",
      "163068\n",
      "263.0\n",
      "193037\n",
      "264.0\n",
      "101721\n",
      "265.0\n",
      "127060\n",
      "266.0\n",
      "38453\n",
      "267.0\n",
      "156129\n",
      "268.0\n",
      "108745\n",
      "269.0\n",
      "48726\n",
      "270.0\n",
      "82222\n",
      "271.0\n",
      "172818\n",
      "272.0\n",
      "203420\n",
      "273.0\n",
      "181304\n",
      "274.0\n",
      "92828\n",
      "275.0\n",
      "421\n",
      "276.0\n",
      "66589\n",
      "277.0\n",
      "198994\n",
      "278.0\n",
      "54138\n",
      "279.0\n",
      "181279\n",
      "280.0\n",
      "3\n",
      "281.0\n",
      "17392\n",
      "282.0\n",
      "192135\n",
      "283.0\n",
      "188834\n",
      "284.0\n",
      "77130\n",
      "285.0\n",
      "160477\n",
      "286.0\n",
      "760\n",
      "287.0\n",
      "204583\n",
      "288.0\n",
      "41114\n",
      "289.0\n",
      "19777\n",
      "290.0\n",
      "119890\n",
      "291.0\n",
      "45315\n",
      "292.0\n",
      "59959\n",
      "293.0\n",
      "172081\n",
      "294.0\n",
      "40692\n",
      "295.0\n",
      "163745\n",
      "296.0\n",
      "144344\n",
      "297.0\n",
      "13122\n",
      "298.0\n",
      "109276\n",
      "299.0\n",
      "176920\n",
      "300.0\n",
      "176734\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n",
      "0\n"
     ]
    }
   ],
   "source": [
    "string = ''\n",
    "domain_types = [ 'Abstract Strategy Games', 'Customizable Games', 'Thematic Games', 'Family Games',\n",
    "\"Children's Games\", \"Party Games\", \"Strategy Games\", \"Wargames\"]\n",
    "game_stats = pd.DataFrame()\n",
    "count = 0.0\n",
    "for x in range(100,1001,100):\n",
    "    for i in l[:x]:\n",
    "        string += str(i) + \",\"\n",
    "    string = string[:-1]\n",
    "    response_stats = requests.get(\"https://boardgamegeek.com/xmlapi/boardgame/\"+string+\"?&stats=1\")\n",
    "    content_stats = response_stats.content\n",
    "    parser_stats = BeautifulSoup(content_stats, 'html.parser')\n",
    "    boardgames = parser_stats.findAll(\"boardgame\")\n",
    "    print(len(boardgames))\n",
    "    for boardgame in boardgames:\n",
    "        count+=1\n",
    "        print(count)    \n",
    "        temp = {}\n",
    "#         print(boardgame)\n",
    "#         print(id)\n",
    "        print(boardgame['objectid'])\n",
    "        temp['ID'] = boardgame['objectid']\n",
    "        temp['Year Published'] = boardgame.yearpublished.text\n",
    "        temp['Min Players'] = boardgame.minplayers.text\n",
    "        temp['Max Players'] = boardgame.maxplayers.text\n",
    "        temp['Playing Time'] = boardgame.playingtime.text\n",
    "        temp['Min Playing Time'] = boardgame.minplaytime.text\n",
    "        temp['Max Playing Time'] = boardgame.maxplaytime.text\n",
    "        temp['Owned'] = boardgame.owned.text\n",
    "        temp['Users Rated'] = boardgame.usersrated.text\n",
    "        temp['Average Rating'] = boardgame.average.text\n",
    "        temp['Bayes Average Rating'] = boardgame.bayesaverage.text\n",
    "        temp['Age'] = int(boardgame.age.text)\n",
    "        temp['Complexity Rating'] = float(boardgame.averageweight.text)\n",
    "        temp['Comments'] = boardgame.numcomments.text\n",
    "        temp['Wishing'] = boardgame.wishing.text\n",
    "        temp['NumWeights'] = boardgame.numweights.text\n",
    "        temp['Wanting'] = boardgame.wanting.text\n",
    "        temp['Trading'] = boardgame.trading.text\n",
    "\n",
    "        if (boardgame.videogamebg != None):\n",
    "            temp['Video Games'] = boardgame.videogamebg.text\n",
    "        else:\n",
    "            temp['Video Games'] = ' '\n",
    "\n",
    "        temp['Median'] = boardgame.median.text\n",
    "        temp['Std Deviation'] = boardgame.stddev.text\n",
    "\n",
    "        temp['Publisher'] = boardgame.findAll(\"boardgamepublisher\")[0].text\n",
    "\n",
    "        publishers = boardgame.findAll(\"boardgamepublisher\")\n",
    "        game_publishers = []\n",
    "        for publisher in publishers[1:]:\n",
    "            game_publishers.append(publisher.text)\n",
    "        temp['Secondary Publishers'] = game_publishers\n",
    "\n",
    "        polls = boardgame.findAll(\"poll\")\n",
    "\n",
    "        poll_numplayers = boardgame.find(\"poll\",{\"name\":\"suggested_numplayers\"})\n",
    "\n",
    "        players_df = pd.DataFrame()\n",
    "        num = []\n",
    "        labels = []\n",
    "        percent = []\n",
    "        for i in range(1,len(poll_numplayers.findAll(\"results\"))):\n",
    "            poll_numplayers_1 = poll_numplayers.find(\"results\",{\"numplayers\":i})\n",
    "            numvotes_players_1 = []\n",
    "            values_players_1 = []\n",
    "            total = 0.0\n",
    "            for result in poll_numplayers_1.findAll(\"result\"):\n",
    "                total += int(result['numvotes'])\n",
    "                numvotes_players_1.append(int(result['numvotes']))\n",
    "                values_players_1.append(result['value'])\n",
    "            total = (1.0 if total == 0.0 else total)\n",
    "            if numvotes_players_1 != []: \n",
    "                max_players_1 = max(numvotes_players_1)\n",
    "                percent_players_1 = (max(numvotes_players_1)/total)*100\n",
    "                index_players_1 = numvotes_players_1.index(max_players_1)\n",
    "                num.append(i)\n",
    "                labels.append(values_players_1[index_players_1])\n",
    "                percent.append(percent_players_1)\n",
    "        players_df['num'] = num\n",
    "        players_df['labels'] = labels\n",
    "        players_df['percent'] = percent\n",
    "\n",
    "        for label in players_df['labels'].unique():\n",
    "            temp['Num Players '+label] = (players_df[players_df['labels'] == label]['num']).tolist()\n",
    "\n",
    "        poll_lang = boardgame.find(\"poll\",{\"name\":\"language_dependence\"})\n",
    "        numvotes_lang = []\n",
    "        values_lang = []\n",
    "        for result in poll_lang.findAll(\"result\"):\n",
    "            numvotes_lang.append(int(result['numvotes']))\n",
    "            values_lang.append(result['value'])\n",
    "        if numvotes_lang != []:\n",
    "            max_lang = max(numvotes_lang)\n",
    "            index_lang = numvotes_lang.index(max_lang)\n",
    "            temp['Language Dependence'] = values_lang[index_lang]\n",
    "        else:\n",
    "            temp['Language Dependence'] = ' '\n",
    "\n",
    "        poll_age = boardgame.find(\"poll\",{\"name\":\"suggested_playerage\"})\n",
    "        numvotes_age = []\n",
    "        values_age = []\n",
    "        for result in poll_age.findAll(\"result\"):\n",
    "            numvotes_age.append(int(result['numvotes']))\n",
    "            values_age.append(result['value'])\n",
    "        if numvotes_age !=[]:\n",
    "            max_age = max(numvotes_age)\n",
    "            index_age = numvotes_age.index(max_age)\n",
    "            temp['Suggested Player Age'] = values_age[index_age]\n",
    "        else:\n",
    "            temp['Suggested Player Age'] = 0\n",
    "\n",
    "        domains = []\n",
    "        boardgamesubdomain = boardgame.findAll(\"boardgamesubdomain\")\n",
    "        for domain in boardgamesubdomain:\n",
    "            domains.append(domain.text)\n",
    "        temp['Game Domains'] = domains\n",
    "\n",
    "        for domain in domain_types:\n",
    "            if domain in domains:\n",
    "                temp[domain] = True\n",
    "            else:\n",
    "                temp[domain] = False\n",
    "\n",
    "        categories = []\n",
    "        gamecategory = boardgame.findAll(\"boardgamecategory\")\n",
    "        for category in gamecategory:\n",
    "            categories.append(category.text)\n",
    "        temp['Game Categories'] = categories\n",
    "\n",
    "        mechanics = boardgame.findAll(\"boardgamemechanic\")\n",
    "        game_mechanics = []\n",
    "        for mechanic in mechanics:\n",
    "            game_mechanics.append(mechanic.text)\n",
    "        temp['Game Mechanics'] = game_mechanics\n",
    "\n",
    "        designers = boardgame.findAll(\"boardgamedesigner\")\n",
    "        game_designers = []\n",
    "        for designer in designers:\n",
    "            game_designers.append(designer.text)\n",
    "        temp['Game Designers'] = game_designers\n",
    "\n",
    "        families = boardgame.findAll(\"boardgamefamily\")\n",
    "        game_families = []\n",
    "        for family in families:\n",
    "            game_families.append(family.text)\n",
    "        temp['Game Family'] = game_families\n",
    "\n",
    "        ranks = boardgame.findAll(\"rank\")\n",
    "    # Should I keep this column in the df or not?\n",
    "    #     rank_dict={}\n",
    "    #     for rank in ranks:\n",
    "    #         rank_dict[rank['friendlyname']]=int(rank['value'])\n",
    "    #     temp['Ranks'] = rank_dict\n",
    "\n",
    "        if len(ranks)>1:\n",
    "            for rank in ranks[1:]:\n",
    "                temp[rank['friendlyname']]=int(rank['value'])\n",
    "\n",
    "        artists = boardgame.findAll(\"boardgameartist\")\n",
    "        game_artists = []\n",
    "        for artist in artists:\n",
    "            game_artists.append(artist.text)\n",
    "        temp['Game Artists'] = game_artists\n",
    "\n",
    "        temp_df = pd.DataFrame.from_dict(temp, orient='index')\n",
    "        temp_df = temp_df.transpose()\n",
    "\n",
    "        game_stats = pd.concat([game_stats, temp_df],sort=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "CPU times: user 70 µs, sys: 1 µs, total: 71 µs\n",
      "Wall time: 74.9 µs\n"
     ]
    }
   ],
   "source": [
    "%%time\n",
    "game_stats.reset_index(drop=True, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "game_stats.to_csv(\"game_stats_bulk.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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>ID</th>\n",
       "      <th>Year Published</th>\n",
       "      <th>Min Players</th>\n",
       "      <th>Max Players</th>\n",
       "      <th>Playing Time</th>\n",
       "      <th>Min Playing Time</th>\n",
       "      <th>Max Playing Time</th>\n",
       "      <th>Owned</th>\n",
       "      <th>Users Rated</th>\n",
       "      <th>Average Rating</th>\n",
       "      <th>...</th>\n",
       "      <th>Game Family</th>\n",
       "      <th>Thematic Rank</th>\n",
       "      <th>Strategy Game Rank</th>\n",
       "      <th>Game Artists</th>\n",
       "      <th>Num Players Not Recommended</th>\n",
       "      <th>War Game Rank</th>\n",
       "      <th>Customizable Rank</th>\n",
       "      <th>Abstract Game Rank</th>\n",
       "      <th>Family Game Rank</th>\n",
       "      <th>Party Game Rank</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>174430</td>\n",
       "      <td>2017</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>120</td>\n",
       "      <td>60</td>\n",
       "      <td>120</td>\n",
       "      <td>33576</td>\n",
       "      <td>20312</td>\n",
       "      <td>8.92994</td>\n",
       "      <td>...</td>\n",
       "      <td>[Campaign Games, Components: Miniatures, Crowd...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>[Alexandr Elichev, Josh T. McDowell, Alvaro Ne...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>161936</td>\n",
       "      <td>2015</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>60</td>\n",
       "      <td>60</td>\n",
       "      <td>60</td>\n",
       "      <td>45427</td>\n",
       "      <td>28528</td>\n",
       "      <td>8.65145</td>\n",
       "      <td>...</td>\n",
       "      <td>[Campaign Games, Legacy, Pandemic]</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>[Chris Quilliams]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>182028</td>\n",
       "      <td>2015</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>240</td>\n",
       "      <td>180</td>\n",
       "      <td>240</td>\n",
       "      <td>17668</td>\n",
       "      <td>14006</td>\n",
       "      <td>8.56732</td>\n",
       "      <td>...</td>\n",
       "      <td>[Tableau Building]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>[Jakub Politzer, Milan Vavroň]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>167791</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>120</td>\n",
       "      <td>120</td>\n",
       "      <td>120</td>\n",
       "      <td>40824</td>\n",
       "      <td>32136</td>\n",
       "      <td>8.39275</td>\n",
       "      <td>...</td>\n",
       "      <td>[Fryxgames' Future Timeline, Planets: Mars, So...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>[Isaac Fryxelius]</td>\n",
       "      <td>[5]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>12333</td>\n",
       "      <td>2005</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>180</td>\n",
       "      <td>120</td>\n",
       "      <td>180</td>\n",
       "      <td>44900</td>\n",
       "      <td>32806</td>\n",
       "      <td>8.33008</td>\n",
       "      <td>...</td>\n",
       "      <td>[Country: Soviet Union, Country: USA, Historic...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>[Viktor Csete, Rodger B. MacGowan, Chechu Niet...</td>\n",
       "      <td>[1]</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>187645</td>\n",
       "      <td>2016</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>240</td>\n",
       "      <td>180</td>\n",
       "      <td>240</td>\n",
       "      <td>22816</td>\n",
       "      <td>14956</td>\n",
       "      <td>8.45402</td>\n",
       "      <td>...</td>\n",
       "      <td>[Components: Miniatures, Star Wars]</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>[]</td>\n",
       "      <td>[1, 3, 4]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>169786</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>115</td>\n",
       "      <td>90</td>\n",
       "      <td>115</td>\n",
       "      <td>44416</td>\n",
       "      <td>34220</td>\n",
       "      <td>8.28321</td>\n",
       "      <td>...</td>\n",
       "      <td>[Alternate History, Components: Miniatures, Cr...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>[Jakub Rozalski]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>220308</td>\n",
       "      <td>2017</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>150</td>\n",
       "      <td>60</td>\n",
       "      <td>150</td>\n",
       "      <td>8928</td>\n",
       "      <td>7219</td>\n",
       "      <td>8.59267</td>\n",
       "      <td>...</td>\n",
       "      <td>[Solitaire Games, Tableau Building, Terra Myst...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>[Dennis Lohausen]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>193738</td>\n",
       "      <td>2016</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>150</td>\n",
       "      <td>75</td>\n",
       "      <td>150</td>\n",
       "      <td>19872</td>\n",
       "      <td>16334</td>\n",
       "      <td>8.28944</td>\n",
       "      <td>...</td>\n",
       "      <td>[Animals: Cattle, Stronghold Games: The Great ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>[Andreas Resch]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>120677</td>\n",
       "      <td>2012</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>150</td>\n",
       "      <td>60</td>\n",
       "      <td>150</td>\n",
       "      <td>34333</td>\n",
       "      <td>30969</td>\n",
       "      <td>8.21162</td>\n",
       "      <td>...</td>\n",
       "      <td>[Tableau Building, Terra Mystica]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>[Dennis Lohausen]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>84876</td>\n",
       "      <td>2011</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>90</td>\n",
       "      <td>30</td>\n",
       "      <td>90</td>\n",
       "      <td>47526</td>\n",
       "      <td>34118</td>\n",
       "      <td>8.12684</td>\n",
       "      <td>...</td>\n",
       "      <td>[Alea Big Box, Country: France, Tableau Building]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12</td>\n",
       "      <td>[Julien Delval, Harald Lieske]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>115746</td>\n",
       "      <td>2012</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>180</td>\n",
       "      <td>150</td>\n",
       "      <td>180</td>\n",
       "      <td>14598</td>\n",
       "      <td>8988</td>\n",
       "      <td>8.39623</td>\n",
       "      <td>...</td>\n",
       "      <td>[Components: Miniatures, Monsters, Tolkien Gam...</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[John Howe, Fabio Maiorana]</td>\n",
       "      <td>[1, 3, 4]</td>\n",
       "      <td>2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>173346</td>\n",
       "      <td>2015</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>55865</td>\n",
       "      <td>36260</td>\n",
       "      <td>8.13675</td>\n",
       "      <td>...</td>\n",
       "      <td>[7 Wonders, 7 Wonders Duel, Tableau Building]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "      <td>[Miguel Coimbra]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>180263</td>\n",
       "      <td>2017</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1000</td>\n",
       "      <td>5</td>\n",
       "      <td>1000</td>\n",
       "      <td>15181</td>\n",
       "      <td>7869</td>\n",
       "      <td>8.52118</td>\n",
       "      <td>...</td>\n",
       "      <td>[The 7th Continent, Campaign Games, Components...</td>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Ludovic Roudy]</td>\n",
       "      <td>[4]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>233078</td>\n",
       "      <td>2017</td>\n",
       "      <td>3</td>\n",
       "      <td>6</td>\n",
       "      <td>480</td>\n",
       "      <td>240</td>\n",
       "      <td>480</td>\n",
       "      <td>6546</td>\n",
       "      <td>4537</td>\n",
       "      <td>8.76953</td>\n",
       "      <td>...</td>\n",
       "      <td>[4X games, Components: Miniatures, Twilight Im...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11</td>\n",
       "      <td>[Scott Schomburg]</td>\n",
       "      <td>[1, 2]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>3076</td>\n",
       "      <td>2002</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>150</td>\n",
       "      <td>90</td>\n",
       "      <td>150</td>\n",
       "      <td>63235</td>\n",
       "      <td>54603</td>\n",
       "      <td>8.04659</td>\n",
       "      <td>...</td>\n",
       "      <td>[Alea Big Box, Colonial Theme, Country: Puerto...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21</td>\n",
       "      <td>[Harald Lieske, Franz Vohwinkel]</td>\n",
       "      <td>[1, 2]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>102794</td>\n",
       "      <td>2013</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>210</td>\n",
       "      <td>30</td>\n",
       "      <td>210</td>\n",
       "      <td>28460</td>\n",
       "      <td>22398</td>\n",
       "      <td>8.09309</td>\n",
       "      <td>...</td>\n",
       "      <td>[Animals: Sheep, Caverna, Harvest Series, Mini...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>[Klemens Franz]</td>\n",
       "      <td>[6, 7]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>205637</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>120</td>\n",
       "      <td>60</td>\n",
       "      <td>120</td>\n",
       "      <td>27406</td>\n",
       "      <td>14698</td>\n",
       "      <td>8.23798</td>\n",
       "      <td>...</td>\n",
       "      <td>[Arkham Horror, Arkham Horror: The Card Game L...</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Christopher Hosch, Marcin Jakubowski, Ignacio...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>183394</td>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>90</td>\n",
       "      <td>45</td>\n",
       "      <td>90</td>\n",
       "      <td>19732</td>\n",
       "      <td>14616</td>\n",
       "      <td>8.14724</td>\n",
       "      <td>...</td>\n",
       "      <td>[Country: Italy, Solitaire Games, Theme: Farmi...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18</td>\n",
       "      <td>[Jacqui Davis, David Montgomery, Beth Sobel]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>124361</td>\n",
       "      <td>2013</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>100</td>\n",
       "      <td>20402</td>\n",
       "      <td>17576</td>\n",
       "      <td>8.08661</td>\n",
       "      <td>...</td>\n",
       "      <td>[Ancient Rome, Concordia]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16</td>\n",
       "      <td>[Marina Fahrenbach, Mac Gerdts, Dominik Mayer]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>31260</td>\n",
       "      <td>2007</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>150</td>\n",
       "      <td>30</td>\n",
       "      <td>150</td>\n",
       "      <td>66409</td>\n",
       "      <td>55262</td>\n",
       "      <td>8.00648</td>\n",
       "      <td>...</td>\n",
       "      <td>[Agricola, Animals: Cattle, Animals: Horses, A...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>25</td>\n",
       "      <td>[Klemens Franz]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>96848</td>\n",
       "      <td>2011</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>240</td>\n",
       "      <td>60</td>\n",
       "      <td>240</td>\n",
       "      <td>33033</td>\n",
       "      <td>22465</td>\n",
       "      <td>8.10599</td>\n",
       "      <td>...</td>\n",
       "      <td>[Clix, Components: Miniatures, Mage Knight Uni...</td>\n",
       "      <td>12</td>\n",
       "      <td>26</td>\n",
       "      <td>[J. Lonnee, Chris Raimo, Milan Vavroň]</td>\n",
       "      <td>[4]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>162886</td>\n",
       "      <td>2017</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>120</td>\n",
       "      <td>90</td>\n",
       "      <td>120</td>\n",
       "      <td>10945</td>\n",
       "      <td>7045</td>\n",
       "      <td>8.39409</td>\n",
       "      <td>...</td>\n",
       "      <td>[Colonial Theme, Components: Miniatures, Crowd...</td>\n",
       "      <td>7</td>\n",
       "      <td>14</td>\n",
       "      <td>[Jason Behnke, Kat G Bermelin, Loïc Billiau, C...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>205059</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>180</td>\n",
       "      <td>120</td>\n",
       "      <td>180</td>\n",
       "      <td>22674</td>\n",
       "      <td>14417</td>\n",
       "      <td>8.17646</td>\n",
       "      <td>...</td>\n",
       "      <td>[Arkham Horror, Components: Miniatures, Cthulh...</td>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Cristi Balanescu, Yoann Boissonnet, Anders Fi...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>28720</td>\n",
       "      <td>2007</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>120</td>\n",
       "      <td>60</td>\n",
       "      <td>120</td>\n",
       "      <td>17988</td>\n",
       "      <td>13610</td>\n",
       "      <td>8.0943</td>\n",
       "      <td>...</td>\n",
       "      <td>[Cities: Manchester, Country: England]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17</td>\n",
       "      <td>[Lina Cossette, Peter Dennis, David Forest, Ec...</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>164928</td>\n",
       "      <td>2014</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>90</td>\n",
       "      <td>90</td>\n",
       "      <td>90</td>\n",
       "      <td>16798</td>\n",
       "      <td>14337</td>\n",
       "      <td>8.08353</td>\n",
       "      <td>...</td>\n",
       "      <td>[Cities: Orléans (France), Country: France, Cr...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22</td>\n",
       "      <td>[Klemens Franz]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>170216</td>\n",
       "      <td>2015</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>90</td>\n",
       "      <td>60</td>\n",
       "      <td>90</td>\n",
       "      <td>28468</td>\n",
       "      <td>23257</td>\n",
       "      <td>8.04858</td>\n",
       "      <td>...</td>\n",
       "      <td>[Components: Miniatures, Crowdfunding: Kicksta...</td>\n",
       "      <td>14</td>\n",
       "      <td>29</td>\n",
       "      <td>[Henning Ludvigsen, Mike McVey, Adrian Smith]</td>\n",
       "      <td>[1, 2]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>175914</td>\n",
       "      <td>2015</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>240</td>\n",
       "      <td>120</td>\n",
       "      <td>240</td>\n",
       "      <td>10579</td>\n",
       "      <td>8657</td>\n",
       "      <td>8.19729</td>\n",
       "      <td>...</td>\n",
       "      <td>[Food / Cooking]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20</td>\n",
       "      <td>[Iris de Haan, Ynze Moedt]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>209010</td>\n",
       "      <td>2016</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>90</td>\n",
       "      <td>60</td>\n",
       "      <td>90</td>\n",
       "      <td>15705</td>\n",
       "      <td>10310</td>\n",
       "      <td>8.16758</td>\n",
       "      <td>...</td>\n",
       "      <td>[Campaign Games, Components: Miniatures]</td>\n",
       "      <td>11</td>\n",
       "      <td>28</td>\n",
       "      <td>[Danny Beck, Tysen Henderson]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>177736</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>120</td>\n",
       "      <td>30</td>\n",
       "      <td>120</td>\n",
       "      <td>12740</td>\n",
       "      <td>9611</td>\n",
       "      <td>8.16685</td>\n",
       "      <td>...</td>\n",
       "      <td>[Admin: Better Description Needed!, Food / Coo...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24</td>\n",
       "      <td>[Dennis Lohausen]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</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>270</th>\n",
       "      <td>172818</td>\n",
       "      <td>2015</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>90</td>\n",
       "      <td>90</td>\n",
       "      <td>90</td>\n",
       "      <td>14173</td>\n",
       "      <td>9230</td>\n",
       "      <td>7.5395</td>\n",
       "      <td>...</td>\n",
       "      <td>[Above and Below, Crowdfunding: Kickstarter, W...</td>\n",
       "      <td>50</td>\n",
       "      <td>131</td>\n",
       "      <td>[Ryan Laukat]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>271</th>\n",
       "      <td>203420</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>120</td>\n",
       "      <td>60</td>\n",
       "      <td>120</td>\n",
       "      <td>8071</td>\n",
       "      <td>4900</td>\n",
       "      <td>7.72197</td>\n",
       "      <td>...</td>\n",
       "      <td>[Escape Room Games, EXIT: Das Spiel]</td>\n",
       "      <td>33</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Inka Brand, Markus Brand, Silvia Christoph, F...</td>\n",
       "      <td>[5, 6]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>272</th>\n",
       "      <td>181304</td>\n",
       "      <td>2015</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>42</td>\n",
       "      <td>42</td>\n",
       "      <td>42</td>\n",
       "      <td>31524</td>\n",
       "      <td>20856</td>\n",
       "      <td>7.42479</td>\n",
       "      <td>...</td>\n",
       "      <td>[Ghosts, Holidays: Halloween, Mysterium]</td>\n",
       "      <td>61</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Igor Burlakov, Xavier Collette, Oleksandr Nev...</td>\n",
       "      <td>[1, 2]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>22</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>273</th>\n",
       "      <td>92828</td>\n",
       "      <td>2011</td>\n",
       "      <td>3</td>\n",
       "      <td>12</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>17030</td>\n",
       "      <td>12582</td>\n",
       "      <td>7.48597</td>\n",
       "      <td>...</td>\n",
       "      <td>[Dixit, Judging Games]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Marie Cardouat, Pierô]</td>\n",
       "      <td>[1, 2, 3]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>274</th>\n",
       "      <td>421</td>\n",
       "      <td>1986</td>\n",
       "      <td>2</td>\n",
       "      <td>7</td>\n",
       "      <td>360</td>\n",
       "      <td>180</td>\n",
       "      <td>360</td>\n",
       "      <td>5446</td>\n",
       "      <td>3800</td>\n",
       "      <td>7.83291</td>\n",
       "      <td>...</td>\n",
       "      <td>[18xx, Country: USA]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>96</td>\n",
       "      <td>[Mike Atkinson, Jared Blando, Charles Kibler, ...</td>\n",
       "      <td>[1, 2, 7]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>275</th>\n",
       "      <td>66589</td>\n",
       "      <td>2010</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>90</td>\n",
       "      <td>60</td>\n",
       "      <td>90</td>\n",
       "      <td>6719</td>\n",
       "      <td>7045</td>\n",
       "      <td>7.56928</td>\n",
       "      <td>...</td>\n",
       "      <td>[Age of Discovery, Colonial Theme, Country: Po...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>113</td>\n",
       "      <td>[Marina Fahrenbach, Mac Gerdts]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276</th>\n",
       "      <td>198994</td>\n",
       "      <td>2016</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>30</td>\n",
       "      <td>20</td>\n",
       "      <td>30</td>\n",
       "      <td>12467</td>\n",
       "      <td>6426</td>\n",
       "      <td>7.68017</td>\n",
       "      <td>...</td>\n",
       "      <td>[Crowdfunding: Kickstarter, Hero Realms]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>134</td>\n",
       "      <td>[Randy Delven, Vito Gesualdi, Antonis Papanton...</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>277</th>\n",
       "      <td>54138</td>\n",
       "      <td>2009</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>180</td>\n",
       "      <td>120</td>\n",
       "      <td>180</td>\n",
       "      <td>5234</td>\n",
       "      <td>4822</td>\n",
       "      <td>7.71908</td>\n",
       "      <td>...</td>\n",
       "      <td>[Rondel Series]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>104</td>\n",
       "      <td>[Alexander Jung]</td>\n",
       "      <td>[1, 2]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>278</th>\n",
       "      <td>181279</td>\n",
       "      <td>2015</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>180</td>\n",
       "      <td>120</td>\n",
       "      <td>180</td>\n",
       "      <td>14374</td>\n",
       "      <td>7427</td>\n",
       "      <td>7.59177</td>\n",
       "      <td>...</td>\n",
       "      <td>[Vampires]</td>\n",
       "      <td>43</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Chris Beck, Samuel Shimota]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>279</th>\n",
       "      <td>3</td>\n",
       "      <td>1998</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>60</td>\n",
       "      <td>30</td>\n",
       "      <td>60</td>\n",
       "      <td>13203</td>\n",
       "      <td>13129</td>\n",
       "      <td>7.44234</td>\n",
       "      <td>...</td>\n",
       "      <td>[Asian Theme, Country: Japan, Knizia tile-layi...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>132</td>\n",
       "      <td>[Franz Vohwinkel]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>280</th>\n",
       "      <td>17392</td>\n",
       "      <td>2006</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>360</td>\n",
       "      <td>180</td>\n",
       "      <td>360</td>\n",
       "      <td>4772</td>\n",
       "      <td>3205</td>\n",
       "      <td>7.93629</td>\n",
       "      <td>...</td>\n",
       "      <td>[Cities: Ravenna (Italy), Country: England, Co...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Rodger B. MacGowan, Mark Simonitch]</td>\n",
       "      <td>[1, 2, 4, 5]</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>281</th>\n",
       "      <td>192135</td>\n",
       "      <td>2017</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>120</td>\n",
       "      <td>60</td>\n",
       "      <td>120</td>\n",
       "      <td>3459</td>\n",
       "      <td>1995</td>\n",
       "      <td>8.55082</td>\n",
       "      <td>...</td>\n",
       "      <td>[Crowdfunding: Kickstarter, Solitaire Games, T...</td>\n",
       "      <td>19</td>\n",
       "      <td>93</td>\n",
       "      <td>[Josh J. Carlson, Anthony LeTourneau]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>282</th>\n",
       "      <td>188834</td>\n",
       "      <td>2016</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>45</td>\n",
       "      <td>13036</td>\n",
       "      <td>9571</td>\n",
       "      <td>7.58372</td>\n",
       "      <td>...</td>\n",
       "      <td>[Crowdfunding: Kickstarter, Werewolf / Mafia]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Mackenzie Schubert]</td>\n",
       "      <td>[1, 2, 3, 4, 5]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>283</th>\n",
       "      <td>77130</td>\n",
       "      <td>2010</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>240</td>\n",
       "      <td>120</td>\n",
       "      <td>240</td>\n",
       "      <td>17099</td>\n",
       "      <td>12911</td>\n",
       "      <td>7.46498</td>\n",
       "      <td>...</td>\n",
       "      <td>[4X games]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>142</td>\n",
       "      <td>[Henning Ludvigsen]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>284</th>\n",
       "      <td>160477</td>\n",
       "      <td>2014</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>20</td>\n",
       "      <td>15</td>\n",
       "      <td>20</td>\n",
       "      <td>13947</td>\n",
       "      <td>8577</td>\n",
       "      <td>7.53089</td>\n",
       "      <td>...</td>\n",
       "      <td>[5x5 grid, Asian Theme, Combinatorial, Country...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Jun Kondo, Mariusz Szmerdt]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285</th>\n",
       "      <td>760</td>\n",
       "      <td>2000</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>16863</td>\n",
       "      <td>13700</td>\n",
       "      <td>7.41829</td>\n",
       "      <td>...</td>\n",
       "      <td>[Schotten-Totten]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>140</td>\n",
       "      <td>[Roland MacDonald, Rodger B. MacGowan, Mark Si...</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286</th>\n",
       "      <td>204583</td>\n",
       "      <td>2016</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>20</td>\n",
       "      <td>15</td>\n",
       "      <td>20</td>\n",
       "      <td>27782</td>\n",
       "      <td>16602</td>\n",
       "      <td>7.40054</td>\n",
       "      <td>...</td>\n",
       "      <td>[Admin: Better Description Needed!, Blue Orang...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Cyril Bouquet]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>287</th>\n",
       "      <td>41114</td>\n",
       "      <td>2009</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>46323</td>\n",
       "      <td>30558</td>\n",
       "      <td>7.35537</td>\n",
       "      <td>...</td>\n",
       "      <td>[Dystopian Universe, Postcard Box Games, Werew...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Luis Francisco, Luis Franco, Piotr Haraszczak...</td>\n",
       "      <td>[1, 2, 3, 4]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>288</th>\n",
       "      <td>19777</td>\n",
       "      <td>2005</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>240</td>\n",
       "      <td>180</td>\n",
       "      <td>240</td>\n",
       "      <td>4191</td>\n",
       "      <td>3381</td>\n",
       "      <td>7.82166</td>\n",
       "      <td>...</td>\n",
       "      <td>[Asian Theme, Country: Indonesia]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>100</td>\n",
       "      <td>[Jeroen Kesselaar, Ynze Moedt]</td>\n",
       "      <td>[1, 2]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>289</th>\n",
       "      <td>119890</td>\n",
       "      <td>2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>30</td>\n",
       "      <td>15804</td>\n",
       "      <td>10604</td>\n",
       "      <td>7.4436</td>\n",
       "      <td>...</td>\n",
       "      <td>[Agricola, Animals: Cattle, Animals: Horses, A...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>141</td>\n",
       "      <td>[Klemens Franz]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>290</th>\n",
       "      <td>45315</td>\n",
       "      <td>2009</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>90</td>\n",
       "      <td>90</td>\n",
       "      <td>90</td>\n",
       "      <td>12974</td>\n",
       "      <td>11791</td>\n",
       "      <td>7.42522</td>\n",
       "      <td>...</td>\n",
       "      <td>[Dungeon Lords]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>138</td>\n",
       "      <td>[David Cochard]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>291</th>\n",
       "      <td>59959</td>\n",
       "      <td>2011</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>120</td>\n",
       "      <td>120</td>\n",
       "      <td>120</td>\n",
       "      <td>15361</td>\n",
       "      <td>11229</td>\n",
       "      <td>7.4528</td>\n",
       "      <td>...</td>\n",
       "      <td>[Characters: Jack the Ripper, Cities: London, ...</td>\n",
       "      <td>64</td>\n",
       "      <td>152</td>\n",
       "      <td>[Gianluca Santopietro]</td>\n",
       "      <td>[1, 6]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>292</th>\n",
       "      <td>172081</td>\n",
       "      <td>2015</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>90</td>\n",
       "      <td>45</td>\n",
       "      <td>90</td>\n",
       "      <td>9665</td>\n",
       "      <td>5381</td>\n",
       "      <td>7.63707</td>\n",
       "      <td>...</td>\n",
       "      <td>[Crowdfunding: Kickstarter, Crowdfunding: Spie...</td>\n",
       "      <td>49</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Virginia Critchfield, Ryan Goldsberry, Heiko ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>293</th>\n",
       "      <td>40692</td>\n",
       "      <td>2009</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>80</td>\n",
       "      <td>40</td>\n",
       "      <td>80</td>\n",
       "      <td>66734</td>\n",
       "      <td>51386</td>\n",
       "      <td>7.31193</td>\n",
       "      <td>...</td>\n",
       "      <td>[Small World]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>171</td>\n",
       "      <td>[Miguel Coimbra, Cyrille Daujean]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>26</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>163745</td>\n",
       "      <td>2015</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>120</td>\n",
       "      <td>120</td>\n",
       "      <td>120</td>\n",
       "      <td>7516</td>\n",
       "      <td>3627</td>\n",
       "      <td>7.92071</td>\n",
       "      <td>...</td>\n",
       "      <td>[Components: Miniatures, Star Wars, Star Wars:...</td>\n",
       "      <td>36</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[Ben Zweifel]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>295</th>\n",
       "      <td>144344</td>\n",
       "      <td>2013</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>120</td>\n",
       "      <td>60</td>\n",
       "      <td>120</td>\n",
       "      <td>7126</td>\n",
       "      <td>5908</td>\n",
       "      <td>7.57563</td>\n",
       "      <td>...</td>\n",
       "      <td>[]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>126</td>\n",
       "      <td>[Michael Menzel]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>296</th>\n",
       "      <td>13122</td>\n",
       "      <td>2004</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>180</td>\n",
       "      <td>120</td>\n",
       "      <td>180</td>\n",
       "      <td>4368</td>\n",
       "      <td>2943</td>\n",
       "      <td>7.89608</td>\n",
       "      <td>...</td>\n",
       "      <td>[Polyominoes]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>99</td>\n",
       "      <td>[Ynze Moedt]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>297</th>\n",
       "      <td>109276</td>\n",
       "      <td>2014</td>\n",
       "      <td>2</td>\n",
       "      <td>4</td>\n",
       "      <td>120</td>\n",
       "      <td>90</td>\n",
       "      <td>120</td>\n",
       "      <td>5058</td>\n",
       "      <td>3669</td>\n",
       "      <td>7.7831</td>\n",
       "      <td>...</td>\n",
       "      <td>[Automotive, Crowdfunding: Giochistarter, Stro...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>112</td>\n",
       "      <td>[Naomi Robinson, Vital Lacerda]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>176920</td>\n",
       "      <td>2015</td>\n",
       "      <td>2</td>\n",
       "      <td>6</td>\n",
       "      <td>90</td>\n",
       "      <td>45</td>\n",
       "      <td>90</td>\n",
       "      <td>9144</td>\n",
       "      <td>6613</td>\n",
       "      <td>7.54006</td>\n",
       "      <td>...</td>\n",
       "      <td>[Components: Miniatures, Planets: Mars, Steamp...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>136</td>\n",
       "      <td>[Andrew Bosley, Samuel Shimota, Alyn Spiller]</td>\n",
       "      <td>[1, 2]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>21</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>176734</td>\n",
       "      <td>2016</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>120</td>\n",
       "      <td>60</td>\n",
       "      <td>120</td>\n",
       "      <td>4933</td>\n",
       "      <td>3331</td>\n",
       "      <td>7.84657</td>\n",
       "      <td>...</td>\n",
       "      <td>[Crowdfunding: Kickstarter, The Manhattan Proj...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>115</td>\n",
       "      <td>[Josh Cappel, Jeffrey Edwards]</td>\n",
       "      <td>[1]</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>300 rows × 49 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "         ID Year Published Min Players Max Players Playing Time  \\\n",
       "0    174430           2017           1           4          120   \n",
       "1    161936           2015           2           4           60   \n",
       "2    182028           2015           2           4          240   \n",
       "3    167791           2016           1           5          120   \n",
       "4     12333           2005           2           2          180   \n",
       "5    187645           2016           2           4          240   \n",
       "6    169786           2016           1           5          115   \n",
       "7    220308           2017           1           4          150   \n",
       "8    193738           2016           2           4          150   \n",
       "9    120677           2012           2           5          150   \n",
       "10    84876           2011           2           4           90   \n",
       "11   115746           2012           2           4          180   \n",
       "12   173346           2015           2           2           30   \n",
       "13   180263           2017           1           4         1000   \n",
       "14   233078           2017           3           6          480   \n",
       "15     3076           2002           2           5          150   \n",
       "16   102794           2013           1           7          210   \n",
       "17   205637           2016           1           2          120   \n",
       "18   183394           2015           1           6           90   \n",
       "19   124361           2013           2           5          100   \n",
       "20    31260           2007           1           5          150   \n",
       "21    96848           2011           1           4          240   \n",
       "22   162886           2017           1           4          120   \n",
       "23   205059           2016           1           5          180   \n",
       "24    28720           2007           2           4          120   \n",
       "25   164928           2014           2           4           90   \n",
       "26   170216           2015           2           4           90   \n",
       "27   175914           2015           2           5          240   \n",
       "28   209010           2016           2           4           90   \n",
       "29   177736           2016           1           4          120   \n",
       "..      ...            ...         ...         ...          ...   \n",
       "270  172818           2015           2           4           90   \n",
       "271  203420           2016           1           6          120   \n",
       "272  181304           2015           2           7           42   \n",
       "273   92828           2011           3          12           30   \n",
       "274     421           1986           2           7          360   \n",
       "275   66589           2010           2           5           90   \n",
       "276  198994           2016           2           4           30   \n",
       "277   54138           2009           2           6          180   \n",
       "278  181279           2015           2           5          180   \n",
       "279       3           1998           2           4           60   \n",
       "280   17392           2006           2           6          360   \n",
       "281  192135           2017           1           4          120   \n",
       "282  188834           2016           5          10           45   \n",
       "283   77130           2010           2           4          240   \n",
       "284  160477           2014           2           2           20   \n",
       "285     760           2000           2           2           30   \n",
       "286  204583           2016           2           4           20   \n",
       "287   41114           2009           5          10           30   \n",
       "288   19777           2005           2           5          240   \n",
       "289  119890           2012           2           2           30   \n",
       "290   45315           2009           2           4           90   \n",
       "291   59959           2011           2           6          120   \n",
       "292  172081           2015           1           4           90   \n",
       "293   40692           2009           2           5           80   \n",
       "294  163745           2015           2           2          120   \n",
       "295  144344           2013           2           5          120   \n",
       "296   13122           2004           2           4          180   \n",
       "297  109276           2014           2           4          120   \n",
       "298  176920           2015           2           6           90   \n",
       "299  176734           2016           1           5          120   \n",
       "\n",
       "    Min Playing Time Max Playing Time  Owned Users Rated Average Rating  \\\n",
       "0                 60              120  33576       20312        8.92994   \n",
       "1                 60               60  45427       28528        8.65145   \n",
       "2                180              240  17668       14006        8.56732   \n",
       "3                120              120  40824       32136        8.39275   \n",
       "4                120              180  44900       32806        8.33008   \n",
       "5                180              240  22816       14956        8.45402   \n",
       "6                 90              115  44416       34220        8.28321   \n",
       "7                 60              150   8928        7219        8.59267   \n",
       "8                 75              150  19872       16334        8.28944   \n",
       "9                 60              150  34333       30969        8.21162   \n",
       "10                30               90  47526       34118        8.12684   \n",
       "11               150              180  14598        8988        8.39623   \n",
       "12                30               30  55865       36260        8.13675   \n",
       "13                 5             1000  15181        7869        8.52118   \n",
       "14               240              480   6546        4537        8.76953   \n",
       "15                90              150  63235       54603        8.04659   \n",
       "16                30              210  28460       22398        8.09309   \n",
       "17                60              120  27406       14698        8.23798   \n",
       "18                45               90  19732       14616        8.14724   \n",
       "19               100              100  20402       17576        8.08661   \n",
       "20                30              150  66409       55262        8.00648   \n",
       "21                60              240  33033       22465        8.10599   \n",
       "22                90              120  10945        7045        8.39409   \n",
       "23               120              180  22674       14417        8.17646   \n",
       "24                60              120  17988       13610         8.0943   \n",
       "25                90               90  16798       14337        8.08353   \n",
       "26                60               90  28468       23257        8.04858   \n",
       "27               120              240  10579        8657        8.19729   \n",
       "28                60               90  15705       10310        8.16758   \n",
       "29                30              120  12740        9611        8.16685   \n",
       "..               ...              ...    ...         ...            ...   \n",
       "270               90               90  14173        9230         7.5395   \n",
       "271               60              120   8071        4900        7.72197   \n",
       "272               42               42  31524       20856        7.42479   \n",
       "273               30               30  17030       12582        7.48597   \n",
       "274              180              360   5446        3800        7.83291   \n",
       "275               60               90   6719        7045        7.56928   \n",
       "276               20               30  12467        6426        7.68017   \n",
       "277              120              180   5234        4822        7.71908   \n",
       "278              120              180  14374        7427        7.59177   \n",
       "279               30               60  13203       13129        7.44234   \n",
       "280              180              360   4772        3205        7.93629   \n",
       "281               60              120   3459        1995        8.55082   \n",
       "282               45               45  13036        9571        7.58372   \n",
       "283              120              240  17099       12911        7.46498   \n",
       "284               15               20  13947        8577        7.53089   \n",
       "285               30               30  16863       13700        7.41829   \n",
       "286               15               20  27782       16602        7.40054   \n",
       "287               30               30  46323       30558        7.35537   \n",
       "288              180              240   4191        3381        7.82166   \n",
       "289               30               30  15804       10604         7.4436   \n",
       "290               90               90  12974       11791        7.42522   \n",
       "291              120              120  15361       11229         7.4528   \n",
       "292               45               90   9665        5381        7.63707   \n",
       "293               40               80  66734       51386        7.31193   \n",
       "294              120              120   7516        3627        7.92071   \n",
       "295               60              120   7126        5908        7.57563   \n",
       "296              120              180   4368        2943        7.89608   \n",
       "297               90              120   5058        3669         7.7831   \n",
       "298               45               90   9144        6613        7.54006   \n",
       "299               60              120   4933        3331        7.84657   \n",
       "\n",
       "          ...                                              Game Family  \\\n",
       "0         ...        [Campaign Games, Components: Miniatures, Crowd...   \n",
       "1         ...                       [Campaign Games, Legacy, Pandemic]   \n",
       "2         ...                                       [Tableau Building]   \n",
       "3         ...        [Fryxgames' Future Timeline, Planets: Mars, So...   \n",
       "4         ...        [Country: Soviet Union, Country: USA, Historic...   \n",
       "5         ...                      [Components: Miniatures, Star Wars]   \n",
       "6         ...        [Alternate History, Components: Miniatures, Cr...   \n",
       "7         ...        [Solitaire Games, Tableau Building, Terra Myst...   \n",
       "8         ...        [Animals: Cattle, Stronghold Games: The Great ...   \n",
       "9         ...                        [Tableau Building, Terra Mystica]   \n",
       "10        ...        [Alea Big Box, Country: France, Tableau Building]   \n",
       "11        ...        [Components: Miniatures, Monsters, Tolkien Gam...   \n",
       "12        ...            [7 Wonders, 7 Wonders Duel, Tableau Building]   \n",
       "13        ...        [The 7th Continent, Campaign Games, Components...   \n",
       "14        ...        [4X games, Components: Miniatures, Twilight Im...   \n",
       "15        ...        [Alea Big Box, Colonial Theme, Country: Puerto...   \n",
       "16        ...        [Animals: Sheep, Caverna, Harvest Series, Mini...   \n",
       "17        ...        [Arkham Horror, Arkham Horror: The Card Game L...   \n",
       "18        ...        [Country: Italy, Solitaire Games, Theme: Farmi...   \n",
       "19        ...                                [Ancient Rome, Concordia]   \n",
       "20        ...        [Agricola, Animals: Cattle, Animals: Horses, A...   \n",
       "21        ...        [Clix, Components: Miniatures, Mage Knight Uni...   \n",
       "22        ...        [Colonial Theme, Components: Miniatures, Crowd...   \n",
       "23        ...        [Arkham Horror, Components: Miniatures, Cthulh...   \n",
       "24        ...                   [Cities: Manchester, Country: England]   \n",
       "25        ...        [Cities: Orléans (France), Country: France, Cr...   \n",
       "26        ...        [Components: Miniatures, Crowdfunding: Kicksta...   \n",
       "27        ...                                         [Food / Cooking]   \n",
       "28        ...                 [Campaign Games, Components: Miniatures]   \n",
       "29        ...        [Admin: Better Description Needed!, Food / Coo...   \n",
       "..        ...                                                      ...   \n",
       "270       ...        [Above and Below, Crowdfunding: Kickstarter, W...   \n",
       "271       ...                     [Escape Room Games, EXIT: Das Spiel]   \n",
       "272       ...                 [Ghosts, Holidays: Halloween, Mysterium]   \n",
       "273       ...                                   [Dixit, Judging Games]   \n",
       "274       ...                                     [18xx, Country: USA]   \n",
       "275       ...        [Age of Discovery, Colonial Theme, Country: Po...   \n",
       "276       ...                 [Crowdfunding: Kickstarter, Hero Realms]   \n",
       "277       ...                                          [Rondel Series]   \n",
       "278       ...                                               [Vampires]   \n",
       "279       ...        [Asian Theme, Country: Japan, Knizia tile-layi...   \n",
       "280       ...        [Cities: Ravenna (Italy), Country: England, Co...   \n",
       "281       ...        [Crowdfunding: Kickstarter, Solitaire Games, T...   \n",
       "282       ...            [Crowdfunding: Kickstarter, Werewolf / Mafia]   \n",
       "283       ...                                               [4X games]   \n",
       "284       ...        [5x5 grid, Asian Theme, Combinatorial, Country...   \n",
       "285       ...                                        [Schotten-Totten]   \n",
       "286       ...        [Admin: Better Description Needed!, Blue Orang...   \n",
       "287       ...        [Dystopian Universe, Postcard Box Games, Werew...   \n",
       "288       ...                        [Asian Theme, Country: Indonesia]   \n",
       "289       ...        [Agricola, Animals: Cattle, Animals: Horses, A...   \n",
       "290       ...                                          [Dungeon Lords]   \n",
       "291       ...        [Characters: Jack the Ripper, Cities: London, ...   \n",
       "292       ...        [Crowdfunding: Kickstarter, Crowdfunding: Spie...   \n",
       "293       ...                                            [Small World]   \n",
       "294       ...        [Components: Miniatures, Star Wars, Star Wars:...   \n",
       "295       ...                                                       []   \n",
       "296       ...                                            [Polyominoes]   \n",
       "297       ...        [Automotive, Crowdfunding: Giochistarter, Stro...   \n",
       "298       ...        [Components: Miniatures, Planets: Mars, Steamp...   \n",
       "299       ...        [Crowdfunding: Kickstarter, The Manhattan Proj...   \n",
       "\n",
       "    Thematic Rank Strategy Game Rank  \\\n",
       "0               1                  1   \n",
       "1               2                  2   \n",
       "2             NaN                  3   \n",
       "3             NaN                  4   \n",
       "4             NaN                  7   \n",
       "5               3                  6   \n",
       "6             NaN                  9   \n",
       "7             NaN                  5   \n",
       "8             NaN                  8   \n",
       "9             NaN                 10   \n",
       "10            NaN                 12   \n",
       "11              4                NaN   \n",
       "12            NaN                 13   \n",
       "13              5                NaN   \n",
       "14            NaN                 11   \n",
       "15            NaN                 21   \n",
       "16            NaN                 15   \n",
       "17              9                NaN   \n",
       "18            NaN                 18   \n",
       "19            NaN                 16   \n",
       "20            NaN                 25   \n",
       "21             12                 26   \n",
       "22              7                 14   \n",
       "23             10                NaN   \n",
       "24            NaN                 17   \n",
       "25            NaN                 22   \n",
       "26             14                 29   \n",
       "27            NaN                 20   \n",
       "28             11                 28   \n",
       "29            NaN                 24   \n",
       "..            ...                ...   \n",
       "270            50                131   \n",
       "271            33                NaN   \n",
       "272            61                NaN   \n",
       "273           NaN                NaN   \n",
       "274           NaN                 96   \n",
       "275           NaN                113   \n",
       "276           NaN                134   \n",
       "277           NaN                104   \n",
       "278            43                NaN   \n",
       "279           NaN                132   \n",
       "280           NaN                NaN   \n",
       "281            19                 93   \n",
       "282           NaN                NaN   \n",
       "283           NaN                142   \n",
       "284           NaN                NaN   \n",
       "285           NaN                140   \n",
       "286           NaN                NaN   \n",
       "287           NaN                NaN   \n",
       "288           NaN                100   \n",
       "289           NaN                141   \n",
       "290           NaN                138   \n",
       "291            64                152   \n",
       "292            49                NaN   \n",
       "293           NaN                171   \n",
       "294            36                NaN   \n",
       "295           NaN                126   \n",
       "296           NaN                 99   \n",
       "297           NaN                112   \n",
       "298           NaN                136   \n",
       "299           NaN                115   \n",
       "\n",
       "                                          Game Artists  \\\n",
       "0    [Alexandr Elichev, Josh T. McDowell, Alvaro Ne...   \n",
       "1                                    [Chris Quilliams]   \n",
       "2                       [Jakub Politzer, Milan Vavroň]   \n",
       "3                                    [Isaac Fryxelius]   \n",
       "4    [Viktor Csete, Rodger B. MacGowan, Chechu Niet...   \n",
       "5                                                   []   \n",
       "6                                     [Jakub Rozalski]   \n",
       "7                                    [Dennis Lohausen]   \n",
       "8                                      [Andreas Resch]   \n",
       "9                                    [Dennis Lohausen]   \n",
       "10                      [Julien Delval, Harald Lieske]   \n",
       "11                         [John Howe, Fabio Maiorana]   \n",
       "12                                    [Miguel Coimbra]   \n",
       "13                                     [Ludovic Roudy]   \n",
       "14                                   [Scott Schomburg]   \n",
       "15                    [Harald Lieske, Franz Vohwinkel]   \n",
       "16                                     [Klemens Franz]   \n",
       "17   [Christopher Hosch, Marcin Jakubowski, Ignacio...   \n",
       "18        [Jacqui Davis, David Montgomery, Beth Sobel]   \n",
       "19      [Marina Fahrenbach, Mac Gerdts, Dominik Mayer]   \n",
       "20                                     [Klemens Franz]   \n",
       "21              [J. Lonnee, Chris Raimo, Milan Vavroň]   \n",
       "22   [Jason Behnke, Kat G Bermelin, Loïc Billiau, C...   \n",
       "23   [Cristi Balanescu, Yoann Boissonnet, Anders Fi...   \n",
       "24   [Lina Cossette, Peter Dennis, David Forest, Ec...   \n",
       "25                                     [Klemens Franz]   \n",
       "26       [Henning Ludvigsen, Mike McVey, Adrian Smith]   \n",
       "27                          [Iris de Haan, Ynze Moedt]   \n",
       "28                       [Danny Beck, Tysen Henderson]   \n",
       "29                                   [Dennis Lohausen]   \n",
       "..                                                 ...   \n",
       "270                                      [Ryan Laukat]   \n",
       "271  [Inka Brand, Markus Brand, Silvia Christoph, F...   \n",
       "272  [Igor Burlakov, Xavier Collette, Oleksandr Nev...   \n",
       "273                            [Marie Cardouat, Pierô]   \n",
       "274  [Mike Atkinson, Jared Blando, Charles Kibler, ...   \n",
       "275                    [Marina Fahrenbach, Mac Gerdts]   \n",
       "276  [Randy Delven, Vito Gesualdi, Antonis Papanton...   \n",
       "277                                   [Alexander Jung]   \n",
       "278                       [Chris Beck, Samuel Shimota]   \n",
       "279                                  [Franz Vohwinkel]   \n",
       "280               [Rodger B. MacGowan, Mark Simonitch]   \n",
       "281              [Josh J. Carlson, Anthony LeTourneau]   \n",
       "282                               [Mackenzie Schubert]   \n",
       "283                                [Henning Ludvigsen]   \n",
       "284                       [Jun Kondo, Mariusz Szmerdt]   \n",
       "285  [Roland MacDonald, Rodger B. MacGowan, Mark Si...   \n",
       "286                                    [Cyril Bouquet]   \n",
       "287  [Luis Francisco, Luis Franco, Piotr Haraszczak...   \n",
       "288                     [Jeroen Kesselaar, Ynze Moedt]   \n",
       "289                                    [Klemens Franz]   \n",
       "290                                    [David Cochard]   \n",
       "291                             [Gianluca Santopietro]   \n",
       "292  [Virginia Critchfield, Ryan Goldsberry, Heiko ...   \n",
       "293                  [Miguel Coimbra, Cyrille Daujean]   \n",
       "294                                      [Ben Zweifel]   \n",
       "295                                   [Michael Menzel]   \n",
       "296                                       [Ynze Moedt]   \n",
       "297                    [Naomi Robinson, Vital Lacerda]   \n",
       "298      [Andrew Bosley, Samuel Shimota, Alyn Spiller]   \n",
       "299                     [Josh Cappel, Jeffrey Edwards]   \n",
       "\n",
       "    Num Players Not Recommended War Game Rank Customizable Rank  \\\n",
       "0                           NaN           NaN               NaN   \n",
       "1                           [1]           NaN               NaN   \n",
       "2                           [1]           NaN               NaN   \n",
       "3                           [5]           NaN               NaN   \n",
       "4                           [1]             1               NaN   \n",
       "5                     [1, 3, 4]           NaN               NaN   \n",
       "6                           NaN           NaN               NaN   \n",
       "7                           NaN           NaN               NaN   \n",
       "8                           [1]           NaN               NaN   \n",
       "9                           [1]           NaN               NaN   \n",
       "10                          [1]           NaN               NaN   \n",
       "11                    [1, 3, 4]             2               NaN   \n",
       "12                          [1]           NaN               NaN   \n",
       "13                          [4]           NaN               NaN   \n",
       "14                       [1, 2]           NaN               NaN   \n",
       "15                       [1, 2]           NaN               NaN   \n",
       "16                       [6, 7]           NaN               NaN   \n",
       "17                          NaN           NaN                 1   \n",
       "18                          NaN           NaN               NaN   \n",
       "19                          [1]           NaN               NaN   \n",
       "20                          NaN           NaN               NaN   \n",
       "21                          [4]           NaN               NaN   \n",
       "22                          NaN           NaN               NaN   \n",
       "23                          NaN           NaN               NaN   \n",
       "24                          [1]           NaN               NaN   \n",
       "25                          [1]           NaN               NaN   \n",
       "26                       [1, 2]           NaN               NaN   \n",
       "27                          [1]           NaN               NaN   \n",
       "28                          [1]           NaN               NaN   \n",
       "29                          NaN           NaN               NaN   \n",
       "..                          ...           ...               ...   \n",
       "270                         [1]           NaN               NaN   \n",
       "271                      [5, 6]           NaN               NaN   \n",
       "272                      [1, 2]           NaN               NaN   \n",
       "273                   [1, 2, 3]           NaN               NaN   \n",
       "274                   [1, 2, 7]           NaN               NaN   \n",
       "275                         [1]           NaN               NaN   \n",
       "276                         [1]           NaN                12   \n",
       "277                      [1, 2]           NaN               NaN   \n",
       "278                         [1]           NaN               NaN   \n",
       "279                         [1]           NaN               NaN   \n",
       "280                [1, 2, 4, 5]             8               NaN   \n",
       "281                         NaN           NaN               NaN   \n",
       "282             [1, 2, 3, 4, 5]           NaN               NaN   \n",
       "283                         [1]           NaN               NaN   \n",
       "284                         [1]           NaN               NaN   \n",
       "285                         [1]           NaN               NaN   \n",
       "286                         [1]           NaN               NaN   \n",
       "287                [1, 2, 3, 4]           NaN               NaN   \n",
       "288                      [1, 2]           NaN               NaN   \n",
       "289                         [1]           NaN               NaN   \n",
       "290                         [1]           NaN               NaN   \n",
       "291                      [1, 6]           NaN               NaN   \n",
       "292                         NaN           NaN               NaN   \n",
       "293                         [1]           NaN               NaN   \n",
       "294                         [1]            31               NaN   \n",
       "295                         [1]           NaN               NaN   \n",
       "296                         [1]           NaN               NaN   \n",
       "297                         [1]           NaN               NaN   \n",
       "298                      [1, 2]           NaN               NaN   \n",
       "299                         [1]           NaN               NaN   \n",
       "\n",
       "    Abstract Game Rank Family Game Rank Party Game Rank  \n",
       "0                  NaN              NaN             NaN  \n",
       "1                  NaN              NaN             NaN  \n",
       "2                  NaN              NaN             NaN  \n",
       "3                  NaN              NaN             NaN  \n",
       "4                  NaN              NaN             NaN  \n",
       "5                  NaN              NaN             NaN  \n",
       "6                  NaN              NaN             NaN  \n",
       "7                  NaN              NaN             NaN  \n",
       "8                  NaN              NaN             NaN  \n",
       "9                  NaN              NaN             NaN  \n",
       "10                 NaN              NaN             NaN  \n",
       "11                 NaN              NaN             NaN  \n",
       "12                 NaN              NaN             NaN  \n",
       "13                 NaN              NaN             NaN  \n",
       "14                 NaN              NaN             NaN  \n",
       "15                 NaN              NaN             NaN  \n",
       "16                 NaN              NaN             NaN  \n",
       "17                 NaN              NaN             NaN  \n",
       "18                 NaN              NaN             NaN  \n",
       "19                 NaN              NaN             NaN  \n",
       "20                 NaN              NaN             NaN  \n",
       "21                 NaN              NaN             NaN  \n",
       "22                 NaN              NaN             NaN  \n",
       "23                 NaN              NaN             NaN  \n",
       "24                 NaN              NaN             NaN  \n",
       "25                 NaN              NaN             NaN  \n",
       "26                 NaN              NaN             NaN  \n",
       "27                 NaN              NaN             NaN  \n",
       "28                 NaN              NaN             NaN  \n",
       "29                 NaN              NaN             NaN  \n",
       "..                 ...              ...             ...  \n",
       "270                NaN              NaN             NaN  \n",
       "271                NaN               14             NaN  \n",
       "272                NaN               22             NaN  \n",
       "273                NaN              NaN               7  \n",
       "274                NaN              NaN             NaN  \n",
       "275                NaN              NaN             NaN  \n",
       "276                NaN              NaN             NaN  \n",
       "277                NaN              NaN             NaN  \n",
       "278                NaN              NaN             NaN  \n",
       "279                NaN              NaN             NaN  \n",
       "280                NaN              NaN             NaN  \n",
       "281                NaN              NaN             NaN  \n",
       "282                NaN              NaN              14  \n",
       "283                NaN              NaN             NaN  \n",
       "284                  9              NaN             NaN  \n",
       "285                NaN              NaN             NaN  \n",
       "286                NaN               23             NaN  \n",
       "287                NaN              NaN              17  \n",
       "288                NaN              NaN             NaN  \n",
       "289                NaN              NaN             NaN  \n",
       "290                NaN              NaN             NaN  \n",
       "291                NaN              NaN             NaN  \n",
       "292                NaN               20             NaN  \n",
       "293                NaN               26             NaN  \n",
       "294                NaN              NaN             NaN  \n",
       "295                NaN              NaN             NaN  \n",
       "296                NaN              NaN             NaN  \n",
       "297                NaN              NaN             NaN  \n",
       "298                NaN               21             NaN  \n",
       "299                NaN              NaN             NaN  \n",
       "\n",
       "[300 rows x 49 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "game_stats"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>Name</th>\n",
       "      <th>Rank</th>\n",
       "      <th>ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>298</th>\n",
       "      <td>Biblios</td>\n",
       "      <td>299</td>\n",
       "      <td>34219</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>299</th>\n",
       "      <td>Small World Underground</td>\n",
       "      <td>300</td>\n",
       "      <td>97786</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>300</th>\n",
       "      <td>Madeira</td>\n",
       "      <td>301</td>\n",
       "      <td>95527</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Name  Rank     ID\n",
       "298                  Biblios   299  34219\n",
       "299  Small World Underground   300  97786\n",
       "300                  Madeira   301  95527"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "top_games[298:301]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": []
  },
  {
   "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
}