pip install pandas openpyxl PyPDF2 Pillow pyperclip requests beautifulsoup4 schedule

import os

def batch_rename_files(folder_path, old_str, new_str):
    """
    批量重命名指定文件夾下的文件。
    :param folder_path: 文件夾路徑
    :param old_str: 文件名中需要被替換的舊字符串
    :param new_str: 替換舊字符串的新字符串
    """
    try:
        for filename in os.listdir(folder_path):
            if old_str in filename:
                new_filename = filename.replace(old_str, new_str)
                old_file_path = os.path.join(folder_path, filename)
                new_file_path = os.path.join(folder_path, new_filename)
                os.rename(old_file_path, new_file_path)
                print(f"文件 '{filename}' 已重命名為 '{new_filename}'")
        print("所有文件重命名完成！")
    except Exception as e:
        print(f"發(fā)生錯誤: {e}")

if __name__ == "__main__":
    # 請修改為你實(shí)際的文件夾路徑、舊字符串和新字符串
    folder = "D:/MyDocuments/Photos" # 示例路徑
    old_text = "IMG_"
    new_text = "Vacation_"
    batch_rename_files(folder, old_text, new_text)

    # 示例2: 添加前綴
    # folder = "D:/MyDocuments/Reports"
    # old_text = "" # 空字符串表示添加前綴
    # new_text = "Final_"
    # batch_rename_files(folder, old_text, new_text)

import os
import shutil

def organize_files_by_type(folder_path):
    """
    根據(jù)文件類型（擴(kuò)展名）將文件移動到對應(yīng)的子文件夾中。
    :param folder_path: 需要整理的文件夾路徑
    """
    try:
        for filename in os.listdir(folder_path):
            file_path = os.path.join(folder_path, filename)
            if os.path.isfile(file_path): # 確保是文件而不是文件夾
                file_extension = os.path.splitext(filename)[1].lower() # 獲取文件擴(kuò)展名
                if not file_extension: # 沒有擴(kuò)展名的文件跳過
                    continue

                # 創(chuàng)建目標(biāo)文件夾
                target_folder = os.path.join(folder_path, file_extension[1:] + "_Files") # 例如 ".txt" -> "txt_Files"
                os.makedirs(target_folder, exist_ok=True)

                # 移動文件
                shutil.move(file_path, target_folder)
                print(f"文件 '{filename}' 已移動到 '{target_folder}'")
        print("文件整理完成！")
    except Exception as e:
        print(f"發(fā)生錯誤: {e}")

if __name__ == "__main__":
    # 請修改為你實(shí)際的文件夾路徑
    folder = "D:/MyDocuments/Downloads" # 示例路徑
    organize_files_by_type(folder)

import os

def delete_empty_folders(folder_path):
    """
    遞歸查找并刪除指定路徑下的所有空文件夾。
    :param folder_path: 需要清理的根文件夾路徑
    :return: 被刪除的空文件夾數(shù)量
    """
    deleted_count = 0
    for dirpath, dirnames, filenames in os.walk(folder_path, topdown=False):
        # topdown=False 確保先處理子目錄，再處理父目錄
        if not dirnames and not filenames:
            try:
                os.rmdir(dirpath)
                print(f"已刪除空文件夾: {dirpath}")
                deleted_count += 1
            except OSError as e:
                print(f"無法刪除文件夾 {dirpath}: {e}")
    return deleted_count

if __name__ == "__main__":
    # 請修改為你實(shí)際的根文件夾路徑
    root_folder = "D:/MyDocuments/Temp" # 示例路徑
    print(f"開始清理 '{root_folder}' 下的空文件夾...")
    count = delete_empty_folders(root_folder)
    print(f"清理完成，共刪除 {count} 個空文件夾。")

import os

