Missing data profiler
Inspect missingness by row, variable and repeated pattern without silently replacing missing values.
Profile top-level variables across JSON objects. Choose whether empty or whitespace-only strings count as missing; null and absent fields always do. Zero and false remain present. Nested values are present unless null. Reports contain counts, source row numbers and patterns without copying input values. At most 10,000 rows, 200 variables and 100,000 cells. No imputation is performed. Processing stays on your device. JSON supports up to 1,000,000 input characters, 50,000 values and 64 nesting levels. Duplicate keys and numbers that cannot survive JSON serialization exactly are rejected. Operations are limited to 100,000 comparisons, 4,000,000 JSON output characters and 8,000,000 CSV output characters. Tables show the first 200 rows; downloads preserve the complete report. CSV uses exact JSON Pointer paths and typed JSON value envelopes for spreadsheet-safe reporting. Profile top-level variables across JSON objects. Choose whether empty or whitespace-only strings count as missing; null and absent fields always do. Zero and false remain present. Nested values are present unless null. Reports contain counts, source row numbers and patterns without copying input values. At most 10,000 rows, 200 variables and 100,000 cells. No imputation is performed. Up to 1,000,000 characters. Review the settings before running.
Your result
How to use Missing data profiler
- Paste the documented input and choose the relevant settings.
- Run the local diagnostic and inspect its findings.
- Download the complete output and reports. Tables preview the first 200 rows.
Useful next steps
Make the missing-value definition explicit
Absent fields and null always count as missing. Choose whether empty strings or whitespace-only strings also count. Zero and false remain valid values. Each top-level object key is a variable; nested non-null values remain present. Reports identify source rows and missingness patterns but do not retain input cell values or perform imputation.
Keep the complete report
JSON records the full result, settings and assumptions. CSV contains exact JSON Pointer paths, value types and JSON value envelopes for every report node, including typed object and array markers. Preview limits do not truncate downloadable reports.