itable examples¶

These tables are created using the itable package https://github.com/mgymrek/itable.

These examples are originally described in this post before I had created the separate itable package. Usage is identical except for the change in the package name.

In [16]:

import pandas as pd
import itable

In [17]:

# Create an example data frame
df = pd.DataFrame({"x":[1,2,3], "y":[6,4,3], "z":["testing","pretty","tables"], "f":[0.023432, 0.234321,0.5555]})

In [18]:

# Display a simple table
itable.PrettyTable(df)

Out[18]:

f	x	y	z
0.023432	1	6	testing
0.234321	2	4	pretty
0.5555	3	3	tables

In [19]:

# Give it a theme and center the table
itable.PrettyTable(df, tstyle=itable.TableStyle(theme="theme1"), center=True)

Out[19]:

f	x	y	z
0.023432	1	6	testing
0.234321	2	4	pretty
0.5555	3	3	tables

In [20]:

# Set cell style using a CellStyle object
pt = itable.PrettyTable(df, tstyle=itable.TableStyle(theme="theme1"), center=True)
cs = itable.CellStyle()
cs.set("background-color", "red")
cs.set("color", "white")
pt.set_cell_style(style=cs)
pt

Out[20]:

f	x	y	z
0.023432	1	6	testing
0.234321	2	4	pretty
0.5555	3	3	tables

In [21]:

# Only for a subset of rows/columns
pt = itable.PrettyTable(df, tstyle=itable.TableStyle(theme="theme1"), center=True)
cs = itable.CellStyle()
cs.set("background-color", "red")
cs.set("color", "white")
pt.set_cell_style(style=cs, rows=[1,2], cols=[2])
pt

Out[21]:

f	x	y	z
0.023432	1	6	testing
0.234321	2	4	pretty
0.5555	3	3	tables

In [22]:

# Set styles using keywords (these are all CSS properties, just replace "-" with "_")
pt = itable.PrettyTable(df, tstyle=itable.TableStyle(theme="theme1"), center=True)
pt.set_cell_style(font_weight="bold", color="purple", background_color="yellow", rows=[1], cols=[2,3])
pt

Out[22]:

f	x	y	z
0.023432	1	6	testing
0.234321	2	4	pretty
0.5555	3	3	tables

In [23]:

# Set the header style. corner sets the corner cell
# "indices" applies the style only to certain indices
pt = itable.PrettyTable(df, tstyle=itable.TableStyle(theme="theme1"), center=True, header_row=True)
pt.set_row_header_style(color="blue")
pt.set_col_header_style(background_color="white", font_weight="bold", indices=[2])
pt.set_corner_style(background_color="red")
pt

Out[23]:

	f	x	y	z
0	0.023432	1	6	testing
1	0.234321	2	4	pretty
2	0.5555	3	3	tables

In [24]:

# Update current styles
pt = itable.PrettyTable(df, tstyle=itable.TableStyle(theme="theme1"), center=True, header_row=True)
pt.set_cell_style(font_weight="bold", color="purple", background_color="yellow", rows=[1], cols=[2,3])
pt.update_cell_style(background_color="pink", rows=[1], cols=[3])
pt.update_row_header_style(background_color="blue", indices=[0])
pt.update_col_header_style(color="red")
pt.update_corner_style(background_color="purple")
pt

Out[24]:

	f	x	y	z
0	0.023432	1	6	testing
1	0.234321	2	4	pretty
2	0.5555	3	3	tables

In [25]:

# Set cell formats
df = pd.DataFrame({"FloatColumn": [0.0324234, 0.23432111, 0.555555], "SciNotColumn":[1e10, 4.232e-6, 53e-8]})
pt = itable.PrettyTable(df, tstyle=itable.TableStyle(theme="theme1"), center=True)
pt.set_cell_style(cols=[0], format_function=lambda x: "%.3f"%x)
def SciNot(x):
    xx = "%.2E"%x
    base, exp = xx.split("E")
    return "%s &times; 10<sup>%s</sup>"%(base, int(exp))
pt.set_cell_style(cols=[1], format_function=SciNot)
pt

Out[25]:

FloatColumn	SciNotColumn
0.032	1.00 × 10¹⁰
0.234	4.23 × 10^-6
0.556	5.30 × 10^-7