Original task proposed here https://inf-ege.sdamgia.ru/problem?id=47000
Python script code
(.env) boris@fedora40RCKDE:~/EXCEL$ cat excelSqlite.py
import sqlite3
import pandas as pd
con = sqlite3.connect('cps.db')
wb = pd.read_excel('031.xlsx',sheet_name = None)
for sheet in wb:
wb[sheet].to_sql(sheet,con,index=False)
con.commit()
con.close()
$ rm -f cps.db
$ touch -f cps.db
$ python excelSqlite.py
Database tables structure
SQL QUERY OUTPUT
SOLVE USE SAMPLE OUTPUT obtained via excel filtering
