Easy ETL project to extract data from a website abou banks and their market capital in different countries. You can use jupyter notebook or any other python notebook to open , run and edit it . 1.Running the ETL process. 2.Extracting bank and market cap data from the JSON file bank_market_cap.json. 3.Transforming the market cap currency using the exchange rate data. 4.Loading the transformed data into a seperate CSV.
Extract, Transform and Load it's the process that allows to move data from multiple sources, clean them and load them into a database, that could be used.
- Clone the repository
- Create a virtual environment called env
- pip install jupyterlab
- Then, you can run your code with jupyter notebook