# 運(yùn)行環(huán)境：Python≥3.8
# pip install pandas openpyxl

import pandas as pd
import os

def merge_excels(folder_path, output_file):
    # 獲取文件夾下所有xlsx文件
    files = [f for f in os.listdir(folder_path) if f.endswith('.xlsx')]
    all_data = []
    
    print(f"發(fā)現(xiàn) {len(files)} 個(gè)文件，開始合并...")
    
    for file in files:
        file_path = os.path.join(folder_path, file)
        # 讀取數(shù)據(jù)，默認(rèn)讀取第一個(gè)sheet
        df = pd.read_excel(file_path)
        all_data.append(df)
        
    # 合并所有數(shù)據(jù)
    result = pd.concat(all_data, ignore_index=True)
    # 導(dǎo)出結(jié)果
    result.to_excel(output_file, index=False)
    print(f"合并完成！文件已保存為：{output_file}")

# 使用示例：將 'data' 文件夾下的所有表格合并
merge_excels('./data', '合并匯總.xlsx')

# 運(yùn)行環(huán)境：Python≥3.8
# pip install pandas openpyxl

import pandas as pd

def split_excel_by_column(file_path, column_name):
    # 讀取總表
    df = pd.read_excel(file_path)
    
    # 獲取該列所有唯一值（如所有部門名稱）
    unique_values = df[column_name].unique()
    
    for value in unique_values:
        # 篩選數(shù)據(jù)
        new_df = df[df[column_name] == value]
        # 保存為新文件
        filename = f"{value}_數(shù)據(jù).xlsx"
        new_df.to_excel(filename, index=False)
        print(f"已生成：{filename}")

# 使用示例：按 '部門' 列拆分 '總表.xlsx'
split_excel_by_column('總表.xlsx', '部門')

# 運(yùn)行環(huán)境：Python≥3.8
# pip install python-docx

from docx import Document

def batch_generate_contracts(template_path, data_dict):
    """
    data_dict: {'張三': '2023-10-01', '李四': '2023-10-02'}
    """
    for name, date in data_dict.items():
        doc = Document(template_path)
        
        # 遍歷所有段落進(jìn)行替換
        for paragraph in doc.paragraphs:
            if '{name}' in paragraph.text:
                paragraph.text = paragraph.text.replace('{name}', name)
            if '{date}' in paragraph.text:
                paragraph.text = paragraph.text.replace('{date}', date)
                
        file_name = f"合同_{name}.docx"
        doc.save(file_name)
        print(f"生成合同：{file_name}")

# 使用示例：模板中需用 {name} 和 {date} 占位
data = {'王小明': '2024-01-01', '趙鐵柱': '2024-01-05'}
batch_generate_contracts('合同模板.docx', data)

# 運(yùn)行環(huán)境：Windows, Python≥3.8
# pip install docx2pdf
from docx2pdf import convert
import os
def word_to_pdf_batch(folder_path):
    # 獲取所有docx文件
    files = [f for f in os.listdir(folder_path) if f.endswith('.docx')]
    print(f"開始轉(zhuǎn)換 {len(files)} 個(gè)文件...")
    for file in files:
        word_path = os.path.join(folder_path, file)
        pdf_path = os.path.join(folder_path, file.replace('.docx', '.pdf'))
        # 轉(zhuǎn)換操作
        convert(word_path, pdf_path)
        print(f"轉(zhuǎn)換成功：{pdf_path}")
# 使用示例：轉(zhuǎn)換 'docs' 目錄下的所有文檔
word_to_pdf_batch('./docs')

# 運(yùn)行環(huán)境：Python≥3.8
# pip install python-pptx

from pptx import Presentation

def create_ppt_from_text(title_text, content_list, filename):
    prs = Presentation()
    
    # 創(chuàng)建封面
    slide = prs.slides.add_slide(prs.slide_layouts[0])
    slide.shapes.title.text = title_text
    slide.placeholders[1].text = "自動(dòng)生成匯報(bào)"
    
    # 創(chuàng)建內(nèi)容頁(yè)
    for content in content_list:
        slide = prs.slides.add_slide(prs.slide_layouts[1])
        slide.shapes.title.text = content['title']
        slide.placeholders[1].text = content['body']
        
    prs.save(filename)
    print(f"PPT已生成：{filename}")

