Joule
Search
K
Comment on page

Transform

The process of taking an original value and input variables and derive a target feature ready for analytic processing

Log Transform

Log transformation is a data transformation method in which it replaces each variable x with a log(x) where x is a positive number and greater than zero
Attribute
Description
Type
Required
source field
The column to perform the calculation upon
Double

Example

features:
compute:
log_spend:
function:
log transform:
source field: spend

Day of Week Transform

Provide the day of week from the passed date object to a number between 1 and 7, where start of week is Monday(1).

Supported date objects:

  • java.time.LocalDate
  • java.sql.Date
  • org.joda.time.DateTime

Attributes

Attribute
Description
Type
Required
source field
The column to perform the calculation upon
Double

Example

features:
compute:
day_of_week:
function:
day-of-week transform:
source field: date

Day Binning

Categorise a day into one of two categories where a weekday (Mon-Fri) is assigned as 1 and 2 for (Sat-Sun)

Attributes

Attribute
Description
Type
Required
source field
The column to perform the calculation upon
Double

Example

features:
compute:
day_bin:
function:
day binning:
source field: date

Age Binning

Categorise a passed age value, either an integer or date object, in to a pre-configured age bin.

Attributes

Attribute
Description
Type
Required
bins
Array of age bins to use. Default bins are set to 0-9, 10-19,...110-119.
Int[][]
as date
Passed event field is a supported date object.
Supported Data classes
  • java.time.LocalDate
  • java.sql.Date
Boolean
Default: false
base date
Provide a date which is used to calculate the age. Default set to the date process is started
String
Format: YYYY-MM-DD
source field
The column to perform the calculation upon
Double

Example

features:
compute:
age_bin:
function:
age binning:
bins: [ [0,18], [19,21], [22, 40], [41, 55], [56,76]]
base date: 2023-01-01
source field: current_age