Advanced Scripting
  • 23 Dec 2022
  • 1 Minute to read
  • Dark
    Light

Advanced Scripting

  • Dark
    Light

Article summary

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.


Was this article helpful?