从编程小白到自动生成代码，我只用了aipy的三个功能

import os
import requests
from bs4 import BeautifulSoup
import pandas as pd
from datetime import datetime
import sys
import re
 
# 设置headers模拟浏览器访问
headers = {
    'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/125.0.0.0 Safari/537.36',
    'Cookie': 'SUB=_2AkMSIQmYf8NxqwFRmP4dyWjjaIh1zATEieKl5U9gJRMxHRl-yT9jqmYgtRB6PwLPGHJhQx7L10D0aVM0XW7NCQCLcyjZ;'
}
 
def clean_heat_value(heat_str):
    """清理热度值，提取数字部分"""
    if not heat_str:
        return "0"
    # 提取数字部分
    numbers = re.findall(r'\d+', heat_str)
    return numbers[0] if numbers else "0"
 
try:
    # 获取微博热搜页面
    print("正在获取微博热搜数据...")
    url = "https://s.weibo.com/top/summary?cate=realtimehot"
    response = requests.get(url, headers=headers, timeout=10)
    response.raise_for_status()
    
    # 解析HTML
    soup = BeautifulSoup(response.text, 'html.parser')
    
    # 查找热搜列表
    hot_elements = soup.select('div.data tbody tr') or soup.select('div[class^="data"] tbody tr')
    if not hot_elements:
        raise ValueError("无法定位热搜列表元素")
    
    # 提取前10条数据
    hot_items = []
    for i, item in enumerate(hot_elements[:10], 1):
        try:
            title_tag = item.select_one('td[class$="02"] a')
            if not title_tag:
                continue
                
            title = title_tag.text.strip()
            link = "https://s.weibo.com" + title_tag['href'] if not title_tag['href'].startswith('javascript') else "无效链接"
            count_tag = item.select_one('td[class$="02"] span')
            count = clean_heat_value(count_tag.text if count_tag else "0")
            
            hot_items.append({
                '排名': i,
                '标题': title,
                '热度': count,
                '链接': link
            })
        except Exception as e:
            print(f"处理第{i}条热搜时出错: {str(e)}", file=sys.stderr)
            continue
    
    if not hot_items:
        raise ValueError("未能提取任何热搜数据")
    
    # 转换为DataFrame并保存为CSV
    df = pd.DataFrame(hot_items)
    desktop_path = os.path.join(os.path.expanduser('~'), 'Desktop')
    filename = f"微博热搜_优化版_{datetime.now().strftime('%Y%m%d_%H%M%S')}.csv"
    save_path = os.path.join(desktop_path, filename)
    
    # 保存为CSV文件
    df.to_csv(save_path, index=False, encoding='utf_8_sig')
    print(f"优化后的热搜数据已保存到: {save_path}")
    print("\n优化后的热搜数据预览:")
    print(df.to_string(index=False))
    
    __result__ = {
        'status': 'success',
        'data': hot_items,
        'save_path': save_path,
        'file_type': 'csv'
    }
    
except Exception as e:
    print(f"程序运行出错: {str(e)}", file=sys.stderr)
    __result__ = {'status': 'error', 'message': str(e)}