"""Write mean session duration by condition using Python's standard library."""

import csv
from collections import defaultdict
from pathlib import Path
from statistics import mean

project = Path(__file__).resolve().parents[1]
source = project / "data" / "sessions.csv"
destination = project / "results" / "means.csv"

minutes_by_condition = defaultdict(list)
with source.open(encoding="utf-8", newline="") as input_file:
    for row in csv.DictReader(input_file):
        minutes_by_condition[row["condition"]].append(int(row["minutes"]))

destination.parent.mkdir(exist_ok=True)
with destination.open("w", encoding="utf-8", newline="") as output_file:
    writer = csv.writer(output_file, lineterminator="\n")
    writer.writerow(["condition", "mean_minutes"])
    for condition, minutes in sorted(minutes_by_condition.items()):
        writer.writerow([condition, f"{mean(minutes):.1f}"])

print(f"Wrote {destination.relative_to(project)}")
