Operations with petl: Advanced Extractions & Transformations

Petl 1.6
  • 10 Videos | 1h 19m 43s
  • Includes Assessment
  • Earns a Badge
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, you'll 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. You'll begin by investigating the use of regular expressions to analyze, search, and extract specific rows and columns in a petl table. You'll then create transform functions and apply them to your data. These include operations on numeric as well as string fields. Moving on, you'll implement sort operations to organize data in a petl table and arrange it in a sequence that suits your purposes. Finally, you'll investigate how to perform joins and set operations on data tables and meaningfully reduce the data in them using aggregation functions.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    access regular expression patterns in data tables
    implement regular expression searches on petl data tables
    implement split operations on data stored within petl data tables
    unpack nested fields when creating data tables
  • use mapping to perform various operations on columns and fields in data tables
    transform data by rows using rowmap() and rowmapmany() functions
    perform sort operations on data stored within a data table
    implement SQL-like joins on data from multiple petl tables
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 50s
    UP NEXT
  • Playable
    2. 
    Viewing Regular Expression Patterns in petl
    10m 6s
  • Locked
    3. 
    Performing Searches in petl Using Regular Expression
    4m 44s
  • Locked
    4. 
    Splitting Fields in petl Using Regular Expressions
    9m 29s
  • Locked
    5. 
    Unpacking Nested Fields in petl
    5m 14s
  • Locked
    6. 
    Converting Fields in petl Data Tables Using Mapping
    9m 23s
  • Locked
    7. 
    Transforming Data by Rows in petl
    10m 51s
  • Locked
    8. 
    Sorting Data in petl Data Table
    10m 7s
  • Locked
    9. 
    Joining petl Data Tables
    10m 58s
  • Locked
    10. 
    Course Summary
    2m 3s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 0 Likes 0  
Likes 16 Likes 16  
Likes 3 Likes 3