module2_dynamic.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "module2_dynamic.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "mount_file_id": "1f1z7r2TeOqSNuNig9BR6i-TIgldYiAX1",
      "authorship_tag": "ABX9TyMbGsn27rWdCS60lT4JYrM+",
      "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/alexeynick/msu_oil_gas/blob/main/module2_dynamic.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "YgC4ByQPbYRi"
      },
      "source": [
        "## Задачи модуля №2. Определение стадий разработки"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "_bqSLDYgNWmV"
      },
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n",
        "import io\n",
        "\n",
        "import plotly.express as px\n",
        "import plotly.graph_objects as go\n",
        "from plotly.graph_objs import *\n",
        "import matplotlib.pyplot as plt \n",
        "\n",
        "from sklearn.impute import KNNImputer"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "67_glmQ9xubb"
      },
      "source": [
        "#from google.colab import drive\n",
        "#drive.mount('/content/gdrive')"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "WmulQ1ftxGgh"
      },
      "source": [
        "#df_object3 = pd.read_csv('/content/sample_data/mnist_test.csv')"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "T-Q-RIBTQBm9"
      },
      "source": [
        "#df_object3 = pd.read_csv(io.StringIO(uploaded['dynamic_object_3.csv'].decode('utf-8')))"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "jMxmxP24w4C9"
      },
      "source": [
        "#df_object3 = pd.read_csv('/content/drive/MyDrive/Colab Notebooks/dynamic_object_3.csv')"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "kqrkmp5m_Sgl"
      },
      "source": [
        "anno_font = dict(\n",
        "        family=\"arial bold\",\n",
        "        size=36,\n",
        "        color=\"Black\"\n",
        "    )"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "EiqbhF4CzGm1"
      },
      "source": [
        "## Объект #1"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 379
        },
        "id": "nde7cA00zLkK",
        "outputId": "8f20f6ff-8b3a-44a4-a575-63d73e6b6532"
      },
      "source": [
        "df_object1 = pd.read_csv('https://raw.githubusercontent.com/alexeynick/msu_oil_gas/main/datasets/dynamic_object_1.csv')\n",
        "df_object1.tail(10)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>year</th>\n",
              "      <th>well_production</th>\n",
              "      <th>well_common</th>\n",
              "      <th>oil_year</th>\n",
              "      <th>water_year</th>\n",
              "      <th>fluid_year</th>\n",
              "      <th>water_cut</th>\n",
              "      <th>oil_day</th>\n",
              "      <th>fluid_day</th>\n",
              "      <th>oil_total</th>\n",
              "      <th>water_total</th>\n",
              "      <th>fluid_total</th>\n",
              "      <th>kin</th>\n",
              "      <th>production_frac_total</th>\n",
              "      <th>production_frac</th>\n",
              "      <th>production_frac_rem</th>\n",
              "      <th>gas_total</th>\n",
              "      <th>well_injection</th>\n",
              "      <th>inject_year</th>\n",
              "      <th>inject_total</th>\n",
              "      <th>inject_comp_year</th>\n",
              "      <th>inject_comp_total</th>\n",
              "      <th>inject_response</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>2000</td>\n",
              "      <td>84</td>\n",
              "      <td>2</td>\n",
              "      <td>68.571</td>\n",
              "      <td>144.777</td>\n",
              "      <td>213.348</td>\n",
              "      <td>67.9</td>\n",
              "      <td>2.6</td>\n",
              "      <td>7.9</td>\n",
              "      <td>4068.492</td>\n",
              "      <td>4472.856</td>\n",
              "      <td>8541.348</td>\n",
              "      <td>0.164</td>\n",
              "      <td>51.3</td>\n",
              "      <td>0.9</td>\n",
              "      <td>1.8</td>\n",
              "      <td>60.9</td>\n",
              "      <td>8</td>\n",
              "      <td>314.882</td>\n",
              "      <td>17577.974</td>\n",
              "      <td>149.1</td>\n",
              "      <td>198.2</td>\n",
              "      <td>158.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>2001</td>\n",
              "      <td>94</td>\n",
              "      <td>2</td>\n",
              "      <td>68.195</td>\n",
              "      <td>137.851</td>\n",
              "      <td>206.046</td>\n",
              "      <td>66.9</td>\n",
              "      <td>2.2</td>\n",
              "      <td>6.5</td>\n",
              "      <td>4136.687</td>\n",
              "      <td>4610.707</td>\n",
              "      <td>8747.394</td>\n",
              "      <td>0.166</td>\n",
              "      <td>52.1</td>\n",
              "      <td>0.9</td>\n",
              "      <td>1.8</td>\n",
              "      <td>59.9</td>\n",
              "      <td>10</td>\n",
              "      <td>290.768</td>\n",
              "      <td>17868.742</td>\n",
              "      <td>142.1</td>\n",
              "      <td>196.9</td>\n",
              "      <td>132.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>2002</td>\n",
              "      <td>90</td>\n",
              "      <td>2</td>\n",
              "      <td>66.201</td>\n",
              "      <td>123.351</td>\n",
              "      <td>189.552</td>\n",
              "      <td>65.1</td>\n",
              "      <td>2.1</td>\n",
              "      <td>6.0</td>\n",
              "      <td>4202.888</td>\n",
              "      <td>4734.058</td>\n",
              "      <td>8936.946</td>\n",
              "      <td>0.169</td>\n",
              "      <td>53.0</td>\n",
              "      <td>0.8</td>\n",
              "      <td>1.8</td>\n",
              "      <td>57.9</td>\n",
              "      <td>8</td>\n",
              "      <td>319.026</td>\n",
              "      <td>18187.768</td>\n",
              "      <td>168.5</td>\n",
              "      <td>196.3</td>\n",
              "      <td>143.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>2003</td>\n",
              "      <td>84</td>\n",
              "      <td>1</td>\n",
              "      <td>66.001</td>\n",
              "      <td>111.688</td>\n",
              "      <td>177.689</td>\n",
              "      <td>62.9</td>\n",
              "      <td>2.2</td>\n",
              "      <td>6.0</td>\n",
              "      <td>4268.889</td>\n",
              "      <td>4845.746</td>\n",
              "      <td>9114.635</td>\n",
              "      <td>0.172</td>\n",
              "      <td>53.8</td>\n",
              "      <td>0.8</td>\n",
              "      <td>1.8</td>\n",
              "      <td>55.6</td>\n",
              "      <td>9</td>\n",
              "      <td>365.000</td>\n",
              "      <td>18552.768</td>\n",
              "      <td>204.3</td>\n",
              "      <td>196.5</td>\n",
              "      <td>123.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>2004</td>\n",
              "      <td>81</td>\n",
              "      <td>1</td>\n",
              "      <td>69.041</td>\n",
              "      <td>97.322</td>\n",
              "      <td>166.363</td>\n",
              "      <td>58.5</td>\n",
              "      <td>2.7</td>\n",
              "      <td>6.4</td>\n",
              "      <td>4337.930</td>\n",
              "      <td>4943.068</td>\n",
              "      <td>9280.998</td>\n",
              "      <td>0.174</td>\n",
              "      <td>54.7</td>\n",
              "      <td>0.9</td>\n",
              "      <td>1.9</td>\n",
              "      <td>51.0</td>\n",
              "      <td>12</td>\n",
              "      <td>363.301</td>\n",
              "      <td>18916.069</td>\n",
              "      <td>214.2</td>\n",
              "      <td>196.8</td>\n",
              "      <td>97.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>2005</td>\n",
              "      <td>76</td>\n",
              "      <td>1</td>\n",
              "      <td>71.848</td>\n",
              "      <td>80.698</td>\n",
              "      <td>152.546</td>\n",
              "      <td>52.9</td>\n",
              "      <td>3.0</td>\n",
              "      <td>6.3</td>\n",
              "      <td>4409.778</td>\n",
              "      <td>5023.766</td>\n",
              "      <td>9433.544</td>\n",
              "      <td>0.177</td>\n",
              "      <td>55.6</td>\n",
              "      <td>0.9</td>\n",
              "      <td>2.0</td>\n",
              "      <td>45.3</td>\n",
              "      <td>11</td>\n",
              "      <td>345.936</td>\n",
              "      <td>19262.005</td>\n",
              "      <td>218.7</td>\n",
              "      <td>197.1</td>\n",
              "      <td>105.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>2006</td>\n",
              "      <td>75</td>\n",
              "      <td>1</td>\n",
              "      <td>71.147</td>\n",
              "      <td>80.817</td>\n",
              "      <td>151.964</td>\n",
              "      <td>53.2</td>\n",
              "      <td>3.0</td>\n",
              "      <td>6.5</td>\n",
              "      <td>4480.925</td>\n",
              "      <td>5104.583</td>\n",
              "      <td>9585.508</td>\n",
              "      <td>0.180</td>\n",
              "      <td>56.5</td>\n",
              "      <td>0.9</td>\n",
              "      <td>2.1</td>\n",
              "      <td>45.6</td>\n",
              "      <td>8</td>\n",
              "      <td>294.087</td>\n",
              "      <td>19556.092</td>\n",
              "      <td>186.8</td>\n",
              "      <td>197.0</td>\n",
              "      <td>100.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>2007</td>\n",
              "      <td>76</td>\n",
              "      <td>1</td>\n",
              "      <td>81.084</td>\n",
              "      <td>70.893</td>\n",
              "      <td>151.977</td>\n",
              "      <td>46.6</td>\n",
              "      <td>3.6</td>\n",
              "      <td>6.7</td>\n",
              "      <td>4562.010</td>\n",
              "      <td>5175.476</td>\n",
              "      <td>9737.486</td>\n",
              "      <td>0.183</td>\n",
              "      <td>57.5</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.4</td>\n",
              "      <td>39.2</td>\n",
              "      <td>10</td>\n",
              "      <td>176.191</td>\n",
              "      <td>19732.283</td>\n",
              "      <td>109.7</td>\n",
              "      <td>195.6</td>\n",
              "      <td>67.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>2008</td>\n",
              "      <td>75</td>\n",
              "      <td>1</td>\n",
              "      <td>78.838</td>\n",
              "      <td>73.870</td>\n",
              "      <td>152.708</td>\n",
              "      <td>48.4</td>\n",
              "      <td>3.4</td>\n",
              "      <td>6.6</td>\n",
              "      <td>4640.847</td>\n",
              "      <td>5249.346</td>\n",
              "      <td>9890.193</td>\n",
              "      <td>0.187</td>\n",
              "      <td>58.5</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.4</td>\n",
              "      <td>40.9</td>\n",
              "      <td>9</td>\n",
              "      <td>172.868</td>\n",
              "      <td>19905.151</td>\n",
              "      <td>107.7</td>\n",
              "      <td>194.2</td>\n",
              "      <td>61.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>2009</td>\n",
              "      <td>75</td>\n",
              "      <td>1</td>\n",
              "      <td>83.066</td>\n",
              "      <td>81.232</td>\n",
              "      <td>164.298</td>\n",
              "      <td>49.4</td>\n",
              "      <td>3.4</td>\n",
              "      <td>6.8</td>\n",
              "      <td>4723.913</td>\n",
              "      <td>5330.578</td>\n",
              "      <td>10054.491</td>\n",
              "      <td>0.190</td>\n",
              "      <td>59.5</td>\n",
              "      <td>1.0</td>\n",
              "      <td>2.6</td>\n",
              "      <td>NaN</td>\n",
              "      <td>18</td>\n",
              "      <td>171.870</td>\n",
              "      <td>20077.021</td>\n",
              "      <td>99.1</td>\n",
              "      <td>190.0</td>\n",
              "      <td>42.8</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "    year  well_production  ...  inject_comp_total  inject_response\n",
              "34  2000               84  ...              198.2            158.9\n",
              "35  2001               94  ...              196.9            132.3\n",
              "36  2002               90  ...              196.3            143.1\n",
              "37  2003               84  ...              196.5            123.0\n",
              "38  2004               81  ...              196.8             97.2\n",
              "39  2005               76  ...              197.1            105.2\n",
              "40  2006               75  ...              197.0            100.5\n",
              "41  2007               76  ...              195.6             67.1\n",
              "42  2008               75  ...              194.2             61.8\n",
              "43  2009               75  ...              190.0             42.8\n",
              "\n",
              "[10 rows x 23 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 817
        },
        "id": "LOY3hnop1OTL",
        "outputId": "1f2dfbc5-ffa6-49bf-e752-83317edbc6f9"
      },
      "source": [
        "df_data = df_object1\n",
        "years = df_data['year']\n",
        "\n",
        "fig = go.Figure()\n",
        "\n",
        "fig.add_trace(go.Bar(x=years,\n",
        "                y=df_data['well_production'],\n",
        "                name='Действующий фонд <br>добывающих скважин',\n",
        "                marker_color='yellowgreen',\n",
        "                opacity=0.7\n",
        "                ))\n",
        "\n",
        "fig.add_trace(go.Bar(x=years,\n",
        "                y=df_data['well_injection'],\n",
        "                name='Действующий фонд <br>нагнетательных скважин',\n",
        "                marker_color='limegreen',\n",
        "                opacity=0.7\n",
        "                ))\n",
        "\n",
        "fig.add_trace(go.Scatter(x=years, \n",
        "                    y=df_data['oil_year'],\n",
        "                    mode='lines',\n",
        "                    marker_color='blue',\n",
        "                    name='Годовая добыча, млн т',\n",
        "    yaxis=\"y2\"))\n",
        "\n",
        "fig.add_trace(go.Scatter(x=years, \n",
        "                    y=df_data['water_cut'],\n",
        "                    mode='lines',\n",
        "                    marker_color='red',\n",
        "                    name='Обводненность, %',\n",
        "    yaxis=\"y3\"))\n",
        "\n",
        "fig.add_trace(go.Scatter(x=years, \n",
        "                    y=df_data['kin'] * 100,\n",
        "                    mode='lines',\n",
        "                    marker_color='magenta',\n",
        "                    name='КИН текущий, %',\n",
        "    yaxis=\"y4\"))\n",
        "\n",
        "shapes=[]\n",
        "#for year in [1973, 1980, 1990, 2002]:\n",
        "for year in [1973, 1979, 1988]:\n",
        "  shapes.append(\n",
        "      dict(\n",
        "          type= 'line',\n",
        "          yref= 'paper', y0= 0, y1= 1,\n",
        "          xref= 'x', x0= year, x1= year,\n",
        "          line=dict(\n",
        "                      color=\"Black\",\n",
        "                      width=4,\n",
        "                      dash=\"dashdot\",\n",
        "                  )\n",
        "      )\n",
        "  )\n",
        "\n",
        "#fig.add_annotation(x=1977, y=105, text=\"I\", showarrow=False, yshift=10, font=anno_font)\n",
        "#fig.add_annotation(x=1985, y=105, text=\"II\", showarrow=False, yshift=10, font=anno_font)\n",
        "#fig.add_annotation(x=1996, y=105, text=\"III\", showarrow=False, yshift=10, font=anno_font)\n",
        "#fig.add_annotation(x=2006, y=105, text=\"IV\", showarrow=False, yshift=10, font=anno_font)\n",
        "\n",
        "fig.add_annotation(x=1976, y=105, text=\"I\", showarrow=False, yshift=10, font=anno_font)\n",
        "fig.add_annotation(x=1984, y=105, text=\"II\", showarrow=False, yshift=10, font=anno_font)\n",
        "fig.add_annotation(x=1998, y=105, text=\"III\", showarrow=False, yshift=10, font=anno_font)\n",
        "\n",
        "fig.update_layout( \n",
        "    shapes = shapes,\n",
        "    xaxis=dict(\n",
        "        domain=[0.1, 0.9],\n",
        "        #tickmode = 'array',\n",
        "        #tickvals = df_object2['year'],\n",
        "        tickangle=-45,\n",
        "        title='Год',\n",
        "    ),\n",
        "\n",
        "    yaxis=dict(\n",
        "        range=[0, 110],\n",
        "        title=\"Число скажин (шт)\",\n",
        "        titlefont=dict(\n",
        "            color=\"green\"\n",
        "        ),\n",
        "        tickfont=dict(\n",
        "            color=\"green\"\n",
        "        )\n",
        "    ),\n",
        "\n",
        "    yaxis2=dict(\n",
        "        range=[0, 290],\n",
        "        title=\"Годовая добыча, млн т\",\n",
        "        titlefont=dict(\n",
        "            color=\"blue\"\n",
        "        ),\n",
        "        tickfont=dict(\n",
        "            color=\"blue\"\n",
        "        ),\n",
        "        anchor=\"x\",\n",
        "        overlaying=\"y\",\n",
        "        side=\"right\"\n",
        "    ),\n",
        "\n",
        "    yaxis3=dict(\n",
        "        range=[0, 110],\n",
        "        title=\"Обводненность, %\",\n",
        "        titlefont=dict(\n",
        "            color=\"red\"\n",
        "        ),\n",
        "        tickfont=dict(\n",
        "            color=\"red\"\n",
        "        ),\n",
        "        anchor=\"free\",\n",
        "        overlaying=\"y\",\n",
        "        side=\"left\",\n",
        "        position=0.01\n",
        "    ),\n",
        "\n",
        "    yaxis4=dict(\n",
        "        range=[0, 25],\n",
        "        title=\"КИН текущий, %\",\n",
        "        titlefont=dict(\n",
        "            color=\"magenta\"\n",
        "        ),\n",
        "        tickfont=dict(\n",
        "            color=\"magenta\"\n",
        "        ),\n",
        "        anchor=\"free\",\n",
        "        overlaying=\"y\",\n",
        "        side=\"right\",\n",
        "        position=0.99\n",
        "    ),\n",
        "\n",
        "    title={\n",
        "        'text': \"Динамика разработки месторождения Объект 1 (Башкирский ярус)\",\n",
        "        'y':0.95,\n",
        "        'x':0.4,\n",
        "        'xanchor': 'center',\n",
        "        'yanchor': 'top'},\n",
        "\n",
        "    autosize=False,\n",
        "    width=1300,\n",
        "    height=800)\n",
        "\n",
        "fig.show()\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<html>\n",
              "<head><meta charset=\"utf-8\" /></head>\n",
              "<body>\n",
              "    <div>\n",
              "            <script src=\"https://cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.5/MathJax.js?config=TeX-AMS-MML_SVG\"></script><script type=\"text/javascript\">if (window.MathJax) {MathJax.Hub.Config({SVG: {font: \"STIX-Web\"}});}</script>\n",
              "                <script type=\"text/javascript\">window.PlotlyConfig = {MathJaxConfig: 'local'};</script>\n",
              "        <script src=\"https://cdn.plot.ly/plotly-latest.min.js\"></script>    \n",
              "            <div id=\"b31fe230-32c7-4252-a51a-6744d92237f2\" class=\"plotly-graph-div\" style=\"height:800px; width:1300px;\"></div>\n",
              "            <script type=\"text/javascript\">\n",
              "                \n",
              "                    window.PLOTLYENV=window.PLOTLYENV || {};\n",
              "                    \n",
              "                if (document.getElementById(\"b31fe230-32c7-4252-a51a-6744d92237f2\")) {\n",
              "                    Plotly.newPlot(\n",
              "                        'b31fe230-32c7-4252-a51a-6744d92237f2',\n",
              "                        [{\"marker\": {\"color\": \"yellowgreen\"}, \"name\": \"\\u0414\\u0435\\u0439\\u0441\\u0442\\u0432\\u0443\\u044e\\u0449\\u0438\\u0439 \\u0444\\u043e\\u043d\\u0434 <br>\\u0434\\u043e\\u0431\\u044b\\u0432\\u0430\\u044e\\u0449\\u0438\\u0445 \\u0441\\u043a\\u0432\\u0430\\u0436\\u0438\\u043d\", \"opacity\": 0.7, \"type\": \"bar\", \"x\": [1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1975, 1976, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009], \"y\": [2, 2, 1, 2, 2, 2, 2, 1, 6, 10, 19, 43, 58, 75, 91, 94, 99, 96, 97, 104, 103, 102, 101, 101, 102, 96, 95, 98, 98, 81, 86, 77, 73, 75, 84, 94, 90, 84, 81, 76, 75, 76, 75, 75]}, {\"marker\": {\"color\": \"limegreen\"}, \"name\": \"\\u0414\\u0435\\u0439\\u0441\\u0442\\u0432\\u0443\\u044e\\u0449\\u0438\\u0439 \\u0444\\u043e\\u043d\\u0434 <br>\\u043d\\u0430\\u0433\\u043d\\u0435\\u0442\\u0430\\u0442\\u0435\\u043b\\u044c\\u043d\\u044b\\u0445 \\u0441\\u043a\\u0432\\u0430\\u0436\\u0438\\u043d\", \"opacity\": 0.7, \"type\": \"bar\", \"x\": [1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1975, 1976, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009], \"y\": [0, 0, 1, 1, 1, 1, 1, 1, 3, 5, 5, 2, 5, 6, 7, 7, 12, 14, 19, 23, 24, 25, 26, 22, 15, 20, 22, 20, 13, 7, 10, 8, 11, 16, 8, 10, 8, 9, 12, 11, 8, 10, 9, 18]}, {\"marker\": {\"color\": \"blue\"}, \"mode\": \"lines\", \"name\": \"\\u0413\\u043e\\u0434\\u043e\\u0432\\u0430\\u044f \\u0434\\u043e\\u0431\\u044b\\u0447\\u0430, \\u043c\\u043b\\u043d \\u0442\", \"type\": \"scatter\", \"x\": [1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1975, 1976, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009], \"y\": [6.522, 6.132000000000001, 0.498, 4.213, 4.283, 4.114, 4.067, 2.126, 12.21, 79.07, 168.293, 206.753, 228.49599999999998, 208.153, 207.988, 181.79, 170.229, 209.75400000000002, 264.159, 256.276, 258.526, 234.898, 180.41299999999998, 158.072, 166.11700000000002, 127.446, 120.69200000000001, 102.40299999999999, 72.14399999999999, 74.285, 70.237, 68.926, 73.906, 66.73100000000001, 68.571, 68.195, 66.20100000000001, 66.001, 69.041, 71.848, 71.14699999999999, 81.084, 78.83800000000001, 83.066], \"yaxis\": \"y2\"}, {\"marker\": {\"color\": \"red\"}, \"mode\": \"lines\", \"name\": \"\\u041e\\u0431\\u0432\\u043e\\u0434\\u043d\\u0435\\u043d\\u043d\\u043e\\u0441\\u0442\\u044c, %\", \"type\": \"scatter\", \"x\": [1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1975, 1976, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009], \"y\": [1.3, 1.4, 11.4, 2.0, 0.4, 0.5, 1.2, 0.0, 26.6, 19.5, 13.1, 17.3, 27.1, 37.6, 36.4, 41.9, 44.9, 45.8, 46.6, 49.5, 53.5, 54.9, 63.1, 63.2, 63.9, 65.6, 61.2, 65.1, 71.3, 67.4, 63.1, 66.5, 69.3, 67.2, 67.9, 66.9, 65.1, 62.9, 58.5, 52.9, 53.2, 46.6, 48.4, 49.4], \"yaxis\": \"y3\"}, {\"marker\": {\"color\": \"magenta\"}, \"mode\": \"lines\", \"name\": \"\\u041a\\u0418\\u041d \\u0442\\u0435\\u043a\\u0443\\u0449\\u0438\\u0439, %\", \"type\": \"scatter\", \"x\": [1966, 1967, 1968, 1969, 1970, 1971, 1972, 1973, 1974, 1975, 1976, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009], \"y\": [0.0, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.1, 0.2, 0.5, 1.2, 2.0, 2.9, 3.8, 4.6, 5.3, 6.0, 6.9, 7.9, 8.9, 10.0, 10.9, 11.7, 12.3, 13.0, 13.5, 14.000000000000002, 14.400000000000002, 14.7, 15.0, 15.2, 15.5, 15.8, 16.1, 16.4, 16.6, 16.9, 17.2, 17.4, 17.7, 18.0, 18.3, 18.7, 19.0], \"yaxis\": \"y4\"}],\n",
              "                        {\"annotations\": [{\"font\": {\"color\": \"Black\", \"family\": \"arial bold\", \"size\": 36}, \"showarrow\": false, \"text\": \"I\", \"x\": 1976, \"y\": 105, \"yshift\": 10}, {\"font\": {\"color\": \"Black\", \"family\": \"arial bold\", \"size\": 36}, \"showarrow\": false, \"text\": \"II\", \"x\": 1984, \"y\": 105, \"yshift\": 10}, {\"font\": {\"color\": \"Black\", \"family\": \"arial bold\", \"size\": 36}, \"showarrow\": false, \"text\": \"III\", \"x\": 1998, \"y\": 105, \"yshift\": 10}], \"autosize\": false, \"height\": 800, \"shapes\": [{\"line\": {\"color\": \"Black\", \"dash\": \"dashdot\", \"width\": 4}, \"type\": \"line\", \"x0\": 1973, \"x1\": 1973, \"xref\": \"x\", \"y0\": 0, \"y1\": 1, \"yref\": \"paper\"}, {\"line\": {\"color\": \"Black\", \"dash\": \"dashdot\", \"width\": 4}, \"type\": \"line\", \"x0\": 1979, \"x1\": 1979, \"xref\": \"x\", \"y0\": 0, \"y1\": 1, \"yref\": \"paper\"}, {\"line\": {\"color\": \"Black\", \"dash\": \"dashdot\", \"width\": 4}, \"type\": \"line\", \"x0\": 1988, \"x1\": 1988, \"xref\": \"x\", \"y0\": 0, \"y1\": 1, \"yref\": \"paper\"}], \"template\": {\"data\": {\"bar\": [{\"error_x\": {\"color\": \"#2a3f5f\"}, \"error_y\": {\"color\": \"#2a3f5f\"}, \"marker\": {\"line\": {\"color\": \"#E5ECF6\", \"width\": 0.5}}, \"type\": \"bar\"}], \"barpolar\": [{\"marker\": {\"line\": {\"color\": \"#E5ECF6\", \"width\": 0.5}}, \"type\": \"barpolar\"}], \"carpet\": [{\"aaxis\": {\"endlinecolor\": \"#2a3f5f\", \"gridcolor\": \"white\", \"linecolor\": \"white\", \"minorgridcolor\": \"white\", \"startlinecolor\": \"#2a3f5f\"}, \"baxis\": {\"endlinecolor\": \"#2a3f5f\", \"gridcolor\": \"white\", \"linecolor\": \"white\", \"minorgridcolor\": \"white\", \"startlinecolor\": \"#2a3f5f\"}, \"type\": \"carpet\"}], \"choropleth\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"choropleth\"}], \"contour\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"contour\"}], \"contourcarpet\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"contourcarpet\"}], \"heatmap\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"heatmap\"}], \"heatmapgl\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"heatmapgl\"}], \"histogram\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"histogram\"}], \"histogram2d\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"histogram2d\"}], \"histogram2dcontour\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"histogram2dcontour\"}], \"mesh3d\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"mesh3d\"}], \"parcoords\": [{\"line\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"parcoords\"}], \"pie\": [{\"automargin\": true, \"type\": \"pie\"}], \"scatter\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatter\"}], \"scatter3d\": [{\"line\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatter3d\"}], \"scattercarpet\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattercarpet\"}], \"scattergeo\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattergeo\"}], \"scattergl\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattergl\"}], \"scattermapbox\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattermapbox\"}], \"scatterpolar\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterpolar\"}], \"scatterpolargl\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterpolargl\"}], \"scatterternary\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterternary\"}], \"surface\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"surface\"}], \"table\": [{\"cells\": {\"fill\": {\"color\": \"#EBF0F8\"}, \"line\": {\"color\": \"white\"}}, \"header\": {\"fill\": {\"color\": \"#C8D4E3\"}, \"line\": {\"color\": \"white\"}}, \"type\": \"table\"}]}, \"layout\": {\"annotationdefaults\": {\"arrowcolor\": \"#2a3f5f\", \"arrowhead\": 0, \"arrowwidth\": 1}, \"coloraxis\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"colorscale\": {\"diverging\": [[0, \"#8e0152\"], [0.1, \"#c51b7d\"], [0.2, \"#de77ae\"], [0.3, \"#f1b6da\"], [0.4, \"#fde0ef\"], [0.5, \"#f7f7f7\"], [0.6, \"#e6f5d0\"], [0.7, \"#b8e186\"], [0.8, \"#7fbc41\"], [0.9, \"#4d9221\"], [1, \"#276419\"]], \"sequential\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"sequentialminus\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]]}, \"colorway\": [\"#636efa\", \"#EF553B\", \"#00cc96\", \"#ab63fa\", \"#FFA15A\", \"#19d3f3\", \"#FF6692\", \"#B6E880\", \"#FF97FF\", \"#FECB52\"], \"font\": {\"color\": \"#2a3f5f\"}, \"geo\": {\"bgcolor\": \"white\", \"lakecolor\": \"white\", \"landcolor\": \"#E5ECF6\", \"showlakes\": true, \"showland\": true, \"subunitcolor\": \"white\"}, \"hoverlabel\": {\"align\": \"left\"}, \"hovermode\": \"closest\", \"mapbox\": {\"style\": \"light\"}, \"paper_bgcolor\": \"white\", \"plot_bgcolor\": \"#E5ECF6\", \"polar\": {\"angularaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"bgcolor\": \"#E5ECF6\", \"radialaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}}, \"scene\": {\"xaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}, \"yaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}, \"zaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}}, \"shapedefaults\": {\"line\": {\"color\": \"#2a3f5f\"}}, \"ternary\": {\"aaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"baxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"bgcolor\": \"#E5ECF6\", \"caxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}}, \"title\": {\"x\": 0.05}, \"xaxis\": {\"automargin\": true, \"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\", \"title\": {\"standoff\": 15}, \"zerolinecolor\": \"white\", \"zerolinewidth\": 2}, \"yaxis\": {\"automargin\": true, \"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\", \"title\": {\"standoff\": 15}, \"zerolinecolor\": \"white\", \"zerolinewidth\": 2}}}, \"title\": {\"text\": \"\\u0414\\u0438\\u043d\\u0430\\u043c\\u0438\\u043a\\u0430 \\u0440\\u0430\\u0437\\u0440\\u0430\\u0431\\u043e\\u0442\\u043a\\u0438 \\u043c\\u0435\\u0441\\u0442\\u043e\\u0440\\u043e\\u0436\\u0434\\u0435\\u043d\\u0438\\u044f \\u041e\\u0431\\u044a\\u0435\\u043a\\u0442 1 (\\u0411\\u0430\\u0448\\u043a\\u0438\\u0440\\u0441\\u043a\\u0438\\u0439 \\u044f\\u0440\\u0443\\u0441)\", \"x\": 0.4, \"xanchor\": \"center\", \"y\": 0.95, \"yanchor\": \"top\"}, \"width\": 1300, \"xaxis\": {\"domain\": [0.1, 0.9], \"tickangle\": -45, \"title\": {\"text\": \"\\u0413\\u043e\\u0434\"}}, \"yaxis\": {\"range\": [0, 110], \"tickfont\": {\"color\": \"green\"}, \"title\": {\"font\": {\"color\": \"green\"}, \"text\": \"\\u0427\\u0438\\u0441\\u043b\\u043e \\u0441\\u043a\\u0430\\u0436\\u0438\\u043d (\\u0448\\u0442)\"}}, \"yaxis2\": {\"anchor\": \"x\", \"overlaying\": \"y\", \"range\": [0, 290], \"side\": \"right\", \"tickfont\": {\"color\": \"blue\"}, \"title\": {\"font\": {\"color\": \"blue\"}, \"text\": \"\\u0413\\u043e\\u0434\\u043e\\u0432\\u0430\\u044f \\u0434\\u043e\\u0431\\u044b\\u0447\\u0430, \\u043c\\u043b\\u043d \\u0442\"}}, \"yaxis3\": {\"anchor\": \"free\", \"overlaying\": \"y\", \"position\": 0.01, \"range\": [0, 110], \"side\": \"left\", \"tickfont\": {\"color\": \"red\"}, \"title\": {\"font\": {\"color\": \"red\"}, \"text\": \"\\u041e\\u0431\\u0432\\u043e\\u0434\\u043d\\u0435\\u043d\\u043d\\u043e\\u0441\\u0442\\u044c, %\"}}, \"yaxis4\": {\"anchor\": \"free\", \"overlaying\": \"y\", \"position\": 0.99, \"range\": [0, 25], \"side\": \"right\", \"tickfont\": {\"color\": \"magenta\"}, \"title\": {\"font\": {\"color\": \"magenta\"}, \"text\": \"\\u041a\\u0418\\u041d \\u0442\\u0435\\u043a\\u0443\\u0449\\u0438\\u0439, %\"}}},\n",
              "                        {\"responsive\": true}\n",
              "                    ).then(function(){\n",
              "                            \n",
              "var gd = document.getElementById('b31fe230-32c7-4252-a51a-6744d92237f2');\n",
              "var x = new MutationObserver(function (mutations, observer) {{\n",
              "        var display = window.getComputedStyle(gd).display;\n",
              "        if (!display || display === 'none') {{\n",
              "            console.log([gd, 'removed!']);\n",
              "            Plotly.purge(gd);\n",
              "            observer.disconnect();\n",
              "        }}\n",
              "}});\n",
              "\n",
              "// Listen for the removal of the full notebook cells\n",
              "var notebookContainer = gd.closest('#notebook-container');\n",
              "if (notebookContainer) {{\n",
              "    x.observe(notebookContainer, {childList: true});\n",
              "}}\n",
              "\n",
              "// Listen for the clearing of the current output cell\n",
              "var outputEl = gd.closest('.output');\n",
              "if (outputEl) {{\n",
              "    x.observe(outputEl, {childList: true});\n",
              "}}\n",
              "\n",
              "                        })\n",
              "                };\n",
              "                \n",
              "            </script>\n",
              "        </div>\n",
              "</body>\n",
              "</html>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "uQludApvbpBB"
      },
      "source": [
        "## Объект №2"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 368
        },
        "id": "o0ZOjICabsea",
        "outputId": "39bbf9a8-10ea-4ff1-86e8-ae3918b23999"
      },
      "source": [
        "df_object2 = pd.read_csv('https://raw.githubusercontent.com/alexeynick/msu_oil_gas/main/datasets/dynamic_object_2.csv')\n",
        "df_object2.tail(10)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>year</th>\n",
              "      <th>well_production</th>\n",
              "      <th>well_common</th>\n",
              "      <th>oil_year</th>\n",
              "      <th>fluid_year</th>\n",
              "      <th>water_cut</th>\n",
              "      <th>oil_day</th>\n",
              "      <th>fluid_day</th>\n",
              "      <th>oil_total</th>\n",
              "      <th>fluid_total</th>\n",
              "      <th>kin</th>\n",
              "      <th>production_frac_total</th>\n",
              "      <th>production_frac</th>\n",
              "      <th>gas_year</th>\n",
              "      <th>gas_total</th>\n",
              "      <th>well_injection</th>\n",
              "      <th>inject_year</th>\n",
              "      <th>inject_total</th>\n",
              "      <th>inject_comp_year</th>\n",
              "      <th>inject_comp_total</th>\n",
              "      <th>inject_response</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>2004</td>\n",
              "      <td>21</td>\n",
              "      <td>3</td>\n",
              "      <td>42.7</td>\n",
              "      <td>209.8</td>\n",
              "      <td>79.6</td>\n",
              "      <td>5.7</td>\n",
              "      <td>28.2</td>\n",
              "      <td>1599.5</td>\n",
              "      <td>5938.9</td>\n",
              "      <td>0.354</td>\n",
              "      <td>66.8</td>\n",
              "      <td>1.8</td>\n",
              "      <td>2.823</td>\n",
              "      <td>149.936</td>\n",
              "      <td>4</td>\n",
              "      <td>83.9</td>\n",
              "      <td>6042.1</td>\n",
              "      <td>37.8</td>\n",
              "      <td>94.4</td>\n",
              "      <td>57.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>2005</td>\n",
              "      <td>22</td>\n",
              "      <td>3</td>\n",
              "      <td>41.8</td>\n",
              "      <td>219.4</td>\n",
              "      <td>80.9</td>\n",
              "      <td>5.5</td>\n",
              "      <td>29.1</td>\n",
              "      <td>1641.3</td>\n",
              "      <td>6158.2</td>\n",
              "      <td>0.363</td>\n",
              "      <td>68.6</td>\n",
              "      <td>1.7</td>\n",
              "      <td>2.985</td>\n",
              "      <td>152.921</td>\n",
              "      <td>4</td>\n",
              "      <td>74.3</td>\n",
              "      <td>6116.4</td>\n",
              "      <td>32.1</td>\n",
              "      <td>92.2</td>\n",
              "      <td>52.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>2006</td>\n",
              "      <td>21</td>\n",
              "      <td>3</td>\n",
              "      <td>43.1</td>\n",
              "      <td>233.6</td>\n",
              "      <td>81.6</td>\n",
              "      <td>5.8</td>\n",
              "      <td>31.1</td>\n",
              "      <td>1684.4</td>\n",
              "      <td>6391.8</td>\n",
              "      <td>0.373</td>\n",
              "      <td>70.4</td>\n",
              "      <td>1.8</td>\n",
              "      <td>2.451</td>\n",
              "      <td>155.372</td>\n",
              "      <td>4</td>\n",
              "      <td>89.2</td>\n",
              "      <td>6205.6</td>\n",
              "      <td>36.3</td>\n",
              "      <td>90.2</td>\n",
              "      <td>78.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>2007</td>\n",
              "      <td>21</td>\n",
              "      <td>3</td>\n",
              "      <td>35.4</td>\n",
              "      <td>200.2</td>\n",
              "      <td>82.3</td>\n",
              "      <td>4.9</td>\n",
              "      <td>27.4</td>\n",
              "      <td>1719.8</td>\n",
              "      <td>6592.0</td>\n",
              "      <td>0.381</td>\n",
              "      <td>71.8</td>\n",
              "      <td>1.5</td>\n",
              "      <td>4.730</td>\n",
              "      <td>160.102</td>\n",
              "      <td>4</td>\n",
              "      <td>114.1</td>\n",
              "      <td>6319.8</td>\n",
              "      <td>54.3</td>\n",
              "      <td>89.2</td>\n",
              "      <td>109.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>2008</td>\n",
              "      <td>22</td>\n",
              "      <td>3</td>\n",
              "      <td>44.7</td>\n",
              "      <td>211.1</td>\n",
              "      <td>78.8</td>\n",
              "      <td>6.2</td>\n",
              "      <td>29.3</td>\n",
              "      <td>1764.5</td>\n",
              "      <td>6803.1</td>\n",
              "      <td>0.391</td>\n",
              "      <td>73.7</td>\n",
              "      <td>1.9</td>\n",
              "      <td>3.095</td>\n",
              "      <td>163.197</td>\n",
              "      <td>4</td>\n",
              "      <td>98.8</td>\n",
              "      <td>6418.6</td>\n",
              "      <td>46.4</td>\n",
              "      <td>94.5</td>\n",
              "      <td>92.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>2009</td>\n",
              "      <td>22</td>\n",
              "      <td>3</td>\n",
              "      <td>49.3</td>\n",
              "      <td>227.7</td>\n",
              "      <td>78.3</td>\n",
              "      <td>6.4</td>\n",
              "      <td>29.4</td>\n",
              "      <td>1813.8</td>\n",
              "      <td>7030.8</td>\n",
              "      <td>0.402</td>\n",
              "      <td>75.8</td>\n",
              "      <td>2.1</td>\n",
              "      <td>3.419</td>\n",
              "      <td>166.616</td>\n",
              "      <td>4</td>\n",
              "      <td>118.0</td>\n",
              "      <td>6536.6</td>\n",
              "      <td>51.3</td>\n",
              "      <td>93.0</td>\n",
              "      <td>108.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>2010</td>\n",
              "      <td>22</td>\n",
              "      <td>3</td>\n",
              "      <td>44.8</td>\n",
              "      <td>205.7</td>\n",
              "      <td>78.2</td>\n",
              "      <td>5.8</td>\n",
              "      <td>26.5</td>\n",
              "      <td>1858.6</td>\n",
              "      <td>7236.5</td>\n",
              "      <td>0.411</td>\n",
              "      <td>77.6</td>\n",
              "      <td>1.9</td>\n",
              "      <td>3.977</td>\n",
              "      <td>170.593</td>\n",
              "      <td>4</td>\n",
              "      <td>95.0</td>\n",
              "      <td>6631.5</td>\n",
              "      <td>45.8</td>\n",
              "      <td>91.7</td>\n",
              "      <td>92.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>2011</td>\n",
              "      <td>22</td>\n",
              "      <td>3</td>\n",
              "      <td>43.6</td>\n",
              "      <td>230.0</td>\n",
              "      <td>81.0</td>\n",
              "      <td>5.7</td>\n",
              "      <td>30.1</td>\n",
              "      <td>1902.2</td>\n",
              "      <td>7466.5</td>\n",
              "      <td>0.421</td>\n",
              "      <td>79.5</td>\n",
              "      <td>1.8</td>\n",
              "      <td>3.492</td>\n",
              "      <td>174.085</td>\n",
              "      <td>4</td>\n",
              "      <td>95.4</td>\n",
              "      <td>6726.9</td>\n",
              "      <td>41.8</td>\n",
              "      <td>90.2</td>\n",
              "      <td>91.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>2012</td>\n",
              "      <td>22</td>\n",
              "      <td>5</td>\n",
              "      <td>32.7</td>\n",
              "      <td>245.8</td>\n",
              "      <td>86.7</td>\n",
              "      <td>4.5</td>\n",
              "      <td>33.7</td>\n",
              "      <td>1934.9</td>\n",
              "      <td>7712.3</td>\n",
              "      <td>0.428</td>\n",
              "      <td>80.8</td>\n",
              "      <td>1.4</td>\n",
              "      <td>2.278</td>\n",
              "      <td>176.363</td>\n",
              "      <td>4</td>\n",
              "      <td>97.2</td>\n",
              "      <td>6824.0</td>\n",
              "      <td>41.3</td>\n",
              "      <td>88.7</td>\n",
              "      <td>89.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>2013</td>\n",
              "      <td>21</td>\n",
              "      <td>5</td>\n",
              "      <td>24.2</td>\n",
              "      <td>228.4</td>\n",
              "      <td>89.4</td>\n",
              "      <td>3.3</td>\n",
              "      <td>31.5</td>\n",
              "      <td>1959.2</td>\n",
              "      <td>7940.7</td>\n",
              "      <td>0.434</td>\n",
              "      <td>81.8</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.638</td>\n",
              "      <td>178.001</td>\n",
              "      <td>4</td>\n",
              "      <td>84.9</td>\n",
              "      <td>6908.9</td>\n",
              "      <td>39.8</td>\n",
              "      <td>87.4</td>\n",
              "      <td>80.9</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "    year  well_production  ...  inject_comp_total  inject_response\n",
              "29  2004               21  ...               94.4             57.3\n",
              "30  2005               22  ...               92.2             52.9\n",
              "31  2006               21  ...               90.2             78.3\n",
              "32  2007               21  ...               89.2            109.4\n",
              "33  2008               22  ...               94.5             92.2\n",
              "34  2009               22  ...               93.0            108.8\n",
              "35  2010               22  ...               91.7             92.2\n",
              "36  2011               22  ...               90.2             91.6\n",
              "37  2012               22  ...               88.7             89.2\n",
              "38  2013               21  ...               87.4             80.9\n",
              "\n",
              "[10 rows x 21 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 817
        },
        "id": "JHQMqFoDbsoT",
        "outputId": "8b4b4d7f-5f9c-4f38-aede-0cf2962b3890"
      },
      "source": [
        "df_data = df_object2\n",
        "years = df_data['year']\n",
        "\n",
        "fig = go.Figure()\n",
        "\n",
        "fig.add_trace(go.Bar(x=years,\n",
        "                y=df_data['well_production'],\n",
        "                name='Действующий фонд <br>добывающих скважин',\n",
        "                marker_color='yellowgreen',\n",
        "                opacity=0.7\n",
        "                ))\n",
        "\n",
        "fig.add_trace(go.Bar(x=years,\n",
        "                y=df_data['well_injection'],\n",
        "                name='Действующий фонд <br>нагнетательных скважин',\n",
        "                marker_color='limegreen',\n",
        "                opacity=0.7\n",
        "                ))\n",
        "\n",
        "fig.add_trace(go.Scatter(x=years, \n",
        "                    y=df_data['oil_year'],\n",
        "                    mode='lines',\n",
        "                    marker_color='blue',\n",
        "                    name='Годовая добыча, млн т',\n",
        "    yaxis=\"y2\"))\n",
        "\n",
        "fig.add_trace(go.Scatter(x=years, \n",
        "                    y=df_data['water_cut'],\n",
        "                    mode='lines',\n",
        "                    marker_color='red',\n",
        "                    name='Обводненность, %',\n",
        "    yaxis=\"y3\"))\n",
        "\n",
        "fig.add_trace(go.Scatter(x=years, \n",
        "                    y=df_data['kin'] * 100,\n",
        "                    mode='lines',\n",
        "                    marker_color='magenta',\n",
        "                    name='КИН текущий, %',\n",
        "    yaxis=\"y4\"))\n",
        "\n",
        "shapes=[]\n",
        "#for year in [1977, 1983, 1998, 2010]:\n",
        "for year in [1977, 1994, 2003]:\n",
        "  shapes.append(\n",
        "      dict(\n",
        "          type= 'line',\n",
        "          yref= 'paper', y0= 0, y1= 1,\n",
        "          xref= 'x', x0= year, x1= year,\n",
        "          line=dict(\n",
        "                      color=\"Black\",\n",
        "                      width=4,\n",
        "                      dash=\"dashdot\",\n",
        "                  )\n",
        "      )\n",
        "  )\n",
        "\n",
        "fig.add_annotation(x=1985, y=25, text=\"I\", showarrow=False, yshift=10, font=anno_font)\n",
        "fig.add_annotation(x=1999, y=25, text=\"II\", showarrow=False, yshift=10, font=anno_font)\n",
        "fig.add_annotation(x=2008, y=25, text=\"III\", showarrow=False, yshift=10, font=anno_font)\n",
        "#fig.add_annotation(x=2008, y=25, text=\"IV\", showarrow=False, yshift=10, font=anno_font)\n",
        "\n",
        "fig.update_layout( \n",
        "    shapes = shapes,\n",
        "    xaxis=dict(\n",
        "        domain=[0.1, 0.9],\n",
        "        #tickmode = 'array',\n",
        "        #tickvals = df_object2['year'],\n",
        "        tickangle=-45,\n",
        "        title='Год',\n",
        "    ),\n",
        "\n",
        "    yaxis=dict(\n",
        "        range=[0, 27],\n",
        "        title=\"Число скажин (шт)\",\n",
        "        titlefont=dict(\n",
        "            color=\"green\"\n",
        "        ),\n",
        "        tickfont=dict(\n",
        "            color=\"green\"\n",
        "        )\n",
        "    ),\n",
        "\n",
        "    yaxis2=dict(\n",
        "        range=[0, 180],\n",
        "        title=\"Годовая добыча, млн т\",\n",
        "        titlefont=dict(\n",
        "            color=\"blue\"\n",
        "        ),\n",
        "        tickfont=dict(\n",
        "            color=\"blue\"\n",
        "        ),\n",
        "        anchor=\"x\",\n",
        "        overlaying=\"y\",\n",
        "        side=\"right\"\n",
        "    ),\n",
        "\n",
        "    yaxis3=dict(\n",
        "        range=[0, 100],\n",
        "        title=\"Обводненность, %\",\n",
        "        titlefont=dict(\n",
        "            color=\"red\"\n",
        "        ),\n",
        "        tickfont=dict(\n",
        "            color=\"red\"\n",
        "        ),\n",
        "        anchor=\"free\",\n",
        "        overlaying=\"y\",\n",
        "        side=\"left\",\n",
        "        position=0.01\n",
        "    ),\n",
        "\n",
        "    yaxis4=dict(\n",
        "        range=[0, 55],\n",
        "        title=\"КИН текущий, %\",\n",
        "        titlefont=dict(\n",
        "            color=\"magenta\"\n",
        "        ),\n",
        "        tickfont=dict(\n",
        "            color=\"magenta\"\n",
        "        ),\n",
        "        anchor=\"free\",\n",
        "        overlaying=\"y\",\n",
        "        side=\"right\",\n",
        "        position=0.99\n",
        "    ),\n",
        "\n",
        "    title={\n",
        "        'text': \"Динамика разработки месторождения Объект 2\",\n",
        "        'y':0.95,\n",
        "        'x':0.4,\n",
        "        'xanchor': 'center',\n",
        "        'yanchor': 'top'},\n",
        "\n",
        "    autosize=False,\n",
        "    width=1300,\n",
        "    height=800)\n",
        "\n",
        "fig.show()\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<html>\n",
              "<head><meta charset=\"utf-8\" /></head>\n",
              "<body>\n",
              "    <div>\n",
              "            <script src=\"https://cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.5/MathJax.js?config=TeX-AMS-MML_SVG\"></script><script type=\"text/javascript\">if (window.MathJax) {MathJax.Hub.Config({SVG: {font: \"STIX-Web\"}});}</script>\n",
              "                <script type=\"text/javascript\">window.PlotlyConfig = {MathJaxConfig: 'local'};</script>\n",
              "        <script src=\"https://cdn.plot.ly/plotly-latest.min.js\"></script>    \n",
              "            <div id=\"b9139c3c-f7e2-40f3-aa2b-28076a0f8479\" class=\"plotly-graph-div\" style=\"height:800px; width:1300px;\"></div>\n",
              "            <script type=\"text/javascript\">\n",
              "                \n",
              "                    window.PLOTLYENV=window.PLOTLYENV || {};\n",
              "                    \n",
              "                if (document.getElementById(\"b9139c3c-f7e2-40f3-aa2b-28076a0f8479\")) {\n",
              "                    Plotly.newPlot(\n",
              "                        'b9139c3c-f7e2-40f3-aa2b-28076a0f8479',\n",
              "                        [{\"marker\": {\"color\": \"yellowgreen\"}, \"name\": \"\\u0414\\u0435\\u0439\\u0441\\u0442\\u0432\\u0443\\u044e\\u0449\\u0438\\u0439 \\u0444\\u043e\\u043d\\u0434 <br>\\u0434\\u043e\\u0431\\u044b\\u0432\\u0430\\u044e\\u0449\\u0438\\u0445 \\u0441\\u043a\\u0432\\u0430\\u0436\\u0438\\u043d\", \"opacity\": 0.7, \"type\": \"bar\", \"x\": [1975, 1976, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013], \"y\": [2, 2, 2, 3, 6, 12, 12, 13, 14, 14, 13, 12, 13, 12, 12, 13, 14, 18, 17, 16, 18, 22, 20, 20, 19, 23, 23, 22, 21, 21, 22, 21, 21, 22, 22, 22, 22, 22, 21]}, {\"marker\": {\"color\": \"limegreen\"}, \"name\": \"\\u0414\\u0435\\u0439\\u0441\\u0442\\u0432\\u0443\\u044e\\u0449\\u0438\\u0439 \\u0444\\u043e\\u043d\\u0434 <br>\\u043d\\u0430\\u0433\\u043d\\u0435\\u0442\\u0430\\u0442\\u0435\\u043b\\u044c\\u043d\\u044b\\u0445 \\u0441\\u043a\\u0432\\u0430\\u0436\\u0438\\u043d\", \"opacity\": 0.7, \"type\": \"bar\", \"x\": [1975, 1976, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013], \"y\": [0, 0, 0, 0, 2, 2, 4, 5, 5, 4, 4, 4, 4, 3, 4, 5, 4, 6, 4, 5, 7, 5, 8, 7, 5, 5, 4, 5, 5, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4]}, {\"marker\": {\"color\": \"blue\"}, \"mode\": \"lines\", \"name\": \"\\u0413\\u043e\\u0434\\u043e\\u0432\\u0430\\u044f \\u0434\\u043e\\u0431\\u044b\\u0447\\u0430, \\u043c\\u043b\\u043d \\u0442\", \"type\": \"scatter\", \"x\": [1975, 1976, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013], \"y\": [48.8, 166.8, 77.7, 10.1, 44.1, 103.4, 132.3, 70.1, 44.6, 38.8, 36.6, 22.3, 13.4, 13.3, 11.9, 12.6, 13.0, 21.5, 30.0, 42.7, 45.9, 49.1, 57.2, 82.3, 85.6, 80.1, 68.8, 71.9, 61.8, 42.7, 41.8, 43.1, 35.4, 44.7, 49.3, 44.8, 43.6, 32.7, 24.2], \"yaxis\": \"y2\"}, {\"marker\": {\"color\": \"red\"}, \"mode\": \"lines\", \"name\": \"\\u041e\\u0431\\u0432\\u043e\\u0434\\u043d\\u0435\\u043d\\u043d\\u043e\\u0441\\u0442\\u044c, %\", \"type\": \"scatter\", \"x\": [1975, 1976, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013], \"y\": [0.0, 1.1, 11.6, 41.8, 46.6, 44.8, 53.7, 75.4, 84.9, 87.2, 89.2, 93.0, 94.8, 94.6, 94.1, 94.6, 95.1, 90.7, 85.4, 80.5, 78.6, 67.0, 35.7, 22.2, 43.9, 49.1, 56.7, 64.3, 71.9, 79.6, 80.9, 81.6, 82.3, 78.8, 78.3, 78.2, 81.0, 86.7, 89.4], \"yaxis\": \"y3\"}, {\"marker\": {\"color\": \"magenta\"}, \"mode\": \"lines\", \"name\": \"\\u041a\\u0418\\u041d \\u0442\\u0435\\u043a\\u0443\\u0449\\u0438\\u0439, %\", \"type\": \"scatter\", \"x\": [1975, 1976, 1977, 1978, 1979, 1980, 1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013], \"y\": [1.1, 4.8, 6.5, 6.7, 7.7, 10.0, 12.9, 14.499999999999998, 15.5, 16.3, 17.1, 17.6, 17.9, 18.2, 18.5, 18.8, 19.0, 19.5, 20.2, 21.1, 22.1, 23.2, 24.5, 26.3, 28.199999999999996, 30.0, 31.5, 33.1, 34.5, 35.4, 36.3, 37.3, 38.1, 39.1, 40.2, 41.1, 42.1, 42.8, 43.4], \"yaxis\": \"y4\"}],\n",
              "                        {\"annotations\": [{\"font\": {\"color\": \"Black\", \"family\": \"arial bold\", \"size\": 36}, \"showarrow\": false, \"text\": \"I\", \"x\": 1985, \"y\": 25, \"yshift\": 10}, {\"font\": {\"color\": \"Black\", \"family\": \"arial bold\", \"size\": 36}, \"showarrow\": false, \"text\": \"II\", \"x\": 1999, \"y\": 25, \"yshift\": 10}, {\"font\": {\"color\": \"Black\", \"family\": \"arial bold\", \"size\": 36}, \"showarrow\": false, \"text\": \"III\", \"x\": 2008, \"y\": 25, \"yshift\": 10}], \"autosize\": false, \"height\": 800, \"shapes\": [{\"line\": {\"color\": \"Black\", \"dash\": \"dashdot\", \"width\": 4}, \"type\": \"line\", \"x0\": 1977, \"x1\": 1977, \"xref\": \"x\", \"y0\": 0, \"y1\": 1, \"yref\": \"paper\"}, {\"line\": {\"color\": \"Black\", \"dash\": \"dashdot\", \"width\": 4}, \"type\": \"line\", \"x0\": 1994, \"x1\": 1994, \"xref\": \"x\", \"y0\": 0, \"y1\": 1, \"yref\": \"paper\"}, {\"line\": {\"color\": \"Black\", \"dash\": \"dashdot\", \"width\": 4}, \"type\": \"line\", \"x0\": 2003, \"x1\": 2003, \"xref\": \"x\", \"y0\": 0, \"y1\": 1, \"yref\": \"paper\"}], \"template\": {\"data\": {\"bar\": [{\"error_x\": {\"color\": \"#2a3f5f\"}, \"error_y\": {\"color\": \"#2a3f5f\"}, \"marker\": {\"line\": {\"color\": \"#E5ECF6\", \"width\": 0.5}}, \"type\": \"bar\"}], \"barpolar\": [{\"marker\": {\"line\": {\"color\": \"#E5ECF6\", \"width\": 0.5}}, \"type\": \"barpolar\"}], \"carpet\": [{\"aaxis\": {\"endlinecolor\": \"#2a3f5f\", \"gridcolor\": \"white\", \"linecolor\": \"white\", \"minorgridcolor\": \"white\", \"startlinecolor\": \"#2a3f5f\"}, \"baxis\": {\"endlinecolor\": \"#2a3f5f\", \"gridcolor\": \"white\", \"linecolor\": \"white\", \"minorgridcolor\": \"white\", \"startlinecolor\": \"#2a3f5f\"}, \"type\": \"carpet\"}], \"choropleth\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"choropleth\"}], \"contour\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"contour\"}], \"contourcarpet\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"contourcarpet\"}], \"heatmap\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"heatmap\"}], \"heatmapgl\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"heatmapgl\"}], \"histogram\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"histogram\"}], \"histogram2d\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"histogram2d\"}], \"histogram2dcontour\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"histogram2dcontour\"}], \"mesh3d\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"mesh3d\"}], \"parcoords\": [{\"line\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"parcoords\"}], \"pie\": [{\"automargin\": true, \"type\": \"pie\"}], \"scatter\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatter\"}], \"scatter3d\": [{\"line\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatter3d\"}], \"scattercarpet\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattercarpet\"}], \"scattergeo\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattergeo\"}], \"scattergl\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattergl\"}], \"scattermapbox\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattermapbox\"}], \"scatterpolar\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterpolar\"}], \"scatterpolargl\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterpolargl\"}], \"scatterternary\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterternary\"}], \"surface\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"surface\"}], \"table\": [{\"cells\": {\"fill\": {\"color\": \"#EBF0F8\"}, \"line\": {\"color\": \"white\"}}, \"header\": {\"fill\": {\"color\": \"#C8D4E3\"}, \"line\": {\"color\": \"white\"}}, \"type\": \"table\"}]}, \"layout\": {\"annotationdefaults\": {\"arrowcolor\": \"#2a3f5f\", \"arrowhead\": 0, \"arrowwidth\": 1}, \"coloraxis\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"colorscale\": {\"diverging\": [[0, \"#8e0152\"], [0.1, \"#c51b7d\"], [0.2, \"#de77ae\"], [0.3, \"#f1b6da\"], [0.4, \"#fde0ef\"], [0.5, \"#f7f7f7\"], [0.6, \"#e6f5d0\"], [0.7, \"#b8e186\"], [0.8, \"#7fbc41\"], [0.9, \"#4d9221\"], [1, \"#276419\"]], \"sequential\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"sequentialminus\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]]}, \"colorway\": [\"#636efa\", \"#EF553B\", \"#00cc96\", \"#ab63fa\", \"#FFA15A\", \"#19d3f3\", \"#FF6692\", \"#B6E880\", \"#FF97FF\", \"#FECB52\"], \"font\": {\"color\": \"#2a3f5f\"}, \"geo\": {\"bgcolor\": \"white\", \"lakecolor\": \"white\", \"landcolor\": \"#E5ECF6\", \"showlakes\": true, \"showland\": true, \"subunitcolor\": \"white\"}, \"hoverlabel\": {\"align\": \"left\"}, \"hovermode\": \"closest\", \"mapbox\": {\"style\": \"light\"}, \"paper_bgcolor\": \"white\", \"plot_bgcolor\": \"#E5ECF6\", \"polar\": {\"angularaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"bgcolor\": \"#E5ECF6\", \"radialaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}}, \"scene\": {\"xaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}, \"yaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}, \"zaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}}, \"shapedefaults\": {\"line\": {\"color\": \"#2a3f5f\"}}, \"ternary\": {\"aaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"baxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"bgcolor\": \"#E5ECF6\", \"caxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}}, \"title\": {\"x\": 0.05}, \"xaxis\": {\"automargin\": true, \"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\", \"title\": {\"standoff\": 15}, \"zerolinecolor\": \"white\", \"zerolinewidth\": 2}, \"yaxis\": {\"automargin\": true, \"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\", \"title\": {\"standoff\": 15}, \"zerolinecolor\": \"white\", \"zerolinewidth\": 2}}}, \"title\": {\"text\": \"\\u0414\\u0438\\u043d\\u0430\\u043c\\u0438\\u043a\\u0430 \\u0440\\u0430\\u0437\\u0440\\u0430\\u0431\\u043e\\u0442\\u043a\\u0438 \\u043c\\u0435\\u0441\\u0442\\u043e\\u0440\\u043e\\u0436\\u0434\\u0435\\u043d\\u0438\\u044f \\u041e\\u0431\\u044a\\u0435\\u043a\\u0442 2\", \"x\": 0.4, \"xanchor\": \"center\", \"y\": 0.95, \"yanchor\": \"top\"}, \"width\": 1300, \"xaxis\": {\"domain\": [0.1, 0.9], \"tickangle\": -45, \"title\": {\"text\": \"\\u0413\\u043e\\u0434\"}}, \"yaxis\": {\"range\": [0, 27], \"tickfont\": {\"color\": \"green\"}, \"title\": {\"font\": {\"color\": \"green\"}, \"text\": \"\\u0427\\u0438\\u0441\\u043b\\u043e \\u0441\\u043a\\u0430\\u0436\\u0438\\u043d (\\u0448\\u0442)\"}}, \"yaxis2\": {\"anchor\": \"x\", \"overlaying\": \"y\", \"range\": [0, 180], \"side\": \"right\", \"tickfont\": {\"color\": \"blue\"}, \"title\": {\"font\": {\"color\": \"blue\"}, \"text\": \"\\u0413\\u043e\\u0434\\u043e\\u0432\\u0430\\u044f \\u0434\\u043e\\u0431\\u044b\\u0447\\u0430, \\u043c\\u043b\\u043d \\u0442\"}}, \"yaxis3\": {\"anchor\": \"free\", \"overlaying\": \"y\", \"position\": 0.01, \"range\": [0, 100], \"side\": \"left\", \"tickfont\": {\"color\": \"red\"}, \"title\": {\"font\": {\"color\": \"red\"}, \"text\": \"\\u041e\\u0431\\u0432\\u043e\\u0434\\u043d\\u0435\\u043d\\u043d\\u043e\\u0441\\u0442\\u044c, %\"}}, \"yaxis4\": {\"anchor\": \"free\", \"overlaying\": \"y\", \"position\": 0.99, \"range\": [0, 55], \"side\": \"right\", \"tickfont\": {\"color\": \"magenta\"}, \"title\": {\"font\": {\"color\": \"magenta\"}, \"text\": \"\\u041a\\u0418\\u041d \\u0442\\u0435\\u043a\\u0443\\u0449\\u0438\\u0439, %\"}}},\n",
              "                        {\"responsive\": true}\n",
              "                    ).then(function(){\n",
              "                            \n",
              "var gd = document.getElementById('b9139c3c-f7e2-40f3-aa2b-28076a0f8479');\n",
              "var x = new MutationObserver(function (mutations, observer) {{\n",
              "        var display = window.getComputedStyle(gd).display;\n",
              "        if (!display || display === 'none') {{\n",
              "            console.log([gd, 'removed!']);\n",
              "            Plotly.purge(gd);\n",
              "            observer.disconnect();\n",
              "        }}\n",
              "}});\n",
              "\n",
              "// Listen for the removal of the full notebook cells\n",
              "var notebookContainer = gd.closest('#notebook-container');\n",
              "if (notebookContainer) {{\n",
              "    x.observe(notebookContainer, {childList: true});\n",
              "}}\n",
              "\n",
              "// Listen for the clearing of the current output cell\n",
              "var outputEl = gd.closest('.output');\n",
              "if (outputEl) {{\n",
              "    x.observe(outputEl, {childList: true});\n",
              "}}\n",
              "\n",
              "                        })\n",
              "                };\n",
              "                \n",
              "            </script>\n",
              "        </div>\n",
              "</body>\n",
              "</html>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "r6CDE2VNbRAJ"
      },
      "source": [
        "## Объект №3"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 348
        },
        "id": "hT0y09IfNjdb",
        "outputId": "c0e9836d-9719-46ec-d38b-61580f1e0ed7"
      },
      "source": [
        "df_object3 = pd.read_csv('https://raw.githubusercontent.com/alexeynick/msu_oil_gas/main/datasets/dynamic_object_3.csv')\n",
        "df_object3.tail(10)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>year</th>\n",
              "      <th>well_total</th>\n",
              "      <th>well_production</th>\n",
              "      <th>well_injection</th>\n",
              "      <th>oil_year</th>\n",
              "      <th>oil_total</th>\n",
              "      <th>kin</th>\n",
              "      <th>fluid_year</th>\n",
              "      <th>fluid_total</th>\n",
              "      <th>water_cut</th>\n",
              "      <th>inject_year</th>\n",
              "      <th>inject_total</th>\n",
              "      <th>gas_year</th>\n",
              "      <th>gas_total</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>2006</td>\n",
              "      <td>28</td>\n",
              "      <td>26</td>\n",
              "      <td>0</td>\n",
              "      <td>51.8</td>\n",
              "      <td>711.2</td>\n",
              "      <td>0.083</td>\n",
              "      <td>60.0</td>\n",
              "      <td>773.0</td>\n",
              "      <td>14.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>2.900</td>\n",
              "      <td>32.747</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>2007</td>\n",
              "      <td>28</td>\n",
              "      <td>25</td>\n",
              "      <td>1</td>\n",
              "      <td>49.8</td>\n",
              "      <td>761.0</td>\n",
              "      <td>0.089</td>\n",
              "      <td>59.8</td>\n",
              "      <td>833.7</td>\n",
              "      <td>16.7</td>\n",
              "      <td>25.1</td>\n",
              "      <td>25.1</td>\n",
              "      <td>2.786</td>\n",
              "      <td>35.533</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>2008</td>\n",
              "      <td>28</td>\n",
              "      <td>25</td>\n",
              "      <td>1</td>\n",
              "      <td>51.1</td>\n",
              "      <td>812.1</td>\n",
              "      <td>0.095</td>\n",
              "      <td>65.6</td>\n",
              "      <td>899.2</td>\n",
              "      <td>22.0</td>\n",
              "      <td>26.4</td>\n",
              "      <td>51.5</td>\n",
              "      <td>2.866</td>\n",
              "      <td>38.399</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>2009</td>\n",
              "      <td>31</td>\n",
              "      <td>28</td>\n",
              "      <td>2</td>\n",
              "      <td>54.8</td>\n",
              "      <td>867.0</td>\n",
              "      <td>0.101</td>\n",
              "      <td>67.5</td>\n",
              "      <td>966.8</td>\n",
              "      <td>18.8</td>\n",
              "      <td>29.4</td>\n",
              "      <td>80.9</td>\n",
              "      <td>3.066</td>\n",
              "      <td>41.466</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>2010</td>\n",
              "      <td>31</td>\n",
              "      <td>27</td>\n",
              "      <td>2</td>\n",
              "      <td>67.7</td>\n",
              "      <td>934.7</td>\n",
              "      <td>0.109</td>\n",
              "      <td>86.3</td>\n",
              "      <td>1053.0</td>\n",
              "      <td>21.5</td>\n",
              "      <td>51.1</td>\n",
              "      <td>131.9</td>\n",
              "      <td>3.795</td>\n",
              "      <td>45.260</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>2011</td>\n",
              "      <td>31</td>\n",
              "      <td>26</td>\n",
              "      <td>3</td>\n",
              "      <td>73.0</td>\n",
              "      <td>1008.6</td>\n",
              "      <td>0.118</td>\n",
              "      <td>96.6</td>\n",
              "      <td>1149.6</td>\n",
              "      <td>23.5</td>\n",
              "      <td>85.9</td>\n",
              "      <td>217.8</td>\n",
              "      <td>4.140</td>\n",
              "      <td>49.400</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>2012</td>\n",
              "      <td>31</td>\n",
              "      <td>26</td>\n",
              "      <td>3</td>\n",
              "      <td>91.0</td>\n",
              "      <td>1100.5</td>\n",
              "      <td>0.129</td>\n",
              "      <td>113.4</td>\n",
              "      <td>1263.0</td>\n",
              "      <td>19.0</td>\n",
              "      <td>67.1</td>\n",
              "      <td>284.9</td>\n",
              "      <td>5.145</td>\n",
              "      <td>54.545</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>2013</td>\n",
              "      <td>31</td>\n",
              "      <td>22</td>\n",
              "      <td>5</td>\n",
              "      <td>129.8</td>\n",
              "      <td>1230.2</td>\n",
              "      <td>0.144</td>\n",
              "      <td>152.8</td>\n",
              "      <td>1415.8</td>\n",
              "      <td>15.1</td>\n",
              "      <td>115.1</td>\n",
              "      <td>400.0</td>\n",
              "      <td>7.446</td>\n",
              "      <td>61.992</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>2014</td>\n",
              "      <td>31</td>\n",
              "      <td>22</td>\n",
              "      <td>5</td>\n",
              "      <td>171.0</td>\n",
              "      <td>1401.3</td>\n",
              "      <td>0.164</td>\n",
              "      <td>207.1</td>\n",
              "      <td>1622.9</td>\n",
              "      <td>17.4</td>\n",
              "      <td>193.9</td>\n",
              "      <td>593.9</td>\n",
              "      <td>4.773</td>\n",
              "      <td>66.765</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>2015</td>\n",
              "      <td>31</td>\n",
              "      <td>21</td>\n",
              "      <td>5</td>\n",
              "      <td>163.3</td>\n",
              "      <td>1564.5</td>\n",
              "      <td>0.183</td>\n",
              "      <td>209.0</td>\n",
              "      <td>1831.8</td>\n",
              "      <td>21.0</td>\n",
              "      <td>233.4</td>\n",
              "      <td>827.2</td>\n",
              "      <td>5.490</td>\n",
              "      <td>72.255</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "    year  well_total  well_production  ...  inject_total  gas_year  gas_total\n",
              "25  2006          28               26  ...           0.0     2.900     32.747\n",
              "26  2007          28               25  ...          25.1     2.786     35.533\n",
              "27  2008          28               25  ...          51.5     2.866     38.399\n",
              "28  2009          31               28  ...          80.9     3.066     41.466\n",
              "29  2010          31               27  ...         131.9     3.795     45.260\n",
              "30  2011          31               26  ...         217.8     4.140     49.400\n",
              "31  2012          31               26  ...         284.9     5.145     54.545\n",
              "32  2013          31               22  ...         400.0     7.446     61.992\n",
              "33  2014          31               22  ...         593.9     4.773     66.765\n",
              "34  2015          31               21  ...         827.2     5.490     72.255\n",
              "\n",
              "[10 rows x 14 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 817
        },
        "id": "zGNcZpd7iNOE",
        "outputId": "3547e40f-a913-491f-9fbf-579091abdd76"
      },
      "source": [
        "df_data = df_object3\n",
        "years = df_data['year']\n",
        "\n",
        "fig = go.Figure()\n",
        "\n",
        "fig.add_trace(go.Bar(x=years,\n",
        "                y=df_data['well_production'],\n",
        "                name='Действующий фонд <br>добывающих скважин',\n",
        "                marker_color='yellowgreen',\n",
        "                opacity=0.7\n",
        "                ))\n",
        "\n",
        "fig.add_trace(go.Bar(x=years,\n",
        "                y=df_data['well_injection'],\n",
        "                name='Действующий фонд <br>нагнетательных скважин',\n",
        "                marker_color='limegreen',\n",
        "                opacity=0.7\n",
        "                ))\n",
        "\n",
        "fig.add_trace(go.Scatter(x=years, \n",
        "                    y=df_data['oil_year'],\n",
        "                    mode='lines',\n",
        "                    marker_color='blue',\n",
        "                    name='Годовая добыча, млн т',\n",
        "    yaxis=\"y2\"))\n",
        "\n",
        "fig.add_trace(go.Scatter(x=years, \n",
        "                    y=df_data['water_cut'],\n",
        "                    mode='lines',\n",
        "                    marker_color='red',\n",
        "                    name='Обводненность, %',\n",
        "    yaxis=\"y3\"))\n",
        "\n",
        "fig.add_trace(go.Scatter(x=years, \n",
        "                    y=df_data['kin'] * 100,\n",
        "                    mode='lines',\n",
        "                    marker_color='magenta',\n",
        "                    name='КИН текущий, %',\n",
        "    yaxis=\"y4\"))\n",
        "\n",
        "shapes=[]\n",
        "#for year in [1986, 2002, 2010]:\n",
        "for year in [1986, 2002, 2014]:\n",
        "  shapes.append(\n",
        "      dict(\n",
        "          type= 'line',\n",
        "          yref= 'paper', y0= 0, y1= 1,\n",
        "          xref= 'x', x0= year, x1= year,\n",
        "          line=dict(\n",
        "                      color=\"Black\",\n",
        "                      width=4,\n",
        "                      dash=\"dashdot\",\n",
        "                  )\n",
        "      )\n",
        "  )\n",
        "\n",
        "fig.add_annotation(x=1994, y=28, text=\"I\", showarrow=False, yshift=10, font=anno_font)\n",
        "fig.add_annotation(x=2006, y=28, text=\"II\", showarrow=False, yshift=10, font=anno_font)\n",
        "fig.add_annotation(x=2015, y=28, text=\"III\", showarrow=False, yshift=10, font=anno_font)\n",
        "\n",
        "fig.update_layout( \n",
        "    shapes = shapes,\n",
        "    xaxis=dict(\n",
        "        domain=[0.1, 0.9],\n",
        "        #tickmode = 'array',\n",
        "        #tickvals = df_object2['year'],\n",
        "        tickangle=-45,\n",
        "        title='Год',\n",
        "    ),\n",
        "\n",
        "    yaxis=dict(\n",
        "        range=[0, 30],\n",
        "        title=\"Число скажин (шт)\",\n",
        "        titlefont=dict(\n",
        "            color=\"green\"\n",
        "        ),\n",
        "        tickfont=dict(\n",
        "            color=\"green\"\n",
        "        )\n",
        "    ),\n",
        "\n",
        "    yaxis2=dict(\n",
        "        range=[0, 180],\n",
        "        title=\"Годовая добыча, млн т\",\n",
        "        titlefont=dict(\n",
        "            color=\"blue\"\n",
        "        ),\n",
        "        tickfont=dict(\n",
        "            color=\"blue\"\n",
        "        ),\n",
        "        anchor=\"x\",\n",
        "        overlaying=\"y\",\n",
        "        side=\"right\"\n",
        "    ),\n",
        "\n",
        "    yaxis3=dict(\n",
        "        range=[0, 50],\n",
        "        title=\"Обводненность, %\",\n",
        "        titlefont=dict(\n",
        "            color=\"red\"\n",
        "        ),\n",
        "        tickfont=dict(\n",
        "            color=\"red\"\n",
        "        ),\n",
        "        anchor=\"free\",\n",
        "        overlaying=\"y\",\n",
        "        side=\"left\",\n",
        "        position=0.01\n",
        "    ),\n",
        "\n",
        "    yaxis4=dict(\n",
        "        range=[0, 25],\n",
        "        title=\"КИН текущий, %\",\n",
        "        titlefont=dict(\n",
        "            color=\"magenta\"\n",
        "        ),\n",
        "        tickfont=dict(\n",
        "            color=\"magenta\"\n",
        "        ),\n",
        "        anchor=\"free\",\n",
        "        overlaying=\"y\",\n",
        "        side=\"right\",\n",
        "        position=0.99\n",
        "    ),\n",
        "\n",
        "    title={\n",
        "        'text': \"Динамика разработки месторождения Объект 3\",\n",
        "        'y':0.95,\n",
        "        'x':0.4,\n",
        "        'xanchor': 'center',\n",
        "        'yanchor': 'top'},\n",
        "\n",
        "    autosize=False,\n",
        "    width=1300,\n",
        "    height=800)\n",
        "\n",
        "fig.show()\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<html>\n",
              "<head><meta charset=\"utf-8\" /></head>\n",
              "<body>\n",
              "    <div>\n",
              "            <script src=\"https://cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.5/MathJax.js?config=TeX-AMS-MML_SVG\"></script><script type=\"text/javascript\">if (window.MathJax) {MathJax.Hub.Config({SVG: {font: \"STIX-Web\"}});}</script>\n",
              "                <script type=\"text/javascript\">window.PlotlyConfig = {MathJaxConfig: 'local'};</script>\n",
              "        <script src=\"https://cdn.plot.ly/plotly-latest.min.js\"></script>    \n",
              "            <div id=\"714b00e5-db61-4dc3-b8ae-28a6e9e8b88d\" class=\"plotly-graph-div\" style=\"height:800px; width:1300px;\"></div>\n",
              "            <script type=\"text/javascript\">\n",
              "                \n",
              "                    window.PLOTLYENV=window.PLOTLYENV || {};\n",
              "                    \n",
              "                if (document.getElementById(\"714b00e5-db61-4dc3-b8ae-28a6e9e8b88d\")) {\n",
              "                    Plotly.newPlot(\n",
              "                        '714b00e5-db61-4dc3-b8ae-28a6e9e8b88d',\n",
              "                        [{\"marker\": {\"color\": \"yellowgreen\"}, \"name\": \"\\u0414\\u0435\\u0439\\u0441\\u0442\\u0432\\u0443\\u044e\\u0449\\u0438\\u0439 \\u0444\\u043e\\u043d\\u0434 <br>\\u0434\\u043e\\u0431\\u044b\\u0432\\u0430\\u044e\\u0449\\u0438\\u0445 \\u0441\\u043a\\u0432\\u0430\\u0436\\u0438\\u043d\", \"opacity\": 0.7, \"type\": \"bar\", \"x\": [1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015], \"y\": [1, 1, 1, 1, 1, 1, 4, 7, 9, 12, 13, 13, 15, 15, 14, 15, 15, 15, 15, 15, 18, 23, 27, 27, 27, 26, 25, 25, 28, 27, 26, 26, 22, 22, 21]}, {\"marker\": {\"color\": \"limegreen\"}, \"name\": \"\\u0414\\u0435\\u0439\\u0441\\u0442\\u0432\\u0443\\u044e\\u0449\\u0438\\u0439 \\u0444\\u043e\\u043d\\u0434 <br>\\u043d\\u0430\\u0433\\u043d\\u0435\\u0442\\u0430\\u0442\\u0435\\u043b\\u044c\\u043d\\u044b\\u0445 \\u0441\\u043a\\u0432\\u0430\\u0436\\u0438\\u043d\", \"opacity\": 0.7, \"type\": \"bar\", \"x\": [1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015], \"y\": [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 2, 2, 3, 3, 5, 5, 5]}, {\"marker\": {\"color\": \"blue\"}, \"mode\": \"lines\", \"name\": \"\\u0413\\u043e\\u0434\\u043e\\u0432\\u0430\\u044f \\u0434\\u043e\\u0431\\u044b\\u0447\\u0430, \\u043c\\u043b\\u043d \\u0442\", \"type\": \"scatter\", \"x\": [1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015], \"y\": [0.03, 3.7, 4.2, 5.3, 5.9, 6.3, 7.2, 14.5, 21.9, 15.2, 22.5, 23.7, 24.5, 20.0, 37.6, 40.8, 41.1, 45.0, 44.8, 38.1, 36.0, 44.7, 46.0, 54.4, 55.0, 51.8, 49.8, 51.1, 54.8, 67.7, 73.0, 91.0, 129.8, 171.0, 163.3], \"yaxis\": \"y2\"}, {\"marker\": {\"color\": \"red\"}, \"mode\": \"lines\", \"name\": \"\\u041e\\u0431\\u0432\\u043e\\u0434\\u043d\\u0435\\u043d\\u043d\\u043e\\u0441\\u0442\\u044c, %\", \"type\": \"scatter\", \"x\": [1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015], \"y\": [0.0, 0.6, 2.1, 2.6, 3.6, 5.0, 4.3, 3.0, 0.6, 0.7, 2.5, 5.9, 8.5, 6.1, 2.5, 3.4, 3.9, 7.8, 12.5, 10.1, 8.0, 10.2, 9.4, 8.1, 14.4, 14.0, 16.7, 22.0, 18.8, 21.5, 23.5, 19.0, 15.1, 17.4, 21.0], \"yaxis\": \"y3\"}, {\"marker\": {\"color\": \"magenta\"}, \"mode\": \"lines\", \"name\": \"\\u041a\\u0418\\u041d \\u0442\\u0435\\u043a\\u0443\\u0449\\u0438\\u0439, %\", \"type\": \"scatter\", \"x\": [1981, 1982, 1983, 1984, 1985, 1986, 1987, 1988, 1989, 1990, 1991, 1992, 1993, 1994, 1995, 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2015], \"y\": [0.0, 0.0, 0.1, 0.2, 0.2, 0.3, 0.4, 0.6, 0.8, 1.0, 1.2, 1.5, 1.8000000000000003, 2.0, 2.5, 3.0, 3.4000000000000004, 4.0, 4.5, 4.9, 5.4, 5.9, 6.4, 7.1, 7.7, 8.3, 8.9, 9.5, 10.1, 10.9, 11.8, 12.9, 14.400000000000002, 16.4, 18.3], \"yaxis\": \"y4\"}],\n",
              "                        {\"annotations\": [{\"font\": {\"color\": \"Black\", \"family\": \"arial bold\", \"size\": 36}, \"showarrow\": false, \"text\": \"I\", \"x\": 1994, \"y\": 28, \"yshift\": 10}, {\"font\": {\"color\": \"Black\", \"family\": \"arial bold\", \"size\": 36}, \"showarrow\": false, \"text\": \"II\", \"x\": 2006, \"y\": 28, \"yshift\": 10}, {\"font\": {\"color\": \"Black\", \"family\": \"arial bold\", \"size\": 36}, \"showarrow\": false, \"text\": \"III\", \"x\": 2015, \"y\": 28, \"yshift\": 10}], \"autosize\": false, \"height\": 800, \"shapes\": [{\"line\": {\"color\": \"Black\", \"dash\": \"dashdot\", \"width\": 4}, \"type\": \"line\", \"x0\": 1986, \"x1\": 1986, \"xref\": \"x\", \"y0\": 0, \"y1\": 1, \"yref\": \"paper\"}, {\"line\": {\"color\": \"Black\", \"dash\": \"dashdot\", \"width\": 4}, \"type\": \"line\", \"x0\": 2002, \"x1\": 2002, \"xref\": \"x\", \"y0\": 0, \"y1\": 1, \"yref\": \"paper\"}, {\"line\": {\"color\": \"Black\", \"dash\": \"dashdot\", \"width\": 4}, \"type\": \"line\", \"x0\": 2014, \"x1\": 2014, \"xref\": \"x\", \"y0\": 0, \"y1\": 1, \"yref\": \"paper\"}], \"template\": {\"data\": {\"bar\": [{\"error_x\": {\"color\": \"#2a3f5f\"}, \"error_y\": {\"color\": \"#2a3f5f\"}, \"marker\": {\"line\": {\"color\": \"#E5ECF6\", \"width\": 0.5}}, \"type\": \"bar\"}], \"barpolar\": [{\"marker\": {\"line\": {\"color\": \"#E5ECF6\", \"width\": 0.5}}, \"type\": \"barpolar\"}], \"carpet\": [{\"aaxis\": {\"endlinecolor\": \"#2a3f5f\", \"gridcolor\": \"white\", \"linecolor\": \"white\", \"minorgridcolor\": \"white\", \"startlinecolor\": \"#2a3f5f\"}, \"baxis\": {\"endlinecolor\": \"#2a3f5f\", \"gridcolor\": \"white\", \"linecolor\": \"white\", \"minorgridcolor\": \"white\", \"startlinecolor\": \"#2a3f5f\"}, \"type\": \"carpet\"}], \"choropleth\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"choropleth\"}], \"contour\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"contour\"}], \"contourcarpet\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"contourcarpet\"}], \"heatmap\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"heatmap\"}], \"heatmapgl\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"heatmapgl\"}], \"histogram\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"histogram\"}], \"histogram2d\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"histogram2d\"}], \"histogram2dcontour\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"histogram2dcontour\"}], \"mesh3d\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"mesh3d\"}], \"parcoords\": [{\"line\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"parcoords\"}], \"pie\": [{\"automargin\": true, \"type\": \"pie\"}], \"scatter\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatter\"}], \"scatter3d\": [{\"line\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatter3d\"}], \"scattercarpet\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattercarpet\"}], \"scattergeo\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattergeo\"}], \"scattergl\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattergl\"}], \"scattermapbox\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattermapbox\"}], \"scatterpolar\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterpolar\"}], \"scatterpolargl\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterpolargl\"}], \"scatterternary\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterternary\"}], \"surface\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"surface\"}], \"table\": [{\"cells\": {\"fill\": {\"color\": \"#EBF0F8\"}, \"line\": {\"color\": \"white\"}}, \"header\": {\"fill\": {\"color\": \"#C8D4E3\"}, \"line\": {\"color\": \"white\"}}, \"type\": \"table\"}]}, \"layout\": {\"annotationdefaults\": {\"arrowcolor\": \"#2a3f5f\", \"arrowhead\": 0, \"arrowwidth\": 1}, \"coloraxis\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"colorscale\": {\"diverging\": [[0, \"#8e0152\"], [0.1, \"#c51b7d\"], [0.2, \"#de77ae\"], [0.3, \"#f1b6da\"], [0.4, \"#fde0ef\"], [0.5, \"#f7f7f7\"], [0.6, \"#e6f5d0\"], [0.7, \"#b8e186\"], [0.8, \"#7fbc41\"], [0.9, \"#4d9221\"], [1, \"#276419\"]], \"sequential\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"sequentialminus\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]]}, \"colorway\": [\"#636efa\", \"#EF553B\", \"#00cc96\", \"#ab63fa\", \"#FFA15A\", \"#19d3f3\", \"#FF6692\", \"#B6E880\", \"#FF97FF\", \"#FECB52\"], \"font\": {\"color\": \"#2a3f5f\"}, \"geo\": {\"bgcolor\": \"white\", \"lakecolor\": \"white\", \"landcolor\": \"#E5ECF6\", \"showlakes\": true, \"showland\": true, \"subunitcolor\": \"white\"}, \"hoverlabel\": {\"align\": \"left\"}, \"hovermode\": \"closest\", \"mapbox\": {\"style\": \"light\"}, \"paper_bgcolor\": \"white\", \"plot_bgcolor\": \"#E5ECF6\", \"polar\": {\"angularaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"bgcolor\": \"#E5ECF6\", \"radialaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}}, \"scene\": {\"xaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}, \"yaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}, \"zaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}}, \"shapedefaults\": {\"line\": {\"color\": \"#2a3f5f\"}}, \"ternary\": {\"aaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"baxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"bgcolor\": \"#E5ECF6\", \"caxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}}, \"title\": {\"x\": 0.05}, \"xaxis\": {\"automargin\": true, \"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\", \"title\": {\"standoff\": 15}, \"zerolinecolor\": \"white\", \"zerolinewidth\": 2}, \"yaxis\": {\"automargin\": true, \"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\", \"title\": {\"standoff\": 15}, \"zerolinecolor\": \"white\", \"zerolinewidth\": 2}}}, \"title\": {\"text\": \"\\u0414\\u0438\\u043d\\u0430\\u043c\\u0438\\u043a\\u0430 \\u0440\\u0430\\u0437\\u0440\\u0430\\u0431\\u043e\\u0442\\u043a\\u0438 \\u043c\\u0435\\u0441\\u0442\\u043e\\u0440\\u043e\\u0436\\u0434\\u0435\\u043d\\u0438\\u044f \\u041e\\u0431\\u044a\\u0435\\u043a\\u0442 3\", \"x\": 0.4, \"xanchor\": \"center\", \"y\": 0.95, \"yanchor\": \"top\"}, \"width\": 1300, \"xaxis\": {\"domain\": [0.1, 0.9], \"tickangle\": -45, \"title\": {\"text\": \"\\u0413\\u043e\\u0434\"}}, \"yaxis\": {\"range\": [0, 30], \"tickfont\": {\"color\": \"green\"}, \"title\": {\"font\": {\"color\": \"green\"}, \"text\": \"\\u0427\\u0438\\u0441\\u043b\\u043e \\u0441\\u043a\\u0430\\u0436\\u0438\\u043d (\\u0448\\u0442)\"}}, \"yaxis2\": {\"anchor\": \"x\", \"overlaying\": \"y\", \"range\": [0, 180], \"side\": \"right\", \"tickfont\": {\"color\": \"blue\"}, \"title\": {\"font\": {\"color\": \"blue\"}, \"text\": \"\\u0413\\u043e\\u0434\\u043e\\u0432\\u0430\\u044f \\u0434\\u043e\\u0431\\u044b\\u0447\\u0430, \\u043c\\u043b\\u043d \\u0442\"}}, \"yaxis3\": {\"anchor\": \"free\", \"overlaying\": \"y\", \"position\": 0.01, \"range\": [0, 50], \"side\": \"left\", \"tickfont\": {\"color\": \"red\"}, \"title\": {\"font\": {\"color\": \"red\"}, \"text\": \"\\u041e\\u0431\\u0432\\u043e\\u0434\\u043d\\u0435\\u043d\\u043d\\u043e\\u0441\\u0442\\u044c, %\"}}, \"yaxis4\": {\"anchor\": \"free\", \"overlaying\": \"y\", \"position\": 0.99, \"range\": [0, 25], \"side\": \"right\", \"tickfont\": {\"color\": \"magenta\"}, \"title\": {\"font\": {\"color\": \"magenta\"}, \"text\": \"\\u041a\\u0418\\u041d \\u0442\\u0435\\u043a\\u0443\\u0449\\u0438\\u0439, %\"}}},\n",
              "                        {\"responsive\": true}\n",
              "                    ).then(function(){\n",
              "                            \n",
              "var gd = document.getElementById('714b00e5-db61-4dc3-b8ae-28a6e9e8b88d');\n",
              "var x = new MutationObserver(function (mutations, observer) {{\n",
              "        var display = window.getComputedStyle(gd).display;\n",
              "        if (!display || display === 'none') {{\n",
              "            console.log([gd, 'removed!']);\n",
              "            Plotly.purge(gd);\n",
              "            observer.disconnect();\n",
              "        }}\n",
              "}});\n",
              "\n",
              "// Listen for the removal of the full notebook cells\n",
              "var notebookContainer = gd.closest('#notebook-container');\n",
              "if (notebookContainer) {{\n",
              "    x.observe(notebookContainer, {childList: true});\n",
              "}}\n",
              "\n",
              "// Listen for the clearing of the current output cell\n",
              "var outputEl = gd.closest('.output');\n",
              "if (outputEl) {{\n",
              "    x.observe(outputEl, {childList: true});\n",
              "}}\n",
              "\n",
              "                        })\n",
              "                };\n",
              "                \n",
              "            </script>\n",
              "        </div>\n",
              "</body>\n",
              "</html>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "JAZYBV6-TL1-"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "RM66KxWg4151"
      },
      "source": [
        "## Объект №4"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 348
        },
        "id": "SZ7KiQjp44Rf",
        "outputId": "aedbc0e1-4c5f-4499-b373-feeaf1cec7b8"
      },
      "source": [
        "df_object4 = pd.read_csv('https://raw.githubusercontent.com/alexeynick/msu_oil_gas/main/datasets/dynamic_object_4.csv')\n",
        "df_object4.tail(10)"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/html": [
              "<div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>year</th>\n",
              "      <th>well_production</th>\n",
              "      <th>oil_year</th>\n",
              "      <th>fluid_year</th>\n",
              "      <th>water_cut</th>\n",
              "      <th>production_frac</th>\n",
              "      <th>well_injection</th>\n",
              "      <th>inject_year</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>50</th>\n",
              "      <td>2037</td>\n",
              "      <td>14.0</td>\n",
              "      <td>6.116227</td>\n",
              "      <td>131.513</td>\n",
              "      <td>95.349337</td>\n",
              "      <td>0.399805</td>\n",
              "      <td>8.0</td>\n",
              "      <td>134.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>51</th>\n",
              "      <td>2038</td>\n",
              "      <td>14.0</td>\n",
              "      <td>5.091627</td>\n",
              "      <td>131.528</td>\n",
              "      <td>96.128865</td>\n",
              "      <td>0.332829</td>\n",
              "      <td>7.0</td>\n",
              "      <td>133.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>52</th>\n",
              "      <td>2039</td>\n",
              "      <td>14.0</td>\n",
              "      <td>4.234155</td>\n",
              "      <td>122.830</td>\n",
              "      <td>96.552833</td>\n",
              "      <td>0.276778</td>\n",
              "      <td>7.0</td>\n",
              "      <td>124.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>53</th>\n",
              "      <td>2040</td>\n",
              "      <td>12.0</td>\n",
              "      <td>3.430484</td>\n",
              "      <td>108.436</td>\n",
              "      <td>96.836398</td>\n",
              "      <td>0.224243</td>\n",
              "      <td>6.0</td>\n",
              "      <td>109.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>54</th>\n",
              "      <td>2041</td>\n",
              "      <td>11.0</td>\n",
              "      <td>2.859560</td>\n",
              "      <td>102.281</td>\n",
              "      <td>97.204212</td>\n",
              "      <td>0.186923</td>\n",
              "      <td>6.0</td>\n",
              "      <td>103.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>55</th>\n",
              "      <td>2042</td>\n",
              "      <td>10.0</td>\n",
              "      <td>2.346551</td>\n",
              "      <td>94.431</td>\n",
              "      <td>97.515063</td>\n",
              "      <td>0.153389</td>\n",
              "      <td>5.0</td>\n",
              "      <td>95.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>56</th>\n",
              "      <td>2043</td>\n",
              "      <td>9.0</td>\n",
              "      <td>1.900510</td>\n",
              "      <td>78.543</td>\n",
              "      <td>97.580293</td>\n",
              "      <td>0.124232</td>\n",
              "      <td>4.0</td>\n",
              "      <td>79.3</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>57</th>\n",
              "      <td>2044</td>\n",
              "      <td>8.0</td>\n",
              "      <td>1.590848</td>\n",
              "      <td>70.033</td>\n",
              "      <td>97.728431</td>\n",
              "      <td>0.103990</td>\n",
              "      <td>4.0</td>\n",
              "      <td>70.7</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>58</th>\n",
              "      <td>2045</td>\n",
              "      <td>6.0</td>\n",
              "      <td>1.297058</td>\n",
              "      <td>59.448</td>\n",
              "      <td>97.818163</td>\n",
              "      <td>0.084786</td>\n",
              "      <td>4.0</td>\n",
              "      <td>60.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>59</th>\n",
              "      <td>2046</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.106178</td>\n",
              "      <td>56.462</td>\n",
              "      <td>98.040845</td>\n",
              "      <td>0.072309</td>\n",
              "      <td>0.0</td>\n",
              "      <td>59.9</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "    year  well_production  ...  well_injection  inject_year\n",
              "50  2037             14.0  ...             8.0        134.0\n",
              "51  2038             14.0  ...             7.0        133.6\n",
              "52  2039             14.0  ...             7.0        124.6\n",
              "53  2040             12.0  ...             6.0        109.8\n",
              "54  2041             11.0  ...             6.0        103.4\n",
              "55  2042             10.0  ...             5.0         95.4\n",
              "56  2043              9.0  ...             4.0         79.3\n",
              "57  2044              8.0  ...             4.0         70.7\n",
              "58  2045              6.0  ...             4.0         60.0\n",
              "59  2046              0.0  ...             0.0         59.9\n",
              "\n",
              "[10 rows x 8 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Yq9evPoz5CZm",
        "outputId": "cfbda64f-2859-4c43-ef3c-302d757ba031"
      },
      "source": [
        "imputer_nn_mean = KNNImputer(n_neighbors=10)\n",
        "\n",
        "imputer_nn_mean"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "KNNImputer(add_indicator=False, copy=True, metric='nan_euclidean',\n",
              "           missing_values=nan, n_neighbors=10, weights='uniform')"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "fOebn2wb5NMs"
      },
      "source": [
        "imputed_df = imputer_nn_mean.fit_transform(df_object4)\n",
        "\n",
        "df_object4 = pd.DataFrame(imputed_df, columns=df_object4.columns, index=df_object4.index)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 817
        },
        "id": "_o1nHkL35x6d",
        "outputId": "696f32d3-39c3-4bd4-9aa8-1b1d26788ef0"
      },
      "source": [
        "df_data = df_object4\n",
        "years = df_data['year']\n",
        "\n",
        "fig = go.Figure()\n",
        "\n",
        "fig.add_trace(go.Bar(x=years,\n",
        "                y=df_data['well_production'],\n",
        "                name='Действующий фонд <br>добывающих скважин',\n",
        "                marker_color='yellowgreen',\n",
        "                opacity=0.7\n",
        "                ))\n",
        "\n",
        "fig.add_trace(go.Bar(x=years,\n",
        "                y=df_data['well_injection'],\n",
        "                name='Действующий фонд <br>нагнетательных скважин',\n",
        "                marker_color='limegreen',\n",
        "                opacity=0.7\n",
        "                ))\n",
        "\n",
        "fig.add_trace(go.Scatter(x=years, \n",
        "                    y=df_data['oil_year'],\n",
        "                    mode='lines',\n",
        "                    marker_color='blue',\n",
        "                    name='Годовая добыча, млн т',\n",
        "    yaxis=\"y2\"))\n",
        "\n",
        "fig.add_trace(go.Scatter(x=years, \n",
        "                    y=df_data['water_cut'],\n",
        "                    mode='lines',\n",
        "                    marker_color='red',\n",
        "                    name='Обводненность, %',\n",
        "    yaxis=\"y3\"))\n",
        "\n",
        "shapes=[]\n",
        "#for year in [1994, 2012, 2030]:\n",
        "for year in [1994, 2012, 2033]:\n",
        "  shapes.append(\n",
        "      dict(\n",
        "          type= 'line',\n",
        "          yref= 'paper', y0= 0, y1= 1,\n",
        "          xref= 'x', x0= year, x1= year,\n",
        "          line=dict(\n",
        "                      color=\"Black\",\n",
        "                      width=4,\n",
        "                      dash=\"dashdot\",\n",
        "                  )\n",
        "      )\n",
        "  )\n",
        "\n",
        "fig.add_annotation(x=1990, y=30, text=\"I\", showarrow=False, yshift=10, font=anno_font)\n",
        "fig.add_annotation(x=2003, y=30, text=\"II\", showarrow=False, yshift=10, font=anno_font)\n",
        "fig.add_annotation(x=2021, y=30, text=\"III\", showarrow=False, yshift=10, font=anno_font)\n",
        "fig.add_annotation(x=2040, y=30, text=\"IV\", showarrow=False, yshift=10, font=anno_font)\n",
        "\n",
        "fig.update_layout( \n",
        "    shapes = shapes,\n",
        "    xaxis=dict(\n",
        "        domain=[0.1, 0.9],\n",
        "        tickmode = 'array',\n",
        "        tickvals = list(filter(lambda x : x % 5 == 0, df_data['year'])),\n",
        "        tickangle=-45,\n",
        "        title='Год',\n",
        "    ),\n",
        "\n",
        "    yaxis=dict(\n",
        "        range=[0, 32],\n",
        "        title=\"Число скажин (шт)\",\n",
        "        titlefont=dict(\n",
        "            color=\"green\"\n",
        "        ),\n",
        "        tickfont=dict(\n",
        "            color=\"green\"\n",
        "        )\n",
        "    ),\n",
        "\n",
        "    yaxis2=dict(\n",
        "        range=[0, 90],\n",
        "        title=\"Годовая добыча, млн т\",\n",
        "        titlefont=dict(\n",
        "            color=\"blue\"\n",
        "        ),\n",
        "        tickfont=dict(\n",
        "            color=\"blue\"\n",
        "        ),\n",
        "        anchor=\"x\",\n",
        "        overlaying=\"y\",\n",
        "        side=\"right\"\n",
        "    ),\n",
        "\n",
        "    yaxis3=dict(\n",
        "        range=[0, 110],\n",
        "        title=\"Обводненность, %\",\n",
        "        titlefont=dict(\n",
        "            color=\"red\"\n",
        "        ),\n",
        "        tickfont=dict(\n",
        "            color=\"red\"\n",
        "        ),\n",
        "        anchor=\"free\",\n",
        "        overlaying=\"y\",\n",
        "        side=\"left\",\n",
        "        position=0.01\n",
        "    ),\n",
        "\n",
        "    title={\n",
        "        'text': \"Динамика разработки месторождения Объект 4\",\n",
        "        'y':0.95,\n",
        "        'x':0.4,\n",
        "        'xanchor': 'center',\n",
        "        'yanchor': 'top'},\n",
        "\n",
        "    autosize=False,\n",
        "    width=1400,\n",
        "    height=800)\n",
        "\n",
        "fig.show()\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/html": [
              "<html>\n",
              "<head><meta charset=\"utf-8\" /></head>\n",
              "<body>\n",
              "    <div>\n",
              "            <script src=\"https://cdnjs.cloudflare.com/ajax/libs/mathjax/2.7.5/MathJax.js?config=TeX-AMS-MML_SVG\"></script><script type=\"text/javascript\">if (window.MathJax) {MathJax.Hub.Config({SVG: {font: \"STIX-Web\"}});}</script>\n",
              "                <script type=\"text/javascript\">window.PlotlyConfig = {MathJaxConfig: 'local'};</script>\n",
              "        <script src=\"https://cdn.plot.ly/plotly-latest.min.js\"></script>    \n",
              "            <div id=\"ee302967-4512-4946-9b78-8a39f7d64d56\" class=\"plotly-graph-div\" style=\"height:800px; width:1400px;\"></div>\n",
              "            <script type=\"text/javascript\">\n",
              "                \n",
              "                    window.PLOTLYENV=window.PLOTLYENV || {};\n",
              "                    \n",
              "                if (document.getElementById(\"ee302967-4512-4946-9b78-8a39f7d64d56\")) {\n",
              "                    Plotly.newPlot(\n",
              "                        'ee302967-4512-4946-9b78-8a39f7d64d56',\n",
              "                        [{\"marker\": {\"color\": \"yellowgreen\"}, \"name\": \"\\u0414\\u0435\\u0439\\u0441\\u0442\\u0432\\u0443\\u044e\\u0449\\u0438\\u0439 \\u0444\\u043e\\u043d\\u0434 <br>\\u0434\\u043e\\u0431\\u044b\\u0432\\u0430\\u044e\\u0449\\u0438\\u0445 \\u0441\\u043a\\u0432\\u0430\\u0436\\u0438\\u043d\", \"opacity\": 0.7, \"type\": \"bar\", \"x\": [1987.0, 1988.0, 1989.0, 1990.0, 1991.0, 1992.0, 1993.0, 1994.0, 1995.0, 1996.0, 1997.0, 1998.0, 1999.0, 2000.0, 2001.0, 2002.0, 2003.0, 2004.0, 2005.0, 2006.0, 2007.0, 2008.0, 2009.0, 2010.0, 2011.0, 2012.0, 2013.0, 2014.0, 2015.0, 2016.0, 2017.0, 2018.0, 2019.0, 2020.0, 2021.0, 2022.0, 2023.0, 2024.0, 2025.0, 2026.0, 2027.0, 2028.0, 2029.0, 2030.0, 2031.0, 2032.0, 2033.0, 2034.0, 2035.0, 2036.0, 2037.0, 2038.0, 2039.0, 2040.0, 2041.0, 2042.0, 2043.0, 2044.0, 2045.0, 2046.0], \"y\": [7.0, 7.0, 9.0, 10.0, 12.0, 13.0, 17.0, 18.0, 18.0, 17.0, 17.0, 15.0, 17.0, 19.0, 23.0, 22.0, 24.0, 23.0, 23.0, 23.0, 24.0, 24.0, 24.0, 24.0, 23.0, 23.0, 24.0, 27.0, 27.0, 25.9, 26.0, 27.0, 27.0, 28.0, 27.0, 27.0, 27.0, 27.0, 26.0, 26.0, 26.0, 26.0, 25.0, 24.0, 24.0, 22.0, 21.0, 19.0, 17.0, 15.0, 14.0, 14.0, 14.0, 12.0, 11.0, 10.0, 9.0, 8.0, 6.0, 0.0]}, {\"marker\": {\"color\": \"limegreen\"}, \"name\": \"\\u0414\\u0435\\u0439\\u0441\\u0442\\u0432\\u0443\\u044e\\u0449\\u0438\\u0439 \\u0444\\u043e\\u043d\\u0434 <br>\\u043d\\u0430\\u0433\\u043d\\u0435\\u0442\\u0430\\u0442\\u0435\\u043b\\u044c\\u043d\\u044b\\u0445 \\u0441\\u043a\\u0432\\u0430\\u0436\\u0438\\u043d\", \"opacity\": 0.7, \"type\": \"bar\", \"x\": [1987.0, 1988.0, 1989.0, 1990.0, 1991.0, 1992.0, 1993.0, 1994.0, 1995.0, 1996.0, 1997.0, 1998.0, 1999.0, 2000.0, 2001.0, 2002.0, 2003.0, 2004.0, 2005.0, 2006.0, 2007.0, 2008.0, 2009.0, 2010.0, 2011.0, 2012.0, 2013.0, 2014.0, 2015.0, 2016.0, 2017.0, 2018.0, 2019.0, 2020.0, 2021.0, 2022.0, 2023.0, 2024.0, 2025.0, 2026.0, 2027.0, 2028.0, 2029.0, 2030.0, 2031.0, 2032.0, 2033.0, 2034.0, 2035.0, 2036.0, 2037.0, 2038.0, 2039.0, 2040.0, 2041.0, 2042.0, 2043.0, 2044.0, 2045.0, 2046.0], \"y\": [1.0, 3.0, 4.0, 5.0, 5.0, 5.0, 3.0, 6.0, 6.0, 6.0, 6.0, 4.0, 2.0, 2.0, 2.0, 2.0, 2.0, 4.0, 4.0, 4.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 5.0, 6.0, 6.7, 7.0, 8.0, 8.0, 9.0, 9.0, 9.0, 9.0, 9.0, 9.0, 9.0, 9.0, 9.0, 9.0, 9.0, 9.0, 9.0, 9.0, 9.0, 9.0, 9.0, 8.0, 7.0, 7.0, 6.0, 6.0, 5.0, 4.0, 4.0, 4.0, 0.0]}, {\"marker\": {\"color\": \"blue\"}, \"mode\": \"lines\", \"name\": \"\\u0413\\u043e\\u0434\\u043e\\u0432\\u0430\\u044f \\u0434\\u043e\\u0431\\u044b\\u0447\\u0430, \\u043c\\u043b\\u043d \\u0442\", \"type\": \"scatter\", \"x\": [1987.0, 1988.0, 1989.0, 1990.0, 1991.0, 1992.0, 1993.0, 1994.0, 1995.0, 1996.0, 1997.0, 1998.0, 1999.0, 2000.0, 2001.0, 2002.0, 2003.0, 2004.0, 2005.0, 2006.0, 2007.0, 2008.0, 2009.0, 2010.0, 2011.0, 2012.0, 2013.0, 2014.0, 2015.0, 2016.0, 2017.0, 2018.0, 2019.0, 2020.0, 2021.0, 2022.0, 2023.0, 2024.0, 2025.0, 2026.0, 2027.0, 2028.0, 2029.0, 2030.0, 2031.0, 2032.0, 2033.0, 2034.0, 2035.0, 2036.0, 2037.0, 2038.0, 2039.0, 2040.0, 2041.0, 2042.0, 2043.0, 2044.0, 2045.0, 2046.0], \"y\": [10.481, 12.585999999999999, 15.282, 18.941, 23.176, 24.138, 29.474, 22.901999999999997, 27.638, 24.99, 24.237, 30.516, 31.932040500925897, 35.424, 43.498000000000005, 43.873999999999995, 51.644, 64.536, 67.104, 67.729, 58.821000000000005, 66.589, 55.17, 53.6, 53.0710029849368, 61.785075528216, 62.433, 58.7709600000001, 48.8621999999998, 47.07263985131529, 41.1856800000001, 39.7031999999999, 38.1184800000001, 34.77864, 32.0181600000001, 29.7944399999999, 26.9572800000001, 24.4779599999999, 22.2031199999999, 20.45652, 18.590640000000104, 17.2444800000001, 15.9494400000001, 14.6458799999998, 13.6831200000001, 12.5158799999999, 11.289000000000001, 9.988924630986741, 8.50498683098683, 7.274226830986859, 6.11622683098675, 5.09162683098684, 4.23415483098684, 3.4304839999999905, 2.8595600000001, 2.34655079999999, 1.90051024, 1.59084800000002, 1.2970584031999899, 1.106178068], \"yaxis\": \"y2\"}, {\"marker\": {\"color\": \"red\"}, \"mode\": \"lines\", \"name\": \"\\u041e\\u0431\\u0432\\u043e\\u0434\\u043d\\u0435\\u043d\\u043d\\u043e\\u0441\\u0442\\u044c, %\", \"type\": \"scatter\", \"x\": [1987.0, 1988.0, 1989.0, 1990.0, 1991.0, 1992.0, 1993.0, 1994.0, 1995.0, 1996.0, 1997.0, 1998.0, 1999.0, 2000.0, 2001.0, 2002.0, 2003.0, 2004.0, 2005.0, 2006.0, 2007.0, 2008.0, 2009.0, 2010.0, 2011.0, 2012.0, 2013.0, 2014.0, 2015.0, 2016.0, 2017.0, 2018.0, 2019.0, 2020.0, 2021.0, 2022.0, 2023.0, 2024.0, 2025.0, 2026.0, 2027.0, 2028.0, 2029.0, 2030.0, 2031.0, 2032.0, 2033.0, 2034.0, 2035.0, 2036.0, 2037.0, 2038.0, 2039.0, 2040.0, 2041.0, 2042.0, 2043.0, 2044.0, 2045.0, 2046.0], \"y\": [2.8817642698294996, 4.10666666666667, 3.61400189214759, 3.69146285656177, 4.68435122352459, 12.3656694742957, 17.720953603930603, 28.3080294255752, 30.9343529000175, 35.5927835051546, 36.285488958990506, 33.4118879287772, 43.7776595166457, 38.947295853297, 30.947883098122002, 34.3812628997039, 29.8162644053055, 27.7482338979635, 29.2069754929369, 33.3211912380015, 31.1882172646553, 33.2978731929352, 45.743676487943, 47.160362385275896, 54.82030793039989, 56.1528, 59.5728905969236, 69.7605581625092, 75.1765656196182, 72.83337863782309, 79.84699924155309, 81.2035393202574, 82.3946128692567, 84.2339522738812, 85.1715603638317, 86.40745995611259, 87.8175704989154, 89.0638442361478, 90.0091255163477, 90.61950246474841, 91.5269860079303, 92.1935708756411, 92.56467560801642, 92.89448864739, 93.3850675845532, 93.64863136741471, 94.0951554016592, 94.4383927891836, 94.4983945824874, 94.71653132940621, 95.3493366960021, 96.1288647048637, 96.55283332167481, 96.8363975063632, 97.2042119259686, 97.5150630619183, 97.5802932915728, 97.72843088258391, 97.818163095142, 98.04084504976801], \"yaxis\": \"y3\"}],\n",
              "                        {\"annotations\": [{\"font\": {\"color\": \"Black\", \"family\": \"arial bold\", \"size\": 36}, \"showarrow\": false, \"text\": \"I\", \"x\": 1990, \"y\": 30, \"yshift\": 10}, {\"font\": {\"color\": \"Black\", \"family\": \"arial bold\", \"size\": 36}, \"showarrow\": false, \"text\": \"II\", \"x\": 2003, \"y\": 30, \"yshift\": 10}, {\"font\": {\"color\": \"Black\", \"family\": \"arial bold\", \"size\": 36}, \"showarrow\": false, \"text\": \"III\", \"x\": 2021, \"y\": 30, \"yshift\": 10}, {\"font\": {\"color\": \"Black\", \"family\": \"arial bold\", \"size\": 36}, \"showarrow\": false, \"text\": \"IV\", \"x\": 2040, \"y\": 30, \"yshift\": 10}], \"autosize\": false, \"height\": 800, \"shapes\": [{\"line\": {\"color\": \"Black\", \"dash\": \"dashdot\", \"width\": 4}, \"type\": \"line\", \"x0\": 1994, \"x1\": 1994, \"xref\": \"x\", \"y0\": 0, \"y1\": 1, \"yref\": \"paper\"}, {\"line\": {\"color\": \"Black\", \"dash\": \"dashdot\", \"width\": 4}, \"type\": \"line\", \"x0\": 2012, \"x1\": 2012, \"xref\": \"x\", \"y0\": 0, \"y1\": 1, \"yref\": \"paper\"}, {\"line\": {\"color\": \"Black\", \"dash\": \"dashdot\", \"width\": 4}, \"type\": \"line\", \"x0\": 2033, \"x1\": 2033, \"xref\": \"x\", \"y0\": 0, \"y1\": 1, \"yref\": \"paper\"}], \"template\": {\"data\": {\"bar\": [{\"error_x\": {\"color\": \"#2a3f5f\"}, \"error_y\": {\"color\": \"#2a3f5f\"}, \"marker\": {\"line\": {\"color\": \"#E5ECF6\", \"width\": 0.5}}, \"type\": \"bar\"}], \"barpolar\": [{\"marker\": {\"line\": {\"color\": \"#E5ECF6\", \"width\": 0.5}}, \"type\": \"barpolar\"}], \"carpet\": [{\"aaxis\": {\"endlinecolor\": \"#2a3f5f\", \"gridcolor\": \"white\", \"linecolor\": \"white\", \"minorgridcolor\": \"white\", \"startlinecolor\": \"#2a3f5f\"}, \"baxis\": {\"endlinecolor\": \"#2a3f5f\", \"gridcolor\": \"white\", \"linecolor\": \"white\", \"minorgridcolor\": \"white\", \"startlinecolor\": \"#2a3f5f\"}, \"type\": \"carpet\"}], \"choropleth\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"choropleth\"}], \"contour\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"contour\"}], \"contourcarpet\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"contourcarpet\"}], \"heatmap\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"heatmap\"}], \"heatmapgl\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"heatmapgl\"}], \"histogram\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"histogram\"}], \"histogram2d\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"histogram2d\"}], \"histogram2dcontour\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"histogram2dcontour\"}], \"mesh3d\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"type\": \"mesh3d\"}], \"parcoords\": [{\"line\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"parcoords\"}], \"pie\": [{\"automargin\": true, \"type\": \"pie\"}], \"scatter\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatter\"}], \"scatter3d\": [{\"line\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatter3d\"}], \"scattercarpet\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattercarpet\"}], \"scattergeo\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattergeo\"}], \"scattergl\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattergl\"}], \"scattermapbox\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scattermapbox\"}], \"scatterpolar\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterpolar\"}], \"scatterpolargl\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterpolargl\"}], \"scatterternary\": [{\"marker\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"type\": \"scatterternary\"}], \"surface\": [{\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}, \"colorscale\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"type\": \"surface\"}], \"table\": [{\"cells\": {\"fill\": {\"color\": \"#EBF0F8\"}, \"line\": {\"color\": \"white\"}}, \"header\": {\"fill\": {\"color\": \"#C8D4E3\"}, \"line\": {\"color\": \"white\"}}, \"type\": \"table\"}]}, \"layout\": {\"annotationdefaults\": {\"arrowcolor\": \"#2a3f5f\", \"arrowhead\": 0, \"arrowwidth\": 1}, \"coloraxis\": {\"colorbar\": {\"outlinewidth\": 0, \"ticks\": \"\"}}, \"colorscale\": {\"diverging\": [[0, \"#8e0152\"], [0.1, \"#c51b7d\"], [0.2, \"#de77ae\"], [0.3, \"#f1b6da\"], [0.4, \"#fde0ef\"], [0.5, \"#f7f7f7\"], [0.6, \"#e6f5d0\"], [0.7, \"#b8e186\"], [0.8, \"#7fbc41\"], [0.9, \"#4d9221\"], [1, \"#276419\"]], \"sequential\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]], \"sequentialminus\": [[0.0, \"#0d0887\"], [0.1111111111111111, \"#46039f\"], [0.2222222222222222, \"#7201a8\"], [0.3333333333333333, \"#9c179e\"], [0.4444444444444444, \"#bd3786\"], [0.5555555555555556, \"#d8576b\"], [0.6666666666666666, \"#ed7953\"], [0.7777777777777778, \"#fb9f3a\"], [0.8888888888888888, \"#fdca26\"], [1.0, \"#f0f921\"]]}, \"colorway\": [\"#636efa\", \"#EF553B\", \"#00cc96\", \"#ab63fa\", \"#FFA15A\", \"#19d3f3\", \"#FF6692\", \"#B6E880\", \"#FF97FF\", \"#FECB52\"], \"font\": {\"color\": \"#2a3f5f\"}, \"geo\": {\"bgcolor\": \"white\", \"lakecolor\": \"white\", \"landcolor\": \"#E5ECF6\", \"showlakes\": true, \"showland\": true, \"subunitcolor\": \"white\"}, \"hoverlabel\": {\"align\": \"left\"}, \"hovermode\": \"closest\", \"mapbox\": {\"style\": \"light\"}, \"paper_bgcolor\": \"white\", \"plot_bgcolor\": \"#E5ECF6\", \"polar\": {\"angularaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"bgcolor\": \"#E5ECF6\", \"radialaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}}, \"scene\": {\"xaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}, \"yaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}, \"zaxis\": {\"backgroundcolor\": \"#E5ECF6\", \"gridcolor\": \"white\", \"gridwidth\": 2, \"linecolor\": \"white\", \"showbackground\": true, \"ticks\": \"\", \"zerolinecolor\": \"white\"}}, \"shapedefaults\": {\"line\": {\"color\": \"#2a3f5f\"}}, \"ternary\": {\"aaxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"baxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}, \"bgcolor\": \"#E5ECF6\", \"caxis\": {\"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\"}}, \"title\": {\"x\": 0.05}, \"xaxis\": {\"automargin\": true, \"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\", \"title\": {\"standoff\": 15}, \"zerolinecolor\": \"white\", \"zerolinewidth\": 2}, \"yaxis\": {\"automargin\": true, \"gridcolor\": \"white\", \"linecolor\": \"white\", \"ticks\": \"\", \"title\": {\"standoff\": 15}, \"zerolinecolor\": \"white\", \"zerolinewidth\": 2}}}, \"title\": {\"text\": \"\\u0414\\u0438\\u043d\\u0430\\u043c\\u0438\\u043a\\u0430 \\u0440\\u0430\\u0437\\u0440\\u0430\\u0431\\u043e\\u0442\\u043a\\u0438 \\u043c\\u0435\\u0441\\u0442\\u043e\\u0440\\u043e\\u0436\\u0434\\u0435\\u043d\\u0438\\u044f \\u041e\\u0431\\u044a\\u0435\\u043a\\u0442 4\", \"x\": 0.4, \"xanchor\": \"center\", \"y\": 0.95, \"yanchor\": \"top\"}, \"width\": 1400, \"xaxis\": {\"domain\": [0.1, 0.9], \"tickangle\": -45, \"tickmode\": \"array\", \"tickvals\": [1990.0, 1995.0, 2000.0, 2005.0, 2010.0, 2015.0, 2020.0, 2025.0, 2030.0, 2035.0, 2040.0, 2045.0], \"title\": {\"text\": \"\\u0413\\u043e\\u0434\"}}, \"yaxis\": {\"range\": [0, 32], \"tickfont\": {\"color\": \"green\"}, \"title\": {\"font\": {\"color\": \"green\"}, \"text\": \"\\u0427\\u0438\\u0441\\u043b\\u043e \\u0441\\u043a\\u0430\\u0436\\u0438\\u043d (\\u0448\\u0442)\"}}, \"yaxis2\": {\"anchor\": \"x\", \"overlaying\": \"y\", \"range\": [0, 90], \"side\": \"right\", \"tickfont\": {\"color\": \"blue\"}, \"title\": {\"font\": {\"color\": \"blue\"}, \"text\": \"\\u0413\\u043e\\u0434\\u043e\\u0432\\u0430\\u044f \\u0434\\u043e\\u0431\\u044b\\u0447\\u0430, \\u043c\\u043b\\u043d \\u0442\"}}, \"yaxis3\": {\"anchor\": \"free\", \"overlaying\": \"y\", \"position\": 0.01, \"range\": [0, 110], \"side\": \"left\", \"tickfont\": {\"color\": \"red\"}, \"title\": {\"font\": {\"color\": \"red\"}, \"text\": \"\\u041e\\u0431\\u0432\\u043e\\u0434\\u043d\\u0435\\u043d\\u043d\\u043e\\u0441\\u0442\\u044c, %\"}}},\n",
              "                        {\"responsive\": true}\n",
              "                    ).then(function(){\n",
              "                            \n",
              "var gd = document.getElementById('ee302967-4512-4946-9b78-8a39f7d64d56');\n",
              "var x = new MutationObserver(function (mutations, observer) {{\n",
              "        var display = window.getComputedStyle(gd).display;\n",
              "        if (!display || display === 'none') {{\n",
              "            console.log([gd, 'removed!']);\n",
              "            Plotly.purge(gd);\n",
              "            observer.disconnect();\n",
              "        }}\n",
              "}});\n",
              "\n",
              "// Listen for the removal of the full notebook cells\n",
              "var notebookContainer = gd.closest('#notebook-container');\n",
              "if (notebookContainer) {{\n",
              "    x.observe(notebookContainer, {childList: true});\n",
              "}}\n",
              "\n",
              "// Listen for the clearing of the current output cell\n",
              "var outputEl = gd.closest('.output');\n",
              "if (outputEl) {{\n",
              "    x.observe(outputEl, {childList: true});\n",
              "}}\n",
              "\n",
              "                        })\n",
              "                };\n",
              "                \n",
              "            </script>\n",
              "        </div>\n",
              "</body>\n",
              "</html>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "rTEZsbDn7aUm"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Pn0SlaUT5B5J"
      },
      "source": [
        "Комментарий от Ксении Александровны:\n",
        "\n",
        "Объект 1 (башскирский ярус)-смею предположить, что объект еще не достиг\n",
        "4-й стадии, 2-ю стадию я бы сместила. Есть такое правило ( я вам не\n",
        "говорила, забыла), что ко второй стадии могут примыкать года, в которых\n",
        "отличие годовой добычи не более 10%.\n",
        "\n",
        " Ось добычи желательно подписывать \"Годовая добыча\",слово \"объемы\" не\n",
        "надо. Но это мелочи.\n",
        "\n",
        "\n",
        "Объект 2-вторая стадия характеризуется максимальными отборами УВ.\n",
        "Посмотрите еще раз.На счет 4-1 стадии более менее согласна, хотя есть\n",
        "некоторая неопределенность в тренде этого хвоста, я бы наверно не стала\n",
        "выделять.\n",
        "\n",
        "Объект 3-тоже самое-вторая стадия характеризуется максимальными отборами\n",
        "УВ. Посмотрите еще разок.\n",
        "\n",
        "Объект 4-все ОК, чуть-чуть бы правую границу сместить на 2 года. В целом ОК."
      ]
    }
  ]
}