I need to visualize some parking occupancy data, shaped something like this:

┌──────┬─────┬──────────┬───────┐
│ zone ┆ lot ┆ occupied ┆ total │
│ ---  ┆ --- ┆ ---      ┆ ---   │
│ str  ┆ str ┆ i64      ┆ i64   │
╞══════╪═════╪══════════╪═══════╡
│ A    ┆ A1  ┆ 80       ┆ 100   │
│ A    ┆ A2  ┆ 25       ┆ 50    │
│ B    ┆ B1  ┆ 15       ┆ 50    │
│ B    ┆ B2  ┆ 25       ┆ 25    │
└──────┴─────┴──────────┴───────┘

I had in mind to make a treemap with 'zone' as the parent and each lot's rectangle showing the proportion occupied as a kind of 'fill' of the total rectangle area, but I can't figure out whether or not this is possible in a treemap. Plotly Express is my usual comfort zone, but I'm open to any ideas.

Also open to alternative visualizations if there's a better option than a treemap.

Thanks!

I need to visualize some parking occupancy data, shaped something like this:

┌──────┬─────┬──────────┬───────┐
│ zone ┆ lot ┆ occupied ┆ total │
│ ---  ┆ --- ┆ ---      ┆ ---   │
│ str  ┆ str ┆ i64      ┆ i64   │
╞══════╪═════╪══════════╪═══════╡
│ A    ┆ A1  ┆ 80       ┆ 100   │
│ A    ┆ A2  ┆ 25       ┆ 50    │
│ B    ┆ B1  ┆ 15       ┆ 50    │
│ B    ┆ B2  ┆ 25       ┆ 25    │
└──────┴─────┴──────────┴───────┘

I had in mind to make a treemap with 'zone' as the parent and each lot's rectangle showing the proportion occupied as a kind of 'fill' of the total rectangle area, but I can't figure out whether or not this is possible in a treemap. Plotly Express is my usual comfort zone, but I'm open to any ideas.

Also open to alternative visualizations if there's a better option than a treemap.

Thanks!

• python
• visualization
• treemap

• The following code will create a treemap. See this reference for more information. px.treemap(df, path=[px.Constant('all'), 'zone','lot',], values='total') – r-beginners Commented yesterday

1 Answer 1

I would go for a plain bar chart, as it is easier to visually grasp:

import pandas as pd
import plotly.express as px

df = pd.DataFrame(
    {
        "Zone": ["A", "A", "B", "B"],
        "Lot": ["A1", "A2", "B1", "B2"],
        "Occupied": [80, 25, 15, 25],
        "Total": [100, 50, 50, 25],
    }
)
# additional "Free" data for stacking purposes
df["Free"] = df["Total"] - df["Occupied"]
fig = px.bar(
    df,
    x="Lot",
    y=["Occupied", "Free"],
    text_auto=True,
    color_discrete_sequence=["blue", "red"],
)
fig.show()