def merge_txt_files(folder_path, output_filename="merged_output.txt"):
    """
    合并指定文件夾下所有TXT文件的內(nèi)容到一個新的TXT文件。
    :param folder_path: 包含TXT文件的文件夾路徑
    :param output_filename: 合并后的輸出文件名
    """
    output_path = os.path.join(folder_path, output_filename)
    try:
        with open(output_path, 'w', encoding='utf-8') as outfile:
            for filename in os.listdir(folder_path):
                if filename.endswith(".txt") and filename != output_filename:
                    filepath = os.path.join(folder_path, filename)
                    try:
                        with open(filepath, 'r', encoding='utf-8') as infile:
                            outfile.write(f"--- 文件開始: {filename} ---\n")
                            outfile.write(infile.read())
                            outfile.write(f"\n--- 文件結(jié)束: {filename} ---\n\n")
                        print(f"已合并文件: {filename}")
                    except UnicodeDecodeError:
                        print(f"警告: 文件 '{filename}' 編碼錯誤，嘗試使用GBK...")
                        try:
                            with open(filepath, 'r', encoding='gbk') as infile:
                                outfile.write(f"--- 文件開始: {filename} (GBK編碼) ---\n")
                                outfile.write(infile.read())
                                outfile.write(f"\n--- 文件結(jié)束: {filename} (GBK編碼) ---\n\n")
                            print(f"已合并文件: {filename} (GBK)")
                        except Exception as e:
                            print(f"錯誤: 無法讀取文件 '{filename}' ({e})")
                    except Exception as e:
                        print(f"錯誤: 讀取文件 '{filename}' 失敗 ({e})")
        print(f"\n所有TXT文件已成功合并到 '{output_path}'")
    except Exception as e:
        print(f"發(fā)生錯誤: {e}")

if __name__ == "__main__":
    # 請修改為你實(shí)際的文件夾路徑
    folder = "D:/MyDocuments/Reports" # 示例路徑
    merge_txt_files(folder, "Annual_Report_Combined.txt")

import os

def batch_find_replace(folder_path, old_text, new_text, file_extension=".txt"):
    """
    在指定文件夾下所有指定類型的文件中查找并替換文本。
    :param folder_path: 文件夾路徑
    :param old_text: 需要查找的舊文本
    :param new_text: 替換舊文本的新文本
    :param file_extension: 需要處理的文件擴(kuò)展名 (例如 ".txt", ".md", ".py")
    """
    replaced_count = 0
    for filename in os.listdir(folder_path):
        if filename.endswith(file_extension):
            filepath = os.path.join(folder_path, filename)
            try:
                with open(filepath, 'r', encoding='utf-8') as f:
                    content = f.read()

                if old_text in content:
                    new_content = content.replace(old_text, new_text)
                    with open(filepath, 'w', encoding='utf-8') as f:
                        f.write(new_content)
                    print(f"文件 '{filename}' 中的 '{old_text}' 已替換為 '{new_text}'")
                    replaced_count += 1
            except UnicodeDecodeError:
                print(f"警告: 文件 '{filename}' 編碼錯誤，跳過。")
            except Exception as e:
                print(f"處理文件 '{filename}' 時發(fā)生錯誤: {e}")
    print(f"\n批量查找替換完成，共修改了 {replaced_count} 個文件。")

if __name__ == "__main__":
    # 請修改為你實(shí)際的文件夾路徑、舊文本、新文本和文件擴(kuò)展名
    folder = "D:/MyDocuments/Projects/MyCode" # 示例路徑
    old_string = "deprecated_function"
    new_string = "new_function_v2"
    file_ext = ".py" # 例如，可以修改為 ".txt", ".md", ".html" 等

    batch_find_replace(folder, old_string, new_string, file_ext)

import pandas as pd
import os

def csv_to_excel(csv_folder_path, output_excel_filename="merged_output.xlsx"):
    """
    將指定文件夾下的所有CSV文件合并并轉(zhuǎn)換為一個Excel文件。
    :param csv_folder_path: 包含CSV文件的文件夾路徑
    :param output_excel_filename: 輸出的Excel文件名
    """
    all_data = []
    for filename in os.listdir(csv_folder_path):
        if filename.endswith(".csv"):
            filepath = os.path.join(csv_folder_path, filename)
            try:
                # 嘗試多種編碼讀取CSV
                df = pd.read_csv(filepath, encoding='utf-8')
                all_data.append(df)
                print(f"已讀取CSV文件: {filename}")
            except UnicodeDecodeError:
                print(f"警告: CSV文件 '{filename}' 編碼錯誤，嘗試使用GBK...")
                try:
                    df = pd.read_csv(filepath, encoding='gbk')
                    all_data.append(df)
                    print(f"已讀取CSV文件: {filename} (GBK)")
                except Exception as e:
                    print(f"錯誤: 無法讀取CSV文件 '{filename}' ({e})")
            except Exception as e:
                print(f"處理CSV文件 '{filename}' 時發(fā)生錯誤: {e}")

    if not all_data:
        print("未找到任何CSV文件或所有文件讀取失敗。")
        return

    # 合并所有DataFrame
    merged_df = pd.concat(all_data, ignore_index=True)

    # 寫入Excel
    output_path = os.path.join(csv_folder_path, output_excel_filename)
    try:
        merged_df.to_excel(output_path, index=False)
        print(f"\n所有CSV文件已成功合并并轉(zhuǎn)換為Excel文件: '{output_path}'")
    except Exception as e:
        print(f"寫入Excel文件失敗: {e}")

