Files

95 lines
4.6 KiB
Python
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
# -*- 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()