Icon

Solutions

9 workflows in this folder and its subfolders

Icon
01 Read Data from File - Solution

April 2020 · 01 Read Data from File - Solution Solution to an exercise for reading data from a file CHECK YOUR ANSWERS: a. The reader nodes to use are Excel Reader, CSV Reader/File Reader, and Table Reader b. The geo coordinates table has the most rows (245) VIDEO: File Reader https://youtu.be/flaHQw-Qhlg VIDEO:…

Icon
02 Accessing Databases - Solution

April 2020 · 02 Accessing Databases - Solution Solution to an exercise for reading data from a database. CHECK YOUR ANSWERS: The overall life expectancy in the world is 72.6 years according to the data VIDEO: Accessing Databases https://youtu.be/WW0j_n79pIg TAGS: data access,sqlite,database

Icon
03 Row and Column Filtering - Solution

April 2020 · 03 Row and Column Filtering - Solution Solution to an exercise for row and column filtering. CHECK YOUR ANSWERS: Russia has the most inhabitants in Europe in 2019. Vatican City has the least. The life expectancy is at least 80 years in 33 countries/regions VIDEO: Row Filter: Removing Data Rows https…

Icon
04 Numbers Strings and Rules - Solution

October 2020 · 04 Numbers Strings and Rules - Solution Solution to an exercise for data transformation. Perform data manipulation operations with the Rule Engine, Math Formula, String Manipulation, and Column Expressions nodes. VIDEO: Data Manipulation: Numbers, Strings, and Rules https://youtu.be/mJrBXmLQ4ko VIDE…

Icon
05 Date and Time Manipulation - Solution

October 2020 · 05 Date and Time Manipulation - Solution Solution to an exercise for date and time manipulation. Perform data manipulation operations that are specific to date and time values. CHECK YOUR ANSWERS: The date format is yyyy/MM/dd All life expectancy data were accessed in 2020 VIDEO: String to Date&Time…

Icon
06 Aggregations - Solution

October 2020 · 06 Aggregations - Solution Solution to an exercise for data aggregation. Calculate statistics for subgroups of data with the GroupBy and Pivoting nodes. CHECK YOUR ANSWERS: The rank 16 in life expectancy is shared by 5 countries In average the population was increasing from 2018 to 2019 on all conti…

Icon
07 Join and Concatenate - Solution

April 2020 · 07 Join and Concatenate - Solution Solution to an exercise for joining and concatenating data. Join tables with different information for the same ID. Concatenate tables with the same information for different IDs. CHECK YOUR ANSWERS: The joined table contains 174 rows. Some rows were discarded in t…

Icon
08 Database Data Manipulation - Solution

April 2020 · 08 Database Data Manipulation - Solution Exercise for manipulating data on a database. Select a table on the database and aggregate and filter the data directly on the database. CHECK YOUR ANSWERS: In countries where life expectancy is at least 80 years, the most common travel risk category is 1: Ex…

Icon
09 Metanodes - Solution

April 2020 · 09 Metanodes - Solution Solution to an exercise for practicing with metanodes. Structure your workflow by collapsing parts of it into metanodes. VIDEO: Metanodes to Clean Up Workflows https://youtu.be/TpApSOR2mrI TAGS: metanode