
Count the Values Lost When Numeric Conversion Uses Coerce
A numeric conversion can finish without an error while replacing some entries with missing values. That behaviour may be intentional, but the replacements…
From a download link to a useful question: approachable guides to understanding and working with data.

A numeric conversion can finish without an error while replacing some entries with missing values. That behaviour may be intentional, but the replacements…

A file contains the value 12,5. Is the comma part of one decimal number or the separator between two fields? The answer belongs to the file’s format, not to…

An orders table contains one row per order. An items table contains one row per item. Join them by order ID and an order containing three items can appear…

Sometimes you want a group average beside every observation, not a shorter table containing only the averages. A window calculation can preserve the…

Assigning red, green, and blue the numbers one, two, and three can accidentally suggest an order that the categories do not possess. One-hot encoding offers…

Combining two tables is not always the same as collecting their distinct values. Before choosing UNION or UNION ALL, decide whether two identical-looking…

A table has four rows, but one field contains a missing value. How many observations are there? The answer depends on whether you mean rows, recorded values…

A record can pass a structural check and still contain an inaccurate observation. A schema helps define what a record must look like; it does not…