{ "cells": [ { "cell_type": "markdown", "id": "5c8decec", "metadata": {}, "source": [ "# Propósito del Modelo\n", "El objetivo es hacer análisis que involucran múltiples variables de diferentes bases de datos combinadas." ] }, { "cell_type": "code", "execution_count": 1, "id": "ff4e01c3", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "( 1960 1961 1962 \\\n", " Country Name Country Code \n", " Aruba ABW -0.201874 -0.200982 -0.200327 \n", " Africa Eastern and Southern AFE -0.094914 -0.098259 -0.094392 \n", " Afghanistan AFG -0.201874 -0.200982 -0.200327 \n", " Africa Western and Central AFW -0.135881 -0.136426 -0.136892 \n", " Angola AGO -0.201874 -0.200982 -0.200327 \n", " \n", " 1963 1964 1965 \\\n", " Country Name Country Code \n", " Aruba ABW -0.199863 -0.200426 -0.202832 \n", " Africa Eastern and Southern AFE -0.094446 -0.097204 -0.095992 \n", " Afghanistan AFG -0.199863 -0.200426 -0.202832 \n", " Africa Western and Central AFW -0.135198 -0.136542 -0.136252 \n", " Angola AGO -0.199863 -0.200426 -0.202832 \n", " \n", " 1966 1967 1968 \\\n", " Country Name Country Code \n", " Aruba ABW -0.202705 -0.202662 -0.203255 \n", " Africa Eastern and Southern AFE -0.097136 -0.094766 -0.097880 \n", " Afghanistan AFG -0.202705 -0.202662 -0.203255 \n", " Africa Western and Central AFW -0.141240 -0.150569 -0.154342 \n", " Angola AGO -0.202705 -0.202662 -0.203255 \n", " \n", " 1969 ... 2013 2014 \\\n", " Country Name Country Code ... \n", " Aruba ABW -0.204786 ... -0.288371 -0.289320 \n", " Africa Eastern and Southern AFE -0.099362 ... -0.173739 -0.173601 \n", " Afghanistan AFG -0.204786 ... -0.286345 -0.287284 \n", " Africa Western and Central AFW -0.149334 ... -0.195458 -0.193785 \n", " Angola AGO -0.204786 ... -0.277472 -0.278209 \n", " \n", " 2015 2016 2017 \\\n", " Country Name Country Code \n", " Aruba ABW -0.289823 -0.290696 -0.291427 \n", " Africa Eastern and Southern AFE -0.174254 -0.175796 -0.177555 \n", " Afghanistan AFG -0.287813 -0.288695 -0.289457 \n", " Africa Western and Central AFW -0.194550 -0.197907 -0.199728 \n", " Angola AGO -0.278940 -0.280400 -0.281517 \n", " \n", " 2018 2019 2020 \\\n", " Country Name Country Code \n", " Aruba ABW -0.292036 -0.292556 -0.292998 \n", " Africa Eastern and Southern AFE -0.179122 -0.180347 -0.180619 \n", " Afghanistan AFG -0.290112 -0.290586 -0.290938 \n", " Africa Western and Central AFW -0.200799 -0.200851 -0.199375 \n", " Angola AGO -0.282588 -0.283415 -0.284049 \n", " \n", " 2021 2022 \n", " Country Name Country Code \n", " Aruba ABW -0.293201 -0.294042 \n", " Africa Eastern and Southern AFE -0.183041 -0.183463 \n", " Afghanistan AFG -0.291793 -0.287261 \n", " Africa Western and Central AFW -0.201723 -0.201925 \n", " Angola AGO -0.284755 -0.285617 \n", " \n", " [5 rows x 63 columns],\n", " 1960 1961 1962 \\\n", " Country Name Country Code \n", " Aruba ABW -0.084868 -0.08484 -0.083201 \n", " Africa Eastern and Southern AFE -0.084868 -0.08484 -0.083201 \n", " Afghanistan AFG -0.084868 -0.08484 -0.083201 \n", " Africa Western and Central AFW -0.084868 -0.08484 -0.083201 \n", " Angola AGO -0.084868 -0.08484 -0.083201 \n", " \n", " 1963 1964 1965 \\\n", " Country Name Country Code \n", " Aruba ABW -0.082048 -0.080368 -0.074607 \n", " Africa Eastern and Southern AFE -0.082048 -0.080368 -0.074607 \n", " Afghanistan AFG -0.082048 -0.080368 -0.074607 \n", " Africa Western and Central AFW -0.082048 -0.080368 -0.074607 \n", " Angola AGO -0.082048 -0.080368 -0.074607 \n", " \n", " 1966 1967 1968 \\\n", " Country Name Country Code \n", " Aruba ABW -0.075705 -0.073737 -0.072911 \n", " Africa Eastern and Southern AFE -0.075705 -0.073737 -0.072911 \n", " Afghanistan AFG -0.075705 -0.073737 -0.072911 \n", " Africa Western and Central AFW -0.075705 -0.073737 -0.072911 \n", " Angola AGO -0.075705 -0.073737 -0.072911 \n", " \n", " 1969 ... 2013 2014 \\\n", " Country Name Country Code ... \n", " Aruba ABW -0.071835 ... -0.105875 -0.107196 \n", " Africa Eastern and Southern AFE -0.071835 ... -0.105875 -0.107196 \n", " Afghanistan AFG -0.071835 ... -0.105875 -0.107196 \n", " Africa Western and Central AFW -0.071835 ... -0.105875 -0.107196 \n", " Angola AGO -0.071835 ... -0.104616 -0.106276 \n", " \n", " 2015 2016 2017 \\\n", " Country Name Country Code \n", " Aruba ABW -0.105721 -0.104515 -0.105551 \n", " Africa Eastern and Southern AFE -0.105721 -0.104515 -0.105551 \n", " Afghanistan AFG -0.105721 -0.104515 -0.105551 \n", " Africa Western and Central AFW -0.105721 -0.104515 -0.105551 \n", " Angola AGO -0.105172 -0.104014 -0.105000 \n", " \n", " 2018 2019 2020 \\\n", " Country Name Country Code \n", " Aruba ABW -0.107831 -0.111312 -0.111963 \n", " Africa Eastern and Southern AFE -0.107831 -0.111312 -0.111963 \n", " Afghanistan AFG -0.107831 -0.111312 -0.111067 \n", " Africa Western and Central AFW -0.107831 -0.111312 -0.111963 \n", " Angola AGO -0.107297 -0.110756 -0.111903 \n", " \n", " 2021 2022 \n", " Country Name Country Code \n", " Aruba ABW -0.110932 -0.111682 \n", " Africa Eastern and Southern AFE -0.110932 -0.111682 \n", " Afghanistan AFG -0.110692 -0.111682 \n", " Africa Western and Central AFW -0.110932 -0.111682 \n", " Angola AGO -0.111045 -0.111847 \n", " \n", " [5 rows x 63 columns],\n", " 1960 1961 1962 \\\n", " Country Name Country Code \n", " Aruba ABW -0.146825 -0.158595 -0.153408 \n", " Africa Eastern and Southern AFE -0.146825 -0.158595 -0.153408 \n", " Afghanistan AFG -0.146825 -0.158595 -0.153408 \n", " Africa Western and Central AFW -0.146825 -0.158595 -0.153408 \n", " Angola AGO -0.146825 -0.158595 -0.153408 \n", " \n", " 1963 1964 1965 \\\n", " Country Name Country Code \n", " Aruba ABW -0.158273 -0.158734 -0.162173 \n", " Africa Eastern and Southern AFE -0.158273 -0.158734 -0.162173 \n", " Afghanistan AFG -0.158273 -0.158734 -0.162173 \n", " Africa Western and Central AFW -0.158273 -0.158734 -0.162173 \n", " Angola AGO -0.158273 -0.158734 -0.162173 \n", " \n", " 1966 1967 1968 \\\n", " Country Name Country Code \n", " Aruba ABW -0.158459 -0.162375 -0.1682 \n", " Africa Eastern and Southern AFE -0.158459 -0.162375 -0.1682 \n", " Afghanistan AFG -0.158459 -0.162375 -0.1682 \n", " Africa Western and Central AFW -0.158459 -0.162375 -0.1682 \n", " Angola AGO -0.158459 -0.162375 -0.1682 \n", " \n", " 1969 ... 2013 2014 \\\n", " Country Name Country Code ... \n", " Aruba ABW -0.184395 ... -0.203738 -0.202930 \n", " Africa Eastern and Southern AFE -0.184395 ... -0.071547 -0.081470 \n", " Afghanistan AFG -0.184395 ... -0.203738 -0.202930 \n", " Africa Western and Central AFW -0.184395 ... -0.203738 -0.202930 \n", " Angola AGO -0.184395 ... -0.194796 -0.193997 \n", " \n", " 2015 2016 2017 \\\n", " Country Name Country Code \n", " Aruba ABW -0.285333 -0.202682 -0.202571 \n", " Africa Eastern and Southern AFE -0.195116 -0.092256 -0.090919 \n", " Afghanistan AFG -0.285333 -0.202682 -0.202571 \n", " Africa Western and Central AFW -0.285333 -0.202682 -0.202571 \n", " Angola AGO -0.280513 -0.198833 -0.198563 \n", " \n", " 2018 2019 2020 \\\n", " Country Name Country Code \n", " Aruba ABW -0.202676 -0.202183 -0.201677 \n", " Africa Eastern and Southern AFE -0.093306 -0.094302 -0.094236 \n", " Afghanistan AFG -0.202676 -0.202183 -0.201677 \n", " Africa Western and Central AFW -0.202676 -0.202183 -0.201677 \n", " Angola AGO -0.200401 -0.201239 -0.199575 \n", " \n", " 2021 2022 \n", " Country Name Country Code \n", " Aruba ABW -0.201440 -0.201034 \n", " Africa Eastern and Southern AFE -0.093547 -0.090401 \n", " Afghanistan AFG -0.201440 -0.201034 \n", " Africa Western and Central AFW -0.201440 -0.201034 \n", " Angola AGO -0.201274 -0.203768 \n", " \n", " [5 rows x 63 columns],\n", " 1960 1961 1962 \\\n", " Country Name Country Code \n", " Aruba ABW -0.090809 -0.091864 -0.09344 \n", " Africa Eastern and Southern AFE -0.090809 -0.091864 -0.09344 \n", " Afghanistan AFG -0.090809 -0.091864 -0.09344 \n", " Africa Western and Central AFW -0.090809 -0.091864 -0.09344 \n", " Angola AGO -0.090809 -0.091864 -0.09344 \n", " \n", " 1963 1964 1965 \\\n", " Country Name Country Code \n", " Aruba ABW -0.093163 -0.094031 -0.092187 \n", " Africa Eastern and Southern AFE -0.093163 -0.094031 -0.092187 \n", " Afghanistan AFG -0.093163 -0.094031 -0.092187 \n", " Africa Western and Central AFW -0.093163 -0.094031 -0.092187 \n", " Angola AGO -0.093163 -0.094031 -0.092187 \n", " \n", " 1966 1967 1968 \\\n", " Country Name Country Code \n", " Aruba ABW -0.090953 -0.089691 -0.090635 \n", " Africa Eastern and Southern AFE -0.090953 -0.089691 -0.090635 \n", " Afghanistan AFG -0.090953 -0.089691 -0.090635 \n", " Africa Western and Central AFW -0.090953 -0.089691 -0.090635 \n", " Angola AGO -0.090953 -0.089691 -0.090635 \n", " \n", " 1969 ... 2013 2014 \\\n", " Country Name Country Code ... \n", " Aruba ABW -0.089882 ... -0.113248 -0.114293 \n", " Africa Eastern and Southern AFE -0.089882 ... -0.113248 -0.114293 \n", " Afghanistan AFG -0.089882 ... -0.113248 -0.114293 \n", " Africa Western and Central AFW -0.089882 ... -0.113248 -0.114293 \n", " Angola AGO -0.089882 ... -0.112900 -0.113945 \n", " \n", " 2015 2016 2017 \\\n", " Country Name Country Code \n", " Aruba ABW -0.115194 -0.114932 -0.115308 \n", " Africa Eastern and Southern AFE -0.115194 -0.114932 -0.115308 \n", " Afghanistan AFG -0.115194 -0.114932 -0.115308 \n", " Africa Western and Central AFW -0.115194 -0.114932 -0.115308 \n", " Angola AGO -0.114668 -0.114465 -0.114863 \n", " \n", " 2018 2019 2020 \\\n", " Country Name Country Code \n", " Aruba ABW -0.116877 -0.119049 -0.118598 \n", " Africa Eastern and Southern AFE -0.116877 -0.119049 -0.118598 \n", " Afghanistan AFG -0.116877 -0.119049 -0.117498 \n", " Africa Western and Central AFW -0.116877 -0.119049 -0.118598 \n", " Angola AGO -0.116601 -0.118793 -0.118486 \n", " \n", " 2021 2022 \n", " Country Name Country Code \n", " Aruba ABW -0.118736 -0.117705 \n", " Africa Eastern and Southern AFE -0.118736 -0.117705 \n", " Afghanistan AFG -0.118341 -0.117705 \n", " Africa Western and Central AFW -0.118736 -0.117705 \n", " Angola AGO -0.118741 -0.118102 \n", " \n", " [5 rows x 63 columns],\n", " 1960 1961 1962 \\\n", " Country Name Country Code \n", " Aruba ABW -0.162675 -0.152507 -0.175345 \n", " Africa Eastern and Southern AFE 2.381755 2.202534 2.959211 \n", " Afghanistan AFG -0.162675 -0.152507 -0.175345 \n", " Africa Western and Central AFW -0.162675 -0.152507 -0.175345 \n", " Angola AGO -0.162675 -0.109791 -0.142530 \n", " \n", " 1963 1964 1965 \\\n", " Country Name Country Code \n", " Aruba ABW -0.199606 -0.207111 -0.257548 \n", " Africa Eastern and Southern AFE 2.810270 2.750210 3.317384 \n", " Afghanistan AFG -0.199606 -0.207111 -0.257548 \n", " Africa Western and Central AFW -0.199606 -0.207111 -0.257548 \n", " Angola AGO -0.165347 -0.144329 -0.250614 \n", " \n", " 1966 1967 1968 \\\n", " Country Name Country Code \n", " Aruba ABW -0.288931 -0.277482 -0.278466 \n", " Africa Eastern and Southern AFE 4.608648 3.940742 3.916744 \n", " Afghanistan AFG -0.288931 -0.277482 -0.278466 \n", " Africa Western and Central AFW -0.288931 -0.277482 0.066949 \n", " Angola AGO -0.261803 -0.277482 -0.278466 \n", " \n", " 1969 ... 2011 2012 \\\n", " Country Name Country Code ... \n", " Aruba ABW -0.270550 ... -0.325080 -0.311868 \n", " Africa Eastern and Southern AFE 4.802118 ... -0.325080 -0.311868 \n", " Afghanistan AFG -0.270550 ... -0.325080 -0.311868 \n", " Africa Western and Central AFW 0.209348 ... 0.935966 0.632917 \n", " Angola AGO -0.270550 ... 0.266913 0.170396 \n", " \n", " 2013 2014 2015 \\\n", " Country Name Country Code \n", " Aruba ABW -0.306099 -0.309704 -0.250354 \n", " Africa Eastern and Southern AFE -0.306099 -0.309704 -0.250354 \n", " Afghanistan AFG -0.306099 -0.309704 -0.250354 \n", " Africa Western and Central AFW 0.353438 0.164271 -0.175233 \n", " Angola AGO 0.224552 0.035088 -0.153382 \n", " \n", " 2016 2017 2018 \\\n", " Country Name Country Code \n", " Aruba ABW -0.252749 -0.257753 -0.291725 \n", " Africa Eastern and Southern AFE -0.252749 -0.257753 -0.291725 \n", " Afghanistan AFG -0.252749 -0.257753 -0.291725 \n", " Africa Western and Central AFW -0.252749 -0.133328 0.042448 \n", " Angola AGO -0.115071 -0.036075 0.042644 \n", " \n", " 2019 2020 \n", " Country Name Country Code \n", " Aruba ABW -0.281673 -0.251303 \n", " Africa Eastern and Southern AFE -0.281673 -0.251303 \n", " Afghanistan AFG -0.281673 -0.251303 \n", " Africa Western and Central AFW -0.051936 -0.239934 \n", " Angola AGO -0.088127 -0.217208 \n", " \n", " [5 rows x 61 columns])" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "import pandas as pd\n", "import numpy as np\n", "import statsmodels.formula.api as smf\n", "import statsmodels.api as sm\n", "import matplotlib.pyplot as plt\n", "import seaborn as sns\n", "\n", "main_gdp = pd.read_csv('main_gdp.csv', index_col=['Country Name', 'Country Code'])\n", "main_government = pd.read_csv('main_government.csv', index_col=['Country Name', 'Country Code'])\n", "main_investments = pd.read_csv('main_investments.csv', index_col=['Country Name', 'Country Code'])\n", "main_consumption = pd.read_csv('main_consumption.csv', index_col=['Country Name', 'Country Code'])\n", "main_trade = pd.read_csv('main_trade.csv', index_col=['Country Name', 'Country Code'])\n", "\n", "(main_gdp.head(), main_government.head(), main_investments.head(), main_consumption.head(), main_trade.head())" ] }, { "cell_type": "markdown", "id": "5c1b62dd", "metadata": {}, "source": [ "#### Unir mediante sufijos especificados" ] }, { "cell_type": "code", "execution_count": 2, "id": "f35b32d2", "metadata": { "scrolled": true }, "outputs": [ { "data": { "text/html": [ "
\n", " | \n", " | GDP_calculated_1960 | \n", "GDP_calculated_1961 | \n", "GDP_calculated_1962 | \n", "GDP_calculated_1963 | \n", "GDP_calculated_1964 | \n", "GDP_calculated_1965 | \n", "GDP_calculated_1966 | \n", "GDP_calculated_1967 | \n", "GDP_calculated_1968 | \n", "GDP_calculated_1969 | \n", "... | \n", "GDP_calculated_2013 | \n", "GDP_calculated_2014 | \n", "GDP_calculated_2015 | \n", "GDP_calculated_2016 | \n", "GDP_calculated_2017 | \n", "GDP_calculated_2018 | \n", "GDP_calculated_2019 | \n", "GDP_calculated_2020 | \n", "GDP_calculated_2021 | \n", "GDP_calculated_2022 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Country Name | \n", "Country Code | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
Aruba | \n", "ABW | \n", "-0.687051 | \n", "-0.688787 | \n", "-0.705721 | \n", "-0.732952 | \n", "-0.740670 | \n", "-0.789346 | \n", "-0.816753 | \n", "-0.805947 | \n", "-0.813468 | \n", "-0.821448 | \n", "... | \n", "-1.017331 | \n", "-1.023442 | \n", "-1.046426 | \n", "-0.965575 | \n", "-0.972609 | \n", "-1.011146 | \n", "-1.006774 | \n", "-0.976539 | \n", "-0.925748 | \n", "-0.925497 | \n", "
Africa Eastern and Southern | \n", "AFE | \n", "1.964340 | \n", "1.768977 | \n", "2.534770 | \n", "2.382340 | \n", "2.319873 | \n", "2.892425 | \n", "4.186396 | \n", "3.520173 | \n", "3.487117 | \n", "4.356643 | \n", "... | \n", "-0.770508 | \n", "-0.786264 | \n", "-0.840639 | \n", "-0.740249 | \n", "-0.747085 | \n", "-0.788861 | \n", "-0.786684 | \n", "-0.756719 | \n", "-0.599803 | \n", "-0.593651 | \n", "
Afghanistan | \n", "AFG | \n", "-0.687051 | \n", "-0.688787 | \n", "-0.705721 | \n", "-0.732952 | \n", "-0.740670 | \n", "-0.789346 | \n", "-0.816753 | \n", "-0.805947 | \n", "-0.813468 | \n", "-0.821448 | \n", "... | \n", "-1.015306 | \n", "-1.021407 | \n", "-1.044415 | \n", "-0.963573 | \n", "-0.970639 | \n", "-1.009221 | \n", "-1.004804 | \n", "-0.972484 | \n", "-0.923705 | \n", "-0.918717 | \n", "
Africa Western and Central | \n", "AFW | \n", "-0.621058 | \n", "-0.624231 | \n", "-0.642287 | \n", "-0.668287 | \n", "-0.676786 | \n", "-0.722767 | \n", "-0.755287 | \n", "-0.753854 | \n", "-0.419140 | \n", "-0.286099 | \n", "... | \n", "-0.264882 | \n", "-0.453932 | \n", "-0.876033 | \n", "-0.872786 | \n", "-0.756485 | \n", "-0.585735 | \n", "-0.685331 | \n", "-0.871547 | \n", "-0.834270 | \n", "-0.833380 | \n", "
Angola | \n", "AGO | \n", "-0.687051 | \n", "-0.646070 | \n", "-0.672906 | \n", "-0.698693 | \n", "-0.677888 | \n", "-0.782412 | \n", "-0.789625 | \n", "-0.805947 | \n", "-0.813468 | \n", "-0.821448 | \n", "... | \n", "-0.465233 | \n", "-0.657339 | \n", "-0.932675 | \n", "-0.812782 | \n", "-0.736018 | \n", "-0.664243 | \n", "-0.802329 | \n", "-0.931221 | \n", "-0.917089 | \n", "-0.923103 | \n", "
5 rows × 63 columns
\n", "\n", " | 1960_gdp | \n", "1961_gdp | \n", "1962_gdp | \n", "1963_gdp | \n", "1964_gdp | \n", "1965_gdp | \n", "1966_gdp | \n", "1967_gdp | \n", "1968_gdp | \n", "1969_gdp | \n", "... | \n", "GDP_calculated_2013 | \n", "GDP_calculated_2014 | \n", "GDP_calculated_2015 | \n", "GDP_calculated_2016 | \n", "GDP_calculated_2017 | \n", "GDP_calculated_2018 | \n", "GDP_calculated_2019 | \n", "GDP_calculated_2020 | \n", "GDP_calculated_2021 | \n", "GDP_calculated_2022 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Country Code | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
WLD | \n", "8.925325 | \n", "8.916576 | \n", "8.903261 | \n", "8.903658 | \n", "8.909846 | \n", "8.905935 | \n", "8.893228 | \n", "8.892912 | \n", "8.894431 | \n", "8.920468 | \n", "... | \n", "19.945839 | \n", "19.911398 | \n", "17.391711 | \n", "19.909714 | \n", "19.897277 | \n", "19.865401 | \n", "19.844482 | \n", "19.80143 | \n", "31.407289 | \n", "31.527472 | \n", "
1 rows × 376 columns
\n", "\n", " | \n", " | 1960_gdp | \n", "1961_gdp | \n", "1962_gdp | \n", "1963_gdp | \n", "1964_gdp | \n", "1965_gdp | \n", "1966_gdp | \n", "1967_gdp | \n", "1968_gdp | \n", "1969_gdp | \n", "... | \n", "GDP_calculated_2013 | \n", "GDP_calculated_2014 | \n", "GDP_calculated_2015 | \n", "GDP_calculated_2016 | \n", "GDP_calculated_2017 | \n", "GDP_calculated_2018 | \n", "GDP_calculated_2019 | \n", "GDP_calculated_2020 | \n", "GDP_calculated_2021 | \n", "GDP_calculated_2022 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Country Name | \n", "Country Code | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
Aruba | \n", "ABW | \n", "-0.201874 | \n", "-0.200982 | \n", "-0.200327 | \n", "-0.199863 | \n", "-0.200426 | \n", "-0.202832 | \n", "-0.202705 | \n", "-0.202662 | \n", "-0.203255 | \n", "-0.204786 | \n", "... | \n", "-1.017331 | \n", "-1.023442 | \n", "-1.046426 | \n", "-0.965575 | \n", "-0.972609 | \n", "-1.011146 | \n", "-1.006774 | \n", "-0.976539 | \n", "-0.925748 | \n", "-0.925497 | \n", "
Afghanistan | \n", "AFG | \n", "-0.201874 | \n", "-0.200982 | \n", "-0.200327 | \n", "-0.199863 | \n", "-0.200426 | \n", "-0.202832 | \n", "-0.202705 | \n", "-0.202662 | \n", "-0.203255 | \n", "-0.204786 | \n", "... | \n", "-1.015306 | \n", "-1.021407 | \n", "-1.044415 | \n", "-0.963573 | \n", "-0.970639 | \n", "-1.009221 | \n", "-1.004804 | \n", "-0.972484 | \n", "-0.923705 | \n", "-0.918717 | \n", "
Angola | \n", "AGO | \n", "-0.201874 | \n", "-0.200982 | \n", "-0.200327 | \n", "-0.199863 | \n", "-0.200426 | \n", "-0.202832 | \n", "-0.202705 | \n", "-0.202662 | \n", "-0.203255 | \n", "-0.204786 | \n", "... | \n", "-0.465233 | \n", "-0.657339 | \n", "-0.932675 | \n", "-0.812782 | \n", "-0.736018 | \n", "-0.664243 | \n", "-0.802329 | \n", "-0.931221 | \n", "-0.917089 | \n", "-0.923103 | \n", "
Albania | \n", "ALB | \n", "-0.201874 | \n", "-0.200982 | \n", "-0.200327 | \n", "-0.199863 | \n", "-0.200426 | \n", "-0.202832 | \n", "-0.202705 | \n", "-0.202662 | \n", "-0.203255 | \n", "-0.204786 | \n", "... | \n", "-1.024486 | \n", "-1.030680 | \n", "-1.050654 | \n", "-0.972267 | \n", "-0.979659 | \n", "-1.018762 | \n", "-1.015177 | \n", "-0.984239 | \n", "-0.946538 | \n", "-0.954034 | \n", "
Andorra | \n", "AND | \n", "-0.201874 | \n", "-0.200982 | \n", "-0.200327 | \n", "-0.199863 | \n", "-0.200426 | \n", "-0.202832 | \n", "-0.202705 | \n", "-0.202662 | \n", "-0.203255 | \n", "-0.204786 | \n", "... | \n", "-1.017377 | \n", "-1.023472 | \n", "-1.046447 | \n", "-0.965590 | \n", "-0.972647 | \n", "-1.011185 | \n", "-1.006798 | \n", "-0.976514 | \n", "-0.925774 | \n", "-0.925529 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
Kosovo | \n", "XKX | \n", "-0.201874 | \n", "-0.200982 | \n", "-0.200327 | \n", "-0.199863 | \n", "-0.200426 | \n", "-0.202832 | \n", "-0.202705 | \n", "-0.202662 | \n", "-0.203255 | \n", "-0.204786 | \n", "... | \n", "-1.028729 | \n", "-1.034928 | \n", "-1.054572 | \n", "-0.976205 | \n", "-0.983589 | \n", "-1.022714 | \n", "-1.019152 | \n", "-0.988298 | \n", "-0.951340 | \n", "-0.959118 | \n", "
Yemen, Rep. | \n", "YEM | \n", "-0.201874 | \n", "-0.200982 | \n", "-0.200327 | \n", "-0.199863 | \n", "-0.200426 | \n", "-0.202832 | \n", "-0.202705 | \n", "-0.202662 | \n", "-0.203255 | \n", "-0.204786 | \n", "... | \n", "-1.018770 | \n", "-1.025404 | \n", "-1.049979 | \n", "-0.972641 | \n", "-0.980441 | \n", "-1.018888 | \n", "-1.000565 | \n", "-0.970490 | \n", "-0.919628 | \n", "-0.918717 | \n", "
South Africa | \n", "ZAF | \n", "-0.169603 | \n", "-0.168437 | \n", "-0.167114 | \n", "-0.165969 | \n", "-0.165662 | \n", "-0.163839 | \n", "-0.163451 | \n", "-0.160740 | \n", "-0.162603 | \n", "-0.164274 | \n", "... | \n", "-0.933638 | \n", "-0.942189 | \n", "-0.971863 | \n", "-0.888590 | \n", "-0.883052 | \n", "-0.940374 | \n", "-0.938708 | \n", "-0.791299 | \n", "-0.852809 | \n", "-0.859582 | \n", "
Zambia | \n", "ZMB | \n", "-0.221483 | \n", "-0.220372 | \n", "-0.219614 | \n", "-0.219669 | \n", "-0.219984 | \n", "-0.218117 | \n", "-0.217284 | \n", "-0.216134 | \n", "-0.217168 | \n", "-0.218587 | \n", "... | \n", "-1.009544 | \n", "-1.021177 | \n", "-1.047666 | \n", "-0.963273 | \n", "-0.970319 | \n", "-1.008834 | \n", "-1.003544 | \n", "-0.951182 | \n", "-0.923430 | \n", "-0.923146 | \n", "
Zimbabwe | \n", "ZWE | \n", "-0.220994 | \n", "-0.219722 | \n", "-0.218875 | \n", "-0.218843 | \n", "-0.219564 | \n", "-0.218025 | \n", "-0.216980 | \n", "-0.215805 | \n", "-0.216831 | \n", "-0.217879 | \n", "... | \n", "-1.026594 | \n", "-1.032658 | \n", "-1.052336 | \n", "-0.974104 | \n", "-0.981528 | \n", "-1.020672 | \n", "-1.017468 | \n", "-0.986864 | \n", "-0.950039 | \n", "-0.957146 | \n", "
226 rows × 376 columns
\n", "\n", " | 1960_gdp | \n", "1961_gdp | \n", "1962_gdp | \n", "1963_gdp | \n", "1964_gdp | \n", "1965_gdp | \n", "1966_gdp | \n", "1967_gdp | \n", "1968_gdp | \n", "1969_gdp | \n", "... | \n", "GDP_calculated_2013 | \n", "GDP_calculated_2014 | \n", "GDP_calculated_2015 | \n", "GDP_calculated_2016 | \n", "GDP_calculated_2017 | \n", "GDP_calculated_2018 | \n", "GDP_calculated_2019 | \n", "GDP_calculated_2020 | \n", "GDP_calculated_2021 | \n", "GDP_calculated_2022 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Region | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
East Asia & Pacific | \n", "-6.824558 | \n", "-6.801649 | \n", "-6.773692 | \n", "-6.739758 | \n", "-6.723409 | \n", "-6.765620 | \n", "-6.720207 | \n", "-6.669891 | \n", "-6.659509 | \n", "-6.649542 | \n", "... | \n", "-3.674142 | \n", "-2.358834 | \n", "0.121531 | \n", "1.459465 | \n", "1.690320 | \n", "0.226357 | \n", "2.495186 | \n", "3.851648 | \n", "-0.500491 | \n", "-0.310485 | \n", "
Europe & Central Asia | \n", "-9.691664 | \n", "-9.603688 | \n", "-9.578843 | \n", "-9.550707 | \n", "-9.599877 | \n", "-9.727407 | \n", "-9.740002 | \n", "-9.710470 | \n", "-9.759768 | \n", "-9.842725 | \n", "... | \n", "-41.788147 | \n", "-43.454942 | \n", "-49.563682 | \n", "-43.578853 | \n", "-42.284450 | \n", "-43.163723 | \n", "-44.222898 | \n", "-45.346960 | \n", "-46.765078 | \n", "-46.937925 | \n", "
Latin America & Caribbean | \n", "-8.464656 | \n", "-8.408003 | \n", "-8.379139 | \n", "-8.387486 | \n", "-8.404706 | \n", "-8.423448 | \n", "-8.409930 | \n", "-8.381006 | \n", "-8.407552 | \n", "-8.457507 | \n", "... | \n", "-38.686483 | \n", "-38.834487 | \n", "-40.279676 | \n", "-36.497662 | \n", "-36.286598 | \n", "-37.868593 | \n", "-37.789479 | \n", "-36.552207 | \n", "-34.779918 | \n", "-34.828626 | \n", "
Middle East & North Africa | \n", "-4.249103 | \n", "-4.229591 | \n", "-4.217366 | \n", "-4.204654 | \n", "-4.214414 | \n", "-4.276927 | \n", "-4.277744 | \n", "-4.264914 | \n", "-4.259781 | \n", "-4.281930 | \n", "... | \n", "16.659887 | \n", "14.186188 | \n", "9.040055 | \n", "10.892649 | \n", "11.531911 | \n", "12.373879 | \n", "10.400159 | \n", "8.780381 | \n", "9.038083 | \n", "8.685722 | \n", "
North America | \n", "2.438380 | \n", "2.396244 | \n", "2.418113 | \n", "2.396826 | \n", "2.377447 | \n", "2.403834 | \n", "2.425244 | \n", "2.381201 | \n", "2.347475 | \n", "2.280019 | \n", "... | \n", "1.929953 | \n", "1.933112 | \n", "1.327117 | \n", "2.066289 | \n", "2.023086 | \n", "1.927699 | \n", "1.933361 | \n", "2.090802 | \n", "4.829924 | \n", "4.690498 | \n", "
5 rows × 376 columns
\n", "