As a data analysis, i was asked by the Colorado election boad to complete an election aduit of a recent local congressional election. Below, are the following taks that are to be incorporated in the audit.
- Calculate the total number of vote cast.
- Get a complete list of candidates who received votes.
- Calculate the total number of votes each candidate received.
- Calculate the percentage of vote each candidate received.
- Determine the winniner of the election base on popular votes.
Data source: election_result.csv
Software: Python, VS code
AS a data analysis, i was asked by the Colorado election boad to complete an election aduit of a recent local congressional election. Below, are the following taks that was included in the audit.
I provided Seth and his team with the findings of the following tasks in my first draft of the election audit:
- Calculate the total number of votes cast.
- Get a complete list of candidates who received votes.
- Calculate the total number of votes each candidate received.
- Calculate the percentage of votes each candidate won.
- Determine the winner of the election based on popular vote.
Even though, the outcomes of the election are important, there are a few more key insights his team would like to review. The election commission of Seth's team asked if he could confirm the voter turnout for each county that voted in this congressional district.
The findings of the following tasks were added to the final election audit:
- Calculate the voter turnout for each county.
- Calculate the percentage of votes each county contributed to the election.
- Determine which county had the largest turnout.
Election Results Total Votes: 369,711
County Results:
Jefferson: 10.5% (38,855)
Denver: 82.8% (306,055)
Arapahoe: 6.7% (24,801) Largest County Turnout: Denver
Candidate Results:
Charles Casper Stockham: 23.0% (85,213)
Diana DeGette: 73.8% (272,892)
Raymon Anthony Doane: 3.1% (11,606) Election Winner:
Diana DeGette
Vote Count: 272,892
Percentage: 73.8%
The analysis of the election show that:
There were 369,711 votes cast in the election.
The candidates were:
Charles Casper Stockham Diana DeGette Raymon Anthony Doane
The candidate results were:
Charles Casper Stockham received 23.0% of the vote and 85,213 number of votes.
Diana DeGette received 73.8% of the vote and 272,892 number of votes.
Raymon Anthony Doane received 3.1% of the vote and 11,606 number of votes.
The winner of the election was:
Diana DeGette, who received 272,892 number of votes, 73.8% of the total votes cast in the election.