Python Homework - Py Me Up, Charlie

Python Homework - Py Me Up, Charlie

In this homework assignment, you are required to complete two Python challenges: PyBank and PyPoll. These challenges simulate real-world scenarios where your Python scripting skills are applicable. You will analyze financial records in CSV format for PyBank, calculating various metrics, and analyze election data in CSV format for PyPoll, determining vote counts and winners. Your scripts should read data from the provided CSV files, perform the necessary calculations, print the results to the terminal, and export the analysis to a text file. Ensure your code works independently on each dataset and incorporates proper data handling, looping, conditions, and string formatting. Follow best practices for code clarity, organization, and commenting.

Paper For Above instruction

The objective of this assignment is to develop Python scripts that solve practical data analysis problems using CSV datasets related to financial records and election results. The challenges—PyBank and PyPoll—are designed to enhance understanding of data processing with Python, covering tasks such as reading CSV files, performing calculations, and generating summarized reports.

In the PyBank challenge, the user is tasked with analyzing a company's financial records stored in a CSV file labeled 'budget_data.csv'. This file contains two columns: 'Date' and 'Profit/Losses'. The script must calculate the total number of months, the total profit/losses over the period, the average change in profits/losses between months, and identify the greatest increase and decrease in profits, along with corresponding dates. The analysis should be printed to the console and written into an output text file. This task emphasizes file I/O operations, iteration over dataset rows, and calculations of differences between sequential data points.

The PyPoll challenge involves analyzing election data stored in 'election_data.csv', comprising 'Voter ID', 'County', and 'Candidate' columns. The script must compute the total votes cast, list all candidates who received votes, calculate the percentage and total votes per candidate, and determine the winner based on popular vote. Similar to PyBank, the results should be outputted to both the terminal and a text file. This challenge provides practical experience with data aggregation, dictionaries, and most-vote calculations.

To accomplish both challenges, users are expected to utilize modules like `csv`, perform data manipulation with loops and conditionals, and format output messages for clarity. Proper structuring, including functions for readability and maintainability, is encouraged. The scripts should be adaptable to different datasets and be capable of running independently without data dependencies outside the provided files.

Overall, this assignment aims to improve proficiency in file handling, data processing, and reporting in Python, skills essential for data analysis and scripting tasks in a professional environment. Working efficiently on these challenges will develop foundational skills that support more advanced data manipulation projects.

References

  • PyBank Dataset: https://github.com//python-challenge/blob/main/PyBank/Resources/budget_data.csv
  • PyPoll Dataset: https://github.com//python-challenge/blob/main/PyPoll/Resources/election_data.csv
  • Python CSV Module Documentation: https://docs.python.org/3/library/csv.html
  • W3Schools Python File Handling: https://www.w3schools.com/python/python_file_handling.asp
  • Automate the Boring Stuff with Python, Al Sweigart, 2015
  • Python Official Documentation: https://docs.python.org/3/
  • Real Python CSV Data Tutorial: https://realpython.com/python-csv/
  • Data analysis with Python: https://pandas.pydata.org/pandas-docs/stable/
  • Effective Python: 59 Specific Ways to Write Better Python, Brett Slatkin, 2015
  • Best Practices for Python Scripts: https://realpython.com/python-best-practices/

Related Assignments