Sublime

import pandas as pd

import matplotlib.pyplot as plt

from pptx import Presentation

from pptx.util import Inches, Pt

# 1. Load data

df = pd.read_excel("EVENTS SHEET.xlsx")

# 2. Pre-process

# a) Event type counts

etype_counts = df["Event type"].value_counts()

# b) Venue capacity bins

bins = [0, 200, 1000, 5000, df["Venue Capacity"].max()]

labels = ["0–200",