Operations with petl: Basic Data Transformations

Petl 1.6
  • 11 Videos | 1h 38m 58s
  • Includes Assessment
  • Earns a Badge
Software development often requires manipulation of data that has been extracted from different data sources to make it compatible with the user's specifications and requirements. petl's data transformation features can help achieve this. In this course, you'll investigate fundamental data transformations that can be performed using the petl library. You'll demonstrate how to load data into a petl table, filter columns, and combine multiple tables using different forms of concatenation operations. Next, you'll outline how to convert data in a petl table into a form that is compatible with your requirements. This includes transforming strings to numbers, applying calculations to numeric fields, and replacing specific values in the table. Lastly, you'll explore ways to filter content in petl tables using the facet() function and different select operations.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    create a petl data table from Python-based data structures, such as NumPy arrays and Pandas DataFrames
    perform slicing, dicing, and merging operations on petl data tables
    combine data from multiple tables into one table
    insert as well as edit rows and columns in petl data tables
    perform various replace and type change operations on data
  • find and replace specific values in a field
    implement SQL-like query operations on petl data tables
    filter data based on single as well as a combination of conditions
    use petl's facet() function to define filters for specific fields in a table
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 35s
    UP NEXT
  • Playable
    2. 
    Creating Tables in petl from Python Data Sources
    9m 27s
  • Locked
    3. 
    Performing Basic Transformations on Data in petl
    9m 6s
  • Locked
    4. 
    Combining Data from Multiple Tables in petl
    8m 42s
  • Locked
    5. 
    Inserting Rows and Columns in petl Data Tables
    10m 11s
  • Locked
    6. 
    Implementing Replace and Type Change Operations
    12m 17s
  • Locked
    7. 
    Replacing Values in petl Data Tables
    9m 32s
  • Locked
    8. 
    Querying Data in petl Data Tables
    11m 15s
  • Locked
    9. 
    Filtering Data Based on Conditions in petl
    9m 10s
  • Locked
    10. 
    Defining Filters for Specific Fields in petl
    10m 38s
  • Locked
    11. 
    Course Summary
    1m 35s

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.