Extract, Transform and Load data using Python, Pandas, pgAdmin and jupyter notebook
-
Updated
Dec 27, 2022 - Jupyter Notebook
Extract, Transform and Load data using Python, Pandas, pgAdmin and jupyter notebook
Team project performing ETL on 2020 U.S. Election data, using jupyter notebook, PostgreSQL, and quickDBD.
An ETL process for a fictitious streaming service, Amazing Prime, was developed in Jupyter Notebook. The code was then refactored into a Python script to automate the ETL process.
A Case Study of Extract, Transform, Load. Documentaion includes sources of data, types of data wrangling performed (data cleaning, joining, filtering, and aggregating) and the schemata used in the final production database. Technologies used include Pandas, PostgreSQL, Jupyter Notebook.
Add a description, image, and links to the etl-process topic page so that developers can more easily learn about it.
To associate your repository with the etl-process topic, visit your repo's landing page and select "manage topics."