Python ETL with petl Competency (Intermediate Level)

  • 11m
  • 11 questions
The Python ETL with petl Competency (Intermediate Level) benchmark measures your ability to perform data operations by implementing replace and type change operations, querying data in petl data tables, and defining filters. You will be evaluated on your ability to extract data using regular expressions, implement joins and set operations on tables, and aggregate data using petl. A learner who scores high on this benchmark demonstrates that they have the skills to implement advanced extractions and transformations with petl.

Topics covered

  • filter data based on single as well as a combination of conditions
  • implement regular expression searches on petl data tables
  • implement split operations on data stored within petl data tables
  • implement SQL-like joins on data from multiple petl tables
  • implement SQL-like query operations on petl data tables
  • perform sort operations on data stored within a data table
  • perform various replace and type change operations on data
  • transform data by rows using rowmap() and rowmapmany() functions
  • unpack nested fields when creating data tables
  • use mapping to perform various operations on columns and fields in data tables
  • use petl's facet() function to define filters for specific fields in a table