if __name__ == "__main__":
    # 請修改為你實(shí)際的文件夾路徑和輸出文件名
    csv_folder = "D:/MyDocuments/Data/Sales" # 示例路徑
    csv_to_excel(csv_folder, "Sales_Data_Combined.xlsx")

import pandas as pd
import os

def merge_excel_files(excel_folder_path, output_excel_filename="merged_all_data.xlsx"):
    """
    將指定文件夾下的所有Excel文件（每個文件作為一個工作表）合并到一個新的Excel文件。
    :param excel_folder_path: 包含Excel文件的文件夾路徑
    :param output_excel_filename: 輸出的Excel文件名
    """
    output_path = os.path.join(excel_folder_path, output_excel_filename)
    writer = pd.ExcelWriter(output_path, engine='openpyxl')

    for filename in os.listdir(excel_folder_path):
        if filename.endswith((".xlsx", ".xls")) and filename != output_excel_filename:
            filepath = os.path.join(excel_folder_path, filename)
            try:
                df = pd.read_excel(filepath)
                sheet_name = os.path.splitext(filename)[0][:30] # 工作表名稱不能太長
                df.to_excel(writer, sheet_name=sheet_name, index=False)
                print(f"已將文件 '{filename}' 寫入到工作表 '{sheet_name}'")
            except Exception as e:
                print(f"處理Excel文件 '{filename}' 時發(fā)生錯誤: {e}")

    try:
        writer.save()
        print(f"\n所有Excel文件已成功合并到 '{output_path}'")
    except Exception as e:
        print(f"寫入Excel文件失敗: {e}")

if __name__ == "__main__":
    # 請修改為你實(shí)際的文件夾路徑和輸出文件名
    excel_folder = "D:/MyDocuments/Data/MonthlyReports" # 示例路徑
    merge_excel_files(excel_folder, "Combined_Monthly_Reports.xlsx")

import pandas as pd
import os

def extract_data_from_excel(input_excel_path, output_filename="extracted_data.xlsx"):
    """
    從Excel文件中讀取數(shù)據(jù)，并根據(jù)條件提取特定數(shù)據(jù)。
    :param input_excel_path: 輸入的Excel文件路徑
    :param output_filename: 提取數(shù)據(jù)后保存的輸出文件名
    """
    try:
        df = pd.read_excel(input_excel_path)
        print("原始數(shù)據(jù)前5行:")
        print(df.head())

        # 示例：提取 '銷售額' 大于 5000 且 '地區(qū)' 為 '華東' 的數(shù)據(jù)
        # 請根據(jù)你的實(shí)際數(shù)據(jù)列名和條件進(jìn)行修改
        extracted_df = df[(df['銷售額'] > 5000) & (df['地區(qū)'] == '華東')]

        output_path = os.path.join(os.path.dirname(input_excel_path), output_filename)
        extracted_df.to_excel(output_path, index=False)
        print(f"\n成功提取數(shù)據(jù)并保存到 '{output_path}'")
        print("提取數(shù)據(jù)前5行:")
        print(extracted_df.head())

    except FileNotFoundError:
        print(f"錯誤: 文件未找到 '{input_excel_path}'")
    except KeyError as e:
        print(f"錯誤: Excel文件中缺少列 '{e}'。請檢查列名是否正確。")
    except Exception as e:
        print(f"處理Excel文件時發(fā)生錯誤: {e}")

if __name__ == "__main__":
    # 請修改為你實(shí)際的輸入Excel文件路徑
    input_file = "D:/MyDocuments/Data/Sales_Data.xlsx" # 示例路徑

    # 請確保你的Excel文件中有 '銷售額' 和 '地區(qū)' 列，并包含相應(yīng)的數(shù)據(jù)
    # 如果沒有，請根據(jù)你的數(shù)據(jù)調(diào)整篩選條件或創(chuàng)建示例Excel文件進(jìn)行測試。
    # 示例Excel文件內(nèi)容 (Sales_Data.xlsx):
    # 銷售員,地區(qū),銷售額,產(chǎn)品
    # 張三,華東,6000,A
    # 李四,華南,4500,B
    # 王五,華東,7200,C
    # 趙六,華北,3000,A
    # 錢七,華東,5500,B

    extract_data_from_excel(input_file, "High_Sales_East_Region.xlsx")

from PIL import Image
import os

