Python自动化代码库：Excel/爬虫/邮件告警场景模板即用

import os  

def batch_rename(path, prefix):  
    for count, filename in enumerate(os.listdir(path)):  
        new_name = f"{prefix}_{count+1}{os.path.splitext(filename)[1]}"  
        os.rename(  
            os.path.join(path, filename),  
            os.path.join(path, new_name)  
        print(f"Renamed: {filename} → {new_name}")  

batch_rename("/docs/photos", "vacation")  

import pandas as pd  

# 合并多个Excel文件  
files = ["sales_2023Q1.xlsx", "sales_2023Q2.xlsx"]  
df = pd.concat([pd.read_excel(f) for f in files])  

# 删除空值并保存  
df.dropna(inplace=True)  
df.to_excel("merged_sales.xlsx", index=False)  

import requests  
from bs4 import BeautifulSoup  

url = "https://news.ycombinator.com"  
response = requests.get(url)  
soup = BeautifulSoup(response.text, "html.parser")  

# 提取标题和链接  
for item in soup.select(".titleline > a"):  
    print(item.text, item["href"])  

from selenium import webdriver  
from selenium.webdriver.common.by import By  

driver = webdriver.Chrome()  
driver.get("https://example.com/login")  

# 输入用户名密码并提交  
driver.find_element(By.ID, "username").send_keys("admin")  
driver.find_element(By.ID, "password").send_keys("pass123")  
driver.find_element(By.TAG_NAME, "button").click()  

driver.quit()  

import psutil  
import smtplib  

# 获取CPU和内存使用率  
cpu_usage = psutil.cpu_percent(interval=1)  
mem_usage = psutil.virtual_memory().percent  

if cpu_usage > 90 or mem_usage > 90:  
    # 发送邮件告警  
    server = smtplib.SMTP('smtp.gmail.com', 587)  
    server.starttls()  
    server.login("your_email@gmail.com", "password")  
    server.sendmail("from@example.com", "admin@example.com",  
                   f"Subject: Server Alert\n\nCPU: {cpu_usage}%, Memory: {mem_usage}%")  

import paramiko  

def run_ssh_command(host, username, password, command):  
    client = paramiko.SSHClient()  
    client.set_missing_host_key_policy(paramiko.AutoAddPolicy())  
    client.connect(host, username=username, password=password)  
    stdin, stdout, stderr = client.exec_command(command)  
    print(stdout.read().decode())  
    client.close()  

# 在多台服务器执行更新  
servers = ["192.168.1.101", "192.168.1.102"]  
for server in servers:  
    run_ssh_command(server, "root", "password123", "apt update && apt upgrade -y")  

import unittest  

def add(a, b):  
    return a + b  

class TestMath(unittest.TestCase):  
    def test_add(self):  
        self.assertEqual(add(2, 3), 5)  
        self.assertRaises(TypeError, add, "2", 3)  

if __name__ == "__main__":  
    unittest.main()  

import requests  
import json  

def test_api():  
    url = "https://api.example.com/login"  
    payload = {"username": "test", "password": "123"}  
    response = requests.post(url, json=payload)  
    assert response.status_code == 200  
    assert json.loads(response.text)["token"] is not None  

test_api()  

from apscheduler.schedulers.blocking import BlockingScheduler  

def job():  
    print("定时任务执行中...")  

scheduler = BlockingScheduler()  
scheduler.add_job(job, 'cron', hour=8)  # 每天8点执行  
scheduler.start()  

import pyautogui  

# 打开记事本并输入文字  
pyautogui.hotkey('win', 'r')  
pyautogui.write('notepad')  
pyautogui.press('enter')  
pyautogui.sleep(1)  
pyautogui.write('Hello, Python Automation!')