Python ETL with petl Literacy (Beginner Level)

  • 14m
  • 14 questions
The Python ETL with petl Literacy (Beginner Level) benchmark measures your ability to process data belonging to various file formats, connect to a database, and perform basic Extract, Transform, and Load (ETL) tasks using petl. You will be evaluated on your ability to perform fundamental transform operations on numbers, strings, and tables using petl. A learner who scores high on this benchmark demonstrates that they have the skills to perform basic data transformations with petl.

Topics covered

  • combine data from multiple tables into one table
  • create a petl data table from Python-based data structures, such as NumPy arrays and Pandas DataFrames
  • create a table in SQLite and import it to petl using SQLAlchemy and SQLite3
  • export data from petl using a template, epilogue, and prologue
  • implement read operations on data and export it in HTML format
  • import data from Microsoft Excel and perform basic operations on it
  • import data from XML files and perform lookups on it
  • insert as well as edit rows and columns in petl data tables
  • install petl and create a basic petl table from a toy dataset
  • perform lookups on data imported from pickle files
  • perform slicing, dicing, and merging operations on petl data tables
  • perform various import and export operations on CSV, TSV, and TXT files
  • read JSON data and perform lookup operations on it
  • slice and dice data stored as records within a petl data table