Missing Data Analyzer
Report missing cells per column and rows with any missing values.
About this tool
Drop a CSV and see, for every column, how many cells are empty and what percentage that is. You also get the total missing cells, how many rows have any gap, and the index of each incomplete row.
How to use
How it works
A cell is treated as missing when it is empty. For each column the tool reports present and missing counts and the missing percentage. Row indexes are zero-based positions among the data rows, not counting the header.
Worked example
One blank cell
- Input
- region,product,units,revenue ... East,Gadget,,45 ... (7 data rows)
- Output
- totalMissingCells 1 rowsWithAnyMissing 1 units: missing 1 (14.29%), present 6 incompleteRowIndexes: [5]
- Walkthrough
- Row index 5 is the sixth data row, the one with the empty units cell.
Limitations
- Only empty cells are missing. Placeholders such as NA, N/A, null or -- are treated as real text.
- It reports gaps but does not fill or drop them.
Questions
How do I find missing values in a CSV?
Does it detect NA or null strings?
Are row numbers zero-based?
Can it fill the gaps?
Features
- Missing per column
- Incomplete row indexes
- Runs in your browser
Related resources
Guides and videos from around the web—opens on YouTube or the publisher’s site.
SQL Tutorial - Full Database Course
freeCodeCamp.org
SQL and tabular data sit next to CSV/JSON data tools.
Watch on YouTubeLearn JSON - Full Crash Course
freeCodeCamp.org
JSON is a primary interchange format for data utilities.
Watch on YouTube
- Introducing JSON
json.org
JSON grammar for data format converters.
- Data Index
Math is Fun
Stats explainers when summarizing columns.