for_prediction_Final_mean_monthly_flow.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"provenance":[{"file_id":"11h7KyEZA9c_MFkdPpv5DHe8CoWkOwAtx","timestamp":1651168872276},{"file_id":"1O3kCZ_0JbSKcdAa8jPrA53aZNC2b72VO","timestamp":1651085761893}],"collapsed_sections":[]},"kernelspec":{"name":"python3","display_name":"Python 3"},"language_info":{"name":"python"}},"cells":[{"cell_type":"code","execution_count":null,"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"0eYaSEslR--x","executionInfo":{"status":"ok","timestamp":1653560456798,"user_tz":-360,"elapsed":4832,"user":{"displayName":"tasfia tasnim","userId":"13178643082102812040"}},"outputId":"bd73ce3c-f758-4229-e9d1-4389507607f3"},"outputs":[{"output_type":"stream","name":"stdout","text":["Mounted at /content/gdrive\n"]}],"source":["import pandas as pd\n","import numpy as np\n","\n","from google.colab import drive\n","\n","drive.mount('/content/gdrive')\n","root_path = 'gdrive/My Drive/'"]},{"cell_type":"code","source":["from google.colab import drive\n","drive.mount('/content/drive')"],"metadata":{"id":"wzJx2Cbg1ooK","colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"status":"ok","timestamp":1653560460855,"user_tz":-360,"elapsed":4070,"user":{"displayName":"tasfia tasnim","userId":"13178643082102812040"}},"outputId":"4440cba2-d99a-48c8-f7b0-0e53dc153ffd"},"execution_count":null,"outputs":[{"output_type":"stream","name":"stdout","text":["Mounted at /content/drive\n"]}]},{"cell_type":"code","source":["df=pd.read_excel('/content/drive/MyDrive/2000-2005_Q_Buriganga.xlsx', skiprows=1, sheet_name=0)"],"metadata":{"id":"9gSLKeY1ULJ2"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":["df[\"DATE\"] = df[\"DATE\"].astype('datetime64[ns]')\n","df = df.drop('SL', axis = 1)"],"metadata":{"id":"vu_UbixHUOKU"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":["df.dtypes"],"metadata":{"id":"nPZbcJh0Unck","colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"status":"ok","timestamp":1653560460856,"user_tz":-360,"elapsed":7,"user":{"displayName":"tasfia tasnim","userId":"13178643082102812040"}},"outputId":"c65814b4-91f9-487e-be68-af0cffc8773a"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["DATE                   datetime64[ns]\n","Avg Water Level(m)            float64\n","Q (m3/s-1)                    float64\n","dtype: object"]},"metadata":{},"execution_count":24}]},{"cell_type":"code","source":["df.set_index('DATE')"],"metadata":{"id":"lG9od61LUoq9","colab":{"base_uri":"https://localhost:8080/","height":455},"executionInfo":{"status":"ok","timestamp":1653560461684,"user_tz":-360,"elapsed":25,"user":{"displayName":"tasfia tasnim","userId":"13178643082102812040"}},"outputId":"e7e0555a-9bfd-4779-b70a-99f8a9fa613f"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["            Avg Water Level(m)   Q (m3/s-1)\n","DATE                                       \n","2000-01-01                 1.29  295.872858\n","2000-01-02                 1.30  296.931737\n","2000-01-03                 1.34  301.195618\n","2000-01-04                 1.27  293.763573\n","2000-01-05                 1.27  293.763573\n","...                         ...         ...\n","2005-12-27                 1.55  324.336993\n","2005-12-28                 1.64  334.651296\n","2005-12-29                 1.63  333.493315\n","2005-12-30                 1.62  332.338332\n","2005-12-31                 1.64  334.651296\n","\n","[2192 rows x 2 columns]"],"text/html":["\n","  <div id=\"df-cb4a45e2-cee4-41d9-8560-40ee85c46b98\">\n","    <div class=\"colab-df-container\">\n","      <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>Avg Water Level(m)</th>\n","      <th>Q (m3/s-1)</th>\n","    </tr>\n","    <tr>\n","      <th>DATE</th>\n","      <th></th>\n","      <th></th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>2000-01-01</th>\n","      <td>1.29</td>\n","      <td>295.872858</td>\n","    </tr>\n","    <tr>\n","      <th>2000-01-02</th>\n","      <td>1.30</td>\n","      <td>296.931737</td>\n","    </tr>\n","    <tr>\n","      <th>2000-01-03</th>\n","      <td>1.34</td>\n","      <td>301.195618</td>\n","    </tr>\n","    <tr>\n","      <th>2000-01-04</th>\n","      <td>1.27</td>\n","      <td>293.763573</td>\n","    </tr>\n","    <tr>\n","      <th>2000-01-05</th>\n","      <td>1.27</td>\n","      <td>293.763573</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>2005-12-27</th>\n","      <td>1.55</td>\n","      <td>324.336993</td>\n","    </tr>\n","    <tr>\n","      <th>2005-12-28</th>\n","      <td>1.64</td>\n","      <td>334.651296</td>\n","    </tr>\n","    <tr>\n","      <th>2005-12-29</th>\n","      <td>1.63</td>\n","      <td>333.493315</td>\n","    </tr>\n","    <tr>\n","      <th>2005-12-30</th>\n","      <td>1.62</td>\n","      <td>332.338332</td>\n","    </tr>\n","    <tr>\n","      <th>2005-12-31</th>\n","      <td>1.64</td>\n","      <td>334.651296</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>2192 rows × 2 columns</p>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-cb4a45e2-cee4-41d9-8560-40ee85c46b98')\"\n","              title=\"Convert this dataframe to an interactive table.\"\n","              style=\"display:none;\">\n","        \n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","       width=\"24px\">\n","    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n","    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n","  </svg>\n","      </button>\n","      \n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      flex-wrap:wrap;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","      <script>\n","        const buttonEl =\n","          document.querySelector('#df-cb4a45e2-cee4-41d9-8560-40ee85c46b98 button.colab-df-convert');\n","        buttonEl.style.display =\n","          google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","        async function convertToInteractive(key) {\n","          const element = document.querySelector('#df-cb4a45e2-cee4-41d9-8560-40ee85c46b98');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n","  "]},"metadata":{},"execution_count":25}]},{"cell_type":"code","source":["df.tail()"],"metadata":{"id":"aYI-iWy2U5Uc","colab":{"base_uri":"https://localhost:8080/","height":206},"executionInfo":{"status":"ok","timestamp":1653560461686,"user_tz":-360,"elapsed":23,"user":{"displayName":"tasfia tasnim","userId":"13178643082102812040"}},"outputId":"d6cc75f8-248f-45a2-c418-bc2081ad1a79"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["           DATE  Avg Water Level(m)   Q (m3/s-1)\n","2187 2005-12-27                 1.55  324.336993\n","2188 2005-12-28                 1.64  334.651296\n","2189 2005-12-29                 1.63  333.493315\n","2190 2005-12-30                 1.62  332.338332\n","2191 2005-12-31                 1.64  334.651296"],"text/html":["\n","  <div id=\"df-28ac540f-9c03-406a-a652-798e757b8a0e\">\n","    <div class=\"colab-df-container\">\n","      <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>DATE</th>\n","      <th>Avg Water Level(m)</th>\n","      <th>Q (m3/s-1)</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>2187</th>\n","      <td>2005-12-27</td>\n","      <td>1.55</td>\n","      <td>324.336993</td>\n","    </tr>\n","    <tr>\n","      <th>2188</th>\n","      <td>2005-12-28</td>\n","      <td>1.64</td>\n","      <td>334.651296</td>\n","    </tr>\n","    <tr>\n","      <th>2189</th>\n","      <td>2005-12-29</td>\n","      <td>1.63</td>\n","      <td>333.493315</td>\n","    </tr>\n","    <tr>\n","      <th>2190</th>\n","      <td>2005-12-30</td>\n","      <td>1.62</td>\n","      <td>332.338332</td>\n","    </tr>\n","    <tr>\n","      <th>2191</th>\n","      <td>2005-12-31</td>\n","      <td>1.64</td>\n","      <td>334.651296</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-28ac540f-9c03-406a-a652-798e757b8a0e')\"\n","              title=\"Convert this dataframe to an interactive table.\"\n","              style=\"display:none;\">\n","        \n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","       width=\"24px\">\n","    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n","    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n","  </svg>\n","      </button>\n","      \n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      flex-wrap:wrap;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","      <script>\n","        const buttonEl =\n","          document.querySelector('#df-28ac540f-9c03-406a-a652-798e757b8a0e button.colab-df-convert');\n","        buttonEl.style.display =\n","          google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","        async function convertToInteractive(key) {\n","          const element = document.querySelector('#df-28ac540f-9c03-406a-a652-798e757b8a0e');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n","  "]},"metadata":{},"execution_count":26}]},{"cell_type":"code","source":["df['Q (m3/s-1)'] = df['Q (m3/s-1)'].to_numpy()"],"metadata":{"id":"fIGhlhomW_e0"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":["df1 = df.resample('M', on='DATE').agg(np.mean)"],"metadata":{"id":"rHDBQWe2XQyk"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":["df1"],"metadata":{"id":"oEhG7Dj3XUGO","colab":{"base_uri":"https://localhost:8080/","height":455},"executionInfo":{"status":"ok","timestamp":1653560461689,"user_tz":-360,"elapsed":23,"user":{"displayName":"tasfia tasnim","userId":"13178643082102812040"}},"outputId":"aee71762-a277-414a-bd99-48ebf2cb6119"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["            Avg Water Level(m)   Q (m3/s-1)\n","DATE                                       \n","2000-01-31             1.268065  293.814843\n","2000-02-29             1.136552  280.294503\n","2000-03-31             1.357742  303.440859\n","2000-04-30             1.834333  358.486772\n","2000-05-31             2.548387  453.635739\n","...                         ...         ...\n","2005-08-31             4.753871  869.370578\n","2005-09-30             4.369667  788.462782\n","2005-10-31             3.622903  632.326598\n","2005-11-30             2.612333  466.113673\n","2005-12-31             1.765484  350.165720\n","\n","[72 rows x 2 columns]"],"text/html":["\n","  <div id=\"df-5847d0ce-63b3-4115-b9e3-50aaf0ab37ab\">\n","    <div class=\"colab-df-container\">\n","      <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>Avg Water Level(m)</th>\n","      <th>Q (m3/s-1)</th>\n","    </tr>\n","    <tr>\n","      <th>DATE</th>\n","      <th></th>\n","      <th></th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>2000-01-31</th>\n","      <td>1.268065</td>\n","      <td>293.814843</td>\n","    </tr>\n","    <tr>\n","      <th>2000-02-29</th>\n","      <td>1.136552</td>\n","      <td>280.294503</td>\n","    </tr>\n","    <tr>\n","      <th>2000-03-31</th>\n","      <td>1.357742</td>\n","      <td>303.440859</td>\n","    </tr>\n","    <tr>\n","      <th>2000-04-30</th>\n","      <td>1.834333</td>\n","      <td>358.486772</td>\n","    </tr>\n","    <tr>\n","      <th>2000-05-31</th>\n","      <td>2.548387</td>\n","      <td>453.635739</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>2005-08-31</th>\n","      <td>4.753871</td>\n","      <td>869.370578</td>\n","    </tr>\n","    <tr>\n","      <th>2005-09-30</th>\n","      <td>4.369667</td>\n","      <td>788.462782</td>\n","    </tr>\n","    <tr>\n","      <th>2005-10-31</th>\n","      <td>3.622903</td>\n","      <td>632.326598</td>\n","    </tr>\n","    <tr>\n","      <th>2005-11-30</th>\n","      <td>2.612333</td>\n","      <td>466.113673</td>\n","    </tr>\n","    <tr>\n","      <th>2005-12-31</th>\n","      <td>1.765484</td>\n","      <td>350.165720</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>72 rows × 2 columns</p>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-5847d0ce-63b3-4115-b9e3-50aaf0ab37ab')\"\n","              title=\"Convert this dataframe to an interactive table.\"\n","              style=\"display:none;\">\n","        \n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","       width=\"24px\">\n","    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n","    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n","  </svg>\n","      </button>\n","      \n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      flex-wrap:wrap;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","      <script>\n","        const buttonEl =\n","          document.querySelector('#df-5847d0ce-63b3-4115-b9e3-50aaf0ab37ab button.colab-df-convert');\n","        buttonEl.style.display =\n","          google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","        async function convertToInteractive(key) {\n","          const element = document.querySelector('#df-5847d0ce-63b3-4115-b9e3-50aaf0ab37ab');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n","  "]},"metadata":{},"execution_count":29}]},{"cell_type":"code","source":["df1=df1.drop('Avg Water Level(m) ', axis=1)\n","df1"],"metadata":{"id":"Mo2eZLGYXZeO","colab":{"base_uri":"https://localhost:8080/","height":455},"executionInfo":{"status":"ok","timestamp":1653560461691,"user_tz":-360,"elapsed":24,"user":{"displayName":"tasfia tasnim","userId":"13178643082102812040"}},"outputId":"3317aa0b-acdd-4162-e4da-262453418ae0"},"execution_count":null,"outputs":[{"output_type":"execute_result","data":{"text/plain":["            Q (m3/s-1)\n","DATE                  \n","2000-01-31  293.814843\n","2000-02-29  280.294503\n","2000-03-31  303.440859\n","2000-04-30  358.486772\n","2000-05-31  453.635739\n","...                ...\n","2005-08-31  869.370578\n","2005-09-30  788.462782\n","2005-10-31  632.326598\n","2005-11-30  466.113673\n","2005-12-31  350.165720\n","\n","[72 rows x 1 columns]"],"text/html":["\n","  <div id=\"df-8e427265-eef8-466d-9c62-976102f232d9\">\n","    <div class=\"colab-df-container\">\n","      <div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>Q (m3/s-1)</th>\n","    </tr>\n","    <tr>\n","      <th>DATE</th>\n","      <th></th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>2000-01-31</th>\n","      <td>293.814843</td>\n","    </tr>\n","    <tr>\n","      <th>2000-02-29</th>\n","      <td>280.294503</td>\n","    </tr>\n","    <tr>\n","      <th>2000-03-31</th>\n","      <td>303.440859</td>\n","    </tr>\n","    <tr>\n","      <th>2000-04-30</th>\n","      <td>358.486772</td>\n","    </tr>\n","    <tr>\n","      <th>2000-05-31</th>\n","      <td>453.635739</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>2005-08-31</th>\n","      <td>869.370578</td>\n","    </tr>\n","    <tr>\n","      <th>2005-09-30</th>\n","      <td>788.462782</td>\n","    </tr>\n","    <tr>\n","      <th>2005-10-31</th>\n","      <td>632.326598</td>\n","    </tr>\n","    <tr>\n","      <th>2005-11-30</th>\n","      <td>466.113673</td>\n","    </tr>\n","    <tr>\n","      <th>2005-12-31</th>\n","      <td>350.165720</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>72 rows × 1 columns</p>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-8e427265-eef8-466d-9c62-976102f232d9')\"\n","              title=\"Convert this dataframe to an interactive table.\"\n","              style=\"display:none;\">\n","        \n","  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n","       width=\"24px\">\n","    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n","    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n","  </svg>\n","      </button>\n","      \n","  <style>\n","    .colab-df-container {\n","      display:flex;\n","      flex-wrap:wrap;\n","      gap: 12px;\n","    }\n","\n","    .colab-df-convert {\n","      background-color: #E8F0FE;\n","      border: none;\n","      border-radius: 50%;\n","      cursor: pointer;\n","      display: none;\n","      fill: #1967D2;\n","      height: 32px;\n","      padding: 0 0 0 0;\n","      width: 32px;\n","    }\n","\n","    .colab-df-convert:hover {\n","      background-color: #E2EBFA;\n","      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n","      fill: #174EA6;\n","    }\n","\n","    [theme=dark] .colab-df-convert {\n","      background-color: #3B4455;\n","      fill: #D2E3FC;\n","    }\n","\n","    [theme=dark] .colab-df-convert:hover {\n","      background-color: #434B5C;\n","      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n","      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n","      fill: #FFFFFF;\n","    }\n","  </style>\n","\n","      <script>\n","        const buttonEl =\n","          document.querySelector('#df-8e427265-eef8-466d-9c62-976102f232d9 button.colab-df-convert');\n","        buttonEl.style.display =\n","          google.colab.kernel.accessAllowed ? 'block' : 'none';\n","\n","        async function convertToInteractive(key) {\n","          const element = document.querySelector('#df-8e427265-eef8-466d-9c62-976102f232d9');\n","          const dataTable =\n","            await google.colab.kernel.invokeFunction('convertToInteractive',\n","                                                     [key], {});\n","          if (!dataTable) return;\n","\n","          const docLinkHtml = 'Like what you see? Visit the ' +\n","            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n","            + ' to learn more about interactive tables.';\n","          element.innerHTML = '';\n","          dataTable['output_type'] = 'display_data';\n","          await google.colab.output.renderOutput(dataTable, element);\n","          const docLink = document.createElement('div');\n","          docLink.innerHTML = docLinkHtml;\n","          element.appendChild(docLink);\n","        }\n","      </script>\n","    </div>\n","  </div>\n","  "]},"metadata":{},"execution_count":30}]},{"cell_type":"code","source":["df1.to_excel(\"2000-2005_SW42_meanQ.xlsx\")"],"metadata":{"id":"x3MpZbwXXx6E"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":["#df1.groupby(df.DATE.dt.month)\n","#df2=df1.groupby(level='month').agg(np.mean)\n","#df2=df1.groupby(by=['M']).agg(np.mean)"],"metadata":{"id":"9uEM3dBaAZol"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":["#df2"],"metadata":{"id":"xOczaAHnAayS"},"execution_count":null,"outputs":[]},{"cell_type":"code","source":["#df2.to_excel(\"SW42_Yearly_meanQ.xlsx\")"],"metadata":{"id":"ZRRGhsKqAfpJ"},"execution_count":null,"outputs":[]}]}