Filter data with Code Assist

The Titanic data have been assigned to a variable named df.

Hover over the icon. Select the Transformations item from the popup menu.

The Transformations dialog appears. Select the target variable from the dropdown menu and preview the data.

Click on the kebab icon to the right of any of the nan values in the Cabin column. Then click on the Filter values like this popup button.

A dialog appears with fields to choose a column, an operator and a value. The value is set to nan by default.

Since we are wanting to exclude records with missing values, we change the operator from == to !=. Press the Apply button.

The required code is inserted into the notebook and immediately executed.

Under the Column selector choose Embarked. Set Operator to == and Value to S. Turn the as string toggle on. Press the Add Transformation button.

The preview is updated to show only those records where Embarked is "S".

Under the Column selector choose Pclass. Set Operator to < and Value to 3. Press the Add Transformation button.

The preview is updated to show only those records where Embarked is "S" and Pclass is less than 3. Press the Insert Code button.

The required code is inserted into the notebook and immediately executed.