The Transformations widget can be used to chain together multiple operations.
For this tutorial we’ll use the Titanic data.
-
Hover over the icon. Select the Transformations item from the popup menu. Select the Groupby and aggregate option.
-
Specify
Pclass
andEmbarked
as the columns to group by. ChooseFare
as the column to aggregate. Selectmean
as the aggregator function. Press the button. -
The preview is updated with the summary data.
-
Next we’re going to filter the rows. Specify
Embarked
as the columns to filter by. Choose!=
as the operator andQ
as the value. Turn theas string
toggle on. Press the button. -
The preview is updated with the filtered data. Finally select the Drop columns option and specify
Embarked
as the column to drop. Press the button. -
The preview is updated. Press the
button. -
The required code is inserted into the notebook and immediately executed.