def batch_resize_images(folder_path, output_folder_name="resized_images", size=(800, 600)):
    """
    批量縮放指定文件夾下的所有圖片。
    :param folder_path: 包含圖片的文件夾路徑
    :param output_folder_name: 縮放后圖片保存的子文件夾名稱
    :param size: 目標(biāo)尺寸 (寬度, 高度)
    """
    output_folder = os.path.join(folder_path, output_folder_name)
    os.makedirs(output_folder, exist_ok=True)

    for filename in os.listdir(folder_path):
        if filename.lower().endswith(('.png', '.jpg', '.jpeg', '.gif', '.bmp')):
            filepath = os.path.join(folder_path, filename)
            try:
                with Image.open(filepath) as img:
                    img_resized = img.resize(size)
                    output_filepath = os.path.join(output_folder, filename)
                    img_resized.save(output_filepath)
                    print(f"圖片 '{filename}' 已縮放并保存到 '{output_folder_name}'")
            except Exception as e:
                print(f"處理圖片 '{filename}' 時發(fā)生錯誤: {e}")
    print("\n所有圖片縮放完成！")

if __name__ == "__main__":
    # 請修改為你實(shí)際的圖片文件夾路徑和目標(biāo)尺寸
    image_folder = "D:/MyDocuments/ImageGallery" # 示例路徑
    target_size = (1280, 720) # 目標(biāo)寬度和高度

    batch_resize_images(image_folder, size=target_size)

from PIL import Image
import os

def batch_convert_images(folder_path, output_folder_name="converted_images", target_format="PNG"):
    """
    批量轉(zhuǎn)換指定文件夾下的所有圖片格式。
    :param folder_path: 包含圖片的文件夾路徑
    :param output_folder_name: 轉(zhuǎn)換后圖片保存的子文件夾名稱
    :param target_format: 目標(biāo)格式 (例如 "PNG", "JPEG", "BMP")
    """
    output_folder = os.path.join(folder_path, output_folder_name)
    os.makedirs(output_folder, exist_ok=True)

    for filename in os.listdir(folder_path):
        # 排除已是目標(biāo)格式的文件，防止重復(fù)處理
        if not filename.lower().endswith(f'.{target_format.lower()}'):
            filepath = os.path.join(folder_path, filename)
            try:
                with Image.open(filepath) as img:
                    # 構(gòu)建新的文件名和路徑
                    base_name = os.path.splitext(filename)[0]
                    output_filepath = os.path.join(output_folder, f"{base_name}.{target_format.lower()}")
                    img.save(output_filepath, format=target_format)
                    print(f"圖片 '{filename}' 已轉(zhuǎn)換為 {target_format} 格式并保存到 '{output_folder_name}'")
            except Exception as e:
                print(f"處理圖片 '{filename}' 時發(fā)生錯誤: {e}")
    print("\n所有圖片格式轉(zhuǎn)換完成！")

if __name__ == "__main__":
    # 請修改為你實(shí)際的圖片文件夾路徑和目標(biāo)格式
    image_folder = "D:/MyDocuments/ImageGallery" # 示例路徑
    target_format = "JPEG" # 例如 "PNG", "JPEG", "BMP"

    batch_convert_images(image_folder, target_format=target_format)

import webbrowser
import time

def open_websites(urls):
    """
    在默認(rèn)瀏覽器中打開一個或多個指定的網(wǎng)頁鏈接。
    :param urls: 一個包含網(wǎng)頁鏈接的列表
    """
    for url in urls:
        try:
            webbrowser.open_new_tab(url)
            print(f"已打開網(wǎng)頁: {url}")
            time.sleep(1) # 暫停1秒，避免同時打開過多標(biāo)簽頁導(dǎo)致瀏覽器卡頓
        except Exception as e:
            print(f"無法打開網(wǎng)頁 '{url}': {e}")
    print("\n所有指定網(wǎng)頁已嘗試打開。")

if __name__ == "__main__":
    # 請修改為你需要打開的網(wǎng)頁鏈接列表
    my_work_websites = [
        "https://www.google.com",
        "https://chat.openai.com",
        "https://github.com",
        "https://www.example.com" # 替換為你的實(shí)際網(wǎng)址
    ]
    open_websites(my_work_websites)

import time

def set_timer_reminder(minutes, message):
    """
    設(shè)置一個定時提醒。
    :param minutes: 提醒間隔時間（分鐘）
    :param message: 提醒消息內(nèi)容
    """
    seconds = minutes * 60
    print(f"提醒已設(shè)置！將在 {minutes} 分鐘后（即 {seconds} 秒后）顯示消息：'{message}'")
    time.sleep(seconds)
    print("\n" + "="*30)
    print(f"提醒時間到！消息：{message}")
    print("="*30 + "\n")

