NeuralNetword_ValidationData.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "id": "hYXFXXesL3UY"
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import math\n",
    "import tensorflow as tf\n",
    "from tensorflow import keras\n",
    "from sklearn.model_selection import train_test_split\n",
    "from sklearn import linear_model"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "q7zVt-oTVCQY"
   },
   "source": [
    "# Initial Data\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "D1SXiX5bynVC"
   },
   "source": [
    "*   x1: Total Population *(in 1000s)*\n",
    "*   x2: Population Density *(inhabitants/square km)*\n",
    "*   x3: GDP per capita *(USD/inhabitant)*\n",
    "*   x4: Long term average annual precipitation in depth *(mm/year)*\n",
    "*   x5: Total renewable resources per capita *($m^{3}$/inhabitant /year)*\n",
    "*   x6: Total water withdrawal per capita *($m^{3}$/inhabitant /year)*\n",
    "*   x7: Agricultural water withdrawal *(%age of x6)*\n",
    "*   x8: Industrial water withdrawal *(%age of x6)*\n",
    "*   x9: Municipal water withdrawal *(%age of x6)*\n",
    "*   x10: Collected Municipal wastewater  *($km^{3}$/year)*\n",
    "*   x11: Capacity of the municipal wastewater treatment facilities *($km^{3}$/year)*\n",
    "*   x12: Not treated municipal wastewater *($km^{3}$/year)*\n",
    "*   y: Water Stress *(%age)*"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 424
    },
    "id": "yCntS4IKMDYN",
    "outputId": "e553389b-6b0c-4f0b-9da3-83ed1e9e7690"
   },
   "outputs": [
    {
     "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>Area</th>\n",
       "      <th>Variable Name</th>\n",
       "      <th>Year</th>\n",
       "      <th>Value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Total population</td>\n",
       "      <td>1962</td>\n",
       "      <td>9351.441000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Total population</td>\n",
       "      <td>1967</td>\n",
       "      <td>10399.926000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Total population</td>\n",
       "      <td>1972</td>\n",
       "      <td>11791.215000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Total population</td>\n",
       "      <td>1977</td>\n",
       "      <td>13171.306000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Total population</td>\n",
       "      <td>1982</td>\n",
       "      <td>12882.528000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18698</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>SDG 6.4.2. Water Stress</td>\n",
       "      <td>2002</td>\n",
       "      <td>39.476155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18699</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>SDG 6.4.2. Water Stress</td>\n",
       "      <td>2007</td>\n",
       "      <td>33.514833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18700</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>SDG 6.4.2. Water Stress</td>\n",
       "      <td>2012</td>\n",
       "      <td>32.488030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18701</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>SDG 6.4.2. Water Stress</td>\n",
       "      <td>2017</td>\n",
       "      <td>31.346226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18702</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>SDG 6.4.2. Water Stress</td>\n",
       "      <td>2018</td>\n",
       "      <td>35.405370</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>18703 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              Area            Variable Name  Year         Value\n",
       "0      Afghanistan         Total population  1962   9351.441000\n",
       "1      Afghanistan         Total population  1967  10399.926000\n",
       "2      Afghanistan         Total population  1972  11791.215000\n",
       "3      Afghanistan         Total population  1977  13171.306000\n",
       "4      Afghanistan         Total population  1982  12882.528000\n",
       "...            ...                      ...   ...           ...\n",
       "18698     Zimbabwe  SDG 6.4.2. Water Stress  2002     39.476155\n",
       "18699     Zimbabwe  SDG 6.4.2. Water Stress  2007     33.514833\n",
       "18700     Zimbabwe  SDG 6.4.2. Water Stress  2012     32.488030\n",
       "18701     Zimbabwe  SDG 6.4.2. Water Stress  2017     31.346226\n",
       "18702     Zimbabwe  SDG 6.4.2. Water Stress  2018     35.405370\n",
       "\n",
       "[18703 rows x 4 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Read and prepare the data\n",
    "data = pd.read_csv('https://www.dropbox.com/s/j07u99pg44kbfvm/final_data.csv?dl=1')\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 658
    },
    "id": "jSZF2hsFi4jT",
    "outputId": "90738331-47e8-4bbc-b4d2-82c37c4ec154"
   },
   "outputs": [
    {
     "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>Variable Name</th>\n",
       "      <th>Agricultural water withdrawal as % of total water withdrawal</th>\n",
       "      <th>Capacity of the municipal wastewater treatment facilities</th>\n",
       "      <th>Collected municipal wastewater</th>\n",
       "      <th>GDP per capita</th>\n",
       "      <th>Industrial water withdrawal as % of total water withdrawal</th>\n",
       "      <th>Long-term average annual precipitation in volume</th>\n",
       "      <th>Municipal water withdrawal as % of total withdrawal</th>\n",
       "      <th>Not treated municipal wastewater</th>\n",
       "      <th>Population density</th>\n",
       "      <th>SDG 6.4.2. Water Stress</th>\n",
       "      <th>Total population</th>\n",
       "      <th>Total renewable water resources per capita</th>\n",
       "      <th>Total water withdrawal per capita</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Year</th>\n",
       "      <th>Area</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">1962</th>\n",
       "      <th>Afghanistan</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>213.48522</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14.323808</td>\n",
       "      <td>NaN</td>\n",
       "      <td>9351.441</td>\n",
       "      <td>6986.089096</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Albania</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42.69375</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>60.441252</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1737.686</td>\n",
       "      <td>17379.434490</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Algeria</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>211.97486</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.878714</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11619.828</td>\n",
       "      <td>1004.059613</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Andorra</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.47240</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>32.702128</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15.370</td>\n",
       "      <td>20533.506830</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Angola</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1259.16700</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4.498708</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5608.539</td>\n",
       "      <td>26459.653750</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">2018</th>\n",
       "      <th>Venezuela (Bolivarian Republic of)</th>\n",
       "      <td>73.852110</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6433.928949</td>\n",
       "      <td>3.506097</td>\n",
       "      <td>1864.23020</td>\n",
       "      <td>22.641793</td>\n",
       "      <td>NaN</td>\n",
       "      <td>31.672735</td>\n",
       "      <td>7.540367</td>\n",
       "      <td>28887.118</td>\n",
       "      <td>45868.196340</td>\n",
       "      <td>783.266091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Viet Nam</th>\n",
       "      <td>94.782397</td>\n",
       "      <td>0.423</td>\n",
       "      <td>0.19700</td>\n",
       "      <td>2538.068147</td>\n",
       "      <td>3.747409</td>\n",
       "      <td>603.16983</td>\n",
       "      <td>1.470194</td>\n",
       "      <td>1.775</td>\n",
       "      <td>288.458056</td>\n",
       "      <td>18.130315</td>\n",
       "      <td>95545.962</td>\n",
       "      <td>9253.347619</td>\n",
       "      <td>858.539684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yemen</th>\n",
       "      <td>90.743338</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>922.404203</td>\n",
       "      <td>1.823282</td>\n",
       "      <td>88.17099</td>\n",
       "      <td>7.433380</td>\n",
       "      <td>NaN</td>\n",
       "      <td>53.977845</td>\n",
       "      <td>169.761905</td>\n",
       "      <td>28498.683</td>\n",
       "      <td>73.687616</td>\n",
       "      <td>125.093500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zambia</th>\n",
       "      <td>73.282443</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1549.354235</td>\n",
       "      <td>8.269720</td>\n",
       "      <td>767.66220</td>\n",
       "      <td>18.447837</td>\n",
       "      <td>NaN</td>\n",
       "      <td>23.055378</td>\n",
       "      <td>2.835498</td>\n",
       "      <td>17351.708</td>\n",
       "      <td>6039.751245</td>\n",
       "      <td>90.596269</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zimbabwe</th>\n",
       "      <td>80.635470</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0.00027</td>\n",
       "      <td>1437.425967</td>\n",
       "      <td>2.157035</td>\n",
       "      <td>256.72932</td>\n",
       "      <td>17.207494</td>\n",
       "      <td>0.099</td>\n",
       "      <td>36.950563</td>\n",
       "      <td>35.405370</td>\n",
       "      <td>14438.802</td>\n",
       "      <td>1385.156469</td>\n",
       "      <td>261.197570</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2431 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Variable Name                            Agricultural water withdrawal as % of total water withdrawal  \\\n",
       "Year Area                                                                                               \n",
       "1962 Afghanistan                                                                       NaN              \n",
       "     Albania                                                                           NaN              \n",
       "     Algeria                                                                           NaN              \n",
       "     Andorra                                                                           NaN              \n",
       "     Angola                                                                            NaN              \n",
       "...                                                                                    ...              \n",
       "2018 Venezuela (Bolivarian Republic of)                                          73.852110              \n",
       "     Viet Nam                                                                    94.782397              \n",
       "     Yemen                                                                       90.743338              \n",
       "     Zambia                                                                      73.282443              \n",
       "     Zimbabwe                                                                    80.635470              \n",
       "\n",
       "Variable Name                            Capacity of the municipal wastewater treatment facilities  \\\n",
       "Year Area                                                                                            \n",
       "1962 Afghanistan                                                                       NaN           \n",
       "     Albania                                                                           NaN           \n",
       "     Algeria                                                                           NaN           \n",
       "     Andorra                                                                           NaN           \n",
       "     Angola                                                                            NaN           \n",
       "...                                                                                    ...           \n",
       "2018 Venezuela (Bolivarian Republic of)                                                NaN           \n",
       "     Viet Nam                                                                        0.423           \n",
       "     Yemen                                                                             NaN           \n",
       "     Zambia                                                                            NaN           \n",
       "     Zimbabwe                                                                          NaN           \n",
       "\n",
       "Variable Name                            Collected municipal wastewater  \\\n",
       "Year Area                                                                 \n",
       "1962 Afghanistan                                                    NaN   \n",
       "     Albania                                                        NaN   \n",
       "     Algeria                                                        NaN   \n",
       "     Andorra                                                        NaN   \n",
       "     Angola                                                         NaN   \n",
       "...                                                                 ...   \n",
       "2018 Venezuela (Bolivarian Republic of)                             NaN   \n",
       "     Viet Nam                                                   0.19700   \n",
       "     Yemen                                                          NaN   \n",
       "     Zambia                                                         NaN   \n",
       "     Zimbabwe                                                   0.00027   \n",
       "\n",
       "Variable Name                            GDP per capita  \\\n",
       "Year Area                                                 \n",
       "1962 Afghanistan                                    NaN   \n",
       "     Albania                                        NaN   \n",
       "     Algeria                                        NaN   \n",
       "     Andorra                                        NaN   \n",
       "     Angola                                         NaN   \n",
       "...                                                 ...   \n",
       "2018 Venezuela (Bolivarian Republic of)     6433.928949   \n",
       "     Viet Nam                               2538.068147   \n",
       "     Yemen                                   922.404203   \n",
       "     Zambia                                 1549.354235   \n",
       "     Zimbabwe                               1437.425967   \n",
       "\n",
       "Variable Name                            Industrial water withdrawal as % of total water withdrawal  \\\n",
       "Year Area                                                                                             \n",
       "1962 Afghanistan                                                                       NaN            \n",
       "     Albania                                                                           NaN            \n",
       "     Algeria                                                                           NaN            \n",
       "     Andorra                                                                           NaN            \n",
       "     Angola                                                                            NaN            \n",
       "...                                                                                    ...            \n",
       "2018 Venezuela (Bolivarian Republic of)                                           3.506097            \n",
       "     Viet Nam                                                                     3.747409            \n",
       "     Yemen                                                                        1.823282            \n",
       "     Zambia                                                                       8.269720            \n",
       "     Zimbabwe                                                                     2.157035            \n",
       "\n",
       "Variable Name                            Long-term average annual precipitation in volume  \\\n",
       "Year Area                                                                                   \n",
       "1962 Afghanistan                                                                213.48522   \n",
       "     Albania                                                                     42.69375   \n",
       "     Algeria                                                                    211.97486   \n",
       "     Andorra                                                                      0.47240   \n",
       "     Angola                                                                    1259.16700   \n",
       "...                                                                                   ...   \n",
       "2018 Venezuela (Bolivarian Republic of)                                        1864.23020   \n",
       "     Viet Nam                                                                   603.16983   \n",
       "     Yemen                                                                       88.17099   \n",
       "     Zambia                                                                     767.66220   \n",
       "     Zimbabwe                                                                   256.72932   \n",
       "\n",
       "Variable Name                            Municipal water withdrawal as % of total withdrawal  \\\n",
       "Year Area                                                                                      \n",
       "1962 Afghanistan                                                                       NaN     \n",
       "     Albania                                                                           NaN     \n",
       "     Algeria                                                                           NaN     \n",
       "     Andorra                                                                           NaN     \n",
       "     Angola                                                                            NaN     \n",
       "...                                                                                    ...     \n",
       "2018 Venezuela (Bolivarian Republic of)                                          22.641793     \n",
       "     Viet Nam                                                                     1.470194     \n",
       "     Yemen                                                                        7.433380     \n",
       "     Zambia                                                                      18.447837     \n",
       "     Zimbabwe                                                                    17.207494     \n",
       "\n",
       "Variable Name                            Not treated municipal wastewater  \\\n",
       "Year Area                                                                   \n",
       "1962 Afghanistan                                                      NaN   \n",
       "     Albania                                                          NaN   \n",
       "     Algeria                                                          NaN   \n",
       "     Andorra                                                          NaN   \n",
       "     Angola                                                           NaN   \n",
       "...                                                                   ...   \n",
       "2018 Venezuela (Bolivarian Republic of)                               NaN   \n",
       "     Viet Nam                                                       1.775   \n",
       "     Yemen                                                            NaN   \n",
       "     Zambia                                                           NaN   \n",
       "     Zimbabwe                                                       0.099   \n",
       "\n",
       "Variable Name                            Population density  \\\n",
       "Year Area                                                     \n",
       "1962 Afghanistan                                  14.323808   \n",
       "     Albania                                      60.441252   \n",
       "     Algeria                                       4.878714   \n",
       "     Andorra                                      32.702128   \n",
       "     Angola                                        4.498708   \n",
       "...                                                     ...   \n",
       "2018 Venezuela (Bolivarian Republic of)           31.672735   \n",
       "     Viet Nam                                    288.458056   \n",
       "     Yemen                                        53.977845   \n",
       "     Zambia                                       23.055378   \n",
       "     Zimbabwe                                     36.950563   \n",
       "\n",
       "Variable Name                            SDG 6.4.2. Water Stress  \\\n",
       "Year Area                                                          \n",
       "1962 Afghanistan                                             NaN   \n",
       "     Albania                                                 NaN   \n",
       "     Algeria                                                 NaN   \n",
       "     Andorra                                                 NaN   \n",
       "     Angola                                                  NaN   \n",
       "...                                                          ...   \n",
       "2018 Venezuela (Bolivarian Republic of)                 7.540367   \n",
       "     Viet Nam                                          18.130315   \n",
       "     Yemen                                            169.761905   \n",
       "     Zambia                                             2.835498   \n",
       "     Zimbabwe                                          35.405370   \n",
       "\n",
       "Variable Name                            Total population  \\\n",
       "Year Area                                                   \n",
       "1962 Afghanistan                                 9351.441   \n",
       "     Albania                                     1737.686   \n",
       "     Algeria                                    11619.828   \n",
       "     Andorra                                       15.370   \n",
       "     Angola                                      5608.539   \n",
       "...                                                   ...   \n",
       "2018 Venezuela (Bolivarian Republic of)         28887.118   \n",
       "     Viet Nam                                   95545.962   \n",
       "     Yemen                                      28498.683   \n",
       "     Zambia                                     17351.708   \n",
       "     Zimbabwe                                   14438.802   \n",
       "\n",
       "Variable Name                            Total renewable water resources per capita  \\\n",
       "Year Area                                                                             \n",
       "1962 Afghanistan                                                        6986.089096   \n",
       "     Albania                                                           17379.434490   \n",
       "     Algeria                                                            1004.059613   \n",
       "     Andorra                                                           20533.506830   \n",
       "     Angola                                                            26459.653750   \n",
       "...                                                                             ...   \n",
       "2018 Venezuela (Bolivarian Republic of)                                45868.196340   \n",
       "     Viet Nam                                                           9253.347619   \n",
       "     Yemen                                                                73.687616   \n",
       "     Zambia                                                             6039.751245   \n",
       "     Zimbabwe                                                           1385.156469   \n",
       "\n",
       "Variable Name                            Total water withdrawal per capita  \n",
       "Year Area                                                                   \n",
       "1962 Afghanistan                                                       NaN  \n",
       "     Albania                                                           NaN  \n",
       "     Algeria                                                           NaN  \n",
       "     Andorra                                                           NaN  \n",
       "     Angola                                                            NaN  \n",
       "...                                                                    ...  \n",
       "2018 Venezuela (Bolivarian Republic of)                         783.266091  \n",
       "     Viet Nam                                                   858.539684  \n",
       "     Yemen                                                      125.093500  \n",
       "     Zambia                                                      90.596269  \n",
       "     Zimbabwe                                                   261.197570  \n",
       "\n",
       "[2431 rows x 13 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#data_x1_x5.pivot(columns='Variable Name', index='Area')['Value']\n",
    "data = data.groupby(['Year','Variable Name', 'Area'])['Value'].aggregate('mean').unstack(1)\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "KaHYPG0CzrEI",
    "outputId": "b3d9fe67-f37a-4393-c95b-80390d1a26a3"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Variable Name\n",
       "Agricultural water withdrawal as % of total water withdrawal    1180\n",
       "Capacity of the municipal wastewater treatment facilities       2206\n",
       "Collected municipal wastewater                                  2170\n",
       "GDP per capita                                                   409\n",
       "Industrial water withdrawal as % of total water withdrawal      1204\n",
       "Long-term average annual precipitation in volume                 210\n",
       "Municipal water withdrawal as % of total withdrawal             1182\n",
       "Not treated municipal wastewater                                2082\n",
       "Population density                                                27\n",
       "SDG 6.4.2. Water Stress                                         1104\n",
       "Total population                                                  11\n",
       "Total renewable water resources per capita                        41\n",
       "Total water withdrawal per capita                               1090\n",
       "dtype: int64"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.isna().sum()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "XRr3cpgRBpz0"
   },
   "source": [
    "## Exploratory Data Analysis"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "jAh8SSr4Bh7c"
   },
   "source": [
    "\n",
    "\n",
    "*   Three variables, Capacity of the municipal wastewater treatment facilities (x11), Collected municipal wastewater (x10) and Not treated municipal wastewater (x12) are missing around 75% to 80% of the values. Therefore it can be assumed that they do not impact the water stress (y) values and can be droped from the dataset.\n",
    "*   All the rows with NaN values can be dropped.\n",
    "*   Variables x6, x7 and x8 sum up to 100 as they are percentages of x6. Therefore we need only two of these three variables and one of them should be dropped to avoid redundancy.\n",
    "*   Total population and Population density are related variables. So one of them can be dropped. Total population being a more absolute variable can be dropped.\n",
    "\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "hOwmW_1RzYID"
   },
   "source": [
    "# Cleaning the dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "z-3hxt20RDAi",
    "outputId": "72778811-5ff2-47e0-e480-87bb6de5585b"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Dimensions of the original dataset:  (2431, 13)\n",
      "Dimensions of the new dataset:  (1205, 8)\n"
     ]
    }
   ],
   "source": [
    "#drop the rows that are missing \"y\" values i.e. missing SDG 6.4.2. Water Stress\n",
    "print(\"Dimensions of the original dataset: \", data.shape)\n",
    "data.dropna(subset=[\"Population density\",\"GDP per capita\",\"SDG 6.4.2. Water Stress\",\"Agricultural water withdrawal as % of total water withdrawal\",\"Municipal water withdrawal as % of total withdrawal\"], inplace=True)\n",
    "data.drop([\"Total population\",\"Capacity of the municipal wastewater treatment facilities\",\"Collected municipal wastewater\",\"Not treated municipal wastewater\",\"Industrial water withdrawal as % of total water withdrawal\"], axis=1, inplace=True)\n",
    "print(\"Dimensions of the new dataset: \", data.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "KvX4LBM_X7AO",
    "outputId": "33ce60c4-ac92-4b3b-f620-9ed33e30665c"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Variable Name\n",
       "Agricultural water withdrawal as % of total water withdrawal    0\n",
       "GDP per capita                                                  0\n",
       "Long-term average annual precipitation in volume                0\n",
       "Municipal water withdrawal as % of total withdrawal             0\n",
       "Population density                                              0\n",
       "SDG 6.4.2. Water Stress                                         0\n",
       "Total renewable water resources per capita                      0\n",
       "Total water withdrawal per capita                               0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "id": "NRncT-37e34y"
   },
   "outputs": [],
   "source": [
    "data.reset_index(inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 572
    },
    "id": "bB5Qk0fEflTq",
    "outputId": "3e96ce90-4969-47c6-e9f2-ae07e9a53d58"
   },
   "outputs": [
    {
     "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>Variable Name</th>\n",
       "      <th>Year</th>\n",
       "      <th>Area</th>\n",
       "      <th>Agricultural water withdrawal as % of total water withdrawal</th>\n",
       "      <th>GDP per capita</th>\n",
       "      <th>Long-term average annual precipitation in volume</th>\n",
       "      <th>Municipal water withdrawal as % of total withdrawal</th>\n",
       "      <th>Population density</th>\n",
       "      <th>SDG 6.4.2. Water Stress</th>\n",
       "      <th>Total renewable water resources per capita</th>\n",
       "      <th>Total water withdrawal per capita</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1972</td>\n",
       "      <td>Denmark</td>\n",
       "      <td>31.947484</td>\n",
       "      <td>4655.290175</td>\n",
       "      <td>30.29227</td>\n",
       "      <td>60.831510</td>\n",
       "      <td>115.816802</td>\n",
       "      <td>24.716063</td>\n",
       "      <td>1202.273258</td>\n",
       "      <td>183.146293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1972</td>\n",
       "      <td>Ghana</td>\n",
       "      <td>54.727904</td>\n",
       "      <td>493.336524</td>\n",
       "      <td>283.14698</td>\n",
       "      <td>32.902354</td>\n",
       "      <td>38.692173</td>\n",
       "      <td>1.505958</td>\n",
       "      <td>6089.084168</td>\n",
       "      <td>37.430171</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1972</td>\n",
       "      <td>Hungary</td>\n",
       "      <td>22.379496</td>\n",
       "      <td>782.184870</td>\n",
       "      <td>54.79467</td>\n",
       "      <td>20.569268</td>\n",
       "      <td>112.072299</td>\n",
       "      <td>5.828256</td>\n",
       "      <td>9974.980064</td>\n",
       "      <td>323.626719</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1972</td>\n",
       "      <td>Israel</td>\n",
       "      <td>78.318250</td>\n",
       "      <td>2762.062183</td>\n",
       "      <td>9.60045</td>\n",
       "      <td>16.779789</td>\n",
       "      <td>135.771726</td>\n",
       "      <td>135.122077</td>\n",
       "      <td>594.029932</td>\n",
       "      <td>531.022713</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1972</td>\n",
       "      <td>Italy</td>\n",
       "      <td>59.201104</td>\n",
       "      <td>2674.044383</td>\n",
       "      <td>250.71488</td>\n",
       "      <td>16.811125</td>\n",
       "      <td>180.058210</td>\n",
       "      <td>37.599562</td>\n",
       "      <td>3525.699205</td>\n",
       "      <td>786.449189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1200</th>\n",
       "      <td>2018</td>\n",
       "      <td>Venezuela (Bolivarian Republic of)</td>\n",
       "      <td>73.852110</td>\n",
       "      <td>6433.928949</td>\n",
       "      <td>1864.23020</td>\n",
       "      <td>22.641793</td>\n",
       "      <td>31.672735</td>\n",
       "      <td>7.540367</td>\n",
       "      <td>45868.196340</td>\n",
       "      <td>783.266091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1201</th>\n",
       "      <td>2018</td>\n",
       "      <td>Viet Nam</td>\n",
       "      <td>94.782397</td>\n",
       "      <td>2538.068147</td>\n",
       "      <td>603.16983</td>\n",
       "      <td>1.470194</td>\n",
       "      <td>288.458056</td>\n",
       "      <td>18.130315</td>\n",
       "      <td>9253.347619</td>\n",
       "      <td>858.539684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1202</th>\n",
       "      <td>2018</td>\n",
       "      <td>Yemen</td>\n",
       "      <td>90.743338</td>\n",
       "      <td>922.404203</td>\n",
       "      <td>88.17099</td>\n",
       "      <td>7.433380</td>\n",
       "      <td>53.977845</td>\n",
       "      <td>169.761905</td>\n",
       "      <td>73.687616</td>\n",
       "      <td>125.093500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1203</th>\n",
       "      <td>2018</td>\n",
       "      <td>Zambia</td>\n",
       "      <td>73.282443</td>\n",
       "      <td>1549.354235</td>\n",
       "      <td>767.66220</td>\n",
       "      <td>18.447837</td>\n",
       "      <td>23.055378</td>\n",
       "      <td>2.835498</td>\n",
       "      <td>6039.751245</td>\n",
       "      <td>90.596269</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1204</th>\n",
       "      <td>2018</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>80.635470</td>\n",
       "      <td>1437.425967</td>\n",
       "      <td>256.72932</td>\n",
       "      <td>17.207494</td>\n",
       "      <td>36.950563</td>\n",
       "      <td>35.405370</td>\n",
       "      <td>1385.156469</td>\n",
       "      <td>261.197570</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1205 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Variable Name  Year                                Area  \\\n",
       "0              1972                             Denmark   \n",
       "1              1972                               Ghana   \n",
       "2              1972                             Hungary   \n",
       "3              1972                              Israel   \n",
       "4              1972                               Italy   \n",
       "...             ...                                 ...   \n",
       "1200           2018  Venezuela (Bolivarian Republic of)   \n",
       "1201           2018                            Viet Nam   \n",
       "1202           2018                               Yemen   \n",
       "1203           2018                              Zambia   \n",
       "1204           2018                            Zimbabwe   \n",
       "\n",
       "Variable Name  Agricultural water withdrawal as % of total water withdrawal  \\\n",
       "0                                                      31.947484              \n",
       "1                                                      54.727904              \n",
       "2                                                      22.379496              \n",
       "3                                                      78.318250              \n",
       "4                                                      59.201104              \n",
       "...                                                          ...              \n",
       "1200                                                   73.852110              \n",
       "1201                                                   94.782397              \n",
       "1202                                                   90.743338              \n",
       "1203                                                   73.282443              \n",
       "1204                                                   80.635470              \n",
       "\n",
       "Variable Name  GDP per capita  \\\n",
       "0                 4655.290175   \n",
       "1                  493.336524   \n",
       "2                  782.184870   \n",
       "3                 2762.062183   \n",
       "4                 2674.044383   \n",
       "...                       ...   \n",
       "1200              6433.928949   \n",
       "1201              2538.068147   \n",
       "1202               922.404203   \n",
       "1203              1549.354235   \n",
       "1204              1437.425967   \n",
       "\n",
       "Variable Name  Long-term average annual precipitation in volume  \\\n",
       "0                                                      30.29227   \n",
       "1                                                     283.14698   \n",
       "2                                                      54.79467   \n",
       "3                                                       9.60045   \n",
       "4                                                     250.71488   \n",
       "...                                                         ...   \n",
       "1200                                                 1864.23020   \n",
       "1201                                                  603.16983   \n",
       "1202                                                   88.17099   \n",
       "1203                                                  767.66220   \n",
       "1204                                                  256.72932   \n",
       "\n",
       "Variable Name  Municipal water withdrawal as % of total withdrawal  \\\n",
       "0                                                      60.831510     \n",
       "1                                                      32.902354     \n",
       "2                                                      20.569268     \n",
       "3                                                      16.779789     \n",
       "4                                                      16.811125     \n",
       "...                                                          ...     \n",
       "1200                                                   22.641793     \n",
       "1201                                                    1.470194     \n",
       "1202                                                    7.433380     \n",
       "1203                                                   18.447837     \n",
       "1204                                                   17.207494     \n",
       "\n",
       "Variable Name  Population density  SDG 6.4.2. Water Stress  \\\n",
       "0                      115.816802                24.716063   \n",
       "1                       38.692173                 1.505958   \n",
       "2                      112.072299                 5.828256   \n",
       "3                      135.771726               135.122077   \n",
       "4                      180.058210                37.599562   \n",
       "...                           ...                      ...   \n",
       "1200                    31.672735                 7.540367   \n",
       "1201                   288.458056                18.130315   \n",
       "1202                    53.977845               169.761905   \n",
       "1203                    23.055378                 2.835498   \n",
       "1204                    36.950563                35.405370   \n",
       "\n",
       "Variable Name  Total renewable water resources per capita  \\\n",
       "0                                             1202.273258   \n",
       "1                                             6089.084168   \n",
       "2                                             9974.980064   \n",
       "3                                              594.029932   \n",
       "4                                             3525.699205   \n",
       "...                                                   ...   \n",
       "1200                                         45868.196340   \n",
       "1201                                          9253.347619   \n",
       "1202                                            73.687616   \n",
       "1203                                          6039.751245   \n",
       "1204                                          1385.156469   \n",
       "\n",
       "Variable Name  Total water withdrawal per capita  \n",
       "0                                     183.146293  \n",
       "1                                      37.430171  \n",
       "2                                     323.626719  \n",
       "3                                     531.022713  \n",
       "4                                     786.449189  \n",
       "...                                          ...  \n",
       "1200                                  783.266091  \n",
       "1201                                  858.539684  \n",
       "1202                                  125.093500  \n",
       "1203                                   90.596269  \n",
       "1204                                  261.197570  \n",
       "\n",
       "[1205 rows x 10 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 737
    },
    "id": "BAI0RrKPGsm-",
    "outputId": "6a4e4c08-f59a-4ec0-d534-4bd8c10833bd"
   },
   "outputs": [
    {
     "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>Variable Name</th>\n",
       "      <th>Year</th>\n",
       "      <th>Agricultural water withdrawal as % of total water withdrawal</th>\n",
       "      <th>GDP per capita</th>\n",
       "      <th>Long-term average annual precipitation in volume</th>\n",
       "      <th>Municipal water withdrawal as % of total withdrawal</th>\n",
       "      <th>Population density</th>\n",
       "      <th>SDG 6.4.2. Water Stress</th>\n",
       "      <th>Total renewable water resources per capita</th>\n",
       "      <th>Total water withdrawal per capita</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Variable Name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Year</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.060807</td>\n",
       "      <td>0.223303</td>\n",
       "      <td>0.024027</td>\n",
       "      <td>0.078427</td>\n",
       "      <td>0.023163</td>\n",
       "      <td>0.030757</td>\n",
       "      <td>-0.068900</td>\n",
       "      <td>-0.051328</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Agricultural water withdrawal as % of total water withdrawal</th>\n",
       "      <td>-0.060807</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.415532</td>\n",
       "      <td>0.018947</td>\n",
       "      <td>-0.675577</td>\n",
       "      <td>-0.180608</td>\n",
       "      <td>0.085287</td>\n",
       "      <td>-0.089993</td>\n",
       "      <td>0.296968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>GDP per capita</th>\n",
       "      <td>0.223303</td>\n",
       "      <td>-0.415532</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.026815</td>\n",
       "      <td>0.250539</td>\n",
       "      <td>0.165558</td>\n",
       "      <td>0.170544</td>\n",
       "      <td>0.093298</td>\n",
       "      <td>0.035759</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Long-term average annual precipitation in volume</th>\n",
       "      <td>0.024027</td>\n",
       "      <td>0.018947</td>\n",
       "      <td>0.026815</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.094149</td>\n",
       "      <td>-0.073010</td>\n",
       "      <td>-0.066559</td>\n",
       "      <td>0.054745</td>\n",
       "      <td>0.066076</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Municipal water withdrawal as % of total withdrawal</th>\n",
       "      <td>0.078427</td>\n",
       "      <td>-0.675577</td>\n",
       "      <td>0.250539</td>\n",
       "      <td>-0.094149</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.148729</td>\n",
       "      <td>-0.011202</td>\n",
       "      <td>0.099943</td>\n",
       "      <td>-0.422910</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Population density</th>\n",
       "      <td>0.023163</td>\n",
       "      <td>-0.180608</td>\n",
       "      <td>0.165558</td>\n",
       "      <td>-0.073010</td>\n",
       "      <td>0.148729</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.045586</td>\n",
       "      <td>-0.090589</td>\n",
       "      <td>-0.069448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SDG 6.4.2. Water Stress</th>\n",
       "      <td>0.030757</td>\n",
       "      <td>0.085287</td>\n",
       "      <td>0.170544</td>\n",
       "      <td>-0.066559</td>\n",
       "      <td>-0.011202</td>\n",
       "      <td>0.045586</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.078604</td>\n",
       "      <td>0.079976</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total renewable water resources per capita</th>\n",
       "      <td>-0.068900</td>\n",
       "      <td>-0.089993</td>\n",
       "      <td>0.093298</td>\n",
       "      <td>0.054745</td>\n",
       "      <td>0.099943</td>\n",
       "      <td>-0.090589</td>\n",
       "      <td>-0.078604</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.094333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Total water withdrawal per capita</th>\n",
       "      <td>-0.051328</td>\n",
       "      <td>0.296968</td>\n",
       "      <td>0.035759</td>\n",
       "      <td>0.066076</td>\n",
       "      <td>-0.422910</td>\n",
       "      <td>-0.069448</td>\n",
       "      <td>0.079976</td>\n",
       "      <td>0.094333</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Variable Name                                           Year  \\\n",
       "Variable Name                                                  \n",
       "Year                                                1.000000   \n",
       "Agricultural water withdrawal as % of total wat... -0.060807   \n",
       "GDP per capita                                      0.223303   \n",
       "Long-term average annual precipitation in volume    0.024027   \n",
       "Municipal water withdrawal as % of total withdr...  0.078427   \n",
       "Population density                                  0.023163   \n",
       "SDG 6.4.2. Water Stress                             0.030757   \n",
       "Total renewable water resources per capita         -0.068900   \n",
       "Total water withdrawal per capita                  -0.051328   \n",
       "\n",
       "Variable Name                                       Agricultural water withdrawal as % of total water withdrawal  \\\n",
       "Variable Name                                                                                                      \n",
       "Year                                                                                        -0.060807              \n",
       "Agricultural water withdrawal as % of total wat...                                           1.000000              \n",
       "GDP per capita                                                                              -0.415532              \n",
       "Long-term average annual precipitation in volume                                             0.018947              \n",
       "Municipal water withdrawal as % of total withdr...                                          -0.675577              \n",
       "Population density                                                                          -0.180608              \n",
       "SDG 6.4.2. Water Stress                                                                      0.085287              \n",
       "Total renewable water resources per capita                                                  -0.089993              \n",
       "Total water withdrawal per capita                                                            0.296968              \n",
       "\n",
       "Variable Name                                       GDP per capita  \\\n",
       "Variable Name                                                        \n",
       "Year                                                      0.223303   \n",
       "Agricultural water withdrawal as % of total wat...       -0.415532   \n",
       "GDP per capita                                            1.000000   \n",
       "Long-term average annual precipitation in volume          0.026815   \n",
       "Municipal water withdrawal as % of total withdr...        0.250539   \n",
       "Population density                                        0.165558   \n",
       "SDG 6.4.2. Water Stress                                   0.170544   \n",
       "Total renewable water resources per capita                0.093298   \n",
       "Total water withdrawal per capita                         0.035759   \n",
       "\n",
       "Variable Name                                       Long-term average annual precipitation in volume  \\\n",
       "Variable Name                                                                                          \n",
       "Year                                                                                        0.024027   \n",
       "Agricultural water withdrawal as % of total wat...                                          0.018947   \n",
       "GDP per capita                                                                              0.026815   \n",
       "Long-term average annual precipitation in volume                                            1.000000   \n",
       "Municipal water withdrawal as % of total withdr...                                         -0.094149   \n",
       "Population density                                                                         -0.073010   \n",
       "SDG 6.4.2. Water Stress                                                                    -0.066559   \n",
       "Total renewable water resources per capita                                                  0.054745   \n",
       "Total water withdrawal per capita                                                           0.066076   \n",
       "\n",
       "Variable Name                                       Municipal water withdrawal as % of total withdrawal  \\\n",
       "Variable Name                                                                                             \n",
       "Year                                                                                         0.078427     \n",
       "Agricultural water withdrawal as % of total wat...                                          -0.675577     \n",
       "GDP per capita                                                                               0.250539     \n",
       "Long-term average annual precipitation in volume                                            -0.094149     \n",
       "Municipal water withdrawal as % of total withdr...                                           1.000000     \n",
       "Population density                                                                           0.148729     \n",
       "SDG 6.4.2. Water Stress                                                                     -0.011202     \n",
       "Total renewable water resources per capita                                                   0.099943     \n",
       "Total water withdrawal per capita                                                           -0.422910     \n",
       "\n",
       "Variable Name                                       Population density  \\\n",
       "Variable Name                                                            \n",
       "Year                                                          0.023163   \n",
       "Agricultural water withdrawal as % of total wat...           -0.180608   \n",
       "GDP per capita                                                0.165558   \n",
       "Long-term average annual precipitation in volume             -0.073010   \n",
       "Municipal water withdrawal as % of total withdr...            0.148729   \n",
       "Population density                                            1.000000   \n",
       "SDG 6.4.2. Water Stress                                       0.045586   \n",
       "Total renewable water resources per capita                   -0.090589   \n",
       "Total water withdrawal per capita                            -0.069448   \n",
       "\n",
       "Variable Name                                       SDG 6.4.2. Water Stress  \\\n",
       "Variable Name                                                                 \n",
       "Year                                                               0.030757   \n",
       "Agricultural water withdrawal as % of total wat...                 0.085287   \n",
       "GDP per capita                                                     0.170544   \n",
       "Long-term average annual precipitation in volume                  -0.066559   \n",
       "Municipal water withdrawal as % of total withdr...                -0.011202   \n",
       "Population density                                                 0.045586   \n",
       "SDG 6.4.2. Water Stress                                            1.000000   \n",
       "Total renewable water resources per capita                        -0.078604   \n",
       "Total water withdrawal per capita                                  0.079976   \n",
       "\n",
       "Variable Name                                       Total renewable water resources per capita  \\\n",
       "Variable Name                                                                                    \n",
       "Year                                                                                 -0.068900   \n",
       "Agricultural water withdrawal as % of total wat...                                   -0.089993   \n",
       "GDP per capita                                                                        0.093298   \n",
       "Long-term average annual precipitation in volume                                      0.054745   \n",
       "Municipal water withdrawal as % of total withdr...                                    0.099943   \n",
       "Population density                                                                   -0.090589   \n",
       "SDG 6.4.2. Water Stress                                                              -0.078604   \n",
       "Total renewable water resources per capita                                            1.000000   \n",
       "Total water withdrawal per capita                                                     0.094333   \n",
       "\n",
       "Variable Name                                       Total water withdrawal per capita  \n",
       "Variable Name                                                                          \n",
       "Year                                                                        -0.051328  \n",
       "Agricultural water withdrawal as % of total wat...                           0.296968  \n",
       "GDP per capita                                                               0.035759  \n",
       "Long-term average annual precipitation in volume                             0.066076  \n",
       "Municipal water withdrawal as % of total withdr...                          -0.422910  \n",
       "Population density                                                          -0.069448  \n",
       "SDG 6.4.2. Water Stress                                                      0.079976  \n",
       "Total renewable water resources per capita                                   0.094333  \n",
       "Total water withdrawal per capita                                            1.000000  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.corr()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "prebrmfChiyR"
   },
   "source": [
    "There is no direct linear relation between any of the variables and the water stress values. We need to build a prediction model that analyze complex relations between variables such as Neural Networks."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "-y44RPJ3yVDh"
   },
   "source": [
    "# Scaling the dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "id": "_VKHuj2ByarF"
   },
   "outputs": [],
   "source": [
    "#Create X_data and Y_data\n",
    "X_data= data[[\"Agricultural water withdrawal as % of total water withdrawal\", \"GDP per capita\", \"Long-term average annual precipitation in volume\", \"Municipal water withdrawal as % of total withdrawal\", \"Total renewable water resources per capita\", \"Total water withdrawal per capita\", \"Population density\"]]\n",
    "Y_data= data[\"SDG 6.4.2. Water Stress\"]\n",
    "X_scale= X_data.apply(lambda x: (x-x.min(axis=0)) / (x.max(axis=0)-x.min(axis=0)))\n",
    "#Change the percentage to proportion\n",
    "Y_scale=Y_data.apply(lambda x: x/100)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "qQII1AJGZt47"
   },
   "source": [
    "# Neural Network Model"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "wErvHcMwBYfv"
   },
   "source": [
    "## Splitting the dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "xr-57CaHshFJ",
    "outputId": "fcbdc7aa-c97f-400b-b7aa-938e812cfcfd"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(1205, 7) (1205,)\n"
     ]
    }
   ],
   "source": [
    "print(X_scale.shape,Y_scale.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "id": "Cygj8-hgZ7fo"
   },
   "outputs": [],
   "source": [
    "#convert dataframes to array\n",
    "X=pd.DataFrame(X_scale).to_numpy()\n",
    "Y=pd.DataFrame(Y_scale).to_numpy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "39BumEixzZ33",
    "outputId": "c97fc0e2-2f67-468f-b639-1e5ba9554edf"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[3.20902724e-01, 3.84416071e-02, 2.01606512e-03, ...,\n",
       "        1.64310175e-03, 3.06699357e-02, 1.43787686e-02],\n",
       "       [5.49725098e-01, 3.78738908e-03, 1.88773038e-02, ...,\n",
       "        8.34868443e-03, 5.25083958e-03, 4.67859864e-03],\n",
       "       [2.24795207e-01, 6.19246477e-03, 3.64997106e-03, ...,\n",
       "        1.36808319e-02, 5.51757034e-02, 1.39078125e-02],\n",
       "       ...,\n",
       "       [9.11489140e-01, 7.35999131e-03, 5.87562111e-03, ...,\n",
       "        9.44794555e-05, 2.05430567e-02, 6.60111833e-03],\n",
       "       [7.36099775e-01, 1.25802472e-02, 5.11864775e-02, ...,\n",
       "        8.28099080e-03, 1.45252708e-02, 2.71191726e-03],\n",
       "       [8.09958693e-01, 1.16482843e-02, 1.71156816e-02, ...,\n",
       "        1.89405038e-03, 4.42854017e-02, 4.45955169e-03]])"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "X"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "VQ6y-LVNbQiG",
    "outputId": "6cc0c2ee-0cec-496d-d66a-2ddd361edbaf"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[0.24716063],\n",
       "       [0.01505958],\n",
       "       [0.05828256],\n",
       "       ...,\n",
       "       [1.69761905],\n",
       "       [0.02835498],\n",
       "       [0.3540537 ]])"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Y"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "4mHi9UM_BOht",
    "outputId": "6b81c34d-1e2c-47e8-c4d9-396e3207be1a"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(964, 7) (241, 7) (964, 1) (241, 1)\n"
     ]
    }
   ],
   "source": [
    "#split the data for testing and training\n",
    "X_train, X_test, Y_train, Y_test = train_test_split(X,Y,test_size=0.2)\n",
    "print(X_train.shape, X_test.shape, Y_train.shape, Y_test.shape)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "lS5Y2gT7GhUo"
   },
   "source": [
    "## Building the Neural Network Model"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "id": "bdAhr4p0dllI"
   },
   "outputs": [],
   "source": [
    "#Create a neutral network model\n",
    "model=tf.keras.models.Sequential()\n",
    "model.add(tf.keras.layers.Flatten()),\n",
    "model.add(tf.keras.layers.Dense(35, activation=\"relu\")),\n",
    "model.add(tf.keras.layers.Dense(30, activation=\"sigmoid\")),\n",
    "model.add(tf.keras.layers.Dense(25, activation=\"sigmoid\")),\n",
    "model.add(tf.keras.layers.Dense(1, activation=\"linear\")),\n",
    "\n",
    "#compile the model\n",
    "model.compile(optimizer=\"adam\",loss=\"mean_squared_error\", metrics=\"accuracy\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "SI9duShFdvHb",
    "outputId": "496208ec-8857-4d4e-814c-d12c44dd2a1c"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Epoch 1/450\n",
      "31/31 [==============================] - 1s 3ms/step - loss: 8.9759 - accuracy: 0.0000e+00\n",
      "Epoch 2/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 7.8904 - accuracy: 0.0000e+00\n",
      "Epoch 3/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 7.7503 - accuracy: 0.0000e+00\n",
      "Epoch 4/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 7.7306 - accuracy: 0.0000e+00\n",
      "Epoch 5/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 7.7277 - accuracy: 0.0000e+00\n",
      "Epoch 6/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 7.7155 - accuracy: 0.0000e+00\n",
      "Epoch 7/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 7.7124 - accuracy: 0.0000e+00\n",
      "Epoch 8/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 7.6917 - accuracy: 0.0000e+00\n",
      "Epoch 9/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 7.6735 - accuracy: 0.0000e+00\n",
      "Epoch 10/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 7.6596 - accuracy: 0.0000e+00\n",
      "Epoch 11/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 7.6301 - accuracy: 0.0000e+00\n",
      "Epoch 12/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 7.6065 - accuracy: 0.0000e+00\n",
      "Epoch 13/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 7.5800 - accuracy: 0.0000e+00\n",
      "Epoch 14/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 7.5470 - accuracy: 0.0000e+00\n",
      "Epoch 15/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 7.5081 - accuracy: 0.0000e+00\n",
      "Epoch 16/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 7.4596 - accuracy: 0.0000e+00\n",
      "Epoch 17/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 7.4163 - accuracy: 0.0000e+00\n",
      "Epoch 18/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 7.3592 - accuracy: 0.0000e+00\n",
      "Epoch 19/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 7.3091 - accuracy: 0.0000e+00\n",
      "Epoch 20/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 7.2573 - accuracy: 0.0000e+00\n",
      "Epoch 21/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 7.2021 - accuracy: 0.0000e+00\n",
      "Epoch 22/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 7.1482 - accuracy: 0.0000e+00\n",
      "Epoch 23/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 7.0944 - accuracy: 0.0000e+00\n",
      "Epoch 24/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 7.0497 - accuracy: 0.0000e+00\n",
      "Epoch 25/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 7.0247 - accuracy: 0.0000e+00\n",
      "Epoch 26/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 6.9258 - accuracy: 0.0000e+00\n",
      "Epoch 27/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 6.8796 - accuracy: 0.0000e+00\n",
      "Epoch 28/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 6.8483 - accuracy: 0.0000e+00\n",
      "Epoch 29/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 6.7982 - accuracy: 0.0000e+00\n",
      "Epoch 30/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 6.7306 - accuracy: 0.0000e+00\n",
      "Epoch 31/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 6.6700 - accuracy: 0.0000e+00\n",
      "Epoch 32/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 6.6407 - accuracy: 0.0000e+00\n",
      "Epoch 33/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 6.5805 - accuracy: 0.0000e+00\n",
      "Epoch 34/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 6.5038 - accuracy: 0.0000e+00\n",
      "Epoch 35/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 6.4300 - accuracy: 0.0000e+00\n",
      "Epoch 36/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 6.3901 - accuracy: 0.0000e+00\n",
      "Epoch 37/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 6.3453 - accuracy: 0.0000e+00\n",
      "Epoch 38/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 6.2909 - accuracy: 0.0000e+00\n",
      "Epoch 39/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 6.2468 - accuracy: 0.0000e+00\n",
      "Epoch 40/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 6.1789 - accuracy: 0.0000e+00\n",
      "Epoch 41/450\n",
      "31/31 [==============================] - 0s 1ms/step - loss: 6.1322 - accuracy: 0.0000e+00\n",
      "Epoch 42/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 6.0919 - accuracy: 0.0000e+00\n",
      "Epoch 43/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 6.0544 - accuracy: 0.0000e+00\n",
      "Epoch 44/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 6.0055 - accuracy: 0.0000e+00\n",
      "Epoch 45/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.9645 - accuracy: 0.0000e+00\n",
      "Epoch 46/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.9409 - accuracy: 0.0000e+00\n",
      "Epoch 47/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.9015 - accuracy: 0.0000e+00\n",
      "Epoch 48/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.8429 - accuracy: 0.0000e+00\n",
      "Epoch 49/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.8031 - accuracy: 0.0000e+00\n",
      "Epoch 50/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 5.7673 - accuracy: 0.0000e+00\n",
      "Epoch 51/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.7415 - accuracy: 0.0000e+00\n",
      "Epoch 52/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.7017 - accuracy: 0.0000e+00\n",
      "Epoch 53/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.6616 - accuracy: 0.0000e+00\n",
      "Epoch 54/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 5.6218 - accuracy: 0.0000e+00\n",
      "Epoch 55/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 5.5748 - accuracy: 0.0000e+00\n",
      "Epoch 56/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 5.5614 - accuracy: 0.0000e+00\n",
      "Epoch 57/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.5350 - accuracy: 0.0000e+00\n",
      "Epoch 58/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 5.4647 - accuracy: 0.0000e+00\n",
      "Epoch 59/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.4681 - accuracy: 0.0000e+00\n",
      "Epoch 60/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.4413 - accuracy: 0.0000e+00\n",
      "Epoch 61/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.3712 - accuracy: 0.0000e+00\n",
      "Epoch 62/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.3545 - accuracy: 0.0000e+00\n",
      "Epoch 63/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.3806 - accuracy: 0.0000e+00\n",
      "Epoch 64/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.2975 - accuracy: 0.0000e+00\n",
      "Epoch 65/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.2419 - accuracy: 0.0000e+00\n",
      "Epoch 66/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.2327 - accuracy: 0.0000e+00\n",
      "Epoch 67/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.1447 - accuracy: 0.0000e+00\n",
      "Epoch 68/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.1394 - accuracy: 0.0000e+00\n",
      "Epoch 69/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.0611 - accuracy: 0.0000e+00\n",
      "Epoch 70/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.0366 - accuracy: 0.0000e+00\n",
      "Epoch 71/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 5.0036 - accuracy: 0.0000e+00\n",
      "Epoch 72/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.9820 - accuracy: 0.0000e+00\n",
      "Epoch 73/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.9201 - accuracy: 0.0000e+00\n",
      "Epoch 74/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.9087 - accuracy: 0.0000e+00\n",
      "Epoch 75/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.8642 - accuracy: 0.0000e+00\n",
      "Epoch 76/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.8278 - accuracy: 0.0000e+00\n",
      "Epoch 77/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.7923 - accuracy: 0.0000e+00\n",
      "Epoch 78/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.8344 - accuracy: 0.0000e+00\n",
      "Epoch 79/450\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "31/31 [==============================] - 0s 2ms/step - loss: 4.7272 - accuracy: 0.0000e+00\n",
      "Epoch 80/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.6903 - accuracy: 0.0000e+00\n",
      "Epoch 81/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.6523 - accuracy: 0.0000e+00\n",
      "Epoch 82/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.6297 - accuracy: 0.0000e+00\n",
      "Epoch 83/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 4.5778 - accuracy: 0.0000e+00\n",
      "Epoch 84/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.5521 - accuracy: 0.0000e+00\n",
      "Epoch 85/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 4.5885 - accuracy: 0.0000e+00\n",
      "Epoch 86/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 4.5176 - accuracy: 0.0000e+00\n",
      "Epoch 87/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.4849 - accuracy: 0.0000e+00\n",
      "Epoch 88/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 4.4314 - accuracy: 0.0000e+00\n",
      "Epoch 89/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 4.4580 - accuracy: 0.0000e+00\n",
      "Epoch 90/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 4.4097 - accuracy: 0.0000e+00\n",
      "Epoch 91/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 4.4548 - accuracy: 0.0000e+00\n",
      "Epoch 92/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.3622 - accuracy: 0.0000e+00\n",
      "Epoch 93/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.4447 - accuracy: 0.0000e+00\n",
      "Epoch 94/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.2634 - accuracy: 0.0000e+00\n",
      "Epoch 95/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.2481 - accuracy: 0.0000e+00\n",
      "Epoch 96/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.2553 - accuracy: 0.0000e+00\n",
      "Epoch 97/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.2309 - accuracy: 0.0000e+00\n",
      "Epoch 98/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.1923 - accuracy: 0.0000e+00\n",
      "Epoch 99/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.1688 - accuracy: 0.0000e+00\n",
      "Epoch 100/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.1937 - accuracy: 0.0000e+00\n",
      "Epoch 101/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.1275 - accuracy: 0.0000e+00\n",
      "Epoch 102/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.1143 - accuracy: 0.0000e+00\n",
      "Epoch 103/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.0699 - accuracy: 0.0000e+00\n",
      "Epoch 104/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.0806 - accuracy: 0.0000e+00\n",
      "Epoch 105/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.0243 - accuracy: 0.0000e+00\n",
      "Epoch 106/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.9937 - accuracy: 0.0000e+00\n",
      "Epoch 107/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.0076 - accuracy: 0.0000e+00\n",
      "Epoch 108/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 4.0000 - accuracy: 0.0000e+00\n",
      "Epoch 109/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.9711 - accuracy: 0.0000e+00\n",
      "Epoch 110/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.9784 - accuracy: 0.0000e+00\n",
      "Epoch 111/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.9271 - accuracy: 0.0000e+00\n",
      "Epoch 112/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.9033 - accuracy: 0.0000e+00\n",
      "Epoch 113/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.9322 - accuracy: 0.0000e+00\n",
      "Epoch 114/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.9362 - accuracy: 0.0000e+00\n",
      "Epoch 115/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.8489 - accuracy: 0.0000e+00\n",
      "Epoch 116/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.8797 - accuracy: 0.0000e+00\n",
      "Epoch 117/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.8531 - accuracy: 0.0000e+00\n",
      "Epoch 118/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.7816 - accuracy: 0.0000e+00\n",
      "Epoch 119/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.8170 - accuracy: 0.0000e+00\n",
      "Epoch 120/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.7510 - accuracy: 0.0000e+00\n",
      "Epoch 121/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.7500 - accuracy: 0.0000e+00\n",
      "Epoch 122/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 3.6960 - accuracy: 0.0000e+00\n",
      "Epoch 123/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 3.6902 - accuracy: 0.0000e+00\n",
      "Epoch 124/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.8009 - accuracy: 0.0000e+00\n",
      "Epoch 125/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.7022 - accuracy: 0.0000e+00\n",
      "Epoch 126/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.6587 - accuracy: 0.0000e+00\n",
      "Epoch 127/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.6126 - accuracy: 0.0000e+00\n",
      "Epoch 128/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 3.6486 - accuracy: 0.0000e+00\n",
      "Epoch 129/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.5922 - accuracy: 0.0000e+00\n",
      "Epoch 130/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.5832 - accuracy: 0.0000e+00\n",
      "Epoch 131/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.5628 - accuracy: 0.0000e+00\n",
      "Epoch 132/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.5401 - accuracy: 0.0000e+00\n",
      "Epoch 133/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 3.5358 - accuracy: 0.0000e+00\n",
      "Epoch 134/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 3.5082 - accuracy: 0.0000e+00\n",
      "Epoch 135/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.4948 - accuracy: 0.0000e+00\n",
      "Epoch 136/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.5036 - accuracy: 0.0000e+00\n",
      "Epoch 137/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.5209 - accuracy: 0.0000e+00\n",
      "Epoch 138/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 3.5216 - accuracy: 0.0000e+00\n",
      "Epoch 139/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.5079 - accuracy: 0.0000e+00\n",
      "Epoch 140/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.4655 - accuracy: 0.0000e+00\n",
      "Epoch 141/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.4562 - accuracy: 0.0000e+00\n",
      "Epoch 142/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.6194 - accuracy: 0.0000e+00\n",
      "Epoch 143/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.4429 - accuracy: 0.0000e+00\n",
      "Epoch 144/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.4663 - accuracy: 0.0000e+00\n",
      "Epoch 145/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 3.3694 - accuracy: 0.0000e+00\n",
      "Epoch 146/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.3389 - accuracy: 0.0000e+00\n",
      "Epoch 147/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.3366 - accuracy: 0.0000e+00\n",
      "Epoch 148/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.4454 - accuracy: 0.0000e+00\n",
      "Epoch 149/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.4032 - accuracy: 0.0000e+00\n",
      "Epoch 150/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.3417 - accuracy: 0.0000e+00\n",
      "Epoch 151/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.2727 - accuracy: 0.0000e+00\n",
      "Epoch 152/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.3693 - accuracy: 0.0000e+00\n",
      "Epoch 153/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.3342 - accuracy: 0.0000e+00\n",
      "Epoch 154/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.2433 - accuracy: 0.0000e+00\n",
      "Epoch 155/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.2543 - accuracy: 0.0000e+00\n",
      "Epoch 156/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.2416 - accuracy: 0.0000e+00\n",
      "Epoch 157/450\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "31/31 [==============================] - 0s 2ms/step - loss: 3.2122 - accuracy: 0.0000e+00\n",
      "Epoch 158/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.3233 - accuracy: 0.0000e+00\n",
      "Epoch 159/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.2558 - accuracy: 0.0000e+00\n",
      "Epoch 160/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.2260 - accuracy: 0.0000e+00\n",
      "Epoch 161/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.2072 - accuracy: 0.0000e+00\n",
      "Epoch 162/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.3137 - accuracy: 0.0000e+00\n",
      "Epoch 163/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.1678 - accuracy: 0.0000e+00\n",
      "Epoch 164/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.1877 - accuracy: 0.0000e+00\n",
      "Epoch 165/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.1479 - accuracy: 0.0000e+00\n",
      "Epoch 166/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.1417 - accuracy: 0.0000e+00\n",
      "Epoch 167/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.1425 - accuracy: 0.0000e+00\n",
      "Epoch 168/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 3.1822 - accuracy: 0.0000e+00\n",
      "Epoch 169/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.2094 - accuracy: 0.0000e+00\n",
      "Epoch 170/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.1168 - accuracy: 0.0000e+00\n",
      "Epoch 171/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.1262 - accuracy: 0.0000e+00\n",
      "Epoch 172/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.1188 - accuracy: 0.0000e+00\n",
      "Epoch 173/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.1340 - accuracy: 0.0000e+00\n",
      "Epoch 174/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.1497 - accuracy: 0.0000e+00\n",
      "Epoch 175/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.0860 - accuracy: 0.0000e+00\n",
      "Epoch 176/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.0937 - accuracy: 0.0000e+00\n",
      "Epoch 177/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.0521 - accuracy: 0.0000e+00\n",
      "Epoch 178/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.1781 - accuracy: 0.0000e+00\n",
      "Epoch 179/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.0604 - accuracy: 0.0000e+00\n",
      "Epoch 180/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.1074 - accuracy: 0.0000e+00\n",
      "Epoch 181/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.0581 - accuracy: 0.0000e+00\n",
      "Epoch 182/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.0076 - accuracy: 0.0000e+00\n",
      "Epoch 183/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.1332 - accuracy: 0.0000e+00\n",
      "Epoch 184/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.0894 - accuracy: 0.0000e+00\n",
      "Epoch 185/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.0792 - accuracy: 0.0000e+00\n",
      "Epoch 186/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 3.1039 - accuracy: 0.0000e+00\n",
      "Epoch 187/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 3.0127 - accuracy: 0.0000e+00\n",
      "Epoch 188/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.9769 - accuracy: 0.0000e+00\n",
      "Epoch 189/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.0639 - accuracy: 0.0000e+00\n",
      "Epoch 190/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.1094 - accuracy: 0.0000e+00\n",
      "Epoch 191/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.9808 - accuracy: 0.0000e+00\n",
      "Epoch 192/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.9474 - accuracy: 0.0000e+00\n",
      "Epoch 193/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.9665 - accuracy: 0.0000e+00\n",
      "Epoch 194/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.9783 - accuracy: 0.0000e+00\n",
      "Epoch 195/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.9758 - accuracy: 0.0000e+00\n",
      "Epoch 196/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.1391 - accuracy: 0.0000e+00\n",
      "Epoch 197/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.9182 - accuracy: 0.0000e+00\n",
      "Epoch 198/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.9101 - accuracy: 0.0000e+00\n",
      "Epoch 199/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.9472 - accuracy: 0.0000e+00\n",
      "Epoch 200/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.9812 - accuracy: 0.0000e+00\n",
      "Epoch 201/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.8925 - accuracy: 0.0000e+00\n",
      "Epoch 202/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.9073 - accuracy: 0.0000e+00\n",
      "Epoch 203/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.8663 - accuracy: 0.0000e+00\n",
      "Epoch 204/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.9029 - accuracy: 0.0000e+00\n",
      "Epoch 205/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.0340 - accuracy: 0.0000e+00\n",
      "Epoch 206/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.9618 - accuracy: 0.0000e+00\n",
      "Epoch 207/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.3532 - accuracy: 0.0000e+00\n",
      "Epoch 208/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.8716 - accuracy: 0.0000e+00\n",
      "Epoch 209/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.8382 - accuracy: 0.0000e+00\n",
      "Epoch 210/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.9085 - accuracy: 0.0000e+00\n",
      "Epoch 211/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.8596 - accuracy: 0.0000e+00\n",
      "Epoch 212/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.8237 - accuracy: 0.0000e+00\n",
      "Epoch 213/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.8309 - accuracy: 0.0000e+00\n",
      "Epoch 214/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.7945 - accuracy: 0.0000e+00\n",
      "Epoch 215/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.8501 - accuracy: 0.0000e+00\n",
      "Epoch 216/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.8354 - accuracy: 0.0000e+00\n",
      "Epoch 217/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.8061 - accuracy: 0.0000e+00\n",
      "Epoch 218/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.9009 - accuracy: 0.0000e+00\n",
      "Epoch 219/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.7996 - accuracy: 0.0000e+00\n",
      "Epoch 220/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.7809 - accuracy: 0.0000e+00\n",
      "Epoch 221/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.7594 - accuracy: 0.0000e+00\n",
      "Epoch 222/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.8117 - accuracy: 0.0000e+00\n",
      "Epoch 223/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.7293 - accuracy: 0.0000e+00\n",
      "Epoch 224/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.7547 - accuracy: 0.0000e+00\n",
      "Epoch 225/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.7591 - accuracy: 0.0000e+00\n",
      "Epoch 226/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.7181 - accuracy: 0.0000e+00\n",
      "Epoch 227/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.7595 - accuracy: 0.0000e+00\n",
      "Epoch 228/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.7874 - accuracy: 0.0000e+00\n",
      "Epoch 229/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.8266 - accuracy: 0.0000e+00\n",
      "Epoch 230/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.7301 - accuracy: 0.0000e+00\n",
      "Epoch 231/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.7129 - accuracy: 0.0000e+00\n",
      "Epoch 232/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.7310 - accuracy: 0.0000e+00\n",
      "Epoch 233/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.6953 - accuracy: 0.0000e+00\n",
      "Epoch 234/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.7273 - accuracy: 0.0000e+00\n",
      "Epoch 235/450\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "31/31 [==============================] - 0s 2ms/step - loss: 2.8176 - accuracy: 0.0000e+00\n",
      "Epoch 236/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.7962 - accuracy: 0.0000e+00\n",
      "Epoch 237/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.6791 - accuracy: 0.0000e+00\n",
      "Epoch 238/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.6783 - accuracy: 0.0000e+00\n",
      "Epoch 239/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.6836 - accuracy: 0.0000e+00\n",
      "Epoch 240/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.6820 - accuracy: 0.0000e+00\n",
      "Epoch 241/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.6366 - accuracy: 0.0000e+00\n",
      "Epoch 242/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.6795 - accuracy: 0.0000e+00\n",
      "Epoch 243/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.7908 - accuracy: 0.0000e+00\n",
      "Epoch 244/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.7956 - accuracy: 0.0000e+00\n",
      "Epoch 245/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.6413 - accuracy: 0.0000e+00\n",
      "Epoch 246/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.6524 - accuracy: 0.0000e+00\n",
      "Epoch 247/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.7167 - accuracy: 0.0000e+00\n",
      "Epoch 248/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.8007 - accuracy: 0.0000e+00\n",
      "Epoch 249/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.7469 - accuracy: 0.0000e+00\n",
      "Epoch 250/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.6251 - accuracy: 0.0000e+00\n",
      "Epoch 251/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.6693 - accuracy: 0.0000e+00\n",
      "Epoch 252/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.6670 - accuracy: 0.0000e+00\n",
      "Epoch 253/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.6156 - accuracy: 0.0000e+00\n",
      "Epoch 254/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.6408 - accuracy: 0.0000e+00\n",
      "Epoch 255/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.6297 - accuracy: 0.0000e+00\n",
      "Epoch 256/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.6947 - accuracy: 0.0000e+00\n",
      "Epoch 257/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.6050 - accuracy: 0.0000e+00\n",
      "Epoch 258/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.7582 - accuracy: 0.0000e+00\n",
      "Epoch 259/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.5901 - accuracy: 0.0000e+00\n",
      "Epoch 260/450\n",
      "31/31 [==============================] - 0s 1ms/step - loss: 2.5534 - accuracy: 0.0000e+00\n",
      "Epoch 261/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.5663 - accuracy: 0.0000e+00\n",
      "Epoch 262/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.5840 - accuracy: 0.0000e+00\n",
      "Epoch 263/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.6622 - accuracy: 0.0000e+00\n",
      "Epoch 264/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.5787 - accuracy: 0.0000e+00\n",
      "Epoch 265/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.5735 - accuracy: 0.0000e+00\n",
      "Epoch 266/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.5829 - accuracy: 0.0000e+00\n",
      "Epoch 267/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.5207 - accuracy: 0.0000e+00\n",
      "Epoch 268/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.5649 - accuracy: 0.0000e+00\n",
      "Epoch 269/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.5700 - accuracy: 0.0000e+00\n",
      "Epoch 270/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.4866 - accuracy: 0.0000e+00\n",
      "Epoch 271/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.5723 - accuracy: 0.0000e+00\n",
      "Epoch 272/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.5317 - accuracy: 0.0000e+00\n",
      "Epoch 273/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.4899 - accuracy: 0.0000e+00\n",
      "Epoch 274/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.5319 - accuracy: 0.0000e+00\n",
      "Epoch 275/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.7115 - accuracy: 0.0000e+00\n",
      "Epoch 276/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.4864 - accuracy: 0.0000e+00\n",
      "Epoch 277/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.4556 - accuracy: 0.0000e+00\n",
      "Epoch 278/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.6901 - accuracy: 0.0000e+00\n",
      "Epoch 279/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.5375 - accuracy: 0.0000e+00\n",
      "Epoch 280/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.4770 - accuracy: 0.0000e+00\n",
      "Epoch 281/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.5881 - accuracy: 0.0000e+00\n",
      "Epoch 282/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.4574 - accuracy: 0.0000e+00\n",
      "Epoch 283/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.4824 - accuracy: 0.0000e+00\n",
      "Epoch 284/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.4794 - accuracy: 0.0000e+00\n",
      "Epoch 285/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.4984 - accuracy: 0.0000e+00\n",
      "Epoch 286/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.4635 - accuracy: 0.0000e+00\n",
      "Epoch 287/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.4506 - accuracy: 0.0000e+00\n",
      "Epoch 288/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.4396 - accuracy: 0.0000e+00\n",
      "Epoch 289/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.5213 - accuracy: 0.0000e+00\n",
      "Epoch 290/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.6898 - accuracy: 0.0000e+00\n",
      "Epoch 291/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.4493 - accuracy: 0.0000e+00\n",
      "Epoch 292/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.4653 - accuracy: 0.0000e+00\n",
      "Epoch 293/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.3916 - accuracy: 0.0000e+00\n",
      "Epoch 294/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.4488 - accuracy: 0.0000e+00\n",
      "Epoch 295/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.4130 - accuracy: 0.0000e+00\n",
      "Epoch 296/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.3546 - accuracy: 0.0000e+00\n",
      "Epoch 297/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.3427 - accuracy: 0.0000e+00\n",
      "Epoch 298/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.3526 - accuracy: 0.0000e+00\n",
      "Epoch 299/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.4171 - accuracy: 0.0000e+00\n",
      "Epoch 300/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.3509 - accuracy: 0.0000e+00\n",
      "Epoch 301/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.3283 - accuracy: 0.0000e+00\n",
      "Epoch 302/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.4050 - accuracy: 0.0000e+00\n",
      "Epoch 303/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.3521 - accuracy: 0.0000e+00\n",
      "Epoch 304/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.3793 - accuracy: 0.0000e+00\n",
      "Epoch 305/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.5213 - accuracy: 0.0000e+00\n",
      "Epoch 306/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.3445 - accuracy: 0.0000e+00\n",
      "Epoch 307/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.3911 - accuracy: 0.0000e+00\n",
      "Epoch 308/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.3513 - accuracy: 0.0000e+00\n",
      "Epoch 309/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.2689 - accuracy: 0.0000e+00\n",
      "Epoch 310/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.5931 - accuracy: 0.0000e+00\n",
      "Epoch 311/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.3365 - accuracy: 0.0000e+00\n",
      "Epoch 312/450\n",
      "31/31 [==============================] - 0s 1ms/step - loss: 2.3045 - accuracy: 0.0000e+00\n",
      "Epoch 313/450\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "31/31 [==============================] - 0s 2ms/step - loss: 2.2957 - accuracy: 0.0000e+00\n",
      "Epoch 314/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.3562 - accuracy: 0.0000e+00\n",
      "Epoch 315/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.2816 - accuracy: 0.0000e+00\n",
      "Epoch 316/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.4042 - accuracy: 0.0000e+00\n",
      "Epoch 317/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.5988 - accuracy: 0.0000e+00\n",
      "Epoch 318/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.2667 - accuracy: 0.0000e+00\n",
      "Epoch 319/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.3319 - accuracy: 0.0000e+00\n",
      "Epoch 320/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.3390 - accuracy: 0.0000e+00\n",
      "Epoch 321/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.5042 - accuracy: 0.0000e+00\n",
      "Epoch 322/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.2391 - accuracy: 0.0000e+00\n",
      "Epoch 323/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.3013 - accuracy: 0.0000e+00\n",
      "Epoch 324/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.3238 - accuracy: 0.0000e+00\n",
      "Epoch 325/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.3166 - accuracy: 0.0000e+00\n",
      "Epoch 326/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.5463 - accuracy: 0.0000e+00\n",
      "Epoch 327/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.6644 - accuracy: 0.0000e+00\n",
      "Epoch 328/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.4998 - accuracy: 0.0000e+00\n",
      "Epoch 329/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.3941 - accuracy: 0.0000e+00\n",
      "Epoch 330/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.2628 - accuracy: 0.0000e+00\n",
      "Epoch 331/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.2825 - accuracy: 0.0000e+00\n",
      "Epoch 332/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.3832 - accuracy: 0.0000e+00\n",
      "Epoch 333/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.3156 - accuracy: 0.0000e+00\n",
      "Epoch 334/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.6163 - accuracy: 0.0000e+00\n",
      "Epoch 335/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.2137 - accuracy: 0.0000e+00\n",
      "Epoch 336/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.2672 - accuracy: 0.0000e+00\n",
      "Epoch 337/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.3524 - accuracy: 0.0000e+00\n",
      "Epoch 338/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.2513 - accuracy: 0.0000e+00\n",
      "Epoch 339/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.2302 - accuracy: 0.0000e+00\n",
      "Epoch 340/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.1826 - accuracy: 0.0000e+00\n",
      "Epoch 341/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.2059 - accuracy: 0.0000e+00\n",
      "Epoch 342/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.1772 - accuracy: 0.0000e+00\n",
      "Epoch 343/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.2800 - accuracy: 0.0000e+00\n",
      "Epoch 344/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.3012 - accuracy: 0.0000e+00\n",
      "Epoch 345/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.1267 - accuracy: 0.0000e+00\n",
      "Epoch 346/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.1619 - accuracy: 0.0000e+00\n",
      "Epoch 347/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.2394 - accuracy: 0.0000e+00\n",
      "Epoch 348/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.1595 - accuracy: 0.0000e+00\n",
      "Epoch 349/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.6595 - accuracy: 0.0000e+00\n",
      "Epoch 350/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.2557 - accuracy: 0.0000e+00\n",
      "Epoch 351/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.1524 - accuracy: 0.0000e+00\n",
      "Epoch 352/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.1496 - accuracy: 0.0000e+00\n",
      "Epoch 353/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.1311 - accuracy: 0.0000e+00\n",
      "Epoch 354/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.7185 - accuracy: 0.0000e+00\n",
      "Epoch 355/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.2635 - accuracy: 0.0000e+00\n",
      "Epoch 356/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.1348 - accuracy: 0.0000e+00\n",
      "Epoch 357/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.1912 - accuracy: 0.0000e+00\n",
      "Epoch 358/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.0834 - accuracy: 0.0000e+00\n",
      "Epoch 359/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.1024 - accuracy: 0.0000e+00\n",
      "Epoch 360/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.1009 - accuracy: 0.0000e+00\n",
      "Epoch 361/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.1232 - accuracy: 0.0000e+00\n",
      "Epoch 362/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.1819 - accuracy: 0.0000e+00\n",
      "Epoch 363/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.1239 - accuracy: 0.0000e+00\n",
      "Epoch 364/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0984 - accuracy: 0.0000e+00\n",
      "Epoch 365/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0990 - accuracy: 0.0000e+00\n",
      "Epoch 366/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0997 - accuracy: 0.0000e+00\n",
      "Epoch 367/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.0933 - accuracy: 0.0000e+00\n",
      "Epoch 368/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.0584 - accuracy: 0.0000e+00\n",
      "Epoch 369/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.1137 - accuracy: 0.0000e+00\n",
      "Epoch 370/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.1135 - accuracy: 0.0000e+00\n",
      "Epoch 371/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.1723 - accuracy: 0.0000e+00\n",
      "Epoch 372/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.2301 - accuracy: 0.0000e+00\n",
      "Epoch 373/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.1202 - accuracy: 0.0000e+00\n",
      "Epoch 374/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.3101 - accuracy: 0.0000e+00\n",
      "Epoch 375/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.1125 - accuracy: 0.0000e+00\n",
      "Epoch 376/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0463 - accuracy: 0.0000e+00\n",
      "Epoch 377/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.1273 - accuracy: 0.0000e+00\n",
      "Epoch 378/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.2266 - accuracy: 0.0000e+00\n",
      "Epoch 379/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.4159 - accuracy: 0.0000e+00\n",
      "Epoch 380/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.2276 - accuracy: 0.0000e+00\n",
      "Epoch 381/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.1406 - accuracy: 0.0000e+00\n",
      "Epoch 382/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.2603 - accuracy: 0.0000e+00\n",
      "Epoch 383/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0914 - accuracy: 0.0000e+00\n",
      "Epoch 384/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.4261 - accuracy: 0.0000e+00\n",
      "Epoch 385/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.3265 - accuracy: 0.0000e+00\n",
      "Epoch 386/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.1285 - accuracy: 0.0000e+00\n",
      "Epoch 387/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.1048 - accuracy: 0.0000e+00\n",
      "Epoch 388/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0387 - accuracy: 0.0000e+00\n",
      "Epoch 389/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.1517 - accuracy: 0.0000e+00\n",
      "Epoch 390/450\n",
      "31/31 [==============================] - 0s 4ms/step - loss: 2.0731 - accuracy: 0.0000e+00\n",
      "Epoch 391/450\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "31/31 [==============================] - 0s 3ms/step - loss: 2.0198 - accuracy: 0.0000e+00\n",
      "Epoch 392/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.1218 - accuracy: 0.0000e+00\n",
      "Epoch 393/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.1359 - accuracy: 0.0000e+00\n",
      "Epoch 394/450\n",
      "31/31 [==============================] - 0s 4ms/step - loss: 2.2039 - accuracy: 0.0000e+00\n",
      "Epoch 395/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.2604 - accuracy: 0.0000e+00\n",
      "Epoch 396/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 1.9777 - accuracy: 0.0000e+00\n",
      "Epoch 397/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.0531 - accuracy: 0.0000e+00\n",
      "Epoch 398/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.1100 - accuracy: 0.0000e+00\n",
      "Epoch 399/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.0145 - accuracy: 0.0000e+00\n",
      "Epoch 400/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.0406 - accuracy: 0.0000e+00\n",
      "Epoch 401/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.0455 - accuracy: 0.0000e+00\n",
      "Epoch 402/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.1438 - accuracy: 0.0000e+00\n",
      "Epoch 403/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 1.9952 - accuracy: 0.0000e+00\n",
      "Epoch 404/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0033 - accuracy: 0.0000e+00\n",
      "Epoch 405/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0182 - accuracy: 0.0000e+00\n",
      "Epoch 406/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.0529 - accuracy: 0.0000e+00\n",
      "Epoch 407/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 1.9671 - accuracy: 0.0000e+00\n",
      "Epoch 408/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.0274 - accuracy: 0.0000e+00\n",
      "Epoch 409/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.0090 - accuracy: 0.0000e+00\n",
      "Epoch 410/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0313 - accuracy: 0.0000e+00\n",
      "Epoch 411/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 1.9931 - accuracy: 0.0000e+00\n",
      "Epoch 412/450\n",
      "31/31 [==============================] - 0s 4ms/step - loss: 1.9774 - accuracy: 0.0000e+00\n",
      "Epoch 413/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 1.9445 - accuracy: 0.0000e+00\n",
      "Epoch 414/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 1.9623 - accuracy: 0.0000e+00\n",
      "Epoch 415/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 1.9731 - accuracy: 0.0000e+00\n",
      "Epoch 416/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 1.9743 - accuracy: 0.0000e+00\n",
      "Epoch 417/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0372 - accuracy: 0.0000e+00\n",
      "Epoch 418/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 1.9857 - accuracy: 0.0000e+00\n",
      "Epoch 419/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 3.7585 - accuracy: 0.0000e+00\n",
      "Epoch 420/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.2176 - accuracy: 0.0000e+00\n",
      "Epoch 421/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.1401 - accuracy: 0.0000e+00\n",
      "Epoch 422/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.0245 - accuracy: 0.0000e+00\n",
      "Epoch 423/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0436 - accuracy: 0.0000e+00\n",
      "Epoch 424/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.1308 - accuracy: 0.0000e+00\n",
      "Epoch 425/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0719 - accuracy: 0.0000e+00\n",
      "Epoch 426/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0805 - accuracy: 0.0000e+00\n",
      "Epoch 427/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 1.9908 - accuracy: 0.0000e+00\n",
      "Epoch 428/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0755 - accuracy: 0.0000e+00\n",
      "Epoch 429/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 1.9324 - accuracy: 0.0000e+00\n",
      "Epoch 430/450\n",
      "31/31 [==============================] - 0s 3ms/step - loss: 2.0050 - accuracy: 0.0000e+00\n",
      "Epoch 431/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0257 - accuracy: 0.0000e+00\n",
      "Epoch 432/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0130 - accuracy: 0.0000e+00\n",
      "Epoch 433/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 1.9317 - accuracy: 0.0000e+00\n",
      "Epoch 434/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0124 - accuracy: 0.0000e+00\n",
      "Epoch 435/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0644 - accuracy: 0.0000e+00\n",
      "Epoch 436/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.2069 - accuracy: 0.0000e+00\n",
      "Epoch 437/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0136 - accuracy: 0.0000e+00\n",
      "Epoch 438/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0331 - accuracy: 0.0000e+00\n",
      "Epoch 439/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0051 - accuracy: 0.0000e+00\n",
      "Epoch 440/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 1.9936 - accuracy: 0.0000e+00\n",
      "Epoch 441/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 1.9353 - accuracy: 0.0000e+00\n",
      "Epoch 442/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 1.9556 - accuracy: 0.0000e+00\n",
      "Epoch 443/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 1.9869 - accuracy: 0.0000e+00\n",
      "Epoch 444/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.4705 - accuracy: 0.0000e+00\n",
      "Epoch 445/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0290 - accuracy: 0.0000e+00\n",
      "Epoch 446/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 1.9416 - accuracy: 0.0000e+00\n",
      "Epoch 447/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 2.0183 - accuracy: 0.0000e+00\n",
      "Epoch 448/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 1.8295 - accuracy: 0.0000e+00\n",
      "Epoch 449/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 1.9165 - accuracy: 0.0000e+00\n",
      "Epoch 450/450\n",
      "31/31 [==============================] - 0s 2ms/step - loss: 1.9903 - accuracy: 0.0000e+00\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "<keras.callbacks.History at 0x25a6cc43880>"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#train the model\n",
    "model.fit(X_train, Y_train, epochs=450, batch_size=32)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "1I_U4wX_gRsH"
   },
   "source": [
    "## Predicting the test data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "EfO1MqKCeLbH",
    "outputId": "53be6ae8-27c5-401c-cf5a-45221f57c17e"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "8/8 [==============================] - 0s 1ms/step\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "array([[ 0.7179318 ],\n",
       "       [ 0.14259958],\n",
       "       [ 0.6663942 ],\n",
       "       [ 0.07807833],\n",
       "       [ 0.08353722],\n",
       "       [ 0.07509935],\n",
       "       [ 0.19101822],\n",
       "       [ 0.16766697],\n",
       "       [ 0.07509935],\n",
       "       [ 0.20958626],\n",
       "       [ 0.39574462],\n",
       "       [ 0.14912128],\n",
       "       [ 0.21232665],\n",
       "       [ 0.33833754],\n",
       "       [ 0.8213795 ],\n",
       "       [ 0.07871932],\n",
       "       [ 0.08050418],\n",
       "       [ 0.23019129],\n",
       "       [ 0.09562194],\n",
       "       [ 0.34592122],\n",
       "       [ 0.16889066],\n",
       "       [ 0.07509959],\n",
       "       [ 0.1844911 ],\n",
       "       [ 0.2929303 ],\n",
       "       [ 0.40083086],\n",
       "       [ 0.37147468],\n",
       "       [ 0.56945115],\n",
       "       [ 0.23851901],\n",
       "       [ 0.07509935],\n",
       "       [ 0.19429195],\n",
       "       [ 0.32545173],\n",
       "       [ 0.07625467],\n",
       "       [ 0.46853036],\n",
       "       [ 0.07721889],\n",
       "       [ 0.19393581],\n",
       "       [ 0.09648085],\n",
       "       [ 0.4816519 ],\n",
       "       [ 0.14166659],\n",
       "       [ 0.4939857 ],\n",
       "       [ 0.10705298],\n",
       "       [ 0.568876  ],\n",
       "       [ 0.1018458 ],\n",
       "       [ 5.967721  ],\n",
       "       [ 0.07520735],\n",
       "       [ 0.07974213],\n",
       "       [ 0.12215233],\n",
       "       [ 0.23786491],\n",
       "       [ 0.07509935],\n",
       "       [ 0.3980893 ],\n",
       "       [ 0.07510036],\n",
       "       [ 0.07509935],\n",
       "       [ 0.8485868 ],\n",
       "       [ 0.07512659],\n",
       "       [ 0.16994858],\n",
       "       [ 0.10826302],\n",
       "       [ 0.09594023],\n",
       "       [ 0.1391769 ],\n",
       "       [ 0.400855  ],\n",
       "       [ 0.07979482],\n",
       "       [ 0.45566452],\n",
       "       [ 0.40111047],\n",
       "       [ 0.44179046],\n",
       "       [ 0.40827614],\n",
       "       [ 0.35380346],\n",
       "       [ 0.41352475],\n",
       "       [ 0.9323561 ],\n",
       "       [ 1.8401188 ],\n",
       "       [ 0.7107264 ],\n",
       "       [ 0.2585606 ],\n",
       "       [ 0.08703983],\n",
       "       [ 1.4866909 ],\n",
       "       [ 0.16756248],\n",
       "       [ 0.1375885 ],\n",
       "       [ 0.1656279 ],\n",
       "       [ 6.2030754 ],\n",
       "       [ 0.11492872],\n",
       "       [ 0.7059259 ],\n",
       "       [ 0.28890783],\n",
       "       [ 0.49106252],\n",
       "       [ 0.23848611],\n",
       "       [ 0.1672067 ],\n",
       "       [ 0.07509935],\n",
       "       [ 0.4931001 ],\n",
       "       [ 5.4615455 ],\n",
       "       [ 0.09077728],\n",
       "       [ 0.25669515],\n",
       "       [ 0.07509935],\n",
       "       [ 0.34097433],\n",
       "       [ 0.398803  ],\n",
       "       [ 0.36736727],\n",
       "       [ 0.8950293 ],\n",
       "       [ 0.73908603],\n",
       "       [ 0.12302911],\n",
       "       [ 0.18895882],\n",
       "       [ 0.14674151],\n",
       "       [ 0.15776676],\n",
       "       [ 0.11365741],\n",
       "       [ 0.13165665],\n",
       "       [ 0.13202894],\n",
       "       [ 0.39897984],\n",
       "       [ 0.07510036],\n",
       "       [ 1.1059008 ],\n",
       "       [22.797688  ],\n",
       "       [ 0.10822046],\n",
       "       [ 0.08226234],\n",
       "       [ 0.20583487],\n",
       "       [ 0.6746668 ],\n",
       "       [ 0.07663208],\n",
       "       [ 0.07509935],\n",
       "       [ 0.08829463],\n",
       "       [ 0.18555152],\n",
       "       [ 0.33147192],\n",
       "       [ 0.20867473],\n",
       "       [ 0.07994258],\n",
       "       [ 0.07511055],\n",
       "       [ 0.07511777],\n",
       "       [ 0.1312716 ],\n",
       "       [ 0.16852939],\n",
       "       [ 0.08526683],\n",
       "       [ 0.18810701],\n",
       "       [ 0.51667756],\n",
       "       [ 0.26101226],\n",
       "       [ 0.07509935],\n",
       "       [ 0.07509983],\n",
       "       [ 0.07510608],\n",
       "       [ 0.5141304 ],\n",
       "       [ 0.25873137],\n",
       "       [ 0.2357589 ],\n",
       "       [ 0.3734753 ],\n",
       "       [ 0.15587234],\n",
       "       [ 0.2515149 ],\n",
       "       [ 1.4497627 ],\n",
       "       [ 0.28783584],\n",
       "       [ 0.07510316],\n",
       "       [ 0.41276145],\n",
       "       [ 0.41490424],\n",
       "       [ 0.5060166 ],\n",
       "       [ 0.07509935],\n",
       "       [ 0.09584671],\n",
       "       [ 0.07510364],\n",
       "       [ 0.35320085],\n",
       "       [ 0.07642287],\n",
       "       [ 1.2028276 ],\n",
       "       [ 0.07509935],\n",
       "       [ 0.07513106],\n",
       "       [ 0.15446633],\n",
       "       [ 0.25003505],\n",
       "       [ 0.18334931],\n",
       "       [ 0.1824776 ],\n",
       "       [ 0.29356933],\n",
       "       [ 6.9083886 ],\n",
       "       [ 0.4020381 ],\n",
       "       [ 0.4309607 ],\n",
       "       [ 0.07509935],\n",
       "       [ 6.8710504 ],\n",
       "       [ 0.48572212],\n",
       "       [ 0.31781977],\n",
       "       [ 0.07961535],\n",
       "       [ 0.07509935],\n",
       "       [ 0.07819146],\n",
       "       [ 0.09433448],\n",
       "       [ 0.43618238],\n",
       "       [ 0.16186225],\n",
       "       [ 0.2056688 ],\n",
       "       [ 0.33226663],\n",
       "       [ 2.0965886 ],\n",
       "       [ 0.77581716],\n",
       "       [ 0.11942977],\n",
       "       [ 0.7671606 ],\n",
       "       [ 0.18256563],\n",
       "       [ 0.25887007],\n",
       "       [ 0.14388013],\n",
       "       [ 2.719856  ],\n",
       "       [ 0.11543083],\n",
       "       [ 0.1244756 ],\n",
       "       [ 0.20578402],\n",
       "       [ 0.13701725],\n",
       "       [ 0.15869176],\n",
       "       [ 0.34839612],\n",
       "       [ 0.22954637],\n",
       "       [ 7.8447456 ],\n",
       "       [ 0.07509935],\n",
       "       [ 0.08094722],\n",
       "       [ 1.0612849 ],\n",
       "       [ 0.16092324],\n",
       "       [ 0.97857535],\n",
       "       [ 0.22781152],\n",
       "       [ 0.6226279 ],\n",
       "       [ 0.25428724],\n",
       "       [ 0.0751133 ],\n",
       "       [ 0.20968086],\n",
       "       [ 0.2631647 ],\n",
       "       [ 0.7429315 ],\n",
       "       [ 0.6150808 ],\n",
       "       [ 1.3950984 ],\n",
       "       [ 0.07509935],\n",
       "       [ 0.39112192],\n",
       "       [ 0.26091677],\n",
       "       [ 0.07557404],\n",
       "       [ 0.63736665],\n",
       "       [ 0.20256484],\n",
       "       [ 0.12822676],\n",
       "       [ 0.19722563],\n",
       "       [ 1.3795145 ],\n",
       "       [ 0.38568288],\n",
       "       [ 0.8097509 ],\n",
       "       [ 3.6718225 ],\n",
       "       [ 0.64096546],\n",
       "       [ 0.07933879],\n",
       "       [ 0.14777458],\n",
       "       [ 0.26667368],\n",
       "       [ 0.11102796],\n",
       "       [ 0.21394652],\n",
       "       [ 0.24732727],\n",
       "       [ 0.07523763],\n",
       "       [ 0.08896917],\n",
       "       [ 0.4023804 ],\n",
       "       [ 0.07522261],\n",
       "       [ 0.10441703],\n",
       "       [ 0.12098151],\n",
       "       [ 0.14739591],\n",
       "       [ 0.38645124],\n",
       "       [ 0.38806343],\n",
       "       [ 0.07510799],\n",
       "       [ 0.24939758],\n",
       "       [ 1.7048826 ],\n",
       "       [ 0.43246245],\n",
       "       [ 0.65563506],\n",
       "       [ 1.4561021 ],\n",
       "       [ 0.33312726],\n",
       "       [ 0.36448056],\n",
       "       [ 0.08393288],\n",
       "       [ 0.16740108],\n",
       "       [ 0.14124155],\n",
       "       [ 0.26394725],\n",
       "       [ 0.07612503],\n",
       "       [ 0.09330767],\n",
       "       [ 0.23058462],\n",
       "       [ 0.07752001],\n",
       "       [ 0.07509935],\n",
       "       [ 0.29175568]], dtype=float32)"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Y_hat=model.predict(X_test)\n",
    "Y_hat"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "3WUz5SKXeWeA",
    "outputId": "f140f85c-c3fd-4497-9664-b8b20b159fef"
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[1.16714286e+00],\n",
       "       [8.17057212e-02],\n",
       "       [7.87544531e-01],\n",
       "       [1.49572650e-02],\n",
       "       [5.91313131e-02],\n",
       "       [2.47898551e-03],\n",
       "       [6.27029448e-02],\n",
       "       [5.08756567e-02],\n",
       "       [5.02166065e-03],\n",
       "       [5.73452485e-02],\n",
       "       [5.48754749e-01],\n",
       "       [5.74209708e-02],\n",
       "       [1.40845753e-01],\n",
       "       [2.71312265e-01],\n",
       "       [9.10891089e-01],\n",
       "       [3.43948718e-02],\n",
       "       [6.78235294e-02],\n",
       "       [2.14908880e-01],\n",
       "       [6.63979132e-02],\n",
       "       [1.74084416e-01],\n",
       "       [5.08756567e-02],\n",
       "       [2.30433000e-02],\n",
       "       [1.35503388e-01],\n",
       "       [8.46153846e-02],\n",
       "       [6.84512428e-02],\n",
       "       [3.67736151e-01],\n",
       "       [6.41022433e-01],\n",
       "       [2.07942170e-01],\n",
       "       [1.32242833e-03],\n",
       "       [1.75048381e-01],\n",
       "       [4.02076574e-01],\n",
       "       [3.35648148e-03],\n",
       "       [1.01250000e+00],\n",
       "       [3.03260459e-02],\n",
       "       [3.39163498e-02],\n",
       "       [3.39500734e-02],\n",
       "       [6.20557157e-01],\n",
       "       [1.94195387e-01],\n",
       "       [1.43000000e-01],\n",
       "       [3.46646571e-02],\n",
       "       [5.08333333e-01],\n",
       "       [1.05796421e-01],\n",
       "       [6.68571429e+00],\n",
       "       [4.18912388e-02],\n",
       "       [5.26701493e-02],\n",
       "       [4.62126876e-02],\n",
       "       [1.48682746e-01],\n",
       "       [2.26933007e-03],\n",
       "       [8.29109551e-01],\n",
       "       [1.26029448e-02],\n",
       "       [1.41380753e-02],\n",
       "       [7.42556918e-01],\n",
       "       [1.83539971e-02],\n",
       "       [2.83549784e-02],\n",
       "       [8.63402303e-02],\n",
       "       [9.04145996e-02],\n",
       "       [6.41401051e-02],\n",
       "       [2.81619843e-01],\n",
       "       [1.83503244e-03],\n",
       "       [2.49606204e-01],\n",
       "       [2.33564951e-01],\n",
       "       [9.13750138e-01],\n",
       "       [5.47570194e-01],\n",
       "       [3.93210030e-01],\n",
       "       [2.98510773e-01],\n",
       "       [5.93302401e-01],\n",
       "       [9.75142857e-01],\n",
       "       [8.75000000e-01],\n",
       "       [3.22571865e-01],\n",
       "       [1.12173724e-01],\n",
       "       [7.94074949e-01],\n",
       "       [6.02409639e-02],\n",
       "       [1.81303154e-01],\n",
       "       [9.24914729e-02],\n",
       "       [1.03614874e+00],\n",
       "       [5.72333948e-02],\n",
       "       [3.80459770e-01],\n",
       "       [7.05000000e-02],\n",
       "       [4.70347648e-01],\n",
       "       [1.79564692e-01],\n",
       "       [9.66821705e-02],\n",
       "       [2.74463010e-04],\n",
       "       [4.14518008e-01],\n",
       "       [7.32091837e+00],\n",
       "       [5.58641551e-02],\n",
       "       [1.29632408e-01],\n",
       "       [9.37419955e-03],\n",
       "       [7.56620877e-01],\n",
       "       [2.07708373e-01],\n",
       "       [4.37777778e-02],\n",
       "       [8.51371862e-01],\n",
       "       [1.39694591e+00],\n",
       "       [4.62126876e-02],\n",
       "       [1.31177130e-01],\n",
       "       [1.23157123e-01],\n",
       "       [1.24740125e-01],\n",
       "       [7.77029361e-02],\n",
       "       [1.81303154e-01],\n",
       "       [8.00308642e-02],\n",
       "       [7.36104411e-01],\n",
       "       [1.03400123e-02],\n",
       "       [1.02390446e+00],\n",
       "       [1.66733333e+01],\n",
       "       [9.40421576e-03],\n",
       "       [1.21744255e-02],\n",
       "       [4.05642091e-01],\n",
       "       [3.95533141e-01],\n",
       "       [6.55683994e-02],\n",
       "       [4.42294894e-03],\n",
       "       [5.82606118e-02],\n",
       "       [1.40127080e-01],\n",
       "       [1.81765236e-01],\n",
       "       [2.45277406e-01],\n",
       "       [1.44724640e-02],\n",
       "       [1.16896701e-02],\n",
       "       [1.45433806e-03],\n",
       "       [4.09616871e-02],\n",
       "       [1.03653566e-01],\n",
       "       [6.05995717e-02],\n",
       "       [7.06932314e-02],\n",
       "       [1.01250000e+00],\n",
       "       [2.79866180e-01],\n",
       "       [5.02166065e-03],\n",
       "       [3.62176806e-03],\n",
       "       [2.85433667e-02],\n",
       "       [5.00389560e-01],\n",
       "       [2.49147050e-01],\n",
       "       [1.69761905e+00],\n",
       "       [7.14778504e-01],\n",
       "       [2.30411711e-02],\n",
       "       [3.83216222e-02],\n",
       "       [8.52218330e-01],\n",
       "       [1.92301491e-01],\n",
       "       [4.58444902e-02],\n",
       "       [3.01394170e-01],\n",
       "       [2.65358615e-01],\n",
       "       [5.47570194e-01],\n",
       "       [3.33333333e-02],\n",
       "       [6.06872016e-02],\n",
       "       [1.26029448e-02],\n",
       "       [1.00000000e-01],\n",
       "       [1.04260355e-02],\n",
       "       [1.37920360e+00],\n",
       "       [2.74463010e-04],\n",
       "       [5.64705882e-02],\n",
       "       [2.74384556e-01],\n",
       "       [7.18249875e-02],\n",
       "       [1.33837918e-01],\n",
       "       [2.77404678e-01],\n",
       "       [5.28593508e-01],\n",
       "       [8.17142857e+00],\n",
       "       [3.78109453e-02],\n",
       "       [5.92811306e-01],\n",
       "       [1.32242833e-03],\n",
       "       [1.08912087e+00],\n",
       "       [3.94808566e-01],\n",
       "       [2.36426508e-01],\n",
       "       [1.49572650e-02],\n",
       "       [1.32242833e-03],\n",
       "       [2.67062108e-02],\n",
       "       [5.82825561e-02],\n",
       "       [1.03681787e+00],\n",
       "       [2.00145307e-02],\n",
       "       [6.33333333e-02],\n",
       "       [2.47160627e-01],\n",
       "       [1.33862480e+00],\n",
       "       [3.75176409e-01],\n",
       "       [6.33750824e-02],\n",
       "       [8.89134199e-01],\n",
       "       [2.77404678e-01],\n",
       "       [2.30139352e-01],\n",
       "       [5.10507881e-02],\n",
       "       [8.17142857e+00],\n",
       "       [7.65112263e-02],\n",
       "       [1.68099752e-01],\n",
       "       [1.32127261e-01],\n",
       "       [7.70038441e-02],\n",
       "       [2.20965637e-02],\n",
       "       [1.00000000e-01],\n",
       "       [2.45076603e-01],\n",
       "       [2.24302898e-01],\n",
       "       [3.00333241e-03],\n",
       "       [2.69242847e-02],\n",
       "       [1.50831661e+00],\n",
       "       [4.29492187e-02],\n",
       "       [9.66102966e-01],\n",
       "       [4.14102564e-02],\n",
       "       [1.95356106e-01],\n",
       "       [1.59608142e-01],\n",
       "       [2.64311594e-03],\n",
       "       [1.32127261e-01],\n",
       "       [1.29632408e-01],\n",
       "       [8.64736652e-01],\n",
       "       [2.87588846e-01],\n",
       "       [1.11616619e+00],\n",
       "       [6.98985344e-03],\n",
       "       [1.96998378e-01],\n",
       "       [1.58531473e-01],\n",
       "       [9.01071110e-03],\n",
       "       [1.35122077e+00],\n",
       "       [5.10843505e-02],\n",
       "       [9.49101962e-02],\n",
       "       [3.98343505e-02],\n",
       "       [1.43560021e+00],\n",
       "       [3.54742307e-01],\n",
       "       [5.01022495e-01],\n",
       "       [1.35001294e+00],\n",
       "       [4.20229885e-01],\n",
       "       [2.69242847e-02],\n",
       "       [1.38701736e-01],\n",
       "       [2.99513382e-01],\n",
       "       [3.87022350e-02],\n",
       "       [1.32127261e-01],\n",
       "       [1.69761905e+00],\n",
       "       [2.56481482e-03],\n",
       "       [4.20560261e-02],\n",
       "       [4.42160088e-01],\n",
       "       [9.78609626e-02],\n",
       "       [4.27449136e-02],\n",
       "       [3.15115440e-02],\n",
       "       [1.50595757e-02],\n",
       "       [4.50260307e-01],\n",
       "       [7.82026769e-02],\n",
       "       [4.77296366e-02],\n",
       "       [7.15478031e-01],\n",
       "       [1.25262295e+00],\n",
       "       [5.83833341e-01],\n",
       "       [4.11143132e-01],\n",
       "       [5.77970547e-01],\n",
       "       [1.69166667e-01],\n",
       "       [1.54603175e-01],\n",
       "       [1.08100358e-02],\n",
       "       [1.01928675e-01],\n",
       "       [4.20585938e-02],\n",
       "       [9.64354794e-02],\n",
       "       [2.97373030e-03],\n",
       "       [6.34116656e-02],\n",
       "       [7.30527349e-01],\n",
       "       [6.78235294e-02],\n",
       "       [2.35507246e-03],\n",
       "       [9.07854137e-01]])"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "Y_test"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "nST1AeApewHr"
   },
   "source": [
    "Problems to be addressed:\n",
    "*   Analyze the performance of the model.\n",
    "*   Prediction of coutries that will run out of water by 2050. (can be verified by checking if the Water stress will reach 100% or 1.0)\n",
    "*   No justification behind chossing the certain number of hidden layers and certain number of neurons.\n",
    "*   Further use this model to predict values of water stress in the app.\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {
    "id": "aSXvfg1NmOfo"
   },
   "source": [
    "# Predict the x variables for future"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 424
    },
    "id": "wRFpQN5kxZpG",
    "outputId": "d0bd5a70-b758-4d72-ca9c-ec3e56c2d53d"
   },
   "outputs": [
    {
     "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>Area</th>\n",
       "      <th>Variable Name</th>\n",
       "      <th>Year</th>\n",
       "      <th>Value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Total population</td>\n",
       "      <td>1962</td>\n",
       "      <td>9351.441000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Total population</td>\n",
       "      <td>1967</td>\n",
       "      <td>10399.926000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Total population</td>\n",
       "      <td>1972</td>\n",
       "      <td>11791.215000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Total population</td>\n",
       "      <td>1977</td>\n",
       "      <td>13171.306000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Total population</td>\n",
       "      <td>1982</td>\n",
       "      <td>12882.528000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18698</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>SDG 6.4.2. Water Stress</td>\n",
       "      <td>2002</td>\n",
       "      <td>39.476155</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18699</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>SDG 6.4.2. Water Stress</td>\n",
       "      <td>2007</td>\n",
       "      <td>33.514833</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18700</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>SDG 6.4.2. Water Stress</td>\n",
       "      <td>2012</td>\n",
       "      <td>32.488030</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18701</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>SDG 6.4.2. Water Stress</td>\n",
       "      <td>2017</td>\n",
       "      <td>31.346226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18702</th>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>SDG 6.4.2. Water Stress</td>\n",
       "      <td>2018</td>\n",
       "      <td>35.405370</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>18703 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              Area            Variable Name  Year         Value\n",
       "0      Afghanistan         Total population  1962   9351.441000\n",
       "1      Afghanistan         Total population  1967  10399.926000\n",
       "2      Afghanistan         Total population  1972  11791.215000\n",
       "3      Afghanistan         Total population  1977  13171.306000\n",
       "4      Afghanistan         Total population  1982  12882.528000\n",
       "...            ...                      ...   ...           ...\n",
       "18698     Zimbabwe  SDG 6.4.2. Water Stress  2002     39.476155\n",
       "18699     Zimbabwe  SDG 6.4.2. Water Stress  2007     33.514833\n",
       "18700     Zimbabwe  SDG 6.4.2. Water Stress  2012     32.488030\n",
       "18701     Zimbabwe  SDG 6.4.2. Water Stress  2017     31.346226\n",
       "18702     Zimbabwe  SDG 6.4.2. Water Stress  2018     35.405370\n",
       "\n",
       "[18703 rows x 4 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Read and prepare the data\n",
    "data_ori = pd.read_csv('https://www.dropbox.com/s/j07u99pg44kbfvm/final_data.csv?dl=1')\n",
    "data_ori"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 606
    },
    "id": "fcLfzQEhPaPb",
    "outputId": "c6a5f754-afce-4369-96b5-a457291d0c3e"
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Dimensions of the original dataset:  (2431, 15)\n",
      "Dimensions of the new dataset:  (1205, 10)\n"
     ]
    },
    {
     "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>Variable Name</th>\n",
       "      <th>Year</th>\n",
       "      <th>Area</th>\n",
       "      <th>Agricultural water withdrawal as % of total water withdrawal</th>\n",
       "      <th>GDP per capita</th>\n",
       "      <th>Long-term average annual precipitation in volume</th>\n",
       "      <th>Municipal water withdrawal as % of total withdrawal</th>\n",
       "      <th>Population density</th>\n",
       "      <th>SDG 6.4.2. Water Stress</th>\n",
       "      <th>Total renewable water resources per capita</th>\n",
       "      <th>Total water withdrawal per capita</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>388</th>\n",
       "      <td>1972</td>\n",
       "      <td>Denmark</td>\n",
       "      <td>31.947484</td>\n",
       "      <td>4655.290175</td>\n",
       "      <td>30.29227</td>\n",
       "      <td>60.831510</td>\n",
       "      <td>115.816802</td>\n",
       "      <td>24.716063</td>\n",
       "      <td>1202.273258</td>\n",
       "      <td>183.146293</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>404</th>\n",
       "      <td>1972</td>\n",
       "      <td>Ghana</td>\n",
       "      <td>54.727904</td>\n",
       "      <td>493.336524</td>\n",
       "      <td>283.14698</td>\n",
       "      <td>32.902354</td>\n",
       "      <td>38.692173</td>\n",
       "      <td>1.505958</td>\n",
       "      <td>6089.084168</td>\n",
       "      <td>37.430171</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>414</th>\n",
       "      <td>1972</td>\n",
       "      <td>Hungary</td>\n",
       "      <td>22.379496</td>\n",
       "      <td>782.184870</td>\n",
       "      <td>54.79467</td>\n",
       "      <td>20.569268</td>\n",
       "      <td>112.072299</td>\n",
       "      <td>5.828256</td>\n",
       "      <td>9974.980064</td>\n",
       "      <td>323.626719</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>421</th>\n",
       "      <td>1972</td>\n",
       "      <td>Israel</td>\n",
       "      <td>78.318250</td>\n",
       "      <td>2762.062183</td>\n",
       "      <td>9.60045</td>\n",
       "      <td>16.779789</td>\n",
       "      <td>135.771726</td>\n",
       "      <td>135.122077</td>\n",
       "      <td>594.029932</td>\n",
       "      <td>531.022713</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>422</th>\n",
       "      <td>1972</td>\n",
       "      <td>Italy</td>\n",
       "      <td>59.201104</td>\n",
       "      <td>2674.044383</td>\n",
       "      <td>250.71488</td>\n",
       "      <td>16.811125</td>\n",
       "      <td>180.058210</td>\n",
       "      <td>37.599562</td>\n",
       "      <td>3525.699205</td>\n",
       "      <td>786.449189</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2426</th>\n",
       "      <td>2018</td>\n",
       "      <td>Venezuela (Bolivarian Republic of)</td>\n",
       "      <td>73.852110</td>\n",
       "      <td>6433.928949</td>\n",
       "      <td>1864.23020</td>\n",
       "      <td>22.641793</td>\n",
       "      <td>31.672735</td>\n",
       "      <td>7.540367</td>\n",
       "      <td>45868.196340</td>\n",
       "      <td>783.266091</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2427</th>\n",
       "      <td>2018</td>\n",
       "      <td>Viet Nam</td>\n",
       "      <td>94.782397</td>\n",
       "      <td>2538.068147</td>\n",
       "      <td>603.16983</td>\n",
       "      <td>1.470194</td>\n",
       "      <td>288.458056</td>\n",
       "      <td>18.130315</td>\n",
       "      <td>9253.347619</td>\n",
       "      <td>858.539684</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2428</th>\n",
       "      <td>2018</td>\n",
       "      <td>Yemen</td>\n",
       "      <td>90.743338</td>\n",
       "      <td>922.404203</td>\n",
       "      <td>88.17099</td>\n",
       "      <td>7.433380</td>\n",
       "      <td>53.977845</td>\n",
       "      <td>169.761905</td>\n",
       "      <td>73.687616</td>\n",
       "      <td>125.093500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2429</th>\n",
       "      <td>2018</td>\n",
       "      <td>Zambia</td>\n",
       "      <td>73.282443</td>\n",
       "      <td>1549.354235</td>\n",
       "      <td>767.66220</td>\n",
       "      <td>18.447837</td>\n",
       "      <td>23.055378</td>\n",
       "      <td>2.835498</td>\n",
       "      <td>6039.751245</td>\n",
       "      <td>90.596269</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2430</th>\n",
       "      <td>2018</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>80.635470</td>\n",
       "      <td>1437.425967</td>\n",
       "      <td>256.72932</td>\n",
       "      <td>17.207494</td>\n",
       "      <td>36.950563</td>\n",
       "      <td>35.405370</td>\n",
       "      <td>1385.156469</td>\n",
       "      <td>261.197570</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1205 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Variable Name  Year                                Area  \\\n",
       "388            1972                             Denmark   \n",
       "404            1972                               Ghana   \n",
       "414            1972                             Hungary   \n",
       "421            1972                              Israel   \n",
       "422            1972                               Italy   \n",
       "...             ...                                 ...   \n",
       "2426           2018  Venezuela (Bolivarian Republic of)   \n",
       "2427           2018                            Viet Nam   \n",
       "2428           2018                               Yemen   \n",
       "2429           2018                              Zambia   \n",
       "2430           2018                            Zimbabwe   \n",
       "\n",
       "Variable Name  Agricultural water withdrawal as % of total water withdrawal  \\\n",
       "388                                                    31.947484              \n",
       "404                                                    54.727904              \n",
       "414                                                    22.379496              \n",
       "421                                                    78.318250              \n",
       "422                                                    59.201104              \n",
       "...                                                          ...              \n",
       "2426                                                   73.852110              \n",
       "2427                                                   94.782397              \n",
       "2428                                                   90.743338              \n",
       "2429                                                   73.282443              \n",
       "2430                                                   80.635470              \n",
       "\n",
       "Variable Name  GDP per capita  \\\n",
       "388               4655.290175   \n",
       "404                493.336524   \n",
       "414                782.184870   \n",
       "421               2762.062183   \n",
       "422               2674.044383   \n",
       "...                       ...   \n",
       "2426              6433.928949   \n",
       "2427              2538.068147   \n",
       "2428               922.404203   \n",
       "2429              1549.354235   \n",
       "2430              1437.425967   \n",
       "\n",
       "Variable Name  Long-term average annual precipitation in volume  \\\n",
       "388                                                    30.29227   \n",
       "404                                                   283.14698   \n",
       "414                                                    54.79467   \n",
       "421                                                     9.60045   \n",
       "422                                                   250.71488   \n",
       "...                                                         ...   \n",
       "2426                                                 1864.23020   \n",
       "2427                                                  603.16983   \n",
       "2428                                                   88.17099   \n",
       "2429                                                  767.66220   \n",
       "2430                                                  256.72932   \n",
       "\n",
       "Variable Name  Municipal water withdrawal as % of total withdrawal  \\\n",
       "388                                                    60.831510     \n",
       "404                                                    32.902354     \n",
       "414                                                    20.569268     \n",
       "421                                                    16.779789     \n",
       "422                                                    16.811125     \n",
       "...                                                          ...     \n",
       "2426                                                   22.641793     \n",
       "2427                                                    1.470194     \n",
       "2428                                                    7.433380     \n",
       "2429                                                   18.447837     \n",
       "2430                                                   17.207494     \n",
       "\n",
       "Variable Name  Population density  SDG 6.4.2. Water Stress  \\\n",
       "388                    115.816802                24.716063   \n",
       "404                     38.692173                 1.505958   \n",
       "414                    112.072299                 5.828256   \n",
       "421                    135.771726               135.122077   \n",
       "422                    180.058210                37.599562   \n",
       "...                           ...                      ...   \n",
       "2426                    31.672735                 7.540367   \n",
       "2427                   288.458056                18.130315   \n",
       "2428                    53.977845               169.761905   \n",
       "2429                    23.055378                 2.835498   \n",
       "2430                    36.950563                35.405370   \n",
       "\n",
       "Variable Name  Total renewable water resources per capita  \\\n",
       "388                                           1202.273258   \n",
       "404                                           6089.084168   \n",
       "414                                           9974.980064   \n",
       "421                                            594.029932   \n",
       "422                                           3525.699205   \n",
       "...                                                   ...   \n",
       "2426                                         45868.196340   \n",
       "2427                                          9253.347619   \n",
       "2428                                            73.687616   \n",
       "2429                                          6039.751245   \n",
       "2430                                          1385.156469   \n",
       "\n",
       "Variable Name  Total water withdrawal per capita  \n",
       "388                                   183.146293  \n",
       "404                                    37.430171  \n",
       "414                                   323.626719  \n",
       "421                                   531.022713  \n",
       "422                                   786.449189  \n",
       "...                                          ...  \n",
       "2426                                  783.266091  \n",
       "2427                                  858.539684  \n",
       "2428                                  125.093500  \n",
       "2429                                   90.596269  \n",
       "2430                                  261.197570  \n",
       "\n",
       "[1205 rows x 10 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_ori = data_ori.groupby(['Year','Variable Name', 'Area'])['Value'].aggregate('mean').unstack(1)\n",
    "data_ori.reset_index(inplace=True)\n",
    "print(\"Dimensions of the original dataset: \", data_ori.shape)\n",
    "data_ori.dropna(subset=[\"Population density\",\"GDP per capita\",\"SDG 6.4.2. Water Stress\",\"Agricultural water withdrawal as % of total water withdrawal\",\"Municipal water withdrawal as % of total withdrawal\"], inplace=True)\n",
    "data_ori.drop([\"Total population\",\"Capacity of the municipal wastewater treatment facilities\",\"Collected municipal wastewater\",\"Not treated municipal wastewater\",\"Industrial water withdrawal as % of total water withdrawal\"], axis=1, inplace=True)\n",
    "print(\"Dimensions of the new dataset: \", data_ori.shape)\n",
    "data_ori\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {
    "id": "Prv3Oih1bNtE"
   },
   "outputs": [],
   "source": [
    "def extrapolate(country,variable):\n",
    "  poly = np.polyfit(data_ori[data_ori['Area']==country]['Year'], data_ori[data_ori['Area']==country][variable], deg=1)\n",
    "  y_int  = np.polyval(poly, 2022)\n",
    "  return y_int"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "id": "jkZ2RzxRaUrU"
   },
   "outputs": [],
   "source": [
    "newdata = data_ori[data_ori['Area']=='country']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "id": "x-XrwYpwaPBX",
    "outputId": "585a43df-c28e-4b20-99dc-cc74f5fa6394"
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
      "C:\\Users\\nikte\\AppData\\Local\\Temp\\ipykernel_5752\\1285327992.py:5: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n"
     ]
    }
   ],
   "source": [
    "ind=0\n",
    "for i in np.unique(np.array(data_ori['Area'])):\n",
    "  #print(ind)\n",
    "  #print(i)\n",
    "  newdata.loc[ind] = pd.Series({'Year':2022, 'Area':i,\n",
    "                                'Agricultural water withdrawal as % of total water withdrawal':extrapolate(i,'Agricultural water withdrawal as % of total water withdrawal'),\n",
    "                                'GDP per capita':extrapolate(i,'GDP per capita'), \n",
    "                                'Long-term average annual precipitation in volume':extrapolate(i,'Long-term average annual precipitation in volume'),\n",
    "                                'Municipal water withdrawal as % of total withdrawal':extrapolate(i,'Municipal water withdrawal as % of total withdrawal'),\n",
    "                                'Population density':extrapolate(i,'Population density'), \n",
    "                                'SDG 6.4.2. Water Stress':extrapolate(i,'SDG 6.4.2. Water Stress'),\n",
    "                                'Total renewable water resources per capita':extrapolate(i,'Total renewable water resources per capita'),\n",
    "                                'Total water withdrawal per capita':extrapolate(i,'Total water withdrawal per capita')})\n",
    "  #print(newdata.loc[ind])\n",
    "  ind=ind+1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/",
     "height": 606
    },
    "id": "QV7uZu8chlSL",
    "outputId": "7cd5bcb4-834e-4163-a15c-68a96bf0a26b"
   },
   "outputs": [
    {
     "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>Variable Name</th>\n",
       "      <th>Year</th>\n",
       "      <th>Area</th>\n",
       "      <th>Agricultural water withdrawal as % of total water withdrawal</th>\n",
       "      <th>GDP per capita</th>\n",
       "      <th>Long-term average annual precipitation in volume</th>\n",
       "      <th>Municipal water withdrawal as % of total withdrawal</th>\n",
       "      <th>Population density</th>\n",
       "      <th>SDG 6.4.2. Water Stress</th>\n",
       "      <th>Total renewable water resources per capita</th>\n",
       "      <th>Total water withdrawal per capita</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>97.941104</td>\n",
       "      <td>656.180969</td>\n",
       "      <td>213.48522</td>\n",
       "      <td>0.993969</td>\n",
       "      <td>61.257508</td>\n",
       "      <td>50.562994</td>\n",
       "      <td>969.975594</td>\n",
       "      <td>176.892287</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022</td>\n",
       "      <td>Albania</td>\n",
       "      <td>57.542793</td>\n",
       "      <td>5786.599868</td>\n",
       "      <td>41.381326</td>\n",
       "      <td>30.362635</td>\n",
       "      <td>101.094659</td>\n",
       "      <td>6.154082</td>\n",
       "      <td>10689.844269</td>\n",
       "      <td>363.92748</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022</td>\n",
       "      <td>Algeria</td>\n",
       "      <td>58.977252</td>\n",
       "      <td>4659.461837</td>\n",
       "      <td>211.974923</td>\n",
       "      <td>38.004788</td>\n",
       "      <td>18.40922</td>\n",
       "      <td>142.115966</td>\n",
       "      <td>233.342039</td>\n",
       "      <td>255.148373</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022</td>\n",
       "      <td>Angola</td>\n",
       "      <td>5.890727</td>\n",
       "      <td>4653.147601</td>\n",
       "      <td>1259.167</td>\n",
       "      <td>53.707643</td>\n",
       "      <td>25.809087</td>\n",
       "      <td>2.03677</td>\n",
       "      <td>3238.309847</td>\n",
       "      <td>21.052376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022</td>\n",
       "      <td>Antigua and Barbuda</td>\n",
       "      <td>14.236588</td>\n",
       "      <td>16491.180458</td>\n",
       "      <td>0.4532</td>\n",
       "      <td>63.205424</td>\n",
       "      <td>231.527633</td>\n",
       "      <td>9.855674</td>\n",
       "      <td>485.886409</td>\n",
       "      <td>131.255451</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>2022</td>\n",
       "      <td>Venezuela (Bolivarian Republic of)</td>\n",
       "      <td>76.424646</td>\n",
       "      <td>9129.766093</td>\n",
       "      <td>1864.069566</td>\n",
       "      <td>21.187347</td>\n",
       "      <td>35.293496</td>\n",
       "      <td>8.25744</td>\n",
       "      <td>32080.107666</td>\n",
       "      <td>819.597845</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>2022</td>\n",
       "      <td>Viet Nam</td>\n",
       "      <td>95.87318</td>\n",
       "      <td>2400.104517</td>\n",
       "      <td>602.640497</td>\n",
       "      <td>0.828757</td>\n",
       "      <td>304.226958</td>\n",
       "      <td>20.510049</td>\n",
       "      <td>8166.541004</td>\n",
       "      <td>944.226983</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>2022</td>\n",
       "      <td>Yemen</td>\n",
       "      <td>90.544375</td>\n",
       "      <td>1217.420441</td>\n",
       "      <td>88.17099</td>\n",
       "      <td>7.490926</td>\n",
       "      <td>57.992638</td>\n",
       "      <td>177.354961</td>\n",
       "      <td>56.084185</td>\n",
       "      <td>106.871156</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>2022</td>\n",
       "      <td>Zambia</td>\n",
       "      <td>72.242013</td>\n",
       "      <td>1861.535819</td>\n",
       "      <td>767.6622</td>\n",
       "      <td>18.899592</td>\n",
       "      <td>24.287317</td>\n",
       "      <td>2.745366</td>\n",
       "      <td>4918.65272</td>\n",
       "      <td>67.947275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>2022</td>\n",
       "      <td>Zimbabwe</td>\n",
       "      <td>82.04176</td>\n",
       "      <td>1204.127361</td>\n",
       "      <td>256.72932</td>\n",
       "      <td>15.679512</td>\n",
       "      <td>37.888992</td>\n",
       "      <td>39.641407</td>\n",
       "      <td>1301.994531</td>\n",
       "      <td>298.781443</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>177 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "Variable Name  Year                                Area  \\\n",
       "0              2022                         Afghanistan   \n",
       "1              2022                             Albania   \n",
       "2              2022                             Algeria   \n",
       "3              2022                              Angola   \n",
       "4              2022                 Antigua and Barbuda   \n",
       "..              ...                                 ...   \n",
       "172            2022  Venezuela (Bolivarian Republic of)   \n",
       "173            2022                            Viet Nam   \n",
       "174            2022                               Yemen   \n",
       "175            2022                              Zambia   \n",
       "176            2022                            Zimbabwe   \n",
       "\n",
       "Variable Name Agricultural water withdrawal as % of total water withdrawal  \\\n",
       "0                                                      97.941104             \n",
       "1                                                      57.542793             \n",
       "2                                                      58.977252             \n",
       "3                                                       5.890727             \n",
       "4                                                      14.236588             \n",
       "..                                                           ...             \n",
       "172                                                    76.424646             \n",
       "173                                                     95.87318             \n",
       "174                                                    90.544375             \n",
       "175                                                    72.242013             \n",
       "176                                                     82.04176             \n",
       "\n",
       "Variable Name GDP per capita Long-term average annual precipitation in volume  \\\n",
       "0                 656.180969                                        213.48522   \n",
       "1                5786.599868                                        41.381326   \n",
       "2                4659.461837                                       211.974923   \n",
       "3                4653.147601                                         1259.167   \n",
       "4               16491.180458                                           0.4532   \n",
       "..                       ...                                              ...   \n",
       "172              9129.766093                                      1864.069566   \n",
       "173              2400.104517                                       602.640497   \n",
       "174              1217.420441                                         88.17099   \n",
       "175              1861.535819                                         767.6622   \n",
       "176              1204.127361                                        256.72932   \n",
       "\n",
       "Variable Name Municipal water withdrawal as % of total withdrawal  \\\n",
       "0                                                       0.993969    \n",
       "1                                                      30.362635    \n",
       "2                                                      38.004788    \n",
       "3                                                      53.707643    \n",
       "4                                                      63.205424    \n",
       "..                                                           ...    \n",
       "172                                                    21.187347    \n",
       "173                                                     0.828757    \n",
       "174                                                     7.490926    \n",
       "175                                                    18.899592    \n",
       "176                                                    15.679512    \n",
       "\n",
       "Variable Name Population density SDG 6.4.2. Water Stress  \\\n",
       "0                      61.257508               50.562994   \n",
       "1                     101.094659                6.154082   \n",
       "2                       18.40922              142.115966   \n",
       "3                      25.809087                 2.03677   \n",
       "4                     231.527633                9.855674   \n",
       "..                           ...                     ...   \n",
       "172                    35.293496                 8.25744   \n",
       "173                   304.226958               20.510049   \n",
       "174                    57.992638              177.354961   \n",
       "175                    24.287317                2.745366   \n",
       "176                    37.888992               39.641407   \n",
       "\n",
       "Variable Name Total renewable water resources per capita  \\\n",
       "0                                             969.975594   \n",
       "1                                           10689.844269   \n",
       "2                                             233.342039   \n",
       "3                                            3238.309847   \n",
       "4                                             485.886409   \n",
       "..                                                   ...   \n",
       "172                                         32080.107666   \n",
       "173                                          8166.541004   \n",
       "174                                            56.084185   \n",
       "175                                           4918.65272   \n",
       "176                                          1301.994531   \n",
       "\n",
       "Variable Name Total water withdrawal per capita  \n",
       "0                                    176.892287  \n",
       "1                                     363.92748  \n",
       "2                                    255.148373  \n",
       "3                                     21.052376  \n",
       "4                                    131.255451  \n",
       "..                                          ...  \n",
       "172                                  819.597845  \n",
       "173                                  944.226983  \n",
       "174                                  106.871156  \n",
       "175                                   67.947275  \n",
       "176                                  298.781443  \n",
       "\n",
       "[177 rows x 10 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newdata"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "id": "fvC73Y79iL-2"
   },
   "outputs": [],
   "source": [
    "newdata.to_csv('validation_data.csv', encoding = 'utf-8-sig') "
   ]
  }
 ],
 "metadata": {
  "colab": {
   "collapsed_sections": [],
   "name": "NeuralNetword_ValidationData.ipynb",
   "provenance": []
  },
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}