Does Datio fill in missing values automatically?

No — there is no automatic imputation. Datio shows you exactly where the blanks are (null in tables, counted per column), and you decide whether to drop the rows in the Cleaner, filter them out, or fix them at the source.

How are blank cells displayed versus exported?

Blank cells display as null in tables so they are easy to spot, but they export as genuinely empty cells in CSV. Empty CSV cells become null again if you convert to JSON.

Documentation

Handling missing values

Find blanks with the Profiler, then decide how to handle them.

Quick answer

Profile the file to get per-column and total missing counts, then decide: drop fully empty rows in the CSV Cleaner, keep rows where key columns are present with Transform & Filter, and re-profile to confirm the counts changed.

Steps

Open Tools → Data Profiler and load the file.
Read the per-column missing counts and the total missing-cell count.
Open the same file in CSV Cleaner to remove fully empty rows if they are noise.
For partially empty rows, use Transform & Filter to keep only rows where key columns are present.
Re-profile the cleaned file to confirm the counts changed as expected.

Tips

Datio shows blanks as null in tables but exports them as empty cells.
There is no automatic imputation — you decide whether to drop or fix rows.

Common questions

Does Datio fill in missing values automatically?: No — there is no automatic imputation. Datio shows you exactly where the blanks are (null in tables, counted per column), and you decide whether to drop the rows in the Cleaner, filter them out, or fix them at the source.
How are blank cells displayed versus exported?: Blank cells display as null in tables so they are easy to spot, but they export as genuinely empty cells in CSV. Empty CSV cells become null again if you convert to JSON.

Use it in

Back to documentation Cleaning data Removing duplicates Converting formats

Documentation

Handling missing values

Find blanks with the Profiler, then decide how to handle them.

Quick answer

Steps

Open Tools → Data Profiler and load the file.
Read the per-column missing counts and the total missing-cell count.
Open the same file in CSV Cleaner to remove fully empty rows if they are noise.
For partially empty rows, use Transform & Filter to keep only rows where key columns are present.
Re-profile the cleaned file to confirm the counts changed as expected.

Tips

Datio shows blanks as null in tables but exports them as empty cells.
There is no automatic imputation — you decide whether to drop or fix rows.

Common questions

Does Datio fill in missing values automatically?: No — there is no automatic imputation. Datio shows you exactly where the blanks are (null in tables, counted per column), and you decide whether to drop the rows in the Cleaner, filter them out, or fix them at the source.
How are blank cells displayed versus exported?: Blank cells display as null in tables so they are easy to spot, but they export as genuinely empty cells in CSV. Empty CSV cells become null again if you convert to JSON.

Use it in

Back to documentation Cleaning data Removing duplicates Converting formats

Handling missing values

Quick answer

Steps

Tips

Common questions

Use it in

Loading Datio workspace…

Handling missing values

Quick answer

Steps

Tips

Common questions

Use it in