format_columns
The format_columns method creates a new table containing a new, formula column defining a column format for
each argument. It is a special case of update_view that creates columns that hold
format information instead of regular data.
Since format_columns is implemented using update_view, the new columns are not stored in memory, and instead a
formula is stored that is used to determine the format for each cell/row when necessary.
Syntax
Parameters
| Parameter | Type | Description |
|---|---|---|
| column_formats | Union[str, list[str]] | Formulas to compute formats for columns or rows in the table; e.g., For color formats, the result of each formula must be either a color string (such as a hexadecimal RGB color,
e.g. For decimal formats, the result must be a string, and the formula must be wrapped in the special internal
function |
Returns
A new table that includes all the original columns from the source table and the newly defined format columns. The format columns are identified internally by the query engine by appending a suffix to the column name.
Examples
In the following example, the column A is formatted with a color depending on the value of column B, and
column C is specified to display values as a percentage using the decimal format pattern 0.00%.