Project 6:Review

Due: Nov 6th at 11:59pm

Summary:

Several of you in the exam expressed that you needed to absorb some of the dictionary and other concepts a little better before we add new programming concepts, so this program is a review of the first half of the semester.

Details:

First create your new project in pycharm with your name in the project name
Next add the openpyxl library the same way that we used the arcade library in the past. You don't have to do anything with this library, my code will use it
Next get the file project6Files.zip and save it into your project folder
unzip the file, you should have three files now

StateMedianIncome.xlsx (when grading I will use a file from a different year)

Project6Loader.py

main.py

You will work in main.py. In that file I have imported Project6Loader and called the function that I put there (it reads data fromStateMedianIncome.xlsx and makes a list of dictionaries out of that data. The list of dictionaries is stored in the income_data variable. Do all of your work below this.

Each dictionary is in the following format

|================================================+++++=========|

| "Name" : <the state Name is a string> |

| "income2022" : <median state income for 2022 as an int> |

| "income2021" : <the state median income for 2021 as int>|

|====================================================++++++=====|

Hint/Reminder from the PAL classes:

just like in the arcade package there are colors, in the colorama package (which is in the python standard library) there are colors for printing to the command line in color

colorama.Fore.<COLORNAME> is the general pattern for text colors. For example

print(colorama.Fore.BLUE +f"{income_data}")

will print whatever is in the variable income_data in blue

For the program functionality:

First ask the user what they want to do and then do one of the following

Find wealthy states:

ask the user to enter a yearly income amount.
print all of the states and their median incomes from 2022 that had more than that yearly income amount

Find poor states

ask the user to enter a yearly income amount.
print all of the states and their median incomes from 2022 that had less than that yearly income amount

How is it changing?

go through all of the data

if the state has a higher median income in 2022 than the year before, print its name in one color (maybe GREEN or CYAN or BLUE) and print the change in income
if the state has a lower median income in 2022 than in the year before, print its name in another color (maybe RED or YELLOW) and print the change in income

Find Biggest Losers

find all of the states that had more than $3000 dollar median income loss from 2021 to 2022
Print those state names and the change in median income with a background color and message indicating that this is scary

Find biggest Winners

find all of the states that had more than $3000 dollar median income gain from 2021 to 2022
Print out state names and the change in median income with a background color and message indicating that this is good.

Remember! I'll use a different year (but the same dictionary keys) so the data will be different, so you need to calculate the answers in the program rather than just doing the work yourself and make your printer print things out.

Of course put this into git and onto github sooner rather than later.

Additional requirements:
Your code must be commented. you don't have to comment every line, but you need to explain to me what you are doing in the code.

Submission:

As with the previous project, to submit the project to me, share it with me on github. My github id is jsantore. You can see directions for doing this here.