Data Science & AI Literacy · Foundations
Missing Data
On this page 9 sections
In 30 seconds
missing data Entries in a dataset that were never recorded, leaving blank cells where values were expected. Full entry → means blank cells in a dataset: a survey question no one answered, a sensor reading that never arrived, a record that was lost. Gaps are normal in real data, but they are never neutral. The pattern of missingness, and the way you handle it — dropping rows Removing entire records that contain missing values so that only complete records remain in the dataset. Full entry →, filling values, flagging the gap — can change what an analysis appears to say. Honest analyses report how much data was missing and what they did about it.
Why this matters
Every real dataset has gaps, and the choices made about those blanks shape the conclusions. A hospital's appointment records, a city's traffic sensors, a retailer's sales logs — none are complete. Statisticians have studied missingness since the 1970s; Donald Rubin's 1976 framework of three missing-data mechanisms still organizes how analysts think about it. The stakes grow as data science spreads: models trained on poorly handled gaps inherit whatever distortion the handling introduced. Understanding missing data is also a reading skill — when you see a study, you can ask how much data was missing and what the authors did, and judge whether their answer is credible.
The college version
Gaps are the norm, not the exception
A dataset is a record of something that happened, and records are rarely perfect. A row in a table stands for one person, one day, one measurement — and sometimes part of that row never got recorded. The blank cell is not a value of zero; it is the absence of a recorded value. Missing data is the general term for these gaps. Most real-world analyses start by counting them: the number and location of gaps already tell you something before any analysis begins. A column where a third of the entries are empty is a finding in itself.
Three ordinary routes to a gap
Values usually go missing in one of three everyday ways. First, people skip questions. In a course feedback form, students who loved or hated the class often leave a rating, while mildly satisfied students scroll past it — so the ratings you have are not a random sample of all students. Second, instruments fail. A weather station's rainfall sensor goes offline during a storm, a warehouse temperature logger's battery dies midweek, or a fitness tracker sits in a drawer for three days. Sometimes the equipment simply broke, and the gap has nothing to do with what was being measured; but equipment often fails precisely when conditions are extreme, and then the gaps depend on the very values that went unrecorded. Third, records are lost or never entered. A clinic's paper intake forms from one week are misplaced before scanning, a new cashier forgets to scan one product category, or a file-transfer step silently skips rows. Each route leaves the same visible symptom — a blank cell — but the three routes have very different meanings.
Why the pattern of missingness matters
In 1976 the statistician Donald Rubin introduced a way of classifying missingness that analysts still use, and it turns on one question: does the gap relate to anything else in the data? If the missing values are scattered with no connection to the data — like a sprinkler that randomly wets some pages of a notebook — the pattern is called missing completely at random (MCAR) A missingness pattern in which gaps are unrelated to any value in the dataset, so the blanks are scattered as if by chance. Full entry →. MCAR is the friendliest case: ignoring the gaps wastes a little information, but it does not bend the results. If the chance of a gap depends on something you can see — students who score low on a pre-test are more likely to skip the post-test, so the missing scores are explainable from the pre-test — the pattern is missing at random (MAR) A missingness pattern in which the chance of a gap depends on values that were observed, such as a skipped follow-up question explained by an earlier answer. Full entry →. The gap is not random at all, but its cause is visible in the data you still have. The dangerous case is missing not at random (MNAR) A missingness pattern in which the chance of a gap depends on the missing value itself, such as high earners withholding their income. Full entry →: the chance of a gap depends on the missing value itself. People with very high incomes are more likely to withhold their income; patients with severe symptoms are more likely to drop out of a treatment study. Nothing you still have fully explains these gaps, because the thing that explains them is precisely what is missing.
Four ways analysts respond
Analysts respond to gaps with a few standard moves, each with a price. Dropping the row removes the incomplete record and keeps only fully recorded values. It is simple and honest, but it throws away everything else that row contained — and if the missing rows differ from the rest, the rows left behind no longer represent the whole group. Filling in a value (often called imputation The practice of filling a missing value with a placeholder such as an average or an estimated value. Full entry →) replaces each blank with a placeholder such as the average of the column, a typical value, or an estimated one. The row survives, but the filled number is a guess wearing the uniform of a real measurement, and repeated guesses can pull the whole picture toward the middle. Flagging leaves the gap in place but marks it, for example with a column recording whether a value was missing, so nothing downstream mistakes the blank for a real zero. Investigating means going back to the source: asking the people who collected the data, checking the instrument's logs, finding the lost forms. It is the only option that can recover information instead of spending it.
Handling choices can create bias
The key warning: both filling and dropping are interventions, and interventions can distort. Dropping rows when the gaps are not random removes one kind of person, one kind of day, one kind of failure. Filling with an average pulls unusual rows toward the middle, shrinking the variation you may be trying to study. Microsoft's machine-learning documentation puts it plainly: the cleaning method you choose for missing values can dramatically affect your results. Every handling choice assumes something about the values that are absent. If the assumption is wrong — and with MNAR it usually is — the analysis inherits the error. That does not make handling choices wrong; it makes them decisions, which means they need a reason, not a default.
Report the gaps honestly
A credible analysis states how much data was missing, where the gaps were, what was done about them, and why. The research literature is explicit: researchers should acknowledge the missing-data problem and the conditions under which it occurred. Readers can then judge whether the handling was reasonable, and reviewers can hold authors to the standard. A report that says only 'after cleaning, the final dataset had 4,800 rows' has hidden a decision; one that says '540 of 5,340 records were missing a satisfaction score, and we kept those rows but flagged the blanks' has made the decision visible. Missingness is not a blemish to be tidied away; it is a property of the data, and describing it is part of describing the data.

