import pandas as pd

# 讀取Excel文件
df = pd.read_excel('example.xlsx')

# 進行簡單的數(shù)據(jù)處理
df['New Column'] = df['Old Column'] * 2

# 保存修改后的數(shù)據(jù)
df.to_excel('modified_example.xlsx', index=False)

from fpdf import FPDF

# 創(chuàng)建PDF對象
pdf = FPDF()
pdf.add_page()

# 設(shè)置字體
pdf.set_font('Arial', size=12)

# 添加文本
pdf.cell(200, 10, txt="Hello World!", ln=True, align='C')

# 保存PDF文件
pdf.output("example.pdf")

import smtplib
from email.mime.text import MIMEText

# 設(shè)置郵件內(nèi)容
msg = MIMEText("Hello, this is an automated email.")
msg['Subject'] = 'Automated Email'
msg['From'] = 'you@example.com'
msg['To'] = 'recipient@example.com'

# 發(fā)送郵件
with smtplib.SMTP('smtp.example.com', 587) as server:
    server.starttls()
    server.login("you@example.com", "password")
    server.send_message(msg)

import os

# 定義文件路徑
folder_path = '/path/to/folder'

# 遍歷文件并重命名
for filename in os.listdir(folder_path):
    new_name = "new_" + filename
    os.rename(os.path.join(folder_path, filename), os.path.join(folder_path, new_name))

import requests

urls = ['https://example.com/page1', 'https://example.com/page2']

for url in urls:
    response = requests.get(url)
    with open(url.split('/')[-1] + '.html', 'w') as file:
        file.write(response.text)

import matplotlib.pyplot as plt

# 數(shù)據(jù)
x = [1, 2, 3, 4, 5]
y = [10, 20, 25, 30, 40]

# 繪制折線圖
plt.plot(x, y)
plt.xlabel('X axis')
plt.ylabel('Y axis')
plt.title('Automated Plot')

# 保存圖片
plt.savefig('plot.png')

from docx import Document

# 創(chuàng)建Word文檔
doc = Document()
doc.add_heading('Automated Report', 0)
doc.add_paragraph('This is an automated report generated by Python.')

# 保存文檔
doc.save('report.docx')

import zipfile
import os

# 壓縮文件夾中的所有文件
with zipfile.ZipFile('archive.zip', 'w') as zipf:
    for root, dirs, files in os.walk('/path/to/folder'):
        for file in files:
            zipf.write(os.path.join(root, file))

import time
import win10toast

toaster = win10toast.ToastNotifier()

# 定時提醒
time.sleep(5)
toaster.show_toast("Reminder", "Time to attend the meeting!", duration=10)

import shutil
import time

# 定義源路徑和備份路徑
source_path = '/path/to/data'
backup_path = '/path/to/backup'

# 定時備份操作
while True:
    shutil.copytree(source_path, backup_path)
    print('Data backup completed.')
    time.sleep(3600)  # 每隔一小時備份一次