import pandas as pd

# 讀取Excel文件
df = pd.read_excel("your_excel_file.xlsx")

# 數(shù)據(jù)清洗（填充缺失值，轉(zhuǎn)換數(shù)據(jù)類型）
df['列名'].fillna(0, inplace=True)
df['日期'] = pd.to_datetime(df['日期'])

# 數(shù)據(jù)透視表
pivot_table = pd.pivot_table(df, values='銷售額', index='地區(qū)', columns='產(chǎn)品', aggfunc='sum')

# 保存結(jié)果到新Excel
pivot_table.to_excel("pivot_report.xlsx")

from openpyxl import Workbook
from openpyxl.styles import PatternFill

# 創(chuàng)建一個新的Excel文件
wb = Workbook()
sheet = wb.active

# 寫入數(shù)據(jù)
sheet['A1'] = 'Hello, Excel!'

# 設(shè)置單元格背景顏色
cell = sheet['A1']
cell.fill = PatternFill(start_color="FFFF00", end_color="FFFF00", fill_type = "solid")

# 保存Excel文件
wb.save("example.xlsx")

import xlwings as xw

# 連接到Excel應用程序
app = xw.App(visible=True, add_book=False)  # 啟動Excel并可見，不創(chuàng)建新的工作簿
wb = app.books.open('your_excel_file.xlsx') # 打開已存在的工作簿
sheet = wb.sheets['Sheet1']
sheet.range('A1').value = 'Hello from Python!' # 寫入數(shù)據(jù)
wb.save() # 保存Excel文件
wb.close()
app.quit() # 關(guān)閉Excel程序

from pptx import Presentation
from pptx.util import Inches

# 創(chuàng)建一個新的PPT
prs = Presentation()
blank_slide_layout = prs.slide_layouts[5]  # 獲取一個空白幻燈片布局

# 添加幻燈片
slide = prs.slides.add_slide(blank_slide_layout)

# 添加標題
title = slide.shapes.title
title.text = "我的自動化PPT報告"

# 添加文本框
left = top = Inches(2.0)
width = Inches(6.0)
height = Inches(1.0)
textbox = slide.shapes.add_textbox(left, top, width, height)
text_frame = textbox.text_frame
text_frame.text = "使用Python自動生成PPT!"

# 保存PPT
prs.save("automated_report.pptx")

from reportlab.pdfgen import canvas
from reportlab.lib.units import inch

# 創(chuàng)建一個PDF文件
c = canvas.Canvas("report.pdf")

# 繪制文本
c.drawString(inch, 7.5 * inch, "Hello, PDF!")

# 繪制圖片（假設(shè)圖片名為test.png）
# c.drawImage("test.png", inch, 6 * inch, width=2*inch, height=1.5*inch)

# 結(jié)束并保存
c.save()

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

# 郵件服務器配置
sender_email = "your_email@example.com"
receiver_email = "recipient@example.com"
password = "your_password" # 請使用App密碼

# 創(chuàng)建郵件內(nèi)容
message = MIMEMultipart()
message["From"] = sender_email
message["To"] = receiver_email
message["Subject"] = "Python 自動發(fā)送郵件"

body = "這是使用Python自動發(fā)送的郵件內(nèi)容。"
message.attach(MIMEText(body, "plain"))

# 連接郵件服務器并發(fā)送郵件
try:
    with smtplib.SMTP_SSL("smtp.example.com", 465) as server: # 使用SSL
        server.login(sender_email, password)
        server.sendmail(sender_email, receiver_email, message.as_string())
    print("郵件發(fā)送成功!")
except Exception as e:
    print(f"郵件發(fā)送失敗: {e}")

import schedule
import time

def job():
    print("定時任務正在執(zhí)行...")

# 每隔一段時間執(zhí)行一次任務
schedule.every(10).seconds.do(job) # 每10秒
schedule.every().hour.do(job)       # 每小時
schedule.every().day.at("10:30").do(job) # 每天10:30

# 循環(huán)執(zhí)行
while True:
    schedule.run_pending() # 運行待處理的任務
    time.sleep(1)

import os
import shutil

# 創(chuàng)建目錄
if not os.path.exists("backup_folder"):
    os.makedirs("backup_folder")

# 復制文件
shutil.copy2("source.txt", "backup_folder/source.txt")

# 列出目錄下的所有文件
for filename in os.listdir("."):
    print(filename)

# 刪除文件
# os.remove("file_to_delete.txt")

import requests
from bs4 import BeautifulSoup

# 發(fā)送GET請求獲取網(wǎng)頁內(nèi)容
url = "https://www.example.com"
response = requests.get(url)

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

# 提取所有鏈接
for link in soup.find_all('a'):
    print(link.get('href'))