Notebooks/Aula03/novas-questoes.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Novas perguntas\n",
    "O análise e os questionamentos desenvolvidos aqui estão organizamos neste [documento apartado](./novas-questoes.md)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_csv('./../../Datasets/world-data-2023-01-com-labels.csv')\n",
    "data.drop(data.columns[0], axis=1, inplace=True)\n",
    "\n",
    "# clean column names\n",
    "data.columns = [str(col).lower().replace('(', '').replace(')', '') \\\n",
    "                .replace(' ', '_').replace('\\n', '').replace('/', '_') \\\n",
    "                .replace(':', '') \\\n",
    "                for col in data.columns]\n",
    "\n",
    "# Cut countries in categories by GDP\n",
    "# Obs: Na tentativa de cortar em 5 beans iguais ficaram EU e China no último bean e todos os outros (exceto Japão) no bean XS \n",
    "bins = [data['gdp'].min(), data['gdp'].quantile(.40), data['gdp'].quantile(.80), data['gdp'].quantile(.95), data['gdp'].max()]\n",
    "labels = ['S', 'M', 'L', 'XL']\n",
    "data['country_size'] = pd.cut(data['gdp'], bins=bins, labels=labels)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Configs and functions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "DARKGRID = \"darkgrid\"\n",
    "sns.set_style(DARKGRID)\n",
    "\n",
    "FIGSIZE=(10,10)\n",
    "\n",
    "\n",
    "# Selecionando pares de variáveis com correlação positiva > limit\n",
    "def select_best_corr(corr_df_, cut_limit=0.75):\n",
    "    corr_matrix_unstacked = corr_df_.unstack().copy()\n",
    "    corr_matrix_unstacked.sort_values(ascending=False, inplace=True)\n",
    "\n",
    "    pos = [(col1, col2, corr_matrix_unstacked[col1, col2]) for col1, col2 in corr_matrix_unstacked.index \\\n",
    "           if corr_matrix_unstacked[col1, col2] > cut_limit and col1 != col2]\n",
    "    \n",
    "    neg = [(col1, col2, corr_matrix_unstacked[col1, col2]) for col1, col2 in corr_matrix_unstacked.index \\\n",
    "           if corr_matrix_unstacked[col1, col2] < (cut_limit * -1) and col1 != col2]\n",
    "    \n",
    "    return pos, neg\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "2. **Impacto da Atividade Agrícola no Meio Ambiente:** Analise como a percentagem de terra usada para atividades agrícolas está relacionada com emissões de CO2, área de floresta, entre outras variáveis ambientais."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "# selecionar features que tenha a ver com esse assunto\n",
    "agricultura_features = ['densityp_km2', 'agricultural_land_%', 'land_areakm2', 'co2-emissions', 'forested_area_%', \n",
    "      'gasoline_price', 'gdp', 'gross_primary_education_enrollment_%',\n",
    "      'gross_tertiary_education_enrollment_%', 'minimum_wage', 'population', \n",
    "      'population_labor_force_participation_%', 'urban_population']\n",
    "agricultura_df = data.loc[:, agricultura_features].copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_13b1f_row0_col0, #T_13b1f_row1_col1, #T_13b1f_row2_col2, #T_13b1f_row3_col3, #T_13b1f_row4_col4, #T_13b1f_row5_col5, #T_13b1f_row6_col6, #T_13b1f_row7_col7, #T_13b1f_row8_col8, #T_13b1f_row9_col9, #T_13b1f_row10_col10, #T_13b1f_row11_col11, #T_13b1f_row12_col12 {\n",
       "  background-color: #023858;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_13b1f_row0_col1, #T_13b1f_row0_col4, #T_13b1f_row2_col1, #T_13b1f_row8_col5, #T_13b1f_row12_col4 {\n",
       "  background-color: #c6cce3;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row0_col2 {\n",
       "  background-color: #eee9f3;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row0_col3, #T_13b1f_row0_col10, #T_13b1f_row0_col12, #T_13b1f_row1_col11 {\n",
       "  background-color: #f8f1f8;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row0_col5, #T_13b1f_row3_col1 {\n",
       "  background-color: #b0c2de;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row0_col6, #T_13b1f_row1_col4, #T_13b1f_row2_col0, #T_13b1f_row2_col5, #T_13b1f_row4_col1, #T_13b1f_row5_col2, #T_13b1f_row5_col3, #T_13b1f_row5_col6, #T_13b1f_row5_col7, #T_13b1f_row5_col10, #T_13b1f_row5_col12, #T_13b1f_row8_col11, #T_13b1f_row11_col8, #T_13b1f_row11_col9 {\n",
       "  background-color: #fff7fb;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row0_col7, #T_13b1f_row1_col6, #T_13b1f_row3_col7, #T_13b1f_row8_col0, #T_13b1f_row11_col0 {\n",
       "  background-color: #f5eef6;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row0_col8, #T_13b1f_row0_col11, #T_13b1f_row3_col9 {\n",
       "  background-color: #e6e2ef;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row0_col9 {\n",
       "  background-color: #c0c9e2;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row1_col0, #T_13b1f_row4_col6, #T_13b1f_row4_col10, #T_13b1f_row7_col6, #T_13b1f_row11_col6, #T_13b1f_row11_col10 {\n",
       "  background-color: #fdf5fa;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row1_col2, #T_13b1f_row3_col11, #T_13b1f_row4_col8, #T_13b1f_row5_col11 {\n",
       "  background-color: #ece7f2;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row1_col3 {\n",
       "  background-color: #ede7f2;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row1_col5 {\n",
       "  background-color: #dddbec;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row1_col7, #T_13b1f_row4_col0, #T_13b1f_row11_col12 {\n",
       "  background-color: #fcf4fa;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row1_col8, #T_13b1f_row9_col10, #T_13b1f_row10_col9 {\n",
       "  background-color: #f9f2f8;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row1_col9, #T_13b1f_row7_col3 {\n",
       "  background-color: #f5eff6;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row1_col10 {\n",
       "  background-color: #e1dfed;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row1_col12, #T_13b1f_row8_col12, #T_13b1f_row10_col8 {\n",
       "  background-color: #e4e1ef;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row2_col3, #T_13b1f_row6_col2, #T_13b1f_row12_col2 {\n",
       "  background-color: #3991c1;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_13b1f_row2_col4, #T_13b1f_row8_col4, #T_13b1f_row9_col4 {\n",
       "  background-color: #c1cae2;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row2_col6 {\n",
       "  background-color: #569dc8;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_13b1f_row2_col7, #T_13b1f_row9_col11 {\n",
       "  background-color: #f4eef6;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row2_col8 {\n",
       "  background-color: #b5c4df;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row2_col9 {\n",
       "  background-color: #dbdaeb;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row2_col10 {\n",
       "  background-color: #7bacd1;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_13b1f_row2_col11, #T_13b1f_row6_col11, #T_13b1f_row7_col8 {\n",
       "  background-color: #ebe6f2;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row2_col12 {\n",
       "  background-color: #4c99c5;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_13b1f_row3_col0, #T_13b1f_row6_col0, #T_13b1f_row7_col9, #T_13b1f_row10_col0 {\n",
       "  background-color: #faf3f9;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row3_col2 {\n",
       "  background-color: #2a88bc;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_13b1f_row3_col4 {\n",
       "  background-color: #c5cce3;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row3_col5, #T_13b1f_row7_col5, #T_13b1f_row7_col12, #T_13b1f_row9_col12, #T_13b1f_row10_col5, #T_13b1f_row12_col9, #T_13b1f_row12_col11 {\n",
       "  background-color: #f1ebf4;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row3_col6 {\n",
       "  background-color: #034d79;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_13b1f_row3_col8, #T_13b1f_row6_col9, #T_13b1f_row7_col1, #T_13b1f_row11_col7 {\n",
       "  background-color: #c9cee4;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row3_col10, #T_13b1f_row10_col3 {\n",
       "  background-color: #04639b;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_13b1f_row3_col12, #T_13b1f_row12_col3 {\n",
       "  background-color: #034a74;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_13b1f_row4_col2 {\n",
       "  background-color: #e8e4f0;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row4_col3, #T_13b1f_row4_col12 {\n",
       "  background-color: #faf2f8;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row4_col5, #T_13b1f_row4_col11 {\n",
       "  background-color: #cdd0e5;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row4_col7 {\n",
       "  background-color: #dcdaeb;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row4_col9, #T_13b1f_row7_col0, #T_13b1f_row11_col3 {\n",
       "  background-color: #f7f0f7;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row5_col0, #T_13b1f_row5_col8, #T_13b1f_row10_col4 {\n",
       "  background-color: #cccfe5;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row5_col1 {\n",
       "  background-color: #b4c4df;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row5_col4 {\n",
       "  background-color: #a1bbda;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row5_col9 {\n",
       "  background-color: #a8bedc;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row6_col1 {\n",
       "  background-color: #b3c3de;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row6_col3 {\n",
       "  background-color: #034c78;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_13b1f_row6_col4, #T_13b1f_row9_col1 {\n",
       "  background-color: #bfc9e1;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row6_col5 {\n",
       "  background-color: #e9e5f1;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row6_col7, #T_13b1f_row8_col7 {\n",
       "  background-color: #f6eff7;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row6_col8 {\n",
       "  background-color: #b8c6e0;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row6_col10 {\n",
       "  background-color: #2987bc;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_13b1f_row6_col12 {\n",
       "  background-color: #0567a2;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_13b1f_row7_col2 {\n",
       "  background-color: #e5e1ef;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row7_col4 {\n",
       "  background-color: #9ab8d8;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row7_col10, #T_13b1f_row10_col7 {\n",
       "  background-color: #f0eaf4;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row7_col11 {\n",
       "  background-color: #b7c5df;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row8_col1, #T_13b1f_row8_col6, #T_13b1f_row11_col1 {\n",
       "  background-color: #d5d5e8;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row8_col2 {\n",
       "  background-color: #b1c2de;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row8_col3 {\n",
       "  background-color: #d9d8ea;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row8_col9 {\n",
       "  background-color: #78abd0;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_13b1f_row8_col10, #T_13b1f_row12_col5, #T_13b1f_row12_col7 {\n",
       "  background-color: #f1ebf5;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row9_col0 {\n",
       "  background-color: #c4cbe3;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row9_col2 {\n",
       "  background-color: #c8cde4;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row9_col3, #T_13b1f_row11_col2, #T_13b1f_row11_col5 {\n",
       "  background-color: #e7e3f0;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row9_col5 {\n",
       "  background-color: #91b5d6;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row9_col6 {\n",
       "  background-color: #d4d4e8;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row9_col7, #T_13b1f_row12_col0 {\n",
       "  background-color: #fbf3f9;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row9_col8 {\n",
       "  background-color: #67a4cc;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_13b1f_row10_col1 {\n",
       "  background-color: #a2bcda;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row10_col2 {\n",
       "  background-color: #63a2cb;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_13b1f_row10_col6 {\n",
       "  background-color: #308cbe;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_13b1f_row10_col11 {\n",
       "  background-color: #f2ecf5;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row10_col12, #T_13b1f_row12_col10 {\n",
       "  background-color: #034369;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_13b1f_row11_col4 {\n",
       "  background-color: #9cb9d9;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row12_col1 {\n",
       "  background-color: #a7bddb;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_13b1f_row12_col6 {\n",
       "  background-color: #0569a5;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_13b1f_row12_col8 {\n",
       "  background-color: #d6d6e9;\n",
       "  color: #000000;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_13b1f\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th id=\"T_13b1f_level0_col0\" class=\"col_heading level0 col0\" >densityp_km2</th>\n",
       "      <th id=\"T_13b1f_level0_col1\" class=\"col_heading level0 col1\" >agricultural_land_%</th>\n",
       "      <th id=\"T_13b1f_level0_col2\" class=\"col_heading level0 col2\" >land_areakm2</th>\n",
       "      <th id=\"T_13b1f_level0_col3\" class=\"col_heading level0 col3\" >co2-emissions</th>\n",
       "      <th id=\"T_13b1f_level0_col4\" class=\"col_heading level0 col4\" >forested_area_%</th>\n",
       "      <th id=\"T_13b1f_level0_col5\" class=\"col_heading level0 col5\" >gasoline_price</th>\n",
       "      <th id=\"T_13b1f_level0_col6\" class=\"col_heading level0 col6\" >gdp</th>\n",
       "      <th id=\"T_13b1f_level0_col7\" class=\"col_heading level0 col7\" >gross_primary_education_enrollment_%</th>\n",
       "      <th id=\"T_13b1f_level0_col8\" class=\"col_heading level0 col8\" >gross_tertiary_education_enrollment_%</th>\n",
       "      <th id=\"T_13b1f_level0_col9\" class=\"col_heading level0 col9\" >minimum_wage</th>\n",
       "      <th id=\"T_13b1f_level0_col10\" class=\"col_heading level0 col10\" >population</th>\n",
       "      <th id=\"T_13b1f_level0_col11\" class=\"col_heading level0 col11\" >population_labor_force_participation_%</th>\n",
       "      <th id=\"T_13b1f_level0_col12\" class=\"col_heading level0 col12\" >urban_population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_13b1f_level0_row0\" class=\"row_heading level0 row0\" >densityp_km2</th>\n",
       "      <td id=\"T_13b1f_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
       "      <td id=\"T_13b1f_row0_col1\" class=\"data row0 col1\" >-0.033645</td>\n",
       "      <td id=\"T_13b1f_row0_col2\" class=\"data row0 col2\" >-0.053637</td>\n",
       "      <td id=\"T_13b1f_row0_col3\" class=\"data row0 col3\" >-0.019218</td>\n",
       "      <td id=\"T_13b1f_row0_col4\" class=\"data row0 col4\" >-0.032696</td>\n",
       "      <td id=\"T_13b1f_row0_col5\" class=\"data row0 col5\" >0.224237</td>\n",
       "      <td id=\"T_13b1f_row0_col6\" class=\"data row0 col6\" >-0.018790</td>\n",
       "      <td id=\"T_13b1f_row0_col7\" class=\"data row0 col7\" >0.003602</td>\n",
       "      <td id=\"T_13b1f_row0_col8\" class=\"data row0 col8\" >0.019196</td>\n",
       "      <td id=\"T_13b1f_row0_col9\" class=\"data row0 col9\" >0.249618</td>\n",
       "      <td id=\"T_13b1f_row0_col10\" class=\"data row0 col10\" >-0.017870</td>\n",
       "      <td id=\"T_13b1f_row0_col11\" class=\"data row0 col11\" >0.019065</td>\n",
       "      <td id=\"T_13b1f_row0_col12\" class=\"data row0 col12\" >-0.023438</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_13b1f_level0_row1\" class=\"row_heading level0 row1\" >agricultural_land_%</th>\n",
       "      <td id=\"T_13b1f_row1_col0\" class=\"data row1 col0\" >-0.033645</td>\n",
       "      <td id=\"T_13b1f_row1_col1\" class=\"data row1 col1\" >1.000000</td>\n",
       "      <td id=\"T_13b1f_row1_col2\" class=\"data row1 col2\" >-0.031372</td>\n",
       "      <td id=\"T_13b1f_row1_col3\" class=\"data row1 col3\" >0.061898</td>\n",
       "      <td id=\"T_13b1f_row1_col4\" class=\"data row1 col4\" >-0.434566</td>\n",
       "      <td id=\"T_13b1f_row1_col5\" class=\"data row1 col5\" >0.045731</td>\n",
       "      <td id=\"T_13b1f_row1_col6\" class=\"data row1 col6\" >0.051623</td>\n",
       "      <td id=\"T_13b1f_row1_col7\" class=\"data row1 col7\" >-0.046669</td>\n",
       "      <td id=\"T_13b1f_row1_col8\" class=\"data row1 col8\" >-0.109088</td>\n",
       "      <td id=\"T_13b1f_row1_col9\" class=\"data row1 col9\" >-0.002432</td>\n",
       "      <td id=\"T_13b1f_row1_col10\" class=\"data row1 col10\" >0.117165</td>\n",
       "      <td id=\"T_13b1f_row1_col11\" class=\"data row1 col11\" >-0.108046</td>\n",
       "      <td id=\"T_13b1f_row1_col12\" class=\"data row1 col12\" >0.101364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_13b1f_level0_row2\" class=\"row_heading level0 row2\" >land_areakm2</th>\n",
       "      <td id=\"T_13b1f_row2_col0\" class=\"data row2 col0\" >-0.053637</td>\n",
       "      <td id=\"T_13b1f_row2_col1\" class=\"data row2 col1\" >-0.031372</td>\n",
       "      <td id=\"T_13b1f_row2_col2\" class=\"data row2 col2\" >1.000000</td>\n",
       "      <td id=\"T_13b1f_row2_col3\" class=\"data row2 col3\" >0.591510</td>\n",
       "      <td id=\"T_13b1f_row2_col4\" class=\"data row2 col4\" >-0.014244</td>\n",
       "      <td id=\"T_13b1f_row2_col5\" class=\"data row2 col5\" >-0.183163</td>\n",
       "      <td id=\"T_13b1f_row2_col6\" class=\"data row2 col6\" >0.550855</td>\n",
       "      <td id=\"T_13b1f_row2_col7\" class=\"data row2 col7\" >0.006032</td>\n",
       "      <td id=\"T_13b1f_row2_col8\" class=\"data row2 col8\" >0.223394</td>\n",
       "      <td id=\"T_13b1f_row2_col9\" class=\"data row2 col9\" >0.140740</td>\n",
       "      <td id=\"T_13b1f_row2_col10\" class=\"data row2 col10\" >0.446891</td>\n",
       "      <td id=\"T_13b1f_row2_col11\" class=\"data row2 col11\" >-0.006003</td>\n",
       "      <td id=\"T_13b1f_row2_col12\" class=\"data row2 col12\" >0.547687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_13b1f_level0_row3\" class=\"row_heading level0 row3\" >co2-emissions</th>\n",
       "      <td id=\"T_13b1f_row3_col0\" class=\"data row3 col0\" >-0.019218</td>\n",
       "      <td id=\"T_13b1f_row3_col1\" class=\"data row3 col1\" >0.061898</td>\n",
       "      <td id=\"T_13b1f_row3_col2\" class=\"data row3 col2\" >0.591510</td>\n",
       "      <td id=\"T_13b1f_row3_col3\" class=\"data row3 col3\" >1.000000</td>\n",
       "      <td id=\"T_13b1f_row3_col4\" class=\"data row3 col4\" >-0.027207</td>\n",
       "      <td id=\"T_13b1f_row3_col5\" class=\"data row3 col5\" >-0.068345</td>\n",
       "      <td id=\"T_13b1f_row3_col6\" class=\"data row3 col6\" >0.916978</td>\n",
       "      <td id=\"T_13b1f_row3_col7\" class=\"data row3 col7\" >0.001930</td>\n",
       "      <td id=\"T_13b1f_row3_col8\" class=\"data row3 col8\" >0.157411</td>\n",
       "      <td id=\"T_13b1f_row3_col9\" class=\"data row3 col9\" >0.090509</td>\n",
       "      <td id=\"T_13b1f_row3_col10\" class=\"data row3 col10\" >0.810229</td>\n",
       "      <td id=\"T_13b1f_row3_col11\" class=\"data row3 col11\" >-0.013108</td>\n",
       "      <td id=\"T_13b1f_row3_col12\" class=\"data row3 col12\" >0.926331</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_13b1f_level0_row4\" class=\"row_heading level0 row4\" >forested_area_%</th>\n",
       "      <td id=\"T_13b1f_row4_col0\" class=\"data row4 col0\" >-0.032696</td>\n",
       "      <td id=\"T_13b1f_row4_col1\" class=\"data row4 col1\" >-0.434566</td>\n",
       "      <td id=\"T_13b1f_row4_col2\" class=\"data row4 col2\" >-0.014244</td>\n",
       "      <td id=\"T_13b1f_row4_col3\" class=\"data row4 col3\" >-0.027207</td>\n",
       "      <td id=\"T_13b1f_row4_col4\" class=\"data row4 col4\" >1.000000</td>\n",
       "      <td id=\"T_13b1f_row4_col5\" class=\"data row4 col5\" >0.123949</td>\n",
       "      <td id=\"T_13b1f_row4_col6\" class=\"data row4 col6\" >-0.000559</td>\n",
       "      <td id=\"T_13b1f_row4_col7\" class=\"data row4 col7\" >0.142624</td>\n",
       "      <td id=\"T_13b1f_row4_col8\" class=\"data row4 col8\" >-0.012679</td>\n",
       "      <td id=\"T_13b1f_row4_col9\" class=\"data row4 col9\" >-0.013233</td>\n",
       "      <td id=\"T_13b1f_row4_col10\" class=\"data row4 col10\" >-0.055554</td>\n",
       "      <td id=\"T_13b1f_row4_col11\" class=\"data row4 col11\" >0.141633</td>\n",
       "      <td id=\"T_13b1f_row4_col12\" class=\"data row4 col12\" >-0.034752</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_13b1f_level0_row5\" class=\"row_heading level0 row5\" >gasoline_price</th>\n",
       "      <td id=\"T_13b1f_row5_col0\" class=\"data row5 col0\" >0.224237</td>\n",
       "      <td id=\"T_13b1f_row5_col1\" class=\"data row5 col1\" >0.045731</td>\n",
       "      <td id=\"T_13b1f_row5_col2\" class=\"data row5 col2\" >-0.183163</td>\n",
       "      <td id=\"T_13b1f_row5_col3\" class=\"data row5 col3\" >-0.068345</td>\n",
       "      <td id=\"T_13b1f_row5_col4\" class=\"data row5 col4\" >0.123949</td>\n",
       "      <td id=\"T_13b1f_row5_col5\" class=\"data row5 col5\" >1.000000</td>\n",
       "      <td id=\"T_13b1f_row5_col6\" class=\"data row5 col6\" >-0.018332</td>\n",
       "      <td id=\"T_13b1f_row5_col7\" class=\"data row5 col7\" >-0.069283</td>\n",
       "      <td id=\"T_13b1f_row5_col8\" class=\"data row5 col8\" >0.148140</td>\n",
       "      <td id=\"T_13b1f_row5_col9\" class=\"data row5 col9\" >0.323638</td>\n",
       "      <td id=\"T_13b1f_row5_col10\" class=\"data row5 col10\" >-0.069534</td>\n",
       "      <td id=\"T_13b1f_row5_col11\" class=\"data row5 col11\" >-0.011484</td>\n",
       "      <td id=\"T_13b1f_row5_col12\" class=\"data row5 col12\" >-0.072518</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_13b1f_level0_row6\" class=\"row_heading level0 row6\" >gdp</th>\n",
       "      <td id=\"T_13b1f_row6_col0\" class=\"data row6 col0\" >-0.018790</td>\n",
       "      <td id=\"T_13b1f_row6_col1\" class=\"data row6 col1\" >0.051623</td>\n",
       "      <td id=\"T_13b1f_row6_col2\" class=\"data row6 col2\" >0.550855</td>\n",
       "      <td id=\"T_13b1f_row6_col3\" class=\"data row6 col3\" >0.916978</td>\n",
       "      <td id=\"T_13b1f_row6_col4\" class=\"data row6 col4\" >-0.000559</td>\n",
       "      <td id=\"T_13b1f_row6_col5\" class=\"data row6 col5\" >-0.018332</td>\n",
       "      <td id=\"T_13b1f_row6_col6\" class=\"data row6 col6\" >1.000000</td>\n",
       "      <td id=\"T_13b1f_row6_col7\" class=\"data row6 col7\" >-0.004106</td>\n",
       "      <td id=\"T_13b1f_row6_col8\" class=\"data row6 col8\" >0.214354</td>\n",
       "      <td id=\"T_13b1f_row6_col9\" class=\"data row6 col9\" >0.218397</td>\n",
       "      <td id=\"T_13b1f_row6_col10\" class=\"data row6 col10\" >0.632505</td>\n",
       "      <td id=\"T_13b1f_row6_col11\" class=\"data row6 col11\" >-0.006399</td>\n",
       "      <td id=\"T_13b1f_row6_col12\" class=\"data row6 col12\" >0.784549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_13b1f_level0_row7\" class=\"row_heading level0 row7\" >gross_primary_education_enrollment_%</th>\n",
       "      <td id=\"T_13b1f_row7_col0\" class=\"data row7 col0\" >0.003602</td>\n",
       "      <td id=\"T_13b1f_row7_col1\" class=\"data row7 col1\" >-0.046669</td>\n",
       "      <td id=\"T_13b1f_row7_col2\" class=\"data row7 col2\" >0.006032</td>\n",
       "      <td id=\"T_13b1f_row7_col3\" class=\"data row7 col3\" >0.001930</td>\n",
       "      <td id=\"T_13b1f_row7_col4\" class=\"data row7 col4\" >0.142624</td>\n",
       "      <td id=\"T_13b1f_row7_col5\" class=\"data row7 col5\" >-0.069283</td>\n",
       "      <td id=\"T_13b1f_row7_col6\" class=\"data row7 col6\" >-0.004106</td>\n",
       "      <td id=\"T_13b1f_row7_col7\" class=\"data row7 col7\" >1.000000</td>\n",
       "      <td id=\"T_13b1f_row7_col8\" class=\"data row7 col8\" >-0.004799</td>\n",
       "      <td id=\"T_13b1f_row7_col9\" class=\"data row7 col9\" >-0.037568</td>\n",
       "      <td id=\"T_13b1f_row7_col10\" class=\"data row7 col10\" >0.039502</td>\n",
       "      <td id=\"T_13b1f_row7_col11\" class=\"data row7 col11\" >0.219505</td>\n",
       "      <td id=\"T_13b1f_row7_col12\" class=\"data row7 col12\" >0.028603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_13b1f_level0_row8\" class=\"row_heading level0 row8\" >gross_tertiary_education_enrollment_%</th>\n",
       "      <td id=\"T_13b1f_row8_col0\" class=\"data row8 col0\" >0.019196</td>\n",
       "      <td id=\"T_13b1f_row8_col1\" class=\"data row8 col1\" >-0.109088</td>\n",
       "      <td id=\"T_13b1f_row8_col2\" class=\"data row8 col2\" >0.223394</td>\n",
       "      <td id=\"T_13b1f_row8_col3\" class=\"data row8 col3\" >0.157411</td>\n",
       "      <td id=\"T_13b1f_row8_col4\" class=\"data row8 col4\" >-0.012679</td>\n",
       "      <td id=\"T_13b1f_row8_col5\" class=\"data row8 col5\" >0.148140</td>\n",
       "      <td id=\"T_13b1f_row8_col6\" class=\"data row8 col6\" >0.214354</td>\n",
       "      <td id=\"T_13b1f_row8_col7\" class=\"data row8 col7\" >-0.004799</td>\n",
       "      <td id=\"T_13b1f_row8_col8\" class=\"data row8 col8\" >1.000000</td>\n",
       "      <td id=\"T_13b1f_row8_col9\" class=\"data row8 col9\" >0.452364</td>\n",
       "      <td id=\"T_13b1f_row8_col10\" class=\"data row8 col10\" >0.028720</td>\n",
       "      <td id=\"T_13b1f_row8_col11\" class=\"data row8 col11\" >-0.158007</td>\n",
       "      <td id=\"T_13b1f_row8_col12\" class=\"data row8 col12\" >0.100441</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_13b1f_level0_row9\" class=\"row_heading level0 row9\" >minimum_wage</th>\n",
       "      <td id=\"T_13b1f_row9_col0\" class=\"data row9 col0\" >0.249618</td>\n",
       "      <td id=\"T_13b1f_row9_col1\" class=\"data row9 col1\" >-0.002432</td>\n",
       "      <td id=\"T_13b1f_row9_col2\" class=\"data row9 col2\" >0.140740</td>\n",
       "      <td id=\"T_13b1f_row9_col3\" class=\"data row9 col3\" >0.090509</td>\n",
       "      <td id=\"T_13b1f_row9_col4\" class=\"data row9 col4\" >-0.013233</td>\n",
       "      <td id=\"T_13b1f_row9_col5\" class=\"data row9 col5\" >0.323638</td>\n",
       "      <td id=\"T_13b1f_row9_col6\" class=\"data row9 col6\" >0.218397</td>\n",
       "      <td id=\"T_13b1f_row9_col7\" class=\"data row9 col7\" >-0.037568</td>\n",
       "      <td id=\"T_13b1f_row9_col8\" class=\"data row9 col8\" >0.452364</td>\n",
       "      <td id=\"T_13b1f_row9_col9\" class=\"data row9 col9\" >1.000000</td>\n",
       "      <td id=\"T_13b1f_row9_col10\" class=\"data row9 col10\" >-0.027627</td>\n",
       "      <td id=\"T_13b1f_row9_col11\" class=\"data row9 col11\" >-0.073154</td>\n",
       "      <td id=\"T_13b1f_row9_col12\" class=\"data row9 col12\" >0.029364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_13b1f_level0_row10\" class=\"row_heading level0 row10\" >population</th>\n",
       "      <td id=\"T_13b1f_row10_col0\" class=\"data row10 col0\" >-0.017870</td>\n",
       "      <td id=\"T_13b1f_row10_col1\" class=\"data row10 col1\" >0.117165</td>\n",
       "      <td id=\"T_13b1f_row10_col2\" class=\"data row10 col2\" >0.446891</td>\n",
       "      <td id=\"T_13b1f_row10_col3\" class=\"data row10 col3\" >0.810229</td>\n",
       "      <td id=\"T_13b1f_row10_col4\" class=\"data row10 col4\" >-0.055554</td>\n",
       "      <td id=\"T_13b1f_row10_col5\" class=\"data row10 col5\" >-0.069534</td>\n",
       "      <td id=\"T_13b1f_row10_col6\" class=\"data row10 col6\" >0.632505</td>\n",
       "      <td id=\"T_13b1f_row10_col7\" class=\"data row10 col7\" >0.039502</td>\n",
       "      <td id=\"T_13b1f_row10_col8\" class=\"data row10 col8\" >0.028720</td>\n",
       "      <td id=\"T_13b1f_row10_col9\" class=\"data row10 col9\" >-0.027627</td>\n",
       "      <td id=\"T_13b1f_row10_col10\" class=\"data row10 col10\" >1.000000</td>\n",
       "      <td id=\"T_13b1f_row10_col11\" class=\"data row10 col11\" >-0.056213</td>\n",
       "      <td id=\"T_13b1f_row10_col12\" class=\"data row10 col12\" >0.954261</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_13b1f_level0_row11\" class=\"row_heading level0 row11\" >population_labor_force_participation_%</th>\n",
       "      <td id=\"T_13b1f_row11_col0\" class=\"data row11 col0\" >0.019065</td>\n",
       "      <td id=\"T_13b1f_row11_col1\" class=\"data row11 col1\" >-0.108046</td>\n",
       "      <td id=\"T_13b1f_row11_col2\" class=\"data row11 col2\" >-0.006003</td>\n",
       "      <td id=\"T_13b1f_row11_col3\" class=\"data row11 col3\" >-0.013108</td>\n",
       "      <td id=\"T_13b1f_row11_col4\" class=\"data row11 col4\" >0.141633</td>\n",
       "      <td id=\"T_13b1f_row11_col5\" class=\"data row11 col5\" >-0.011484</td>\n",
       "      <td id=\"T_13b1f_row11_col6\" class=\"data row11 col6\" >-0.006399</td>\n",
       "      <td id=\"T_13b1f_row11_col7\" class=\"data row11 col7\" >0.219505</td>\n",
       "      <td id=\"T_13b1f_row11_col8\" class=\"data row11 col8\" >-0.158007</td>\n",
       "      <td id=\"T_13b1f_row11_col9\" class=\"data row11 col9\" >-0.073154</td>\n",
       "      <td id=\"T_13b1f_row11_col10\" class=\"data row11 col10\" >-0.056213</td>\n",
       "      <td id=\"T_13b1f_row11_col11\" class=\"data row11 col11\" >1.000000</td>\n",
       "      <td id=\"T_13b1f_row11_col12\" class=\"data row11 col12\" >-0.047780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_13b1f_level0_row12\" class=\"row_heading level0 row12\" >urban_population</th>\n",
       "      <td id=\"T_13b1f_row12_col0\" class=\"data row12 col0\" >-0.023438</td>\n",
       "      <td id=\"T_13b1f_row12_col1\" class=\"data row12 col1\" >0.101364</td>\n",
       "      <td id=\"T_13b1f_row12_col2\" class=\"data row12 col2\" >0.547687</td>\n",
       "      <td id=\"T_13b1f_row12_col3\" class=\"data row12 col3\" >0.926331</td>\n",
       "      <td id=\"T_13b1f_row12_col4\" class=\"data row12 col4\" >-0.034752</td>\n",
       "      <td id=\"T_13b1f_row12_col5\" class=\"data row12 col5\" >-0.072518</td>\n",
       "      <td id=\"T_13b1f_row12_col6\" class=\"data row12 col6\" >0.784549</td>\n",
       "      <td id=\"T_13b1f_row12_col7\" class=\"data row12 col7\" >0.028603</td>\n",
       "      <td id=\"T_13b1f_row12_col8\" class=\"data row12 col8\" >0.100441</td>\n",
       "      <td id=\"T_13b1f_row12_col9\" class=\"data row12 col9\" >0.029364</td>\n",
       "      <td id=\"T_13b1f_row12_col10\" class=\"data row12 col10\" >0.954261</td>\n",
       "      <td id=\"T_13b1f_row12_col11\" class=\"data row12 col11\" >-0.047780</td>\n",
       "      <td id=\"T_13b1f_row12_col12\" class=\"data row12 col12\" >1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7fedc69bac20>"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "agricultura_cm = agricultura_df.corr()\n",
    "agricultura_cm.style.background_gradient()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "# correlações positivas \n",
    "for orientacao in [0, 1]:\n",
    "       for correlacao in select_best_corr(agricultura_cm, .9)[orientacao]:\n",
    "              plt.figure(figsize=FIGSIZE)\n",
    "              sns.regplot(data=agricultura_df, x=correlacao[0], y=correlacao[1])\n",
    "              plt.title(f\"{correlacao[0]} x {correlacao[1]} | {round(correlacao[2], 2)}\")\n",
    "              plt.xscale('log')\n",
    "              plt.yscale('log')\n",
    "              plt.savefig(f'./images/{correlacao[0]}_{correlacao[1]}.png')\n",
    "              plt.ioff()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [],
   "source": [
    "plt.figure(figsize=FIGSIZE)\n",
    "sns.scatterplot(data=data, x='life_expectancy', y='fertility_rate', \\\n",
    "    hue='country_size', style='country_size')\n",
    "plt.title(f\"Life Expectancy x Fertility Rate\")\n",
    "plt.xscale('log')\n",
    "plt.yscale('log')\n",
    "plt.savefig('./images/life_exp_fert_rate.png')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "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>densityp_km2</th>\n",
       "      <th>agricultural_land_%</th>\n",
       "      <th>land_areakm2</th>\n",
       "      <th>armed_forces_size</th>\n",
       "      <th>birth_rate</th>\n",
       "      <th>calling_code</th>\n",
       "      <th>co2-emissions</th>\n",
       "      <th>cpi</th>\n",
       "      <th>cpi_change_%</th>\n",
       "      <th>fertility_rate</th>\n",
       "      <th>forested_area_%</th>\n",
       "      <th>gasoline_price</th>\n",
       "      <th>gdp</th>\n",
       "      <th>...</th>\n",
       "      <th>maternal_mortality_ratio</th>\n",
       "      <th>minimum_wage</th>\n",
       "      <th>official_language</th>\n",
       "      <th>out_of_pocket_health_expenditure</th>\n",
       "      <th>physicians_per_thousand</th>\n",
       "      <th>population</th>\n",
       "      <th>population_labor_force_participation_%</th>\n",
       "      <th>tax_revenue_%</th>\n",
       "      <th>total_tax_rate</th>\n",
       "      <th>unemployment_rate</th>\n",
       "      <th>urban_population</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>country_size</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>60.0</td>\n",
       "      <td>58.1</td>\n",
       "      <td>652230.0</td>\n",
       "      <td>323000.0</td>\n",
       "      <td>32.49</td>\n",
       "      <td>93.0</td>\n",
       "      <td>8672.0</td>\n",
       "      <td>149.90</td>\n",
       "      <td>2.3</td>\n",
       "      <td>4.47</td>\n",
       "      <td>2.1</td>\n",
       "      <td>0.70</td>\n",
       "      <td>1.910135e+10</td>\n",
       "      <td>...</td>\n",
       "      <td>638.0</td>\n",
       "      <td>0.43</td>\n",
       "      <td>Pashto</td>\n",
       "      <td>78.4</td>\n",
       "      <td>0.28</td>\n",
       "      <td>38041754.0</td>\n",
       "      <td>48.90</td>\n",
       "      <td>9.3</td>\n",
       "      <td>71.4</td>\n",
       "      <td>11.12</td>\n",
       "      <td>9797273.0</td>\n",
       "      <td>33.939110</td>\n",
       "      <td>67.709953</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Albania</td>\n",
       "      <td>105.0</td>\n",
       "      <td>43.1</td>\n",
       "      <td>28748.0</td>\n",
       "      <td>9000.0</td>\n",
       "      <td>11.78</td>\n",
       "      <td>355.0</td>\n",
       "      <td>4536.0</td>\n",
       "      <td>119.05</td>\n",
       "      <td>1.4</td>\n",
       "      <td>1.62</td>\n",
       "      <td>28.1</td>\n",
       "      <td>1.36</td>\n",
       "      <td>1.527808e+10</td>\n",
       "      <td>...</td>\n",
       "      <td>15.0</td>\n",
       "      <td>1.12</td>\n",
       "      <td>Albanian</td>\n",
       "      <td>56.9</td>\n",
       "      <td>1.20</td>\n",
       "      <td>2854191.0</td>\n",
       "      <td>55.70</td>\n",
       "      <td>18.6</td>\n",
       "      <td>36.6</td>\n",
       "      <td>12.33</td>\n",
       "      <td>1747593.0</td>\n",
       "      <td>41.153332</td>\n",
       "      <td>20.168331</td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Algeria</td>\n",
       "      <td>18.0</td>\n",
       "      <td>17.4</td>\n",
       "      <td>2381741.0</td>\n",
       "      <td>317000.0</td>\n",
       "      <td>24.28</td>\n",
       "      <td>213.0</td>\n",
       "      <td>150006.0</td>\n",
       "      <td>151.36</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.02</td>\n",
       "      <td>0.8</td>\n",
       "      <td>0.28</td>\n",
       "      <td>1.699882e+11</td>\n",
       "      <td>...</td>\n",
       "      <td>112.0</td>\n",
       "      <td>0.95</td>\n",
       "      <td>Arabic</td>\n",
       "      <td>28.1</td>\n",
       "      <td>1.72</td>\n",
       "      <td>43053054.0</td>\n",
       "      <td>41.20</td>\n",
       "      <td>37.2</td>\n",
       "      <td>66.1</td>\n",
       "      <td>11.70</td>\n",
       "      <td>31510100.0</td>\n",
       "      <td>28.033886</td>\n",
       "      <td>1.659626</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Andorra</td>\n",
       "      <td>164.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>468.0</td>\n",
       "      <td>31000.0</td>\n",
       "      <td>7.20</td>\n",
       "      <td>376.0</td>\n",
       "      <td>469.0</td>\n",
       "      <td>125.34</td>\n",
       "      <td>2.3</td>\n",
       "      <td>1.27</td>\n",
       "      <td>34.0</td>\n",
       "      <td>1.51</td>\n",
       "      <td>3.154058e+09</td>\n",
       "      <td>...</td>\n",
       "      <td>53.0</td>\n",
       "      <td>6.63</td>\n",
       "      <td>Catalan</td>\n",
       "      <td>36.4</td>\n",
       "      <td>3.33</td>\n",
       "      <td>77142.0</td>\n",
       "      <td>62.45</td>\n",
       "      <td>16.3</td>\n",
       "      <td>37.2</td>\n",
       "      <td>5.36</td>\n",
       "      <td>67873.0</td>\n",
       "      <td>42.506285</td>\n",
       "      <td>1.521801</td>\n",
       "      <td>S</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Angola</td>\n",
       "      <td>26.0</td>\n",
       "      <td>47.5</td>\n",
       "      <td>1246700.0</td>\n",
       "      <td>117000.0</td>\n",
       "      <td>40.73</td>\n",
       "      <td>244.0</td>\n",
       "      <td>34693.0</td>\n",
       "      <td>261.73</td>\n",
       "      <td>17.1</td>\n",
       "      <td>5.52</td>\n",
       "      <td>46.3</td>\n",
       "      <td>0.97</td>\n",
       "      <td>9.463542e+10</td>\n",
       "      <td>...</td>\n",
       "      <td>241.0</td>\n",
       "      <td>0.71</td>\n",
       "      <td>Portuguese</td>\n",
       "      <td>33.4</td>\n",
       "      <td>0.21</td>\n",
       "      <td>31825295.0</td>\n",
       "      <td>77.50</td>\n",
       "      <td>9.2</td>\n",
       "      <td>49.1</td>\n",
       "      <td>6.89</td>\n",
       "      <td>21061025.0</td>\n",
       "      <td>-11.202692</td>\n",
       "      <td>17.873887</td>\n",
       "      <td>M</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       country  densityp_km2  agricultural_land_%  land_areakm2  \\\n",
       "0  Afghanistan          60.0                 58.1      652230.0   \n",
       "1      Albania         105.0                 43.1       28748.0   \n",
       "2      Algeria          18.0                 17.4     2381741.0   \n",
       "3      Andorra         164.0                 40.0         468.0   \n",
       "4       Angola          26.0                 47.5     1246700.0   \n",
       "\n",
       "   armed_forces_size  birth_rate  calling_code  co2-emissions     cpi  \\\n",
       "0           323000.0       32.49          93.0         8672.0  149.90   \n",
       "1             9000.0       11.78         355.0         4536.0  119.05   \n",
       "2           317000.0       24.28         213.0       150006.0  151.36   \n",
       "3            31000.0        7.20         376.0          469.0  125.34   \n",
       "4           117000.0       40.73         244.0        34693.0  261.73   \n",
       "\n",
       "   cpi_change_%  fertility_rate  forested_area_%  gasoline_price  \\\n",
       "0           2.3            4.47              2.1            0.70   \n",
       "1           1.4            1.62             28.1            1.36   \n",
       "2           2.0            3.02              0.8            0.28   \n",
       "3           2.3            1.27             34.0            1.51   \n",
       "4          17.1            5.52             46.3            0.97   \n",
       "\n",
       "            gdp  ...  maternal_mortality_ratio  minimum_wage  \\\n",
       "0  1.910135e+10  ...                     638.0          0.43   \n",
       "1  1.527808e+10  ...                      15.0          1.12   \n",
       "2  1.699882e+11  ...                     112.0          0.95   \n",
       "3  3.154058e+09  ...                      53.0          6.63   \n",
       "4  9.463542e+10  ...                     241.0          0.71   \n",
       "\n",
       "   official_language  out_of_pocket_health_expenditure  \\\n",
       "0             Pashto                              78.4   \n",
       "1           Albanian                              56.9   \n",
       "2             Arabic                              28.1   \n",
       "3            Catalan                              36.4   \n",
       "4         Portuguese                              33.4   \n",
       "\n",
       "   physicians_per_thousand  population population_labor_force_participation_%  \\\n",
       "0                     0.28  38041754.0                                  48.90   \n",
       "1                     1.20   2854191.0                                  55.70   \n",
       "2                     1.72  43053054.0                                  41.20   \n",
       "3                     3.33     77142.0                                  62.45   \n",
       "4                     0.21  31825295.0                                  77.50   \n",
       "\n",
       "   tax_revenue_%  total_tax_rate  unemployment_rate  urban_population  \\\n",
       "0            9.3            71.4              11.12         9797273.0   \n",
       "1           18.6            36.6              12.33         1747593.0   \n",
       "2           37.2            66.1              11.70        31510100.0   \n",
       "3           16.3            37.2               5.36           67873.0   \n",
       "4            9.2            49.1               6.89        21061025.0   \n",
       "\n",
       "    latitude  longitude  country_size  \n",
       "0  33.939110  67.709953             M  \n",
       "1  41.153332  20.168331             S  \n",
       "2  28.033886   1.659626             M  \n",
       "3  42.506285   1.521801             S  \n",
       "4 -11.202692  17.873887             M  \n",
       "\n",
       "[5 rows x 32 columns]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "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>country_size</th>\n",
       "      <th>densityp_km2</th>\n",
       "      <th>co2-emissions</th>\n",
       "      <th>cpi</th>\n",
       "      <th>cpi_change_%</th>\n",
       "      <th>gdp</th>\n",
       "      <th>gross_primary_education_enrollment_%</th>\n",
       "      <th>gross_tertiary_education_enrollment_%</th>\n",
       "      <th>minimum_wage</th>\n",
       "      <th>population_labor_force_participation_%</th>\n",
       "      <th>tax_revenue_%</th>\n",
       "      <th>total_tax_rate</th>\n",
       "      <th>unemployment_rate</th>\n",
       "      <th>urban_population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>Togo</td>\n",
       "      <td>S</td>\n",
       "      <td>152.0</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>113.30</td>\n",
       "      <td>0.7</td>\n",
       "      <td>5.459979e+09</td>\n",
       "      <td>123.80</td>\n",
       "      <td>14.5</td>\n",
       "      <td>0.340</td>\n",
       "      <td>77.60</td>\n",
       "      <td>16.9</td>\n",
       "      <td>48.2</td>\n",
       "      <td>2.04</td>\n",
       "      <td>3414638.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>Uzbekistan</td>\n",
       "      <td>M</td>\n",
       "      <td>79.0</td>\n",
       "      <td>91811.0</td>\n",
       "      <td>125.34</td>\n",
       "      <td>2.3</td>\n",
       "      <td>5.792129e+10</td>\n",
       "      <td>104.20</td>\n",
       "      <td>10.1</td>\n",
       "      <td>0.240</td>\n",
       "      <td>65.10</td>\n",
       "      <td>14.8</td>\n",
       "      <td>31.6</td>\n",
       "      <td>5.92</td>\n",
       "      <td>16935729.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Austria</td>\n",
       "      <td>L</td>\n",
       "      <td>109.0</td>\n",
       "      <td>61448.0</td>\n",
       "      <td>118.06</td>\n",
       "      <td>1.5</td>\n",
       "      <td>4.463147e+11</td>\n",
       "      <td>103.10</td>\n",
       "      <td>85.1</td>\n",
       "      <td>1.045</td>\n",
       "      <td>60.70</td>\n",
       "      <td>25.4</td>\n",
       "      <td>51.4</td>\n",
       "      <td>4.67</td>\n",
       "      <td>5194416.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Jamaica</td>\n",
       "      <td>S</td>\n",
       "      <td>273.0</td>\n",
       "      <td>8225.0</td>\n",
       "      <td>162.47</td>\n",
       "      <td>3.9</td>\n",
       "      <td>1.645807e+10</td>\n",
       "      <td>91.00</td>\n",
       "      <td>27.1</td>\n",
       "      <td>1.330</td>\n",
       "      <td>66.00</td>\n",
       "      <td>26.8</td>\n",
       "      <td>35.1</td>\n",
       "      <td>8.00</td>\n",
       "      <td>1650594.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Belize</td>\n",
       "      <td>S</td>\n",
       "      <td>17.0</td>\n",
       "      <td>568.0</td>\n",
       "      <td>105.68</td>\n",
       "      <td>-0.9</td>\n",
       "      <td>1.879614e+09</td>\n",
       "      <td>111.70</td>\n",
       "      <td>24.7</td>\n",
       "      <td>1.650</td>\n",
       "      <td>65.10</td>\n",
       "      <td>26.3</td>\n",
       "      <td>31.1</td>\n",
       "      <td>6.41</td>\n",
       "      <td>179039.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Ivory Coast</td>\n",
       "      <td>M</td>\n",
       "      <td>83.0</td>\n",
       "      <td>9674.0</td>\n",
       "      <td>111.61</td>\n",
       "      <td>-0.9</td>\n",
       "      <td>5.879221e+10</td>\n",
       "      <td>99.80</td>\n",
       "      <td>9.3</td>\n",
       "      <td>0.360</td>\n",
       "      <td>57.00</td>\n",
       "      <td>11.8</td>\n",
       "      <td>50.1</td>\n",
       "      <td>3.32</td>\n",
       "      <td>13176900.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Republic of the Congo</td>\n",
       "      <td>S</td>\n",
       "      <td>16.0</td>\n",
       "      <td>3282.0</td>\n",
       "      <td>124.74</td>\n",
       "      <td>2.2</td>\n",
       "      <td>1.082059e+10</td>\n",
       "      <td>106.60</td>\n",
       "      <td>12.7</td>\n",
       "      <td>0.880</td>\n",
       "      <td>69.40</td>\n",
       "      <td>9.0</td>\n",
       "      <td>54.3</td>\n",
       "      <td>9.47</td>\n",
       "      <td>3625010.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>Palestinian National Authority</td>\n",
       "      <td>M</td>\n",
       "      <td>847.0</td>\n",
       "      <td>12303.0</td>\n",
       "      <td>125.34</td>\n",
       "      <td>2.3</td>\n",
       "      <td>3.438723e+10</td>\n",
       "      <td>102.55</td>\n",
       "      <td>31.2</td>\n",
       "      <td>1.045</td>\n",
       "      <td>62.45</td>\n",
       "      <td>16.3</td>\n",
       "      <td>37.2</td>\n",
       "      <td>5.36</td>\n",
       "      <td>4678103.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Kenya</td>\n",
       "      <td>M</td>\n",
       "      <td>94.0</td>\n",
       "      <td>17910.0</td>\n",
       "      <td>180.51</td>\n",
       "      <td>4.7</td>\n",
       "      <td>9.550309e+10</td>\n",
       "      <td>103.20</td>\n",
       "      <td>11.5</td>\n",
       "      <td>0.250</td>\n",
       "      <td>74.70</td>\n",
       "      <td>15.1</td>\n",
       "      <td>37.2</td>\n",
       "      <td>2.64</td>\n",
       "      <td>14461523.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Barbados</td>\n",
       "      <td>S</td>\n",
       "      <td>668.0</td>\n",
       "      <td>1276.0</td>\n",
       "      <td>134.09</td>\n",
       "      <td>4.1</td>\n",
       "      <td>5.209000e+09</td>\n",
       "      <td>99.40</td>\n",
       "      <td>65.4</td>\n",
       "      <td>3.130</td>\n",
       "      <td>65.20</td>\n",
       "      <td>27.5</td>\n",
       "      <td>35.6</td>\n",
       "      <td>10.33</td>\n",
       "      <td>89431.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            country country_size  densityp_km2  co2-emissions  \\\n",
       "175                            Togo            S         152.0         3000.0   \n",
       "188                      Uzbekistan            M          79.0        91811.0   \n",
       "9                           Austria            L         109.0        61448.0   \n",
       "84                          Jamaica            S         273.0         8225.0   \n",
       "17                           Belize            S          17.0          568.0   \n",
       "28                      Ivory Coast            M          83.0         9674.0   \n",
       "39            Republic of the Congo            S          16.0         3282.0   \n",
       "133  Palestinian National Authority            M         847.0        12303.0   \n",
       "88                            Kenya            M          94.0        17910.0   \n",
       "14                         Barbados            S         668.0         1276.0   \n",
       "\n",
       "        cpi  cpi_change_%           gdp  gross_primary_education_enrollment_%  \\\n",
       "175  113.30           0.7  5.459979e+09                                123.80   \n",
       "188  125.34           2.3  5.792129e+10                                104.20   \n",
       "9    118.06           1.5  4.463147e+11                                103.10   \n",
       "84   162.47           3.9  1.645807e+10                                 91.00   \n",
       "17   105.68          -0.9  1.879614e+09                                111.70   \n",
       "28   111.61          -0.9  5.879221e+10                                 99.80   \n",
       "39   124.74           2.2  1.082059e+10                                106.60   \n",
       "133  125.34           2.3  3.438723e+10                                102.55   \n",
       "88   180.51           4.7  9.550309e+10                                103.20   \n",
       "14   134.09           4.1  5.209000e+09                                 99.40   \n",
       "\n",
       "     gross_tertiary_education_enrollment_%  minimum_wage  \\\n",
       "175                                   14.5         0.340   \n",
       "188                                   10.1         0.240   \n",
       "9                                     85.1         1.045   \n",
       "84                                    27.1         1.330   \n",
       "17                                    24.7         1.650   \n",
       "28                                     9.3         0.360   \n",
       "39                                    12.7         0.880   \n",
       "133                                   31.2         1.045   \n",
       "88                                    11.5         0.250   \n",
       "14                                    65.4         3.130   \n",
       "\n",
       "     population_labor_force_participation_%  tax_revenue_%  total_tax_rate  \\\n",
       "175                                   77.60           16.9            48.2   \n",
       "188                                   65.10           14.8            31.6   \n",
       "9                                     60.70           25.4            51.4   \n",
       "84                                    66.00           26.8            35.1   \n",
       "17                                    65.10           26.3            31.1   \n",
       "28                                    57.00           11.8            50.1   \n",
       "39                                    69.40            9.0            54.3   \n",
       "133                                   62.45           16.3            37.2   \n",
       "88                                    74.70           15.1            37.2   \n",
       "14                                    65.20           27.5            35.6   \n",
       "\n",
       "     unemployment_rate  urban_population  \n",
       "175               2.04         3414638.0  \n",
       "188               5.92        16935729.0  \n",
       "9                 4.67         5194416.0  \n",
       "84                8.00         1650594.0  \n",
       "17                6.41          179039.0  \n",
       "28                3.32        13176900.0  \n",
       "39                9.47         3625010.0  \n",
       "133               5.36         4678103.5  \n",
       "88                2.64        14461523.0  \n",
       "14               10.33           89431.0  "
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns\n",
    "# 3. **Desenvolvimento Econômico e Educação:** Explore a relação entre o PIB, matrícula em educação primária e terciária, e o percentual de matrícula bruta nessas áreas.\n",
    "\n",
    "fields = ['country', 'country_size', 'densityp_km2', 'co2-emissions', 'cpi', 'cpi_change_%', 'gdp', 'gross_primary_education_enrollment_%',\n",
    "         'gross_tertiary_education_enrollment_%', 'minimum_wage', 'population_labor_force_participation_%', 'tax_revenue_%', 'total_tax_rate', 'unemployment_rate', 'urban_population']\n",
    "\n",
    "data2 = data[fields].copy()\n",
    "data2.sample(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<style type=\"text/css\">\n",
       "#T_205de_row0_col0, #T_205de_row1_col1, #T_205de_row2_col2, #T_205de_row3_col3, #T_205de_row4_col4, #T_205de_row5_col5, #T_205de_row6_col6, #T_205de_row7_col7, #T_205de_row8_col8, #T_205de_row9_col9, #T_205de_row10_col10, #T_205de_row11_col11, #T_205de_row12_col12 {\n",
       "  background-color: #023858;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_205de_row0_col1, #T_205de_row2_col9, #T_205de_row11_col5, #T_205de_row12_col7 {\n",
       "  background-color: #efe9f3;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row0_col2, #T_205de_row4_col2, #T_205de_row8_col1, #T_205de_row8_col12, #T_205de_row11_col10 {\n",
       "  background-color: #eee8f3;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row0_col3, #T_205de_row0_col4, #T_205de_row2_col4, #T_205de_row3_col9, #T_205de_row9_col2, #T_205de_row10_col5, #T_205de_row10_col9 {\n",
       "  background-color: #f2ecf5;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row0_col5, #T_205de_row1_col5, #T_205de_row2_col6, #T_205de_row6_col2, #T_205de_row11_col1, #T_205de_row11_col4 {\n",
       "  background-color: #e9e5f1;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row0_col6, #T_205de_row6_col3, #T_205de_row8_col2, #T_205de_row10_col4 {\n",
       "  background-color: #e6e2ef;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row0_col7, #T_205de_row1_col11 {\n",
       "  background-color: #bcc7e1;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row0_col8, #T_205de_row2_col8, #T_205de_row11_col9 {\n",
       "  background-color: #bbc7e0;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row0_col9 {\n",
       "  background-color: #e8e4f0;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row0_col10, #T_205de_row1_col3, #T_205de_row2_col1, #T_205de_row7_col10, #T_205de_row10_col6 {\n",
       "  background-color: #eee9f3;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row0_col11, #T_205de_row6_col1, #T_205de_row7_col11 {\n",
       "  background-color: #cccfe5;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row0_col12, #T_205de_row4_col5, #T_205de_row6_col5 {\n",
       "  background-color: #eae6f1;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row1_col0, #T_205de_row1_col9, #T_205de_row4_col0, #T_205de_row7_col3, #T_205de_row11_col7 {\n",
       "  background-color: #faf3f9;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row1_col2, #T_205de_row3_col1 {\n",
       "  background-color: #ede7f2;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row1_col4 {\n",
       "  background-color: #034c78;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_205de_row1_col6 {\n",
       "  background-color: #c9cee4;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row1_col7, #T_205de_row12_col5 {\n",
       "  background-color: #e4e1ef;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row1_col8, #T_205de_row3_col8 {\n",
       "  background-color: #c2cbe2;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row1_col10 {\n",
       "  background-color: #dcdaeb;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row1_col12 {\n",
       "  background-color: #034871;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_205de_row2_col0, #T_205de_row3_col5, #T_205de_row12_col0 {\n",
       "  background-color: #fbf3f9;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row2_col3, #T_205de_row3_col2 {\n",
       "  background-color: #03517e;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_205de_row2_col5, #T_205de_row2_col7, #T_205de_row3_col7, #T_205de_row5_col2, #T_205de_row5_col3, #T_205de_row8_col6, #T_205de_row8_col10, #T_205de_row8_col11, #T_205de_row9_col1, #T_205de_row9_col4, #T_205de_row9_col12, #T_205de_row11_col0, #T_205de_row11_col8, #T_205de_row12_col9 {\n",
       "  background-color: #fff7fb;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row2_col10, #T_205de_row5_col12 {\n",
       "  background-color: #e0deed;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row2_col11 {\n",
       "  background-color: #a1bbda;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row2_col12, #T_205de_row11_col12 {\n",
       "  background-color: #e7e3f0;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row3_col0 {\n",
       "  background-color: #fbf4f9;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row3_col4, #T_205de_row4_col3, #T_205de_row5_col4, #T_205de_row7_col5, #T_205de_row8_col4 {\n",
       "  background-color: #f0eaf4;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row3_col6, #T_205de_row7_col12, #T_205de_row10_col1 {\n",
       "  background-color: #e0dded;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row3_col10, #T_205de_row6_col12, #T_205de_row10_col12 {\n",
       "  background-color: #d2d3e7;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row3_col11 {\n",
       "  background-color: #a2bcda;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row3_col12 {\n",
       "  background-color: #e3e0ee;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row4_col1 {\n",
       "  background-color: #034b76;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_205de_row4_col6 {\n",
       "  background-color: #b8c6e0;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row4_col7, #T_205de_row5_col11, #T_205de_row9_col7, #T_205de_row10_col11 {\n",
       "  background-color: #c6cce3;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row4_col8, #T_205de_row7_col4, #T_205de_row12_col11 {\n",
       "  background-color: #c0c9e2;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row4_col9, #T_205de_row5_col0 {\n",
       "  background-color: #f7f0f7;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row4_col10, #T_205de_row6_col8 {\n",
       "  background-color: #dedcec;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row4_col11, #T_205de_row8_col5 {\n",
       "  background-color: #b7c5df;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row4_col12 {\n",
       "  background-color: #04649d;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_205de_row5_col1 {\n",
       "  background-color: #ece7f2;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row5_col6, #T_205de_row12_col2 {\n",
       "  background-color: #ebe6f2;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row5_col7, #T_205de_row10_col7 {\n",
       "  background-color: #f8f1f8;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row5_col8 {\n",
       "  background-color: #86b0d3;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row5_col9, #T_205de_row7_col0 {\n",
       "  background-color: #c4cbe3;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row5_col10, #T_205de_row8_col3 {\n",
       "  background-color: #f1ebf4;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row6_col0, #T_205de_row8_col0, #T_205de_row9_col10 {\n",
       "  background-color: #f4eef6;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row6_col4 {\n",
       "  background-color: #c1cae2;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row6_col7 {\n",
       "  background-color: #75a9cf;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_205de_row6_col9 {\n",
       "  background-color: #a4bcda;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row6_col10, #T_205de_row12_col3 {\n",
       "  background-color: #ede8f3;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row6_col11 {\n",
       "  background-color: #b5c4df;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row7_col1 {\n",
       "  background-color: #dad9ea;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row7_col2 {\n",
       "  background-color: #f5eff6;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row7_col6 {\n",
       "  background-color: #67a4cc;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_205de_row7_col8 {\n",
       "  background-color: #d0d1e6;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row7_col9 {\n",
       "  background-color: #b3c3de;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row8_col7, #T_205de_row10_col0 {\n",
       "  background-color: #fdf5fa;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row8_col9 {\n",
       "  background-color: #f6eff7;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row9_col0 {\n",
       "  background-color: #faf2f8;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row9_col3 {\n",
       "  background-color: #f9f2f8;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row9_col5 {\n",
       "  background-color: #c8cde4;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row9_col6 {\n",
       "  background-color: #a9bfdc;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row9_col8, #T_205de_row12_col6 {\n",
       "  background-color: #d6d6e9;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row9_col11 {\n",
       "  background-color: #8eb3d5;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row10_col2 {\n",
       "  background-color: #e1dfed;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row10_col3 {\n",
       "  background-color: #d9d8ea;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row10_col8 {\n",
       "  background-color: #dfddec;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row11_col2 {\n",
       "  background-color: #d1d2e6;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row11_col3 {\n",
       "  background-color: #d8d7e9;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row11_col6 {\n",
       "  background-color: #e2dfee;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row12_col1 {\n",
       "  background-color: #034973;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_205de_row12_col4 {\n",
       "  background-color: #0566a0;\n",
       "  color: #f1f1f1;\n",
       "}\n",
       "#T_205de_row12_col8 {\n",
       "  background-color: #cacee5;\n",
       "  color: #000000;\n",
       "}\n",
       "#T_205de_row12_col10 {\n",
       "  background-color: #d5d5e8;\n",
       "  color: #000000;\n",
       "}\n",
       "</style>\n",
       "<table id=\"T_205de\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th class=\"blank level0\" >&nbsp;</th>\n",
       "      <th id=\"T_205de_level0_col0\" class=\"col_heading level0 col0\" >densityp_km2</th>\n",
       "      <th id=\"T_205de_level0_col1\" class=\"col_heading level0 col1\" >co2-emissions</th>\n",
       "      <th id=\"T_205de_level0_col2\" class=\"col_heading level0 col2\" >cpi</th>\n",
       "      <th id=\"T_205de_level0_col3\" class=\"col_heading level0 col3\" >cpi_change_%</th>\n",
       "      <th id=\"T_205de_level0_col4\" class=\"col_heading level0 col4\" >gdp</th>\n",
       "      <th id=\"T_205de_level0_col5\" class=\"col_heading level0 col5\" >gross_primary_education_enrollment_%</th>\n",
       "      <th id=\"T_205de_level0_col6\" class=\"col_heading level0 col6\" >gross_tertiary_education_enrollment_%</th>\n",
       "      <th id=\"T_205de_level0_col7\" class=\"col_heading level0 col7\" >minimum_wage</th>\n",
       "      <th id=\"T_205de_level0_col8\" class=\"col_heading level0 col8\" >population_labor_force_participation_%</th>\n",
       "      <th id=\"T_205de_level0_col9\" class=\"col_heading level0 col9\" >tax_revenue_%</th>\n",
       "      <th id=\"T_205de_level0_col10\" class=\"col_heading level0 col10\" >total_tax_rate</th>\n",
       "      <th id=\"T_205de_level0_col11\" class=\"col_heading level0 col11\" >unemployment_rate</th>\n",
       "      <th id=\"T_205de_level0_col12\" class=\"col_heading level0 col12\" >urban_population</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th id=\"T_205de_level0_row0\" class=\"row_heading level0 row0\" >densityp_km2</th>\n",
       "      <td id=\"T_205de_row0_col0\" class=\"data row0 col0\" >1.000000</td>\n",
       "      <td id=\"T_205de_row0_col1\" class=\"data row0 col1\" >-0.019218</td>\n",
       "      <td id=\"T_205de_row0_col2\" class=\"data row0 col2\" >-0.025382</td>\n",
       "      <td id=\"T_205de_row0_col3\" class=\"data row0 col3\" >-0.029640</td>\n",
       "      <td id=\"T_205de_row0_col4\" class=\"data row0 col4\" >-0.018790</td>\n",
       "      <td id=\"T_205de_row0_col5\" class=\"data row0 col5\" >0.003602</td>\n",
       "      <td id=\"T_205de_row0_col6\" class=\"data row0 col6\" >0.019196</td>\n",
       "      <td id=\"T_205de_row0_col7\" class=\"data row0 col7\" >0.249618</td>\n",
       "      <td id=\"T_205de_row0_col8\" class=\"data row0 col8\" >0.019065</td>\n",
       "      <td id=\"T_205de_row0_col9\" class=\"data row0 col9\" >-0.014490</td>\n",
       "      <td id=\"T_205de_row0_col10\" class=\"data row0 col10\" >-0.039397</td>\n",
       "      <td id=\"T_205de_row0_col11\" class=\"data row0 col11\" >-0.055211</td>\n",
       "      <td id=\"T_205de_row0_col12\" class=\"data row0 col12\" >-0.023438</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_205de_level0_row1\" class=\"row_heading level0 row1\" >co2-emissions</th>\n",
       "      <td id=\"T_205de_row1_col0\" class=\"data row1 col0\" >-0.019218</td>\n",
       "      <td id=\"T_205de_row1_col1\" class=\"data row1 col1\" >1.000000</td>\n",
       "      <td id=\"T_205de_row1_col2\" class=\"data row1 col2\" >-0.014447</td>\n",
       "      <td id=\"T_205de_row1_col3\" class=\"data row1 col3\" >-0.001040</td>\n",
       "      <td id=\"T_205de_row1_col4\" class=\"data row1 col4\" >0.916978</td>\n",
       "      <td id=\"T_205de_row1_col5\" class=\"data row1 col5\" >0.001930</td>\n",
       "      <td id=\"T_205de_row1_col6\" class=\"data row1 col6\" >0.157411</td>\n",
       "      <td id=\"T_205de_row1_col7\" class=\"data row1 col7\" >0.090509</td>\n",
       "      <td id=\"T_205de_row1_col8\" class=\"data row1 col8\" >-0.013108</td>\n",
       "      <td id=\"T_205de_row1_col9\" class=\"data row1 col9\" >-0.143687</td>\n",
       "      <td id=\"T_205de_row1_col10\" class=\"data row1 col10\" >0.063710</td>\n",
       "      <td id=\"T_205de_row1_col11\" class=\"data row1 col11\" >0.012696</td>\n",
       "      <td id=\"T_205de_row1_col12\" class=\"data row1 col12\" >0.926331</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_205de_level0_row2\" class=\"row_heading level0 row2\" >cpi</th>\n",
       "      <td id=\"T_205de_row2_col0\" class=\"data row2 col0\" >-0.025382</td>\n",
       "      <td id=\"T_205de_row2_col1\" class=\"data row2 col1\" >-0.014447</td>\n",
       "      <td id=\"T_205de_row2_col2\" class=\"data row2 col2\" >1.000000</td>\n",
       "      <td id=\"T_205de_row2_col3\" class=\"data row2 col3\" >0.894924</td>\n",
       "      <td id=\"T_205de_row2_col4\" class=\"data row2 col4\" >-0.023630</td>\n",
       "      <td id=\"T_205de_row2_col5\" class=\"data row2 col5\" >-0.159170</td>\n",
       "      <td id=\"T_205de_row2_col6\" class=\"data row2 col6\" >0.003105</td>\n",
       "      <td id=\"T_205de_row2_col7\" class=\"data row2 col7\" >-0.083903</td>\n",
       "      <td id=\"T_205de_row2_col8\" class=\"data row2 col8\" >0.019967</td>\n",
       "      <td id=\"T_205de_row2_col9\" class=\"data row2 col9\" >-0.056198</td>\n",
       "      <td id=\"T_205de_row2_col10\" class=\"data row2 col10\" >0.041498</td>\n",
       "      <td id=\"T_205de_row2_col11\" class=\"data row2 col11\" >0.126116</td>\n",
       "      <td id=\"T_205de_row2_col12\" class=\"data row2 col12\" >-0.005858</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_205de_level0_row3\" class=\"row_heading level0 row3\" >cpi_change_%</th>\n",
       "      <td id=\"T_205de_row3_col0\" class=\"data row3 col0\" >-0.029640</td>\n",
       "      <td id=\"T_205de_row3_col1\" class=\"data row3 col1\" >-0.001040</td>\n",
       "      <td id=\"T_205de_row3_col2\" class=\"data row3 col2\" >0.894924</td>\n",
       "      <td id=\"T_205de_row3_col3\" class=\"data row3 col3\" >1.000000</td>\n",
       "      <td id=\"T_205de_row3_col4\" class=\"data row3 col4\" >-0.007797</td>\n",
       "      <td id=\"T_205de_row3_col5\" class=\"data row3 col5\" >-0.124938</td>\n",
       "      <td id=\"T_205de_row3_col6\" class=\"data row3 col6\" >0.050153</td>\n",
       "      <td id=\"T_205de_row3_col7\" class=\"data row3 col7\" >-0.086926</td>\n",
       "      <td id=\"T_205de_row3_col8\" class=\"data row3 col8\" >-0.016684</td>\n",
       "      <td id=\"T_205de_row3_col9\" class=\"data row3 col9\" >-0.077064</td>\n",
       "      <td id=\"T_205de_row3_col10\" class=\"data row3 col10\" >0.114516</td>\n",
       "      <td id=\"T_205de_row3_col11\" class=\"data row3 col11\" >0.118692</td>\n",
       "      <td id=\"T_205de_row3_col12\" class=\"data row3 col12\" >0.010888</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_205de_level0_row4\" class=\"row_heading level0 row4\" >gdp</th>\n",
       "      <td id=\"T_205de_row4_col0\" class=\"data row4 col0\" >-0.018790</td>\n",
       "      <td id=\"T_205de_row4_col1\" class=\"data row4 col1\" >0.916978</td>\n",
       "      <td id=\"T_205de_row4_col2\" class=\"data row4 col2\" >-0.023630</td>\n",
       "      <td id=\"T_205de_row4_col3\" class=\"data row4 col3\" >-0.007797</td>\n",
       "      <td id=\"T_205de_row4_col4\" class=\"data row4 col4\" >1.000000</td>\n",
       "      <td id=\"T_205de_row4_col5\" class=\"data row4 col5\" >-0.004106</td>\n",
       "      <td id=\"T_205de_row4_col6\" class=\"data row4 col6\" >0.214354</td>\n",
       "      <td id=\"T_205de_row4_col7\" class=\"data row4 col7\" >0.218397</td>\n",
       "      <td id=\"T_205de_row4_col8\" class=\"data row4 col8\" >-0.006399</td>\n",
       "      <td id=\"T_205de_row4_col9\" class=\"data row4 col9\" >-0.116944</td>\n",
       "      <td id=\"T_205de_row4_col10\" class=\"data row4 col10\" >0.053455</td>\n",
       "      <td id=\"T_205de_row4_col11\" class=\"data row4 col11\" >0.037671</td>\n",
       "      <td id=\"T_205de_row4_col12\" class=\"data row4 col12\" >0.784549</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_205de_level0_row5\" class=\"row_heading level0 row5\" >gross_primary_education_enrollment_%</th>\n",
       "      <td id=\"T_205de_row5_col0\" class=\"data row5 col0\" >0.003602</td>\n",
       "      <td id=\"T_205de_row5_col1\" class=\"data row5 col1\" >0.001930</td>\n",
       "      <td id=\"T_205de_row5_col2\" class=\"data row5 col2\" >-0.159170</td>\n",
       "      <td id=\"T_205de_row5_col3\" class=\"data row5 col3\" >-0.124938</td>\n",
       "      <td id=\"T_205de_row5_col4\" class=\"data row5 col4\" >-0.004106</td>\n",
       "      <td id=\"T_205de_row5_col5\" class=\"data row5 col5\" >1.000000</td>\n",
       "      <td id=\"T_205de_row5_col6\" class=\"data row5 col6\" >-0.004799</td>\n",
       "      <td id=\"T_205de_row5_col7\" class=\"data row5 col7\" >-0.037568</td>\n",
       "      <td id=\"T_205de_row5_col8\" class=\"data row5 col8\" >0.219505</td>\n",
       "      <td id=\"T_205de_row5_col9\" class=\"data row5 col9\" >0.158629</td>\n",
       "      <td id=\"T_205de_row5_col10\" class=\"data row5 col10\" >-0.055105</td>\n",
       "      <td id=\"T_205de_row5_col11\" class=\"data row5 col11\" >-0.034002</td>\n",
       "      <td id=\"T_205de_row5_col12\" class=\"data row5 col12\" >0.028603</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_205de_level0_row6\" class=\"row_heading level0 row6\" >gross_tertiary_education_enrollment_%</th>\n",
       "      <td id=\"T_205de_row6_col0\" class=\"data row6 col0\" >0.019196</td>\n",
       "      <td id=\"T_205de_row6_col1\" class=\"data row6 col1\" >0.157411</td>\n",
       "      <td id=\"T_205de_row6_col2\" class=\"data row6 col2\" >0.003105</td>\n",
       "      <td id=\"T_205de_row6_col3\" class=\"data row6 col3\" >0.050153</td>\n",
       "      <td id=\"T_205de_row6_col4\" class=\"data row6 col4\" >0.214354</td>\n",
       "      <td id=\"T_205de_row6_col5\" class=\"data row6 col5\" >-0.004799</td>\n",
       "      <td id=\"T_205de_row6_col6\" class=\"data row6 col6\" >1.000000</td>\n",
       "      <td id=\"T_205de_row6_col7\" class=\"data row6 col7\" >0.452364</td>\n",
       "      <td id=\"T_205de_row6_col8\" class=\"data row6 col8\" >-0.158007</td>\n",
       "      <td id=\"T_205de_row6_col9\" class=\"data row6 col9\" >0.266423</td>\n",
       "      <td id=\"T_205de_row6_col10\" class=\"data row6 col10\" >-0.029027</td>\n",
       "      <td id=\"T_205de_row6_col11\" class=\"data row6 col11\" >0.038999</td>\n",
       "      <td id=\"T_205de_row6_col12\" class=\"data row6 col12\" >0.100441</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_205de_level0_row7\" class=\"row_heading level0 row7\" >minimum_wage</th>\n",
       "      <td id=\"T_205de_row7_col0\" class=\"data row7 col0\" >0.249618</td>\n",
       "      <td id=\"T_205de_row7_col1\" class=\"data row7 col1\" >0.090509</td>\n",
       "      <td id=\"T_205de_row7_col2\" class=\"data row7 col2\" >-0.083903</td>\n",
       "      <td id=\"T_205de_row7_col3\" class=\"data row7 col3\" >-0.086926</td>\n",
       "      <td id=\"T_205de_row7_col4\" class=\"data row7 col4\" >0.218397</td>\n",
       "      <td id=\"T_205de_row7_col5\" class=\"data row7 col5\" >-0.037568</td>\n",
       "      <td id=\"T_205de_row7_col6\" class=\"data row7 col6\" >0.452364</td>\n",
       "      <td id=\"T_205de_row7_col7\" class=\"data row7 col7\" >1.000000</td>\n",
       "      <td id=\"T_205de_row7_col8\" class=\"data row7 col8\" >-0.073154</td>\n",
       "      <td id=\"T_205de_row7_col9\" class=\"data row7 col9\" >0.217805</td>\n",
       "      <td id=\"T_205de_row7_col10\" class=\"data row7 col10\" >-0.036776</td>\n",
       "      <td id=\"T_205de_row7_col11\" class=\"data row7 col11\" >-0.052880</td>\n",
       "      <td id=\"T_205de_row7_col12\" class=\"data row7 col12\" >0.029364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_205de_level0_row8\" class=\"row_heading level0 row8\" >population_labor_force_participation_%</th>\n",
       "      <td id=\"T_205de_row8_col0\" class=\"data row8 col0\" >0.019065</td>\n",
       "      <td id=\"T_205de_row8_col1\" class=\"data row8 col1\" >-0.013108</td>\n",
       "      <td id=\"T_205de_row8_col2\" class=\"data row8 col2\" >0.019967</td>\n",
       "      <td id=\"T_205de_row8_col3\" class=\"data row8 col3\" >-0.016684</td>\n",
       "      <td id=\"T_205de_row8_col4\" class=\"data row8 col4\" >-0.006399</td>\n",
       "      <td id=\"T_205de_row8_col5\" class=\"data row8 col5\" >0.219505</td>\n",
       "      <td id=\"T_205de_row8_col6\" class=\"data row8 col6\" >-0.158007</td>\n",
       "      <td id=\"T_205de_row8_col7\" class=\"data row8 col7\" >-0.073154</td>\n",
       "      <td id=\"T_205de_row8_col8\" class=\"data row8 col8\" >1.000000</td>\n",
       "      <td id=\"T_205de_row8_col9\" class=\"data row8 col9\" >-0.110572</td>\n",
       "      <td id=\"T_205de_row8_col10\" class=\"data row8 col10\" >-0.167444</td>\n",
       "      <td id=\"T_205de_row8_col11\" class=\"data row8 col11\" >-0.431414</td>\n",
       "      <td id=\"T_205de_row8_col12\" class=\"data row8 col12\" >-0.047780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_205de_level0_row9\" class=\"row_heading level0 row9\" >tax_revenue_%</th>\n",
       "      <td id=\"T_205de_row9_col0\" class=\"data row9 col0\" >-0.014490</td>\n",
       "      <td id=\"T_205de_row9_col1\" class=\"data row9 col1\" >-0.143687</td>\n",
       "      <td id=\"T_205de_row9_col2\" class=\"data row9 col2\" >-0.056198</td>\n",
       "      <td id=\"T_205de_row9_col3\" class=\"data row9 col3\" >-0.077064</td>\n",
       "      <td id=\"T_205de_row9_col4\" class=\"data row9 col4\" >-0.116944</td>\n",
       "      <td id=\"T_205de_row9_col5\" class=\"data row9 col5\" >0.158629</td>\n",
       "      <td id=\"T_205de_row9_col6\" class=\"data row9 col6\" >0.266423</td>\n",
       "      <td id=\"T_205de_row9_col7\" class=\"data row9 col7\" >0.217805</td>\n",
       "      <td id=\"T_205de_row9_col8\" class=\"data row9 col8\" >-0.110572</td>\n",
       "      <td id=\"T_205de_row9_col9\" class=\"data row9 col9\" >1.000000</td>\n",
       "      <td id=\"T_205de_row9_col10\" class=\"data row9 col10\" >-0.081535</td>\n",
       "      <td id=\"T_205de_row9_col11\" class=\"data row9 col11\" >0.189511</td>\n",
       "      <td id=\"T_205de_row9_col12\" class=\"data row9 col12\" >-0.183282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_205de_level0_row10\" class=\"row_heading level0 row10\" >total_tax_rate</th>\n",
       "      <td id=\"T_205de_row10_col0\" class=\"data row10 col0\" >-0.039397</td>\n",
       "      <td id=\"T_205de_row10_col1\" class=\"data row10 col1\" >0.063710</td>\n",
       "      <td id=\"T_205de_row10_col2\" class=\"data row10 col2\" >0.041498</td>\n",
       "      <td id=\"T_205de_row10_col3\" class=\"data row10 col3\" >0.114516</td>\n",
       "      <td id=\"T_205de_row10_col4\" class=\"data row10 col4\" >0.053455</td>\n",
       "      <td id=\"T_205de_row10_col5\" class=\"data row10 col5\" >-0.055105</td>\n",
       "      <td id=\"T_205de_row10_col6\" class=\"data row10 col6\" >-0.029027</td>\n",
       "      <td id=\"T_205de_row10_col7\" class=\"data row10 col7\" >-0.036776</td>\n",
       "      <td id=\"T_205de_row10_col8\" class=\"data row10 col8\" >-0.167444</td>\n",
       "      <td id=\"T_205de_row10_col9\" class=\"data row10 col9\" >-0.081535</td>\n",
       "      <td id=\"T_205de_row10_col10\" class=\"data row10 col10\" >1.000000</td>\n",
       "      <td id=\"T_205de_row10_col11\" class=\"data row10 col11\" >-0.033682</td>\n",
       "      <td id=\"T_205de_row10_col12\" class=\"data row10 col12\" >0.100936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_205de_level0_row11\" class=\"row_heading level0 row11\" >unemployment_rate</th>\n",
       "      <td id=\"T_205de_row11_col0\" class=\"data row11 col0\" >-0.055211</td>\n",
       "      <td id=\"T_205de_row11_col1\" class=\"data row11 col1\" >0.012696</td>\n",
       "      <td id=\"T_205de_row11_col2\" class=\"data row11 col2\" >0.126116</td>\n",
       "      <td id=\"T_205de_row11_col3\" class=\"data row11 col3\" >0.118692</td>\n",
       "      <td id=\"T_205de_row11_col4\" class=\"data row11 col4\" >0.037671</td>\n",
       "      <td id=\"T_205de_row11_col5\" class=\"data row11 col5\" >-0.034002</td>\n",
       "      <td id=\"T_205de_row11_col6\" class=\"data row11 col6\" >0.038999</td>\n",
       "      <td id=\"T_205de_row11_col7\" class=\"data row11 col7\" >-0.052880</td>\n",
       "      <td id=\"T_205de_row11_col8\" class=\"data row11 col8\" >-0.431414</td>\n",
       "      <td id=\"T_205de_row11_col9\" class=\"data row11 col9\" >0.189511</td>\n",
       "      <td id=\"T_205de_row11_col10\" class=\"data row11 col10\" >-0.033682</td>\n",
       "      <td id=\"T_205de_row11_col11\" class=\"data row11 col11\" >1.000000</td>\n",
       "      <td id=\"T_205de_row11_col12\" class=\"data row11 col12\" >-0.005968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th id=\"T_205de_level0_row12\" class=\"row_heading level0 row12\" >urban_population</th>\n",
       "      <td id=\"T_205de_row12_col0\" class=\"data row12 col0\" >-0.023438</td>\n",
       "      <td id=\"T_205de_row12_col1\" class=\"data row12 col1\" >0.926331</td>\n",
       "      <td id=\"T_205de_row12_col2\" class=\"data row12 col2\" >-0.005858</td>\n",
       "      <td id=\"T_205de_row12_col3\" class=\"data row12 col3\" >0.010888</td>\n",
       "      <td id=\"T_205de_row12_col4\" class=\"data row12 col4\" >0.784549</td>\n",
       "      <td id=\"T_205de_row12_col5\" class=\"data row12 col5\" >0.028603</td>\n",
       "      <td id=\"T_205de_row12_col6\" class=\"data row12 col6\" >0.100441</td>\n",
       "      <td id=\"T_205de_row12_col7\" class=\"data row12 col7\" >0.029364</td>\n",
       "      <td id=\"T_205de_row12_col8\" class=\"data row12 col8\" >-0.047780</td>\n",
       "      <td id=\"T_205de_row12_col9\" class=\"data row12 col9\" >-0.183282</td>\n",
       "      <td id=\"T_205de_row12_col10\" class=\"data row12 col10\" >0.100936</td>\n",
       "      <td id=\"T_205de_row12_col11\" class=\"data row12 col11\" >-0.005968</td>\n",
       "      <td id=\"T_205de_row12_col12\" class=\"data row12 col12\" >1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n"
      ],
      "text/plain": [
       "<pandas.io.formats.style.Styler at 0x7fedc551e530>"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data2.iloc[:,2:].corr().style.background_gradient()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Existe uma leve correlação positiva (0.452364) entre o valor do salário mínimo e a matrícula bruta na educação terceária."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Exclusão de campos não numéricos\n",
    "data_apenas_numeros = data.drop(['country', 'country_size', 'official_language'], axis=1).copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "([('fertility_rate', 'birth_rate', 0.9778290850910695),\n",
       "  ('birth_rate', 'fertility_rate', 0.9778290850910695),\n",
       "  ('population', 'urban_population', 0.9542611100342405),\n",
       "  ('urban_population', 'population', 0.9542611100342405),\n",
       "  ('urban_population', 'co2-emissions', 0.9263307679819908),\n",
       "  ('co2-emissions', 'urban_population', 0.9263307679819908),\n",
       "  ('gdp', 'co2-emissions', 0.916978279147576),\n",
       "  ('co2-emissions', 'gdp', 0.916978279147576),\n",
       "  ('cpi_change_%', 'cpi', 0.8949237803337273),\n",
       "  ('cpi', 'cpi_change_%', 0.8949237803337273),\n",
       "  ('population', 'armed_forces_size', 0.8772304358337647),\n",
       "  ('armed_forces_size', 'population', 0.8772304358337647),\n",
       "  ('infant_mortality', 'maternal_mortality_ratio', 0.8693203462373724),\n",
       "  ('maternal_mortality_ratio', 'infant_mortality', 0.8693203462373724),\n",
       "  ('infant_mortality', 'birth_rate', 0.8666773856519949),\n",
       "  ('birth_rate', 'infant_mortality', 0.8666773856519949),\n",
       "  ('urban_population', 'armed_forces_size', 0.852839070053562),\n",
       "  ('armed_forces_size', 'urban_population', 0.852839070053562),\n",
       "  ('infant_mortality', 'fertility_rate', 0.8518259240002628),\n",
       "  ('fertility_rate', 'infant_mortality', 0.8518259240002628),\n",
       "  ('co2-emissions', 'population', 0.810229182902134),\n",
       "  ('population', 'co2-emissions', 0.810229182902134),\n",
       "  ('gdp', 'urban_population', 0.7845493078738869),\n",
       "  ('urban_population', 'gdp', 0.7845493078738869),\n",
       "  ('fertility_rate', 'maternal_mortality_ratio', 0.7753336870635711),\n",
       "  ('maternal_mortality_ratio', 'fertility_rate', 0.7753336870635711),\n",
       "  ('birth_rate', 'maternal_mortality_ratio', 0.761649306290954),\n",
       "  ('maternal_mortality_ratio', 'birth_rate', 0.761649306290954)],\n",
       " [('maternal_mortality_ratio', 'life_expectancy', -0.8184476255348099),\n",
       "  ('life_expectancy', 'maternal_mortality_ratio', -0.8184476255348099),\n",
       "  ('fertility_rate', 'life_expectancy', -0.846445392992109),\n",
       "  ('life_expectancy', 'fertility_rate', -0.846445392992109),\n",
       "  ('life_expectancy', 'birth_rate', -0.867506786793468),\n",
       "  ('birth_rate', 'life_expectancy', -0.867506786793468),\n",
       "  ('life_expectancy', 'infant_mortality', -0.9181259622994663),\n",
       "  ('infant_mortality', 'life_expectancy', -0.9181259622994663)])"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Isolar correlações fortes positivas e negativas\n",
    "correlacoes = select_best_corr(data_apenas_numeros.corr(), .75)\n",
    "correlacoes"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.12"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}