Pydeck tooltip format numbers

Question

Does anyone know how to edit the tooltip portion of a pydeck plot. Specifically, I want to change the mrt_distance in the html portion to display it in whole number, with a comma at the thousands. For example, 2143.45 meters should be displayed as 2,143 meters.

import pandas as pd
import pydeck as pdk

DATA_URL = "https://raw.githubusercontent.com/ajduberstein/geo_datasets/master/housing.csv"
df = pd.read_csv(DATA_URL)

view = pdk.data_utils.compute_view(df[["lng", "lat"]])
view.pitch = 75
view.bearing = 60

column_layer = pdk.Layer(
    "ColumnLayer",
    data=df,
    get_position=["lng", "lat"],
    get_elevation="price_per_unit_area",
    elevation_scale=100,
    radius=50,
    get_fill_color=["mrt_distance * 10", "mrt_distance", "mrt_distance * 10", 140],
    pickable=True,
    auto_highlight=True,
)

tooltip = {
    "html": "<b>{mrt_distance}</b> meters away from an MRT station, costs <b>{price_per_unit_area}</b> NTD/sqm",
    "style": {"background": "grey", "color": "white", "font-family": '"Helvetica Neue", Arial', "z-index": "10000"},
}

r = pdk.Deck(
    column_layer,
    initial_view_state=view,
    tooltip=tooltip,
    map_provider="mapbox",
    map_style=pdk.map_styles.SATELLITE,
)

r.to_html("column_layer.html")

Answer 1

Currently, you have to create a separate field in your input data that's the appropriately formatted string, e.g.,

df['formatted_distance'] = df['mrt_distance'].apply(lambda d: f'{round(d, 2):,}')

You can then mention this column by name in the tooltip.