Functions

Functions

column_equal_to_column(col_left, col_right)

Create a condition to check if a column is equal to another column.

column_equal_to_value(col_name, value)

Create a condition to check if a column is equal to a given value.

column_ge_column(col_left, col_right)

Create a condition to check if a column is greater or equal to another column.

column_ge_value(col_name, value)

Create a condition to check if a column is greater or equal to a given value.

column_gt_column(col_left, col_right)

Create a condition to check if a column is greater than another column.

column_gt_value(col_name, value)

Create a condition to check if a column is greater than a given value.

column_le_column(col_left, col_right)

Create a condition to check if a column is lower or equal to another column.

column_le_value(col_name, value)

Create a condition to check if a column is lower or equal to a given value.

column_lt_column(col_left, col_right)

Create a condition to check if a column is lower than another column.

column_lt_value(col_name, value)

Create a condition to check if a column is lower than a given value.

compare_column_to_column(col_left, operator, ...)

Create a condition to compare a column to another column.

compare_column_to_value(col_name, operator, ...)

Create a condition to compare a column to a value.

compare_length(col_name, operator, length)

Create a condition to compare the length of the column values.

compare_year_to_value(col_name, operator, value)

Create a condition to compare a column value to a specific year.

count_decimal_digit(col_name, operator, digit)

Create a condition to compare the number of decimal digits in a column

count_eq_value(col_name, value)

Create a condition to compare if the number of elements of a column is equal to a given value.

count_ge_value(col_name, value)

Create a condition to compare if the number of elements of a column is greater than or equal to a given value.

count_gt_value(col_name, value)

Create a condition to compare if the number of elements of a column is greater than a given value.

count_integer_digit(col_name, operator, digit)

Create a condition to compare the number of integer digits in a column.

count_le_value(col_name, value)

Create a condition to compare if the number of elements of a column is less than or equal to a given value.

count_lt_value(col_name, value)

Create a condition to compare if the number of elements of a column is less than a given value.

decimal_digit_eq(col_name, digit)

Create a condition to check if the number of decimal is equal to a given value.

decimal_digit_ge(col_name, digit)

Create a condition to check if the number of decimal is greater or equal to a given value.

decimal_digit_gt(col_name, digit)

Create a condition to check if the number of decimal is greater than a given value.

decimal_digit_le(col_name, digit)

Create a condition to check if the number of decimal is lower or equal a given value.

decimal_digit_lt(col_name, digit)

Create a condition to check if the number of decimal is lower than a given value.

integer_digit_equal(col_name, digit)

Create a condition to check if the number of integer is equal to a given value.

integer_digit_ge(col_name, digit)

Create a condition to check if the number of integer is greater or equal to a given value.

integer_digit_gt(col_name, digit)

Create a condition to check if the number of integer is greater than a given value.

integer_digit_le(col_name, digit)

Create a condition to check if the number of integer is lower or equal a given value.

integer_lt_digit(col_name, digit)

Create a condition to check if the number of integer is lower than a given value.

is_alphabetic(col_name)

Create a condition to check if a column value is alphabetic.

is_between(col_name, min_value, max_value)

Create a condition to check if the column values are between the given lower bound and upper bound.

is_boolean(col_name)

Create a condition to check if a column value is a boolean.

is_date(col_name)

Create a condition to check if a column value is a date.

is_email(col_name)

Create a condition to check if a column value is an email.

is_float(col_name)

Create a condition to check if a column value is a float.

is_iban(col_name)

Create a condition to check if a column value is an IBAN.

is_in(col_name, list_of_values)

Create a condition to check if a column value is in a list of values.

is_integer(col_name)

Create a condition to check if a column value is an integer.

is_ip_address(col_name)

Create a condition to check if a column value is an IP address.

is_negative(col_name)

Create a condition to check if a column value is negative.

is_not_in(col_name, list_of_values)

Create a condition to check if a column value is not in a list of values.

is_not_null(col_name)

Create a condition to check if a column is not null.

is_null(col_name)

Create a condition to check if a column is null.

is_phone_number(col_name[, filter_per_country])

Create a condition to check if a column value is a phone number.

is_positive(col_name)

Create a condition to check if a column value is positive.

is_unique(col_name)

Create a condition to check if all values in a column are unique.

length_eq(col_name, length)

Create a condition to check if the values of length is equal to a given value.

length_ge(col_name, length)

Create a condition to check if the values of length is greater or equal to a given value.

length_gt(col_name, length)

Create a condition to check if the values of length is greater than a given value.

length_le(col_name, length)

Create a condition to check if the values of length is lower or equal to a given value.

length_lt(col_name, length)

Create a condition to check if the values of length is lower than a given value.

max_eq_value(col_name, value)

Create a condition to compare if the maximum of a column is equal to a value.

max_ge_value(col_name, value)

Create a condition to compare if the maximum of a column is greater than or equal to a value.

max_gt_value(col_name, value)

Create a condition to compare if the maximum of a column is greater than a value.

max_le_value(col_name, value)

Create a condition to compare if the maximum of a column is lower than or equal to a value.

max_lt_value(col_name, value)

Create a condition to compare if the maximum of a column is lower than a value.

mean_eq_value(col_name, value)

Create a condition to compare if the average of a column is equal to a value.

mean_ge_value(col_name, value)

Create a condition to compare if the average of a column is greater than or equal to a value.

mean_gt_value(col_name, value)

Create a condition to compare if the average of a column is greater than a value.

mean_le_value(col_name, value)

Create a condition to compare if the average of a column is less than or equal to a value.

mean_lt_value(col_name, value)

Create a condition to compare if the average of a column is less than a value.

median_eq_value(col_name, value)

Create a condition to compare if the median of a column is equal to a value.

median_ge_value(col_name, value)

Create a condition to compare if the median of a column is greater than or equal to a value.

median_gt_value(col_name, value)

Create a condition to compare if the median of a column is greater than a value.

median_le_value(col_name, value)

Create a condition to compare if the median of a column is lower than or equal to a value.

median_lt_value(col_name, value)

Create a condition to compare if the median of a column is lower than a value.

min_eq_value(col_name, value)

Create a condition to compare if the minimum of a column is equal to a value.

min_ge_value(col_name, value)

Create a condition to compare if the minimum of a column is greater than or equal to a value.

min_gt_value(col_name, value)

Create a condition to compare if the minimum of a column is greater than a value.

min_le_value(col_name, value)

Create a condition to compare if the minimum of a column is lower than or equal to a value.

min_lt_value(col_name, value)

Create a condition to compare if the minimum of a column is lower than a value.

rlike(col_name, pattern)

Create a condition to check if a column value matches a regex.

sum_eq_value(col_name, value)

Create a condition to compare if the sum of a column is equal to a given value.

sum_ge_value(col_name, value)

Create a condition to compare if the sum of a column is greater than or equal to a given value.

sum_gt_value(col_name, value)

Create a condition to compare if the sum of a column is greater than a given value.

sum_le_value(col_name, value)

Create a condition to compare if the sum of a column is less than or equal to a given value.

sum_lt_value(col_name, value)

Create a condition to compare if the sum of a column is less than a given value.

year_equal_to_value(col_name, value)

Create a condition to check if the year of a date in a column is equal to a specific year.

year_ge_value(col_name, value)

Create a condition to check if the year of a date in a column is greater or equal to a specific year.

year_gt_value(col_name, value)

Create a condition to check if the year of a date in a column is greater than a specific year.

year_le_value(col_name, value)

Create a condition to check if the year of a date in a column is lower or equal to a specific year.

year_lt_value(col_name, value)

Create a condition to check if the year of a date in a column is lower than a specific year.