How to Write Python Code with AI: Real Examples & Prompts 2026

"""Auto-organise Downloads by file extension."""
import shutil
from pathlib import Path

DOWNLOADS = Path.home() / "Downloads"

CATEGORIES = {
    "Images":    [".jpg", ".jpeg", ".png", ".gif", ".webp", ".heic"],
    "Documents": [".pdf", ".doc", ".docx", ".txt", ".pages", ".md"],
    "Sheets":    [".xlsx", ".xls", ".csv", ".numbers"],
    "Videos":    [".mp4", ".mov", ".avi", ".mkv", ".wmv"],
    "Archives":  [".zip", ".rar", ".gz", ".tar", ".7z"],
}

def get_category(suffix: str) -> str:
    suffix = suffix.lower()
    for cat, exts in CATEGORIES.items():
        if suffix in exts:
            return cat
    return "Other"

moved = 0
for file in DOWNLOADS.iterdir():
    if file.is_dir():
        continue
    dest_dir = DOWNLOADS / get_category(file.suffix)
    dest_dir.mkdir(exist_ok=True)
    shutil.move(str(file), str(dest_dir / file.name))
    print(f"✅ {file.name} → {dest_dir.name}/")
    moved += 1

print(f"\nDone. Moved {moved} file(s).")

# pip install requests beautifulsoup4
import smtplib, requests
from email.mime.text import MIMEText
from bs4 import BeautifulSoup

PRODUCT_URL  = "https://example.com/product"
TARGET_PRICE = 199.99
EMAIL_FROM   = "you@gmail.com"
EMAIL_TO     = "you@gmail.com"
APP_PASSWORD = "your_app_password"  # Gmail App Password

def get_price(url: str) -> float | None:
    try:
        headers = {"User-Agent": "Mozilla/5.0"}
        r = requests.get(url, headers=headers, timeout=10)
        r.raise_for_status()
        soup = BeautifulSoup(r.text, "html.parser")
        # Adjust selector to match the site's price element:
        price_tag = soup.select_one("[class*='price']")
        if price_tag:
            raw = price_tag.get_text(strip=True).replace("$", "").replace(",", "")
            return float(raw)
    except Exception as e:
        print(f"Error fetching price: {e}")
    return None

def send_alert(price: float) -> None:
    body = f"Price dropped to ${price:.2f}! (Target: ${TARGET_PRICE})\n{PRODUCT_URL}"
    msg = MIMEText(body)
    msg["Subject"] = f"🔔 Price Alert: ${price:.2f}"
    msg["From"]    = EMAIL_FROM
    msg["To"]      = EMAIL_TO
    try:
        with smtplib.SMTP_SSL("smtp.gmail.com", 465) as server:
            server.login(EMAIL_FROM, APP_PASSWORD)
            server.send_message(msg)
        print("✅ Alert email sent!")
    except smtplib.SMTPException as e:
        print(f"SMTP error: {e}")

price = get_price(PRODUCT_URL)
if price is not None:
    print(f"Current price: ${price:.2f}")
    if price < TARGET_PRICE:
        send_alert(price)
    else:
        print("Price not low enough yet.")

# pip install pandas openpyxl
import pandas as pd
from openpyxl import load_workbook
from openpyxl.styles import Font, PatternFill, Alignment
from openpyxl.utils import get_column_letter

df = pd.read_csv("sales_data.csv")

by_person = df.groupby("Salesperson")["Amount"].sum().reset_index()
by_region = df.groupby("Region")["Amount"].sum().reset_index()

# Append totals row
by_person.loc[len(by_person)] = ["TOTAL", by_person["Amount"].sum()]
by_region.loc[len(by_region)] = ["TOTAL", by_region["Amount"].sum()]

with pd.ExcelWriter("weekly_report.xlsx", engine="openpyxl") as writer:
    df.to_excel(writer, sheet_name="Raw Data", index=False)
    by_person.to_excel(writer, sheet_name="By Salesperson", index=False)
    by_region.to_excel(writer, sheet_name="By Region", index=False)

def format_sheet(ws):
    header_fill = PatternFill("solid", fgColor="1E40AF")
    for cell in ws[1]:
        cell.font      = Font(bold=True, color="FFFFFF")
        cell.fill      = header_fill
        cell.alignment = Alignment(horizontal="center")
    for col in ws.columns:
        max_len = max(len(str(c.value or "")) for c in col)
        ws.column_dimensions[get_column_letter(col[0].column)].width = max_len + 4

wb = load_workbook("weekly_report.xlsx")
for sheet_name in wb.sheetnames:
    format_sheet(wb[sheet_name])
wb.save("weekly_report.xlsx")
print("✅ weekly_report.xlsx created.")