Static preview - Pandas dataframes#

itables.to_html_static_preview() returns the plain HTML table that to_html_datatable() shows by default, ahead of the interactive table - see Static preview for why, and when, this is shown instead. This page shows it for each of our test Pandas dataframes; see Pandas dataframes for the same dataframes rendered as interactive tables.

from IPython.display import HTML, display

import itables

dict_of_test_dfs = itables.sample_pandas_dfs.get_dict_of_test_dfs()

empty#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["empty"])))

No rows#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["no_rows"])))
a

No columns#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["no_columns"])))
a

No rows one column#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["no_rows_one_column"])))
a

No columns one row#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["no_columns_one_row"])))
a

bool#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["bool"])))
a b c d
TrueTrueFalseFalse
TrueFalseTrueFalse

Nullable boolean#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["nullable_boolean"])))
a b c d
TrueTrueFalse
TrueFalseFalse
FalseTrueFalse

int#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["int"])))
a b c d e
-12-34-5
6-78-910

Nullable integer#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["nullable_int"])))
a b c
-12-3
4-56
7

float#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["float"])))
int inf nan math unsorted
0.0infNaN3.141593100.000000
1.0-infNaN2.718282NaN
2.0infNaN3.141593NaN
3.0-infNaN2.71828220.000000
4.0infNaN3.1415933.141593
5.0-infNaN2.7182822.718282
6.0infNaN3.1415930.000000
7.0-infNaN2.718282-0.000000
8.0infNaN3.141593inf
9.0-infNaN2.718282-inf

float_types#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["float_types"])))
float32 float64
1.0000001.000000
0.0000000.000000
3.1415933.141593
NaNNaN
infinf
-inf-inf

str#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["str"])))
text_column very_long_text_column
somea very very very very very very very very very very very very long text
texta very very very very very very very very very very very very long text

time#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["time"])))
datetime timestamp timedelta
2000-01-01NaT2 days 00:00:00
2001-01-012000-01-01 18:55:330 days 00:00:50
NaT2001-01-01 18:55:55.456654-04:56NaT

date_range#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["date_range"])))
timestamps
2026-07-19 22:58:13.616768
2026-07-19 22:58:14.616768
2026-07-19 22:58:15.616768
2026-07-19 22:58:16.616768
2026-07-19 22:58:17.616768

ordered_categories#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["ordered_categories"])))
int
categorical_index
first0
second1
third2
fourth3

ordered_categories_in_multiindex#

display(
    HTML(
        itables.to_html_static_preview(
            dict_of_test_dfs["ordered_categories_in_multiindex"]
        )
    )
)
int
categorical_index integer_index
first00
second11
third22
fourth33

object#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["object"])))
dict list
{'a': 1}[a]
{'b': 2, 'c': 3}[1, 2]

multiindex#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["multiindex"])))
A B
1 2 1 2
C30123
C44567
D3891011
D412131415

countries#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["countries"])))
region country capital longitude latitude
code
AWLatin America & Caribbean ArubaOranjestad-70.01670012.516700
AFSouth AsiaAfghanistanKabul69.17610034.522800
AOSub-Saharan Africa AngolaLuanda13.242000-8.811550
ALEurope & Central AsiaAlbaniaTirane19.81720041.331700
ADEurope & Central AsiaAndorraAndorra la Vella1.52180042.507500
AEMiddle East & North AfricaUnited Arab EmiratesAbu Dhabi54.37050024.476400
ARLatin America & Caribbean ArgentinaBuenos Aires-58.417300-34.611800
AMEurope & Central AsiaArmeniaYerevan44.50900040.159600
ASEast Asia & PacificAmerican SamoaPago Pago-170.691000-14.284600
AGLatin America & Caribbean Antigua and BarbudaSaint John's-61.84560017.117500
(198 more rows not shown)

