Sample dataframes#

In this notebook we make sure that our test dataframes are displayed nicely with the default itables settings.

from itables import init_notebook_mode, show
from itables.sample_dfs import get_dict_of_test_dfs

dict_of_test_dfs = get_dict_of_test_dfs()
init_notebook_mode(all_interactive=True)
This is the init_notebook_mode cell from ITables v2.1.0
(you should not see this message - is your notebook trusted?)

empty#

show(dict_of_test_dfs["empty"])
Loading ITables v2.1.0 from the init_notebook_mode cell... (need help?)

No rows#

show(dict_of_test_dfs["no_rows"])
a
Loading ITables v2.1.0 from the init_notebook_mode cell... (need help?)

No rows one column#

show(dict_of_test_dfs["no_rows_one_column"])
a
Loading ITables v2.1.0 from the init_notebook_mode cell... (need help?)

No columns#

show(dict_of_test_dfs["no_columns"])
Loading ITables v2.1.0 from the init_notebook_mode cell... (need help?)

No columns one row#

show(dict_of_test_dfs["no_columns_one_row"])
Loading ITables v2.1.0 from the init_notebook_mode cell... (need help?)

bool#

show(dict_of_test_dfs["bool"])
a b c d
Loading ITables v2.1.0 from the init_notebook_mode cell... (need help?)

Nullable boolean#

show(dict_of_test_dfs["nullable_boolean"])
a b c d
Loading ITables v2.1.0 from the init_notebook_mode cell... (need help?)

int#

show(dict_of_test_dfs["int"])
a b c d e
Loading ITables v2.1.0 from the init_notebook_mode cell... (need help?)

Nullable integer#

show(dict_of_test_dfs["nullable_int"])
a b c
Loading ITables v2.1.0 from the init_notebook_mode cell... (need help?)

float#

show(dict_of_test_dfs["float"])
int inf nan math
Loading ITables v2.1.0 from the init_notebook_mode cell... (need help?)

str#

show(dict_of_test_dfs["str"])
text_column very_long_text_column
Loading ITables v2.1.0 from the init_notebook_mode cell... (need help?)

time#

show(dict_of_test_dfs["time"])
datetime timestamp timedelta
Loading ITables v2.1.0 from the init_notebook_mode cell... (need help?)

object#

show(dict_of_test_dfs["object"])
dict list
Loading ITables v2.1.0 from the init_notebook_mode cell... (need help?)

ordered_categories#

show(dict_of_test_dfs["ordered_categories"])
int
categorical_index
Loading ITables v2.1.0 from the init_notebook_mode cell... (need help?)

ordered_categories_in_multiindex#

show(dict_of_test_dfs["ordered_categories_in_multiindex"])
int
categorical_index integer_index
Loading ITables v2.1.0 from the init_notebook_mode cell... (need help?)

multiindex#

show(dict_of_test_dfs["multiindex"])
A B
1 2 1 2
Loading ITables v2.1.0 from the init_notebook_mode cell... (need help?)

countries#

show(dict_of_test_dfs["countries"])
region country capital longitude latitude flag
code
Loading ITables v2.1.0 from the init_notebook_mode cell... (need help?)

capital#

show(dict_of_test_dfs["capital"])
capital
region country
Loading ITables v2.1.0 from the init_notebook_mode cell... (need help?)

complex_index#

show(dict_of_test_dfs["complex_index"])
category code data localisation data
detail code capital longitude latitude flag
region country
Loading ITables v2.1.0 from the init_notebook_mode cell... (need help?)

int_float_str#

show(dict_of_test_dfs["int_float_str"])
int float str
Loading ITables v2.1.0 from the init_notebook_mode cell... (need help?)

wide#

show(dict_of_test_dfs["wide"], maxBytes=100000, maxColumns=100, scrollX=True)
column_0 column_1 column_2 column_3 column_4 column_5 column_6 column_7 column_8 column_9 column_10 column_11 column_12 column_13 column_14 column_15 column_16 column_17 column_18 column_19 column_20 column_21 column_22 column_23 column_24 column_25 column_26 column_27 column_28 column_29 column_30 column_31 column_32 column_33 column_34 column_35 column_36 column_37 column_38 column_39 column_40 column_41 column_42 column_43 column_44 column_45 column_46 column_47 column_48 column_49 column_50 column_51 column_52 column_53 column_54 column_55 column_56 column_57 column_58 column_59 column_60 column_61 column_62 column_63 column_64 column_65 column_66 column_67 column_68 column_69 column_70 column_71 column_72 column_73 column_74 column_75 column_76 column_77 column_78 column_79 column_80 column_81 column_82 column_83 column_84 column_85 column_86 column_87 column_88 column_89 column_90 column_91 column_92 column_93 column_94 column_95 column_96 column_97 column_98 column_99
Loading ITables v2.1.0 from the init_notebook_mode cell... (need help?)