Establish a Column Count Expectation

In the last video, we learned about the ExpectTableRowCountToEqual(value: int) Expectation for a table's row count. As we saw towards the end of the video, Great Expectations also has an Expectation called ExpectTableColumnCountToEqual(value: int) This class is the exact same, except it applies to the column count instead of the row count. In this exercise, you'll implement the class to create and validate a column count Expectation.

You'll be using the same Renewable Power Generation dataset we referenced in the video. You can learn more about the dataset here.

The dataset has already been loaded into a Batch, assigned to the variable batch. Great Expectations and pandas are available as gx and pd, respectively.

Cet exercice fait partie du cours

Introduction to Data Quality with Great Expectations

Afficher le cours

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.


# Create table column count Expectation
expectation = gx.expectations.____(
	value=____
)

Modifier et exécuter le code

Cet exercice fait partie du cours

Introduction to Data Quality with Great Expectations

IntermédiaireNiveau de compétence

4.7+

Commencer le cours gratuitement

Understand why Great Expectations (GX) is such a powerful tool for monitoring data quality. Get familiar with the basics of GX, including how to start a session using a Data Context, and how to load in a pandas dataframe using a Data Source, Data Asset, and Batch Definition.

Exercise 1: Create a Data Context Exercise 2: Create your Data Context Exercise 3: Sneak Peek into GX Exercise 4: Keyword Definitions Exercise 5: Connect to Data Exercise 6: Concept Review Exercise 7: Create a Data Source and Data Asset Exercise 8: Read Data in Batches Exercise 9: Create a Batch Definition and Batch Exercise 10: Inspect your Batch

Create and evaluate basic shape and schema Expectations. Validate your Expectations either individually, as part of an Expectation Suite with a Batch Definition, or using a Validation Definition.

Exercise 1: Create Expectations Exercise 2: Establish a Column Count Expectation

Exercice en cours

Exercise 3: Evaluate Validation Results Exercise 4: Schema Expectations Exercise 5: Establish a Column Name Expectation Exercise 6: Establish a Column Range Expectation Exercise 7: Create a Suite of Expectations Exercise 8: Create an Expectation Suite Exercise 9: Validate your Expectation Suite Exercise 10: Validate Expectation Suites Exercise 11: Create and Run a Validation Definition Exercise 12: Validation Definition vs. Batch Definition

Learn practical skills that will help you dominate the dynamic nature of Expectations in the real world. Deploy Validation Definitions using Checkpoints; update your Expectation Suites; and learn how to add, retrieve, list, and delete key GX components.

Exercise 1: Deploy Validation Definitions Exercise 2: Concept Check Exercise 3: Create a Checkpoint Exercise 4: Update Expectation Suites Exercise 5: Copy an Expectation Exercise 6: Delete an Expectation Exercise 7: Update an Expectation Exercise 8: Manage Components Exercise 9: Add and list components Exercise 10: Manage a Checkpoint

Dive head-first into the world of Expectations. Practice creating basic column Expectations, row- and aggregate-level numeric Expectations, string and string parseability Expectations, and more. Learn how to apply Expectations to only some rows of a dataframe.

Exercise 1: Basic Column Expectations Exercise 2: Establish row-level Expectations Exercise 3: Establish aggregate-level Expectations Exercise 4: Type-Specific Expectations Exercise 5: Establish numeric Expectations Exercise 6: Establish string Expectations Exercise 7: Conditional Expectations Exercise 8: Write up a Conditional Expectation Exercise 9: Invert a Conditional Expectation Exercise 10: Wrap-Up