Please comment the code, use python 3 save as a .py or .ipynb file. In addition to commented code please provide a word document describing the steps to produce the ETL result.
Take multiple data sources and migrate it to a production data base.
## Finding Data
Project must use 2 or more sources of data. Recommend the following sites to use as sources of data:
* [data.world](https:
data.world/)
* [Kaggle](https:
www.kaggle.com/)
You can also use APIs or data scraped from the web. However, contact me prior if you wish to use this method.
## Data Cleanup & Analysis
Once you have identified your datasets, perform ETL (extract, transform, load) on the data. Make sure to plan and document the following:
* The sources of data that you will extract from.
* The type of transformation needed for this data (cleaning, joining, filtering, aggregating, etc).
* The type of final production database to load the data into (relational or non-relational).
* The final tables or collections that will be used in the production database.
Please include a final technical report with the above information and steps required to reproduce your ETL process. This can be one page.
## Project Report
Report that describes the following:
* **E**xtract: your original data sources and how the data was formatted (CSV, JSON, pgAdmin 4, etc).
* **T**ransform: what data cleaning or transformation was required.
* **L**oad: the final database, tables/collections, and why this was chosen.
- - -