ML_sample_2.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyNrRsFsHfWbUpFfVQFuYiQ6"
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "-t8kbNv9UJc7"
      },
      "outputs": [],
      "source": [
        "import pandas as pd\n",
        "from sklearn.linear_model import LinearRegression\n",
        "from sklearn.model_selection import train_test_split\n",
        "from sklearn.metrics import mean_squared_error"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df = pd.read_csv ('spendings.csv', sep = \",\")\n",
        "df.head ()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "a33cA2pxVGmv",
        "outputId": "4276a42a-969d-434e-a65c-ecfd30badb3c"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "  Unnamed: 0  RD_July  AT_July  Spend_July  RD_Aug  AT_Aug  Spend_Aug  \\\n",
              "0  chokolate      1.3     18.0       400.0     1.8    16.7      460.0   \n",
              "1  ice-cream      1.3     18.0      1300.0     1.8    16.7     1060.0   \n",
              "2       vino      1.3     18.0       300.0     1.8    16.7      390.0   \n",
              "3        gas      1.3     18.0      1000.0     1.8    16.7     1100.0   \n",
              "4    clothes      1.3     18.0       500.0     1.8    16.7      510.0   \n",
              "\n",
              "   RD_Sept  AT_Sept  Spend_Sept  RD_Oct  AT_Oct  Spend_Oct  \n",
              "0      3.8     15.1       490.0     4.6    13.2      515.0  \n",
              "1      3.8     15.1       540.0     4.6    13.2      130.0  \n",
              "2      3.8     15.1       450.0     4.6    13.2      717.0  \n",
              "3      3.8     15.1      1500.0     4.6    13.2     1900.0  \n",
              "4      3.8     15.1       900.0     4.6    13.2     1900.0  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-297041c3-8a8f-4022-a21b-bcfff5a91b85\">\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>Unnamed: 0</th>\n",
              "      <th>RD_July</th>\n",
              "      <th>AT_July</th>\n",
              "      <th>Spend_July</th>\n",
              "      <th>RD_Aug</th>\n",
              "      <th>AT_Aug</th>\n",
              "      <th>Spend_Aug</th>\n",
              "      <th>RD_Sept</th>\n",
              "      <th>AT_Sept</th>\n",
              "      <th>Spend_Sept</th>\n",
              "      <th>RD_Oct</th>\n",
              "      <th>AT_Oct</th>\n",
              "      <th>Spend_Oct</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>chokolate</td>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>400.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>16.7</td>\n",
              "      <td>460.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>490.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>13.2</td>\n",
              "      <td>515.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>ice-cream</td>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>1300.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>16.7</td>\n",
              "      <td>1060.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>540.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>13.2</td>\n",
              "      <td>130.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>vino</td>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>16.7</td>\n",
              "      <td>390.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>450.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>13.2</td>\n",
              "      <td>717.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>gas</td>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>1000.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>16.7</td>\n",
              "      <td>1100.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>1500.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>13.2</td>\n",
              "      <td>1900.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>clothes</td>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>16.7</td>\n",
              "      <td>510.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>900.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>13.2</td>\n",
              "      <td>1900.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-297041c3-8a8f-4022-a21b-bcfff5a91b85')\"\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",
              "  <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-297041c3-8a8f-4022-a21b-bcfff5a91b85 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-297041c3-8a8f-4022-a21b-bcfff5a91b85');\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": [
        "Собраны данные за 4 месяца. Объектами являются позиции по вертикали: шоколад, мороженое, вино и т.д. Они имеют ряд признаков: \n",
        "RD_July = rainy days july = среднее количество дождливых дней в июле и по аналогии в остальные месяцы \n",
        "AT_July = average temperature = средняя температура в данном месяц;\n",
        "Spendings = траты.\n",
        "\n",
        "Цель: построить прогноз по тратам на Октябрь с помощью метода Регрессии и сравнить с фактическими данными.\n"
      ],
      "metadata": {
        "id": "Y7UWkjORWSF7"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df.info ()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "HJO1OlhzYcMQ",
        "outputId": "e39c5ec6-5ceb-4769-851e-1b93ce3e90eb"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "<class 'pandas.core.frame.DataFrame'>\n",
            "RangeIndex: 8 entries, 0 to 7\n",
            "Data columns (total 13 columns):\n",
            " #   Column      Non-Null Count  Dtype  \n",
            "---  ------      --------------  -----  \n",
            " 0   Unnamed: 0  8 non-null      object \n",
            " 1   RD_July     8 non-null      float64\n",
            " 2   AT_July     8 non-null      float64\n",
            " 3   Spend_July  8 non-null      float64\n",
            " 4   RD_Aug      8 non-null      float64\n",
            " 5   AT_Aug      8 non-null      float64\n",
            " 6   Spend_Aug   8 non-null      float64\n",
            " 7   RD_Sept     8 non-null      float64\n",
            " 8   AT_Sept     8 non-null      float64\n",
            " 9   Spend_Sept  8 non-null      float64\n",
            " 10  RD_Oct      8 non-null      float64\n",
            " 11  AT_Oct      8 non-null      float64\n",
            " 12  Spend_Oct   8 non-null      float64\n",
            "dtypes: float64(12), object(1)\n",
            "memory usage: 960.0+ bytes\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.describe ()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 301
        },
        "id": "yQc8hWT3rHS_",
        "outputId": "394847f3-086d-450b-add7-829b98a1a7b5"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "       RD_July  AT_July   Spend_July        RD_Aug  AT_Aug    Spend_Aug  \\\n",
              "count      8.0      8.0     8.000000  8.000000e+00     8.0     8.000000   \n",
              "mean       1.3     18.0   600.000000  1.800000e+00    16.7   604.750000   \n",
              "std        0.0      0.0   440.778532  2.373757e-16     0.0   396.944311   \n",
              "min        1.3     18.0   100.000000  1.800000e+00    16.7   102.000000   \n",
              "25%        1.3     18.0   275.000000  1.800000e+00    16.7   344.250000   \n",
              "50%        1.3     18.0   450.000000  1.800000e+00    16.7   485.000000   \n",
              "75%        1.3     18.0  1000.000000  1.800000e+00    16.7  1021.750000   \n",
              "max        1.3     18.0  1300.000000  1.800000e+00    16.7  1100.000000   \n",
              "\n",
              "            RD_Sept       AT_Sept   Spend_Sept        RD_Oct        AT_Oct  \\\n",
              "count  8.000000e+00  8.000000e+00     8.000000  8.000000e+00  8.000000e+00   \n",
              "mean   3.800000e+00  1.510000e+01   704.750000  4.600000e+00  1.320000e+01   \n",
              "std    4.747513e-16  1.899005e-15   453.964048  9.495027e-16  1.899005e-15   \n",
              "min    3.800000e+00  1.510000e+01   200.000000  4.600000e+00  1.320000e+01   \n",
              "25%    3.800000e+00  1.510000e+01   425.000000  4.600000e+00  1.320000e+01   \n",
              "50%    3.800000e+00  1.510000e+01   515.000000  4.600000e+00  1.320000e+01   \n",
              "75%    3.800000e+00  1.510000e+01   977.000000  4.600000e+00  1.320000e+01   \n",
              "max    3.800000e+00  1.510000e+01  1500.000000  4.600000e+00  1.320000e+01   \n",
              "\n",
              "         Spend_Oct  \n",
              "count     8.000000  \n",
              "mean    998.125000  \n",
              "std     696.319803  \n",
              "min     130.000000  \n",
              "25%     514.000000  \n",
              "50%     709.000000  \n",
              "75%    1683.250000  \n",
              "max    1900.000000  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-87362bea-ffaf-47b4-a386-722bbdcdcd0b\">\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>RD_July</th>\n",
              "      <th>AT_July</th>\n",
              "      <th>Spend_July</th>\n",
              "      <th>RD_Aug</th>\n",
              "      <th>AT_Aug</th>\n",
              "      <th>Spend_Aug</th>\n",
              "      <th>RD_Sept</th>\n",
              "      <th>AT_Sept</th>\n",
              "      <th>Spend_Sept</th>\n",
              "      <th>RD_Oct</th>\n",
              "      <th>AT_Oct</th>\n",
              "      <th>Spend_Oct</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>8.0</td>\n",
              "      <td>8.0</td>\n",
              "      <td>8.000000</td>\n",
              "      <td>8.000000e+00</td>\n",
              "      <td>8.0</td>\n",
              "      <td>8.000000</td>\n",
              "      <td>8.000000e+00</td>\n",
              "      <td>8.000000e+00</td>\n",
              "      <td>8.000000</td>\n",
              "      <td>8.000000e+00</td>\n",
              "      <td>8.000000e+00</td>\n",
              "      <td>8.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>mean</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>600.000000</td>\n",
              "      <td>1.800000e+00</td>\n",
              "      <td>16.7</td>\n",
              "      <td>604.750000</td>\n",
              "      <td>3.800000e+00</td>\n",
              "      <td>1.510000e+01</td>\n",
              "      <td>704.750000</td>\n",
              "      <td>4.600000e+00</td>\n",
              "      <td>1.320000e+01</td>\n",
              "      <td>998.125000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>std</th>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>440.778532</td>\n",
              "      <td>2.373757e-16</td>\n",
              "      <td>0.0</td>\n",
              "      <td>396.944311</td>\n",
              "      <td>4.747513e-16</td>\n",
              "      <td>1.899005e-15</td>\n",
              "      <td>453.964048</td>\n",
              "      <td>9.495027e-16</td>\n",
              "      <td>1.899005e-15</td>\n",
              "      <td>696.319803</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>min</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>100.000000</td>\n",
              "      <td>1.800000e+00</td>\n",
              "      <td>16.7</td>\n",
              "      <td>102.000000</td>\n",
              "      <td>3.800000e+00</td>\n",
              "      <td>1.510000e+01</td>\n",
              "      <td>200.000000</td>\n",
              "      <td>4.600000e+00</td>\n",
              "      <td>1.320000e+01</td>\n",
              "      <td>130.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25%</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>275.000000</td>\n",
              "      <td>1.800000e+00</td>\n",
              "      <td>16.7</td>\n",
              "      <td>344.250000</td>\n",
              "      <td>3.800000e+00</td>\n",
              "      <td>1.510000e+01</td>\n",
              "      <td>425.000000</td>\n",
              "      <td>4.600000e+00</td>\n",
              "      <td>1.320000e+01</td>\n",
              "      <td>514.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50%</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>450.000000</td>\n",
              "      <td>1.800000e+00</td>\n",
              "      <td>16.7</td>\n",
              "      <td>485.000000</td>\n",
              "      <td>3.800000e+00</td>\n",
              "      <td>1.510000e+01</td>\n",
              "      <td>515.000000</td>\n",
              "      <td>4.600000e+00</td>\n",
              "      <td>1.320000e+01</td>\n",
              "      <td>709.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75%</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>1000.000000</td>\n",
              "      <td>1.800000e+00</td>\n",
              "      <td>16.7</td>\n",
              "      <td>1021.750000</td>\n",
              "      <td>3.800000e+00</td>\n",
              "      <td>1.510000e+01</td>\n",
              "      <td>977.000000</td>\n",
              "      <td>4.600000e+00</td>\n",
              "      <td>1.320000e+01</td>\n",
              "      <td>1683.250000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>max</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>1300.000000</td>\n",
              "      <td>1.800000e+00</td>\n",
              "      <td>16.7</td>\n",
              "      <td>1100.000000</td>\n",
              "      <td>3.800000e+00</td>\n",
              "      <td>1.510000e+01</td>\n",
              "      <td>1500.000000</td>\n",
              "      <td>4.600000e+00</td>\n",
              "      <td>1.320000e+01</td>\n",
              "      <td>1900.000000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-87362bea-ffaf-47b4-a386-722bbdcdcd0b')\"\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",
              "  <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-87362bea-ffaf-47b4-a386-722bbdcdcd0b 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-87362bea-ffaf-47b4-a386-722bbdcdcd0b');\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": 39
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.columns"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "oolYjO3Gbw_Z",
        "outputId": "94239786-dd2a-46ed-8311-d880ff76b8dd"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['Unnamed: 0', 'RD_July', 'AT_July', 'Spend_July', 'RD_Aug', 'AT_Aug',\n",
              "       'Spend_Aug', 'RD_Sept', 'AT_Sept', 'Spend_Sept', 'RD_Oct', 'AT_Oct',\n",
              "       'Spend_Oct'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {},
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "## формируем признаки и целевую переменную\n",
        "\n",
        "X = df [['RD_July', 'AT_July', 'Spend_July', 'RD_Aug', 'AT_Aug',\n",
        "       'Spend_Aug', 'RD_Sept', 'AT_Sept', 'Spend_Sept', 'RD_Oct', 'AT_Oct',]]\n",
        "\n",
        "y = df ['Spend_Oct']\n"
      ],
      "metadata": {
        "id": "IA-JGALtcOCD"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "X"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 301
        },
        "id": "p3LvAV19duu6",
        "outputId": "f1a8c43c-d4e1-42a7-e1b2-43ef9e71ff9e"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   RD_July  AT_July  Spend_July  RD_Aug  AT_Aug  Spend_Aug  RD_Sept  AT_Sept  \\\n",
              "0      1.3     18.0       400.0     1.8    16.7      460.0      3.8     15.1   \n",
              "1      1.3     18.0      1300.0     1.8    16.7     1060.0      3.8     15.1   \n",
              "2      1.3     18.0       300.0     1.8    16.7      390.0      3.8     15.1   \n",
              "3      1.3     18.0      1000.0     1.8    16.7     1100.0      3.8     15.1   \n",
              "4      1.3     18.0       500.0     1.8    16.7      510.0      3.8     15.1   \n",
              "5      1.3     18.0       100.0     1.8    16.7      102.0      3.8     15.1   \n",
              "6      1.3     18.0      1000.0     1.8    16.7     1009.0      3.8     15.1   \n",
              "7      1.3     18.0       200.0     1.8    16.7      207.0      3.8     15.1   \n",
              "\n",
              "   Spend_Sept  RD_Oct  AT_Oct  \n",
              "0       490.0     4.6    13.2  \n",
              "1       540.0     4.6    13.2  \n",
              "2       450.0     4.6    13.2  \n",
              "3      1500.0     4.6    13.2  \n",
              "4       900.0     4.6    13.2  \n",
              "5       200.0     4.6    13.2  \n",
              "6      1208.0     4.6    13.2  \n",
              "7       350.0     4.6    13.2  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-95cd8535-e66b-4fe4-9703-4c3a2fcf2ba9\">\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>RD_July</th>\n",
              "      <th>AT_July</th>\n",
              "      <th>Spend_July</th>\n",
              "      <th>RD_Aug</th>\n",
              "      <th>AT_Aug</th>\n",
              "      <th>Spend_Aug</th>\n",
              "      <th>RD_Sept</th>\n",
              "      <th>AT_Sept</th>\n",
              "      <th>Spend_Sept</th>\n",
              "      <th>RD_Oct</th>\n",
              "      <th>AT_Oct</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>400.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>16.7</td>\n",
              "      <td>460.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>490.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>13.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>1300.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>16.7</td>\n",
              "      <td>1060.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>540.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>13.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>16.7</td>\n",
              "      <td>390.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>450.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>13.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>1000.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>16.7</td>\n",
              "      <td>1100.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>1500.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>13.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>16.7</td>\n",
              "      <td>510.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>900.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>13.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>16.7</td>\n",
              "      <td>102.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>200.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>13.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>1000.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>16.7</td>\n",
              "      <td>1009.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>1208.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>13.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>200.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>16.7</td>\n",
              "      <td>207.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>350.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>13.2</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-95cd8535-e66b-4fe4-9703-4c3a2fcf2ba9')\"\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",
              "  <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-95cd8535-e66b-4fe4-9703-4c3a2fcf2ba9 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-95cd8535-e66b-4fe4-9703-4c3a2fcf2ba9');\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": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "y"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ernvB8F-eFoK",
        "outputId": "0236d4a3-ee93-48d1-9fb6-4620976b606a"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0     515.0\n",
              "1     130.0\n",
              "2     717.0\n",
              "3    1900.0\n",
              "4    1900.0\n",
              "5     511.0\n",
              "6    1611.0\n",
              "7     701.0\n",
              "Name: Spend_Oct, dtype: float64"
            ]
          },
          "metadata": {},
          "execution_count": 18
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "X_train, X_test, y_train, y_test = train_test_split (X, y, test_size = 0.3) ##раздел данных на выборки для проверки и обучения"
      ],
      "metadata": {
        "id": "ITpUDozTeXo6"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "X_train"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "id": "WITqRqfUm_Zt",
        "outputId": "ef098b53-055d-4e1b-dcdc-6858b417a5a1"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   RD_July  AT_July  Spend_July  RD_Aug  AT_Aug  Spend_Aug  RD_Sept  AT_Sept  \\\n",
              "5      1.3     18.0       100.0     1.8    16.7      102.0      3.8     15.1   \n",
              "0      1.3     18.0       400.0     1.8    16.7      460.0      3.8     15.1   \n",
              "6      1.3     18.0      1000.0     1.8    16.7     1009.0      3.8     15.1   \n",
              "7      1.3     18.0       200.0     1.8    16.7      207.0      3.8     15.1   \n",
              "4      1.3     18.0       500.0     1.8    16.7      510.0      3.8     15.1   \n",
              "\n",
              "   Spend_Sept  RD_Oct  AT_Oct  \n",
              "5       200.0     4.6    13.2  \n",
              "0       490.0     4.6    13.2  \n",
              "6      1208.0     4.6    13.2  \n",
              "7       350.0     4.6    13.2  \n",
              "4       900.0     4.6    13.2  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-57151ce8-24fc-402a-8987-f13482b49b88\">\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>RD_July</th>\n",
              "      <th>AT_July</th>\n",
              "      <th>Spend_July</th>\n",
              "      <th>RD_Aug</th>\n",
              "      <th>AT_Aug</th>\n",
              "      <th>Spend_Aug</th>\n",
              "      <th>RD_Sept</th>\n",
              "      <th>AT_Sept</th>\n",
              "      <th>Spend_Sept</th>\n",
              "      <th>RD_Oct</th>\n",
              "      <th>AT_Oct</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>100.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>16.7</td>\n",
              "      <td>102.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>200.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>13.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>400.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>16.7</td>\n",
              "      <td>460.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>490.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>13.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>1000.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>16.7</td>\n",
              "      <td>1009.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>1208.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>13.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>200.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>16.7</td>\n",
              "      <td>207.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>350.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>13.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>500.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>16.7</td>\n",
              "      <td>510.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>900.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>13.2</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-57151ce8-24fc-402a-8987-f13482b49b88')\"\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",
              "  <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-57151ce8-24fc-402a-8987-f13482b49b88 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-57151ce8-24fc-402a-8987-f13482b49b88');\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": 41
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "y_train"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "m7bShCaenD_1",
        "outputId": "44990532-9fcb-49f5-cbb5-cf4bc9d81511"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "5     511.0\n",
              "0     515.0\n",
              "6    1611.0\n",
              "7     701.0\n",
              "4    1900.0\n",
              "Name: Spend_Oct, dtype: float64"
            ]
          },
          "metadata": {},
          "execution_count": 42
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "X_test"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 144
        },
        "id": "SEA_tad9nL37",
        "outputId": "024856e2-d4c6-475d-ebd7-800b96e93c36"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   RD_July  AT_July  Spend_July  RD_Aug  AT_Aug  Spend_Aug  RD_Sept  AT_Sept  \\\n",
              "2      1.3     18.0       300.0     1.8    16.7      390.0      3.8     15.1   \n",
              "3      1.3     18.0      1000.0     1.8    16.7     1100.0      3.8     15.1   \n",
              "1      1.3     18.0      1300.0     1.8    16.7     1060.0      3.8     15.1   \n",
              "\n",
              "   Spend_Sept  RD_Oct  AT_Oct  \n",
              "2       450.0     4.6    13.2  \n",
              "3      1500.0     4.6    13.2  \n",
              "1       540.0     4.6    13.2  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-ffafc6dc-105a-4f83-8bea-8111ed23822d\">\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>RD_July</th>\n",
              "      <th>AT_July</th>\n",
              "      <th>Spend_July</th>\n",
              "      <th>RD_Aug</th>\n",
              "      <th>AT_Aug</th>\n",
              "      <th>Spend_Aug</th>\n",
              "      <th>RD_Sept</th>\n",
              "      <th>AT_Sept</th>\n",
              "      <th>Spend_Sept</th>\n",
              "      <th>RD_Oct</th>\n",
              "      <th>AT_Oct</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>300.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>16.7</td>\n",
              "      <td>390.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>450.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>13.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>1000.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>16.7</td>\n",
              "      <td>1100.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>1500.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>13.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1.3</td>\n",
              "      <td>18.0</td>\n",
              "      <td>1300.0</td>\n",
              "      <td>1.8</td>\n",
              "      <td>16.7</td>\n",
              "      <td>1060.0</td>\n",
              "      <td>3.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>540.0</td>\n",
              "      <td>4.6</td>\n",
              "      <td>13.2</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-ffafc6dc-105a-4f83-8bea-8111ed23822d')\"\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",
              "  <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-ffafc6dc-105a-4f83-8bea-8111ed23822d 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-ffafc6dc-105a-4f83-8bea-8111ed23822d');\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": 43
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "y_test"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "JtYGkm1wnPQC",
        "outputId": "c9628a05-2c75-4e28-a6b6-0212376566fb"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "2     717.0\n",
              "3    1900.0\n",
              "1     130.0\n",
              "Name: Spend_Oct, dtype: float64"
            ]
          },
          "metadata": {},
          "execution_count": 44
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "## создание и обучение модели\n",
        "\n",
        "lr = LinearRegression ()"
      ],
      "metadata": {
        "id": "2AdAgEZBnojC"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "lr.fit (X_train, y_train)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "gjml7xLYoE6T",
        "outputId": "0e0abac6-d139-49ce-afb3-85eec8c92244"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "LinearRegression()"
            ]
          },
          "metadata": {},
          "execution_count": 46
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "lr.coef_"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ep7D04Stoole",
        "outputId": "922ca96c-b2ec-4a1f-90e5-cf72bf5e6548"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array([-9.65894031e-15,  0.00000000e+00,  3.65362689e-01,  0.00000000e+00,\n",
              "        0.00000000e+00, -3.20100801e+00,  0.00000000e+00,  0.00000000e+00,\n",
              "        3.67079585e+00,  0.00000000e+00,  0.00000000e+00])"
            ]
          },
          "metadata": {},
          "execution_count": 47
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "## prediction\n",
        "\n",
        "lr.predict (X_test)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "z5GDwYbYo6x6",
        "outputId": "45eb738c-6259-43bc-aeda-89e8083de20d"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array([ 553.56243032, 2390.93626843, -895.37862016])"
            ]
          },
          "metadata": {},
          "execution_count": 48
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "## сравнить значения \"на глаз\"\n",
        "\n",
        "pd.DataFrame([y_test.values, lr.predict(X_test)]).T"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 144
        },
        "id": "p71IzXc4phvN",
        "outputId": "05f874cd-2906-4beb-f6cd-d769ce12ea6e"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "        0            1\n",
              "0   717.0   553.562430\n",
              "1  1900.0  2390.936268\n",
              "2   130.0  -895.378620"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-4c7fdbd3-f846-4a25-b555-7223ec893ee9\">\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>0</th>\n",
              "      <th>1</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>717.0</td>\n",
              "      <td>553.562430</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1900.0</td>\n",
              "      <td>2390.936268</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>130.0</td>\n",
              "      <td>-895.378620</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-4c7fdbd3-f846-4a25-b555-7223ec893ee9')\"\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",
              "  <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-4c7fdbd3-f846-4a25-b555-7223ec893ee9 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-4c7fdbd3-f846-4a25-b555-7223ec893ee9');\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": 49
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "mean_squared_error(y_test, lr.predict(X_test))"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Drt7hVfHqEmi",
        "outputId": "0bdbaed5-d217-4614-9936-49dbbf390f22"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "439710.52450855536"
            ]
          },
          "metadata": {},
          "execution_count": 50
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "mean_squared_error(y_train, lr.predict(X_train))"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "QlDDJlSXqHIJ",
        "outputId": "5c3fff15-602f-4766-a9b4-e73d7ac751b6"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "387.1180718634258"
            ]
          },
          "metadata": {},
          "execution_count": 51
        }
      ]
    }
  ]
}