Part_0_games_and_friends_dataset_setup_draft.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyPJXA8HwQBIXSDEYlD5rwrL",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/CS-Edwards/games_and_friends/blob/main/Part_0_games_and_friends_dataset_setup_draft.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "l6Wfe1nIsIV1",
        "outputId": "8ed7d0eb-686f-4ba4-90bd-a81b62faab5f"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m325.2/325.2 kB\u001b[0m \u001b[31m3.8 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m75.6/75.6 kB\u001b[0m \u001b[31m2.1 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m40.0/40.0 kB\u001b[0m \u001b[31m1.3 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m223.8/223.8 kB\u001b[0m \u001b[31m7.1 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m2.3/2.3 MB\u001b[0m \u001b[31m11.7 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m309.2/309.2 kB\u001b[0m \u001b[31m2.4 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m77.9/77.9 kB\u001b[0m \u001b[31m3.7 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m58.3/58.3 kB\u001b[0m \u001b[31m4.4 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[?25h\u001b[31mERROR: pip's dependency resolver does not currently take into account all the packages that are installed. This behaviour is the source of the following dependency conflicts.\n",
            "cudf-cu12 24.4.1 requires protobuf<5,>=3.20, but you have protobuf 5.27.0 which is incompatible.\n",
            "google-ai-generativelanguage 0.6.4 requires protobuf!=3.20.0,!=3.20.1,!=4.21.0,!=4.21.1,!=4.21.2,!=4.21.3,!=4.21.4,!=4.21.5,<5.0.0dev,>=3.19.5, but you have protobuf 5.27.0 which is incompatible.\n",
            "google-api-core 2.11.1 requires protobuf!=3.20.0,!=3.20.1,!=4.21.0,!=4.21.1,!=4.21.2,!=4.21.3,!=4.21.4,!=4.21.5,<5.0.0.dev0,>=3.19.5, but you have protobuf 5.27.0 which is incompatible.\n",
            "google-cloud-aiplatform 1.52.0 requires protobuf!=3.20.0,!=3.20.1,!=4.21.0,!=4.21.1,!=4.21.2,!=4.21.3,!=4.21.4,!=4.21.5,<5.0.0dev,>=3.19.5, but you have protobuf 5.27.0 which is incompatible.\n",
            "google-cloud-bigquery-connection 1.12.1 requires protobuf!=3.20.0,!=3.20.1,!=4.21.0,!=4.21.1,!=4.21.2,!=4.21.3,!=4.21.4,!=4.21.5,<5.0.0dev,>=3.19.5, but you have protobuf 5.27.0 which is incompatible.\n",
            "google-cloud-bigquery-storage 2.25.0 requires protobuf!=3.20.0,!=3.20.1,!=4.21.0,!=4.21.1,!=4.21.2,!=4.21.3,!=4.21.4,!=4.21.5,<5.0.0dev,>=3.19.5, but you have protobuf 5.27.0 which is incompatible.\n",
            "google-cloud-datastore 2.15.2 requires protobuf!=3.20.0,!=3.20.1,!=4.21.0,!=4.21.1,!=4.21.2,!=4.21.3,!=4.21.4,!=4.21.5,<5.0.0dev,>=3.19.5, but you have protobuf 5.27.0 which is incompatible.\n",
            "google-cloud-firestore 2.11.1 requires protobuf!=3.20.0,!=3.20.1,!=4.21.0,!=4.21.1,!=4.21.2,!=4.21.3,!=4.21.4,!=4.21.5,<5.0.0dev,>=3.19.5, but you have protobuf 5.27.0 which is incompatible.\n",
            "google-cloud-functions 1.13.3 requires protobuf!=3.20.0,!=3.20.1,!=4.21.0,!=4.21.1,!=4.21.2,!=4.21.3,!=4.21.4,!=4.21.5,<5.0.0dev,>=3.19.5, but you have protobuf 5.27.0 which is incompatible.\n",
            "google-cloud-iam 2.15.0 requires protobuf!=3.20.0,!=3.20.1,!=4.21.0,!=4.21.1,!=4.21.2,!=4.21.3,!=4.21.4,!=4.21.5,<5.0.0dev,>=3.19.5, but you have protobuf 5.27.0 which is incompatible.\n",
            "google-cloud-language 2.13.3 requires protobuf!=3.20.0,!=3.20.1,!=4.21.0,!=4.21.1,!=4.21.2,!=4.21.3,!=4.21.4,!=4.21.5,<5.0.0dev,>=3.19.5, but you have protobuf 5.27.0 which is incompatible.\n",
            "google-cloud-resource-manager 1.12.3 requires protobuf!=3.20.0,!=3.20.1,!=4.21.0,!=4.21.1,!=4.21.2,!=4.21.3,!=4.21.4,!=4.21.5,<5.0.0dev,>=3.19.5, but you have protobuf 5.27.0 which is incompatible.\n",
            "google-cloud-translate 3.11.3 requires protobuf!=3.20.0,!=3.20.1,!=4.21.0,!=4.21.1,!=4.21.2,!=4.21.3,!=4.21.4,!=4.21.5,<5.0.0dev,>=3.19.5, but you have protobuf 5.27.0 which is incompatible.\n",
            "grpc-google-iam-v1 0.13.0 requires protobuf!=3.20.0,!=3.20.1,!=4.21.1,!=4.21.2,!=4.21.3,!=4.21.4,!=4.21.5,<5.0.0dev,>=3.19.5, but you have protobuf 5.27.0 which is incompatible.\n",
            "proto-plus 1.23.0 requires protobuf<5.0.0dev,>=3.19.0, but you have protobuf 5.27.0 which is incompatible.\n",
            "tensorflow 2.15.0 requires protobuf!=4.21.0,!=4.21.1,!=4.21.2,!=4.21.3,!=4.21.4,!=4.21.5,<5.0.0dev,>=3.20.3, but you have protobuf 5.27.0 which is incompatible.\n",
            "tensorflow-metadata 1.15.0 requires protobuf<4.21,>=3.20.3; python_version < \"3.11\", but you have protobuf 5.27.0 which is incompatible.\u001b[0m\u001b[31m\n",
            "\u001b[2K     \u001b[90m━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\u001b[0m \u001b[32m324.1/324.1 kB\u001b[0m \u001b[31m7.3 MB/s\u001b[0m eta \u001b[36m0:00:00\u001b[0m\n",
            "\u001b[?25h  Preparing metadata (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "  Building wheel for wikipedia (setup.py) ... \u001b[?25l\u001b[?25hdone\n",
            "COMPLETED INSTALL: Weaviate, Kaggle API, Wikipedia API, OpenAI API\n"
          ]
        }
      ],
      "source": [
        "#@title 🟢 [RUN FIRST] Install Project Packages\n",
        "!pip install -q kaggle\n",
        "!pip install -q wikipedia\n",
        "\n",
        "print(\"COMPLETED INSTALL:  Kaggle API, Wikipedia API\")\n",
        "\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "JXNmVer551jq"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "import os"
      ],
      "metadata": {
        "id": "Ir_S39EssZZ1"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#\n",
        "# Data From Kaggle\n",
        "#\n",
        "\n",
        "#First: Drag and drop kaggle.json into Colab (currentl saved in 'Downloads/')"
      ],
      "metadata": {
        "id": "DyzjibuA2PsT"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Kaggle Access resource: https://saturncloud.io/blog/how-to-use-kaggle-datasets-in-google-colab/\n",
        "# copy kaggle.json to /root/.kaggle/ folder so that kaggle cli can access it.\n",
        "# dataset: https://www.kaggle.com/datasets/medaxone/boardgamegeek-top100\n",
        "#from the dataset menu select \"Copy API command\"\n",
        "!mkdir /.kaggle\n",
        "!mv kaggle.json /.kaggle\n",
        "!mv /.kaggle /root/\n",
        "!chmod 600 ~/.kaggle/kaggle.json\n"
      ],
      "metadata": {
        "id": "DNgU9UC93u3o",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "cc3bf117-a8df-4598-c885-13e20ff487c1"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "mv: cannot stat 'kaggle.json': No such file or directory\n",
            "chmod: cannot access '/root/.kaggle/kaggle.json': No such file or directory\n",
            "Dataset URL: https://www.kaggle.com/datasets/medaxone/boardgamegeek-top100\n",
            "License(s): CC0-1.0\n",
            "Downloading boardgamegeek-top100.zip to /content\n",
            "  0% 0.00/6.71k [00:00<?, ?B/s]\n",
            "100% 6.71k/6.71k [00:00<00:00, 14.1MB/s]\n",
            "Archive:  boardgamegeek-top100.zip\n",
            "  inflating: BGG100.csv              \n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "!kaggle datasets download -d medaxone/boardgamegeek-top100\n",
        "!unzip boardgamegeek-top100.zip"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "DBPocggS2rce",
        "outputId": "7015afd0-b2df-45b7-d199-ccde3baacf52"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Dataset URL: https://www.kaggle.com/datasets/medaxone/boardgamegeek-top100\n",
            "License(s): CC0-1.0\n",
            "Downloading boardgamegeek-top100.zip to /content\n",
            "  0% 0.00/6.71k [00:00<?, ?B/s]\n",
            "100% 6.71k/6.71k [00:00<00:00, 12.6MB/s]\n",
            "Archive:  boardgamegeek-top100.zip\n",
            "  inflating: BGG100.csv              \n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "dzQfjZUA5hlh",
        "outputId": "b2dab96d-1ce3-4d0d-ad4a-09480401967a"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Archive:  boardgamegeek-top100.zip\n",
            "  inflating: BGG100.csv              \n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import pandas as pd\n",
        "import chardet\n",
        "\n",
        "#\n",
        "# Try this code if you run into UnicodeDecodeError\n",
        "#\n",
        "\n",
        "# @TODO move into utils\n",
        "\n",
        "# Function to detect file encoding\n",
        "def detect_encoding(file_path):\n",
        "    with open(file_path, 'rb') as f:\n",
        "        result = chardet.detect(f.read())\n",
        "    return result['encoding']\n",
        "\n",
        "# Try reading the CSV file with detected encoding\n",
        "try:\n",
        "    encoding = detect_encoding(\"BGG100.csv\")\n",
        "    data = pd.read_csv(\"BGG100.csv\", encoding=encoding)\n",
        "    print(\"File successfully loaded using encoding:\", encoding)\n",
        "except Exception as e:\n",
        "    print(\"Error:\", e)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "tfKzXtHP6qdA",
        "outputId": "fa84465a-e70f-4ea3-e2de-a7b0ae6d1e30"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "File successfully loaded using encoding: Windows-1252\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "E2whm1-O8cNw",
        "outputId": "dfe985c5-013b-40d1-cc01-86d6ab023988"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   Rank  Rating                               Name  \\\n",
              "0     1   8.511                        Gloomhaven    \n",
              "1     2   8.442          Pandemic Legacy: Season 1   \n",
              "2     3   8.418                  Brass: Birmingham   \n",
              "3     4   8.273                  Terraforming Mars   \n",
              "4     5   8.262  Twilight Imperium: Fourth Edition   \n",
              "\n",
              "                                            Subtitle  Year  MinPlayers  \\\n",
              "0  Vanquish monsters with strategic cardplay. Ful...  2017           1   \n",
              "1  Mutating diseases are spreading around the wor...  2015           2   \n",
              "2  Build networks, grow industries, and navigate ...  2018           2   \n",
              "3  Compete with rival CEOs to make Mars habitable...  2016           1   \n",
              "4  Build an intergalactic empire through trade, r...  2017           3   \n",
              "\n",
              "   MaxPlayers BestPlayers  MinPlayTime  MaxPlayTime  MinAge  Weight  \\\n",
              "0           4           3           60          120      14    3.87   \n",
              "1           4           4           60           60      13    2.83   \n",
              "2           4        3, 4           60          120      14    3.90   \n",
              "3           5           3          120          120      12    3.24   \n",
              "4           6           6          240          480      14    4.26   \n",
              "\n",
              "                  Type  \n",
              "0  Strategy,  Thematic  \n",
              "1  Strategy,  Thematic  \n",
              "2            Strategy   \n",
              "3            Strategy   \n",
              "4  Strategy,  Thematic  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-3cac2468-2196-4e51-be3b-719a5d34cbbf\" class=\"colab-df-container\">\n",
              "    <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>Rank</th>\n",
              "      <th>Rating</th>\n",
              "      <th>Name</th>\n",
              "      <th>Subtitle</th>\n",
              "      <th>Year</th>\n",
              "      <th>MinPlayers</th>\n",
              "      <th>MaxPlayers</th>\n",
              "      <th>BestPlayers</th>\n",
              "      <th>MinPlayTime</th>\n",
              "      <th>MaxPlayTime</th>\n",
              "      <th>MinAge</th>\n",
              "      <th>Weight</th>\n",
              "      <th>Type</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>8.511</td>\n",
              "      <td>Gloomhaven</td>\n",
              "      <td>Vanquish monsters with strategic cardplay. Ful...</td>\n",
              "      <td>2017</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>60</td>\n",
              "      <td>120</td>\n",
              "      <td>14</td>\n",
              "      <td>3.87</td>\n",
              "      <td>Strategy,  Thematic</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>8.442</td>\n",
              "      <td>Pandemic Legacy: Season 1</td>\n",
              "      <td>Mutating diseases are spreading around the wor...</td>\n",
              "      <td>2015</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>60</td>\n",
              "      <td>60</td>\n",
              "      <td>13</td>\n",
              "      <td>2.83</td>\n",
              "      <td>Strategy,  Thematic</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>8.418</td>\n",
              "      <td>Brass: Birmingham</td>\n",
              "      <td>Build networks, grow industries, and navigate ...</td>\n",
              "      <td>2018</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>3, 4</td>\n",
              "      <td>60</td>\n",
              "      <td>120</td>\n",
              "      <td>14</td>\n",
              "      <td>3.90</td>\n",
              "      <td>Strategy</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4</td>\n",
              "      <td>8.273</td>\n",
              "      <td>Terraforming Mars</td>\n",
              "      <td>Compete with rival CEOs to make Mars habitable...</td>\n",
              "      <td>2016</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>3</td>\n",
              "      <td>120</td>\n",
              "      <td>120</td>\n",
              "      <td>12</td>\n",
              "      <td>3.24</td>\n",
              "      <td>Strategy</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5</td>\n",
              "      <td>8.262</td>\n",
              "      <td>Twilight Imperium: Fourth Edition</td>\n",
              "      <td>Build an intergalactic empire through trade, r...</td>\n",
              "      <td>2017</td>\n",
              "      <td>3</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>240</td>\n",
              "      <td>480</td>\n",
              "      <td>14</td>\n",
              "      <td>4.26</td>\n",
              "      <td>Strategy,  Thematic</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-3cac2468-2196-4e51-be3b-719a5d34cbbf')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-3cac2468-2196-4e51-be3b-719a5d34cbbf button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-3cac2468-2196-4e51-be3b-719a5d34cbbf');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-32fc69e4-e112-4315-b87a-1bf338440237\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-32fc69e4-e112-4315-b87a-1bf338440237')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-32fc69e4-e112-4315-b87a-1bf338440237 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "data",
              "summary": "{\n  \"name\": \"data\",\n  \"rows\": 100,\n  \"fields\": [\n    {\n      \"column\": \"Rank\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 29,\n        \"min\": 1,\n        \"max\": 100,\n        \"num_unique_values\": 100,\n        \"samples\": [\n          84,\n          54,\n          71\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Rating\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.22611896283490984,\n        \"min\": 7.512,\n        \"max\": 8.511,\n        \"num_unique_values\": 95,\n        \"samples\": [\n          7.643,\n          7.944,\n          7.624\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Name\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 100,\n        \"samples\": [\n          \"Caylus\",\n          \"Star Wars: Imperial Assault\",\n          \"Teotihuacan: City of Gods\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Subtitle\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 100,\n        \"samples\": [\n          \"Entrepreneurs pay workers & bribe an official to build a Ch?teau & gain royal favor.\",\n          \"Play as Rebel or Imperial forces to fulfil mission objectives.\",\n          \"Use your worker dice to raise the legendary and breathtaking Pyramid of the Sun.\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Year\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 14,\n        \"min\": 1876,\n        \"max\": 2020,\n        \"num_unique_values\": 21,\n        \"samples\": [\n          2017,\n          2010,\n          2006\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MinPlayers\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0,\n        \"min\": 1,\n        \"max\": 3,\n        \"num_unique_values\": 3,\n        \"samples\": [\n          1,\n          2,\n          3\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MaxPlayers\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1,\n        \"min\": 2,\n        \"max\": 8,\n        \"num_unique_values\": 6,\n        \"samples\": [\n          4,\n          5,\n          8\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"BestPlayers\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 11,\n        \"samples\": [\n          \"4, 5\",\n          \"3\",\n          \"2, 4\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MinPlayTime\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 38,\n        \"min\": 5,\n        \"max\": 240,\n        \"num_unique_values\": 15,\n        \"samples\": [\n          40,\n          20,\n          60\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MaxPlayTime\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 107,\n        \"min\": 20,\n        \"max\": 1000,\n        \"num_unique_values\": 17,\n        \"samples\": [\n          120,\n          60,\n          180\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MinAge\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1,\n        \"min\": 8,\n        \"max\": 17,\n        \"num_unique_values\": 7,\n        \"samples\": [\n          14,\n          13,\n          17\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Weight\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.6982331525740777,\n        \"min\": 1.25,\n        \"max\": 4.65,\n        \"num_unique_values\": 83,\n        \"samples\": [\n          3.79,\n          3.87,\n          3.48\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Type\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 12,\n        \"samples\": [\n          \"Abstract,\\u00a0\\u00a0Family\",\n          \"Strategy\",\n          \"Strategy,\\u00a0\\u00a0Thematic\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "NeDN-pvJ909m",
        "outputId": "a95b04c0-bd2b-4e90-d49d-f451fc320fa2"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 100 entries, 0 to 99\n",
            "Data columns (total 13 columns):\n",
            " #   Column       Non-Null Count  Dtype  \n",
            "---  ------       --------------  -----  \n",
            " 0   Rank         100 non-null    int64  \n",
            " 1   Rating       100 non-null    float64\n",
            " 2   Name         100 non-null    object \n",
            " 3   Subtitle     100 non-null    object \n",
            " 4   Year         100 non-null    int64  \n",
            " 5   MinPlayers   100 non-null    int64  \n",
            " 6   MaxPlayers   100 non-null    int64  \n",
            " 7   BestPlayers  97 non-null     object \n",
            " 8   MinPlayTime  100 non-null    int64  \n",
            " 9   MaxPlayTime  100 non-null    int64  \n",
            " 10  MinAge       100 non-null    int64  \n",
            " 11  Weight       100 non-null    float64\n",
            " 12  Type         100 non-null    object \n",
            "dtypes: float64(2), int64(7), object(4)\n",
            "memory usage: 10.3+ KB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# Split values in \"Type\" column by delimiter \", \"\n",
        "types_split = data['Type'].str.split(',', expand=True)\n",
        "\n",
        "# Rename columns\n",
        "types_split.columns = [f\"Type_{i}\" for i in range(1, types_split.shape[1] + 1)]\n",
        "\n",
        "# Concatenate the split columns with the original DataFrame\n",
        "data = pd.concat([data, types_split], axis=1)\n",
        "\n",
        "# Drop the original \"Type\" column\n",
        "data.drop(columns=['Type'], inplace=True)\n",
        "\n"
      ],
      "metadata": {
        "id": "cc3pZzCf98cU"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "data.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "TAjUgjaS_VIO",
        "outputId": "ee251b77-663e-4f9a-8a38-a2a711c00896"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   Rank  Rating                               Name  \\\n",
              "0     1   8.511                        Gloomhaven    \n",
              "1     2   8.442          Pandemic Legacy: Season 1   \n",
              "2     3   8.418                  Brass: Birmingham   \n",
              "3     4   8.273                  Terraforming Mars   \n",
              "4     5   8.262  Twilight Imperium: Fourth Edition   \n",
              "\n",
              "                                            Subtitle  Year  MinPlayers  \\\n",
              "0  Vanquish monsters with strategic cardplay. Ful...  2017           1   \n",
              "1  Mutating diseases are spreading around the wor...  2015           2   \n",
              "2  Build networks, grow industries, and navigate ...  2018           2   \n",
              "3  Compete with rival CEOs to make Mars habitable...  2016           1   \n",
              "4  Build an intergalactic empire through trade, r...  2017           3   \n",
              "\n",
              "   MaxPlayers BestPlayers  MinPlayTime  MaxPlayTime  MinAge  Weight  \\\n",
              "0           4           3           60          120      14    3.87   \n",
              "1           4           4           60           60      13    2.83   \n",
              "2           4        3, 4           60          120      14    3.90   \n",
              "3           5           3          120          120      12    3.24   \n",
              "4           6           6          240          480      14    4.26   \n",
              "\n",
              "      Type_1      Type_2  \n",
              "0   Strategy    Thematic  \n",
              "1   Strategy    Thematic  \n",
              "2  Strategy         None  \n",
              "3  Strategy         None  \n",
              "4   Strategy    Thematic  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-499d2e03-7f2a-485e-885b-d28cb10e3bfc\" class=\"colab-df-container\">\n",
              "    <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>Rank</th>\n",
              "      <th>Rating</th>\n",
              "      <th>Name</th>\n",
              "      <th>Subtitle</th>\n",
              "      <th>Year</th>\n",
              "      <th>MinPlayers</th>\n",
              "      <th>MaxPlayers</th>\n",
              "      <th>BestPlayers</th>\n",
              "      <th>MinPlayTime</th>\n",
              "      <th>MaxPlayTime</th>\n",
              "      <th>MinAge</th>\n",
              "      <th>Weight</th>\n",
              "      <th>Type_1</th>\n",
              "      <th>Type_2</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>8.511</td>\n",
              "      <td>Gloomhaven</td>\n",
              "      <td>Vanquish monsters with strategic cardplay. Ful...</td>\n",
              "      <td>2017</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>60</td>\n",
              "      <td>120</td>\n",
              "      <td>14</td>\n",
              "      <td>3.87</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>Thematic</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>8.442</td>\n",
              "      <td>Pandemic Legacy: Season 1</td>\n",
              "      <td>Mutating diseases are spreading around the wor...</td>\n",
              "      <td>2015</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>60</td>\n",
              "      <td>60</td>\n",
              "      <td>13</td>\n",
              "      <td>2.83</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>Thematic</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>8.418</td>\n",
              "      <td>Brass: Birmingham</td>\n",
              "      <td>Build networks, grow industries, and navigate ...</td>\n",
              "      <td>2018</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>3, 4</td>\n",
              "      <td>60</td>\n",
              "      <td>120</td>\n",
              "      <td>14</td>\n",
              "      <td>3.90</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4</td>\n",
              "      <td>8.273</td>\n",
              "      <td>Terraforming Mars</td>\n",
              "      <td>Compete with rival CEOs to make Mars habitable...</td>\n",
              "      <td>2016</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>3</td>\n",
              "      <td>120</td>\n",
              "      <td>120</td>\n",
              "      <td>12</td>\n",
              "      <td>3.24</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5</td>\n",
              "      <td>8.262</td>\n",
              "      <td>Twilight Imperium: Fourth Edition</td>\n",
              "      <td>Build an intergalactic empire through trade, r...</td>\n",
              "      <td>2017</td>\n",
              "      <td>3</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>240</td>\n",
              "      <td>480</td>\n",
              "      <td>14</td>\n",
              "      <td>4.26</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>Thematic</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-499d2e03-7f2a-485e-885b-d28cb10e3bfc')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-499d2e03-7f2a-485e-885b-d28cb10e3bfc button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-499d2e03-7f2a-485e-885b-d28cb10e3bfc');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-7e63af6a-1c82-48ec-9f46-4abae0526e51\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-7e63af6a-1c82-48ec-9f46-4abae0526e51')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-7e63af6a-1c82-48ec-9f46-4abae0526e51 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "data",
              "summary": "{\n  \"name\": \"data\",\n  \"rows\": 100,\n  \"fields\": [\n    {\n      \"column\": \"Rank\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 29,\n        \"min\": 1,\n        \"max\": 100,\n        \"num_unique_values\": 100,\n        \"samples\": [\n          84,\n          54,\n          71\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Rating\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.22611896283490984,\n        \"min\": 7.512,\n        \"max\": 8.511,\n        \"num_unique_values\": 95,\n        \"samples\": [\n          7.643,\n          7.944,\n          7.624\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Name\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 100,\n        \"samples\": [\n          \"Caylus\",\n          \"Star Wars: Imperial Assault\",\n          \"Teotihuacan: City of Gods\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Subtitle\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 100,\n        \"samples\": [\n          \"Entrepreneurs pay workers & bribe an official to build a Ch?teau & gain royal favor.\",\n          \"Play as Rebel or Imperial forces to fulfil mission objectives.\",\n          \"Use your worker dice to raise the legendary and breathtaking Pyramid of the Sun.\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Year\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 14,\n        \"min\": 1876,\n        \"max\": 2020,\n        \"num_unique_values\": 21,\n        \"samples\": [\n          2017,\n          2010,\n          2006\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MinPlayers\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0,\n        \"min\": 1,\n        \"max\": 3,\n        \"num_unique_values\": 3,\n        \"samples\": [\n          1,\n          2,\n          3\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MaxPlayers\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1,\n        \"min\": 2,\n        \"max\": 8,\n        \"num_unique_values\": 6,\n        \"samples\": [\n          4,\n          5,\n          8\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"BestPlayers\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 11,\n        \"samples\": [\n          \"4, 5\",\n          \"3\",\n          \"2, 4\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MinPlayTime\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 38,\n        \"min\": 5,\n        \"max\": 240,\n        \"num_unique_values\": 15,\n        \"samples\": [\n          40,\n          20,\n          60\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MaxPlayTime\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 107,\n        \"min\": 20,\n        \"max\": 1000,\n        \"num_unique_values\": 17,\n        \"samples\": [\n          120,\n          60,\n          180\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MinAge\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1,\n        \"min\": 8,\n        \"max\": 17,\n        \"num_unique_values\": 7,\n        \"samples\": [\n          14,\n          13,\n          17\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Weight\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.6982331525740777,\n        \"min\": 1.25,\n        \"max\": 4.65,\n        \"num_unique_values\": 83,\n        \"samples\": [\n          3.79,\n          3.87,\n          3.48\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Type_1\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 7,\n        \"samples\": [\n          \"Strategy\",\n          \"Strategy\\u00a0\",\n          \"Abstract\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Type_2\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 4,\n        \"samples\": [\n          \"\\u00a0\\u00a0Wargames\",\n          \"\\u00a0\\u00a0Family\",\n          \"\\u00a0\\u00a0Thematic\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data.tail()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 293
        },
        "id": "5ZWSkOjiLClJ",
        "outputId": "97538a34-4741-45ce-9c79-2e04160f9603"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "    Rank  Rating                Name  \\\n",
              "95    96   7.529    The Isle of Cats   \n",
              "96    97   7.528  Russian Railroads    \n",
              "97    98   7.526  Tigris & Euphrates   \n",
              "98    99   7.516            Decrypto   \n",
              "99   100   7.512              Trajan   \n",
              "\n",
              "                                             Subtitle  Year  MinPlayers  \\\n",
              "95  Rescue as many island cats as you can before L...  2019           1   \n",
              "96  Acquire locomotives & industry, build track, a...  2013           2   \n",
              "97  Keep your Mesopotamian civilisation in perfect...  1997           2   \n",
              "98  Decipher your opponents' code before they deci...  2018           3   \n",
              "99  Manage and rule all aspects of Ancient Rome wi...  2011           2   \n",
              "\n",
              "    MaxPlayers BestPlayers  MinPlayTime  MaxPlayTime  MinAge  Weight  \\\n",
              "95           4           3           60           90       8    2.31   \n",
              "96           4           4           90          120      12    3.41   \n",
              "97           4           4           90           90      12    3.51   \n",
              "98           8        4, 6           15           45      12    1.80   \n",
              "99           4           4           60          120      12    3.65   \n",
              "\n",
              "      Type_1      Type_2  \n",
              "95    Family    Strategy  \n",
              "96  Strategy        None  \n",
              "97  Strategy        None  \n",
              "98     Party        None  \n",
              "99  Strategy        None  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-ae5119ea-1359-4178-8e68-a26a646e0f62\" class=\"colab-df-container\">\n",
              "    <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>Rank</th>\n",
              "      <th>Rating</th>\n",
              "      <th>Name</th>\n",
              "      <th>Subtitle</th>\n",
              "      <th>Year</th>\n",
              "      <th>MinPlayers</th>\n",
              "      <th>MaxPlayers</th>\n",
              "      <th>BestPlayers</th>\n",
              "      <th>MinPlayTime</th>\n",
              "      <th>MaxPlayTime</th>\n",
              "      <th>MinAge</th>\n",
              "      <th>Weight</th>\n",
              "      <th>Type_1</th>\n",
              "      <th>Type_2</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>95</th>\n",
              "      <td>96</td>\n",
              "      <td>7.529</td>\n",
              "      <td>The Isle of Cats</td>\n",
              "      <td>Rescue as many island cats as you can before L...</td>\n",
              "      <td>2019</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>60</td>\n",
              "      <td>90</td>\n",
              "      <td>8</td>\n",
              "      <td>2.31</td>\n",
              "      <td>Family</td>\n",
              "      <td>Strategy</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>96</th>\n",
              "      <td>97</td>\n",
              "      <td>7.528</td>\n",
              "      <td>Russian Railroads</td>\n",
              "      <td>Acquire locomotives &amp; industry, build track, a...</td>\n",
              "      <td>2013</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>90</td>\n",
              "      <td>120</td>\n",
              "      <td>12</td>\n",
              "      <td>3.41</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>97</th>\n",
              "      <td>98</td>\n",
              "      <td>7.526</td>\n",
              "      <td>Tigris &amp; Euphrates</td>\n",
              "      <td>Keep your Mesopotamian civilisation in perfect...</td>\n",
              "      <td>1997</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>90</td>\n",
              "      <td>90</td>\n",
              "      <td>12</td>\n",
              "      <td>3.51</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>98</th>\n",
              "      <td>99</td>\n",
              "      <td>7.516</td>\n",
              "      <td>Decrypto</td>\n",
              "      <td>Decipher your opponents' code before they deci...</td>\n",
              "      <td>2018</td>\n",
              "      <td>3</td>\n",
              "      <td>8</td>\n",
              "      <td>4, 6</td>\n",
              "      <td>15</td>\n",
              "      <td>45</td>\n",
              "      <td>12</td>\n",
              "      <td>1.80</td>\n",
              "      <td>Party</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>99</th>\n",
              "      <td>100</td>\n",
              "      <td>7.512</td>\n",
              "      <td>Trajan</td>\n",
              "      <td>Manage and rule all aspects of Ancient Rome wi...</td>\n",
              "      <td>2011</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>60</td>\n",
              "      <td>120</td>\n",
              "      <td>12</td>\n",
              "      <td>3.65</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-ae5119ea-1359-4178-8e68-a26a646e0f62')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-ae5119ea-1359-4178-8e68-a26a646e0f62 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-ae5119ea-1359-4178-8e68-a26a646e0f62');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-6273eaec-d68a-4fc5-88a6-00bbec6f9b87\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-6273eaec-d68a-4fc5-88a6-00bbec6f9b87')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-6273eaec-d68a-4fc5-88a6-00bbec6f9b87 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "summary": "{\n  \"name\": \"data\",\n  \"rows\": 5,\n  \"fields\": [\n    {\n      \"column\": \"Rank\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1,\n        \"min\": 96,\n        \"max\": 100,\n        \"num_unique_values\": 5,\n        \"samples\": [\n          97,\n          100,\n          98\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Rating\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.007694153624668556,\n        \"min\": 7.512,\n        \"max\": 7.529,\n        \"num_unique_values\": 5,\n        \"samples\": [\n          7.528,\n          7.512,\n          7.526\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Name\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 5,\n        \"samples\": [\n          \"Russian Railroads\\u00a0\",\n          \"Trajan\",\n          \"Tigris & Euphrates\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Subtitle\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 5,\n        \"samples\": [\n          \"Acquire locomotives & industry, build track, and hire the best engineers in Russia.\",\n          \"Manage and rule all aspects of Ancient Rome with a clever action selection mancala.\\u00a0\",\n          \"Keep your Mesopotamian civilisation in perfect balance through revolutions and wars.\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Year\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 8,\n        \"min\": 1997,\n        \"max\": 2019,\n        \"num_unique_values\": 5,\n        \"samples\": [\n          2013,\n          2011,\n          1997\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MinPlayers\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0,\n        \"min\": 1,\n        \"max\": 3,\n        \"num_unique_values\": 3,\n        \"samples\": [\n          1,\n          2,\n          3\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MaxPlayers\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1,\n        \"min\": 4,\n        \"max\": 8,\n        \"num_unique_values\": 2,\n        \"samples\": [\n          8,\n          4\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"BestPlayers\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 3,\n        \"samples\": [\n          \"3\",\n          \"4\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MinPlayTime\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 30,\n        \"min\": 15,\n        \"max\": 90,\n        \"num_unique_values\": 3,\n        \"samples\": [\n          60,\n          90\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MaxPlayTime\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 30,\n        \"min\": 45,\n        \"max\": 120,\n        \"num_unique_values\": 3,\n        \"samples\": [\n          90,\n          120\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MinAge\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1,\n        \"min\": 8,\n        \"max\": 12,\n        \"num_unique_values\": 2,\n        \"samples\": [\n          12,\n          8\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Weight\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.8286012309911203,\n        \"min\": 1.8,\n        \"max\": 3.65,\n        \"num_unique_values\": 5,\n        \"samples\": [\n          3.41,\n          3.65\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Type_1\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 3,\n        \"samples\": [\n          \"Family\",\n          \"Strategy\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Type_2\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 1,\n        \"samples\": [\n          \"\\u00a0\\u00a0Strategy\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "# wikipedia\n",
        "\n",
        "import wikipedia\n",
        "\n",
        "keyword = \"board game\"\n",
        "game = \"Gloomhaven\"\n",
        "\n",
        "result = wikipedia.search(f\"{game} {keyword}\")"
      ],
      "metadata": {
        "id": "JQ48E3GvYVa1"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "result"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "CF7gnBcEZN6U",
        "outputId": "796d5d2d-ddd8-4799-819f-1f7b1b5d6683"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['Gloomhaven',\n",
              " 'Gloomhaven (video game)',\n",
              " 'List of Game of the Year awards (board games)',\n",
              " 'BoardGameGeek',\n",
              " 'Deutscher Spiele Preis',\n",
              " 'List of Dragon Award nominees']"
            ]
          },
          "metadata": {},
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "page = wikipedia.page(result[0]).content"
      ],
      "metadata": {
        "id": "sV5e93HhZOdx"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "print(page)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Az-Z4-7yZnJS",
        "outputId": "c8ea88bc-ed64-4224-b4f5-55bc9614554b"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Brass is a board game set in Lancashire, England during the Industrial Revolution. It was developed by Martin Wallace. The object is to build mines, cotton factories, ports, canals and rail links, and establish trade routes, all of which will be used to score points. The game is divided into two historical periods: the canal period and the rail period. Victory points are scored at the end of each. Depending on the card the players draw, they will be limited in their choices.\n",
            "\n",
            "\n",
            "== Details ==\n",
            "Number of players 2-4 but it is best played with 4 players. Playing time 1-2 hours. It is suggested to be played by ages 14 and up.  Brass was followed by Age of Industry, which is basically a simplified (no canals), shorter (2 hours) and more accessible (minimum 2 players instead of 3) version of Brass.\n",
            "\n",
            "\n",
            "=== Publisher ===\n",
            "The game was published in 2007 by Warfrog (now Treefrog) Games, Wallace's publishing company. It was later published by Pegasus Spiele as Kohle - Mit Volldampf zum Reichtum ('Coal - Full Steam Ahead to Riches') with additional artwork by Eckhard Freytag, and under its original name by Eagle Games and FRED Distribution (USA), White Goblin Games (France) and Wargames Club Publishing (China)\n",
            "\n",
            "\n",
            "==== 2018 reprint and successor ====\n",
            "In 2017 Canadian publisher Roxley Games launched a Kickstarter campaign to realize a reprinting of the game under the new name Brass: Lancashire with new artwork and components as well as slightly modified rules. At the same time the successor, Brass: Birmingham, was introduced, adding Gavan Brown and Matt Tolman to the design team and featuring new mechanisms while keeping the same core rule-set. The campaign succeeded reaching 1.7m CAD given only 80.000 CAD was pledged and both games hit retail in 2018.\n",
            "In February 2023, Brass: Birmingham reached the No. 1 spot as the top rated board game on leading website BoardGameGeek.\n",
            "\n",
            "\n",
            "== Honours ==\n",
            "2007 Jogo do Ano Winner\n",
            "2007 Jogo do Ano Nominee\n",
            "2007 Meeples' Choice Award\n",
            "2008 Golden Geek Best Gamer's Board Game Nominee\n",
            "2008 International Gamers Awards - General Strategy; Multi-player Nominee\n",
            "2008 Tric Trac Nominee\n",
            "2010 Nederlandse Spellenprijs Nominee\n",
            "\n",
            "\n",
            "== References ==\n",
            "\n",
            "\n",
            "== External links ==\n",
            "Brass: Lancashire   at BoardGameGeek\n",
            "Brass: Birmingham   at BoardGameGeek\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "summary = wikipedia.page('Gloomhaven').summary"
      ],
      "metadata": {
        "id": "nFZXJPxnZofo"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "print(summary)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "sk3Sy-XQZxvI",
        "outputId": "55580b5d-5260-481a-8d48-7a32b6255dfc"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Gloomhaven is a cooperative board game for one to four players designed by Isaac Childres and published by Cephalofair Games in 2017. It is a campaign-based dungeon crawl game including a narrative campaign, 95 unique playable scenarios, and 17 playable classes. Since its introduction the game has been acclaimed by reviewers, and has been described as one of the best board games ever made.\n",
            "\n",
            "\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "import wikipedia\n",
        "from typing import Optional\n",
        "\n",
        "def get_wikipedia_page_content(game_title: str, keyword: str = \"boardgame\") -> Optional[str]:\n",
        "    \"\"\"\n",
        "    Retrieve Wikipedia page content related to the game title and keyword.\n",
        "\n",
        "    Args:\n",
        "        game_title (str): Title of the game.\n",
        "        keyword (str): Additional keyword to refine the search. Default is \"boardgame\".\n",
        "\n",
        "    Returns:\n",
        "        Optional[str]: Content of the Wikipedia page if found, else None.\n",
        "\n",
        "    Raises:\n",
        "        wikipedia.exceptions.DisambiguationError: If search query results are ambiguous.\n",
        "        wikipedia.exceptions.PageError: If no Wikipedia page is found for the query.\n",
        "    \"\"\"\n",
        "\n",
        "    try:\n",
        "        result = wikipedia.search(f\"{game_title} {keyword}\")\n",
        "        if result:\n",
        "            page_content = wikipedia.page(result[0]).content\n",
        "            return page_content\n",
        "        else:\n",
        "            return None  # No search result found\n",
        "    except wikipedia.exceptions.DisambiguationError as e:\n",
        "        # Handle disambiguation error (multiple search results)\n",
        "        print(\"Disambiguation error:\", e.options)\n",
        "        return None\n",
        "    except wikipedia.exceptions.PageError as e:\n",
        "        # Handle page error (no Wikipedia page found)\n",
        "        print(\"Page error:\", e)\n",
        "        return None\n",
        "\n",
        "# # Example usage:\n",
        "# game_title = \"Minecraft\"\n",
        "# keyword = \"gameplay\"\n",
        "# content = get_wikipedia_page_content(game_title, keyword)\n",
        "# if content:\n",
        "#     print(content)\n",
        "# else:\n",
        "#     print(\"No Wikipedia page content found for the given game title and keyword.\")\n"
      ],
      "metadata": {
        "id": "OnVdawqWZy05"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#\n",
        "# ~2 mins to run\n",
        "#\n",
        "\n",
        "data['wiki_game_summary'] = data['Name'].apply(lambda x: get_wikipedia_page_content(x))\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "UN10qJks4sfL",
        "outputId": "f9825174-7ef1-4908-d6db-ced37e1d6558"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Page error: Page id \"gloomhaven video games\" does not match any pages. Try another id!\n"
          ]
        },
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "/usr/local/lib/python3.10/dist-packages/wikipedia/wikipedia.py:389: GuessedAtParserWarning: No parser was explicitly specified, so I'm using the best available HTML parser for this system (\"lxml\"). This usually isn't a problem, but if you run this code on another system, or in a different virtual environment, it may use a different parser and behave differently.\n",
            "\n",
            "The code that caused this warning is on line 389 of the file /usr/local/lib/python3.10/dist-packages/wikipedia/wikipedia.py. To get rid of this warning, pass the additional argument 'features=\"lxml\"' to the BeautifulSoup constructor.\n",
            "\n",
            "  lis = BeautifulSoup(html).find_all('li')\n"
          ]
        },
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Disambiguation error: ['clue (information)', 'DJ Clue', 'Fredy Clue', 'Oliver Clue', 'Tim Clue', 'Arthur Clues', 'Ivan Clues', 'Tim Cluess', 'Cluedo', 'Clue (1992 video game)', 'Clue (1998 video game)', 'Clue (book series)', 'Clue (film)', 'Clue (miniseries)', 'Clue (mobile games)', 'Clue (musical)', 'Clues (band)', 'Clues (Clues album)', 'Clues (Robert Palmer album)', '\"Clues\" (Star Trek: The Next Generation)', \"I'm Sorry I Haven't a Clue\", 'The Clue', 'Suraag – The Clue', 'Clue (mobile app)', 'Clue cell', 'Cluster Exploratory', 'Comprehensive Loss Underwriting Exchange', 'Clew', 'CLU (disambiguation)', 'Evidence']\n",
            "Page error: Page id \"gloomhaven video games\" does not match any pages. Try another id!\n",
            "Page error: Page id \"list of board game\" does not match any pages. Try another id!\n",
            "Page error: Page id \"list of board game\" does not match any pages. Try another id!\n",
            "Page error: Page id \"fantasy flight game\" does not match any pages. Try another id!\n",
            "Page error: Page id \"list of board game\" does not match any pages. Try another id!\n",
            "Page error: Page id \"judge dread\" does not match any pages. Try another id!\n",
            "Disambiguation error: ['clue (information)', 'DJ Clue', 'Fredy Clue', 'Oliver Clue', 'Tim Clue', 'Arthur Clues', 'Ivan Clues', 'Tim Cluess', 'Cluedo', 'Clue (1992 video game)', 'Clue (1998 video game)', 'Clue (book series)', 'Clue (film)', 'Clue (miniseries)', 'Clue (mobile games)', 'Clue (musical)', 'Clues (band)', 'Clues (Clues album)', 'Clues (Robert Palmer album)', '\"Clues\" (Star Trek: The Next Generation)', \"I'm Sorry I Haven't a Clue\", 'The Clue', 'Suraag – The Clue', 'Clue (mobile app)', 'Clue cell', 'Cluster Exploratory', 'Comprehensive Loss Underwriting Exchange', 'Clew', 'CLU (disambiguation)', 'Evidence']\n",
            "Page error: Page id \"list of board game\" does not match any pages. Try another id!\n",
            "Page error: Page id \"list of board game\" does not match any pages. Try another id!\n",
            "Page error: Page id \"slay the squire\" does not match any pages. Try another id!\n",
            "Page error: Page id \"list of board game\" does not match any pages. Try another id!\n",
            "Page error: Page id \"list of board game\" does not match any pages. Try another id!\n",
            "Page error: Page id \"raiders of the lost park\" does not match any pages. Try another id!\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data.head(20)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 677
        },
        "id": "vE_Ycr6rGhQ_",
        "outputId": "4f709937-7bde-4a86-a0de-1b9e25e6169b"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "    Rank  Rating                                           Name  \\\n",
              "0      1   8.511                                    Gloomhaven    \n",
              "1      2   8.442                      Pandemic Legacy: Season 1   \n",
              "2      3   8.418                              Brass: Birmingham   \n",
              "3      4   8.273                              Terraforming Mars   \n",
              "4      5   8.262              Twilight Imperium: Fourth Edition   \n",
              "5      6   8.261                   Gloomhaven: Jaws of the Lion   \n",
              "6      7   8.175                                   Gaia Project   \n",
              "7      8   8.172                           Star Wars: Rebellion   \n",
              "8      9   8.150  Through the Ages: A New Story of Civilization   \n",
              "9     10   8.136                War of the Ring: Second Edition   \n",
              "10    11   8.133                                  Spirit Island   \n",
              "11    12   8.124                            Great Western Trail   \n",
              "12    13   8.114                              Twilight Struggle   \n",
              "13    14   8.064                                        Scythe    \n",
              "14    15   8.008                        The Castles of Burgundy   \n",
              "15    16   7.984                                 7 Wonders Duel   \n",
              "16    17   7.982                                        Nemesis   \n",
              "17    18   7.966                                  Terra Mystica   \n",
              "18    19   7.965                                      Concordia   \n",
              "19    20   7.963                              Brass: Lancashire   \n",
              "\n",
              "                                             Subtitle  Year  MinPlayers  \\\n",
              "0   Vanquish monsters with strategic cardplay. Ful...  2017           1   \n",
              "1   Mutating diseases are spreading around the wor...  2015           2   \n",
              "2   Build networks, grow industries, and navigate ...  2018           2   \n",
              "3   Compete with rival CEOs to make Mars habitable...  2016           1   \n",
              "4   Build an intergalactic empire through trade, r...  2017           3   \n",
              "5   Vanquish monsters with strategic cardplay in a...  2020           1   \n",
              "6   Expand, research, upgrade, and settle the gala...  2017           1   \n",
              "7   Strike from your hidden base as the Rebels—or ...  2016           2   \n",
              "8   Rewrite history as you build up your civilizat...  2015           2   \n",
              "9   The Fellowship and the Free Peoples clash with...  2012           2   \n",
              "10  Island Spirits join forces using elemental pow...  2017           1   \n",
              "11  Use strategic outposts and navigate danger as ...  2016           2   \n",
              "12  Relive the Cold War and rewrite history in an ...  2005           2   \n",
              "13  Five factions vie for dominance in a war-torn,...  2016           1   \n",
              "14  Plan, trade, and build your Burgundian estate ...  2011           2   \n",
              "15  Science? Military? What will you draft to win ...  2015           2   \n",
              "16  Survive an alien-infested spaceship but beware...  2018           1   \n",
              "17  Play fantastical factions. Expand your influen...  2012           2   \n",
              "18  Lead your Roman dynasty and build the greatest...  2013           2   \n",
              "19  Test your economic mettle as you build and net...  2007           2   \n",
              "\n",
              "    MaxPlayers BestPlayers  MinPlayTime  MaxPlayTime  MinAge  Weight  \\\n",
              "0            4           3           60          120      14    3.87   \n",
              "1            4           4           60           60      13    2.83   \n",
              "2            4        3, 4           60          120      14    3.90   \n",
              "3            5           3          120          120      12    3.24   \n",
              "4            6           6          240          480      14    4.26   \n",
              "5            4         NaN           30          120      14    3.57   \n",
              "6            4        3, 4           60          150      12    4.37   \n",
              "7            4           2          180          240      14    3.73   \n",
              "8            4           3          120          120      14    4.41   \n",
              "9            4           2          150          180      13    4.17   \n",
              "10           4           2           90          120      13    4.03   \n",
              "11           4           3           75          150      12    3.71   \n",
              "12           2           2          120          180      13    3.59   \n",
              "13           5           4           90          115      14    3.43   \n",
              "14           4           2           30           90      12    3.00   \n",
              "15           2           2           30           30      10    2.22   \n",
              "16           5        4, 5           90          180      12    3.38   \n",
              "17           5           4           60          150      12    3.97   \n",
              "18           5           4          100          100      13    3.01   \n",
              "19           4           4           60          120      14    3.86   \n",
              "\n",
              "       Type_1      Type_2                                  wiki_game_summary  \n",
              "0    Strategy    Thematic                                               None  \n",
              "1    Strategy    Thematic  A legacy game is a variant of tabletop board g...  \n",
              "2   Strategy         None                                               None  \n",
              "3   Strategy         None  Terraforming Mars is a board game for 1 to 5 p...  \n",
              "4    Strategy    Thematic  Twilight Imperium is a strategy board game pro...  \n",
              "5    Strategy    Thematic                                               None  \n",
              "6   Strategy         None  Game of the Year (abbreviated GotY) is a title...  \n",
              "7    Thematic        None  This is a list of board wargames by historical...  \n",
              "8   Strategy         None  Age of Empires is a series of historical real-...  \n",
              "9    Thematic    Wargames  This is a list of board wargames by historical...  \n",
              "10  Strategy         None                                               None  \n",
              "11  Strategy         None  Great Western Trail is a board game designed b...  \n",
              "12   Strategy    Wargames  Twilight Struggle: The Cold War, 1945–1989 is ...  \n",
              "13  Strategy         None  Scythe is a board game for one to five players...  \n",
              "14  Strategy         None  The Castles of Burgundy is a board game for tw...  \n",
              "15  Strategy         None  7 Wonders is a board game created by Antoine B...  \n",
              "16   Thematic        None  Throne of Glass is a high fantasy novel series...  \n",
              "17  Strategy         None  A Eurogame, also called a German-style board g...  \n",
              "18  Strategy         None  A Eurogame, also called a German-style board g...  \n",
              "19  Strategy         None                                               None  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-21822924-2283-454f-971a-84a6bf07c074\" class=\"colab-df-container\">\n",
              "    <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>Rank</th>\n",
              "      <th>Rating</th>\n",
              "      <th>Name</th>\n",
              "      <th>Subtitle</th>\n",
              "      <th>Year</th>\n",
              "      <th>MinPlayers</th>\n",
              "      <th>MaxPlayers</th>\n",
              "      <th>BestPlayers</th>\n",
              "      <th>MinPlayTime</th>\n",
              "      <th>MaxPlayTime</th>\n",
              "      <th>MinAge</th>\n",
              "      <th>Weight</th>\n",
              "      <th>Type_1</th>\n",
              "      <th>Type_2</th>\n",
              "      <th>wiki_game_summary</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1</td>\n",
              "      <td>8.511</td>\n",
              "      <td>Gloomhaven</td>\n",
              "      <td>Vanquish monsters with strategic cardplay. Ful...</td>\n",
              "      <td>2017</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>60</td>\n",
              "      <td>120</td>\n",
              "      <td>14</td>\n",
              "      <td>3.87</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>Thematic</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2</td>\n",
              "      <td>8.442</td>\n",
              "      <td>Pandemic Legacy: Season 1</td>\n",
              "      <td>Mutating diseases are spreading around the wor...</td>\n",
              "      <td>2015</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>60</td>\n",
              "      <td>60</td>\n",
              "      <td>13</td>\n",
              "      <td>2.83</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>Thematic</td>\n",
              "      <td>A legacy game is a variant of tabletop board g...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>3</td>\n",
              "      <td>8.418</td>\n",
              "      <td>Brass: Birmingham</td>\n",
              "      <td>Build networks, grow industries, and navigate ...</td>\n",
              "      <td>2018</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>3, 4</td>\n",
              "      <td>60</td>\n",
              "      <td>120</td>\n",
              "      <td>14</td>\n",
              "      <td>3.90</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>4</td>\n",
              "      <td>8.273</td>\n",
              "      <td>Terraforming Mars</td>\n",
              "      <td>Compete with rival CEOs to make Mars habitable...</td>\n",
              "      <td>2016</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>3</td>\n",
              "      <td>120</td>\n",
              "      <td>120</td>\n",
              "      <td>12</td>\n",
              "      <td>3.24</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>None</td>\n",
              "      <td>Terraforming Mars is a board game for 1 to 5 p...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>5</td>\n",
              "      <td>8.262</td>\n",
              "      <td>Twilight Imperium: Fourth Edition</td>\n",
              "      <td>Build an intergalactic empire through trade, r...</td>\n",
              "      <td>2017</td>\n",
              "      <td>3</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>240</td>\n",
              "      <td>480</td>\n",
              "      <td>14</td>\n",
              "      <td>4.26</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>Thematic</td>\n",
              "      <td>Twilight Imperium is a strategy board game pro...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>6</td>\n",
              "      <td>8.261</td>\n",
              "      <td>Gloomhaven: Jaws of the Lion</td>\n",
              "      <td>Vanquish monsters with strategic cardplay in a...</td>\n",
              "      <td>2020</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>NaN</td>\n",
              "      <td>30</td>\n",
              "      <td>120</td>\n",
              "      <td>14</td>\n",
              "      <td>3.57</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>Thematic</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>7</td>\n",
              "      <td>8.175</td>\n",
              "      <td>Gaia Project</td>\n",
              "      <td>Expand, research, upgrade, and settle the gala...</td>\n",
              "      <td>2017</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>3, 4</td>\n",
              "      <td>60</td>\n",
              "      <td>150</td>\n",
              "      <td>12</td>\n",
              "      <td>4.37</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>None</td>\n",
              "      <td>Game of the Year (abbreviated GotY) is a title...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>8</td>\n",
              "      <td>8.172</td>\n",
              "      <td>Star Wars: Rebellion</td>\n",
              "      <td>Strike from your hidden base as the Rebels—or ...</td>\n",
              "      <td>2016</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>2</td>\n",
              "      <td>180</td>\n",
              "      <td>240</td>\n",
              "      <td>14</td>\n",
              "      <td>3.73</td>\n",
              "      <td>Thematic</td>\n",
              "      <td>None</td>\n",
              "      <td>This is a list of board wargames by historical...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>9</td>\n",
              "      <td>8.150</td>\n",
              "      <td>Through the Ages: A New Story of Civilization</td>\n",
              "      <td>Rewrite history as you build up your civilizat...</td>\n",
              "      <td>2015</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>120</td>\n",
              "      <td>120</td>\n",
              "      <td>14</td>\n",
              "      <td>4.41</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>None</td>\n",
              "      <td>Age of Empires is a series of historical real-...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>10</td>\n",
              "      <td>8.136</td>\n",
              "      <td>War of the Ring: Second Edition</td>\n",
              "      <td>The Fellowship and the Free Peoples clash with...</td>\n",
              "      <td>2012</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>2</td>\n",
              "      <td>150</td>\n",
              "      <td>180</td>\n",
              "      <td>13</td>\n",
              "      <td>4.17</td>\n",
              "      <td>Thematic</td>\n",
              "      <td>Wargames</td>\n",
              "      <td>This is a list of board wargames by historical...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>11</td>\n",
              "      <td>8.133</td>\n",
              "      <td>Spirit Island</td>\n",
              "      <td>Island Spirits join forces using elemental pow...</td>\n",
              "      <td>2017</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>2</td>\n",
              "      <td>90</td>\n",
              "      <td>120</td>\n",
              "      <td>13</td>\n",
              "      <td>4.03</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>12</td>\n",
              "      <td>8.124</td>\n",
              "      <td>Great Western Trail</td>\n",
              "      <td>Use strategic outposts and navigate danger as ...</td>\n",
              "      <td>2016</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>75</td>\n",
              "      <td>150</td>\n",
              "      <td>12</td>\n",
              "      <td>3.71</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>None</td>\n",
              "      <td>Great Western Trail is a board game designed b...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>13</td>\n",
              "      <td>8.114</td>\n",
              "      <td>Twilight Struggle</td>\n",
              "      <td>Relive the Cold War and rewrite history in an ...</td>\n",
              "      <td>2005</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>120</td>\n",
              "      <td>180</td>\n",
              "      <td>13</td>\n",
              "      <td>3.59</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>Wargames</td>\n",
              "      <td>Twilight Struggle: The Cold War, 1945–1989 is ...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>14</td>\n",
              "      <td>8.064</td>\n",
              "      <td>Scythe</td>\n",
              "      <td>Five factions vie for dominance in a war-torn,...</td>\n",
              "      <td>2016</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>4</td>\n",
              "      <td>90</td>\n",
              "      <td>115</td>\n",
              "      <td>14</td>\n",
              "      <td>3.43</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>None</td>\n",
              "      <td>Scythe is a board game for one to five players...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>15</td>\n",
              "      <td>8.008</td>\n",
              "      <td>The Castles of Burgundy</td>\n",
              "      <td>Plan, trade, and build your Burgundian estate ...</td>\n",
              "      <td>2011</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>2</td>\n",
              "      <td>30</td>\n",
              "      <td>90</td>\n",
              "      <td>12</td>\n",
              "      <td>3.00</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>None</td>\n",
              "      <td>The Castles of Burgundy is a board game for tw...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>16</td>\n",
              "      <td>7.984</td>\n",
              "      <td>7 Wonders Duel</td>\n",
              "      <td>Science? Military? What will you draft to win ...</td>\n",
              "      <td>2015</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>30</td>\n",
              "      <td>30</td>\n",
              "      <td>10</td>\n",
              "      <td>2.22</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>None</td>\n",
              "      <td>7 Wonders is a board game created by Antoine B...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>17</td>\n",
              "      <td>7.982</td>\n",
              "      <td>Nemesis</td>\n",
              "      <td>Survive an alien-infested spaceship but beware...</td>\n",
              "      <td>2018</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>4, 5</td>\n",
              "      <td>90</td>\n",
              "      <td>180</td>\n",
              "      <td>12</td>\n",
              "      <td>3.38</td>\n",
              "      <td>Thematic</td>\n",
              "      <td>None</td>\n",
              "      <td>Throne of Glass is a high fantasy novel series...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>18</td>\n",
              "      <td>7.966</td>\n",
              "      <td>Terra Mystica</td>\n",
              "      <td>Play fantastical factions. Expand your influen...</td>\n",
              "      <td>2012</td>\n",
              "      <td>2</td>\n",
              "      <td>5</td>\n",
              "      <td>4</td>\n",
              "      <td>60</td>\n",
              "      <td>150</td>\n",
              "      <td>12</td>\n",
              "      <td>3.97</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>None</td>\n",
              "      <td>A Eurogame, also called a German-style board g...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>19</td>\n",
              "      <td>7.965</td>\n",
              "      <td>Concordia</td>\n",
              "      <td>Lead your Roman dynasty and build the greatest...</td>\n",
              "      <td>2013</td>\n",
              "      <td>2</td>\n",
              "      <td>5</td>\n",
              "      <td>4</td>\n",
              "      <td>100</td>\n",
              "      <td>100</td>\n",
              "      <td>13</td>\n",
              "      <td>3.01</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>None</td>\n",
              "      <td>A Eurogame, also called a German-style board g...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>20</td>\n",
              "      <td>7.963</td>\n",
              "      <td>Brass: Lancashire</td>\n",
              "      <td>Test your economic mettle as you build and net...</td>\n",
              "      <td>2007</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>60</td>\n",
              "      <td>120</td>\n",
              "      <td>14</td>\n",
              "      <td>3.86</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-21822924-2283-454f-971a-84a6bf07c074')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-21822924-2283-454f-971a-84a6bf07c074 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-21822924-2283-454f-971a-84a6bf07c074');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-cb4349a5-4a39-4b38-a5b7-b3af7b6895b4\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-cb4349a5-4a39-4b38-a5b7-b3af7b6895b4')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-cb4349a5-4a39-4b38-a5b7-b3af7b6895b4 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "data",
              "summary": "{\n  \"name\": \"data\",\n  \"rows\": 100,\n  \"fields\": [\n    {\n      \"column\": \"Rank\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 29,\n        \"min\": 1,\n        \"max\": 100,\n        \"num_unique_values\": 100,\n        \"samples\": [\n          84,\n          54,\n          71\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Rating\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.22611896283490984,\n        \"min\": 7.512,\n        \"max\": 8.511,\n        \"num_unique_values\": 95,\n        \"samples\": [\n          7.643,\n          7.944,\n          7.624\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Name\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 100,\n        \"samples\": [\n          \"Caylus\",\n          \"Star Wars: Imperial Assault\",\n          \"Teotihuacan: City of Gods\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Subtitle\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 100,\n        \"samples\": [\n          \"Entrepreneurs pay workers & bribe an official to build a Ch?teau & gain royal favor.\",\n          \"Play as Rebel or Imperial forces to fulfil mission objectives.\",\n          \"Use your worker dice to raise the legendary and breathtaking Pyramid of the Sun.\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Year\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 14,\n        \"min\": 1876,\n        \"max\": 2020,\n        \"num_unique_values\": 21,\n        \"samples\": [\n          2017,\n          2010,\n          2006\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MinPlayers\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0,\n        \"min\": 1,\n        \"max\": 3,\n        \"num_unique_values\": 3,\n        \"samples\": [\n          1,\n          2,\n          3\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MaxPlayers\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1,\n        \"min\": 2,\n        \"max\": 8,\n        \"num_unique_values\": 6,\n        \"samples\": [\n          4,\n          5,\n          8\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"BestPlayers\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 11,\n        \"samples\": [\n          \"4, 5\",\n          \"3\",\n          \"2, 4\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MinPlayTime\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 38,\n        \"min\": 5,\n        \"max\": 240,\n        \"num_unique_values\": 15,\n        \"samples\": [\n          40,\n          20,\n          60\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MaxPlayTime\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 107,\n        \"min\": 20,\n        \"max\": 1000,\n        \"num_unique_values\": 17,\n        \"samples\": [\n          120,\n          60,\n          180\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MinAge\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1,\n        \"min\": 8,\n        \"max\": 17,\n        \"num_unique_values\": 7,\n        \"samples\": [\n          14,\n          13,\n          17\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Weight\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0.6982331525740777,\n        \"min\": 1.25,\n        \"max\": 4.65,\n        \"num_unique_values\": 83,\n        \"samples\": [\n          3.79,\n          3.87,\n          3.48\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Type_1\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 7,\n        \"samples\": [\n          \"Strategy\",\n          \"Strategy\\u00a0\",\n          \"Abstract\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Type_2\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 4,\n        \"samples\": [\n          \"\\u00a0\\u00a0Wargames\",\n          \"\\u00a0\\u00a0Family\",\n          \"\\u00a0\\u00a0Thematic\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"wiki_game_summary\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 35,\n        \"samples\": [\n          \"Le Havre is a board game about the development of the town of Le Havre.  It was inspired by the games Caylus and Agricola and was developed in December 2007.\\nThe game was edited by Uwe Rosenberg and Hanno Girke and the former gets the main cover credit. The illustrator was Klemens Franz while the English translator was Melissa Rogerson. Numerous credits are given to others who assisted with playtesting and other tasks.  The game was published by Lookout Games and distributed by Heidelberger Spieleverlag.\\nThe game was released at Spiel 2008 in both German and Australian English, with both editions published by Lookout Games. It did not do as well as its predecessor Agricola in the Fairplay polls, with a rating of 2.51 (1 is best), but has a high rating of 7.9/10 at BoardGameGeek (a different rating system), ranking among the top 100 games and is generally considered to be highly regarded by critics.\\nThe game was adapted into an iOS app by Codito Development Inc. and released on June 21, 2012. The game has a Metacritic rating of 82% based on 6 critic reviews.\\nA two player version called Le Havre: The Inland Port was released in 2012.  There is also a corresponding iOS app.\\n\\n\\n== Gameplay ==\\nThe gameplay takes place in the harbour of Le Havre, where players take goods such as fish and wood from the wharves. These goods are used either to feed the players' community, to construct buildings and ships, or are processed into finished goods. For example, a smokehouse building may be constructed in which players may process fish into smoked fish, which is more valuable.\\nThe game is played for a set number of rounds. The winner is the player with the greatest net wealth at the end.\\nPoints are earned by making money, building buildings and ships (which each have their own values), and selling goods. At the end of each round, players must be able to give food to their workers. The amount of food depends on the round number and the number of players, starting out low and gradually increasing as the game progresses. Players not planning ahead will soon find themselves with a shortage of food which will require taking loans from the Bank. Building ships can help with this food problem, as each ship will give the player a discount on their food each round (they count as trade routes which give the player more sources of food).\\n\\n\\n== References ==\\n\\n\\n== External links ==\\nLookout Games' Le Havre homepage\\nLe Havre   at BoardGameGeek\",\n          \"Dune is a strategy board game set in Frank Herbert's Dune universe, published by Avalon Hill in 1979. The game was designed by Bill Eberle, Jack Kittredge and Peter Olotka. After many years out of print, the game was reissued by Gale Force Nine in 2019 in advance of the 2021 Dune film adaptation.\\n\\n\\n== History ==\\nThe game was originally designed with a Roman Empire theme, with the name Tribute. Avalon Hill had acquired the license to produce a Dune game, but when their design proved unusable, the company contacted Eberle, Kittredge and Olotka. Elements suitable for the Dune universe were added to the game, particularly from their earlier game, Cosmic Encounter.\\nIn 1984, to tie in with the Dune film, Avalon Hill published a second edition of the game as well as two expansions, Spice Harvest and The Duel.\\nThe Spice Harvest expansion changes the initial setup of the standard game by adding a pre-game in which the factions lobby for control of the inter-world Spice market in order to purchase a more advantageous initial position for the start of the main game (control for the planet of Arrakis).\\nThe Duel adds \\\"leader tokens\\\" representing the primary leaders of each faction and a secondary board representing a circular arena for one-on-one combat. Leaders may fight individual combat using a special deck of cards for movement and attacks.\\nBoth supplements included additional Treachery Cards. Both supplements are also incorporated into the French edition published by Jeux Descartes.\\nIn addition, Avalon Hill's strategy magazines, The General and Heroes, published counters and rules for three additional factions: the Bene Tleilax, the Ixians, and the Landsraad, factions and organizations that appeared in Frank Herbert's original novels.\\nThe game received good reviews and due to the popularity of the Dune setting, coupled with the lack of new edition since 1984, became a sought-after item among board game collectors, with prices on secondary market reaching hundreds of dollars. A fan-made print-and-play version was also made available online around 2010.\\nIn the 1990s, Jeux Descartes published a French edition of the game.\\nThe game was reprinted by Fantasy Flight Games in 2012 as Rex: Final Days of an Empire. Fantasy Flight was able to acquire the rights to the system used in Dune (known as the \\u201cSimultaneous Dial Based Order System\\u201d), but were not able to get the license for the Dune setting. As a result, the game's setting was switched to Fantasy Flight's Twilight Imperium universe.\\nWith the demise of Avalon Hill, Dune remained out of print for many years despite being a highly regarded board game. With newfound interest in the Dune series due to the upcoming 2021 Dune film, board game publisher Gale Force 9 reached out to the Herbert estate, which owns the general rights to the game, and received permission to remake it. The art was new for this edition, drawn by Russian illustrator \\\"Ilya77\\\", who was commissioned for the reuse of their art, in addition to the game's original designers, Bill Eberle, Jack Kittredge, and Peter Olotka. Gale Force 9 made very few changes of the game's original rules, tweaking about 3 to 5 percent of the rules. The game was released on October 30, 2019 in advance of the Dune cinematic reboot in late 2021. Along with the reprint, Gale Force Nine also released three expansion sets that allows players to control six additional factions, Ixians, the Tleilaxu, CHOAM, House Richese, House Ecaz, and House Moritani, co-designed by Greg Olotka and Jack Reda.\\n\\n\\n== Gameplay ==\\nPlayers take on the role of one of the factions in the politics of the planet Arrakis. Victory in the game is achieved by controlling a specified number of strongholds, either alone or in an alliance with other players.\\nThe game board, which is based on the book's original map, represents the planet's northern hemisphere. It is divided into radial sections and territories, some of which overlap multiple radial sections. Five territories contain strongholds.\\nThe radial divisions are used exclusively for storm movement. The planet's permanent coriolis storm moves along the radial sections, destroying any troops in its way. It is possible for a multi-radial territory to be partly in storm and partly clear.\\nPlayers move their units from territory to territory. If two or more players enter the same territory, a battle ensues and the contest is resolved using a hidden bidding system based on troop numbers, leaders, and possible treachery cards.\\nSpice serves as money. Each turn, one territory (determined by a card draw) produces a \\\"spice blow\\\", which places an amount of spice in that territory. This is one of the two ways in which all factions can earn spice for auctions, transportation, revival, and negotiating deals. The other is by winning a battle in which a leader is killed, which earns the faction the leader's value in spice.\\nAn auction is held each turn in which players can purchase \\\"treachery cards\\\". These cards contain a variety of uses such as weapons and defenses, which can be used as advantages in resolving battles.\\nEach player has five leader tokens of varying strengths. Leaders are used in combat to supplement the strength of their units. However, each player may have one or more traitors among the other players' leaders, so using leaders can be a risk. Leaders can be killed in combat, but players may use spice to buy dead leaders back from the Bene Tleilaxu tanks.\\n\\n\\n=== Combat ===\\nBattle results when a territory is contested. Combat is resolved using a battle wheel, which consists of three parts: the number of troops, the leader, and any treachery cards which will be used during the battle.\\nEach player in the contest chooses in secret to sacrifice a number of their troops in that territory. Each unit sacrificed gives them a base score of one. Leader tokens add to the strength of their side, provided it survives the attack by the opposing leader. Attacks and defenses affecting leaders are chosen in secret by the players from their available treachery cards.\\nOnce both players have chosen their strategies, they reveal the number of units, leaders and items used. If the player has chosen their opponent's traitor, they are defeated. Otherwise, if a player has used a weapon against which the other player has not used a defense, their opponent's leader is killed. If a laser is used against a shield, all units and leaders are killed from both sides. Otherwise, the scores are then added together, and the player with the lower score is defeated. The player with the higher score, while victorious, still must lose the number of units they planned in their strategy.  In the event of a tie, the attacking player wins the battle.\\n\\n\\n=== Factions ===\\nEach faction has unique powers which modify the rules. Both the default abilities and the optional \\\"Additional Character Advantages\\\" are included below.\\n\\nHouse Atreides\\nDuring auctions, the Atreides player may use \\\"prescience\\\" to view the treachery card being bid on, while other players must bid blind. The Atreides player may also use prescience to look at the next spice blow card, and force their opponents to reveal one element of their battle plan. In advanced rules, the Atreides player may bring the Kwizatz Haderach into play, which adds a bonus to the battle wheel.\\nThe Bene Gesserit\\nThe Bene Gesserit player may temporarily \\\"coexist\\\" with other players' units without causing a confrontation, which allows transportation of one unit to the polar sink free of charge for every other player's transport. The player may command other players to use or not to use certain cards during combat (representing their use of \\\"the Voice\\\"). At the beginning of the game the Bene Gesserit player secretly records the name of another player and the turn at which they think that other player will win the game. If the Bene Gesserit correctly guesses who will win and when, they win the game instead. In advanced rules, Bene Gesserit units are capable of extended coexistence and arrive in the same territory as the other player's transport.\\nThe Padishah Emperor\\nWhen the other players buy treachery cards, they pay the Emperor. The player may revive up to three additional units as gholas. In advanced play, the Emperor has five elite units (Sardaukar) that are twice as effective as ordinary units, although they lose this bonus against the Fremen.\\nThe Fremen\\nThe Fremen armies are already on Arrakis, so they need not pay shipping costs to the Guild. They are also able to use \\\"desert power\\\" to move two territories per turn instead of one. Their troops are not killed if a worm appears; instead, they can ride the worm to a location of their choice. If no-one has won after ten turns and certain strongholds are either unoccupied or occupied by the Fremen, they win. In advanced play, they have three elite units (Fedaykin), and only suffer half losses from the storm.\\nThe Spacing Guild\\nThe Guild player receives the payment when other players transport units onto the board, while paying only half for transporting themselves. They can ship units around the planet, or even send them back to their reserves. If no-one has won after ten turns, and the Fremen don't win, the Guild does. In advanced play, they can choose to take their turn at any point during a turn.\\nHouse Harkonnen\\nWhen the Harkonnen player buys a treachery card, they receive a second one free, without having to show it to the Atreides player. They can hold twice as many treachery cards as other players, to a maximum of eight. Where the other players must choose one traitor out of four, the Harkonnen player can keep all four. In advanced rules, whenever they win a battle, they may kill or temporarily capture a random leader from the loser.\\nEach faction also grants some aspect of their powers to their allies.\\n\\n\\n=== Winning ===\\nA faction wins by controlling three of the five strongholds at the end of a turn. An alliance of factions wins by controlling four of the five strongholds at the end of a turn. In a game with only two factions, the winning faction must control four strongholds.\\nIn a recommended \\\"longer game\\\" variant a faction or alliance of factions must control four strongholds, or all five in a game with only two factions.\\nThree other winning conditions exist:\\nThe Fremen win at the end of turn 10 (the final round of game play) if no faction has won the game by the normal criteria and the occupancy of certain strongholds meets certain constraints. This win condition represents a situation where the Fremen have prevented interference with their own plans for Dune.\\nThe Guild wins if, at the end of turn 10, no faction has won via the conventional win, and the Fremen win conditions are not met. This win condition represents the situation where the Guild has preserved the status quo on Dune and may continue to provide shipping services.\\nThe Bene Gesserit win if, after a faction or alliance has succeeded in a conventional win, they reveal that they predicted (prior to the game's start) that that faction would win in that turn. The Bene Gesserit need only predict one of the winning players in the event of an alliance win. If the Bene Gesserit cause their own alliance to win in the turn that they predicted one of their allies would win, then the Bene Gesserit alone win. This win condition represents the situation where the Bene Gesserit have manipulated the situation so that their hidden agenda is fulfilled.\\nThe Bene Gesserit cannot predict the Fremen or Guild turn 10 default wins.  However they may predict that the Fremen or the Guild will win in turn 10 by the normal majority stronghold occupancy criteria.\\n\\n\\n== Reception ==\\nIn the January\\u2013February 1980 edition of The Space Gamer (Issue No. 26), Tony Watson commented that \\\"Not only is Dune a good game, it does an amazingly accurate job of conveying the feel and air of Dune the novel.\\\"\\nIn the inaugural edition of Ares Magazine (March 1980), Eric Goldberg gave it a below average rating of 6 out of 9, saying, \\\"Battles are won and lost dependent on the number of spice tokens present in an area. Treachery, storms and the fearsome shai-hulud (gigantic sandworms) enliven affairs. Dune is a nice little game, but nothing special.\\\"\\nIn Issue 77 of the UK magazine Games & Puzzles, Nick Palmer was impressed, writing, \\\"The ability of the game to bring out the delicate power balance in the planetary power struggle depicted by the book is nothing short of extraordinary \\u2014 and yet the rules occupy a mere three pages!\\\" However, Palmer had issues with the alliance rule, which states that players in an alliance can jointly win the game. But Palmer pointed out \\\"A strong alliance can generally win at once, and if one wants to avoid an abrupt ending it seems best to limit wins to single players. One can then employ Diplomacy-like cunning in lining up some unsuspecting allies before making a dash for victory, since allies cannot interfere with each other's plans until alliances are reviewed when the next sandworm appears.\\\"  Nonetheless, Palmer game the game an Excitement rating of 5 out of 5, saying, \\\"Dune is in my view the best game that appeared in 1979, simple, fast-moving, yet packed with strategic and tactical ingenuity.\\\"\\nIn the December 1993 edition of Dragon (Issue 200), Allen Varney considered Dune a classic, saying \\\"Unique flavor comes with the movement rules, combat strategies, and chances that your leaders will turn traitor.\\\" However, Varney advised \\\"Don\\u2019t bother with the unbalanced advanced rules that Avalon Hill foisted on the clean basic design.\\\"\\nIn a retrospective review in There Will Be Games, Jonathan Volk gave high praise to the game's unusual, asymmetrical design. In Dune, he noted, there is no artificial balance, no \\\"Arthurian circularity\\\" to the game table: the various player positions have wildly differing strengths and weaknesses, and the unfairness of the world setup makes \\\"a seductive point of entry\\\". More importantly, that unfairness presses players into complex social relations and moral quandaries rarely found in games. It's \\\"impossibly good, better than any board game I\\u2019ve played, and I\\u2019ve played a lot of them,\\\" wrote Volk, summing up: \\\"No game lingers with me more than Dune.\\nTom Mendelsohn, in a retrospective review from Ars Technica, stated that the game was \\\"moderately popular\\\" during its release, but commented that the 1984 re-release was commercially unsuccessful. Mendelsohn, however, stated that the game was \\\"ahead of its time\\\", shown by the variable number of rounds each game. The reviewer additionally complimented the tenseness, the combat as a \\\"state-of-the-art\\\" mechanic that is a \\\"battle of wits and bluffing\\\", and praised the hidden information and \\\"bursts of chaos\\\". Nevertheless, the asymmetry was criticised as unappealing to some players, Mehdelsohn also stated that the rules are \\\"full of holes and ambiguities\\\" and that the expansions are dubiously necessary. The review also described that Rex: Final Days of an Empire was received less favourably. Similar to Mendelsohn, who commented that Dune \\\"features more than a few rough edges courtesy of how ahead of its time it was\\\", Luke Plunkett from Kotaku observed that the game had \\\"rough edges\\\", criticising that \\\"If a major publisher was pitched Dune in 2020 they\\u2019d likely tear it to pieces, aghast at how so many of this game\\u2019s features are seemingly worthless, overpowered or both at the same time.\\\" Nonetheless, he praised that the \\\"elastic nature\\\" of victory conditions and \\\"treachery lurking\\\", and complimented the engagement in consequence of \\\"unpredictability and unfairness\\\".\\n\\n\\n== Reviews ==\\nCasus Belli #24 (Feb 1985)\\n1982 Games 100 in Games\\n\\n\\n== Expansions ==\\nThe Duel is a 1984 expansion for Dune published by The Avalon Hill Game Company. It provides optional rules for duels between character groups.\\nSteve Crow reviewed The Duel in The Space Gamer No. 76. Crow commented that \\\"In all, The Duel makes an interesting supplement to the original Dune rules, but overuse of the challenge rules just bogs down the game.\\\"\\nThe 2019 Gale Force Nine edition has released three expansions to date, Ixians & Tleilaxu, which adds both of those factions, along with Tech Tokens and additional Treachery Cards, and other new cards, CHOAM & Richese, which adds two more factions, Leader Skill Cards, and Advanced Stronghold Cards, and Ecaz & Moritani, which adds another two factions, homeworld tokens, and new cards.\\nAll three expansions were designed by Eberle, Kittridge, and Olotka, along with Greg Olotka and Jack Reda.\\n\\n\\n== References ==\\n\\n\\n== Further reading ==\\nMendelsohn, Tom (13 May 2017). \\\"Dune: Spice and sandworms power one of the great \\\"lost\\\" board games\\\". Ars Technica. Retrieved 13 November 2021.\\n\\n\\n== External links ==\\nDune   at BoardGameGeek\\nThe Dune Emulator Free computer game version of the board game for Windows\\nVideo Guide to Dune\\n2020 board game review\",\n          \"The 7th Continent is a 2017 storytelling cooperative board game designed by Ludovic Roudy and Bruno Sautter.\\nThe game was crowdfunded through the Kickstarter platform, where it became one of the most funded projects of that year, raising over 5 million USD in less than 24 hours.\\n\\n\\n== Gameplay ==\\nThe 7th Continent is inspired by adventure books within which players are able to make their own survival decisions. This aligns with the tagline of the game, \\\"YOU are the hero\\\". It can be played individually or with up to four individual players or teams. Players can progress through the game at their preferred pace; it features a save system that allows for the game to be paused and re-started where left off. Each player can save the items they have collected, along with their action deck and terrain card. The game requires players to use a combination of survival skills through the game. These survival skills include hunting, fishing, crafting items, using the current environment of player to advantage, and gaining experience points to trade for new skills. Players go through a different adventure each time the game is played due to the multiple possible random events and alternatives that are possible for any single card. Players can be both easily added and dropped out of a game. The game is designed to be played with cards and dice.\\nThe game exists in a universe where a mysterious land has been discovered off the coast of Antarctica known as the seventh continent. Within this story, each player is an explorer who has just returned from the first expedition to the seventh continent. Several other members of this expedition group have disappeared suddenly upon their return. This explorer has been feeling strange symptoms for the past few days. As the explorer falls asleep at night, they are transported back to the seventh continent where they must lift the curse they are under to resolve the situation. This point is where the board game begins for each player. The goal of the game is help lift the curses that players are fighting through the help of clues. One clue per curse is provided at the start of the game. These clue cards are shuffled into the deck. The game is furthered gradually through the use of Terrain and Event cards. Terrain or adventure cards represent a patch of land or the contents of the seventh continent that a player will explore. They also include information about the events that occur around that terrain. Action cards are played to move about and take various decisions. The action deck contains skills and items that players gain through the game, as well as cards that allow exploration of the continent. These cards also represent a player's health. Players can choose to perform actions individually or in conjunction with other players.\\n\\n\\n== Versions ==\\nThe game is exclusively available through the Serious Poulp website. There is the option of buying a \\\"Classic Edition\\\" base box and a \\\"Collector Edition\\\" base box. The \\\"Collector Edition\\\" base box is exclusively available for those who helped fund the game on Kickstarter. The \\\"Classic Edition\\\" base box retails for $69 USD through the website. Expansion card packets are also available. Additionally, various game accessories are also available for purchase through Serious Poulp. There are also mobile apps available for the game on both the Android and the Apple platforms.\\n\\n\\n== Awards ==\\n2017 Swiss Gamers Award Winner\\n2017 Board Game Quest Awards Best Card Game Winner\\n\\n\\n== References ==\\n\\n\\n== External links ==\\nThe 7th Continent   at BoardGameGeek\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#\n",
        "# Drop Rank, Rating, Weight Columns\n",
        "#\n",
        "\n",
        "data.drop(['Rank', 'Rating', 'Weight'], axis=1, inplace=True)\n",
        "data.head()\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "-6b3CmWDtxpX",
        "outputId": "e9e837c6-34b5-44b9-9949-6042222f7850"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                Name  \\\n",
              "0                        Gloomhaven    \n",
              "1          Pandemic Legacy: Season 1   \n",
              "2                  Brass: Birmingham   \n",
              "3                  Terraforming Mars   \n",
              "4  Twilight Imperium: Fourth Edition   \n",
              "\n",
              "                                            Subtitle  Year  MinPlayers  \\\n",
              "0  Vanquish monsters with strategic cardplay. Ful...  2017           1   \n",
              "1  Mutating diseases are spreading around the wor...  2015           2   \n",
              "2  Build networks, grow industries, and navigate ...  2018           2   \n",
              "3  Compete with rival CEOs to make Mars habitable...  2016           1   \n",
              "4  Build an intergalactic empire through trade, r...  2017           3   \n",
              "\n",
              "   MaxPlayers BestPlayers  MinPlayTime  MaxPlayTime  MinAge     Type_1  \\\n",
              "0           4           3           60          120      14   Strategy   \n",
              "1           4           4           60           60      13   Strategy   \n",
              "2           4        3, 4           60          120      14  Strategy    \n",
              "3           5           3          120          120      12  Strategy    \n",
              "4           6           6          240          480      14   Strategy   \n",
              "\n",
              "       Type_2                                  wiki_game_summary  \n",
              "0    Thematic                                               None  \n",
              "1    Thematic  A legacy game is a variant of tabletop board g...  \n",
              "2        None                                               None  \n",
              "3        None  Terraforming Mars is a board game for 1 to 5 p...  \n",
              "4    Thematic  Twilight Imperium is a strategy board game pro...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-d0f3e253-3d3c-48aa-bba7-abfe8fe1fa01\" class=\"colab-df-container\">\n",
              "    <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>Subtitle</th>\n",
              "      <th>Year</th>\n",
              "      <th>MinPlayers</th>\n",
              "      <th>MaxPlayers</th>\n",
              "      <th>BestPlayers</th>\n",
              "      <th>MinPlayTime</th>\n",
              "      <th>MaxPlayTime</th>\n",
              "      <th>MinAge</th>\n",
              "      <th>Type_1</th>\n",
              "      <th>Type_2</th>\n",
              "      <th>wiki_game_summary</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Gloomhaven</td>\n",
              "      <td>Vanquish monsters with strategic cardplay. Ful...</td>\n",
              "      <td>2017</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>3</td>\n",
              "      <td>60</td>\n",
              "      <td>120</td>\n",
              "      <td>14</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>Thematic</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Pandemic Legacy: Season 1</td>\n",
              "      <td>Mutating diseases are spreading around the wor...</td>\n",
              "      <td>2015</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>60</td>\n",
              "      <td>60</td>\n",
              "      <td>13</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>Thematic</td>\n",
              "      <td>A legacy game is a variant of tabletop board g...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Brass: Birmingham</td>\n",
              "      <td>Build networks, grow industries, and navigate ...</td>\n",
              "      <td>2018</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>3, 4</td>\n",
              "      <td>60</td>\n",
              "      <td>120</td>\n",
              "      <td>14</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>None</td>\n",
              "      <td>None</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Terraforming Mars</td>\n",
              "      <td>Compete with rival CEOs to make Mars habitable...</td>\n",
              "      <td>2016</td>\n",
              "      <td>1</td>\n",
              "      <td>5</td>\n",
              "      <td>3</td>\n",
              "      <td>120</td>\n",
              "      <td>120</td>\n",
              "      <td>12</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>None</td>\n",
              "      <td>Terraforming Mars is a board game for 1 to 5 p...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Twilight Imperium: Fourth Edition</td>\n",
              "      <td>Build an intergalactic empire through trade, r...</td>\n",
              "      <td>2017</td>\n",
              "      <td>3</td>\n",
              "      <td>6</td>\n",
              "      <td>6</td>\n",
              "      <td>240</td>\n",
              "      <td>480</td>\n",
              "      <td>14</td>\n",
              "      <td>Strategy</td>\n",
              "      <td>Thematic</td>\n",
              "      <td>Twilight Imperium is a strategy board game pro...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-d0f3e253-3d3c-48aa-bba7-abfe8fe1fa01')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-d0f3e253-3d3c-48aa-bba7-abfe8fe1fa01 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-d0f3e253-3d3c-48aa-bba7-abfe8fe1fa01');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-0be8ecbc-3953-4a02-9302-79a88f834874\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-0be8ecbc-3953-4a02-9302-79a88f834874')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-0be8ecbc-3953-4a02-9302-79a88f834874 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "data",
              "summary": "{\n  \"name\": \"data\",\n  \"rows\": 100,\n  \"fields\": [\n    {\n      \"column\": \"Name\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 100,\n        \"samples\": [\n          \"Caylus\",\n          \"Star Wars: Imperial Assault\",\n          \"Teotihuacan: City of Gods\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Subtitle\",\n      \"properties\": {\n        \"dtype\": \"string\",\n        \"num_unique_values\": 100,\n        \"samples\": [\n          \"Entrepreneurs pay workers & bribe an official to build a Ch?teau & gain royal favor.\",\n          \"Play as Rebel or Imperial forces to fulfil mission objectives.\",\n          \"Use your worker dice to raise the legendary and breathtaking Pyramid of the Sun.\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Year\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 14,\n        \"min\": 1876,\n        \"max\": 2020,\n        \"num_unique_values\": 21,\n        \"samples\": [\n          2017,\n          2010,\n          2006\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MinPlayers\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 0,\n        \"min\": 1,\n        \"max\": 3,\n        \"num_unique_values\": 3,\n        \"samples\": [\n          1,\n          2,\n          3\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MaxPlayers\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1,\n        \"min\": 2,\n        \"max\": 8,\n        \"num_unique_values\": 6,\n        \"samples\": [\n          4,\n          5,\n          8\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"BestPlayers\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 11,\n        \"samples\": [\n          \"4, 5\",\n          \"3\",\n          \"2, 4\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MinPlayTime\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 38,\n        \"min\": 5,\n        \"max\": 240,\n        \"num_unique_values\": 15,\n        \"samples\": [\n          40,\n          20,\n          60\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MaxPlayTime\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 107,\n        \"min\": 20,\n        \"max\": 1000,\n        \"num_unique_values\": 17,\n        \"samples\": [\n          120,\n          60,\n          180\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"MinAge\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1,\n        \"min\": 8,\n        \"max\": 17,\n        \"num_unique_values\": 7,\n        \"samples\": [\n          14,\n          13,\n          17\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Type_1\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 7,\n        \"samples\": [\n          \"Strategy\",\n          \"Strategy\\u00a0\",\n          \"Abstract\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Type_2\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 4,\n        \"samples\": [\n          \"\\u00a0\\u00a0Wargames\",\n          \"\\u00a0\\u00a0Family\",\n          \"\\u00a0\\u00a0Thematic\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"wiki_game_summary\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 35,\n        \"samples\": [\n          \"Le Havre is a board game about the development of the town of Le Havre.  It was inspired by the games Caylus and Agricola and was developed in December 2007.\\nThe game was edited by Uwe Rosenberg and Hanno Girke and the former gets the main cover credit. The illustrator was Klemens Franz while the English translator was Melissa Rogerson. Numerous credits are given to others who assisted with playtesting and other tasks.  The game was published by Lookout Games and distributed by Heidelberger Spieleverlag.\\nThe game was released at Spiel 2008 in both German and Australian English, with both editions published by Lookout Games. It did not do as well as its predecessor Agricola in the Fairplay polls, with a rating of 2.51 (1 is best), but has a high rating of 7.9/10 at BoardGameGeek (a different rating system), ranking among the top 100 games and is generally considered to be highly regarded by critics.\\nThe game was adapted into an iOS app by Codito Development Inc. and released on June 21, 2012. The game has a Metacritic rating of 82% based on 6 critic reviews.\\nA two player version called Le Havre: The Inland Port was released in 2012.  There is also a corresponding iOS app.\\n\\n\\n== Gameplay ==\\nThe gameplay takes place in the harbour of Le Havre, where players take goods such as fish and wood from the wharves. These goods are used either to feed the players' community, to construct buildings and ships, or are processed into finished goods. For example, a smokehouse building may be constructed in which players may process fish into smoked fish, which is more valuable.\\nThe game is played for a set number of rounds. The winner is the player with the greatest net wealth at the end.\\nPoints are earned by making money, building buildings and ships (which each have their own values), and selling goods. At the end of each round, players must be able to give food to their workers. The amount of food depends on the round number and the number of players, starting out low and gradually increasing as the game progresses. Players not planning ahead will soon find themselves with a shortage of food which will require taking loans from the Bank. Building ships can help with this food problem, as each ship will give the player a discount on their food each round (they count as trade routes which give the player more sources of food).\\n\\n\\n== References ==\\n\\n\\n== External links ==\\nLookout Games' Le Havre homepage\\nLe Havre   at BoardGameGeek\",\n          \"Dune is a strategy board game set in Frank Herbert's Dune universe, published by Avalon Hill in 1979. The game was designed by Bill Eberle, Jack Kittredge and Peter Olotka. After many years out of print, the game was reissued by Gale Force Nine in 2019 in advance of the 2021 Dune film adaptation.\\n\\n\\n== History ==\\nThe game was originally designed with a Roman Empire theme, with the name Tribute. Avalon Hill had acquired the license to produce a Dune game, but when their design proved unusable, the company contacted Eberle, Kittredge and Olotka. Elements suitable for the Dune universe were added to the game, particularly from their earlier game, Cosmic Encounter.\\nIn 1984, to tie in with the Dune film, Avalon Hill published a second edition of the game as well as two expansions, Spice Harvest and The Duel.\\nThe Spice Harvest expansion changes the initial setup of the standard game by adding a pre-game in which the factions lobby for control of the inter-world Spice market in order to purchase a more advantageous initial position for the start of the main game (control for the planet of Arrakis).\\nThe Duel adds \\\"leader tokens\\\" representing the primary leaders of each faction and a secondary board representing a circular arena for one-on-one combat. Leaders may fight individual combat using a special deck of cards for movement and attacks.\\nBoth supplements included additional Treachery Cards. Both supplements are also incorporated into the French edition published by Jeux Descartes.\\nIn addition, Avalon Hill's strategy magazines, The General and Heroes, published counters and rules for three additional factions: the Bene Tleilax, the Ixians, and the Landsraad, factions and organizations that appeared in Frank Herbert's original novels.\\nThe game received good reviews and due to the popularity of the Dune setting, coupled with the lack of new edition since 1984, became a sought-after item among board game collectors, with prices on secondary market reaching hundreds of dollars. A fan-made print-and-play version was also made available online around 2010.\\nIn the 1990s, Jeux Descartes published a French edition of the game.\\nThe game was reprinted by Fantasy Flight Games in 2012 as Rex: Final Days of an Empire. Fantasy Flight was able to acquire the rights to the system used in Dune (known as the \\u201cSimultaneous Dial Based Order System\\u201d), but were not able to get the license for the Dune setting. As a result, the game's setting was switched to Fantasy Flight's Twilight Imperium universe.\\nWith the demise of Avalon Hill, Dune remained out of print for many years despite being a highly regarded board game. With newfound interest in the Dune series due to the upcoming 2021 Dune film, board game publisher Gale Force 9 reached out to the Herbert estate, which owns the general rights to the game, and received permission to remake it. The art was new for this edition, drawn by Russian illustrator \\\"Ilya77\\\", who was commissioned for the reuse of their art, in addition to the game's original designers, Bill Eberle, Jack Kittredge, and Peter Olotka. Gale Force 9 made very few changes of the game's original rules, tweaking about 3 to 5 percent of the rules. The game was released on October 30, 2019 in advance of the Dune cinematic reboot in late 2021. Along with the reprint, Gale Force Nine also released three expansion sets that allows players to control six additional factions, Ixians, the Tleilaxu, CHOAM, House Richese, House Ecaz, and House Moritani, co-designed by Greg Olotka and Jack Reda.\\n\\n\\n== Gameplay ==\\nPlayers take on the role of one of the factions in the politics of the planet Arrakis. Victory in the game is achieved by controlling a specified number of strongholds, either alone or in an alliance with other players.\\nThe game board, which is based on the book's original map, represents the planet's northern hemisphere. It is divided into radial sections and territories, some of which overlap multiple radial sections. Five territories contain strongholds.\\nThe radial divisions are used exclusively for storm movement. The planet's permanent coriolis storm moves along the radial sections, destroying any troops in its way. It is possible for a multi-radial territory to be partly in storm and partly clear.\\nPlayers move their units from territory to territory. If two or more players enter the same territory, a battle ensues and the contest is resolved using a hidden bidding system based on troop numbers, leaders, and possible treachery cards.\\nSpice serves as money. Each turn, one territory (determined by a card draw) produces a \\\"spice blow\\\", which places an amount of spice in that territory. This is one of the two ways in which all factions can earn spice for auctions, transportation, revival, and negotiating deals. The other is by winning a battle in which a leader is killed, which earns the faction the leader's value in spice.\\nAn auction is held each turn in which players can purchase \\\"treachery cards\\\". These cards contain a variety of uses such as weapons and defenses, which can be used as advantages in resolving battles.\\nEach player has five leader tokens of varying strengths. Leaders are used in combat to supplement the strength of their units. However, each player may have one or more traitors among the other players' leaders, so using leaders can be a risk. Leaders can be killed in combat, but players may use spice to buy dead leaders back from the Bene Tleilaxu tanks.\\n\\n\\n=== Combat ===\\nBattle results when a territory is contested. Combat is resolved using a battle wheel, which consists of three parts: the number of troops, the leader, and any treachery cards which will be used during the battle.\\nEach player in the contest chooses in secret to sacrifice a number of their troops in that territory. Each unit sacrificed gives them a base score of one. Leader tokens add to the strength of their side, provided it survives the attack by the opposing leader. Attacks and defenses affecting leaders are chosen in secret by the players from their available treachery cards.\\nOnce both players have chosen their strategies, they reveal the number of units, leaders and items used. If the player has chosen their opponent's traitor, they are defeated. Otherwise, if a player has used a weapon against which the other player has not used a defense, their opponent's leader is killed. If a laser is used against a shield, all units and leaders are killed from both sides. Otherwise, the scores are then added together, and the player with the lower score is defeated. The player with the higher score, while victorious, still must lose the number of units they planned in their strategy.  In the event of a tie, the attacking player wins the battle.\\n\\n\\n=== Factions ===\\nEach faction has unique powers which modify the rules. Both the default abilities and the optional \\\"Additional Character Advantages\\\" are included below.\\n\\nHouse Atreides\\nDuring auctions, the Atreides player may use \\\"prescience\\\" to view the treachery card being bid on, while other players must bid blind. The Atreides player may also use prescience to look at the next spice blow card, and force their opponents to reveal one element of their battle plan. In advanced rules, the Atreides player may bring the Kwizatz Haderach into play, which adds a bonus to the battle wheel.\\nThe Bene Gesserit\\nThe Bene Gesserit player may temporarily \\\"coexist\\\" with other players' units without causing a confrontation, which allows transportation of one unit to the polar sink free of charge for every other player's transport. The player may command other players to use or not to use certain cards during combat (representing their use of \\\"the Voice\\\"). At the beginning of the game the Bene Gesserit player secretly records the name of another player and the turn at which they think that other player will win the game. If the Bene Gesserit correctly guesses who will win and when, they win the game instead. In advanced rules, Bene Gesserit units are capable of extended coexistence and arrive in the same territory as the other player's transport.\\nThe Padishah Emperor\\nWhen the other players buy treachery cards, they pay the Emperor. The player may revive up to three additional units as gholas. In advanced play, the Emperor has five elite units (Sardaukar) that are twice as effective as ordinary units, although they lose this bonus against the Fremen.\\nThe Fremen\\nThe Fremen armies are already on Arrakis, so they need not pay shipping costs to the Guild. They are also able to use \\\"desert power\\\" to move two territories per turn instead of one. Their troops are not killed if a worm appears; instead, they can ride the worm to a location of their choice. If no-one has won after ten turns and certain strongholds are either unoccupied or occupied by the Fremen, they win. In advanced play, they have three elite units (Fedaykin), and only suffer half losses from the storm.\\nThe Spacing Guild\\nThe Guild player receives the payment when other players transport units onto the board, while paying only half for transporting themselves. They can ship units around the planet, or even send them back to their reserves. If no-one has won after ten turns, and the Fremen don't win, the Guild does. In advanced play, they can choose to take their turn at any point during a turn.\\nHouse Harkonnen\\nWhen the Harkonnen player buys a treachery card, they receive a second one free, without having to show it to the Atreides player. They can hold twice as many treachery cards as other players, to a maximum of eight. Where the other players must choose one traitor out of four, the Harkonnen player can keep all four. In advanced rules, whenever they win a battle, they may kill or temporarily capture a random leader from the loser.\\nEach faction also grants some aspect of their powers to their allies.\\n\\n\\n=== Winning ===\\nA faction wins by controlling three of the five strongholds at the end of a turn. An alliance of factions wins by controlling four of the five strongholds at the end of a turn. In a game with only two factions, the winning faction must control four strongholds.\\nIn a recommended \\\"longer game\\\" variant a faction or alliance of factions must control four strongholds, or all five in a game with only two factions.\\nThree other winning conditions exist:\\nThe Fremen win at the end of turn 10 (the final round of game play) if no faction has won the game by the normal criteria and the occupancy of certain strongholds meets certain constraints. This win condition represents a situation where the Fremen have prevented interference with their own plans for Dune.\\nThe Guild wins if, at the end of turn 10, no faction has won via the conventional win, and the Fremen win conditions are not met. This win condition represents the situation where the Guild has preserved the status quo on Dune and may continue to provide shipping services.\\nThe Bene Gesserit win if, after a faction or alliance has succeeded in a conventional win, they reveal that they predicted (prior to the game's start) that that faction would win in that turn. The Bene Gesserit need only predict one of the winning players in the event of an alliance win. If the Bene Gesserit cause their own alliance to win in the turn that they predicted one of their allies would win, then the Bene Gesserit alone win. This win condition represents the situation where the Bene Gesserit have manipulated the situation so that their hidden agenda is fulfilled.\\nThe Bene Gesserit cannot predict the Fremen or Guild turn 10 default wins.  However they may predict that the Fremen or the Guild will win in turn 10 by the normal majority stronghold occupancy criteria.\\n\\n\\n== Reception ==\\nIn the January\\u2013February 1980 edition of The Space Gamer (Issue No. 26), Tony Watson commented that \\\"Not only is Dune a good game, it does an amazingly accurate job of conveying the feel and air of Dune the novel.\\\"\\nIn the inaugural edition of Ares Magazine (March 1980), Eric Goldberg gave it a below average rating of 6 out of 9, saying, \\\"Battles are won and lost dependent on the number of spice tokens present in an area. Treachery, storms and the fearsome shai-hulud (gigantic sandworms) enliven affairs. Dune is a nice little game, but nothing special.\\\"\\nIn Issue 77 of the UK magazine Games & Puzzles, Nick Palmer was impressed, writing, \\\"The ability of the game to bring out the delicate power balance in the planetary power struggle depicted by the book is nothing short of extraordinary \\u2014 and yet the rules occupy a mere three pages!\\\" However, Palmer had issues with the alliance rule, which states that players in an alliance can jointly win the game. But Palmer pointed out \\\"A strong alliance can generally win at once, and if one wants to avoid an abrupt ending it seems best to limit wins to single players. One can then employ Diplomacy-like cunning in lining up some unsuspecting allies before making a dash for victory, since allies cannot interfere with each other's plans until alliances are reviewed when the next sandworm appears.\\\"  Nonetheless, Palmer game the game an Excitement rating of 5 out of 5, saying, \\\"Dune is in my view the best game that appeared in 1979, simple, fast-moving, yet packed with strategic and tactical ingenuity.\\\"\\nIn the December 1993 edition of Dragon (Issue 200), Allen Varney considered Dune a classic, saying \\\"Unique flavor comes with the movement rules, combat strategies, and chances that your leaders will turn traitor.\\\" However, Varney advised \\\"Don\\u2019t bother with the unbalanced advanced rules that Avalon Hill foisted on the clean basic design.\\\"\\nIn a retrospective review in There Will Be Games, Jonathan Volk gave high praise to the game's unusual, asymmetrical design. In Dune, he noted, there is no artificial balance, no \\\"Arthurian circularity\\\" to the game table: the various player positions have wildly differing strengths and weaknesses, and the unfairness of the world setup makes \\\"a seductive point of entry\\\". More importantly, that unfairness presses players into complex social relations and moral quandaries rarely found in games. It's \\\"impossibly good, better than any board game I\\u2019ve played, and I\\u2019ve played a lot of them,\\\" wrote Volk, summing up: \\\"No game lingers with me more than Dune.\\nTom Mendelsohn, in a retrospective review from Ars Technica, stated that the game was \\\"moderately popular\\\" during its release, but commented that the 1984 re-release was commercially unsuccessful. Mendelsohn, however, stated that the game was \\\"ahead of its time\\\", shown by the variable number of rounds each game. The reviewer additionally complimented the tenseness, the combat as a \\\"state-of-the-art\\\" mechanic that is a \\\"battle of wits and bluffing\\\", and praised the hidden information and \\\"bursts of chaos\\\". Nevertheless, the asymmetry was criticised as unappealing to some players, Mehdelsohn also stated that the rules are \\\"full of holes and ambiguities\\\" and that the expansions are dubiously necessary. The review also described that Rex: Final Days of an Empire was received less favourably. Similar to Mendelsohn, who commented that Dune \\\"features more than a few rough edges courtesy of how ahead of its time it was\\\", Luke Plunkett from Kotaku observed that the game had \\\"rough edges\\\", criticising that \\\"If a major publisher was pitched Dune in 2020 they\\u2019d likely tear it to pieces, aghast at how so many of this game\\u2019s features are seemingly worthless, overpowered or both at the same time.\\\" Nonetheless, he praised that the \\\"elastic nature\\\" of victory conditions and \\\"treachery lurking\\\", and complimented the engagement in consequence of \\\"unpredictability and unfairness\\\".\\n\\n\\n== Reviews ==\\nCasus Belli #24 (Feb 1985)\\n1982 Games 100 in Games\\n\\n\\n== Expansions ==\\nThe Duel is a 1984 expansion for Dune published by The Avalon Hill Game Company. It provides optional rules for duels between character groups.\\nSteve Crow reviewed The Duel in The Space Gamer No. 76. Crow commented that \\\"In all, The Duel makes an interesting supplement to the original Dune rules, but overuse of the challenge rules just bogs down the game.\\\"\\nThe 2019 Gale Force Nine edition has released three expansions to date, Ixians & Tleilaxu, which adds both of those factions, along with Tech Tokens and additional Treachery Cards, and other new cards, CHOAM & Richese, which adds two more factions, Leader Skill Cards, and Advanced Stronghold Cards, and Ecaz & Moritani, which adds another two factions, homeworld tokens, and new cards.\\nAll three expansions were designed by Eberle, Kittridge, and Olotka, along with Greg Olotka and Jack Reda.\\n\\n\\n== References ==\\n\\n\\n== Further reading ==\\nMendelsohn, Tom (13 May 2017). \\\"Dune: Spice and sandworms power one of the great \\\"lost\\\" board games\\\". Ars Technica. Retrieved 13 November 2021.\\n\\n\\n== External links ==\\nDune   at BoardGameGeek\\nThe Dune Emulator Free computer game version of the board game for Windows\\nVideo Guide to Dune\\n2020 board game review\",\n          \"The 7th Continent is a 2017 storytelling cooperative board game designed by Ludovic Roudy and Bruno Sautter.\\nThe game was crowdfunded through the Kickstarter platform, where it became one of the most funded projects of that year, raising over 5 million USD in less than 24 hours.\\n\\n\\n== Gameplay ==\\nThe 7th Continent is inspired by adventure books within which players are able to make their own survival decisions. This aligns with the tagline of the game, \\\"YOU are the hero\\\". It can be played individually or with up to four individual players or teams. Players can progress through the game at their preferred pace; it features a save system that allows for the game to be paused and re-started where left off. Each player can save the items they have collected, along with their action deck and terrain card. The game requires players to use a combination of survival skills through the game. These survival skills include hunting, fishing, crafting items, using the current environment of player to advantage, and gaining experience points to trade for new skills. Players go through a different adventure each time the game is played due to the multiple possible random events and alternatives that are possible for any single card. Players can be both easily added and dropped out of a game. The game is designed to be played with cards and dice.\\nThe game exists in a universe where a mysterious land has been discovered off the coast of Antarctica known as the seventh continent. Within this story, each player is an explorer who has just returned from the first expedition to the seventh continent. Several other members of this expedition group have disappeared suddenly upon their return. This explorer has been feeling strange symptoms for the past few days. As the explorer falls asleep at night, they are transported back to the seventh continent where they must lift the curse they are under to resolve the situation. This point is where the board game begins for each player. The goal of the game is help lift the curses that players are fighting through the help of clues. One clue per curse is provided at the start of the game. These clue cards are shuffled into the deck. The game is furthered gradually through the use of Terrain and Event cards. Terrain or adventure cards represent a patch of land or the contents of the seventh continent that a player will explore. They also include information about the events that occur around that terrain. Action cards are played to move about and take various decisions. The action deck contains skills and items that players gain through the game, as well as cards that allow exploration of the continent. These cards also represent a player's health. Players can choose to perform actions individually or in conjunction with other players.\\n\\n\\n== Versions ==\\nThe game is exclusively available through the Serious Poulp website. There is the option of buying a \\\"Classic Edition\\\" base box and a \\\"Collector Edition\\\" base box. The \\\"Collector Edition\\\" base box is exclusively available for those who helped fund the game on Kickstarter. The \\\"Classic Edition\\\" base box retails for $69 USD through the website. Expansion card packets are also available. Additionally, various game accessories are also available for purchase through Serious Poulp. There are also mobile apps available for the game on both the Android and the Apple platforms.\\n\\n\\n== Awards ==\\n2017 Swiss Gamers Award Winner\\n2017 Board Game Quest Awards Best Card Game Winner\\n\\n\\n== References ==\\n\\n\\n== External links ==\\nThe 7th Continent   at BoardGameGeek\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 12
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#\n",
        "# Convert BestPlayers into int64 column and remove additional numbers and comma (see row 2: Brass: Birmingham example)\n",
        "#\n",
        "\n",
        "data['BestPlayers'] = data['BestPlayers'].fillna('0').str.split(',').str[0].astype('int64')\n"
      ],
      "metadata": {
        "id": "o-MUpS2vpHHM"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "#\n",
        "# Drop empty wiki_game_summary records\n",
        "#\n",
        "\n",
        "print(data['wiki_game_summary'].isna().sum()) # 23\n",
        "data.dropna(subset=['wiki_game_summary'], inplace=True)\n",
        "\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "FdJWC9MytxvV",
        "outputId": "c4d075aa-f8e3-446d-d1fe-570ae8389887"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "23\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "data.info()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Xlx5d-nnpJVs",
        "outputId": "2d5b849a-3ad7-44ea-863c-a35c55a78fa5"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "Index: 77 entries, 1 to 99\n",
            "Data columns (total 12 columns):\n",
            " #   Column             Non-Null Count  Dtype \n",
            "---  ------             --------------  ----- \n",
            " 0   Name               77 non-null     object\n",
            " 1   Subtitle           77 non-null     object\n",
            " 2   Year               77 non-null     int64 \n",
            " 3   MinPlayers         77 non-null     int64 \n",
            " 4   MaxPlayers         77 non-null     int64 \n",
            " 5   BestPlayers        77 non-null     int64 \n",
            " 6   MinPlayTime        77 non-null     int64 \n",
            " 7   MaxPlayTime        77 non-null     int64 \n",
            " 8   MinAge             77 non-null     int64 \n",
            " 9   Type_1             77 non-null     object\n",
            " 10  Type_2             18 non-null     object\n",
            " 11  wiki_game_summary  77 non-null     object\n",
            "dtypes: int64(7), object(5)\n",
            "memory usage: 7.8+ KB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "#\n",
        "# Write to CSV and JSON\n",
        "#\n",
        "\n",
        "data.to_csv('board_game_dataset.csv', index= False)\n",
        "data.to_json('board_game_dataset.json')\n"
      ],
      "metadata": {
        "id": "3TFsB2VipnV5"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "ud7w455ppnW6"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}