Icon

02 Data Manipulation

Documentation for Data Manipulation:In workflow 1, I used the GroupBy nodes to see the average lifeexpectancies by Region and Country.In workflow 2, I used Pivoting to see the average life expectancy in eachregion by year. This is to see if the life expectancies are increasing/decreasing with each passing year.In workflow 3, I imported another CSV file that has data on HumanDevelopment Index. I used the column filter and included some of thecolumns that combines well with the other CSV data. Next, I used aJoiner to merge those datasets by the “Country”. Next I concatenated allthe datasets by adding another Human Development Index file with adifferent columns. Workflow 1 Workflow 2 Workflow 3 Average life-expectancy in each region by yearnew column "Life-Expectancy(High/Low/Avg)"Average Life Expectancy by RegionLife Expectancy DataAverage Life Expectancy by CountryLife Expectancy Datanew column "Life-Expectancy(High/Low/Avg)"Life Expectancy DataHuman Development IndexFiltered columns by Year 2010Inner join by countryHuman Development IndexFiltered columns by Year 2010Filtered missing values in coumn: UNDP Developing RegionsConcatenated all three datasets Pivoting Rule Engine GroupBy CSV Reader GroupBy CSV Reader Rule Engine CSV Reader CSV Reader Column Filter Joiner CSV Reader Column Filter Row Filter Concatenate Documentation for Data Manipulation:In workflow 1, I used the GroupBy nodes to see the average lifeexpectancies by Region and Country.In workflow 2, I used Pivoting to see the average life expectancy in eachregion by year. This is to see if the life expectancies are increasing/decreasing with each passing year.In workflow 3, I imported another CSV file that has data on HumanDevelopment Index. I used the column filter and included some of thecolumns that combines well with the other CSV data. Next, I used aJoiner to merge those datasets by the “Country”. Next I concatenated allthe datasets by adding another Human Development Index file with adifferent columns. Workflow 1 Workflow 2 Workflow 3 Average life-expectancy in each region by yearnew column "Life-Expectancy(High/Low/Avg)"Average Life Expectancy by RegionLife Expectancy DataAverage Life Expectancy by CountryLife Expectancy Datanew column "Life-Expectancy(High/Low/Avg)"Life Expectancy DataHuman Development IndexFiltered columns by Year 2010Inner join by countryHuman Development IndexFiltered columns by Year 2010Filtered missing values in coumn: UNDP Developing RegionsConcatenated all three datasets Pivoting Rule Engine GroupBy CSV Reader GroupBy CSV Reader Rule Engine CSV Reader CSV Reader Column Filter Joiner CSV Reader Column Filter Row Filter Concatenate

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Rena
Created at: 2023-04-09
On NodePit since: 2023-04-10
Last update: 2024-05-02
Created with KNIME version: v4.7.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!