Operations with petl: Advanced Extractions & Transformations

Petl 1.6    |    Intermediate
  • 10 videos | 1h 15m 43s
  • Includes Assessment
  • Earns a Badge
Likes 11 Likes 11
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
    In this video, you’ll learn more about your instructor and this course. In this course, you’ll learn more about the complex operations in PETL when it comes to extracting data from a source and converting it to a format… FREE ACCESS
  • Playable
    2.  Viewing Regular Expression Patterns in petl
    10m 6s
    In this video, you’ll learn more about ETL operations. You’ll learn that working with unstructured data and regular expressions can be a powerful addition to your toolkit. You’ll learn that operations like searching for a… FREE ACCESS
  • Locked
    3.  Performing Searches in petl Using Regular Expression
    4m 44s
    In this video, you’ll watch a demo. In this demo, you’ll start where you left off at the end of the last one. You’ll find the rows that contain a pattern. You’ll return to etl.search, with a different variant. Here,… FREE ACCESS
  • Locked
    4.  Splitting Fields in petl Using Regular Expressions
    9m 29s
    In this video, you’ll watch a demo. In this demo, you’ll learn operations where you’ll modify data based on patterns present within it. You’ll learn that search and replace is closely related to etl.search. Next, you’ll… FREE ACCESS
  • Locked
    5.  Unpacking Nested Fields in petl
    5m 14s
    In this video, you’ll watch a demo. In this demo, you’ll work with some specialized ETL functions. Specifically, you’ll learn to unpack a nested field. Onscreen, you’ll see a dataset. This is a list of lists called… FREE ACCESS
  • Locked
    6.  Converting Fields in petl Data Tables Using Mapping
    9m 23s
    In this video, you’ll watch a demo. In this demo, you’ll continue with the theme of transforming data using petl. You’ll learn about radical transformations that perform complete makeovers of the data. The output will… FREE ACCESS
  • Locked
    7.  Transforming Data by Rows in petl
    10m 51s
    In this video, you’ll watch a demo. In this demo, you’ll focus on row-oriented transformations rather than column-oriented transformations. You’ll continue using the same dataset you used in the previous demo. Onscreen,… FREE ACCESS
  • Locked
    8.  Sorting Data in petl Data Table
    10m 7s
    In this video, you’ll watch a demo. In this demo, you’ll learn about sorting operations. You’ll use the same dataset from the previous demo. This dataset is in a petl table read in from a pandas DataFrame. You’ll start… FREE ACCESS
  • Locked
    9.  Joining petl Data Tables
    10m 58s
    In this video, you’ll watch a demo. In this demo, we will turn our attention to joins. You’ll need the import of petl as etl. Onscreen now is a list of lists, called trees_legal_status. It consists of data with three… FREE ACCESS
  • Locked
    10.  Course Summary
    2m 3s
    In this video, you’ll summarize what you learned in the course. In this course, you learned the use of regular expressions to analyze, search for, and extract specific rows and columns in your petl table based on the… 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 on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Operations with petl: Introduction
Likes 8 Likes 8  
Course Tableau for Data Visualization: Advanced Features
Likes 70 Likes 70  
Course Tableau for Data Visualization: Exploring Visualizations & Data Formats
Likes 71 Likes 71