Operations with petl: Introduction

“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.”