{ "cells": [ { "cell_type": "markdown", "id": "3a4b0821", "metadata": {}, "source": [ "# Sample dataframes\n", "\n", "In this notebook we make sure that our test dataframes are displayed nicely with the default `itables` settings." ] }, { "cell_type": "code", "execution_count": 1, "id": "3cc78157", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" }, { "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
\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()\n", "init_notebook_mode(all_interactive=True)" ] }, { "cell_type": "markdown", "id": "dfb5d33c", "metadata": {}, "source": [ "## empty" ] }, { "cell_type": "code", "execution_count": 2, "id": "9d2c978b", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
\n", "\n", "
\n", "Loading ITables v2.0.1 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": "2f98e529", "metadata": {}, "source": [ "## No rows" ] }, { "cell_type": "code", "execution_count": 3, "id": "a6eda627", "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 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": "98b76c80", "metadata": {}, "source": [ "## No rows one column" ] }, { "cell_type": "code", "execution_count": 4, "id": "d98802c4", "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 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": "e9d390e4", "metadata": {}, "source": [ "## No columns" ] }, { "cell_type": "code", "execution_count": 5, "id": "afe9beed", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
\n", "\n", "
\n", "Loading ITables v2.0.1 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": "20c79f7d", "metadata": {}, "source": [ "## No columns one row" ] }, { "cell_type": "code", "execution_count": 6, "id": "f5b0610b", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
\n", "\n", "
\n", "Loading ITables v2.0.1 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": "d67f5746", "metadata": {}, "source": [ "## bool" ] }, { "cell_type": "code", "execution_count": 7, "id": "29078ff5", "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 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": "ffade201", "metadata": {}, "source": [ "## Nullable boolean" ] }, { "cell_type": "code", "execution_count": 8, "id": "38575532", "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 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": "2dfb9f43", "metadata": {}, "source": [ "## int" ] }, { "cell_type": "code", "execution_count": 9, "id": "3755319a", "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 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": "587fd2c1", "metadata": {}, "source": [ "## Nullable integer" ] }, { "cell_type": "code", "execution_count": 10, "id": "727055e8", "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 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": "edca5183", "metadata": {}, "source": [ "## float" ] }, { "cell_type": "code", "execution_count": 11, "id": "3a1b1342", "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 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": "789533ee", "metadata": {}, "source": [ "## str" ] }, { "cell_type": "code", "execution_count": 12, "id": "bc3517e0", "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 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": "108d88ba", "metadata": {}, "source": [ "## time" ] }, { "cell_type": "code", "execution_count": 13, "id": "c76ab287", "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 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": "95088206", "metadata": {}, "source": [ "## object" ] }, { "cell_type": "code", "execution_count": 14, "id": "db93d8c3", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
dictlist
\n", "\n", "
\n", "Loading ITables v2.0.1 from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"object\"])" ] }, { "cell_type": "markdown", "id": "263a1f15", "metadata": {}, "source": [ "## ordered_categories" ] }, { "cell_type": "code", "execution_count": 15, "id": "0b27ffae", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
int
categorical_index
\n", "\n", "
\n", "Loading ITables v2.0.1 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": "4f299c22", "metadata": {}, "source": [ "## ordered_categories_in_multiindex" ] }, { "cell_type": "code", "execution_count": 16, "id": "f66ed69b", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
int
categorical_indexinteger_index
\n", "\n", "
\n", "Loading ITables v2.0.1 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": "2f680a35", "metadata": {}, "source": [ "## multiindex" ] }, { "cell_type": "code", "execution_count": 17, "id": "db421450", "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", "
AB
1212
\n", "\n", "
\n", "Loading ITables v2.0.1 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": "adf8aea0", "metadata": {}, "source": [ "## countries" ] }, { "cell_type": "code", "execution_count": 18, "id": "89932ef0", "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", "
regioncountrycapitallongitudelatitudeflag
code
\n", "\n", "
\n", "Loading ITables v2.0.1 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": "6958abdf", "metadata": {}, "source": [ "## capital" ] }, { "cell_type": "code", "execution_count": 19, "id": "bcab1e43", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
capital
regioncountry
\n", "\n", "
\n", "Loading ITables v2.0.1 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": "8d9b0755", "metadata": {}, "source": [ "## complex_index" ] }, { "cell_type": "code", "execution_count": 20, "id": "c29e770f", "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", "
categorycodedatalocalisationdata
detailcodecapitallongitudelatitudeflag
regioncountry
\n", "\n", "
\n", "Loading ITables v2.0.1 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": "b1ac00f8", "metadata": {}, "source": [ "## int_float_str" ] }, { "cell_type": "code", "execution_count": 21, "id": "5d3313b6", "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 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": "ba395aea", "metadata": {}, "source": [ "## wide" ] }, { "cell_type": "code", "execution_count": 22, "id": "92d8a81b", "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 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": "2e6e9570", "metadata": {}, "source": [ "## long_column_names" ] }, { "cell_type": "code", "execution_count": 23, "id": "e57bb68c", "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 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": "a7a4dd27", "metadata": {}, "source": [ "## duplicated_columns" ] }, { "cell_type": "code", "execution_count": 24, "id": "f00f8f28", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
AA
AA
\n", "\n", "
\n", "Loading ITables v2.0.1 from the init_notebook_mode cell...\n", "(need help?)
\n", "\n" ], "text/plain": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "show(dict_of_test_dfs[\"duplicated_columns\"])" ] }, { "cell_type": "markdown", "id": "898b7ded", "metadata": {}, "source": [ "## named_column_index" ] }, { "cell_type": "code", "execution_count": 25, "id": "f92df3cd", "metadata": {}, "outputs": [ { "data": { "text/html": [ "\n", "\n", " \n", " \n", " \n", " \n", " \n", "\n", "\n", "\n", "\n", "
columnsa
\n", "\n", "
\n", "Loading ITables v2.0.1 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": "670a05b9", "metadata": {}, "source": [ "## big_integers" ] }, { "cell_type": "code", "execution_count": 26, "id": "46859d8f", "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 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, 19, 25, 29, 31, 35, 37, 41, 43, 47, 49, 53, 55, 59, 61, 65, 67, 71, 73, 77, 79, 83, 85, 89, 91, 95, 97, 101, 103, 107, 109, 113, 115, 119, 121, 125, 129, 133, 135, 139, 143, 147, 149, 153, 157, 161, 165, 169, 171, 175, 177, 181 ] }, "nbformat": 4, "nbformat_minor": 5 }