Skip to content

Test statuses

Gerald Rich edited this page May 26, 2021 · 1 revision

A list of tests sorted by their statuses, from failure to info. To change a tests' status, please file a pull request or open a discussion to propose changing or adding statuses.

Failures

Tests that raise serious concerns worth flagging and can throw an error with the --exit CLI flag

  • Duplicate Rows (source)
  • Integer at its SQL upper limit (source)
  • Potential big integer at its SQL upper limit (source)
  • Potential small integer at its SQL upper limit (source)
  • Potential summed integer at its SQL upper limit (source)
  • Potential missing rows at its Excel upper limit (source)
  • Words at their SQL character upper limit (source)
  • Invalid coordinates: latitudes above 90º or below -90º; longitudes above 180º or below -180º (source)
  • Void coordinates: 0º,0º aka in the ocean off the coast of West Africa (source)

Warn

Tests that may cause problems for certain programs.

  • The percentage of empty cells within columns (source)
  • The percentage of cells with special characters within columns (source)

Info

Tests that provide additional context provided the --verbose CLI flag

  • The percentage of numeric cells within columns (source)
  • The percentage of cells with letters within columns (source)
  • Outliers are numbers more than three median absolute deviations from the median (source)
  • Outliers are numbers more than three standard deviations from the mean (source)
Clone this wiki locally