import os
import re
 
# 設(shè)置目錄路徑
directory = 'C:/path/to/your/files'
 
# 獲取文件列表
files = os.listdir(directory)
 
# 批量重命名文件
for filename in files:
    new_name = re.sub(r'old_pattern', 'new_pattern', filename)  # 替換文件名中的內(nèi)容
    os.rename(os.path.join(directory, filename), os.path.join(directory, new_name))
 
print("文件重命名完成！")

import os
import shutil
 
# 設(shè)置目錄路徑
directory = 'C:/path/to/your/files'
 
# 獲取文件列表
files = os.listdir(directory)
 
# 定義文件分類規(guī)則
file_types = {
    'images': ['.jpg', '.jpeg', '.png', '.gif'],
    'documents': ['.pdf', '.txt', '.docx'],
    'audio': ['.mp3', '.wav']
}
 
# 創(chuàng)建文件夾（如果不存在）
for folder in file_types:
    if not os.path.exists(os.path.join(directory, folder)):
        os.makedirs(os.path.join(directory, folder))
 
# 移動文件
for filename in files:
    file_path = os.path.join(directory, filename)
    if os.path.isfile(file_path):
        moved = False
        for folder, extensions in file_types.items():
            if any(filename.endswith(ext) for ext in extensions):
                shutil.move(file_path, os.path.join(directory, folder, filename))
                moved = True
                break
        if not moved:
            print(f"文件 {filename} 沒有分類！")
            
print("文件分類完成！")

import schedule
import time
 
# 定義要執(zhí)行的任務(wù)
def job():
    print("任務(wù)開始執(zhí)行！")
 
# 每隔 10 秒執(zhí)行一次任務(wù)
schedule.every(10).seconds.do(job)
 
# 持續(xù)運行任務(wù)
while True:
    schedule.run_pending()
    time.sleep(1)

from apscheduler.schedulers.blocking import BlockingScheduler
import datetime
 
# 定義要執(zhí)行的任務(wù)
def print_time():
    print(f"當前時間：{datetime.datetime.now()}")
 
# 創(chuàng)建調(diào)度器
scheduler = BlockingScheduler()
 
# 添加任務(wù)，定時每分鐘執(zhí)行
scheduler.add_job(print_time, 'interval', minutes=1)
 
# 啟動調(diào)度器
scheduler.start()

import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
 
def send_email(subject, body, to_email):
    from_email = "your_email@gmail.com"
    password = "your_password"
 
    # 設(shè)置郵件內(nèi)容
    msg = MIMEMultipart()
    msg['From'] = from_email
    msg['To'] = to_email
    msg['Subject'] = subject
    msg.attach(MIMEText(body, 'plain'))
 
    # 發(fā)送郵件
    try:
        server = smtplib.SMTP('smtp.gmail.com', 587)
        server.starttls()
        server.login(from_email, password)
        text = msg.as_string()
        server.sendmail(from_email, to_email, text)
        server.quit()
        print("郵件發(fā)送成功！")
    except Exception as e:
        print(f"郵件發(fā)送失?。簕e}")
 
# 調(diào)用函數(shù)發(fā)送郵件
send_email("自動化報告", "這是自動化發(fā)送的郵件內(nèi)容", "recipient_email@example.com")

import requests
from bs4 import BeautifulSoup
 
# 定義爬取目標網(wǎng)址
url = "https://example.com"
 
# 發(fā)送 HTTP 請求獲取網(wǎng)頁內(nèi)容
response = requests.get(url)
 
# 解析網(wǎng)頁內(nèi)容
soup = BeautifulSoup(response.text, 'html.parser')
 
# 獲取頁面標題
title = soup.title.string
 
# 打印標題
print(f"網(wǎng)頁標題: {title}")

import pandas as pd
 
# 讀取 CSV 文件
df = pd.read_csv('data.csv')
 
# 進行數(shù)據(jù)處理（例如：篩選大于 100 的值）
df_filtered = df[df['column_name'] > 100]
 
# 保存處理后的數(shù)據(jù)到新的 CSV 文件
df_filtered.to_csv('filtered_data.csv', index=False)
 
print("數(shù)據(jù)處理完成！")

import mysql.connector
import datetime
import os
 
def backup_database():
    # 數(shù)據(jù)庫連接配置
    db = mysql.connector.connect(
        host="localhost",
        user="your_user",
        password="your_password",
        database="your_database"
    )
 
    # 創(chuàng)建備份文件名
    backup_filename = f"backup_{datetime.datetime.now().strftime('%Y%m%d_%H%M%S')}.sql"
 
    # 使用 mysqldump 進行備份
    os.system(f"mysqldump -u your_user -p'your_password' your_database > {backup_filename}")
 
    print(f"數(shù)據(jù)庫備份完成！備份文件: {backup_filename}")
 
# 定時備份
backup_database()

from PIL import Image
import os
 
# 設(shè)置圖像目錄
image_directory = 'C:/path/to/your/images'
 
# 獲取所有圖像文件
files = os.listdir(image_directory)
 
# 批量調(diào)整圖像大小
for filename in files:
    if filename.endswith('.jpg'):
        image_path = os.path.join(image_directory, filename)
        with Image.open(image_path) as img:
            img = img.resize((800, 600))  # 調(diào)整大小為 800x600
            img.save(os.path.join(image_directory, f"resized_{filename}"))
 
print("圖像處理完成！")

from selenium import webdriver
 
# 設(shè)置 WebDriver
driver = webdriver.Chrome(executable_path="path/to/chromedriver")
 
# 打開網(wǎng)頁
driver.get("https://example.com")
 
# 查找并點擊一個按鈕
button = driver.find_element_by_xpath("http://button[@id='submit']")
button.click()
 
# 獲取網(wǎng)頁內(nèi)容
page_content = driver.page_source
print(page_content)
 
# 關(guān)閉瀏覽器
driver.quit()