Skip to content

Click in-app to access the full platform documentation for your version of DataRobot.

Highlight data

The Data Prep Highlight tools provide visual queues that help you to better understand your data. You can highlight patterns, spaces, and numeric ranges, then use column operations to update values.

Work with the Highlight tools

To work with highlighting, hover over the Highlight tools in the project Tools bar and select the patterns, spaces, or ranges tool.


You can enable all Highlight tools simultaneously.

Highlight patterns

The Highlight patterns tool detects cells in your dataset that may be similar to one another and provides a color code to flag those cells.

For example, cells with nearby matching data values share the same color. The Highlight patterns tool is especially useful when used in conjunction with the Filter pane and Columns tool.

Highlight spaces

The Highlight spaces tool automatically highlights space characters in your dataset. Space characters appear as gray boxes. Space characters include the following: space, tab, carriage return, new line character, vertical tab character, form feed character.

Highlight ranges

The Highlight ranges tool provides automatic coloration of numeric columns to indicate where a value falls within the range of all values in the column.

The range displays similar in appearance to a bar graph:

  • All positive values: Suppose the range of values is from 50 to 100. For a cell with value 75, a shaded bar extends halfway across the cell because 75 is halfway between 50 and 100. For cell value 100, the cell is entirely shaded.

  • All negative values: All negative values display with the same basic appearance as for all positive values. For range -100 to -50, cell value -75 has its cell halfway shaded and cell value -50 has its cell entirely shaded.

  • Both positive and negative values: If the column includes negative and positive values, for negative values, the shaded bar extends to the left from the point that represents zero. For positive values, the shaded bar extends to the right from the point that represents zero. If zero is not the midway point of the actual range of values, zero is proportionally positioned to the left or right of center. For example, if your range is from -10 to 1000, the point that represents zero is near the left edge of the cell.


The highlighting does not affect your project’s published AnswerSet. See Export datasets to learn about AnswerSets.

Updated April 12, 2022
Back to top