使用Python将DataFrame导出为pptx

pip install python-pptx

import pandas as pd
from pptx import Presentation
from pptx.util import Inches

prs = Presentation()

df = pd.read_csv('data.csv')  # 假设数据保存在data.csv文件中

slide_layout = prs.slide_layouts[1]  # 选择幻灯片布局（根据需要选择合适的布局）
slide = prs.slides.add_slide(slide_layout)

# 创建一个表格
rows = df.shape[0] + 1
cols = df.shape[1]
left = Inches(1)
top = Inches(1.5)
width = Inches(8)
height = Inches(0.8)
table = slide.shapes.add_table(rows, cols, left, top, width, height).table

# 添加表头
for i, column in enumerate(df.columns):
    table.cell(0, i).text = column

# 添加数据
for i, row in enumerate(df.itertuples()):
    for j, value in enumerate(row[1:]):
        table.cell(i+1, j).text = str(value)

prs.save('output.pptx')  # 将结果保存为output.pptx文件