1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to Data Quality with Great Expectations
Connected

Exercise

Establish aggregate-level Expectations

Time to practice writing some column-specific Expectations at the aggregate level. The Expectation Suite and Batch have already been assigned to the variables suite and batch, respectively, and loaded with the Shein Footwear dataset. Great Expectations and pandas are available as gx and pd, respectively.

Instructions 1/3

undefined XP
    1
    2
    3
  • Add the following column Expectations:
    • "colour": in the set "Khaki", "Purple", or "Grey"
    • "seller_name": 7 to 10 distinct values
    • "link": all unique values
    • "review_count": most common value in the set "0" or "100+"