Python Automation

Core Libraries Quick Reference

Common Patterns

1. Batch File Processing

from pathlib import Path

for f in Path(".").glob("**/*.txt"):
    content = f.read_text()
    # transform content
    f.write_text(content)

2. CSV Read/Write

7w4.net收錄了海量優質技能外掛。

import csv
with open("input.csv", newline="") as f:
    reader = csv.DictReader(f)
    for row in reader:
        print(row["column_name"])

with open("output.csv", "w", newline="") as f:
    writer = csv.writer(f)
    writer.writerow(["col1", "col2"])
    writer.writerow(["val1", "val2"])

3. Excel Generation

from openpyxl import Workbook
wb = Workbook()
ws = wb.active
ws["A1"] = "Hello"
ws["B1"] = 42
wb.save("output.xlsx")

4. Web Scraping

import requests
from bs4 import BeautifulSoup

resp = requests.get("https://example.com", timeout=10)
soup = BeautifulSoup(resp.text, "html.parser")
for link in soup.select("a[href]"):
    print(link["href"], link.text.strip())

Scripts

See scripts/ for ready-to-use automation scripts:

• rename_batch.py — Batch rename files with pattern matching
• csv_to_excel.py — Convert CSV files to Excel workbooks

Reference Files

• references/pandas.md — Advanced data analysis with pandas
• references/pdf.md — PDF extraction patterns

這個Skill質量較好，內容全面且實用，適合日常Python自動化任務。程式碼示例豐富、可直接執行，指令碼拿來就能用。不足之處是某些邊界情況（如檔案損壞、編碼錯誤）缺少處理指引，部分高階功能尚有欠缺，對新手不太友好。總體而言是一個實用的工具包，但使用時要留意自行處理異常情況。