data_table

data_table#

Interactive DataFrame display on IPython using itables.

Functions

get_ITable_widget

ipywidgets-compatible itables DataFrame display on IPython.

show

Interactive DataFrame display on IPython using itables.
get_ITable_widget(data: DataFrame, table_name: str = None, search_columns_per_row: int = 4, max_bytes: str = '64KB')#

ipywidgets-compatible itables DataFrame display on IPython.

Parameters:

  • data (pandas.DataFrame) – The Pandas DataFrame to be displayed.

  • table_name (str, optional) – An optional title to display above the table. If provided, the title is also used as an HTML id for CSS.

  • search_columns_per_row (int, default 4) – Determines the grid layout of the SearchPanes (filter boxes).

  • max_bytes (str, default "64KB") – The maximum data size threshold for itables to render. If data size is larger than max_bytes, it will be downsampled. To remove the size threshold, set max_bytes to 0. Note that this may cause a performance issue if data is large.

Notes

On the first call, this function performs a global initialization:

  1. Injects customized layout CSS.

  2. Initializes itables notebook mode with connected=True.

The resulting dataframe display includes:

  • Pagination: Display data in pages of maximum 10 records.

  • Filters: High-level filters for attributes values.

  • Column Controls: Individual dropdown searches per column.

show(data: DataFrame, table_name: str = None, search_columns_per_row: int = 4, max_bytes: str = '64KB')#

Interactive DataFrame display on IPython using itables.

Parameters:

  • data (pandas.DataFrame) – The Pandas DataFrame to be displayed.

  • table_name (str, optional) – An optional title to display above the table. If provided, the title is also used as an HTML id for CSS.

  • search_columns_per_row (int, default 4) – Determines the grid layout of the SearchPanes (filter boxes).

  • max_bytes (str, default "64KB") – The maximum data size threshold for itables to render. If data size is larger than max_bytes, it will be downsampled. To remove the size threshold, set max_bytes to 0. Note that this may cause a performance issue if data is large.

Notes

On the first call, this function performs a global initialization:

  1. Injects customized layout CSS.

  2. Initializes itables notebook mode with connected=True.

The resulting dataframe display includes:

  • Pagination: Display data in pages of maximum 10 records.

  • Filters: High-level filters for attributes values.

  • Column Controls: Individual dropdown searches per column.