{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "import pandas as pd" ] }, { "cell_type": "code", "execution_count": 2, "metadata": {}, "outputs": [], "source": [ "wh_data_file = 'WHR20_DataForTable2.1.xls'\n", "wh_all_df = pd.read_excel(wh_data_file)" ] }, { "cell_type": "code", "execution_count": 3, "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", "
|---|---|---|---|---|---|---|---|---|
| 0 | \n", "2008 | \n", "3.723590 | \n", "7.144916 | \n", "0.450662 | \n", "50.799999 | \n", "0.718114 | \n", "0.178993 | \n", "0.881686 | \n", "
| 1 | \n", "2009 | \n", "4.401778 | \n", "7.314788 | \n", "0.552308 | \n", "51.200001 | \n", "0.678896 | \n", "0.201228 | \n", "0.850035 | \n", "
| 2 | \n", "2010 | \n", "4.758381 | \n", "7.421525 | \n", "0.539075 | \n", "51.599998 | \n", "0.600127 | \n", "0.131578 | \n", "0.706766 | \n", "
| 3 | \n", "2011 | \n", "3.831719 | \n", "7.394349 | \n", "0.521104 | \n", "51.919998 | \n", "0.495901 | \n", "0.173452 | \n", "0.731109 | \n", "
| 4 | \n", "2012 | \n", "3.782938 | \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", "... | \n", "... | \n", "
| 1843 | \n", "2015 | \n", "3.703191 | \n", "7.827643 | \n", "0.735800 | \n", "53.799999 | \n", "0.667193 | \n", "-0.117035 | \n", "0.810457 | \n", "
| 1844 | \n", "2016 | \n", "3.735400 | \n", "7.819675 | \n", "0.768425 | \n", "54.400002 | \n", "0.732971 | \n", "-0.088488 | \n", "0.723612 | \n", "
| 1845 | \n", "2017 | \n", "3.638300 | \n", "7.851042 | \n", "0.754147 | \n", "55.000000 | \n", "0.752826 | \n", "-0.091540 | \n", "0.751208 | \n", "
| 1846 | \n", "2018 | \n", "3.616480 | \n", "7.896704 | \n", "0.775388 | \n", "55.599998 | \n", "0.762675 | \n", "-0.063282 | \n", "0.844209 | \n", "
| 1847 | \n", "2019 | \n", "2.693523 | \n", "7.850442 | \n", "0.759162 | \n", "56.200001 | \n", "0.631908 | \n", "-0.062325 | \n", "0.830652 | \n", "
1848 rows × 8 columns
\n", "