"""Build the article's original fictional estimate with real pandas output.""" from html import escape import json from pathlib import Path import sys import pandas as pd ROOT = Path(__file__).resolve().parent def build_report() -> dict: df = pd.DataFrame({ "Work": ["Discovery", "Prototype review", "QA", "Handoff"], "Hours": [6.0, 12.0, 4.0, None], "Rate": [95.0, 95.0, 85.0, 85.0], }) df["Amount"] = df["Hours"] * df["Rate"] known_subtotal = df["Amount"].sum(min_count=1) assert df.loc[0, "Amount"] == 570 assert df.loc[1, "Amount"] == 1140 assert df.loc[2, "Amount"] == 340 assert pd.isna(df.loc[3, "Amount"]) assert known_subtotal == 2050 styled = ( df.style.hide(axis="index") .format( {"Hours": "{:,.0f}", "Rate": "${:,.0f}", "Amount": "${:,.0f}"}, na_rep="Pending", escape="html", ) .format_index(axis="columns", escape="html") .set_caption("Illustrative estimate — handoff hours pending") .set_uuid("project_estimate") .set_properties(**{"text-align": "right"}, subset=["Hours", "Rate", "Amount"]) .set_properties(**{"text-align": "left"}, subset=["Work"]) ) table = styled.to_html() escape_probe = pd.DataFrame({"Text": [""]}).style.format(escape="html").to_html() assert "<review>" in escape_probe assert "" not in escape_probe assert table.count('class="data row') == 16 title = "Website prototype estimate" html = f''' {escape(title)}

PROJECT ESTIMATE / REVIEW COPY

{escape(title)}

Original fictional example. The known work is priced below; handoff hours still need agreement.

{table}

Known subtotal${known_subtotal:,.0f}

This is not the final price. Handoff hours and their amount remain pending. A missing amount has not been replaced with zero.

What to confirm

Check the three priced work items and agree the handoff hours before a final estimate is issued.

''' target = ROOT / "pandas-dataframe-to-html-report.html" target.write_text(html, encoding="utf-8") df.to_csv(ROOT / "pandas-report-source.csv", index=False) result = { "pandasVersion": pd.__version__, "pythonVersion": sys.version.split()[0], "fictional": True, "rows": len(df), "columns": len(df.columns), "knownSubtotal": float(known_subtotal), "pendingAmountRows": int(df["Amount"].isna().sum()), "numericAssertionsPassed": True, "escapingAssertionPassed": True, "tableDataCells": 16, "html": str(target), } (ROOT / "pandas-execution.json").write_text( json.dumps(result, ensure_ascii=False, indent=2), encoding="utf-8", ) return result if __name__ == "__main__": print(json.dumps(build_report(), ensure_ascii=False))