{ "cells": [ { "cell_type": "code", "execution_count": 52, "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "import os" ] }, { "cell_type": "code", "execution_count": 53, "metadata": {}, "outputs": [], "source": [ "BLI = pd.read_csv(\"data\\BLI.csv\")\n", "WEO = pd.read_csv(\"data\\WEO.xls\", thousands=',', delimiter='\\t', encoding='latin1', na_values='n/a')" ] }, { "cell_type": "code", "execution_count": 69, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
GDP per capita
Country
Afghanistan509.759
Albania5847.056
Algeria4039.101
Angola2867.517
Antigua and Barbuda18887.448
......
Vanuatu3361.283
Vietnam2954.637
Yemen709.312
Zambia1236.192
Zimbabwe847.163
\n", "

190 rows × 1 columns

\n", "
" ], "text/plain": [ " GDP per capita\n", "Country \n", "Afghanistan 509.759\n", "Albania 5847.056\n", "Algeria 4039.101\n", "Angola 2867.517\n", "Antigua and Barbuda 18887.448\n", "... ...\n", "Vanuatu 3361.283\n", "Vietnam 2954.637\n", "Yemen 709.312\n", "Zambia 1236.192\n", "Zimbabwe 847.163\n", "\n", "[190 rows x 1 columns]" ] }, "execution_count": 69, "metadata": {}, "output_type": "execute_result" } ], "source": [ "WEONew2" ] }, { "cell_type": "code", "execution_count": 70, "metadata": {}, "outputs": [], "source": [ "WEONew2 = WEO.copy().dropna()[['Country', '2020']]" ] }, { "cell_type": "code", "execution_count": 71, "metadata": {}, "outputs": [], "source": [ "BLINew = BLI.copy()" ] }, { "cell_type": "code", "execution_count": 72, "metadata": {}, "outputs": [], "source": [ "BLINew = BLINew[['Country','Value']]" ] }, { "cell_type": "code", "execution_count": 73, "metadata": {}, "outputs": [], "source": [ "BLINew2 = BLI[BLI['INEQUALITY']=='TOT']\n", "BLINew2 = BLINew2.pivot(index=\"Country\", columns=\"Indicator\", values=\"Value\")" ] }, { "cell_type": "code", "execution_count": 74, "metadata": {}, "outputs": [], "source": [ "WEONew2.rename(columns={\"2020\": \"GDP per capita\"}, inplace=True)\n", "WEONew2.set_index(\"Country\", inplace=True)" ] }, { "cell_type": "code", "execution_count": 75, "metadata": {}, "outputs": [], "source": [ "full_country_stats = pd.merge(left=BLINew2, right=WEONew2,\n", " left_index=True, right_index=True)\n", "full_country_stats.sort_values(by=\"GDP per capita\", inplace=True)" ] }, { "cell_type": "code", "execution_count": 77, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Air pollutionDwellings without basic facilitiesEducational attainmentEmployees working very long hoursEmployment rateFeeling safe walking alone at nightHomicide rateHousehold net adjusted disposable incomeHousehold net wealthHousing expenditure...Quality of support networkRooms per personSelf-reported healthStakeholder engagement for developing regulationsStudent skillsTime devoted to leisure and personal careVoter turnoutWater qualityYears in educationGDP per capita
Country
South Africa22.037.073.018.1243.036.113.7NaNNaN18.0...88.0NaNNaNNaNNaN14.9273.067.0NaN6193.171
Colombia10.023.954.026.5667.044.424.5NaNNaN17.0...89.01.2NaN1.4410.0NaN53.075.014.16744.007
Brazil10.06.749.07.1361.035.626.7NaNNaNNaN...90.0NaNNaN2.2395.0NaN79.073.016.28955.650
Turkey20.08.039.032.6452.059.81.4NaNNaN20.0...86.01.069.01.5425.014.7986.065.018.39683.565
Mexico16.025.538.028.7061.041.818.1NaNNaN20.0...81.01.066.03.2416.0NaN63.068.015.210405.789
Russia15.014.894.00.1470.052.89.6NaNNaN18.0...89.00.943.0NaN492.0NaN68.055.016.211305.118
Chile16.09.465.09.7263.047.94.2NaN100967.018.0...85.01.257.01.3443.0NaN47.071.017.515854.652
Poland22.03.092.05.9566.067.30.719814.0210991.022.0...86.01.158.02.6504.014.4255.082.017.615988.035
Hungary19.04.784.03.0368.056.31.0NaN104458.019.0...86.01.260.01.2474.0NaN70.077.016.418535.147
Latvia11.013.988.01.2770.062.44.816275.070160.023.0...86.01.247.02.2487.013.8359.079.018.019104.841
Lithuania14.013.693.00.5470.055.93.421660.0NaN19.0...88.01.543.02.4475.0NaN51.081.018.420354.997
Slovak Republic21.01.291.04.1466.063.50.820474.0NaN23.0...91.01.166.03.0463.0NaN60.085.015.820494.627
Greece18.00.573.06.4253.060.00.817700.0150134.023.0...80.01.274.01.8458.0NaN64.069.019.020845.315
Portugal10.01.048.08.2768.073.41.021203.0232666.021.0...88.01.748.01.5497.0NaN56.086.016.923731.127
Czech Republic20.00.794.05.6574.072.30.521453.0NaN24.0...91.01.460.01.6491.0NaN61.087.017.924569.058
Estonia8.07.089.02.4274.069.03.119697.0159373.017.0...92.01.653.02.7524.014.9064.084.017.724802.770
Slovenia16.00.488.04.3969.086.10.620820.0203044.018.0...92.01.564.02.5509.014.7553.090.018.327452.323
Spain11.00.159.04.0162.082.10.623999.0373548.021.0...93.01.972.01.8491.015.9370.072.017.930734.119
Korea28.02.588.0NaN67.066.61.021882.0285980.015.0...78.01.533.02.9519.014.7077.076.017.331246.041
Italy18.00.761.04.1158.058.40.626588.0279889.023.0...92.01.471.02.5485.016.4773.071.016.633431.250
United Kingdom11.00.381.012.1575.077.70.228715.0548392.026.0...94.01.969.03.1500.014.9269.084.017.540391.839
New Zealand5.0NaN79.015.1177.065.71.3NaN388514.026.0...96.02.488.02.5506.014.8780.089.017.742084.399
France13.00.578.07.6765.070.50.531304.0280653.021.0...90.01.866.02.1496.016.3675.081.016.542643.949
Japan14.06.4NaNNaN75.072.50.229798.0305878.022.0...89.01.936.01.4529.0NaN53.087.016.443043.422
Israel21.0NaN87.015.4569.069.81.8NaNNaNNaN...88.01.284.02.5472.0NaN72.067.015.644474.065
Belgium15.01.977.04.7563.070.11.030364.0386006.021.0...91.02.274.02.0503.015.7089.084.019.345979.691
Canada7.00.291.03.6973.082.21.330854.0423849.022.0...93.02.688.02.9523.014.5668.091.017.347931.460
Germany14.00.287.04.2675.072.50.534294.0259667.020.0...90.01.865.01.8508.015.6276.091.018.147992.322
Finland6.00.588.03.8170.085.11.329943.0200827.023.0...95.01.970.02.2523.015.1767.095.019.850774.198
Austria16.00.985.06.6672.080.60.533541.0308325.021.0...92.01.670.01.3492.014.5580.092.017.051330.462
Sweden6.00.083.01.0777.075.60.931287.0NaN19.0...91.01.775.02.0496.015.1886.096.019.351892.079
Australia5.0NaN81.013.0473.063.51.132759.0427064.020.0...95.0NaN85.02.7502.014.3591.093.021.052952.268
Netherlands14.00.178.00.4276.082.00.629333.0157824.019.0...91.01.976.02.6508.0NaN82.093.018.753873.370
Denmark9.00.581.02.3474.083.50.629606.0118637.023.0...95.01.971.02.0504.015.8786.095.019.561732.569
Iceland3.00.077.015.0686.086.00.5NaNNaN24.0...98.01.676.02.1481.0NaN79.099.019.066601.877
United States10.00.191.011.0970.073.95.545284.0632100.019.0...91.02.488.03.1488.014.4465.083.017.267426.835
Norway5.00.082.02.9374.090.10.435725.0228936.017.0...94.02.177.02.2504.015.5678.098.018.378333.222
Ireland7.01.082.05.2567.075.90.725310.0217130.020.0...95.02.183.01.3509.0NaN65.085.018.180264.835
Switzerland15.00.188.00.3780.085.30.637466.0NaN22.0...93.01.978.02.3506.0NaN49.095.017.586673.501
Luxembourg12.00.577.03.8266.075.80.639264.0769053.021.0...93.01.969.01.7483.0NaN91.084.015.1116727.211
\n", "

40 rows × 25 columns

\n", "
" ], "text/plain": [ " Air pollution Dwellings without basic facilities \\\n", "Country \n", "South Africa 22.0 37.0 \n", "Colombia 10.0 23.9 \n", "Brazil 10.0 6.7 \n", "Turkey 20.0 8.0 \n", "Mexico 16.0 25.5 \n", "Russia 15.0 14.8 \n", "Chile 16.0 9.4 \n", "Poland 22.0 3.0 \n", "Hungary 19.0 4.7 \n", "Latvia 11.0 13.9 \n", "Lithuania 14.0 13.6 \n", "Slovak Republic 21.0 1.2 \n", "Greece 18.0 0.5 \n", "Portugal 10.0 1.0 \n", "Czech Republic 20.0 0.7 \n", "Estonia 8.0 7.0 \n", "Slovenia 16.0 0.4 \n", "Spain 11.0 0.1 \n", "Korea 28.0 2.5 \n", "Italy 18.0 0.7 \n", "United Kingdom 11.0 0.3 \n", "New Zealand 5.0 NaN \n", "France 13.0 0.5 \n", "Japan 14.0 6.4 \n", "Israel 21.0 NaN \n", "Belgium 15.0 1.9 \n", "Canada 7.0 0.2 \n", "Germany 14.0 0.2 \n", "Finland 6.0 0.5 \n", "Austria 16.0 0.9 \n", "Sweden 6.0 0.0 \n", "Australia 5.0 NaN \n", "Netherlands 14.0 0.1 \n", "Denmark 9.0 0.5 \n", "Iceland 3.0 0.0 \n", "United States 10.0 0.1 \n", "Norway 5.0 0.0 \n", "Ireland 7.0 1.0 \n", "Switzerland 15.0 0.1 \n", "Luxembourg 12.0 0.5 \n", "\n", " Educational attainment Employees working very long hours \\\n", "Country \n", "South Africa 73.0 18.12 \n", "Colombia 54.0 26.56 \n", "Brazil 49.0 7.13 \n", "Turkey 39.0 32.64 \n", "Mexico 38.0 28.70 \n", "Russia 94.0 0.14 \n", "Chile 65.0 9.72 \n", "Poland 92.0 5.95 \n", "Hungary 84.0 3.03 \n", "Latvia 88.0 1.27 \n", "Lithuania 93.0 0.54 \n", "Slovak Republic 91.0 4.14 \n", "Greece 73.0 6.42 \n", "Portugal 48.0 8.27 \n", "Czech Republic 94.0 5.65 \n", "Estonia 89.0 2.42 \n", "Slovenia 88.0 4.39 \n", "Spain 59.0 4.01 \n", "Korea 88.0 NaN \n", "Italy 61.0 4.11 \n", "United Kingdom 81.0 12.15 \n", "New Zealand 79.0 15.11 \n", "France 78.0 7.67 \n", "Japan NaN NaN \n", "Israel 87.0 15.45 \n", "Belgium 77.0 4.75 \n", "Canada 91.0 3.69 \n", "Germany 87.0 4.26 \n", "Finland 88.0 3.81 \n", "Austria 85.0 6.66 \n", "Sweden 83.0 1.07 \n", "Australia 81.0 13.04 \n", "Netherlands 78.0 0.42 \n", "Denmark 81.0 2.34 \n", "Iceland 77.0 15.06 \n", "United States 91.0 11.09 \n", "Norway 82.0 2.93 \n", "Ireland 82.0 5.25 \n", "Switzerland 88.0 0.37 \n", "Luxembourg 77.0 3.82 \n", "\n", " Employment rate Feeling safe walking alone at night \\\n", "Country \n", "South Africa 43.0 36.1 \n", "Colombia 67.0 44.4 \n", "Brazil 61.0 35.6 \n", "Turkey 52.0 59.8 \n", "Mexico 61.0 41.8 \n", "Russia 70.0 52.8 \n", "Chile 63.0 47.9 \n", "Poland 66.0 67.3 \n", "Hungary 68.0 56.3 \n", "Latvia 70.0 62.4 \n", "Lithuania 70.0 55.9 \n", "Slovak Republic 66.0 63.5 \n", "Greece 53.0 60.0 \n", "Portugal 68.0 73.4 \n", "Czech Republic 74.0 72.3 \n", "Estonia 74.0 69.0 \n", "Slovenia 69.0 86.1 \n", "Spain 62.0 82.1 \n", "Korea 67.0 66.6 \n", "Italy 58.0 58.4 \n", "United Kingdom 75.0 77.7 \n", "New Zealand 77.0 65.7 \n", "France 65.0 70.5 \n", "Japan 75.0 72.5 \n", "Israel 69.0 69.8 \n", "Belgium 63.0 70.1 \n", "Canada 73.0 82.2 \n", "Germany 75.0 72.5 \n", "Finland 70.0 85.1 \n", "Austria 72.0 80.6 \n", "Sweden 77.0 75.6 \n", "Australia 73.0 63.5 \n", "Netherlands 76.0 82.0 \n", "Denmark 74.0 83.5 \n", "Iceland 86.0 86.0 \n", "United States 70.0 73.9 \n", "Norway 74.0 90.1 \n", "Ireland 67.0 75.9 \n", "Switzerland 80.0 85.3 \n", "Luxembourg 66.0 75.8 \n", "\n", " Homicide rate Household net adjusted disposable income \\\n", "Country \n", "South Africa 13.7 NaN \n", "Colombia 24.5 NaN \n", "Brazil 26.7 NaN \n", "Turkey 1.4 NaN \n", "Mexico 18.1 NaN \n", "Russia 9.6 NaN \n", "Chile 4.2 NaN \n", "Poland 0.7 19814.0 \n", "Hungary 1.0 NaN \n", "Latvia 4.8 16275.0 \n", "Lithuania 3.4 21660.0 \n", "Slovak Republic 0.8 20474.0 \n", "Greece 0.8 17700.0 \n", "Portugal 1.0 21203.0 \n", "Czech Republic 0.5 21453.0 \n", "Estonia 3.1 19697.0 \n", "Slovenia 0.6 20820.0 \n", "Spain 0.6 23999.0 \n", "Korea 1.0 21882.0 \n", "Italy 0.6 26588.0 \n", "United Kingdom 0.2 28715.0 \n", "New Zealand 1.3 NaN \n", "France 0.5 31304.0 \n", "Japan 0.2 29798.0 \n", "Israel 1.8 NaN \n", "Belgium 1.0 30364.0 \n", "Canada 1.3 30854.0 \n", "Germany 0.5 34294.0 \n", "Finland 1.3 29943.0 \n", "Austria 0.5 33541.0 \n", "Sweden 0.9 31287.0 \n", "Australia 1.1 32759.0 \n", "Netherlands 0.6 29333.0 \n", "Denmark 0.6 29606.0 \n", "Iceland 0.5 NaN \n", "United States 5.5 45284.0 \n", "Norway 0.4 35725.0 \n", "Ireland 0.7 25310.0 \n", "Switzerland 0.6 37466.0 \n", "Luxembourg 0.6 39264.0 \n", "\n", " Household net wealth Housing expenditure ... \\\n", "Country ... \n", "South Africa NaN 18.0 ... \n", "Colombia NaN 17.0 ... \n", "Brazil NaN NaN ... \n", "Turkey NaN 20.0 ... \n", "Mexico NaN 20.0 ... \n", "Russia NaN 18.0 ... \n", "Chile 100967.0 18.0 ... \n", "Poland 210991.0 22.0 ... \n", "Hungary 104458.0 19.0 ... \n", "Latvia 70160.0 23.0 ... \n", "Lithuania NaN 19.0 ... \n", "Slovak Republic NaN 23.0 ... \n", "Greece 150134.0 23.0 ... \n", "Portugal 232666.0 21.0 ... \n", "Czech Republic NaN 24.0 ... \n", "Estonia 159373.0 17.0 ... \n", "Slovenia 203044.0 18.0 ... \n", "Spain 373548.0 21.0 ... \n", "Korea 285980.0 15.0 ... \n", "Italy 279889.0 23.0 ... \n", "United Kingdom 548392.0 26.0 ... \n", "New Zealand 388514.0 26.0 ... \n", "France 280653.0 21.0 ... \n", "Japan 305878.0 22.0 ... \n", "Israel NaN NaN ... \n", "Belgium 386006.0 21.0 ... \n", "Canada 423849.0 22.0 ... \n", "Germany 259667.0 20.0 ... \n", "Finland 200827.0 23.0 ... \n", "Austria 308325.0 21.0 ... \n", "Sweden NaN 19.0 ... \n", "Australia 427064.0 20.0 ... \n", "Netherlands 157824.0 19.0 ... \n", "Denmark 118637.0 23.0 ... \n", "Iceland NaN 24.0 ... \n", "United States 632100.0 19.0 ... \n", "Norway 228936.0 17.0 ... \n", "Ireland 217130.0 20.0 ... \n", "Switzerland NaN 22.0 ... \n", "Luxembourg 769053.0 21.0 ... \n", "\n", " Quality of support network Rooms per person \\\n", "Country \n", "South Africa 88.0 NaN \n", "Colombia 89.0 1.2 \n", "Brazil 90.0 NaN \n", "Turkey 86.0 1.0 \n", "Mexico 81.0 1.0 \n", "Russia 89.0 0.9 \n", "Chile 85.0 1.2 \n", "Poland 86.0 1.1 \n", "Hungary 86.0 1.2 \n", "Latvia 86.0 1.2 \n", "Lithuania 88.0 1.5 \n", "Slovak Republic 91.0 1.1 \n", "Greece 80.0 1.2 \n", "Portugal 88.0 1.7 \n", "Czech Republic 91.0 1.4 \n", "Estonia 92.0 1.6 \n", "Slovenia 92.0 1.5 \n", "Spain 93.0 1.9 \n", "Korea 78.0 1.5 \n", "Italy 92.0 1.4 \n", "United Kingdom 94.0 1.9 \n", "New Zealand 96.0 2.4 \n", "France 90.0 1.8 \n", "Japan 89.0 1.9 \n", "Israel 88.0 1.2 \n", "Belgium 91.0 2.2 \n", "Canada 93.0 2.6 \n", "Germany 90.0 1.8 \n", "Finland 95.0 1.9 \n", "Austria 92.0 1.6 \n", "Sweden 91.0 1.7 \n", "Australia 95.0 NaN \n", "Netherlands 91.0 1.9 \n", "Denmark 95.0 1.9 \n", "Iceland 98.0 1.6 \n", "United States 91.0 2.4 \n", "Norway 94.0 2.1 \n", "Ireland 95.0 2.1 \n", "Switzerland 93.0 1.9 \n", "Luxembourg 93.0 1.9 \n", "\n", " Self-reported health \\\n", "Country \n", "South Africa NaN \n", "Colombia NaN \n", "Brazil NaN \n", "Turkey 69.0 \n", "Mexico 66.0 \n", "Russia 43.0 \n", "Chile 57.0 \n", "Poland 58.0 \n", "Hungary 60.0 \n", "Latvia 47.0 \n", "Lithuania 43.0 \n", "Slovak Republic 66.0 \n", "Greece 74.0 \n", "Portugal 48.0 \n", "Czech Republic 60.0 \n", "Estonia 53.0 \n", "Slovenia 64.0 \n", "Spain 72.0 \n", "Korea 33.0 \n", "Italy 71.0 \n", "United Kingdom 69.0 \n", "New Zealand 88.0 \n", "France 66.0 \n", "Japan 36.0 \n", "Israel 84.0 \n", "Belgium 74.0 \n", "Canada 88.0 \n", "Germany 65.0 \n", "Finland 70.0 \n", "Austria 70.0 \n", "Sweden 75.0 \n", "Australia 85.0 \n", "Netherlands 76.0 \n", "Denmark 71.0 \n", "Iceland 76.0 \n", "United States 88.0 \n", "Norway 77.0 \n", "Ireland 83.0 \n", "Switzerland 78.0 \n", "Luxembourg 69.0 \n", "\n", " Stakeholder engagement for developing regulations \\\n", "Country \n", "South Africa NaN \n", "Colombia 1.4 \n", "Brazil 2.2 \n", "Turkey 1.5 \n", "Mexico 3.2 \n", "Russia NaN \n", "Chile 1.3 \n", "Poland 2.6 \n", "Hungary 1.2 \n", "Latvia 2.2 \n", "Lithuania 2.4 \n", "Slovak Republic 3.0 \n", "Greece 1.8 \n", "Portugal 1.5 \n", "Czech Republic 1.6 \n", "Estonia 2.7 \n", "Slovenia 2.5 \n", "Spain 1.8 \n", "Korea 2.9 \n", "Italy 2.5 \n", "United Kingdom 3.1 \n", "New Zealand 2.5 \n", "France 2.1 \n", "Japan 1.4 \n", "Israel 2.5 \n", "Belgium 2.0 \n", "Canada 2.9 \n", "Germany 1.8 \n", "Finland 2.2 \n", "Austria 1.3 \n", "Sweden 2.0 \n", "Australia 2.7 \n", "Netherlands 2.6 \n", "Denmark 2.0 \n", "Iceland 2.1 \n", "United States 3.1 \n", "Norway 2.2 \n", "Ireland 1.3 \n", "Switzerland 2.3 \n", "Luxembourg 1.7 \n", "\n", " Student skills Time devoted to leisure and personal care \\\n", "Country \n", "South Africa NaN 14.92 \n", "Colombia 410.0 NaN \n", "Brazil 395.0 NaN \n", "Turkey 425.0 14.79 \n", "Mexico 416.0 NaN \n", "Russia 492.0 NaN \n", "Chile 443.0 NaN \n", "Poland 504.0 14.42 \n", "Hungary 474.0 NaN \n", "Latvia 487.0 13.83 \n", "Lithuania 475.0 NaN \n", "Slovak Republic 463.0 NaN \n", "Greece 458.0 NaN \n", "Portugal 497.0 NaN \n", "Czech Republic 491.0 NaN \n", "Estonia 524.0 14.90 \n", "Slovenia 509.0 14.75 \n", "Spain 491.0 15.93 \n", "Korea 519.0 14.70 \n", "Italy 485.0 16.47 \n", "United Kingdom 500.0 14.92 \n", "New Zealand 506.0 14.87 \n", "France 496.0 16.36 \n", "Japan 529.0 NaN \n", "Israel 472.0 NaN \n", "Belgium 503.0 15.70 \n", "Canada 523.0 14.56 \n", "Germany 508.0 15.62 \n", "Finland 523.0 15.17 \n", "Austria 492.0 14.55 \n", "Sweden 496.0 15.18 \n", "Australia 502.0 14.35 \n", "Netherlands 508.0 NaN \n", "Denmark 504.0 15.87 \n", "Iceland 481.0 NaN \n", "United States 488.0 14.44 \n", "Norway 504.0 15.56 \n", "Ireland 509.0 NaN \n", "Switzerland 506.0 NaN \n", "Luxembourg 483.0 NaN \n", "\n", " Voter turnout Water quality Years in education \\\n", "Country \n", "South Africa 73.0 67.0 NaN \n", "Colombia 53.0 75.0 14.1 \n", "Brazil 79.0 73.0 16.2 \n", "Turkey 86.0 65.0 18.3 \n", "Mexico 63.0 68.0 15.2 \n", "Russia 68.0 55.0 16.2 \n", "Chile 47.0 71.0 17.5 \n", "Poland 55.0 82.0 17.6 \n", "Hungary 70.0 77.0 16.4 \n", "Latvia 59.0 79.0 18.0 \n", "Lithuania 51.0 81.0 18.4 \n", "Slovak Republic 60.0 85.0 15.8 \n", "Greece 64.0 69.0 19.0 \n", "Portugal 56.0 86.0 16.9 \n", "Czech Republic 61.0 87.0 17.9 \n", "Estonia 64.0 84.0 17.7 \n", "Slovenia 53.0 90.0 18.3 \n", "Spain 70.0 72.0 17.9 \n", "Korea 77.0 76.0 17.3 \n", "Italy 73.0 71.0 16.6 \n", "United Kingdom 69.0 84.0 17.5 \n", "New Zealand 80.0 89.0 17.7 \n", "France 75.0 81.0 16.5 \n", "Japan 53.0 87.0 16.4 \n", "Israel 72.0 67.0 15.6 \n", "Belgium 89.0 84.0 19.3 \n", "Canada 68.0 91.0 17.3 \n", "Germany 76.0 91.0 18.1 \n", "Finland 67.0 95.0 19.8 \n", "Austria 80.0 92.0 17.0 \n", "Sweden 86.0 96.0 19.3 \n", "Australia 91.0 93.0 21.0 \n", "Netherlands 82.0 93.0 18.7 \n", "Denmark 86.0 95.0 19.5 \n", "Iceland 79.0 99.0 19.0 \n", "United States 65.0 83.0 17.2 \n", "Norway 78.0 98.0 18.3 \n", "Ireland 65.0 85.0 18.1 \n", "Switzerland 49.0 95.0 17.5 \n", "Luxembourg 91.0 84.0 15.1 \n", "\n", " GDP per capita \n", "Country \n", "South Africa 6193.171 \n", "Colombia 6744.007 \n", "Brazil 8955.650 \n", "Turkey 9683.565 \n", "Mexico 10405.789 \n", "Russia 11305.118 \n", "Chile 15854.652 \n", "Poland 15988.035 \n", "Hungary 18535.147 \n", "Latvia 19104.841 \n", "Lithuania 20354.997 \n", "Slovak Republic 20494.627 \n", "Greece 20845.315 \n", "Portugal 23731.127 \n", "Czech Republic 24569.058 \n", "Estonia 24802.770 \n", "Slovenia 27452.323 \n", "Spain 30734.119 \n", "Korea 31246.041 \n", "Italy 33431.250 \n", "United Kingdom 40391.839 \n", "New Zealand 42084.399 \n", "France 42643.949 \n", "Japan 43043.422 \n", "Israel 44474.065 \n", "Belgium 45979.691 \n", "Canada 47931.460 \n", "Germany 47992.322 \n", "Finland 50774.198 \n", "Austria 51330.462 \n", "Sweden 51892.079 \n", "Australia 52952.268 \n", "Netherlands 53873.370 \n", "Denmark 61732.569 \n", "Iceland 66601.877 \n", "United States 67426.835 \n", "Norway 78333.222 \n", "Ireland 80264.835 \n", "Switzerland 86673.501 \n", "Luxembourg 116727.211 \n", "\n", "[40 rows x 25 columns]" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "display(full_country_stats)" ] }, { "cell_type": "code", "execution_count": 78, "metadata": {}, "outputs": [], "source": [ "full_country_stats.to_csv(r'data\\andy_country_stats.csv')\n" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [ " " ] } ], "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.7.6" } }, "nbformat": 4, "nbformat_minor": 2 }