CSV İstatistikleri

import csv, io, statistics

def csv_stats(csv_text: str) -> dict:
    reader = csv.DictReader(io.StringIO(csv_text))
    columns: dict[str, list[float]] = {}
    for row in reader:
        for key, val in row.items():
            try:
                columns.setdefault(key, []).append(float(val))
            except ValueError:
                pass
    result = {}
    for col, vals in columns.items():
        result[col] = {
            "count": len(vals),
            "mean": statistics.mean(vals),
            "median": statistics.median(vals),
            "stdev": statistics.stdev(vals) if len(vals) > 1 else 0,
            "min": min(vals),
            "max": max(vals),
        }
    return result

csv_text = """name,score
Alice,92
Bob,78
Carol,85"""
import json; print(json.dumps(csv_stats(csv_text), indent=2))