Icon

JKISeason3-4_​tomljh-part2

Causes of Death in the EU

Level: Medium

Description: You work for the United Nations and want to discuss how the causes of death vary across the European Union (EU). You know how to analyze data and generate insightful visualizations, but the data you have at hand is a bit challenging: the meaning of its different columns and codes is not clear. To conclude your work well, you will have to integrate this data with some metadata in XML format, making sense of the different death causes and data attributes. What patterns can you find in the different countries?

Author: Emilio Silvestri

Datasets: Demographic Data from the EU in the KNIME Community Hub

Part 2: Data analysis 1、Directly obtain statistical rowsTip: Only analyze the dimension of the cause of death 2.On the basis of the dimension of cause of death,overlay the geo dimension analysis Note: [A-Z]|A_B|S_T|G_H|U.*|Z.*|V01-Y89Cause of death filter conditions:1. Statistics are based on major diseases, so capital letters A-Z are used.2. But there are special circumstances where some types of diseases are merged, such as A_B, G_H, and S_T.3. In 2021, the special epidemic was classified into category U, but there was no major category U, only minoritems. So the filtering condition is "U.*" The output file of the part 1EU_death_causes_2021.tablesex = "Total"age = "Total"resid = " All deaths reported in the country" Filter by major categories of causes of deathregex: [A-Z]|A_B|S_T|G_H|U.*|Z.*|V01-Y89Order by OBS_VALUE DesRanking of main causes of deathtop: European Unionbottom: Other countriesgroup by : geo_desc/countriespivot: icd10_descagg: firstThe proportion of each reasonsumk=3rowid -> geo_descgroup by geo_descRanking of main causes of deathk=5 Table Reader Row Filter Row Filter Row Filter Row Filter Sorter Bar Chart Row Splitter Pivot Math Formula(Multi Column) Column Aggregator Scatter Plot Color Manager k-Means RowID Group Loop Start Bar Chart Top k Row Filter Image to Table Loop End Part 2: Data analysis 1、Directly obtain statistical rowsTip: Only analyze the dimension of the cause of death 2.On the basis of the dimension of cause of death,overlay the geo dimension analysis Note: [A-Z]|A_B|S_T|G_H|U.*|Z.*|V01-Y89Cause of death filter conditions:1. Statistics are based on major diseases, so capital letters A-Z are used.2. But there are special circumstances where some types of diseases are merged, such as A_B, G_H, and S_T.3. In 2021, the special epidemic was classified into category U, but there was no major category U, only minoritems. So the filtering condition is "U.*" The output file of the part 1EU_death_causes_2021.tablesex = "Total"age = "Total"resid = " All deaths reported in the country" Filter by major categories of causes of deathregex: [A-Z]|A_B|S_T|G_H|U.*|Z.*|V01-Y89Order by OBS_VALUE DesRanking of main causes of deathtop: European Unionbottom: Other countriesgroup by : geo_desc/countriespivot: icd10_descagg: firstThe proportion of each reasonsumk=3rowid -> geo_descgroup by geo_descRanking of main causes of deathk=5Table Reader Row Filter Row Filter Row Filter Row Filter Sorter Bar Chart Row Splitter Pivot Math Formula(Multi Column) Column Aggregator Scatter Plot Color Manager k-Means RowID Group Loop Start Bar Chart Top k Row Filter Image to Table Loop End

Nodes

Extensions

Links