.. DO NOT EDIT. .. THIS FILE WAS AUTOMATICALLY GENERATED BY SPHINX-GALLERY. .. TO MAKE CHANGES, EDIT THE SOURCE PYTHON FILE: .. "_examples/tableone/plot_main01.py" .. LINE NUMBERS ARE GIVEN BELOW. .. only:: html .. note:: :class: sphx-glr-download-link-note Click :ref:`here ` to download the full example code .. rst-class:: sphx-glr-example-title .. _sphx_glr__examples_tableone_plot_main01.py: 01. Basic example ----------------- Basic usage of the tableone library. .. GENERATED FROM PYTHON SOURCE LINES 8-37 .. code-block:: default :lineno-start: 8 # Libraries import pandas as pd from tableone import TableOne # Load data url="https://raw.githubusercontent.com/tompollard/data/master/primary-biliary-cirrhosis/pbc.csv" data=pd.read_csv(url) # List of columns columns = [ 'age', 'bili', 'albumin', 'ast', 'platelet', 'protime', 'ascites', 'hepato', 'spiders', 'edema', 'sex', 'trt' ] # Specify categorical columns categorical = ['ascites','hepato','edema','sex','spiders','trt'] # Define groupby and not normal groupby = 'trt' nonnormal = ['bili'] # Create descriptive table mytable = TableOne(data, columns, categorical, groupby, nonnormal, pval=True) .. GENERATED FROM PYTHON SOURCE LINES 38-40 .. code-block:: default :lineno-start: 38 mytable.tableone .. raw:: html
Grouped by trt
Missing Overall 1.0 2.0 P-Value
n 418 158 154
age, mean (SD) 0 50.7 (10.4) 51.4 (11.0) 48.6 (10.0) 0.018
bili, median [Q1,Q3] 0 1.4 [0.8,3.4] 1.4 [0.8,3.2] 1.3 [0.7,3.6] 0.842
albumin, mean (SD) 0 3.5 (0.4) 3.5 (0.4) 3.5 (0.4) 0.874
ast, mean (SD) 106 122.6 (56.7) 120.2 (54.5) 125.0 (58.9) 0.460
platelet, mean (SD) 11 257.0 (98.3) 258.8 (100.3) 265.2 (90.7) 0.554
protime, mean (SD) 2 10.7 (1.0) 10.7 (0.9) 10.8 (1.1) 0.199
ascites, n (%) 0.0 106 288 (92.3) 144 (91.1) 144 (93.5) 0.567
1.0 24 (7.7) 14 (8.9) 10 (6.5)
hepato, n (%) 0.0 106 152 (48.7) 85 (53.8) 67 (43.5) 0.088
1.0 160 (51.3) 73 (46.2) 87 (56.5)
spiders, n (%) 0.0 106 222 (71.2) 113 (71.5) 109 (70.8) 0.985
1.0 90 (28.8) 45 (28.5) 45 (29.2)
edema, n (%) 0.0 0 354 (84.7) 132 (83.5) 131 (85.1) 0.877
0.5 44 (10.5) 16 (10.1) 13 (8.4)
1.0 20 (4.8) 10 (6.3) 10 (6.5)
sex, n (%) f 0 374 (89.5) 137 (86.7) 139 (90.3) 0.421
m 44 (10.5) 21 (13.3) 15 (9.7)
trt, n (%) 1.0 106 158 (50.6) 158 (100.0) <0.001
2.0 154 (49.4) 154 (100.0)


