import pandas as pd
import os
# 文件夾路徑
folder\_path = 'your\_folder\_path'
for filename in os.listdir(folder\_path):
    if filename.endswith('.xlsx'):
        file\_path = os.path.join(folder\_path, filename)
        df = pd.read\_excel(file\_path)
        \# 這里可以對df進(jìn)行各種操作，比如新增一列
        df\['new\_column'] = df\['原有列'] \* 2
        df.to\_excel(file\_path, index=False)

import smtplib
from email.mime.text import MIMEText
from email.header import Header
# 發(fā)件人郵箱
sender = "your\_email@example.com"
# 收件人郵箱
receivers = \["recipient\_email@example.com"]
# 郵件內(nèi)容
message = MIMEText('郵件內(nèi)容', 'plain', 'utf-8')
message\['From'] = Header("發(fā)件人姓名", 'utf-8')
message\['To'] = Header("收件人姓名", 'utf-8')
message\['Subject'] = Header("郵件主題", 'utf-8')
try:
    smtpObj = smtplib.SMTP('smtp.example.com', 587)
    smtpObj.starttls()
    smtpObj.login(sender, "password")
    smtpObj.sendmail(sender, receivers, message.as\_string())
    print("郵件發(fā)送成功")
except smtplib.SMTPException as e:
    print("Error: 無法發(fā)送郵件", e)

import os
folder\_path = 'your\_folder\_path'
count = 1
for filename in os.listdir(folder\_path):
    if os.path.isfile(os.path.join(folder\_path, filename)):
        new\_name = f'new\_name\_{count}{os.path.splitext(filename)\[1]}'
        os.rename(os.path.join(folder\_path, filename), os.path.join(folder\_path, new\_name))
        count += 1

import pandas as pd
df = pd.read\_csv('your\_data.csv')
# 去除重復(fù)行
df = df.drop\_duplicates()
# 處理缺失值，這里用0填充
df = df.fillna(0)
df.to\_csv('cleaned\_data.csv', index=False)

from pptx import Presentation
from pptx.util import Inches
prs = Presentation()
title\_slide\_layout = prs.slide\_layouts\[0]
slide = prs.slides.add\_slide(title\_slide\_layout)
title = slide.shapes.title
subtitle = slide.placeholders\[1]
title.text = "PPT標(biāo)題"
subtitle.text = "PPT副標(biāo)題"
# 后續(xù)可以添加更多內(nèi)容，如圖片、表格等
prs.save('test.pptx')

from selenium import webdriver
driver = webdriver.Chrome()
driver.get('https://www.example.com')
# 查找元素并操作
element = driver.find\_element\_by\_id('element\_id')
element.click()
# 關(guān)閉瀏覽器
driver.quit()

import PyPDF2
pdf\_file = open('your\_pdf.pdf', 'rb')
pdf\_reader = PyPDF2.PdfReader(pdf\_file)
text = ""
for page\_num in range(len(pdf\_reader.pages)):
    page = pdf\_reader.pages\[page\_num]
    text += page.extract\_text()
print(text)
pdf\_file.close()

import pandas as pd
import matplotlib.pyplot as plt
df = pd.read\_csv('data.csv')
# 假設(shè)統(tǒng)計(jì)某列數(shù)據(jù)
data = df\['column\_name'].value\_counts()
data.plot(kind='bar')
plt.title('數(shù)據(jù)統(tǒng)計(jì)報(bào)表')
plt.xlabel('類別')
plt.ylabel('數(shù)量')
plt.savefig('report.png')

import shutil
import os
source\_folder = 'your\_source\_folder'
backup\_folder = 'your\_backup\_folder'
if not os.path.exists(backup\_folder):
    os.makedirs(backup\_folder)
for filename in os.listdir(source\_folder):
    file\_path = os.path.join(source\_folder, filename)
    if os.path.isfile(file\_path):
        shutil.copy2(file\_path, backup\_folder)

from apscheduler.schedulers.blocking import BlockingScheduler
import your\_script
scheduler = BlockingScheduler()
# 每天凌晨1點(diǎn)執(zhí)行任務(wù)
scheduler.add\_job(your\_script.run, 'cron', hour=1)
scheduler.start()