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