{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Solution part 5" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Previous part 2" ] }, { "cell_type": "code", "execution_count": 6, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import seaborn as sns" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "### Read the World Happiness data from an Excel file into a dataframe " ] }, { "cell_type": "code", "execution_count": 7, "metadata": {}, "outputs": [], "source": [ "wh_file = 'WHR20_DataForTable2.1.xls'\n", "wh_all_df = pd.read_excel(wh_file)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "#### Display the content of the dataframe" ] }, { "cell_type": "code", "execution_count": 8, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
| \n", " | Country name | \n", "year | \n", "Life Ladder | \n", "Log GDP per capita | \n", "Social support | \n", "Healthy life expectancy at birth | \n", "Freedom to make life choices | \n", "Generosity | \n", "Perceptions of corruption | \n", "Positive affect | \n", "... | \n", "GINI index (World Bank estimate) | \n", "GINI index (World Bank estimate), average 2000-2017, unbalanced panel | \n", "gini of household income reported in Gallup, by wp5-year | \n", "Most people can be trusted, Gallup | \n", "Most people can be trusted, WVS round 1981-1984 | \n", "Most people can be trusted, WVS round 1989-1993 | \n", "Most people can be trusted, WVS round 1994-1998 | \n", "Most people can be trusted, WVS round 1999-2004 | \n", "Most people can be trusted, WVS round 2005-2009 | \n", "Most people can be trusted, WVS round 2010-2014 | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | \n", "Afghanistan | \n", "2008 | \n", "3.723590 | \n", "7.144916 | \n", "0.450662 | \n", "50.799999 | \n", "0.718114 | \n", "0.178993 | \n", "0.881686 | \n", "0.517637 | \n", "... | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 1 | \n", "Afghanistan | \n", "2009 | \n", "4.401778 | \n", "7.314788 | \n", "0.552308 | \n", "51.200001 | \n", "0.678896 | \n", "0.201228 | \n", "0.850035 | \n", "0.583926 | \n", "... | \n", "NaN | \n", "NaN | \n", "0.441906 | \n", "0.286315 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 2 | \n", "Afghanistan | \n", "2010 | \n", "4.758381 | \n", "7.421525 | \n", "0.539075 | \n", "51.599998 | \n", "0.600127 | \n", "0.131578 | \n", "0.706766 | \n", "0.618265 | \n", "... | \n", "NaN | \n", "NaN | \n", "0.327318 | \n", "0.275833 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 3 | \n", "Afghanistan | \n", "2011 | \n", "3.831719 | \n", "7.394349 | \n", "0.521104 | \n", "51.919998 | \n", "0.495901 | \n", "0.173452 | \n", "0.731109 | \n", "0.611387 | \n", "... | \n", "NaN | \n", "NaN | \n", "0.336764 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| 4 | \n", "Afghanistan | \n", "2012 | \n", "3.782938 | \n", "7.480296 | \n", "0.520637 | \n", "52.240002 | \n", "0.530935 | \n", "0.246943 | \n", "0.775620 | \n", "0.710385 | \n", "... | \n", "NaN | \n", "NaN | \n", "0.344540 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 1843 | \n", "Zimbabwe | \n", "2015 | \n", "3.703191 | \n", "7.827643 | \n", "0.735800 | \n", "53.799999 | \n", "0.667193 | \n", "-0.117035 | \n", "0.810457 | \n", "0.715079 | \n", "... | \n", "NaN | \n", "0.432 | \n", "0.655137 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0.116683 | \n", "NaN | \n", "0.082942 | \n", "
| 1844 | \n", "Zimbabwe | \n", "2016 | \n", "3.735400 | \n", "7.819675 | \n", "0.768425 | \n", "54.400002 | \n", "0.732971 | \n", "-0.088488 | \n", "0.723612 | \n", "0.737636 | \n", "... | \n", "NaN | \n", "0.432 | \n", "0.596690 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0.116683 | \n", "NaN | \n", "0.082942 | \n", "
| 1845 | \n", "Zimbabwe | \n", "2017 | \n", "3.638300 | \n", "7.851042 | \n", "0.754147 | \n", "55.000000 | \n", "0.752826 | \n", "-0.091540 | \n", "0.751208 | \n", "0.806428 | \n", "... | \n", "NaN | \n", "0.432 | \n", "0.581484 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0.116683 | \n", "NaN | \n", "0.082942 | \n", "
| 1846 | \n", "Zimbabwe | \n", "2018 | \n", "3.616480 | \n", "7.896704 | \n", "0.775388 | \n", "55.599998 | \n", "0.762675 | \n", "-0.063282 | \n", "0.844209 | \n", "0.710119 | \n", "... | \n", "NaN | \n", "0.432 | \n", "0.541772 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0.116683 | \n", "NaN | \n", "0.082942 | \n", "
| 1847 | \n", "Zimbabwe | \n", "2019 | \n", "2.693523 | \n", "7.850442 | \n", "0.759162 | \n", "56.200001 | \n", "0.631908 | \n", "-0.062325 | \n", "0.830652 | \n", "0.716004 | \n", "... | \n", "NaN | \n", "0.432 | \n", "0.699588 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "0.116683 | \n", "NaN | \n", "0.082942 | \n", "
1848 rows × 26 columns
\n", "| \n", " | year | \n", "Life Ladder | \n", "Log GDP per capita | \n", "Social support | \n", "Healthy life expectancy at birth | \n", "Freedom to make life choices | \n", "Generosity | \n", "Perceptions of corruption | \n", "
|---|---|---|---|---|---|---|---|---|
| year | \n", "1.000000 | \n", "0.005903 | \n", "0.048507 | \n", "-0.032555 | \n", "0.133141 | \n", "0.193448 | \n", "-0.045407 | \n", "-0.071487 | \n", "
| Life Ladder | \n", "0.005903 | \n", "1.000000 | \n", "0.776676 | \n", "0.704046 | \n", "0.741604 | \n", "0.523349 | \n", "0.196849 | \n", "-0.422653 | \n", "
| Log GDP per capita | \n", "0.048507 | \n", "0.776676 | \n", "1.000000 | \n", "0.678557 | \n", "0.829849 | \n", "0.361548 | \n", "-0.000773 | \n", "-0.342296 | \n", "
| Social support | \n", "-0.032555 | \n", "0.704046 | \n", "0.678557 | \n", "1.000000 | \n", "0.612411 | \n", "0.409955 | \n", "0.066356 | \n", "-0.214311 | \n", "
| Healthy life expectancy at birth | \n", "0.133141 | \n", "0.741604 | \n", "0.829849 | \n", "0.612411 | \n", "1.000000 | \n", "0.378726 | \n", "0.030108 | \n", "-0.315927 | \n", "
| Freedom to make life choices | \n", "0.193448 | \n", "0.523349 | \n", "0.361548 | \n", "0.409955 | \n", "0.378726 | \n", "1.000000 | \n", "0.334219 | \n", "-0.490592 | \n", "
| Generosity | \n", "-0.045407 | \n", "0.196849 | \n", "-0.000773 | \n", "0.066356 | \n", "0.030108 | \n", "0.334219 | \n", "1.000000 | \n", "-0.299612 | \n", "
| Perceptions of corruption | \n", "-0.071487 | \n", "-0.422653 | \n", "-0.342296 | \n", "-0.214311 | \n", "-0.315927 | \n", "-0.490592 | \n", "-0.299612 | \n", "1.000000 | \n", "
| \n", " | Log GDP per capita | \n", "Social support | \n", "Healthy life expectancy at birth | \n", "Freedom to make life choices | \n", "Generosity | \n", "Perceptions of corruption | \n", "
|---|---|---|---|---|---|---|
| 0 | \n", "7.144916 | \n", "0.450662 | \n", "50.799999 | \n", "0.718114 | \n", "0.178993 | \n", "0.881686 | \n", "
| 1 | \n", "7.314788 | \n", "0.552308 | \n", "51.200001 | \n", "0.678896 | \n", "0.201228 | \n", "0.850035 | \n", "
| 2 | \n", "7.421525 | \n", "0.539075 | \n", "51.599998 | \n", "0.600127 | \n", "0.131578 | \n", "0.706766 | \n", "
| 3 | \n", "7.394349 | \n", "0.521104 | \n", "51.919998 | \n", "0.495901 | \n", "0.173452 | \n", "0.731109 | \n", "
| 4 | \n", "7.480296 | \n", "0.520637 | \n", "52.240002 | \n", "0.530935 | \n", "0.246943 | \n", "0.775620 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 1504 | \n", "7.826639 | \n", "0.765839 | \n", "52.380001 | \n", "0.642034 | \n", "-0.067743 | \n", "0.820217 | \n", "
| 1505 | \n", "7.827643 | \n", "0.735800 | \n", "53.799999 | \n", "0.667193 | \n", "-0.117035 | \n", "0.810457 | \n", "
| 1506 | \n", "7.819675 | \n", "0.768425 | \n", "54.400002 | \n", "0.732971 | \n", "-0.088488 | \n", "0.723612 | \n", "
| 1507 | \n", "7.851042 | \n", "0.754147 | \n", "55.000000 | \n", "0.752826 | \n", "-0.091540 | \n", "0.751208 | \n", "
| 1508 | \n", "7.896704 | \n", "0.775388 | \n", "55.599998 | \n", "0.762675 | \n", "-0.063282 | \n", "0.844209 | \n", "
1509 rows × 6 columns
\n", "| \n", " | Life Ladder | \n", "
|---|---|
| 0 | \n", "3.723590 | \n", "
| 1 | \n", "4.401778 | \n", "
| 2 | \n", "4.758381 | \n", "
| 3 | \n", "3.831719 | \n", "
| 4 | \n", "3.782938 | \n", "
| ... | \n", "... | \n", "
| 1504 | \n", "4.184451 | \n", "
| 1505 | \n", "3.703191 | \n", "
| 1506 | \n", "3.735400 | \n", "
| 1507 | \n", "3.638300 | \n", "
| 1508 | \n", "3.616480 | \n", "
1509 rows × 1 columns
\n", "| \n", " | Log GDP per capita | \n", "Social support | \n", "Healthy life expectancy at birth | \n", "Freedom to make life choices | \n", "Generosity | \n", "Perceptions of corruption | \n", "
|---|---|---|---|---|---|---|
| 0 | \n", "7.458469 | \n", "0.419973 | \n", "52.400002 | \n", "0.393656 | \n", "-0.096549 | \n", "0.923849 | \n", "
| 1 | \n", "9.456569 | \n", "0.686365 | \n", "69.000000 | \n", "0.777351 | \n", "-0.100784 | \n", "0.914284 | \n", "
| 2 | \n", "9.537369 | \n", "0.803259 | \n", "66.099998 | \n", "0.385083 | \n", "-0.017092 | \n", "0.740609 | \n", "
| 3 | \n", "9.772140 | \n", "0.896371 | \n", "69.000000 | \n", "0.817053 | \n", "-0.202615 | \n", "0.830460 | \n", "
| 4 | \n", "10.725492 | \n", "0.942774 | \n", "73.900002 | \n", "0.917537 | \n", "0.117622 | \n", "0.430209 | \n", "
| ... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
| 113 | \n", "9.959532 | \n", "0.933471 | \n", "69.099998 | \n", "0.902679 | \n", "-0.102370 | \n", "0.599400 | \n", "
| 114 | \n", "8.773669 | \n", "0.915276 | \n", "65.400002 | \n", "0.970295 | \n", "0.303127 | \n", "0.511197 | \n", "
| 115 | \n", "8.850640 | \n", "0.847592 | \n", "68.099998 | \n", "0.952469 | \n", "-0.122386 | \n", "0.787889 | \n", "
| 116 | \n", "8.224403 | \n", "0.637894 | \n", "55.799999 | \n", "0.811040 | \n", "0.066340 | \n", "0.831956 | \n", "
| 117 | \n", "7.850442 | \n", "0.759162 | \n", "56.200001 | \n", "0.631908 | \n", "-0.062325 | \n", "0.830652 | \n", "
118 rows × 6 columns
\n", "| \n", " | Life Ladder | \n", "
|---|---|
| 0 | \n", "2.375092 | \n", "
| 1 | \n", "4.995318 | \n", "
| 2 | \n", "4.744627 | \n", "
| 3 | \n", "6.085561 | \n", "
| 4 | \n", "7.233995 | \n", "
| ... | \n", "... | \n", "
| 113 | \n", "6.600337 | \n", "
| 114 | \n", "6.154049 | \n", "
| 115 | \n", "5.467451 | \n", "
| 116 | \n", "3.306797 | \n", "
| 117 | \n", "2.693523 | \n", "
118 rows × 1 columns
\n", "