{ "cells": [ { "cell_type": "markdown", "id": "f94ef132", "metadata": {}, "source": [ "# Polars dataframes\n", "\n", "In this notebook we make sure that our test [Polars](https://www.pola.rs/)\n", "dataframes are displayed nicely with the default `itables` settings." ] }, { "cell_type": "code", "execution_count": 1, "id": "2012529e", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "
\n", "
\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", " \n", " \n", " \n", " \n", "\n", " \n", " \n", " \n", " \n", "\n", " \n", " \n", " \n", " \n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "
\n", "
\n", "This is the init_notebook_mode cell from ITables v2.0.1-dev
\n", "(you should not see this message - is your notebook trusted?)\n", "
\n", "
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "from itables import init_notebook_mode, show\n", "from itables.sample_dfs import get_dict_of_test_dfs\n", "\n", "dict_of_test_dfs = get_dict_of_test_dfs(polars=True)\n", "init_notebook_mode(all_interactive=True)" ] }, { "cell_type": "markdown", "id": "ac31c8f6", "metadata": {}, "source": [ "## empty" ] }, { "cell_type": "code", "execution_count": 2, "id": "3eb1d917", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"empty\"])" ] }, { "cell_type": "markdown", "id": "ca771a53", "metadata": {}, "source": [ "## No rows" ] }, { "cell_type": "code", "execution_count": 3, "id": "4cbd5a2b", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
a
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"no_rows\"])" ] }, { "cell_type": "markdown", "id": "b15fa24c", "metadata": {}, "source": [ "## No rows one column" ] }, { "cell_type": "code", "execution_count": 4, "id": "5c1c25bc", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
a
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"no_rows_one_column\"])" ] }, { "cell_type": "markdown", "id": "76fb701e", "metadata": {}, "source": [ "## No columns" ] }, { "cell_type": "code", "execution_count": 5, "id": "dc65b68a", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"no_columns\"])" ] }, { "cell_type": "markdown", "id": "4b1e1561", "metadata": {}, "source": [ "## No columns one row" ] }, { "cell_type": "code", "execution_count": 6, "id": "3d30f550", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"no_columns_one_row\"])" ] }, { "cell_type": "markdown", "id": "e49411b1", "metadata": {}, "source": [ "## bool" ] }, { "cell_type": "code", "execution_count": 7, "id": "4fb5a0e7", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
abcd
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"bool\"])" ] }, { "cell_type": "markdown", "id": "12d746c7", "metadata": {}, "source": [ "## Nullable boolean" ] }, { "cell_type": "code", "execution_count": 8, "id": "55eda9cb", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
abcd
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"nullable_boolean\"])" ] }, { "cell_type": "markdown", "id": "f7da0c32", "metadata": {}, "source": [ "## int" ] }, { "cell_type": "code", "execution_count": 9, "id": "a7fbdb20", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
abcde
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"int\"])" ] }, { "cell_type": "markdown", "id": "226d8ee2", "metadata": {}, "source": [ "## Nullable integer" ] }, { "cell_type": "code", "execution_count": 10, "id": "ce61d555", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
abc
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"nullable_int\"])" ] }, { "cell_type": "markdown", "id": "341cfd86", "metadata": {}, "source": [ "## float" ] }, { "cell_type": "code", "execution_count": 11, "id": "410847fd", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
intinfnanmath
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"float\"])" ] }, { "cell_type": "markdown", "id": "dff8f98b", "metadata": {}, "source": [ "## str" ] }, { "cell_type": "code", "execution_count": 12, "id": "7a5821f6", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
text_columnvery_long_text_column
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"str\"])" ] }, { "cell_type": "markdown", "id": "3836bb83", "metadata": {}, "source": [ "## time" ] }, { "cell_type": "code", "execution_count": 13, "id": "26b5689f", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
datetimetimestamptimedelta
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"time\"])" ] }, { "cell_type": "markdown", "id": "a8c32188", "metadata": {}, "source": [ "## ordered_categories" ] }, { "cell_type": "code", "execution_count": 14, "id": "1251841d", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
int
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"ordered_categories\"])" ] }, { "cell_type": "markdown", "id": "caf84310", "metadata": {}, "source": [ "## ordered_categories_in_multiindex" ] }, { "cell_type": "code", "execution_count": 15, "id": "def3fd22", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
int
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"ordered_categories_in_multiindex\"])" ] }, { "cell_type": "markdown", "id": "ed090ecb", "metadata": {}, "source": [ "## multiindex" ] }, { "cell_type": "code", "execution_count": 16, "id": "d40494ee", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
('A', 1)('A', 2)('B', 1)('B', 2)
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"multiindex\"])" ] }, { "cell_type": "markdown", "id": "a16bf270", "metadata": {}, "source": [ "## countries" ] }, { "cell_type": "code", "execution_count": 17, "id": "a3250c57", "metadata": { "tags": [ "full-width" ] }, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
regioncountrycapitallongitudelatitudeflag
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"countries\"])" ] }, { "cell_type": "markdown", "id": "9ec3aa1e", "metadata": {}, "source": [ "## capital" ] }, { "cell_type": "code", "execution_count": 18, "id": "be756ed4", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
capital
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"capital\"])" ] }, { "cell_type": "markdown", "id": "682a42f4", "metadata": {}, "source": [ "## complex_index" ] }, { "cell_type": "code", "execution_count": 19, "id": "1dbae88f", "metadata": { "tags": [ "full-width" ] }, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
('code', 'code')('data', 'capital')('localisation', 'longitude')('localisation', 'latitude')('data', 'flag')
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"complex_index\"])" ] }, { "cell_type": "markdown", "id": "011fe267", "metadata": {}, "source": [ "## int_float_str" ] }, { "cell_type": "code", "execution_count": 20, "id": "75352a91", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
intfloatstr
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"int_float_str\"])" ] }, { "cell_type": "markdown", "id": "655f3734", "metadata": {}, "source": [ "## wide" ] }, { "cell_type": "code", "execution_count": 21, "id": "67dc30b2", "metadata": { "tags": [ "full-width" ] }, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
column_0column_1column_2column_3column_4column_5column_6column_7column_8column_9column_10column_11column_12column_13column_14column_15column_16column_17column_18column_19column_20column_21column_22column_23column_24column_25column_26column_27column_28column_29column_30column_31column_32column_33column_34column_35column_36column_37column_38column_39column_40column_41column_42column_43column_44column_45column_46column_47column_48column_49column_50column_51column_52column_53column_54column_55column_56column_57column_58column_59column_60column_61column_62column_63column_64column_65column_66column_67column_68column_69column_70column_71column_72column_73column_74column_75column_76column_77column_78column_79column_80column_81column_82column_83column_84column_85column_86column_87column_88column_89column_90column_91column_92column_93column_94column_95column_96column_97column_98column_99
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"wide\"], maxBytes=100000, maxColumns=100, scrollX=True)" ] }, { "cell_type": "markdown", "id": "c118e942", "metadata": {}, "source": [ "## long_column_names" ] }, { "cell_type": "code", "execution_count": 22, "id": "96255800", "metadata": { "tags": [ "full-width" ] }, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
short namevery very very very very long namevery very very very very very very very very very long namevery very very very very very very very very very very very very very very very very very very very long namenospaceinveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryverylongnamenospaceinveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryverylongname
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"long_column_names\"], scrollX=True)" ] }, { "cell_type": "markdown", "id": "04ec1b4e", "metadata": {}, "source": [ "## named_column_index" ] }, { "cell_type": "code", "execution_count": 23, "id": "25a65160", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
a
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"named_column_index\"])" ] }, { "cell_type": "markdown", "id": "7ecdb292", "metadata": {}, "source": [ "## big_integers" ] }, { "cell_type": "code", "execution_count": 24, "id": "5dbf68c9", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
bigintexpected
\n", "\n", "
\n", "Loading ITables v2.0.1-dev from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"big_integers\"])" ] } ], "metadata": { "jupytext": { "formats": "md:myst", "text_representation": { "extension": ".md", "format_name": "myst", "format_version": 0.13, "jupytext_version": "1.14.5" } }, "kernelspec": { "display_name": "itables", "language": "python", "name": "itables" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.11.9" }, "source_map": [ 13, 20, 26, 30, 32, 36, 38, 42, 44, 48, 50, 54, 56, 60, 62, 66, 68, 72, 74, 78, 80, 84, 86, 90, 92, 96, 98, 102, 104, 108, 110, 114, 116, 120, 124, 128, 130, 134, 138, 142, 144, 148, 152, 156, 160, 164, 166, 170 ] }, "nbformat": 4, "nbformat_minor": 5 }