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 courseaccess regular expression patterns in data tablesimplement regular expression searches on petl data tablesimplement split operations on data stored within petl data tablesunpack nested fields when creating data tables
-
use mapping to perform various operations on columns and fields in data tablestransform data by rows using rowmap() and rowmapmany() functionsperform sort operations on data stored within a data tableimplement SQL-like joins on data from multiple petl tablessummarize the key concepts covered in this course
IN THIS COURSE
-
2m 50sIn 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
-
10m 6sIn 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
-
4m 44sIn 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
-
9m 29sIn 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
-
5m 14sIn 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
-
9m 23sIn 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
-
10m 51sIn 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
-
10m 7sIn 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
-
10m 58sIn 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
-
2m 3sIn 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.