Operations with petl: Advanced Extractions & Transformations

Petl facilitates and streamlines tasks related to data extraction and manipulation often required by software developers to make data fit for actionable business intelligence (BI). In this course youll work with complex operations in petl and outline how to extract data from a source and convert it to a format that complies with your requirements. Youll begin by investigating the use of regular expressions to analyze search and extract specific rows and columns in a petl table. Youll then create transform functions and apply them to your data. These include operations on numeric as well as string fields. Moving on youll implement sort operations to organize data in a petl table and arrange it in a sequence that suits your purposes. Finally youll investigate how to perform joins and set operations on data tables and meaningfully reduce the data in them using aggregation functions.