import pandas as pd
import sqlite3

# 连接SQLite数据库（自动创建文件）
conn = sqlite3.connect("college_info.db")

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}'
    df_name.to_sql(table_name, conn, index=False, if_exists='replace')
    print(f"✅ {i}年数据已写入SQLite表 {table_name}")
    i -= 1

conn.close()
print("\n🎉 SQLite数据写入成功！")