痛点：每周要合并10个部门的Excel报表，手动复制粘贴要2小时，眼睛都看花了。

import pandas as pd
import os
from datetime import datetime

def merge_reports(folder_path, output_file):
    """合并指定文件夹下所有Excel报表"""
    all_data = []
    
    for file in os.listdir(folder_path):
        if file.endswith('.xlsx'):
            df = pd.read_excel(os.path.join(folder_path, file))
            all_data.append(df)
    
    merged = pd.concat(all_data, ignore_index=True)
    merged.to_excel(output_file, index=False)
    print(f"已合并 {len(all_data)} 份报表，保存至 {output_file}")

# 使用示例
merge_reports('./周报', '本周汇总.xlsx')

✅ 实测效果：2小时 → 5分钟

我现在的周五下午茶时间就是这么来的

痛点：给客户发邮件要个性化称呼、附上不同附件，一个一个发太折磨人了。

import smtplib
import pandas as pd
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart

def batch_send_email(excel_path, subject, body_template):
    """批量发送个性化邮件"""
    contacts = pd.read_excel(excel_path)
    
    for _, row in contacts.iterrows():
        name = row['姓名']
        email = row['邮箱']
        body = body_template.format(姓名=name)
        
        msg = MIMEMultipart()
        msg['From'] = 'your_email@example.com'
        msg['To'] = email
        msg['Subject'] = subject
        msg.attach(MIMEText(body, 'html'))
        
        # 发送邮件...
        print(f"已发送给: {name} <{email}>")

batch_send_email('客户列表.xlsx', '您的月度报告', '您好 {姓名}，附件是您的报告...')

✅ 实测效果：100封邮件从3小时压缩到10分钟

而且不会漏发、不会搞错附件

痛点：下载文件夹永远乱糟糟的，每次找文件要翻半天。

import os
import shutil

def organize_downloads(download_folder):
    """自动整理下载文件夹"""
    rules = {
        '文档': ['.pdf', '.docx', '.txt', '.pptx'],
        '图片': ['.jpg', '.jpeg', '.png', '.gif'],
        '视频': ['.mp4', '.avi', '.mov'],
        '压缩包': ['.zip', '.rar', '.7z'],
        '代码': ['.py', '.js', '.html']
    }
    
    for folder, extensions in rules.items():
        folder_path = os.path.join(download_folder, folder)
        if not os.path.exists(folder_path):
            os.makedirs(folder_path)
    
    for filename in os.listdir(download_folder):
        file_path = os.path.join(download_folder, filename)
        if os.path.isdir(file_path):
            continue
        
        ext = os.path.splitext(filename)[1].lower()
        for folder_name, extensions in rules.items():
            if ext in extensions:
                dest = os.path.join(download_folder, folder_name, filename)
                shutil.move(file_path, dest)
                print(f"移动: {filename} → {folder_name}/")
                break

organize_downloads('C:/Users/Downloads')

✅ 实测效果：文件夹终于清爽了

每天找文件快多了

痛点：每月要给领导做数据分析PPT，要从数据库拉数据、做图表、排版，至少半天。

import pandas as pd
import matplotlib.pyplot as plt
from pptx import Presentation
import sqlite3

def generate_monthly_report():
    """自动生成月度数据报告"""
    # 1. 从数据库拉取数据
    conn = sqlite3.connect('sales.db')
    df = pd.read_sql('SELECT * FROM orders', conn)
    conn.close()
    
    # 2. 数据分析
    sales_by_region = df.groupby('region')['amount'].sum()
    sales_by_product = df.groupby('product')['amount'].sum()
    
    # 3. 生成图表
    fig, axes = plt.subplots(1, 2, figsize=(12, 5))
    sales_by_region.plot(kind='bar', ax=axes[0], color='steelblue')
    sales_by_product.plot(kind='pie', ax=axes[1], autopct='%1.1f%%')
    plt.tight_layout()
    plt.savefig('chart.png', dpi=150)
    
    # 4. 创建PPT
    prs = Presentation()
    slide = prs.slides.add_slide(prs.slide_layouts[6])
    slide.shapes.add_picture('chart.png', 100, 150)
    prs.save('月度报告.pptx')
    print("报告已生成: 月度报告.pptx")

generate_monthly_report()

✅ 实测效果：原来半天的工作量，现在20分钟搞定

还能一键更新最新数据

痛点：开了很多会，录音整理成文字后，手动分段、提炼要点太费时间。

import re

def parse_meeting_notes(raw_text):
    """自动整理会议纪要"""
    lines = raw_text.strip().split('\n')
    meetings = []
    current = []
    
    for line in lines:
        # 检测新会议开始
        if re.match(r'\d{4}-\d{2}-\d{2}', line):
            if current:
                meetings.append('\n'.join(current))
            current = [line]
        else:
            current.append(line)
    
    # 提取待办事项
    todos = []
    keywords = []
    todo_pattern = r'[（(]?(待办|TODO|ACTION)[:：]?\s*(.+)'
    keyword_pattern = r'#(\w+)'
    
    for meeting in '\n'.join(meetings + [current]):
        for line in meeting.split('\n'):
            if re.search(todo_pattern, line):
                todos.append(re.search(todo_pattern, line).group(2))
            keywords.extend(re.findall(keyword_pattern, line))
    
    return {'会议数量': len(meetings), '待办': todos, '关键词': list(set(keywords))}

result = parse_meeting_notes(raw)
print(f"待办事项: {result['待办']}")

✅ 实测效果：整理一周会议记录从1小时缩短到5分钟

待办事项一目了然