SELECT subject, AVG(score) AS avg_score FROM student_scores GROUP BY subject;
import pandas as pd
import matplotlib.pyplot as plt
# 加载数据
data = pd.read_csv('student_scores.csv')
# 计算平均分数
avg_scores = data.groupby('subject')['score'].mean()
# 绘制柱状图
avg_scores.plot(kind='bar', color='skyblue')
plt.title('Average Scores by Subject')
plt.xlabel('Subject')
plt.ylabel('Score')
plt.show()
SELECT grade, AVG(score) AS avg_score FROM student_scores GROUP BY grade;
from flask import Flask, jsonify
app = Flask(__name__)
@app.route('/api/avg_scores', methods=['GET'])
def get_avg_scores():
avg_scores = {
'Math': 78,
'Science': 82,
'English': 85
}
return jsonify(avg_scores)
if __name__ == '__main__':
app.run(debug=True)