import pandas as pd
# 示例数据
data = {
'student_id': [1, 2, 3],
'name': ['Tom', 'Jerry', 'Spike'],
'attendance': [95, 80, 60],
'performance': [4, 3, 2], # 性能评分
'warnings': [0, 1, 2] # 预警次数
}
df = pd.DataFrame(data)
print(df)
]]>
def check_warning(row):
if row['attendance'] < 80 and row['performance'] < 3:
return True
return False
df['warning_status'] = df.apply(check_warning, axis=1)
print(df)
]]>
from flask import Flask, request
app = Flask(__name__)
@app.route('/update', methods=['POST'])
def update_student():
data = request.json
# 更新数据库逻辑
print("Received update:", data)
return "Success", 200
if __name__ == '__main__':
app.run()
]]>