co-relation_calculator.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "613013e0-736c-452e-ae38-eb82f2e2693f",
   "metadata": {},
   "source": [
    "# Co-relation calculation"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d2df2c32-641f-41c3-afc8-5c7a7f9de12e",
   "metadata": {},
   "source": [
    "#### For two comparisons, we decided to calculate the co-relation of the variables being visualised using a scatter plot so as to better understand the visualisations and this would allow us to make a (_somewhat_) generalisable insight from the data. "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0fbb982c-c53b-4b0e-b42a-748ba30c139c",
   "metadata": {},
   "source": [
    "The function that takes a pandas DataFrame df with two columns containing data for two variables, and returns the correlation coefficient between the two variables using the pearsonr function from the scipy.stats module:"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "584035c1-c2c5-463f-bff2-0edd84db8a0a",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import scipy.stats as stats\n",
    "\n",
    "viz1_2016 = [\n",
    "    {\n",
    "      \"title\": \"Estonia\",\n",
    "      \"id\": \"EE\",\n",
    "      \"PRIS_OFF_CAP\": 221.51, \n",
    "      \"PRIS_ACT_CAP\":217.64,\n",
    "      \"Living Conditions\": (217.64 / 221.51),\n",
    "      \"GF03\": 1.9\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Sweden\",\n",
    "      \"id\": \"SE\",\n",
    "      \"PRIS_OFF_CAP\": 63.47, \n",
    "      \"PRIS_ACT_CAP\": 57.44,\n",
    "      \"Living Conditions\": (57.44 / 63.47),\n",
    "      \"GF03\": 1.3\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Denmark\",\n",
    "      \"id\": \"DK\",\n",
    "      \"PRIS_OFF_CAP\": 61.71,\n",
    "      \"PRIS_ACT_CAP\": 59.71,\n",
    "      \"Living Conditions\": (61.71 / 59.71),\n",
    "      \"GF03\": 1.0\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Finland\",\n",
    "      \"id\": \"FI\",\n",
    "      \"PRIS_OFF_CAP\": 53.92,\n",
    "      \"PRIS_ACT_CAP\": 57.51,\n",
    "      \"Living Conditions\": (57.51 / 53.92),\n",
    "      \"GF03\": 1.2\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Bulgaria\",\n",
    "      \"id\": \"BG\",\n",
    "      \"PRIS_OFF_CAP\": 118.69, \n",
    "      \"PRIS_ACT_CAP\":102.67,\n",
    "      \"Living Conditions\": (61.71 / 59.71),\n",
    "      \"GF03\": 2.3\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Hungary\",\n",
    "      \"id\": \"HG\",\n",
    "      \"PRIS_OFF_CAP\": 140.11, \n",
    "      \"PRIS_ACT_CAP\":179.62,\n",
    "      \"Living Conditions\":(179.62 / 140.11),\n",
    "      \"GF03\": 2.3\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Austria\",\n",
    "      \"id\": \"AT\",\n",
    "      \"PRIS_OFF_CAP\": 101.43, \n",
    "      \"PRIS_ACT_CAP\":99.18,\n",
    "      \"Living Conditions\": (99.18 / 101.43),\n",
    "      \"GF03\": 1.3\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Poland\",\n",
    "      \"id\": \"PL\",\n",
    "      \"PRIS_OFF_CAP\": 234.88, \n",
    "      \"PRIS_ACT_CAP\":190.19,\n",
    "      \"Living Conditions\": (190.19 / 234.88),\n",
    "      \"GF03\": 2.2\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Romania\",\n",
    "      \"id\": \"RO\",\n",
    "      \"PRIS_OFF_CAP\": 141.13, \n",
    "      \"PRIS_ACT_CAP\":138.94,\n",
    "      \"Living Conditions\": (138.94 / 141.13),\n",
    "      \"GF03\": 2.1\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Slovakia\",\n",
    "      \"id\": \"SK\",\n",
    "      \"PRIS_OFF_CAP\": 203.33, \n",
    "      \"PRIS_ACT_CAP\":184.20,\n",
    "      \"Living Conditions\": (184.20 / 203.33),\n",
    "      \"GF03\": 2.4\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Slovenia\",\n",
    "      \"id\": \"SI\",\n",
    "      \"PRIS_OFF_CAP\": 64.04, \n",
    "      \"PRIS_ACT_CAP\":63.37,\n",
    "      \"Living Conditions\": (63.37 / 64.04),\n",
    "      \"GF03\": 1.7\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Greece\",\n",
    "      \"id\": \"GR\",\n",
    "      \"PRIS_OFF_CAP\": 91.02, \n",
    "      \"PRIS_ACT_CAP\":88.65,\n",
    "      \"Living Conditions\": (91.02 / 88.65), \n",
    "      \"GF03\": 2.2\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Italy\",\n",
    "      \"id\": \"IT\",\n",
    "      \"PRIS_OFF_CAP\":  83.75, \n",
    "      \"PRIS_ACT_CAP\": 92.27,\n",
    "      \"Living Conditions\": (92.27 /  83.75 ),\n",
    "      \"GF03\": 1.8\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Portugal\",\n",
    "      \"id\": \"PT\",\n",
    "      \"PRIS_OFF_CAP\": 121.84, \n",
    "      \"PRIS_ACT_CAP\":134.58,\n",
    "      \"Living Conditions\": (134.58 / 121.84),\n",
    "      \"GF03\": 1.8\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Spain\",\n",
    "      \"id\": \"ES\",\n",
    "      \"PRIS_OFF_CAP\":   138.12, \n",
    "      \"PRIS_ACT_CAP\":128.31,\n",
    "      \"Living Conditions\": (128.31 / 138.12),\n",
    "      \"GF03\": 1.9\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"France\",\n",
    "      \"id\": \"FR\",\n",
    "      \"PRIS_OFF_CAP\": 88.06, \n",
    "      \"PRIS_ACT_CAP\":102.50,\n",
    "      \"Living Conditions\": (102.50 / 88.06),\n",
    "      \"GF03\": 1.6\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Germany\",\n",
    "      \"id\": \"DE\",\n",
    "      \"PRIS_OFF_CAP\": 89.60, \n",
    "      \"PRIS_ACT_CAP\": 78.24,\n",
    "      \"Living Conditions\": (78.24 / 89.60),\n",
    "      \"GF03\": 1.5\n",
    "    }]\n",
    "\n",
    "viz1_2017 = [{\n",
    "      \"title\": \"Estonia\",\n",
    "      \"id\": \"EE\",\n",
    "      \"PRIS_OFF_CAP\": 221.57, \n",
    "      \"PRIS_ACT_CAP\":206.97,\n",
    "      \"Living Conditions\": (206.97 / 221.57) ,\n",
    "      \"GF03\": 1.9\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Sweden\",\n",
    "      \"id\": \"SE\",\n",
    "      \"PRIS_OFF_CAP\": 61.50, \n",
    "      \"PRIS_ACT_CAP\": 57.16,\n",
    "      \"Living Conditions\": 57.16 / 61.50 ,\n",
    "      \"GF03\": 1.3\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Denmark\",\n",
    "      \"id\": \"DK\",\n",
    "      \"PRIS_OFF_CAP\": 62.48,\n",
    "      \"PRIS_ACT_CAP\": 59.46,\n",
    "      \"Living Conditions\": (59.46 /  62.48) ,\n",
    "      \"GF03\": 0.9\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Finland\",\n",
    "      \"id\": \"FI\",\n",
    "      \"PRIS_OFF_CAP\": 53.10,\n",
    "      \"PRIS_ACT_CAP\": 56.00,\n",
    "      \"Living Conditions\": (56.00 / 53.10) ,\n",
    "      \"GF03\": 1.1\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Bulgaria\",\n",
    "      \"id\": \"BG\",\n",
    "      \"PRIS_OFF_CAP\": 119.56, \n",
    "      \"PRIS_ACT_CAP\":98.40,\n",
    "      \"Living Conditions\": (98.40 / 119.56) ,\n",
    "      \"GF03\": 2.5\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Hungary\",\n",
    "      \"id\": \"HG\",\n",
    "      \"PRIS_OFF_CAP\": 143.00, \n",
    "      \"PRIS_ACT_CAP\":177.01,\n",
    "      \"Living Conditions\": (177.01 / 143.00) ,\n",
    "      \"GF03\": 2.3\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Austria\",\n",
    "      \"id\": \"AT\",\n",
    "      \"PRIS_OFF_CAP\": 99.69, \n",
    "      \"PRIS_ACT_CAP\":100.90,\n",
    "      \"Living Conditions\": (100.90 / 99.69) ,\n",
    "      \"GF03\": 1.4\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Poland\",\n",
    "      \"id\": \"PL\",\n",
    "      \"PRIS_OFF_CAP\": 228.76, \n",
    "      \"PRIS_ACT_CAP\":196.14,\n",
    "      \"Living Conditions\": (196.14 / 228.76),\n",
    "      \"GF03\": 2.1\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Romania\",\n",
    "      \"id\": \"RO\",\n",
    "      \"PRIS_OFF_CAP\": 103.89, \n",
    "      \"PRIS_ACT_CAP\":119.37,\n",
    "      \"Living Conditions\": (119.37 / 103.89) ,\n",
    "      \"GF03\": 2.0\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Slovakia\",\n",
    "      \"id\": \"SK\",\n",
    "      \"PRIS_OFF_CAP\": 201.29, \n",
    "      \"PRIS_ACT_CAP\":184.50,\n",
    "      \"Living Conditions\": (184.50 / 201.29) ,\n",
    "      \"GF03\": 2.1\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Greece\",\n",
    "      \"id\": \"GR\",\n",
    "      \"PRIS_OFF_CAP\": 92.26, \n",
    "      \"PRIS_ACT_CAP\":92.97,\n",
    "      \"Living Conditions\": (92.97 / 92.26) , \n",
    "      \"GF03\": 2.1\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Italy\",\n",
    "      \"id\": \"IT\",\n",
    "      \"PRIS_OFF_CAP\":  84.30, \n",
    "      \"PRIS_ACT_CAP\":97.44,\n",
    "      \"Living Conditions\": (97.44 / 84.30) ,\n",
    "      \"GF03\": 1.8\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Portugal\",\n",
    "      \"id\": \"PT\",\n",
    "      \"PRIS_OFF_CAP\": 123.13, \n",
    "      \"PRIS_ACT_CAP\":131.79,\n",
    "      \"Living Conditions\": (131.79 /  123.13) ,\n",
    "      \"GF03\": 1.7\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Spain\",\n",
    "      \"id\": \"ES\",\n",
    "      \"PRIS_OFF_CAP\":   137.79 , \n",
    "      \"PRIS_ACT_CAP\":126.40,\n",
    "      \"Living Conditions\": (126.40 /  137.79) ,\n",
    "      \"GF03\": 1.8\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"France\",\n",
    "      \"id\": \"FR\",\n",
    "      \"PRIS_OFF_CAP\":89.46, \n",
    "      \"PRIS_ACT_CAP\":103.25,\n",
    "      \"Living Conditions\": (103.25 / 89.46) ,\n",
    "      \"GF03\": 1.6\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Germany\",\n",
    "      \"id\": \"DE\",\n",
    "      \"PRIS_OFF_CAP\": 89.19, \n",
    "      \"PRIS_ACT_CAP\": 79.79,\n",
    "      \"Living Conditions\": (79.79 /  89.19) ,\n",
    "      \"GF03\": 1.6\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Netherlands\",\n",
    "      \"id\": \"NL\",\n",
    "      \"PRIS_OFF_CAP\": 70.69, \n",
    "      \"PRIS_ACT_CAP\":63.66,\n",
    "      \"Living Conditions\": (63.66 / 70.69) ,\n",
    "      \"GF03\": 1.8\n",
    "    }]\n",
    "\n",
    "viz1_2018 = [{\n",
    "      \"title\": \"Estonia\",\n",
    "      \"id\": \"EE\",\n",
    "      \"PRIS_OFF_CAP\": 252.74, \n",
    "      \"PRIS_ACT_CAP\":195.89,\n",
    "      \"Living Conditions\": (195.89 / 252.74) ,\n",
    "      \"GF03\": 1.9\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Sweden\",\n",
    "      \"id\": \"SE\",\n",
    "      \"PRIS_OFF_CAP\": 60.41, \n",
    "      \"PRIS_ACT_CAP\": 64.61,\n",
    "      \"Living Conditions\": 64.61 / 60.41,\n",
    "      \"GF03\": 1.3\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Denmark\",\n",
    "      \"id\": \"DK\",\n",
    "      \"PRIS_OFF_CAP\": 65.64,\n",
    "      \"PRIS_ACT_CAP\": 62.88,\n",
    "      \"Living Conditions\": (62.88/  65.64) ,\n",
    "      \"GF03\": 0.9\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Finland\",\n",
    "      \"id\": \"FI\",\n",
    "      \"PRIS_OFF_CAP\": 53.96,\n",
    "      \"PRIS_ACT_CAP\": 53.62,\n",
    "      \"Living Conditions\": (53.62 / 53.96) ,\n",
    "      \"GF03\": 1.1\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Bulgaria\",\n",
    "      \"id\": \"BG\",\n",
    "      \"PRIS_OFF_CAP\": 116.89, \n",
    "      \"PRIS_ACT_CAP\":94.34,\n",
    "      \"Living Conditions\": (94.34 / 116.89) ,\n",
    "      \"GF03\": 2.5\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Hungary\",\n",
    "      \"id\": \"HG\",\n",
    "      \"PRIS_OFF_CAP\": 144.70, \n",
    "      \"PRIS_ACT_CAP\":177.01,\n",
    "      \"Living Conditions\": (177.01 / 144.70) ,\n",
    "      \"GF03\": 2.2\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Austria\",\n",
    "      \"id\": \"AT\",\n",
    "      \"PRIS_OFF_CAP\": 100.24, \n",
    "      \"PRIS_ACT_CAP\":103.86,\n",
    "      \"Living Conditions\": (103.86 / 100.24) ,\n",
    "      \"GF03\": 1.4\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Poland\",\n",
    "      \"id\": \"PL\",\n",
    "      \"PRIS_OFF_CAP\": 226.30, \n",
    "      \"PRIS_ACT_CAP\":191.74 ,\n",
    "      \"Living Conditions\": (196.14 / 228.76),\n",
    "      \"GF03\": 2.1\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Romania\",\n",
    "      \"id\": \"RO\",\n",
    "      \"PRIS_OFF_CAP\": 99.39, \n",
    "      \"PRIS_ACT_CAP\":106.46,\n",
    "      \"Living Conditions\": (106.46 / 99.39) ,\n",
    "      \"GF03\": 2.2\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Slovakia\",\n",
    "      \"id\": \"SK\",\n",
    "      \"PRIS_OFF_CAP\": 211.26, \n",
    "      \"PRIS_ACT_CAP\":189.12,\n",
    "      \"Living Conditions\": (189.12 / 211.26) ,\n",
    "      \"GF03\": 2.2\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Greece\",\n",
    "      \"id\": \"GR\",\n",
    "      \"PRIS_OFF_CAP\": 92.49, \n",
    "      \"PRIS_ACT_CAP\":99.19,\n",
    "      \"Living Conditions\": (99.19 / 92.49) , \n",
    "      \"GF03\": 2.3\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Italy\",\n",
    "      \"id\": \"IT\",\n",
    "      \"PRIS_OFF_CAP\":  84.55 , \n",
    "      \"PRIS_ACT_CAP\":101.07,\n",
    "      \"Living Conditions\": (101.07/ 84.55 ) ,\n",
    "      \"GF03\": 1.8\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Portugal\",\n",
    "      \"id\": \"PT\",\n",
    "      \"PRIS_OFF_CAP\": 125.68, \n",
    "      \"PRIS_ACT_CAP\":126.53 ,\n",
    "      \"Living Conditions\": (131.79 /  125.68) ,\n",
    "      \"GF03\": 1.7\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Spain\",\n",
    "      \"id\": \"ES\",\n",
    "      \"PRIS_OFF_CAP\":137.67, \n",
    "      \"PRIS_ACT_CAP\":126.20,\n",
    "      \"Living Conditions\": (126.20 /  137.67) ,\n",
    "      \"GF03\": 1.8\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"France\",\n",
    "      \"id\": \"FR\",\n",
    "      \"PRIS_OFF_CAP\":89.74, \n",
    "      \"PRIS_ACT_CAP\":104.69,\n",
    "      \"Living Conditions\": (104.69 / 89.74) ,\n",
    "      \"GF03\": 1.6\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Germany\",\n",
    "      \"id\": \"DE\",\n",
    "      \"PRIS_OFF_CAP\": 89.85, \n",
    "      \"PRIS_ACT_CAP\": 79.43 ,\n",
    "      \"Living Conditions\": (79.43 / 89.85) ,\n",
    "      \"GF03\": 1.6\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Netherlands\",\n",
    "      \"id\": \"NL\",\n",
    "      \"PRIS_OFF_CAP\": 72.03, \n",
    "      \"PRIS_ACT_CAP\":65.48,\n",
    "      \"Living Conditions\": (65.48 / 72.03) ,\n",
    "      \"GF03\": 1.8\n",
    "    }]\n",
    "\n",
    "viz1_2019 = [{\n",
    "      \"title\": \"Estonia\",\n",
    "      \"id\": \"EE\",\n",
    "      \"PRIS_OFF_CAP\": 247.43, \n",
    "      \"PRIS_ACT_CAP\":187.72,\n",
    "      \"Living Conditions\": (187.72 / 247.43) ,\n",
    "      \"GF03\": 1.8\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Sweden\",\n",
    "      \"id\": \"SE\",\n",
    "      \"PRIS_OFF_CAP\": 65.07 , \n",
    "      \"PRIS_ACT_CAP\": 65.68 ,\n",
    "      \"Living Conditions\": (65.68 / 65.07),\n",
    "      \"GF03\": 1.3\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Denmark\",\n",
    "      \"id\": \"DK\",\n",
    "      \"PRIS_OFF_CAP\": 67.98,\n",
    "      \"PRIS_ACT_CAP\": 67.52,\n",
    "      \"Living Conditions\": (67.52/67.98) ,\n",
    "      \"GF03\": 1.0\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Finland\",\n",
    "      \"id\": \"FI\",\n",
    "      \"PRIS_OFF_CAP\": 52.16,\n",
    "      \"PRIS_ACT_CAP\": 53.37 ,\n",
    "      \"Living Conditions\": (53.37  / 52.16) ,\n",
    "      \"GF03\": 1.2\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Bulgaria\",\n",
    "      \"id\": \"BG\",\n",
    "      \"PRIS_OFF_CAP\": 115.79 , \n",
    "      \"PRIS_ACT_CAP\":92.11,\n",
    "      \"Living Conditions\": (92.11/ 115.79 ) ,\n",
    "      \"GF03\": 2.7\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Hungary\",\n",
    "      \"id\": \"HG\",\n",
    "      \"PRIS_OFF_CAP\": 152.12, \n",
    "      \"PRIS_ACT_CAP\":170.51,\n",
    "      \"Living Conditions\": (170.51 / 152.12) ,\n",
    "      \"GF03\": 2.1\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Austria\",\n",
    "      \"id\": \"AT\",\n",
    "      \"PRIS_OFF_CAP\": 100.27, \n",
    "      \"PRIS_ACT_CAP\":102.41,\n",
    "      \"Living Conditions\": (102.41 / 100.27) ,\n",
    "      \"GF03\": 1.3\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Poland\",\n",
    "      \"id\": \"PL\",\n",
    "      \"PRIS_OFF_CAP\": 225.82, \n",
    "      \"PRIS_ACT_CAP\":196.49  ,\n",
    "      \"Living Conditions\": (196.49/225.82),\n",
    "      \"GF03\": 2.1\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Romania\",\n",
    "      \"id\": \"RO\",\n",
    "      \"PRIS_OFF_CAP\": 100.55, \n",
    "      \"PRIS_ACT_CAP\":105.99,\n",
    "      \"Living Conditions\": (105.99 / 100.55) ,\n",
    "      \"GF03\": 2.2\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Slovakia\",\n",
    "      \"id\": \"SK\",\n",
    "      \"PRIS_OFF_CAP\": 213.29, \n",
    "      \"PRIS_ACT_CAP\":193.65,\n",
    "      \"Living Conditions\": (193.65 / 213.29) ,\n",
    "      \"GF03\": 2.3\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Greece\",\n",
    "      \"id\": \"GR\",\n",
    "      \"PRIS_OFF_CAP\": 92.64 , \n",
    "      \"PRIS_ACT_CAP\":101.55 ,\n",
    "      \"Living Conditions\": (101.55  / 92.64 ) , \n",
    "      \"GF03\": 2.1\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Italy\",\n",
    "      \"id\": \"IT\",\n",
    "      \"PRIS_OFF_CAP\":  85.68 , \n",
    "      \"PRIS_ACT_CAP\":104.04 ,\n",
    "      \"Living Conditions\": (104.04 / 85.68 ) ,\n",
    "      \"GF03\": 1.8\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Portugal\",\n",
    "      \"id\": \"PT\",\n",
    "      \"PRIS_OFF_CAP\": 125.86 , \n",
    "      \"PRIS_ACT_CAP\":125.99 ,\n",
    "      \"Living Conditions\": (125.99/  125.86 ) ,\n",
    "      \"GF03\": 1.6\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Spain\",\n",
    "      \"id\": \"ES\",\n",
    "      \"PRIS_OFF_CAP\":136.85, \n",
    "      \"PRIS_ACT_CAP\":124.67,\n",
    "      \"Living Conditions\": (124.67 /  136.85) ,\n",
    "      \"GF03\": 1.8\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"France\",\n",
    "      \"id\": \"FR\",\n",
    "      \"PRIS_OFF_CAP\":90.86 , \n",
    "      \"PRIS_ACT_CAP\":105.30,\n",
    "      \"Living Conditions\": (105.30 / 90.86 ) ,\n",
    "      \"GF03\": 1.6\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Germany\",\n",
    "      \"id\": \"DE\",\n",
    "      \"PRIS_OFF_CAP\": 87.89 , \n",
    "      \"PRIS_ACT_CAP\": 76.06 ,\n",
    "      \"Living Conditions\": (76.06 / 87.89 ) ,\n",
    "      \"GF03\": 1.6\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Netherlands\",\n",
    "      \"id\": \"NL\",\n",
    "      \"PRIS_OFF_CAP\": 67.20 , \n",
    "      \"PRIS_ACT_CAP\":68.15 ,\n",
    "      \"Living Conditions\": (68.15 / 67.20) ,\n",
    "      \"GF03\": 1.8\n",
    "    }]\n",
    "\n",
    "viz1_2020 = [{\n",
    "      \"title\": \"Estonia\",\n",
    "      \"id\": \"EE\",\n",
    "      \"PRIS_OFF_CAP\": 246.66, \n",
    "      \"PRIS_ACT_CAP\":178.03,\n",
    "      \"Living Conditions\": (178.03 / 246.66) ,\n",
    "      \"GF03\": 2.0\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Sweden\",\n",
    "      \"id\": \"SE\",\n",
    "      \"PRIS_OFF_CAP\": 67.38 , \n",
    "      \"PRIS_ACT_CAP\": 70.66  ,\n",
    "      \"Living Conditions\": (70.66  / 67.38),\n",
    "      \"GF03\": 1.4\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Denmark\",\n",
    "      \"id\": \"DK\",\n",
    "      \"PRIS_OFF_CAP\": 70.33,\n",
    "      \"PRIS_ACT_CAP\": 71.55,\n",
    "      \"Living Conditions\": (71.55/70.33) ,\n",
    "      \"GF03\": 1.0\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Finland\",\n",
    "      \"id\": \"FI\",\n",
    "      \"PRIS_OFF_CAP\": 54.24,\n",
    "      \"PRIS_ACT_CAP\": 49.79,\n",
    "      \"Living Conditions\": (49.79/54.24) ,\n",
    "      \"GF03\": 1.2\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Bulgaria\",\n",
    "      \"id\": \"BG\",\n",
    "      \"PRIS_OFF_CAP\": 117.40, \n",
    "      \"PRIS_ACT_CAP\":89.92 ,\n",
    "      \"Living Conditions\": (89.92 / 117.40 ) ,\n",
    "      \"GF03\": 2.7\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Hungary\",\n",
    "      \"id\": \"HG\",\n",
    "      \"PRIS_OFF_CAP\":162.80 , \n",
    "      \"PRIS_ACT_CAP\":171.21,\n",
    "      \"Living Conditions\": (171.21/ 162.80) ,\n",
    "      \"GF03\": 2.1\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Austria\",\n",
    "      \"id\": \"AT\",\n",
    "      \"PRIS_OFF_CAP\": 99.64 , \n",
    "      \"PRIS_ACT_CAP\":95.36,\n",
    "      \"Living Conditions\": (95.36 / 99.64 ) ,\n",
    "      \"GF03\": 1.4\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Poland\",\n",
    "      \"id\": \"PL\",\n",
    "      \"PRIS_OFF_CAP\": 226.75 , \n",
    "      \"PRIS_ACT_CAP\":180.08,\n",
    "      \"Living Conditions\": (180.08/226.75 ),\n",
    "      \"GF03\": 2.3\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Romania\",\n",
    "      \"id\": \"RO\",\n",
    "      \"PRIS_OFF_CAP\": 101.05, \n",
    "      \"PRIS_ACT_CAP\":112.54,\n",
    "      \"Living Conditions\": (105.99 / 101.05) ,\n",
    "      \"GF03\": 2.5\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Slovakia\",\n",
    "      \"id\": \"SK\",\n",
    "      \"PRIS_OFF_CAP\": 213.00 , \n",
    "      \"PRIS_ACT_CAP\":192.73 ,\n",
    "      \"Living Conditions\": (192.73 / 213.00) ,\n",
    "      \"GF03\": 2.4\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Greece\",\n",
    "      \"id\": \"GR\",\n",
    "      \"PRIS_OFF_CAP\": 94.93, \n",
    "      \"PRIS_ACT_CAP\":106.16,\n",
    "      \"Living Conditions\": (106.16/ 94.93) , \n",
    "      \"GF03\": 2.4\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Italy\",\n",
    "      \"id\": \"IT\",\n",
    "      \"PRIS_OFF_CAP\":  85.72, \n",
    "      \"PRIS_ACT_CAP\":91.56 ,\n",
    "      \"Living Conditions\": (91.56  / 85.72) ,\n",
    "      \"GF03\": 2.0\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Portugal\",\n",
    "      \"id\": \"PT\",\n",
    "      \"PRIS_OFF_CAP\": 125.52 , \n",
    "      \"PRIS_ACT_CAP\":111.71,\n",
    "      \"Living Conditions\": (111.71/125.52 ) ,\n",
    "      \"GF03\": 1.9\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Spain\",\n",
    "      \"id\": \"ES\",\n",
    "      \"PRIS_OFF_CAP\":136.13, \n",
    "      \"PRIS_ACT_CAP\":116.58,\n",
    "      \"Living Conditions\": (116.58/ 136.13) ,\n",
    "      \"GF03\": 2.1\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"France\",\n",
    "      \"id\": \"FR\",\n",
    "      \"PRIS_OFF_CAP\":89.99, \n",
    "      \"PRIS_ACT_CAP\":93.10,\n",
    "      \"Living Conditions\": (93.10 / 89.99 ) ,\n",
    "      \"GF03\": 1.8\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Germany\",\n",
    "      \"id\": \"DE\",\n",
    "      \"PRIS_OFF_CAP\": 87.00 , \n",
    "      \"PRIS_ACT_CAP\": 71.65,\n",
    "      \"Living Conditions\": (71.65/87.00 ) ,\n",
    "      \"GF03\": 1.7\n",
    "    },\n",
    "    {\n",
    "      \"title\": \"Netherlands\",\n",
    "      \"id\": \"NL\",\n",
    "      \"PRIS_OFF_CAP\": 69.49 , \n",
    "      \"PRIS_ACT_CAP\":63.33,\n",
    "      \"Living Conditions\": (63.33 / 69.49) ,\n",
    "      \"GF03\": 2.0\n",
    "    }]\n",
    "# storing the data in a df\n",
    "DF1 = pd.DataFrame() \n",
    "DF2 = pd.DataFrame()\n",
    "DF3 = pd.DataFrame() \n",
    "DF4 = pd.DataFrame()\n",
    "DF5 = pd.DataFrame()\n",
    "def createDF(data,df):\n",
    "    for item in data:\n",
    "        s = pd.Series(item)\n",
    "        df = pd.concat([df, s.to_frame().T], ignore_index=True)\n",
    "\n",
    "    return df\n",
    "\n",
    "DF1 = createDF(viz1_2016,DF1)    \n",
    "DF2 = createDF(viz1_2017,DF2)\n",
    "DF3 = createDF(viz1_2018,DF3)\n",
    "DF4 = createDF(viz1_2019,DF4)\n",
    "DF5 = createDF(viz1_2020,DF5)\n",
    "DF1 = DF1.drop(columns=['PRIS_OFF_CAP','id','PRIS_ACT_CAP','title'])\n",
    "DF2 = DF2.drop(columns=['PRIS_OFF_CAP','id','PRIS_ACT_CAP','title'])\n",
    "DF3 = DF3.drop(columns=['PRIS_OFF_CAP','id','PRIS_ACT_CAP','title'])\n",
    "DF4 = DF4.drop(columns=['PRIS_OFF_CAP','id','PRIS_ACT_CAP','title'])\n",
    "DF5 = DF5.drop(columns=['PRIS_OFF_CAP','id','PRIS_ACT_CAP','title'])\n",
    "\n",
    "\n",
    "# ===================================================================================================="
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "id": "49d55592-4788-425c-9185-743ad363caab",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "   Living Conditions Suicides\n",
      "0           0.758679        4\n",
      "1           1.009375        2\n",
      "2           0.993233        9\n",
      "3           1.023198        1\n",
      "4           0.795492        3\n",
      "5           1.120891        6\n",
      "6           1.021342        9\n",
      "7           0.870118       24\n",
      "8           1.054102        7\n",
      "11          1.214286       53\n",
      "12          1.001033       11\n",
      "13          0.910997       43\n",
      "14          1.158926      128\n",
      "16          1.014137       12\n"
     ]
    }
   ],
   "source": [
    "# data for the second plot chart\n",
    "\n",
    "viz5_2016 = [{\n",
    "      \n",
    "        \"title\": \"Estonia\",\n",
    "        \"id\": \"EE\",\n",
    "        \"PRIS_OFF_CAP\": 221.51, \n",
    "        \"PRIS_ACT_CAP\":217.64,\n",
    "        \"Living Conditions\": (217.64 / 221.51),\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Sweden\",\n",
    "        \"id\": \"SE\",\n",
    "        \"PRIS_OFF_CAP\": 63.47, \n",
    "        \"PRIS_ACT_CAP\": 57.44,\n",
    "        \"Living Conditions\": (57.44 / 63.47),\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Denmark\",\n",
    "        \"id\": \"DK\",\n",
    "        \"PRIS_OFF_CAP\": 61.71,\n",
    "        \"PRIS_ACT_CAP\": 59.71,\n",
    "        \"Living Conditions\": (61.71 / 59.71),\n",
    "        \"Suicides\": 8 \n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Finland\",\n",
    "        \"id\": \"FI\",\n",
    "        \"PRIS_OFF_CAP\": 53.92,\n",
    "        \"PRIS_ACT_CAP\": 57.51,\n",
    "        \"Living Conditions\": (57.51 / 53.92),\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Bulgaria\",\n",
    "        \"id\": \"BG\",\n",
    "        \"PRIS_OFF_CAP\": 118.69, \n",
    "        \"PRIS_ACT_CAP\":102.67,\n",
    "        \"Living Conditions\": (61.71 / 59.71),\n",
    "        \"Suicides\": 3\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Hungary\",\n",
    "        \"id\": \"HG\",\n",
    "        \"PRIS_OFF_CAP\": 140.11, \n",
    "        \"PRIS_ACT_CAP\":179.62,\n",
    "        \"Living Conditions\":(179.62 / 140.11),\n",
    "        \"Suicides\": 9\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Austria\",\n",
    "        \"id\": \"AT\",\n",
    "        \"PRIS_OFF_CAP\": 101.43, \n",
    "        \"PRIS_ACT_CAP\":99.18,\n",
    "        \"Living Conditions\": (99.18 / 101.43),\n",
    "        \"Suicides\": 10\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Poland\",\n",
    "        \"id\": \"PL\",\n",
    "        \"PRIS_OFF_CAP\": 234.88, \n",
    "        \"PRIS_ACT_CAP\":190.19,\n",
    "        \"Living Conditions\": (190.19 / 234.88),\n",
    "        \"Suicides\": 24\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Romania\",\n",
    "        \"id\": \"RO\",\n",
    "        \"PRIS_OFF_CAP\": 141.13, \n",
    "        \"PRIS_ACT_CAP\":138.94,\n",
    "        \"Living Conditions\": (138.94 / 141.13),\n",
    "        \"Suicides\": 11\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Slovakia\",\n",
    "        \"id\": \"SK\",\n",
    "        \"PRIS_OFF_CAP\": 203.33, \n",
    "        \"PRIS_ACT_CAP\":184.20,\n",
    "        \"Living Conditions\": (184.20 / 203.33),\n",
    "        \"Suicides\": 6\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Slovenia\",\n",
    "        \"id\": \"SI\",\n",
    "        \"PRIS_OFF_CAP\": 64.04, \n",
    "        \"PRIS_ACT_CAP\":63.37,\n",
    "        \"Living Conditions\": (63.37 / 64.04),\n",
    "        \"Suicides\": 3 \n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Greece\",\n",
    "        \"id\": \"GR\",\n",
    "        \"PRIS_OFF_CAP\": 91.02, \n",
    "        \"PRIS_ACT_CAP\":88.65,\n",
    "        \"Living Conditions\": (91.02 / 88.65), \n",
    "        \"Suicides\": 6\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Italy\",\n",
    "        \"id\": \"IT\",\n",
    "        \"PRIS_OFF_CAP\":  83.75, \n",
    "        \"PRIS_ACT_CAP\": 92.27,\n",
    "        \"Living Conditions\": (92.27 /  83.75 ),\n",
    "        \"Suicides\": 39\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Portugal\",\n",
    "        \"id\": \"PT\",\n",
    "        \"PRIS_OFF_CAP\": 121.84, \n",
    "        \"PRIS_ACT_CAP\":134.58,\n",
    "        \"Living Conditions\": (134.58 / 121.84),\n",
    "        \"Suicides\": 9 \n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Spain\",\n",
    "        \"id\": \"ES\",\n",
    "        \"PRIS_OFF_CAP\":   138.12, \n",
    "        \"PRIS_ACT_CAP\":128.31,\n",
    "        \"Living Conditions\": (128.31 / 138.12),\n",
    "        \"Suicides\": 23\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"France\",\n",
    "        \"id\": \"FR\",\n",
    "        \"PRIS_OFF_CAP\": 88.06, \n",
    "        \"PRIS_ACT_CAP\":102.50,\n",
    "        \"Living Conditions\": (102.50 / 88.06),\n",
    "        \"Suicides\": 125\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Germany\",\n",
    "        \"id\": \"DE\",\n",
    "        \"PRIS_OFF_CAP\": 89.60, \n",
    "        \"PRIS_ACT_CAP\": 78.24,\n",
    "        \"Living Conditions\": (78.24 / 89.60),\n",
    "        \"Suicides\": 76\n",
    "      }]\n",
    "viz5_2017 = [{\n",
    "        \n",
    "            \"title\": \"Estonia\",\n",
    "            \"id\": \"EE\",\n",
    "            \"PRIS_OFF_CAP\": 221.57, \n",
    "            \"PRIS_ACT_CAP\":206.97,\n",
    "            \"Living Conditions\": (206.97 / 221.57) ,\n",
    "            \"Suicides\": 1\n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Sweden\",\n",
    "            \"id\": \"SE\",\n",
    "            \"PRIS_OFF_CAP\": 61.50, \n",
    "            \"PRIS_ACT_CAP\": 57.16,\n",
    "            \"Living Conditions\": 57.16 / 61.50 ,\n",
    "            \"Suicides\": 1\n",
    "    \n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Denmark\",\n",
    "            \"id\": \"DK\",\n",
    "            \"PRIS_OFF_CAP\": 62.48,\n",
    "            \"PRIS_ACT_CAP\": 59.46,\n",
    "            \"Living Conditions\": (59.46 /  62.48) ,\n",
    "            \"Suicides\": 4\n",
    "    \n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Finland\",\n",
    "            \"id\": \"FI\",\n",
    "            \"PRIS_OFF_CAP\": 53.10,\n",
    "            \"PRIS_ACT_CAP\": 56.00,\n",
    "            \"Living Conditions\": (56.00 / 53.10) ,\n",
    "            \"Suicides\": 2\n",
    "    \n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Bulgaria\",\n",
    "            \"id\": \"BG\",\n",
    "            \"PRIS_OFF_CAP\": 119.56, \n",
    "            \"PRIS_ACT_CAP\":98.40,\n",
    "            \"Living Conditions\": (98.40 / 119.56) ,\n",
    "            \"Suicides\": 5\n",
    "    \n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Hungary\",\n",
    "            \"id\": \"HG\",\n",
    "            \"PRIS_OFF_CAP\": 143.00, \n",
    "            \"PRIS_ACT_CAP\":177.01,\n",
    "            \"Living Conditions\": (177.01 / 143.00) ,\n",
    "            \"Suicides\": 4\n",
    "    \n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Austria\",\n",
    "            \"id\": \"AT\",\n",
    "            \"PRIS_OFF_CAP\": 99.69, \n",
    "            \"PRIS_ACT_CAP\":100.90,\n",
    "            \"Living Conditions\": (100.90 / 99.69) ,\n",
    "            \"Suicides\": 11\n",
    "    \n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Poland\",\n",
    "            \"id\": \"PL\",\n",
    "            \"PRIS_OFF_CAP\": 228.76, \n",
    "            \"PRIS_ACT_CAP\":196.14,\n",
    "            \"Living Conditions\": (196.14 / 228.76),\n",
    "    \n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Romania\",\n",
    "            \"id\": \"RO\",\n",
    "            \"PRIS_OFF_CAP\": 103.89, \n",
    "            \"PRIS_ACT_CAP\":119.37,\n",
    "            \"Living Conditions\": (119.37 / 103.89) ,\n",
    "            \"Suicides\": 9\n",
    "    \n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Slovakia\",\n",
    "            \"id\": \"SK\",\n",
    "            \"PRIS_OFF_CAP\": 201.29, \n",
    "            \"PRIS_ACT_CAP\":184.50,\n",
    "            \"Living Conditions\": (184.50 / 201.29) ,\n",
    "            \"Suicides\": 10\n",
    "    \n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Greece\",\n",
    "            \"id\": \"GR\",\n",
    "            \"PRIS_OFF_CAP\": 92.26, \n",
    "            \"PRIS_ACT_CAP\":92.97,\n",
    "            \"Living Conditions\": (92.97 / 92.26) , \n",
    "            \"Suicides\": 0\n",
    "    \n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Italy\",\n",
    "            \"id\": \"IT\",\n",
    "            \"PRIS_OFF_CAP\":  84.30, \n",
    "            \"PRIS_ACT_CAP\":97.44,\n",
    "            \"Living Conditions\": (97.44 / 84.30) ,\n",
    "            \"Suicides\": 48\n",
    "    \n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Portugal\",\n",
    "            \"id\": \"PT\",\n",
    "            \"PRIS_OFF_CAP\": 123.13, \n",
    "            \"PRIS_ACT_CAP\":131.79,\n",
    "            \"Living Conditions\": (131.79 /  123.13) ,\n",
    "            \"Suicides\": 15\n",
    "    \n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Spain\",\n",
    "            \"id\": \"ES\",\n",
    "            \"PRIS_OFF_CAP\":   137.79 , \n",
    "            \"PRIS_ACT_CAP\":126.40,\n",
    "            \"Living Conditions\": (126.40 /  137.79) ,\n",
    "            \"Suicides\": 27\n",
    "    \n",
    "          },\n",
    "          {\n",
    "            \"title\": \"France\",\n",
    "            \"id\": \"FR\",\n",
    "            \"PRIS_OFF_CAP\":89.46, \n",
    "            \"PRIS_ACT_CAP\":103.25,\n",
    "            \"Living Conditions\": (103.25 / 89.46) ,\n",
    "            \"Suicides\": 88\n",
    "    \n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Germany\",\n",
    "            \"id\": \"DE\",\n",
    "            \"PRIS_OFF_CAP\": 89.19, \n",
    "            \"PRIS_ACT_CAP\": 79.79,\n",
    "            \"Living Conditions\": (79.79 /  89.19) ,\n",
    "            \"Suicides\": 82\n",
    "    \n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Netherlands\",\n",
    "            \"id\": \"NL\",\n",
    "            \"PRIS_OFF_CAP\": 70.69, \n",
    "            \"PRIS_ACT_CAP\":63.66,\n",
    "            \"Living Conditions\": (63.66 / 70.69) ,\n",
    "            \"Suicides\": 14\n",
    "          }]\n",
    "viz5_2018 = [{\n",
    "      \n",
    "        \"title\": \"Estonia\",\n",
    "        \"id\": \"EE\",\n",
    "        \"PRIS_OFF_CAP\": 252.74, \n",
    "        \"PRIS_ACT_CAP\":195.89,\n",
    "        \"Living Conditions\": (195.89 / 252.74) ,       \n",
    "        \"Suicides\": 4\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Sweden\",\n",
    "        \"id\": \"SE\",\n",
    "        \"PRIS_OFF_CAP\": 60.41, \n",
    "        \"PRIS_ACT_CAP\": 64.61,\n",
    "        \"Living Conditions\": 64.61 / 60.41,\n",
    "        \"Suicides\": 2\n",
    "      },    \n",
    "      {\n",
    "        \"title\": \"Denmark\",\n",
    "        \"id\": \"DK\",\n",
    "        \"PRIS_OFF_CAP\": 65.64,\n",
    "        \"PRIS_ACT_CAP\": 62.88,\n",
    "        \"Living Conditions\": (62.88/  65.64) ,\n",
    "        \"Suicides\":5 },\n",
    "      {\n",
    "        \"title\": \"Finland\",\n",
    "        \"id\": \"FI\",\n",
    "        \"PRIS_OFF_CAP\": 53.96,\n",
    "        \"PRIS_ACT_CAP\": 53.62,\n",
    "        \"Living Conditions\": (53.62 / 53.96) ,\n",
    "        \"Suicides\": 2 },\n",
    "      {\n",
    "        \"title\": \"Bulgaria\",\n",
    "        \"id\": \"BG\",\n",
    "        \"PRIS_OFF_CAP\": 116.89, \n",
    "        \"PRIS_ACT_CAP\":94.34,\n",
    "        \"Living Conditions\": (94.34 / 116.89) ,\n",
    "        \"Suicides\": 3 },\n",
    "      {\n",
    "        \"title\": \"Hungary\",\n",
    "        \"id\": \"HG\",\n",
    "        \"PRIS_OFF_CAP\": 144.70, \n",
    "        \"PRIS_ACT_CAP\":177.01,\n",
    "        \"Living Conditions\": (177.01 / 144.70) ,  \n",
    "        \"Suicides\": 6     \n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Austria\",\n",
    "        \"id\": \"AT\",\n",
    "        \"PRIS_OFF_CAP\": 100.24, \n",
    "        \"PRIS_ACT_CAP\":103.86,\n",
    "        \"Living Conditions\": (103.86 / 100.24) ,      \n",
    "        \"Suicides\": 12\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Poland\",\n",
    "        \"id\": \"PL\",\n",
    "        \"PRIS_OFF_CAP\": 226.30, \n",
    "        \"PRIS_ACT_CAP\":191.74 ,\n",
    "        \"Living Conditions\": (196.14 / 228.76),\n",
    "        \"Suicides\": 26\n",
    "     },\n",
    "      {\n",
    "        \"title\": \"Romania\",\n",
    "        \"id\": \"RO\",\n",
    "        \"PRIS_OFF_CAP\": 99.39, \n",
    "        \"PRIS_ACT_CAP\":106.46,\n",
    "        \"Living Conditions\": (106.46 / 99.39) ,\n",
    "        \"Suicides\": 11\n",
    "     },\n",
    "      {\n",
    "        \"title\": \"Slovakia\",\n",
    "        \"id\": \"SK\",\n",
    "        \"PRIS_OFF_CAP\": 211.26, \n",
    "        \"PRIS_ACT_CAP\":189.12,\n",
    "        \"Living Conditions\": (189.12 / 211.26) ,\n",
    "        \"Suicides\": 5       \n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Greece\",\n",
    "        \"id\": \"GR\",\n",
    "        \"PRIS_OFF_CAP\": 92.49, \n",
    "        \"PRIS_ACT_CAP\":99.19,\n",
    "        \"Living Conditions\": (99.19 / 92.49) , \n",
    "        \"Suicides\": 9  },\n",
    "      {\n",
    "        \"title\": \"Italy\",\n",
    "        \"id\": \"IT\",\n",
    "        \"PRIS_OFF_CAP\":  84.55 , \n",
    "        \"PRIS_ACT_CAP\":101.07,\n",
    "        \"Living Conditions\": (101.07/ 84.55 ) ,\n",
    "        \"Suicides\": 61 },\n",
    "      {\n",
    "        \"title\": \"Portugal\",\n",
    "        \"id\": \"PT\",\n",
    "        \"PRIS_OFF_CAP\": 125.68, \n",
    "        \"PRIS_ACT_CAP\":126.53 ,\n",
    "        \"Living Conditions\": (131.79 /  125.68),\n",
    "        \"Suicides\":11\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Spain\",\n",
    "        \"id\": \"ES\",\n",
    "        \"PRIS_OFF_CAP\":137.67, \n",
    "        \"PRIS_ACT_CAP\":126.20,\n",
    "        \"Living Conditions\": (126.20 /  137.67),\n",
    "        \"Suicides\":33       \n",
    "      },\n",
    "      {\n",
    "        \"title\": \"France\",\n",
    "        \"id\": \"FR\",\n",
    "        \"PRIS_OFF_CAP\":89.74, \n",
    "        \"PRIS_ACT_CAP\":104.69,\n",
    "        \"Living Conditions\": (104.69 / 89.74) ,\n",
    "        \"Suicides\": 103  },\n",
    "      {\n",
    "        \"title\": \"Netherlands\",\n",
    "        \"id\": \"NL\",\n",
    "        \"PRIS_OFF_CAP\": 72.03, \n",
    "        \"PRIS_ACT_CAP\":65.48,\n",
    "        \"Living Conditions\": (65.48 / 72.03) ,\n",
    "        \"Suicides\": 13\n",
    "    }]\n",
    "viz5_2019 = [{\n",
    "            \"title\": \"Estonia\",\n",
    "            \"id\": \"EE\",\n",
    "            \"PRIS_OFF_CAP\": 247.43, \n",
    "            \"PRIS_ACT_CAP\":187.72,\n",
    "            \"Living Conditions\": (187.72 / 247.43) ,\n",
    "            \"Suicides\": 4\n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Sweden\",\n",
    "            \"id\": \"SE\",\n",
    "            \"PRIS_OFF_CAP\": 65.07 , \n",
    "            \"PRIS_ACT_CAP\": 65.68 ,\n",
    "            \"Living Conditions\": (65.68 / 65.07),\n",
    "            \"Suicides\": 2\n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Denmark\",\n",
    "            \"id\": \"DK\",\n",
    "            \"PRIS_OFF_CAP\": 67.98,\n",
    "            \"PRIS_ACT_CAP\": 67.52,\n",
    "            \"Living Conditions\": (67.52/67.98) ,\n",
    "            \"Suicides\":9\n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Finland\",\n",
    "            \"id\": \"FI\",\n",
    "            \"PRIS_OFF_CAP\": 52.16,\n",
    "            \"PRIS_ACT_CAP\": 53.37 ,\n",
    "            \"Living Conditions\": (53.37  / 52.16) ,\n",
    "            \"Suicides\": 1\n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Bulgaria\",\n",
    "            \"id\": \"BG\",\n",
    "            \"PRIS_OFF_CAP\": 115.79 , \n",
    "            \"PRIS_ACT_CAP\":92.11,\n",
    "            \"Living Conditions\": (92.11/ 115.79 ) ,\n",
    "            \"Suicides\": 3\n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Hungary\",\n",
    "            \"id\": \"HG\",\n",
    "            \"PRIS_OFF_CAP\": 152.12, \n",
    "            \"PRIS_ACT_CAP\":170.51,\n",
    "            \"Living Conditions\": (170.51 / 152.12) ,\n",
    "            \"Suicides\": 6\n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Austria\",\n",
    "            \"id\": \"AT\",\n",
    "            \"PRIS_OFF_CAP\": 100.27, \n",
    "            \"PRIS_ACT_CAP\":102.41,\n",
    "            \"Living Conditions\": (102.41 / 100.27) ,\n",
    "            \"Suicides\": 9\n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Poland\",\n",
    "            \"id\": \"PL\",\n",
    "            \"PRIS_OFF_CAP\": 225.82, \n",
    "            \"PRIS_ACT_CAP\":196.49  ,\n",
    "            \"Living Conditions\": (196.49/225.82),\n",
    "            \"Suicides\": 24\n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Romania\",\n",
    "            \"id\": \"RO\",\n",
    "            \"PRIS_OFF_CAP\": 100.55, \n",
    "            \"PRIS_ACT_CAP\":105.99,\n",
    "            \"Living Conditions\": (105.99 / 100.55) ,\n",
    "            \"Suicides\": 7\n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Slovakia\",\n",
    "            \"id\": \"SK\",\n",
    "            \"PRIS_OFF_CAP\": 213.29, \n",
    "            \"PRIS_ACT_CAP\":193.65,\n",
    "            \"Living Conditions\": (193.65 / 213.29) ,\n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Greece\",\n",
    "            \"id\": \"GR\",\n",
    "            \"PRIS_OFF_CAP\": 92.64 , \n",
    "            \"PRIS_ACT_CAP\":101.55 ,\n",
    "            \"Living Conditions\": (101.55  / 92.64 ) , \n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Italy\",\n",
    "            \"id\": \"IT\",\n",
    "            \"PRIS_OFF_CAP\":  85.68 , \n",
    "            \"PRIS_ACT_CAP\":104.04 ,\n",
    "            \"Living Conditions\": (104.04 / 85.68 ) ,\n",
    "            \"Suicides\": 53\n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Portugal\",\n",
    "            \"id\": \"PT\",\n",
    "            \"PRIS_OFF_CAP\": 125.86 , \n",
    "            \"PRIS_ACT_CAP\":125.99 ,\n",
    "            \"Living Conditions\": (125.99/  125.86 ) ,\n",
    "            \"Suicides\": 11\n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Spain\",\n",
    "            \"id\": \"ES\",\n",
    "            \"PRIS_OFF_CAP\":136.85, \n",
    "            \"PRIS_ACT_CAP\":124.67,\n",
    "            \"Living Conditions\": (124.67 /  136.85) ,\n",
    "            \"Suicides\": 43\n",
    "          },\n",
    "          {\n",
    "            \"title\": \"France\",\n",
    "            \"id\": \"FR\",\n",
    "            \"PRIS_OFF_CAP\":90.86 , \n",
    "            \"PRIS_ACT_CAP\":105.30,\n",
    "            \"Living Conditions\": (105.30 / 90.86 ) ,\n",
    "            \"Suicides\": 128\n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Germany\",\n",
    "            \"id\": \"DE\",\n",
    "            \"PRIS_OFF_CAP\": 87.89 , \n",
    "            \"PRIS_ACT_CAP\": 76.06 ,\n",
    "            \"Living Conditions\": (76.06 / 87.89 ) ,\n",
    "          },\n",
    "          {\n",
    "            \"title\": \"Netherlands\",\n",
    "            \"id\": \"NL\",\n",
    "            \"PRIS_OFF_CAP\": 67.20 , \n",
    "            \"PRIS_ACT_CAP\":68.15 ,\n",
    "            \"Living Conditions\": (68.15 / 67.20) ,\n",
    "            \"Suicides\": 12\n",
    "      \n",
    "        \n",
    "    }]\n",
    "viz5_2020 = [{\n",
    "        \"title\": \"Estonia\",\n",
    "        \"id\": \"EE\",\n",
    "        \"PRIS_OFF_CAP\": 246.66, \n",
    "        \"PRIS_ACT_CAP\":178.03,\n",
    "        \"Living Conditions\": (178.03 / 246.66),\n",
    "        \"Suicides\": 3\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Sweden\",\n",
    "        \"id\": \"SE\",\n",
    "        \"PRIS_OFF_CAP\": 67.38 , \n",
    "        \"PRIS_ACT_CAP\": 70.66  ,\n",
    "        \"Living Conditions\": (70.66  / 67.38),\n",
    "        \"Suicides\": 2\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Denmark\",\n",
    "        \"id\": \"DK\",\n",
    "        \"PRIS_OFF_CAP\": 70.33,\n",
    "        \"PRIS_ACT_CAP\": 71.55,\n",
    "        \"Living Conditions\": (71.55/70.33) ,\n",
    "        \"Suicides\": 4\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Finland\",\n",
    "        \"id\": \"FI\",\n",
    "        \"PRIS_OFF_CAP\": 54.24,\n",
    "        \"PRIS_ACT_CAP\": 49.79,\n",
    "        \"Living Conditions\": (49.79/54.24) ,\n",
    "        \"Suicides\": 4\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Bulgaria\",\n",
    "        \"id\": \"BG\",\n",
    "        \"PRIS_OFF_CAP\": 117.40, \n",
    "        \"PRIS_ACT_CAP\":89.92 ,\n",
    "        \"Living Conditions\": (89.92 / 117.40 ) ,\n",
    "        \"Suicides\": 1\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Hungary\",\n",
    "        \"id\": \"HG\",\n",
    "        \"PRIS_OFF_CAP\":162.80 , \n",
    "        \"PRIS_ACT_CAP\":171.21,\n",
    "        \"Living Conditions\": (171.21/ 162.80) ,\n",
    "        \"Suicides\": 5\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Austria\",\n",
    "        \"id\": \"AT\",\n",
    "        \"PRIS_OFF_CAP\": 99.64 , \n",
    "        \"PRIS_ACT_CAP\":95.36,\n",
    "        \"Living Conditions\": (95.36 / 99.64 ) ,\n",
    "        \"Suicides\": 8\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Poland\",\n",
    "        \"id\": \"PL\",\n",
    "        \"PRIS_OFF_CAP\": 226.75 , \n",
    "        \"PRIS_ACT_CAP\":180.08,\n",
    "        \"Living Conditions\": (180.08/226.75 ),\n",
    "        \"Suicides\": 27\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Romania\",\n",
    "        \"id\": \"RO\",\n",
    "        \"PRIS_OFF_CAP\": 101.05, \n",
    "        \"PRIS_ACT_CAP\":112.54,\n",
    "        \"Living Conditions\": (105.99 / 101.05) ,\n",
    "        \"Suicides\": 14\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Slovakia\",\n",
    "        \"id\": \"SK\",\n",
    "        \"PRIS_OFF_CAP\": 213.00 , \n",
    "        \"PRIS_ACT_CAP\":192.73 ,\n",
    "        \"Living Conditions\": (192.73 / 213.00) ,\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Greece\",\n",
    "        \"id\": \"GR\",\n",
    "        \"PRIS_OFF_CAP\": 94.93, \n",
    "        \"PRIS_ACT_CAP\":106.16,\n",
    "        \"Living Conditions\": (106.16/ 94.93) , \n",
    "        \"Suicides\":6\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Italy\",\n",
    "        \"id\": \"IT\",\n",
    "        \"PRIS_OFF_CAP\":  85.72, \n",
    "        \"PRIS_ACT_CAP\":91.56 ,\n",
    "        \"Living Conditions\": (91.56  / 85.72) ,\n",
    "        \"Suicides\":61\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Portugal\",\n",
    "        \"id\": \"PT\",\n",
    "        \"PRIS_OFF_CAP\": 125.52 , \n",
    "        \"PRIS_ACT_CAP\":111.71,\n",
    "        \"Living Conditions\": (111.71/125.52 ) ,\n",
    "        \"Suicides\": 21\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Spain\",\n",
    "        \"id\": \"ES\",\n",
    "        \"PRIS_OFF_CAP\":136.13, \n",
    "        \"PRIS_ACT_CAP\":116.58,\n",
    "        \"Living Conditions\": (116.58/ 136.13) ,\n",
    "        \"Suicides\":51\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"France\",\n",
    "        \"id\": \"FR\",\n",
    "        \"PRIS_OFF_CAP\":89.99, \n",
    "        \"PRIS_ACT_CAP\":93.10,\n",
    "        \"Living Conditions\": (93.10 / 89.99 ) ,\n",
    "        \"Suicides\": 119\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Germany\",\n",
    "        \"id\": \"DE\",\n",
    "        \"PRIS_OFF_CAP\": 87.00 , \n",
    "        \"PRIS_ACT_CAP\": 71.65,\n",
    "        \"Living Conditions\": (71.65/87.00 ) ,\n",
    "      },\n",
    "      {\n",
    "        \"title\": \"Netherlands\",\n",
    "        \"id\": \"NL\",\n",
    "        \"PRIS_OFF_CAP\": 69.49 , \n",
    "        \"PRIS_ACT_CAP\":63.33,\n",
    "        \"Living Conditions\": (63.33 / 69.49) ,\n",
    "        \"Suicides\": 13\n",
    "      }]\n",
    "\n",
    "def drop_nan_rows(df):\n",
    "    \"\"\"\n",
    "    Drop rows that contain NaN values in a Pandas DataFrame.\n",
    "    \"\"\"\n",
    "    return df.dropna(axis=0, how='any')\n",
    "\n",
    "DF6 = pd.DataFrame()\n",
    "DF7 = pd.DataFrame()\n",
    "DF8 = pd.DataFrame()\n",
    "DF9 = pd.DataFrame()\n",
    "DF10 = pd.DataFrame()\n",
    "\n",
    "DF6 = createDF(viz5_2016,DF6)\n",
    "DF7 = createDF(viz5_2017,DF7)\n",
    "DF8 = createDF(viz5_2018,DF8)\n",
    "DF9 = createDF(viz5_2019,DF9)\n",
    "DF10 = createDF(viz5_2020,DF10)\n",
    "\n",
    "DF6 = DF6.drop(columns=['title','PRIS_ACT_CAP','PRIS_OFF_CAP','id','title'])\n",
    "DF7 = DF7.drop(columns=['title','PRIS_ACT_CAP','PRIS_OFF_CAP','id','title'])\n",
    "DF8 = DF8.drop(columns=['title','PRIS_ACT_CAP','PRIS_OFF_CAP','id','title'])\n",
    "DF9 = DF9.drop(columns=['title','PRIS_ACT_CAP','PRIS_OFF_CAP','id','title'])\n",
    "DF10 = DF10.drop(columns=['title','PRIS_ACT_CAP','PRIS_OFF_CAP','id','title'])\n",
    "\n",
    "# drop NaN\n",
    "DF6 = drop_nan_rows(DF6)\n",
    "DF7 = drop_nan_rows(DF7)\n",
    "DF8 = drop_nan_rows(DF8)\n",
    "DF9 = drop_nan_rows(DF9)\n",
    "DF10 = drop_nan_rows(DF10)\n",
    "\n",
    "print(DF9)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "id": "069e1ba7-ae60-463d-81f3-867302044f10",
   "metadata": {},
   "outputs": [],
   "source": [
    "def calculate_correlation(df):\n",
    "    \"\"\"\n",
    "    Calculate correlation coefficient between two variables in a pandas DataFrame.\n",
    "    \n",
    "    Parameters:\n",
    "        df (pandas.DataFrame): DataFrame containing data for two variables.\n",
    "        \n",
    "    Returns:\n",
    "        float: Pearson correlation coefficient between the two variables.\n",
    "    \"\"\"\n",
    "    x = df.iloc[:,0]\n",
    "    y = df.iloc[:,1]\n",
    "    corr_coef, p_value = stats.pearsonr(x, y)\n",
    "    return corr_coef,p_value"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "id": "f350879f-b000-4d76-b194-7aca3135725d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(0.027442531754036645, 0.9167338235525603)\n",
      "(-0.03630177486306102, 0.8899876254318758)\n",
      "(-0.11874533301732573, 0.6498873117380816)\n",
      "(-0.2440835680360957, 0.3451113199197201)\n",
      "(-0.18749908998087922, 0.4711413350116708)\n"
     ]
    }
   ],
   "source": [
    "# example data\n",
    "data = {'x': [1, 2, 3, 4, 5],\n",
    "        'y': [2, 4, 6, 8, 10]}\n",
    "df = pd.DataFrame(data)\n",
    "\n",
    "# calculate correlation coefficient\n",
    "corr_coef = calculate_correlation(DF1)\n",
    "print(corr_coef)\n",
    "corr_coef2 = calculate_correlation(DF2)\n",
    "print(corr_coef2)\n",
    "corr_coef3 = calculate_correlation(DF3)\n",
    "print(corr_coef3)\n",
    "corr_coef4 = calculate_correlation(DF4)\n",
    "print(corr_coef4)\n",
    "corr_coef5 = calculate_correlation(DF5)\n",
    "print(corr_coef5)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "718da4ef-48ab-4dbf-85b5-188f0ce75994",
   "metadata": {},
   "source": [
    "The first year(2016) = 0.027442531754036645 <br>\n",
    "The second year(2017) = -0.03630177486306102 <br>\n",
    "The third year(2018) = -0.11874533301732573 <br>\n",
    "The fourth year(2019) = -0.2440835680360957 <br>\n",
    "The fourth year(2020) = -0.18749908998087922 <br>\n",
    "\n",
    "\n",
    "The first two year(2016,2017) = -0.003136083759218096 <br>\n",
    "The first three years(2016,17,18) = -0.046247764089734876 <br>\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2fe336a5-052e-42b6-8166-86120941b60e",
   "metadata": {},
   "source": [
    "A correlation coefficient measures the strength of the relationship between two variables.\n",
    "The most commonly used correlation coefficient is the Pearson coefficient, which ranges from -1.0 to +1.0.\n",
    "A positive correlation indicates two variables that tend to move in the same direction.\n",
    "A negative correlation indicates two variables that tend to move in opposite directions.\n",
    "A correlation coefficient of -0.8 or lower indicates a strong negative relationship, while a coefficient of -0.3 or lower indicates a very weak one."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "id": "526fa57c-8c1b-4235-a9f9-16548bdfb625",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(0.11266702379436973, 0.7013620094387367)\n",
      "(0.16235214416896915, 0.5480146642608515)\n",
      "(0.4248988906818991, 0.100888003345688)\n",
      "(0.45228431713273787, 0.10442987481284179)\n",
      "(0.1821655895100144, 0.5158283956843357)\n"
     ]
    }
   ],
   "source": [
    "# calculate correlation coefficient\n",
    "corr_coef = calculate_correlation(DF6)\n",
    "print(corr_coef)\n",
    "corr_coef2 = calculate_correlation(DF7)\n",
    "print(corr_coef2)\n",
    "corr_coef3 = calculate_correlation(DF8)\n",
    "print(corr_coef3)\n",
    "corr_coef4 = calculate_correlation(DF9)\n",
    "print(corr_coef4)\n",
    "corr_coef5 = calculate_correlation(DF10)\n",
    "print(corr_coef5)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "be353367-45b1-4dae-bedf-a0e1047fbcf5",
   "metadata": {},
   "source": [
    "### calculating co-relation for the entire set of years data "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "id": "34510161-4e78-466f-97b4-754189b63f9f",
   "metadata": {},
   "outputs": [],
   "source": [
    "DF_1 = pd.DataFrame()\n",
    "DF_2 = pd.DataFrame()\n",
    "\n",
    "dflst1 = [DF1,DF2,DF3,DF4,DF5]\n",
    "dflst2 = [DF6,DF7,DF8,DF9,DF10]\n",
    "\n",
    "for item in dflst1:\n",
    "    DF_1 = pd.concat([DF_1,item])\n",
    "    \n",
    "for item2 in dflst2:\n",
    "    DF_2 = pd.concat([DF_2,item2])\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "id": "0a011d59-12ac-439d-81ab-2c8a59c8dc50",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Result 1 is -  (-0.1402607892776991, 0.20042786331382934)\n",
      "Result 2 is -  (0.26154757820785013, 0.023412482928931434)\n"
     ]
    }
   ],
   "source": [
    "result1 = calculate_correlation(DF_1)\n",
    "\n",
    "result2 = calculate_correlation(DF_2)\n",
    "\n",
    "print(\"Result 1 is - \",result1)\n",
    "print(\"Result 2 is - \",result2)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e805ffce-479e-4a37-8137-6f067d073ad9",
   "metadata": {},
   "source": [
    "## Concluding thoughts"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ffdb4059-7040-4e85-8f4b-82d091096a67",
   "metadata": {},
   "source": [
    "The results for the co-relation coefficient calculated for specific years does provide us with a semi-consistent value range but due to lack of larger dataset, the p-calue is generally very high and does not allow us to draw a generalisable conclusion but we could still say few things from the results.\n",
    "\n",
    "For the first visualisation done to compare the `Living conditions in prison` with `Governament expenditure`, we get a very very weak negative value for the coefficient which does imply that higher expenditure by the governament on maintining these public systems can be a factor in better living conditions in prison which means that they do not get over-populated. \n",
    "\n",
    "For the second visualisation done to compare the `Living conditions in prison` with `Suicides in prison` , we get a very week positive value for the coefficient which implies that higher suicides can be an indicator of overpopulated prisons.\n",
    "\n",
    "To get better p_values for our coefficients we also calculated it after merging the datasets for all the years together and it did provide us better p_values as you can see above, especially for the second set of compared variables, we get a p_value if 0.02 which is an indicator that the co-efficient value is not a result of chance and can be considered somewhat generalisable."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.10.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}