{ "cells": [ { "cell_type": "code", "execution_count": 1, "metadata": {}, "outputs": [], "source": [ "# Data Manipulation Tools\n", "import pandas as pd\n", "\n", "from sklearn import preprocessing\n", "from sklearn.preprocessing import StandardScaler # For scaling dataset\n", "from sklearn.cluster import KMeans #For clustering\n", "\n", "# Data Visualization Tools\n", "import seaborn as sns \n", "import plotly.graph_objs as go # version=2.7.0\n", "import matplotlib.pyplot as plt" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Data Overview" ] }, { "cell_type": "code", "execution_count": 25, "metadata": { "scrolled": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Index(['indicator', 'population', 'gdp_per_cap', 'gdp', 'gdp_growth',\n", " 'gdp_per_km2', 'land_area', 'population_density', 'total_foreign_born',\n", " 'per_foreign_born', 'population_living_abroad_diaspora',\n", " 'population_living_abroad', 'happy_planet_index', 'world_happiness',\n", " 'human_development_index', 'health_expenditure', 'government_spending',\n", " 'sustainable_economic_development_assessment(seda)', 'employment',\n", " 'political_stability&absence_of_violence', 'control_of_corruption',\n", " 'judicial_effectiveness', 'government_integrity', 'property_rights',\n", " 'tax_burden', 'overall_economic_freedom', 'financial_freedom'],\n", " dtype='object')\n" ] } ], "source": [ "\n", "# pd.options.display.float_format = '{:,.5f}'.format\n", "\n", "# Transform df(Dataframe) to numeric dtype\n", "df = pd.read_excel(\"Datasets_cleaned.xlsx\", 0)\n", "# cols = df.columns\n", "\n", "# cols\n", "print(df.columns)" ] }, { "cell_type": "code", "execution_count": 26, "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ " population gdp_per_cap gdp gdp_per_km2 \\\n", "count 67.00000 67.00000 67.00000 67.00000 \n", "mean 1,873,134.32836 42.46866 21,050.87015 4,926,014.63806 \n", "std 1,565,981.35458 70.89179 24,102.55335 13,309,816.67525 \n", "min 100,000.00000 0.20000 651.90000 5,136.56852 \n", "25% 450,000.00000 3.45000 6,107.70000 199,950.89965 \n", "50% 1,300,000.00000 18.40000 11,840.20000 812,864.46369 \n", "75% 3,000,000.00000 40.35000 26,656.00000 2,714,976.69619 \n", "max 4,900,000.00000 329.20000 127,659.60000 88,026,315.78947 \n", "\n", " land_area population_density government_spending \n", "count 67.00000 67.00000 67.00000 \n", "mean 112,900.59701 187.12315 58.40149 \n", "std 261,572.49117 345.60623 20.51883 \n", "min 298.00000 1.97974 0.00000 \n", "25% 4,580.50000 26.84716 47.00000 \n", "50% 22,806.00000 73.72588 63.40000 \n", "75% 65,781.50000 187.86034 72.70000 \n", "max 1,553,556.00000 1,935.90662 94.60000 \n" ] } ], "source": [ "print(df.describe())" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# Data Processing" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Data Cleaning" ] }, { "cell_type": "code", "execution_count": 30, "metadata": { "scrolled": true }, "outputs": [], "source": [ "## Clean columns\n", "df = df.drop(columns=[\"happy_planet_index\",\"world_happiness\"], errors='ignore')\n", "\n", "# Transform to float type\n", "for i in df.columns[1:]:\n", " # The reason to use pd.to_numeric instead of astyle \n", " # is that the former transforms invalid data to NaN,\n", " # while the other does not.\n", " df[i] = pd.to_numeric(df[i],downcast='float', errors='coerce')" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Data Preprocessing" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "missing values:drop rows that have more than 20% NAN, and drop happiness planet and world happiness index" ] }, { "cell_type": "code", "execution_count": 31, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", " | indicator | \n", "population | \n", "gdp_per_cap | \n", "gdp | \n", "gdp_growth | \n", "gdp_per_km2 | \n", "land_area | \n", "population_density | \n", "total_foreign_born | \n", "per_foreign_born | \n", "... | \n", "sustainable_economic_development_assessment(seda) | \n", "employment | \n", "political_stability&absence_of_violence | \n", "control_of_corruption | \n", "judicial_effectiveness | \n", "government_integrity | \n", "property_rights | \n", "tax_burden | \n", "overall_economic_freedom | \n", "financial_freedom | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "Albania | \n", "2,900,000.00000 | \n", "34.20000 | \n", "11,840.20020 | \n", "1.50000 | \n", "1,248,266.25000 | \n", "27,398.00000 | \n", "104.87070 | \n", "57,616.00000 | \n", "3.10000 | \n", "... | \n", "53.10000 | \n", "91.50000 | \n", "-2.78000 | \n", "-1.52000 | \n", "28.20000 | \n", "26.20000 | \n", "17.90000 | \n", "91.80000 | \n", "51.30000 | \n", "10.00000 | \n", "
1 | \n", "Armenia | \n", "3,000,000.00000 | \n", "25.80000 | \n", "8,621.00000 | \n", "2.60000 | \n", "914,796.31250 | \n", "28,203.00000 | \n", "102.93115 | \n", "191,199.00000 | \n", "10.60000 | \n", "... | \n", "51.70000 | \n", "83.70000 | \n", "0.40000 | \n", "-0.42000 | \n", "25.40000 | \n", "39.90000 | \n", "54.10000 | \n", "85.10000 | \n", "64.50000 | \n", "70.00000 | \n", "
2 | \n", "Bahamas | \n", "400,000.00000 | \n", "9.00000 | \n", "24,555.19922 | \n", "3.70000 | \n", "899,100.87500 | \n", "10,010.00000 | \n", "39.49660 | \n", "59,306.00000 | \n", "16.30000 | \n", "... | \n", "60.40000 | \n", "88.80000 | \n", "-0.96000 | \n", "-0.61000 | \n", "35.20000 | \n", "29.00000 | \n", "27.80000 | \n", "74.00000 | \n", "44.70000 | \n", "30.00000 | \n", "
4 | \n", "Barbados | \n", "300,000.00000 | \n", "4.80000 | \n", "17,100.19922 | \n", "3.00000 | \n", "11,162,791.00000 | \n", "430.00000 | \n", "664.46277 | \n", "34,475.00000 | \n", "11.30000 | \n", "... | \n", "60.80000 | \n", "93.40000 | \n", "-0.29000 | \n", "-1.41000 | \n", "25.40000 | \n", "18.90000 | \n", "36.00000 | \n", "82.40000 | \n", "48.60000 | \n", "40.00000 | \n", "
6 | \n", "Bhutan | \n", "800,000.00000 | \n", "6.50000 | \n", "8,227.40039 | \n", "1.20000 | \n", "169,297.28125 | \n", "38,394.00000 | \n", "21.18766 | \n", "51,106.00000 | \n", "6.70000 | \n", "... | \n", "47.70000 | \n", "93.40000 | \n", "0.18000 | \n", "-0.26000 | \n", "44.50000 | \n", "32.60000 | \n", "40.80000 | \n", "65.70000 | \n", "52.30000 | \n", "60.00000 | \n", "
7 | \n", "Bosnia and Herzegovina | \n", "3,900,000.00000 | \n", "42.20000 | \n", "10,957.50000 | \n", "3.00000 | \n", "824,428.06250 | \n", "51,187.00000 | \n", "68.49643 | \n", "34,803.00000 | \n", "0.60000 | \n", "... | \n", "50.20000 | \n", "83.20000 | \n", "-0.71000 | \n", "-0.56000 | \n", "47.40000 | \n", "40.50000 | \n", "55.30000 | \n", "84.70000 | \n", "68.70000 | \n", "70.00000 | \n", "
8 | \n", "Botswana | \n", "2,200,000.00000 | \n", "36.70000 | \n", "17,041.59961 | \n", "2.50000 | \n", "64,757.46875 | \n", "566,730.00000 | \n", "4.04366 | \n", "160,644.00000 | \n", "7.20000 | \n", "... | \n", "44.10000 | \n", "94.30000 | \n", "0.90000 | \n", "1.80000 | \n", "93.40000 | \n", "77.40000 | \n", "78.70000 | \n", "63.00000 | \n", "80.90000 | \n", "90.00000 | \n", "
9 | \n", "Brunei Darussalam | \n", "400,000.00000 | \n", "32.50000 | \n", "76,884.00000 | \n", "0.90000 | \n", "6,172,839.50000 | \n", "5,265.00000 | \n", "81.34668 | \n", "102,733.00000 | \n", "49.30000 | \n", "... | \n", "72.50000 | \n", "93.90000 | \n", "1.04000 | \n", "1.53000 | \n", "80.90000 | \n", "73.50000 | \n", "83.50000 | \n", "49.90000 | \n", "71.80000 | \n", "70.00000 | \n", "
10 | \n", "Cabo Verde | \n", "500,000.00000 | \n", "3.50000 | \n", "6,662.00000 | \n", "1.10000 | \n", "867,840.31250 | \n", "4,033.00000 | \n", "135.58015 | \n", "14,924.00000 | \n", "3.00000 | \n", "... | \n", "nan | \n", "94.90000 | \n", "-0.76000 | \n", "-0.88000 | \n", "36.80000 | \n", "39.90000 | \n", "53.60000 | \n", "87.50000 | \n", "64.30000 | \n", "60.00000 | \n", "
11 | \n", "Central African Republic | \n", "4,900,000.00000 | \n", "3.20000 | \n", "651.90002 | \n", "0.50000 | \n", "5,136.56836 | \n", "622,984.00000 | \n", "7.47870 | \n", "81,598.00000 | \n", "2.90000 | \n", "... | \n", "16.10000 | \n", "84.70000 | \n", "1.00000 | \n", "1.17000 | \n", "53.50000 | \n", "50.90000 | \n", "46.50000 | \n", "96.50000 | \n", "63.30000 | \n", "60.00000 | \n", "
12 | \n", "Comoros | \n", "800,000.00000 | \n", "1.30000 | \n", "1,529.19995 | \n", "3.20000 | \n", "581,655.50000 | \n", "2,235.00000 | \n", "437.35196 | \n", "12,555.00000 | \n", "1.70000 | \n", "... | \n", "nan | \n", "98.70000 | \n", "-0.95000 | \n", "-0.14000 | \n", "55.10000 | \n", "51.80000 | \n", "62.10000 | \n", "99.90000 | \n", "67.70000 | \n", "80.00000 | \n", "
13 | \n", "Congo | \n", "4,500,000.00000 | \n", "29.80000 | \n", "6,676.10010 | \n", "6.40000 | \n", "87,262.07812 | \n", "341,500.00000 | \n", "15.40483 | \n", "392,996.00000 | \n", "9.70000 | \n", "... | \n", "32.70000 | \n", "95.90000 | \n", "-1.25000 | \n", "-0.83000 | \n", "32.60000 | \n", "21.20000 | \n", "32.40000 | \n", "72.70000 | \n", "55.10000 | \n", "30.00000 | \n", "
14 | \n", "Costa Rica | \n", "4,900,000.00000 | \n", "80.70000 | \n", "16,435.80078 | \n", "0.50000 | \n", "1,580,493.50000 | \n", "51,060.00000 | \n", "96.07851 | \n", "421,697.00000 | \n", "8.70000 | \n", "... | \n", "58.90000 | \n", "88.60000 | \n", "0.98000 | \n", "1.42000 | \n", "54.40000 | \n", "53.80000 | \n", "51.40000 | \n", "74.00000 | \n", "57.00000 | \n", "60.00000 | \n", "
15 | \n", "Croatia | \n", "4,200,000.00000 | \n", "95.10000 | \n", "22,795.30078 | \n", "-3.90000 | \n", "1,699,003.12500 | \n", "55,974.00000 | \n", "73.72588 | \n", "576,883.00000 | \n", "17.60000 | \n", "... | \n", "64.50000 | \n", "99.50000 | \n", "0.03000 | \n", "-0.26000 | \n", "57.30000 | \n", "42.00000 | \n", "53.50000 | \n", "89.80000 | \n", "58.10000 | \n", "10.00000 | \n", "
16 | \n", "Cyprus | \n", "800,000.00000 | \n", "29.70000 | \n", "34,970.30078 | \n", "1.40000 | \n", "3,213,938.00000 | \n", "9,241.00000 | \n", "127.65704 | \n", "196,167.00000 | \n", "18.20000 | \n", "... | \n", "65.90000 | \n", "91.70000 | \n", "0.42000 | \n", "1.50000 | \n", "69.50000 | \n", "70.90000 | \n", "81.20000 | \n", "44.00000 | \n", "67.50000 | \n", "70.00000 | \n", "
17 | \n", "Djibouti | \n", "1,000,000.00000 | \n", "3.30000 | \n", "3,369.60010 | \n", "1.50000 | \n", "142,364.10938 | \n", "23,180.00000 | \n", "41.28494 | \n", "112,351.00000 | \n", "14.20000 | \n", "... | \n", "nan | \n", "89.00000 | \n", "0.05000 | \n", "-0.27000 | \n", "53.50000 | \n", "34.70000 | \n", "42.10000 | \n", "80.00000 | \n", "57.10000 | \n", "50.00000 | \n", "
18 | \n", "Dominica | \n", "100,000.00000 | \n", "0.80000 | \n", "11,374.59961 | \n", "5.20000 | \n", "1,065,246.37500 | \n", "751.00000 | \n", "98.56667 | \n", "6,720.00000 | \n", "8.90000 | \n", "... | \n", "nan | \n", "99.00000 | \n", "0.05000 | \n", "-0.55000 | \n", "31.30000 | \n", "30.20000 | \n", "35.50000 | \n", "67.40000 | \n", "56.70000 | \n", "50.00000 | \n", "
19 | \n", "Equatorial Guinea | \n", "800,000.00000 | \n", "31.70000 | \n", "38,639.10156 | \n", "7.70000 | \n", "1,130,084.50000 | \n", "28,051.00000 | \n", "45.19390 | \n", "10,825.00000 | \n", "1.30000 | \n", "... | \n", "nan | \n", "97.60000 | \n", "1.13000 | \n", "1.57000 | \n", "51.60000 | \n", "50.90000 | \n", "60.90000 | \n", "83.00000 | \n", "61.80000 | \n", "30.00000 | \n", "
20 | \n", "Estonia | \n", "1,300,000.00000 | \n", "38.50000 | \n", "29,312.90039 | \n", "4.80000 | \n", "908,275.93750 | \n", "42,388.00000 | \n", "31.03279 | \n", "202,348.00000 | \n", "16.40000 | \n", "... | \n", "70.80000 | \n", "96.30000 | \n", "-0.30000 | \n", "-0.66000 | \n", "11.40000 | \n", "23.10000 | \n", "19.00000 | \n", "85.70000 | \n", "44.10000 | \n", "40.00000 | \n", "
21 | \n", "Eswatini | \n", "1,100,000.00000 | \n", "11.10000 | \n", "9,775.79980 | \n", "2.80000 | \n", "645,198.81250 | \n", "17,204.00000 | \n", "79.49151 | \n", "31,579.00000 | \n", "2.00000 | \n", "... | \n", "nan | \n", "74.20000 | \n", "-0.38000 | \n", "-0.52000 | \n", "43.70000 | \n", "28.40000 | \n", "39.50000 | \n", "83.50000 | \n", "61.40000 | \n", "60.00000 | \n", "
22 | \n", "Fiji | \n", "900,000.00000 | \n", "8.30000 | \n", "9,268.09961 | \n", "-0.30000 | \n", "454,197.21875 | \n", "18,274.00000 | \n", "49.56223 | \n", "13,751.00000 | \n", "2.50000 | \n", "... | \n", "49.00000 | \n", "81.60000 | \n", "1.03000 | \n", "0.80000 | \n", "54.70000 | \n", "56.60000 | \n", "57.70000 | \n", "76.10000 | \n", "69.90000 | \n", "70.00000 | \n", "
23 | \n", "Gabon | \n", "1,900,000.00000 | \n", "35.90000 | \n", "19,056.50000 | \n", "-3.80000 | \n", "139,327.10938 | \n", "257,667.00000 | \n", "7.85942 | \n", "268,384.00000 | \n", "23.60000 | \n", "... | \n", "40.90000 | \n", "88.50000 | \n", "-0.41000 | \n", "-0.53000 | \n", "55.50000 | \n", "31.40000 | \n", "55.80000 | \n", "70.60000 | \n", "51.40000 | \n", "50.00000 | \n", "
24 | \n", "Gambia | \n", "2,100,000.00000 | \n", "3.40000 | \n", "1,666.59998 | \n", "-0.20000 | \n", "335,968.37500 | \n", "10,120.00000 | \n", "207.56601 | \n", "192,540.00000 | \n", "8.80000 | \n", "... | \n", "40.90000 | \n", "98.00000 | \n", "1.19000 | \n", "0.71000 | \n", "57.10000 | \n", "45.40000 | \n", "56.60000 | \n", "85.60000 | \n", "64.20000 | \n", "50.00000 | \n", "
25 | \n", "Georgia | \n", "3,700,000.00000 | \n", "37.20000 | \n", "10,043.79980 | \n", "3.00000 | \n", "533,715.93750 | \n", "69,700.00000 | \n", "65.03201 | \n", "168,802.00000 | \n", "4.40000 | \n", "... | \n", "55.40000 | \n", "92.00000 | \n", "0.37000 | \n", "-0.16000 | \n", "42.50000 | \n", "38.20000 | \n", "63.60000 | \n", "90.90000 | \n", "68.30000 | \n", "60.00000 | \n", "
26 | \n", "Guinea-Bissau | \n", "1,700,000.00000 | \n", "2.90000 | \n", "1,729.90002 | \n", "4.00000 | \n", "103,129.44531 | \n", "28,120.00000 | \n", "66.19072 | \n", "22,333.00000 | \n", "1.10000 | \n", "... | \n", "nan | \n", "97.00000 | \n", "-0.92000 | \n", "-0.11000 | \n", "47.10000 | \n", "31.80000 | \n", "42.10000 | \n", "80.60000 | \n", "60.00000 | \n", "40.00000 | \n", "
27 | \n", "Guyana | \n", "800,000.00000 | \n", "6.00000 | \n", "7,872.89990 | \n", "-4.10000 | \n", "30,480.21484 | \n", "196,849.00000 | \n", "3.95153 | \n", "15,384.00000 | \n", "1.70000 | \n", "... | \n", "42.80000 | \n", "98.40000 | \n", "-1.97000 | \n", "-1.28000 | \n", "21.70000 | \n", "26.20000 | \n", "17.60000 | \n", "71.00000 | \n", "50.90000 | \n", "30.00000 | \n", "
28 | \n", "Iceland | \n", "300,000.00000 | \n", "16.50000 | \n", "49,135.60156 | \n", "1.80000 | \n", "164,588.53125 | \n", "100,250.00000 | \n", "3.40433 | \n", "37,522.00000 | \n", "10.70000 | \n", "... | \n", "83.70000 | \n", "89.50000 | \n", "0.90000 | \n", "0.84000 | \n", "52.00000 | \n", "42.80000 | \n", "42.10000 | \n", "74.00000 | \n", "60.00000 | \n", "60.00000 | \n", "
29 | \n", "Ireland | \n", "4,700,000.00000 | \n", "324.89999 | \n", "69,230.79688 | \n", "6.90000 | \n", "4,716,693.50000 | \n", "68,883.00000 | \n", "69.87383 | \n", "746,260.00000 | \n", "15.90000 | \n", "... | \n", "80.30000 | \n", "99.70000 | \n", "0.17000 | \n", "-1.29000 | \n", "24.50000 | \n", "17.70000 | \n", "36.00000 | \n", "89.80000 | \n", "58.70000 | \n", "50.00000 | \n", "
30 | \n", "Jamaica | \n", "2,800,000.00000 | \n", "25.40000 | \n", "8,975.70020 | \n", "5.90000 | \n", "2,345,120.50000 | \n", "10,831.00000 | \n", "266.87894 | \n", "23,167.00000 | \n", "1.30000 | \n", "... | \n", "49.70000 | \n", "95.50000 | \n", "-1.08000 | \n", "-1.18000 | \n", "29.40000 | \n", "23.40000 | \n", "40.60000 | \n", "73.70000 | \n", "51.90000 | \n", "50.00000 | \n", "
31 | \n", "Kiribati | \n", "100,000.00000 | \n", "0.20000 | \n", "1,823.30005 | \n", "1.20000 | \n", "246,609.12500 | \n", "811.00000 | \n", "143.70123 | \n", "3,153.00000 | \n", "2.60000 | \n", "... | \n", "nan | \n", "92.90000 | \n", "1.11000 | \n", "1.92000 | \n", "77.10000 | \n", "78.30000 | \n", "87.50000 | \n", "76.70000 | \n", "77.70000 | \n", "80.00000 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
37 | \n", "Liberia | \n", "4,400,000.00000 | \n", "3.80000 | \n", "855.09998 | \n", "1.00000 | \n", "39,451.82812 | \n", "96,320.00000 | \n", "49.12693 | \n", "113,779.00000 | \n", "5.30000 | \n", "... | \n", "30.60000 | \n", "80.00000 | \n", "0.03000 | \n", "-0.68000 | \n", "28.20000 | \n", "27.50000 | \n", "36.70000 | \n", "59.70000 | \n", "56.20000 | \n", "30.00000 | \n", "
38 | \n", "Lithuania | \n", "2,900,000.00000 | \n", "86.10000 | \n", "29,972.30078 | \n", "7.70000 | \n", "1,373,643.87500 | \n", "62,680.00000 | \n", "45.13521 | \n", "136,036.00000 | \n", "4.90000 | \n", "... | \n", "67.40000 | \n", "96.40000 | \n", "-2.30000 | \n", "-1.42000 | \n", "23.90000 | \n", "27.30000 | \n", "24.10000 | \n", "73.20000 | \n", "52.10000 | \n", "20.00000 | \n", "
39 | \n", "Luxembourg | \n", "600,000.00000 | \n", "59.90000 | \n", "104,003.29688 | \n", "2.50000 | \n", "23,163,186.00000 | \n", "2,586.00000 | \n", "231.44749 | \n", "249,325.00000 | \n", "43.30000 | \n", "... | \n", "83.20000 | \n", "88.80000 | \n", "-0.53000 | \n", "-1.33000 | \n", "28.20000 | \n", "24.60000 | \n", "32.40000 | \n", "60.80000 | \n", "38.90000 | \n", "30.00000 | \n", "
40 | \n", "Macedonia | \n", "2,100,000.00000 | \n", "30.30000 | \n", "14,597.00000 | \n", "3.70000 | \n", "1,191,365.50000 | \n", "25,433.00000 | \n", "82.59953 | \n", "130,730.00000 | \n", "6.60000 | \n", "... | \n", "52.50000 | \n", "91.00000 | \n", "0.51000 | \n", "0.47000 | \n", "57.80000 | \n", "51.80000 | \n", "54.80000 | \n", "79.30000 | \n", "65.60000 | \n", "50.00000 | \n", "
41 | \n", "Maldives | \n", "400,000.00000 | \n", "5.50000 | \n", "15,553.00000 | \n", "8.60000 | \n", "18,456,376.00000 | \n", "298.00000 | \n", "1,454.43335 | \n", "94,086.00000 | \n", "24.40000 | \n", "... | \n", "nan | \n", "90.70000 | \n", "-1.09000 | \n", "-0.52000 | \n", "44.20000 | \n", "36.60000 | \n", "39.40000 | \n", "76.40000 | \n", "62.00000 | \n", "50.00000 | \n", "
42 | \n", "Malta | \n", "400,000.00000 | \n", "17.30000 | \n", "39,833.80078 | \n", "1.60000 | \n", "54,746,836.00000 | \n", "316.00000 | \n", "1,454.03748 | \n", "41,442.00000 | \n", "8.00000 | \n", "... | \n", "68.80000 | \n", "86.50000 | \n", "0.75000 | \n", "0.19000 | \n", "56.50000 | \n", "40.50000 | \n", "65.90000 | \n", "66.00000 | \n", "61.00000 | \n", "60.00000 | \n", "
43 | \n", "Mauritania | \n", "3,800,000.00000 | \n", "16.40000 | \n", "4,328.00000 | \n", "4.30000 | \n", "15,911.51660 | \n", "1,030,700.00000 | \n", "4.28853 | \n", "138,162.00000 | \n", "2.30000 | \n", "... | \n", "28.90000 | \n", "97.10000 | \n", "0.69000 | \n", "0.27000 | \n", "10.00000 | \n", "38.10000 | \n", "29.70000 | \n", "49.00000 | \n", "31.90000 | \n", "10.00000 | \n", "
44 | \n", "Mauritius | \n", "1,300,000.00000 | \n", "25.90000 | \n", "20,421.59961 | \n", "1.60000 | \n", "12,758,621.00000 | \n", "2,030.00000 | \n", "622.96210 | \n", "28,585.00000 | \n", "3.60000 | \n", "... | \n", "60.20000 | \n", "88.30000 | \n", "0.60000 | \n", "0.78000 | \n", "56.70000 | \n", "41.30000 | \n", "71.20000 | \n", "75.20000 | \n", "67.80000 | \n", "60.00000 | \n", "
45 | \n", "Micronesia | \n", "100,000.00000 | \n", "0.30000 | \n", "3,234.30005 | \n", "4.20000 | \n", "427,350.43750 | \n", "702.00000 | \n", "150.77715 | \n", "2,756.00000 | \n", "2.60000 | \n", "... | \n", "nan | \n", "96.00000 | \n", "1.02000 | \n", "0.57000 | \n", "57.90000 | \n", "51.10000 | \n", "73.00000 | \n", "82.90000 | \n", "74.20000 | \n", "80.00000 | \n", "
46 | \n", "Moldova | \n", "3,600,000.00000 | \n", "18.90000 | \n", "5,328.00000 | \n", "1.20000 | \n", "574,625.25000 | \n", "32,891.00000 | \n", "123.65451 | \n", "142,904.00000 | \n", "11.20000 | \n", "... | \n", "48.70000 | \n", "93.90000 | \n", "0.87000 | \n", "2.19000 | \n", "83.60000 | \n", "84.10000 | \n", "84.80000 | \n", "41.40000 | \n", "76.60000 | \n", "80.00000 | \n", "
47 | \n", "Mongolia | \n", "3,000,000.00000 | \n", "37.00000 | \n", "12,274.90039 | \n", "6.50000 | \n", "23,816.32812 | \n", "1,553,556.00000 | \n", "1.97974 | \n", "17,620.00000 | \n", "0.60000 | \n", "... | \n", "50.60000 | \n", "93.40000 | \n", "-0.71000 | \n", "-0.64000 | \n", "13.80000 | \n", "29.00000 | \n", "19.00000 | \n", "69.80000 | \n", "45.10000 | \n", "50.00000 | \n", "
48 | \n", "Montenegro | \n", "600,000.00000 | \n", "10.40000 | \n", "16,643.19922 | \n", "-4.30000 | \n", "773,119.25000 | \n", "13,452.00000 | \n", "46.28037 | \n", "82,541.00000 | \n", "8.20000 | \n", "... | \n", "nan | \n", "nan | \n", "1.04000 | \n", "0.65000 | \n", "69.20000 | \n", "49.90000 | \n", "48.60000 | \n", "72.90000 | \n", "64.50000 | \n", "30.00000 | \n", "
49 | \n", "Namibia | \n", "2,300,000.00000 | \n", "26.00000 | \n", "11,289.70020 | \n", "7.00000 | \n", "31,580.60938 | \n", "823,290.00000 | \n", "3.07764 | \n", "93,888.00000 | \n", "2.20000 | \n", "... | \n", "39.10000 | \n", "85.60000 | \n", "0.16000 | \n", "-0.74000 | \n", "23.10000 | \n", "26.20000 | \n", "51.70000 | \n", "84.60000 | \n", "61.60000 | \n", "40.00000 | \n", "
50 | \n", "New Zealand | \n", "4,700,000.00000 | \n", "177.00000 | \n", "37,294.00000 | \n", "0.00000 | \n", "669,093.56250 | \n", "264,537.00000 | \n", "18.20630 | \n", "1,039,736.00000 | \n", "25.10000 | \n", "... | \n", "78.60000 | \n", "94.60000 | \n", "-0.10000 | \n", "-0.60000 | \n", "23.30000 | \n", "30.20000 | \n", "36.70000 | \n", "79.40000 | \n", "48.50000 | \n", "40.00000 | \n", "
51 | \n", "Oman | \n", "4,000,000.00000 | \n", "184.80000 | \n", "46,698.00000 | \n", "4.20000 | \n", "597,092.06250 | \n", "309,500.00000 | \n", "14.97985 | \n", "1,844,978.00000 | \n", "30.60000 | \n", "... | \n", "62.10000 | \n", "88.00000 | \n", "-1.42000 | \n", "-0.54000 | \n", "52.50000 | \n", "32.20000 | \n", "32.70000 | \n", "84.20000 | \n", "53.40000 | \n", "50.00000 | \n", "
52 | \n", "Panama | \n", "4,000,000.00000 | \n", "92.90000 | \n", "23,023.90039 | \n", "2.40000 | \n", "1,249,663.75000 | \n", "74,340.00000 | \n", "55.13300 | \n", "184,710.00000 | \n", "4.70000 | \n", "... | \n", "54.50000 | \n", "93.70000 | \n", "-0.25000 | \n", "-0.51000 | \n", "35.40000 | \n", "25.20000 | \n", "37.30000 | \n", "78.90000 | \n", "63.20000 | \n", "60.00000 | \n", "
53 | \n", "Qatar | \n", "2,600,000.00000 | \n", "329.20001 | \n", "127,659.60156 | \n", "-12.20000 | \n", "28,413,602.00000 | \n", "11,586.00000 | \n", "227.32222 | \n", "1,687,640.00000 | \n", "73.80000 | \n", "... | \n", "70.80000 | \n", "92.70000 | \n", "-0.15000 | \n", "-1.83000 | \n", "17.60000 | \n", "26.20000 | \n", "29.80000 | \n", "69.60000 | \n", "42.00000 | \n", "30.00000 | \n", "
54 | \n", "Saint Lucia | \n", "200,000.00000 | \n", "2.10000 | \n", "11,782.90039 | \n", "4.80000 | \n", "3,465,346.50000 | \n", "606.00000 | \n", "293.18689 | \n", "12,771.00000 | \n", "6.70000 | \n", "... | \n", "nan | \n", "92.70000 | \n", "-0.66000 | \n", "-1.20000 | \n", "13.80000 | \n", "23.40000 | \n", "35.50000 | \n", "79.90000 | \n", "41.70000 | \n", "20.00000 | \n", "
55 | \n", "Saint Vincent and the Grenadines | \n", "100,000.00000 | \n", "1.20000 | \n", "11,270.50000 | \n", "1.10000 | \n", "3,084,833.00000 | \n", "389.00000 | \n", "281.78717 | \n", "4,577.00000 | \n", "9.40000 | \n", "... | \n", "nan | \n", "93.10000 | \n", "0.66000 | \n", "1.24000 | \n", "83.90000 | \n", "75.70000 | \n", "80.40000 | \n", "80.70000 | \n", "78.80000 | \n", "80.00000 | \n", "
56 | \n", "Samoa | \n", "200,000.00000 | \n", "1.10000 | \n", "5,553.39990 | \n", "1.70000 | \n", "389,932.65625 | \n", "2,821.00000 | \n", "69.41343 | \n", "4,929.00000 | \n", "3.00000 | \n", "... | \n", "nan | \n", "74.70000 | \n", "-0.30000 | \n", "-0.30000 | \n", "35.30000 | \n", "26.90000 | \n", "55.30000 | \n", "74.80000 | \n", "55.90000 | \n", "40.00000 | \n", "
57 | \n", "Sao Tome | \n", "200,000.00000 | \n", "0.60000 | \n", "3,071.80005 | \n", "10.20000 | \n", "622,406.62500 | \n", "964.00000 | \n", "212.84062 | \n", "2,394.00000 | \n", "3.30000 | \n", "... | \n", "nan | \n", "94.30000 | \n", "-1.69000 | \n", "-0.56000 | \n", "37.60000 | \n", "37.70000 | \n", "31.10000 | \n", "76.50000 | \n", "52.80000 | \n", "20.00000 | \n", "
58 | \n", "Seychelles | \n", "100,000.00000 | \n", "2.60000 | \n", "27,602.19922 | \n", "4.30000 | \n", "5,714,285.50000 | \n", "455.00000 | \n", "208.35435 | \n", "12,791.00000 | \n", "13.00000 | \n", "... | \n", "59.10000 | \n", "92.10000 | \n", "0.79000 | \n", "0.36000 | \n", "47.10000 | \n", "34.80000 | \n", "68.30000 | \n", "81.40000 | \n", "62.00000 | \n", "50.00000 | \n", "
59 | \n", "Slovenia | \n", "2,100,000.00000 | \n", "66.20000 | \n", "32,084.90039 | \n", "0.40000 | \n", "3,285,196.75000 | \n", "20,151.00000 | \n", "102.61906 | \n", "235,966.00000 | \n", "11.30000 | \n", "... | \n", "72.60000 | \n", "91.00000 | \n", "1.07000 | \n", "2.22000 | \n", "82.70000 | \n", "89.80000 | \n", "89.00000 | \n", "66.50000 | \n", "74.10000 | \n", "80.00000 | \n", "
60 | \n", "Solomon Islands | \n", "600,000.00000 | \n", "1.20000 | \n", "1,972.59998 | \n", "1.10000 | \n", "42,878.58203 | \n", "27,986.00000 | \n", "21.84148 | \n", "2,585.00000 | \n", "1.40000 | \n", "... | \n", "nan | \n", "90.00000 | \n", "0.21000 | \n", "1.26000 | \n", "72.70000 | \n", "65.10000 | \n", "84.00000 | \n", "47.30000 | \n", "63.90000 | \n", "70.00000 | \n", "
61 | \n", "Suriname | \n", "600,000.00000 | \n", "7.90000 | \n", "13,988.20020 | \n", "4.00000 | \n", "50,641.02734 | \n", "156,000.00000 | \n", "3.61155 | \n", "46,836.00000 | \n", "7.50000 | \n", "... | \n", "52.70000 | \n", "81.50000 | \n", "-0.09000 | \n", "-0.81000 | \n", "27.80000 | \n", "33.40000 | \n", "29.90000 | \n", "74.30000 | \n", "58.00000 | \n", "40.00000 | \n", "
62 | \n", "Timor-Leste | \n", "1,200,000.00000 | \n", "5.00000 | \n", "4,186.60010 | \n", "4.40000 | \n", "336,157.06250 | \n", "14,874.00000 | \n", "87.17626 | \n", "10,834.00000 | \n", "1.00000 | \n", "... | \n", "nan | \n", "70.30000 | \n", "nan | \n", "nan | \n", "38.80000 | \n", "36.80000 | \n", "34.40000 | \n", "71.90000 | \n", "52.30000 | \n", "50.00000 | \n", "
63 | \n", "Tonga | \n", "100,000.00000 | \n", "0.60000 | \n", "5,386.50000 | \n", "2.80000 | \n", "836,820.06250 | \n", "717.00000 | \n", "150.02777 | \n", "5,731.00000 | \n", "4.80000 | \n", "... | \n", "nan | \n", "88.40000 | \n", "-0.37000 | \n", "0.74000 | \n", "64.20000 | \n", "61.80000 | \n", "62.80000 | \n", "87.00000 | \n", "76.20000 | \n", "60.00000 | \n", "
64 | \n", "Trinidad and Tobago | \n", "1,400,000.00000 | \n", "43.60000 | \n", "31,870.30078 | \n", "1.50000 | \n", "8,502,340.00000 | \n", "5,128.00000 | \n", "266.88596 | \n", "49,883.00000 | \n", "2.40000 | \n", "... | \n", "58.70000 | \n", "95.70000 | \n", "0.58000 | \n", "1.84000 | \n", "78.00000 | \n", "75.30000 | \n", "81.00000 | \n", "61.30000 | \n", "74.20000 | \n", "70.00000 | \n", "
65 | \n", "Uruguay | \n", "3,500,000.00000 | \n", "74.90000 | \n", "21,527.30078 | \n", "3.50000 | \n", "427,963.31250 | \n", "175,015.00000 | \n", "19.75060 | \n", "71,799.00000 | \n", "2.30000 | \n", "... | \n", "64.20000 | \n", "94.20000 | \n", "0.09000 | \n", "-0.23000 | \n", "43.70000 | \n", "32.90000 | \n", "48.90000 | \n", "83.50000 | \n", "56.00000 | \n", "60.00000 | \n", "
66 | \n", "Vanuatu | \n", "300,000.00000 | \n", "0.70000 | \n", "2,631.39990 | \n", "-0.20000 | \n", "57,428.82812 | \n", "12,189.00000 | \n", "22.66153 | \n", "3,187.00000 | \n", "1.30000 | \n", "... | \n", "-64.50000 | \n", "76.10000 | \n", "-0.13000 | \n", "-0.14000 | \n", "59.00000 | \n", "37.90000 | \n", "52.30000 | \n", "60.40000 | \n", "57.30000 | \n", "40.00000 | \n", "
65 rows × 25 columns
\n", "\n", " | population | \n", "gdp_per_cap | \n", "gdp | \n", "gdp_growth | \n", "gdp_per_km2 | \n", "land_area | \n", "population_density | \n", "total_foreign_born | \n", "per_foreign_born | \n", "population_living_abroad_diaspora | \n", "... | \n", "sustainable_economic_development_assessment(seda) | \n", "employment | \n", "political_stability&absence_of_violence | \n", "control_of_corruption | \n", "judicial_effectiveness | \n", "government_integrity | \n", "property_rights | \n", "tax_burden | \n", "overall_economic_freedom | \n", "financial_freedom | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
count | \n", "65.00000 | \n", "65.00000 | \n", "65.00000 | \n", "65.00000 | \n", "65.00000 | \n", "65.00000 | \n", "65.00000 | \n", "64.00000 | \n", "64.00000 | \n", "64.00000 | \n", "... | \n", "46.00000 | \n", "64.00000 | \n", "64.00000 | \n", "64.00000 | \n", "65.00000 | \n", "65.00000 | \n", "65.00000 | \n", "65.00000 | \n", "65.00000 | \n", "65.00000 | \n", "
mean | \n", "0.00000 | \n", "-0.00000 | \n", "-0.00000 | \n", "-0.00000 | \n", "0.00000 | \n", "-0.00000 | \n", "0.00000 | \n", "-0.00000 | \n", "-0.00000 | \n", "-0.00000 | \n", "... | \n", "0.00000 | \n", "-0.00000 | \n", "-0.00000 | \n", "0.00000 | \n", "-0.00000 | \n", "0.00000 | \n", "0.00000 | \n", "-0.00000 | \n", "-0.00000 | \n", "0.00000 | \n", "
std | \n", "1.00778 | \n", "1.00778 | \n", "1.00778 | \n", "1.00778 | \n", "1.00778 | \n", "1.00778 | \n", "1.00778 | \n", "1.00791 | \n", "1.00791 | \n", "1.00791 | \n", "... | \n", "1.01105 | \n", "1.00791 | \n", "1.00791 | \n", "1.00791 | \n", "1.00778 | \n", "1.00778 | \n", "1.00778 | \n", "1.00778 | \n", "1.00778 | \n", "1.00778 | \n", "
min | \n", "-1.15279 | \n", "-0.59686 | \n", "-0.84082 | \n", "-4.32306 | \n", "-0.43846 | \n", "-0.44005 | \n", "-0.59460 | \n", "-0.46968 | \n", "-0.76103 | \n", "-0.78808 | \n", "... | \n", "-5.11444 | \n", "-3.27375 | \n", "-2.90097 | \n", "-1.75474 | \n", "-1.78433 | \n", "-1.34947 | \n", "-1.63901 | \n", "-2.64631 | \n", "-2.66445 | \n", "-2.05991 | \n", "
25% | \n", "-0.89727 | \n", "-0.55052 | \n", "-0.63619 | \n", "-0.40885 | \n", "-0.41186 | \n", "-0.42169 | \n", "-0.48721 | \n", "-0.44627 | \n", "-0.59990 | \n", "-0.63302 | \n", "... | \n", "-0.32448 | \n", "-0.38002 | \n", "-0.65938 | \n", "-0.62169 | \n", "-0.87710 | \n", "-0.79128 | \n", "-0.71615 | \n", "-0.38544 | \n", "-0.70664 | \n", "-0.52090 | \n", "
50% | \n", "-0.32235 | \n", "-0.34126 | \n", "-0.37373 | \n", "0.00317 | \n", "-0.34316 | \n", "-0.35303 | \n", "-0.32941 | \n", "-0.34889 | \n", "-0.31325 | \n", "-0.42974 | \n", "... | \n", "0.08584 | \n", "0.28898 | \n", "0.14196 | \n", "-0.23752 | \n", "-0.06457 | \n", "-0.26157 | \n", "-0.04077 | \n", "0.13568 | \n", "0.03233 | \n", "-0.00789 | \n", "
75% | \n", "0.69973 | \n", "-0.05896 | \n", "0.20531 | \n", "0.53291 | \n", "-0.16237 | \n", "-0.17923 | \n", "0.01963 | \n", "-0.10795 | \n", "0.12774 | \n", "0.22297 | \n", "... | \n", "0.56037 | \n", "0.64129 | \n", "0.83230 | \n", "0.75451 | \n", "0.57348 | \n", "0.54154 | \n", "0.65524 | \n", "0.68887 | \n", "0.75212 | \n", "0.50511 | \n", "
max | \n", "1.91345 | \n", "4.02372 | \n", "4.46156 | \n", "2.26929 | \n", "6.02048 | \n", "5.46691 | \n", "4.77406 | \n", "5.00718 | \n", "4.23914 | \n", "3.99662 | \n", "... | \n", "1.33748 | \n", "1.38155 | \n", "1.39811 | \n", "2.18420 | \n", "2.37300 | \n", "2.75721 | \n", "2.04210 | \n", "2.04378 | \n", "2.03813 | \n", "2.04413 | \n", "
8 rows × 24 columns
\n", "