Question
Problem: Justworks wants to generate insight from a list of banking transactions occurring in customer accounts. We want to generate minimum , maximum and ending
Problem:
Justworks wants to generate insight from a list of banking transactions occurring in customer accounts. We want to generate minimum , maximum and ending balances by month for all customers. You can assume starting balance at begining of month is 0. You should read transaction data from csv files and produce output in the format mentioned below. You can assume -ve number as debit and +ve number as credit
Please apply credit transactions first to calculate balance on a given day. Please write clear instructions on how to run your program on a local machine. Please use dataset in Data Tab to test your program. You do not need to add Column Header in output. Please assume input file does not have header row.
Input CSV Format: CustomerID, Date, Amount
Output Format: CustomerID, MM/YYYY, Min Balance, Max Balance, Ending Balance
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started