DataWhisperer solution

Check missing values and duplicate rows

“Before I use this file, which values are missing or duplicated?”

Situation

A survey export is ready for reporting, but blank score fields and repeated rows could change the figures you present.

How to get there

Open a file and expand Data profile
Inspect column summaries and common values
Review the accompanying Data health checks

What you get

Column types, missing-value percentages, and unique counts
Numeric summaries and common values
Duplicate-row, type-mismatch, and empty-column flags

A read-only column-by-column profile showing data types, missing values, unique and common values, numeric ranges, and summaries. Data health checks flag duplicate rows, type mismatches, and empty or constant columns.

Why DataWhisperer?

Know what to inspect in the source file.

Make an early check of the records that could change a reported score.

Find incomplete score columns

Locate blank score fields in the read-only column summaries.

Review suspect records at the source

Confirm flagged exact duplicates and type mismatches at the source, correct there, and upload the revised file.

Example

Data quality checked in ~1 sec

Representative 48-row sample estimate, not a timed action in this preview. File size and task vary; loading and display affect total elapsed time; not a browser completion guarantee.

Which score columns have blanks, and are any rows exact duplicates?

Start free