构建基于大学综合门户的排行系统

CREATE TABLE university (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(255) NOT NULL,

location VARCHAR(255)

);

CREATE TABLE faculty (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(255) NOT NULL,

university_id INT,

FOREIGN KEY (university_id) REFERENCES university(id)

);

CREATE TABLE course (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(255) NOT NULL,

faculty_id INT,

rating FLOAT DEFAULT 0,

FOREIGN KEY (faculty_id) REFERENCES faculty(id)

);

]]>

import pandas as pd

# 假设df是包含课程数据的DataFrame

df = pd.read_csv('courses.csv')

# 按照评分降序排序

sorted_courses = df.sort_values(by='rating', ascending=False)

sorted_courses.to_csv('sorted_courses.csv', index=False)

]]>

大学课程排行榜

]]>