Tag archive

#data-quality

Commands grouped around the same concept, pattern, or recurring problem.

4 commands with this tag Browse related patterns quickly

beginner data-quality MySQL MariaDB SQL Server PostgreSQL SQLite

Count Missing Values Per Column

Audit a table for `NULL` values by counting how many rows have no value in each column of interest.

advanced aggregation MariaDB SQL Server PostgreSQL

Detect Outliers Using the IQR Method

Flag values that fall outside the interquartile fence `[Q1 − 1.5 × IQR, Q3 + 1.5 × IQR]` using `PERCENTILE_CONT` in PostgreSQL, MariaDB, and SQL Server.

advanced data-quality MySQL MariaDB SQL Server PostgreSQL SQLite

Find Gaps In An Integer Sequence

Generate the expected numbers and left join to the existing table to find missing ids or sequence values.

beginner data-quality MySQL MariaDB SQL Server PostgreSQL SQLite

Find Rows That Violate A Data Rule

Use a `WHERE` predicate to list rows that already break a business or constraint rule.