SamplingFDS (2).ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "execution_count": 5,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 522
        },
        "id": "YezwfHLC7Lvs",
        "outputId": "6f9b24b0-b335-47a9-fd0d-e39ec2aadcda"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "595.803\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      Unnamed: 0  Unnamed: 0.1 iso_code      country  year     co2  \\\n",
              "0              0            52      AFG  Afghanistan  2001   0.798   \n",
              "1            247            53      AFG  Afghanistan  2002   1.052   \n",
              "2            494            54      AFG  Afghanistan  2003   1.186   \n",
              "3            741            55      AFG  Afghanistan  2004   0.889   \n",
              "4            988            56      AFG  Afghanistan  2005   1.303   \n",
              "...          ...           ...      ...          ...   ...     ...   \n",
              "4946        3960         25984      ZWE     Zimbabwe  2016  10.738   \n",
              "4947        4208         25985      ZWE     Zimbabwe  2017   9.582   \n",
              "4948        4456         25986      ZWE     Zimbabwe  2018  11.854   \n",
              "4949        4703         25987      ZWE     Zimbabwe  2019  10.949   \n",
              "4950        4950         25988      ZWE     Zimbabwe  2020  10.531   \n",
              "\n",
              "      co2_per_capita  trade_co2  cement_co2  cement_co2_per_capita  ...  \\\n",
              "0              0.037      2.605       0.007                  0.000  ...   \n",
              "1              0.046      2.605       0.011                  0.000  ...   \n",
              "2              0.050      2.605       0.010                  0.000  ...   \n",
              "3              0.036      2.605       0.010                  0.000  ...   \n",
              "4              0.051      2.605       0.006                  0.000  ...   \n",
              "...              ...        ...         ...                    ...  ...   \n",
              "4946           0.765      1.415       0.639                  0.046  ...   \n",
              "4947           0.673      1.666       0.678                  0.048  ...   \n",
              "4948           0.821      1.308       0.697                  0.048  ...   \n",
              "4949           0.748      1.473       0.697                  0.048  ...   \n",
              "4950           0.709      2.605       0.697                  0.047  ...   \n",
              "\n",
              "      ghg_excluding_lucf_per_capita  methane  methane_per_capita  \\\n",
              "0                             0.624    9.360               0.433   \n",
              "1                             0.712   11.190               0.495   \n",
              "2                             0.709   11.480               0.485   \n",
              "3                             0.668   11.460               0.463   \n",
              "4                             0.678   11.670               0.455   \n",
              "...                             ...      ...                 ...   \n",
              "4946                          2.076   11.500               0.820   \n",
              "4947                          2.023   11.620               0.816   \n",
              "4948                          2.173   11.960               0.828   \n",
              "4949                          4.632    8.585               1.013   \n",
              "4950                          4.632    8.585               1.013   \n",
              "\n",
              "      nitrous_oxide  nitrous_oxide_per_capita  population           gdp  \\\n",
              "0             3.220                     0.149  21606992.0  1.102127e+10   \n",
              "1             3.700                     0.164  22600774.0  1.880487e+10   \n",
              "2             3.840                     0.162  23680871.0  2.107434e+10   \n",
              "3             3.810                     0.154  24726689.0  2.233257e+10   \n",
              "4             3.970                     0.155  25654274.0  2.539769e+10   \n",
              "...             ...                       ...         ...           ...   \n",
              "4946          6.210                     0.443  14030338.0  2.096179e+10   \n",
              "4947          6.350                     0.446  14236599.0  2.194784e+10   \n",
              "4948          6.590                     0.456  14438812.0  2.271535e+10   \n",
              "4949          3.515                     0.370  14645473.0  7.540152e+10   \n",
              "4950          3.515                     0.370  14862927.0  7.540152e+10   \n",
              "\n",
              "      primary_energy_consumption  energy_per_capita  energy_per_gdp  \n",
              "0                          4.664            215.860           0.423  \n",
              "1                          4.428            195.930           0.235  \n",
              "2                          5.208            219.910           0.247  \n",
              "3                          4.810            194.542           0.215  \n",
              "4                          6.153            239.855           0.242  \n",
              "...                          ...                ...             ...  \n",
              "4946                      46.666           3326.073           2.226  \n",
              "4947                      45.936           3226.617           2.093  \n",
              "4948                      47.502           3289.887           2.091  \n",
              "4949                      49.427           3374.877           1.168  \n",
              "4950                      54.680          15333.018           1.168  \n",
              "\n",
              "[4951 rows x 62 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-16ca041d-a430-44f5-b521-78e8ec6d9ef4\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Unnamed: 0</th>\n",
              "      <th>Unnamed: 0.1</th>\n",
              "      <th>iso_code</th>\n",
              "      <th>country</th>\n",
              "      <th>year</th>\n",
              "      <th>co2</th>\n",
              "      <th>co2_per_capita</th>\n",
              "      <th>trade_co2</th>\n",
              "      <th>cement_co2</th>\n",
              "      <th>cement_co2_per_capita</th>\n",
              "      <th>...</th>\n",
              "      <th>ghg_excluding_lucf_per_capita</th>\n",
              "      <th>methane</th>\n",
              "      <th>methane_per_capita</th>\n",
              "      <th>nitrous_oxide</th>\n",
              "      <th>nitrous_oxide_per_capita</th>\n",
              "      <th>population</th>\n",
              "      <th>gdp</th>\n",
              "      <th>primary_energy_consumption</th>\n",
              "      <th>energy_per_capita</th>\n",
              "      <th>energy_per_gdp</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>52</td>\n",
              "      <td>AFG</td>\n",
              "      <td>Afghanistan</td>\n",
              "      <td>2001</td>\n",
              "      <td>0.798</td>\n",
              "      <td>0.037</td>\n",
              "      <td>2.605</td>\n",
              "      <td>0.007</td>\n",
              "      <td>0.000</td>\n",
              "      <td>...</td>\n",
              "      <td>0.624</td>\n",
              "      <td>9.360</td>\n",
              "      <td>0.433</td>\n",
              "      <td>3.220</td>\n",
              "      <td>0.149</td>\n",
              "      <td>21606992.0</td>\n",
              "      <td>1.102127e+10</td>\n",
              "      <td>4.664</td>\n",
              "      <td>215.860</td>\n",
              "      <td>0.423</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>247</td>\n",
              "      <td>53</td>\n",
              "      <td>AFG</td>\n",
              "      <td>Afghanistan</td>\n",
              "      <td>2002</td>\n",
              "      <td>1.052</td>\n",
              "      <td>0.046</td>\n",
              "      <td>2.605</td>\n",
              "      <td>0.011</td>\n",
              "      <td>0.000</td>\n",
              "      <td>...</td>\n",
              "      <td>0.712</td>\n",
              "      <td>11.190</td>\n",
              "      <td>0.495</td>\n",
              "      <td>3.700</td>\n",
              "      <td>0.164</td>\n",
              "      <td>22600774.0</td>\n",
              "      <td>1.880487e+10</td>\n",
              "      <td>4.428</td>\n",
              "      <td>195.930</td>\n",
              "      <td>0.235</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>494</td>\n",
              "      <td>54</td>\n",
              "      <td>AFG</td>\n",
              "      <td>Afghanistan</td>\n",
              "      <td>2003</td>\n",
              "      <td>1.186</td>\n",
              "      <td>0.050</td>\n",
              "      <td>2.605</td>\n",
              "      <td>0.010</td>\n",
              "      <td>0.000</td>\n",
              "      <td>...</td>\n",
              "      <td>0.709</td>\n",
              "      <td>11.480</td>\n",
              "      <td>0.485</td>\n",
              "      <td>3.840</td>\n",
              "      <td>0.162</td>\n",
              "      <td>23680871.0</td>\n",
              "      <td>2.107434e+10</td>\n",
              "      <td>5.208</td>\n",
              "      <td>219.910</td>\n",
              "      <td>0.247</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>741</td>\n",
              "      <td>55</td>\n",
              "      <td>AFG</td>\n",
              "      <td>Afghanistan</td>\n",
              "      <td>2004</td>\n",
              "      <td>0.889</td>\n",
              "      <td>0.036</td>\n",
              "      <td>2.605</td>\n",
              "      <td>0.010</td>\n",
              "      <td>0.000</td>\n",
              "      <td>...</td>\n",
              "      <td>0.668</td>\n",
              "      <td>11.460</td>\n",
              "      <td>0.463</td>\n",
              "      <td>3.810</td>\n",
              "      <td>0.154</td>\n",
              "      <td>24726689.0</td>\n",
              "      <td>2.233257e+10</td>\n",
              "      <td>4.810</td>\n",
              "      <td>194.542</td>\n",
              "      <td>0.215</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>988</td>\n",
              "      <td>56</td>\n",
              "      <td>AFG</td>\n",
              "      <td>Afghanistan</td>\n",
              "      <td>2005</td>\n",
              "      <td>1.303</td>\n",
              "      <td>0.051</td>\n",
              "      <td>2.605</td>\n",
              "      <td>0.006</td>\n",
              "      <td>0.000</td>\n",
              "      <td>...</td>\n",
              "      <td>0.678</td>\n",
              "      <td>11.670</td>\n",
              "      <td>0.455</td>\n",
              "      <td>3.970</td>\n",
              "      <td>0.155</td>\n",
              "      <td>25654274.0</td>\n",
              "      <td>2.539769e+10</td>\n",
              "      <td>6.153</td>\n",
              "      <td>239.855</td>\n",
              "      <td>0.242</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>4946</th>\n",
              "      <td>3960</td>\n",
              "      <td>25984</td>\n",
              "      <td>ZWE</td>\n",
              "      <td>Zimbabwe</td>\n",
              "      <td>2016</td>\n",
              "      <td>10.738</td>\n",
              "      <td>0.765</td>\n",
              "      <td>1.415</td>\n",
              "      <td>0.639</td>\n",
              "      <td>0.046</td>\n",
              "      <td>...</td>\n",
              "      <td>2.076</td>\n",
              "      <td>11.500</td>\n",
              "      <td>0.820</td>\n",
              "      <td>6.210</td>\n",
              "      <td>0.443</td>\n",
              "      <td>14030338.0</td>\n",
              "      <td>2.096179e+10</td>\n",
              "      <td>46.666</td>\n",
              "      <td>3326.073</td>\n",
              "      <td>2.226</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4947</th>\n",
              "      <td>4208</td>\n",
              "      <td>25985</td>\n",
              "      <td>ZWE</td>\n",
              "      <td>Zimbabwe</td>\n",
              "      <td>2017</td>\n",
              "      <td>9.582</td>\n",
              "      <td>0.673</td>\n",
              "      <td>1.666</td>\n",
              "      <td>0.678</td>\n",
              "      <td>0.048</td>\n",
              "      <td>...</td>\n",
              "      <td>2.023</td>\n",
              "      <td>11.620</td>\n",
              "      <td>0.816</td>\n",
              "      <td>6.350</td>\n",
              "      <td>0.446</td>\n",
              "      <td>14236599.0</td>\n",
              "      <td>2.194784e+10</td>\n",
              "      <td>45.936</td>\n",
              "      <td>3226.617</td>\n",
              "      <td>2.093</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4948</th>\n",
              "      <td>4456</td>\n",
              "      <td>25986</td>\n",
              "      <td>ZWE</td>\n",
              "      <td>Zimbabwe</td>\n",
              "      <td>2018</td>\n",
              "      <td>11.854</td>\n",
              "      <td>0.821</td>\n",
              "      <td>1.308</td>\n",
              "      <td>0.697</td>\n",
              "      <td>0.048</td>\n",
              "      <td>...</td>\n",
              "      <td>2.173</td>\n",
              "      <td>11.960</td>\n",
              "      <td>0.828</td>\n",
              "      <td>6.590</td>\n",
              "      <td>0.456</td>\n",
              "      <td>14438812.0</td>\n",
              "      <td>2.271535e+10</td>\n",
              "      <td>47.502</td>\n",
              "      <td>3289.887</td>\n",
              "      <td>2.091</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4949</th>\n",
              "      <td>4703</td>\n",
              "      <td>25987</td>\n",
              "      <td>ZWE</td>\n",
              "      <td>Zimbabwe</td>\n",
              "      <td>2019</td>\n",
              "      <td>10.949</td>\n",
              "      <td>0.748</td>\n",
              "      <td>1.473</td>\n",
              "      <td>0.697</td>\n",
              "      <td>0.048</td>\n",
              "      <td>...</td>\n",
              "      <td>4.632</td>\n",
              "      <td>8.585</td>\n",
              "      <td>1.013</td>\n",
              "      <td>3.515</td>\n",
              "      <td>0.370</td>\n",
              "      <td>14645473.0</td>\n",
              "      <td>7.540152e+10</td>\n",
              "      <td>49.427</td>\n",
              "      <td>3374.877</td>\n",
              "      <td>1.168</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4950</th>\n",
              "      <td>4950</td>\n",
              "      <td>25988</td>\n",
              "      <td>ZWE</td>\n",
              "      <td>Zimbabwe</td>\n",
              "      <td>2020</td>\n",
              "      <td>10.531</td>\n",
              "      <td>0.709</td>\n",
              "      <td>2.605</td>\n",
              "      <td>0.697</td>\n",
              "      <td>0.047</td>\n",
              "      <td>...</td>\n",
              "      <td>4.632</td>\n",
              "      <td>8.585</td>\n",
              "      <td>1.013</td>\n",
              "      <td>3.515</td>\n",
              "      <td>0.370</td>\n",
              "      <td>14862927.0</td>\n",
              "      <td>7.540152e+10</td>\n",
              "      <td>54.680</td>\n",
              "      <td>15333.018</td>\n",
              "      <td>1.168</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>4951 rows × 62 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-16ca041d-a430-44f5-b521-78e8ec6d9ef4')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-16ca041d-a430-44f5-b521-78e8ec6d9ef4 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-16ca041d-a430-44f5-b521-78e8ec6d9ef4');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ],
      "source": [
        "import numpy as np\n",
        "import pandas as pd\n",
        "\n",
        "np.random.seed(42)\n",
        "\n",
        "data = pd.read_csv('/content/median_fillna.csv.xls')\n",
        "data\n",
        "\n",
        "real_mean = round(df['co2'].mean(),3)\n",
        "print(real_mean)\n",
        "df"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "simple_random_sample = df.sample(n=4).sort_values(by='iso_code')\n",
        "simple_random_mean = round(simple_random_sample['co2'].mean(),3)\n",
        "print(simple_random_mean)\n",
        "simple_random_sample"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 303
        },
        "id": "Sy4WxpdV8SyV",
        "outputId": "ebb977c4-63ca-4fe7-fe1c-cc6575bdc721"
      },
      "execution_count": 6,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "6.785\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      Unnamed: 0  Unnamed: 0.1 iso_code    country  year     co2  \\\n",
              "230         2484          1043      ABW      Aruba  2011   2.499   \n",
              "1371        3285          6873      EST    Estonia  2014  18.885   \n",
              "1957        4800         10413      HTI      Haiti  2020   2.920   \n",
              "3464        3390         18084      PSE  Palestine  2014   2.836   \n",
              "\n",
              "      co2_per_capita  trade_co2  cement_co2  cement_co2_per_capita  ...  \\\n",
              "230           24.486      2.605       1.341                  0.118  ...   \n",
              "1371          14.348     -0.849       0.422                  0.320  ...   \n",
              "1957           0.256      2.605       0.078                  0.007  ...   \n",
              "3464           0.640      2.605       1.341                  0.118  ...   \n",
              "\n",
              "      ghg_excluding_lucf_per_capita  methane  methane_per_capita  \\\n",
              "230                           4.632    8.585               1.013   \n",
              "1371                         15.605    1.130               0.858   \n",
              "1957                          4.632    8.585               1.013   \n",
              "3464                          4.632    8.585               1.013   \n",
              "\n",
              "      nitrous_oxide  nitrous_oxide_per_capita  population           gdp  \\\n",
              "230           3.515                     0.370    102050.0  7.540152e+10   \n",
              "1371          1.370                     1.041   1316273.0  3.103787e+10   \n",
              "1957          3.515                     0.370  11402533.0  7.540152e+10   \n",
              "3464          3.515                     0.370   4428634.0  2.108459e+10   \n",
              "\n",
              "      primary_energy_consumption  energy_per_capita  energy_per_gdp  \n",
              "230                        4.262          41768.622           1.168  \n",
              "1371                      75.257          57173.987           2.425  \n",
              "1957                      54.680          15333.018           1.168  \n",
              "3464                      16.496           3724.822           0.782  \n",
              "\n",
              "[4 rows x 62 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-0e3a7b68-7cb6-4431-b16d-e563f609d81b\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Unnamed: 0</th>\n",
              "      <th>Unnamed: 0.1</th>\n",
              "      <th>iso_code</th>\n",
              "      <th>country</th>\n",
              "      <th>year</th>\n",
              "      <th>co2</th>\n",
              "      <th>co2_per_capita</th>\n",
              "      <th>trade_co2</th>\n",
              "      <th>cement_co2</th>\n",
              "      <th>cement_co2_per_capita</th>\n",
              "      <th>...</th>\n",
              "      <th>ghg_excluding_lucf_per_capita</th>\n",
              "      <th>methane</th>\n",
              "      <th>methane_per_capita</th>\n",
              "      <th>nitrous_oxide</th>\n",
              "      <th>nitrous_oxide_per_capita</th>\n",
              "      <th>population</th>\n",
              "      <th>gdp</th>\n",
              "      <th>primary_energy_consumption</th>\n",
              "      <th>energy_per_capita</th>\n",
              "      <th>energy_per_gdp</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>230</th>\n",
              "      <td>2484</td>\n",
              "      <td>1043</td>\n",
              "      <td>ABW</td>\n",
              "      <td>Aruba</td>\n",
              "      <td>2011</td>\n",
              "      <td>2.499</td>\n",
              "      <td>24.486</td>\n",
              "      <td>2.605</td>\n",
              "      <td>1.341</td>\n",
              "      <td>0.118</td>\n",
              "      <td>...</td>\n",
              "      <td>4.632</td>\n",
              "      <td>8.585</td>\n",
              "      <td>1.013</td>\n",
              "      <td>3.515</td>\n",
              "      <td>0.370</td>\n",
              "      <td>102050.0</td>\n",
              "      <td>7.540152e+10</td>\n",
              "      <td>4.262</td>\n",
              "      <td>41768.622</td>\n",
              "      <td>1.168</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1371</th>\n",
              "      <td>3285</td>\n",
              "      <td>6873</td>\n",
              "      <td>EST</td>\n",
              "      <td>Estonia</td>\n",
              "      <td>2014</td>\n",
              "      <td>18.885</td>\n",
              "      <td>14.348</td>\n",
              "      <td>-0.849</td>\n",
              "      <td>0.422</td>\n",
              "      <td>0.320</td>\n",
              "      <td>...</td>\n",
              "      <td>15.605</td>\n",
              "      <td>1.130</td>\n",
              "      <td>0.858</td>\n",
              "      <td>1.370</td>\n",
              "      <td>1.041</td>\n",
              "      <td>1316273.0</td>\n",
              "      <td>3.103787e+10</td>\n",
              "      <td>75.257</td>\n",
              "      <td>57173.987</td>\n",
              "      <td>2.425</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1957</th>\n",
              "      <td>4800</td>\n",
              "      <td>10413</td>\n",
              "      <td>HTI</td>\n",
              "      <td>Haiti</td>\n",
              "      <td>2020</td>\n",
              "      <td>2.920</td>\n",
              "      <td>0.256</td>\n",
              "      <td>2.605</td>\n",
              "      <td>0.078</td>\n",
              "      <td>0.007</td>\n",
              "      <td>...</td>\n",
              "      <td>4.632</td>\n",
              "      <td>8.585</td>\n",
              "      <td>1.013</td>\n",
              "      <td>3.515</td>\n",
              "      <td>0.370</td>\n",
              "      <td>11402533.0</td>\n",
              "      <td>7.540152e+10</td>\n",
              "      <td>54.680</td>\n",
              "      <td>15333.018</td>\n",
              "      <td>1.168</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3464</th>\n",
              "      <td>3390</td>\n",
              "      <td>18084</td>\n",
              "      <td>PSE</td>\n",
              "      <td>Palestine</td>\n",
              "      <td>2014</td>\n",
              "      <td>2.836</td>\n",
              "      <td>0.640</td>\n",
              "      <td>2.605</td>\n",
              "      <td>1.341</td>\n",
              "      <td>0.118</td>\n",
              "      <td>...</td>\n",
              "      <td>4.632</td>\n",
              "      <td>8.585</td>\n",
              "      <td>1.013</td>\n",
              "      <td>3.515</td>\n",
              "      <td>0.370</td>\n",
              "      <td>4428634.0</td>\n",
              "      <td>2.108459e+10</td>\n",
              "      <td>16.496</td>\n",
              "      <td>3724.822</td>\n",
              "      <td>0.782</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>4 rows × 62 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-0e3a7b68-7cb6-4431-b16d-e563f609d81b')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-0e3a7b68-7cb6-4431-b16d-e563f609d81b button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-0e3a7b68-7cb6-4431-b16d-e563f609d81b');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "def systematic_sampling(data, step):\n",
        "    \n",
        "    indexes = np.arange(0,len(data),step=step)\n",
        "    systematic_sample = data.iloc[indexes]\n",
        "    return systematic_sample\n",
        "    \n",
        "systematic_sample = systematic_sampling(data, 3)\n",
        "\n",
        "systematic_mean = round(systematic_sample['co2'].mean(),3)\n",
        "\n",
        "systematic_sample"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 505
        },
        "id": "Jb358G3M8xDA",
        "outputId": "9810392e-b096-4c45-9eae-80f11e2b5bdc"
      },
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "      Unnamed: 0  Unnamed: 0.1 iso_code      country  year     co2  \\\n",
              "0              0            52      AFG  Afghanistan  2001   0.798   \n",
              "3            741            55      AFG  Afghanistan  2004   0.889   \n",
              "6           1482            58      AFG  Afghanistan  2007   2.269   \n",
              "9           2225            61      AFG  Afghanistan  2010   8.398   \n",
              "12          2969            64      AFG  Afghanistan  2013   8.441   \n",
              "...          ...           ...      ...          ...   ...     ...   \n",
              "4938        1976         25976      ZWE     Zimbabwe  2008   7.720   \n",
              "4941        2720         25979      ZWE     Zimbabwe  2011   9.744   \n",
              "4944        3464         25982      ZWE     Zimbabwe  2014  11.906   \n",
              "4947        4208         25985      ZWE     Zimbabwe  2017   9.582   \n",
              "4950        4950         25988      ZWE     Zimbabwe  2020  10.531   \n",
              "\n",
              "      co2_per_capita  trade_co2  cement_co2  cement_co2_per_capita  ...  \\\n",
              "0              0.037      2.605       0.007                  0.000  ...   \n",
              "3              0.036      2.605       0.010                  0.000  ...   \n",
              "6              0.084      2.605       0.012                  0.000  ...   \n",
              "9              0.288      2.605       0.015                  0.000  ...   \n",
              "12             0.262      2.605       0.036                  0.001  ...   \n",
              "...              ...        ...         ...                    ...  ...   \n",
              "4938           0.624      1.575       0.154                  0.012  ...   \n",
              "4941           0.756      1.046       0.382                  0.030  ...   \n",
              "4944           0.876      1.261       0.496                  0.036  ...   \n",
              "4947           0.673      1.666       0.678                  0.048  ...   \n",
              "4950           0.709      2.605       0.697                  0.047  ...   \n",
              "\n",
              "      ghg_excluding_lucf_per_capita  methane  methane_per_capita  \\\n",
              "0                             0.624    9.360               0.433   \n",
              "3                             0.668   11.460               0.463   \n",
              "6                             0.918   18.100               0.668   \n",
              "9                             1.539   30.010               1.028   \n",
              "12                            2.318   58.130               1.801   \n",
              "...                             ...      ...                 ...   \n",
              "4938                          1.951   10.560               0.853   \n",
              "4941                          2.369   11.900               0.923   \n",
              "4944                          2.160   10.900               0.802   \n",
              "4947                          2.023   11.620               0.816   \n",
              "4950                          4.632    8.585               1.013   \n",
              "\n",
              "      nitrous_oxide  nitrous_oxide_per_capita  population           gdp  \\\n",
              "0             3.220                     0.149  21606992.0  1.102127e+10   \n",
              "3             3.810                     0.154  24726689.0  2.233257e+10   \n",
              "6             4.250                     0.157  27100542.0  3.450753e+10   \n",
              "9             5.990                     0.205  29185511.0  4.739942e+10   \n",
              "12            7.720                     0.239  32269592.0  6.299370e+10   \n",
              "...             ...                       ...         ...           ...   \n",
              "4938          5.970                     0.482  12379553.0  1.505022e+10   \n",
              "4941          6.950                     0.539  12894323.0  1.955407e+10   \n",
              "4944          5.930                     0.436  13586710.0  2.122250e+10   \n",
              "4947          6.350                     0.446  14236599.0  2.194784e+10   \n",
              "4950          3.515                     0.370  14862927.0  7.540152e+10   \n",
              "\n",
              "      primary_energy_consumption  energy_per_capita  energy_per_gdp  \n",
              "0                          4.664            215.860           0.423  \n",
              "3                          4.810            194.542           0.215  \n",
              "6                         10.039            370.438           0.291  \n",
              "9                         34.740           1190.324           0.733  \n",
              "12                        36.489           1130.743           0.579  \n",
              "...                          ...                ...             ...  \n",
              "4938                      41.728           3370.733           2.773  \n",
              "4941                      50.290           3900.153           2.572  \n",
              "4944                      54.604           4018.925           2.573  \n",
              "4947                      45.936           3226.617           2.093  \n",
              "4950                      54.680          15333.018           1.168  \n",
              "\n",
              "[1651 rows x 62 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-9331f8b0-f785-4ab8-938f-7486371b9ec2\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Unnamed: 0</th>\n",
              "      <th>Unnamed: 0.1</th>\n",
              "      <th>iso_code</th>\n",
              "      <th>country</th>\n",
              "      <th>year</th>\n",
              "      <th>co2</th>\n",
              "      <th>co2_per_capita</th>\n",
              "      <th>trade_co2</th>\n",
              "      <th>cement_co2</th>\n",
              "      <th>cement_co2_per_capita</th>\n",
              "      <th>...</th>\n",
              "      <th>ghg_excluding_lucf_per_capita</th>\n",
              "      <th>methane</th>\n",
              "      <th>methane_per_capita</th>\n",
              "      <th>nitrous_oxide</th>\n",
              "      <th>nitrous_oxide_per_capita</th>\n",
              "      <th>population</th>\n",
              "      <th>gdp</th>\n",
              "      <th>primary_energy_consumption</th>\n",
              "      <th>energy_per_capita</th>\n",
              "      <th>energy_per_gdp</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>0</td>\n",
              "      <td>52</td>\n",
              "      <td>AFG</td>\n",
              "      <td>Afghanistan</td>\n",
              "      <td>2001</td>\n",
              "      <td>0.798</td>\n",
              "      <td>0.037</td>\n",
              "      <td>2.605</td>\n",
              "      <td>0.007</td>\n",
              "      <td>0.000</td>\n",
              "      <td>...</td>\n",
              "      <td>0.624</td>\n",
              "      <td>9.360</td>\n",
              "      <td>0.433</td>\n",
              "      <td>3.220</td>\n",
              "      <td>0.149</td>\n",
              "      <td>21606992.0</td>\n",
              "      <td>1.102127e+10</td>\n",
              "      <td>4.664</td>\n",
              "      <td>215.860</td>\n",
              "      <td>0.423</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>741</td>\n",
              "      <td>55</td>\n",
              "      <td>AFG</td>\n",
              "      <td>Afghanistan</td>\n",
              "      <td>2004</td>\n",
              "      <td>0.889</td>\n",
              "      <td>0.036</td>\n",
              "      <td>2.605</td>\n",
              "      <td>0.010</td>\n",
              "      <td>0.000</td>\n",
              "      <td>...</td>\n",
              "      <td>0.668</td>\n",
              "      <td>11.460</td>\n",
              "      <td>0.463</td>\n",
              "      <td>3.810</td>\n",
              "      <td>0.154</td>\n",
              "      <td>24726689.0</td>\n",
              "      <td>2.233257e+10</td>\n",
              "      <td>4.810</td>\n",
              "      <td>194.542</td>\n",
              "      <td>0.215</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>1482</td>\n",
              "      <td>58</td>\n",
              "      <td>AFG</td>\n",
              "      <td>Afghanistan</td>\n",
              "      <td>2007</td>\n",
              "      <td>2.269</td>\n",
              "      <td>0.084</td>\n",
              "      <td>2.605</td>\n",
              "      <td>0.012</td>\n",
              "      <td>0.000</td>\n",
              "      <td>...</td>\n",
              "      <td>0.918</td>\n",
              "      <td>18.100</td>\n",
              "      <td>0.668</td>\n",
              "      <td>4.250</td>\n",
              "      <td>0.157</td>\n",
              "      <td>27100542.0</td>\n",
              "      <td>3.450753e+10</td>\n",
              "      <td>10.039</td>\n",
              "      <td>370.438</td>\n",
              "      <td>0.291</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>2225</td>\n",
              "      <td>61</td>\n",
              "      <td>AFG</td>\n",
              "      <td>Afghanistan</td>\n",
              "      <td>2010</td>\n",
              "      <td>8.398</td>\n",
              "      <td>0.288</td>\n",
              "      <td>2.605</td>\n",
              "      <td>0.015</td>\n",
              "      <td>0.000</td>\n",
              "      <td>...</td>\n",
              "      <td>1.539</td>\n",
              "      <td>30.010</td>\n",
              "      <td>1.028</td>\n",
              "      <td>5.990</td>\n",
              "      <td>0.205</td>\n",
              "      <td>29185511.0</td>\n",
              "      <td>4.739942e+10</td>\n",
              "      <td>34.740</td>\n",
              "      <td>1190.324</td>\n",
              "      <td>0.733</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>2969</td>\n",
              "      <td>64</td>\n",
              "      <td>AFG</td>\n",
              "      <td>Afghanistan</td>\n",
              "      <td>2013</td>\n",
              "      <td>8.441</td>\n",
              "      <td>0.262</td>\n",
              "      <td>2.605</td>\n",
              "      <td>0.036</td>\n",
              "      <td>0.001</td>\n",
              "      <td>...</td>\n",
              "      <td>2.318</td>\n",
              "      <td>58.130</td>\n",
              "      <td>1.801</td>\n",
              "      <td>7.720</td>\n",
              "      <td>0.239</td>\n",
              "      <td>32269592.0</td>\n",
              "      <td>6.299370e+10</td>\n",
              "      <td>36.489</td>\n",
              "      <td>1130.743</td>\n",
              "      <td>0.579</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>4938</th>\n",
              "      <td>1976</td>\n",
              "      <td>25976</td>\n",
              "      <td>ZWE</td>\n",
              "      <td>Zimbabwe</td>\n",
              "      <td>2008</td>\n",
              "      <td>7.720</td>\n",
              "      <td>0.624</td>\n",
              "      <td>1.575</td>\n",
              "      <td>0.154</td>\n",
              "      <td>0.012</td>\n",
              "      <td>...</td>\n",
              "      <td>1.951</td>\n",
              "      <td>10.560</td>\n",
              "      <td>0.853</td>\n",
              "      <td>5.970</td>\n",
              "      <td>0.482</td>\n",
              "      <td>12379553.0</td>\n",
              "      <td>1.505022e+10</td>\n",
              "      <td>41.728</td>\n",
              "      <td>3370.733</td>\n",
              "      <td>2.773</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4941</th>\n",
              "      <td>2720</td>\n",
              "      <td>25979</td>\n",
              "      <td>ZWE</td>\n",
              "      <td>Zimbabwe</td>\n",
              "      <td>2011</td>\n",
              "      <td>9.744</td>\n",
              "      <td>0.756</td>\n",
              "      <td>1.046</td>\n",
              "      <td>0.382</td>\n",
              "      <td>0.030</td>\n",
              "      <td>...</td>\n",
              "      <td>2.369</td>\n",
              "      <td>11.900</td>\n",
              "      <td>0.923</td>\n",
              "      <td>6.950</td>\n",
              "      <td>0.539</td>\n",
              "      <td>12894323.0</td>\n",
              "      <td>1.955407e+10</td>\n",
              "      <td>50.290</td>\n",
              "      <td>3900.153</td>\n",
              "      <td>2.572</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4944</th>\n",
              "      <td>3464</td>\n",
              "      <td>25982</td>\n",
              "      <td>ZWE</td>\n",
              "      <td>Zimbabwe</td>\n",
              "      <td>2014</td>\n",
              "      <td>11.906</td>\n",
              "      <td>0.876</td>\n",
              "      <td>1.261</td>\n",
              "      <td>0.496</td>\n",
              "      <td>0.036</td>\n",
              "      <td>...</td>\n",
              "      <td>2.160</td>\n",
              "      <td>10.900</td>\n",
              "      <td>0.802</td>\n",
              "      <td>5.930</td>\n",
              "      <td>0.436</td>\n",
              "      <td>13586710.0</td>\n",
              "      <td>2.122250e+10</td>\n",
              "      <td>54.604</td>\n",
              "      <td>4018.925</td>\n",
              "      <td>2.573</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4947</th>\n",
              "      <td>4208</td>\n",
              "      <td>25985</td>\n",
              "      <td>ZWE</td>\n",
              "      <td>Zimbabwe</td>\n",
              "      <td>2017</td>\n",
              "      <td>9.582</td>\n",
              "      <td>0.673</td>\n",
              "      <td>1.666</td>\n",
              "      <td>0.678</td>\n",
              "      <td>0.048</td>\n",
              "      <td>...</td>\n",
              "      <td>2.023</td>\n",
              "      <td>11.620</td>\n",
              "      <td>0.816</td>\n",
              "      <td>6.350</td>\n",
              "      <td>0.446</td>\n",
              "      <td>14236599.0</td>\n",
              "      <td>2.194784e+10</td>\n",
              "      <td>45.936</td>\n",
              "      <td>3226.617</td>\n",
              "      <td>2.093</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4950</th>\n",
              "      <td>4950</td>\n",
              "      <td>25988</td>\n",
              "      <td>ZWE</td>\n",
              "      <td>Zimbabwe</td>\n",
              "      <td>2020</td>\n",
              "      <td>10.531</td>\n",
              "      <td>0.709</td>\n",
              "      <td>2.605</td>\n",
              "      <td>0.697</td>\n",
              "      <td>0.047</td>\n",
              "      <td>...</td>\n",
              "      <td>4.632</td>\n",
              "      <td>8.585</td>\n",
              "      <td>1.013</td>\n",
              "      <td>3.515</td>\n",
              "      <td>0.370</td>\n",
              "      <td>14862927.0</td>\n",
              "      <td>7.540152e+10</td>\n",
              "      <td>54.680</td>\n",
              "      <td>15333.018</td>\n",
              "      <td>1.168</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1651 rows × 62 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-9331f8b0-f785-4ab8-938f-7486371b9ec2')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-9331f8b0-f785-4ab8-938f-7486371b9ec2 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-9331f8b0-f785-4ab8-938f-7486371b9ec2');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "outcomes = {'sample_mean':[simple_random_mean,systematic_mean],\n",
        "           'real_mean':real_mean}\n",
        "\n",
        "\n",
        "outcomes = pd.DataFrame(outcomes, index=['Simple Random Sampling','Systematic Sampling'])\n",
        "\n",
        "outcomes['abs_error'] = abs(outcomes['real_mean'] - outcomes['sample_mean'])\n",
        "\n",
        "outcomes.sort_values(by='abs_error')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 112
        },
        "id": "s1cR4ajE9JVy",
        "outputId": "560bc8ba-25f8-4071-91de-d57bc2aac5fc"
      },
      "execution_count": 15,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                        sample_mean  real_mean  abs_error\n",
              "Systematic Sampling         600.551    595.803      4.748\n",
              "Simple Random Sampling        6.785    595.803    589.018"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-bb4bac11-8761-41e5-b0c2-271efda498b3\">\n",
              "    <div class=\"colab-df-container\">\n",
              "      <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>sample_mean</th>\n",
              "      <th>real_mean</th>\n",
              "      <th>abs_error</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>Systematic Sampling</th>\n",
              "      <td>600.551</td>\n",
              "      <td>595.803</td>\n",
              "      <td>4.748</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>Simple Random Sampling</th>\n",
              "      <td>6.785</td>\n",
              "      <td>595.803</td>\n",
              "      <td>589.018</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-bb4bac11-8761-41e5-b0c2-271efda498b3')\"\n",
              "              title=\"Convert this dataframe to an interactive table.\"\n",
              "              style=\"display:none;\">\n",
              "        \n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "      <script>\n",
              "        const buttonEl =\n",
              "          document.querySelector('#df-bb4bac11-8761-41e5-b0c2-271efda498b3 button.colab-df-convert');\n",
              "        buttonEl.style.display =\n",
              "          google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "        async function convertToInteractive(key) {\n",
              "          const element = document.querySelector('#df-bb4bac11-8761-41e5-b0c2-271efda498b3');\n",
              "          const dataTable =\n",
              "            await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                     [key], {});\n",
              "          if (!dataTable) return;\n",
              "\n",
              "          const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "            '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "            + ' to learn more about interactive tables.';\n",
              "          element.innerHTML = '';\n",
              "          dataTable['output_type'] = 'display_data';\n",
              "          await google.colab.output.renderOutput(dataTable, element);\n",
              "          const docLink = document.createElement('div');\n",
              "          docLink.innerHTML = docLinkHtml;\n",
              "          element.appendChild(docLink);\n",
              "        }\n",
              "      </script>\n",
              "    </div>\n",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 15
        }
      ]
    }
  ]
}