capital#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["capital"])))
capital
region country
Latin America & Caribbean ArubaOranjestad
South AsiaAfghanistanKabul
Sub-Saharan Africa AngolaLuanda
Europe & Central AsiaAlbaniaTirane
Europe & Central AsiaAndorraAndorra la Vella
Middle East & North AfricaUnited Arab EmiratesAbu Dhabi
Latin America & Caribbean ArgentinaBuenos Aires
Europe & Central AsiaArmeniaYerevan
East Asia & PacificAmerican SamoaPago Pago
Latin America & Caribbean Antigua and BarbudaSaint John's
(198 more rows not shown)

complex_index#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["complex_index"])))
category code data localisation
detail code capital longitude latitude
region country
Latin America & Caribbean ArubaAWOranjestad-70.01670012.516700
South AsiaAfghanistanAFKabul69.17610034.522800
Sub-Saharan Africa AngolaAOLuanda13.242000-8.811550
Europe & Central AsiaAlbaniaALTirane19.81720041.331700
Europe & Central AsiaAndorraADAndorra la Vella1.52180042.507500
Middle East & North AfricaUnited Arab EmiratesAEAbu Dhabi54.37050024.476400
Latin America & Caribbean ArgentinaARBuenos Aires-58.417300-34.611800
Europe & Central AsiaArmeniaAMYerevan44.50900040.159600
East Asia & PacificAmerican SamoaASPago Pago-170.691000-14.284600
Latin America & Caribbean Antigua and BarbudaAGSaint John's-61.84560017.117500
(198 more rows not shown)

int_float_str#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["int_float_str"])))
int float str
05.000000a
14.949495b
24.898990c
34.848485d
44.797980e
54.747475f
64.696970g
74.646465h
84.595960i
94.545455j
(90 more rows not shown)

