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

1 answer below »
Use two sources of data, links provided in the instructions, pull the data from a website, clean and organize the data, then output the data onto database or table. The choice of data to use is open but should come from the data world or Kaggle websites provided. Please comment the code well and let me know if there are any questions.




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. - - -
Answered Same DayOct 16, 2021

Answer To: Please comment the code, use python 3 save as a .py or .ipynb file. In addition to commented code...

Neha answered on Oct 20 2021
146 Votes
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here