Comp 151 Project 4

Working with Excel Data Part I

Summary:

Due: Monday April 4th at 11:59pm

Description:

Last week (As of this assignment) the US released population change and migration data for counties across the US during the mid 2020 to mid 2021 period. Since this data is so fresh, lets examine this data.

Your program needs to use functions

First as usual, create a new project - again have your name in the project so I know who did the project.

Next Download the countyPopChange2020-2021.xlsx file and put it into your project folder

In your program you will

• Create four functions (you can have extra helper functions if you want to, but have at least the functions below
  

• In your main function
  

• call the open_worksheet function and store the result in a variable
  
• call the should_get_losses function and store the result in a variable
• call the process_data function passing the two variables above as parameters
  

• Create a open_worksheet function which 

• open the countypopchange2020-2021.xlsx excel file
• Read the contents of the file, and get the first worksheet.

• finally, return the worksheet from the function

• The should_get_losses function ask the user if we should get the counties that lost population if so return true, otherwise return false

• the process_data function should

  • take two parameters:
  • the worksheet (Which was the return value of the open_worksheet function)
  • a boolean parameter called show_losses which was the return value of the should_get_losses function
  • go through all of the counties in the spreadsheet and calculate the percentage change of population from total population to the 2021 population change (POPESTIMATE2021 and NPOPCHG2021)

  • if show_losses is true

  • print the state and county names and percentage change for any county that lost more than 2% of its population in the July 2020 to July 2021 period
    

  • If show_losses is false

    • print the state and county names and percentage change for any county that gained more than 1.5% of its population in the July 2020 to July 2021 period

      
      

Additional  requirements:

Your code must be commented

use functions. 

To help me identify your work, make the name of your project

yourFirstInitialLastNameProject3

(so mine would be JSantoreProject3)
And put the following at the beginning of the program as a comment:

• Your name

• anything that was left undone

• anything that I need to know to run the program correctly.

Project Submission

Submit the project by putting it on github as a private project and making me a collaborator as before.