data-prepare.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "1d26245f",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import copy\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "\n",
    "import warnings\n",
    "warnings.filterwarnings(\"ignore\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "7cfff9a0",
   "metadata": {},
   "outputs": [],
   "source": [
    "raw_scores = pd.read_excel('catan.xlsx', parse_dates=[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "e803f695",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index([                'Oyun No',                   'Tarih',\n",
       "                   'Asıl oyuncu',                    'Sıra',\n",
       "                  'Yedek oyuncu',                 'Kazanan',\n",
       "                          'Puan',                    'Renk',\n",
       "                  'Şehir Sayısı',              'Köy Sayısı',\n",
       "                    'Yol Sayısı',    'Gelişim Kartı Sayısı',\n",
       "             'ilk Gelişim Kartı',          'İlk Şehirleşen',\n",
       "                       'İlk Köy',            'Liman Sayısı',\n",
       "       'İlk Hangi Kaynak yanına',                    'Kasa',\n",
       "                          'Süre',               'Extension',\n",
       "                'Başlangıç Saat',             'En Uzun Yol',\n",
       "                       'Şövalye',     'İlk 2-1 Tuğla Liman',\n",
       "            'İlk 2-1 Kaya Liman',     'İlk 2-1 Saman Liman',\n",
       "           'İlk 2-1 Koyun Liman',      'İlk 2-1 Odun Liman',\n",
       "                 'İlk 3-1 Liman',               '2-1 Tuğla',\n",
       "                     '2-1 Saman',       2022-03-01 00:00:00,\n",
       "                      '2-1 Odun',                '2-1 Kaya',\n",
       "                     '2-1 Koyun',                     'Zar',\n",
       "                      'Çöl Yeri'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "raw_scores.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "0af45747",
   "metadata": {},
   "outputs": [],
   "source": [
    "raw_scores.columns = [\"game_id\", \"date\", \"player\", \"rank\", \"substitute_player\", \"winner\", \"score\", \"color\",\n",
    "                        \"num_of_cities\", \"num_of_settlement\", \"num_of_roads\", \"num_of_dev_cards\", \n",
    "                      \"buy_dev_card_first\", \"builds_city_first\", \"builds_settlement_first\", \"num_of_harbor\",\n",
    "                     \"which_resources_first\", \"cashier\", \"time_in_min\", \"is_extension\",\n",
    "                     \"start_time\", \"longest_road\", \"largest_army\", \"first_brick_harbor\",\n",
    "                     \"first_ore_harbor\", \"first_grain_harbor\", \"first_wool_harbor\", \"first_lumber_harbor\",\n",
    "                     \"first_3to1_harbor\", \"num_of_brick_harbor\", \"num_of_grain_harbor\", \"num_of_3to1_harbor\",\n",
    "                     \"num_of_lumber_harbor\", \"num_of_ore_harbor\", \"num_of_wool_harbor\", \"initial_dices\",\"dessert_placement\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "60b23249",
   "metadata": {},
   "outputs": [],
   "source": [
    "raw_scores[\"player\"].replace({\"Batuhan\": \"B\",\n",
    "                             \"Alperen\": \"A\",\n",
    "                             \"Feyza\": \"F\",\n",
    "                             \"Ecem\": \"E\",\n",
    "                             \"Canberk\": \"Ck\",\n",
    "                             \"Volkan\": \"V\",\n",
    "                             \"Çağatay\": \"Cc\",\n",
    "                             \"Melis\": \"M\",\n",
    "                             \"İzel\": \"I\",\n",
    "                             \"Aysima\": \"Ak\"}, inplace=True)\n",
    "\n",
    "raw_scores[\"substitute_player\"].replace({\"Batuhan\": \"B\",\n",
    "                             \"Alperen\": \"A\",\n",
    "                             \"Feyza\": \"F\",\n",
    "                             \"Ecem\": \"E\",\n",
    "                             \"Canberk\": \"Ck\",\n",
    "                             \"Volkan\": \"V\",\n",
    "                             \"Çağatay\": \"Cc\",\n",
    "                             \"Melis\": \"M\",\n",
    "                             \"İzel\": \"I\",\n",
    "                            \"Aysima\": \"Ak\"}, inplace=True)\n",
    "\n",
    "raw_scores[\"winner\"].replace({\"Batuhan\": \"B\",\n",
    "                             \"Alperen\": \"A\",\n",
    "                             \"Feyza\": \"F\",\n",
    "                             \"Ecem\": \"E\",\n",
    "                             \"Canberk\": \"Ck\",\n",
    "                             \"Volkan\": \"V\",\n",
    "                             \"Çağatay\": \"Cc\",\n",
    "                             \"Melis\": \"M\",\n",
    "                             \"İzel\": \"I\",\n",
    "                             \"Aysima\": \"Ak\"}, inplace=True)\n",
    "\n",
    "\n",
    "raw_scores[\"color\"].replace({\"Mavi\": \"Blue\",\n",
    "                             \"Kırmızı\": \"Red\",\n",
    "                             \"Yeşil\": \"Green\",\n",
    "                             \"Kahverengi\": \"Brown\",\n",
    "                             \"Beyaz\": \"White\",\n",
    "                             \"Turuncu\": \"Orange\"}, inplace=True)\n",
    "\n",
    "\n",
    "\n",
    "raw_scores[\"dessert_placement\"].replace({\"Dış Çember\": \"Outer Circle\",\n",
    "                             \"Orta Çember\": \"Middle\",\n",
    "                             \"İç Çember\": \"Inner Circle\"\n",
    "                             }, inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "d123acbc",
   "metadata": {},
   "outputs": [],
   "source": [
    "d = {\"Tuğla\": \"Brick\",\n",
    "                                             \"Kaya\": \"Ore\",\n",
    "                                             \"Saman\": \"Grain\",\n",
    "                                             \"Odun\": \"Lumber\",\n",
    "                                             \"Koyun\": \"Wool\"}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "5b1eb3b0",
   "metadata": {},
   "outputs": [],
   "source": [
    "full = []\n",
    "for i, row in raw_scores.iterrows():\n",
    "    temp = []\n",
    "    for j in row.which_resources_first.split(\",\"):\n",
    "        j = j.strip()\n",
    "        temp.append(d[j])\n",
    "    full.append(temp)\n",
    "raw_scores[\"which_resources_first\"] = full"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "68803451",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>game_id</th>\n",
       "      <th>date</th>\n",
       "      <th>player</th>\n",
       "      <th>rank</th>\n",
       "      <th>substitute_player</th>\n",
       "      <th>winner</th>\n",
       "      <th>score</th>\n",
       "      <th>color</th>\n",
       "      <th>num_of_cities</th>\n",
       "      <th>num_of_settlement</th>\n",
       "      <th>...</th>\n",
       "      <th>first_lumber_harbor</th>\n",
       "      <th>first_3to1_harbor</th>\n",
       "      <th>num_of_brick_harbor</th>\n",
       "      <th>num_of_grain_harbor</th>\n",
       "      <th>num_of_3to1_harbor</th>\n",
       "      <th>num_of_lumber_harbor</th>\n",
       "      <th>num_of_ore_harbor</th>\n",
       "      <th>num_of_wool_harbor</th>\n",
       "      <th>initial_dices</th>\n",
       "      <th>dessert_placement</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>2022-02-22</td>\n",
       "      <td>B</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Blue</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.0</td>\n",
       "      <td>2022-02-22</td>\n",
       "      <td>A</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A</td>\n",
       "      <td>10.0</td>\n",
       "      <td>White</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.0</td>\n",
       "      <td>2022-02-22</td>\n",
       "      <td>V</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Cc</td>\n",
       "      <td>A</td>\n",
       "      <td>8.0</td>\n",
       "      <td>Red</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.0</td>\n",
       "      <td>2022-02-22</td>\n",
       "      <td>M</td>\n",
       "      <td>3.0</td>\n",
       "      <td>E</td>\n",
       "      <td>A</td>\n",
       "      <td>7.0</td>\n",
       "      <td>Orange</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2.0</td>\n",
       "      <td>2022-03-06</td>\n",
       "      <td>A</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Cc</td>\n",
       "      <td>5.0</td>\n",
       "      <td>White</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>53.0</td>\n",
       "      <td>2022-10-12</td>\n",
       "      <td>A</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "      <td>8.0</td>\n",
       "      <td>White</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5, 8, 10, 4, 9, 11</td>\n",
       "      <td>Middle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>54.0</td>\n",
       "      <td>2022-11-12</td>\n",
       "      <td>V</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Blue</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5, 10, 6, 11, 4</td>\n",
       "      <td>Middle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>54.0</td>\n",
       "      <td>2022-11-12</td>\n",
       "      <td>E</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "      <td>9.0</td>\n",
       "      <td>Orange</td>\n",
       "      <td>1.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>5, 6, 11, 3, 8</td>\n",
       "      <td>Middle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>54.0</td>\n",
       "      <td>2022-11-12</td>\n",
       "      <td>B</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Red</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5, 9, 10, 4, 9, 11</td>\n",
       "      <td>Middle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>54.0</td>\n",
       "      <td>2022-11-12</td>\n",
       "      <td>A</td>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>B</td>\n",
       "      <td>9.0</td>\n",
       "      <td>White</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3, 8, 10, 3, 4, 19</td>\n",
       "      <td>Middle</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>226 rows × 37 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     game_id       date player  rank substitute_player winner  score   color  \\\n",
       "0        1.0 2022-02-22      B   1.0               NaN      A    7.0    Blue   \n",
       "1        1.0 2022-02-22      A   2.0               NaN      A   10.0   White   \n",
       "2        1.0 2022-02-22      V   4.0                Cc      A    8.0     Red   \n",
       "3        1.0 2022-02-22      M   3.0                 E      A    7.0  Orange   \n",
       "4        2.0 2022-03-06      A   2.0               NaN     Cc    5.0   White   \n",
       "..       ...        ...    ...   ...               ...    ...    ...     ...   \n",
       "221     53.0 2022-10-12      A   4.0               NaN      B    8.0   White   \n",
       "222     54.0 2022-11-12      V   1.0               NaN      B    9.0    Blue   \n",
       "223     54.0 2022-11-12      E   2.0               NaN      B    9.0  Orange   \n",
       "224     54.0 2022-11-12      B   3.0               NaN      B   10.0     Red   \n",
       "225     54.0 2022-11-12      A   4.0               NaN      B    9.0   White   \n",
       "\n",
       "     num_of_cities  num_of_settlement  ...  first_lumber_harbor  \\\n",
       "0              2.0                2.0  ...                  NaN   \n",
       "1              5.0                0.0  ...                  NaN   \n",
       "2              2.0                3.0  ...                  NaN   \n",
       "3              2.0                1.0  ...                  NaN   \n",
       "4              2.0                1.0  ...                  NaN   \n",
       "..             ...                ...  ...                  ...   \n",
       "221            4.0                0.0  ...                  0.0   \n",
       "222            3.0                1.0  ...                  1.0   \n",
       "223            1.0                4.0  ...                  0.0   \n",
       "224            4.0                1.0  ...                  0.0   \n",
       "225            3.0                1.0  ...                  0.0   \n",
       "\n",
       "     first_3to1_harbor  num_of_brick_harbor  num_of_grain_harbor  \\\n",
       "0                  NaN                  NaN                  NaN   \n",
       "1                  NaN                  NaN                  NaN   \n",
       "2                  NaN                  NaN                  NaN   \n",
       "3                  NaN                  NaN                  NaN   \n",
       "4                  NaN                  NaN                  NaN   \n",
       "..                 ...                  ...                  ...   \n",
       "221                0.0                  0.0                  0.0   \n",
       "222                0.0                  0.0                  0.0   \n",
       "223                1.0                  0.0                  0.0   \n",
       "224                0.0                  0.0                  0.0   \n",
       "225                0.0                  0.0                  0.0   \n",
       "\n",
       "     num_of_3to1_harbor  num_of_lumber_harbor num_of_ore_harbor  \\\n",
       "0                   NaN                   NaN               NaN   \n",
       "1                   NaN                   NaN               NaN   \n",
       "2                   NaN                   NaN               NaN   \n",
       "3                   NaN                   NaN               NaN   \n",
       "4                   NaN                   NaN               NaN   \n",
       "..                  ...                   ...               ...   \n",
       "221                 2.0                   0.0               0.0   \n",
       "222                 0.0                   1.0               1.0   \n",
       "223                 2.0                   0.0               0.0   \n",
       "224                 1.0                   0.0               0.0   \n",
       "225                 0.0                   0.0               0.0   \n",
       "\n",
       "     num_of_wool_harbor       initial_dices  dessert_placement  \n",
       "0                   NaN                 NaN                NaN  \n",
       "1                   NaN                 NaN                NaN  \n",
       "2                   NaN                 NaN                NaN  \n",
       "3                   NaN                 NaN                NaN  \n",
       "4                   NaN                 NaN                NaN  \n",
       "..                  ...                 ...                ...  \n",
       "221                 0.0  5, 8, 10, 4, 9, 11             Middle  \n",
       "222                 0.0     5, 10, 6, 11, 4             Middle  \n",
       "223                 1.0      5, 6, 11, 3, 8             Middle  \n",
       "224                 0.0  5, 9, 10, 4, 9, 11             Middle  \n",
       "225                 0.0  3, 8, 10, 3, 4, 19             Middle  \n",
       "\n",
       "[226 rows x 37 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "raw_scores"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "c72bade4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([nan, 'Cc', 'E', 'F'], dtype=object)"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "raw_scores[\"substitute_player\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "efa9daa8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Blue' 'White' 'Red' 'Orange' 'Green' 'Brown']\n",
      "['B' 'A' 'V' 'M' 'F' 'Cc' 'E' 'Ck' 'Ak' 'I']\n",
      "['B' 'A' 'V' 'M' 'F' 'Cc' 'E' 'Ck' 'Ak' 'I']\n",
      "[nan 'Outer Circle' 'Middle']\n"
     ]
    }
   ],
   "source": [
    "print(raw_scores[\"color\"].unique())\n",
    "print(raw_scores[\"player\"].unique())\n",
    "print(raw_scores[\"player\"].unique())\n",
    "print(raw_scores[\"dessert_placement\"].unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "58708c01",
   "metadata": {},
   "outputs": [],
   "source": [
    "raw_scores.to_csv(\"./catan_scores.csv\", index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "02ed9ae0",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}