一站式网上办事大厅

pip install pandas matplotlib pptx

import pandas as pd

import matplotlib.pyplot as plt

from pptx import Presentation

# 假设我们已经从一表通平台导出了CSV文件

df = pd.read_csv('course_data.csv')

# 统计某门课的成绩分布

grades_distribution = df['Grade'].value_counts()

# 使用Matplotlib绘制饼图

plt.figure(figsize=(6,6))

grades_distribution.plot.pie(autopct='%1.1f%%')

plt.title('Course Grade Distribution')

plt.savefig('grades_pie.png')

# 创建一个新的PowerPoint文档

prs = Presentation()

slide = prs.slides.add_slide(prs.slide_layouts[5])

# 在幻灯片上添加标题

title = slide.shapes.title

title.text = "Course Performance Analysis"

# 插入图片

left = top = width = height = Inches(1)

pic = slide.shapes.add_picture('grades_pie.png', left, top, width, height)

校友服务系统

# 保存幻灯片

prs.save('course_performance.pptx')