PivotBuilder class

Definition

Interactive object that can be used to generate pivoted columns from the selected pivot columns.

PivotBuilder(dataflow: azureml.dataprep.api.dataflow.Dataflow, engine_api: azureml.dataprep.api.engineapi.api.EngineAPI, columns_to_pivot: typing.List[str], value_column: str, summary_function: azureml.dataprep.api.engineapi.typedefinitions.SummaryFunction = None, group_by_columns: typing.List[str] = None, null_value_replacement: str = None, error_value_replacement: str = None)
Inheritance
builtins.object
PivotBuilder

Remarks

This Builder allows for generation, modification and preview of pivoted columns.

Methods

learn() -> None

Generates pivoted columns from selected pivot columns values. There will be one pivoted column generated per distinct row, where each distinct row is defined by the values in the selected pivot columns.

to_dataflow() -> azureml.dataprep.api.dataflow.Dataflow

Returns a new dataflow with encoded labels in a new column. If encoded_labels are not defined, they will be learned from source_column's values.

learn() -> None

Generates pivoted columns from selected pivot columns values. There will be one pivoted column generated per distinct row, where each distinct row is defined by the values in the selected pivot columns.

learn() -> None

to_dataflow() -> azureml.dataprep.api.dataflow.Dataflow

Returns a new dataflow with encoded labels in a new column. If encoded_labels are not defined, they will be learned from source_column's values.

to_dataflow() -> azureml.dataprep.api.dataflow.Dataflow

Returns

A new Dataflow with a new column that contains encoded labels.

Attributes

pivoted_columns

Returns the list of pivoted columns.

Remarks

pivoted_columns can be assigned by calling learn() -> None, which will generate and assign the pivoted_columns for you. Alternatively, you can directly assign the value to pivoted_columns.