Expect the specified column to exist.

Expect the columns to exactly match a specified list.

Expect the columns to match a specified set.

Expect the number of rows to be between two values.

Expect the number of rows to equal a value.

Expect the number of columns to be between two values.

Expect the number of columns to equal a value.

Expect each column value to be unique.

Expect that the columns are unique together, e.g. a multi-column primary key

Expect the values for each record to be unique across the columns listed. Note that records can be duplicated.

Expect column values to NOT be null. Values must be explicitly null or missing. Empty strings don’t count as null unless they have been coerced to a null type.

Expect column values to be null.

Expect each column value to be in a given set.

Expect each column value to NOT be in a given set.

Expect column entries to be between a minimum value and a maximum value.

Expect column entries to be strings with length between a minimum value and a maximum value. This expectation only works for string-type values.

Expect column entries to be strings with length equal to the provided value. This expectation only works for string-type values.

Expect column entries to be strings that match a given regular expression.

Expect column entries to be strings that do NOT match a given regular expression. The regex must NOT match any portion of the provided string. .

Expect the column entries to be strings that can be matched to either any of or all of a list of regular expressions. Matches can be anywhere in the string.

Expect the column entries to be strings that do not match any of a list of regular expressions. Matches can be anywhere in the string.

Expect the column mean to be between a minimum value and a maximum value (inclusive). min_value and max_value are both inclusive unless strict_min or strict_max are set to True.

Expect the column median to be between a minimum value and a maximum value.

Expect the number of unique values to be between a minimum value and a maximum value. (inclusive)

Expect the proportion of unique values to be between a minimum value and a maximum value. For example, in a column containing [1, 2, 2, 3, 3, 3, 4, 4, 4, 4], there are 4 unique values and 10 total values for a proportion of 0.4.

Expect the column to sum to be between an min and max value

Expect the sum of row values is the same for each row, summing only values in column_list, and equal to sum_total.

Expect the column minimum to be between an min and max value

Expect the column maximum to be between an min and max value

Expect the values in column A to be the same as column B.