Icon

JKI Challenge 02 - Linguistic Diversity

<p>You are a linguist studying linguistic diversity around the world. You have found a dataset that includes information about countries, such as the number of languages spoken, area, and population. The dataset also contains a column called MGS, which refers to the mean growing season in each country (i.e., for how many months per year crops can be grown on average). What are the top 5 countries by the number of languages spoken? What are the top 5 countries by the ratio of languages spoken to population? What are the top 5 countries by the ratio of languages spoken to land area? Finally, do you notice any patterns between the numbers of languages spoken and the MGS values?</p>

URL: Subscribe to my KNIME focused YouTube channel (free) https://www.youtube.com/@bytesandbudgets?sub_confirmation=1
URL: JKI 4-2 on the KNIME forum https://forum.knime.com/t/solutions-to-just-knime-it-challenge-2-season-4/88065

Description


You are a linguist studying linguistic diversity around the world. You have found a dataset that includes information about countries, such as the number of languages spoken, area, and population. The dataset also contains a column called MGS, which refers to the mean growing season in each country (i.e., for how many months per year crops can be grown on average). What are the top 5 countries by the number of languages spoken? What are the top 5 countries by the ratio of languages spoken to population? What are the top 5 countries by the ratio of languages spoken to land area? Finally, do you notice any patterns between the numbers of languages spoken and the MGS values?

Objective 1 (Easy): Learn how to import a CSV file into KNIME.
Objective 2 (Easy): Perform ratio calculations between columns (e.g., number of languages spoken and population size ratio).
Objective 3 (Easy): Sort the resulting table using specific criteria to select top 5 countries.
Objective 4 (Easy): Filter the top rows based on your selected criteria.

Objective 1 - Import CSV



Objective 2 - Ratio Calc



Objective 3 - Sort



Objective 4 - Top 5 Countries



Bonus - Relationships



import climate dataset
CSV Reader
calculatelang 2 population &lang 2 arearatios
Expression
sort bylang 2 population(descending)
Sorter
sort bylang 2 area(descending)
Sorter
top 5 countriesby lang 2 population(descending)
Top k Row Filter
top 5 countriesby lang 2 population(descending)
Top k Row Filter
Lang 2 Population RatiovsMGS
Generic ECharts View
Lang 2 Area RatiovsMGS
Generic ECharts View

Nodes

Extensions

Links