Write up a Conditional Expectation
Taking a look at the Shein dataset, you can probably come up with a few Conditional Expectations. One such Expectation could be that the star_rating of a product should be 0.0 if the product has no reviews. Let's practice establishing this Conditional Expectation.
A Batch connected to the Shein Footwear dataset has already been created and assigned to the variable batch. Great Expectations and pandas are available as gx and pd, respectively.
This exercise is part of the course
Introduction to Data Quality with Great Expectations
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Establish Conditional Expectation
expectation = gx.expectations.ExpectColumnValuesToBeInSet(
column='____',
value_set={____},
condition_parser='pandas',
row_condition='____==0',
)