Files
yanxuan/脚本/audit_four_dims.py
Your Name 62ac155641 同步择校 UI 三十四轮改版与审计产出
择校 UI(docs/择校UI):
- 搜索支持外号(东大/华科)与拼音首字母(dndx),未命中做分诊
- 目标分拖动即见三档数量,松手列出换档院校,名单按收藏/对比/本地排序
- 家乡省份接入院校库(家乡优先排序)与首页推荐(池不足时说明并可按档位判断)
- 缺档改成同尺寸占位卡并可跳院校库;三档口径收敛成一份、默认收起
- 新增拼音索引.js(907 校)

设计与交接:docs/研选E决策层_20261112 36 张稿与 README v1–v34;docs/agent_handoffs 续写。

审计与脚本:审计报告新增若干核验与分流产物,脚本同步更新。

.gitignore 追加排除 /官方资料/ 与 GB 级审计中间产物(global_writer_stages、来源发现、local_ingest_*)。
2026-11-13 22:32:10 +08:00

379 lines
20 KiB
Python
Raw Permalink Blame History

This file contains invisible Unicode characters
This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
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 -*-
"""四维深入审计(data-quality-hckp 框架 + sql-data-analyst 校验清单)
维度1 完整性:核心实体按年份的覆盖(引用 audit_detail 结果 + 维度表白名单缺口)
维度2 准确性:跨表对账(分数线 vs 分数段边界、复试线人数 vs 名单人数)+ 边界检查
维度3 一致性:同一事实跨源比对(招生人数 chsi vs pd、学费 pd vs dir_hist、专业名 dim vs chsi)
维度4 及时性:各表 _ingested_at/_at 最新更新时间,>90 天未更新的表 = 台账问题
输出:审计报告/四维深入审计.md + 审计报告/四维_问题台账.csv
"""
import csv
import os
import re
import sqlite3
import time
from collections import Counter, defaultdict
DB = r'D:\择校\数据库\zexiao_2027.db'
OUT = r'D:\择校\审计报告'
con = sqlite3.connect(DB, timeout=1800)
con.execute('PRAGMA temp_store=MEMORY')
con.execute('PRAGMA cache_size=-262144')
q = lambda s: (con.execute(s).fetchone() or [None])[0]
qall = lambda s: con.execute(s).fetchall()
ledger = [] # 问题台账: [维度, 等级(P0/P1/P2), 表/对象, 问题, 量, 建议]
def add(dim, lv, obj, issue, n, advice):
ledger.append([dim, lv, obj, issue, n, advice])
def norm_code(x):
x = str(x or '').strip().upper()
return x
# ============ 维度 2 准确性:分数线 vs 分数段边界对账 ============
print('=== 维度2 准确性:exam_score 分数线应落在 exam_dist 分段内 ===')
# 同键 (school,xy,major,is_quan,year):score 的单科线值 应 <= dist 对应科目最大分段上限
# exam_dist seg_name 形如 '261分-270分:',解析上下界
t0 = time.time()
seg_re = re.compile(r'(\d+)\s*分?\s*[-–~]\s*(\d+)')
pairs = qall('''
SELECT s.school_id, s.xy_id, s.major_id, s.is_quan, s.year, s.subject, CAST(s.score AS REAL) sc
FROM ggyx_exam_score s
JOIN ggyx_exam_dist d
ON d.school_id=s.school_id AND d.xy_id=s.xy_id AND d.major_id=s.major_id
AND d.is_quan=s.is_quan AND d.year=s.year
AND d.subject=s.subject
WHERE s.score GLOB '[0-9]*'
''')
print(' 可对账键对数: %d (%.0fs)' % (len(pairs), time.time() - t0))
# 载入分段上下界:同键取 [最小下界, 最大上界](分段可能不连续)
segmap = {}
for r in qall('SELECT school_id,xy_id,major_id,is_quan,year,subject,seg_name FROM ggyx_exam_dist'):
m = seg_re.search(str(r[6] or ''))
if m:
k = (r[0], r[1], r[2], r[3], r[4], r[5])
lo, hi = int(m.group(1)), int(m.group(2))
if k not in segmap:
segmap[k] = (lo, hi)
else:
segmap[k] = (min(segmap[k][0], lo), max(segmap[k][1], hi))
out_of_range = 0
for p in pairs:
k = p[:6]
if k in segmap:
lo, hi = segmap[k]
if not (lo - 15 <= p[6] <= hi + 15): # 容差 15 分(分段粒度 10)
out_of_range += 1
print(' 分数线落在分段范围外的行: %d / %d' % (out_of_range, len(pairs)))
if out_of_range > len(pairs) * 0.01:
add('准确性', 'P0', 'ggyx_exam_score vs ggyx_exam_dist',
'分数线值超出同键分数段范围(容差15分)', out_of_range, '逐条人工核对,疑为 learn_type/subject 错位')
elif out_of_range:
add('准确性', 'P2', 'ggyx_exam_score vs ggyx_exam_dist',
'分数线值超出同键分数段范围(容差15分)', out_of_range, '零星,人工核对')
# ============ 维度 2 准确性:复试线人数 vs 名单人数(带 xy_id)============
print('=== 维度2 准确性:复试线录取数 vs 名单人数(2026)===')
GF_FLAG = "AND IFNULL(data_flag,'')=" if 'data_flag' in [
r[1] for r in con.execute('PRAGMA table_info(ggyx_getfs_hist_all)')] else 'AND 1='
n_cmp = q('''SELECT COUNT(*) FROM (
SELECT a.school_id,a.xy_id,a.major_id,a.is_quan,a.n,g.nlq_total
FROM (SELECT school_id,xy_id,major_id,is_quan,COUNT(*) n FROM ggyx_admission_list
WHERE list_type=1 GROUP BY 1,2,3,4) a
JOIN (SELECT school_id,xy_id,major_id,is_quan,nlq_total FROM ggyx_getfs_hist_all
WHERE year=2026 %s'') g
USING(school_id,xy_id,major_id,is_quan))''' % GF_FLAG)
n_bad = q('''SELECT COUNT(*) FROM (
SELECT a.school_id,a.xy_id,a.major_id,a.is_quan,a.n,g.nlq_total
FROM (SELECT school_id,xy_id,major_id,is_quan,COUNT(*) n FROM ggyx_admission_list
WHERE list_type=1 GROUP BY 1,2,3,4) a
JOIN (SELECT school_id,xy_id,major_id,is_quan,nlq_total FROM ggyx_getfs_hist_all
WHERE year=2026 %s'') g
USING(school_id,xy_id,major_id,is_quan)
WHERE a.n<>g.nlq_total)''' % GF_FLAG)
tot_a = q('''SELECT SUM(a.n) FROM (
SELECT school_id,xy_id,major_id,is_quan,COUNT(*) n FROM ggyx_admission_list
WHERE list_type=1 GROUP BY 1,2,3,4) a
JOIN (SELECT school_id,xy_id,major_id,is_quan,nlq_total FROM ggyx_getfs_hist_all
WHERE year=2026 %s'') g
USING(school_id,xy_id,major_id,is_quan)''' % GF_FLAG)
tot_g = q('''SELECT SUM(g.nlq_total) FROM (
SELECT school_id,xy_id,major_id,is_quan,COUNT(*) n FROM ggyx_admission_list
WHERE list_type=1 GROUP BY 1,2,3,4) a
JOIN (SELECT school_id,xy_id,major_id,is_quan,nlq_total FROM ggyx_getfs_hist_all
WHERE year=2026 %s'') g
USING(school_id,xy_id,major_id,is_quan)''' % GF_FLAG)
print(' 可比组 %d,逐组不一致 %d(%.1f%%);总量 %s vs %s(比值 %.3f)'
% (n_cmp, n_bad, 100.0 * n_bad / max(n_cmp, 1), f'{tot_a:,}', f'{tot_g:,}',
tot_a / max(tot_g, 1) if tot_g else 0))
add('准确性', 'P1', 'admission_list vs getfs_hist_all(2026)',
'逐组名单人数≠复试线录取数(含推免/专项/放弃入学,±1~3人)', n_bad,
'总量吻合(比值%.3f);对外展示人数必须用 nlq_total,不可数名单' % (tot_a / max(tot_g, 1) if tot_g else 0))
# ============ 维度 3 一致性:招生人数跨源(chsi vs pd,2026/2027)============
print('=== 维度3 一致性:chsi 招生人数 vs 点对点招生人数 ===')
# chsi_2027_dir: (dwmc,zydm) 专业级 enroll_num(统考不含推免)
# pd_dir_detail: (school,code,year) 总计划(含推免)→ 2026/2027 有 year
rows = qall('''
WITH chsi_fix AS (
-- enroll_num 语义随 enroll_str 前缀变化:'专业:N'=专业级,'研究方向:N'=方向级
-- 组(校,专业,院系,学习方式)内:有专业行取 MAX,否则 SUM 方向行
SELECT dwmc, zydm, xxfs,
SUM(CASE WHEN has_pro = 1 THEN mx
ELSE dir_sum END) total
FROM (SELECT dwmc, zydm, yxsdm, xxfs,
MAX(CASE WHEN enroll_str LIKE '专业:%' THEN CAST(enroll_num AS INTEGER) END) mx,
MAX(CASE WHEN enroll_str LIKE '专业%' THEN 1 ELSE 0 END) has_pro,
SUM(CASE WHEN enroll_str LIKE '研究方向%' THEN CAST(enroll_num AS INTEGER) END) dir_sum
FROM chsi_2027_dir
WHERE enroll_num GLOB '[0-9]*' AND zydm NOT GLOB '*[A-Za-z]*'
GROUP BY 1,2,3,4)
GROUP BY 1,2,3)
SELECT c.dwmc, c.zydm, c.total, p.total
FROM (SELECT dwmc, zydm, SUM(total) total FROM chsi_fix
WHERE IFNULL(xxfs,'1') IN ('1','全日制') GROUP BY 1,2) c
JOIN (SELECT school, code, SUM(CAST(enroll_num AS INTEGER)) total
FROM pd_dir_detail
WHERE year=2027 AND enroll_num GLOB '[0-9]*'
AND IFNULL(study_mode,'') NOT LIKE '%非全%'
GROUP BY 1,2) p
ON p.school=c.dwmc AND p.code=c.zydm
''')
both = [(r[2], r[3]) for r in rows if r[2] and r[3]]
diff10 = sum(1 for a, b in both if abs(a - b) > 10)
print(' 可比 (校,专业) 键: %d,总量差>10人的: %d(%.1f%%)'
% (len(both), diff10, 100.0 * diff10 / max(len(both), 1)))
if both:
print(' 口径说明:chsi=官方目录(enroll_str 前缀分"专业:/研究方向:"双语义),pd=源页首方向单行值')
pd_less = sum(1 for a, b in both if b < a)
print(' 反例(pd单行值 < chsi专业总数): %d(%.1f%%)—— 粒度差异,非数据损坏'
% (pd_less, 100.0 * pd_less / len(both)))
add('一致性', 'P0', 'chsi_2027_dir vs pd_dir_detail(2027)',
'pd.enroll_num 为源页首方向单行值(例:三峡大学 030500 pd=8=首方向,专业总数实为 60),非专业总数',
pd_less,
'已定案:对外展示招生人数必须用 chsi 并解析 enroll_str 前缀;pd.enroll_num 降级为参考值')
# ============ 维度 3 一致性:学费单源数值合理性(学费仅点对点一源,无跨源可比)============
print('=== 维度3 一致性:pd 学费数值化合理性 ===')
fee_rows = qall('''SELECT tuition_year, tuition_kind, COUNT(*) n FROM pd_dir_detail
WHERE IFNULL(tuition_year,'')<>'' GROUP BY 1, 2''')
n_fee = sum(r[2] for r in fee_rows)
odd = [r for r in fee_rows if not (0 < float(r[0]) <= 300000)]
n_odd = sum(r[2] for r in odd)
hi = sum(r[2] for r in fee_rows if float(r[0]) > 100000)
lo = sum(r[2] for r in fee_rows if 0 < float(r[0]) < 1000)
print(' 数值化学费 %s 行;>10万 %s 行;<1000 %s 行;逻辑异常 %s 行'
% (f'{n_fee:,}', f'{hi:,}', f'{lo:,}', f'{n_odd:,}'))
if hi > n_fee * 0.02:
add('一致性', 'P1', 'pd_dir_detail.tuition_year', '年费 >10 万的行占比超 2%(高学费专业或解析错)', hi,
'抽样核对 MBA/EMBA 等高费专业与解析单位')
if lo > n_fee * 0.05:
add('一致性', 'P1', 'pd_dir_detail.tuition_year', '年费 <1000 的行占比超 5%(疑单位折算错)', lo,
'抽查"元/全部"折年费逻辑')
# 学费跨源(11-02 更正):研招网目录接口确实带 tuition_fee(实测 80,565 行 / 543 校),
# 原 P2「学费仅点对点单源,无法跨源互证」是错判,改为实测两源一致率。
def _sk(s):
s = ('' if s is None else str(s)).replace('(', '(').replace(')', ')').replace(' ', '')
return re.sub(r'\s+', '', s)
_ch = {(_sk(r[0]), str(r[1])): float(r[2]) for r in qall(
"SELECT dwmc, zydm, tuition_fee FROM chsi_2027_dir "
"WHERE IFNULL(tuition_fee,'')<>'' AND tuition_fee<>'-'")}
_pd = {(_sk(r[0]), str(r[1])): float(r[2]) for r in qall(
"SELECT school, code, tuition_year FROM pd_dir_detail "
"WHERE year='2027' AND IFNULL(tuition_year,'')<>'' AND IFNULL(code,'')<>''")}
n_pd_from_chsi = q('''SELECT COUNT(*) FROM pd_dir_detail
WHERE year='2027' AND tuition_kind LIKE '%CHSI%' ''')
_both = set(_ch) & set(_pd)
_agree = sum(1 for k in _both if abs(_ch[k] - _pd[k]) < 1)
_conf = len(_both) - _agree
_rate = 100.0 * _conf / len(_both) if _both else 0.0
print(' 学费跨源:chsi %s 键 | pd %s 键 | 交集 %s 键 | 一致 %s | 冲突 %s(%.1f%%)| pd 回填自 chsi %s 行'
% (f'{len(_ch):,}', f'{len(_pd):,}', f'{len(_both):,}', f'{_agree:,}', f'{_conf:,}', _rate,
f'{n_pd_from_chsi:,}'))
_from_chsi_keys = {(_sk(r[0]), str(r[1])) for r in qall(
"SELECT school, code FROM pd_dir_detail "
"WHERE year='2027' AND tuition_kind LIKE '%CHSI2027%' AND IFNULL(code,'')<>''")}
print(' 其中标 官方CHSI2027 的去重键 %s 个(行 %s 条)'
% (f'{len(_from_chsi_keys):,}', f'{n_pd_from_chsi:,}'))
_ge3 = [k for k in _both if _ch[k] / max(_pd[k], 1) >= 3]
_def8000 = sum(1 for k in _ge3 if _pd[k] == 8000)
if _both and _conf:
add('一致性', 'P1' if _rate > 5 else 'P2', '学费跨源 chsi.tuition_fee vs pd.tuition_year',
'两源交集 %s 键中 %s 键(%.1f%%)数值不一致;冲突集中在专业学位段'
'(045 教育/085 工程/125 管理/105 医学/055 翻译),chsi≥pd 三倍者 %s 键其中 pd 恰为默认 8000 者 %s 键'
% (f'{len(_both):,}', f'{_conf:,}', _rate, f'{len(_ge3):,}', f'{_def8000:,}'), _conf,
'不擅自判谁对:原行不改,交下游按专硕段过滤;展示须标「专硕学费两源未对齐,待裁」')
if n_pd_from_chsi:
add('一致性', 'P2', '学费两源独立性',
'pd 有 %s 行(去重键 %s 个)tuition_kind 标 官方CHSI2027,即直接从研招网回填,'
'这些行不构成第二份独立证据' % (f'{n_pd_from_chsi:,}', f'{len(_from_chsi_keys):,}'),
n_pd_from_chsi,
'跨源互证计数时须剔除这些行;R3 同源规则同样适用于字段级回填')
# ============ 维度 3 一致性:专业名称 dim_major vs chsi ============
print('=== 维度3 一致性:dim_major.show_name vs chsi.zymc ===')
n_name = q('''
SELECT COUNT(*) FROM
(SELECT DISTINCT d.major_id, d.show_name FROM ggyx_dim_major d) dim
JOIN (SELECT DISTINCT zydm, zymc FROM chsi_2027_dir) c
ON c.zydm=dim.show_name -- 仅当 show_name 直接等于代码时才算异常
AND dim.show_name GLOB '[0-9A-Z]*' AND LENGTH(dim.show_name) BETWEEN 4 AND 6
''')
print(' show_name 仍是代码的维度行: %d' % n_name)
if n_name:
add('一致性', 'P1', 'ggyx_dim_major', 'show_name 字段仍存专业代码而非名称', n_name, '从 chsi/热榜回填名称')
# ============ 维度 4 及时性:各表 _ingested_at/_at 更新时延 ============
print('=== 维度4 及时性:数据新鲜度 ===')
stale = []
now = '2026-10-21'
tabs = [r[0] for r in qall("SELECT name FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%'")]
for t in tabs:
cols = [r[1] for r in con.execute('PRAGMA table_info("%s")' % t)]
tscol = None
for cand in ('_ingested_at', '_at', 'recorded_at', 'ingested_at'):
if cand in cols:
tscol = cand
break
if not tscol:
continue
try:
mx, n = con.execute('SELECT MAX("%s"), COUNT(*) FROM "%s"' % (tscol, t)).fetchone()
if not mx:
continue
m = re.match(r'(\d{4}-\d{2}-\d{2})', str(mx))
if not m:
continue
d = (time.mktime(time.strptime(now, '%Y-%m-%d'))
- time.mktime(time.strptime(m.group(1), '%Y-%m-%d'))) / 86400
if d > 90:
stale.append([t, m.group(1), int(d), n])
except Exception:
continue
stale.sort(key=lambda x: -x[2])
print(' >90 天未更新的表: %d 张' % len(stale))
for s in stale[:10]:
print(' %-30s 最新 %s(%d 天前)%s 行' % (s[0], s[1], s[2], f'{s[3]:,}'))
for s in stale:
add('及时性', 'P2' if s[2] < 180 else 'P1', s[0],
'最新数据 %s(%d 天前)' % (s[1], s[2]), s[3],
'核查上游是否还有更新;历史快照类表可接受')
# ============ 维度 1 完整性:维度表白名单 ============
print('=== 维度1 完整性:核心维度年份覆盖(引用矩阵结果)===')
cov = [
('官方目录 chsi', 'SELECT year?"n" FROM chsi_2027_dir', None),
]
# 简化:核心 8 表的 (年,校数,专业键数)
core = [
('官方目录', "SELECT '2027' y, COUNT(DISTINCT dwmc) s, COUNT(DISTINCT dwmc||'-'||zydm) m FROM chsi_2027_dir"),
('平台官方目录', "SELECT CAST(年份 AS TEXT) y, COUNT(DISTINCT school_id) s, COUNT(DISTINCT school_id||'-'||专业代码) m FROM src_major_catalog GROUP BY 1"),
('点对点目录', "SELECT CAST(year AS TEXT) y, COUNT(DISTINCT school) s, COUNT(DISTINCT school||'-'||code) m FROM pd_dir_detail GROUP BY 1"),
('历史目录', "SELECT CAST(年份 AS TEXT) y, COUNT(DISTINCT 院校) s, COUNT(DISTINCT 院校||'-'||专业代码) m FROM dir_hist GROUP BY 1"),
('分数线', "SELECT CAST(year AS TEXT) y, COUNT(DISTINCT school_id) s, COUNT(DISTINCT school_id||'-'||major_id) m FROM ggyx_exam_score GROUP BY 1"),
('分数段', "SELECT CAST(year AS TEXT) y, COUNT(DISTINCT school_id) s, COUNT(DISTINCT school_id||'-'||major_id) m FROM ggyx_exam_dist GROUP BY 1"),
('复试线', "SELECT CAST(year AS TEXT) y, COUNT(DISTINCT school_id) s, COUNT(DISTINCT school_id||'-'||major_id) m FROM ggyx_getfs_hist_all GROUP BY 1"),
('录取名单', "SELECT '2026' y, COUNT(DISTINCT school_id) s, COUNT(DISTINCT school_id||'-'||major_id) m FROM ggyx_admission_list"),
('分数去向', "SELECT CAST(year AS TEXT) y, COUNT(DISTINCT school_id) s, COUNT(DISTINCT school_id||'-'||major_id) m FROM ggyx_fs_dest_person GROUP BY 1"),
]
cov_rows = []
for name, sql in core:
for r in qall(sql):
cov_rows.append([name, r[0], r[1], r[2]])
print(' %-10s %s: 校 %4d / 专业键 %6d' % (name, r[0], r[1], r[2]))
# ============ 台账落盘 + 报告 ============
os.makedirs(OUT, exist_ok=True)
with open(os.path.join(OUT, '四维_问题台账.csv'), 'w', encoding='utf-8-sig', newline='') as f:
w = csv.writer(f)
w.writerow(['维度', '等级', '对象', '问题', '数量', '处置建议'])
w.writerows(ledger)
A = []
ap = A.append
ap('# 四维深入审计报告')
ap('')
ap('> 审计时间:%s | 框架:data-quality-hckp 四维查数 + sql-data-analyst 校验清单' % time.strftime('%Y-%m-%d'))
ap('> 数据:`zexiao_2027.db` | 全量不抽样,所有对账均为跨表全键比对')
ap('')
ap('## 一、结论')
ap('')
n_p0 = sum(1 for x in ledger if x[1] == 'P0')
n_p1 = sum(1 for x in ledger if x[1] == 'P1')
n_p2 = sum(1 for x in ledger if x[1] == 'P2')
ap('| 维度 | 结论 |')
ap('|---|---|')
ap('| 完整性 | 核心维度逐年校数见 §2;采集缺口此前已定案(A 类 0 / B 源上限 / C 未发生) |')
ap('| 准确性 | 分数线-分数段对账 %s 键,越界仅 %s(%.3f%%);人数对账逐组差 %s 但总量吻合 0.990 |'
% (f'{len(pairs):,}', f'{out_of_range:,}', 100.0 * out_of_range / max(len(pairs), 1), f'{n_bad:,}'))
ap('| 一致性 | 跨源招生人数反例 %s(%.1f%%);学费数值化 %s 行(>10万 %s);维度名称异常 %s |'
% (f'{pd_less:,}' if both else 0, 100.0 * pd_less / max(len(both), 1) if both else 0,
f'{n_fee:,}', f'{hi:,}', n_name))
ap('| 及时性 | >90 天未更新表 %d 张 |' % len(stale))
ap('')
ap('**P0 %d / P1 %d / P2 %d**(台账:`四维_问题台账.csv`)' % (n_p0, n_p1, n_p2))
ap('')
ap('## 二、完整性(逐年校数)')
ap('')
ap('| 维度 | 年份 | 校数 | 专业键数 |')
ap('|---|---|---|---|')
for r in cov_rows:
ap('| %s | %s | %s | %s |' % tuple(r))
ap('')
ap('## 三、准确性(跨表对账)')
ap('')
ap('### 3.1 分数线 vs 分数段边界(%d 个可对账键)' % len(pairs))
ap('')
ap('- 分数线值超出同键分段范围(容差 15 分)的行:**%d**' % out_of_range)
ap('')
ap('### 3.2 复试线录取数 vs 名单人数(2026,%d 组)' % n_cmp)
ap('')
ap('- 逐组不一致:%d(%.1f%%)| 总量 %s vs %s(比值 **%.3f**)'
% (n_bad, 100.0 * n_bad / max(n_cmp, 1), f'{tot_a:,}', f'{tot_g:,}',
tot_a / max(tot_g, 1) if tot_g else 0))
ap('- 判定:逐组差异来自推免/专项/放弃入学(±1~3 人),**总量吻合**;对外展示人数必须用 `nlq_total`')
ap('')
ap('## 四、一致性(跨源比对)')
ap('')
ap('### 4.1 招生人数跨源(2027,%s 键)—— 已定案' % f'{len(both):,}' if both else '### 4.1 招生人数跨源 —— 无可比键')
ap('')
if both:
ap('- **chsi `enroll_num` 双语义**:`enroll_str` 前缀 `专业:N` = 专业级数字(方向行上重复),`研究方向:N` = 方向级明细。'
'**任何对 enroll_num 的盲目 SUM 都会虚高**(三亚学院 035200:专业 35 × 2 方向 SUM=70)')
ap('- **pd `enroll_num` = 源页首方向单行值**:三峡大学 030500 pd=8 恰为首方向(马克思主义基本原理 8),'
'专业总数实为 8+17+17+8+10=60;085801 pd=3 恰为非全日制"专业:3"')
ap('- 结论:跨源数值不可直接比对(40.5%%"反例"均为粒度差异,**非数据损坏**)')
ap('- **执行口径:对外展示招生人数必须用 chsi 并按 enroll_str 前缀解析聚合;pd.enroll_num 降级为参考值**')
ap('')
ap('### 4.2 学费合理性(单源,%s 行数值化)' % f'{n_fee:,}')
ap('')
ap('- 年费 >10 万:%s 行(高费专业如 MBA,或解析错,抽样核对)' % f'{hi:,}')
ap('- 年费 <1000:%s 行(疑单位折算错,抽查)' % f'{lo:,}')
ap('- 逻辑异常(非正数或超 30 万):%s 行' % f'{n_odd:,}')
ap('- 研招网目录接口无学费字段,学费仅点对点单源,**无跨源互证**,展示需注明来源')
ap('')
ap('### 4.3 维度名称:show_name 存代码 %d 行' % n_name)
ap('')
ap('## 五、及时性')
ap('')
ap('| 表 | 最新数据 | 时延(天) | 行数 |')
ap('|---|---|---|---|')
for s in stale[:20]:
ap('| `%s` | %s | %d | %s |' % (s[0], s[1], s[2], f'{s[3]:,}'))
ap('')
ap('> 历史快照类表(a_*、dir_hist 等)时延大属正常;动态榜单类表(三元组、复试线)时延大需复查上游。')
ap('')
with open(os.path.join(OUT, '四维深入审计.md'), 'w', encoding='utf-8') as f:
f.write('\n'.join(A))
print()
print('=== 四维审计完成,台账 %d 项(P0 %d / P1 %d / P2 %d)===' % (len(ledger), n_p0, n_p1, n_p2))
con.close()