Comp 151 Project 5

Working with Excel Data Part II Viewing the data on Maps

Summary:

Due: Friday April 15th at 11:59pm

Description:

We will continue to examine the recently released population change 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 five 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 (lets call it pop_worksheet)
  
• call the should_display_pop_change function and store the result in a variable (lets call is show_pop_change)
  
• if the variable from above is true
  
• call the show_pop_change_map function passing the variable as a pop_worksheet parameter
  
• else
• call the show_percent_change_map function passing the variable as a pop_worksheet parameter

• 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_display_pop_change function should ask the user if the program should display a map of total population changes, if so return true, other wise the function should return false

• The show_pop_change_map function should go through the database, only looking at the state totals (where the county number is 0), collect the state 2021 population changes [NPOPCHG2021 column] and the state abbreviations and display a map of those total population changes using ployly like we did in class.
  

• the show_percent_change_map function should

  • go through all of the states in the spreadsheet (last time we did the counties, but this time we only want the states - again where column E is zero) and calculate the percentage change of population from total population to the 2021 population change (POPESTIMATE2021 and NPOPCHG2021)
  • display a USA map with the state population changes as the data shown

Additional  requirements:

Your code must be commented

use functions. 

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

yourFirstInitialLastNameProject5

(so mine would be JSantoreProject5)
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.