Skip to main content

De-Pivot

Synopsis

This operator transforms the ExampleSet by converting the examples of the selected attributes (usually attributes that measure the same characteristic) into examples of a single attribute.

Description

This operator is usually used when your ExampleSet has multiple attributes that measure the same characteristic (may be at different time intervals) and you want to merge these observations into a single attribute without loss of information. If the original ExampleSet hasnexamples andkattributes that measure the same characteristic, after application of this operator the ExampleSet will havekxnexamples. Thekattributes will be combined into one attribute. This attribute will havenea的例子ch of thekattributes. This can be easily understood by studying the attached Example Process.

In other words, this operator converts an ExampleSet by dividing examples which consist of multiple observations (at different times) into multiple examples, where each example covers one point in time. An index attribute is added in the ExampleSet, which denotes the actual point in time the example belongs to after the transformation.

Thekeep missingsparameter specifies whether an example should be kept, even if it has missing values for all series at a certain point in time. Thecreate nominal indexparameter is only applicable if only one time series per example exists. Instead of using a numeric index, then the names of the attributes representing the single time points are used as index attribute values.

Input

example set input

This input port expects an ExampleSet. It is the output of the Subprocess operator in the attached Example Process. The output of other operators can also be used as input.

Output

example set output

The selected attributes are converted into examples of a new attribute and the resultant ExampleSet is output of this port.

original

The ExampleSet that was given as input is passed without changing to the output through this port. This is usually used to reuse the same ExampleSet in further operators or to view the ExampleSet in the Results Workspace.

Parameters

Attribute name

This parameter maps a number of source attributes onto result attributes. The attribute name parameter is used for specifying the group of attributes that you want to combine and the name of the new attribute. The attributes of a group are selected through a regular expression. There can be numerous groups with each group having multiple attributes.

Index attribute

This parameter specifies the name of the newly created index attribute. The index attribute is used for differentiating between examples of different attributes of a group after the transformation.

Create nominal index

Thecreate nominal indexparameter is only applicable if only one time series per example exists. Instead of using a numeric index, then the names of the attributes representing the single time points are used as index attribute values.

Keep missings

Thekeep missingsparameter specifies whether an example should be kept, even if it has missing values for all series at a certain point in time.