Skip to content

Generating Automated Reports

What a report pipeline looks like

Collect data (CSV, API, DB)
Clean/aggregate
Render output (Excel/Docx/PDF)
Distribute (email/Slack)
Schedule (cron/schedule)

Mini example: CSV -> Excel

csv_to_excel.py

import csv
from openpyxl import Workbook
 
wb = Workbook()
ws = wb.active
 
with open("input.csv", newline="", encoding="utf-8") as f:
    reader = csv.reader(f)
    for row in reader:
        ws.append(row)
 
wb.save("output.xlsx")

csv_to_excel.py

import csv
from openpyxl import Workbook
 
wb = Workbook()
ws = wb.active
 
with open("input.csv", newline="", encoding="utf-8") as f:
    reader = csv.reader(f)
    for row in reader:
        ws.append(row)
 
wb.save("output.xlsx")

Tips

keep configuration separate (YAML/JSON)
add logging + error handling
store outputs with timestamps

🧪 Try It Yourself

Exercise 1 – List Files with os.listdir

Exercise 2 – Join Paths with os.path.join

Exercise 3 – Write and Read a File

If this helped you, consider buying me a coffee ☕

Buy me a coffee