This packages changes how Pandas and Polars DataFrames are rendered in Jupyter Notebooks.
With itables
you can display your tables as interactive DataTables
that you can sort, paginate, scroll or filter.
ITables is just about how tables are displayed. You can turn it on and off in just two lines, with no other impact on your data workflow.
The itables
package only depends on numpy
, pandas
and IPython
which you must already have if you work with Pandas in Jupyter (add polars
, pyarrow
if you
work with Polars DataFrames).
Browse the documentation to see examples of Pandas or Polars DataFrames rendered as interactive DataTables.
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 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:
Since ITables v1.0, the jQuery and DataTables 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
.
ITables works in all the usual Jupyter Notebook environments, including Jupyter Notebook, Jupyter Lab, Jupyter nbconvert (i.e. the tables are still interactive in the HTML export of a notebook), Jupyter Book, Google Colab and Kaggle.
You can also use ITables in Quarto HTML documents, and in RISE presentations.
ITables works well in VS Code, both in Jupyter Notebooks and in interactive Python sessions.
Last but not least, ITables is also available as
- a Jupyter Widget
- a Streamlit component,
- and it also works in Shiny applications.