Skip to main content
Version: Python

format_row_where

The format_row_where method applies color formatting to rows of the source table, based on user-specified conditions.

Syntax​

table.format_row_where(cond: str, formula: str) -> Table

Parameters​

ParameterTypeDescription
condstr

The condition expression.

formulastr

Formulas to compute formats for columns or rows in the table; e.g., "X = Y > 5 ? RED : NO_FORMATTING". For color formats, the result of each formula must be either a color string (such as a hexadecimal RGB color, e.g. "#040427"), a Color, or a packed long representation of the background and foreground color (as returned by bgfg() or bgfga()).

For decimal formats, the result must be a string, and the formula must be wrapped in the special internal function Decimal(); e.g., "X = Decimal(`$#,##0.00`)".

Returns​

A new table that applies the specified formatting to the source table.

Examples​

In the following example, we use format_row_where to paint the table's 4th row red.

from deephaven import time_table

tt = time_table("PT1S").update("X = ii")

result = tt.format_row_where(cond="X > 2 && X < 4", formula="RED")