科技项目

# 1. 不重复随机整数 — 控制抽题编号
def Random_num(num_max, num_qty):
    num_list = []
    while len(num_list) < num_qty:
        num = random.randint(2, num_max)
        if num not in num_list:
            num_list.append(num)
    return num_list

# 2. 按编号从 Excel 题库抽取 4 类题型
def Question(que_type, numbers):
    questions, wb = [], load_workbook("题库.xlsx")
    ws = wb[que_type]
    for i in numbers:
        q = ws["B"+str(i)].value       # 题干
        right = ws["G"+str(i)].value   # 正确答案
        questions.append([q, "A："+a, ..., right])
    return questions

# 3. 主循环 — 一次生成 20 套试卷 + 20 份答案
for number in range(1, 21):
    n1 = Random_num(566, 40)  # 单选
    n2 = Random_num(196, 20)  # 多选
    n3 = Random_num(418, 10)  # 判断
    n4 = Random_num(190, 10)  # 填空
    To_word(number, questions_data)
    Answer(number, questions_data)

# 1. 启动浏览器时开启 API 监听 — 只抓搜索接口
page = ChromiumPage()
page.listen.start(
    "https://so.xiaohongshu.com/api/sns/web/v2/search/notes",
    method='POST'
)
page.get(f"https://www.xiaohongshu.com/search_result_ai?keyword={kw}")

# 2. 循环 20 次滚动加载 — 触发页面懒加载
for i in range(20):
    page.scroll.to_bottom()
    time.sleep(1)
    res = page.listen.wait()          # 监听返回抓包内容
    items = res.response.body['data']['items']

# 3. 字段提取 + CSV 落地 — 9 个维度
allData.append([id, token, title, name, avatar,
                liked_count, collected_count,
                comment_count, shared_count])
cf.writerow(['id','token','标题','name','头像',
             '点赞','收藏','评论','分享'])

# 1. 中文站名 → 12306 英文代码映射
from stations import stations
from_station = stations.get(arguments['<from>'])  # 北京 → BJP
to_station   = stations.get(arguments['<to>'])    # 上海 → SHH
url = "https://kyfw.12306.cn/otn/leftTicket/query?..."

# 2. 接口字段解析 — result 以 | 分隔，按固定下标取值
for item in available_trains['result']:
    item = item.split('|')
    train_no  = item[3]     # 车次号
    departure = item[8]     # 出发时间
    arrival   = item[9]     # 到达时间
    yd = item[-4]            # 一等座
    ed = item[-3]            # 二等座

# 3. PrettyTable + Colorama 彩色表格
pt = PrettyTable()
pt._set_field_names(header = ['车次','起始站','终点站',
                              '出发时间','到达时间','历时',
                              '一等座','二等座','软卧',
                              '硬卧','硬座','无座'])
for train in self.train:
    pt.add_row([self._color_print(start, Fore.MAGENTA),
                self._color_print(end,   Fore.GREEN), ...])