CSV Statistics
Calculate mean, median, standard deviation from CSV numeric data.
About this tool
CSV Statistics is a browser-based tool that analyzes numeric data from CSV files to calculate essential statistical measures such as mean, median, and standard deviation. It processes data entirely in your browser without uploading to any server, making it ideal for analyzing sensitive datasets, financial records, or research data that should remain private.
To use the tool, paste or upload your CSV data with numeric columns. The calculator automatically detects numeric columns and computes key statistics for each one, displaying results in a clear summary. You can use it for analyzing exam scores, test results, sales figures, sensor measurements, or any dataset where you need quick statistical insights without manual calculations.
Frequently Asked Questions
Code Implementation
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))Comments & Feedback
Comments are powered by Giscus. Sign in with GitHub to leave a comment.