# 使用示例
contents = [
    {'title': '項(xiàng)目背景', 'body': '市場(chǎng)需求增長(zhǎng)...'},
    {'title': '執(zhí)行計(jì)劃', 'body': '第一階段：調(diào)研...'}
]
create_ppt_from_text("年度規(guī)劃", contents, "匯報(bào).pptx")

# 運(yùn)行環(huán)境：Python≥3.8
# pip install yagmail

import yagmail
import time

def send_salary_emails(sender_email, password, staff_data):
    # 連接郵箱服務(wù)器 (以QQ郵箱為例)
    yag = yagmail.SMTP(user=sender_email, password=password, host='smtp.qq.com')
    
    for staff in staff_data:
        email = staff['email']
        name = staff['name']
        file_path = staff['attachment']
        
        contents = [
            f"親愛的 {name}：",
            "這是您本月的工資條，請(qǐng)查收。",
            "如有疑問(wèn)請(qǐng)聯(lián)系財(cái)務(wù)部。"
        ]
        
        # 發(fā)送郵件
        yag.send(to=email, subject='本月工資條', contents=contents, attachments=file_path)
        print(f"已發(fā)送給：{name}")
        time.sleep(2) # 避免發(fā)送過(guò)快被封

# 使用示例
staffs = [{'name': '張三', 'email': 'zhangsan@ex.com', 'attachment': '張三_工資.xlsx'}]
# 注意：密碼通常是郵箱的授權(quán)碼
# send_salary_emails('your_email@qq.com', 'your_auth_code', staffs)

# 運(yùn)行環(huán)境：Python≥3.8
# pip install pypdf

from pypdf import PdfWriter
import os

def merge_pdfs(folder_path, output_filename):
    merger = PdfWriter()
    # 按文件名排序
    files = sorted([f for f in os.listdir(folder_path) if f.endswith('.pdf')])
    
    for pdf in files:
        merger.append(os.path.join(folder_path, pdf))
        
    merger.write(output_filename)
    merger.close()
    print(f"成功合并 {len(files)} 個(gè)文件為 {output_filename}")

# 使用示例
merge_pdfs('./scan_files', '完整合同.pdf')

# 運(yùn)行環(huán)境：Python≥3.8
# pip install pypdf

from pypdf import PdfReader, PdfWriter

def extract_pages(input_pdf, output_pdf, start_page, end_page):
    reader = PdfReader(input_pdf)
    writer = PdfWriter()
    
    # 頁(yè)面索引從0開始，所以要減1
    # 注意：range不包含結(jié)束值，但我們要包含end_page
    for i in range(start_page - 1, end_page):
        writer.add_page(reader.pages[i])
        
    with open(output_pdf, "wb") as f:
        writer.write(f)
    print(f"已提取第 {start_page} 到 {end_page} 頁(yè)")

# 使用示例：提取第 5 到 10 頁(yè)
extract_pages('行業(yè)報(bào)告.pdf', '市場(chǎng)分析部分.pdf', 5, 10)

# 運(yùn)行環(huán)境：Python≥3.8
# 無(wú)需安裝第三方庫(kù)

import os

def batch_rename(folder_path, prefix):
    files = os.listdir(folder_path)
    count = 1
    
    for file in files:
        # 跳過(guò)系統(tǒng)文件
        if file.startswith('.'): continue
        
        # 獲取后綴名
        ext = os.path.splitext(file)[1]
        new_name = f"{prefix}_{count:03d}{ext}"
        
        old_path = os.path.join(folder_path, file)
        new_path = os.path.join(folder_path, new_name)
        
        os.rename(old_path, new_path)
        print(f"重命名: {file} -> {new_name}")
        count += 1

# 使用示例
batch_rename('./photos', '年會(huì)現(xiàn)場(chǎng)')

# 運(yùn)行環(huán)境：Python≥3.8
# 無(wú)需安裝第三方庫(kù)

import os
import shutil

