banner

For a full list of BASHing data blog posts, see the index page.     RSS


How to enter nothing in a database

I call them NITS, which is short for Nothing Interesting To Say. They're the filler items that appear in spreadsheets and databases when the person entering the data has no information for a particular field. Here are some real-world examples from the databases I've audited:

NITS1

Besides these all-purpose NITS, I've also seen filler items tailored to specific fields. Sometimes these almost have information content. Examples:

NITS are a nuisance in data cleaning. Like blank records and blank fields, they contribute nothing useful to a database and muck up the tally of a field's contents.

Ugly:

NITS2

Nice:

NITS3

If you have nothing to enter in a field for a particular record, there's nothing wrong with leaving the data item blank. Please?


Last update: 2018-10-18