Operations with petl: Advanced Extractions & Transformations

Petl 1.6    |    Intermediate
  • 10 Videos | 1h 15m 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
    FREE ACCESS
  • Locked
    4. 
    Splitting Fields in petl Using Regular Expressions
    9m 29s
    FREE ACCESS
  • Locked
    5. 
    Unpacking Nested Fields in petl
    5m 14s
    FREE ACCESS
  • Locked
    6. 
    Converting Fields in petl Data Tables Using Mapping
    9m 23s
    FREE ACCESS
  • Locked
    7. 
    Transforming Data by Rows in petl
    10m 51s
    FREE ACCESS
  • Locked
    8. 
    Sorting Data in petl Data Table
    10m 7s
    FREE ACCESS
  • Locked
    9. 
    Joining petl Data Tables
    10m 58s
    FREE ACCESS
  • Locked
    10. 
    Course Summary
    2m 3s
    FREE ACCESS

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

COURSE PL-300: Preparing Data for Visualizations in Power BI
COURSE Data Visualization: Getting Started with Plotly
COURSE Analyzing Data Using Python: Data Analytics Using Pandas
Likes 31 Likes 31