CSV/JSON Column Stats
Convert CSV and JSON locally, preview rows, and compute descriptive statistics for numeric columns.
At a glance
- Computes
- CSV to JSON conversion, a row preview, and descriptive statistics per numeric column.
- You supply
- Pasted CSV or JSON, with a delimiter, header, and missing-token setting.
- Use when
- You have a whole table and want per-column summaries without opening a spreadsheet.
- Not for
- A single list of numbers you already isolated. Standard Deviation Calculator
Rows summarized
Paste data
Converted output and column stats will appear below.
Converted output
| Column | Type | Count | Missing | Mean | Median | Sample SD |
|---|
| Row | Values |
|---|
Count by Column 1; 3 bins of width 1 (fd rule)
Count by Column 2; 3 bins of width 1 (fd rule)
Count by Column 3; 3 bins of width 1 (fd rule)
Count by Column 4; 3 bins of width 1 (fd rule)
Count by Column 5; 3 bins of width 1 (fd rule)
Count by Column 6; 3 bins of width 1 (fd rule)
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