DocTransform

Data profiling

See the type, the empty cells and what needs fixing in every column before you change anything.

What each header shows

Each column header shows a histogram and three counts, worked out from the first 1,000 rows. Types are inferred separately, from a random sample of 1,000 rows: about 20 are recognized, including numbers, dates, emails and currencies, and a value that does not fit its column's type counts as invalid.

IndicatorWhat it showsUse it to
HistogramThe shape of the column: where values cluster and where they do notSpot a skewed or odd distribution
nullHow many cells are emptyDecide whether to drop or fill them
invalidHow many values do not fit the column's typeFind values to fix
uniqueHow many distinct values existCatch duplicates in an ID column
clinicflow_visits.csv
Patient IDAgeVisit Date
H-1042342026-01-14
H-10431422026-01-15
H-1044N/A2026-01-16
  • 1 Raw import, before profiling.

Two groups: To fix and Tidy up

Open Health from the toolbar. It sorts what it finds into two groups. To fix holds values that do not fit their column, such as a word in a number column. Tidy up holds clean-ups that take one click, such as Repeated rows, Cells that say N/A or similar, Empty rows and an Almost empty column.

Act on a line

Click a line to jump to the first affected cell, then step through the rest. Each line has one button, such as Fix or Rewrite. Health then shows one message with the count and an Undo. The step is added to your template.