In this activity, I was tasked with creating a Python script for analyzing the financial records of a company.
I was provided with a financial dataset in this file: budget_data.csv.
This dataset is composed of two columns, Date and Profit/Losses.
My task was to create a Python script that analyzes the records to calculate each of the following:
-
The total number of months included in the dataset.
-
The net total amount of Profit/Losses over the entire period.
-
The average of the changes in Profit/Losses over the entire period.
-
The greatest increase in profits (date and amount) over the entire period.
-
The greatest decrease in losses (date and amount) over the entire period.
My final script is contained in main.ipynb.
It prints the analysis to the terminal and exports a text file with the results.
My resulting analysis is contained in this text file: Financial_analysis.txt
It states as follows
Financial Analysis
----------------------------
Total Months: 86
Total: $38382578
Average Change: $-2315.1176470588234
Greatest Increase in Profits: Feb-2012 ($1926159)
Greatest Decrease in Profits: Sep-2013 ($-2196167)