Class DisplayOptions (1.4.0)

DisplayOptions(
    max_columns: int = 20,
    max_rows: int = 25,
    progress_bar: typing.Optional[str] = "auto",
    repr_mode: typing.Literal["head", "deferred"] = "head",
    max_info_columns: int = 100,
    max_info_rows: typing.Optional[int] = 200000,
    memory_usage: bool = True,
)

Encapsulates the configuration for displaying objects.

Examples:

Define Repr mode to "deferred" will prevent job execution in repr.

import bigframes.pandas as bpd df = bpd.read_gbq("bigquery-public-data.ml_datasets.penguins")

bpd.options.display.repr_mode = "deferred" df.head(20) # will no longer run the job Computation deferred. Computation will process 28.9 kB

Users can also get a dry run of the job by accessing the query_job property before they've run the job. This will return a dry run instance of the job they can inspect.

df.query_job.total_bytes_processed 28947

User can execute the job by calling .to_pandas()

df.to_pandas()

Reset repr_mode option

bpd.options.display.repr_mode = "head"

Can also set the progress_bar option to see the progress bar in terminal,

bpd.options.display.progress_bar = "terminal"

notebook,

bpd.options.display.progress_bar = "notebook"

or just remove it.

bpd.options.display.progress_bar = None

Setting to default value "auto" will detect and show progress bar automatically.

bpd.options.display.progress_bar = "auto"

Attributes

Name Description
max_columns int, default 20
If max_columns is exceeded, switch to truncate view.
max_rows int, default 25
If max_rows is exceeded, switch to truncate view.
progress_bar Optional(str), default "auto"
Determines if progress bars are shown during job runs. Valid values are auto, notebook, and terminal. Set to None to remove progress bars.
repr_mode Literal[head, deferred]
head: Execute, download, and display results (limited to head) from Dataframe and Series objects during repr. deferred: Prevent executions from repr statements in DataFrame and Series objects. Instead, estimated bytes processed will be shown. DataFrame and Series objects can still be computed with methods that explicitly execute and download results.
max_info_columns int
max_info_columns is used in DataFrame.info method to decide if information in each column will be printed.
max_info_rows int or None
df.info() will usually show null-counts for each column. For large frames, this can be quite slow. max_info_rows and max_info_cols limit this null check only to frames with smaller dimensions than specified.
memory_usage bool
This specifies if the memory usage of a DataFrame should be displayed when df.info() is called. Valid values True,False,