Solution
This directory contains 9 workflows.
01 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. […]
02 Accessing Databases
Exercise for reading data from a database
03 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) […]
04 Numbers Strings and Rules
Exercise for data transformation. Perform data manipulation operations with the Rule Engine, Math Formula, String Manipulation, and Column Expressions […]
05 Date and Time Manipulation
Exercise for date and time manipulation. Perform data manipulation operations that are specific to date and time values.
06 Aggregations
Exercise for data aggregation. Calculate statistics for subgroups of data with the GroupBy and Pivoting nodes.
07 Join and Concatenate
Exercises for joining and concatenating data. Join tables with different information for the same ID. Concatenate tables with the same information for […]
08 Database Data Manipulation
Exercise for manipulating data on a database. Select a table on the database and aggregate and filter the data directly on the […]
09 Metanodes
Exercise for practicing with metanodes. Structure your workflow by collapsing parts of it into metanodes.