upload_arwu.py

import pandas as pd
from sqlalchemy import Numeric, create_engine

engine = create_engine("sqlite:///arwu.sqlite")


def upload_table(table, name, conn):
    dtypes = {}
    for col in table.columns:
        if str(table.dtypes[col]) == "float64":
            dtypes[col] = Numeric(10, 3)

    table.to_sql(name, conn, dtype=dtypes, index=False)


t1 = pd.read_excel("/home/lisk2/ARWU 2025 edited.xlsx")
upload_table(t1, "arwu_2025", engine)


t2 = pd.read_excel(
    "/home/lisk2/2025_2012_ARWU_WUR_с_раcчетными_позициями.xlsx", sheet_name="ARWU"
)
upload_table(t2, "arwu_wur_2025_2012", engine)