Operations with petl: Introduction

Petl 1.6    |    Beginner
  • 15 Videos | 2h 8m 35s
  • Includes Assessment
  • Earns a Badge
Extract, Transform, and Load (ETL) tasks help in collecting and manipulating data from diverse sources to fit the user's requirements. In this course, you'll explore different interfaces available in the petl library and perform basic ETL tasks using petl. You will begin by examining how to import data from various data sources, including delimited text files, Microsoft Excel, and structured JSON data. You'll also recognize how to load and save data in these formats. Next, you'll outline how to integrate petl with a relational database using SQLAlchemy and SQLite3. Finally, you'll perform transform operations on data using different petl features to filter specific data needed by you. Once you have completed this course, you'll have a clear understanding of the role played by petl in simplifying ETL tasks.

WHAT YOU WILL LEARN

  • discover the key concepts covered in this course
    install petl and create a basic petl table from a toy dataset
    import data from a CSV file and extract it to a petl table
    perform various import and export operations on CSV, TSV, and TXT files
    export data from petl using a template, epilogue, and prologue
    perform lookups on data imported from pickle files
    import data from XML files and perform lookups on it
    implement read operations on data and export it in HTML format
  • read JSON data and perform lookup operations on it
    export data stored in petl data tables to a persistent file format
    import data from Microsoft Excel and perform basic operations on it
    view summary statistics of data in petl and export it to Microsoft Excel
    create a table in SQLite and import it to petl using SQLAlchemy and SQLite3
    slice and dice data stored as records within a petl data table
    summarize the key concepts covered in this course

IN THIS COURSE

  • Playable
    1. 
    Course Overview
    2m 30s
    UP NEXT
  • Playable
    2. 
    Installing petl and Creating a Data Table
    7m 55s
  • Locked
    3. 
    Reading Data from CSV Files in petl
    11m 24s
    FREE ACCESS
  • Locked
    4. 
    Working with Structured and Semi-structured Data
    10m 13s
    FREE ACCESS
  • Locked
    5. 
    Exporting Data from petl Using Templates
    9m 21s
    FREE ACCESS
  • Locked
    6. 
    Performing Lookups in petl
    7m 23s
    FREE ACCESS
  • Locked
    7. 
    Importing XML Data to petl
    11m 21s
    FREE ACCESS
  • Locked
    8. 
    Formatting Data in petl and Exporting It to HTML
    11m 31s
    FREE ACCESS
  • Locked
    9. 
    Working with JSON Data in petl
    11m 2s
    FREE ACCESS
  • Locked
    10. 
    Exporting petl Data to Persistent File Formats
    6m 54s
    FREE ACCESS
  • Locked
    11. 
    Importing Data from Microsoft Excel to petl
    9m 29s
    FREE ACCESS
  • Locked
    12. 
    Exporting Data from petl to Microsoft Excel
    5m 40s
    FREE ACCESS
  • Locked
    13. 
    Importing SQL Tables to petl
    8m 22s
    FREE ACCESS
  • Locked
    14. 
    Slicing and Dicing Data in a petl Table
    7m 13s
    FREE ACCESS
  • Locked
    15. 
    Course Summary
    1m 49s
    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 Complete Guide to Excel 365: Validating, Cleaning, & Performing Lookups on Data
COURSE SQL Databases Using SQLAlchemy: Using Triggers, Stored Procedures, & Transactions
COURSE SQL Databases Using SQLAlchemy: Manipulating Data