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
-
1.Course Overview2m 50sUP NEXT
-
2.Viewing Regular Expression Patterns in petl10m 6s
-
3.Performing Searches in petl Using Regular Expression4m 44s
-
4.Splitting Fields in petl Using Regular Expressions9m 29s
-
5.Unpacking Nested Fields in petl5m 14s
-
6.Converting Fields in petl Data Tables Using Mapping9m 23s
-
7.Transforming Data by Rows in petl10m 51s
-
8.Sorting Data in petl Data Table10m 7s
-
9.Joining petl Data Tables10m 58s
-
10.Course Summary2m 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.