Operations with petl: Introduction
Petl 1.6
| Beginner
- 15 Videos | 2h 2m 5s
- 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
-
1.Course Overview2m 30sUP NEXT
-
2.Installing petl and Creating a Data Table7m 55s
-
3.Reading Data from CSV Files in petl11m 24s
-
4.Working with Structured and Semi-structured Data10m 13s
-
5.Exporting Data from petl Using Templates9m 21s
-
6.Performing Lookups in petl7m 23s
-
7.Importing XML Data to petl11m 21s
-
8.Formatting Data in petl and Exporting It to HTML11m 31s
-
9.Working with JSON Data in petl11m 2s
-
10.Exporting petl Data to Persistent File Formats6m 54s
-
11.Importing Data from Microsoft Excel to petl9m 29s
-
12.Exporting Data from petl to Microsoft Excel5m 40s
-
13.Importing SQL Tables to petl8m 22s
-
14.Slicing and Dicing Data in a petl Table7m 13s
-
15.Course Summary1m 49s
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.
