Hi Team, Hi Community,
I’ve been trying to get an expectation to work but I think I need help. I want to use
expect_column_values_to_be_between, but only actually run the expectation if the column exists. If the column does not exist, I do not care about validating it. My data source is a CSV with pandas.
When just coding the expectation, I get KeyError on files where the given column does not exist and passing in
catch_exceptions catches the exceptions but still fails the suite and marks the expectation as error. I want it to succeed if the column doesn’t exist and validate if the column does exist. I’ve been trying to get
row_condition to work for me, but the pandas query engine doesn’t seem to support querying whether a column exists as it is intended for expression syntax in columns.