CSV/JSON Column Stats
Convert CSV and JSON locally, preview rows, and compute descriptive statistics for numeric columns.
Rows summarized
Paste data
Converted output and column stats will appear below.
Converted output
| Column | Type | Count | Missing | Mean | Median | Sample SD |
|---|
| Row | Values |
|---|
sample SD = sqrt(sum((x - mean)^2) / (n - 1))
How?
How this is calculated
CSV is parsed with quote-aware records and a detected or selected delimiter. JSON uses the browser's standard JSON parser. Numeric summaries use finite numeric values only, and sample standard deviation uses denominator n minus 1. Conservative inference keeps leading-zero IDs and unsafe long integers as text.
Formula: sample SD = sqrt(sum((x - mean)^2) / (n - 1))
Sources
- RFC 4180, Common Format and MIME Type for CSV Files. IETF. Retrieved .
- RFC 8259, The JavaScript Object Notation Data Interchange Format. IETF. Retrieved .
- NIST Engineering Statistics Handbook, Measures of Location. NIST. Retrieved .
- NIST Engineering Statistics Handbook, Measures of Scale. NIST. Retrieved .
Method last reviewed