Промежуточная_аттестация_по_модулю_1.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "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/Sinrez/PythonProjects/blob/main/%D0%9F%D1%80%D0%BE%D0%BC%D0%B5%D0%B6%D1%83%D1%82%D0%BE%D1%87%D0%BD%D0%B0%D1%8F_%D0%B0%D1%82%D1%82%D0%B5%D1%81%D1%82%D0%B0%D1%86%D0%B8%D1%8F_%D0%BF%D0%BE_%D0%BC%D0%BE%D0%B4%D1%83%D0%BB%D1%8E_1.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "При выборе газонокосилки Юрий собрал следующие данные об аккумуляторных газонокосилках:\n",
        "\n",
        "Название газонокосилки — NAME\n",
        "Ширина скашиваемой полосы — WIDTH\n",
        "Стоимость — PRICE\n",
        "Мощность — POWER\n",
        "Объем травосборника — GRASS\n",
        "Площадь скашиваемой поверхности на одном заряде аккумулятора — AREA\n",
        "Описание газонокосилки — DESCRIPTION\n",
        "Не все оказалось идеально с данными. Некоторые значения оказались пропущены, некоторые явно содержали экстремальные выбросы. Юрию пришлось обработать исходные данные следующим образом:"
      ],
      "metadata": {
        "id": "tw8Sfmo8cJbZ"
      }
    },
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "id": "_lDrB6FwXsFm"
      },
      "outputs": [],
      "source": [
        "import numpy as np\n",
        "import pandas as pd\n",
        "import re\n",
        "\n",
        "df = pd.read_csv('/content/lawnmower_var_478063.csv', index_col='NAME')"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.head(20)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 708
        },
        "id": "0rrr-R085Bvt",
        "outputId": "3586c5ef-5aa4-4ef6-cf89-dba49f54e01b"
      },
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                 WIDTH    PRICE  POWER  GRASS   AREA  \\\n",
              "NAME                                                   \n",
              "Boch GEX523       43.0  31000.0   1.00   30.0  400.0   \n",
              "Champion CLX897   40.0  44000.0   1.00   50.0  550.0   \n",
              "Wolf QMK791       37.0  40000.0   1.90   60.0  450.0   \n",
              "Champion BHQ184   38.0  17000.0   0.85   70.0  600.0   \n",
              "Nakita MHC974     43.0  45000.0   1.25   60.0  300.0   \n",
              "Worx YGN356       43.0  44000.0    NaN   25.0  500.0   \n",
              "Nakita DNJ664     43.0  41000.0   1.10   45.0  550.0   \n",
              "Worx OFF459       35.0  20000.0   1.70   75.0  450.0   \n",
              "Gardez OGJ378     37.0  41000.0   1.55   60.0  550.0   \n",
              "Boch MVC515       35.0  37000.0   1.05   45.0  250.0   \n",
              "Champion KIE278   41.0  31000.0   1.85   60.0  300.0   \n",
              "Cooper PCP596     31.0  18000.0   1.25   40.0  200.0   \n",
              "Boch IHM978       36.0  28000.0   1.40    NaN  250.0   \n",
              "Gardez UIB467     30.0      NaN   1.80   55.0  500.0   \n",
              "Bear WLR116       33.0  16000.0   1.65   65.0  300.0   \n",
              "Worx PKP959       44.0  44000.0   1.10   45.0  200.0   \n",
              "Wolf IUP443       44.0  41000.0   0.90   55.0  200.0   \n",
              "Worx VWL881       43.0  17000.0   1.00   25.0  350.0   \n",
              "Nakita RDT953     43.0  37000.0   0.80   70.0  250.0   \n",
              "Cooper GUV727     44.0  36000.0   1.90   40.0  450.0   \n",
              "\n",
              "                                                       DESCRIPTION  \n",
              "NAME                                                                \n",
              "Boch GEX523      Широкая полоса скашивания на данной газонокоси...  \n",
              "Champion CLX897  Средняя ширина скашиваемой полосы на данной га...  \n",
              "Wolf QMK791      Средняя ширина скашиваемой полосы на данной га...  \n",
              "Champion BHQ184  Средняя ширина скашиваемой полосы на данной га...  \n",
              "Nakita MHC974    Широкая полоса скашивания на данной газонокоси...  \n",
              "Worx YGN356      Широкая полоса скашивания на данной газонокоси...  \n",
              "Nakita DNJ664    Широкая полоса скашивания на данной газонокоси...  \n",
              "Worx OFF459      Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Gardez OGJ378    Средняя ширина скашиваемой полосы на данной га...  \n",
              "Boch MVC515      Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Champion KIE278  Широкая полоса скашивания на данной газонокоси...  \n",
              "Cooper PCP596    Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Boch IHM978      Средняя ширина скашиваемой полосы на данной га...  \n",
              "Gardez UIB467    Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Bear WLR116      Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Worx PKP959      Широкая полоса скашивания на данной газонокоси...  \n",
              "Wolf IUP443      Широкая полоса скашивания на данной газонокоси...  \n",
              "Worx VWL881      Широкая полоса скашивания на данной газонокоси...  \n",
              "Nakita RDT953    Широкая полоса скашивания на данной газонокоси...  \n",
              "Cooper GUV727    Широкая полоса скашивания на данной газонокоси...  "
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-0ea3aeaf-548f-4832-9599-11e8dabe847d\">\n",
              "    <div 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>WIDTH</th>\n",
              "      <th>PRICE</th>\n",
              "      <th>POWER</th>\n",
              "      <th>GRASS</th>\n",
              "      <th>AREA</th>\n",
              "      <th>DESCRIPTION</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>NAME</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>Boch GEX523</th>\n",
              "      <td>43.0</td>\n",
              "      <td>31000.0</td>\n",
              "      <td>1.00</td>\n",
              "      <td>30.0</td>\n",
              "      <td>400.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Champion CLX897</th>\n",
              "      <td>40.0</td>\n",
              "      <td>44000.0</td>\n",
              "      <td>1.00</td>\n",
              "      <td>50.0</td>\n",
              "      <td>550.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Wolf QMK791</th>\n",
              "      <td>37.0</td>\n",
              "      <td>40000.0</td>\n",
              "      <td>1.90</td>\n",
              "      <td>60.0</td>\n",
              "      <td>450.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Champion BHQ184</th>\n",
              "      <td>38.0</td>\n",
              "      <td>17000.0</td>\n",
              "      <td>0.85</td>\n",
              "      <td>70.0</td>\n",
              "      <td>600.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Nakita MHC974</th>\n",
              "      <td>43.0</td>\n",
              "      <td>45000.0</td>\n",
              "      <td>1.25</td>\n",
              "      <td>60.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx YGN356</th>\n",
              "      <td>43.0</td>\n",
              "      <td>44000.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>25.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Nakita DNJ664</th>\n",
              "      <td>43.0</td>\n",
              "      <td>41000.0</td>\n",
              "      <td>1.10</td>\n",
              "      <td>45.0</td>\n",
              "      <td>550.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx OFF459</th>\n",
              "      <td>35.0</td>\n",
              "      <td>20000.0</td>\n",
              "      <td>1.70</td>\n",
              "      <td>75.0</td>\n",
              "      <td>450.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Gardez OGJ378</th>\n",
              "      <td>37.0</td>\n",
              "      <td>41000.0</td>\n",
              "      <td>1.55</td>\n",
              "      <td>60.0</td>\n",
              "      <td>550.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Boch MVC515</th>\n",
              "      <td>35.0</td>\n",
              "      <td>37000.0</td>\n",
              "      <td>1.05</td>\n",
              "      <td>45.0</td>\n",
              "      <td>250.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Champion KIE278</th>\n",
              "      <td>41.0</td>\n",
              "      <td>31000.0</td>\n",
              "      <td>1.85</td>\n",
              "      <td>60.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Cooper PCP596</th>\n",
              "      <td>31.0</td>\n",
              "      <td>18000.0</td>\n",
              "      <td>1.25</td>\n",
              "      <td>40.0</td>\n",
              "      <td>200.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Boch IHM978</th>\n",
              "      <td>36.0</td>\n",
              "      <td>28000.0</td>\n",
              "      <td>1.40</td>\n",
              "      <td>NaN</td>\n",
              "      <td>250.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Gardez UIB467</th>\n",
              "      <td>30.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.80</td>\n",
              "      <td>55.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Bear WLR116</th>\n",
              "      <td>33.0</td>\n",
              "      <td>16000.0</td>\n",
              "      <td>1.65</td>\n",
              "      <td>65.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx PKP959</th>\n",
              "      <td>44.0</td>\n",
              "      <td>44000.0</td>\n",
              "      <td>1.10</td>\n",
              "      <td>45.0</td>\n",
              "      <td>200.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Wolf IUP443</th>\n",
              "      <td>44.0</td>\n",
              "      <td>41000.0</td>\n",
              "      <td>0.90</td>\n",
              "      <td>55.0</td>\n",
              "      <td>200.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx VWL881</th>\n",
              "      <td>43.0</td>\n",
              "      <td>17000.0</td>\n",
              "      <td>1.00</td>\n",
              "      <td>25.0</td>\n",
              "      <td>350.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Nakita RDT953</th>\n",
              "      <td>43.0</td>\n",
              "      <td>37000.0</td>\n",
              "      <td>0.80</td>\n",
              "      <td>70.0</td>\n",
              "      <td>250.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Cooper GUV727</th>\n",
              "      <td>44.0</td>\n",
              "      <td>36000.0</td>\n",
              "      <td>1.90</td>\n",
              "      <td>40.0</td>\n",
              "      <td>450.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-0ea3aeaf-548f-4832-9599-11e8dabe847d')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-24399dcb-0cdf-4578-bc1c-8ab1fd06ba05\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-24399dcb-0cdf-4578-bc1c-8ab1fd06ba05')\"\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",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\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-quickchart: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",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart: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",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-24399dcb-0cdf-4578-bc1c-8ab1fd06ba05 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-0ea3aeaf-548f-4832-9599-11e8dabe847d 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-0ea3aeaf-548f-4832-9599-11e8dabe847d');\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",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 2
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Не все оказалось идеально с данными. Некоторые значения оказались пропущены, некоторые явно содержали экстремальные выбросы. Юрию пришлось обработать исходные данные следующим образом:\n",
        "\n",
        "Если в описании газонокосилки встречались слова \"узкая/узкие/узкую/узкой\", то значение восстанавливалось как медиана по существующим в исходном датасете значениям в диапазоне от 30 до 35.\n"
      ],
      "metadata": {
        "id": "oa6C6ARCYv9l"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "1. Параметр \"Ширина скашиваемой полосы\" содержал много пропущенных значений. Юрий придумал следующий алгоритм по их восстановлению:\n",
        "\n",
        "Если в описании газонокосилки встречались слова \"узкая/узкие/узкую/узкой\", то значение восстанавливалось как медиана по существующим в исходном датасете значениям в диапазоне от 30 до 35."
      ],
      "metadata": {
        "id": "ee-SzRra68S8"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "m_30_35 = df[(df[\"WIDTH\"] >= 30) & (df[\"WIDTH\"] <= 35)]['WIDTH'].median() #находим медиану\n",
        "m_30_35"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "rCQf7XlcdKRf",
        "outputId": "3fee923f-4c41-4b95-8252-6e794ea2006a"
      },
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "32.0"
            ]
          },
          "metadata": {},
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Если встречались слова \"средняя ширина\"/\"ширина средняя\", то значение восстанавливалось как округленное до целого среднее арифметическое по существующим значениям в диапазоне от 36 до 40.\n",
        "Введите округленное до целого среднее арифметическое по существующим в исходном датасете значениям в диапазоне от 36 до 40."
      ],
      "metadata": {
        "id": "12UCO8WI7ESo"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "m_36_40 = df[(df[\"WIDTH\"] >= 36) & (df[\"WIDTH\"] <= 40)]['WIDTH'].median() #находим ср. арифм.\n",
        "m_36_40"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Ja-X3ljZ7IM0",
        "outputId": "418e1beb-393b-49f0-85cf-fabb46b8919f"
      },
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "38.0"
            ]
          },
          "metadata": {},
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "round(m_36_40,2)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "QWMVJjXaXPYs",
        "outputId": "4daa68ca-1112-464f-8c88-9a15b5517d6b"
      },
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "38.0"
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Если встречались слова (\"широкая\" и \"полоса\")/(\"широкие\" и \"полосы\"), то значение восстанавливалось как медиана по существующим значениям в диапазоне от 41 до 45.\n",
        "Введите медиану по существующим в исходном датасете значениям в диапазоне от 41 до 45."
      ],
      "metadata": {
        "id": "MRCwVbFN7IY2"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "m_41_45 = df[(df[\"WIDTH\"] >= 41) & (df[\"WIDTH\"] <= 45)]['WIDTH'].median() #находим медиану\n",
        "m_41_45"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "177kLqW97Ii7",
        "outputId": "520d3380-6c60-4fcc-8792-d76b0533a0ec"
      },
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "43.0"
            ]
          },
          "metadata": {},
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Востановим пропущенные значения\n",
        "\n",
        "1 вариант"
      ],
      "metadata": {
        "id": "4WEGKYf06P9W"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df.loc[(df['DESCRIPTION'].str.contains(r'узкая|узкие|узкую|узкой', case=False)) & (df['WIDTH'].isnull()), 'WIDTH'] = m_30_35\n",
        "df.head(20)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 708
        },
        "id": "004tY8xUdkaK",
        "outputId": "9099a392-5c6a-4b67-8fe0-6cedc5cc4a2e"
      },
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                 WIDTH    PRICE  POWER  GRASS   AREA  \\\n",
              "NAME                                                   \n",
              "Boch GEX523       43.0  31000.0   1.00   30.0  400.0   \n",
              "Champion CLX897   40.0  44000.0   1.00   50.0  550.0   \n",
              "Wolf QMK791       37.0  40000.0   1.90   60.0  450.0   \n",
              "Champion BHQ184   38.0  17000.0   0.85   70.0  600.0   \n",
              "Nakita MHC974     43.0  45000.0   1.25   60.0  300.0   \n",
              "Worx YGN356       43.0  44000.0    NaN   25.0  500.0   \n",
              "Nakita DNJ664     43.0  41000.0   1.10   45.0  550.0   \n",
              "Worx OFF459       35.0  20000.0   1.70   75.0  450.0   \n",
              "Gardez OGJ378     37.0  41000.0   1.55   60.0  550.0   \n",
              "Boch MVC515       35.0  37000.0   1.05   45.0  250.0   \n",
              "Champion KIE278   41.0  31000.0   1.85   60.0  300.0   \n",
              "Cooper PCP596     31.0  18000.0   1.25   40.0  200.0   \n",
              "Boch IHM978       36.0  28000.0   1.40    NaN  250.0   \n",
              "Gardez UIB467     30.0      NaN   1.80   55.0  500.0   \n",
              "Bear WLR116       33.0  16000.0   1.65   65.0  300.0   \n",
              "Worx PKP959       44.0  44000.0   1.10   45.0  200.0   \n",
              "Wolf IUP443       44.0  41000.0   0.90   55.0  200.0   \n",
              "Worx VWL881       43.0  17000.0   1.00   25.0  350.0   \n",
              "Nakita RDT953     43.0  37000.0   0.80   70.0  250.0   \n",
              "Cooper GUV727     44.0  36000.0   1.90   40.0  450.0   \n",
              "\n",
              "                                                       DESCRIPTION  \n",
              "NAME                                                                \n",
              "Boch GEX523      Широкая полоса скашивания на данной газонокоси...  \n",
              "Champion CLX897  Средняя ширина скашиваемой полосы на данной га...  \n",
              "Wolf QMK791      Средняя ширина скашиваемой полосы на данной га...  \n",
              "Champion BHQ184  Средняя ширина скашиваемой полосы на данной га...  \n",
              "Nakita MHC974    Широкая полоса скашивания на данной газонокоси...  \n",
              "Worx YGN356      Широкая полоса скашивания на данной газонокоси...  \n",
              "Nakita DNJ664    Широкая полоса скашивания на данной газонокоси...  \n",
              "Worx OFF459      Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Gardez OGJ378    Средняя ширина скашиваемой полосы на данной га...  \n",
              "Boch MVC515      Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Champion KIE278  Широкая полоса скашивания на данной газонокоси...  \n",
              "Cooper PCP596    Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Boch IHM978      Средняя ширина скашиваемой полосы на данной га...  \n",
              "Gardez UIB467    Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Bear WLR116      Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Worx PKP959      Широкая полоса скашивания на данной газонокоси...  \n",
              "Wolf IUP443      Широкая полоса скашивания на данной газонокоси...  \n",
              "Worx VWL881      Широкая полоса скашивания на данной газонокоси...  \n",
              "Nakita RDT953    Широкая полоса скашивания на данной газонокоси...  \n",
              "Cooper GUV727    Широкая полоса скашивания на данной газонокоси...  "
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-a4c343cd-75a9-402b-a80e-343d2783d420\">\n",
              "    <div 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>WIDTH</th>\n",
              "      <th>PRICE</th>\n",
              "      <th>POWER</th>\n",
              "      <th>GRASS</th>\n",
              "      <th>AREA</th>\n",
              "      <th>DESCRIPTION</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>NAME</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>Boch GEX523</th>\n",
              "      <td>43.0</td>\n",
              "      <td>31000.0</td>\n",
              "      <td>1.00</td>\n",
              "      <td>30.0</td>\n",
              "      <td>400.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Champion CLX897</th>\n",
              "      <td>40.0</td>\n",
              "      <td>44000.0</td>\n",
              "      <td>1.00</td>\n",
              "      <td>50.0</td>\n",
              "      <td>550.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Wolf QMK791</th>\n",
              "      <td>37.0</td>\n",
              "      <td>40000.0</td>\n",
              "      <td>1.90</td>\n",
              "      <td>60.0</td>\n",
              "      <td>450.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Champion BHQ184</th>\n",
              "      <td>38.0</td>\n",
              "      <td>17000.0</td>\n",
              "      <td>0.85</td>\n",
              "      <td>70.0</td>\n",
              "      <td>600.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Nakita MHC974</th>\n",
              "      <td>43.0</td>\n",
              "      <td>45000.0</td>\n",
              "      <td>1.25</td>\n",
              "      <td>60.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx YGN356</th>\n",
              "      <td>43.0</td>\n",
              "      <td>44000.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>25.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Nakita DNJ664</th>\n",
              "      <td>43.0</td>\n",
              "      <td>41000.0</td>\n",
              "      <td>1.10</td>\n",
              "      <td>45.0</td>\n",
              "      <td>550.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx OFF459</th>\n",
              "      <td>35.0</td>\n",
              "      <td>20000.0</td>\n",
              "      <td>1.70</td>\n",
              "      <td>75.0</td>\n",
              "      <td>450.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Gardez OGJ378</th>\n",
              "      <td>37.0</td>\n",
              "      <td>41000.0</td>\n",
              "      <td>1.55</td>\n",
              "      <td>60.0</td>\n",
              "      <td>550.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Boch MVC515</th>\n",
              "      <td>35.0</td>\n",
              "      <td>37000.0</td>\n",
              "      <td>1.05</td>\n",
              "      <td>45.0</td>\n",
              "      <td>250.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Champion KIE278</th>\n",
              "      <td>41.0</td>\n",
              "      <td>31000.0</td>\n",
              "      <td>1.85</td>\n",
              "      <td>60.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Cooper PCP596</th>\n",
              "      <td>31.0</td>\n",
              "      <td>18000.0</td>\n",
              "      <td>1.25</td>\n",
              "      <td>40.0</td>\n",
              "      <td>200.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Boch IHM978</th>\n",
              "      <td>36.0</td>\n",
              "      <td>28000.0</td>\n",
              "      <td>1.40</td>\n",
              "      <td>NaN</td>\n",
              "      <td>250.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Gardez UIB467</th>\n",
              "      <td>30.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.80</td>\n",
              "      <td>55.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Bear WLR116</th>\n",
              "      <td>33.0</td>\n",
              "      <td>16000.0</td>\n",
              "      <td>1.65</td>\n",
              "      <td>65.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx PKP959</th>\n",
              "      <td>44.0</td>\n",
              "      <td>44000.0</td>\n",
              "      <td>1.10</td>\n",
              "      <td>45.0</td>\n",
              "      <td>200.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Wolf IUP443</th>\n",
              "      <td>44.0</td>\n",
              "      <td>41000.0</td>\n",
              "      <td>0.90</td>\n",
              "      <td>55.0</td>\n",
              "      <td>200.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx VWL881</th>\n",
              "      <td>43.0</td>\n",
              "      <td>17000.0</td>\n",
              "      <td>1.00</td>\n",
              "      <td>25.0</td>\n",
              "      <td>350.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Nakita RDT953</th>\n",
              "      <td>43.0</td>\n",
              "      <td>37000.0</td>\n",
              "      <td>0.80</td>\n",
              "      <td>70.0</td>\n",
              "      <td>250.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Cooper GUV727</th>\n",
              "      <td>44.0</td>\n",
              "      <td>36000.0</td>\n",
              "      <td>1.90</td>\n",
              "      <td>40.0</td>\n",
              "      <td>450.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a4c343cd-75a9-402b-a80e-343d2783d420')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-9cd2b587-3f91-45b0-bdd6-3957a0215250\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-9cd2b587-3f91-45b0-bdd6-3957a0215250')\"\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",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\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-quickchart: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",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart: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",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-9cd2b587-3f91-45b0-bdd6-3957a0215250 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-a4c343cd-75a9-402b-a80e-343d2783d420 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-a4c343cd-75a9-402b-a80e-343d2783d420');\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",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        " 2 вариант"
      ],
      "metadata": {
        "id": "D06qa00s6aYv"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "pattern = re.compile(r'узкая|узкие|узкую|узкой', re.IGNORECASE)\n",
        "df['WIDTH'] =df.apply(lambda x: m_30_35 if re.search(pattern, x['DESCRIPTION']) and pd.isna(x['WIDTH']) else x['WIDTH'],axis = 1)\n",
        "df.head(20)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 708
        },
        "id": "bHPko3yBfHG8",
        "outputId": "cd1d7b1a-252c-44a3-8a6d-a8d66282d804"
      },
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                 WIDTH    PRICE  POWER  GRASS   AREA  \\\n",
              "NAME                                                   \n",
              "Boch GEX523       43.0  31000.0   1.00   30.0  400.0   \n",
              "Champion CLX897   40.0  44000.0   1.00   50.0  550.0   \n",
              "Wolf QMK791       37.0  40000.0   1.90   60.0  450.0   \n",
              "Champion BHQ184   38.0  17000.0   0.85   70.0  600.0   \n",
              "Nakita MHC974     43.0  45000.0   1.25   60.0  300.0   \n",
              "Worx YGN356       43.0  44000.0    NaN   25.0  500.0   \n",
              "Nakita DNJ664     43.0  41000.0   1.10   45.0  550.0   \n",
              "Worx OFF459       35.0  20000.0   1.70   75.0  450.0   \n",
              "Gardez OGJ378     37.0  41000.0   1.55   60.0  550.0   \n",
              "Boch MVC515       35.0  37000.0   1.05   45.0  250.0   \n",
              "Champion KIE278   41.0  31000.0   1.85   60.0  300.0   \n",
              "Cooper PCP596     31.0  18000.0   1.25   40.0  200.0   \n",
              "Boch IHM978       36.0  28000.0   1.40    NaN  250.0   \n",
              "Gardez UIB467     30.0      NaN   1.80   55.0  500.0   \n",
              "Bear WLR116       33.0  16000.0   1.65   65.0  300.0   \n",
              "Worx PKP959       44.0  44000.0   1.10   45.0  200.0   \n",
              "Wolf IUP443       44.0  41000.0   0.90   55.0  200.0   \n",
              "Worx VWL881       43.0  17000.0   1.00   25.0  350.0   \n",
              "Nakita RDT953     43.0  37000.0   0.80   70.0  250.0   \n",
              "Cooper GUV727     44.0  36000.0   1.90   40.0  450.0   \n",
              "\n",
              "                                                       DESCRIPTION  \n",
              "NAME                                                                \n",
              "Boch GEX523      Широкая полоса скашивания на данной газонокоси...  \n",
              "Champion CLX897  Средняя ширина скашиваемой полосы на данной га...  \n",
              "Wolf QMK791      Средняя ширина скашиваемой полосы на данной га...  \n",
              "Champion BHQ184  Средняя ширина скашиваемой полосы на данной га...  \n",
              "Nakita MHC974    Широкая полоса скашивания на данной газонокоси...  \n",
              "Worx YGN356      Широкая полоса скашивания на данной газонокоси...  \n",
              "Nakita DNJ664    Широкая полоса скашивания на данной газонокоси...  \n",
              "Worx OFF459      Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Gardez OGJ378    Средняя ширина скашиваемой полосы на данной га...  \n",
              "Boch MVC515      Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Champion KIE278  Широкая полоса скашивания на данной газонокоси...  \n",
              "Cooper PCP596    Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Boch IHM978      Средняя ширина скашиваемой полосы на данной га...  \n",
              "Gardez UIB467    Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Bear WLR116      Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Worx PKP959      Широкая полоса скашивания на данной газонокоси...  \n",
              "Wolf IUP443      Широкая полоса скашивания на данной газонокоси...  \n",
              "Worx VWL881      Широкая полоса скашивания на данной газонокоси...  \n",
              "Nakita RDT953    Широкая полоса скашивания на данной газонокоси...  \n",
              "Cooper GUV727    Широкая полоса скашивания на данной газонокоси...  "
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-ccc64fec-5a09-4544-926d-d557a0122cff\">\n",
              "    <div 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>WIDTH</th>\n",
              "      <th>PRICE</th>\n",
              "      <th>POWER</th>\n",
              "      <th>GRASS</th>\n",
              "      <th>AREA</th>\n",
              "      <th>DESCRIPTION</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>NAME</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>Boch GEX523</th>\n",
              "      <td>43.0</td>\n",
              "      <td>31000.0</td>\n",
              "      <td>1.00</td>\n",
              "      <td>30.0</td>\n",
              "      <td>400.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Champion CLX897</th>\n",
              "      <td>40.0</td>\n",
              "      <td>44000.0</td>\n",
              "      <td>1.00</td>\n",
              "      <td>50.0</td>\n",
              "      <td>550.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Wolf QMK791</th>\n",
              "      <td>37.0</td>\n",
              "      <td>40000.0</td>\n",
              "      <td>1.90</td>\n",
              "      <td>60.0</td>\n",
              "      <td>450.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Champion BHQ184</th>\n",
              "      <td>38.0</td>\n",
              "      <td>17000.0</td>\n",
              "      <td>0.85</td>\n",
              "      <td>70.0</td>\n",
              "      <td>600.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Nakita MHC974</th>\n",
              "      <td>43.0</td>\n",
              "      <td>45000.0</td>\n",
              "      <td>1.25</td>\n",
              "      <td>60.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx YGN356</th>\n",
              "      <td>43.0</td>\n",
              "      <td>44000.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>25.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Nakita DNJ664</th>\n",
              "      <td>43.0</td>\n",
              "      <td>41000.0</td>\n",
              "      <td>1.10</td>\n",
              "      <td>45.0</td>\n",
              "      <td>550.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx OFF459</th>\n",
              "      <td>35.0</td>\n",
              "      <td>20000.0</td>\n",
              "      <td>1.70</td>\n",
              "      <td>75.0</td>\n",
              "      <td>450.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Gardez OGJ378</th>\n",
              "      <td>37.0</td>\n",
              "      <td>41000.0</td>\n",
              "      <td>1.55</td>\n",
              "      <td>60.0</td>\n",
              "      <td>550.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Boch MVC515</th>\n",
              "      <td>35.0</td>\n",
              "      <td>37000.0</td>\n",
              "      <td>1.05</td>\n",
              "      <td>45.0</td>\n",
              "      <td>250.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Champion KIE278</th>\n",
              "      <td>41.0</td>\n",
              "      <td>31000.0</td>\n",
              "      <td>1.85</td>\n",
              "      <td>60.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Cooper PCP596</th>\n",
              "      <td>31.0</td>\n",
              "      <td>18000.0</td>\n",
              "      <td>1.25</td>\n",
              "      <td>40.0</td>\n",
              "      <td>200.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Boch IHM978</th>\n",
              "      <td>36.0</td>\n",
              "      <td>28000.0</td>\n",
              "      <td>1.40</td>\n",
              "      <td>NaN</td>\n",
              "      <td>250.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Gardez UIB467</th>\n",
              "      <td>30.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.80</td>\n",
              "      <td>55.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Bear WLR116</th>\n",
              "      <td>33.0</td>\n",
              "      <td>16000.0</td>\n",
              "      <td>1.65</td>\n",
              "      <td>65.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx PKP959</th>\n",
              "      <td>44.0</td>\n",
              "      <td>44000.0</td>\n",
              "      <td>1.10</td>\n",
              "      <td>45.0</td>\n",
              "      <td>200.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Wolf IUP443</th>\n",
              "      <td>44.0</td>\n",
              "      <td>41000.0</td>\n",
              "      <td>0.90</td>\n",
              "      <td>55.0</td>\n",
              "      <td>200.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx VWL881</th>\n",
              "      <td>43.0</td>\n",
              "      <td>17000.0</td>\n",
              "      <td>1.00</td>\n",
              "      <td>25.0</td>\n",
              "      <td>350.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Nakita RDT953</th>\n",
              "      <td>43.0</td>\n",
              "      <td>37000.0</td>\n",
              "      <td>0.80</td>\n",
              "      <td>70.0</td>\n",
              "      <td>250.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Cooper GUV727</th>\n",
              "      <td>44.0</td>\n",
              "      <td>36000.0</td>\n",
              "      <td>1.90</td>\n",
              "      <td>40.0</td>\n",
              "      <td>450.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-ccc64fec-5a09-4544-926d-d557a0122cff')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-9ab976ba-ad00-4302-9abb-eca3350f42cc\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-9ab976ba-ad00-4302-9abb-eca3350f42cc')\"\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",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\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-quickchart: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",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart: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",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-9ab976ba-ad00-4302-9abb-eca3350f42cc button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-ccc64fec-5a09-4544-926d-d557a0122cff 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-ccc64fec-5a09-4544-926d-d557a0122cff');\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",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "pattern = re.compile(r'средняя ширина|ширина средняя', re.IGNORECASE)\n",
        "df['WIDTH'] =df.apply(lambda x: m_36_40 if re.search(pattern, x['DESCRIPTION']) and pd.isna(x['WIDTH']) else x['WIDTH'],axis = 1)\n",
        "pattern = re.compile(r'широк(?:ая|ие)\\s+полос(?:а|ы)', re.IGNORECASE)\n",
        "df['WIDTH'] =df.apply(lambda x: m_41_45 if re.search(pattern, x['DESCRIPTION']) and pd.isna(x['WIDTH']) else x['WIDTH'],axis = 1)"
      ],
      "metadata": {
        "id": "AE9dXoV2Rlbm"
      },
      "execution_count": 9,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df.head(20)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 708
        },
        "id": "lBnVfQyK9WPR",
        "outputId": "3e4326f7-8c69-411c-a09d-ca9c2eb3bb1b"
      },
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                 WIDTH    PRICE  POWER  GRASS   AREA  \\\n",
              "NAME                                                   \n",
              "Boch GEX523       43.0  31000.0   1.00   30.0  400.0   \n",
              "Champion CLX897   40.0  44000.0   1.00   50.0  550.0   \n",
              "Wolf QMK791       37.0  40000.0   1.90   60.0  450.0   \n",
              "Champion BHQ184   38.0  17000.0   0.85   70.0  600.0   \n",
              "Nakita MHC974     43.0  45000.0   1.25   60.0  300.0   \n",
              "Worx YGN356       43.0  44000.0    NaN   25.0  500.0   \n",
              "Nakita DNJ664     43.0  41000.0   1.10   45.0  550.0   \n",
              "Worx OFF459       35.0  20000.0   1.70   75.0  450.0   \n",
              "Gardez OGJ378     37.0  41000.0   1.55   60.0  550.0   \n",
              "Boch MVC515       35.0  37000.0   1.05   45.0  250.0   \n",
              "Champion KIE278   41.0  31000.0   1.85   60.0  300.0   \n",
              "Cooper PCP596     31.0  18000.0   1.25   40.0  200.0   \n",
              "Boch IHM978       36.0  28000.0   1.40    NaN  250.0   \n",
              "Gardez UIB467     30.0      NaN   1.80   55.0  500.0   \n",
              "Bear WLR116       33.0  16000.0   1.65   65.0  300.0   \n",
              "Worx PKP959       44.0  44000.0   1.10   45.0  200.0   \n",
              "Wolf IUP443       44.0  41000.0   0.90   55.0  200.0   \n",
              "Worx VWL881       43.0  17000.0   1.00   25.0  350.0   \n",
              "Nakita RDT953     43.0  37000.0   0.80   70.0  250.0   \n",
              "Cooper GUV727     44.0  36000.0   1.90   40.0  450.0   \n",
              "\n",
              "                                                       DESCRIPTION  \n",
              "NAME                                                                \n",
              "Boch GEX523      Широкая полоса скашивания на данной газонокоси...  \n",
              "Champion CLX897  Средняя ширина скашиваемой полосы на данной га...  \n",
              "Wolf QMK791      Средняя ширина скашиваемой полосы на данной га...  \n",
              "Champion BHQ184  Средняя ширина скашиваемой полосы на данной га...  \n",
              "Nakita MHC974    Широкая полоса скашивания на данной газонокоси...  \n",
              "Worx YGN356      Широкая полоса скашивания на данной газонокоси...  \n",
              "Nakita DNJ664    Широкая полоса скашивания на данной газонокоси...  \n",
              "Worx OFF459      Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Gardez OGJ378    Средняя ширина скашиваемой полосы на данной га...  \n",
              "Boch MVC515      Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Champion KIE278  Широкая полоса скашивания на данной газонокоси...  \n",
              "Cooper PCP596    Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Boch IHM978      Средняя ширина скашиваемой полосы на данной га...  \n",
              "Gardez UIB467    Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Bear WLR116      Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Worx PKP959      Широкая полоса скашивания на данной газонокоси...  \n",
              "Wolf IUP443      Широкая полоса скашивания на данной газонокоси...  \n",
              "Worx VWL881      Широкая полоса скашивания на данной газонокоси...  \n",
              "Nakita RDT953    Широкая полоса скашивания на данной газонокоси...  \n",
              "Cooper GUV727    Широкая полоса скашивания на данной газонокоси...  "
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-7b182d44-a2e0-4608-9923-bd5d111e3be4\">\n",
              "    <div 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>WIDTH</th>\n",
              "      <th>PRICE</th>\n",
              "      <th>POWER</th>\n",
              "      <th>GRASS</th>\n",
              "      <th>AREA</th>\n",
              "      <th>DESCRIPTION</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>NAME</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>Boch GEX523</th>\n",
              "      <td>43.0</td>\n",
              "      <td>31000.0</td>\n",
              "      <td>1.00</td>\n",
              "      <td>30.0</td>\n",
              "      <td>400.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Champion CLX897</th>\n",
              "      <td>40.0</td>\n",
              "      <td>44000.0</td>\n",
              "      <td>1.00</td>\n",
              "      <td>50.0</td>\n",
              "      <td>550.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Wolf QMK791</th>\n",
              "      <td>37.0</td>\n",
              "      <td>40000.0</td>\n",
              "      <td>1.90</td>\n",
              "      <td>60.0</td>\n",
              "      <td>450.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Champion BHQ184</th>\n",
              "      <td>38.0</td>\n",
              "      <td>17000.0</td>\n",
              "      <td>0.85</td>\n",
              "      <td>70.0</td>\n",
              "      <td>600.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Nakita MHC974</th>\n",
              "      <td>43.0</td>\n",
              "      <td>45000.0</td>\n",
              "      <td>1.25</td>\n",
              "      <td>60.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx YGN356</th>\n",
              "      <td>43.0</td>\n",
              "      <td>44000.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>25.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Nakita DNJ664</th>\n",
              "      <td>43.0</td>\n",
              "      <td>41000.0</td>\n",
              "      <td>1.10</td>\n",
              "      <td>45.0</td>\n",
              "      <td>550.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx OFF459</th>\n",
              "      <td>35.0</td>\n",
              "      <td>20000.0</td>\n",
              "      <td>1.70</td>\n",
              "      <td>75.0</td>\n",
              "      <td>450.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Gardez OGJ378</th>\n",
              "      <td>37.0</td>\n",
              "      <td>41000.0</td>\n",
              "      <td>1.55</td>\n",
              "      <td>60.0</td>\n",
              "      <td>550.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Boch MVC515</th>\n",
              "      <td>35.0</td>\n",
              "      <td>37000.0</td>\n",
              "      <td>1.05</td>\n",
              "      <td>45.0</td>\n",
              "      <td>250.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Champion KIE278</th>\n",
              "      <td>41.0</td>\n",
              "      <td>31000.0</td>\n",
              "      <td>1.85</td>\n",
              "      <td>60.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Cooper PCP596</th>\n",
              "      <td>31.0</td>\n",
              "      <td>18000.0</td>\n",
              "      <td>1.25</td>\n",
              "      <td>40.0</td>\n",
              "      <td>200.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Boch IHM978</th>\n",
              "      <td>36.0</td>\n",
              "      <td>28000.0</td>\n",
              "      <td>1.40</td>\n",
              "      <td>NaN</td>\n",
              "      <td>250.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Gardez UIB467</th>\n",
              "      <td>30.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.80</td>\n",
              "      <td>55.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Bear WLR116</th>\n",
              "      <td>33.0</td>\n",
              "      <td>16000.0</td>\n",
              "      <td>1.65</td>\n",
              "      <td>65.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx PKP959</th>\n",
              "      <td>44.0</td>\n",
              "      <td>44000.0</td>\n",
              "      <td>1.10</td>\n",
              "      <td>45.0</td>\n",
              "      <td>200.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Wolf IUP443</th>\n",
              "      <td>44.0</td>\n",
              "      <td>41000.0</td>\n",
              "      <td>0.90</td>\n",
              "      <td>55.0</td>\n",
              "      <td>200.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx VWL881</th>\n",
              "      <td>43.0</td>\n",
              "      <td>17000.0</td>\n",
              "      <td>1.00</td>\n",
              "      <td>25.0</td>\n",
              "      <td>350.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Nakita RDT953</th>\n",
              "      <td>43.0</td>\n",
              "      <td>37000.0</td>\n",
              "      <td>0.80</td>\n",
              "      <td>70.0</td>\n",
              "      <td>250.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Cooper GUV727</th>\n",
              "      <td>44.0</td>\n",
              "      <td>36000.0</td>\n",
              "      <td>1.90</td>\n",
              "      <td>40.0</td>\n",
              "      <td>450.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-7b182d44-a2e0-4608-9923-bd5d111e3be4')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-de3fdf84-762e-461a-ad81-377b077bcd6c\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-de3fdf84-762e-461a-ad81-377b077bcd6c')\"\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",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\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-quickchart: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",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart: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",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-de3fdf84-762e-461a-ad81-377b077bcd6c button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-7b182d44-a2e0-4608-9923-bd5d111e3be4 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-7b182d44-a2e0-4608-9923-bd5d111e3be4');\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",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Cреднее арифметическое для параметра \"Ширина скашиваемой полосы\" после восстановления пропущенных значений:"
      ],
      "metadata": {
        "id": "yWZ6EIWG99CQ"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "print(round(df[\"WIDTH\"].mean(),2))"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "thehaCJukXJU",
        "outputId": "cf742015-9e94-45fa-9f96-6c91a0e49e68"
      },
      "execution_count": 11,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "37.39\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "2. Цены на газонокосилки имели очень большой разброс и Юрий решил избавиться от вариантов, стоимость которых попадала под определение \"экстремальных выбросов\"."
      ],
      "metadata": {
        "id": "N-JaBtlKlEZE"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Находим значения квартилей"
      ],
      "metadata": {
        "id": "Y8Q_usn--TjD"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "Q1 = df['PRICE'].quantile(0.25)\n",
        "Q2 = df['PRICE'].quantile(0.5)\n",
        "Q3 = df['PRICE'].quantile(0.75)\n",
        "IQR = Q3-Q1\n",
        "print(Q1,Q2,Q3,IQR)\n",
        "print(IQR*3)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "81EU1Mfn-3de",
        "outputId": "1c2d8c9f-1d89-4091-c5d5-e5392df1e914"
      },
      "execution_count": 12,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "20000.0 31000.0 41000.0 21000.0\n",
            "63000.0\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "print(Q1 - 3 * IQR)\n",
        "print(Q3 + 3 * IQR)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "TGOyhl-zT0Ua",
        "outputId": "733537d8-b1de-422e-c99d-c99802fc713c"
      },
      "execution_count": 13,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "-43000.0\n",
            "104000.0\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Удаляем экстремальные выбросы"
      ],
      "metadata": {
        "id": "_HnhCFRr_j69"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df = df[(df['PRICE'] > Q1 - 3 * IQR) & (df['PRICE'] < Q3 + 3 * IQR)]\n",
        "df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 455
        },
        "id": "Z3_yF-fp_kDZ",
        "outputId": "82e65270-fa7d-4866-dc9d-d71585530cc3"
      },
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                 WIDTH    PRICE  POWER  GRASS   AREA  \\\n",
              "NAME                                                   \n",
              "Boch GEX523       43.0  31000.0   1.00   30.0  400.0   \n",
              "Champion CLX897   40.0  44000.0   1.00   50.0  550.0   \n",
              "Wolf QMK791       37.0  40000.0   1.90   60.0  450.0   \n",
              "Champion BHQ184   38.0  17000.0   0.85   70.0  600.0   \n",
              "Nakita MHC974     43.0  45000.0   1.25   60.0  300.0   \n",
              "...                ...      ...    ...    ...    ...   \n",
              "Bear UTB412       32.0  11000.0   1.65   70.0  350.0   \n",
              "Bear XEA325       30.0  20000.0   0.90   25.0  250.0   \n",
              "Boch KYS338       38.0  21000.0   0.95   65.0  350.0   \n",
              "Gardez GOI478     30.0  21000.0   1.90   35.0  300.0   \n",
              "Worx GJT456       43.0  39000.0   1.35   45.0  450.0   \n",
              "\n",
              "                                                       DESCRIPTION  \n",
              "NAME                                                                \n",
              "Boch GEX523      Широкая полоса скашивания на данной газонокоси...  \n",
              "Champion CLX897  Средняя ширина скашиваемой полосы на данной га...  \n",
              "Wolf QMK791      Средняя ширина скашиваемой полосы на данной га...  \n",
              "Champion BHQ184  Средняя ширина скашиваемой полосы на данной га...  \n",
              "Nakita MHC974    Широкая полоса скашивания на данной газонокоси...  \n",
              "...                                                            ...  \n",
              "Bear UTB412      Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Bear XEA325      Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Boch KYS338      Средняя ширина скашиваемой полосы на данной га...  \n",
              "Gardez GOI478    Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Worx GJT456      Широкая полоса скашивания на данной газонокоси...  \n",
              "\n",
              "[187 rows x 6 columns]"
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-4c4ce72a-dc6f-45bc-bf4f-cdf571d2edfb\">\n",
              "    <div 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>WIDTH</th>\n",
              "      <th>PRICE</th>\n",
              "      <th>POWER</th>\n",
              "      <th>GRASS</th>\n",
              "      <th>AREA</th>\n",
              "      <th>DESCRIPTION</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>NAME</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>Boch GEX523</th>\n",
              "      <td>43.0</td>\n",
              "      <td>31000.0</td>\n",
              "      <td>1.00</td>\n",
              "      <td>30.0</td>\n",
              "      <td>400.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Champion CLX897</th>\n",
              "      <td>40.0</td>\n",
              "      <td>44000.0</td>\n",
              "      <td>1.00</td>\n",
              "      <td>50.0</td>\n",
              "      <td>550.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Wolf QMK791</th>\n",
              "      <td>37.0</td>\n",
              "      <td>40000.0</td>\n",
              "      <td>1.90</td>\n",
              "      <td>60.0</td>\n",
              "      <td>450.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Champion BHQ184</th>\n",
              "      <td>38.0</td>\n",
              "      <td>17000.0</td>\n",
              "      <td>0.85</td>\n",
              "      <td>70.0</td>\n",
              "      <td>600.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Nakita MHC974</th>\n",
              "      <td>43.0</td>\n",
              "      <td>45000.0</td>\n",
              "      <td>1.25</td>\n",
              "      <td>60.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Bear UTB412</th>\n",
              "      <td>32.0</td>\n",
              "      <td>11000.0</td>\n",
              "      <td>1.65</td>\n",
              "      <td>70.0</td>\n",
              "      <td>350.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Bear XEA325</th>\n",
              "      <td>30.0</td>\n",
              "      <td>20000.0</td>\n",
              "      <td>0.90</td>\n",
              "      <td>25.0</td>\n",
              "      <td>250.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Boch KYS338</th>\n",
              "      <td>38.0</td>\n",
              "      <td>21000.0</td>\n",
              "      <td>0.95</td>\n",
              "      <td>65.0</td>\n",
              "      <td>350.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Gardez GOI478</th>\n",
              "      <td>30.0</td>\n",
              "      <td>21000.0</td>\n",
              "      <td>1.90</td>\n",
              "      <td>35.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx GJT456</th>\n",
              "      <td>43.0</td>\n",
              "      <td>39000.0</td>\n",
              "      <td>1.35</td>\n",
              "      <td>45.0</td>\n",
              "      <td>450.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>187 rows × 6 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-4c4ce72a-dc6f-45bc-bf4f-cdf571d2edfb')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-0c5bbcc0-ab1d-4c0a-861b-18b6be9de899\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-0c5bbcc0-ab1d-4c0a-861b-18b6be9de899')\"\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",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\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-quickchart: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",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart: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",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-0c5bbcc0-ab1d-4c0a-861b-18b6be9de899 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-4c4ce72a-dc6f-45bc-bf4f-cdf571d2edfb 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-4c4ce72a-dc6f-45bc-bf4f-cdf571d2edfb');\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",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Исключаем записи, в которых все еще оставались пропущенные значения."
      ],
      "metadata": {
        "id": "pF2ID9j4ALpS"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df = df.dropna()\n",
        "df"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 455
        },
        "id": "jwkNX5pEALzU",
        "outputId": "70c4c01b-abc8-4fb7-f095-69e4d0d134d5"
      },
      "execution_count": 15,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                 WIDTH    PRICE  POWER  GRASS   AREA  \\\n",
              "NAME                                                   \n",
              "Boch GEX523       43.0  31000.0   1.00   30.0  400.0   \n",
              "Champion CLX897   40.0  44000.0   1.00   50.0  550.0   \n",
              "Wolf QMK791       37.0  40000.0   1.90   60.0  450.0   \n",
              "Champion BHQ184   38.0  17000.0   0.85   70.0  600.0   \n",
              "Nakita MHC974     43.0  45000.0   1.25   60.0  300.0   \n",
              "...                ...      ...    ...    ...    ...   \n",
              "Bear UTB412       32.0  11000.0   1.65   70.0  350.0   \n",
              "Bear XEA325       30.0  20000.0   0.90   25.0  250.0   \n",
              "Boch KYS338       38.0  21000.0   0.95   65.0  350.0   \n",
              "Gardez GOI478     30.0  21000.0   1.90   35.0  300.0   \n",
              "Worx GJT456       43.0  39000.0   1.35   45.0  450.0   \n",
              "\n",
              "                                                       DESCRIPTION  \n",
              "NAME                                                                \n",
              "Boch GEX523      Широкая полоса скашивания на данной газонокоси...  \n",
              "Champion CLX897  Средняя ширина скашиваемой полосы на данной га...  \n",
              "Wolf QMK791      Средняя ширина скашиваемой полосы на данной га...  \n",
              "Champion BHQ184  Средняя ширина скашиваемой полосы на данной га...  \n",
              "Nakita MHC974    Широкая полоса скашивания на данной газонокоси...  \n",
              "...                                                            ...  \n",
              "Bear UTB412      Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Bear XEA325      Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Boch KYS338      Средняя ширина скашиваемой полосы на данной га...  \n",
              "Gardez GOI478    Новая газонокосилка имеет узкую ширину скашива...  \n",
              "Worx GJT456      Широкая полоса скашивания на данной газонокоси...  \n",
              "\n",
              "[177 rows x 6 columns]"
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-72cc7c50-9b97-4018-ae87-94a08ddd8837\">\n",
              "    <div 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>WIDTH</th>\n",
              "      <th>PRICE</th>\n",
              "      <th>POWER</th>\n",
              "      <th>GRASS</th>\n",
              "      <th>AREA</th>\n",
              "      <th>DESCRIPTION</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>NAME</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>Boch GEX523</th>\n",
              "      <td>43.0</td>\n",
              "      <td>31000.0</td>\n",
              "      <td>1.00</td>\n",
              "      <td>30.0</td>\n",
              "      <td>400.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Champion CLX897</th>\n",
              "      <td>40.0</td>\n",
              "      <td>44000.0</td>\n",
              "      <td>1.00</td>\n",
              "      <td>50.0</td>\n",
              "      <td>550.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Wolf QMK791</th>\n",
              "      <td>37.0</td>\n",
              "      <td>40000.0</td>\n",
              "      <td>1.90</td>\n",
              "      <td>60.0</td>\n",
              "      <td>450.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Champion BHQ184</th>\n",
              "      <td>38.0</td>\n",
              "      <td>17000.0</td>\n",
              "      <td>0.85</td>\n",
              "      <td>70.0</td>\n",
              "      <td>600.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Nakita MHC974</th>\n",
              "      <td>43.0</td>\n",
              "      <td>45000.0</td>\n",
              "      <td>1.25</td>\n",
              "      <td>60.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Bear UTB412</th>\n",
              "      <td>32.0</td>\n",
              "      <td>11000.0</td>\n",
              "      <td>1.65</td>\n",
              "      <td>70.0</td>\n",
              "      <td>350.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Bear XEA325</th>\n",
              "      <td>30.0</td>\n",
              "      <td>20000.0</td>\n",
              "      <td>0.90</td>\n",
              "      <td>25.0</td>\n",
              "      <td>250.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Boch KYS338</th>\n",
              "      <td>38.0</td>\n",
              "      <td>21000.0</td>\n",
              "      <td>0.95</td>\n",
              "      <td>65.0</td>\n",
              "      <td>350.0</td>\n",
              "      <td>Средняя ширина скашиваемой полосы на данной га...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Gardez GOI478</th>\n",
              "      <td>30.0</td>\n",
              "      <td>21000.0</td>\n",
              "      <td>1.90</td>\n",
              "      <td>35.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>Новая газонокосилка имеет узкую ширину скашива...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx GJT456</th>\n",
              "      <td>43.0</td>\n",
              "      <td>39000.0</td>\n",
              "      <td>1.35</td>\n",
              "      <td>45.0</td>\n",
              "      <td>450.0</td>\n",
              "      <td>Широкая полоса скашивания на данной газонокоси...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>177 rows × 6 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-72cc7c50-9b97-4018-ae87-94a08ddd8837')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-1f54d595-2dce-4863-9663-a696192195e1\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-1f54d595-2dce-4863-9663-a696192195e1')\"\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",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\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-quickchart: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",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart: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",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-1f54d595-2dce-4863-9663-a696192195e1 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-72cc7c50-9b97-4018-ae87-94a08ddd8837 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-72cc7c50-9b97-4018-ae87-94a08ddd8837');\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",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "3.   Количество оставшихся к рассмотрению газонокосилок:\n",
        "\n",
        "\n"
      ],
      "metadata": {
        "id": "5Y1mg8LGAlA4"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df.shape[0]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "1BKA0tl0Alo9",
        "outputId": "53133198-d2e8-4188-dd5c-6672f876797e"
      },
      "execution_count": 16,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "177"
            ]
          },
          "metadata": {},
          "execution_count": 16
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Среднее арифметическое для параметра \"Стоимость\" полученного после обработки набора данных"
      ],
      "metadata": {
        "id": "1nV-rIAzA9V4"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "round(df['PRICE'].mean(),2)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "y_XUTxphA9xL",
        "outputId": "68a562e3-c8ec-4ac6-c9cc-c216beb0d9d2"
      },
      "execution_count": 17,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "29587.57"
            ]
          },
          "metadata": {},
          "execution_count": 17
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "4. Параметры газонокосилок имеют разную размерность, так что Юрий решил экспоненциально нормировать значения числовых параметров."
      ],
      "metadata": {
        "id": "hhCgQKP3BcJx"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df.info()"
      ],
      "metadata": {
        "id": "8Q812IMMCddt",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "ef365730-3231-49c4-cc27-c697c677df18"
      },
      "execution_count": 18,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "Index: 177 entries, Boch GEX523 to Worx GJT456\n",
            "Data columns (total 6 columns):\n",
            " #   Column       Non-Null Count  Dtype  \n",
            "---  ------       --------------  -----  \n",
            " 0   WIDTH        177 non-null    float64\n",
            " 1   PRICE        177 non-null    float64\n",
            " 2   POWER        177 non-null    float64\n",
            " 3   GRASS        177 non-null    float64\n",
            " 4   AREA         177 non-null    float64\n",
            " 5   DESCRIPTION  177 non-null    object \n",
            "dtypes: float64(5), object(1)\n",
            "memory usage: 9.7+ KB\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df_n = df.drop(columns=['DESCRIPTION'])\n",
        "df_n = 1 - np.exp(1 - df_n/df_n.min())\n",
        "df_n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 455
        },
        "id": "Xy4ircnDBhVI",
        "outputId": "dfbecf88-7234-4003-a780-402cd4d07c68"
      },
      "execution_count": 19,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                    WIDTH     PRICE     POWER     GRASS      AREA\n",
              "NAME                                                             \n",
              "Boch GEX523      0.351656  0.943584  0.283469  0.181269  0.632121\n",
              "Champion CLX897  0.283469  0.988891  0.283469  0.632121  0.826226\n",
              "Wolf QMK791      0.208110  0.981684  0.784185  0.753403  0.713495\n",
              "Champion BHQ184  0.234072  0.675348  0.124827  0.834701  0.864665\n",
              "Nakita MHC974    0.351656  0.990196  0.486583  0.753403  0.393469\n",
              "...                   ...       ...       ...       ...       ...\n",
              "Bear UTB412      0.064493  0.312711  0.698806  0.834701  0.527633\n",
              "Bear XEA325      0.000000  0.776870  0.181269  0.000000  0.221199\n",
              "Boch KYS338      0.234072  0.803088  0.234072  0.798103  0.527633\n",
              "Gardez GOI478    0.000000  0.803088  0.784185  0.329680  0.393469\n",
              "Worx GJT456      0.351656  0.979246  0.550671  0.550671  0.713495\n",
              "\n",
              "[177 rows x 5 columns]"
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-efe3b6cc-f132-463b-a20b-0802ceb704df\">\n",
              "    <div 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>WIDTH</th>\n",
              "      <th>PRICE</th>\n",
              "      <th>POWER</th>\n",
              "      <th>GRASS</th>\n",
              "      <th>AREA</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>NAME</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>Boch GEX523</th>\n",
              "      <td>0.351656</td>\n",
              "      <td>0.943584</td>\n",
              "      <td>0.283469</td>\n",
              "      <td>0.181269</td>\n",
              "      <td>0.632121</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Champion CLX897</th>\n",
              "      <td>0.283469</td>\n",
              "      <td>0.988891</td>\n",
              "      <td>0.283469</td>\n",
              "      <td>0.632121</td>\n",
              "      <td>0.826226</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Wolf QMK791</th>\n",
              "      <td>0.208110</td>\n",
              "      <td>0.981684</td>\n",
              "      <td>0.784185</td>\n",
              "      <td>0.753403</td>\n",
              "      <td>0.713495</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Champion BHQ184</th>\n",
              "      <td>0.234072</td>\n",
              "      <td>0.675348</td>\n",
              "      <td>0.124827</td>\n",
              "      <td>0.834701</td>\n",
              "      <td>0.864665</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Nakita MHC974</th>\n",
              "      <td>0.351656</td>\n",
              "      <td>0.990196</td>\n",
              "      <td>0.486583</td>\n",
              "      <td>0.753403</td>\n",
              "      <td>0.393469</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Bear UTB412</th>\n",
              "      <td>0.064493</td>\n",
              "      <td>0.312711</td>\n",
              "      <td>0.698806</td>\n",
              "      <td>0.834701</td>\n",
              "      <td>0.527633</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Bear XEA325</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.776870</td>\n",
              "      <td>0.181269</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.221199</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Boch KYS338</th>\n",
              "      <td>0.234072</td>\n",
              "      <td>0.803088</td>\n",
              "      <td>0.234072</td>\n",
              "      <td>0.798103</td>\n",
              "      <td>0.527633</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Gardez GOI478</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.803088</td>\n",
              "      <td>0.784185</td>\n",
              "      <td>0.329680</td>\n",
              "      <td>0.393469</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx GJT456</th>\n",
              "      <td>0.351656</td>\n",
              "      <td>0.979246</td>\n",
              "      <td>0.550671</td>\n",
              "      <td>0.550671</td>\n",
              "      <td>0.713495</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>177 rows × 5 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-efe3b6cc-f132-463b-a20b-0802ceb704df')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-3e298f99-7ef5-452a-becb-127e67d694fc\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-3e298f99-7ef5-452a-becb-127e67d694fc')\"\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",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\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-quickchart: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",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart: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",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-3e298f99-7ef5-452a-becb-127e67d694fc button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-efe3b6cc-f132-463b-a20b-0802ceb704df 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-efe3b6cc-f132-463b-a20b-0802ceb704df');\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",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "Введите нормированные значения параметров газнокосилки Nakita RDT953:"
      ],
      "metadata": {
        "id": "dkEmQ9NSGL4V"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "print(round(df_n.loc['Nakita RDT953']['WIDTH'],2))\n",
        "print(round(df_n.loc['Nakita RDT953']['PRICE'],2))\n",
        "print(round(df_n.loc['Nakita RDT953']['POWER'],2))\n",
        "print(round(df_n.loc['Nakita RDT953']['GRASS'],2))\n",
        "print(round(df_n.loc['Nakita RDT953']['AREA'],2))"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "EVgeC-4GEkc5",
        "outputId": "01438b54-e55f-444d-9a1a-b5edb5dcdc2b"
      },
      "execution_count": 21,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "0.35\n",
            "0.97\n",
            "0.06\n",
            "0.83\n",
            "0.22\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "\n",
        "\n",
        "5.   И наконец, Юрий составил целевую функцию, на основе которой определил 3 наиболее подходящие (на его взгляд) газонокосилки. При определении целевой функции он использовал следующие слагаемые:\n",
        "\n",
        "Нормированная ширина скашиваемой полосы с коэффициентом 1\n",
        "Стоимость как слагаемое вида (1 - нормированная стоимость) с коэффициентом 8\n",
        "Нормированную мощность с коэффициентом 8\n",
        "Нормированный объём травосборника с коэффициентом 5\n",
        "Нормированную площадь скашиваемой поверхности с коэффициентом 5"
      ],
      "metadata": {
        "id": "MEk8iUWIHKz7"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df_n['SUM'] = df_n['WIDTH']*4 + (1 - df_n['PRICE']) * 7 + df_n['POWER'] * 5 + df_n['GRASS'] * 4 + df_n['AREA'] *6\n",
        "df_n.sort_values(by = ['SUM'], ascending = False)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 455
        },
        "id": "yA1_6U0MHLDC",
        "outputId": "ef3044b8-9dc9-48f3-ced0-e24a5b701e49"
      },
      "execution_count": 24,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                    WIDTH     PRICE     POWER     GRASS      AREA        SUM\n",
              "NAME                                                                        \n",
              "Bear AYR452      0.259182  0.117503  0.655846  0.834701  0.864665  19.020229\n",
              "Worx XXK993      0.351656  0.117503  0.655846  0.632121  0.826226  18.349171\n",
              "Cooper LZN757    0.372911  0.221199  0.769307  0.753403  0.632121  17.596119\n",
              "Boch BYY995      0.283469  0.000000  0.579650  0.550671  0.527633  16.400608\n",
              "Worx ITH691      0.208110  0.000000  0.283469  0.834701  0.632121  16.381313\n",
              "...                   ...       ...       ...       ...       ...        ...\n",
              "Champion CZT356  0.306959  0.981684  0.124827  0.181269  0.393469   5.066073\n",
              "Worx PJP333      0.000000  0.936072  0.283469  0.181269  0.393469   4.950732\n",
              "Nakita OMQ937    0.234072  0.927560  0.000000  0.329680  0.221199   4.089280\n",
              "Wolf ZCU697      0.234072  0.956063  0.372911  0.181269  0.000000   3.833477\n",
              "Bear XEA325      0.000000  0.776870  0.181269  0.000000  0.221199   3.795453\n",
              "\n",
              "[177 rows x 6 columns]"
            ],
            "text/html": [
              "\n",
              "\n",
              "  <div id=\"df-70f000b1-9d60-4947-8af3-f4253fc81bb1\">\n",
              "    <div 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>WIDTH</th>\n",
              "      <th>PRICE</th>\n",
              "      <th>POWER</th>\n",
              "      <th>GRASS</th>\n",
              "      <th>AREA</th>\n",
              "      <th>SUM</th>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>NAME</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>Bear AYR452</th>\n",
              "      <td>0.259182</td>\n",
              "      <td>0.117503</td>\n",
              "      <td>0.655846</td>\n",
              "      <td>0.834701</td>\n",
              "      <td>0.864665</td>\n",
              "      <td>19.020229</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx XXK993</th>\n",
              "      <td>0.351656</td>\n",
              "      <td>0.117503</td>\n",
              "      <td>0.655846</td>\n",
              "      <td>0.632121</td>\n",
              "      <td>0.826226</td>\n",
              "      <td>18.349171</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Cooper LZN757</th>\n",
              "      <td>0.372911</td>\n",
              "      <td>0.221199</td>\n",
              "      <td>0.769307</td>\n",
              "      <td>0.753403</td>\n",
              "      <td>0.632121</td>\n",
              "      <td>17.596119</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Boch BYY995</th>\n",
              "      <td>0.283469</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.579650</td>\n",
              "      <td>0.550671</td>\n",
              "      <td>0.527633</td>\n",
              "      <td>16.400608</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx ITH691</th>\n",
              "      <td>0.208110</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.283469</td>\n",
              "      <td>0.834701</td>\n",
              "      <td>0.632121</td>\n",
              "      <td>16.381313</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Champion CZT356</th>\n",
              "      <td>0.306959</td>\n",
              "      <td>0.981684</td>\n",
              "      <td>0.124827</td>\n",
              "      <td>0.181269</td>\n",
              "      <td>0.393469</td>\n",
              "      <td>5.066073</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Worx PJP333</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.936072</td>\n",
              "      <td>0.283469</td>\n",
              "      <td>0.181269</td>\n",
              "      <td>0.393469</td>\n",
              "      <td>4.950732</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Nakita OMQ937</th>\n",
              "      <td>0.234072</td>\n",
              "      <td>0.927560</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.329680</td>\n",
              "      <td>0.221199</td>\n",
              "      <td>4.089280</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Wolf ZCU697</th>\n",
              "      <td>0.234072</td>\n",
              "      <td>0.956063</td>\n",
              "      <td>0.372911</td>\n",
              "      <td>0.181269</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>3.833477</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Bear XEA325</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.776870</td>\n",
              "      <td>0.181269</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.221199</td>\n",
              "      <td>3.795453</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>177 rows × 6 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-70f000b1-9d60-4947-8af3-f4253fc81bb1')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "\n",
              "\n",
              "\n",
              "    <div id=\"df-2ac414a7-e889-407b-af63-f9c088448524\">\n",
              "      <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-2ac414a7-e889-407b-af63-f9c088448524')\"\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",
              "    </div>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\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-quickchart: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",
              "  [theme=dark] .colab-df-quickchart {\n",
              "    background-color: #3B4455;\n",
              "    fill: #D2E3FC;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart: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",
              "      async function quickchart(key) {\n",
              "        const containerElement = document.querySelector('#' + key);\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      }\n",
              "    </script>\n",
              "\n",
              "      <script>\n",
              "\n",
              "function displayQuickchartButton(domScope) {\n",
              "  let quickchartButtonEl =\n",
              "    domScope.querySelector('#df-2ac414a7-e889-407b-af63-f9c088448524 button.colab-df-quickchart');\n",
              "  quickchartButtonEl.style.display =\n",
              "    google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "}\n",
              "\n",
              "        displayQuickchartButton(document);\n",
              "      </script>\n",
              "      <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-70f000b1-9d60-4947-8af3-f4253fc81bb1 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-70f000b1-9d60-4947-8af3-f4253fc81bb1');\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",
              "  </div>\n"
            ]
          },
          "metadata": {},
          "execution_count": 24
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "l = list(df_n.sort_values(by = ['SUM'], ascending = False).iloc[0:3].index)"
      ],
      "metadata": {
        "id": "M0WPKmZIIheb"
      },
      "execution_count": 27,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "print(', '.join(l))"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "qOIzOiNJjoOj",
        "outputId": "d3cfc653-38d4-48bd-ce41-deff4b9dbe22"
      },
      "execution_count": 28,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Bear AYR452, Worx XXK993, Cooper LZN757\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "'wow' + ' ' + 'wow' * 5"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        },
        "id": "Kn3J5KCuIMbx",
        "outputId": "a7204d71-4f1c-439a-c4ec-c48d33b2ce6a"
      },
      "execution_count": 1,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "'wow wowwowwowwowwow'"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            }
          },
          "metadata": {},
          "execution_count": 1
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "13 + (-238) // 7 * 3 % 10"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "pBq84dyIIUaM",
        "outputId": "0cc5df93-72d5-4a06-ebd2-3943d08ad48e"
      },
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "21"
            ]
          },
          "metadata": {},
          "execution_count": 2
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "k = 1\n",
        "s = 0\n",
        "while k <= 15:\n",
        "    s = s + 2 * k\n",
        "    k = k + 1\n",
        "print(s)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "dMVA08wmPKXp",
        "outputId": "7388967b-6add-4348-b073-9f4a7762b309"
      },
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "240\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "s = 0\n",
        "x = 8762\n",
        "while x > 0:\n",
        "    if x % 2 == 0:\n",
        "        s += x % 10\n",
        "    x //= 10\n",
        "print(s)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "bgH1VziYPhaF",
        "outputId": "fd677995-c915-4d39-dc04-fac85d44b021"
      },
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "16\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "A = [0] * 11\n",
        "for i in range(0, 11):\n",
        "  A[i] = i + 1\n",
        "print(' '.join(map(str, A)))"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "_FxZSkxBYuX9",
        "outputId": "2243516a-68e2-48d3-875e-64a76bf6ea01"
      },
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "1 2 3 4 5 6 7 8 9 10 11\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "A = [9, 4, 6, 1, 2, 4, 3, 8, 0, 5]\n",
        "A[1:6:2]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "1LzHXR9zZCe4",
        "outputId": "1dd87043-3e1a-4254-b558-983fc060a46c"
      },
      "execution_count": 1,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[4, 1, 4]"
            ]
          },
          "metadata": {},
          "execution_count": 1
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "D = [1, 2, 5, 9, 2, 7, 8, 2, 6, 6, 0, 2]\n",
        "a = D.count(2)\n",
        "b = D.index(6)\n",
        "print(a + b)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "VPg6n4dnZT0I",
        "outputId": "2d1a2dc3-2b50-4947-9d66-ab2b4ab9ccb9"
      },
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "12\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "M = [34, 765, 1, 45, 9, 83, 22]\n",
        "M.insert(2, 3)\n",
        "M.append(55)\n",
        "M.reverse()\n",
        "print(*M)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "5YRHUiBXZiqZ",
        "outputId": "ddfc0f79-94d9-4120-9703-6c3f2a57424a"
      },
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "55 22 83 9 45 1 3 765 34\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "С = [9, 8, 7, 6, 5, 4, 3]\n",
        "С.pop(0)\n",
        "print(' '.join(map(str, С)))"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "v1hRvMw0Zo3I",
        "outputId": "14b32f51-6db0-4c9e-8363-c9a5468922b8"
      },
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "8 7 6 5 4 3\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "s = 'hello'\n",
        "t = 'world'\n",
        "w = (s + ' ' + t) * 2\n",
        "print(len(w))"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "etNM_08DlICi",
        "outputId": "4cd20542-d4af-41bc-d743-ccd92bf037bd"
      },
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "22\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "s = 'abracadabra'\n",
        "s[1] + s[-4] + s[2:5]"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 35
        },
        "id": "cAa_sO4ulNRf",
        "outputId": "5d9e9f26-ba82-4b13-d404-564c30898fea"
      },
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "'barac'"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            }
          },
          "metadata": {},
          "execution_count": 8
        }
      ]
    }
  ]
}