The Formatting Values page introduced the basics of fmt_number(), fmt_currency(), fmt_date(), and fmt_time(). But Great Tables has a much larger formatting toolkit. This page covers additional formatters that handle percentages, byte sizes, durations, scientific units, icons, flags, images, boolean values, Markdown, and more. Each formatter transforms raw cell data into presentation-ready content.
The fmt_percent() method formats numeric values as percentages. By default, it assumes the input values are proportions (e.g., 0.25 becomes "25.00%"). If your values are already in percent form, set scale_values=False.
import polars as pl
from great_tables import GT
pct_df = pl.DataFrame({
"metric": ["Conversion rate", "Bounce rate", "Click-through"],
"proportion": [0.034, 0.621, 0.158],
"already_pct": [3.4, 62.1, 15.8],
})
(
GT(pct_df, rowname_col="metric")
.fmt_percent(columns="proportion", decimals=1)
.fmt_percent(columns="already_pct", decimals=1, scale_values=False)
)| proportion | already_pct | |
|---|---|---|
| Conversion rate | 3.4% | 3.4% |
| Bounce rate | 62.1% | 62.1% |
| Click-through | 15.8% | 15.8% |
Both columns display correctly as percentages, but the proportion column needed scaling (the default behavior) while already_pct did not.
The fmt_bytes() method converts raw byte counts into human-readable sizes. It automatically selects the appropriate unit (kB, MB, GB, etc.) based on the magnitude of the value.
bytes_df = pl.DataFrame({
"file": ["photo.jpg", "video.mp4", "document.pdf", "database.sqlite"],
"size_bytes": [2_048_000, 1_573_000_000, 524_288, 85_000_000_000],
})
(
GT(bytes_df, rowname_col="file")
.fmt_bytes(columns="size_bytes", standard="decimal")
)| size_bytes | |
|---|---|
| photo.jpg | 2 MB |
| video.mp4 | 1.6 GB |
| document.pdf | 524.3 kB |
| database.sqlite | 85 GB |
The standard= argument controls the unit system. Use "decimal" for powers of 1000 (kB, MB, GB) or "binary" for powers of 1024 (KiB, MiB, GiB).
| size_bytes | |
|---|---|
| photo.jpg | 2 MiB |
| video.mp4 | 1.5 GiB |
| document.pdf | 512 KiB |
| database.sqlite | 79.2 GiB |
With the binary standard, the same byte values display in KiB, MiB, and GiB units. Choose whichever standard matches the conventions of your domain.
The fmt_duration() method formats numeric values (or timedelta objects) as styled time duration strings. You specify the input unit and the method handles the conversion and display.
duration_df = pl.DataFrame({
"event": ["Sprint", "Marathon", "Triathlon", "Ultra"],
"seconds": [58, 7380, 21600, 172800],
})
(
GT(duration_df, rowname_col="event")
.fmt_duration(columns="seconds", input_units="seconds")
)| seconds | |
|---|---|
| Sprint | 58s |
| Marathon | 2h 3m |
| Triathlon | 6h |
| Ultra | 2d |
The duration_style= argument controls the output format. The available styles are:
"narrow" (the default): compact format like "2d 3h 15m""wide": spelled out like "2 days 3 hours 15 minutes""colon-sep": clock format like "51:03:15""iso": ISO 8601 format like "P2DT3H15M"(
GT(duration_df, rowname_col="event")
.fmt_duration(columns="seconds", input_units="seconds", duration_style="wide")
)| seconds | |
|---|---|
| Sprint | 58 seconds |
| Marathon | 2 hours 3 minutes |
| Triathlon | 6 hours |
| Ultra | 2 days |
You can limit the number of output units with max_output_units= to keep the display concise.
(
GT(duration_df, rowname_col="event")
.fmt_duration(columns="seconds", input_units="seconds", max_output_units=2)
)| seconds | |
|---|---|
| Sprint | 58s |
| Marathon | 2h 3m |
| Triathlon | 6h |
| Ultra | 2d |
Limiting the output to two units (e.g., "2d 3h" instead of "2d 3h 15m") keeps the display compact when exact precision is not required.
The fmt_engineering() method formats values in engineering notation, where the exponent is always a multiple of 3. This aligns with SI prefixes (kilo, mega, milli, micro, etc.) and is common in technical and scientific contexts.
eng_df = pl.DataFrame({
"quantity": ["Resistance", "Capacitance", "Frequency", "Power"],
"value": [4700.0, 0.0000001, 2400000000.0, 0.0035],
})
(
GT(eng_df, rowname_col="quantity")
.fmt_engineering(columns="value")
)| value | |
|---|---|
| Resistance | 4.70 × 103 |
| Capacitance | 100.00 × 10−9 |
| Frequency | 2.40 × 109 |
| Power | 3.50 × 10−3 |
Each value is expressed with a mantissa between 1 and 999 and an exponent that is a multiple of 3. This makes it straightforward to mentally convert to SI prefixes (e.g., 4.7 x 10^3 = 4.7 kilo).
The fmt_partsper() method formats values as parts-per quantities: per mille, ppm, ppb, and more. By default, it assumes input values are proportions and scales them accordingly.
ppm_df = pl.DataFrame({
"substance": ["Lead", "Mercury", "Arsenic"],
"concentration": [0.000015, 0.000001, 0.00001],
})
(
GT(ppm_df, rowname_col="substance")
.fmt_partsper(columns="concentration", to_units="ppm")
)| concentration | |
|---|---|
| Lead | 15.00 ppm |
| Mercury | 1.00 ppm |
| Arsenic | 10.00 ppm |
The to_units= argument accepts the following values: "per-mille", "per-myriad", "pcm", "ppm", "ppb", "ppt", and "ppq".
The fmt_roman() method converts integer values into Roman numerals. This can be useful for numbering chapters, sections, or ranked items.
roman_df = pl.DataFrame({
"event": ["Opening", "Keynote", "Workshop", "Closing"],
"order": [1, 2, 3, 4],
})
(
GT(roman_df, rowname_col="event")
.fmt_roman(columns="order")
)| order | |
|---|---|
| Opening | I |
| Keynote | II |
| Workshop | III |
| Closing | IV |
The case= argument accepts "upper" (the default, producing "I", "II", "III") or "lower" (producing "i", "ii", "iii").
The fmt_units() method renders measurement units with proper subscripts, superscripts, and special symbols. It uses a concise notation syntax where ^ indicates superscripts, _ indicates subscripts, and special names are referenced with colons.
units_df = pl.DataFrame({
"quantity": ["Speed of light", "Boltzmann constant", "Planck constant", "Acceleration"],
"units": ["m/s", "J Hz^-1", "kg m^2 s^-1", "m s^-2"],
})
(
GT(units_df, rowname_col="quantity")
.fmt_units(columns="units")
)| units | |
|---|---|
| Speed of light | m/s |
| Boltzmann constant | J Hz−1 |
| Planck constant | kg m2 s−1 |
| Acceleration | m s−2 |
The units notation supports Greek letters (:alpha:, :beta:, :sigma:), chemical formulas in percent delimiters (%H2O%), and combined subscripts and superscripts (t_i^2).
The fmt_tf() method transforms boolean values into visual indicators. It offers a variety of preset styles including text labels, check marks, shapes, and arrows.
tf_df = pl.DataFrame({
"feature": ["Dark mode", "Auto-save", "Spell check", "Notifications"],
"enabled": [True, True, False, True],
"premium": [False, True, False, True],
})
(
GT(tf_df, rowname_col="feature")
.fmt_tf(columns="enabled", tf_style="check-mark")
.fmt_tf(columns="premium", tf_style="circles")
)| enabled | premium | |
|---|---|---|
| Dark mode | ✔ | ⭘ |
| Auto-save | ✔ | ● |
| Spell check | ✘ | ⭘ |
| Notifications | ✔ | ● |
The available tf_style= values include: "true-false", "yes-no", "up-down", "check-mark", "circles", "squares", "diamonds", "arrows", "triangles", and "triangles-lr".
You can also apply colors to the True/False indicators using the colors= argument.
(
GT(tf_df, rowname_col="feature")
.fmt_tf(columns="enabled", tf_style="check-mark", colors=["green", "red"])
)| enabled | premium | |
|---|---|---|
| Dark mode | ✔ | false |
| Auto-save | ✔ | true |
| Spell check | ✘ | false |
| Notifications | ✔ | true |
When you provide two colors, the first applies to True values and the second to False values.
The fmt_markdown() method renders Markdown-formatted text that appears in cells. This is useful when your data contains text with emphasis, links, or other inline formatting.
md_df = pl.DataFrame({
"package": ["polars", "pandas", "numpy"],
"description": [
"**Fast** DataFrame library for *Rust* and Python",
"Flexible data analysis with **labeled** axes",
"Fundamental package for *scientific computing*",
],
})
(
GT(md_df, rowname_col="package")
.fmt_markdown(columns="description")
)| description | |
|---|---|
| polars | Fast DataFrame library for Rust and Python |
| pandas | Flexible data analysis with labeled axes |
| numpy | Fundamental package for scientific computing |
The Markdown is converted to HTML during rendering, so standard inline Markdown syntax (bold, italic, links, code) is supported.
The fmt_icon() method renders Font Awesome icons based on icon names stored in cells. This is a visually engaging way to represent categories, statuses, or types.
icon_df = pl.DataFrame({
"platform": ["Web", "Mobile", "Desktop"],
"icon_name": ["globe", "mobile", "desktop"],
"users": [45000, 32000, 12000],
})
(
GT(icon_df, rowname_col="platform")
.fmt_icon(columns="icon_name", fill_color="steelblue")
.fmt_number(columns="users", compact=True)
)| icon_name | users | |
|---|---|---|
| Web | 45.00K | |
| Mobile | 32.00K | |
| Desktop | 12.00K |
The fill_color= argument accepts a single color (applied to all icons) or a dictionary mapping icon names to specific colors.
(
GT(icon_df, rowname_col="platform")
.fmt_icon(
columns="icon_name",
fill_color={"globe": "royalblue", "mobile": "forestgreen", "desktop": "slategray"}
)
)| icon_name | users | |
|---|---|---|
| Web | 45000 | |
| Mobile | 32000 | |
| Desktop | 12000 |
Using a dictionary for fill_color= lets you assign semantically meaningful colors to each icon, making the visual distinction immediate.
The fmt_flag() method generates flag icons from ISO 3166-1 country codes (two- or three-letter codes). This is useful for international datasets.
country_df = pl.DataFrame({
"country_code": ["US", "GB", "JP", "DE", "BR"],
"country": ["United States", "United Kingdom", "Japan", "Germany", "Brazil"],
"gdp_trillion": [25.5, 3.1, 4.2, 4.1, 1.9],
})
(
GT(country_df, rowname_col="country")
.fmt_flag(columns="country_code")
.fmt_number(columns="gdp_trillion", decimals=1)
.cols_label(country_code="Flag", gdp_trillion="GDP (USD trillions)")
)| Flag | GDP (USD trillions) | |
|---|---|---|
| United States | 25.5 | |
| United Kingdom | 3.1 | |
| Japan | 4.2 | |
| Germany | 4.1 | |
| Brazil | 1.9 |
The flags render as small inline images with a hover tooltip showing the country name (controlled by use_title=).
The fmt_image() method renders image paths or URLs as inline images within cells. This is useful for product catalogs, team rosters, or any dataset where visual identification matters.
img_df = pl.DataFrame({
"planet": ["Earth", "Mars", "Jupiter"],
"image_file": ["earth.png", "mars.png", "jupiter.png"],
"diameter_km": [12742, 6779, 139820],
})
(
GT(img_df, rowname_col="planet")
.fmt_image(columns="image_file", path="images/", height="40px")
.fmt_number(columns="diameter_km", use_seps=True)
)The path= argument provides a common prefix for all file references, and height=/width= control the rendered dimensions. When encode=True (the default), local image files are base64-encoded directly into the HTML output, making the table self-contained.
When none of the built-in formatters fit your needs, the generic fmt() method lets you supply any function as a formatter. The function receives a raw cell value and should return a formatted string.
def format_score(value):
"""Convert a 0-100 score to a letter grade."""
if value >= 90:
return "A"
elif value >= 80:
return "B"
elif value >= 70:
return "C"
elif value >= 60:
return "D"
else:
return "F"
grades_df = pl.DataFrame({
"student": ["Alice", "Bob", "Charlie", "Diana"],
"score": [95, 82, 67, 91],
})
(
GT(grades_df, rowname_col="student")
.fmt(fns=format_score, columns="score")
)| score | |
|---|---|
| Alice | A |
| Bob | B |
| Charlie | D |
| Diana | A |
The fmt() method is the escape hatch for any formatting logic that the specialized fmt_*() methods do not cover. Your function can return plain text or HTML strings for rich formatting.
The formatting methods in Great Tables cover a wide spectrum of data types and presentation needs. From scientific notation to country flags, from boolean indicators to custom functions, you have the tools to make every column in your table look exactly right for its audience and context.