Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Python code files written to execute a quick profit-loss financial analysis, and tabulate the results of a local election to declare a winner.

Notifications You must be signed in to change notification settings

patelpurvip/Basic-Python-Analysis

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 

Repository files navigation

Basic Python Analysis of Excel/CSV worksheets

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

1) Financial Analysis (PyBank):

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

2) Election Results Analysis (PyElection):

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.

About

Python code files written to execute a quick profit-loss financial analysis, and tabulate the results of a local election to declare a winner.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

Morty Proxy This is a proxified and sanitized view of the page, visit original site.