Sample dataframes

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)

empty#

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

No rows#

show(dict_of_test_dfs["no_rows"])
a
Loading ITables v2.2.4 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.2.4 from the init_notebook_mode cell... (need help?)

No columns#

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

No columns one row#

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

bool#

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

Nullable boolean#

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

int#

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

Nullable integer#

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

float#

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

str#

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

time#

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

object#

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

ordered_categories#

show(dict_of_test_dfs["ordered_categories"])
int
categorical_index
Loading ITables v2.2.4 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.2.4 from the init_notebook_mode cell... (need help?)

multiindex#

show(dict_of_test_dfs["multiindex"])
A B
1 2 1 2
Loading ITables v2.2.4 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.2.4 from the init_notebook_mode cell... (need help?)

capital#

show(dict_of_test_dfs["capital"])
capital
region country
Loading ITables v2.2.4 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.2.4 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.2.4 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.2.4 from the init_notebook_mode cell... (need help?)

long_column_names#

show(dict_of_test_dfs["long_column_names"], scrollX=True)
short name very very very very very long name very very very very very very very very very very long name very very very very very very very very very very very very very very very very very very very very long name nospaceinveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryverylongname nospaceinveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryveryverylongname
Loading ITables v2.2.4 from the init_notebook_mode cell... (need help?)

duplicated_columns#

show(dict_of_test_dfs["duplicated_columns"])
A A
A A
Loading ITables v2.2.4 from the init_notebook_mode cell... (need help?)

named_column_index#

show(dict_of_test_dfs["named_column_index"])
columns a
Loading ITables v2.2.4 from the init_notebook_mode cell... (need help?)

big_integers#

show(dict_of_test_dfs["big_integers"])
bigint expected
Loading ITables v2.2.4 from the init_notebook_mode cell... (need help?)