Python 自动化脚本编写五个实战案例

import os

# 定义文件夹路径
folder_path = 'path/to/your/folder'

# 获取文件夹中的所有文件
files = os.listdir(folder_path)

# 过滤出图片文件（假设只有 .jpg 格式）
image_files = [f for f in files if f.endswith('.jpg')]

# 按文件名排序
image_files.sort()

# 重命名文件
for i, file_name in enumerate(image_files):
    # 构建新的文件名
    new_name = f'image{i + 1}.jpg'
    # 构建完整路径
    old_path = os.path.join(folder_path, file_name)
    new_path = os.path.join(folder_path, new_name)
    # 重命名文件
    os.rename(old_path, new_path)
    print(f'Renamed {file_name} to {new_name}')
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.

import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
import schedule
import time

# 邮件配置
smtp_server = 'smtp.example.com'
smtp_port = 587
smtp_user = 'your_email@example.com'
smtp_password = 'your_password'
to_email = 'client_email@example.com'

def send_email():
    # 创建邮件对象
    msg = MIMEMultipart()
    msg['From'] = smtp_user
    msg['To'] = to_email
    msg['Subject'] = 'Daily Report'

    # 添加邮件正文
    body = 'Here is the latest report.'
    msg.attach(MIMEText(body, 'plain'))

    # 发送邮件
    with smtplib.SMTP(smtp_server, smtp_port) as server:
        server.starttls()
        server.login(smtp_user, smtp_password)
        server.sendmail(smtp_user, to_email, msg.as_string())
        print('Email sent successfully')

# 定时任务
schedule.every().day.at("10:00").do(send_email)

while True:
    schedule.run_pending()
    time.sleep(1)
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.

import requests
from bs4 import BeautifulSoup
import pandas as pd

# 目标 URL
url = 'https://example.com/data'

# 发送请求
response = requests.get(url)
response.raise_for_status()  # 检查请求是否成功

# 解析 HTML
soup = BeautifulSoup(response.text, 'html.parser')

# 提取数据
data = []
table = soup.find('table')
rows = table.find_all('tr')
for row in rows:
    cols = row.find_all('td')
    cols = [col.text.strip() for col in cols]
    data.append(cols)

# 转换为 DataFrame
df = pd.DataFrame(data[1:], columns=data[0])

# 保存到 CSV 文件
df.to_csv('data.csv', index=False)
print('Data saved to data.csv')
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.

from selenium import webdriver
from selenium.webdriver.common.by import By
from selenium.webdriver.common.keys import Keys
import time

# 配置 WebDriver
driver = webdriver.Chrome()

# 打开目标网站
driver.get('https://example.com/login')

# 输入用户名和密码
username_input = driver.find_element(By.NAME, 'username')
password_input = driver.find_element(By.NAME, 'password')
username_input.send_keys('test_user')
password_input.send_keys('test_password')

# 提交表单
password_input.send_keys(Keys.RETURN)

# 等待页面加载
time.sleep(2)

# 检查登录是否成功
if 'Dashboard' in driver.page_source:
    print('Login successful')
else:
    print('Login failed')

# 关闭浏览器
driver.quit()
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.

import subprocess
import boto3
import os
import datetime

# 数据库配置
db_host = 'localhost'
db_user = 'root'
db_password = 'password'
db_name = 'mydatabase'

# S3 配置
s3_bucket = 'your-bucket-name'
s3_key = 'backups/'

# 生成备份文件名
backup_file = f'{db_name}_{datetime.datetime.now().strftime("%Y%m%d%H%M%S")}.sql'

# 执行备份命令
backup_command = f'mysqldump -h {db_host} -u {db_user} -p{db_password} {db_name} > {backup_file}'
subprocess.run(backup_command, shell=True, check=True)
print(f'Database backup created: {backup_file}')

# 上传到 S3
s3 = boto3.client('s3')
s3.upload_file(backup_file, s3_bucket, s3_key + backup_file)
print(f'Backup uploaded to S3: {s3_key + backup_file}')

# 删除本地备份文件
os.remove(backup_file)
print('Local backup file deleted')
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.

import pandas as pd
import matplotlib.pyplot as plt
import smtplib
from email.mime.text import MIMEText
from email.mime.multipart import MIMEMultipart
from email.mime.application import MIMEApplication
import schedule
import time

# 读取销售数据
sales_data = pd.read_csv('sales_data.csv')

# 生成图表
plt.figure(figsize=(10, 6))
plt.plot(sales_data['date'], sales_data['amount'])
plt.title('Sales Report')
plt.xlabel('Date')
plt.ylabel('Amount')
plt.savefig('sales_report.png')

# 创建邮件对象
msg = MIMEMultipart()
msg['From'] = 'your_email@example.com'
msg['To'] = 'manager_email@example.com'
msg['Subject'] = 'Daily Sales Report'

# 添加邮件正文
body = 'Please find the attached sales report.'
msg.attach(MIMEText(body, 'plain'))

# 添加附件
with open('sales_report.png', 'rb') as f:
    img = MIMEApplication(f.read(), _subtype='png')
    img.add_header('Content-Disposition', 'attachment', filename='sales_report.png')
    msg.attach(img)

# 发送邮件
with smtplib.SMTP('smtp.example.com', 587) as server:
    server.starttls()
    server.login('your_email@example.com', 'your_password')
    server.sendmail('your_email@example.com', 'manager_email@example.com', msg.as_string())
    print('Email sent successfully')

# 定时任务
schedule.every().day.at("12:00").do(send_email)

while True:
    schedule.run_pending()
    time.sleep(1)
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.