Missing value
A missing value is a marker or condition indicating that an expected data value or reference is absent, unavailable, unknown, or inapplicable.
The Well-Grounded Data Analyst
A missing value is an absent or unavailable value for a field that is expected to contain data.
- How it is used
- Supports data-quality checks before transforming, grouping, or interpreting analytical datasets.
- How deep it goes
- Demonstrates counting, inspecting, dropping, retaining, and filling missing values, while deferring any universal threshold for acceptable loss.
- Examples
- Uses customer addresses, ecommerce events, survey responses, and property transactions with missing address fields.
- What you can do after
- Evaluate/understand whether to retain, drop, label, investigate, or supplement records with absent values.
Read how The Well-Grounded Data Analyst explains missing value →
Machine Learning for Tabular Data: XGBoost, Deep Learning, and AI
Missing data is the absence of recorded or available values or cases in a dataset, often represented explicitly by a special marker.
- How it is used
- Guides tabular-data cleanup before machine-learning or deep-learning training.
- How deep it goes
- Explains detection, causes, indicators, imputation, placeholders, and target-row removal, while deferring multivariate imputation detail.
- Examples
- Uses Auto MPG NaN counts, review-derived Airbnb fields, and Kuala Lumpur property listings.
- What you can do after
- Apply it via pandas and configured cleanup rules to detect and treat missing values for model-ready data.
Read how Machine Learning for Tabular Data: XGBoost, Deep Learning, and AI explains missing value →
Starting Data Analytics with Generative AI and Python
A missing value is an absent or unavailable data value in a record or variable.
- How it is used
- Uses missing-value checks to prepare tabular data for reliable business analysis and cleaning decisions.
- How deep it goes
- Explains possible causes and choices among deletion, ignoring, and filling, without prescribing one replacement rule.
- Examples
- Examines missing order dates and product details, and warns against copying values across alphabetically sorted country records.
- What you can do after
- Diagnose/debug with it by counting missing entries, inspecting affected records, and selecting a response suited to their meaning.
Read how Starting Data Analytics with Generative AI and Python explains missing value →
Statistics Slam Dunk
A missing value or missing data item is an observation whose value is unavailable, unrecorded, or not applicable in a dataset.
- How it is used
- Uses missing values to prepare NBA datasets for fair aggregation, classification, visualization, and modeling.
- How deep it goes
- Defines NA and demonstrates detection, replacement, exclusion, reshaping, and validation, but does not develop general missing-data theory.
- Examples
- Uses missing colleges, inactive-team seasons, play-by-play event types, points, and categorized NBA statistics.
- What you can do after
- Diagnose/debug with it: locate NAs, choose replacements or exclusions, reshape incomplete records, and verify resulting summaries.
API Design Patterns
A missing value is a value that is absent because its field is omitted rather than explicitly assigned.
- How it is used
- Distinguishes omitted fields from explicit nulls when defining API behavior and partial updates.
- How deep it goes
- Explains omission versus null through inferred masks, dynamic-map deletion, and zero-value ambiguity with API examples.
- Examples
- Uses Fruit color objects, PATCH descriptions, ChatRoom settings deletion, and zero-value Boolean defaults.
- What you can do after
- Apply it via field masks to distinguish omission, explicit null, and dynamic-key removal in API requests.
Pandas Workout: 200 exercises to make you a stronger data analyst
A missing or null value is an absent or unavailable observation or field in a dataset.
- How it is used
- Frames missing values as a data-cleaning problem requiring judgment about which incomplete records remain usable.
- How deep it goes
- Explains NaN representation and row filtering, then extends to column subsets and minimum non-null thresholds.
- Examples
- Uses NYC parking violations, ticket-dismissal policies, BLANKPLATE normalization, and completeness thresholds as working examples.
- What you can do after
- Apply pandas dropna, subset, and thresh rules to measure and clean incomplete records.
Read how Pandas Workout: 200 exercises to make you a stronger data analyst explains missing value →
Outlier Detection in Python
The absence of an expected value or observation in a dataset.
- How it is used
- Uses missing-value analysis to prepare data for outlier detectors while preserving potentially informative absence patterns.
- How deep it goes
- Distinguishes legitimate, unknown, and artifact-driven absence, then gives indicator and imputation procedures without deriving imputation theory.
- Examples
- Uses eldest-child age, failing temperature sensors, pandas null flags, row counts, median filling, and mode filling.
- What you can do after
- Operate/configure pandas preprocessing that flags, counts, and fills missing numeric and categorical values before outlier detection.
Read how Outlier Detection in Python explains missing value →
The Well-Grounded Rubyist, Fourth Edition
nil is Ruby’s singleton object representing the absence of a meaningful value.
- How it is used
- Uses nil to represent absent values and to explain false conditions, nil-returning expressions, and method calls on missing receivers.
- How deep it goes
- Defines nil as NilClass’s sole instance, works through truth values and common returns, then shows how safe navigation handles nil receivers.
- Examples
- Uses irb results for puts and array indexing, plus a roster method chain and debugger inspection of an unassigned value.
- What you can do after
- Diagnose/debug with it by recognizing nil results and avoiding NoMethodError on nil receivers with `&.`.
Read how The Well-Grounded Rubyist, Fourth Edition explains missing value →
100 Go Mistakes and How to Avoid Them
A null value is a database value representing the absence of a value rather than a value of the column's declared type.
- How it is used
- Prevents nullable SQL columns from causing Scan errors or being mistaken for ordinary zero values.
- How deep it goes
- Works through a failing Scan and two nullable destinations, without examining driver internals or writes.
- Examples
- Uses an employee department-and-age query, its NULL-to-string error, and scans into *string and sql.NullString.
- What you can do after
- Diagnose/debug NULL-related Scan failures and select a pointer or sql.NullXXX destination for a nullable column.
Read how 100 Go Mistakes and How to Avoid Them explains missing value →
Fast Python: High performance techniques for large datasets
- How it is used
- Guides column downsizing, numeric cleanup, partition-key filtering, and stable types during chunked conversion.
- How deep it goes
- Explains failed casts, replacement markers, and Arrow’s per-row validity bits; treats broader missing-value encoding as a complex problem.
- Examples
- Uses trip-data payment codes, Arrow null-bearing identifiers, tax-table `X` entries, and chunked CSV-to-Parquet conversion.
- What you can do after
- Apply it via pandas and PyArrow to choose missing-value handling that preserves calculations and permits suitable column types.
Read how Fast Python: High performance techniques for large datasets explains missing value →
PostgreSQL Mistakes and How to Avoid Them
A SQL NULL is a marker representing an absent, unknown, or inapplicable value that participates in three-valued logic rather than ordinary equality.
- How it is used
- Guards exclusion queries, row counts, arithmetic safeguards, and upserts against nullable-data surprises.
- How deep it goes
- Explains predicate outcomes and demonstrates query, aggregate, arithmetic, and unique-index consequences with corrected SQL.
- Examples
- Uses supplier-state exclusion, order item and service counts, zero division, and inventory-location upserts.
- What you can do after
- Diagnose/debug with it by finding nullable inputs and choosing NOT EXISTS, count(*), or NULL-aware unique-index designs.
Read how PostgreSQL Mistakes and How to Avoid Them explains missing value →
Everyday Data Visualization
A missing data point is an expected observation or value that is absent from a dataset or visualization.
- How it is used
- Guides truthful handling of absent observations in visualizations, especially when trending data over time.
- How deep it goes
- Explains visual treatments for isolated and very sparse gaps, while deferring detailed data-cleaning or imputation methods.
- Examples
- Uses daily line and bar trends, including point dots, broken lines, and empty positions for missing periods.
- What you can do after
- Apply it to make absent observations visible and reduce misleading conclusions from trend charts.
Read how Everyday Data Visualization explains missing value →
The Art of Code
In Java, null is the literal value denoting that a reference does not refer to an object.
- How it is used
- Frames absence as a readability and reliability problem in object traversal and price selection.
- How deep it goes
- Works through defensive checks, Optional returns, map-based traversal, and exceptional absence without detailing Optional internals.
- Examples
- Uses user address-to-city retrieval and product discounted-versus-base price lookup as nullable object chains.
- What you can do after
- Apply it via Java Optional to make absent results explicit and traverse nullable object chains with map.
Financial AI in Practice
Data values that are absent from a dataset for some records or fields.
- How it is used
- Supports credit-risk preprocessing by distinguishing absent data from useful risk signals before model training.
- How deep it goes
- Works through inspection and treatment options, including a baseline mean-imputation workflow, but does not specify a production imputation recipe.
- Examples
- Uses absent employment status, missing credit utilization, placeholder codes, and pandas column summaries to make treatment choices concrete.
- What you can do after
- Apply it via pandas to inspect missingness and build a baseline cleaning step while documenting risk-sensitive treatment decisions.
100 Java Mistakes and How to Avoid Them
The null value is Java's special reference value denoting the absence of an object reference.
- How it is used
- Uses null to represent absent, unspecified, deferred, or unavailable object references across Java APIs.
- How deep it goes
- Explains sentinel meanings and failure modes in varargs, collections, maps, and streams, then gives avoidance rules and diagnostic techniques.
- Examples
- Demonstrates null varargs calls, null-hostile collection searches, stream terminals, and collectors with null elements or results.
- What you can do after
- Diagnose null failures, clarify varargs intent, guard collection searches, filter streams, and choose Optional or annotations where appropriate.
Read how 100 Java Mistakes and How to Avoid Them explains missing value →
Clojure: The Essential Reference
nil is Clojure's null value, representing the absence of a value or a null reference.
- How it is used
- Handles absent inputs in map updates, web-form processing, and threaded computations without passing nil to functions that reject it.
- How deep it goes
- Explains positional defaults, a three-default limit, nil-short-circuiting, and set's nil-input result; does not develop nil internals.
- Examples
- Contrasts a failing map update with fnil and some-> alternatives, and uses an unfilled form field to illustrate defaulting.
- What you can do after
- Apply it via Clojure's fnil and some-> to default missing arguments or stop a pipeline before a nil-intolerant call.
Read how Clojure: The Essential Reference explains missing value →
.NET in Action, Second Edition
A null value indicates that a reference or nullable value does not refer to an object or contain a non-null value.
- How it is used
- Uses nullable annotations to express possible missing values in C# properties for parsed command-line options.
- How deep it goes
- Defines null references and explains nullable annotations, compiler warnings, and backward compatibility without detailing runtime internals.
- Examples
- Shows a nullable string property for command-line text and a warning caused by the parser's required-parameter guarantee.
- What you can do after
- Apply nullable reference annotations to option properties and use compiler checks to identify potential null-handling problems.
Read how .NET in Action, Second Edition explains missing value →
F# in Action: A Revised Edition of Get Programming with F#
Missing data is information that is absent, unavailable, or not provided for an expected field or value.
- How it is used
- Models absent domain data explicitly and keeps null handling at .NET boundaries.
- How deep it goes
- Explains null’s two meanings, compiler-enforced optionality, and conversion between options, nulls, and nullable values.
- Examples
- Uses an e-commerce home address and conversions of strings and Nullable integers into options.
- What you can do after
- Apply it via F# Option conversion functions to isolate nulls and nullable values at .NET boundaries.
Read how F# in Action: A Revised Edition of Get Programming with F# explains missing value →
Learn Go with Pocket-Sized Projects
nil is Go's predeclared zero-like value representing the absence of a valid reference, interface value, or other applicable value.
- How it is used
- Uses nil to represent absent dependencies or to compare against slices while building and testing Go programs.
- How deep it goes
- Explains nil through slice comparison, interface calls, runtime panic output, and replacement with a test stub.
- Examples
- Demonstrates nil in a money-conversion test and as the only comparable value for a slice.
- What you can do after
- Diagnose nil pointer dereferences and replace invalid nil test dependencies with interface-compatible stubs.
Read how Learn Go with Pocket-Sized Projects explains missing value →
Data Storytelling with Altair and AI
A missing value is an absent or unrecorded value for an observation and variable in a dataset.
- How it is used
- Uses missing-value checks to prevent incomplete years from distorting tourist-arrival aggregation and trend comparisons.
- How deep it goes
- Explains a context-dependent filtering strategy, year extraction, grouped sums, and charting, without covering imputation or broader missing-data methods.
- Examples
- Uses tourist arrivals by country, missing 1990 data, partial 2019 data, and a 1994–2018 pandas filtering workflow.
- What you can do after
- Apply it via pandas and Altair to restrict a time series to comparable years before aggregating and charting it.
Read how Data Storytelling with Altair and AI explains missing value →
Machine Learning System Design
Missing data consists of absent values, records, or fields that are expected in a dataset or input.
- How it is used
- Monitors ML inputs at feature level and supports decisions to continue, pause, or fall back when missingness rises.
- How deep it goes
- Defines detection, measurement, visualization, thresholds, and feature prioritization, but does not describe how to fill missing values.
- Examples
- Uses “N/A,” “NaN,” and “undefined,” plots, dataset-wide checks, feature-level checks, and critical-feature policies.
- What you can do after
- Diagnose missing-input problems, quantify their extent, and trigger thresholds, pauses, or fallbacks.
Read how Machine Learning System Design explains missing value →
Graph Algorithms for Data Science
Missing data is information that should be present for an entity or observation but is absent from the dataset.
- How it is used
- Profiles property completeness and prepares link-prediction features.
- How deep it goes
- Defines absence, measures non-null coverage, explains graph causes, and demonstrates imputation; stops short of general missing-data theory.
- Examples
- Uses User registration dates, Tweet creation dates, network distances, and Adamic-Adar scores.
- What you can do after
- Apply via Neo4j Cypher and pandas to count, report, and fill missing property values.
Read how Graph Algorithms for Data Science explains missing value →
Modern C
A null pointer is a pointer value that represents no valid object or function address.
- How it is used
- Uses null pointers to represent absent targets and to control safe conditional handling of pointer variables.
- How deep it goes
- Defines valid, null, and indeterminate states, then connects initialization, truth testing, dereferencing, and undefined behavior.
- Examples
- Contrasts zero-valued pointers with empty strings and demonstrates direct pointer tests, array boundaries, and NULL expansions.
- What you can do after
- Operate C pointer variables safely by initializing them, testing their null state, and avoiding invalid dereferences.
Statistics Every Programmer Needs
A null value is a missing or undefined data value represented as having no usable value.
- How it is used
- Uses missing-value handling to prepare datasets for reliable analysis and model fitting.
- How deep it goes
- Explains NaN semantics, inspection with info(), and fillna() replacement, but does not develop broader imputation methods.
- Examples
- Uses NFL play-by-play YARDS_GAINED values and Apple stock-price null-count inspection as concrete examples.
- What you can do after
- Apply it via pandas to inspect null counts and replace semantically appropriate NaN values before analysis.
Read how Statistics Every Programmer Needs explains missing value →
Modern C, Third Edition
nullptr is the C23 null pointer constant used to represent a null pointer value.
- How it is used
- Uses nullptr to represent absent pointer targets, guard failed allocation, and prevent uninitialized pointer use.
- How deep it goes
- Defines null, valid, and invalid pointer states with examples, but defers most pointer operations to later treatment.
- Examples
- Contrasts nullptr with an empty string, shows an uninitialized pointer, and checks malloc failure before copying.
- What you can do after
- Apply it via nullptr to initialize pointers, test absence, replace NULL, and handle failed allocation.
Grokking AI Algorithms, Second Edition
A missing value is an absent or unrecorded value for an attribute in a data record.
- How it is used
- Prepares imperfect datasets so machine-learning algorithms can compare records and use their features.
- How deep it goes
- Explains removal, mean or median replacement, and relationship-based estimation, but stops short of implementation details.
- Examples
- Uses a diamond dataset containing missing Cut, Depth, Carat, Table, Y, X, and Z values.
- What you can do after
- Apply removal, summary-value replacement, or feature-based estimation when preparing data for machine learning.
Read how Grokking AI Algorithms, Second Edition explains missing value →
Pro ASP.NET Core 7, Tenth Edition
A null value represents the absence of an object reference or other value in a context where null is permitted.
- How it is used
- Uses null to model absent values and control which unavailable data crosses ASP.NET Core API boundaries.
- How deep it goes
- Defines nullable values and demonstrates model, serialization, and reference-handling techniques without detailing null-state analysis internals.
- Examples
- Demonstrates a null Product array element, nullable Price, omitted API properties, and nulling Supplier references before serialization.
- What you can do after
- Apply it via nullable types, response projection, JsonIgnoreCondition.WhenWritingNull, and reference cleanup before JSON serialization.
Read how Pro ASP.NET Core 7, Tenth Edition explains missing value →
Delivering Machine Learning Projects: From design to deployment
A null value is a database value representing the absence of a recorded value rather than a measured numeric value.
- How it is used
- Uses missing-value counts to survey database quality and prioritize investigation before modeling.
- How deep it goes
- Explains counting nulls and zeros, assessing prevalence, and investigating patterns, but stops short of prescribing imputation.
- Examples
- Uses temperature readings, SQL-style counts, null prevalence, and ambiguous zero measurements.
- What you can do after
- Diagnose missing-data prevalence and route unexplained patterns into a project backlog.
Read how Delivering Machine Learning Projects: From design to deployment explains missing value →
Grokking Machine Learning
A missing value is an absent, unreadable, or otherwise unavailable entry in a dataset.
- How it is used
- Cleans datasets before training machine-learning models.
- How deep it goes
- Explains detection, column removal, and simple numerical or categorical replacement without developing missingness theory.
- Examples
- Uses Titanic Cabin, Age, and Embarked columns to demonstrate counting, dropping, median filling, and category filling.
- What you can do after
- Apply Pandas checks and replacement methods to prepare a dataset for modeling.
Deep Learning with R, Third Edition
A missing value is an absent or unavailable data entry for an expected attribute of an instance.
- How it is used
- Uses missing-value checks to make datasets suitable for neural-network training.
- How deep it goes
- Defines the issue and places it in preprocessing, while deferring domain-specific handling techniques.
- Examples
- Uses numerical-feature inspection, histograms, representative samples, and pretraining data preparation as teaching examples.
- What you can do after
- Diagnose missing entries through data exploration and include their treatment in preprocessing before training.
Read how Deep Learning with R, Third Edition explains missing value →
Julia as a Second Language
Missing data is information absent from a collected dataset because it was not recorded, was lost, or is otherwise unavailable.
- How it is used
- Represents unavailable observations in statistical, scientific, and data-processing programs.
- How deep it goes
- Explains Missing, propagation, skipmissing, and contrasts with nothing, NaN, and undefined.
- Examples
- Demonstrates incomplete surveys, unfinished studies, data-entry errors, and arrays processed with skipmissing.
- What you can do after
- Apply it via Julia’s missing and skipmissing constructs to represent and summarize incomplete data.
Read how Julia as a Second Language explains missing value →
Grokking Statistics
Missing data consists of observations or variable values that are absent from a dataset when they are expected or needed.
- How it is used
- Frames gaps in collected observations as a reason to define focused questions before gathering data.
- How deep it goes
- Explains why missing information occurs and how it can bias inference, but stops short of formal missing-data methods.
- Examples
- Uses family photographs, surveys, self-driving cars, weather sensors, golf observations, and scorecards.
- What you can do after
- Evaluate whether collected observations support a focused claim without ignoring gaps or curated evidence.
Kotlin in Action, 2E
A null value represents the absence of an object or reference value in a program.
- How it is used
- Uses nullable types to make missing-value handling explicit and prevent many null pointer exceptions before execution.
- How deep it goes
- Explains nullable declarations, compiler rejection, and an if-check implementation, without detailing safe-call or non-null-assertion semantics.
- Examples
- Uses Java and Kotlin string-length functions, nullable String? variables, null arguments, and an if-check returning 0 or 3.
- What you can do after
- Apply Kotlin's nullable-type rules to declare parameters, interpret compiler errors, and handle null with an explicit check.
The Quick Python Book, Fourth Edition
A missing value is a data item for which the intended observation is unavailable, inapplicable, or not reported.
- How it is used
- Cleans file data so missing observations do not block numeric calculations or contaminate parsed column types.
- How deep it goes
- Explains raw markers, replacement choices, parsing effects, and pandas standardization, but stops short of implementing averaging logic.
- Examples
- Uses Illinois weather records, heat-index columns, the Missing marker, pandas NaN, and varied no-data spellings.
- What you can do after
- Apply it via pandas read_csv() to convert selected textual markers into NaN before inspecting or calculating with columns.
Read how The Quick Python Book, Fourth Edition explains missing value →
Deep Learning with Python, Third Edition
An absent data field in a sample that must be handled explicitly during preprocessing.
- How it is used
- Positions missing-value handling within dataset curation and preprocessing before neural-network training.
- How deep it goes
- Identifies missing values as a preprocessing task but defers detailed handling strategies to a later treatment.
- What you can do after
- Apply it by identifying missing values as a data-cleaning requirement before supplying tensors to a neural network.
Read how Deep Learning with Python, Third Edition explains missing value →
Related concepts
- left outer joinproduced by · A left outer join returns every row from the left relation and matching rows from the right relation, representing unmatched right-side values as nulls.
- primitive data typekind of · A primitive data type is a fundamental, language-provided type for representing a basic value, rather than a composite of multiple values.
- imputationuses · Imputation is the replacement of missing or incomplete data with estimated, inferred, representative, or otherwise selected values.
- atomkind of · An atom is an Elixir named constant whose text is stored in the runtime atom table and whose value is a reference to that text.
- findproduced by · A find operation searches a collection for the first element or entry matching a value or predicate and returns it, or indicates that no match exists.
These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.