Concept | Dataset conditional formatting#
Let’s learn how conditional formatting can help you organize and visualize your dataset with color.
Introduction#
Dataiku provides a few formatting options that can add colors to cells in a column. A preview of the column colors will always appear.
Enable from context menu#
You can enable different color formats in the context menu of a column under Conditional formatting.
Enable from Display menu#
You can also enable conditional formatting from the Display menu. However, this will apply the conditional formatting to each column, rather than to individual columns.
Color by meaning validity#
Color by meaning validity is the default display of a dataset.
Cells are colored depending on if their value reflects or does not reflect the column meaning. This allows you to analyze your data quality at a high level. For instance, seeing the color red across all of your columns may indicate that you need to perform some data cleaning.
Note
Learn about column meanings in Concept | Dataset characteristics.
Color by rules#
Color by rules provides a way to color cells by certain logical conditions. You can choose one color per condition, as show here:
Color scale#
The Color scale option uses a sequence of colors to represent a column value’s numerical scale. For example, a column of integers may show the largest value in a dark color and the smallest value in a light color.
