Skip to main content

Interactive Tables in Jupyter

Project description

Interactive Tables

Pypi Conda Version CI codecov.io Language grade: Python Code style: black

Pandas DataFrames and Series as interactive datatables!

Documentation

Browse the documentation to see examples of Pandas datatables rendered as interactive datatables.

Quick start

Install the itables package with either

pip install itables

or

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: df

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: show

Since 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 connected=False. 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 execute init_notebook_mode.

Supported environments

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

You can run our examples notebooks directly on Lab, without having to install anything on your side.

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 the 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 itables.

Downsampling

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 pd.get_option('display.max_columns')).

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
import itables.options as opt

opt.lengthMenu = [2, 5, 10, 20, 50, 100, 200, 500]
opt.maxBytes = 10000

df = get_indicators()
df.values.nbytes
df

To show the table in full, we can modify the value of maxBytes either locally:

show(df, maxBytes=0)

or globally:

opt.maxBytes = 2 ** 20
df

Project details


Release history Release notifications | RSS feed

This version

1.3.3

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

itables-1.3.3.tar.gz (191.3 kB view details)

Uploaded Source

Built Distribution

itables-1.3.3-py3-none-any.whl (193.9 kB view details)

Uploaded Python 3

File details

Details for the file itables-1.3.3.tar.gz.

File metadata

  • Download URL: itables-1.3.3.tar.gz
  • Upload date:
  • Size: 191.3 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.1 CPython/3.7.15

File hashes

Hashes for itables-1.3.3.tar.gz
Algorithm Hash digest
SHA256 a657635c6ca3888e7b9e14bf27687d191d844c347e3608f995278199ca3e8237
MD5 8fcb5f2633024b0eaace1f99b7655bee
BLAKE2b-256 31358c4c7a510f177f0da409f79a8cb9c106a37a29a2ba3cdb1f1efbc72eac60

See more details on using hashes here.

File details

Details for the file itables-1.3.3-py3-none-any.whl.

File metadata

  • Download URL: itables-1.3.3-py3-none-any.whl
  • Upload date:
  • Size: 193.9 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.1 CPython/3.7.15

File hashes

Hashes for itables-1.3.3-py3-none-any.whl
Algorithm Hash digest
SHA256 8ddc032bb38d30b190987b004a9d7da0ed5c1bf35b4e3f93b916c211acf38063
MD5 139121693bd510ce7e473b1537089257
BLAKE2b-256 bf519172e9bf582e7ae9d0fd7aa861f47f79ab061c9328f244da4dd2663cb22a

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page