Advanced Scripting

  • Updated on Dec 23, 2022
  • Published on Mar 14, 2022
  • 1 minute(s) read
Prev Next

These exercises will explore some advanced use cases for nodes that use scripts to process data: Script (Source), Script (Column) and Script (Output) for Python/R, and Filler and Derive for JavaScript.


Exercises

  1. Using only the Script (Source), Script (Column) and Script (Output) nodes, aggregate DailySales_Store1.csv and DailySales_Store2.csv. Set the minimum quantiy to 10, and export this output to CSV.

  1. Using the Derive node, add a column to DailySales_Store1.csv that represents a running total of the Revenue column.

  1. Using the Filler node, convert the iris.csv dataset from using centimeters to inches.

Hints

  1. Read through Source Script, Column Script and Output Script.

  1. Read through Derive.

  1. Read through Filler.