import pandas as pd
url = r'http://127.0.0.1:3000'
df_total = pd.read_html(url, encoding='gbk') 
df_total




from sqlalchemy import create_engine
from sqlalchemy.types import *
engine = create_engine('mysql+pymysql://root:123456@127.0.0.1/college_info')
# 新的列索引
new_column_names = {0: '总分类', 1: '子分类', 2: '分数'}
i = 2024
for df in df_total:
    if i == 2019:
        break
    # 重命名列索引
    df_name = df.rename(columns=new_column_names)
    # 拼接数据表的名称
    table_name = f'college{i}'
    i -= 1
    # 向数据表写入数据
    df_name.to_sql(table_name, engine, index=False)
print('写入成功')