Datasets Analysis

First task when preprocessing economical datasets was to remove non-EU countries, which was done with custom lambda function. Also, some country naming discrepancies were found (Czech Republic - Czechia). Some median age data was missing so dataframe had to be appended with relevant values. The whole cleaning process was finished with merging all datasets into one by country column. Visualizing dataset in a form of the bar chart give us some additional insights. You can easily observe that there are 16 countries where GDP range is between 10,000 and 30,000 USD/capita and 11 countries with GDP between 30,000 and 115,000 with much larger spread. When you also take for consideration the 75% centile , the amount (47614.01) is much lower that the max value and this shows that there are 2 high value outliers, Ireland and Luxembourg.

After removing non-EU countries and standardising their names, next step was to keep only the recent data column as datasets contain data from year 1960. Null value gaps were filed with most recent non-null data from previous years. Once all three datasets were merged into one by country column, I got curious if there is simple linear correlation between country's GDP and a size of a healthcare sector. Common sense would be to say, that wealthy country has more doctors than the poor one. So, I did some analysis in that subject.

First step was to merge dataset with GDP column from economical dataset. Then I had to normalize the data to keep everything in range 0-1, where 1 is the top value and 0 is the lowest. This way it'll be easier for me to compare different value sizes. Once shown on the graph to the right, it's hard to say what top 10 countries have in common.

Much clearer situation is when it comes to nursing staff. Ireland takes the lead in Europe and generally, rich countries have more nurses than the poor ones. I think the main cause would be that the graduated nurses, often drastically underpaid are migrating for better job contracts.

Again, not that clear situation with hospital beds. But two conclusions can be made. First is that Post-soviet countries have more hospital beds due to the fact, that Soviet Union was preparing the invasion on the West and those countries supposed to be the battlefield. Secondly interesting observation is Sweden - I think that has a very low number of hospital beds forced government to seek herd immunity instead of taking a path of the other European countries.