Pivot (Deprecated)
Synopsis
This operator rotates an ExampleSet by grouping multiple examples of same groups to single examples.
Description
主运营商给定ExampleSet旋转grouping multiple examples of same groups to single examples. Thegroup attributeparameter specifies the grouping attribute (i.e. the attribute which identifies examples belonging to the groups). The resultant ExampleSet hasnexamples wherenis the number of unique values of the group attribute. Theindex attributeparameter specifies the attribute whose values are used to identify the examples inside the groups. The values of this attribute are used to name the group attributes which are created during the pivoting. Typically the values of such an attribute capture subgroups or dates. The resultant ExampleSet hasmregular attributes in addition to the group attribute wheremis the number of unique values of the index attribute. If the given ExampleSet contains example weights (i.e. an attribute with weight role), these weights may be aggregated in each group to maintain the weightings among groups. This description can be easily understood by studying the attached Example Process.
Differentiation
Transpose
The Transpose operator simply rotates the given ExampleSet (i.e. interchanges rows and columns) but the Pivot operator provides additional options like grouping and handling weights.
Input
example set input
This input port expects an ExampleSet. It is the output of the Subprocess operator in the attached Example Process.
Output
example set output
The ExampleSet produced after pivoting is the output of this port.
original
The ExampleSet that was given as input is passed without any modifications 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
Group attribute
This parameter specifies the grouping attribute (i.e. the attribute which identifies examples belonging to the groups). The resultant ExampleSet hasnexamples wherenis the number of unique values of the group attribute.
Index attribute
This parameter specifies the attribute whose values are used to identify the examples inside the groups. The values of this attribute are used to name the group attributes which are created during the pivoting. Typically the values of such an attribute capture subgroups or dates. The resultant ExampleSet hasmregular attributes in addition to the group attribute wheremis the number of unique values of the index attribute.
Consider weights
This parameter specifies whether attribute weights (if any) should be kept and aggregated or ignored.
Weight aggregation
This parameter is only available when theconsider weightsparameter is set to true. It specifies how example weights should be aggregated in the groups. It has the following options: average, variance, standard_deviation, count, minimum, maximum, sum, mode, median, product.
Skip constant attributes
This parameter specifies if the attributes should be skipped if their value never changes within a group.
Data management
This is an expert parameter. There are different options, users can choose any of them