Operations with petl: Introduction

Extract Transform and Load (ETL) tasks help in collecting and manipulating data from diverse sources to fit the users requirements. In this course youll 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. Youll also recognize how to load and save data in these formats. Next youll outline how to integrate petl with a relational database using SQLAlchemy and SQLite3. Finally youll perform transform operations on data using different petl features to filter specific data needed by you. Once you have completed this course youll have a clear understanding of the role played by petl in simplifying ETL tasks.