bnarath / python-challenge

Python scripting challenge

PyBank

Analyze the financial records of your company using Python Scripting

Dataset

Budget Data containg Date and Profit/Loss

Tasks

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

In addition, script should both print the analysis to the terminal and export a text file with the results.

Solution

Python code:

It performs all the tasks in the above section and outputs the analysis on terminal and to the analysis file

PyPoll

Dataset

Election Data containg Voter ID, County, and Candidate

Tasks

Create a Python script that 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.

In addition, script should both print the analysis to the terminal and export a text file with the results.

Solution

Python code:

It performs all the tasks in the above section and outputs the analysis on terminal and to the analysis file

PyBoss

You get to be the boss !

You oversee hundreds of employees across the country developing Tuna 2.0, a world-changing snack food based on canned tuna fish. The company recently decided to purchase a new HR system, and the new system requires employee records be stored completely differently.

Dataset

Employee data file holding employee records

Tasks

The required conversions are as follows:

• The Name column should be split into separate First Name and Last Name columns.
• The DOB data should be re-written into MM/DD/YYYY format.
• The SSN data should be re-written such that the first five numbers are hidden from view.
• The State data should be re-written as simple two-letter abbreviations.

Input Format

Emp ID,Name,DOB,SSN,State
214,Sarah Simpson,1985-12-04,282-01-8166,Florida
15,Samantha Lara,1993-09-08,848-80-7526,Colorado
411,Stacy Charles,1957-12-20,658-75-8526,Pennsylvania

Output Format

Emp ID,First Name,Last Name,DOB,SSN,State
214,Sarah,Simpson,12/04/1985,***-**-8166,FL
15,Samantha,Lara,09/08/1993,***-**-7526,CO
411,Stacy,Charles,12/20/1957,***-**-8526,PA

Python code:

It performs all the tasks in the above section and outputs to the csv file

PyParagraph

You get to play the role of chief linguist at a local learning academy

As chief linguist, you are responsible for assessing the complexity of various passages of writing, ranging from the sophomoric Twilight novel to the nauseatingly high-minded research article. Having read so many passages, you've since come up with a fairly simple set of metrics for assessing complexity.

Tasks

Create a Python script to automate the analysis of any such passage using these metrics. Your script will need to do the following:

• Import a text file filled with a paragraph of your choosing.
• Assess the passage for each of the following:
  • Approximate word count
  • Approximate sentence count
  • Approximate letter count (per word)
  • Average sentence length (in words)

Solution

Python code:

It performs all the tasks in the above section and outputs the analysis on terminal and to the analysis file