Missing Value

noun

say it: “MIS-ing VAL-yoo” /ˈmɪsɪŋ ˈvælju/

An empty spot in a table where a value should be, because nobody recorded it.

What is a missing value?

A missing value is a cell with no value in it: left blank, or typed as a word such as unknown or - that means nobody knew. pandas shows it as NaN, and counts and averages leave it out, so check how many are missing before you trust a number.

import pandas as pd
intake = pd.read_csv("intake.csv", na_values=["unknown", "-"])
intake.isna().sum()      # how many missing values each column has

In a sentence

  • “A volunteer typed 'unknown' for the breed, which pandas can read as a missing value.”
  • “Fifty-two ages were left blank, and each missing value meant one fewer animal in the average.”

Level: Novice · More Python terms at this level

Updated