Compute Percentiles for NDJSON Files Online
Compute percentiles, median, MAD, mode, and kurtosis for numeric columns in NDJSON files directly in your browser. Optionally group by a category column. Results download as CSV — no upload required.
About this tool
Compute distribution statistics for any numeric column in a NDJSON file: median (p50), p25, p75, p90, p95, p99, MAD (Median Absolute Deviation), mode, kurtosis, and any custom percentile you specify. Optionally group by a category column to get per-group statistics. The output is a compact summary table ready to download as CSV. This goes beyond the basic sum/avg/min/max of the Aggregate tool — use it when you need to understand the full distribution of a column, spot skew, or calculate SLO targets. Runs locally in your browser.
Frequently Asked Questions
What is the difference between quantile_cont and median in a NDJSON file?
median() is exactly equivalent to quantile_cont(col, 0.5) — the 50th percentile using linear interpolation. quantile_cont always interpolates between real values if the exact percentile falls between two data points. quantile_disc (discrete) always returns an actual value from the dataset.
What is MAD and when should I use it for NDJSON data?
MAD stands for Median Absolute Deviation — it measures the spread of the data around the median. It is more robust than standard deviation because it is not affected by extreme outliers. Use it when your data has heavy tails or outliers that would inflate the standard deviation.
Can I compute percentiles per group in a NDJSON file?
Yes. Set the Group By column and all selected statistics are computed independently within each group. The output has one row per group with all the requested statistics as columns.
Is my data private?
Yes — completely. Your file is never uploaded to any server. Everything runs locally in your browser using WebAssembly — processing happens entirely inside your tab. Once you close the tab, nothing is retained.
What is the maximum file size?
The free limit is 50 MB. For larger files, performance depends on your device's available memory — most modern machines handle 500 MB to 1 GB comfortably.
Related Tools
Convert NDJSON to XML Online
Convert NDJSON files to XML directly in your browser. Download a structured XML document with one element per row — no upload required.
Convert NDJSON to SQL Online
Convert NDJSON files to SQL INSERT statements directly in your browser. Copy or download the generated SQL — no upload required.
Convert NDJSON to Markdown Table Online
Convert NDJSON files to a Markdown table directly in your browser. Copy the output and paste it into any Markdown document.
Convert NDJSON to HTML Table Online
Convert NDJSON files to an HTML table directly in your browser. Copy the markup or download a ready-to-use HTML file.
Compute Percentiles for CSV Files Online
Compute percentiles, median, MAD, mode, and kurtosis for numeric columns in CSV files directly in your browser. Optionally group by a category column. Results download as CSV — no upload required.