Project 1: JP Morgan coding tasks
The projects below are from a Job simulation activity i completed run by JP Morgan.
Task 1:
For the first task, I was given a small csv file (linked above) containing the price of natural gas at the end of each month from 2020-2024
I had to plot that data onto a graph, interpolate the graph to figure out prices between dates (such as in the middle of the month) and the final objective was to extrapolate the data for an extra year
This first task was the hardest for me personally, and took about 5-6 hours of coding, as i had never used data such as a csv file when coding before
I persevered throughout as it was very difficult, but I was really enjoying the challenge which kept me motivated
Task 2:
For my next task, i had to create funtions that take in inputs:
~ Injection date of natural gas into a storage location
~ Withdrawal date of that natural gas from the storage location
~ Maximum amount able to be stored
~ The amount you want to buy and store
~ Cost of storage between Injection and Withdrawal date
~ Cost of injection/ withdrawal
The hardest part of this task was finding the amount of months between the injection and withdrawal dates as they were inputted a strings so i had to find methods such as string slicing to compare months
Task 3:
This task was completely different to the first two,
I was given a large csv file with 10,000 records with information of peoples incomes, outstanding debt, outstanding loan, fico score and other relevant information about each person
my task was to make a program to output the probability of a customer defaulting on their lones and return the expect money lost
I looked at a few factors such as fico score as well as working out the loan as a % of their income
By looking at my already existing data i found the probability od default if these numbers were inputted