if __name__ == "__main__":
    # 請修改為你需要設(shè)置的提醒時間和消息
    reminder_minutes = 30 # 30分鐘后提醒
    reminder_message = "該休息一下眼睛了！"
    set_timer_reminder(reminder_minutes, reminder_message)

    # 另一個例子
    # set_timer_reminder(5, "記得保存當(dāng)前工作！")

import pyperclip

def clipboard_operations():
    """
    演示剪貼板的復(fù)制和粘貼操作。
    """
    print("--- 剪貼板操作演示 ---")

    # 1. 獲取剪貼板內(nèi)容
    try:
        clipboard_content = pyperclip.paste()
        print(f"當(dāng)前剪貼板內(nèi)容: '{clipboard_content}'")
    except pyperclip.PyperclipException as e:
        print(f"無法獲取剪貼板內(nèi)容: {e}. 請確保安裝了必要的剪貼板后端（如xclip/xsel on Linux）。")
        return # 如果無法獲取，則退出，避免后續(xù)錯誤

    # 2. 將文本復(fù)制到剪貼板
    text_to_copy = "Hello, Python Automation!"
    pyperclip.copy(text_to_copy)
    print(f"已將文本 '{text_to_copy}' 復(fù)制到剪貼板。")

    # 3. 再次獲取剪貼板內(nèi)容，驗(yàn)證是否成功復(fù)制
    new_clipboard_content = pyperclip.paste()
    print(f"驗(yàn)證：新的剪貼板內(nèi)容為: '{new_clipboard_content}'")

    if new_clipboard_content == text_to_copy:
        print("剪貼板操作成功！")
    else:
        print("剪貼板操作可能出現(xiàn)問題。")

if __name__ == "__main__":
    clipboard_operations()

from PyPDF2 import PdfMerger
import os

def merge_pdf_files(folder_path, output_filename="merged_document.pdf"):
    """
    合并指定文件夾下的所有PDF文件。
    :param folder_path: 包含PDF文件的文件夾路徑
    :param output_filename: 合并后的輸出文件名
    """
    merger = PdfMerger()
    pdf_files = [f for f in os.listdir(folder_path) if f.lower().endswith('.pdf')]
    pdf_files.sort() # 按文件名排序，確保合并順序

    if not pdf_files:
        print("在指定文件夾中未找到任何PDF文件。")
        return

    for filename in pdf_files:
        filepath = os.path.join(folder_path, filename)
        try:
            merger.append(filepath)
            print(f"已添加文件: {filename}")
        except Exception as e:
            print(f"無法添加文件 '{filename}': {e}")

    output_path = os.path.join(folder_path, output_filename)
    try:
        with open(output_path, "wb") as output_file:
            merger.write(output_file)
        print(f"\n所有PDF文件已成功合并到 '{output_path}'")
    except Exception as e:
        print(f"寫入合并PDF文件失敗: {e}")
    finally:
        merger.close()

if __name__ == "__main__":
    # 請修改為你實(shí)際的PDF文件夾路徑
    pdf_folder = "D:/MyDocuments/Reports/Quarterly" # 示例路徑
    merge_pdf_files(pdf_folder, "Q4_Combined_Report.pdf")

from PyPDF2 import PdfReader
import os

def extract_text_from_pdf(pdf_path, output_txt_filename=None):
    """
    從PDF文件中提取所有文本內(nèi)容并保存到TXT文件。
    :param pdf_path: 輸入的PDF文件路徑
    :param output_txt_filename: 輸出的TXT文件名 (如果為None，則使用PDF文件名)
    """
    if not output_txt_filename:
        base_name = os.path.splitext(os.path.basename(pdf_path))[0]
        output_txt_filename = f"{base_name}_extracted.txt"

    output_path = os.path.join(os.path.dirname(pdf_path), output_txt_filename)

    try:
        reader = PdfReader(pdf_path)
        text_content = ""
        for page in reader.pages:
            text_content += page.extract_text() + "\n" # 提取每頁文本并換行

        with open(output_path, 'w', encoding='utf-8') as f:
            f.write(text_content)
        print(f"成功從 '{pdf_path}' 提取文本并保存到 '{output_path}'")

    except FileNotFoundError:
        print(f"錯誤: PDF文件未找到 '{pdf_path}'")
    except Exception as e:
        print(f"處理PDF文件時發(fā)生錯誤: {e}")

if __name__ == "__main__":
    # 請修改為你實(shí)際的PDF文件路徑
    input_pdf = "D:/MyDocuments/Documents/Contract_Draft.pdf" # 示例路徑
    extract_text_from_pdf(input_pdf)

    # 也可以指定輸出文件名
    # extract_text_from_pdf(input_pdf, "Contract_Text.txt")