#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""读取 2026 满意度问卷（按选项文本）结构 + 核心统计，用于核对报告数字。"""
import sys
import pandas as pd

P = ('/Users/liuxinyuan/.hermes/profiles/zone-b/cache/documents/'
     'doc_3f5eafe34e61_宝锐生物客户满意度调查问卷-2026（按选项文本）-全部.xlsx')

x = pd.ExcelFile(P)
print('=== Sheet 列表 ===')
for s in x.sheet_names:
    d = x.parse(s, nrows=3)
    print('  %-24s 前3行×%d列' % (s, d.shape[1]))

d = x.parse(x.sheet_names[0])
print()
print('=== 主 Sheet ===', x.sheet_names[0])
print('  形状:', d.shape)
print('  列名（前 30）:')
for i, c in enumerate(d.columns[:30]):
    print('    [%3d] %s' % (i, str(c)[:78]))
print()
print('  列名（30 之后，抽样）:')
for i, c in enumerate(d.columns[30:60], start=30):
    print('    [%3d] %s' % (i, str(c)[:78]))