{ "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 múltiples DataFrames al mismo tiempo con 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", "