Skip to main content

Missing-data analysis

Find and Explain Missing Values in a CSV

Measure missingness by column and group, distinguish true nulls from parsing errors and decide what needs correction.

Use the matching tool

Missing Value Report

Open Missing Value Report

What the error actually means

Missing cells may reflect optional fields, failed collection, inapplicable questions or parsing mistakes. A total percentage alone can hide concentrated gaps in one location, period or category. Investigation should preserve the distinction between these mechanisms.

Likely causes

  • Data was not collected.
  • A field was not applicable.
  • Null markers were interpreted inconsistently.
  • A malformed row shifted values.

Missingness by group

Problem

Age is 8% missing overall

Correct pattern

Age is 1% missing in four sites and 36% missing in one site, prompting source review

A safe repair workflow

  1. 1Standardize approved null markers.
  2. 2Calculate counts by column.
  3. 3Break critical missingness down by relevant groups.
  4. 4Trace unexpected patterns to the source.

How to verify the result

A file that downloads successfully is not automatically a correct file. Check the result at both the structural and business-data levels:

  • Structural errors were excluded.
  • Required and optional fields are distinguished.
  • Group-level concentrations are visible.
  • Any imputation is documented separately.

Read the deeper guides

How to Clean CSV Data Without Hiding the Original ProblemsLearn practical techniques to clean messy CSV files. Remove duplicates, fix formatting, and standardize data without Excel crashes or complex scripts.How to Prepare CSV Files for Python PandasPrepare CSV files for reliable pandas imports by making encoding, delimiters, nulls, dates, identifiers, and column types explicit.