Data for this Homework

num$\_$borrowers$\_$per$\_$state.csv

total$\_$loans$\_$per$\_$state.csv

This is the same student loan data we$$ve used in class, but extended over several years. For each state and year, the data has:

Number of US borrowers who currently have an outstanding student loan

Total outstanding balance for the state

Recall that the data reflects current state $--$ the values might go up or down each month depending on whether new people took on loans, or existing borrowers paid money off.

Part $1-$ Questions about the Data

This part of your solution will be auto$-$graded. When you find this assignment on gradescope, the first part will ask you the following questions; type or select your answers. You must compute the answers to these questions programmatically. Gradescope will confirm your answers are correct$/$incorrect$.$

Check the output! Gradescope can be a little picky about formatting, and we don$$t want you to lose points for putting extra characters or whitespace in an answer. Make sure you$$ve got the correct answer to each question for full credit. Note that the original dataset has monetary values in millions $($e$.$g$.,$ $$100==$ $$100$ million$),$ but the homework questions want the $$real$$ values $($$$100$ million $==$ $$100$ million$).$

Answer these questions $($make sure you compute these answers in your Python solution$)$:

How many borrowers had student loans in $2019?$

What is the total outstanding balance for all students as of $2021?$

What is the average outstanding balance per student in $2016?$

What is Nevada$$s average outstanding balance over all years in the dataset?

Which state had the greatest balance on average over all years in the dataset, and how much was it$?$

Which state had the lowest balance on average over all years in the dataset, and how much was it$?$

On average, how much did the number of borrowers in a given state change per year? $($Assume that, in the first year, the number of borrowers did not change. Compute your first value as the change from $2016$ to $2017.$ Negatives$/$positives don$$t matter here. Going from $10$ borrowers to $11,$ or from $10$ to $9,$ is a change of $1$ person.$)$

Part $2-$ Visualization

Create two Python plots and upload them as screenshots$/$downloads$.$

Plot #$1$: A histogram showing the average outstanding balance per borrower in each state, in $2021.$ Note that a histogram shows a frequency distribution $($i$.$e$.,$ number of states within a range of outstanding balances$),$ and you should not create a plot with one bar per state.

Plot #$2$: A line chart showing how the average outstanding balance per borrowing changed over time. This chart should have two lines, comparing any two states you choose.