python
pip install pandas smtplib python-docx requests -i https://mirrors.aliyun.com/pypi/simple/

python
import requests

def call_seed_llm(prompt):
    url = "https://seed.bytedance.com/api/v1/chat/completions"
    headers = {
        "Authorization": "Bearer 你的API密钥",
        "Content-Type": "application/json"
    }
    data = {
        "model": "seed-light-3.0",
        "messages": [{"role": "user", "content": prompt}],
        "temperature": 0.3  # 控制输出稳定性，0.3适合办公场景
    }
    response = requests.post(url, headers=headers, json=data, timeout=10)
    return response.json()["choices"][0]["message"]["content"]

python
import pandas as pd

def auto_sort_excel(file_path, save_path):
    # 读取表格文件
    df = pd.read_excel(file_path) if file_path.endswith(".xlsx") else pd.read_csv(file_path)
    
    # 1. 自动去重（以“电话”字段为核心去重）
    df = df.drop_duplicates(subset=["电话"], keep="first")
    
    # 2. 缺失值填充
    for col in df.columns:
        if df[col].dtype == "object":  # 文本型字段
            df[col] = df[col].fillna("无")
        else:  # 数值型字段
            df[col] = df[col].fillna(df[col].mean())
    
    # 3. 格式统一（日期格式、金额格式）
    if "日期" in df.columns:
        df["日期"] = pd.to_datetime(df["日期"], errors="coerce").dt.strftime("%Y-%m-%d")
    if "金额" in df.columns:
        df["金额"] = df["金额"].apply(lambda x: f"¥{x:.2f}")
    
    # 4. 生成新表格
    if save_path.endswith(".xlsx"):
        df.to_excel(save_path, index=False)
    else:
        df.to_csv(save_path, index=False, encoding="utf-8-sig")
    
    return f"表格整理完成，已保存至：{save_path}"

# 测试调用
result = auto_sort_excel("杂乱数据.xlsx", "整理后数据.xlsx")
print(result)

python
import smtplib
from email.mime.text import MIMEText
from email.header import Header
import pandas as pd

def batch_send_email(sender_email, sender_password, recipient_file, email_topic):
    # 读取收件人列表（Excel表格，包含“姓名”“邮箱”字段）
    df = pd.read_excel(recipient_file)
    recipients = list(zip(df["姓名"], df["邮箱"]))
    
    # 调用Seed大模型拟写邮件内容
    prompt = f"拟写一封{email_topic}的邮件，语气正式、简洁，适合职场场景，无需多余内容，正文控制在200字以内"
    email_content = call_seed_llm(prompt)
    
    # 配置邮箱服务器（QQ邮箱）
    smtp_server = "smtp.qq.com"
    smtp_port = 587
    
    # 批量发送邮件
    success_count = 0
    fail_count = 0
    log = []
    
    with smtplib.SMTP(smtp_server, smtp_port) as server:
        server.starttls()
        server.login(sender_email, sender_password)  # sender_password为QQ邮箱授权码
        
        for name, email in recipients:
            try:
                msg = MIMEText(email_content.replace("[姓名]", name), "plain", "utf-8")
                msg["From"] = Header(sender_email)
                msg["To"] = Header(email)
                msg["Subject"] = Header(email_topic)
                
                server.sendmail(sender_email, email, msg.as_string())
                success_count += 1
                log.append(f"发送成功：{email}")
            except Exception as e:
                fail_count += 1
                log.append(f"发送失败：{email}，原因：{str(e)}")
    
    # 生成发送日志
    with open("邮件发送日志.txt", "w", encoding="utf-8") as f:
        f.write(f"批量发送完成，成功：{success_count}封，失败：{fail_count}封\n")
        f.write("\n".join(log))
    
    return f"批量发送完成，成功：{success_count}封，失败：{fail_count}封，日志已保存至：邮件发送日志.txt"

# 测试调用（替换为自己的邮箱信息）
result = batch_send_email("你的QQ邮箱@qq.com", "你的邮箱授权码", "收件人列表.xlsx", "2026年2月部门会议通知")
print(result)

python
import os
from docx import Document
from PyPDF2 import PdfReader, PdfWriter

def convert_doc_format(input_folder, output_folder, target_format):
    # 创建输出文件夹（若不存在）
    if not os.path.exists(output_folder):
        os.makedirs(output_folder)
    
    success_count = 0
    fail_count = 0
    log = []
    
    # 遍历输入文件夹中的所有文档
    for filename in os.listdir(input_folder):
        input_path = os.path.join(input_folder, filename)
        file_name, file_ext = os.path.splitext(filename)
        
        try:
            # Word转PDF（借助虚拟打印机，简化版用docx2pdf库，需额外安装：pip install docx2pdf）
            if file_ext.lower() == ".docx" and target_format.lower() == "pdf":
                from docx2pdf import convert
                output_path = os.path.join(output_folder, f"{file_name}.pdf")
                convert(input_path, output_path)
            
            # PDF转TXT
            elif file_ext.lower() == ".pdf" and target_format.lower() == "txt":
                output_path = os.path.join(output_folder, f"{file_name}.txt")
                reader = PdfReader(input_path)
                content = ""
                for page in reader.pages:
                    content += page.extract_text()
                with open(output_path, "w", encoding="utf-8") as f:
                    f.write(content)
            
            # Word转TXT
            elif file_ext.lower() == ".docx" and target_format.lower() == "txt":
                output_path = os.path.join(output_folder, f"{file_name}.txt")
                doc = Document(input_path)
                content = "\n".join([para.text for para in doc.paragraphs])
                with open(output_path, "w", encoding="utf-8") as f:
                    f.write(content)
            
            success_count += 1
            log.append(f"转换成功：{filename} → {file_name}.{target_format}")
        except Exception as e:
            fail_count += 1
            log.append(f"转换失败：{filename}，原因：{str(e)}")
    
    # 生成转换日志
    with open(os.path.join(output_folder, "格式转换日志.txt"), "w", encoding="utf-8") as f:
        f.write(f"批量转换完成，成功：{success_count}个，失败：{fail_count}个\n")
        f.write("\n".join(log))
    
    return f"批量转换完成，成功：{success_count}个，失败：{fail_count}个，日志已保存至输出文件夹"

# 测试调用
result = convert_doc_format("需要转换的文档", "转换后的文档", "pdf")
print(result)