Skip to content

Latest commit

 

History

History
15 lines (10 loc) · 645 Bytes

File metadata and controls

15 lines (10 loc) · 645 Bytes

Extract Transform and Load Exercise

This Project demonstrates how the ETL proccesses take place using python. This dataset has two files, with same number of columns.

The procedures for these are

Data Extraction

The data was extracted from a csv file into pandas data frame

Data Transformation

Some transformations were undertaken, Unwated columns were dropped, some coulumns wrere renamed also.

Loading into posqgresql

The later was loaded into ostgres sql, using the sqlalchemy , create_engine and engine libraries
"Clck here for the full code"