基于数据分析系统的师范大学信息化建设实践

CREATE DATABASE university_data;

USE university_data;

CREATE TABLE student_grades (

student_id INT PRIMARY KEY,

course_name VARCHAR(100),

grade FLOAT

);

INSERT INTO student_grades (student_id, course_name, grade) VALUES (1, 'Mathematics', 95.5);

]]

import pandas as pd

# 加载数据

data = {

'student_id': [1, 2, 3],

'course_name': ['Mathematics', 'Physics', 'Chemistry'],

'grade': [95.5, 88.0, 76.0]

}

df = pd.DataFrame(data)

# 计算平均分

avg_grade = df.groupby('course_name')['grade'].mean()

print(avg_grade)

]]>

import matplotlib.pyplot as plt

# 绘制柱状图

avg_grade.plot(kind='bar')

plt.title('Average Grades by Course')

plt.xlabel('Course Name')

plt.ylabel('Grade')

plt.show()

]]>