def organize_desktop(desktop_path):
    # 定義分類規(guī)則
    extensions = {
        '圖片': ['.jpg', '.png', '.jpeg', '.gif'],
        '文檔': ['.pdf', '.docx', '.xlsx', '.txt'],
        '壓縮包': ['.zip', '.rar', '.7z']
    }
    
    for file in os.listdir(desktop_path):
        file_path = os.path.join(desktop_path, file)
        if os.path.isdir(file_path): continue # 跳過(guò)文件夾
        
        ext = os.path.splitext(file)[1].lower()
        for folder, exts in extensions.items():
            if ext in exts:
                target_folder = os.path.join(desktop_path, folder)
                if not os.path.exists(target_folder):
                    os.makedirs(target_folder)
                shutil.move(file_path, os.path.join(target_folder, file))
                print(f"移動(dòng) {file} 到 {folder}")

# 使用示例
# organize_desktop(r'C:\Users\YourName\Desktop')

# 運(yùn)行環(huán)境：Python≥3.8
# pip install Pillow

from PIL import Image
import os

def compress_images(folder_path, quality=60):
    output_folder = os.path.join(folder_path, 'compressed')
    if not os.path.exists(output_folder):
        os.makedirs(output_folder)
        
    for file in os.listdir(folder_path):
        if file.lower().endswith(('.png', '.jpg', '.jpeg')):
            img_path = os.path.join(folder_path, file)
            with Image.open(img_path) as img:
                # 轉(zhuǎn)換為RGB模式以防報(bào)錯(cuò)
                img = img.convert('RGB')
                save_path = os.path.join(output_folder, file)
                img.save(save_path, quality=quality, optimize=True)
                print(f"壓縮完成：{file}")

# 使用示例：質(zhì)量60%
compress_images('./product_imgs', 60)

# 運(yùn)行環(huán)境：Python≥3.8
# pip install Pillow

from PIL import Image, ImageDraw, ImageFont
import os

def add_watermark(folder_path, text):
    # 需準(zhǔn)備一個(gè)字體文件，如 arial.ttf
    font = ImageFont.truetype("arial.ttf", 36)
    
    for file in os.listdir(folder_path):
        if file.lower().endswith(('.jpg', '.png')):
            img = Image.open(os.path.join(folder_path, file))
            draw = ImageDraw.Draw(img)
            
            # 在右下角添加水印
            width, height = img.size
            draw.text((width-200, height-50), text, fill=(255,255,255,128), font=font)
            
            img.save(os.path.join(folder_path, f"watermarked_{file}"))
            print(f"已加水印：{file}")

# 使用示例
# add_watermark('./drafts', 'CONFIDENTIAL')

# 運(yùn)行環(huán)境：Python≥3.8
# pip install pandas matplotlib

import pandas as pd
import matplotlib.pyplot as plt

def generate_bar_chart(csv_file, x_col, y_col):
    df = pd.read_csv(csv_file)
    
    # 設(shè)置圖表大小和風(fēng)格
    plt.figure(figsize=(10, 6))
    plt.bar(df[x_col], df[y_col], color='skyblue')
    
    plt.title('銷售數(shù)據(jù)概覽')
    plt.xlabel(x_col)
    plt.ylabel(y_col)
    plt.xticks(rotation=45)
    
    plt.tight_layout()
    plt.savefig('chart_output.png')
    print("圖表已生成：chart_output.png")

# 使用示例
# generate_bar_chart('sales.csv', '月份', '銷售額')

# 運(yùn)行環(huán)境：Python≥3.8
# pip install requests beautifulsoup4

import requests
from bs4 import BeautifulSoup

def fetch_titles(url):
    headers = {'User-Agent': 'Mozilla/5.0'}
    try:
        response = requests.get(url, headers=headers)
        soup = BeautifulSoup(response.text, 'html.parser')
        
        # 假設(shè)標(biāo)題在 h2 標(biāo)簽中，具體需根據(jù)網(wǎng)站調(diào)整
        titles = soup.find_all('h2')
        for idx, title in enumerate(titles[:10], 1):
            print(f"{idx}. {title.get_text().strip()}")
            
    except Exception as e:
        print(f"抓取失敗: {e}")

