Filling null or empty cells

If you have a column that contains null cells or empty cells, you can specify a value to add to each of these cells.

To fill null or empty cells in a column, follow these steps:

1. Click the drop-down button next to the column name.

2. Click Fill null or empty cells.

3. Enter the value you want appear in all null or empty cells.

4. Click Apply.

Wrangler fills all null and empty cells with the specified value and adds the fill-null-or-empty directive to the recipe. When you run the data pipeline, the transformation will be applied to all values in the column.

For example, you have a column with 10 empty cells and 5 null cells, you can use the drop-down menu for the column called Age and select Fill null or empty cells and enter N/A. Wrangler updates the sample dataset and add the directive fill-null-or-empty :Age 'N/A' to the recipe.