How to stop building the same report every week

from pathlib import Path
import pandas as pd

INPUT = Path("inputs")

frames = []
for file in sorted(INPUT.glob("sales_*.csv")):
    df = pd.read_csv(file, parse_dates=["order_date"])
    df["source_file"] = file.name
    frames.append(df)

sales = pd.concat(frames, ignore_index=True)

sales = (
    sales.drop_duplicates(subset="order_id")
         .assign(
             revenue=lambda d: d["quantity"] * d["unit_price"],
             week=lambda d: d["order_date"].dt.to_period("W-SUN").dt.start_time,
         )
)

weekly = (
    sales.groupby(["week", "region"], as_index=False)
         .agg(revenue=("revenue", "sum"), orders=("order_id", "nunique"))
)

last_week = weekly["week"].max()
latest = weekly[weekly["week"] == last_week]

assert not sales["order_id"].duplicated().any(), "Duplicate orders found"
assert len(latest) > 0, "No data for the latest week"
assert (latest["revenue"] >= 0).all(), "Negative revenue found"

output = Path("outputs") / f"weekly_report_{last_week:%Y-%m-%d}.xlsx"
output.parent.mkdir(exist_ok=True)

with pd.ExcelWriter(output) as writer:
    latest.to_excel(writer, sheet_name="This week", index=False)
    weekly.to_excel(writer, sheet_name="History", index=False)

import os
import smtplib
from email.message import EmailMessage

msg = EmailMessage()
msg["Subject"] = f"Weekly sales report, week of {last_week:%d %B %Y}"
msg["From"] = os.environ["REPORT_SENDER"]
msg["To"] = os.environ["REPORT_RECIPIENTS"]
msg.set_content(f"Hi all,\n\nRevenue last week: £{latest['revenue'].sum():,.0f}.\n"
                "The full report is attached.\n")
msg.add_attachment(output.read_bytes(), maintype="application",
                   subtype="vnd.openxmlformats-officedocument.spreadsheetml.sheet",
                   filename=output.name)

with smtplib.SMTP_SSL(os.environ["SMTP_HOST"], 465) as smtp:
    smtp.login(os.environ["SMTP_USER"], os.environ["SMTP_PASSWORD"])
    smtp.send_message(msg)

0 7 * * 1 cd /path/to/weekly-report && /usr/local/bin/uv run report.py >> run.log 2>&1