95 lines
4.6 KiB
Python
95 lines
4.6 KiB
Python
# -*- coding: utf-8 -*-
|
||
"""缺口精确 hunt:列出各缺口的"可补子集"规模,按性价比排序。只读。"""
|
||
import re
|
||
import sqlite3
|
||
|
||
DB = r'D:\择校\数据库\zexiao_2027.db'
|
||
con = sqlite3.connect(DB, timeout=600)
|
||
q = lambda s, *a: (con.execute(s, a).fetchone() or [None])[0]
|
||
qall = lambda s, *a: con.execute(s, list(a)).fetchall()
|
||
|
||
print('=' * 60)
|
||
print('缺口 1:fact_global 四类指标(零采集成本,P4)')
|
||
print('=' * 60)
|
||
for y in (2025, 2026):
|
||
rows = qall("""SELECT field, COUNT(*) n, COUNT(DISTINCT school) s FROM fact_global
|
||
WHERE year=? AND field IN ('applicants','first_vol_admitted','adjust_admitted','enroll_min_score')
|
||
AND IFNULL(value,'')<>'' GROUP BY field""", y)
|
||
tot = sum(r[1] for r in rows)
|
||
sch = q("""SELECT COUNT(DISTINCT school) FROM fact_global
|
||
WHERE year=? AND field IN ('applicants','first_vol_admitted','adjust_admitted','enroll_min_score')
|
||
AND IFNULL(value,'')<>''""", y)
|
||
print(' %d: %s 行 / %s 校 | %s' % (y, f'{tot:,}', f'{sch:,}',
|
||
' | '.join('%s %s行' % (r[0], f'{r[1]:,}') for r in rows)))
|
||
n_conflict = q("SELECT COUNT(*) FROM fact_global WHERE status='conflict'")
|
||
print(' 其中 conflict 待裁决: %s 行' % f'{n_conflict:,}')
|
||
|
||
print()
|
||
print('=' * 60)
|
||
print('缺口 2:2026/2027 目录专业级缺口 → 点对点可补子集')
|
||
print('=' * 60)
|
||
# 官方分母 vs dir_hist(=pd 同源) 覆盖,缺口校里点对点无收录的
|
||
gaps = qall("""
|
||
SELECT c.dwmc, COUNT(DISTINCT c.zydm) m
|
||
FROM (SELECT DISTINCT dwmc, zydm FROM chsi_2027_dir) c
|
||
LEFT JOIN (SELECT DISTINCT 院校, 专业代码 FROM dir_hist) d
|
||
ON d.院校=c.dwmc AND d.专业代码=c.zydm
|
||
WHERE d.院校 IS NULL
|
||
GROUP BY c.dwmc ORDER BY m DESC""")
|
||
tot_keys = sum(m for _, m in gaps)
|
||
print(' 2027 官方有而目录无的 (校,专业): %d 键,涉及 %d 校' % (tot_keys, len(gaps)))
|
||
print(' Top8:', [(n[:8], m) for n, m in gaps[:8]])
|
||
|
||
print()
|
||
print('=' * 60)
|
||
print('缺口 3:dir_hist 招生人数空 21k 行 → 可用 chsi 补的子集')
|
||
print('=' * 60)
|
||
n_empty = q("SELECT COUNT(*) FROM dir_hist WHERE IFNULL(招生人数,'')=''")
|
||
n_fixable = q("""SELECT COUNT(*) FROM dir_hist h
|
||
WHERE IFNULL(h.招生人数,'')='' AND h.年份 IN ('2026','2027')
|
||
AND EXISTS (SELECT 1 FROM chsi_2027_dir c
|
||
WHERE c.dwmc=h.院校 AND c.zydm=h.专业代码 AND c.enroll_num GLOB '[0-9]*')""")
|
||
n_hist = q("SELECT COUNT(*) FROM dir_hist WHERE IFNULL(招生人数,'')='' AND 年份 NOT IN ('2026','2027')")
|
||
print(' 招生人数空: %s 行;其中 2026/2027 可用 chsi 官方补: %s 行;历史年(无官方源): %s 行'
|
||
% (f'{n_empty:,}', f'{n_fixable:,}', f'{n_hist:,}'))
|
||
# 可补时值
|
||
if n_fixable:
|
||
print(' chsi 侧口径提醒:须按 §1.2a 解析 enroll_str')
|
||
|
||
print()
|
||
print('=' * 60)
|
||
print('缺口 4:2023 分数段 43 校缺口 → 归因核实')
|
||
print('=' * 60)
|
||
n_23 = q("""SELECT COUNT(*) FROM (
|
||
SELECT DISTINCT school_id FROM ggyx_getfs_hist_all WHERE year=2023
|
||
EXCEPT SELECT DISTINCT school_id FROM ggyx_exam_dist WHERE year=2023)""")
|
||
print(' 2023 有复试线但无分数段的校: %d' % n_23)
|
||
# 这些校是否有 2024/2025 分数段(有→疑似漏采;无→当年未开展)
|
||
both = q("""SELECT COUNT(*) FROM (
|
||
SELECT DISTINCT school_id FROM ggyx_getfs_hist_all WHERE year=2023
|
||
EXCEPT SELECT DISTINCT school_id FROM ggyx_exam_dist WHERE year=2023)""")
|
||
later = q("""SELECT COUNT(*) FROM (
|
||
SELECT DISTINCT school_id FROM ggyx_getfs_hist_all WHERE year=2023
|
||
EXCEPT SELECT DISTINCT school_id FROM ggyx_exam_dist WHERE year=2023
|
||
) s WHERE school_id IN (SELECT DISTINCT school_id FROM ggyx_exam_dist WHERE year IN (2024,2025))""")
|
||
print(' 其中 2024/2025 有分数段(疑似 2023 漏采,接口可探测): %d' % later)
|
||
|
||
print()
|
||
print('=' * 60)
|
||
print('缺口 5:fact_dest 分数空 83%(归档表无分数字段)→ 接口可补子集')
|
||
print('=' * 60)
|
||
n_dest = q("SELECT COUNT(*) FROM fact_dest WHERE score IS NULL")
|
||
n_dest26 = q("SELECT COUNT(*) FROM ggyx_admission_list WHERE cs_all_result GLOB '[0-9]*'")
|
||
print(' fact_dest 2024/2025 无分数: %s 行(源归档表无此字段,重采 a 表也补不了)' % f'{n_dest:,}')
|
||
print(' 2026 admission 自带初试分: %s 行 ✓ 已覆盖' % f'{n_dest26:,}')
|
||
|
||
print()
|
||
print('=' * 60)
|
||
print('缺口 6:推免人数(B 类,23-25%)→ 复查 2027 官方是否有推免字段')
|
||
print('=' * 60)
|
||
cols = [r[1] for r in con.execute('PRAGMA table_info(chsi_2027_dir)')]
|
||
print(' chsi_2027_dir 列:', [c for c in cols if 'tuimian' in c.lower() or '推免' in c] or '无推免列')
|
||
print(' zybz 含"推免"的行数:', q("SELECT COUNT(*) FROM chsi_2027_dir WHERE zybz LIKE '%推免%'"))
|
||
|
||
con.close()
|