Filtering and Transforming Data

Overview


One of the key skills utilized when building analytics is the ability to filter or otherwise transform data.

Data that represents a dataset (that is, a plurality of data points), is usually contained within an Javasript array. Arrays provide a set of functions for filtering and transformation.

In addition, the davinci platform provides an additional data type, $list which provides array like functionality and but also includes additional methods for querying and transforming the underlying data.

Topics


  • Iterating a Dataset
  • Filtering
  • Transforming (Map)
  • Grouping
  • Joining

Transformation Apps


In addition to basic scripting facilities, the davinci platform provides a number of different apps and graphical tools for transforming data.

  • View Data App
  • Indicators App - adds computed columns to a tabular dataset. Mostly used with time series.
  • Edit Table - lets users edit records in an array of data