Eli explains
The same idea, in plain words
Explain it like I’m 10
Missing data is just blank cells where a value should be. Blanks happen all the time: someone skips a question, a sensor stops working, a form gets lost. The important question is why the blanks appeared. If gaps are scattered with no pattern, they cost you a little information but nothing more. If gaps depend on something you already know about, they are explainable. If gaps depend on the missing value itself — rich people hiding income, sick patients dropping out — that is the dangerous kind, because nothing you have left explains it. Analysts can drop the row, fill in a guess, mark the gap, or go find the real value. Whatever they choose can quietly change the answer, so honest work says how much was missing and what was done.
Picture it like this
Think of a jigsaw puzzle missing some pieces. If the missing pieces are scattered evenly, you can still see most of the picture and guess the rest. If a whole corner is missing, the picture is distorted where it matters, and the pieces that are gone explain something about the corner itself — maybe that part of the puzzle was damaged. Deciding whether to fill the gaps with guesses or leave them empty changes the picture you present.
Where the picture stops working
Puzzle pieces are gone forever, but missing data can sometimes be recovered by going back to the source. And in data, the pattern of missingness is itself information worth reporting, which a jigsaw puzzle does not communicate.
Worked example
A neighborhood clinic collects 600 appointment-satisfaction forms each month. This month, 54 forms arrived without a satisfaction rating, and 6 forms never arrived at all. The office manager counts the gaps first: 54 of 600 forms are missing a rating, and 6 are missing entirely. Looking closer, she notices that patients over 65 were far more likely to leave the rating blank. That pattern rules out 'missing completely at random' — the gaps track something observable, the patients' age. Dropping all 54 rows would quietly remove older patients from the analysis, which could make the clinic's satisfaction numbers look rosier than they are. Filling each blank with the average rating would hide the fact that older patients were underserved. She keeps the rows, flags the blanks with a 'rating missing' column, and reports: 54 skipped ratings plus 6 lost forms out of 600, with the age pattern noted, and the flagged approach chosen so the clinic's managers can see the gap rather than a smoothed-over number.
Key takeaway
Missing data is normal but never neutral: the pattern of gaps and the way you handle them can quietly change your conclusions. Count the gaps, choose a handling method with its trade-offs in mind, and report both what was missing and what you did.
Quick check
3 questions here, of 5 in this lesson’s practice set. Answers stay hidden until you check.
A school measures students' heights each September. Three students were absent on measuring day for unrelated reasons, so their heights are missing. Which pattern is this most like?
A survey asks people about their income, and higher earners are more likely to skip that question. Why is this the most dangerous pattern of missingness?
Study tools & related lessonsYou’ll learn to · Common mistakes · Easily confused · Key vocabulary · Related
You’ll learn to
- Define missing data and describe the common ways values go missing in real datasets.
- Distinguish the three missingness patterns — missing completely at random, missing at random, and missing not at random — at an intuitive level.
- Explain the trade-offs of the main handling options: dropping rows, filling values, flagging gaps, and investigating why data is missing.
- Apply the principle that filling or dropping data can itself introduce bias.
- Explain what an honest report of missingness should state.
Common mistakes
Deleting every row with a gap without checking whether those rows differ from the rest.
Compare the complete rows with the incomplete ones first; if they differ, dropping them changes what the dataset represents.
Filling blanks with an average and then reporting the filled numbers as if they were real measurements.
A filled value is a placeholder. Report that imputation happened, and treat the filled entries differently from recorded ones.
Reading a blank cell as zero.
A blank means 'no value was recorded'; zero is a recorded value. Mistaking one for the other invents data.
Publishing results without saying how much data was missing or what was done about it.
State the count and location of gaps, the handling method, and the reason for it, so readers can judge the analysis.
Easily confused
A blank cell vs. A recorded zero
A blank means no value was recorded at all; a zero is a real measurement. They carry completely different information and must not be merged.
Dropping rows with gaps vs. Filling gaps with a value
Dropping keeps only real data but loses entire records; filling keeps the records but adds guessed values. Both can distort results, in different directions.
Missing completely at random vs. Missing not at random
In MCAR the gaps are unrelated to the data and mostly harmless; in MNAR the gaps depend on the missing values themselves and are the hardest to fix safely.
Key vocabulary
- missing data
- Entries in a dataset that were never recorded, leaving blank cells where values were expected.
- missing completely at random (MCAR)
- A missingness pattern in which gaps are unrelated to any value in the dataset, so the blanks are scattered as if by chance.
- missing at random (MAR)
- A missingness pattern in which the chance of a gap depends on values that were observed, such as a skipped follow-up question explained by an earlier answer.
- missing not at random (MNAR)
- A missingness pattern in which the chance of a gap depends on the missing value itself, such as high earners withholding their income.
- nonresponse
- A missing value caused by a person who did not answer a question or participate in a survey.
- imputation
- The practice of filling a missing value with a placeholder such as an average or an estimated value.
- dropping rows
- Removing entire records that contain missing values so that only complete records remain in the dataset.
- flagging missingness
- Marking gaps explicitly, for example with an indicator column, so later steps can tell a blank from a real value.
Sources & references
- Principled missing data methods for researchers — SpringerPlus (via PubMed Central, PMC3701793)
- Clean Missing Data: Component Reference - Azure Machine Learning — Microsoft Learn
- Missing Data Methods and Toolbox Users Guide (NISTIR 7023) — National Institute of Standards and Technology (NIST)
EliExplains lessons are original prose written from the open, credible references above. See Copyright & Licensing.
Researched 2026-08-21
Educational content only. It is not medical, legal or professional advice. Found an error? Tell us.

