Python 生成成绩报告单：从理论到实践

bash复制代码
pip install pandas reportlab

学生姓名,数学,英语,物理,化学张三,85,90,78,88李四,92,85,90,82王五,76,80,72,78

import pandas as pdfrom reportlab.lib.pagesizes import letterfrom reportlab.pdfgen import canvas # 读取CSV文件def read_scores(file_path):    df = pd.read_csv(file_path)    return df # 计算成绩统计信息def calculate_statistics(df):    statistics = {}    for subject in df.columns[1:]:  # 跳过第一列（学生姓名）        stats = df[subject].describe()        statistics[subject] = {            '平均分': stats['mean'],            '最高分': stats['max'],            '最低分': stats['min'],            '标准差': stats['std']        }    return statistics # 生成PDF格式的成绩报告单def generate_report(df, statistics, output_path):    c = canvas.Canvas(output_path, pagesize=letter)    width, height = letter     # 设置字体和大小    c.setFont("Helvetica", 12)     # 添加标题    c.drawString(100, height - 100, "学生成绩报告单")    c.line(72, height - 110, width - 72, height - 110)     # 添加学生信息表头    header = ["学生姓名"] + list(df.columns[1:])    c.setFont("Helvetica-Bold", 10)    col_widths = [70] + [50] * (len(header) - 1)    y = height - 120    for i, header_text in enumerate(header):        c.drawString(sum(col_widths[:i]) - col_widths[i] // 2, y, header_text)     # 添加学生信息    c.setFont("Helvetica", 10)    y -= 15    for index, row in df.iterrows():        for i, cell in enumerate(row):            if i == 0:                c.drawString(sum(col_widths[:i]) - col_widths[i] // 2, y, cell)            else:                c.drawString(sum(col_widths[:i]) - col_widths[i] // 2 - 5, y, f"{cell:.2f}")        y -= 15     # 添加统计信息    c.line(72, y - 10, width - 72, y - 10)    y -= 20    c.drawString(100, y, "成绩统计信息")    y -= 15    for subject, stats in statistics.items():        c.drawString(72, y, f"{subject} 平均分: {stats['平均分']:.2f}")        y -= 15        c.drawString(72, y, f"{subject} 最高分: {stats['最高分']:.2f}")        y -= 15        c.drawString(72, y, f"{subject} 最低分: {stats['最低分']:.2f}")        y -= 15        c.drawString(72, y, f"{subject} 标准差: {stats['标准差']:.2f}")        y -= 20     # 保存PDF文件    c.save() # 主函数def main():    file_path = "scores.csv"    output_path = "report.pdf"     df = read_scores(file_path)    statistics = calculate_statistics(df)    generate_report(df, statistics, output_path)     print(f"成绩报告单已生成并保存为 {output_path}") if __name__ == "__main__":    main()