如何转换Pandas DataFrame格式以适配展示或打印需求

数据老陈

2026-7-26

实现方法2：列表形式展示（简洁紧凑）

如果偏好轻量化展示，可生成无序列表格式：

import pandas as pd

df = pd.DataFrame({'model':['AB','AB','AB','AB','AB','AB','AB','AB','AB','AB','AB','AB','AB','C','C','C'],
       'lot':['a','a','a','a','a','a','b','b','b','b','b','b','b','c','c','c'],
       'part':['aa','ab','ac','ad','ae','af','ba','bb','bc','bd','be','bf','bg','ca','cb','cc'],
       'qty':[1,2,1,3,1,5, 2,3,4,5,3,2,1,2,3,3]})

md_content = ""
for model, model_grp in df.groupby("model"):
    md_content += f"# {model}\n\n"
    for lot, lot_grp in model_grp.groupby("lot"):
        md_content += f"## Lot: {lot}\n\n"
        # 生成无序列表
        items = [f"- {row['part']}: {row['qty']}" for _, row in lot_grp.iterrows()]
        md_content += "\n".join(items) + "\n\n"

print(md_content)

输出的Markdown展示效果：