data_combination.ipynb

{
  "cells": [
    {
      "cell_type": "code",
      "execution_count": 61,
      "metadata": {},
      "outputs": [],
      "source": [
        "# Combined Datasets\n",
        "# GDP\n",
        "# Gini\n",
        "# HDI\n",
        "# Infrastructure\n",
        "# Internet\n",
        "# Literacy\n",
        "# CO2\n",
        "# CO2#2\n",
        "# Energy\n",
        "\n",
        "\n",
        "#Energy\n",
        "#Maybe HDI\n",
        "\n",
        "\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 62,
      "metadata": {
        "id": "Afa9zm_Jh00x"
      },
      "outputs": [],
      "source": [
        "import pandas as pd"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 63,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 516
        },
        "id": "MekNynda6-FV",
        "outputId": "6bc41490-19b6-461d-bdbb-16d1614b3b17"
      },
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "GDP DataFrame columns: Index(['entity', 'code', 'GDP per Capita 1990', 'GDP per Capita 1991',\n",
            "       'GDP per Capita 1992', 'GDP per Capita 1993', 'GDP per Capita 1994',\n",
            "       'GDP per Capita 1995', 'GDP per Capita 1996', 'GDP per Capita 1997',\n",
            "       'GDP per Capita 1998', 'GDP per Capita 1999', 'GDP per Capita 2000',\n",
            "       'GDP per Capita 2001', 'GDP per Capita 2002', 'GDP per Capita 2003',\n",
            "       'GDP per Capita 2004', 'GDP per Capita 2005', 'GDP per Capita 2006',\n",
            "       'GDP per Capita 2007', 'GDP per Capita 2008', 'GDP per Capita 2009',\n",
            "       'GDP per Capita 2010', 'GDP per Capita 2011', 'GDP per Capita 2012',\n",
            "       'GDP per Capita 2013', 'GDP per Capita 2014', 'GDP per Capita 2015',\n",
            "       'GDP per Capita 2016', 'GDP per Capita 2017', 'GDP per Capita 2018',\n",
            "       'GDP per Capita 2019', 'GDP per Capita 2020', 'GDP per Capita 2021',\n",
            "       'GDP per Capita 2022', 'GDP per Capita 2023'],\n",
            "      dtype='object')\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></th>\n",
              "      <th>Country</th>\n",
              "      <th>GDP per Capita 1990</th>\n",
              "      <th>GDP per Capita 1991</th>\n",
              "      <th>GDP per Capita 1992</th>\n",
              "      <th>GDP per Capita 1993</th>\n",
              "      <th>GDP per Capita 1994</th>\n",
              "      <th>GDP per Capita 1995</th>\n",
              "      <th>GDP per Capita 1996</th>\n",
              "      <th>GDP per Capita 1997</th>\n",
              "      <th>GDP per Capita 1998</th>\n",
              "      <th>...</th>\n",
              "      <th>GDP per Capita 2014</th>\n",
              "      <th>GDP per Capita 2015</th>\n",
              "      <th>GDP per Capita 2016</th>\n",
              "      <th>GDP per Capita 2017</th>\n",
              "      <th>GDP per Capita 2018</th>\n",
              "      <th>GDP per Capita 2019</th>\n",
              "      <th>GDP per Capita 2020</th>\n",
              "      <th>GDP per Capita 2021</th>\n",
              "      <th>GDP per Capita 2022</th>\n",
              "      <th>GDP per Capita 2023</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Afghanistan</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>...</td>\n",
              "      <td>575.146245808546</td>\n",
              "      <td>565.569730408751</td>\n",
              "      <td>563.872336723147</td>\n",
              "      <td>562.769574140988</td>\n",
              "      <td>553.125151688293</td>\n",
              "      <td>557.861533207459</td>\n",
              "      <td>527.834554499306</td>\n",
              "      <td>408.625855217403</td>\n",
              "      <td>377.665627080705</td>\n",
              "      <td>379.707497269884</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Albania</td>\n",
              "      <td>1606.29646776458</td>\n",
              "      <td>1163.49159838489</td>\n",
              "      <td>1086.4387714304</td>\n",
              "      <td>1197.58090750054</td>\n",
              "      <td>1305.00106057165</td>\n",
              "      <td>1488.02088119627</td>\n",
              "      <td>1633.55200001885</td>\n",
              "      <td>1464.29796254199</td>\n",
              "      <td>1603.64765027651</td>\n",
              "      <td>...</td>\n",
              "      <td>3855.76074409659</td>\n",
              "      <td>3952.80357364813</td>\n",
              "      <td>4090.37272829183</td>\n",
              "      <td>4249.8200493985</td>\n",
              "      <td>4431.55559506989</td>\n",
              "      <td>4542.26866282892</td>\n",
              "      <td>4417.04105105395</td>\n",
              "      <td>4858.05201500931</td>\n",
              "      <td>5154.8274975368</td>\n",
              "      <td>5419.63779125273</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Algeria</td>\n",
              "      <td>3605.68701213527</td>\n",
              "      <td>3478.5097627463</td>\n",
              "      <td>3455.9293629926</td>\n",
              "      <td>3302.91950571082</td>\n",
              "      <td>3201.56914405705</td>\n",
              "      <td>3255.187268716</td>\n",
              "      <td>3322.9553813945</td>\n",
              "      <td>3297.46603365919</td>\n",
              "      <td>3410.88254399624</td>\n",
              "      <td>...</td>\n",
              "      <td>4634.10149183949</td>\n",
              "      <td>4685.05902729002</td>\n",
              "      <td>4768.73140080218</td>\n",
              "      <td>4742.90075536604</td>\n",
              "      <td>4717.00358853556</td>\n",
              "      <td>4672.66408682198</td>\n",
              "      <td>4363.68533766912</td>\n",
              "      <td>4456.74687641147</td>\n",
              "      <td>4544.46688059647</td>\n",
              "      <td>4660.40545686886</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>American Samoa</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>...</td>\n",
              "      <td>12203.0894714284</td>\n",
              "      <td>12727.4102651386</td>\n",
              "      <td>12665.2829921268</td>\n",
              "      <td>11930.7771236826</td>\n",
              "      <td>12412.6024074562</td>\n",
              "      <td>12524.0160252283</td>\n",
              "      <td>13194.274740128</td>\n",
              "      <td>13233.5784817341</td>\n",
              "      <td>13709.0974895473</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Andorra</td>\n",
              "      <td>31143.1468745802</td>\n",
              "      <td>29642.305980666</td>\n",
              "      <td>28161.9424927346</td>\n",
              "      <td>26518.2336327363</td>\n",
              "      <td>26587.1383037195</td>\n",
              "      <td>27619.5060608184</td>\n",
              "      <td>28871.2160741757</td>\n",
              "      <td>31140.6896808445</td>\n",
              "      <td>31800.3640667052</td>\n",
              "      <td>...</td>\n",
              "      <td>37300.6244183478</td>\n",
              "      <td>38654.9347203095</td>\n",
              "      <td>40085.0205971586</td>\n",
              "      <td>39361.0622634329</td>\n",
              "      <td>39242.1448960772</td>\n",
              "      <td>39346.2750344286</td>\n",
              "      <td>34536.6499209948</td>\n",
              "      <td>36929.0191515162</td>\n",
              "      <td>39780.3966116268</td>\n",
              "      <td>40227.2335282714</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 35 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "          Country GDP per Capita 1990 GDP per Capita 1991 GDP per Capita 1992  \\\n",
              "0     Afghanistan                <NA>                <NA>                <NA>   \n",
              "1         Albania    1606.29646776458    1163.49159838489     1086.4387714304   \n",
              "2         Algeria    3605.68701213527     3478.5097627463     3455.9293629926   \n",
              "3  American Samoa                <NA>                <NA>                <NA>   \n",
              "4         Andorra    31143.1468745802     29642.305980666    28161.9424927346   \n",
              "\n",
              "  GDP per Capita 1993 GDP per Capita 1994 GDP per Capita 1995  \\\n",
              "0                <NA>                <NA>                <NA>   \n",
              "1    1197.58090750054    1305.00106057165    1488.02088119627   \n",
              "2    3302.91950571082    3201.56914405705      3255.187268716   \n",
              "3                <NA>                <NA>                <NA>   \n",
              "4    26518.2336327363    26587.1383037195    27619.5060608184   \n",
              "\n",
              "  GDP per Capita 1996 GDP per Capita 1997 GDP per Capita 1998  ...  \\\n",
              "0                <NA>                <NA>                <NA>  ...   \n",
              "1    1633.55200001885    1464.29796254199    1603.64765027651  ...   \n",
              "2     3322.9553813945    3297.46603365919    3410.88254399624  ...   \n",
              "3                <NA>                <NA>                <NA>  ...   \n",
              "4    28871.2160741757    31140.6896808445    31800.3640667052  ...   \n",
              "\n",
              "  GDP per Capita 2014 GDP per Capita 2015 GDP per Capita 2016  \\\n",
              "0    575.146245808546    565.569730408751    563.872336723147   \n",
              "1    3855.76074409659    3952.80357364813    4090.37272829183   \n",
              "2    4634.10149183949    4685.05902729002    4768.73140080218   \n",
              "3    12203.0894714284    12727.4102651386    12665.2829921268   \n",
              "4    37300.6244183478    38654.9347203095    40085.0205971586   \n",
              "\n",
              "  GDP per Capita 2017 GDP per Capita 2018 GDP per Capita 2019  \\\n",
              "0    562.769574140988    553.125151688293    557.861533207459   \n",
              "1     4249.8200493985    4431.55559506989    4542.26866282892   \n",
              "2    4742.90075536604    4717.00358853556    4672.66408682198   \n",
              "3    11930.7771236826    12412.6024074562    12524.0160252283   \n",
              "4    39361.0622634329    39242.1448960772    39346.2750344286   \n",
              "\n",
              "  GDP per Capita 2020 GDP per Capita 2021 GDP per Capita 2022  \\\n",
              "0    527.834554499306    408.625855217403    377.665627080705   \n",
              "1    4417.04105105395    4858.05201500931     5154.8274975368   \n",
              "2    4363.68533766912    4456.74687641147    4544.46688059647   \n",
              "3     13194.274740128    13233.5784817341    13709.0974895473   \n",
              "4    34536.6499209948    36929.0191515162    39780.3966116268   \n",
              "\n",
              "  GDP per Capita 2023  \n",
              "0    379.707497269884  \n",
              "1    5419.63779125273  \n",
              "2    4660.40545686886  \n",
              "3                <NA>  \n",
              "4    40227.2335282714  \n",
              "\n",
              "[5 rows x 35 columns]"
            ]
          },
          "execution_count": 63,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "file_gdp = \"./datasets/GDP.csv\"\n",
        "df_gdp = pd.read_csv(file_gdp)\n",
        "print(\"GDP DataFrame columns:\", df_gdp.columns)\n",
        "if 'code' in df_gdp.columns:\n",
        "    df_gdp = df_gdp.drop(columns=['code'])\n",
        "df_gdp.rename(columns={\"entity\": \"Country\"}, inplace=True)\n",
        "df_gdp.replace(\"..\", pd.NA, inplace=True)\n",
        "df_gdp.head()\n",
        "\n",
        "\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 64,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 496
        },
        "id": "6JJrg4kVvocu",
        "outputId": "54895211-0d47-458b-a38e-350094d7f7f3"
      },
      "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>Country</th>\n",
              "      <th>Gini coefficient 1990</th>\n",
              "      <th>Gini coefficient 1991</th>\n",
              "      <th>Gini coefficient 1992</th>\n",
              "      <th>Gini coefficient 1993</th>\n",
              "      <th>Gini coefficient 1994</th>\n",
              "      <th>Gini coefficient 1995</th>\n",
              "      <th>Gini coefficient 1996</th>\n",
              "      <th>Gini coefficient 1997</th>\n",
              "      <th>Gini coefficient 1998</th>\n",
              "      <th>...</th>\n",
              "      <th>Gini coefficient 2014</th>\n",
              "      <th>Gini coefficient 2015</th>\n",
              "      <th>Gini coefficient 2016</th>\n",
              "      <th>Gini coefficient 2017</th>\n",
              "      <th>Gini coefficient 2018</th>\n",
              "      <th>Gini coefficient 2019</th>\n",
              "      <th>Gini coefficient 2020</th>\n",
              "      <th>Gini coefficient 2021</th>\n",
              "      <th>Gini coefficient 2022</th>\n",
              "      <th>Gini coefficient 2023</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Albania</td>\n",
              "      <td>0.270103</td>\n",
              "      <td>0.270103</td>\n",
              "      <td>0.270103</td>\n",
              "      <td>0.270103</td>\n",
              "      <td>0.270103</td>\n",
              "      <td>0.270103</td>\n",
              "      <td>0.270103</td>\n",
              "      <td>0.270103</td>\n",
              "      <td>0.270103</td>\n",
              "      <td>...</td>\n",
              "      <td>0.345989</td>\n",
              "      <td>0.327537</td>\n",
              "      <td>0.337363</td>\n",
              "      <td>0.330557</td>\n",
              "      <td>0.301483</td>\n",
              "      <td>0.301158</td>\n",
              "      <td>0.294196</td>\n",
              "      <td>0.294196</td>\n",
              "      <td>0.294196</td>\n",
              "      <td>0.294196</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Algeria</td>\n",
              "      <td>0.353301</td>\n",
              "      <td>0.353301</td>\n",
              "      <td>0.353301</td>\n",
              "      <td>0.353301</td>\n",
              "      <td>0.353301</td>\n",
              "      <td>0.353301</td>\n",
              "      <td>0.353301</td>\n",
              "      <td>0.353301</td>\n",
              "      <td>0.353301</td>\n",
              "      <td>...</td>\n",
              "      <td>0.276157</td>\n",
              "      <td>0.276157</td>\n",
              "      <td>0.276157</td>\n",
              "      <td>0.276157</td>\n",
              "      <td>0.276157</td>\n",
              "      <td>0.276157</td>\n",
              "      <td>0.276157</td>\n",
              "      <td>0.276157</td>\n",
              "      <td>0.276157</td>\n",
              "      <td>0.276157</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Angola</td>\n",
              "      <td>0.519447</td>\n",
              "      <td>0.519447</td>\n",
              "      <td>0.519447</td>\n",
              "      <td>0.519447</td>\n",
              "      <td>0.519447</td>\n",
              "      <td>0.519447</td>\n",
              "      <td>0.519447</td>\n",
              "      <td>0.519447</td>\n",
              "      <td>0.519447</td>\n",
              "      <td>...</td>\n",
              "      <td>0.427155</td>\n",
              "      <td>0.427155</td>\n",
              "      <td>0.427155</td>\n",
              "      <td>0.427155</td>\n",
              "      <td>0.512640</td>\n",
              "      <td>0.512640</td>\n",
              "      <td>0.512640</td>\n",
              "      <td>0.512640</td>\n",
              "      <td>0.512640</td>\n",
              "      <td>0.512640</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Argentina (urban)</td>\n",
              "      <td>0.467545</td>\n",
              "      <td>0.467545</td>\n",
              "      <td>0.454552</td>\n",
              "      <td>0.448434</td>\n",
              "      <td>0.458985</td>\n",
              "      <td>0.488787</td>\n",
              "      <td>0.494914</td>\n",
              "      <td>0.490859</td>\n",
              "      <td>0.507132</td>\n",
              "      <td>...</td>\n",
              "      <td>0.418225</td>\n",
              "      <td>0.418225</td>\n",
              "      <td>0.423450</td>\n",
              "      <td>0.414348</td>\n",
              "      <td>0.417190</td>\n",
              "      <td>0.433142</td>\n",
              "      <td>0.427438</td>\n",
              "      <td>0.424456</td>\n",
              "      <td>0.407365</td>\n",
              "      <td>0.407365</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Armenia</td>\n",
              "      <td>0.362197</td>\n",
              "      <td>0.362197</td>\n",
              "      <td>0.362197</td>\n",
              "      <td>0.362197</td>\n",
              "      <td>0.362197</td>\n",
              "      <td>0.362197</td>\n",
              "      <td>0.362197</td>\n",
              "      <td>0.362197</td>\n",
              "      <td>0.362197</td>\n",
              "      <td>...</td>\n",
              "      <td>0.314833</td>\n",
              "      <td>0.323568</td>\n",
              "      <td>0.325479</td>\n",
              "      <td>0.336218</td>\n",
              "      <td>0.344335</td>\n",
              "      <td>0.300312</td>\n",
              "      <td>0.251316</td>\n",
              "      <td>0.279401</td>\n",
              "      <td>0.279453</td>\n",
              "      <td>0.279453</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",
              "      <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>175</th>\n",
              "      <td>Venezuela</td>\n",
              "      <td>0.420618</td>\n",
              "      <td>0.420618</td>\n",
              "      <td>0.420618</td>\n",
              "      <td>0.420618</td>\n",
              "      <td>0.420618</td>\n",
              "      <td>0.471673</td>\n",
              "      <td>0.471673</td>\n",
              "      <td>0.471673</td>\n",
              "      <td>0.479997</td>\n",
              "      <td>...</td>\n",
              "      <td>0.446993</td>\n",
              "      <td>0.446993</td>\n",
              "      <td>0.446993</td>\n",
              "      <td>0.446993</td>\n",
              "      <td>0.446993</td>\n",
              "      <td>0.446993</td>\n",
              "      <td>0.446993</td>\n",
              "      <td>0.446993</td>\n",
              "      <td>0.446993</td>\n",
              "      <td>0.446993</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>176</th>\n",
              "      <td>Vietnam</td>\n",
              "      <td>0.356540</td>\n",
              "      <td>0.356540</td>\n",
              "      <td>0.356540</td>\n",
              "      <td>0.356540</td>\n",
              "      <td>0.356540</td>\n",
              "      <td>0.356540</td>\n",
              "      <td>0.356540</td>\n",
              "      <td>0.354422</td>\n",
              "      <td>0.354422</td>\n",
              "      <td>...</td>\n",
              "      <td>0.347554</td>\n",
              "      <td>0.347554</td>\n",
              "      <td>0.352667</td>\n",
              "      <td>0.352667</td>\n",
              "      <td>0.357155</td>\n",
              "      <td>0.357155</td>\n",
              "      <td>0.367902</td>\n",
              "      <td>0.367902</td>\n",
              "      <td>0.360930</td>\n",
              "      <td>0.360930</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>177</th>\n",
              "      <td>Yemen</td>\n",
              "      <td>0.349978</td>\n",
              "      <td>0.349978</td>\n",
              "      <td>0.349978</td>\n",
              "      <td>0.349978</td>\n",
              "      <td>0.349978</td>\n",
              "      <td>0.349978</td>\n",
              "      <td>0.349978</td>\n",
              "      <td>0.349978</td>\n",
              "      <td>0.349978</td>\n",
              "      <td>...</td>\n",
              "      <td>0.367071</td>\n",
              "      <td>0.367071</td>\n",
              "      <td>0.367071</td>\n",
              "      <td>0.367071</td>\n",
              "      <td>0.367071</td>\n",
              "      <td>0.367071</td>\n",
              "      <td>0.367071</td>\n",
              "      <td>0.367071</td>\n",
              "      <td>0.367071</td>\n",
              "      <td>0.367071</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>178</th>\n",
              "      <td>Zambia</td>\n",
              "      <td>0.594029</td>\n",
              "      <td>0.594029</td>\n",
              "      <td>0.594029</td>\n",
              "      <td>0.525501</td>\n",
              "      <td>0.525501</td>\n",
              "      <td>0.525501</td>\n",
              "      <td>0.483284</td>\n",
              "      <td>0.483284</td>\n",
              "      <td>0.491221</td>\n",
              "      <td>...</td>\n",
              "      <td>0.520111</td>\n",
              "      <td>0.558376</td>\n",
              "      <td>0.558376</td>\n",
              "      <td>0.558376</td>\n",
              "      <td>0.558376</td>\n",
              "      <td>0.558376</td>\n",
              "      <td>0.558376</td>\n",
              "      <td>0.558376</td>\n",
              "      <td>0.514831</td>\n",
              "      <td>0.514831</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>179</th>\n",
              "      <td>Zimbabwe</td>\n",
              "      <td>0.431536</td>\n",
              "      <td>0.431536</td>\n",
              "      <td>0.431536</td>\n",
              "      <td>0.431536</td>\n",
              "      <td>0.431536</td>\n",
              "      <td>0.431536</td>\n",
              "      <td>0.431536</td>\n",
              "      <td>0.431536</td>\n",
              "      <td>0.431536</td>\n",
              "      <td>...</td>\n",
              "      <td>0.431536</td>\n",
              "      <td>0.431536</td>\n",
              "      <td>0.431536</td>\n",
              "      <td>0.443371</td>\n",
              "      <td>0.443371</td>\n",
              "      <td>0.502564</td>\n",
              "      <td>0.502564</td>\n",
              "      <td>0.502564</td>\n",
              "      <td>0.502564</td>\n",
              "      <td>0.502564</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>180 rows × 35 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "               Country  Gini coefficient 1990  Gini coefficient 1991  \\\n",
              "0              Albania               0.270103               0.270103   \n",
              "1              Algeria               0.353301               0.353301   \n",
              "2               Angola               0.519447               0.519447   \n",
              "3    Argentina (urban)               0.467545               0.467545   \n",
              "4              Armenia               0.362197               0.362197   \n",
              "..                 ...                    ...                    ...   \n",
              "175          Venezuela               0.420618               0.420618   \n",
              "176            Vietnam               0.356540               0.356540   \n",
              "177              Yemen               0.349978               0.349978   \n",
              "178             Zambia               0.594029               0.594029   \n",
              "179           Zimbabwe               0.431536               0.431536   \n",
              "\n",
              "     Gini coefficient 1992  Gini coefficient 1993  Gini coefficient 1994  \\\n",
              "0                 0.270103               0.270103               0.270103   \n",
              "1                 0.353301               0.353301               0.353301   \n",
              "2                 0.519447               0.519447               0.519447   \n",
              "3                 0.454552               0.448434               0.458985   \n",
              "4                 0.362197               0.362197               0.362197   \n",
              "..                     ...                    ...                    ...   \n",
              "175               0.420618               0.420618               0.420618   \n",
              "176               0.356540               0.356540               0.356540   \n",
              "177               0.349978               0.349978               0.349978   \n",
              "178               0.594029               0.525501               0.525501   \n",
              "179               0.431536               0.431536               0.431536   \n",
              "\n",
              "     Gini coefficient 1995  Gini coefficient 1996  Gini coefficient 1997  \\\n",
              "0                 0.270103               0.270103               0.270103   \n",
              "1                 0.353301               0.353301               0.353301   \n",
              "2                 0.519447               0.519447               0.519447   \n",
              "3                 0.488787               0.494914               0.490859   \n",
              "4                 0.362197               0.362197               0.362197   \n",
              "..                     ...                    ...                    ...   \n",
              "175               0.471673               0.471673               0.471673   \n",
              "176               0.356540               0.356540               0.354422   \n",
              "177               0.349978               0.349978               0.349978   \n",
              "178               0.525501               0.483284               0.483284   \n",
              "179               0.431536               0.431536               0.431536   \n",
              "\n",
              "     Gini coefficient 1998  ...  Gini coefficient 2014  Gini coefficient 2015  \\\n",
              "0                 0.270103  ...               0.345989               0.327537   \n",
              "1                 0.353301  ...               0.276157               0.276157   \n",
              "2                 0.519447  ...               0.427155               0.427155   \n",
              "3                 0.507132  ...               0.418225               0.418225   \n",
              "4                 0.362197  ...               0.314833               0.323568   \n",
              "..                     ...  ...                    ...                    ...   \n",
              "175               0.479997  ...               0.446993               0.446993   \n",
              "176               0.354422  ...               0.347554               0.347554   \n",
              "177               0.349978  ...               0.367071               0.367071   \n",
              "178               0.491221  ...               0.520111               0.558376   \n",
              "179               0.431536  ...               0.431536               0.431536   \n",
              "\n",
              "     Gini coefficient 2016  Gini coefficient 2017  Gini coefficient 2018  \\\n",
              "0                 0.337363               0.330557               0.301483   \n",
              "1                 0.276157               0.276157               0.276157   \n",
              "2                 0.427155               0.427155               0.512640   \n",
              "3                 0.423450               0.414348               0.417190   \n",
              "4                 0.325479               0.336218               0.344335   \n",
              "..                     ...                    ...                    ...   \n",
              "175               0.446993               0.446993               0.446993   \n",
              "176               0.352667               0.352667               0.357155   \n",
              "177               0.367071               0.367071               0.367071   \n",
              "178               0.558376               0.558376               0.558376   \n",
              "179               0.431536               0.443371               0.443371   \n",
              "\n",
              "     Gini coefficient 2019  Gini coefficient 2020  Gini coefficient 2021  \\\n",
              "0                 0.301158               0.294196               0.294196   \n",
              "1                 0.276157               0.276157               0.276157   \n",
              "2                 0.512640               0.512640               0.512640   \n",
              "3                 0.433142               0.427438               0.424456   \n",
              "4                 0.300312               0.251316               0.279401   \n",
              "..                     ...                    ...                    ...   \n",
              "175               0.446993               0.446993               0.446993   \n",
              "176               0.357155               0.367902               0.367902   \n",
              "177               0.367071               0.367071               0.367071   \n",
              "178               0.558376               0.558376               0.558376   \n",
              "179               0.502564               0.502564               0.502564   \n",
              "\n",
              "     Gini coefficient 2022  Gini coefficient 2023  \n",
              "0                 0.294196               0.294196  \n",
              "1                 0.276157               0.276157  \n",
              "2                 0.512640               0.512640  \n",
              "3                 0.407365               0.407365  \n",
              "4                 0.279453               0.279453  \n",
              "..                     ...                    ...  \n",
              "175               0.446993               0.446993  \n",
              "176               0.360930               0.360930  \n",
              "177               0.367071               0.367071  \n",
              "178               0.514831               0.514831  \n",
              "179               0.502564               0.502564  \n",
              "\n",
              "[180 rows x 35 columns]"
            ]
          },
          "execution_count": 64,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "file_gini = \"./datasets/Gini.csv\"\n",
        "df_gini=pd.read_csv(file_gini)\n",
        "df_gini = df_gini.drop(columns=[\"Code\"])\n",
        "df_gini.rename(columns={\"Entity\": \"Country\"}, inplace=True)\n",
        "df_gini"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 65,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 325
        },
        "id": "guc9nJuJzUCs",
        "outputId": "53d4f8fc-b960-477d-ad35-9ae256aa4083"
      },
      "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>Country</th>\n",
              "      <th>Human Development Index (1990)</th>\n",
              "      <th>Human Development Index (1991)</th>\n",
              "      <th>Human Development Index (1992)</th>\n",
              "      <th>Human Development Index (1993)</th>\n",
              "      <th>Human Development Index (1994)</th>\n",
              "      <th>Human Development Index (1995)</th>\n",
              "      <th>Human Development Index (1996)</th>\n",
              "      <th>Human Development Index (1997)</th>\n",
              "      <th>Human Development Index (1998)</th>\n",
              "      <th>...</th>\n",
              "      <th>Mean Years of Schooling (2012)</th>\n",
              "      <th>Mean Years of Schooling (2013)</th>\n",
              "      <th>Mean Years of Schooling (2014)</th>\n",
              "      <th>Mean Years of Schooling (2015)</th>\n",
              "      <th>Mean Years of Schooling (2016)</th>\n",
              "      <th>Mean Years of Schooling (2017)</th>\n",
              "      <th>Mean Years of Schooling (2018)</th>\n",
              "      <th>Mean Years of Schooling (2019)</th>\n",
              "      <th>Mean Years of Schooling (2020)</th>\n",
              "      <th>Mean Years of Schooling (2021)</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Afghanistan</td>\n",
              "      <td>0.273</td>\n",
              "      <td>0.279</td>\n",
              "      <td>0.287</td>\n",
              "      <td>0.297</td>\n",
              "      <td>0.292</td>\n",
              "      <td>0.310</td>\n",
              "      <td>0.319</td>\n",
              "      <td>0.323</td>\n",
              "      <td>0.324</td>\n",
              "      <td>...</td>\n",
              "      <td>2.209473</td>\n",
              "      <td>2.261614</td>\n",
              "      <td>2.313755</td>\n",
              "      <td>2.365896</td>\n",
              "      <td>2.463660</td>\n",
              "      <td>2.561425</td>\n",
              "      <td>2.659189</td>\n",
              "      <td>2.756953</td>\n",
              "      <td>2.854718</td>\n",
              "      <td>2.985070</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Angola</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>3.909642</td>\n",
              "      <td>3.950166</td>\n",
              "      <td>3.990690</td>\n",
              "      <td>4.704040</td>\n",
              "      <td>5.417391</td>\n",
              "      <td>5.417391</td>\n",
              "      <td>5.417391</td>\n",
              "      <td>5.417391</td>\n",
              "      <td>5.417391</td>\n",
              "      <td>5.417391</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Albania</td>\n",
              "      <td>0.647</td>\n",
              "      <td>0.629</td>\n",
              "      <td>0.614</td>\n",
              "      <td>0.617</td>\n",
              "      <td>0.624</td>\n",
              "      <td>0.634</td>\n",
              "      <td>0.645</td>\n",
              "      <td>0.642</td>\n",
              "      <td>0.657</td>\n",
              "      <td>...</td>\n",
              "      <td>10.025110</td>\n",
              "      <td>10.196281</td>\n",
              "      <td>10.370374</td>\n",
              "      <td>10.547439</td>\n",
              "      <td>10.727528</td>\n",
              "      <td>10.910692</td>\n",
              "      <td>11.096983</td>\n",
              "      <td>11.286455</td>\n",
              "      <td>11.286455</td>\n",
              "      <td>11.286455</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Andorra</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>...</td>\n",
              "      <td>10.587085</td>\n",
              "      <td>10.616062</td>\n",
              "      <td>10.645040</td>\n",
              "      <td>10.573280</td>\n",
              "      <td>10.556100</td>\n",
              "      <td>10.555773</td>\n",
              "      <td>10.555446</td>\n",
              "      <td>10.555120</td>\n",
              "      <td>10.555120</td>\n",
              "      <td>10.555120</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>United Arab Emirates</td>\n",
              "      <td>0.728</td>\n",
              "      <td>0.739</td>\n",
              "      <td>0.742</td>\n",
              "      <td>0.748</td>\n",
              "      <td>0.755</td>\n",
              "      <td>0.762</td>\n",
              "      <td>0.767</td>\n",
              "      <td>0.773</td>\n",
              "      <td>0.779</td>\n",
              "      <td>...</td>\n",
              "      <td>10.169965</td>\n",
              "      <td>10.338129</td>\n",
              "      <td>10.506293</td>\n",
              "      <td>10.674456</td>\n",
              "      <td>10.842620</td>\n",
              "      <td>12.055400</td>\n",
              "      <td>12.484000</td>\n",
              "      <td>12.694030</td>\n",
              "      <td>12.694030</td>\n",
              "      <td>12.694030</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 97 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                Country  Human Development Index (1990)  \\\n",
              "0           Afghanistan                           0.273   \n",
              "1                Angola                             NaN   \n",
              "2               Albania                           0.647   \n",
              "3               Andorra                             NaN   \n",
              "4  United Arab Emirates                           0.728   \n",
              "\n",
              "   Human Development Index (1991)  Human Development Index (1992)  \\\n",
              "0                           0.279                           0.287   \n",
              "1                             NaN                             NaN   \n",
              "2                           0.629                           0.614   \n",
              "3                             NaN                             NaN   \n",
              "4                           0.739                           0.742   \n",
              "\n",
              "   Human Development Index (1993)  Human Development Index (1994)  \\\n",
              "0                           0.297                           0.292   \n",
              "1                             NaN                             NaN   \n",
              "2                           0.617                           0.624   \n",
              "3                             NaN                             NaN   \n",
              "4                           0.748                           0.755   \n",
              "\n",
              "   Human Development Index (1995)  Human Development Index (1996)  \\\n",
              "0                           0.310                           0.319   \n",
              "1                             NaN                             NaN   \n",
              "2                           0.634                           0.645   \n",
              "3                             NaN                             NaN   \n",
              "4                           0.762                           0.767   \n",
              "\n",
              "   Human Development Index (1997)  Human Development Index (1998)  ...  \\\n",
              "0                           0.323                           0.324  ...   \n",
              "1                             NaN                             NaN  ...   \n",
              "2                           0.642                           0.657  ...   \n",
              "3                             NaN                             NaN  ...   \n",
              "4                           0.773                           0.779  ...   \n",
              "\n",
              "   Mean Years of Schooling (2012)  Mean Years of Schooling (2013)  \\\n",
              "0                        2.209473                        2.261614   \n",
              "1                        3.909642                        3.950166   \n",
              "2                       10.025110                       10.196281   \n",
              "3                       10.587085                       10.616062   \n",
              "4                       10.169965                       10.338129   \n",
              "\n",
              "   Mean Years of Schooling (2014)  Mean Years of Schooling (2015)  \\\n",
              "0                        2.313755                        2.365896   \n",
              "1                        3.990690                        4.704040   \n",
              "2                       10.370374                       10.547439   \n",
              "3                       10.645040                       10.573280   \n",
              "4                       10.506293                       10.674456   \n",
              "\n",
              "   Mean Years of Schooling (2016)  Mean Years of Schooling (2017)  \\\n",
              "0                        2.463660                        2.561425   \n",
              "1                        5.417391                        5.417391   \n",
              "2                       10.727528                       10.910692   \n",
              "3                       10.556100                       10.555773   \n",
              "4                       10.842620                       12.055400   \n",
              "\n",
              "   Mean Years of Schooling (2018)  Mean Years of Schooling (2019)  \\\n",
              "0                        2.659189                        2.756953   \n",
              "1                        5.417391                        5.417391   \n",
              "2                       11.096983                       11.286455   \n",
              "3                       10.555446                       10.555120   \n",
              "4                       12.484000                       12.694030   \n",
              "\n",
              "   Mean Years of Schooling (2020)  Mean Years of Schooling (2021)  \n",
              "0                        2.854718                        2.985070  \n",
              "1                        5.417391                        5.417391  \n",
              "2                       11.286455                       11.286455  \n",
              "3                       10.555120                       10.555120  \n",
              "4                       12.694030                       12.694030  \n",
              "\n",
              "[5 rows x 97 columns]"
            ]
          },
          "execution_count": 65,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "file_hdi = \"./datasets/HDI.csv\"\n",
        "df_hdi = pd.read_csv(file_hdi)\n",
        "df_hdi.replace(\"NaN\", pd.NA, inplace=True)\n",
        "df_hdi.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 66,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 224
        },
        "id": "2oSCwMLizhb1",
        "outputId": "95d43cae-a139-492a-fa6b-63d6e6335eeb"
      },
      "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>Country</th>\n",
              "      <th>Average Power Line</th>\n",
              "      <th>Average Schools</th>\n",
              "      <th>Average Supermarkets</th>\n",
              "      <th>Average Public Roads</th>\n",
              "      <th>Average Hospitals</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Ukraine</td>\n",
              "      <td>2.0</td>\n",
              "      <td>0.4</td>\n",
              "      <td>1.2</td>\n",
              "      <td>31.4</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>UAE</td>\n",
              "      <td>1.8</td>\n",
              "      <td>5.4</td>\n",
              "      <td>4.8</td>\n",
              "      <td>44.8</td>\n",
              "      <td>0.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Argentina</td>\n",
              "      <td>2.0</td>\n",
              "      <td>10.0</td>\n",
              "      <td>9.0</td>\n",
              "      <td>8.6</td>\n",
              "      <td>3.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Austria</td>\n",
              "      <td>3.4</td>\n",
              "      <td>15.6</td>\n",
              "      <td>10.2</td>\n",
              "      <td>45.0</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Australia</td>\n",
              "      <td>8.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>10.8</td>\n",
              "      <td>69.8</td>\n",
              "      <td>1.8</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "     Country  Average Power Line  Average Schools  Average Supermarkets  \\\n",
              "0    Ukraine                 2.0              0.4                   1.2   \n",
              "1        UAE                 1.8              5.4                   4.8   \n",
              "2  Argentina                 2.0             10.0                   9.0   \n",
              "3    Austria                 3.4             15.6                  10.2   \n",
              "4  Australia                 8.0             16.0                  10.8   \n",
              "\n",
              "   Average Public Roads  Average Hospitals  \n",
              "0                  31.4                1.0  \n",
              "1                  44.8                0.6  \n",
              "2                   8.6                3.6  \n",
              "3                  45.0                1.0  \n",
              "4                  69.8                1.8  "
            ]
          },
          "execution_count": 66,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "file_infra = \"./datasets/Infrastructure.csv\"\n",
        "df_infra = pd.read_csv(file_infra)\n",
        "df_infra.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 67,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 342
        },
        "id": "snjX-wBC1G6v",
        "outputId": "f7605241-a485-401a-94e8-94180b3dc31c"
      },
      "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>Country</th>\n",
              "      <th>Internet Usage (% of Population) 1990</th>\n",
              "      <th>Internet Usage (% of Population) 1991</th>\n",
              "      <th>Internet Usage (% of Population) 1992</th>\n",
              "      <th>Internet Usage (% of Population) 1993</th>\n",
              "      <th>Internet Usage (% of Population) 1994</th>\n",
              "      <th>Internet Usage (% of Population) 1995</th>\n",
              "      <th>Internet Usage (% of Population) 1996</th>\n",
              "      <th>Internet Usage (% of Population) 1997</th>\n",
              "      <th>Internet Usage (% of Population) 1998</th>\n",
              "      <th>...</th>\n",
              "      <th>Internet Usage (% of Population) 2014</th>\n",
              "      <th>Internet Usage (% of Population) 2015</th>\n",
              "      <th>Internet Usage (% of Population) 2016</th>\n",
              "      <th>Internet Usage (% of Population) 2017</th>\n",
              "      <th>Internet Usage (% of Population) 2018</th>\n",
              "      <th>Internet Usage (% of Population) 2019</th>\n",
              "      <th>Internet Usage (% of Population) 2020</th>\n",
              "      <th>Internet Usage (% of Population) 2021</th>\n",
              "      <th>Internet Usage (% of Population) 2022</th>\n",
              "      <th>Internet Usage (% of Population) 2023</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Afghanistan</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>...</td>\n",
              "      <td>7</td>\n",
              "      <td>8.26</td>\n",
              "      <td>11</td>\n",
              "      <td>13.5</td>\n",
              "      <td>16.8</td>\n",
              "      <td>17.6</td>\n",
              "      <td>18.4</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Albania</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.011168695</td>\n",
              "      <td>0.032196828</td>\n",
              "      <td>0.048593919</td>\n",
              "      <td>0.06502737</td>\n",
              "      <td>...</td>\n",
              "      <td>54.3</td>\n",
              "      <td>56.9</td>\n",
              "      <td>59.6</td>\n",
              "      <td>62.4</td>\n",
              "      <td>65.4</td>\n",
              "      <td>68.5504</td>\n",
              "      <td>72.2377</td>\n",
              "      <td>79.3237</td>\n",
              "      <td>82.6137</td>\n",
              "      <td>83.1356</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Algeria</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.000360674</td>\n",
              "      <td>0.001768954</td>\n",
              "      <td>0.001738533</td>\n",
              "      <td>0.010268463</td>\n",
              "      <td>0.020238555</td>\n",
              "      <td>...</td>\n",
              "      <td>29.5</td>\n",
              "      <td>38.2</td>\n",
              "      <td>42.9455</td>\n",
              "      <td>47.6911</td>\n",
              "      <td>49.0385</td>\n",
              "      <td>58.9776</td>\n",
              "      <td>60.6534</td>\n",
              "      <td>66.2356</td>\n",
              "      <td>71.2432</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>American Samoa</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>...</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Andorra</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1.526601023</td>\n",
              "      <td>3.050175385</td>\n",
              "      <td>6.886209218</td>\n",
              "      <td>...</td>\n",
              "      <td>86.1</td>\n",
              "      <td>87.9</td>\n",
              "      <td>89.7</td>\n",
              "      <td>91.5675</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "      <td>90.7187</td>\n",
              "      <td>93.2056</td>\n",
              "      <td>93.8975</td>\n",
              "      <td>94.4855</td>\n",
              "      <td>&lt;NA&gt;</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 35 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "          Country Internet Usage (% of Population) 1990  \\\n",
              "0     Afghanistan                                     0   \n",
              "1         Albania                                     0   \n",
              "2         Algeria                                     0   \n",
              "3  American Samoa                                     0   \n",
              "4         Andorra                                     0   \n",
              "\n",
              "  Internet Usage (% of Population) 1991 Internet Usage (% of Population) 1992  \\\n",
              "0                                     0                                     0   \n",
              "1                                     0                                     0   \n",
              "2                                     0                                     0   \n",
              "3                                     0                                     0   \n",
              "4                                     0                                     0   \n",
              "\n",
              "  Internet Usage (% of Population) 1993 Internet Usage (% of Population) 1994  \\\n",
              "0                                     0                                     0   \n",
              "1                                     0                                     0   \n",
              "2                                     0                           0.000360674   \n",
              "3                                     0                                     0   \n",
              "4                                     0                                     0   \n",
              "\n",
              "  Internet Usage (% of Population) 1995 Internet Usage (% of Population) 1996  \\\n",
              "0                                     0                                  <NA>   \n",
              "1                           0.011168695                           0.032196828   \n",
              "2                           0.001768954                           0.001738533   \n",
              "3                                     0                                  <NA>   \n",
              "4                                     0                           1.526601023   \n",
              "\n",
              "  Internet Usage (% of Population) 1997 Internet Usage (% of Population) 1998  \\\n",
              "0                                  <NA>                                  <NA>   \n",
              "1                           0.048593919                            0.06502737   \n",
              "2                           0.010268463                           0.020238555   \n",
              "3                                  <NA>                                  <NA>   \n",
              "4                           3.050175385                           6.886209218   \n",
              "\n",
              "   ... Internet Usage (% of Population) 2014  \\\n",
              "0  ...                                     7   \n",
              "1  ...                                  54.3   \n",
              "2  ...                                  29.5   \n",
              "3  ...                                  <NA>   \n",
              "4  ...                                  86.1   \n",
              "\n",
              "  Internet Usage (% of Population) 2015 Internet Usage (% of Population) 2016  \\\n",
              "0                                  8.26                                    11   \n",
              "1                                  56.9                                  59.6   \n",
              "2                                  38.2                               42.9455   \n",
              "3                                  <NA>                                  <NA>   \n",
              "4                                  87.9                                  89.7   \n",
              "\n",
              "  Internet Usage (% of Population) 2017 Internet Usage (% of Population) 2018  \\\n",
              "0                                  13.5                                  16.8   \n",
              "1                                  62.4                                  65.4   \n",
              "2                               47.6911                               49.0385   \n",
              "3                                  <NA>                                  <NA>   \n",
              "4                               91.5675                                  <NA>   \n",
              "\n",
              "  Internet Usage (% of Population) 2019 Internet Usage (% of Population) 2020  \\\n",
              "0                                  17.6                                  18.4   \n",
              "1                               68.5504                               72.2377   \n",
              "2                               58.9776                               60.6534   \n",
              "3                                  <NA>                                  <NA>   \n",
              "4                               90.7187                               93.2056   \n",
              "\n",
              "  Internet Usage (% of Population) 2021 Internet Usage (% of Population) 2022  \\\n",
              "0                                  <NA>                                  <NA>   \n",
              "1                               79.3237                               82.6137   \n",
              "2                               66.2356                               71.2432   \n",
              "3                                  <NA>                                  <NA>   \n",
              "4                               93.8975                               94.4855   \n",
              "\n",
              "  Internet Usage (% of Population) 2023  \n",
              "0                                  <NA>  \n",
              "1                               83.1356  \n",
              "2                                  <NA>  \n",
              "3                                  <NA>  \n",
              "4                                  <NA>  \n",
              "\n",
              "[5 rows x 35 columns]"
            ]
          },
          "execution_count": 67,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "file_net = \"./datasets/Internet.csv\"\n",
        "df_net = pd.read_csv(file_net)\n",
        "df_net = df_net.drop(columns=[\"code\"])\n",
        "df_net.rename(columns={\"entity\": \"Country\"}, inplace=True)\n",
        "df_net.replace(\"..\", pd.NA, inplace=True)\n",
        "df_net.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 68,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 496
        },
        "id": "5jcVxuDPzpvo",
        "outputId": "99708f0c-aea5-479b-a110-6ddbefd6cf00"
      },
      "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>Country</th>\n",
              "      <th>Literacy rate 1990</th>\n",
              "      <th>Literacy rate 1991</th>\n",
              "      <th>Literacy rate 1992</th>\n",
              "      <th>Literacy rate 1993</th>\n",
              "      <th>Literacy rate 1994</th>\n",
              "      <th>Literacy rate 1995</th>\n",
              "      <th>Literacy rate 1996</th>\n",
              "      <th>Literacy rate 1997</th>\n",
              "      <th>Literacy rate 1998</th>\n",
              "      <th>...</th>\n",
              "      <th>Literacy rate 2014</th>\n",
              "      <th>Literacy rate 2015</th>\n",
              "      <th>Literacy rate 2016</th>\n",
              "      <th>Literacy rate 2017</th>\n",
              "      <th>Literacy rate 2018</th>\n",
              "      <th>Literacy rate 2019</th>\n",
              "      <th>Literacy rate 2020</th>\n",
              "      <th>Literacy rate 2021</th>\n",
              "      <th>Literacy rate 2022</th>\n",
              "      <th>Literacy rate 2023</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Afghanistan</td>\n",
              "      <td>31.00000</td>\n",
              "      <td>31.00000</td>\n",
              "      <td>31.00000</td>\n",
              "      <td>31.00000</td>\n",
              "      <td>31.00000</td>\n",
              "      <td>31.00000</td>\n",
              "      <td>31.00000</td>\n",
              "      <td>31.00000</td>\n",
              "      <td>31.00000</td>\n",
              "      <td>...</td>\n",
              "      <td>31.00000</td>\n",
              "      <td>33.75384</td>\n",
              "      <td>33.75384</td>\n",
              "      <td>33.75384</td>\n",
              "      <td>33.75384</td>\n",
              "      <td>33.75384</td>\n",
              "      <td>33.75384</td>\n",
              "      <td>37.00000</td>\n",
              "      <td>37.00000</td>\n",
              "      <td>37.00000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Albania</td>\n",
              "      <td>99.00000</td>\n",
              "      <td>99.00000</td>\n",
              "      <td>99.00000</td>\n",
              "      <td>99.00000</td>\n",
              "      <td>99.00000</td>\n",
              "      <td>99.00000</td>\n",
              "      <td>99.00000</td>\n",
              "      <td>99.00000</td>\n",
              "      <td>99.00000</td>\n",
              "      <td>...</td>\n",
              "      <td>97.00000</td>\n",
              "      <td>97.55390</td>\n",
              "      <td>97.55390</td>\n",
              "      <td>98.81623</td>\n",
              "      <td>98.81623</td>\n",
              "      <td>98.81623</td>\n",
              "      <td>98.81623</td>\n",
              "      <td>98.81623</td>\n",
              "      <td>98.50000</td>\n",
              "      <td>98.50000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Algeria</td>\n",
              "      <td>70.00000</td>\n",
              "      <td>70.00000</td>\n",
              "      <td>70.00000</td>\n",
              "      <td>70.00000</td>\n",
              "      <td>70.00000</td>\n",
              "      <td>70.00000</td>\n",
              "      <td>70.00000</td>\n",
              "      <td>70.00000</td>\n",
              "      <td>70.00000</td>\n",
              "      <td>...</td>\n",
              "      <td>75.00000</td>\n",
              "      <td>79.60840</td>\n",
              "      <td>79.60840</td>\n",
              "      <td>79.60840</td>\n",
              "      <td>81.40784</td>\n",
              "      <td>81.40784</td>\n",
              "      <td>81.40784</td>\n",
              "      <td>81.40784</td>\n",
              "      <td>81.40784</td>\n",
              "      <td>81.40784</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Andorra</td>\n",
              "      <td>100.00000</td>\n",
              "      <td>100.00000</td>\n",
              "      <td>100.00000</td>\n",
              "      <td>100.00000</td>\n",
              "      <td>100.00000</td>\n",
              "      <td>100.00000</td>\n",
              "      <td>100.00000</td>\n",
              "      <td>100.00000</td>\n",
              "      <td>100.00000</td>\n",
              "      <td>...</td>\n",
              "      <td>100.00000</td>\n",
              "      <td>100.00000</td>\n",
              "      <td>100.00000</td>\n",
              "      <td>100.00000</td>\n",
              "      <td>100.00000</td>\n",
              "      <td>100.00000</td>\n",
              "      <td>100.00000</td>\n",
              "      <td>100.00000</td>\n",
              "      <td>100.00000</td>\n",
              "      <td>100.00000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Angola</td>\n",
              "      <td>67.00000</td>\n",
              "      <td>67.00000</td>\n",
              "      <td>67.00000</td>\n",
              "      <td>67.00000</td>\n",
              "      <td>67.00000</td>\n",
              "      <td>67.00000</td>\n",
              "      <td>67.00000</td>\n",
              "      <td>67.00000</td>\n",
              "      <td>67.00000</td>\n",
              "      <td>...</td>\n",
              "      <td>66.00000</td>\n",
              "      <td>66.23586</td>\n",
              "      <td>66.23586</td>\n",
              "      <td>66.23586</td>\n",
              "      <td>66.23586</td>\n",
              "      <td>66.23586</td>\n",
              "      <td>66.23586</td>\n",
              "      <td>66.23586</td>\n",
              "      <td>72.40000</td>\n",
              "      <td>72.40000</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",
              "      <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>255</th>\n",
              "      <td>Western and Central Africa (WB)</td>\n",
              "      <td>43.57052</td>\n",
              "      <td>44.36271</td>\n",
              "      <td>45.13663</td>\n",
              "      <td>45.95827</td>\n",
              "      <td>46.83009</td>\n",
              "      <td>47.00222</td>\n",
              "      <td>47.86489</td>\n",
              "      <td>48.86634</td>\n",
              "      <td>50.23897</td>\n",
              "      <td>...</td>\n",
              "      <td>54.14114</td>\n",
              "      <td>55.00662</td>\n",
              "      <td>55.46578</td>\n",
              "      <td>56.47220</td>\n",
              "      <td>59.74735</td>\n",
              "      <td>59.55367</td>\n",
              "      <td>59.70324</td>\n",
              "      <td>60.00732</td>\n",
              "      <td>60.29085</td>\n",
              "      <td>60.50555</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>256</th>\n",
              "      <td>World</td>\n",
              "      <td>74.90692</td>\n",
              "      <td>75.28641</td>\n",
              "      <td>75.69422</td>\n",
              "      <td>76.10236</td>\n",
              "      <td>76.50139</td>\n",
              "      <td>76.91177</td>\n",
              "      <td>77.29624</td>\n",
              "      <td>79.28838</td>\n",
              "      <td>80.46865</td>\n",
              "      <td>...</td>\n",
              "      <td>85.28639</td>\n",
              "      <td>85.67888</td>\n",
              "      <td>86.00011</td>\n",
              "      <td>86.17700</td>\n",
              "      <td>86.43748</td>\n",
              "      <td>86.54791</td>\n",
              "      <td>86.74745</td>\n",
              "      <td>86.92751</td>\n",
              "      <td>87.15533</td>\n",
              "      <td>87.35600</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>257</th>\n",
              "      <td>Yemen</td>\n",
              "      <td>37.00000</td>\n",
              "      <td>37.00000</td>\n",
              "      <td>37.00000</td>\n",
              "      <td>37.00000</td>\n",
              "      <td>37.00000</td>\n",
              "      <td>37.00000</td>\n",
              "      <td>37.00000</td>\n",
              "      <td>37.00000</td>\n",
              "      <td>37.00000</td>\n",
              "      <td>...</td>\n",
              "      <td>68.78942</td>\n",
              "      <td>69.96195</td>\n",
              "      <td>69.96195</td>\n",
              "      <td>69.96195</td>\n",
              "      <td>69.96195</td>\n",
              "      <td>69.96195</td>\n",
              "      <td>69.96195</td>\n",
              "      <td>69.96195</td>\n",
              "      <td>69.96195</td>\n",
              "      <td>69.96195</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>258</th>\n",
              "      <td>Zambia</td>\n",
              "      <td>65.00000</td>\n",
              "      <td>65.00000</td>\n",
              "      <td>65.00000</td>\n",
              "      <td>65.00000</td>\n",
              "      <td>65.00000</td>\n",
              "      <td>65.00000</td>\n",
              "      <td>65.00000</td>\n",
              "      <td>65.00000</td>\n",
              "      <td>65.00000</td>\n",
              "      <td>...</td>\n",
              "      <td>83.00000</td>\n",
              "      <td>85.11726</td>\n",
              "      <td>85.11726</td>\n",
              "      <td>85.11726</td>\n",
              "      <td>71.13230</td>\n",
              "      <td>71.13230</td>\n",
              "      <td>87.50000</td>\n",
              "      <td>87.50000</td>\n",
              "      <td>87.50000</td>\n",
              "      <td>87.50000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>259</th>\n",
              "      <td>Zimbabwe</td>\n",
              "      <td>84.00000</td>\n",
              "      <td>84.00000</td>\n",
              "      <td>84.00000</td>\n",
              "      <td>84.00000</td>\n",
              "      <td>84.00000</td>\n",
              "      <td>84.00000</td>\n",
              "      <td>84.00000</td>\n",
              "      <td>84.00000</td>\n",
              "      <td>84.00000</td>\n",
              "      <td>...</td>\n",
              "      <td>88.69342</td>\n",
              "      <td>86.87348</td>\n",
              "      <td>86.87348</td>\n",
              "      <td>86.87348</td>\n",
              "      <td>86.87348</td>\n",
              "      <td>93.22755</td>\n",
              "      <td>93.22755</td>\n",
              "      <td>93.22755</td>\n",
              "      <td>89.85000</td>\n",
              "      <td>89.85000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>260 rows × 35 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                             Country  Literacy rate 1990  Literacy rate 1991  \\\n",
              "0                        Afghanistan            31.00000            31.00000   \n",
              "1                            Albania            99.00000            99.00000   \n",
              "2                            Algeria            70.00000            70.00000   \n",
              "3                            Andorra           100.00000           100.00000   \n",
              "4                             Angola            67.00000            67.00000   \n",
              "..                               ...                 ...                 ...   \n",
              "255  Western and Central Africa (WB)            43.57052            44.36271   \n",
              "256                            World            74.90692            75.28641   \n",
              "257                            Yemen            37.00000            37.00000   \n",
              "258                           Zambia            65.00000            65.00000   \n",
              "259                         Zimbabwe            84.00000            84.00000   \n",
              "\n",
              "     Literacy rate 1992  Literacy rate 1993  Literacy rate 1994  \\\n",
              "0              31.00000            31.00000            31.00000   \n",
              "1              99.00000            99.00000            99.00000   \n",
              "2              70.00000            70.00000            70.00000   \n",
              "3             100.00000           100.00000           100.00000   \n",
              "4              67.00000            67.00000            67.00000   \n",
              "..                  ...                 ...                 ...   \n",
              "255            45.13663            45.95827            46.83009   \n",
              "256            75.69422            76.10236            76.50139   \n",
              "257            37.00000            37.00000            37.00000   \n",
              "258            65.00000            65.00000            65.00000   \n",
              "259            84.00000            84.00000            84.00000   \n",
              "\n",
              "     Literacy rate 1995  Literacy rate 1996  Literacy rate 1997  \\\n",
              "0              31.00000            31.00000            31.00000   \n",
              "1              99.00000            99.00000            99.00000   \n",
              "2              70.00000            70.00000            70.00000   \n",
              "3             100.00000           100.00000           100.00000   \n",
              "4              67.00000            67.00000            67.00000   \n",
              "..                  ...                 ...                 ...   \n",
              "255            47.00222            47.86489            48.86634   \n",
              "256            76.91177            77.29624            79.28838   \n",
              "257            37.00000            37.00000            37.00000   \n",
              "258            65.00000            65.00000            65.00000   \n",
              "259            84.00000            84.00000            84.00000   \n",
              "\n",
              "     Literacy rate 1998  ...  Literacy rate 2014  Literacy rate 2015  \\\n",
              "0              31.00000  ...            31.00000            33.75384   \n",
              "1              99.00000  ...            97.00000            97.55390   \n",
              "2              70.00000  ...            75.00000            79.60840   \n",
              "3             100.00000  ...           100.00000           100.00000   \n",
              "4              67.00000  ...            66.00000            66.23586   \n",
              "..                  ...  ...                 ...                 ...   \n",
              "255            50.23897  ...            54.14114            55.00662   \n",
              "256            80.46865  ...            85.28639            85.67888   \n",
              "257            37.00000  ...            68.78942            69.96195   \n",
              "258            65.00000  ...            83.00000            85.11726   \n",
              "259            84.00000  ...            88.69342            86.87348   \n",
              "\n",
              "     Literacy rate 2016  Literacy rate 2017  Literacy rate 2018  \\\n",
              "0              33.75384            33.75384            33.75384   \n",
              "1              97.55390            98.81623            98.81623   \n",
              "2              79.60840            79.60840            81.40784   \n",
              "3             100.00000           100.00000           100.00000   \n",
              "4              66.23586            66.23586            66.23586   \n",
              "..                  ...                 ...                 ...   \n",
              "255            55.46578            56.47220            59.74735   \n",
              "256            86.00011            86.17700            86.43748   \n",
              "257            69.96195            69.96195            69.96195   \n",
              "258            85.11726            85.11726            71.13230   \n",
              "259            86.87348            86.87348            86.87348   \n",
              "\n",
              "     Literacy rate 2019  Literacy rate 2020  Literacy rate 2021  \\\n",
              "0              33.75384            33.75384            37.00000   \n",
              "1              98.81623            98.81623            98.81623   \n",
              "2              81.40784            81.40784            81.40784   \n",
              "3             100.00000           100.00000           100.00000   \n",
              "4              66.23586            66.23586            66.23586   \n",
              "..                  ...                 ...                 ...   \n",
              "255            59.55367            59.70324            60.00732   \n",
              "256            86.54791            86.74745            86.92751   \n",
              "257            69.96195            69.96195            69.96195   \n",
              "258            71.13230            87.50000            87.50000   \n",
              "259            93.22755            93.22755            93.22755   \n",
              "\n",
              "     Literacy rate 2022  Literacy rate 2023  \n",
              "0              37.00000            37.00000  \n",
              "1              98.50000            98.50000  \n",
              "2              81.40784            81.40784  \n",
              "3             100.00000           100.00000  \n",
              "4              72.40000            72.40000  \n",
              "..                  ...                 ...  \n",
              "255            60.29085            60.50555  \n",
              "256            87.15533            87.35600  \n",
              "257            69.96195            69.96195  \n",
              "258            87.50000            87.50000  \n",
              "259            89.85000            89.85000  \n",
              "\n",
              "[260 rows x 35 columns]"
            ]
          },
          "execution_count": 68,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "file_lit = \"./datasets/Literacy.csv\"\n",
        "df_lit = pd.read_csv(file_lit)\n",
        "df_lit = df_lit.drop(columns=[\"Code\"])\n",
        "df_lit.rename(columns={\"Entity\": \"Country\"}, inplace=True)\n",
        "df_lit"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 69,
      "metadata": {},
      "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>Country</th>\n",
              "      <th>1990 CO2 per capita</th>\n",
              "      <th>1991 CO2 per capita</th>\n",
              "      <th>1992 CO2 per capita</th>\n",
              "      <th>1993 CO2 per capita</th>\n",
              "      <th>1994 CO2 per capita</th>\n",
              "      <th>1995 CO2 per capita</th>\n",
              "      <th>1996 CO2 per capita</th>\n",
              "      <th>1997 CO2 per capita</th>\n",
              "      <th>1998 CO2 per capita</th>\n",
              "      <th>...</th>\n",
              "      <th>2014 CO2 per capita</th>\n",
              "      <th>2015 CO2 per capita</th>\n",
              "      <th>2016 CO2 per capita</th>\n",
              "      <th>2017 CO2 per capita</th>\n",
              "      <th>2018 CO2 per capita</th>\n",
              "      <th>2019 CO2 per capita</th>\n",
              "      <th>2020 CO2 per capita</th>\n",
              "      <th>2021 CO2 per capita</th>\n",
              "      <th>2022 CO2 per capita</th>\n",
              "      <th>2023 CO2 per capita</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Afghanistan</td>\n",
              "      <td>0.168</td>\n",
              "      <td>0.156</td>\n",
              "      <td>0.112</td>\n",
              "      <td>0.100</td>\n",
              "      <td>0.089</td>\n",
              "      <td>0.083</td>\n",
              "      <td>0.077</td>\n",
              "      <td>0.071</td>\n",
              "      <td>0.067</td>\n",
              "      <td>...</td>\n",
              "      <td>0.277</td>\n",
              "      <td>0.286</td>\n",
              "      <td>0.257</td>\n",
              "      <td>0.271</td>\n",
              "      <td>0.289</td>\n",
              "      <td>0.286</td>\n",
              "      <td>0.297</td>\n",
              "      <td>0.257</td>\n",
              "      <td>0.260</td>\n",
              "      <td>0.266</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Africa</td>\n",
              "      <td>1.024</td>\n",
              "      <td>1.042</td>\n",
              "      <td>0.984</td>\n",
              "      <td>1.016</td>\n",
              "      <td>1.108</td>\n",
              "      <td>1.154</td>\n",
              "      <td>1.162</td>\n",
              "      <td>1.162</td>\n",
              "      <td>1.157</td>\n",
              "      <td>...</td>\n",
              "      <td>1.143</td>\n",
              "      <td>1.094</td>\n",
              "      <td>1.100</td>\n",
              "      <td>1.087</td>\n",
              "      <td>1.055</td>\n",
              "      <td>1.099</td>\n",
              "      <td>0.983</td>\n",
              "      <td>1.021</td>\n",
              "      <td>0.991</td>\n",
              "      <td>0.959</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Africa (GCP)</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>...</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Albania</td>\n",
              "      <td>1.684</td>\n",
              "      <td>1.307</td>\n",
              "      <td>0.767</td>\n",
              "      <td>0.713</td>\n",
              "      <td>0.588</td>\n",
              "      <td>0.641</td>\n",
              "      <td>0.622</td>\n",
              "      <td>0.478</td>\n",
              "      <td>0.547</td>\n",
              "      <td>...</td>\n",
              "      <td>2.066</td>\n",
              "      <td>1.626</td>\n",
              "      <td>1.598</td>\n",
              "      <td>1.826</td>\n",
              "      <td>1.691</td>\n",
              "      <td>1.673</td>\n",
              "      <td>1.640</td>\n",
              "      <td>1.802</td>\n",
              "      <td>1.830</td>\n",
              "      <td>1.830</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Algeria</td>\n",
              "      <td>3.024</td>\n",
              "      <td>3.032</td>\n",
              "      <td>3.000</td>\n",
              "      <td>3.004</td>\n",
              "      <td>3.177</td>\n",
              "      <td>3.399</td>\n",
              "      <td>3.446</td>\n",
              "      <td>2.988</td>\n",
              "      <td>3.545</td>\n",
              "      <td>...</td>\n",
              "      <td>3.859</td>\n",
              "      <td>4.000</td>\n",
              "      <td>3.880</td>\n",
              "      <td>3.962</td>\n",
              "      <td>4.063</td>\n",
              "      <td>4.155</td>\n",
              "      <td>3.819</td>\n",
              "      <td>4.012</td>\n",
              "      <td>4.058</td>\n",
              "      <td>3.859</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 35 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "        Country  1990 CO2 per capita  1991 CO2 per capita  \\\n",
              "0   Afghanistan                0.168                0.156   \n",
              "1        Africa                1.024                1.042   \n",
              "2  Africa (GCP)                0.000                0.000   \n",
              "3       Albania                1.684                1.307   \n",
              "4       Algeria                3.024                3.032   \n",
              "\n",
              "   1992 CO2 per capita  1993 CO2 per capita  1994 CO2 per capita  \\\n",
              "0                0.112                0.100                0.089   \n",
              "1                0.984                1.016                1.108   \n",
              "2                0.000                0.000                0.000   \n",
              "3                0.767                0.713                0.588   \n",
              "4                3.000                3.004                3.177   \n",
              "\n",
              "   1995 CO2 per capita  1996 CO2 per capita  1997 CO2 per capita  \\\n",
              "0                0.083                0.077                0.071   \n",
              "1                1.154                1.162                1.162   \n",
              "2                0.000                0.000                0.000   \n",
              "3                0.641                0.622                0.478   \n",
              "4                3.399                3.446                2.988   \n",
              "\n",
              "   1998 CO2 per capita  ...  2014 CO2 per capita  2015 CO2 per capita  \\\n",
              "0                0.067  ...                0.277                0.286   \n",
              "1                1.157  ...                1.143                1.094   \n",
              "2                0.000  ...                0.000                0.000   \n",
              "3                0.547  ...                2.066                1.626   \n",
              "4                3.545  ...                3.859                4.000   \n",
              "\n",
              "   2016 CO2 per capita  2017 CO2 per capita  2018 CO2 per capita  \\\n",
              "0                0.257                0.271                0.289   \n",
              "1                1.100                1.087                1.055   \n",
              "2                0.000                0.000                0.000   \n",
              "3                1.598                1.826                1.691   \n",
              "4                3.880                3.962                4.063   \n",
              "\n",
              "   2019 CO2 per capita  2020 CO2 per capita  2021 CO2 per capita  \\\n",
              "0                0.286                0.297                0.257   \n",
              "1                1.099                0.983                1.021   \n",
              "2                0.000                0.000                0.000   \n",
              "3                1.673                1.640                1.802   \n",
              "4                4.155                3.819                4.012   \n",
              "\n",
              "   2022 CO2 per capita  2023 CO2 per capita  \n",
              "0                0.260                0.266  \n",
              "1                0.991                0.959  \n",
              "2                0.000                0.000  \n",
              "3                1.830                1.830  \n",
              "4                4.058                3.859  \n",
              "\n",
              "[5 rows x 35 columns]"
            ]
          },
          "execution_count": 69,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "file_co2 = \"./datasets/CO2.csv\"\n",
        "df_co2 = pd.read_csv(file_co2)\n",
        "df_co2 = df_co2.drop(columns=[\"Unnamed: 0\"])\n",
        "df_co2.rename(columns={\"country\": \"Country\"}, inplace=True)\n",
        "df_co2.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 78,
      "metadata": {},
      "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>Country</th>\n",
              "      <th>1990 CO2 per capita #2</th>\n",
              "      <th>1991 CO2 per capita #2</th>\n",
              "      <th>1992 CO2 per capita #2</th>\n",
              "      <th>1993 CO2 per capita #2</th>\n",
              "      <th>1994 CO2 per capita #2</th>\n",
              "      <th>1995 CO2 per capita #2</th>\n",
              "      <th>1996 CO2 per capita #2</th>\n",
              "      <th>1997 CO2 per capita #2</th>\n",
              "      <th>1998 CO2 per capita #2</th>\n",
              "      <th>...</th>\n",
              "      <th>2014 CO2 per capita #2</th>\n",
              "      <th>2015 CO2 per capita #2</th>\n",
              "      <th>2016 CO2 per capita #2</th>\n",
              "      <th>2017 CO2 per capita #2</th>\n",
              "      <th>2018 CO2 per capita #2</th>\n",
              "      <th>2019 CO2 per capita #2</th>\n",
              "      <th>2020 CO2 per capita #2</th>\n",
              "      <th>2021 CO2 per capita #2</th>\n",
              "      <th>2022 CO2 per capita #2</th>\n",
              "      <th>2023 CO2 per capita #2</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Afghanistan</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>...</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Africa</td>\n",
              "      <td>0.906</td>\n",
              "      <td>0.919</td>\n",
              "      <td>0.915</td>\n",
              "      <td>0.924</td>\n",
              "      <td>1.003</td>\n",
              "      <td>1.028</td>\n",
              "      <td>1.002</td>\n",
              "      <td>1.004</td>\n",
              "      <td>1.039</td>\n",
              "      <td>...</td>\n",
              "      <td>1.123</td>\n",
              "      <td>1.101</td>\n",
              "      <td>1.09</td>\n",
              "      <td>1.039</td>\n",
              "      <td>1.012</td>\n",
              "      <td>1.043</td>\n",
              "      <td>0.956</td>\n",
              "      <td>0.990</td>\n",
              "      <td>0.946</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Africa (GCP)</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>...</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Albania</td>\n",
              "      <td>1.695</td>\n",
              "      <td>1.406</td>\n",
              "      <td>0.888</td>\n",
              "      <td>0.815</td>\n",
              "      <td>0.726</td>\n",
              "      <td>0.781</td>\n",
              "      <td>0.932</td>\n",
              "      <td>0.690</td>\n",
              "      <td>0.790</td>\n",
              "      <td>...</td>\n",
              "      <td>2.242</td>\n",
              "      <td>2.040</td>\n",
              "      <td>2.01</td>\n",
              "      <td>2.055</td>\n",
              "      <td>2.053</td>\n",
              "      <td>2.022</td>\n",
              "      <td>2.009</td>\n",
              "      <td>2.147</td>\n",
              "      <td>2.127</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Algeria</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>...</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.00</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 35 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "        Country  1990 CO2 per capita #2  1991 CO2 per capita #2  \\\n",
              "0   Afghanistan                   0.000                   0.000   \n",
              "1        Africa                   0.906                   0.919   \n",
              "2  Africa (GCP)                   0.000                   0.000   \n",
              "3       Albania                   1.695                   1.406   \n",
              "4       Algeria                   0.000                   0.000   \n",
              "\n",
              "   1992 CO2 per capita #2  1993 CO2 per capita #2  1994 CO2 per capita #2  \\\n",
              "0                   0.000                   0.000                   0.000   \n",
              "1                   0.915                   0.924                   1.003   \n",
              "2                   0.000                   0.000                   0.000   \n",
              "3                   0.888                   0.815                   0.726   \n",
              "4                   0.000                   0.000                   0.000   \n",
              "\n",
              "   1995 CO2 per capita #2  1996 CO2 per capita #2  1997 CO2 per capita #2  \\\n",
              "0                   0.000                   0.000                   0.000   \n",
              "1                   1.028                   1.002                   1.004   \n",
              "2                   0.000                   0.000                   0.000   \n",
              "3                   0.781                   0.932                   0.690   \n",
              "4                   0.000                   0.000                   0.000   \n",
              "\n",
              "   1998 CO2 per capita #2  ...  2014 CO2 per capita #2  \\\n",
              "0                   0.000  ...                   0.000   \n",
              "1                   1.039  ...                   1.123   \n",
              "2                   0.000  ...                   0.000   \n",
              "3                   0.790  ...                   2.242   \n",
              "4                   0.000  ...                   0.000   \n",
              "\n",
              "   2015 CO2 per capita #2  2016 CO2 per capita #2  2017 CO2 per capita #2  \\\n",
              "0                   0.000                    0.00                   0.000   \n",
              "1                   1.101                    1.09                   1.039   \n",
              "2                   0.000                    0.00                   0.000   \n",
              "3                   2.040                    2.01                   2.055   \n",
              "4                   0.000                    0.00                   0.000   \n",
              "\n",
              "   2018 CO2 per capita #2  2019 CO2 per capita #2  2020 CO2 per capita #2  \\\n",
              "0                   0.000                   0.000                   0.000   \n",
              "1                   1.012                   1.043                   0.956   \n",
              "2                   0.000                   0.000                   0.000   \n",
              "3                   2.053                   2.022                   2.009   \n",
              "4                   0.000                   0.000                   0.000   \n",
              "\n",
              "   2021 CO2 per capita #2  2022 CO2 per capita #2  2023 CO2 per capita #2  \n",
              "0                   0.000                   0.000                     0.0  \n",
              "1                   0.990                   0.946                     0.0  \n",
              "2                   0.000                   0.000                     0.0  \n",
              "3                   2.147                   2.127                     0.0  \n",
              "4                   0.000                   0.000                     0.0  \n",
              "\n",
              "[5 rows x 35 columns]"
            ]
          },
          "execution_count": 78,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "file_co22 = \"./datasets/co2#2.csv\"\n",
        "df_co22 = pd.read_csv(file_co22)\n",
        "df_co22 = df_co22.drop(columns=[\"Unnamed: 0\"])\n",
        "df_co22.rename(columns={\"country\": \"Country\"}, inplace=True)\n",
        "# Rename columns to add #2 to CO2 per capita\n",
        "rename_dict = {col: col.replace('CO2 per capita', 'CO2 per capita #2') for col in df_co22.columns if 'CO2 per capita' in col}\n",
        "df_co22.rename(columns=rename_dict, inplace=True)\n",
        "\n",
        "df_co22.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 71,
      "metadata": {},
      "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>Country</th>\n",
              "      <th>2014 Energy</th>\n",
              "      <th>2015 Energy</th>\n",
              "      <th>2016 Energy</th>\n",
              "      <th>2017 Energy</th>\n",
              "      <th>2018 Energy</th>\n",
              "      <th>2019 Energy</th>\n",
              "      <th>2020 Energy</th>\n",
              "      <th>2021 Energy</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Argentina</td>\n",
              "      <td>2.21103916447582</td>\n",
              "      <td>0.78997913166528</td>\n",
              "      <td>0.568187363007616</td>\n",
              "      <td>0.676135028048864</td>\n",
              "      <td>1.43730115442118</td>\n",
              "      <td>1.53656088925892</td>\n",
              "      <td>0.805650721774117</td>\n",
              "      <td>1.59471633197215</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Australia</td>\n",
              "      <td>0.755451088942237</td>\n",
              "      <td>0.567565619466884</td>\n",
              "      <td>0.591410295226177</td>\n",
              "      <td>0.760358992143208</td>\n",
              "      <td>1.14049132500834</td>\n",
              "      <td>1.31732811944483</td>\n",
              "      <td>1.1162720977283</td>\n",
              "      <td>1.6313907314568</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Brazil</td>\n",
              "      <td>1.39876331607307</td>\n",
              "      <td>0.857685698468755</td>\n",
              "      <td>0.686699294180488</td>\n",
              "      <td>0.934976537711634</td>\n",
              "      <td>1.5802963493344</td>\n",
              "      <td>1.44608781006584</td>\n",
              "      <td>0.949585951805012</td>\n",
              "      <td>2.26355193351451</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>China</td>\n",
              "      <td>1.17449560810056</td>\n",
              "      <td>0.55146891809536</td>\n",
              "      <td>0.468471119066501</td>\n",
              "      <td>0.582954445963903</td>\n",
              "      <td>0.704281724834458</td>\n",
              "      <td>0.554702096120324</td>\n",
              "      <td>0.361833602387154</td>\n",
              "      <td>0.689430074246557</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>France</td>\n",
              "      <td>0.00701751945317788</td>\n",
              "      <td>0.00394674875841994</td>\n",
              "      <td>0.00301090345845521</td>\n",
              "      <td>0.00404255730613459</td>\n",
              "      <td>0.00676725037994716</td>\n",
              "      <td>0.00543453180331309</td>\n",
              "      <td>0.00264417156034399</td>\n",
              "      <td>0.00550683481013504</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "     Country          2014 Energy          2015 Energy          2016 Energy  \\\n",
              "0  Argentina     2.21103916447582     0.78997913166528    0.568187363007616   \n",
              "1  Australia    0.755451088942237    0.567565619466884    0.591410295226177   \n",
              "2     Brazil     1.39876331607307    0.857685698468755    0.686699294180488   \n",
              "3      China     1.17449560810056     0.55146891809536    0.468471119066501   \n",
              "4     France  0.00701751945317788  0.00394674875841994  0.00301090345845521   \n",
              "\n",
              "           2017 Energy          2018 Energy          2019 Energy  \\\n",
              "0    0.676135028048864     1.43730115442118     1.53656088925892   \n",
              "1    0.760358992143208     1.14049132500834     1.31732811944483   \n",
              "2    0.934976537711634      1.5802963493344     1.44608781006584   \n",
              "3    0.582954445963903    0.704281724834458    0.554702096120324   \n",
              "4  0.00404255730613459  0.00676725037994716  0.00543453180331309   \n",
              "\n",
              "           2020 Energy          2021 Energy  \n",
              "0    0.805650721774117     1.59471633197215  \n",
              "1      1.1162720977283      1.6313907314568  \n",
              "2    0.949585951805012     2.26355193351451  \n",
              "3    0.361833602387154    0.689430074246557  \n",
              "4  0.00264417156034399  0.00550683481013504  "
            ]
          },
          "execution_count": 71,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "file_energy = \"./datasets/Energy.csv\"\n",
        "df_energy = pd.read_csv(file_energy)\n",
        "df_energy.replace(\"..\", pd.NA, inplace=True)\n",
        "df_energy = df_energy.drop(columns=[\"YR2022\", \"YR2023\"])\n",
        "df_energy.rename(columns={\"Country Name\": \"Country\"}, inplace=True)\n",
        "year_columns = df_energy.columns[1:]\n",
        "rename_dict = {col: col.replace('YR', '') + ' Energy' for col in year_columns}\n",
        "\n",
        "df_energy.rename(columns=rename_dict, inplace=True)\n",
        "df_energy.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 72,
      "metadata": {},
      "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>Country</th>\n",
              "      <th>1990 Mortality</th>\n",
              "      <th>1991 Mortality</th>\n",
              "      <th>1992 Mortality</th>\n",
              "      <th>1993 Mortality</th>\n",
              "      <th>1994 Mortality</th>\n",
              "      <th>1995 Mortality</th>\n",
              "      <th>1996 Mortality</th>\n",
              "      <th>1997 Mortality</th>\n",
              "      <th>1998 Mortality</th>\n",
              "      <th>...</th>\n",
              "      <th>2013 Mortality</th>\n",
              "      <th>2014 Mortality</th>\n",
              "      <th>2015 Mortality</th>\n",
              "      <th>2016 Mortality</th>\n",
              "      <th>2017 Mortality</th>\n",
              "      <th>2018 Mortality</th>\n",
              "      <th>2019 Mortality</th>\n",
              "      <th>2020 Mortality</th>\n",
              "      <th>2021 Mortality</th>\n",
              "      <th>2022 Mortality</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Afghanistan</td>\n",
              "      <td>86.737889</td>\n",
              "      <td>79.666566</td>\n",
              "      <td>72.832604</td>\n",
              "      <td>66.091653</td>\n",
              "      <td>59.747625</td>\n",
              "      <td>53.965552</td>\n",
              "      <td>48.930874</td>\n",
              "      <td>44.358895</td>\n",
              "      <td>43.679160</td>\n",
              "      <td>...</td>\n",
              "      <td>35.706045</td>\n",
              "      <td>37.420748</td>\n",
              "      <td>39.144660</td>\n",
              "      <td>40.561584</td>\n",
              "      <td>41.512834</td>\n",
              "      <td>42.250427</td>\n",
              "      <td>42.954321</td>\n",
              "      <td>43.664294</td>\n",
              "      <td>44.554664</td>\n",
              "      <td>45.381934</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Albania</td>\n",
              "      <td>14.301552</td>\n",
              "      <td>14.483563</td>\n",
              "      <td>14.604564</td>\n",
              "      <td>14.597464</td>\n",
              "      <td>14.496106</td>\n",
              "      <td>14.403960</td>\n",
              "      <td>14.348612</td>\n",
              "      <td>17.321067</td>\n",
              "      <td>13.864254</td>\n",
              "      <td>...</td>\n",
              "      <td>7.746357</td>\n",
              "      <td>7.329462</td>\n",
              "      <td>6.910799</td>\n",
              "      <td>6.520890</td>\n",
              "      <td>6.182847</td>\n",
              "      <td>5.907073</td>\n",
              "      <td>5.690909</td>\n",
              "      <td>5.515814</td>\n",
              "      <td>5.376167</td>\n",
              "      <td>5.252144</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Algeria</td>\n",
              "      <td>20.208882</td>\n",
              "      <td>19.914723</td>\n",
              "      <td>19.630186</td>\n",
              "      <td>19.323652</td>\n",
              "      <td>18.976149</td>\n",
              "      <td>18.558510</td>\n",
              "      <td>18.058564</td>\n",
              "      <td>17.472038</td>\n",
              "      <td>16.812092</td>\n",
              "      <td>...</td>\n",
              "      <td>10.237530</td>\n",
              "      <td>10.161968</td>\n",
              "      <td>10.027424</td>\n",
              "      <td>9.839101</td>\n",
              "      <td>9.604716</td>\n",
              "      <td>9.322065</td>\n",
              "      <td>8.982225</td>\n",
              "      <td>8.604674</td>\n",
              "      <td>8.241613</td>\n",
              "      <td>7.953160</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Andorra</td>\n",
              "      <td>11.723153</td>\n",
              "      <td>11.249447</td>\n",
              "      <td>10.789020</td>\n",
              "      <td>10.391031</td>\n",
              "      <td>10.028884</td>\n",
              "      <td>9.654923</td>\n",
              "      <td>9.310799</td>\n",
              "      <td>8.973685</td>\n",
              "      <td>8.647435</td>\n",
              "      <td>...</td>\n",
              "      <td>5.089380</td>\n",
              "      <td>4.920988</td>\n",
              "      <td>4.741890</td>\n",
              "      <td>4.586083</td>\n",
              "      <td>4.443478</td>\n",
              "      <td>4.319561</td>\n",
              "      <td>4.198529</td>\n",
              "      <td>4.091002</td>\n",
              "      <td>3.989212</td>\n",
              "      <td>3.895987</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Angola</td>\n",
              "      <td>116.854328</td>\n",
              "      <td>109.293817</td>\n",
              "      <td>116.914515</td>\n",
              "      <td>109.060967</td>\n",
              "      <td>108.784116</td>\n",
              "      <td>108.434472</td>\n",
              "      <td>107.715146</td>\n",
              "      <td>106.694523</td>\n",
              "      <td>105.334388</td>\n",
              "      <td>...</td>\n",
              "      <td>58.998576</td>\n",
              "      <td>56.554353</td>\n",
              "      <td>54.426747</td>\n",
              "      <td>52.619912</td>\n",
              "      <td>50.929586</td>\n",
              "      <td>49.409288</td>\n",
              "      <td>47.997828</td>\n",
              "      <td>46.713510</td>\n",
              "      <td>45.551972</td>\n",
              "      <td>44.449184</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 34 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "       Country  1990 Mortality  1991 Mortality  1992 Mortality  \\\n",
              "0  Afghanistan       86.737889       79.666566       72.832604   \n",
              "1      Albania       14.301552       14.483563       14.604564   \n",
              "2      Algeria       20.208882       19.914723       19.630186   \n",
              "3      Andorra       11.723153       11.249447       10.789020   \n",
              "4       Angola      116.854328      109.293817      116.914515   \n",
              "\n",
              "   1993 Mortality  1994 Mortality  1995 Mortality  1996 Mortality  \\\n",
              "0       66.091653       59.747625       53.965552       48.930874   \n",
              "1       14.597464       14.496106       14.403960       14.348612   \n",
              "2       19.323652       18.976149       18.558510       18.058564   \n",
              "3       10.391031       10.028884        9.654923        9.310799   \n",
              "4      109.060967      108.784116      108.434472      107.715146   \n",
              "\n",
              "   1997 Mortality  1998 Mortality  ...  2013 Mortality  2014 Mortality  \\\n",
              "0       44.358895       43.679160  ...       35.706045       37.420748   \n",
              "1       17.321067       13.864254  ...        7.746357        7.329462   \n",
              "2       17.472038       16.812092  ...       10.237530       10.161968   \n",
              "3        8.973685        8.647435  ...        5.089380        4.920988   \n",
              "4      106.694523      105.334388  ...       58.998576       56.554353   \n",
              "\n",
              "   2015 Mortality  2016 Mortality  2017 Mortality  2018 Mortality  \\\n",
              "0       39.144660       40.561584       41.512834       42.250427   \n",
              "1        6.910799        6.520890        6.182847        5.907073   \n",
              "2       10.027424        9.839101        9.604716        9.322065   \n",
              "3        4.741890        4.586083        4.443478        4.319561   \n",
              "4       54.426747       52.619912       50.929586       49.409288   \n",
              "\n",
              "   2019 Mortality  2020 Mortality  2021 Mortality  2022 Mortality  \n",
              "0       42.954321       43.664294       44.554664       45.381934  \n",
              "1        5.690909        5.515814        5.376167        5.252144  \n",
              "2        8.982225        8.604674        8.241613        7.953160  \n",
              "3        4.198529        4.091002        3.989212        3.895987  \n",
              "4       47.997828       46.713510       45.551972       44.449184  \n",
              "\n",
              "[5 rows x 34 columns]"
            ]
          },
          "execution_count": 72,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "file_mortality = \"./datasets/Mortality.csv\"\n",
        "df_mortality = pd.read_csv(file_mortality)\n",
        "year_columns = df_mortality.columns[1:]\n",
        "rename_dict = {str(year): f'{year} Mortality' for year in range(1990, 2023)}\n",
        "df_mortality.rename(columns=rename_dict, inplace=True)\n",
        "df_mortality.head()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 73,
      "metadata": {},
      "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>Country</th>\n",
              "      <th>2010 PM10</th>\n",
              "      <th>2011 PM10</th>\n",
              "      <th>2012 PM10</th>\n",
              "      <th>2013 PM10</th>\n",
              "      <th>2014 PM10</th>\n",
              "      <th>2015 PM10</th>\n",
              "      <th>2016 PM10</th>\n",
              "      <th>2017 PM10</th>\n",
              "      <th>2018 PM10</th>\n",
              "      <th>2019 PM10</th>\n",
              "      <th>2020 PM10</th>\n",
              "      <th>2021 PM10</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Argentina</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>91.666667</td>\n",
              "      <td>100.000000</td>\n",
              "      <td>100.000000</td>\n",
              "      <td>97.200000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Australia</td>\n",
              "      <td>96.255102</td>\n",
              "      <td>95.740817</td>\n",
              "      <td>96.339286</td>\n",
              "      <td>96.454622</td>\n",
              "      <td>95.070408</td>\n",
              "      <td>95.353896</td>\n",
              "      <td>96.483069</td>\n",
              "      <td>89.185714</td>\n",
              "      <td>93.842857</td>\n",
              "      <td>97.364357</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Austria</td>\n",
              "      <td>98.065654</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Bahamas</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>67.000000</td>\n",
              "      <td>99.000000</td>\n",
              "      <td>40.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Bahrain</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>83.470320</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</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",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>72</th>\n",
              "      <td>Trinidad and Tobago</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>62.000000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>73</th>\n",
              "      <td>Turkey</td>\n",
              "      <td>89.866169</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>97.879249</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>74</th>\n",
              "      <td>Ukraine</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>92.300000</td>\n",
              "      <td>100.000000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75</th>\n",
              "      <td>United Kingdom</td>\n",
              "      <td>89.481747</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>76</th>\n",
              "      <td>Uruguay</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>48.219178</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.000000</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>77 rows × 13 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                Country  2010 PM10  2011 PM10  2012 PM10  2013 PM10  \\\n",
              "0             Argentina   0.000000   0.000000   0.000000   0.000000   \n",
              "1             Australia  96.255102  95.740817  96.339286  96.454622   \n",
              "2               Austria  98.065654   0.000000   0.000000   0.000000   \n",
              "3               Bahamas   0.000000   0.000000   0.000000   0.000000   \n",
              "4               Bahrain   0.000000   0.000000   0.000000   0.000000   \n",
              "..                  ...        ...        ...        ...        ...   \n",
              "72  Trinidad and Tobago   0.000000   0.000000   0.000000   0.000000   \n",
              "73               Turkey  89.866169   0.000000   0.000000   0.000000   \n",
              "74              Ukraine   0.000000   0.000000   0.000000   0.000000   \n",
              "75       United Kingdom  89.481747   0.000000   0.000000   0.000000   \n",
              "76              Uruguay   0.000000   0.000000   0.000000   0.000000   \n",
              "\n",
              "    2014 PM10  2015 PM10  2016 PM10   2017 PM10   2018 PM10   2019 PM10  \\\n",
              "0    0.000000   0.000000  91.666667  100.000000  100.000000   97.200000   \n",
              "1   95.070408  95.353896  96.483069   89.185714   93.842857   97.364357   \n",
              "2    0.000000   0.000000   0.000000    0.000000    0.000000    0.000000   \n",
              "3    0.000000   0.000000   0.000000    0.000000   67.000000   99.000000   \n",
              "4    0.000000   0.000000   0.000000    0.000000    0.000000   83.470320   \n",
              "..        ...        ...        ...         ...         ...         ...   \n",
              "72   0.000000   0.000000   0.000000    0.000000    0.000000   62.000000   \n",
              "73   0.000000   0.000000   0.000000    0.000000    0.000000   97.879249   \n",
              "74   0.000000   0.000000   0.000000    0.000000   92.300000  100.000000   \n",
              "75   0.000000   0.000000   0.000000    0.000000    0.000000    0.000000   \n",
              "76  48.219178   0.000000   0.000000    0.000000    0.000000    0.000000   \n",
              "\n",
              "    2020 PM10  2021 PM10  \n",
              "0         0.0        0.0  \n",
              "1         0.0        0.0  \n",
              "2         0.0        0.0  \n",
              "3        40.0        0.0  \n",
              "4         0.0        0.0  \n",
              "..        ...        ...  \n",
              "72        0.0        0.0  \n",
              "73        0.0        0.0  \n",
              "74        0.0        0.0  \n",
              "75        0.0        0.0  \n",
              "76        0.0        0.0  \n",
              "\n",
              "[77 rows x 13 columns]"
            ]
          },
          "execution_count": 73,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "file_pm10 = \"./datasets/PM10.csv\"\n",
        "df_pm10 = pd.read_csv(file_pm10)\n",
        "df_pm10.rename(columns={\"WHO Country Name\": \"Country\"}, inplace=True)\n",
        "rename_dict = {str(year): f'{year} PM10' for year in range(2010, 2022)}\n",
        "df_pm10.rename(columns=rename_dict, inplace=True)\n",
        "df_pm10 "
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 79,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "F9SO7Xz628Da",
        "outputId": "141b81d6-1c84-4f71-c3fc-13c78d27dac3"
      },
      "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>Country</th>\n",
              "      <th>Gini coefficient 1990</th>\n",
              "      <th>Gini coefficient 1991</th>\n",
              "      <th>Gini coefficient 1992</th>\n",
              "      <th>Gini coefficient 1993</th>\n",
              "      <th>Gini coefficient 1994</th>\n",
              "      <th>Gini coefficient 1995</th>\n",
              "      <th>Gini coefficient 1996</th>\n",
              "      <th>Gini coefficient 1997</th>\n",
              "      <th>Gini coefficient 1998</th>\n",
              "      <th>...</th>\n",
              "      <th>2013 Mortality</th>\n",
              "      <th>2014 Mortality</th>\n",
              "      <th>2015 Mortality</th>\n",
              "      <th>2016 Mortality</th>\n",
              "      <th>2017 Mortality</th>\n",
              "      <th>2018 Mortality</th>\n",
              "      <th>2019 Mortality</th>\n",
              "      <th>2020 Mortality</th>\n",
              "      <th>2021 Mortality</th>\n",
              "      <th>2022 Mortality</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Albania</td>\n",
              "      <td>0.270103</td>\n",
              "      <td>0.270103</td>\n",
              "      <td>0.270103</td>\n",
              "      <td>0.270103</td>\n",
              "      <td>0.270103</td>\n",
              "      <td>0.270103</td>\n",
              "      <td>0.270103</td>\n",
              "      <td>0.270103</td>\n",
              "      <td>0.270103</td>\n",
              "      <td>...</td>\n",
              "      <td>7.746357</td>\n",
              "      <td>7.329462</td>\n",
              "      <td>6.910799</td>\n",
              "      <td>6.520890</td>\n",
              "      <td>6.182847</td>\n",
              "      <td>5.907073</td>\n",
              "      <td>5.690909</td>\n",
              "      <td>5.515814</td>\n",
              "      <td>5.376167</td>\n",
              "      <td>5.252144</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Algeria</td>\n",
              "      <td>0.353301</td>\n",
              "      <td>0.353301</td>\n",
              "      <td>0.353301</td>\n",
              "      <td>0.353301</td>\n",
              "      <td>0.353301</td>\n",
              "      <td>0.353301</td>\n",
              "      <td>0.353301</td>\n",
              "      <td>0.353301</td>\n",
              "      <td>0.353301</td>\n",
              "      <td>...</td>\n",
              "      <td>10.237530</td>\n",
              "      <td>10.161968</td>\n",
              "      <td>10.027424</td>\n",
              "      <td>9.839101</td>\n",
              "      <td>9.604716</td>\n",
              "      <td>9.322065</td>\n",
              "      <td>8.982225</td>\n",
              "      <td>8.604674</td>\n",
              "      <td>8.241613</td>\n",
              "      <td>7.953160</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Angola</td>\n",
              "      <td>0.519447</td>\n",
              "      <td>0.519447</td>\n",
              "      <td>0.519447</td>\n",
              "      <td>0.519447</td>\n",
              "      <td>0.519447</td>\n",
              "      <td>0.519447</td>\n",
              "      <td>0.519447</td>\n",
              "      <td>0.519447</td>\n",
              "      <td>0.519447</td>\n",
              "      <td>...</td>\n",
              "      <td>58.998576</td>\n",
              "      <td>56.554353</td>\n",
              "      <td>54.426747</td>\n",
              "      <td>52.619912</td>\n",
              "      <td>50.929586</td>\n",
              "      <td>49.409288</td>\n",
              "      <td>47.997828</td>\n",
              "      <td>46.713510</td>\n",
              "      <td>45.551972</td>\n",
              "      <td>44.449184</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Armenia</td>\n",
              "      <td>0.362197</td>\n",
              "      <td>0.362197</td>\n",
              "      <td>0.362197</td>\n",
              "      <td>0.362197</td>\n",
              "      <td>0.362197</td>\n",
              "      <td>0.362197</td>\n",
              "      <td>0.362197</td>\n",
              "      <td>0.362197</td>\n",
              "      <td>0.362197</td>\n",
              "      <td>...</td>\n",
              "      <td>6.606133</td>\n",
              "      <td>7.062106</td>\n",
              "      <td>7.966167</td>\n",
              "      <td>8.507257</td>\n",
              "      <td>8.112138</td>\n",
              "      <td>7.307098</td>\n",
              "      <td>6.660999</td>\n",
              "      <td>6.572645</td>\n",
              "      <td>7.533118</td>\n",
              "      <td>11.212091</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Australia</td>\n",
              "      <td>0.325786</td>\n",
              "      <td>0.325786</td>\n",
              "      <td>0.325786</td>\n",
              "      <td>0.325786</td>\n",
              "      <td>0.325786</td>\n",
              "      <td>0.325786</td>\n",
              "      <td>0.325786</td>\n",
              "      <td>0.325786</td>\n",
              "      <td>0.325786</td>\n",
              "      <td>...</td>\n",
              "      <td>4.572380</td>\n",
              "      <td>4.477610</td>\n",
              "      <td>4.424821</td>\n",
              "      <td>4.416563</td>\n",
              "      <td>4.448280</td>\n",
              "      <td>4.496637</td>\n",
              "      <td>4.534294</td>\n",
              "      <td>4.541600</td>\n",
              "      <td>4.505020</td>\n",
              "      <td>4.419226</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",
              "      <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>135</th>\n",
              "      <td>Uruguay</td>\n",
              "      <td>0.459414</td>\n",
              "      <td>0.459414</td>\n",
              "      <td>0.459414</td>\n",
              "      <td>0.459414</td>\n",
              "      <td>0.459414</td>\n",
              "      <td>0.459414</td>\n",
              "      <td>0.459414</td>\n",
              "      <td>0.459414</td>\n",
              "      <td>0.459414</td>\n",
              "      <td>...</td>\n",
              "      <td>10.849620</td>\n",
              "      <td>10.688722</td>\n",
              "      <td>10.538097</td>\n",
              "      <td>10.460239</td>\n",
              "      <td>10.474150</td>\n",
              "      <td>10.553494</td>\n",
              "      <td>10.656787</td>\n",
              "      <td>10.779560</td>\n",
              "      <td>10.916725</td>\n",
              "      <td>11.056742</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>136</th>\n",
              "      <td>Uzbekistan</td>\n",
              "      <td>0.442685</td>\n",
              "      <td>0.442685</td>\n",
              "      <td>0.442685</td>\n",
              "      <td>0.442685</td>\n",
              "      <td>0.442685</td>\n",
              "      <td>0.442685</td>\n",
              "      <td>0.442685</td>\n",
              "      <td>0.442685</td>\n",
              "      <td>0.442685</td>\n",
              "      <td>...</td>\n",
              "      <td>11.423584</td>\n",
              "      <td>11.573624</td>\n",
              "      <td>11.698995</td>\n",
              "      <td>11.740396</td>\n",
              "      <td>11.620231</td>\n",
              "      <td>11.275721</td>\n",
              "      <td>10.844921</td>\n",
              "      <td>10.536127</td>\n",
              "      <td>10.435320</td>\n",
              "      <td>10.435145</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>137</th>\n",
              "      <td>Vanuatu</td>\n",
              "      <td>0.373513</td>\n",
              "      <td>0.373513</td>\n",
              "      <td>0.373513</td>\n",
              "      <td>0.373513</td>\n",
              "      <td>0.373513</td>\n",
              "      <td>0.373513</td>\n",
              "      <td>0.373513</td>\n",
              "      <td>0.373513</td>\n",
              "      <td>0.373513</td>\n",
              "      <td>...</td>\n",
              "      <td>15.146252</td>\n",
              "      <td>14.958865</td>\n",
              "      <td>14.819970</td>\n",
              "      <td>14.708312</td>\n",
              "      <td>14.575267</td>\n",
              "      <td>14.396351</td>\n",
              "      <td>14.227136</td>\n",
              "      <td>14.008246</td>\n",
              "      <td>13.789132</td>\n",
              "      <td>13.557602</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>138</th>\n",
              "      <td>Zambia</td>\n",
              "      <td>0.594029</td>\n",
              "      <td>0.594029</td>\n",
              "      <td>0.594029</td>\n",
              "      <td>0.525501</td>\n",
              "      <td>0.525501</td>\n",
              "      <td>0.525501</td>\n",
              "      <td>0.483284</td>\n",
              "      <td>0.483284</td>\n",
              "      <td>0.491221</td>\n",
              "      <td>...</td>\n",
              "      <td>40.704846</td>\n",
              "      <td>39.054175</td>\n",
              "      <td>37.519899</td>\n",
              "      <td>36.036828</td>\n",
              "      <td>34.668885</td>\n",
              "      <td>33.489714</td>\n",
              "      <td>32.601132</td>\n",
              "      <td>31.921261</td>\n",
              "      <td>31.399460</td>\n",
              "      <td>30.978062</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>139</th>\n",
              "      <td>Zimbabwe</td>\n",
              "      <td>0.431536</td>\n",
              "      <td>0.431536</td>\n",
              "      <td>0.431536</td>\n",
              "      <td>0.431536</td>\n",
              "      <td>0.431536</td>\n",
              "      <td>0.431536</td>\n",
              "      <td>0.431536</td>\n",
              "      <td>0.431536</td>\n",
              "      <td>0.431536</td>\n",
              "      <td>...</td>\n",
              "      <td>41.038593</td>\n",
              "      <td>40.189532</td>\n",
              "      <td>39.448588</td>\n",
              "      <td>38.858766</td>\n",
              "      <td>38.341540</td>\n",
              "      <td>37.845183</td>\n",
              "      <td>37.416589</td>\n",
              "      <td>37.070554</td>\n",
              "      <td>36.894658</td>\n",
              "      <td>36.584246</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>140 rows × 342 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "        Country  Gini coefficient 1990  Gini coefficient 1991  \\\n",
              "0       Albania               0.270103               0.270103   \n",
              "1       Algeria               0.353301               0.353301   \n",
              "2        Angola               0.519447               0.519447   \n",
              "3       Armenia               0.362197               0.362197   \n",
              "4     Australia               0.325786               0.325786   \n",
              "..          ...                    ...                    ...   \n",
              "135     Uruguay               0.459414               0.459414   \n",
              "136  Uzbekistan               0.442685               0.442685   \n",
              "137     Vanuatu               0.373513               0.373513   \n",
              "138      Zambia               0.594029               0.594029   \n",
              "139    Zimbabwe               0.431536               0.431536   \n",
              "\n",
              "     Gini coefficient 1992  Gini coefficient 1993  Gini coefficient 1994  \\\n",
              "0                 0.270103               0.270103               0.270103   \n",
              "1                 0.353301               0.353301               0.353301   \n",
              "2                 0.519447               0.519447               0.519447   \n",
              "3                 0.362197               0.362197               0.362197   \n",
              "4                 0.325786               0.325786               0.325786   \n",
              "..                     ...                    ...                    ...   \n",
              "135               0.459414               0.459414               0.459414   \n",
              "136               0.442685               0.442685               0.442685   \n",
              "137               0.373513               0.373513               0.373513   \n",
              "138               0.594029               0.525501               0.525501   \n",
              "139               0.431536               0.431536               0.431536   \n",
              "\n",
              "     Gini coefficient 1995  Gini coefficient 1996  Gini coefficient 1997  \\\n",
              "0                 0.270103               0.270103               0.270103   \n",
              "1                 0.353301               0.353301               0.353301   \n",
              "2                 0.519447               0.519447               0.519447   \n",
              "3                 0.362197               0.362197               0.362197   \n",
              "4                 0.325786               0.325786               0.325786   \n",
              "..                     ...                    ...                    ...   \n",
              "135               0.459414               0.459414               0.459414   \n",
              "136               0.442685               0.442685               0.442685   \n",
              "137               0.373513               0.373513               0.373513   \n",
              "138               0.525501               0.483284               0.483284   \n",
              "139               0.431536               0.431536               0.431536   \n",
              "\n",
              "     Gini coefficient 1998  ...  2013 Mortality  2014 Mortality  \\\n",
              "0                 0.270103  ...        7.746357        7.329462   \n",
              "1                 0.353301  ...       10.237530       10.161968   \n",
              "2                 0.519447  ...       58.998576       56.554353   \n",
              "3                 0.362197  ...        6.606133        7.062106   \n",
              "4                 0.325786  ...        4.572380        4.477610   \n",
              "..                     ...  ...             ...             ...   \n",
              "135               0.459414  ...       10.849620       10.688722   \n",
              "136               0.442685  ...       11.423584       11.573624   \n",
              "137               0.373513  ...       15.146252       14.958865   \n",
              "138               0.491221  ...       40.704846       39.054175   \n",
              "139               0.431536  ...       41.038593       40.189532   \n",
              "\n",
              "     2015 Mortality  2016 Mortality  2017 Mortality  2018 Mortality  \\\n",
              "0          6.910799        6.520890        6.182847        5.907073   \n",
              "1         10.027424        9.839101        9.604716        9.322065   \n",
              "2         54.426747       52.619912       50.929586       49.409288   \n",
              "3          7.966167        8.507257        8.112138        7.307098   \n",
              "4          4.424821        4.416563        4.448280        4.496637   \n",
              "..              ...             ...             ...             ...   \n",
              "135       10.538097       10.460239       10.474150       10.553494   \n",
              "136       11.698995       11.740396       11.620231       11.275721   \n",
              "137       14.819970       14.708312       14.575267       14.396351   \n",
              "138       37.519899       36.036828       34.668885       33.489714   \n",
              "139       39.448588       38.858766       38.341540       37.845183   \n",
              "\n",
              "     2019 Mortality  2020 Mortality  2021 Mortality  2022 Mortality  \n",
              "0          5.690909        5.515814        5.376167        5.252144  \n",
              "1          8.982225        8.604674        8.241613        7.953160  \n",
              "2         47.997828       46.713510       45.551972       44.449184  \n",
              "3          6.660999        6.572645        7.533118       11.212091  \n",
              "4          4.534294        4.541600        4.505020        4.419226  \n",
              "..              ...             ...             ...             ...  \n",
              "135       10.656787       10.779560       10.916725       11.056742  \n",
              "136       10.844921       10.536127       10.435320       10.435145  \n",
              "137       14.227136       14.008246       13.789132       13.557602  \n",
              "138       32.601132       31.921261       31.399460       30.978062  \n",
              "139       37.416589       37.070554       36.894658       36.584246  \n",
              "\n",
              "[140 rows x 342 columns]"
            ]
          },
          "execution_count": 79,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "# Merge multiple DataFrames step by step\n",
        "combined_df_wo_infra = pd.merge(df_gini, df_gdp, how=\"inner\", on=\"Country\")\n",
        "combined_df_wo_infra = pd.merge(combined_df_wo_infra, df_hdi, how=\"inner\", on=\"Country\")\n",
        "combined_df_wo_infra = pd.merge(combined_df_wo_infra, df_lit, how=\"inner\", on=\"Country\")\n",
        "combined_df_wo_infra = pd.merge(combined_df_wo_infra, df_net, how=\"inner\", on=\"Country\")\n",
        "combined_df_wo_infra = pd.merge(combined_df_wo_infra, df_co2, how=\"inner\", on=\"Country\")\n",
        "combined_df_wo_infra = pd.merge(combined_df_wo_infra, df_co22, how=\"inner\", on=\"Country\")\n",
        "combined_df_wo_infra = pd.merge(combined_df_wo_infra, df_energy, how=\"inner\", on=\"Country\")\n",
        "combined_df_wo_infra = pd.merge(combined_df_wo_infra, df_mortality, how=\"inner\", on=\"Country\")\n",
        "\n",
        "# Display the resulting DataFrame\n",
        "combined_df_wo_infra"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 80,
      "metadata": {},
      "outputs": [],
      "source": [
        "combined_df_wo_infra.to_csv(\"./datasets/combined_df_wo_infra.csv\", index=False)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 81,
      "metadata": {},
      "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>Country</th>\n",
              "      <th>Gini coefficient 1990</th>\n",
              "      <th>Gini coefficient 1991</th>\n",
              "      <th>Gini coefficient 1992</th>\n",
              "      <th>Gini coefficient 1993</th>\n",
              "      <th>Gini coefficient 1994</th>\n",
              "      <th>Gini coefficient 1995</th>\n",
              "      <th>Gini coefficient 1996</th>\n",
              "      <th>Gini coefficient 1997</th>\n",
              "      <th>Gini coefficient 1998</th>\n",
              "      <th>...</th>\n",
              "      <th>2018 Mortality</th>\n",
              "      <th>2019 Mortality</th>\n",
              "      <th>2020 Mortality</th>\n",
              "      <th>2021 Mortality</th>\n",
              "      <th>2022 Mortality</th>\n",
              "      <th>Average Power Line</th>\n",
              "      <th>Average Schools</th>\n",
              "      <th>Average Supermarkets</th>\n",
              "      <th>Average Public Roads</th>\n",
              "      <th>Average Hospitals</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Australia</td>\n",
              "      <td>0.325786</td>\n",
              "      <td>0.325786</td>\n",
              "      <td>0.325786</td>\n",
              "      <td>0.325786</td>\n",
              "      <td>0.325786</td>\n",
              "      <td>0.325786</td>\n",
              "      <td>0.325786</td>\n",
              "      <td>0.325786</td>\n",
              "      <td>0.325786</td>\n",
              "      <td>...</td>\n",
              "      <td>4.496637</td>\n",
              "      <td>4.534294</td>\n",
              "      <td>4.541600</td>\n",
              "      <td>4.505020</td>\n",
              "      <td>4.419226</td>\n",
              "      <td>8.0</td>\n",
              "      <td>16.0</td>\n",
              "      <td>10.8</td>\n",
              "      <td>69.8</td>\n",
              "      <td>1.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Austria</td>\n",
              "      <td>0.308280</td>\n",
              "      <td>0.308280</td>\n",
              "      <td>0.308280</td>\n",
              "      <td>0.308280</td>\n",
              "      <td>0.308280</td>\n",
              "      <td>0.299143</td>\n",
              "      <td>0.293178</td>\n",
              "      <td>0.290654</td>\n",
              "      <td>0.313408</td>\n",
              "      <td>...</td>\n",
              "      <td>3.921898</td>\n",
              "      <td>3.933814</td>\n",
              "      <td>3.986880</td>\n",
              "      <td>4.072674</td>\n",
              "      <td>4.178208</td>\n",
              "      <td>3.4</td>\n",
              "      <td>15.6</td>\n",
              "      <td>10.2</td>\n",
              "      <td>45.0</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Belarus</td>\n",
              "      <td>0.320184</td>\n",
              "      <td>0.320184</td>\n",
              "      <td>0.320184</td>\n",
              "      <td>0.320184</td>\n",
              "      <td>0.320184</td>\n",
              "      <td>0.320184</td>\n",
              "      <td>0.320184</td>\n",
              "      <td>0.320184</td>\n",
              "      <td>0.320184</td>\n",
              "      <td>...</td>\n",
              "      <td>5.749728</td>\n",
              "      <td>5.401263</td>\n",
              "      <td>5.140058</td>\n",
              "      <td>4.960482</td>\n",
              "      <td>4.841156</td>\n",
              "      <td>2.2</td>\n",
              "      <td>12.0</td>\n",
              "      <td>1.2</td>\n",
              "      <td>24.4</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Brazil</td>\n",
              "      <td>0.604500</td>\n",
              "      <td>0.604500</td>\n",
              "      <td>0.531017</td>\n",
              "      <td>0.600656</td>\n",
              "      <td>0.600656</td>\n",
              "      <td>0.595304</td>\n",
              "      <td>0.598373</td>\n",
              "      <td>0.597537</td>\n",
              "      <td>0.595654</td>\n",
              "      <td>...</td>\n",
              "      <td>15.990706</td>\n",
              "      <td>15.526359</td>\n",
              "      <td>15.132572</td>\n",
              "      <td>14.805685</td>\n",
              "      <td>14.545867</td>\n",
              "      <td>1.8</td>\n",
              "      <td>3.8</td>\n",
              "      <td>2.8</td>\n",
              "      <td>18.4</td>\n",
              "      <td>0.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Canada</td>\n",
              "      <td>0.313654</td>\n",
              "      <td>0.319434</td>\n",
              "      <td>0.315643</td>\n",
              "      <td>0.316759</td>\n",
              "      <td>0.313038</td>\n",
              "      <td>0.315096</td>\n",
              "      <td>0.327681</td>\n",
              "      <td>0.331169</td>\n",
              "      <td>0.332172</td>\n",
              "      <td>...</td>\n",
              "      <td>5.549870</td>\n",
              "      <td>5.583710</td>\n",
              "      <td>5.690650</td>\n",
              "      <td>5.914808</td>\n",
              "      <td>6.163911</td>\n",
              "      <td>2.4</td>\n",
              "      <td>20.8</td>\n",
              "      <td>11.0</td>\n",
              "      <td>11.4</td>\n",
              "      <td>0.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Chile</td>\n",
              "      <td>0.572354</td>\n",
              "      <td>0.572354</td>\n",
              "      <td>0.548065</td>\n",
              "      <td>0.548065</td>\n",
              "      <td>0.564210</td>\n",
              "      <td>0.564210</td>\n",
              "      <td>0.548688</td>\n",
              "      <td>0.548688</td>\n",
              "      <td>0.555167</td>\n",
              "      <td>...</td>\n",
              "      <td>6.807043</td>\n",
              "      <td>6.842064</td>\n",
              "      <td>6.916595</td>\n",
              "      <td>6.989901</td>\n",
              "      <td>7.015981</td>\n",
              "      <td>3.4</td>\n",
              "      <td>95.8</td>\n",
              "      <td>14.8</td>\n",
              "      <td>32.0</td>\n",
              "      <td>1.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Colombia</td>\n",
              "      <td>0.513523</td>\n",
              "      <td>0.513523</td>\n",
              "      <td>0.513523</td>\n",
              "      <td>0.513523</td>\n",
              "      <td>0.513523</td>\n",
              "      <td>0.513523</td>\n",
              "      <td>0.567805</td>\n",
              "      <td>0.567805</td>\n",
              "      <td>0.567805</td>\n",
              "      <td>...</td>\n",
              "      <td>13.668761</td>\n",
              "      <td>13.711564</td>\n",
              "      <td>13.856109</td>\n",
              "      <td>14.112707</td>\n",
              "      <td>14.453973</td>\n",
              "      <td>7.2</td>\n",
              "      <td>25.4</td>\n",
              "      <td>27.6</td>\n",
              "      <td>15.8</td>\n",
              "      <td>3.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>Croatia</td>\n",
              "      <td>0.325537</td>\n",
              "      <td>0.325537</td>\n",
              "      <td>0.325537</td>\n",
              "      <td>0.325537</td>\n",
              "      <td>0.325537</td>\n",
              "      <td>0.325537</td>\n",
              "      <td>0.325537</td>\n",
              "      <td>0.325537</td>\n",
              "      <td>0.325537</td>\n",
              "      <td>...</td>\n",
              "      <td>4.913303</td>\n",
              "      <td>5.027645</td>\n",
              "      <td>5.155426</td>\n",
              "      <td>5.274027</td>\n",
              "      <td>5.360567</td>\n",
              "      <td>1.4</td>\n",
              "      <td>0.6</td>\n",
              "      <td>0.6</td>\n",
              "      <td>8.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Czechia</td>\n",
              "      <td>0.207033</td>\n",
              "      <td>0.207033</td>\n",
              "      <td>0.207033</td>\n",
              "      <td>0.265535</td>\n",
              "      <td>0.265535</td>\n",
              "      <td>0.265535</td>\n",
              "      <td>0.257990</td>\n",
              "      <td>0.257990</td>\n",
              "      <td>0.257990</td>\n",
              "      <td>...</td>\n",
              "      <td>4.668561</td>\n",
              "      <td>4.629072</td>\n",
              "      <td>4.607017</td>\n",
              "      <td>4.612386</td>\n",
              "      <td>4.643248</td>\n",
              "      <td>9.8</td>\n",
              "      <td>5.4</td>\n",
              "      <td>1.6</td>\n",
              "      <td>9.0</td>\n",
              "      <td>0.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Denmark</td>\n",
              "      <td>0.246910</td>\n",
              "      <td>0.246910</td>\n",
              "      <td>0.246910</td>\n",
              "      <td>0.246910</td>\n",
              "      <td>0.246910</td>\n",
              "      <td>0.229559</td>\n",
              "      <td>0.229559</td>\n",
              "      <td>0.229559</td>\n",
              "      <td>0.229559</td>\n",
              "      <td>...</td>\n",
              "      <td>3.032260</td>\n",
              "      <td>3.035299</td>\n",
              "      <td>3.044604</td>\n",
              "      <td>3.055999</td>\n",
              "      <td>3.070977</td>\n",
              "      <td>1.8</td>\n",
              "      <td>18.4</td>\n",
              "      <td>14.0</td>\n",
              "      <td>69.2</td>\n",
              "      <td>2.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Estonia</td>\n",
              "      <td>0.394273</td>\n",
              "      <td>0.394273</td>\n",
              "      <td>0.394273</td>\n",
              "      <td>0.394273</td>\n",
              "      <td>0.394273</td>\n",
              "      <td>0.394273</td>\n",
              "      <td>0.394273</td>\n",
              "      <td>0.394273</td>\n",
              "      <td>0.394273</td>\n",
              "      <td>...</td>\n",
              "      <td>5.453301</td>\n",
              "      <td>5.101544</td>\n",
              "      <td>4.792426</td>\n",
              "      <td>4.533591</td>\n",
              "      <td>4.355332</td>\n",
              "      <td>1.2</td>\n",
              "      <td>11.0</td>\n",
              "      <td>5.6</td>\n",
              "      <td>25.4</td>\n",
              "      <td>0.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Finland</td>\n",
              "      <td>0.228798</td>\n",
              "      <td>0.228798</td>\n",
              "      <td>0.228798</td>\n",
              "      <td>0.228798</td>\n",
              "      <td>0.228798</td>\n",
              "      <td>0.234591</td>\n",
              "      <td>0.234591</td>\n",
              "      <td>0.234591</td>\n",
              "      <td>0.234591</td>\n",
              "      <td>...</td>\n",
              "      <td>5.311350</td>\n",
              "      <td>5.448363</td>\n",
              "      <td>5.478113</td>\n",
              "      <td>5.407742</td>\n",
              "      <td>5.272486</td>\n",
              "      <td>1.6</td>\n",
              "      <td>3.6</td>\n",
              "      <td>1.0</td>\n",
              "      <td>24.6</td>\n",
              "      <td>0.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>France</td>\n",
              "      <td>0.321191</td>\n",
              "      <td>0.321191</td>\n",
              "      <td>0.321191</td>\n",
              "      <td>0.321191</td>\n",
              "      <td>0.321191</td>\n",
              "      <td>0.321191</td>\n",
              "      <td>0.320166</td>\n",
              "      <td>0.319001</td>\n",
              "      <td>0.316578</td>\n",
              "      <td>...</td>\n",
              "      <td>3.740644</td>\n",
              "      <td>3.696873</td>\n",
              "      <td>3.654224</td>\n",
              "      <td>3.613443</td>\n",
              "      <td>3.569938</td>\n",
              "      <td>1.6</td>\n",
              "      <td>3.0</td>\n",
              "      <td>0.4</td>\n",
              "      <td>34.0</td>\n",
              "      <td>0.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Germany</td>\n",
              "      <td>0.294929</td>\n",
              "      <td>0.294929</td>\n",
              "      <td>0.290733</td>\n",
              "      <td>0.286121</td>\n",
              "      <td>0.291594</td>\n",
              "      <td>0.288113</td>\n",
              "      <td>0.279938</td>\n",
              "      <td>0.282467</td>\n",
              "      <td>0.282704</td>\n",
              "      <td>...</td>\n",
              "      <td>3.422374</td>\n",
              "      <td>3.389413</td>\n",
              "      <td>3.387469</td>\n",
              "      <td>3.425392</td>\n",
              "      <td>3.497733</td>\n",
              "      <td>1.8</td>\n",
              "      <td>21.2</td>\n",
              "      <td>9.6</td>\n",
              "      <td>53.4</td>\n",
              "      <td>0.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>Iceland</td>\n",
              "      <td>0.268360</td>\n",
              "      <td>0.268360</td>\n",
              "      <td>0.268360</td>\n",
              "      <td>0.268360</td>\n",
              "      <td>0.268360</td>\n",
              "      <td>0.268360</td>\n",
              "      <td>0.268360</td>\n",
              "      <td>0.268360</td>\n",
              "      <td>0.268360</td>\n",
              "      <td>...</td>\n",
              "      <td>3.517032</td>\n",
              "      <td>3.383420</td>\n",
              "      <td>3.253735</td>\n",
              "      <td>3.131512</td>\n",
              "      <td>3.026334</td>\n",
              "      <td>0.0</td>\n",
              "      <td>13.6</td>\n",
              "      <td>8.6</td>\n",
              "      <td>35.6</td>\n",
              "      <td>1.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>Italy</td>\n",
              "      <td>0.310499</td>\n",
              "      <td>0.310499</td>\n",
              "      <td>0.310499</td>\n",
              "      <td>0.350863</td>\n",
              "      <td>0.350863</td>\n",
              "      <td>0.352108</td>\n",
              "      <td>0.352108</td>\n",
              "      <td>0.352108</td>\n",
              "      <td>0.366523</td>\n",
              "      <td>...</td>\n",
              "      <td>3.184651</td>\n",
              "      <td>3.069987</td>\n",
              "      <td>2.988643</td>\n",
              "      <td>2.974641</td>\n",
              "      <td>3.033412</td>\n",
              "      <td>5.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>2.0</td>\n",
              "      <td>50.2</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>Jamaica</td>\n",
              "      <td>0.411137</td>\n",
              "      <td>0.411137</td>\n",
              "      <td>0.411137</td>\n",
              "      <td>0.356734</td>\n",
              "      <td>0.356734</td>\n",
              "      <td>0.356734</td>\n",
              "      <td>0.403949</td>\n",
              "      <td>0.403949</td>\n",
              "      <td>0.403949</td>\n",
              "      <td>...</td>\n",
              "      <td>14.303516</td>\n",
              "      <td>14.345895</td>\n",
              "      <td>14.376972</td>\n",
              "      <td>14.376743</td>\n",
              "      <td>15.704952</td>\n",
              "      <td>1.2</td>\n",
              "      <td>3.8</td>\n",
              "      <td>0.4</td>\n",
              "      <td>6.2</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>Japan</td>\n",
              "      <td>0.348423</td>\n",
              "      <td>0.348423</td>\n",
              "      <td>0.348423</td>\n",
              "      <td>0.348423</td>\n",
              "      <td>0.348423</td>\n",
              "      <td>0.348423</td>\n",
              "      <td>0.348423</td>\n",
              "      <td>0.348423</td>\n",
              "      <td>0.348423</td>\n",
              "      <td>...</td>\n",
              "      <td>3.503874</td>\n",
              "      <td>3.530033</td>\n",
              "      <td>3.585924</td>\n",
              "      <td>3.655633</td>\n",
              "      <td>3.724630</td>\n",
              "      <td>5.2</td>\n",
              "      <td>8.4</td>\n",
              "      <td>4.0</td>\n",
              "      <td>299.6</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>Kazakhstan</td>\n",
              "      <td>0.326657</td>\n",
              "      <td>0.326657</td>\n",
              "      <td>0.326657</td>\n",
              "      <td>0.326657</td>\n",
              "      <td>0.326657</td>\n",
              "      <td>0.326657</td>\n",
              "      <td>0.353783</td>\n",
              "      <td>0.353783</td>\n",
              "      <td>0.353783</td>\n",
              "      <td>...</td>\n",
              "      <td>10.165237</td>\n",
              "      <td>9.974507</td>\n",
              "      <td>9.795454</td>\n",
              "      <td>9.583099</td>\n",
              "      <td>9.329854</td>\n",
              "      <td>3.4</td>\n",
              "      <td>21.8</td>\n",
              "      <td>10.8</td>\n",
              "      <td>2.6</td>\n",
              "      <td>7.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>Latvia</td>\n",
              "      <td>0.269931</td>\n",
              "      <td>0.269931</td>\n",
              "      <td>0.269931</td>\n",
              "      <td>0.269931</td>\n",
              "      <td>0.269931</td>\n",
              "      <td>0.309775</td>\n",
              "      <td>0.315908</td>\n",
              "      <td>0.315908</td>\n",
              "      <td>0.315908</td>\n",
              "      <td>...</td>\n",
              "      <td>7.377818</td>\n",
              "      <td>7.153363</td>\n",
              "      <td>6.877405</td>\n",
              "      <td>6.572459</td>\n",
              "      <td>6.272126</td>\n",
              "      <td>3.6</td>\n",
              "      <td>4.4</td>\n",
              "      <td>3.0</td>\n",
              "      <td>39.0</td>\n",
              "      <td>0.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>Lithuania</td>\n",
              "      <td>0.331838</td>\n",
              "      <td>0.331838</td>\n",
              "      <td>0.331838</td>\n",
              "      <td>0.331838</td>\n",
              "      <td>0.331838</td>\n",
              "      <td>0.331838</td>\n",
              "      <td>0.331838</td>\n",
              "      <td>0.331838</td>\n",
              "      <td>0.331838</td>\n",
              "      <td>...</td>\n",
              "      <td>7.262296</td>\n",
              "      <td>6.972947</td>\n",
              "      <td>6.732347</td>\n",
              "      <td>6.512947</td>\n",
              "      <td>6.307903</td>\n",
              "      <td>1.4</td>\n",
              "      <td>6.2</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.8</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>Luxembourg</td>\n",
              "      <td>0.277019</td>\n",
              "      <td>0.271785</td>\n",
              "      <td>0.273095</td>\n",
              "      <td>0.270479</td>\n",
              "      <td>0.281479</td>\n",
              "      <td>0.283010</td>\n",
              "      <td>0.290434</td>\n",
              "      <td>0.295733</td>\n",
              "      <td>0.306054</td>\n",
              "      <td>...</td>\n",
              "      <td>2.476201</td>\n",
              "      <td>2.425169</td>\n",
              "      <td>2.385864</td>\n",
              "      <td>2.356915</td>\n",
              "      <td>2.332532</td>\n",
              "      <td>2.8</td>\n",
              "      <td>13.8</td>\n",
              "      <td>6.4</td>\n",
              "      <td>24.0</td>\n",
              "      <td>0.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>Mexico</td>\n",
              "      <td>0.523107</td>\n",
              "      <td>0.523107</td>\n",
              "      <td>0.523107</td>\n",
              "      <td>0.523107</td>\n",
              "      <td>0.534223</td>\n",
              "      <td>0.534223</td>\n",
              "      <td>0.519715</td>\n",
              "      <td>0.519715</td>\n",
              "      <td>0.532833</td>\n",
              "      <td>...</td>\n",
              "      <td>13.093819</td>\n",
              "      <td>13.466090</td>\n",
              "      <td>13.649610</td>\n",
              "      <td>13.616869</td>\n",
              "      <td>13.395253</td>\n",
              "      <td>2.2</td>\n",
              "      <td>6.2</td>\n",
              "      <td>1.6</td>\n",
              "      <td>10.2</td>\n",
              "      <td>0.8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>Norway</td>\n",
              "      <td>0.252262</td>\n",
              "      <td>0.252262</td>\n",
              "      <td>0.252262</td>\n",
              "      <td>0.252262</td>\n",
              "      <td>0.252262</td>\n",
              "      <td>0.260196</td>\n",
              "      <td>0.260196</td>\n",
              "      <td>0.260196</td>\n",
              "      <td>0.260196</td>\n",
              "      <td>...</td>\n",
              "      <td>3.814943</td>\n",
              "      <td>3.806814</td>\n",
              "      <td>3.775257</td>\n",
              "      <td>3.716708</td>\n",
              "      <td>3.642233</td>\n",
              "      <td>5.2</td>\n",
              "      <td>2.6</td>\n",
              "      <td>2.0</td>\n",
              "      <td>13.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>Portugal</td>\n",
              "      <td>0.387750</td>\n",
              "      <td>0.387750</td>\n",
              "      <td>0.387750</td>\n",
              "      <td>0.387750</td>\n",
              "      <td>0.387750</td>\n",
              "      <td>0.387750</td>\n",
              "      <td>0.387750</td>\n",
              "      <td>0.387750</td>\n",
              "      <td>0.387750</td>\n",
              "      <td>...</td>\n",
              "      <td>3.605020</td>\n",
              "      <td>3.641104</td>\n",
              "      <td>3.714881</td>\n",
              "      <td>3.823418</td>\n",
              "      <td>3.955557</td>\n",
              "      <td>4.0</td>\n",
              "      <td>31.6</td>\n",
              "      <td>20.8</td>\n",
              "      <td>17.8</td>\n",
              "      <td>2.2</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>Qatar</td>\n",
              "      <td>0.351284</td>\n",
              "      <td>0.351284</td>\n",
              "      <td>0.351284</td>\n",
              "      <td>0.351284</td>\n",
              "      <td>0.351284</td>\n",
              "      <td>0.351284</td>\n",
              "      <td>0.351284</td>\n",
              "      <td>0.351284</td>\n",
              "      <td>0.351284</td>\n",
              "      <td>...</td>\n",
              "      <td>5.384760</td>\n",
              "      <td>5.282038</td>\n",
              "      <td>5.237324</td>\n",
              "      <td>5.237335</td>\n",
              "      <td>5.255728</td>\n",
              "      <td>0.4</td>\n",
              "      <td>3.4</td>\n",
              "      <td>6.6</td>\n",
              "      <td>58.8</td>\n",
              "      <td>4.6</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>Slovenia</td>\n",
              "      <td>0.291178</td>\n",
              "      <td>0.291178</td>\n",
              "      <td>0.291178</td>\n",
              "      <td>0.291178</td>\n",
              "      <td>0.291178</td>\n",
              "      <td>0.291178</td>\n",
              "      <td>0.291178</td>\n",
              "      <td>0.241215</td>\n",
              "      <td>0.241215</td>\n",
              "      <td>...</td>\n",
              "      <td>3.844289</td>\n",
              "      <td>3.658384</td>\n",
              "      <td>3.475961</td>\n",
              "      <td>3.301976</td>\n",
              "      <td>3.142685</td>\n",
              "      <td>1.2</td>\n",
              "      <td>1.2</td>\n",
              "      <td>0.8</td>\n",
              "      <td>72.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>South Africa</td>\n",
              "      <td>0.593339</td>\n",
              "      <td>0.593339</td>\n",
              "      <td>0.593339</td>\n",
              "      <td>0.593339</td>\n",
              "      <td>0.593339</td>\n",
              "      <td>0.593339</td>\n",
              "      <td>0.593339</td>\n",
              "      <td>0.593339</td>\n",
              "      <td>0.593339</td>\n",
              "      <td>...</td>\n",
              "      <td>26.805677</td>\n",
              "      <td>26.444436</td>\n",
              "      <td>26.278210</td>\n",
              "      <td>26.267306</td>\n",
              "      <td>26.386059</td>\n",
              "      <td>1.0</td>\n",
              "      <td>3.6</td>\n",
              "      <td>2.6</td>\n",
              "      <td>7.6</td>\n",
              "      <td>0.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>Spain</td>\n",
              "      <td>0.320232</td>\n",
              "      <td>0.320232</td>\n",
              "      <td>0.320232</td>\n",
              "      <td>0.356585</td>\n",
              "      <td>0.351037</td>\n",
              "      <td>0.357266</td>\n",
              "      <td>0.364646</td>\n",
              "      <td>0.353244</td>\n",
              "      <td>0.345801</td>\n",
              "      <td>...</td>\n",
              "      <td>2.926145</td>\n",
              "      <td>2.900405</td>\n",
              "      <td>2.913855</td>\n",
              "      <td>2.977635</td>\n",
              "      <td>3.057541</td>\n",
              "      <td>4.2</td>\n",
              "      <td>3.4</td>\n",
              "      <td>2.4</td>\n",
              "      <td>14.2</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>Switzerland</td>\n",
              "      <td>0.338549</td>\n",
              "      <td>0.338549</td>\n",
              "      <td>0.338549</td>\n",
              "      <td>0.338549</td>\n",
              "      <td>0.338549</td>\n",
              "      <td>0.338549</td>\n",
              "      <td>0.338549</td>\n",
              "      <td>0.338549</td>\n",
              "      <td>0.338549</td>\n",
              "      <td>...</td>\n",
              "      <td>3.350272</td>\n",
              "      <td>3.354682</td>\n",
              "      <td>3.353295</td>\n",
              "      <td>3.349821</td>\n",
              "      <td>3.337957</td>\n",
              "      <td>2.6</td>\n",
              "      <td>9.2</td>\n",
              "      <td>8.0</td>\n",
              "      <td>109.0</td>\n",
              "      <td>0.4</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>Ukraine</td>\n",
              "      <td>0.297088</td>\n",
              "      <td>0.297088</td>\n",
              "      <td>0.297088</td>\n",
              "      <td>0.289270</td>\n",
              "      <td>0.289270</td>\n",
              "      <td>0.392310</td>\n",
              "      <td>0.351536</td>\n",
              "      <td>0.351536</td>\n",
              "      <td>0.351536</td>\n",
              "      <td>...</td>\n",
              "      <td>7.961024</td>\n",
              "      <td>7.815600</td>\n",
              "      <td>7.859186</td>\n",
              "      <td>8.062059</td>\n",
              "      <td>28.569474</td>\n",
              "      <td>2.0</td>\n",
              "      <td>0.4</td>\n",
              "      <td>1.2</td>\n",
              "      <td>31.4</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>Uruguay</td>\n",
              "      <td>0.459414</td>\n",
              "      <td>0.459414</td>\n",
              "      <td>0.459414</td>\n",
              "      <td>0.459414</td>\n",
              "      <td>0.459414</td>\n",
              "      <td>0.459414</td>\n",
              "      <td>0.459414</td>\n",
              "      <td>0.459414</td>\n",
              "      <td>0.459414</td>\n",
              "      <td>...</td>\n",
              "      <td>10.553494</td>\n",
              "      <td>10.656787</td>\n",
              "      <td>10.779560</td>\n",
              "      <td>10.916725</td>\n",
              "      <td>11.056742</td>\n",
              "      <td>0.4</td>\n",
              "      <td>6.2</td>\n",
              "      <td>1.2</td>\n",
              "      <td>4.2</td>\n",
              "      <td>0.2</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>32 rows × 347 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "         Country  Gini coefficient 1990  Gini coefficient 1991  \\\n",
              "0      Australia               0.325786               0.325786   \n",
              "1        Austria               0.308280               0.308280   \n",
              "2        Belarus               0.320184               0.320184   \n",
              "3         Brazil               0.604500               0.604500   \n",
              "4         Canada               0.313654               0.319434   \n",
              "5          Chile               0.572354               0.572354   \n",
              "6       Colombia               0.513523               0.513523   \n",
              "7        Croatia               0.325537               0.325537   \n",
              "8        Czechia               0.207033               0.207033   \n",
              "9        Denmark               0.246910               0.246910   \n",
              "10       Estonia               0.394273               0.394273   \n",
              "11       Finland               0.228798               0.228798   \n",
              "12        France               0.321191               0.321191   \n",
              "13       Germany               0.294929               0.294929   \n",
              "14       Iceland               0.268360               0.268360   \n",
              "15         Italy               0.310499               0.310499   \n",
              "16       Jamaica               0.411137               0.411137   \n",
              "17         Japan               0.348423               0.348423   \n",
              "18    Kazakhstan               0.326657               0.326657   \n",
              "19        Latvia               0.269931               0.269931   \n",
              "20     Lithuania               0.331838               0.331838   \n",
              "21    Luxembourg               0.277019               0.271785   \n",
              "22        Mexico               0.523107               0.523107   \n",
              "23        Norway               0.252262               0.252262   \n",
              "24      Portugal               0.387750               0.387750   \n",
              "25         Qatar               0.351284               0.351284   \n",
              "26      Slovenia               0.291178               0.291178   \n",
              "27  South Africa               0.593339               0.593339   \n",
              "28         Spain               0.320232               0.320232   \n",
              "29   Switzerland               0.338549               0.338549   \n",
              "30       Ukraine               0.297088               0.297088   \n",
              "31       Uruguay               0.459414               0.459414   \n",
              "\n",
              "    Gini coefficient 1992  Gini coefficient 1993  Gini coefficient 1994  \\\n",
              "0                0.325786               0.325786               0.325786   \n",
              "1                0.308280               0.308280               0.308280   \n",
              "2                0.320184               0.320184               0.320184   \n",
              "3                0.531017               0.600656               0.600656   \n",
              "4                0.315643               0.316759               0.313038   \n",
              "5                0.548065               0.548065               0.564210   \n",
              "6                0.513523               0.513523               0.513523   \n",
              "7                0.325537               0.325537               0.325537   \n",
              "8                0.207033               0.265535               0.265535   \n",
              "9                0.246910               0.246910               0.246910   \n",
              "10               0.394273               0.394273               0.394273   \n",
              "11               0.228798               0.228798               0.228798   \n",
              "12               0.321191               0.321191               0.321191   \n",
              "13               0.290733               0.286121               0.291594   \n",
              "14               0.268360               0.268360               0.268360   \n",
              "15               0.310499               0.350863               0.350863   \n",
              "16               0.411137               0.356734               0.356734   \n",
              "17               0.348423               0.348423               0.348423   \n",
              "18               0.326657               0.326657               0.326657   \n",
              "19               0.269931               0.269931               0.269931   \n",
              "20               0.331838               0.331838               0.331838   \n",
              "21               0.273095               0.270479               0.281479   \n",
              "22               0.523107               0.523107               0.534223   \n",
              "23               0.252262               0.252262               0.252262   \n",
              "24               0.387750               0.387750               0.387750   \n",
              "25               0.351284               0.351284               0.351284   \n",
              "26               0.291178               0.291178               0.291178   \n",
              "27               0.593339               0.593339               0.593339   \n",
              "28               0.320232               0.356585               0.351037   \n",
              "29               0.338549               0.338549               0.338549   \n",
              "30               0.297088               0.289270               0.289270   \n",
              "31               0.459414               0.459414               0.459414   \n",
              "\n",
              "    Gini coefficient 1995  Gini coefficient 1996  Gini coefficient 1997  \\\n",
              "0                0.325786               0.325786               0.325786   \n",
              "1                0.299143               0.293178               0.290654   \n",
              "2                0.320184               0.320184               0.320184   \n",
              "3                0.595304               0.598373               0.597537   \n",
              "4                0.315096               0.327681               0.331169   \n",
              "5                0.564210               0.548688               0.548688   \n",
              "6                0.513523               0.567805               0.567805   \n",
              "7                0.325537               0.325537               0.325537   \n",
              "8                0.265535               0.257990               0.257990   \n",
              "9                0.229559               0.229559               0.229559   \n",
              "10               0.394273               0.394273               0.394273   \n",
              "11               0.234591               0.234591               0.234591   \n",
              "12               0.321191               0.320166               0.319001   \n",
              "13               0.288113               0.279938               0.282467   \n",
              "14               0.268360               0.268360               0.268360   \n",
              "15               0.352108               0.352108               0.352108   \n",
              "16               0.356734               0.403949               0.403949   \n",
              "17               0.348423               0.348423               0.348423   \n",
              "18               0.326657               0.353783               0.353783   \n",
              "19               0.309775               0.315908               0.315908   \n",
              "20               0.331838               0.331838               0.331838   \n",
              "21               0.283010               0.290434               0.295733   \n",
              "22               0.534223               0.519715               0.519715   \n",
              "23               0.260196               0.260196               0.260196   \n",
              "24               0.387750               0.387750               0.387750   \n",
              "25               0.351284               0.351284               0.351284   \n",
              "26               0.291178               0.291178               0.241215   \n",
              "27               0.593339               0.593339               0.593339   \n",
              "28               0.357266               0.364646               0.353244   \n",
              "29               0.338549               0.338549               0.338549   \n",
              "30               0.392310               0.351536               0.351536   \n",
              "31               0.459414               0.459414               0.459414   \n",
              "\n",
              "    Gini coefficient 1998  ...  2018 Mortality  2019 Mortality  \\\n",
              "0                0.325786  ...        4.496637        4.534294   \n",
              "1                0.313408  ...        3.921898        3.933814   \n",
              "2                0.320184  ...        5.749728        5.401263   \n",
              "3                0.595654  ...       15.990706       15.526359   \n",
              "4                0.332172  ...        5.549870        5.583710   \n",
              "5                0.555167  ...        6.807043        6.842064   \n",
              "6                0.567805  ...       13.668761       13.711564   \n",
              "7                0.325537  ...        4.913303        5.027645   \n",
              "8                0.257990  ...        4.668561        4.629072   \n",
              "9                0.229559  ...        3.032260        3.035299   \n",
              "10               0.394273  ...        5.453301        5.101544   \n",
              "11               0.234591  ...        5.311350        5.448363   \n",
              "12               0.316578  ...        3.740644        3.696873   \n",
              "13               0.282704  ...        3.422374        3.389413   \n",
              "14               0.268360  ...        3.517032        3.383420   \n",
              "15               0.366523  ...        3.184651        3.069987   \n",
              "16               0.403949  ...       14.303516       14.345895   \n",
              "17               0.348423  ...        3.503874        3.530033   \n",
              "18               0.353783  ...       10.165237        9.974507   \n",
              "19               0.315908  ...        7.377818        7.153363   \n",
              "20               0.331838  ...        7.262296        6.972947   \n",
              "21               0.306054  ...        2.476201        2.425169   \n",
              "22               0.532833  ...       13.093819       13.466090   \n",
              "23               0.260196  ...        3.814943        3.806814   \n",
              "24               0.387750  ...        3.605020        3.641104   \n",
              "25               0.351284  ...        5.384760        5.282038   \n",
              "26               0.241215  ...        3.844289        3.658384   \n",
              "27               0.593339  ...       26.805677       26.444436   \n",
              "28               0.345801  ...        2.926145        2.900405   \n",
              "29               0.338549  ...        3.350272        3.354682   \n",
              "30               0.351536  ...        7.961024        7.815600   \n",
              "31               0.459414  ...       10.553494       10.656787   \n",
              "\n",
              "    2020 Mortality  2021 Mortality  2022 Mortality  Average Power Line  \\\n",
              "0         4.541600        4.505020        4.419226                 8.0   \n",
              "1         3.986880        4.072674        4.178208                 3.4   \n",
              "2         5.140058        4.960482        4.841156                 2.2   \n",
              "3        15.132572       14.805685       14.545867                 1.8   \n",
              "4         5.690650        5.914808        6.163911                 2.4   \n",
              "5         6.916595        6.989901        7.015981                 3.4   \n",
              "6        13.856109       14.112707       14.453973                 7.2   \n",
              "7         5.155426        5.274027        5.360567                 1.4   \n",
              "8         4.607017        4.612386        4.643248                 9.8   \n",
              "9         3.044604        3.055999        3.070977                 1.8   \n",
              "10        4.792426        4.533591        4.355332                 1.2   \n",
              "11        5.478113        5.407742        5.272486                 1.6   \n",
              "12        3.654224        3.613443        3.569938                 1.6   \n",
              "13        3.387469        3.425392        3.497733                 1.8   \n",
              "14        3.253735        3.131512        3.026334                 0.0   \n",
              "15        2.988643        2.974641        3.033412                 5.0   \n",
              "16       14.376972       14.376743       15.704952                 1.2   \n",
              "17        3.585924        3.655633        3.724630                 5.2   \n",
              "18        9.795454        9.583099        9.329854                 3.4   \n",
              "19        6.877405        6.572459        6.272126                 3.6   \n",
              "20        6.732347        6.512947        6.307903                 1.4   \n",
              "21        2.385864        2.356915        2.332532                 2.8   \n",
              "22       13.649610       13.616869       13.395253                 2.2   \n",
              "23        3.775257        3.716708        3.642233                 5.2   \n",
              "24        3.714881        3.823418        3.955557                 4.0   \n",
              "25        5.237324        5.237335        5.255728                 0.4   \n",
              "26        3.475961        3.301976        3.142685                 1.2   \n",
              "27       26.278210       26.267306       26.386059                 1.0   \n",
              "28        2.913855        2.977635        3.057541                 4.2   \n",
              "29        3.353295        3.349821        3.337957                 2.6   \n",
              "30        7.859186        8.062059       28.569474                 2.0   \n",
              "31       10.779560       10.916725       11.056742                 0.4   \n",
              "\n",
              "    Average Schools  Average Supermarkets  Average Public Roads  \\\n",
              "0              16.0                  10.8                  69.8   \n",
              "1              15.6                  10.2                  45.0   \n",
              "2              12.0                   1.2                  24.4   \n",
              "3               3.8                   2.8                  18.4   \n",
              "4              20.8                  11.0                  11.4   \n",
              "5              95.8                  14.8                  32.0   \n",
              "6              25.4                  27.6                  15.8   \n",
              "7               0.6                   0.6                   8.0   \n",
              "8               5.4                   1.6                   9.0   \n",
              "9              18.4                  14.0                  69.2   \n",
              "10             11.0                   5.6                  25.4   \n",
              "11              3.6                   1.0                  24.6   \n",
              "12              3.0                   0.4                  34.0   \n",
              "13             21.2                   9.6                  53.4   \n",
              "14             13.6                   8.6                  35.6   \n",
              "15              3.0                   2.0                  50.2   \n",
              "16              3.8                   0.4                   6.2   \n",
              "17              8.4                   4.0                 299.6   \n",
              "18             21.8                  10.8                   2.6   \n",
              "19              4.4                   3.0                  39.0   \n",
              "20              6.2                   4.0                   4.8   \n",
              "21             13.8                   6.4                  24.0   \n",
              "22              6.2                   1.6                  10.2   \n",
              "23              2.6                   2.0                  13.0   \n",
              "24             31.6                  20.8                  17.8   \n",
              "25              3.4                   6.6                  58.8   \n",
              "26              1.2                   0.8                  72.0   \n",
              "27              3.6                   2.6                   7.6   \n",
              "28              3.4                   2.4                  14.2   \n",
              "29              9.2                   8.0                 109.0   \n",
              "30              0.4                   1.2                  31.4   \n",
              "31              6.2                   1.2                   4.2   \n",
              "\n",
              "    Average Hospitals  \n",
              "0                 1.8  \n",
              "1                 1.0  \n",
              "2                 1.0  \n",
              "3                 0.6  \n",
              "4                 0.4  \n",
              "5                 1.4  \n",
              "6                 3.6  \n",
              "7                 0.0  \n",
              "8                 0.4  \n",
              "9                 2.8  \n",
              "10                0.4  \n",
              "11                0.2  \n",
              "12                0.4  \n",
              "13                0.8  \n",
              "14                1.8  \n",
              "15                0.0  \n",
              "16                0.0  \n",
              "17                1.0  \n",
              "18                7.0  \n",
              "19                0.4  \n",
              "20                0.0  \n",
              "21                0.2  \n",
              "22                0.8  \n",
              "23                0.0  \n",
              "24                2.2  \n",
              "25                4.6  \n",
              "26                0.0  \n",
              "27                0.4  \n",
              "28                0.0  \n",
              "29                0.4  \n",
              "30                1.0  \n",
              "31                0.2  \n",
              "\n",
              "[32 rows x 347 columns]"
            ]
          },
          "execution_count": 81,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "\n",
        "combined_df = pd.merge(combined_df_wo_infra, df_infra, how=\"inner\", on=\"Country\")\n",
        "combined_df\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 82,
      "metadata": {},
      "outputs": [],
      "source": [
        "\n",
        "\n",
        "# Export to CSV\n",
        "combined_df.to_csv(\"./datasets/combined_df.csv\", index=False)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {},
      "outputs": [],
      "source": []
    }
  ],
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "display_name": "Python 3",
      "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.12.8"
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}