bOnline Interview Test

The data

The file sales.json contains a list of dictionaries, each dictionary contains these keys:

• date
• amount (pennies)
• agent

The task

Your task is to write script that prints out a table showing the total value of each agent's sales per month using only the python standard library like this:

Agent   Jan Sales  Jan Total    Feb Sales  Feb Total    Mar Sales  Mar Total
Andy         30     4,100.00         25     5,199.25         32       250.32
Belinda      50    10,125.33         15       100.00         27     1.250.67

You should expect that the code will be tested with different data to that provided, including other months and sales people. This should take a maximum of 45 minutes to an hour.