4113 Data Analytics Project

Two years ago, Panther Suppliers upgraded its general ledger system. The Controller of Panther has some concerns with respect to restrictions on various accounts and has hired you as a consultant to evaluate the effectiveness of the system. You have been provided with a very large data dump to a flat text file (testData.txt), which includes the combination of various queries run by the Controller. The data has four columns: (1) Account, (2) Ledger ID, (3) Dollar Value, and (4) Currency.

Access to data: https://www.dropbox.com/s/kat0oeknggxl9vf/testData.txt?dl=0

The controller has identified 5 accounts (four liability and one expense) that she wishes you to evaluate. Each of these accounts and associated restrictions are detailed below. She also has one final request related to foreign currency, which is listed last.

Write a program in Python 3.x that processes the data file (testData.txt), and prints the results of your analyses (or outputs to a separate text file). The data can be accessed at the following link:

Account 204000 (liability)

Description:

When setting up the accounting system, the firm's implementation team

erroneously linked the invoicing system to this unearned revenue account. Instead of

correcting the problem, the company accountants have instead been manually closing out

unearned revenue periodically. The controller worries this manual fix has resulted in

errors. The invoicing system ledger IDs begin with "100" and the manual adjustments

begin with "105". Note that all invoicing should be done in USD.?

Tasks:

1. Compare the total dollar value of transactions with ledger IDs starting with 100

to the total dollar value of transactions beginning with 105.

2. Verify that the account only has transactions denominated in USD.