"""Office automation starter: three small jobs in one file. Run  python starter_kit.py  and pick a number.
pip install openpyxl pandas
"""
import csv, glob, os
import pandas as pd

def combine_csvs():
    files = glob.glob("*.csv")
    df = pd.concat([pd.read_csv(f).assign(SourceFile=f) for f in files], ignore_index=True)
    df.to_excel("combined.xlsx", index=False); print(f"combined {len(files)} files → combined.xlsx ({len(df)} rows)")

def summary_by_region():
    df = pd.read_csv("orders.csv")
    out = df.pivot_table(index="Region", values="Amount", aggfunc=["sum", "count"])
    out.to_excel("region_summary.xlsx"); print(out)

def rename_with_prefix():
    for f in sorted(glob.glob("*.pdf")):
        new = "2024_" + f
        print(f"{f} → {new}")   # preview only; uncomment next line to rename
        # os.rename(f, new)

jobs = {"1": combine_csvs, "2": summary_by_region, "3": rename_with_prefix}
choice = input("1 = combine CSVs, 2 = region summary, 3 = preview PDF renames: ").strip()
jobs.get(choice, lambda: print("Pick 1, 2 or 3"))()