Icon

Challenge 2 - Linguistic Diversity

<p><strong>Difficulty:</strong> Easy</p><p><strong>Description: </strong>You are a linguist studying linguistic diversity around the world. You’ve 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., how many months per year crops can be grown in that country, on average).</p><p><strong>Beginner-Friendly Objectives:</strong></p><ol><li><p>Learn how to import a CSV file into KNIME.</p></li><li><p>Perform calculations between columns.</p></li><li><p>Sort a table using a specific criterion.</p></li><li><p>Filter the top rows based on your selected criteria.</p></li></ol><p><strong>Try to answer these questions:</strong></p><ol><li><p>What are the top 5 countries by the number of languages spoken?</p></li><li><p>What are the top 5 countries by the ratio of languages spoken to population?</p></li><li><p>What are the top 5 countries by the ratio of languages spoken to land area?</p></li><li><p>Finally, do you notice any patterns related to the MGS value?</p></li></ol>

Challenge 2 - Linguistic Diversity


Level: Easy

Description:You are a linguist studying linguistic diversity around the world. You’ve 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., how many months per year crops can be grown on average).

Beginner-Friendly Objectives:

  1. Learn how to import a CSV file into KNIME.

  2. Perform calculations between columns.

  3. Sort a table using a specific criterion.

  4. Filter the top rows based on your selected criteria.

Tasks: Look at the dataset and answer these questions:

  1. What are the top 5 countries by the number of languages spoken?

  2. What are the top 5 countries by the ratio of languages spoken to population?

  3. What are the top 5 countries by the ratio of languages spoken to land area?

  4. Finally, do you notice any patterns related to the MGS value?

  1. Papua New Guinea, Indonesia, Nigeria, India, Cameroon

  2. Vanuatu, Papua New Guinea, French Guiana, Suriname, Gabon

  3. Nepal, Togo, Papua New Guinea, Solomon Islands, Vanuatu

  4. All the countries mention have a high MGS value, highlighting how fertile a land could be a reason why many languages developed there

nettle_1999_climate.csv
CSV Reader
top 5 by lang
Top k Row Filter
compute lang / population ratio
Expression
top 5 by lang/pop ratio
Top k Row Filter
compute lang / arearatio
Expression
top 5 by lang/area ratio
Top k Row Filter

Nodes

Extensions

Links