Interactive Tables in Jupyter
Pandas DataFrames and Series as interactive datatables!
Browse the documentation to see examples of Pandas datatables rendered as interactive datatables.
itables package with either
pip install itables
conda install itables -c conda-forge
Activate the interactive mode for all series and dataframes with
from itables import init_notebook_mode init_notebook_mode(all_interactive=True)
and then render any Pandas DataFrame as an interactive table that you can sort, search and explore:
If you prefer to render only selected DataFrames as interactive tables, use
itables.show to show just one Series or DataFrame as an interactive table:
itables==1.0.0, the jquery and datatables.net libraries and CSS
are injected in the notebook when you execute
init_notebook_mode with its default argument
Thanks to this the interactive tables will work even without a connection to the internet.
If you prefer to load the libraries dynamically (and keep the notebook lighter), use
connected=True when you
itables has been tested in the following editors:
- Jupyter Notebook
- Jupyter Lab
- Jupyter nbconvert (i.e. the tables are still interactive in the HTML export of a notebook)
- Jupyter Book
- Google Colab
- VS Code (for both Jupyter Notebooks and Python scripts)
- PyCharm (for Jupyter Notebooks)
Try ITables on Binder
Table not loading?
If the table just says "Loading...", then maybe
- You loaded a notebook that is not trusted (run "Trust Notebook" in View / Activate Command Palette)
- You forgot to run
init_notebook_mode, or you deleted that cell or its output
- Or you ran
init_notebook_mode(connected=True)but you are not connected to the internet?
Please note that if you change the value of the
connected argument in
init_notebook_mode cell, you will need to re-execute all the cells
that display interactive tables.
If the above does not help, please check out the ChangeLog
and decide whether you should upgrade
When the data in a table is larger than
maxBytes, which is equal to 64KB by default,
itables will display only a subset of the table - one that fits into
maxBytes. If you wish, you can deactivate the limit with
maxBytes=0, change the value of
maxBytes, or similarly set a limit on the number of rows (
maxRows, defaults to 0) or columns (
maxColumns, defaults to
Note that datatables support server-side processing. At a later stage we may implement support for larger tables using this feature.
from itables.sample_dfs import get_indicators from itables.downsample import nbytes import itables.options as opt opt.lengthMenu = [2, 5, 10, 20, 50, 100, 200, 500] opt.maxBytes = 10000 df = get_indicators() nbytes(df)
To show the table in full, we can modify the value of
maxBytes either locally:
opt.maxBytes = 2 ** 20 df
Release history Release notifications | RSS feed
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.