coffee_tuning_2021_04.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "coffee tuning 2021/04",
      "provenance": [],
      "collapsed_sections": [],
      "authorship_tag": "ABX9TyO0w68xkTnyP2qmJNMvNXoV",
      "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/shu65/coffee-tuning/blob/2021-04/coffee_tuning_2021_04.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "OytZXcmIWjyv",
        "outputId": "d1835d84-92fa-41df-bde6-ae4683e9d293"
      },
      "source": [
        "!pip install optuna gspread pandas"
      ],
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "Requirement already satisfied: optuna in /usr/local/lib/python3.7/dist-packages (2.6.0)\n",
            "Requirement already satisfied: gspread in /usr/local/lib/python3.7/dist-packages (3.0.1)\n",
            "Requirement already satisfied: pandas in /usr/local/lib/python3.7/dist-packages (1.1.5)\n",
            "Requirement already satisfied: packaging>=20.0 in /usr/local/lib/python3.7/dist-packages (from optuna) (20.9)\n",
            "Requirement already satisfied: cliff in /usr/local/lib/python3.7/dist-packages (from optuna) (3.7.0)\n",
            "Requirement already satisfied: scipy!=1.4.0 in /usr/local/lib/python3.7/dist-packages (from optuna) (1.4.1)\n",
            "Requirement already satisfied: colorlog in /usr/local/lib/python3.7/dist-packages (from optuna) (4.8.0)\n",
            "Requirement already satisfied: tqdm in /usr/local/lib/python3.7/dist-packages (from optuna) (4.41.1)\n",
            "Requirement already satisfied: cmaes>=0.8.2 in /usr/local/lib/python3.7/dist-packages (from optuna) (0.8.2)\n",
            "Requirement already satisfied: alembic in /usr/local/lib/python3.7/dist-packages (from optuna) (1.5.8)\n",
            "Requirement already satisfied: numpy<1.20.0 in /usr/local/lib/python3.7/dist-packages (from optuna) (1.19.5)\n",
            "Requirement already satisfied: sqlalchemy>=1.1.0 in /usr/local/lib/python3.7/dist-packages (from optuna) (1.4.3)\n",
            "Requirement already satisfied: requests>=2.2.1 in /usr/local/lib/python3.7/dist-packages (from gspread) (2.23.0)\n",
            "Requirement already satisfied: pytz>=2017.2 in /usr/local/lib/python3.7/dist-packages (from pandas) (2018.9)\n",
            "Requirement already satisfied: python-dateutil>=2.7.3 in /usr/local/lib/python3.7/dist-packages (from pandas) (2.8.1)\n",
            "Requirement already satisfied: pyparsing>=2.0.2 in /usr/local/lib/python3.7/dist-packages (from packaging>=20.0->optuna) (2.4.7)\n",
            "Requirement already satisfied: cmd2>=1.0.0 in /usr/local/lib/python3.7/dist-packages (from cliff->optuna) (1.5.0)\n",
            "Requirement already satisfied: pbr!=2.1.0,>=2.0.0 in /usr/local/lib/python3.7/dist-packages (from cliff->optuna) (5.5.1)\n",
            "Requirement already satisfied: PyYAML>=3.12 in /usr/local/lib/python3.7/dist-packages (from cliff->optuna) (3.13)\n",
            "Requirement already satisfied: PrettyTable>=0.7.2 in /usr/local/lib/python3.7/dist-packages (from cliff->optuna) (2.1.0)\n",
            "Requirement already satisfied: stevedore>=2.0.1 in /usr/local/lib/python3.7/dist-packages (from cliff->optuna) (3.3.0)\n",
            "Requirement already satisfied: python-editor>=0.3 in /usr/local/lib/python3.7/dist-packages (from alembic->optuna) (1.0.4)\n",
            "Requirement already satisfied: Mako in /usr/local/lib/python3.7/dist-packages (from alembic->optuna) (1.1.4)\n",
            "Requirement already satisfied: greenlet!=0.4.17; python_version >= \"3\" in /usr/local/lib/python3.7/dist-packages (from sqlalchemy>=1.1.0->optuna) (1.0.0)\n",
            "Requirement already satisfied: importlib-metadata; python_version < \"3.8\" in /usr/local/lib/python3.7/dist-packages (from sqlalchemy>=1.1.0->optuna) (3.8.1)\n",
            "Requirement already satisfied: idna<3,>=2.5 in /usr/local/lib/python3.7/dist-packages (from requests>=2.2.1->gspread) (2.10)\n",
            "Requirement already satisfied: urllib3!=1.25.0,!=1.25.1,<1.26,>=1.21.1 in /usr/local/lib/python3.7/dist-packages (from requests>=2.2.1->gspread) (1.24.3)\n",
            "Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.7/dist-packages (from requests>=2.2.1->gspread) (2020.12.5)\n",
            "Requirement already satisfied: chardet<4,>=3.0.2 in /usr/local/lib/python3.7/dist-packages (from requests>=2.2.1->gspread) (3.0.4)\n",
            "Requirement already satisfied: six>=1.5 in /usr/local/lib/python3.7/dist-packages (from python-dateutil>=2.7.3->pandas) (1.15.0)\n",
            "Requirement already satisfied: attrs>=16.3.0 in /usr/local/lib/python3.7/dist-packages (from cmd2>=1.0.0->cliff->optuna) (20.3.0)\n",
            "Requirement already satisfied: colorama>=0.3.7 in /usr/local/lib/python3.7/dist-packages (from cmd2>=1.0.0->cliff->optuna) (0.4.4)\n",
            "Requirement already satisfied: wcwidth>=0.1.7 in /usr/local/lib/python3.7/dist-packages (from cmd2>=1.0.0->cliff->optuna) (0.2.5)\n",
            "Requirement already satisfied: pyperclip>=1.6 in /usr/local/lib/python3.7/dist-packages (from cmd2>=1.0.0->cliff->optuna) (1.8.2)\n",
            "Requirement already satisfied: MarkupSafe>=0.9.2 in /usr/local/lib/python3.7/dist-packages (from Mako->alembic->optuna) (1.1.1)\n",
            "Requirement already satisfied: zipp>=0.5 in /usr/local/lib/python3.7/dist-packages (from importlib-metadata; python_version < \"3.8\"->sqlalchemy>=1.1.0->optuna) (3.4.1)\n",
            "Requirement already satisfied: typing-extensions>=3.6.4; python_version < \"3.8\" in /usr/local/lib/python3.7/dist-packages (from importlib-metadata; python_version < \"3.8\"->sqlalchemy>=1.1.0->optuna) (3.7.4.3)\n"
          ],
          "name": "stdout"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ZLT5OcF_W2eB"
      },
      "source": [
        "# Google スプレッドシートの承認\n",
        "\n",
        "from google.colab import auth\n",
        "from oauth2client.client import GoogleCredentials\n",
        "import gspread\n",
        "\n",
        "auth.authenticate_user()\n",
        "gc = gspread.authorize(GoogleCredentials.get_application_default())"
      ],
      "execution_count": 9,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "H7oW-vovXoLp",
        "outputId": "e7f327f7-0d4b-4339-db2e-b1c77d4db70a"
      },
      "source": [
        "# スプレッドシートからデータを取ってくる\n",
        "import numpy as np\n",
        "import pandas as pd\n",
        "\n",
        "ss_name = \"mattari-benkyo-note coffee tuning 202104\"\n",
        "workbook = gc.open(ss_name)\n",
        "worksheet = workbook.get_worksheet(0)\n",
        "df = pd.DataFrame(worksheet.get_all_records())\n",
        "df[df == ''] = np.nan\n",
        "df['かき混ぜる'] = df['かき混ぜる'].astype(np.bool)\n",
        "df['蒸らし'] = df['蒸らし'].astype(np.bool)\n",
        "df = df.set_index('淹れた日')\n",
        "df"
      ],
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>豆</th>\n",
              "      <th>豆を買った日</th>\n",
              "      <th>保存期間</th>\n",
              "      <th>水の種類</th>\n",
              "      <th>抽出道具</th>\n",
              "      <th>保存方法</th>\n",
              "      <th>保存容器</th>\n",
              "      <th>豆の量 (g)/お湯の量(g)</th>\n",
              "      <th>お湯の量 (g)</th>\n",
              "      <th>お湯の温度(℃)</th>\n",
              "      <th>豆の量(g)</th>\n",
              "      <th>ミルのクリック数</th>\n",
              "      <th>抽出時間 (sec)</th>\n",
              "      <th>かき混ぜる</th>\n",
              "      <th>蒸らし</th>\n",
              "      <th>蒸らし時間 (sec)</th>\n",
              "      <th>スコア</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>淹れた日</th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "      <th></th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2021/3/22</th>\n",
              "      <td>マンデリン</td>\n",
              "      <td>2021/3/11</td>\n",
              "      <td>11</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.042328</td>\n",
              "      <td>189</td>\n",
              "      <td>87</td>\n",
              "      <td>8</td>\n",
              "      <td>12</td>\n",
              "      <td>191</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/3/21</th>\n",
              "      <td>マンデリン</td>\n",
              "      <td>2021/3/11</td>\n",
              "      <td>10</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.044554</td>\n",
              "      <td>202</td>\n",
              "      <td>85</td>\n",
              "      <td>9</td>\n",
              "      <td>16</td>\n",
              "      <td>190</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>40</td>\n",
              "      <td>7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/3/20</th>\n",
              "      <td>マンデリン</td>\n",
              "      <td>2021/3/11</td>\n",
              "      <td>9</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.040201</td>\n",
              "      <td>199</td>\n",
              "      <td>89</td>\n",
              "      <td>8</td>\n",
              "      <td>7</td>\n",
              "      <td>254</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/3/17</th>\n",
              "      <td>マンデリン</td>\n",
              "      <td>2021/3/11</td>\n",
              "      <td>6</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.053659</td>\n",
              "      <td>205</td>\n",
              "      <td>86</td>\n",
              "      <td>11</td>\n",
              "      <td>20</td>\n",
              "      <td>184</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>37</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/3/16</th>\n",
              "      <td>マンデリン</td>\n",
              "      <td>2021/3/11</td>\n",
              "      <td>5</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.043902</td>\n",
              "      <td>205</td>\n",
              "      <td>95</td>\n",
              "      <td>9</td>\n",
              "      <td>23</td>\n",
              "      <td>244</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>22</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/3/14</th>\n",
              "      <td>マンデリン</td>\n",
              "      <td>2021/3/11</td>\n",
              "      <td>3</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.058537</td>\n",
              "      <td>205</td>\n",
              "      <td>91</td>\n",
              "      <td>12</td>\n",
              "      <td>20</td>\n",
              "      <td>300</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>23</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/3/13</th>\n",
              "      <td>マンデリン</td>\n",
              "      <td>2021/3/11</td>\n",
              "      <td>2</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.047619</td>\n",
              "      <td>210</td>\n",
              "      <td>96</td>\n",
              "      <td>10</td>\n",
              "      <td>16</td>\n",
              "      <td>240</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/3/2</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/19</td>\n",
              "      <td>11</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.058537</td>\n",
              "      <td>205</td>\n",
              "      <td>99</td>\n",
              "      <td>12</td>\n",
              "      <td>23</td>\n",
              "      <td>225</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>35</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/3/1</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/19</td>\n",
              "      <td>10</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.075377</td>\n",
              "      <td>199</td>\n",
              "      <td>99</td>\n",
              "      <td>15</td>\n",
              "      <td>18</td>\n",
              "      <td>220</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>31</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/27</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/19</td>\n",
              "      <td>8</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.073529</td>\n",
              "      <td>204</td>\n",
              "      <td>99</td>\n",
              "      <td>15</td>\n",
              "      <td>26</td>\n",
              "      <td>257</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>36</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/26</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/19</td>\n",
              "      <td>7</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.072464</td>\n",
              "      <td>207</td>\n",
              "      <td>86</td>\n",
              "      <td>15</td>\n",
              "      <td>21</td>\n",
              "      <td>262</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>26</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/25</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/19</td>\n",
              "      <td>6</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.039024</td>\n",
              "      <td>205</td>\n",
              "      <td>99</td>\n",
              "      <td>8</td>\n",
              "      <td>18</td>\n",
              "      <td>291</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>31</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/24</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/19</td>\n",
              "      <td>5</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.038278</td>\n",
              "      <td>209</td>\n",
              "      <td>97</td>\n",
              "      <td>8</td>\n",
              "      <td>16</td>\n",
              "      <td>295</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>31</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/18</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/14</td>\n",
              "      <td>4</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.065327</td>\n",
              "      <td>199</td>\n",
              "      <td>96</td>\n",
              "      <td>13</td>\n",
              "      <td>16</td>\n",
              "      <td>259</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>40</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/18</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/14</td>\n",
              "      <td>4</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.064039</td>\n",
              "      <td>203</td>\n",
              "      <td>97</td>\n",
              "      <td>13</td>\n",
              "      <td>19</td>\n",
              "      <td>280</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>26</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/18</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/14</td>\n",
              "      <td>4</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.069307</td>\n",
              "      <td>202</td>\n",
              "      <td>92</td>\n",
              "      <td>14</td>\n",
              "      <td>13</td>\n",
              "      <td>250</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>21</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/17</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/14</td>\n",
              "      <td>3</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.067633</td>\n",
              "      <td>207</td>\n",
              "      <td>96</td>\n",
              "      <td>14</td>\n",
              "      <td>19</td>\n",
              "      <td>252</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>31</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/17</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/14</td>\n",
              "      <td>3</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.049505</td>\n",
              "      <td>202</td>\n",
              "      <td>98</td>\n",
              "      <td>10</td>\n",
              "      <td>5</td>\n",
              "      <td>300</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>35</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/16</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/14</td>\n",
              "      <td>2</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.073171</td>\n",
              "      <td>205</td>\n",
              "      <td>99</td>\n",
              "      <td>15</td>\n",
              "      <td>18</td>\n",
              "      <td>239</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/16</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/14</td>\n",
              "      <td>2</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.029703</td>\n",
              "      <td>202</td>\n",
              "      <td>96</td>\n",
              "      <td>6</td>\n",
              "      <td>21</td>\n",
              "      <td>281</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/15</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/14</td>\n",
              "      <td>1</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.042254</td>\n",
              "      <td>213</td>\n",
              "      <td>98</td>\n",
              "      <td>9</td>\n",
              "      <td>17</td>\n",
              "      <td>296</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/11</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/3</td>\n",
              "      <td>8</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.044248</td>\n",
              "      <td>226</td>\n",
              "      <td>99</td>\n",
              "      <td>10</td>\n",
              "      <td>22</td>\n",
              "      <td>229</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>40</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/11</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/3</td>\n",
              "      <td>8</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.049020</td>\n",
              "      <td>204</td>\n",
              "      <td>88</td>\n",
              "      <td>10</td>\n",
              "      <td>11</td>\n",
              "      <td>281</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/9</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/3</td>\n",
              "      <td>6</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.033333</td>\n",
              "      <td>240</td>\n",
              "      <td>93</td>\n",
              "      <td>8</td>\n",
              "      <td>10</td>\n",
              "      <td>248</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>20</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/9</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/3</td>\n",
              "      <td>6</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.049793</td>\n",
              "      <td>241</td>\n",
              "      <td>95</td>\n",
              "      <td>12</td>\n",
              "      <td>15</td>\n",
              "      <td>265</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>21</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/8</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/3</td>\n",
              "      <td>5</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.044643</td>\n",
              "      <td>224</td>\n",
              "      <td>84</td>\n",
              "      <td>10</td>\n",
              "      <td>20</td>\n",
              "      <td>295</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/6</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/3</td>\n",
              "      <td>3</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.032000</td>\n",
              "      <td>250</td>\n",
              "      <td>82</td>\n",
              "      <td>8</td>\n",
              "      <td>19</td>\n",
              "      <td>193</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>35</td>\n",
              "      <td>2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/5</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/3</td>\n",
              "      <td>2</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.051724</td>\n",
              "      <td>232</td>\n",
              "      <td>83</td>\n",
              "      <td>12</td>\n",
              "      <td>23</td>\n",
              "      <td>257</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/4</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/3</td>\n",
              "      <td>1</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.070000</td>\n",
              "      <td>200</td>\n",
              "      <td>80</td>\n",
              "      <td>14</td>\n",
              "      <td>14</td>\n",
              "      <td>290</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/3</th>\n",
              "      <td>コスタリカ</td>\n",
              "      <td>2021/2/3</td>\n",
              "      <td>0</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷蔵</td>\n",
              "      <td>ジップロック</td>\n",
              "      <td>0.047619</td>\n",
              "      <td>231</td>\n",
              "      <td>93</td>\n",
              "      <td>11</td>\n",
              "      <td>13</td>\n",
              "      <td>280</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/2/2</th>\n",
              "      <td>エルサルバドル</td>\n",
              "      <td>2021/1/25</td>\n",
              "      <td>8</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.072727</td>\n",
              "      <td>165</td>\n",
              "      <td>90</td>\n",
              "      <td>12</td>\n",
              "      <td>19</td>\n",
              "      <td>233</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>26</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/1/31</th>\n",
              "      <td>エルサルバドル</td>\n",
              "      <td>2021/1/25</td>\n",
              "      <td>6</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷蔵</td>\n",
              "      <td>ジップロック</td>\n",
              "      <td>0.070064</td>\n",
              "      <td>157</td>\n",
              "      <td>80</td>\n",
              "      <td>11</td>\n",
              "      <td>5</td>\n",
              "      <td>224</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>34</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/1/30</th>\n",
              "      <td>エルサルバドル</td>\n",
              "      <td>2021/1/25</td>\n",
              "      <td>5</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.033898</td>\n",
              "      <td>236</td>\n",
              "      <td>93</td>\n",
              "      <td>8</td>\n",
              "      <td>17</td>\n",
              "      <td>300</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>29</td>\n",
              "      <td>4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/1/29</th>\n",
              "      <td>エルサルバドル</td>\n",
              "      <td>2021/1/25</td>\n",
              "      <td>4</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷蔵</td>\n",
              "      <td>ジップロック</td>\n",
              "      <td>0.066265</td>\n",
              "      <td>166</td>\n",
              "      <td>88</td>\n",
              "      <td>11</td>\n",
              "      <td>23</td>\n",
              "      <td>223</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/1/28</th>\n",
              "      <td>エルサルバドル</td>\n",
              "      <td>2021/1/25</td>\n",
              "      <td>3</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.073034</td>\n",
              "      <td>178</td>\n",
              "      <td>88</td>\n",
              "      <td>13</td>\n",
              "      <td>24</td>\n",
              "      <td>298</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>39</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/1/27</th>\n",
              "      <td>エルサルバドル</td>\n",
              "      <td>2021/1/25</td>\n",
              "      <td>2</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷蔵</td>\n",
              "      <td>ジップロック</td>\n",
              "      <td>0.044554</td>\n",
              "      <td>202</td>\n",
              "      <td>96</td>\n",
              "      <td>9</td>\n",
              "      <td>4</td>\n",
              "      <td>283</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>21</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/1/26</th>\n",
              "      <td>エルサルバドル</td>\n",
              "      <td>2021/1/25</td>\n",
              "      <td>1</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷蔵</td>\n",
              "      <td>ジップロック</td>\n",
              "      <td>0.062500</td>\n",
              "      <td>160</td>\n",
              "      <td>94</td>\n",
              "      <td>10</td>\n",
              "      <td>24</td>\n",
              "      <td>245</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>22</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/1/25</th>\n",
              "      <td>エルサルバドル</td>\n",
              "      <td>2021/1/25</td>\n",
              "      <td>0</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷蔵</td>\n",
              "      <td>ジップロック</td>\n",
              "      <td>0.050000</td>\n",
              "      <td>200</td>\n",
              "      <td>92</td>\n",
              "      <td>10</td>\n",
              "      <td>14</td>\n",
              "      <td>240</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>NaN</td>\n",
              "      <td>5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/1/24</th>\n",
              "      <td>グアテマラ</td>\n",
              "      <td>2021/1/14</td>\n",
              "      <td>10</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷蔵</td>\n",
              "      <td>ジップロック</td>\n",
              "      <td>0.066667</td>\n",
              "      <td>150</td>\n",
              "      <td>94</td>\n",
              "      <td>10</td>\n",
              "      <td>18</td>\n",
              "      <td>254</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>27</td>\n",
              "      <td>7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/1/24</th>\n",
              "      <td>グアテマラ</td>\n",
              "      <td>2021/1/14</td>\n",
              "      <td>10</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷凍</td>\n",
              "      <td>キャニスター</td>\n",
              "      <td>0.066667</td>\n",
              "      <td>150</td>\n",
              "      <td>94</td>\n",
              "      <td>10</td>\n",
              "      <td>18</td>\n",
              "      <td>254</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>27</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2021/1/23</th>\n",
              "      <td>グアテマラ</td>\n",
              "      <td>2021/1/14</td>\n",
              "      <td>9</td>\n",
              "      <td>サントリーの天然水</td>\n",
              "      <td>BODUM  CHAMBORD 350 ml</td>\n",
              "      <td>冷蔵</td>\n",
              "      <td>ジップロック</td>\n",
              "      <td>0.053476</td>\n",
              "      <td>187</td>\n",
              "      <td>90</td>\n",
              "      <td>10</td>\n",
              "      <td>14</td>\n",
              "      <td>254</td>\n",
              "      <td>True</td>\n",
              "      <td>True</td>\n",
              "      <td>27</td>\n",
              "      <td>6</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                 豆     豆を買った日  保存期間       水の種類  ... かき混ぜる   蒸らし 蒸らし時間 (sec)  スコア\n",
              "淹れた日                                            ...                             \n",
              "2021/3/22    マンデリン  2021/3/11    11  サントリーの天然水  ...  True  True         NaN    7\n",
              "2021/3/21    マンデリン  2021/3/11    10  サントリーの天然水  ...  True  True          40    7\n",
              "2021/3/20    マンデリン  2021/3/11     9  サントリーの天然水  ...  True  True         NaN    6\n",
              "2021/3/17    マンデリン  2021/3/11     6  サントリーの天然水  ...  True  True          37    6\n",
              "2021/3/16    マンデリン  2021/3/11     5  サントリーの天然水  ...  True  True          22    5\n",
              "2021/3/14    マンデリン  2021/3/11     3  サントリーの天然水  ...  True  True          23    5\n",
              "2021/3/13    マンデリン  2021/3/11     2  サントリーの天然水  ...  True  True         NaN    4\n",
              "2021/3/2     コスタリカ  2021/2/19    11  サントリーの天然水  ...  True  True          35    5\n",
              "2021/3/1     コスタリカ  2021/2/19    10  サントリーの天然水  ...  True  True          31    4\n",
              "2021/2/27    コスタリカ  2021/2/19     8  サントリーの天然水  ...  True  True          36    5\n",
              "2021/2/26    コスタリカ  2021/2/19     7  サントリーの天然水  ...  True  True          26    4\n",
              "2021/2/25    コスタリカ  2021/2/19     6  サントリーの天然水  ...  True  True          31    5\n",
              "2021/2/24    コスタリカ  2021/2/19     5  サントリーの天然水  ...  True  True          31    5\n",
              "2021/2/18    コスタリカ  2021/2/14     4  サントリーの天然水  ...  True  True          40    4\n",
              "2021/2/18    コスタリカ  2021/2/14     4  サントリーの天然水  ...  True  True          26    5\n",
              "2021/2/18    コスタリカ  2021/2/14     4  サントリーの天然水  ...  True  True          21    5\n",
              "2021/2/17    コスタリカ  2021/2/14     3  サントリーの天然水  ...  True  True          31    6\n",
              "2021/2/17    コスタリカ  2021/2/14     3  サントリーの天然水  ...  True  True          35    4\n",
              "2021/2/16    コスタリカ  2021/2/14     2  サントリーの天然水  ...  True  True         NaN    5\n",
              "2021/2/16    コスタリカ  2021/2/14     2  サントリーの天然水  ...  True  True         NaN    2\n",
              "2021/2/15    コスタリカ  2021/2/14     1  サントリーの天然水  ...  True  True         NaN    5\n",
              "2021/2/11    コスタリカ   2021/2/3     8  サントリーの天然水  ...  True  True          40    3\n",
              "2021/2/11    コスタリカ   2021/2/3     8  サントリーの天然水  ...  True  True         NaN    3\n",
              "2021/2/9     コスタリカ   2021/2/3     6  サントリーの天然水  ...  True  True          20    2\n",
              "2021/2/9     コスタリカ   2021/2/3     6  サントリーの天然水  ...  True  True          21    4\n",
              "2021/2/8     コスタリカ   2021/2/3     5  サントリーの天然水  ...  True  True         NaN    4\n",
              "2021/2/6     コスタリカ   2021/2/3     3  サントリーの天然水  ...  True  True          35    2\n",
              "2021/2/5     コスタリカ   2021/2/3     2  サントリーの天然水  ...  True  True         NaN    4\n",
              "2021/2/4     コスタリカ   2021/2/3     1  サントリーの天然水  ...  True  True         NaN    3\n",
              "2021/2/3     コスタリカ   2021/2/3     0  サントリーの天然水  ...  True  True         NaN    4\n",
              "2021/2/2   エルサルバドル  2021/1/25     8  サントリーの天然水  ...  True  True          26    6\n",
              "2021/1/31  エルサルバドル  2021/1/25     6  サントリーの天然水  ...  True  True          34    5\n",
              "2021/1/30  エルサルバドル  2021/1/25     5  サントリーの天然水  ...  True  True          29    4\n",
              "2021/1/29  エルサルバドル  2021/1/25     4  サントリーの天然水  ...  True  True         NaN    7\n",
              "2021/1/28  エルサルバドル  2021/1/25     3  サントリーの天然水  ...  True  True          39    5\n",
              "2021/1/27  エルサルバドル  2021/1/25     2  サントリーの天然水  ...  True  True          21    5\n",
              "2021/1/26  エルサルバドル  2021/1/25     1  サントリーの天然水  ...  True  True          22    6\n",
              "2021/1/25  エルサルバドル  2021/1/25     0  サントリーの天然水  ...  True  True         NaN    5\n",
              "2021/1/24    グアテマラ  2021/1/14    10  サントリーの天然水  ...  True  True          27    7\n",
              "2021/1/24    グアテマラ  2021/1/14    10  サントリーの天然水  ...  True  True          27    6\n",
              "2021/1/23    グアテマラ  2021/1/14     9  サントリーの天然水  ...  True  True          27    6\n",
              "\n",
              "[41 rows x 17 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "LEOfUjtSYBf_"
      },
      "source": [
        "import optuna\n",
        "\n",
        "study_search_space={\n",
        "    \"豆の量 (g)/お湯の量(g)\": optuna.distributions.UniformDistribution(0.025, 0.08),\n",
        "    \"ミルのクリック数\": optuna.distributions.IntUniformDistribution(4, 26),\n",
        "    \"抽出時間 (sec)\": optuna.distributions.IntUniformDistribution(180, 300),\n",
        "    \"かき混ぜる\": optuna.distributions.CategoricalDistribution([True, False]),\n",
        "    \"蒸らし\": optuna.distributions.CategoricalDistribution([True, False]),\n",
        "    \"蒸らし時間 (sec)\": optuna.distributions.IntUniformDistribution(20, 40),\n",
        "    \"保存方法\": optuna.distributions.CategoricalDistribution([\"冷凍\", \"冷蔵\"]),\n",
        "    \"お湯の温度(℃)\": optuna.distributions.IntUniformDistribution(80, 99),\n",
        "    }\n",
        "score_column = 'スコア'"
      ],
      "execution_count": 13,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "XO1Hl1pUYHuL",
        "outputId": "807ee413-7f2e-4853-ac1e-37fc8f5ac114"
      },
      "source": [
        "import optuna\n",
        "\n",
        "sampler = optuna.samplers.TPESampler(multivariate=True, n_startup_trials=10)\n",
        "study = optuna.create_study(direction='maximize', sampler=sampler)\n",
        "\n",
        "for record_i, record in df.iloc[::-1].iterrows():\n",
        "  is_record_null = record.isnull()\n",
        "  params = {}\n",
        "  trial_search_space = {}\n",
        "  for key in study_search_space.keys():\n",
        "    if not is_record_null[key]:\n",
        "      params[key] = record[key]\n",
        "      trial_search_space[key] = study_search_space[key]\n",
        "  if  not is_record_null[score_column]:\n",
        "    try:\n",
        "      trial = optuna.trial.create_trial(\n",
        "        params=params,\n",
        "        distributions=trial_search_space,\n",
        "        value=record[score_column])\n",
        "      study.add_trial(trial)\n",
        "    except ValueError as e:\n",
        "      print(\"pass trial:\", trial)\n",
        "      print(e)\n",
        "\n",
        "print(\"sample size:\", len(df))"
      ],
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.7/dist-packages/optuna/samplers/_tpe/sampler.py:192: ExperimentalWarning:\n",
            "\n",
            "``multivariate`` option is an experimental feature. The interface can change in the future.\n",
            "\n",
            "\u001b[32m[I 2021-03-31 13:04:27,515]\u001b[0m A new study created in memory with name: no-name-63629c39-6d30-4ae7-bb32-85e8fa6863d2\u001b[0m\n"
          ],
          "name": "stderr"
        },
        {
          "output_type": "stream",
          "text": [
            "sample size: 41\n"
          ],
          "name": "stdout"
        },
        {
          "output_type": "stream",
          "text": [
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:19: ExperimentalWarning:\n",
            "\n",
            "create_trial is experimental (supported from v2.0.0). The interface can change in the future.\n",
            "\n",
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:20: ExperimentalWarning:\n",
            "\n",
            "add_trial is experimental (supported from v2.0.0). The interface can change in the future.\n",
            "\n"
          ],
          "name": "stderr"
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "zgm1zc7cYs--",
        "outputId": "71c5ce51-5618-4ebb-8bf1-c9fd18a6994a"
      },
      "source": [
        "# 次のパラメータの出力\n",
        "trial = study.ask()\n",
        "\n",
        "new_params = {}\n",
        "new_params[\"蒸らし\"] = trial.suggest_categorical(\"蒸らし\", [True, False])\n",
        "if new_params['蒸らし']:\n",
        "  new_params[\"蒸らし時間 (sec)\"] = trial.suggest_int(\"蒸らし時間 (sec)\", 20, 40)\n",
        "\n",
        "new_params[\"豆の量 (g)/お湯の量(g)\"] = trial.suggest_uniform(\"豆の量 (g)/お湯の量(g)\", 0.038, 0.08)\n",
        "new_params[\"ミルのクリック数\"] = trial.suggest_int(\"ミルのクリック数\", 4, 24)\n",
        "new_params[\"抽出時間 (sec)\"] = trial.suggest_int(\"抽出時間 (sec)\", 180, 300)\n",
        "new_params[\"かき混ぜる\"] = trial.suggest_categorical(\"かき混ぜる\",  [True, False])\n",
        "new_params[\"お湯の温度(℃)\"] = trial.suggest_int(\"お湯の温度(℃)\",  80, 99)\n",
        "\n",
        "# わかりやすい順番で表示\n",
        "water=200\n",
        "for key in  [\"お湯の温度(℃)\", \"豆の量 (g)/お湯の量(g)\", \"豆の量(g)\", \"ミルのクリック数\", \"かき混ぜる\", \"蒸らし\", \"蒸らし時間 (sec)\",\"抽出時間 (sec)\"]:\n",
        "  if key in new_params:\n",
        "    if key == \"豆の量 (g)/お湯の量(g)\":\n",
        "      beans = int(water * new_params[key])\n",
        "      print(key, new_params[key], beans / water)\n",
        "      print(\"豆の量 (g)\", beans)\n",
        "    else:\n",
        "      print(key, new_params[key])"
      ],
      "execution_count": 23,
      "outputs": [
        {
          "output_type": "stream",
          "text": [
            "お湯の温度(℃) 88\n",
            "豆の量 (g)/お湯の量(g) 0.05400951154389384 0.05\n",
            "豆の量 (g) 10\n",
            "ミルのクリック数 9\n",
            "かき混ぜる True\n",
            "蒸らし True\n",
            "蒸らし時間 (sec) 24\n",
            "抽出時間 (sec) 205\n"
          ],
          "name": "stdout"
        }
      ]
    }
  ]
}