This repository contains py files that analyze two different csv worksheets:

This final products for each analysis are:

1. raw data (csv file)
2. python script file
3. txt file with analysis results (generated when the corresponding py file is run)

The accompanying csv mirrors a company's financial records, stored in a very basic csv worksheet (the dataset is composed of two columns: Date and Profit/Losses).

The python script analyzes the worksheet to calculate 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

The accompanying csv mirrors polling results from a local election in a small town. The dataset is composed of three columns: Voter ID, County, and Candidate.

The python script analyzes the votes and calculates each of the following:

• The total number of votes cast
• A complete list of candidates who received votes
• The percentage of votes each candidate won
• The total number of votes each candidate won
• The winner of the election based on popular vote.

For both analyses, the final code prints the analysis to the terminal and exports a text file with the results.

Exercise designed by © 2019 Trilogy Education Services, a 2U, Inc. brand. All Rights Reserved.