Before tax deduction, the final offer will depend on the experience and competencies of the selected candidate. Overall remuneration package consists of the salary together with other benefits.
NB! To better understand your technical capabilities and how you could stand out from other candidates, we invite you to complete a short homework assignment.
Overview
The solution can be implemented in Python or a Jupyter Notebook. NB! If you choose to implement the solution in a Jupyter Notebook, ensure that all code cells are executed in order, and that the notebook can be run from start to finish without errors.
Use Python 3.12 or later and a strongly typed coding style (explicit variable types, function return types, etc.). Follow Pythonic conventions and best practices. You may use any suitable Python packages, but avoid obscure or lesser-known libraries. If external packages are used, freeze the dependencies in a requirements.txt file using pip freeze > requirements.txt, or list them in a new README file.
NB! If you use any help from AI tools (e.g., ChatGPT), please mention it in a separate README file in your submission and include links to the chats or chat logs used. If no AI tools were used, please state that as well.
Task
1. (Extract)
2. (Transform)
1. Load daily and historical exchange rates
2. Select only USD, SEK, GBP, and JPY
3. Calculate the historical mean rates for the four selected currencies based on historical data
3. (Load)
Create an HTML or Markdown table with the following columns:
1.Currency Code
2. Rate
3. Mean Historical Rate
Save the table to a file named exchange_rates.html or exchange_rates.md in the project root folder.
Submission
Save your code in a public GitHub repository (or a similar platform) and include the link in your job application.