aNet.ai
Data Science/Learning path
0day streak0XP · Lv 1
← 3. Data Cleaning and Quality
Lesson 4.5 6 min · 99 words

Zero, missing and not applicable

These three meanings are different. Replacing them all with zero changes the question your numbers answer.

Zero lab-use hours means an enrolled student's observed use was zero. Missing hours means use is unknown. Not enrolled means the lab-use question may not apply; those students are outside a target population defined as enrolled lab students. Keep enrolled students with missing hours in the population count and report how many measurements are unavailable.

A missing marker may be an empty string, NaN, NA, a documented sentinel or an explicit not-applicable code. They are not automatically interchangeable. For example, the earlier lab's eq('') detects exact blank strings, not every possible kind of missing data in a general export.

Source: W3 PDF pp. 4-55. The 14-row registry example below comes from the Week 3 lab code you previously pasted in this conversation; it is separate from the lecture's smaller examples.

Practice problems

Supplementary study questions on the lecture concepts — not verbatim exam questions. Each answer counts toward spaced review.

1. Conceptual understanding

Definitions and distinctions.

Question 1 of 6 · +5 XP

What does an observed 0 hours of lab use mean?

Question 2 of 6 · +5 XP

When describing hours for enrolled lab students, who belongs in the population?

2. Application

Apply the concept to a case or calculation.

Question 3 of 6 · Observed zero · +5 XP

An enrolled student has verified 0 lab hours. Should this value enter an observed-hours mean?

Question 4 of 6 · Unknown amount · +5 XP

A blank hours field tells us what amount of use?

3. Interpretation and limitations

Evaluate assumptions and justify conclusions.

Question 5 of 6 · Not applicable · +5 XP

A person is not enrolled in the lab. For a summary of enrolled students' hours, they are what?

Question 6 of 6 · Denominators · +5 XP

Of 30 enrolled students, 24 have recorded hours, including zeros. What is valid n for the observed mean?

Explain it in writing

Self-checked, not marked. Write a few sentences, then compare with the example answer. Your writing is saved as you type.

Show an example answer

Yes. They belong in the enrolled population but not in the valid-measurement denominator for an observed mean. Report the missing count.

Check: did you answer the question, use evidence or working, and avoid claiming more than the evidence supports?

Show an example answer

It turns unknown contact details into a false stored value. Phone numbers are identifiers, not quantities where zero means no use. Keep an appropriate missing marker.

Check: did you answer the question, use evidence or working, and avoid claiming more than the evidence supports?

Practice this topic
Saved in this browser as you type.
aNet.ai · Data Science Fundamentals · Weeks 1–5 · practice material, not an official examProgress saved in this browser