# 使用示例 (請(qǐng)遵守網(wǎng)站robots協(xié)議)
# fetch_titles('https://news.ycombinator.com/')

# 運(yùn)行環(huán)境：Python≥3.8
# pip install plyer

from plyer import notification
import time

def schedule_reminder(title, message, delay_seconds):
    print(f"提醒設(shè)置成功，{delay_seconds}秒后提醒...")
    time.sleep(delay_seconds)
    
    notification.notify(
        title=title,
        message=message,
        app_name='辦公助手',
        timeout=10
    )

# 使用示例：1小時(shí)(3600秒)后提醒喝水
schedule_reminder("休息提醒", "工作一小時(shí)了，起來(lái)喝杯水！", 3600)

# 運(yùn)行環(huán)境：Python≥3.8
# pip install qrcode[pil]

import qrcode

def generate_qrcode(url, filename='qrcode.png'):
    qr = qrcode.QRCode(
        version=1,
        box_size=10,
        border=5
    )
    qr.add_data(url)
    qr.make(fit=True)
    
    img = qr.make_image(fill_color="black", back_color="white")
    img.save(filename)
    print(f"二維碼已生成：{filename}")

# 使用示例
generate_qrcode('https://www.python.org')

# 運(yùn)行環(huán)境：Python≥3.8
# pip install requests

import requests
import time

def monitor_website(url, keyword):
    print(f"開始監(jiān)控 {url}...")
    headers = {'User-Agent': 'Mozilla/5.0'}
    
    while True:
        try:
            response = requests.get(url, headers=headers)
            if keyword in response.text:
                print(f"【發(fā)現(xiàn)目標(biāo)】關(guān)鍵詞 '{keyword}' 出現(xiàn)了！")
                break
            else:
                print("暫無(wú)變化，10秒后重試...")
        except:
            print("網(wǎng)絡(luò)請(qǐng)求錯(cuò)誤")
            
        time.sleep(10)

# 使用示例
# monitor_website('http://example.com/tickets', '有票')

# 運(yùn)行環(huán)境：Python≥3.8
# 無(wú)需安裝第三方庫(kù)

import json
import csv

def json_to_csv(json_file, csv_file):
    with open(json_file, 'r', encoding='utf-8') as f:
        data = json.load(f)
        
    # 假設(shè)data是列表且元素為字典
    if not data: return
    
    keys = data[0].keys()
    
    with open(csv_file, 'w', newline='', encoding='utf-8-sig') as f:
        writer = csv.DictWriter(f, fieldnames=keys)
        writer.writeheader()
        writer.writerows(data)
        
    print(f"轉(zhuǎn)換完成：{csv_file}")

# 使用示例
# json_to_csv('data.json', 'data.csv')

# 運(yùn)行環(huán)境：Python≥3.8
# pip install SpeechRecognition
# 需安裝 ffmpeg

import speech_recognition as sr

def audio_to_text(audio_file):
    r = sr.Recognizer()
    
    with sr.AudioFile(audio_file) as source:
        print("正在讀取音頻...")
        audio_data = r.record(source)
        
    try:
        # 這里使用默認(rèn)的 Google API，實(shí)際建議替換為百度/訊飛API
        text = r.recognize_google(audio_data, language='zh-CN')
        print("識(shí)別結(jié)果：")
        print(text)
    except sr.UnknownValueError:
        print("無(wú)法識(shí)別音頻內(nèi)容")
    except sr.RequestError:
        print("請(qǐng)求服務(wù)失敗")

# 使用示例 (僅支持 wav 等特定格式)
# audio_to_text('meeting_clip.wav')

# 運(yùn)行環(huán)境：Python≥3.8
# 無(wú)需安裝第三方庫(kù)

import string
import secrets

def generate_password(length=12):
    # 包含大小寫字母、數(shù)字和特殊字符
    alphabet = string.ascii_letters + string.digits + string.punctuation
    password = ''.join(secrets.choice(alphabet) for i in range(length))
    print(f"生成的強(qiáng)密碼：{password}")
    return password

# 使用示例：生成3個(gè)16位強(qiáng)密碼
for _ in range(3):
    generate_password(16)