.. GENERATED FROM PYTHON SOURCE LINES 41-42 Convert to html .. GENERATED FROM PYTHON SOURCE LINES 42-45 .. code-block:: default :lineno-start: 42 html = mytable.to_html() html .. rst-class:: sphx-glr-script-out Out: .. code-block:: none '\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
Grouped by trt
MissingOverall1.02.0P-Value
n418158154
age, mean (SD)050.7 (10.4)51.4 (11.0)48.6 (10.0)0.018
bili, median [Q1,Q3]01.4 [0.8,3.4]1.4 [0.8,3.2]1.3 [0.7,3.6]0.842
albumin, mean (SD)03.5 (0.4)3.5 (0.4)3.5 (0.4)0.874
ast, mean (SD)106122.6 (56.7)120.2 (54.5)125.0 (58.9)0.460
platelet, mean (SD)11257.0 (98.3)258.8 (100.3)265.2 (90.7)0.554
protime, mean (SD)210.7 (1.0)10.7 (0.9)10.8 (1.1)0.199
ascites, n (%)0.0106288 (92.3)144 (91.1)144 (93.5)0.567
1.024 (7.7)14 (8.9)10 (6.5)
hepato, n (%)0.0106152 (48.7)85 (53.8)67 (43.5)0.088
1.0160 (51.3)73 (46.2)87 (56.5)
spiders, n (%)0.0106222 (71.2)113 (71.5)109 (70.8)0.985
1.090 (28.8)45 (28.5)45 (29.2)
edema, n (%)0.00354 (84.7)132 (83.5)131 (85.1)0.877
0.544 (10.5)16 (10.1)13 (8.4)
1.020 (4.8)10 (6.3)10 (6.5)
sex, n (%)f0374 (89.5)137 (86.7)139 (90.3)0.421
m44 (10.5)21 (13.3)15 (9.7)
trt, n (%)1.0106158 (50.6)158 (100.0)<0.001
2.0154 (49.4)154 (100.0)
' .. GENERATED FROM PYTHON SOURCE LINES 46-47 Lets tabulate for github. .. GENERATED FROM PYTHON SOURCE LINES 47-49 .. code-block:: default :lineno-start: 47 print(mytable.tabulate(tablefmt="github")) .. rst-class:: sphx-glr-script-out Out: .. code-block:: none | | | Missing | Overall | 1.0 | 2.0 | P-Value | |----------------------|-----|-----------|---------------|---------------|---------------|-----------| | n | | | 418 | 158 | 154 | | | age, mean (SD) | | 0 | 50.7 (10.4) | 51.4 (11.0) | 48.6 (10.0) | 0.018 | | bili, median [Q1,Q3] | | 0 | 1.4 [0.8,3.4] | 1.4 [0.8,3.2] | 1.3 [0.7,3.6] | 0.842 | | albumin, mean (SD) | | 0 | 3.5 (0.4) | 3.5 (0.4) | 3.5 (0.4) | 0.874 | | ast, mean (SD) | | 106 | 122.6 (56.7) | 120.2 (54.5) | 125.0 (58.9) | 0.460 | | platelet, mean (SD) | | 11 | 257.0 (98.3) | 258.8 (100.3) | 265.2 (90.7) | 0.554 | | protime, mean (SD) | | 2 | 10.7 (1.0) | 10.7 (0.9) | 10.8 (1.1) | 0.199 | | ascites, n (%) | 0.0 | 106 | 288 (92.3) | 144 (91.1) | 144 (93.5) | 0.567 | | | 1.0 | | 24 (7.7) | 14 (8.9) | 10 (6.5) | | | hepato, n (%) | 0.0 | 106 | 152 (48.7) | 85 (53.8) | 67 (43.5) | 0.088 | | | 1.0 | | 160 (51.3) | 73 (46.2) | 87 (56.5) | | | spiders, n (%) | 0.0 | 106 | 222 (71.2) | 113 (71.5) | 109 (70.8) | 0.985 | | | 1.0 | | 90 (28.8) | 45 (28.5) | 45 (29.2) | | | edema, n (%) | 0.0 | 0 | 354 (84.7) | 132 (83.5) | 131 (85.1) | 0.877 | | | 0.5 | | 44 (10.5) | 16 (10.1) | 13 (8.4) | | | | 1.0 | | 20 (4.8) | 10 (6.3) | 10 (6.5) | | | sex, n (%) | f | 0 | 374 (89.5) | 137 (86.7) | 139 (90.3) | 0.421 | | | m | | 44 (10.5) | 21 (13.3) | 15 (9.7) | | | trt, n (%) | 1.0 | 106 | 158 (50.6) | 158 (100.0) | | <0.001 | | | 2.0 | | 154 (49.4) | | 154 (100.0) | | .. GENERATED FROM PYTHON SOURCE LINES 50-51 Lets tabulate for latex. .. GENERATED FROM PYTHON SOURCE LINES 51-53 .. code-block:: default :lineno-start: 51 print(mytable.tabulate(tablefmt="latex")) .. rst-class:: sphx-glr-script-out Out: .. code-block:: none \begin{tabular}{lllllll} \hline & & Missing & Overall & 1.0 & 2.0 & P-Value \\ \hline n & & & 418 & 158 & 154 & \\ age, mean (SD) & & 0 & 50.7 (10.4) & 51.4 (11.0) & 48.6 (10.0) & 0.018 \\ bili, median [Q1,Q3] & & 0 & 1.4 [0.8,3.4] & 1.4 [0.8,3.2] & 1.3 [0.7,3.6] & 0.842 \\ albumin, mean (SD) & & 0 & 3.5 (0.4) & 3.5 (0.4) & 3.5 (0.4) & 0.874 \\ ast, mean (SD) & & 106 & 122.6 (56.7) & 120.2 (54.5) & 125.0 (58.9) & 0.460 \\ platelet, mean (SD) & & 11 & 257.0 (98.3) & 258.8 (100.3) & 265.2 (90.7) & 0.554 \\ protime, mean (SD) & & 2 & 10.7 (1.0) & 10.7 (0.9) & 10.8 (1.1) & 0.199 \\ ascites, n (\%) & 0.0 & 106 & 288 (92.3) & 144 (91.1) & 144 (93.5) & 0.567 \\ & 1.0 & & 24 (7.7) & 14 (8.9) & 10 (6.5) & \\ hepato, n (\%) & 0.0 & 106 & 152 (48.7) & 85 (53.8) & 67 (43.5) & 0.088 \\ & 1.0 & & 160 (51.3) & 73 (46.2) & 87 (56.5) & \\ spiders, n (\%) & 0.0 & 106 & 222 (71.2) & 113 (71.5) & 109 (70.8) & 0.985 \\ & 1.0 & & 90 (28.8) & 45 (28.5) & 45 (29.2) & \\ edema, n (\%) & 0.0 & 0 & 354 (84.7) & 132 (83.5) & 131 (85.1) & 0.877 \\ & 0.5 & & 44 (10.5) & 16 (10.1) & 13 (8.4) & \\ & 1.0 & & 20 (4.8) & 10 (6.3) & 10 (6.5) & \\ sex, n (\%) & f & 0 & 374 (89.5) & 137 (86.7) & 139 (90.3) & 0.421 \\ & m & & 44 (10.5) & 21 (13.3) & 15 (9.7) & \\ trt, n (\%) & 1.0 & 106 & 158 (50.6) & 158 (100.0) & & \ensuremath{<}0.001 \\ & 2.0 & & 154 (49.4) & & 154 (100.0) & \\ \hline \end{tabular} .. GENERATED FROM PYTHON SOURCE LINES 54-55 Lets tabulate for grid. .. GENERATED FROM PYTHON SOURCE LINES 55-57 .. code-block:: default :lineno-start: 55 print(mytable.tabulate(tablefmt="grid")) .. rst-class:: sphx-glr-script-out Out: .. code-block:: none +----------------------+-----+-----------+---------------+---------------+---------------+-----------+ | | | Missing | Overall | 1.0 | 2.0 | P-Value | +======================+=====+===========+===============+===============+===============+===========+ | n | | | 418 | 158 | 154 | | +----------------------+-----+-----------+---------------+---------------+---------------+-----------+ | age, mean (SD) | | 0 | 50.7 (10.4) | 51.4 (11.0) | 48.6 (10.0) | 0.018 | +----------------------+-----+-----------+---------------+---------------+---------------+-----------+ | bili, median [Q1,Q3] | | 0 | 1.4 [0.8,3.4] | 1.4 [0.8,3.2] | 1.3 [0.7,3.6] | 0.842 | +----------------------+-----+-----------+---------------+---------------+---------------+-----------+ | albumin, mean (SD) | | 0 | 3.5 (0.4) | 3.5 (0.4) | 3.5 (0.4) | 0.874 | +----------------------+-----+-----------+---------------+---------------+---------------+-----------+ | ast, mean (SD) | | 106 | 122.6 (56.7) | 120.2 (54.5) | 125.0 (58.9) | 0.460 | +----------------------+-----+-----------+---------------+---------------+---------------+-----------+ | platelet, mean (SD) | | 11 | 257.0 (98.3) | 258.8 (100.3) | 265.2 (90.7) | 0.554 | +----------------------+-----+-----------+---------------+---------------+---------------+-----------+ | protime, mean (SD) | | 2 | 10.7 (1.0) | 10.7 (0.9) | 10.8 (1.1) | 0.199 | +----------------------+-----+-----------+---------------+---------------+---------------+-----------+ | ascites, n (%) | 0.0 | 106 | 288 (92.3) | 144 (91.1) | 144 (93.5) | 0.567 | +----------------------+-----+-----------+---------------+---------------+---------------+-----------+ | | 1.0 | | 24 (7.7) | 14 (8.9) | 10 (6.5) | | +----------------------+-----+-----------+---------------+---------------+---------------+-----------+ | hepato, n (%) | 0.0 | 106 | 152 (48.7) | 85 (53.8) | 67 (43.5) | 0.088 | +----------------------+-----+-----------+---------------+---------------+---------------+-----------+ | | 1.0 | | 160 (51.3) | 73 (46.2) | 87 (56.5) | | +----------------------+-----+-----------+---------------+---------------+---------------+-----------+ | spiders, n (%) | 0.0 | 106 | 222 (71.2) | 113 (71.5) | 109 (70.8) | 0.985 | +----------------------+-----+-----------+---------------+---------------+---------------+-----------+ | | 1.0 | | 90 (28.8) | 45 (28.5) | 45 (29.2) | | +----------------------+-----+-----------+---------------+---------------+---------------+-----------+ | edema, n (%) | 0.0 | 0 | 354 (84.7) | 132 (83.5) | 131 (85.1) | 0.877 | +----------------------+-----+-----------+---------------+---------------+---------------+-----------+ | | 0.5 | | 44 (10.5) | 16 (10.1) | 13 (8.4) | | +----------------------+-----+-----------+---------------+---------------+---------------+-----------+ | | 1.0 | | 20 (4.8) | 10 (6.3) | 10 (6.5) | | +----------------------+-----+-----------+---------------+---------------+---------------+-----------+ | sex, n (%) | f | 0 | 374 (89.5) | 137 (86.7) | 139 (90.3) | 0.421 | +----------------------+-----+-----------+---------------+---------------+---------------+-----------+ | | m | | 44 (10.5) | 21 (13.3) | 15 (9.7) | | +----------------------+-----+-----------+---------------+---------------+---------------+-----------+ | trt, n (%) | 1.0 | 106 | 158 (50.6) | 158 (100.0) | | <0.001 | +----------------------+-----+-----------+---------------+---------------+---------------+-----------+ | | 2.0 | | 154 (49.4) | | 154 (100.0) | | +----------------------+-----+-----------+---------------+---------------+---------------+-----------+ .. GENERATED FROM PYTHON SOURCE LINES 58-59 Lets tabulate for fancy grid. .. GENERATED FROM PYTHON SOURCE LINES 59-61 .. code-block:: default :lineno-start: 59 print(mytable.tabulate(tablefmt="fancy_grid")) .. rst-class:: sphx-glr-script-out Out: .. code-block:: none ╒══════════════════════╤═════╤═══════════╤═══════════════╤═══════════════╤═══════════════╤═══════════╕ │ │ │ Missing │ Overall │ 1.0 │ 2.0 │ P-Value │ ╞══════════════════════╪═════╪═══════════╪═══════════════╪═══════════════╪═══════════════╪═══════════╡ │ n │ │ │ 418 │ 158 │ 154 │ │ ├──────────────────────┼─────┼───────────┼───────────────┼───────────────┼───────────────┼───────────┤ │ age, mean (SD) │ │ 0 │ 50.7 (10.4) │ 51.4 (11.0) │ 48.6 (10.0) │ 0.018 │ ├──────────────────────┼─────┼───────────┼───────────────┼───────────────┼───────────────┼───────────┤ │ bili, median [Q1,Q3] │ │ 0 │ 1.4 [0.8,3.4] │ 1.4 [0.8,3.2] │ 1.3 [0.7,3.6] │ 0.842 │ ├──────────────────────┼─────┼───────────┼───────────────┼───────────────┼───────────────┼───────────┤ │ albumin, mean (SD) │ │ 0 │ 3.5 (0.4) │ 3.5 (0.4) │ 3.5 (0.4) │ 0.874 │ ├──────────────────────┼─────┼───────────┼───────────────┼───────────────┼───────────────┼───────────┤ │ ast, mean (SD) │ │ 106 │ 122.6 (56.7) │ 120.2 (54.5) │ 125.0 (58.9) │ 0.460 │ ├──────────────────────┼─────┼───────────┼───────────────┼───────────────┼───────────────┼───────────┤ │ platelet, mean (SD) │ │ 11 │ 257.0 (98.3) │ 258.8 (100.3) │ 265.2 (90.7) │ 0.554 │ ├──────────────────────┼─────┼───────────┼───────────────┼───────────────┼───────────────┼───────────┤ │ protime, mean (SD) │ │ 2 │ 10.7 (1.0) │ 10.7 (0.9) │ 10.8 (1.1) │ 0.199 │ ├──────────────────────┼─────┼───────────┼───────────────┼───────────────┼───────────────┼───────────┤ │ ascites, n (%) │ 0.0 │ 106 │ 288 (92.3) │ 144 (91.1) │ 144 (93.5) │ 0.567 │ ├──────────────────────┼─────┼───────────┼───────────────┼───────────────┼───────────────┼───────────┤ │ │ 1.0 │ │ 24 (7.7) │ 14 (8.9) │ 10 (6.5) │ │ ├──────────────────────┼─────┼───────────┼───────────────┼───────────────┼───────────────┼───────────┤ │ hepato, n (%) │ 0.0 │ 106 │ 152 (48.7) │ 85 (53.8) │ 67 (43.5) │ 0.088 │ ├──────────────────────┼─────┼───────────┼───────────────┼───────────────┼───────────────┼───────────┤ │ │ 1.0 │ │ 160 (51.3) │ 73 (46.2) │ 87 (56.5) │ │ ├──────────────────────┼─────┼───────────┼───────────────┼───────────────┼───────────────┼───────────┤ │ spiders, n (%) │ 0.0 │ 106 │ 222 (71.2) │ 113 (71.5) │ 109 (70.8) │ 0.985 │ ├──────────────────────┼─────┼───────────┼───────────────┼───────────────┼───────────────┼───────────┤ │ │ 1.0 │ │ 90 (28.8) │ 45 (28.5) │ 45 (29.2) │ │ ├──────────────────────┼─────┼───────────┼───────────────┼───────────────┼───────────────┼───────────┤ │ edema, n (%) │ 0.0 │ 0 │ 354 (84.7) │ 132 (83.5) │ 131 (85.1) │ 0.877 │ ├──────────────────────┼─────┼───────────┼───────────────┼───────────────┼───────────────┼───────────┤ │ │ 0.5 │ │ 44 (10.5) │ 16 (10.1) │ 13 (8.4) │ │ ├──────────────────────┼─────┼───────────┼───────────────┼───────────────┼───────────────┼───────────┤ │ │ 1.0 │ │ 20 (4.8) │ 10 (6.3) │ 10 (6.5) │ │ ├──────────────────────┼─────┼───────────┼───────────────┼───────────────┼───────────────┼───────────┤ │ sex, n (%) │ f │ 0 │ 374 (89.5) │ 137 (86.7) │ 139 (90.3) │ 0.421 │ ├──────────────────────┼─────┼───────────┼───────────────┼───────────────┼───────────────┼───────────┤ │ │ m │ │ 44 (10.5) │ 21 (13.3) │ 15 (9.7) │ │ ├──────────────────────┼─────┼───────────┼───────────────┼───────────────┼───────────────┼───────────┤ │ trt, n (%) │ 1.0 │ 106 │ 158 (50.6) │ 158 (100.0) │ │ <0.001 │ ├──────────────────────┼─────┼───────────┼───────────────┼───────────────┼───────────────┼───────────┤ │ │ 2.0 │ │ 154 (49.4) │ │ 154 (100.0) │ │ ╘══════════════════════╧═════╧═══════════╧═══════════════╧═══════════════╧═══════════════╧═══════════╛ .. GENERATED FROM PYTHON SOURCE LINES 62-63 Lets tabulate for markdown .. GENERATED FROM PYTHON SOURCE LINES 63-65 .. code-block:: default :lineno-start: 63 print(mytable.tabulate(tablefmt="rst")) .. rst-class:: sphx-glr-script-out Out: .. code-block:: none ==================== === ========= ============= ============= ============= ========= .. Missing Overall 1.0 2.0 P-Value ==================== === ========= ============= ============= ============= ========= n 418 158 154 age, mean (SD) 0 50.7 (10.4) 51.4 (11.0) 48.6 (10.0) 0.018 bili, median [Q1,Q3] 0 1.4 [0.8,3.4] 1.4 [0.8,3.2] 1.3 [0.7,3.6] 0.842 albumin, mean (SD) 0 3.5 (0.4) 3.5 (0.4) 3.5 (0.4) 0.874 ast, mean (SD) 106 122.6 (56.7) 120.2 (54.5) 125.0 (58.9) 0.460 platelet, mean (SD) 11 257.0 (98.3) 258.8 (100.3) 265.2 (90.7) 0.554 protime, mean (SD) 2 10.7 (1.0) 10.7 (0.9) 10.8 (1.1) 0.199 ascites, n (%) 0.0 106 288 (92.3) 144 (91.1) 144 (93.5) 0.567 .. 1.0 24 (7.7) 14 (8.9) 10 (6.5) hepato, n (%) 0.0 106 152 (48.7) 85 (53.8) 67 (43.5) 0.088 .. 1.0 160 (51.3) 73 (46.2) 87 (56.5) spiders, n (%) 0.0 106 222 (71.2) 113 (71.5) 109 (70.8) 0.985 .. 1.0 90 (28.8) 45 (28.5) 45 (29.2) edema, n (%) 0.0 0 354 (84.7) 132 (83.5) 131 (85.1) 0.877 .. 0.5 44 (10.5) 16 (10.1) 13 (8.4) .. 1.0 20 (4.8) 10 (6.3) 10 (6.5) sex, n (%) f 0 374 (89.5) 137 (86.7) 139 (90.3) 0.421 .. m 44 (10.5) 21 (13.3) 15 (9.7) trt, n (%) 1.0 106 158 (50.6) 158 (100.0) <0.001 .. 2.0 154 (49.4) 154 (100.0) ==================== === ========= ============= ============= ============= ========= .. GENERATED FROM PYTHON SOURCE LINES 66-67 Save as latex file .. GENERATED FROM PYTHON SOURCE LINES 67-69 .. code-block:: default :lineno-start: 67 mytable.to_latex('./outputs/main01-mytable.tex') .. GENERATED FROM PYTHON SOURCE LINES 70-71 Save as xls file .. GENERATED FROM PYTHON SOURCE LINES 71-71 .. code-block:: default :lineno-start: 71 mytable.to_excel('./outputs/main01-mytable.xlsx') .. rst-class:: sphx-glr-timing **Total running time of the script:** ( 0 minutes 0.618 seconds) .. _sphx_glr_download__examples_tableone_plot_main01.py: .. only :: html .. container:: sphx-glr-footer :class: sphx-glr-footer-example .. container:: sphx-glr-download sphx-glr-download-python :download:`Download Python source code: plot_main01.py ` .. container:: sphx-glr-download sphx-glr-download-jupyter :download:`Download Jupyter notebook: plot_main01.ipynb ` .. only:: html .. rst-class:: sphx-glr-signature `Gallery generated by Sphinx-Gallery `_