wide#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["wide"])))
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_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
row_00.0000000.0001000.0002000.0003000.0004000.0005000.0006000.0007000.0008000.0009000.0010000.0011000.0012000.0013000.0014000.0015000.0016000.0017000.0018000.0019000.0020000.0021000.0022000.0023000.0024000.0025000.0026000.0027000.0028000.0029000.0030000.0031000.0032000.0033000.0034000.0035000.0036000.0037000.0038000.0039000.0040000.0041000.0042000.0043000.0044000.0055010.0056010.0057010.0058010.0059010.0060010.0061010.0062010.0063010.0064010.0065010.0066010.0067010.0068010.0069010.0070010.0071010.0072010.0073010.0074010.0075010.0076010.0077010.0078010.0079010.0080010.0081010.0082010.0083010.0084010.0085010.0086010.0087010.0088010.0089010.0090010.0091010.0092010.0093010.0094010.0095010.0096010.0097010.0098010.009901
row_10.0100010.0101010.0102010.0103010.0104010.0105010.0106010.0107010.0108010.0109010.0110010.0111010.0112010.0113010.0114010.0115010.0116010.0117010.0118010.0119010.0120010.0121010.0122010.0123010.0124010.0125010.0126010.0127010.0128010.0129010.0130010.0131010.0132010.0133010.0134010.0135010.0136010.0137010.0138010.0139010.0140010.0141010.0142010.0143010.0144010.0155020.0156020.0157020.0158020.0159020.0160020.0161020.0162020.0163020.0164020.0165020.0166020.0167020.0168020.0169020.0170020.0171020.0172020.0173020.0174020.0175020.0176020.0177020.0178020.0179020.0180020.0181020.0182020.0183020.0184020.0185020.0186020.0187020.0188020.0189020.0190020.0191020.0192020.0193020.0194020.0195020.0196020.0197020.0198020.019902
row_20.0200020.0201020.0202020.0203020.0204020.0205020.0206020.0207020.0208020.0209020.0210020.0211020.0212020.0213020.0214020.0215020.0216020.0217020.0218020.0219020.0220020.0221020.0222020.0223020.0224020.0225020.0226020.0227020.0228020.0229020.0230020.0231020.0232020.0233020.0234020.0235020.0236020.0237020.0238020.0239020.0240020.0241020.0242020.0243020.0244020.0255030.0256030.0257030.0258030.0259030.0260030.0261030.0262030.0263030.0264030.0265030.0266030.0267030.0268030.0269030.0270030.0271030.0272030.0273030.0274030.0275030.0276030.0277030.0278030.0279030.0280030.0281030.0282030.0283030.0284030.0285030.0286030.0287030.0288030.0289030.0290030.0291030.0292030.0293030.0294030.0295030.0296030.0297030.0298030.029903
row_30.0300030.0301030.0302030.0303030.0304030.0305030.0306030.0307030.0308030.0309030.0310030.0311030.0312030.0313030.0314030.0315030.0316030.0317030.0318030.0319030.0320030.0321030.0322030.0323030.0324030.0325030.0326030.0327030.0328030.0329030.0330030.0331030.0332030.0333030.0334030.0335030.0336030.0337030.0338030.0339030.0340030.0341030.0342030.0343030.0344030.0355040.0356040.0357040.0358040.0359040.0360040.0361040.0362040.0363040.0364040.0365040.0366040.0367040.0368040.0369040.0370040.0371040.0372040.0373040.0374040.0375040.0376040.0377040.0378040.0379040.0380040.0381040.0382040.0383040.0384040.0385040.0386040.0387040.0388040.0389040.0390040.0391040.0392040.0393040.0394040.0395040.0396040.0397040.0398040.039904
row_40.0400040.0401040.0402040.0403040.0404040.0405040.0406040.0407040.0408040.0409040.0410040.0411040.0412040.0413040.0414040.0415040.0416040.0417040.0418040.0419040.0420040.0421040.0422040.0423040.0424040.0425040.0426040.0427040.0428040.0429040.0430040.0431040.0432040.0433040.0434040.0435040.0436040.0437040.0438040.0439040.0440040.0441040.0442040.0443040.0444040.0455050.0456050.0457050.0458050.0459050.0460050.0461050.0462050.0463050.0464050.0465050.0466050.0467050.0468050.0469050.0470050.0471050.0472050.0473050.0474050.0475050.0476050.0477050.0478050.0479050.0480050.0481050.0482050.0483050.0484050.0485050.0486050.0487050.0488050.0489050.0490050.0491050.0492050.0493050.0494050.0495050.0496050.0497050.0498050.049905
row_50.0500050.0501050.0502050.0503050.0504050.0505050.0506050.0507050.0508050.0509050.0510050.0511050.0512050.0513050.0514050.0515050.0516050.0517050.0518050.0519050.0520050.0521050.0522050.0523050.0524050.0525050.0526050.0527050.0528050.0529050.0530050.0531050.0532050.0533050.0534050.0535050.0536050.0537050.0538050.0539050.0540050.0541050.0542050.0543050.0544050.0555060.0556060.0557060.0558060.0559060.0560060.0561060.0562060.0563060.0564060.0565060.0566060.0567060.0568060.0569060.0570060.0571060.0572060.0573060.0574060.0575060.0576060.0577060.0578060.0579060.0580060.0581060.0582060.0583060.0584060.0585060.0586060.0587060.0588060.0589060.0590060.0591060.0592060.0593060.0594060.0595060.0596060.0597060.0598060.059906
row_60.0600060.0601060.0602060.0603060.0604060.0605060.0606060.0607060.0608060.0609060.0610060.0611060.0612060.0613060.0614060.0615060.0616060.0617060.0618060.0619060.0620060.0621060.0622060.0623060.0624060.0625060.0626060.0627060.0628060.0629060.0630060.0631060.0632060.0633060.0634060.0635060.0636060.0637060.0638060.0639060.0640060.0641060.0642060.0643060.0644060.0655070.0656070.0657070.0658070.0659070.0660070.0661070.0662070.0663070.0664070.0665070.0666070.0667070.0668070.0669070.0670070.0671070.0672070.0673070.0674070.0675070.0676070.0677070.0678070.0679070.0680070.0681070.0682070.0683070.0684070.0685070.0686070.0687070.0688070.0689070.0690070.0691070.0692070.0693070.0694070.0695070.0696070.0697070.0698070.069907
row_70.0700070.0701070.0702070.0703070.0704070.0705070.0706070.0707070.0708070.0709070.0710070.0711070.0712070.0713070.0714070.0715070.0716070.0717070.0718070.0719070.0720070.0721070.0722070.0723070.0724070.0725070.0726070.0727070.0728070.0729070.0730070.0731070.0732070.0733070.0734070.0735070.0736070.0737070.0738070.0739070.0740070.0741070.0742070.0743070.0744070.0755080.0756080.0757080.0758080.0759080.0760080.0761080.0762080.0763080.0764080.0765080.0766080.0767080.0768080.0769080.0770080.0771080.0772080.0773080.0774080.0775080.0776080.0777080.0778080.0779080.0780080.0781080.0782080.0783080.0784080.0785080.0786080.0787080.0788080.0789080.0790080.0791080.0792080.0793080.0794080.0795080.0796080.0797080.0798080.079908
row_80.0800080.0801080.0802080.0803080.0804080.0805080.0806080.0807080.0808080.0809080.0810080.0811080.0812080.0813080.0814080.0815080.0816080.0817080.0818080.0819080.0820080.0821080.0822080.0823080.0824080.0825080.0826080.0827080.0828080.0829080.0830080.0831080.0832080.0833080.0834080.0835080.0836080.0837080.0838080.0839080.0840080.0841080.0842080.0843080.0844080.0855090.0856090.0857090.0858090.0859090.0860090.0861090.0862090.0863090.0864090.0865090.0866090.0867090.0868090.0869090.0870090.0871090.0872090.0873090.0874090.0875090.0876090.0877090.0878090.0879090.0880090.0881090.0882090.0883090.0884090.0885090.0886090.0887090.0888090.0889090.0890090.0891090.0892090.0893090.0894090.0895090.0896090.0897090.0898090.089909
row_90.0900090.0901090.0902090.0903090.0904090.0905090.0906090.0907090.0908090.0909090.0910090.0911090.0912090.0913090.0914090.0915090.0916090.0917090.0918090.0919090.0920090.0921090.0922090.0923090.0924090.0925090.0926090.0927090.0928090.0929090.0930090.0931090.0932090.0933090.0934090.0935090.0936090.0937090.0938090.0939090.0940090.0941090.0942090.0943090.0944090.0955100.0956100.0957100.0958100.0959100.0960100.0961100.0962100.0963100.0964100.0965100.0966100.0967100.0968100.0969100.0970100.0971100.0972100.0973100.0974100.0975100.0976100.0977100.0978100.0979100.0980100.0981100.0982100.0983100.0984100.0985100.0986100.0987100.0988100.0989100.0990100.0991100.0992100.0993100.0994100.0995100.0996100.0997100.0998100.099910
(90 more rows and 10 more columns not shown)

long_column_names#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["long_column_names"])))
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
001233
001233
001233
001233
001233

sorted_index#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["sorted_index"])))
x y
i
00.00.0
11.00.1
22.00.2

reverse_sorted_index#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["reverse_sorted_index"])))
x y
i
20.00.0
11.00.1
02.00.2

sorted_multiindex#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["sorted_multiindex"])))
x y
i j
030.00.0
141.00.1
252.00.2

unsorted_index#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["unsorted_index"])))
x y
i
00.00.0
21.00.1
12.00.2

duplicated_columns#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["duplicated_columns"])))
A A
A A
0245
1367

named_column_index#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["named_column_index"])))
columns a
1

big_integers#

display(HTML(itables.to_html_static_preview(dict_of_test_dfs["big_integers"])))
bigint expected
-1234567890123456789-1234567890123456789
12345678901234567891234567890123456789
23456789012345678902345678901234567890
34567890123456789013456789012345678901