Icon

Exercises

This directory contains 9 workflows.

Icon01 Read Data from File 

Exercise: Read Data from File. Read the following files, available in the data folder, using the appropriate reader nodes: - airlines.csv. - airplanes.csv. […]

Icon02 Accessing Databases 

02 Accessing Databases Exercise for reading data from a database VIDEO: Accessing Databases […]

Icon03 Row and Column Filtering 

Exercise: Row Filtering. 1) Read the airlines and routes data by executing the reader nodes below. 2) Filter the airline data to the United States. 3) […]

Icon04 Numbers Strings and Rules 

04 Numbers Strings and Rules Exercise for data transformation. Perform data manipulation operations with the Rule Engine, Math Formula, String […]

Icon05 Date and Time Manipulation 

05 Date and Time Manipulation Exercise for date and time manipulation. Perform data manipulation operations that are specific to date and time […]

Icon06 Aggregations 

06 Aggregations Exercise for data aggregation. Calculate statistics for subgroups of data with the GroupBy and Pivoting nodes. VIDEO: […]

Icon07 Join and Concatenate 

07 Join and Concatenate Exercises for joining and concatenating data. Join tables with different information for the same ID. Concatenate tables […]

Icon08 Database Data Manipulation 

08 Database Data Manipulation Exercise for manipulating data on a database. Select a table on the database and aggregate and filter the data […]

Icon09 Metanodes 

09 Metanodes Exercise for practicing with metanodes. Structure your workflow by collapsing parts of it into […]