学生信息管理系统

import pandas as pd

# 读取Excel文件

df = pd.read_excel('students_info.xlsx')

# 打印前几行数据

print(df.head())

]]>

统一认证登录

# 计算平均成绩

df['average_score'] = df[['Math', 'English', 'Physics']].mean(axis=1)

# 计算出勤率

df['attendance_rate'] = df['Attendance'] / df['Total_Attendance']

]]>

# 筛选符合条件的学生

qualified_students = df[(df['average_score'] > 85) & (df['attendance_rate'] > 0.9)]

# 输出符合条件的学生名单

print(qualified_students[['Name', 'average_score', 'attendance_rate']])

]]>